db-jdo-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From c..@apache.org
Subject svn commit: r562540 - in /db/jdo/trunk/tck2/src: sql/derby/applicationidentity/ sql/derby/datastoreidentity/ testdata/org/apache/jdo/tck/pc/company/
Date Fri, 03 Aug 2007 18:26:43 GMT
Author: clr
Date: Fri Aug  3 11:26:42 2007
New Revision: 562540

URL: http://svn.apache.org/viewvc?view=rev&rev=562540
Log:
Added Employee Of The Month to testdata

Modified:
    db/jdo/trunk/tck2/src/sql/derby/applicationidentity/schema.sql
    db/jdo/trunk/tck2/src/sql/derby/applicationidentity/schema1.sql
    db/jdo/trunk/tck2/src/sql/derby/applicationidentity/schema10.sql
    db/jdo/trunk/tck2/src/sql/derby/applicationidentity/schema2.sql
    db/jdo/trunk/tck2/src/sql/derby/applicationidentity/schema3.sql
    db/jdo/trunk/tck2/src/sql/derby/applicationidentity/schema4.sql
    db/jdo/trunk/tck2/src/sql/derby/applicationidentity/schema9.sql
    db/jdo/trunk/tck2/src/sql/derby/datastoreidentity/schema.sql
    db/jdo/trunk/tck2/src/sql/derby/datastoreidentity/schema1.sql
    db/jdo/trunk/tck2/src/sql/derby/datastoreidentity/schema10.sql
    db/jdo/trunk/tck2/src/sql/derby/datastoreidentity/schema2.sql
    db/jdo/trunk/tck2/src/sql/derby/datastoreidentity/schema3.sql
    db/jdo/trunk/tck2/src/sql/derby/datastoreidentity/schema4.sql
    db/jdo/trunk/tck2/src/sql/derby/datastoreidentity/schema9.sql
    db/jdo/trunk/tck2/src/testdata/org/apache/jdo/tck/pc/company/companyAllRelationships.xml

Modified: db/jdo/trunk/tck2/src/sql/derby/applicationidentity/schema.sql
URL: http://svn.apache.org/viewvc/db/jdo/trunk/tck2/src/sql/derby/applicationidentity/schema.sql?view=diff&rev=562540&r1=562539&r2=562540
==============================================================================
--- db/jdo/trunk/tck2/src/sql/derby/applicationidentity/schema.sql (original)
+++ db/jdo/trunk/tck2/src/sql/derby/applicationidentity/schema.sql Fri Aug  3 11:26:42 2007
@@ -329,7 +329,7 @@
 
 ALTER TABLE departments 
     ADD CONSTRAINT EMP_MO_FK FOREIGN KEY
-        (EMP_OF_THE_MONTH) REFERENCES persons(PERSONID);
+        (EMP_OF_THE_MONTH) REFERENCES persons(PERSONID) ON DELETE SET NULL;
 
 -------------------------
 --fieldtypes

Modified: db/jdo/trunk/tck2/src/sql/derby/applicationidentity/schema1.sql
URL: http://svn.apache.org/viewvc/db/jdo/trunk/tck2/src/sql/derby/applicationidentity/schema1.sql?view=diff&rev=562540&r1=562539&r2=562540
==============================================================================
--- db/jdo/trunk/tck2/src/sql/derby/applicationidentity/schema1.sql (original)
+++ db/jdo/trunk/tck2/src/sql/derby/applicationidentity/schema1.sql Fri Aug  3 11:26:42 2007
@@ -164,6 +164,6 @@
 
 ALTER TABLE departments 
     ADD CONSTRAINT EMP_MO_FK FOREIGN KEY
-        (EMP_OF_THE_MONTH) REFERENCES persons(PERSONID);
+        (EMP_OF_THE_MONTH) REFERENCES persons(PERSONID) ON DELETE SET NULL;
 
 disconnect;

