db-jdo-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From mcai...@apache.org
Subject svn commit: r225174 - in /incubator/jdo/trunk/tck20/test/sql/derby: applicationidentity/schema.sql datastoreidentity/schema.sql
Date Mon, 25 Jul 2005 20:30:27 GMT
Author: mcaisse
Date: Mon Jul 25 13:30:19 2005
New Revision: 225174

URL: http://svn.apache.org/viewcvs?rev=225174&view=rev
Log:
typos on DDL

Modified:
    incubator/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema.sql
    incubator/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema.sql

Modified: incubator/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema.sql
URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema.sql?rev=225174&r1=225173&r2=225174&view=diff
==============================================================================
--- incubator/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema.sql (original)
+++ incubator/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema.sql Mon Jul 25 13:30:19
2005
@@ -119,7 +119,7 @@
     ID DATE NOT NULL,
     X INTEGER NOT NULL,
     Y INTEGER,
-    CONSTRAINT PCPNT_SFSTR_PK PRIMARY KEY (ID)
+    CONSTRAINT PCPNT_SFD_PK PRIMARY KEY (ID)
 );
 
 -------------------------
@@ -127,8 +127,8 @@
 -------------------------
 
 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_REV_FK FOREIGN KEY;
+ALTER TABLE project_reviewer DROP CONSTRAINT PR_PROJ_FK;
+ALTER TABLE project_reviewer DROP CONSTRAINT PR_REV_FK;
 DROP TABLE insuranceplans;
 DROP TABLE project_reviewer;
 DROP TABLE project_member;
@@ -219,15 +219,15 @@
 
 ALTER TABLE project_reviewer 
     ADD CONSTRAINT PR_PROJ_FK FOREIGN KEY
-        (PROJID) REFERENCES projects(PROJID)
+        (PROJID) REFERENCES projects(PROJID);
+
+ALTER TABLE project_reviewer 
     ADD CONSTRAINT PR_REV_FK FOREIGN KEY
-        (REVIEWER) REFERENCES persons(PERSONID)
-;
+        (REVIEWER) REFERENCES persons(PERSONID);
 
 ALTER TABLE departments 
     ADD CONSTRAINT EMP_MO_FK FOREIGN KEY
-        (EMP_OF_THE_MONTH) REFERENCES persons(PERSONID)
-;
+        (EMP_OF_THE_MONTH) REFERENCES persons(PERSONID);
 
 -------------------------
 --fieldtypes

Modified: incubator/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema.sql
URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema.sql?rev=225174&r1=225173&r2=225174&view=diff
==============================================================================
--- incubator/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema.sql (original)
+++ incubator/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema.sql Mon Jul 25 13:30:19
2005
@@ -70,8 +70,8 @@
 -------------------------
 
 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;
+ALTER TABLE project_reviewer DROP CONSTRAINT PR_PROJ_FK;
+ALTER TABLE project_reviewer DROP CONSTRAINT PR_REV_FK;
 DROP TABLE insuranceplans;
 DROP TABLE project_reviewer;
 DROP TABLE project_member;
@@ -106,7 +106,7 @@
 
 CREATE TABLE persons (
     DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
-    PERSONID INTEGER,
+    PERSONID INTEGER UNIQUE NOT NULL,
     FIRSTNAME VARCHAR(32) NOT NULL,
     LASTNAME VARCHAR(32) NOT NULL,
     MIDDLENAME VARCHAR(32),
@@ -143,7 +143,7 @@
 
 CREATE TABLE projects (
     DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
-    PROJID INTEGER,
+    PROJID INTEGER UNIQUE NOT NULL,
     NAME VARCHAR(32) NOT NULL,
     BUDGET DECIMAL(11,2) NOT NULL,
     CONSTRAINT PROJS_PK PRIMARY KEY (DATASTORE_IDENTITY)
@@ -167,15 +167,15 @@
 
 ALTER TABLE project_reviewer 
     ADD CONSTRAINT PR_PROJ_FK FOREIGN KEY
-        (PROJID) REFERENCES projects(PROJID)
+        (PROJID) REFERENCES projects(PROJID);
+
+ALTER TABLE project_reviewer 
     ADD CONSTRAINT PR_REV_FK FOREIGN KEY
-        (REVIEWER) REFERENCES persons(PERSONID)
-;
+        (REVIEWER) REFERENCES persons(PERSONID);
 
 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);
 
 -------------------------
 --fieldtypes



Mime
View raw message