svn commit: r470142 - in /db/derby/code/trunk/java/testing/org/apache/derbyTesting/system/oe: build.xml schema/index.sql

[dj...@apache.org]

Author: djd
Date: Wed Nov  1 15:55:24 2006
New Revision: 470142

URL: http://svn.apache.org/viewvc?view=rev&rev=470142
Log:
DERBY-1995 Add final base schema script, index.sql for additional indexes required by the test.
Added copy to the build target to copy the scripts to the classes folder.

Added:
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/system/oe/schema/index.sql   (with props)
Modified:
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/system/oe/build.xml

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/system/oe/build.xml
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/system/oe/build.xml?view=diff&rev=470142&r1=470141&r2=470142
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/system/oe/build.xml (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/system/oe/build.xml Wed Nov  1 15:55:24 2006
@@ -53,7 +53,7 @@
 
 <!--             ============ Begin Targets ==============                -->
  
-  <target name="orderentry" 
+  <target name="orderentry"
           description="Build Order Entry system test kit">
     <javac
       source="1.4"
@@ -74,6 +74,10 @@
       </classpath>
       <include name="${derby.testing.system.dir}/oe/**/*.java"/>
     </javac>
+
+	 <copy todir="${out.dir}/${derby.testing.system.dir}/oe/schema">
+	    <fileset dir="${derby.testing.src.dir}/${derby.testing.system.dir}/oe/schema"/>
+	 </copy>
   </target>
 
 <!--             ============= End Targets ==============                -->

Added: db/derby/code/trunk/java/testing/org/apache/derbyTesting/system/oe/schema/index.sql
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/system/oe/schema/index.sql?view=auto&rev=470142
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/system/oe/schema/index.sql (added)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/system/oe/schema/index.sql Wed Nov  1 15:55:24 2006
@@ -0,0 +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.
+;
+
+-- Index to support the order status and payment transactions
+-- that lookup the customer by the last name.
+CREATE INDEX CUSTOMER_LAST_NAME ON CUSTOMER(C_W_ID, C_D_ID, C_LAST);
\ No newline at end of file

Propchange: db/derby/code/trunk/java/testing/org/apache/derbyTesting/system/oe/schema/index.sql
------------------------------------------------------------------------------
    svn:eol-style = native