From jdo-commits-return-1873-apmail-db-jdo-commits-archive=www.apache.org@db.apache.org Fri Aug 03 18:27:04 2007 Return-Path: Delivered-To: apmail-db-jdo-commits-archive@www.apache.org Received: (qmail 14206 invoked from network); 3 Aug 2007 18:27:04 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 3 Aug 2007 18:27:04 -0000 Received: (qmail 63213 invoked by uid 500); 3 Aug 2007 18:27:04 -0000 Mailing-List: contact jdo-commits-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: jdo-dev@db.apache.org Delivered-To: mailing list jdo-commits@db.apache.org Received: (qmail 63202 invoked by uid 99); 3 Aug 2007 18:27:04 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 03 Aug 2007 11:27:04 -0700 X-ASF-Spam-Status: No, hits=-100.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.3] (HELO eris.apache.org) (140.211.11.3) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 03 Aug 2007 18:27:04 +0000 Received: by eris.apache.org (Postfix, from userid 65534) id E62881A981A; Fri, 3 Aug 2007 11:26:43 -0700 (PDT) Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit 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 -0000 To: jdo-commits@db.apache.org From: clr@apache.org X-Mailer: svnmailer-1.1.0 Message-Id: <20070803182643.E62881A981A@eris.apache.org> X-Virus-Checked: Checked by ClamAV on apache.org 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 @@ 1 Development +