db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From fuzzylo...@apache.org
Subject svn commit: r429826 - in /db/derby/code/trunk/java/demo: ./ nserverdemo/ simple/ toursdb/
Date Tue, 08 Aug 2006 21:30:25 GMT
Author: fuzzylogic
Date: Tue Aug  8 14:30:24 2006
New Revision: 429826

URL: http://svn.apache.org/viewvc?rev=429826&view=rev
Log:
DERBY-1377: Update license headers in java/demo

Added:
    db/derby/code/trunk/java/demo/toursdb/toursdb_readme.html   (with props)
Modified:
    db/derby/code/trunk/java/demo/build.xml
    db/derby/code/trunk/java/demo/csfull.css
    db/derby/code/trunk/java/demo/demo.html
    db/derby/code/trunk/java/demo/navbar.html
    db/derby/code/trunk/java/demo/nserverdemo/NetworkServerUtil.java
    db/derby/code/trunk/java/demo/nserverdemo/NsSample.java
    db/derby/code/trunk/java/demo/nserverdemo/NsSampleClientThread.java
    db/derby/code/trunk/java/demo/nserverdemo/SimpleNetworkClientSample.java
    db/derby/code/trunk/java/demo/nserverdemo/SimpleNetworkServerSample.java
    db/derby/code/trunk/java/demo/nserverdemo/nserverdemo.html
    db/derby/code/trunk/java/demo/nserverdemo/readme.html
    db/derby/code/trunk/java/demo/nserverdemo/simpleserversample.html
    db/derby/code/trunk/java/demo/readme.html
    db/derby/code/trunk/java/demo/simple/SimpleApp.java
    db/derby/code/trunk/java/demo/simple/derby.properties
    db/derby/code/trunk/java/demo/simple/example.html
    db/derby/code/trunk/java/demo/toursdb/ToursDB_schema.sql
    db/derby/code/trunk/java/demo/toursdb/build.xml
    db/derby/code/trunk/java/demo/toursdb/disconnect.sql
    db/derby/code/trunk/java/demo/toursdb/insertMaps.java
    db/derby/code/trunk/java/demo/toursdb/loadAIRLINES.sql
    db/derby/code/trunk/java/demo/toursdb/loadCITIES.sql
    db/derby/code/trunk/java/demo/toursdb/loadCOUNTRIES.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

Modified: db/derby/code/trunk/java/demo/build.xml
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/demo/build.xml?rev=429826&r1=429825&r2=429826&view=diff
==============================================================================
--- db/derby/code/trunk/java/demo/build.xml (original)
+++ db/derby/code/trunk/java/demo/build.xml Tue Aug  8 14:30:24 2006
@@ -1,4 +1,20 @@
 <?xml version="1.0"?>
+<!--
+  Licensed to the Apache Software Foundation (ASF) under one or more
+  contributor license agreements.  See the NOTICE file distributed with
+  this work for additional information regarding copyright ownership.
+  The ASF licenses this file to You under the Apache License, Version 2.0
+  (the "License"); you may not use this file except in compliance with
+  the License.  You may obtain a copy of the License at
+
+      http://www.apache.org/licenses/LICENSE-2.0
+
+  Unless required by applicable law or agreed to in writing, software
+  distributed under the License is distributed on an "AS IS" BASIS,
+  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+  See the License for the specific language governing permissions and
+  limitations under the License.
+-->
 
 <project default="demo" basedir="../..">
 

