Parent Directory | Revision Log | Patch
--- incubator/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema.sql 2005/07/21 23:50:02 220214 +++ incubator/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema.sql 2005/07/21 23:56:25 220215 @@ -70,6 +70,8 @@ CREATE TABLE PrimitiveTypes ( ------------------------- 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; @@ -163,6 +165,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(DATASTORE_IDENTITY)
infrastructure at apache.org | ViewVC Help |
Powered by ViewVC 1.1.26 |