You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jdo-commits@db.apache.org by mc...@apache.org on 2006/09/09 00:57:15 UTC
svn commit: r441681 -
/db/jdo/trunk/tck20/src/sql/derby/datastoreidentity/schema9.sql
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)
);