Modified: db/jdo/trunk/tck2/src/sql/derby/applicationidentity/schema10.sql
URL: http://svn.apache.org/viewvc/db/jdo/trunk/tck2/src/sql/derby/applicationidentity/schema10.sql?view=diff&rev=562540&r1=562539&r2=562540
==============================================================================
--- db/jdo/trunk/tck2/src/sql/derby/applicationidentity/schema10.sql (original)
+++ db/jdo/trunk/tck2/src/sql/derby/applicationidentity/schema10.sql Fri Aug  3 11:26:42 2007
@@ -80,5 +80,5 @@
 
 ALTER TABLE departments 
     ADD CONSTRAINT EMP_MO_FK FOREIGN KEY
-        (EMP_OF_THE_MONTH) REFERENCES persons(PERSONID);
+        (EMP_OF_THE_MONTH) REFERENCES persons(PERSONID) ON DELETE SET NULL;
 

Modified: db/jdo/trunk/tck2/src/sql/derby/applicationidentity/schema2.sql
URL: http://svn.apache.org/viewvc/db/jdo/trunk/tck2/src/sql/derby/applicationidentity/schema2.sql?view=diff&rev=562540&r1=562539&r2=562540
==============================================================================
--- db/jdo/trunk/tck2/src/sql/derby/applicationidentity/schema2.sql (original)
+++ db/jdo/trunk/tck2/src/sql/derby/applicationidentity/schema2.sql Fri Aug  3 11:26:42 2007
@@ -198,6 +198,6 @@
 
 ALTER TABLE departments 
     ADD CONSTRAINT EMP_MO_FK FOREIGN KEY
-        (EMP_OF_THE_MONTH) REFERENCES fulltimeemployees(PERSONID);
+        (EMP_OF_THE_MONTH) REFERENCES fulltimeemployees(PERSONID) ON DELETE SET NULL;
 
 disconnect;

Modified: db/jdo/trunk/tck2/src/sql/derby/applicationidentity/schema3.sql
URL: http://svn.apache.org/viewvc/db/jdo/trunk/tck2/src/sql/derby/applicationidentity/schema3.sql?view=diff&rev=562540&r1=562539&r2=562540
==============================================================================
--- db/jdo/trunk/tck2/src/sql/derby/applicationidentity/schema3.sql (original)
+++ db/jdo/trunk/tck2/src/sql/derby/applicationidentity/schema3.sql Fri Aug  3 11:26:42 2007
@@ -161,6 +161,6 @@
 
 ALTER TABLE departments 
     ADD CONSTRAINT EMP_MO_FK FOREIGN KEY
-        (EMP_OF_THE_MONTH) REFERENCES persons(PERSONID);
+        (EMP_OF_THE_MONTH) REFERENCES persons(PERSONID) ON DELETE SET NULL;
 
 disconnect;

Modified: db/jdo/trunk/tck2/src/sql/derby/applicationidentity/schema4.sql
URL: http://svn.apache.org/viewvc/db/jdo/trunk/tck2/src/sql/derby/applicationidentity/schema4.sql?view=diff&rev=562540&r1=562539&r2=562540
==============================================================================
--- db/jdo/trunk/tck2/src/sql/derby/applicationidentity/schema4.sql (original)
+++ db/jdo/trunk/tck2/src/sql/derby/applicationidentity/schema4.sql Fri Aug  3 11:26:42 2007
@@ -138,6 +138,6 @@
 
 ALTER TABLE departments 
     ADD CONSTRAINT EMP_MO_FK FOREIGN KEY
-        (EMP_OF_THE_MONTH) REFERENCES persons(PERSONID);
+        (EMP_OF_THE_MONTH) REFERENCES persons(PERSONID) ON DELETE SET NULL;
 
 disconnect;

Modified: db/jdo/trunk/tck2/src/sql/derby/applicationidentity/schema9.sql
URL: http://svn.apache.org/viewvc/db/jdo/trunk/tck2/src/sql/derby/applicationidentity/schema9.sql?view=diff&rev=562540&r1=562539&r2=562540
==============================================================================
--- db/jdo/trunk/tck2/src/sql/derby/applicationidentity/schema9.sql (original)
+++ db/jdo/trunk/tck2/src/sql/derby/applicationidentity/schema9.sql Fri Aug  3 11:26:42 2007
@@ -80,5 +80,5 @@
 
 ALTER TABLE departments 
     ADD CONSTRAINT EMP_MO_FK FOREIGN KEY
