You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@openjpa.apache.org by mp...@apache.org on 2007/04/21 00:52:38 UTC
svn commit: r530939 [1/2] - in
/incubator/openjpa/trunk/openjpa-examples/src/main/java: ./ META-INF/
reversemapping/ reversemapping/schema/
Author: mprudhom
Date: Fri Apr 20 15:52:37 2007
New Revision: 530939
URL: http://svn.apache.org/viewvc?view=rev&rev=530939
Log:
Added example for using the reverse mapping tool
Added:
incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/
incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/Main.java (with props)
incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/build.xml (with props)
incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/reverse-customizer.properties (with props)
incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/schema/
incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/schema/ToursDB_schema.sql (with props)
incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/schema/dropdb.sql (with props)
incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/schema/loadAIRLINES.sql (with props)
incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/schema/loadCITIES.sql (with props)
incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/schema/loadCOUNTRIES.sql (with props)
incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/schema/loadFLIGHTAVAILABILITY1.sql (with props)
incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/schema/loadFLIGHTAVAILABILITY2.sql (with props)
incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/schema/loadFLIGHTS1.sql (with props)
incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/schema/loadFLIGHTS2.sql (with props)
Modified:
incubator/openjpa/trunk/openjpa-examples/src/main/java/META-INF/persistence.xml
incubator/openjpa/trunk/openjpa-examples/src/main/java/build.xml
Modified: incubator/openjpa/trunk/openjpa-examples/src/main/java/META-INF/persistence.xml
URL: http://svn.apache.org/viewvc/incubator/openjpa/trunk/openjpa-examples/src/main/java/META-INF/persistence.xml?view=diff&rev=530939&r1=530938&r2=530939
==============================================================================
--- incubator/openjpa/trunk/openjpa-examples/src/main/java/META-INF/persistence.xml (original)
+++ incubator/openjpa/trunk/openjpa-examples/src/main/java/META-INF/persistence.xml Fri Apr 20 15:52:37 2007
@@ -26,6 +26,7 @@
See: http://issues.apache.org/jira/browse/OPENJPA-78
-->
<persistence-unit name="none" transaction-type="RESOURCE_LOCAL">
+ <mapping-file>reversemapping/orm.xml</mapping-file>
<class>hellojpa.Message</class>
<class>relations.Deity</class>
</persistence-unit>
@@ -74,5 +75,10 @@
<!-- persistence unit for the "relations" example -->
<persistence-unit name="relations" transaction-type="RESOURCE_LOCAL">
<class>relations.Deity</class>
+ </persistence-unit>
+
+ <!-- persistence unit for the "reversemapping" example -->
+ <persistence-unit name="reversemapping" transaction-type="RESOURCE_LOCAL">
+ <mapping-file>reversemapping/orm.xml</mapping-file>
</persistence-unit>
</persistence>
Modified: incubator/openjpa/trunk/openjpa-examples/src/main/java/build.xml
URL: http://svn.apache.org/viewvc/incubator/openjpa/trunk/openjpa-examples/src/main/java/build.xml?view=diff&rev=530939&r1=530938&r2=530939
==============================================================================
--- incubator/openjpa/trunk/openjpa-examples/src/main/java/build.xml (original)
+++ incubator/openjpa/trunk/openjpa-examples/src/main/java/build.xml Fri Apr 20 15:52:37 2007
@@ -22,6 +22,13 @@
<property name="parent" value="${basedir}/.."/>
<property name="root" value="${parent}/.."/>
+ <!-- database connection properties -->
+ <property name="dbdriver" value="org.apache.derby.jdbc.EmbeddedDriver"/>
+ <property name="dburl" value="jdbc:derby:${example}-database;create=true"/>
+ <property name="dbuser" value=""/>
+ <property name="dbpass" value=""/>
+
+
<target name="usagewarning">
<fail>
Please traverse to a sub-directory and run "ant" from there.
@@ -43,9 +50,9 @@
</path>
<pathconvert property="javaagent" refid="javaagent"/>
- <target name="clean"
+ <target name="clean" depends="pre-clean"
description="Clean up compiled files and generated database files">
- <delete includeemptydirs="true">
+ <delete includeemptydirs="yes">
<fileset dir="${basedir}">
<include name="*.class"/>
<include name="*.log"/>
@@ -55,9 +62,18 @@
</delete>
</target>
- <target name="compile" description="Compile the example java files">
+ <!-- this target can be overridden by the sub-build -->
+ <target name="pre-clean" description="Pre-clean phase">
+ </target>
+
+ <target name="compile" depends="pre-compile"
+ description="Compile the example java files">
<javac srcdir="${parent}" classpathref="classpath"
- includes="${example}/**.java"/>
+ debug="yes" includes="${example}/**.java"/>
+ </target>
+
+ <!-- this target can be overridden by the sub-build -->
+ <target name="pre-compile" description="Pre-compilation phase">
</target>
<target name="run" depends="compile"
@@ -84,9 +100,10 @@
provided you ensure it is accessible in the classpath.
-->
<sysproperty key="openjpa.ConnectionDriverName"
- value="org.apache.derby.jdbc.EmbeddedDriver"/>
- <sysproperty key="openjpa.ConnectionURL"
- value="jdbc:derby:${example}-database;create=true"/>
+ value="${dbdriver}"/>
+ <sysproperty key="openjpa.ConnectionURL" value="${dburl}"/>
+ <sysproperty key="openjpa.ConnectionUserName" value="${dbuser}"/>
+ <sysproperty key="openjpa.ConnectionPassword" value="${dbpass}"/>
<!--
Tell OpenJPA to automatically create tables in the database
Added: incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/Main.java
URL: http://svn.apache.org/viewvc/incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/Main.java?view=auto&rev=530939
==============================================================================
--- incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/Main.java (added)
+++ incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/Main.java Fri Apr 20 15:52:37 2007
@@ -0,0 +1,120 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements. See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership. The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied. See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+package reversemapping;
+
+import java.text.*;
+import java.util.*;
+import javax.persistence.*;
+
+
+/**
+ * A simple program that uses the reverse-mapped classes from the airlines
+ * schema to print out a list of schedules flightes and the
+ * projected profits from them.
+ */
+public class Main {
+
+ private static void print(String msg) {
+ System.out.println(msg);
+ }
+
+ @SuppressWarnings("unchecked")
+ public static void main(String[] args) {
+ // Create a new EntityManagerFactory using the System properties.
+ // The "reversemapping" name will be used to configure based on the
+ // corresponding name in the META-INF/persistence.xml file
+ EntityManagerFactory factory = Persistence.
+ createEntityManagerFactory("reversemapping",
+ System.getProperties());
+
+ // Create a new EntityManager from the EntityManagerFactory. The
+ // EntityManager is the main object in the persistence API, and is
+ // used to create, delete, and query objects, as well as access
+ // the current transaction
+ EntityManager em = factory.createEntityManager();
+
+ List<Availability> schedule = (List<Availability>)
+ em.createQuery("select avail from Availability avail "
+ + "join fetch avail.flight "
+ + "order by avail.flightDate asc, avail.flight.departureTime asc").
+ getResultList();
+ for (Availability avail : schedule) {
+ Flight flight = avail.getFlight();
+
+ // note that Availability.getFlightDate is just a DATE with no
+ // time component, and Flight.getDepartureTime() is just a TIME
+ // with no date component
+ print(new SimpleDateFormat("MMM dd, yyyy").
+ format(avail.getFlightDate())
+ + " flight "
+ + flight.getFlightId() + " departs "
+ + new SimpleDateFormat("hh:mm aa").
+ format(flight.getDepartureTime())
+ + " from " + flight.getOrigAirport()
+ + " to " + flight.getDestAirport());
+
+ // look up the Airline reference based on the flight ID
+ Airline airline = em.getReference(Airline.class,
+ flight.getFlightId().substring(0, 2));
+ double ratePerMile = airline.getBasicRate();
+ double rate = flight.getMiles() * ratePerMile;
+
+ int econTaken = avail.getEconomySeatsTaken();
+ int businessTaken = avail.getBusinessSeatsTaken();
+ int firstclassTaken = avail.getFirstclassSeatsTaken();
+
+ double income = (econTaken * rate)
+ + (businessTaken * rate)
+ + (businessTaken * rate * airline.getBusinessLevelFactor())
+ + (firstclassTaken * rate)
+ + (firstclassTaken * rate * airline.getFirstclassLevelFactor());
+
+ int seatsTaken = econTaken + businessTaken + firstclassTaken;
+ int totalSeats = airline.getEconomySeats()
+ + airline.getBusinessSeats()
+ + airline.getFirstclassSeats();
+ double percentFull = (double) seatsTaken / (double) totalSeats;
+
+ print(" income from flight: "
+ + NumberFormat.getCurrencyInstance().format(income)
+ + " with " + seatsTaken + " seats taken ("
+ + NumberFormat.getPercentInstance().format(percentFull)
+ + " full)");
+
+ double gallonsPerMile = 2.0d; // approx for a small plane
+ double totalGallons = gallonsPerMile * flight.getMiles();
+ double costPerGallon = 0.50d; // approx 2006 prices
+ double totalFuelCost = totalGallons * costPerGallon;
+ print(" fuel cost of flight over "
+ + NumberFormat.getNumberInstance().format(flight.getMiles())
+ + " miles: "
+ + NumberFormat.getCurrencyInstance().format(totalFuelCost));
+
+ double totalCost = totalFuelCost;
+
+ print(" total profit: " + NumberFormat.getCurrencyInstance().
+ format(income - totalCost));
+ }
+
+ // Again, it is always good to clean up after ourselves
+ em.close();
+
+ factory.close();
+ }
+}
Propchange: incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/Main.java
------------------------------------------------------------------------------
svn:eol-style = native
Added: incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/build.xml
URL: http://svn.apache.org/viewvc/incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/build.xml?view=auto&rev=530939
==============================================================================
--- incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/build.xml (added)
+++ incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/build.xml Fri Apr 20 15:52:37 2007
@@ -0,0 +1,84 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+ Licensed to the Apache Software Foundation (ASF) under one
+ or more contributor license agreements. See the NOTICE file
+ distributed with this work for additional information
+ regarding copyright ownership. The ASF licenses this file
+ to you under the Apache License, Version 2.0 (the
+ "License"); you may not use this file except in compliance
+ with the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing,
+ software distributed under the License is distributed on an
+ "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ KIND, either express or implied. See the License for the
+ specific language governing permissions and limitations
+ under the License.
+-->
+<project name="hellojpa" default="run">
+ <property name="example" value="reversemapping"/>
+ <import file="../build.xml"/>
+
+ <!-- when we clean, also remove all of the auto-generated files -->
+ <target name="pre-clean" description="Pre-clean phase">
+ <delete includeemptydirs="true">
+ <fileset dir="${basedir}">
+ <include name="orm.xml"/>
+ </fileset>
+ <fileset dir="${basedir}">
+ <include name="*.java"/>
+ <include name="*.java~"/>
+ <contains text="Auto-generated by:"/>
+ </fileset>
+ </delete>
+ </target>
+
+ <!--
+ Before we compile and run, we first initialize a
+ database and run the reverse mapping tool on it
+ -->
+ <target name="pre-compile" depends="initialize-db,reverse-map-schema"
+ description="Pre-compilation phase">
+ </target>
+
+ <target name="initialize-db" unless="initialize-db-skip"
+ description="Drop then re-create the database">
+ <!-- first make sure the database is empty -->
+ <sql src="schema/dropdb.sql"
+ driver="${dbdriver}" url="${dburl}"
+ userid="${dbuser}" password="${dbpass}"
+ onerror="continue" classpathref="classpath"/>
+
+ <!-- build the database -->
+ <sql
+ driver="${dbdriver}" url="${dburl}"
+ userid="${dbuser}" password="${dbpass}" classpathref="classpath">
+ <transaction src="schema/ToursDB_schema.sql"/>
+ <transaction src="schema/loadCOUNTRIES.sql"/>
+ <transaction src="schema/loadCITIES.sql"/>
+ <transaction src="schema/loadAIRLINES.sql"/>
+ <transaction src="schema/loadFLIGHTS1.sql"/>
+ <transaction src="schema/loadFLIGHTS2.sql"/>
+ <transaction src="schema/loadFLIGHTAVAILABILITY1.sql"/>
+ <transaction src="schema/loadFLIGHTAVAILABILITY2.sql"/>
+ </sql>
+ </target>
+
+ <target name="reverse-map-schema" depends="initialize-db"
+ unless="reverse-map-schema-skip"
+ description="Generate java files from the database schema">
+ <!-- now run the tool to generate java files from the db schema -->
+ <taskdef name="reversemappingtool" classpathref="classpath"
+ classname="org.apache.openjpa.jdbc.ant.ReverseMappingToolTask"/>
+ <reversemappingtool package="reversemapping" directory="."
+ innerIdentityClasses="true"
+ customizerProperties="reverse-customizer.properties">
+ <config connectiondrivername="${dbdriver}" connectionurl="${dburl}"
+ connectionusername="${dbuser}" connectionpassword="${dbpass}"/>
+ <codeformat tabSpaces="4" spaceBeforeParen="false"
+ braceOnSameLine="true"/>
+ </reversemappingtool>
+ </target>
+</project>
Propchange: incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/build.xml
------------------------------------------------------------------------------
svn:eol-style = native
Added: incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/reverse-customizer.properties
URL: http://svn.apache.org/viewvc/incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/reverse-customizer.properties?view=auto&rev=530939
==============================================================================
--- incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/reverse-customizer.properties (added)
+++ incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/reverse-customizer.properties Fri Apr 20 15:52:37 2007
@@ -0,0 +1,38 @@
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+
+# Fix generated names to be more "java-like"
+
+reversemapping.Airlines.rename: reversemapping.Airline
+reversemapping.Airline.airline.rename: airlineCode
+reversemapping.Airline.airlineFull.rename: fullName
+
+reversemapping.Cities.rename: reversemapping.City
+
+reversemapping.Countries.rename: reversemapping.Country
+
+reversemapping.Flightavailability.rename: reversemapping.Availability
+reversemapping.Availability.identity: Availability$ID
+
+reversemapping.Flights.rename: reversemapping.Flight
+reversemapping.Flight.identity: Flight$ID
+reversemapping.Flight.departTime.rename: departureTime
+reversemapping.Flight.arriveTime.rename: arrivalTime
+reversemapping.Flight.availabilitys.rename: availabilities
+
+reversemapping.Country.citys.rename: cities
+
+
+
Propchange: incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/reverse-customizer.properties
------------------------------------------------------------------------------
svn:eol-style = native
Added: incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/schema/ToursDB_schema.sql
URL: http://svn.apache.org/viewvc/incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/schema/ToursDB_schema.sql?view=auto&rev=530939
==============================================================================
--- incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/schema/ToursDB_schema.sql (added)
+++ incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/schema/ToursDB_schema.sql Fri Apr 20 15:52:37 2007
@@ -0,0 +1,174 @@
+-- Licensed to the Apache Software Foundation (ASF) under one or more
+-- contributor license agreements. See the NOTICE file distributed with
+-- this work for additional information regarding copyright ownership.
+-- The ASF licenses this file to You under the Apache License, Version 2.0
+-- (the "License"); you may not use this file except in compliance with
+-- the License. You may obtain a copy of the License at
+--
+-- http://www.apache.org/licenses/LICENSE-2.0
+--
+-- Unless required by applicable law or agreed to in writing, software
+-- distributed under the License is distributed on an "AS IS" BASIS,
+-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+-- See the License for the specific language governing permissions and
+-- limitations under the License.
+
+CREATE TABLE AIRLINES
+ (
+ AIRLINE CHAR(2) NOT NULL ,
+ AIRLINE_FULL VARCHAR(24),
+ BASIC_RATE DOUBLE PRECISION,
+ DISTANCE_DISCOUNT DOUBLE PRECISION,
+ BUSINESS_LEVEL_FACTOR DOUBLE PRECISION,
+ FIRSTCLASS_LEVEL_FACTOR DOUBLE PRECISION,
+ ECONOMY_SEATS INTEGER,
+ BUSINESS_SEATS INTEGER,
+ FIRSTCLASS_SEATS INTEGER
+ );
+
+
+ALTER TABLE AIRLINES
+ ADD CONSTRAINT AIRLINES_PK Primary Key (
+ AIRLINE);
+
+
+-- \************************************************************\
+
+CREATE TABLE COUNTRIES
+ (
+ COUNTRY VARCHAR(26) NOT NULL,
+ COUNTRY_ISO_CODE CHAR(2) NOT NULL ,
+ REGION VARCHAR(26)
+ );
+
+
+ALTER TABLE COUNTRIES
+ ADD CONSTRAINT COUNTRIES_PK Primary Key (
+ COUNTRY_ISO_CODE);
+
+ALTER TABLE COUNTRIES
+ ADD CONSTRAINT COUNTRIES_UNQ_NM Unique (
+ COUNTRY);
+
+
+ALTER TABLE COUNTRIES
+ ADD CONSTRAINT COUNTRIES_UC
+ CHECK (country_ISO_code = upper(country_ISO_code) );
+
+
+-- \************************************************************\
+
+CREATE TABLE CITIES
+ (
+ CITY_ID INTEGER NOT NULL ,
+ CITY_NAME VARCHAR(24) NOT NULL,
+ COUNTRY VARCHAR(26) NOT NULL,
+ AIRPORT VARCHAR(3),
+ LANGUAGE VARCHAR(16),
+ COUNTRY_ISO_CODE CHAR(2)
+ );
+
+
+ALTER TABLE CITIES
+ ADD CONSTRAINT CITIES_PK Primary Key (
+ CITY_ID);
+
+ALTER TABLE CITIES
+ ADD CONSTRAINT COUNTRIES_FK Foreign Key (
+ COUNTRY_ISO_CODE)
+ REFERENCES COUNTRIES (
+ COUNTRY_ISO_CODE);
+
+
+-- \************************************************************\
+
+CREATE TABLE FLIGHTS
+ (
+ FLIGHT_ID CHAR(6) NOT NULL ,
+ SEGMENT_NUMBER INTEGER NOT NULL ,
+ ORIG_AIRPORT CHAR(3),
+ DEPART_TIME TIME,
+ DEST_AIRPORT CHAR(3),
+ ARRIVE_TIME TIME,
+ MEAL CHAR(1),
+ FLYING_TIME DOUBLE PRECISION,
+ MILES INTEGER,
+ AIRCRAFT VARCHAR(6)
+ );
+
+CREATE INDEX DESTINDEX ON FLIGHTS (
+ DEST_AIRPORT) ;
+
+CREATE INDEX ORIGINDEX ON FLIGHTS (
+ ORIG_AIRPORT) ;
+
+ALTER TABLE FLIGHTS
+ ADD CONSTRAINT FLIGHTS_PK Primary Key (
+ FLIGHT_ID,
+ SEGMENT_NUMBER);
+
+ALTER TABLE FLIGHTS
+ ADD CONSTRAINT MEAL_CONSTRAINT
+ CHECK (meal IN ('B', 'L', 'D', 'S'));
+
+
+-- \************************************************************\
+
+CREATE TABLE FLIGHTAVAILABILITY
+ (
+ FLIGHT_ID CHAR(6) NOT NULL ,
+ SEGMENT_NUMBER INTEGER NOT NULL ,
+ FLIGHT_DATE DATE NOT NULL ,
+ ECONOMY_SEATS_TAKEN INTEGER DEFAULT 0,
+ BUSINESS_SEATS_TAKEN INTEGER DEFAULT 0,
+ FIRSTCLASS_SEATS_TAKEN INTEGER DEFAULT 0
+ );
+
+
+ALTER TABLE FLIGHTAVAILABILITY
+ ADD CONSTRAINT FLIGHTAVAIL_PK Primary Key (
+ FLIGHT_ID,
+ SEGMENT_NUMBER,
+ FLIGHT_DATE);
+
+ALTER TABLE FLIGHTAVAILABILITY
+ ADD CONSTRAINT FLIGHTS_FK2 Foreign Key (
+ FLIGHT_ID,
+ SEGMENT_NUMBER)
+ REFERENCES FLIGHTS (
+ FLIGHT_ID,
+ SEGMENT_NUMBER);
+
+
+-- \************************************************************\
+
+CREATE TABLE MAPS
+ (
+ MAP_ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1),
+ MAP_NAME VARCHAR(24) NOT NULL,
+ REGION VARCHAR(26),
+ AREA DECIMAL(8,4) NOT NULL,
+ PHOTO_FORMAT VARCHAR(26) NOT NULL,
+ PICTURE BLOB(102400),
+ UNIQUE (MAP_ID, MAP_NAME)
+ );
+
+
+-- \************************************************************\
+
+CREATE TABLE FLIGHTS_HISTORY
+ (
+ FLIGHT_ID CHAR(6),
+ SEGMENT_NUMBER INTEGER,
+ ORIG_AIRPORT CHAR(3),
+ DEPART_TIME TIME,
+ DEST_AIRPORT CHAR(3),
+ ARRIVE_TIME TIME,
+ MEAL CHAR(1),
+ FLYING_TIME DOUBLE PRECISION,
+ MILES INTEGER,
+ AIRCRAFT VARCHAR(6),
+ STATUS VARCHAR (20)
+ );
+
+
Propchange: incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/schema/ToursDB_schema.sql
------------------------------------------------------------------------------
svn:eol-style = native
Added: incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/schema/dropdb.sql
URL: http://svn.apache.org/viewvc/incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/schema/dropdb.sql?view=auto&rev=530939
==============================================================================
--- incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/schema/dropdb.sql (added)
+++ incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/schema/dropdb.sql Fri Apr 20 15:52:37 2007
@@ -0,0 +1,21 @@
+-- Licensed to the Apache Software Foundation (ASF) under one or more
+-- contributor license agreements. See the NOTICE file distributed with
+-- this work for additional information regarding copyright ownership.
+-- The ASF licenses this file to You under the Apache License, Version 2.0
+-- (the "License"); you may not use this file except in compliance with
+-- the License. You may obtain a copy of the License at
+--
+-- http://www.apache.org/licenses/LICENSE-2.0
+--
+-- Unless required by applicable law or agreed to in writing, software
+-- distributed under the License is distributed on an "AS IS" BASIS,
+-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+-- See the License for the specific language governing permissions and
+-- limitations under the License.
+DROP TABLE FLIGHTS_HISTORY;
+DROP TABLE FLIGHTAVAILABILITY;
+DROP TABLE FLIGHTS;
+DROP TABLE MAPS;
+DROP TABLE AIRLINES;
+DROP TABLE CITIES;
+DROP TABLE COUNTRIES;
Propchange: incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/schema/dropdb.sql
------------------------------------------------------------------------------
svn:eol-style = native
Added: incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/schema/loadAIRLINES.sql
URL: http://svn.apache.org/viewvc/incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/schema/loadAIRLINES.sql?view=auto&rev=530939
==============================================================================
--- incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/schema/loadAIRLINES.sql (added)
+++ incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/schema/loadAIRLINES.sql Fri Apr 20 15:52:37 2007
@@ -0,0 +1,17 @@
+-- Licensed to the Apache Software Foundation (ASF) under one or more
+-- contributor license agreements. See the NOTICE file distributed with
+-- this work for additional information regarding copyright ownership.
+-- The ASF licenses this file to You under the Apache License, Version 2.0
+-- (the "License"); you may not use this file except in compliance with
+-- the License. You may obtain a copy of the License at
+--
+-- http://www.apache.org/licenses/LICENSE-2.0
+--
+-- Unless required by applicable law or agreed to in writing, software
+-- distributed under the License is distributed on an "AS IS" BASIS,
+-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+-- See the License for the specific language governing permissions and
+-- limitations under the License.
+
+insert into AIRLINES values ('AA','Amazonian Airways',0.18,0.03,0.5,1.5,20,10,5) ;
+insert into AIRLINES values ('US','Union Standard Airlines',0.19,0.05,0.4,1.6,20,10,5);
Propchange: incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/schema/loadAIRLINES.sql
------------------------------------------------------------------------------
svn:eol-style = native
Added: incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/schema/loadCITIES.sql
URL: http://svn.apache.org/viewvc/incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/schema/loadCITIES.sql?view=auto&rev=530939
==============================================================================
--- incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/schema/loadCITIES.sql (added)
+++ incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/schema/loadCITIES.sql Fri Apr 20 15:52:37 2007
@@ -0,0 +1,102 @@
+-- Licensed to the Apache Software Foundation (ASF) under one or more
+-- contributor license agreements. See the NOTICE file distributed with
+-- this work for additional information regarding copyright ownership.
+-- The ASF licenses this file to You under the Apache License, Version 2.0
+-- (the "License"); you may not use this file except in compliance with
+-- the License. You may obtain a copy of the License at
+--
+-- http://www.apache.org/licenses/LICENSE-2.0
+--
+-- Unless required by applicable law or agreed to in writing, software
+-- distributed under the License is distributed on an "AS IS" BASIS,
+-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+-- See the License for the specific language governing permissions and
+-- limitations under the License.
+
+insert into CITIES VALUES (1,'Amsterdam','Netherlands','AMS','Dutch','NL');
+insert into CITIES VALUES (2,'Athens','Greece','ATH','Greek','GR');
+insert into CITIES VALUES (3,'Auckland','New Zealand','AKL','English','NZ');
+insert into CITIES VALUES (4,'Beirut','Lebanon','BEY','Arabic','LB');
+insert into CITIES VALUES (5,'Bogota','Colombia','BOG','Spanish','CO');
+insert into CITIES VALUES (6,'Bombay','India','BOM','Hindi','IN');
+insert into CITIES VALUES (7,'Budapest','Hungary','BUD','Hungarian','HU');
+insert into CITIES VALUES (8,'Buenos Aires','Argentina','BUE','Spanish','AR');
+insert into CITIES VALUES (9,'Cairo','Egypt','CAI','Arabic','EG');
+insert into CITIES VALUES (10,'Calcutta','India','CCU','Bengali','IN');
+insert into CITIES VALUES (11,'Cape Town','South Africa','CPT','English','ZA');
+insert into CITIES VALUES (12,'Caracas','Venezuela','CCS','Spanish','VE');
+insert into CITIES VALUES (13,'Casablanca','Morocco','CAS','Arabic','MA');
+insert into CITIES VALUES (14,'Copenhagen','Denmark','CPH','Danish','DK');
+insert into CITIES VALUES (15,'Dublin','Ireland','DUB','English','IE');
+insert into CITIES VALUES (16,'Geneva','Switzerland','GVA','French','CH');
+insert into CITIES VALUES (17,'Hong Kong','China','HKG','Chinese','CN');
+insert into CITIES VALUES (18,'Istanbul','Turkey','IST','Turkish','TR');
+insert into CITIES VALUES (19,'Jakarta','Indonesia','JKT','Indonesian','ID');
+insert into CITIES VALUES (20,'Kabul','Afghanistan','KBL','Pashto','AF');
+insert into CITIES VALUES (21,'Karachi','Pakistan','KHI','Punjabi','PK');
+insert into CITIES VALUES (22,'Lagos','Nigeria','LOS','English','NG');
+insert into CITIES VALUES (23,'Lima','Peru','LIM','Spanish','PE');
+insert into CITIES VALUES (24,'Lisbon','Portugal','LIS','Portuguese','PT');
+insert into CITIES VALUES (25,'London','United Kingdom','LHR','English','GB');
+insert into CITIES VALUES (26,'Madrid','Spain','MAD','Spanish','ES');
+insert into CITIES VALUES (27,'Manila','Philippines','MNL','Tagalog','PH');
+insert into CITIES VALUES (28,'Melbourne','Australia','MEL','English','AU');
+insert into CITIES VALUES (29,'Mexico City','Mexico','MEX','Spanish','MX');
+insert into CITIES VALUES (30,'Montreal','Canada','YUL','French','CA');
+insert into CITIES VALUES (31,'Moscow','Russia','SVO','Russian','RU');
+insert into CITIES VALUES (32,'Nairobi','Kenya','NBO','English','KE');
+insert into CITIES VALUES (33,'Osaka','Japan','OSA','Japanese','JP');
+insert into CITIES VALUES (34,'Oslo','Norway','OSL','Norwegian','NO');
+insert into CITIES VALUES (35,'Paris','France','CDG','French','FR');
+insert into CITIES VALUES (36,'Prague','Czech Republic','PRG','Czech','CZ');
+insert into CITIES VALUES (37,'Reykjavik','Iceland','REY','Icelandic','IS');
+insert into CITIES VALUES (38,'Rio de Janeiro','Brazil','GIG','Portuguese','BR');
+insert into CITIES VALUES (39,'Rome','Italy','FCO','Italian','IT');
+insert into CITIES VALUES (40,'Santiago','Chile','SCL','Spanish','CL');
+insert into CITIES VALUES (41,'Sao Paulo','Brazil','GRU','Portuguese','BR');
+insert into CITIES VALUES (42,'Seoul','Korea, Republic of','SEL','Korean','KR');
+insert into CITIES VALUES (43,'Shanghai','China','SHA','Chinese','CN');
+insert into CITIES VALUES (44,'Singapore','Singapore','SIN','Malay','SG');
+insert into CITIES VALUES (45,'Stockholm','Sweden','ARN','Swedish','SE');
+insert into CITIES VALUES (46,'Sydney','Australia','SYD','English','AU');
+insert into CITIES VALUES (47,'San Jose','United States','SJC','English','US');
+insert into CITIES VALUES (48,'Tehran','Iran','THR','Farsi','IR');
+insert into CITIES VALUES (49,'Tokyo','Japan','NRT','Japanese','JP');
+insert into CITIES VALUES (50,'Toronto','Canada','YYZ','English','CA');
+insert into CITIES VALUES (51,'Warsaw','Poland','WAW','Polish','PL');
+insert into CITIES VALUES (52,'Albany','United States','ALB','English','US');
+insert into CITIES VALUES (53,'Albuquerque','United States','ABQ','English','US');
+insert into CITIES VALUES (54,'Atlanta','United States','ATL','English','US');
+insert into CITIES VALUES (55,'Boise','United States','BOI','English','US');
+insert into CITIES VALUES (56,'Boston','United States','BOS','English','US');
+insert into CITIES VALUES (57,'Charleston','United States','CHS','English','US');
+insert into CITIES VALUES (58,'Chicago','United States','MDW','English','US');
+insert into CITIES VALUES (59,'Cleveland','United States','CLE','English','US');
+insert into CITIES VALUES (60,'Dallas','United States','DFW','English','US');
+insert into CITIES VALUES (61,'Denver','United States','DEN','English','US');
+insert into CITIES VALUES (62,'Des Moines','United States','DSM','English','US');
+insert into CITIES VALUES (63,'Fairbanks','United States','FAI','English','US');
+insert into CITIES VALUES (64,'Helena','United States','HLN','English','US');
+insert into CITIES VALUES (65,'Honolulu','United States','HNL','English','US');
+insert into CITIES VALUES (66,'Houston','United States','HOU','English','US');
+insert into CITIES VALUES (67,'Juneau','United States','JNU','English','US');
+insert into CITIES VALUES (68,'Kansas City','United States','MCI','English','US');
+insert into CITIES VALUES (69,'Los Angeles','United States','LAX','English','US');
+insert into CITIES VALUES (70,'Memphis','United States','MEM','English','US');
+insert into CITIES VALUES (71,'Miami','United States','MIA','English','US');
+insert into CITIES VALUES (72,'Milwaukee','United States','MKE','English','US');
+insert into CITIES VALUES (73,'Minneapolis','United States','MSP','English','US');
+insert into CITIES VALUES (74,'Nashville','United States','BNA','English','US');
+insert into CITIES VALUES (75,'New Orleans','United States','MSY','English','US');
+insert into CITIES VALUES (76,'New York','United States','JFK','English','US');
+insert into CITIES VALUES (77,'Oklahoma City','United States','OKC','English','US');
+insert into CITIES VALUES (78,'Philadelphia','United States','PHL','English','US');
+insert into CITIES VALUES (79,'Phoenix','United States','PHX','English','US');
+insert into CITIES VALUES (80,'Saint Louis','United States','STL','English','US');
+insert into CITIES VALUES (81,'Salt Lake City','United States','SLC','English','US');
+insert into CITIES VALUES (82,'San Antonio','United States','SAT','English','US');
+insert into CITIES VALUES (83,'San Diego','United States','SAN','English','US');
+insert into CITIES VALUES (84,'San Francisco','United States','SFO','English','US');
+insert into CITIES VALUES (85,'San Juan','United States','SJU','Spanish','US');
+insert into CITIES VALUES (86,'Seattle','United States','SEA','English','US');
+insert into CITIES VALUES (87,'Washington, DC','United States','IAD','English','US');
Propchange: incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/schema/loadCITIES.sql
------------------------------------------------------------------------------
svn:eol-style = native
Added: incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/schema/loadCOUNTRIES.sql
URL: http://svn.apache.org/viewvc/incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/schema/loadCOUNTRIES.sql?view=auto&rev=530939
==============================================================================
--- incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/schema/loadCOUNTRIES.sql (added)
+++ incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/schema/loadCOUNTRIES.sql Fri Apr 20 15:52:37 2007
@@ -0,0 +1,129 @@
+-- Licensed to the Apache Software Foundation (ASF) under one or more
+-- contributor license agreements. See the NOTICE file distributed with
+-- this work for additional information regarding copyright ownership.
+-- The ASF licenses this file to You under the Apache License, Version 2.0
+-- (the "License"); you may not use this file except in compliance with
+-- the License. You may obtain a copy of the License at
+--
+-- http://www.apache.org/licenses/LICENSE-2.0
+--
+-- Unless required by applicable law or agreed to in writing, software
+-- distributed under the License is distributed on an "AS IS" BASIS,
+-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+-- See the License for the specific language governing permissions and
+-- limitations under the License.
+
+insert into COUNTRIES values ( 'Afghanistan','AF','Asia');
+insert into COUNTRIES values ( 'Albania','AL','Europe');
+insert into COUNTRIES values ('Algeria','DZ','North Africa');
+insert into COUNTRIES values ('American Samoa','AS','Pacific Islands');
+insert into COUNTRIES values ('Angola','AO','Africa');
+insert into COUNTRIES values ('Argentina','AR','South America');
+insert into COUNTRIES values ('Armenia','AM','Europe');
+insert into COUNTRIES values ('Australia','AU','Australia and New Zealand');
+insert into COUNTRIES values ('Austria','AT','Europe');
+insert into COUNTRIES values ('Azerbaijan','AZ','Central Asia');
+insert into COUNTRIES values ('Bahamas','BS','Caribbean');
+insert into COUNTRIES values ('Bangladesh','BD','Asia');
+insert into COUNTRIES values ('Barbados','BB','Caribbean');
+insert into COUNTRIES values ('Belgium','BE','Europe');
+insert into COUNTRIES values ('Belize','BZ','Central America');
+insert into COUNTRIES values ('Bermuda','BM','Caribbean');
+insert into COUNTRIES values ('Bolivia','BO','South America');
+insert into COUNTRIES values ('Botswana','BW','Africa');
+insert into COUNTRIES values ('Brazil','BR','South America');
+insert into COUNTRIES values ('Bulgaria','BG','Europe');
+insert into COUNTRIES values ('Cambodia','KH','Asia');
+insert into COUNTRIES values ('Cameroon','CM','Africa');
+insert into COUNTRIES values ('Canada','CA','North America');
+insert into COUNTRIES values ('Cape Verde','CV','Africa');
+insert into COUNTRIES values ('Chile','CL','South America');
+insert into COUNTRIES values ('China','CN','Asia');
+insert into COUNTRIES values ('Colombia','CO','South America');
+insert into COUNTRIES values ('Congo','CG','Africa');
+insert into COUNTRIES values ('Costa Rica','CR','Central America');
+insert into COUNTRIES values ('Cote d''Ivoire','CI','Africa');
+insert into COUNTRIES values ('Cuba','CU','Caribbean');
+insert into COUNTRIES values ('Czech Republic','CZ','Europe');
+insert into COUNTRIES values ('Denmark','DK','Europe');
+insert into COUNTRIES values ('Dominical Republic','DO','Caribbean');
+insert into COUNTRIES values ('Ecuador','EC','South America');
+insert into COUNTRIES values ('Egypt','EG','North Africa');
+insert into COUNTRIES values ('El Salvador','SV','Central America');
+insert into COUNTRIES values ('Ethiopia','ET','North Africa');
+insert into COUNTRIES values ('Falkland Islands','FK','South America');
+insert into COUNTRIES values ('Fiji','FJ','Pacific Islands');
+insert into COUNTRIES values ('Finland','FI','Europe');
+insert into COUNTRIES values ('France','FR','Europe');
+insert into COUNTRIES values ('Georgia','GE','Europe');
+insert into COUNTRIES values ('Germany','DE','Europe');
+insert into COUNTRIES values ('Ghana','GH','Africa');
+insert into COUNTRIES values ('Greece','GR','Europe');
+insert into COUNTRIES values ('Guadeloupe','GP','Caribbean');
+insert into COUNTRIES values ('Guatemala','GT','Central America');
+insert into COUNTRIES values ('Honduras','HN','Central America');
+insert into COUNTRIES values ('Hungary','HU','Europe');
+insert into COUNTRIES values ('Iceland','IS','Europe');
+insert into COUNTRIES values ('India','IN','Asia');
+insert into COUNTRIES values ('Indonesia','ID','Asia');
+insert into COUNTRIES values ('Iran','IR','Middle East');
+insert into COUNTRIES values ('Iraq','IQ','Middle East');
+insert into COUNTRIES values ('Ireland','IE','Europe');
+insert into COUNTRIES values ('Israel','IL','Middle East');
+insert into COUNTRIES values ('Italy','IT','Europe');
+insert into COUNTRIES values ('Jamaica','JM','Caribbean');
+insert into COUNTRIES values ('Japan','JP','Asia');
+insert into COUNTRIES values ('Jordan','JO','Middle East');
+insert into COUNTRIES values ('Kenya','KE','Africa');
+insert into COUNTRIES values ('Korea, Republic of','KR','Asia');
+insert into COUNTRIES values ('Lebanon','LB','Middle East');
+insert into COUNTRIES values ('Lithuania','LT','Europe');
+insert into COUNTRIES values ('Madagascar','MG','Africa');
+insert into COUNTRIES values ('Malaysia','MY','Asia');
+insert into COUNTRIES values ('Mali','ML','Africa');
+insert into COUNTRIES values ('Mexico','MX','North America');
+insert into COUNTRIES values ('Morocco','MA','North Africa');
+insert into COUNTRIES values ('Mozambique','MZ','Africa');
+insert into COUNTRIES values ('Nepal','NP','Asia');
+insert into COUNTRIES values ('Netherlands','NL','Europe');
+insert into COUNTRIES values ('New Zealand','NZ','Australia and New Zealand');
+insert into COUNTRIES values ('Nicaragua','NI','Central America');
+insert into COUNTRIES values ('Nigeria','NG','Africa');
+insert into COUNTRIES values ('Norway','NO','Europe');
+insert into COUNTRIES values ('Pakistan','PK','Central Asia');
+insert into COUNTRIES values ('Paraguay','PY','South America');
+insert into COUNTRIES values ('Peru','PE','South America');
+insert into COUNTRIES values ('Philippines','PH','Asia');
+insert into COUNTRIES values ('Poland','PL','Europe');
+insert into COUNTRIES values ('Portugal','PT','Europe');
+insert into COUNTRIES values ('Russia','RU','Europe');
+insert into COUNTRIES values ('Samoa','WS','Pacific Islands');
+insert into COUNTRIES values ('Senegal','SN','Africa');
+insert into COUNTRIES values ('Sierra Leone','SL','Africa');
+insert into COUNTRIES values ('Singapore','SG','Asia');
+insert into COUNTRIES values ('Slovakia','SK','Europe');
+insert into COUNTRIES values ('South Africa','ZA','Africa');
+insert into COUNTRIES values ('Spain','ES','Europe');
+insert into COUNTRIES values ('Sri Lanka','LK','Asia');
+insert into COUNTRIES values ('Sudan','SD','Africa');
+insert into COUNTRIES values ('Sweden','SE','Europe');
+insert into COUNTRIES values ('Switzerland','CH','Europe');
+insert into COUNTRIES values ('Syrian Arab Republic','SY','Middle East');
+insert into COUNTRIES values ('Tajikistan','TJ','Central Asia');
+insert into COUNTRIES values ('Tanzania','TZ','Africa');
+insert into COUNTRIES values ('Thailand','TH','Asia');
+insert into COUNTRIES values ('Trinidad and Tobago','TT','Caribbean');
+insert into COUNTRIES values ('Tunisia','TN','North Africa');
+insert into COUNTRIES values ('Turkey','TR','Middle East');
+insert into COUNTRIES values ('Ukraine','UA','Europe');
+insert into COUNTRIES values ('United Kingdom','GB','Europe');
+insert into COUNTRIES values ('United States','US','North America');
+insert into COUNTRIES values ('Uruguay','UY','South America');
+insert into COUNTRIES values ('Uzbekistan','UZ','Central Asia');
+insert into COUNTRIES values ('Venezuela','VE','South America');
+insert into COUNTRIES values ('Viet Nam','VN','Asia');
+insert into COUNTRIES values ('Virgin Islands (British)','VG','Caribbean');
+insert into COUNTRIES values ('Virgin Islands (U.S.)','VI','Caribbean');
+insert into COUNTRIES values ('Yugoslavia','YU','Europe');
+insert into COUNTRIES values ('Zaire','ZR','Africa');
+insert into COUNTRIES values ('Zimbabwe','ZW','Africa');
Propchange: incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/schema/loadCOUNTRIES.sql
------------------------------------------------------------------------------
svn:eol-style = native
Added: incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/schema/loadFLIGHTAVAILABILITY1.sql
URL: http://svn.apache.org/viewvc/incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/schema/loadFLIGHTAVAILABILITY1.sql?view=auto&rev=530939
==============================================================================
--- incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/schema/loadFLIGHTAVAILABILITY1.sql (added)
+++ incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/schema/loadFLIGHTAVAILABILITY1.sql Fri Apr 20 15:52:37 2007
@@ -0,0 +1,310 @@
+-- Licensed to the Apache Software Foundation (ASF) under one or more
+-- contributor license agreements. See the NOTICE file distributed with
+-- this work for additional information regarding copyright ownership.
+-- The ASF licenses this file to You under the Apache License, Version 2.0
+-- (the "License"); you may not use this file except in compliance with
+-- the License. You may obtain a copy of the License at
+--
+-- http://www.apache.org/licenses/LICENSE-2.0
+--
+-- Unless required by applicable law or agreed to in writing, software
+-- distributed under the License is distributed on an "AS IS" BASIS,
+-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+-- See the License for the specific language governing permissions and
+-- limitations under the License.
+
+insert into FLIGHTAVAILABILITY values ('AA1116',1,'2004-03-31',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1116',1,'2004-04-11',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1116',1,'2004-04-12',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1116',1,'2004-04-15',5,5,0);
+insert into FLIGHTAVAILABILITY values ('AA1116',1,'2004-04-20',10,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1116',1,'2004-04-23',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1116',1,'2004-04-24',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1116',1,'2004-05-03',11,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1116',1,'2004-05-05',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1116',1,'2004-05-06',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1116',1,'2004-05-17',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1116',1,'2004-05-18',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1116',1,'2004-05-29',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1116',1,'2004-05-30',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1122',1,'2004-03-31',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1122',1,'2004-04-11',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1122',1,'2004-04-12',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1122',1,'2004-04-15',5,5,0);
+insert into FLIGHTAVAILABILITY values ('AA1122',1,'2004-04-20',10,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1122',1,'2004-04-23',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1122',1,'2004-04-24',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1122',1,'2004-05-03',11,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1122',1,'2004-05-05',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1122',1,'2004-05-06',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1122',1,'2004-05-17',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1122',1,'2004-05-18',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1122',1,'2004-05-29',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1122',1,'2004-05-30',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1124',1,'2004-03-31',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1124',1,'2004-04-11',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1124',1,'2004-04-12',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1124',1,'2004-04-15',5,5,0);
+insert into FLIGHTAVAILABILITY values ('AA1124',1,'2004-04-20',10,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1124',1,'2004-04-23',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1124',1,'2004-04-24',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1124',1,'2004-05-03',11,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1124',1,'2004-05-05',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1124',1,'2004-05-06',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1124',1,'2004-05-17',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1124',1,'2004-05-18',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1124',1,'2004-05-29',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1124',1,'2004-05-30',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1126',1,'2004-03-31',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1126',1,'2004-04-11',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1126',1,'2004-04-12',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1126',1,'2004-04-15',5,5,0);
+insert into FLIGHTAVAILABILITY values ('AA1126',1,'2004-04-20',10,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1126',1,'2004-04-23',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1126',1,'2004-04-24',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1126',1,'2004-05-03',11,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1126',1,'2004-05-05',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1126',1,'2004-05-06',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1126',1,'2004-05-17',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1126',1,'2004-05-18',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1126',1,'2004-05-29',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1126',1,'2004-05-30',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1128',1,'2004-03-31',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1128',1,'2004-04-11',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1128',1,'2004-04-12',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1128',1,'2004-04-15',5,5,0);
+insert into FLIGHTAVAILABILITY values ('AA1128',1,'2004-04-20',10,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1128',1,'2004-04-23',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1128',1,'2004-04-24',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1128',1,'2004-05-03',11,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1128',1,'2004-05-05',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1128',1,'2004-05-06',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1128',1,'2004-05-17',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1128',1,'2004-05-18',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1128',1,'2004-05-29',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1128',1,'2004-05-30',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1134',1,'2004-03-31',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1134',1,'2004-04-11',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1134',1,'2004-04-12',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1134',1,'2004-04-15',5,5,0);
+insert into FLIGHTAVAILABILITY values ('AA1134',1,'2004-04-20',10,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1134',1,'2004-04-23',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1134',1,'2004-04-24',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1134',1,'2004-05-03',11,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1134',1,'2004-05-05',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1134',1,'2004-05-06',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1134',1,'2004-05-17',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1134',1,'2004-05-18',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1134',1,'2004-05-29',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1134',1,'2004-05-30',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1140',1,'2004-03-31',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1140',1,'2004-04-11',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1140',1,'2004-04-12',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1140',1,'2004-04-15',5,5,0);
+insert into FLIGHTAVAILABILITY values ('AA1140',1,'2004-04-20',10,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1140',1,'2004-04-23',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1140',1,'2004-04-24',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1140',1,'2004-05-03',11,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1140',1,'2004-05-05',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1140',1,'2004-05-06',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1140',1,'2004-05-17',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1140',1,'2004-05-18',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1140',1,'2004-05-29',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1140',1,'2004-05-30',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1148',1,'2004-03-31',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1148',1,'2004-04-11',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1148',1,'2004-04-12',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1148',1,'2004-04-15',5,5,0);
+insert into FLIGHTAVAILABILITY values ('AA1148',1,'2004-04-20',10,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1148',1,'2004-04-23',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1148',1,'2004-04-24',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1148',1,'2004-05-03',11,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1148',1,'2004-05-05',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1148',1,'2004-05-06',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1148',1,'2004-05-17',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1148',1,'2004-05-18',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1148',1,'2004-05-29',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1148',1,'2004-05-30',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1150',1,'2004-03-31',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1150',1,'2004-04-11',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1150',1,'2004-04-12',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1150',1,'2004-04-15',5,5,0);
+insert into FLIGHTAVAILABILITY values ('AA1150',1,'2004-04-20',10,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1150',1,'2004-04-23',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1150',1,'2004-04-24',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1150',1,'2004-05-03',11,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1150',1,'2004-05-05',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1150',1,'2004-05-06',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1150',1,'2004-05-17',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1150',1,'2004-05-18',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1150',1,'2004-05-29',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1150',1,'2004-05-30',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1158',1,'2004-03-31',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1158',1,'2004-04-11',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1158',1,'2004-04-12',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1158',1,'2004-04-15',5,5,0);
+insert into FLIGHTAVAILABILITY values ('AA1158',1,'2004-04-20',10,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1158',1,'2004-04-23',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1158',1,'2004-04-24',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1158',1,'2004-05-03',11,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1158',1,'2004-05-05',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1158',1,'2004-05-06',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1158',1,'2004-05-17',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1158',1,'2004-05-18',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1158',1,'2004-05-29',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1158',1,'2004-05-30',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1168',1,'2004-03-31',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1168',1,'2004-04-11',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1168',1,'2004-04-12',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1168',1,'2004-04-15',5,5,0);
+insert into FLIGHTAVAILABILITY values ('AA1168',1,'2004-04-20',10,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1168',1,'2004-04-23',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1168',1,'2004-04-24',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1168',1,'2004-05-03',11,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1168',1,'2004-05-05',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1168',1,'2004-05-06',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1168',1,'2004-05-17',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1168',1,'2004-05-18',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1168',1,'2004-05-29',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1168',1,'2004-05-30',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1172',1,'2004-03-31',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1172',1,'2004-04-11',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1172',1,'2004-04-12',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1172',1,'2004-04-15',5,5,0);
+insert into FLIGHTAVAILABILITY values ('AA1172',1,'2004-04-20',10,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1172',1,'2004-04-23',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1172',1,'2004-04-24',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1172',1,'2004-05-03',11,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1172',1,'2004-05-05',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1172',1,'2004-05-06',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1172',1,'2004-05-17',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1172',1,'2004-05-18',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1172',1,'2004-05-29',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1172',1,'2004-05-30',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1176',1,'2004-03-31',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1176',1,'2004-04-11',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1176',1,'2004-04-12',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1176',1,'2004-04-15',5,5,0);
+insert into FLIGHTAVAILABILITY values ('AA1176',1,'2004-04-20',10,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1176',1,'2004-04-23',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1176',1,'2004-04-24',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1176',1,'2004-05-03',11,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1176',1,'2004-05-05',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1176',1,'2004-05-06',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1176',1,'2004-05-17',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1176',1,'2004-05-18',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1176',1,'2004-05-29',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1176',1,'2004-05-30',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1178',1,'2004-03-31',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1178',1,'2004-04-11',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1178',1,'2004-04-12',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1178',1,'2004-04-15',5,5,0);
+insert into FLIGHTAVAILABILITY values ('AA1178',1,'2004-04-20',10,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1178',1,'2004-04-23',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1178',1,'2004-04-24',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1178',1,'2004-05-03',11,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1178',1,'2004-05-05',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1178',1,'2004-05-06',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1178',1,'2004-05-17',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1178',1,'2004-05-18',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1178',1,'2004-05-29',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1178',1,'2004-05-30',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1181',2,'2004-03-31',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1181',2,'2004-04-11',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1181',2,'2004-04-12',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1181',2,'2004-04-15',5,5,0);
+insert into FLIGHTAVAILABILITY values ('AA1181',2,'2004-04-20',10,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1181',2,'2004-04-23',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1181',2,'2004-04-24',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1181',2,'2004-05-03',11,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1181',2,'2004-05-05',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1181',2,'2004-05-06',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1181',2,'2004-05-17',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1181',2,'2004-05-18',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1181',2,'2004-05-29',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1181',2,'2004-05-30',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1182',2,'2004-03-31',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1182',2,'2004-04-11',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1182',2,'2004-04-12',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1182',2,'2004-04-15',5,5,0);
+insert into FLIGHTAVAILABILITY values ('AA1182',2,'2004-04-20',10,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1182',2,'2004-04-23',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1182',2,'2004-04-24',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1182',2,'2004-05-03',11,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1182',2,'2004-05-05',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1182',2,'2004-05-06',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1182',2,'2004-05-17',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1182',2,'2004-05-18',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1182',2,'2004-05-29',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1182',2,'2004-05-30',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1188',1,'2004-03-31',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1188',1,'2004-04-11',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1188',1,'2004-04-12',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1188',1,'2004-04-15',5,5,0);
+insert into FLIGHTAVAILABILITY values ('AA1188',1,'2004-04-20',10,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1188',1,'2004-04-23',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1188',1,'2004-04-24',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1188',1,'2004-05-03',11,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1188',1,'2004-05-05',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1188',1,'2004-05-06',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1188',1,'2004-05-17',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1188',1,'2004-05-18',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1188',1,'2004-05-29',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1188',1,'2004-05-30',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1195',1,'2004-03-31',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1195',1,'2004-04-11',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1195',1,'2004-04-12',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1195',1,'2004-04-15',5,5,0);
+insert into FLIGHTAVAILABILITY values ('AA1195',1,'2004-04-20',10,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1195',1,'2004-04-23',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1195',1,'2004-04-24',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1195',1,'2004-05-03',11,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1195',1,'2004-05-05',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1195',1,'2004-05-06',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1195',1,'2004-05-17',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1195',1,'2004-05-18',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1195',1,'2004-05-29',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1195',1,'2004-05-30',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1197',1,'2004-03-31',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1197',1,'2004-04-11',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1197',1,'2004-04-12',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1197',1,'2004-04-15',5,5,0);
+insert into FLIGHTAVAILABILITY values ('AA1197',1,'2004-04-20',10,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1197',1,'2004-04-23',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1197',1,'2004-04-24',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1197',1,'2004-05-03',11,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1197',1,'2004-05-05',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1197',1,'2004-05-06',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1197',1,'2004-05-17',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1197',1,'2004-05-18',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1197',1,'2004-05-29',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1197',1,'2004-05-30',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1203',1,'2004-03-31',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1203',1,'2004-04-11',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1203',1,'2004-04-12',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1203',1,'2004-04-15',5,5,0);
+insert into FLIGHTAVAILABILITY values ('AA1203',1,'2004-04-20',10,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1203',1,'2004-04-23',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1203',1,'2004-04-24',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1203',1,'2004-05-03',11,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1203',1,'2004-05-05',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1203',1,'2004-05-06',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1203',1,'2004-05-17',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1203',1,'2004-05-18',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1203',1,'2004-05-29',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1203',1,'2004-05-30',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1207',1,'2004-03-31',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1207',1,'2004-04-11',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1207',1,'2004-04-12',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1207',1,'2004-04-15',5,5,0);
+insert into FLIGHTAVAILABILITY values ('AA1207',1,'2004-04-20',10,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1207',1,'2004-04-23',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1207',1,'2004-04-24',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1207',1,'2004-05-03',11,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1207',1,'2004-05-05',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1207',1,'2004-05-06',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1207',1,'2004-05-17',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1207',1,'2004-05-18',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1207',1,'2004-05-29',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1207',1,'2004-05-30',2,2,2);
+
Propchange: incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/schema/loadFLIGHTAVAILABILITY1.sql
------------------------------------------------------------------------------
svn:eol-style = native
Added: incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/schema/loadFLIGHTAVAILABILITY2.sql
URL: http://svn.apache.org/viewvc/incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/schema/loadFLIGHTAVAILABILITY2.sql?view=auto&rev=530939
==============================================================================
--- incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/schema/loadFLIGHTAVAILABILITY2.sql (added)
+++ incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/schema/loadFLIGHTAVAILABILITY2.sql Fri Apr 20 15:52:37 2007
@@ -0,0 +1,239 @@
+-- Licensed to the Apache Software Foundation (ASF) under one or more
+-- contributor license agreements. See the NOTICE file distributed with
+-- this work for additional information regarding copyright ownership.
+-- The ASF licenses this file to You under the Apache License, Version 2.0
+-- (the "License"); you may not use this file except in compliance with
+-- the License. You may obtain a copy of the License at
+--
+-- http://www.apache.org/licenses/LICENSE-2.0
+--
+-- Unless required by applicable law or agreed to in writing, software
+-- distributed under the License is distributed on an "AS IS" BASIS,
+-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+-- See the License for the specific language governing permissions and
+-- limitations under the License.
+
+insert into FLIGHTAVAILABILITY values ('AA1211',1,'2004-03-31',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1211',1,'2004-04-11',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1211',1,'2004-04-12',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1211',1,'2004-04-15',5,5,0);
+insert into FLIGHTAVAILABILITY values ('AA1211',1,'2004-04-20',10,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1211',1,'2004-04-23',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1211',1,'2004-04-24',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1211',1,'2004-05-03',11,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1211',1,'2004-05-05',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1211',1,'2004-05-06',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1211',1,'2004-05-17',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1211',1,'2004-05-18',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1211',1,'2004-05-29',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1211',1,'2004-05-30',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1217',1,'2004-03-31',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1217',1,'2004-04-11',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1217',1,'2004-04-12',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1217',1,'2004-04-15',5,5,0);
+insert into FLIGHTAVAILABILITY values ('AA1217',1,'2004-04-20',10,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1217',1,'2004-04-23',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1217',1,'2004-04-24',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1217',1,'2004-05-03',11,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1217',1,'2004-05-05',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1217',1,'2004-05-06',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1217',1,'2004-05-17',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1217',1,'2004-05-18',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1217',1,'2004-05-29',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1217',1,'2004-05-30',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1219',1,'2004-03-31',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1219',1,'2004-04-11',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1219',1,'2004-04-12',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1219',1,'2004-04-15',5,5,0);
+insert into FLIGHTAVAILABILITY values ('AA1219',1,'2004-04-20',10,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1219',1,'2004-04-23',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1219',1,'2004-04-24',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1219',1,'2004-05-03',11,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1219',1,'2004-05-05',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1219',1,'2004-05-06',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1219',1,'2004-05-17',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1219',1,'2004-05-18',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1219',1,'2004-05-29',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1219',1,'2004-05-30',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1224',1,'2004-03-31',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1224',1,'2004-04-11',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1224',1,'2004-04-12',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1224',1,'2004-04-15',5,5,0);
+insert into FLIGHTAVAILABILITY values ('AA1224',1,'2004-04-20',10,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1224',1,'2004-04-23',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1224',1,'2004-04-24',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1224',1,'2004-05-03',11,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1224',1,'2004-05-05',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1224',1,'2004-05-06',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1224',1,'2004-05-17',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1224',1,'2004-05-18',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1224',1,'2004-05-29',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1224',1,'2004-05-30',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1229',1,'2004-03-31',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1229',1,'2004-04-11',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1229',1,'2004-04-12',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1229',1,'2004-04-15',5,5,0);
+insert into FLIGHTAVAILABILITY values ('AA1229',1,'2004-04-20',10,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1229',1,'2004-04-23',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1229',1,'2004-04-24',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1229',1,'2004-05-03',11,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1229',1,'2004-05-05',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1229',1,'2004-05-06',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1229',1,'2004-05-17',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1229',1,'2004-05-18',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1229',1,'2004-05-29',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1229',1,'2004-05-30',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1231',1,'2004-03-31',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1231',1,'2004-04-11',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1231',1,'2004-04-12',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1231',1,'2004-04-15',5,5,0);
+insert into FLIGHTAVAILABILITY values ('AA1231',1,'2004-04-20',10,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1231',1,'2004-04-23',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1231',1,'2004-04-24',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1231',1,'2004-05-03',11,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1231',1,'2004-05-05',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1231',1,'2004-05-06',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1231',1,'2004-05-17',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1231',1,'2004-05-18',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1231',1,'2004-05-29',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1231',1,'2004-05-30',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1239',1,'2004-03-31',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1239',1,'2004-04-11',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1239',1,'2004-04-12',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1239',1,'2004-04-15',5,5,0);
+insert into FLIGHTAVAILABILITY values ('AA1239',1,'2004-04-20',10,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1239',1,'2004-04-23',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1239',1,'2004-04-24',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1239',1,'2004-05-03',11,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1239',1,'2004-05-05',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1239',1,'2004-05-06',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1239',1,'2004-05-17',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1239',1,'2004-05-18',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1239',1,'2004-05-29',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1239',1,'2004-05-30',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1241',1,'2004-03-31',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1241',1,'2004-04-11',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1241',1,'2004-04-12',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1241',1,'2004-04-15',5,5,0);
+insert into FLIGHTAVAILABILITY values ('AA1241',1,'2004-04-20',10,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1241',1,'2004-04-23',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1241',1,'2004-04-24',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1241',1,'2004-05-03',11,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1241',1,'2004-05-05',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1241',1,'2004-05-06',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1241',1,'2004-05-17',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1241',1,'2004-05-18',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1241',1,'2004-05-29',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1241',1,'2004-05-30',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1243',1,'2004-03-31',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1243',1,'2004-04-11',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1243',1,'2004-04-12',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1243',1,'2004-04-15',5,5,0);
+insert into FLIGHTAVAILABILITY values ('AA1243',1,'2004-04-20',10,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1243',1,'2004-04-23',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1243',1,'2004-04-24',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1243',1,'2004-05-03',11,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1243',1,'2004-05-05',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1243',1,'2004-05-06',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1243',1,'2004-05-17',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1243',1,'2004-05-18',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1243',1,'2004-05-29',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1243',1,'2004-05-30',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1247',1,'2004-03-31',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1247',1,'2004-04-11',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1247',1,'2004-04-12',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1247',1,'2004-04-15',5,5,0);
+insert into FLIGHTAVAILABILITY values ('AA1247',1,'2004-04-20',10,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1247',1,'2004-04-23',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1247',1,'2004-04-24',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1247',1,'2004-05-03',11,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1247',1,'2004-05-05',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1247',1,'2004-05-06',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1247',1,'2004-05-17',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1247',1,'2004-05-18',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1247',1,'2004-05-29',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1247',1,'2004-05-30',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1252',1,'2004-03-31',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1252',1,'2004-04-11',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1252',1,'2004-04-12',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1252',1,'2004-04-15',5,5,0);
+insert into FLIGHTAVAILABILITY values ('AA1252',1,'2004-04-20',10,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1252',1,'2004-04-23',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1252',1,'2004-04-24',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1252',1,'2004-05-03',11,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1252',1,'2004-05-05',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1252',1,'2004-05-06',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1252',1,'2004-05-17',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1252',1,'2004-05-18',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1252',1,'2004-05-29',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1252',1,'2004-05-30',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1258',1,'2004-03-31',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1258',1,'2004-04-11',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1258',1,'2004-04-12',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1258',1,'2004-04-15',5,5,0);
+insert into FLIGHTAVAILABILITY values ('AA1258',1,'2004-04-20',10,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1258',1,'2004-04-23',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1258',1,'2004-04-24',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1258',1,'2004-05-03',11,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1258',1,'2004-05-05',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1258',1,'2004-05-06',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1258',1,'2004-05-17',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1258',1,'2004-05-18',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1258',1,'2004-05-29',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1258',1,'2004-05-30',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1259',1,'2004-03-31',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1259',1,'2004-04-11',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1259',1,'2004-04-12',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1259',1,'2004-04-15',5,5,0);
+insert into FLIGHTAVAILABILITY values ('AA1259',1,'2004-04-20',10,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1259',1,'2004-04-23',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1259',1,'2004-04-24',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1259',1,'2004-05-03',11,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1259',1,'2004-05-05',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1259',1,'2004-05-06',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1259',1,'2004-05-17',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1259',1,'2004-05-18',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1259',1,'2004-05-29',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1259',1,'2004-05-30',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1265',1,'2004-03-31',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1265',1,'2004-04-11',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1265',1,'2004-04-12',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1265',1,'2004-04-15',5,5,0);
+insert into FLIGHTAVAILABILITY values ('AA1265',1,'2004-04-20',10,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1265',1,'2004-04-23',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1265',1,'2004-04-24',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1265',1,'2004-05-03',11,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1265',1,'2004-05-05',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1265',1,'2004-05-06',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1265',1,'2004-05-17',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1265',1,'2004-05-18',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1265',1,'2004-05-29',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1265',1,'2004-05-30',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1271',1,'2004-03-31',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1271',1,'2004-04-11',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1271',1,'2004-04-12',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1271',1,'2004-04-15',5,5,0);
+insert into FLIGHTAVAILABILITY values ('AA1271',1,'2004-04-20',10,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1271',1,'2004-04-23',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1271',1,'2004-04-24',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1271',1,'2004-05-03',11,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1271',1,'2004-05-05',1,1,1);
+insert into FLIGHTAVAILABILITY values ('AA1271',1,'2004-05-06',2,2,2);
+insert into FLIGHTAVAILABILITY values ('AA1290',1,'2004-04-05',3,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1285',1,'2004-04-11',3,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1223',2,'2004-04-11',3,0,0);
+insert into FLIGHTAVAILABILITY values ('US1552',1,'2004-04-19',3,0,0);
+insert into FLIGHTAVAILABILITY values ('AA1221',1,'2004-04-19',3,0,0);
+insert into FLIGHTAVAILABILITY values ('US1518',1,'2004-04-12',0,0,3);
+insert into FLIGHTAVAILABILITY values ('US1518',2,'2004-04-12',0,0,3);
+insert into FLIGHTAVAILABILITY values ('US1499',1,'2004-04-25',0,0,3);
+insert into FLIGHTAVAILABILITY values ('US1404',1,'2004-04-30',0,3,0);
+insert into FLIGHTAVAILABILITY values ('US1519',2,'2004-04-30',0,3,0);
+insert into FLIGHTAVAILABILITY values ('US1560',1,'2004-04-25',0,3,0);
+insert into FLIGHTAVAILABILITY values ('US1276',2,'2004-05-05',0,3,0);
+insert into FLIGHTAVAILABILITY values ('US1439',1,'2004-05-15',0,3,0);
+insert into FLIGHTAVAILABILITY values ('AA1219',1,'2004-04-02',0,0,3);
+insert into FLIGHTAVAILABILITY values ('AA1248',1,'2004-04-02',0,0,3);
+insert into FLIGHTAVAILABILITY values ('AA1245',1,'2004-04-10',0,0,3);
+insert into FLIGHTAVAILABILITY values ('US1435',1,'2004-04-18',0,0,3);
+insert into FLIGHTAVAILABILITY values ('US1357',2,'2004-04-18',0,0,3);
Propchange: incubator/openjpa/trunk/openjpa-examples/src/main/java/reversemapping/schema/loadFLIGHTAVAILABILITY2.sql
------------------------------------------------------------------------------
svn:eol-style = native