db-jdo-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From mcai...@apache.org
Subject svn commit: r441681 - /db/jdo/trunk/tck20/src/sql/derby/datastoreidentity/schema9.sql
Date Fri, 08 Sep 2006 22:57:15 GMT
Author: mcaisse
Date: Fri Sep  8 15:57:14 2006
New Revision: 441681

URL: http://svn.apache.org/viewvc?view=rev&rev=441681
Log:
JDO-193 Added missing unique constraint to allow fk constraint.

Modified:
    db/jdo/trunk/tck20/src/sql/derby/datastoreidentity/schema9.sql

Modified: db/jdo/trunk/tck20/src/sql/derby/datastoreidentity/schema9.sql
URL: http://svn.apache.org/viewvc/db/jdo/trunk/tck20/src/sql/derby/datastoreidentity/schema9.sql?view=diff&rev=441681&r1=441680&r2=441681
==============================================================================
--- db/jdo/trunk/tck20/src/sql/derby/datastoreidentity/schema9.sql (original)
+++ db/jdo/trunk/tck20/src/sql/derby/datastoreidentity/schema9.sql Fri Sep  8 15:57:14 2006
@@ -63,6 +63,7 @@
     CONSTRAINT PERS_MANAGER_FK FOREIGN KEY (MANAGER) REFERENCES persons,
     CONSTRAINT PERS_MENTOR_FK FOREIGN KEY (MENTOR) REFERENCES persons,
     CONSTRAINT PERS_HRADVISOR_FK FOREIGN KEY (HRADVISOR) REFERENCES persons,
+    CONSTRAINT PERS_UK UNIQUE (PERSONID),
     CONSTRAINT PERS_PK PRIMARY KEY (DATASTORE_IDENTITY)
 );
 



Mime
View raw message