-        (EMP_OF_THE_MONTH) REFERENCES persons(PERSONID);
+        (EMP_OF_THE_MONTH) REFERENCES persons(PERSONID) ON DELETE SET NULL;
 

Modified: db/jdo/trunk/tck2/src/sql/derby/datastoreidentity/schema.sql
URL: http://svn.apache.org/viewvc/db/jdo/trunk/tck2/src/sql/derby/datastoreidentity/schema.sql?view=diff&rev=562540&r1=562539&r2=562540
==============================================================================
--- db/jdo/trunk/tck2/src/sql/derby/datastoreidentity/schema.sql (original)
+++ db/jdo/trunk/tck2/src/sql/derby/datastoreidentity/schema.sql Fri Aug  3 11:26:42 2007
@@ -271,7 +271,7 @@
 
 ALTER TABLE departments 
     ADD CONSTRAINT EMP_MO_FK FOREIGN KEY
-        (EMP_OF_THE_MONTH) REFERENCES persons;
+        (EMP_OF_THE_MONTH) REFERENCES persons ON DELETE SET NULL;
 
 -------------------------
 --fieldtypes

Modified: db/jdo/trunk/tck2/src/sql/derby/datastoreidentity/schema1.sql
URL: http://svn.apache.org/viewvc/db/jdo/trunk/tck2/src/sql/derby/datastoreidentity/schema1.sql?view=diff&rev=562540&r1=562539&r2=562540
==============================================================================
--- db/jdo/trunk/tck2/src/sql/derby/datastoreidentity/schema1.sql (original)
+++ db/jdo/trunk/tck2/src/sql/derby/datastoreidentity/schema1.sql Fri Aug  3 11:26:42 2007
@@ -200,6 +200,6 @@
 
 ALTER TABLE departments 
     ADD CONSTRAINT EMP_MO_FK FOREIGN KEY
-        (EMP_OF_THE_MONTH) REFERENCES persons(DATASTORE_IDENTITY);
+        (EMP_OF_THE_MONTH) REFERENCES persons(DATASTORE_IDENTITY) ON DELETE SET NULL;
 
 disconnect;

Modified: db/jdo/trunk/tck2/src/sql/derby/datastoreidentity/schema10.sql
URL: http://svn.apache.org/viewvc/db/jdo/trunk/tck2/src/sql/derby/datastoreidentity/schema10.sql?view=diff&rev=562540&r1=562539&r2=562540
==============================================================================
--- db/jdo/trunk/tck2/src/sql/derby/datastoreidentity/schema10.sql (original)
+++ db/jdo/trunk/tck2/src/sql/derby/datastoreidentity/schema10.sql Fri Aug  3 11:26:42 2007
@@ -83,5 +83,5 @@
 
 ALTER TABLE departments 
     ADD CONSTRAINT EMP_MO_FK FOREIGN KEY
-        (EMP_OF_THE_MONTH) REFERENCES persons(DATASTORE_IDENTITY);
+        (EMP_OF_THE_MONTH) REFERENCES persons(DATASTORE_IDENTITY) ON DELETE SET NULL;
 

Modified: db/jdo/trunk/tck2/src/sql/derby/datastoreidentity/schema2.sql
URL: http://svn.apache.org/viewvc/db/jdo/trunk/tck2/src/sql/derby/datastoreidentity/schema2.sql?view=diff&rev=562540&r1=562539&r2=562540
==============================================================================
--- db/jdo/trunk/tck2/src/sql/derby/datastoreidentity/schema2.sql (original)
+++ db/jdo/trunk/tck2/src/sql/derby/datastoreidentity/schema2.sql Fri Aug  3 11:26:42 2007
@@ -250,6 +250,6 @@
 
 ALTER TABLE departments 
     ADD CONSTRAINT EMP_MO_FK FOREIGN KEY
