db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From fuzzylo...@apache.org
Subject 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...
Date Sat, 18 Mar 2006 00:08:38 GMT
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); 



Mime
View raw message