Modified: db/derby/code/trunk/java/demo/csfull.css
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/demo/csfull.css?rev=429826&r1=429825&r2=429826&view=diff
==============================================================================
--- db/derby/code/trunk/java/demo/csfull.css (original)
+++ db/derby/code/trunk/java/demo/csfull.css Tue Aug  8 14:30:24 2006
@@ -1,3 +1,19 @@
+/*
+* Licensed to the Apache Software Foundation (ASF) under one or more
+* contributor license agreements.  See the NOTICE file distributed with
+* this work for additional information regarding copyright ownership.
+* The ASF licenses this file to You under the Apache License, Version 2.0
+* (the "License"); you may not use this file except in compliance with
+* the License.  You may obtain a copy of the License at
+*
+*     http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+*/
 BODY {
 	font-size : 12pt;
 	font-family : "Times New Roman";

Modified: db/derby/code/trunk/java/demo/demo.html
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/demo/demo.html?rev=429826&r1=429825&r2=429826&view=diff
==============================================================================
--- db/derby/code/trunk/java/demo/demo.html (original)
+++ db/derby/code/trunk/java/demo/demo.html Tue Aug  8 14:30:24 2006
@@ -1,3 +1,19 @@
+<!--
+  Licensed to the Apache Software Foundation (ASF) under one or more
+  contributor license agreements.  See the NOTICE file distributed with
+  this work for additional information regarding copyright ownership.
+  The ASF licenses this file to You under the Apache License, Version 2.0
+  (the "License"); you may not use this file except in compliance with
+  the License.  You may obtain a copy of the License at
+
+      http://www.apache.org/licenses/LICENSE-2.0
+
+  Unless required by applicable law or agreed to in writing, software
+  distributed under the License is distributed on an "AS IS" BASIS,
+  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+  See the License for the specific language governing permissions and
+  limitations under the License.
+-->
 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
 <HTML>
 <HEAD><META http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

Modified: db/derby/code/trunk/java/demo/navbar.html
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/demo/navbar.html?rev=429826&r1=429825&r2=429826&view=diff
==============================================================================
--- db/derby/code/trunk/java/demo/navbar.html (original)
+++ db/derby/code/trunk/java/demo/navbar.html Tue Aug  8 14:30:24 2006
@@ -1,3 +1,19 @@
+<!--
+  Licensed to the Apache Software Foundation (ASF) under one or more
+  contributor license agreements.  See the NOTICE file distributed with
+  this work for additional information regarding copyright ownership.
+  The ASF licenses this file to You under the Apache License, Version 2.0
+  (the "License"); you may not use this file except in compliance with
+  the License.  You may obtain a copy of the License at
+
+      http://www.apache.org/licenses/LICENSE-2.0
+
+  Unless required by applicable law or agreed to in writing, software
+  distributed under the License is distributed on an "AS IS" BASIS,
+  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+  See the License for the specific language governing permissions and
+  limitations under the License.
+-->
 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
 <HTML>
 <HEAD>

Modified: db/derby/code/trunk/java/demo/nserverdemo/NetworkServerUtil.java
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/demo/nserverdemo/NetworkServerUtil.java?rev=429826&r1=429825&r2=429826&view=diff
==============================================================================
--- db/derby/code/trunk/java/demo/nserverdemo/NetworkServerUtil.java (original)
+++ db/derby/code/trunk/java/demo/nserverdemo/NetworkServerUtil.java Tue Aug  8 14:30:24 2006
@@ -2,11 +2,12 @@
 
    Derby - Class nserverdemo.NetworkServerUtil
 
-   Copyright 2003, 2004 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
+   Licensed to the Apache Software Foundation (ASF) under one or more
+   contributor license agreements.  See the NOTICE file distributed with
+   this work for additional information regarding copyright ownership.
+   The ASF licenses this file to You under the Apache License, Version 2.0
+   (the "License"); you may not use this file except in compliance with
+   the License.  You may obtain a copy of the License at
 
       http://www.apache.org/licenses/LICENSE-2.0
 

Modified: db/derby/code/trunk/java/demo/nserverdemo/NsSample.java
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/demo/nserverdemo/NsSample.java?rev=429826&r1=429825&r2=429826&view=diff
==============================================================================
--- db/derby/code/trunk/java/demo/nserverdemo/NsSample.java (original)
+++ db/derby/code/trunk/java/demo/nserverdemo/NsSample.java Tue Aug  8 14:30:24 2006
@@ -2,11 +2,12 @@
 
    Derby - Class nserverdemo.NsSample
 
-   Copyright 2003, 2004 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
+   Licensed to the Apache Software Foundation (ASF) under one or more
+   contributor license agreements.  See the NOTICE file distributed with
+   this work for additional information regarding copyright ownership.
+   The ASF licenses this file to You under the Apache License, Version 2.0
+   (the "License"); you may not use this file except in compliance with
+   the License.  You may obtain a copy of the License at
 
       http://www.apache.org/licenses/LICENSE-2.0
 

Modified: db/derby/code/trunk/java/demo/nserverdemo/NsSampleClientThread.java
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/demo/nserverdemo/NsSampleClientThread.java?rev=429826&r1=429825&r2=429826&view=diff
==============================================================================
--- db/derby/code/trunk/java/demo/nserverdemo/NsSampleClientThread.java (original)
+++ db/derby/code/trunk/java/demo/nserverdemo/NsSampleClientThread.java Tue Aug  8 14:30:24 2006
@@ -2,11 +2,12 @@
 
    Derby - Class nserverdemo.NsSampleClientThread
 
-   Copyright 2003, 2004 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
+   Licensed to the Apache Software Foundation (ASF) under one or more
+   contributor license agreements.  See the NOTICE file distributed with
+   this work for additional information regarding copyright ownership.
+   The ASF licenses this file to You under the Apache License, Version 2.0
+   (the "License"); you may not use this file except in compliance with
+   the License.  You may obtain a copy of the License at
 
       http://www.apache.org/licenses/LICENSE-2.0
 

Modified: db/derby/code/trunk/java/demo/nserverdemo/SimpleNetworkClientSample.java
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/demo/nserverdemo/SimpleNetworkClientSample.java?rev=429826&r1=429825&r2=429826&view=diff
==============================================================================
--- db/derby/code/trunk/java/demo/nserverdemo/SimpleNetworkClientSample.java (original)
+++ db/derby/code/trunk/java/demo/nserverdemo/SimpleNetworkClientSample.java Tue Aug  8 14:30:24 2006
@@ -2,11 +2,12 @@
 
    Derby - Class SimpleNetworkClientSample
 
-   Copyright 2003, 2004 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
+   Licensed to the Apache Software Foundation (ASF) under one or more
+   contributor license agreements.  See the NOTICE file distributed with
+   this work for additional information regarding copyright ownership.
+   The ASF licenses this file to You under the Apache License, Version 2.0
+   (the "License"); you may not use this file except in compliance with
+   the License.  You may obtain a copy of the License at
 
       http://www.apache.org/licenses/LICENSE-2.0
 

Modified: db/derby/code/trunk/java/demo/nserverdemo/SimpleNetworkServerSample.java
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/demo/nserverdemo/SimpleNetworkServerSample.java?rev=429826&r1=429825&r2=429826&view=diff
==============================================================================
--- db/derby/code/trunk/java/demo/nserverdemo/SimpleNetworkServerSample.java (original)
+++ db/derby/code/trunk/java/demo/nserverdemo/SimpleNetworkServerSample.java Tue Aug  8 14:30:24 2006
@@ -2,11 +2,12 @@
 
    Derby - Class SimpleNetworkServerSample
 
-   Copyright 2003, 2004 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
+   Licensed to the Apache Software Foundation (ASF) under one or more
+   contributor license agreements.  See the NOTICE file distributed with
+   this work for additional information regarding copyright ownership.
+   The ASF licenses this file to You under the Apache License, Version 2.0
+   (the "License"); you may not use this file except in compliance with
+   the License.  You may obtain a copy of the License at
 
       http://www.apache.org/licenses/LICENSE-2.0
 

Modified: db/derby/code/trunk/java/demo/nserverdemo/nserverdemo.html
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/demo/nserverdemo/nserverdemo.html?rev=429826&r1=429825&r2=429826&view=diff
==============================================================================
--- db/derby/code/trunk/java/demo/nserverdemo/nserverdemo.html (original)
+++ db/derby/code/trunk/java/demo/nserverdemo/nserverdemo.html Tue Aug  8 14:30:24 2006
@@ -1,3 +1,19 @@
+<!--
+  Licensed to the Apache Software Foundation (ASF) under one or more
+  contributor license agreements.  See the NOTICE file distributed with
+  this work for additional information regarding copyright ownership.
+  The ASF licenses this file to You under the Apache License, Version 2.0
+  (the "License"); you may not use this file except in compliance with
+  the License.  You may obtain a copy of the License at
+
+      http://www.apache.org/licenses/LICENSE-2.0
+
+  Unless required by applicable law or agreed to in writing, software
+  distributed under the License is distributed on an "AS IS" BASIS,
+  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+  See the License for the specific language governing permissions and
+  limitations under the License.
+-->
 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
 <HTML>
 <HEAD>

Modified: db/derby/code/trunk/java/demo/nserverdemo/readme.html
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/demo/nserverdemo/readme.html?rev=429826&r1=429825&r2=429826&view=diff
==============================================================================
--- db/derby/code/trunk/java/demo/nserverdemo/readme.html (original)
+++ db/derby/code/trunk/java/demo/nserverdemo/readme.html Tue Aug  8 14:30:24 2006
@@ -1,3 +1,19 @@
+<!--
+  Licensed to the Apache Software Foundation (ASF) under one or more
+  contributor license agreements.  See the NOTICE file distributed with
+  this work for additional information regarding copyright ownership.
+  The ASF licenses this file to You under the Apache License, Version 2.0
+  (the "License"); you may not use this file except in compliance with
+  the License.  You may obtain a copy of the License at
+
+      http://www.apache.org/licenses/LICENSE-2.0
+
+  Unless required by applicable law or agreed to in writing, software
+  distributed under the License is distributed on an "AS IS" BASIS,
+  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+  See the License for the specific language governing permissions and
+  limitations under the License.
+-->
 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
 <HTML>
 <HEAD><META http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

Modified: db/derby/code/trunk/java/demo/nserverdemo/simpleserversample.html
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/demo/nserverdemo/simpleserversample.html?rev=429826&r1=429825&r2=429826&view=diff
==============================================================================
--- db/derby/code/trunk/java/demo/nserverdemo/simpleserversample.html (original)
+++ db/derby/code/trunk/java/demo/nserverdemo/simpleserversample.html Tue Aug  8 14:30:24 2006
@@ -1,3 +1,19 @@
+<!--
+  Licensed to the Apache Software Foundation (ASF) under one or more
+  contributor license agreements.  See the NOTICE file distributed with
+  this work for additional information regarding copyright ownership.
+  The ASF licenses this file to You under the Apache License, Version 2.0
+  (the "License"); you may not use this file except in compliance with
+  the License.  You may obtain a copy of the License at
+
+      http://www.apache.org/licenses/LICENSE-2.0
+
+  Unless required by applicable law or agreed to in writing, software
+  distributed under the License is distributed on an "AS IS" BASIS,
+  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+  See the License for the specific language governing permissions and
+  limitations under the License.
+-->
 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
 <html>
 

Modified: db/derby/code/trunk/java/demo/readme.html
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/demo/readme.html?rev=429826&r1=429825&r2=429826&view=diff
==============================================================================
--- db/derby/code/trunk/java/demo/readme.html (original)
+++ db/derby/code/trunk/java/demo/readme.html Tue Aug  8 14:30:24 2006
@@ -1,3 +1,19 @@
+<!--
+  Licensed to the Apache Software Foundation (ASF) under one or more
+  contributor license agreements.  See the NOTICE file distributed with
+  this work for additional information regarding copyright ownership.
+  The ASF licenses this file to You under the Apache License, Version 2.0
+  (the "License"); you may not use this file except in compliance with
+  the License.  You may obtain a copy of the License at
+
+      http://www.apache.org/licenses/LICENSE-2.0
+
+  Unless required by applicable law or agreed to in writing, software
+  distributed under the License is distributed on an "AS IS" BASIS,
+  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+  See the License for the specific language governing permissions and
+  limitations under the License.
+-->
 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
 
 <html>

Modified: db/derby/code/trunk/java/demo/simple/SimpleApp.java
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/demo/simple/SimpleApp.java?rev=429826&r1=429825&r2=429826&view=diff
==============================================================================
--- db/derby/code/trunk/java/demo/simple/SimpleApp.java (original)
+++ db/derby/code/trunk/java/demo/simple/SimpleApp.java Tue Aug  8 14:30:24 2006
@@ -2,11 +2,12 @@
 
    Derby - Class SimpleApp
 
-   Copyright 2001, 2004 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
+   Licensed to the Apache Software Foundation (ASF) under one or more
+   contributor license agreements.  See the NOTICE file distributed with
+   this work for additional information regarding copyright ownership.
+   The ASF licenses this file to You under the Apache License, Version 2.0
+   (the "License"); you may not use this file except in compliance with
+   the License.  You may obtain a copy of the License at
 
       http://www.apache.org/licenses/LICENSE-2.0
 

Modified: db/derby/code/trunk/java/demo/simple/derby.properties
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/demo/simple/derby.properties?rev=429826&r1=429825&r2=429826&view=diff
==============================================================================
--- db/derby/code/trunk/java/demo/simple/derby.properties (original)
+++ db/derby/code/trunk/java/demo/simple/derby.properties Tue Aug  8 14:30:24 2006
@@ -1,3 +1,18 @@
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements.  See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License.  You may obtain a copy of the License at
+#
+#     http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+
 # derby.properties
 #
 # we are using the default properties values for this demo

Modified: db/derby/code/trunk/java/demo/simple/example.html
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/demo/simple/example.html?rev=429826&r1=429825&r2=429826&view=diff
==============================================================================
--- db/derby/code/trunk/java/demo/simple/example.html (original)
+++ db/derby/code/trunk/java/demo/simple/example.html Tue Aug  8 14:30:24 2006
@@ -1,3 +1,19 @@
+<!--
+  Licensed to the Apache Software Foundation (ASF) under one or more
+  contributor license agreements.  See the NOTICE file distributed with
+  this work for additional information regarding copyright ownership.
+  The ASF licenses this file to You under the Apache License, Version 2.0
+  (the "License"); you may not use this file except in compliance with
+  the License.  You may obtain a copy of the License at
+
+      http://www.apache.org/licenses/LICENSE-2.0
+
+  Unless required by applicable law or agreed to in writing, software
+  distributed under the License is distributed on an "AS IS" BASIS,
+  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+  See the License for the specific language governing permissions and
+  limitations under the License.
+-->
 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
 <html>
 <head>

Modified: db/derby/code/trunk/java/demo/toursdb/ToursDB_schema.sql
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/demo/toursdb/ToursDB_schema.sql?rev=429826&r1=429825&r2=429826&view=diff
==============================================================================
--- db/derby/code/trunk/java/demo/toursdb/ToursDB_schema.sql (original)
+++ db/derby/code/trunk/java/demo/toursdb/ToursDB_schema.sql Tue Aug  8 14:30:24 2006
@@ -1,3 +1,18 @@
+-- Licensed to the Apache Software Foundation (ASF) under one or more
+-- contributor license agreements.  See the NOTICE file distributed with
+-- this work for additional information regarding copyright ownership.
+-- The ASF licenses this file to You under the Apache License, Version 2.0
+-- (the "License"); you may not use this file except in compliance with
+-- the License.  You may obtain a copy of the License at
+--
+--     http://www.apache.org/licenses/LICENSE-2.0
+--
+-- Unless required by applicable law or agreed to in writing, software
+-- distributed under the License is distributed on an "AS IS" BASIS,
+-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+-- See the License for the specific language governing permissions and
+-- limitations under the License.
+
 CREATE TABLE AIRLINES
    (
       AIRLINE CHAR(2) NOT NULL ,

Modified: db/derby/code/trunk/java/demo/toursdb/build.xml
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/demo/toursdb/build.xml?rev=429826&r1=429825&r2=429826&view=diff
==============================================================================
--- db/derby/code/trunk/java/demo/toursdb/build.xml (original)
+++ db/derby/code/trunk/java/demo/toursdb/build.xml Tue Aug  8 14:30:24 2006
@@ -1,4 +1,20 @@
 <?xml version="1.0"?>
+<!--
+  Licensed to the Apache Software Foundation (ASF) under one or more
+  contributor license agreements.  See the NOTICE file distributed with
+  this work for additional information regarding copyright ownership.
+  The ASF licenses this file to You under the Apache License, Version 2.0
+  (the "License"); you may not use this file except in compliance with
+  the License.  You may obtain a copy of the License at
+
+      http://www.apache.org/licenses/LICENSE-2.0
+
+  Unless required by applicable law or agreed to in writing, software
+  distributed under the License is distributed on an "AS IS" BASIS,
+  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+  See the License for the specific language governing permissions and
+  limitations under the License.
+-->
 
 <project default="toursdb" basedir=".">
 

Modified: db/derby/code/trunk/java/demo/toursdb/disconnect.sql
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/demo/toursdb/disconnect.sql?rev=429826&r1=429825&r2=429826&view=diff
==============================================================================
--- db/derby/code/trunk/java/demo/toursdb/disconnect.sql (original)
+++ db/derby/code/trunk/java/demo/toursdb/disconnect.sql Tue Aug  8 14:30:24 2006
@@ -1,2 +1,17 @@
+-- Licensed to the Apache Software Foundation (ASF) under one or more
+-- contributor license agreements.  See the NOTICE file distributed with
+-- this work for additional information regarding copyright ownership.
+-- The ASF licenses this file to You under the Apache License, Version 2.0
+-- (the "License"); you may not use this file except in compliance with
+-- the License.  You may obtain a copy of the License at
+--
+--     http://www.apache.org/licenses/LICENSE-2.0
+--
+-- Unless required by applicable law or agreed to in writing, software
+-- distributed under the License is distributed on an "AS IS" BASIS,
+-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+-- See the License for the specific language governing permissions and
+-- limitations under the License.
+
 connect 'jdbc:derby:toursdb';
 connect 'jdbc:derby:toursdb;shutdown=true';

Modified: db/derby/code/trunk/java/demo/toursdb/insertMaps.java
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/demo/toursdb/insertMaps.java?rev=429826&r1=429825&r2=429826&view=diff
==============================================================================
--- db/derby/code/trunk/java/demo/toursdb/insertMaps.java (original)
+++ db/derby/code/trunk/java/demo/toursdb/insertMaps.java Tue Aug  8 14:30:24 2006
@@ -2,11 +2,12 @@
 
    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
+   Licensed to the Apache Software Foundation (ASF) under one or more
+   contributor license agreements.  See the NOTICE file distributed with
+   this work for additional information regarding copyright ownership.
+   The ASF licenses this file to You under the Apache License, Version 2.0
+   (the "License"); you may not use this file except in compliance with
+   the License.  You may obtain a copy of the License at
 
       http://www.apache.org/licenses/LICENSE-2.0
 

Modified: db/derby/code/trunk/java/demo/toursdb/loadAIRLINES.sql
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/demo/toursdb/loadAIRLINES.sql?rev=429826&r1=429825&r2=429826&view=diff
==============================================================================
--- db/derby/code/trunk/java/demo/toursdb/loadAIRLINES.sql (original)
+++ db/derby/code/trunk/java/demo/toursdb/loadAIRLINES.sql Tue Aug  8 14:30:24 2006
@@ -1,2 +1,17 @@
+-- Licensed to the Apache Software Foundation (ASF) under one or more
+-- contributor license agreements.  See the NOTICE file distributed with
+-- this work for additional information regarding copyright ownership.
+-- The ASF licenses this file to You under the Apache License, Version 2.0
+-- (the "License"); you may not use this file except in compliance with
+-- the License.  You may obtain a copy of the License at
+--
+--     http://www.apache.org/licenses/LICENSE-2.0
+--
+-- Unless required by applicable law or agreed to in writing, software
+-- distributed under the License is distributed on an "AS IS" BASIS,
+-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+-- See the License for the specific language governing permissions and
+-- limitations under the License.
+
 insert into AIRLINES values ('AA','Amazonian Airways',0.18,0.03,0.5,1.5,20,10,5) ;
 insert into AIRLINES values ('US','Union Standard Airlines',0.19,0.05,0.4,1.6,20,10,5);

Modified: db/derby/code/trunk/java/demo/toursdb/loadCITIES.sql
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/demo/toursdb/loadCITIES.sql?rev=429826&r1=429825&r2=429826&view=diff
==============================================================================
--- db/derby/code/trunk/java/demo/toursdb/loadCITIES.sql (original)
+++ db/derby/code/trunk/java/demo/toursdb/loadCITIES.sql Tue Aug  8 14:30:24 2006
@@ -1,3 +1,18 @@
+-- Licensed to the Apache Software Foundation (ASF) under one or more
+-- contributor license agreements.  See the NOTICE file distributed with
+-- this work for additional information regarding copyright ownership.
+-- The ASF licenses this file to You under the Apache License, Version 2.0
+-- (the "License"); you may not use this file except in compliance with
+-- the License.  You may obtain a copy of the License at
+--
+--     http://www.apache.org/licenses/LICENSE-2.0
+--
+-- Unless required by applicable law or agreed to in writing, software
+-- distributed under the License is distributed on an "AS IS" BASIS,
+-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+-- See the License for the specific language governing permissions and
+-- limitations under the License.
+
 insert into CITIES VALUES (1,'Amsterdam','Netherlands','AMS','Dutch','NL');
 insert into CITIES VALUES (2,'Athens','Greece','ATH','Greek','GR');
 insert into CITIES VALUES (3,'Auckland','New Zealand','AKL','English','NZ');

Modified: db/derby/code/trunk/java/demo/toursdb/loadCOUNTRIES.sql
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/demo/toursdb/loadCOUNTRIES.sql?rev=429826&r1=429825&r2=429826&view=diff
==============================================================================
--- db/derby/code/trunk/java/demo/toursdb/loadCOUNTRIES.sql (original)
+++ db/derby/code/trunk/java/demo/toursdb/loadCOUNTRIES.sql Tue Aug  8 14:30:24 2006
@@ -1,3 +1,18 @@
+-- Licensed to the Apache Software Foundation (ASF) under one or more
+-- contributor license agreements.  See the NOTICE file distributed with
+-- this work for additional information regarding copyright ownership.
+-- The ASF licenses this file to You under the Apache License, Version 2.0
+-- (the "License"); you may not use this file except in compliance with
+-- the License.  You may obtain a copy of the License at
+--
+--     http://www.apache.org/licenses/LICENSE-2.0
+--
+-- Unless required by applicable law or agreed to in writing, software
+-- distributed under the License is distributed on an "AS IS" BASIS,
+-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+-- See the License for the specific language governing permissions and
+-- limitations under the License.
+
 insert into COUNTRIES values ( 'Afghanistan','AF','Asia');
 insert into COUNTRIES values ( 'Albania','AL','Europe');
 insert into COUNTRIES values ('Algeria','DZ','North Africa');

Modified: db/derby/code/trunk/java/demo/toursdb/loadFLIGHTAVAILABILITY1.sql
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/demo/toursdb/loadFLIGHTAVAILABILITY1.sql?rev=429826&r1=429825&r2=429826&view=diff
==============================================================================
--- db/derby/code/trunk/java/demo/toursdb/loadFLIGHTAVAILABILITY1.sql (original)
+++ db/derby/code/trunk/java/demo/toursdb/loadFLIGHTAVAILABILITY1.sql Tue Aug  8 14:30:24 2006
@@ -1,3 +1,18 @@
+-- Licensed to the Apache Software Foundation (ASF) under one or more
+-- contributor license agreements.  See the NOTICE file distributed with
+-- this work for additional information regarding copyright ownership.
+-- The ASF licenses this file to You under the Apache License, Version 2.0
+-- (the "License"); you may not use this file except in compliance with
+-- the License.  You may obtain a copy of the License at
+--
+--     http://www.apache.org/licenses/LICENSE-2.0
+--
+-- Unless required by applicable law or agreed to in writing, software
+-- distributed under the License is distributed on an "AS IS" BASIS,
+-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+-- See the License for the specific language governing permissions and
+-- limitations under the License.
+
 insert into FLIGHTAVAILABILITY values ('AA1116',1,'2004-03-31',2,2,2); 
 insert into FLIGHTAVAILABILITY values ('AA1116',1,'2004-04-11',1,1,1); 
 insert into FLIGHTAVAILABILITY values ('AA1116',1,'2004-04-12',2,2,2); 

Modified: db/derby/code/trunk/java/demo/toursdb/loadFLIGHTAVAILABILITY2.sql
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/demo/toursdb/loadFLIGHTAVAILABILITY2.sql?rev=429826&r1=429825&r2=429826&view=diff
==============================================================================
--- db/derby/code/trunk/java/demo/toursdb/loadFLIGHTAVAILABILITY2.sql (original)
+++ db/derby/code/trunk/java/demo/toursdb/loadFLIGHTAVAILABILITY2.sql Tue Aug  8 14:30:24 2006
@@ -1,3 +1,18 @@
+-- Licensed to the Apache Software Foundation (ASF) under one or more
+-- contributor license agreements.  See the NOTICE file distributed with
+-- this work for additional information regarding copyright ownership.
+-- The ASF licenses this file to You under the Apache License, Version 2.0
+-- (the "License"); you may not use this file except in compliance with
+-- the License.  You may obtain a copy of the License at
+--
+--     http://www.apache.org/licenses/LICENSE-2.0
+--
+-- Unless required by applicable law or agreed to in writing, software
+-- distributed under the License is distributed on an "AS IS" BASIS,
+-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+-- See the License for the specific language governing permissions and
+-- limitations under the License.
+
 insert into FLIGHTAVAILABILITY values ('AA1211',1,'2004-03-31',2,2,2); 
 insert into FLIGHTAVAILABILITY values ('AA1211',1,'2004-04-11',1,1,1); 
 insert into FLIGHTAVAILABILITY values ('AA1211',1,'2004-04-12',2,2,2); 

Modified: db/derby/code/trunk/java/demo/toursdb/loadFLIGHTS1.sql
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/demo/toursdb/loadFLIGHTS1.sql?rev=429826&r1=429825&r2=429826&view=diff
==============================================================================
--- db/derby/code/trunk/java/demo/toursdb/loadFLIGHTS1.sql (original)
+++ db/derby/code/trunk/java/demo/toursdb/loadFLIGHTS1.sql Tue Aug  8 14:30:24 2006
@@ -1,3 +1,18 @@
+-- Licensed to the Apache Software Foundation (ASF) under one or more
+-- contributor license agreements.  See the NOTICE file distributed with
+-- this work for additional information regarding copyright ownership.
+-- The ASF licenses this file to You under the Apache License, Version 2.0
+-- (the "License"); you may not use this file except in compliance with
+-- the License.  You may obtain a copy of the License at
+--
+--     http://www.apache.org/licenses/LICENSE-2.0
+--
+-- Unless required by applicable law or agreed to in writing, software
+-- distributed under the License is distributed on an "AS IS" BASIS,
+-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+-- See the License for the specific language governing permissions and
+-- limitations under the License.
+
 insert into FLIGHTS values ('AA1111',1,'ABQ','09:00:00','LAX','09:19:00','S',1.328,664,'B747'); 
 insert into FLIGHTS values ('AA1112',1,'LAX','09:00:00','ABQ','11:19:00','S',1.328,664,'B747'); 
 insert into FLIGHTS values ('AA1113',1,'ABQ','09:00:00','PHX','09:39:00','S',0.658,329,'B747'); 

Modified: db/derby/code/trunk/java/demo/toursdb/loadFLIGHTS2.sql
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/demo/toursdb/loadFLIGHTS2.sql?rev=429826&r1=429825&r2=429826&view=diff
==============================================================================
--- db/derby/code/trunk/java/demo/toursdb/loadFLIGHTS2.sql (original)
+++ db/derby/code/trunk/java/demo/toursdb/loadFLIGHTS2.sql Tue Aug  8 14:30:24 2006
@@ -1,3 +1,18 @@
+-- Licensed to the Apache Software Foundation (ASF) under one or more
+-- contributor license agreements.  See the NOTICE file distributed with
+-- this work for additional information regarding copyright ownership.
+-- The ASF licenses this file to You under the Apache License, Version 2.0
+-- (the "License"); you may not use this file except in compliance with
+-- the License.  You may obtain a copy of the License at
+--
+--     http://www.apache.org/licenses/LICENSE-2.0
+--
+-- Unless required by applicable law or agreed to in writing, software
+-- distributed under the License is distributed on an "AS IS" BASIS,
+-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+-- See the License for the specific language governing permissions and
+-- limitations under the License.
+
 insert into FLIGHTS values ('AA1137',2,'KBL','13:30:00','SVO','15:41:00','S',4.192,2096,'A320'); 
 insert into FLIGHTS values ('AA1138',1,'SVO','09:00:00','KBL','15:11:00','L',4.192,2096,'A320'); 
 insert into FLIGHTS values ('US1321',1,'KHI','09:00:00','IST','10:54:00','L',4.9,2450,'B747'); 

Modified: db/derby/code/trunk/java/demo/toursdb/loadTables.sql
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/demo/toursdb/loadTables.sql?rev=429826&r1=429825&r2=429826&view=diff
==============================================================================
--- db/derby/code/trunk/java/demo/toursdb/loadTables.sql (original)
+++ db/derby/code/trunk/java/demo/toursdb/loadTables.sql Tue Aug  8 14:30:24 2006
@@ -1,3 +1,18 @@
+-- Licensed to the Apache Software Foundation (ASF) under one or more
+-- contributor license agreements.  See the NOTICE file distributed with
+-- this work for additional information regarding copyright ownership.
+-- The ASF licenses this file to You under the Apache License, Version 2.0
+-- (the "License"); you may not use this file except in compliance with
+-- the License.  You may obtain a copy of the License at
+--
+--     http://www.apache.org/licenses/LICENSE-2.0
+--
+-- Unless required by applicable law or agreed to in writing, software
+-- distributed under the License is distributed on an "AS IS" BASIS,
+-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+-- See the License for the specific language governing permissions and
+-- limitations under the License.
+
 run 'loadCOUNTRIES.sql';
 
 run 'loadCITIES.sql';

Modified: db/derby/code/trunk/java/demo/toursdb/toursdb.xml
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/demo/toursdb/toursdb.xml?rev=429826&r1=429825&r2=429826&view=diff
==============================================================================
--- db/derby/code/trunk/java/demo/toursdb/toursdb.xml (original)
+++ db/derby/code/trunk/java/demo/toursdb/toursdb.xml Tue Aug  8 14:30:24 2006
@@ -1,4 +1,20 @@
 <?xml version="1.0"?>
+<!--
+  Licensed to the Apache Software Foundation (ASF) under one or more
+  contributor license agreements.  See the NOTICE file distributed with
+  this work for additional information regarding copyright ownership.
+  The ASF licenses this file to You under the Apache License, Version 2.0
+  (the "License"); you may not use this file except in compliance with
+  the License.  You may obtain a copy of the License at
+
+      http://www.apache.org/licenses/LICENSE-2.0
+
+  Unless required by applicable law or agreed to in writing, software
+  distributed under the License is distributed on an "AS IS" BASIS,
+  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+  See the License for the specific language governing permissions and
+  limitations under the License.
+-->
 
 <project default="toursdb" basedir=".">
 

Added: db/derby/code/trunk/java/demo/toursdb/toursdb_readme.html
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/demo/toursdb/toursdb_readme.html?rev=429826&view=auto
==============================================================================
--- db/derby/code/trunk/java/demo/toursdb/toursdb_readme.html (added)
+++ db/derby/code/trunk/java/demo/toursdb/toursdb_readme.html Tue Aug  8 14:30:24 2006
@@ -0,0 +1,582 @@
+<!--
+  Licensed to the Apache Software Foundation (ASF) under one or more
+  contributor license agreements.  See the NOTICE file distributed with
+  this work for additional information regarding copyright ownership.
+  The ASF licenses this file to You under the Apache License, Version 2.0
+  (the "License"); you may not use this file except in compliance with
+  the License.  You may obtain a copy of the License at
+
+      http://www.apache.org/licenses/LICENSE-2.0
+
+  Unless required by applicable law or agreed to in writing, software
+  distributed under the License is distributed on an "AS IS" BASIS,
+  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+  See the License for the specific language governing permissions and
+  limitations under the License.
+-->
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
+<HTML>
+<HEAD>
+<META http-equiv="CONTENT-TYPE" content="text/html; charset=iso-8559-1">
+<TITLE>toursdb_readme.htm</TITLE>
+<link rel="stylesheet" type="text/css" href="../../csfull.css" title="toursdb">
+</HEAD>
+<BODY>
+
+<META name="CREATED" content="20051031;9095275">
+<META name="CHANGED" content="20051031;9274086">
+
+<H1>
+<A NAME="top"></A>Derby Example and Demo Database toursdb</FONT></H1>
+<H2><FONT SIZE="5">1. Introduction</FONT></H2>
+<P> This document describes some aspects of the Derby Example and demo database toursdb. 
+<H2><FONT SIZE="5">2. Purpose of the database toursdb</FONT></H2>
+<P>The toursdb is provided as an example and demo database to illustrate some functionality of the Derby RDBMS. Many of the examples in the Derby documentation use tables that exist in the toursdb database. 
+<P>The toursdb database is created, and can be recreated using the files in &lt;your derby install directory&gt;/demo/programs if you have an installation that includes these. 
+<P>The built database is placed in &lt;your derby install directory&gt;/demo/databases. 
+<H2><FONT SIZE="5">3. The toursdb schema</FONT></H2>
+<P>The toursdb schema is the default schema, 'APP'. 
+<P>The toursdb tables are: 
+<BR>(Note: in the following table no description is given where the columnname is deemed to be explanation enough.) <BR CLEAR="LEFT">
+<A HREF="#AIRLINES">AIRLINES</A> <BR CLEAR="LEFT">
+<A HREF="#COUNTRIES">COUNTRIES</A> <BR CLEAR="LEFT">
+<A HREF="#CITIES">CITIES</A> <BR CLEAR="LEFT">
+<A HREF="#FLIGHTS">FLIGHTS</A> <BR CLEAR="LEFT">
+<A HREF="#FLIGHTAVAILABILITY">FLIGHTAVAILABILITY</A> <BR CLEAR="LEFT">
+<A HREF="#MAPS">MAPS</A> <BR CLEAR="LEFT">
+<A HREF="#FLIGHTS_HISTORY">FLIGHTS_HISTORY</A> 
+<P>Constraints and Indices are listed underneath the respective tables 
+<P><A HREF="#TRIGGERS">TRIGGERS</A> 
+<P>
+<TABLE BORDER="1" BORDERCOLOR="#000000" CELLSPACING="0" CELLPADDING="4" WIDTH="100%">
+	<TR>
+		<TD WIDTH="19%" ALIGN="LEFT" VALIGN="TOP">TableName  </TD>
+		<TD WIDTH="30%" ALIGN="LEFT" VALIGN="TOP">ColumnName  </TD>
+		<TD WIDTH="22%" ALIGN="LEFT" VALIGN="TOP">DataType  </TD>
+		<TD WIDTH="6%" ALIGN="LEFT" VALIGN="TOP">other  </TD>
+		<TD WIDTH="19%" ALIGN="LEFT" VALIGN="TOP">Description  </TD></TR>
+
+	<TR>
+		<TD ALIGN="LEFT" VALIGN="TOP"><A NAME="AIRLINES"></A>AIRLINES   </TD>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">Information about Airline companies  </TD></TR>
+
+	<TR>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;   </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">AIRLINE  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">CHAR(2)  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">PK, not null  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">Airline company code  </TD></TR>
+
+	<TR>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;   </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">AIRLINE_FULL  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">VARCHAR(24)  </TD>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">Full name of Airline company  </TD></TR>
+
+	<TR>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;   </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">BASIC_RATE  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">DOUBLE_PRECISION  </TD>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">Basic rate for flying with this airline  </TD></TR>
+
+	<TR>
+		<TD ALIGN="LEFT" VALIGN="TOP">&nbsp;   </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">DISTANCE_DISCOUNT  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">DOUBLE PRECISION  </TD>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">Discount for larger distances  </TD></TR>
+
+	<TR>
+		<TD ALIGN="LEFT" VALIGN="TOP">&nbsp;   </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">BUSINESS_LEVEL_FACTOR  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">DOUBLE PRECISION  </TD>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">&nbsp;  </TD></TR>
+
+	<TR>
+		<TD ALIGN="LEFT" VALIGN="TOP">&nbsp;   </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">FIRSTCLASS_LEVEL_FACTOR  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">DOUBLE PRECISION  </TD>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">Percentage addition for first class cost  </TD></TR>
+
+	<TR>
+		<TD ALIGN="LEFT" VALIGN="TOP">&nbsp;   </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">ECONOMY_SEATS  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">INTEGER  </TD>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">No. of economy seats  </TD></TR>
+
+	<TR>
+		<TD ALIGN="LEFT" VALIGN="TOP">&nbsp;   </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">BUSINESS_SEATS  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">INTEGER  </TD>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">No. of business seats  </TD></TR>
+
+	<TR>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;   </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">FIRSTCLASS_SEATS  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">INTEGER  </TD>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">No. of first class seats  </TD></TR>
+
+</TABLE>
+
+<P>CONSTRAINTS: <BR CLEAR="LEFT">
+
+
+<UL>constraint AIRLINES_PK AIRLINE Primary Key </UL>
+
+<P>
+<TABLE BORDER="1" BORDERCOLOR="#000000" CELLSPACING="0" CELLPADDING="4" WIDTH="100%">
+	<TR>
+		<TD WIDTH="19%" ALIGN="LEFT" VALIGN="TOP"><A NAME="COUNTRIES"></A>COUNTRIES  </TD>
+		<TD WIDTH="31%" ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD>
+		<TD WIDTH="22%" ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD>
+		<TD WIDTH="6%" ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD>
+		<TD WIDTH="19%" ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD></TR>
+
+	<TR>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;   </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">COUNTRY  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">VARCHAR(26)  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">not null  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">Country name in English  </TD></TR>
+
+	<TR>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;   </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">COUNTRY_ISO_CODE  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">CHAR(2)  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">PK, not null  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">Country code  </TD></TR>
+
+	<TR>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;   </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">REGION  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">VARCHAR(26)  </TD>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">Region  </TD></TR>
+
+</TABLE>
+
+<P>CONSTRAINTS: <BR CLEAR="LEFT">
+
+
+<UL>constraint COUNTRIES_PK COUNTRY_ISO_CODE Primary Key <BR CLEAR="LEFT">
+constraint COUNTRIES_UNQ_NM Unique Country <BR CLEAR="LEFT">
+constraint COUNTRIES_UC Check country_ISO_code = upper(country_ISO_code) </UL>
+
+<P>
+<TABLE BORDER="1" BORDERCOLOR="#000000" CELLSPACING="0" CELLPADDING="4" WIDTH="100%">
+	<TR>
+		<TD WIDTH="20%" ALIGN="LEFT" VALIGN="TOP"><A NAME="CITIES"></A>CITIES  </TD>
+		<TD WIDTH="32%" ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD>
+		<TD WIDTH="23%" ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD>
+		<TD WIDTH="6%" ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD>
+		<TD WIDTH="16%" ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD></TR>
+
+	<TR>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;   </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">CITY_ID &nbsp;  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">INTEGER  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">PK, not null  </TD>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD></TR>
+
+	<TR>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;   </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">CITY_NAME  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">VARCHAR(24)  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">not null  </TD>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD></TR>
+
+	<TR>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;   </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">COUNTRY  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">VARCHAR(26)  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">not null  </TD>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD></TR>
+
+	<TR>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;   </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">AIRPORT  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">VARCHAR(3)  </TD>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">airport code&nbsp;  </TD></TR>
+
+	<TR>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;   </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">LANGUAGE  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">VARCHAR(16)  </TD>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD></TR>
+
+	<TR>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;   </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">COUNTRY_ISO_CODE  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">CHAR(2)  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">FK  </TD>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD></TR>
+
+</TABLE>
+
+<P>CONSTRAINTS: <BR CLEAR="LEFT">
+
+
+<UL>constraint CITIES_PK CITY_ID Primary Key <BR CLEAR="LEFT">
+constraint COUNTRIES_FK Foreign Key COUNTRY_ISO_CODE references <BR CLEAR="LEFT">
+</UL>
+
+
+<UL><UL><UL>COUNTRIES.COUNTRY_ISO_CODE</UL></UL></UL>
+
+<P>
+<TABLE BORDER="1" BORDERCOLOR="#000000" CELLSPACING="0" CELLPADDING="4" WIDTH="100%">
+	<TR>
+		<TD WIDTH="19%" ALIGN="LEFT" VALIGN="TOP"><A NAME="FLIGHTS"></A>FLIGHTS  </TD>
+		<TD WIDTH="31%" ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD>
+		<TD WIDTH="22%" ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD>
+		<TD WIDTH="6%" ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD>
+		<TD WIDTH="19%" ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD></TR>
+
+	<TR>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;   </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">FLIGHT_ID  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">CHAR(6)  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">PK, not null  </TD>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD></TR>
+
+	<TR>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;   </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">SEGMENT_NUMBER  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">INTEGER  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">PK, not null  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">number for segment of a flight  </TD></TR>
+
+	<TR>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;   </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">ORIG_AIRPORT  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">CHAR(3)  </TD>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">airport where flight originates  </TD></TR>
+
+	<TR>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;   </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">DEPART_TIME  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">TIME  </TD>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">scheduled departure time  </TD></TR>
+
+	<TR>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;   </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">DEST_AIRPORT  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">CHAR(3)  </TD>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">destination airport  </TD></TR>
+
+	<TR>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;   </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">ARRIVE_TIME  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">TIME  </TD>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">scheduled arrival time  </TD></TR>
+
+	<TR>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;   </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">MEAL  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">CHAR(1)  </TD>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">indicator for type of meals available<BR CLEAR="LEFT">
+B - Breakfast<BR CLEAR="LEFT">
+L - Lunch<BR CLEAR="LEFT">
+D - Dinner<BR CLEAR="LEFT">
+S - Snack  </TD></TR>
+
+	<TR>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;   </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">FLYING_TIME  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">DOUBLE PRECISION  </TD>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">scheduled duration of flight  </TD></TR>
+
+	<TR>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;   </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">MILES  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">INTEGER  </TD>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">length of flight  </TD></TR>
+
+	<TR>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;   </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">AIRCRAFT  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">VARCHAR(6)  </TD>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">type of aircraft  </TD></TR>
+
+</TABLE>
+
+<P>CONSTRAINTS: <BR CLEAR="LEFT">
+
+
+<UL>constraint FLIGHTS_PK FLIGHT_ID,SEGMENT_NUMBER Primary Key <BR CLEAR="LEFT">
+constraint MEAL_COUNSTRAINT Check meal IN ('B', 'L', 'D', 'S') </UL>
+
+<P>INDICES: <BR CLEAR="LEFT">
+
+
+<UL>index DESTINDEX on FLIGHTS (DEST_AIRPORT) <BR CLEAR="LEFT">
+index ORIGINDEX on FLIGHTS (ORIG_AIRPORT) </UL>
+
+<P>
+<TABLE BORDER="1" BORDERCOLOR="#000000" CELLSPACING="0" CELLPADDING="4" WIDTH="100%">
+	<TR>
+		<TD WIDTH="20%" ALIGN="LEFT" VALIGN="TOP"><A NAME="FLIGHTAVAILABILITY"></A>FLIGHTAVAILABILITY  </TD>
+		<TD WIDTH="31%" ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD>
+		<TD WIDTH="23%" ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD>
+		<TD WIDTH="6%" ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD>
+		<TD WIDTH="18%" ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD></TR>
+
+	<TR>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;   </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">FLIGHT_ID  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">CHAR(6)  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">PK, not null  </TD>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD></TR>
+
+	<TR>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;   </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">SEGMENT_NUMBER  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">INTEGER  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">PK, not null  </TD>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">number for segment of a flight</TD></TR>
+
+	<TR>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;   </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">FLIGHT_DATE  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">DATE  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">PK, not null  </TD>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">date on which the flight takes place&nbsp;  </TD></TR>
+
+	<TR>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;   </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">ECONOMY_SEATS_TAKEN  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">INTEGER  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">def. 0  </TD>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD></TR>
+
+	<TR>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;   </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">BUSINESS_SEATS_TAKEN  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">INTEGER  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">def. 0  </TD>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD></TR>
+
+	<TR>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;   </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">FIRSTCLASS_SEATS_TAKEN  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">INTEGER  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">def. 0  </TD>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD></TR>
+
+</TABLE>
+
+<P>def. = default 
+<P>CONSTRAINTS: <BR CLEAR="LEFT">
+
+
+<UL>constraint FLIGHT_AVAILABILITY_PK FLIGHT_ID, SEGMENT_NUMBER, FLIGHT_DATE Primary Key <BR CLEAR="LEFT">
+constraint FLIGHTS_FK2 Foreign Key FLIGHT_ID,SEGMENT_NUMBER references </UL>
+
+
+<UL><UL><UL>FLIGHTS. FLIGHT_ID, SEGMENT_NUMBER</UL></UL></UL>
+
+<P>
+<TABLE BORDER="1" BORDERCOLOR="#000000" CELLSPACING="0" CELLPADDING="4" WIDTH="100%">
+	<TR>
+		<TD WIDTH="20%" ALIGN="LEFT" VALIGN="TOP"><A NAME="MAPS"></A>MAPS  </TD>
+		<TD WIDTH="31%" ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD>
+		<TD WIDTH="23%" ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD>
+		<TD WIDTH="6%" ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD>
+		<TD WIDTH="18%" ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD></TR>
+
+	<TR>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;   </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">MAP_ID  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">INTEGER  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">not null, <P>gen. alw. as id. st. 1 incr. by 1  </TD>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD></TR>
+
+	<TR>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;   </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">MAP_NAME  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">VARCHAR(24)  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">not null  </TD>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD></TR>
+
+	<TR>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;   </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">REGION  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">VARCHAR(26)  </TD>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD></TR>
+
+	<TR>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;   </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">AREA DECIMAL(8,4)  </TD>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">not null  </TD>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD></TR>
+
+	<TR>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;   </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">PHOTO_FORMAT  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">VARCHAR(26)  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">not null  </TD>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD></TR>
+
+	<TR>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;   </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">PICTURE  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">BLOB(102400)  </TD>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD></TR>
+
+</TABLE>
+
+<P>gen alw. as id. st. 1 incr. by 1 = generated always as identity (start with 1, increment by 1) 
+<P>CONSTRAINTS: <BR CLEAR="LEFT">
+
+
+<UL>constraint Unique MAP_ID, MAP_NAME </UL>
+
+<P>
+<TABLE BORDER="1" BORDERCOLOR="#000000" CELLSPACING="0" CELLPADDING="4" WIDTH="100%">
+	<TR>
+		<TD WIDTH="20%" ALIGN="LEFT" VALIGN="TOP"><A NAME="FLIGHTS_HISTORY"></A>FLIGHTS_HISTORY  </TD>
+		<TD WIDTH="30%" ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD>
+		<TD WIDTH="22%" ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD>
+		<TD WIDTH="6%" ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD>
+		<TD WIDTH="18%" ALIGN="LEFT" VALIGN="TOP">archived flights  </TD></TR>
+
+	<TR>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;   </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">FLIGHT_ID  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">CHAR(6)  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">not null  </TD>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD></TR>
+
+	<TR>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;   </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">SEGMENT_NUMBER  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">INTEGER  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">not null  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">number for segment of a flight  </TD></TR>
+
+	<TR>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;   </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">ORIG_AIRPORT  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">CHAR(3)  </TD>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">airport where flight originates  </TD></TR>
+
+	<TR>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;   </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">DEPART_TIME  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">TIME  </TD>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">scheduled departure time  </TD></TR>
+
+	<TR>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;   </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">DEST_AIRPORT  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">CHAR(3)  </TD>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">destination airport  </TD></TR>
+
+	<TR>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;   </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">ARRIVE_TIME  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">TIME  </TD>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">scheduled arrival time  </TD></TR>
+
+	<TR>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;   </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">MEAL  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">CHAR(1)  </TD>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">indicator for type of meals available<BR CLEAR="LEFT">
+B - Breakfast<BR CLEAR="LEFT">
+L - Lunch<BR CLEAR="LEFT">
+D - Dinner<BR CLEAR="LEFT">
+S - Snack  </TD></TR>
+
+	<TR>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;   </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">FLYING_TIME  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">DOUBLE PRECISION  </TD>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">scheduled duration of flight  </TD></TR>
+
+	<TR>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;   </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">MILES  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">INTEGER  </TD>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">length of flight  </TD></TR>
+
+	<TR>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;   </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">AIRCRAFT  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">VARCHAR(6)  </TD>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">type of aircraft  </TD></TR>
+
+	<TR>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;   </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">STATUS  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">VARCHAR(20)  </TD>
+		<TD ALIGN="LEFT" VALIGN="MIDDLE">&nbsp;  </TD>
+		<TD ALIGN="LEFT" VALIGN="TOP">code indicating which trigger created the record  </TD></TR>
+
+</TABLE>
+
+<P><A NAME="TRIGGERS"></A>TRIGGERS: 
+
+<UL>TRIG1 <BR CLEAR="LEFT">
+</UL>
+
+
+<UL><UL>after update on FLIGHTS <BR CLEAR="LEFT">
+referencing old as UPDATEDROW <BR CLEAR="LEFT">
+for each row mode DB2SQL <BR CLEAR="LEFT">
+insert into FLIGHTS_HISTORY values ( <BR CLEAR="LEFT">
+UPDATEDROW.FLIGHT_ID, <BR CLEAR="LEFT">
+UPDATEDROW.SEGMENT_NUMBER, <BR CLEAR="LEFT">
+UPDATEDROW.ORIG_AIRPORT, <BR CLEAR="LEFT">
+UPDATEDROW.DEPART_TIME, <BR CLEAR="LEFT">
+UPDATEDROW.DEST_AIRPORT, <BR CLEAR="LEFT">
+UPDATEDROW.ARRIVE_TIME, <BR CLEAR="LEFT">
+UPDATEDROW.MEAL, <BR CLEAR="LEFT">
+UPDATEDROW.FLYING_TIME, <BR CLEAR="LEFT">
+UPDATEDROW.MILES, <BR CLEAR="LEFT">
+UPDATEDROW.AIRCRAFT, <BR CLEAR="LEFT">
+'INSERTED FROM TRIG1'); </UL></UL>
+
+
+<UL>TRIG2 <BR CLEAR="LEFT">
+</UL>
+
+
+<UL><UL>after delete on FLIGHTS <BR CLEAR="LEFT">
+for each statement mode DB2SQL <BR CLEAR="LEFT">
+insert into FLIGHTS_HISTORY (STATUS) values ('INSERTED FROM TRIG2'); 
+
+</BODY>
+
+</HTML>

Propchange: db/derby/code/trunk/java/demo/toursdb/toursdb_readme.html
------------------------------------------------------------------------------
    svn:eol-style = native



Mime
View raw message