-        (EMP_OF_THE_MONTH) REFERENCES fulltimeemployees;
+        (EMP_OF_THE_MONTH) REFERENCES fulltimeemployees ON DELETE SET NULL;
 
 disconnect;

Modified: db/jdo/trunk/tck2/src/sql/derby/datastoreidentity/schema3.sql
URL: http://svn.apache.org/viewvc/db/jdo/trunk/tck2/src/sql/derby/datastoreidentity/schema3.sql?view=diff&rev=562540&r1=562539&r2=562540
==============================================================================
--- db/jdo/trunk/tck2/src/sql/derby/datastoreidentity/schema3.sql (original)
+++ db/jdo/trunk/tck2/src/sql/derby/datastoreidentity/schema3.sql Fri Aug  3 11:26:42 2007
@@ -207,6 +207,6 @@
 
 ALTER TABLE departments 
     ADD CONSTRAINT EMP_MO_FK FOREIGN KEY
-        (EMP_OF_THE_MONTH) REFERENCES persons;
+        (EMP_OF_THE_MONTH) REFERENCES persons ON DELETE SET NULL;
 
 disconnect;

Modified: db/jdo/trunk/tck2/src/sql/derby/datastoreidentity/schema4.sql
URL: http://svn.apache.org/viewvc/db/jdo/trunk/tck2/src/sql/derby/datastoreidentity/schema4.sql?view=diff&rev=562540&r1=562539&r2=562540
==============================================================================
--- db/jdo/trunk/tck2/src/sql/derby/datastoreidentity/schema4.sql (original)
+++ db/jdo/trunk/tck2/src/sql/derby/datastoreidentity/schema4.sql Fri Aug  3 11:26:42 2007
@@ -170,6 +170,6 @@
 
 ALTER TABLE departments 
     ADD CONSTRAINT EMP_MO_FK FOREIGN KEY
-        (EMP_OF_THE_MONTH) REFERENCES persons;
+        (EMP_OF_THE_MONTH) REFERENCES persons ON DELETE SET NULL;
 
 disconnect;

Modified: db/jdo/trunk/tck2/src/sql/derby/datastoreidentity/schema9.sql
URL: http://svn.apache.org/viewvc/db/jdo/trunk/tck2/src/sql/derby/datastoreidentity/schema9.sql?view=diff&rev=562540&r1=562539&r2=562540
==============================================================================
--- db/jdo/trunk/tck2/src/sql/derby/datastoreidentity/schema9.sql (original)
+++ db/jdo/trunk/tck2/src/sql/derby/datastoreidentity/schema9.sql Fri Aug  3 11:26:42 2007
@@ -84,5 +84,5 @@
 
 ALTER TABLE departments 
     ADD CONSTRAINT EMP_MO_FK FOREIGN KEY
-        (EMP_OF_THE_MONTH) REFERENCES persons(PERSONID);
+        (EMP_OF_THE_MONTH) REFERENCES persons(PERSONID) ON DELETE SET NULL;
 

Modified: db/jdo/trunk/tck2/src/testdata/org/apache/jdo/tck/pc/company/companyAllRelationships.xml
URL: http://svn.apache.org/viewvc/db/jdo/trunk/tck2/src/testdata/org/apache/jdo/tck/pc/company/companyAllRelationships.xml?view=diff&rev=562540&r1=562539&r2=562540
==============================================================================
--- db/jdo/trunk/tck2/src/testdata/org/apache/jdo/tck/pc/company/companyAllRelationships.xml
(original)
+++ db/jdo/trunk/tck2/src/testdata/org/apache/jdo/tck/pc/company/companyAllRelationships.xml
Fri Aug  3 11:26:42 2007
@@ -45,6 +45,7 @@
         <constructor-arg index="0" type="long"><value>1</value></constructor-arg>
         <constructor-arg index="1" type="java.lang.String" ><value>Development</value></constructor-arg>
         <property name="company"><ref bean="company1"/></property>
+        <property name="employeeOfTheMonth"><ref bean="emp1"/></property>
         <property name="employees">
             <set>
                 <ref local="emp1"/>



Mime
View raw message