You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by fu...@apache.org on 2006/03/18 01:08:38 UTC
svn commit: r386767 [1/4] - in /db/derby/code/trunk: ./ java/demo/
java/demo/toursdb/ java/testing/org/apache/derbyTesting/functionTests/master/
java/testing/org/apache/derbyTesting/functionTests/suites/
java/testing/org/apache/derbyTesting/functionTes...
Author: fuzzylogic
Date: Fri Mar 17 16:08:36 2006
New Revision: 386767
URL: http://svn.apache.org/viewcvs?rev=386767&view=rev
Log:
DERBY-422: Contribute toursdb demo database to Derby.
Added:
db/derby/code/trunk/java/demo/toursdb/
db/derby/code/trunk/java/demo/toursdb/BART.gif (with props)
db/derby/code/trunk/java/demo/toursdb/Caltrain.gif (with props)
db/derby/code/trunk/java/demo/toursdb/LightRail.gif (with props)
db/derby/code/trunk/java/demo/toursdb/ToursDB_schema.sql
db/derby/code/trunk/java/demo/toursdb/build.xml (with props)
db/derby/code/trunk/java/demo/toursdb/disconnect.sql
db/derby/code/trunk/java/demo/toursdb/insertMaps.java (with props)
db/derby/code/trunk/java/demo/toursdb/loadAIRLINES.sql
db/derby/code/trunk/java/demo/toursdb/loadCOUNTRIES.sql
db/derby/code/trunk/java/demo/toursdb/loadCities.sql
db/derby/code/trunk/java/demo/toursdb/loadFLIGHTAVAILABILITY1.sql
db/derby/code/trunk/java/demo/toursdb/loadFLIGHTAVAILABILITY2.sql
db/derby/code/trunk/java/demo/toursdb/loadFLIGHTS1.sql
db/derby/code/trunk/java/demo/toursdb/loadFLIGHTS2.sql
db/derby/code/trunk/java/demo/toursdb/loadTables.sql
db/derby/code/trunk/java/demo/toursdb/toursdb.xml (with props)
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/checkToursDB.out (with props)
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/demo/checkToursDB.java (with props)
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/demo/checkToursDB_app.properties (with props)
Modified:
db/derby/code/trunk/build.xml
db/derby/code/trunk/java/demo/build.xml
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/demo.runall
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/demo/build.xml
db/derby/code/trunk/tools/release/build.xml
Modified: db/derby/code/trunk/build.xml
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/build.xml?rev=386767&r1=386766&r2=386767&view=diff
==============================================================================
--- db/derby/code/trunk/build.xml (original)
+++ db/derby/code/trunk/build.xml Fri Mar 17 16:08:36 2006
@@ -367,7 +367,7 @@
<!-- =================================================================== -->
<!-- Remove all built objects (except jars) -->
<!-- =================================================================== -->
- <target name="clobber" depends="clean,cleanstate,cleanparsers,cleancatalog"/>
+ <target name="clobber" depends="clean,cleanstate,cleanparsers,cleancatalog,cleantoursdb"/>
<!-- =================================================================== -->
<!-- Remove output tree -->
@@ -497,6 +497,18 @@
<target name="cleancatalog"
description="Remove the generated catalog java file.">
<delete file="${derby.engine.dir}/iapi/services/cache/ClassSizeCatalog.java"/>
+ </target>
+
+<!-- =================================================================== -->
+<!-- Remove toursdb.jar -->
+<!-- =================================================================== -->
+
+ <target name="cleantoursdb"
+ description="Remove the generated sample database.">
+ <delete file="${derby.demo.src.dir}/toursdb/toursdb.jar"/>
+ <delete file="${derby.demo.src.dir}/toursdb/toursdb.out"/>
+ <delete file="${derby.demo.src.dir}/toursdb/derby.log"/>
+ <delete dir="${derby.demo.src.dir}/toursdb/toursdb"/>
</target>
<!-- =================================================================== -->
Modified: db/derby/code/trunk/java/demo/build.xml
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/demo/build.xml?rev=386767&r1=386766&r2=386767&view=diff
==============================================================================
--- db/derby/code/trunk/java/demo/build.xml (original)
+++ db/derby/code/trunk/java/demo/build.xml Fri Mar 17 16:08:36 2006
@@ -16,7 +16,7 @@
<property file="${properties.dir}/compilepath.properties"/>
<!-- Targets -->
- <target name="demo" depends="compile"/>
+ <target name="demo" depends="compile,checktoursdb,toursdb"/>
<target name="compile">
<javac
@@ -70,6 +70,19 @@
<pathelement path="${java13compile.classpath};${jcc};${jta1_2}"/>
</classpath>
</javac>
+ </target>
+
+ <target name="checktoursdb">
+ <condition property="toursdb.available">
+ <and>
+ <available file="${derby.demo.src.dir}/toursdb/toursdb.jar"/>
+ <available file="${derby.demo.src.dir}/toursdb/toursdb"/>
+ </and>
+ </condition>
+ </target>
+
+ <target name="toursdb" unless="toursdb.available">
+ <ant dir="${derby.demo.src.dir}/toursdb"/>
</target>
</project>
Added: db/derby/code/trunk/java/demo/toursdb/BART.gif
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/demo/toursdb/BART.gif?rev=386767&view=auto
==============================================================================
Binary file - no diff available.
Propchange: db/derby/code/trunk/java/demo/toursdb/BART.gif
------------------------------------------------------------------------------
svn:mime-type = application/octet-stream
Added: db/derby/code/trunk/java/demo/toursdb/Caltrain.gif
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/demo/toursdb/Caltrain.gif?rev=386767&view=auto
==============================================================================
Binary file - no diff available.
Propchange: db/derby/code/trunk/java/demo/toursdb/Caltrain.gif
------------------------------------------------------------------------------
svn:mime-type = application/octet-stream
Added: db/derby/code/trunk/java/demo/toursdb/LightRail.gif
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/demo/toursdb/LightRail.gif?rev=386767&view=auto
==============================================================================
Binary file - no diff available.
Propchange: db/derby/code/trunk/java/demo/toursdb/LightRail.gif
------------------------------------------------------------------------------
svn:mime-type = application/octet-stream
Added: db/derby/code/trunk/java/demo/toursdb/ToursDB_schema.sql
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/demo/toursdb/ToursDB_schema.sql?rev=386767&view=auto
==============================================================================
--- db/derby/code/trunk/java/demo/toursdb/ToursDB_schema.sql (added)
+++ db/derby/code/trunk/java/demo/toursdb/ToursDB_schema.sql Fri Mar 17 16:08:36 2006
@@ -0,0 +1,166 @@
+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)
+ );
+
+
+-- \************************************************************\
+
+CREATE TRIGGER TRIG1 AFTER UPDATE ON FLIGHTS REFERENCING OLD AS UPDATEDROW FOR EACH ROW MODE DB2SQL INSERT INTO FLIGHTS_HISTORY VALUES (UPDATEDROW.FLIGHT_ID, UPDATEDROW.SEGMENT_NUMBER, UPDATEDROW.ORIG_AIRPORT,UPDATEDROW.DEPART_TIME, UPDATEDROW.DEST_AIRPORT,UPDATEDROW.ARRIVE_TIME,UPDATEDROW.MEAL, UPDATEDROW.FLYING_TIME, UPDATEDROW.MILES, UPDATEDROW.AIRCRAFT,'INSERTED FROM TRIG1');
+
+CREATE TRIGGER TRIG2 AFTER DELETE ON FLIGHTS FOR EACH STATEMENT MODE DB2SQL
+INSERT INTO FLIGHTS_HISTORY (STATUS) VALUES ('INSERTED FROM TRIG2');
+
Added: db/derby/code/trunk/java/demo/toursdb/build.xml
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/demo/toursdb/build.xml?rev=386767&view=auto
==============================================================================
--- db/derby/code/trunk/java/demo/toursdb/build.xml (added)
+++ db/derby/code/trunk/java/demo/toursdb/build.xml Fri Mar 17 16:08:36 2006
@@ -0,0 +1,104 @@
+<?xml version="1.0"?>
+
+<project default="toursdb" basedir=".">
+
+<!-- Set Properties -->
+ <!-- User settings -->
+ <property file="${user.home}/ant.properties"/>
+ <!-- Set property lib dir -->
+ <property name="properties.dir" value="${ant.home}/properties"/>
+ <!-- Significant dirs -->
+ <property file="${properties.dir}/dirs.properties"/>
+ <!-- Compiler settings -->
+ <property file="${properties.dir}/${build.compiler}.properties"/>
+ <!-- Compile-time classpath properties files -->
+ <property file="${properties.dir}/extrapath.properties"/>
+ <property file="${properties.dir}/compilepath.properties"/>
+
+
+<!-- Targets -->
+
+ <target name="toursdb" depends="compile,buildschema,loadtables,jarup,copyfiles"/>
+
+ <target name="compile">
+ <echo message="Begin building toursdb"/>
+ <javac
+ bootclasspath="${empty}"
+ debug="${debug}"
+ depend="${depend}"
+ deprecation="${deprecation}"
+ optimize="${optimize}"
+ proceed="${proceed}"
+ verbose="${verbose}"
+ srcdir="${derby.demo.src.dir}"
+ destdir="${out.dir}">
+ <classpath>
+ <pathelement path="${compile.classpath}"/>
+ </classpath>
+ <include name="toursdb/insertMaps.java"/>
+ </javac>
+ </target>
+
+ <target name="buildschema">
+ <java classname="org.apache.derby.tools.ij"
+ output="toursdb.out"
+ failonerror="true"
+ dir="${derby.demo.src.dir}/toursdb" fork="true">
+ <classpath>
+ <pathelement path="${out.dir}"/>
+ <pathelement path="${compile.classpath}"/>
+ </classpath>
+ <sysproperty key="ij.driver" value="org.apache.derby.jdbc.EmbeddedDriver"/>
+ <sysproperty key="ij.database" value="jdbc:derby:toursdb;create=true"/>
+ <arg value="ToursDB_schema.sql"/>
+ </java>
+ </target>
+
+ <target name="loadtables">
+ <java classname="org.apache.derby.tools.ij"
+ output="toursdb.out" append="true"
+ failonerror="true"
+ dir="${derby.demo.src.dir}/toursdb" fork="true">
+ <classpath>
+ <pathelement path="${out.dir}"/>
+ <pathelement path="${compile.classpath}"/>
+ </classpath>
+ <sysproperty key="ij.driver" value="org.apache.derby.jdbc.EmbeddedDriver"/>
+ <sysproperty key="ij.database" value="jdbc:derby:toursdb;create=true"/>
+ <arg value="loadTables.sql"/>
+ </java>
+ <java classname="toursdb.insertMaps"
+ output="toursdb.out" append="true"
+ failonerror="true"
+ dir="${derby.demo.src.dir}/toursdb" fork="true">
+ <classpath>
+ <pathelement path="${out.dir}"/>
+ <pathelement path="${compile.classpath}"/>
+ </classpath>
+ </java>
+ <java classname="org.apache.derby.tools.ij"
+ output="toursdb.out" append="true"
+ failonerror="true"
+ dir="${derby.demo.src.dir}/toursdb" fork="true">
+ <classpath>
+ <pathelement path="${out.dir}"/>
+ <pathelement path="${compile.classpath}"/>
+ </classpath>
+ <arg value="disconnect.sql"/>
+ </java>
+ </target>
+
+ <target name="jarup">
+ <zip destfile="${derby.demo.src.dir}/toursdb/toursdb.jar"
+ basedir="${derby.demo.src.dir}/toursdb/toursdb"/>
+ <echo message="Finished building toursdb"/>
+ </target>
+
+ <target name="copyfiles">
+ <copy todir="${out.dir}/${derby.testing.functest.dir}/tests/demo">
+ <fileset dir="${derby.demo.src.dir}/toursdb"
+ includes="*.sql,BART.gif,Caltrain.gif,LightRail.gif"/>
+ </copy>
+ </target>
+
+</project>
Propchange: db/derby/code/trunk/java/demo/toursdb/build.xml
------------------------------------------------------------------------------
svn:eol-style = native
Added: db/derby/code/trunk/java/demo/toursdb/disconnect.sql
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/demo/toursdb/disconnect.sql?rev=386767&view=auto
==============================================================================
--- db/derby/code/trunk/java/demo/toursdb/disconnect.sql (added)
+++ db/derby/code/trunk/java/demo/toursdb/disconnect.sql Fri Mar 17 16:08:36 2006
@@ -0,0 +1,2 @@
+connect 'jdbc:derby:toursdb';
+connect 'jdbc:derby:toursdb;shutdown=true';
Added: db/derby/code/trunk/java/demo/toursdb/insertMaps.java
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/demo/toursdb/insertMaps.java?rev=386767&view=auto
==============================================================================
--- db/derby/code/trunk/java/demo/toursdb/insertMaps.java (added)
+++ db/derby/code/trunk/java/demo/toursdb/insertMaps.java Fri Mar 17 16:08:36 2006
@@ -0,0 +1,99 @@
+/*
+
+ Derby - Class SimpleApp
+
+ Copyright 2001, 2006 The Apache Software Foundation or its licensors, as applicable.
+
+ Licensed 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 toursdb;
+
+import java.io.File;
+import java.io.FileInputStream;
+import java.io.InputStream;
+import java.sql.PreparedStatement;
+import java.sql.Connection;
+import java.sql.DriverManager;
+import java.math.BigDecimal;
+import java.sql.Clob;
+import java.sql.SQLException;
+
+
+public class insertMaps {
+
+ public static final String CSdriver = new String("org.apache.derby.jdbc.EmbeddedDriver");
+ public static final String dbURLCS = new String("jdbc:derby:toursDB");
+
+ public static void main(String[] args) throws Exception {
+
+ try {
+ Connection connCS = null;
+
+ System.out.println("Loading the Cloudscape jdbc driver...");
+ Class.forName(CSdriver).newInstance();
+
+ System.out.println("Getting Cloudscape database connection...");
+ connCS = DriverManager.getConnection(dbURLCS);
+ System.out.println("Successfully got the Cloudscape database connection...");
+
+ PreparedStatement ps = null;
+
+ ps = connCS.prepareStatement
+ ("insert into maps (map_name, region, area, photo_format, picture) values (?,?,?,?,?)");
+
+ ps.setString(1,"BART");
+ ps.setString(2,"Bay Area");
+ ps.setBigDecimal(3, new BigDecimal("1776.11"));
+ ps.setString(4,"gif");
+ File file = new File ("BART.gif");
+ InputStream fileIn = new FileInputStream(file);
+ ps.setBinaryStream(5, fileIn, (int)file.length());
+ int numrows = ps.executeUpdate();
+
+ ps.setString(1,"Caltrain");
+ ps.setString(2,"West Bay");
+ ps.setBigDecimal(3, new BigDecimal("1166.77"));
+ ps.setString(4,"gif");
+ file = new File ("Caltrain.gif");
+ fileIn = new FileInputStream(file);
+ ps.setBinaryStream(5, fileIn, (int)file.length());
+ numrows = numrows + ps.executeUpdate();
+
+ ps.setString(1,"Light Rail");
+ ps.setString(2,"Santa Clara Valley");
+ ps.setBigDecimal(3, new BigDecimal("9117.90"));
+ ps.setString(4,"gif");
+ file = new File ("BART.gif");
+ fileIn = new FileInputStream(file);
+ ps.setBinaryStream(5, fileIn, (int)file.length());
+ numrows = numrows + ps.executeUpdate();
+
+ System.out.println("Inserted " + numrows + " rows into the ToursDB");
+
+ ps.close();
+
+ connCS.close();
+
+ } catch (SQLException e) {
+ System.out.println ("FAIL -- unexpected exception: " + e.toString());
+ e.printStackTrace();
+ } catch (Exception e) {
+ System.out.println ("FAIL -- unexpected exception: " + e.toString());
+ e.printStackTrace();
+ }
+
+ }
+
+}
Propchange: db/derby/code/trunk/java/demo/toursdb/insertMaps.java
------------------------------------------------------------------------------
svn:eol-style = native
Added: db/derby/code/trunk/java/demo/toursdb/loadAIRLINES.sql
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/demo/toursdb/loadAIRLINES.sql?rev=386767&view=auto
==============================================================================
--- db/derby/code/trunk/java/demo/toursdb/loadAIRLINES.sql (added)
+++ db/derby/code/trunk/java/demo/toursdb/loadAIRLINES.sql Fri Mar 17 16:08:36 2006
@@ -0,0 +1,2 @@
+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);
Added: db/derby/code/trunk/java/demo/toursdb/loadCOUNTRIES.sql
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/demo/toursdb/loadCOUNTRIES.sql?rev=386767&view=auto
==============================================================================
--- db/derby/code/trunk/java/demo/toursdb/loadCOUNTRIES.sql (added)
+++ db/derby/code/trunk/java/demo/toursdb/loadCOUNTRIES.sql Fri Mar 17 16:08:36 2006
@@ -0,0 +1,114 @@
+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');
Added: db/derby/code/trunk/java/demo/toursdb/loadCities.sql
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/demo/toursdb/loadCities.sql?rev=386767&view=auto
==============================================================================
--- db/derby/code/trunk/java/demo/toursdb/loadCities.sql (added)
+++ db/derby/code/trunk/java/demo/toursdb/loadCities.sql Fri Mar 17 16:08:36 2006
@@ -0,0 +1,87 @@
+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');
Added: db/derby/code/trunk/java/demo/toursdb/loadFLIGHTAVAILABILITY1.sql
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/demo/toursdb/loadFLIGHTAVAILABILITY1.sql?rev=386767&view=auto
==============================================================================
--- db/derby/code/trunk/java/demo/toursdb/loadFLIGHTAVAILABILITY1.sql (added)
+++ db/derby/code/trunk/java/demo/toursdb/loadFLIGHTAVAILABILITY1.sql Fri Mar 17 16:08:36 2006
@@ -0,0 +1,295 @@
+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);
+
Added: db/derby/code/trunk/java/demo/toursdb/loadFLIGHTAVAILABILITY2.sql
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/demo/toursdb/loadFLIGHTAVAILABILITY2.sql?rev=386767&view=auto
==============================================================================
--- db/derby/code/trunk/java/demo/toursdb/loadFLIGHTAVAILABILITY2.sql (added)
+++ db/derby/code/trunk/java/demo/toursdb/loadFLIGHTAVAILABILITY2.sql Fri Mar 17 16:08:36 2006
@@ -0,0 +1,224 @@
+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);