Diff of /incubator/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema.sql

Parent Directory | Revision Log | Patch

--- incubator/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema.sql	2005/07/21 23:50:02	220214
+++ incubator/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema.sql	2005/07/21 23:56:25	220215
@@ -127,6 +127,8 @@ CREATE TABLE PCPointSingleFieldDate (
 -------------------------
 
 ALTER TABLE departments DROP CONSTRAINT EMP_MO_FK;
+ALTER TABLE project_reviewer DROP CONSTRAINT PR_PROJ_FK FOREIGN KEY;
+ALTER TABLE project_reviewer DROP CONSTRAINT PR_MEM_FK FOREIGN KEY;
 DROP TABLE insuranceplans;
 DROP TABLE project_reviewer;
 DROP TABLE project_member;
@@ -205,8 +207,8 @@ CREATE TABLE project_reviewer (
 );
 
 CREATE TABLE project_member (
-    PROJID INTEGER REFERENCES projects NOT NULL,
-    MEMBER INTEGER REFERENCES persons NOT NULL
+    PROJID INTEGER NOT NULL,
+    MEMBER INTEGER NOT NULL
 );
 
 CREATE TABLE employee_phoneno_type (
@@ -215,6 +217,13 @@ CREATE TABLE employee_phoneno_type (
     TYPE VARCHAR(16) NOT NULL
 );
 
+ALTER TABLE project_reviewer 
+    ADD CONSTRAINT PR_PROJ_FK FOREIGN KEY
+        (PROJID) REFERENCES projects(PROJID)
+    ADD CONSTRAINT PR_REV_FK FOREIGN KEY
+        (REVIEWER) REFERENCES persons(PERSONID)
+;
+
 ALTER TABLE departments 
     ADD CONSTRAINT EMP_MO_FK FOREIGN KEY
         (EMP_OF_THE_MONTH) REFERENCES persons(PERSONID)