Diff of /incubator/jdo/trunk/tck20/test/sql/derby/schema1.sql

Parent Directory | Revision Log | Patch

--- incubator/jdo/trunk/tck20/test/sql/derby/schema1.sql	2005/04/21 16:26:57	164081
+++ incubator/jdo/trunk/tck20/test/sql/derby/schema1.sql	2005/04/21 16:41:09	164082
@@ -55,32 +55,24 @@ CREATE TABLE PrimitiveTypes (
 -------------------------
 -- company
 -------------------------
---CREATE TABLE addresses (
---    ADDRID INTEGER NOT NULL,
---    STREET VARCHAR(64) NOT NULL,
---    CITY VARCHAR(64) NOT NULL,
---    STATE CHAR(2) NOT NULL,
---    ZIPCODE CHAR(5) NOT NULL,
---    COUNTRY VARCHAR(64) NOT NULL,
---    CONSTRAINT ADDR_PK PRIMARY KEY (ID)
---);
 
 CREATE TABLE companies (
     ID INTEGER NOT NULL,
     NAME VARCHAR(32) NOT NULL,
     FOUNDEDDATE VARCHAR(32) NOT NULL,
-    STREET VARCHAR(64) NOT NULL,
-    CITY VARCHAR(64) NOT NULL,
-    STATE CHAR(2) NOT NULL,
-    ZIPCODE CHAR(5) NOT NULL,
-    COUNTRY VARCHAR(64) NOT NULL,
+    STREET VARCHAR(64),
+    CITY VARCHAR(64),
+    STATE CHAR(2),
+    ZIPCODE CHAR(5),
+    COUNTRY VARCHAR(64),
     CONSTRAINT COMPS_PK PRIMARY KEY (ID)
 );
 
 CREATE TABLE departments (
     ID INTEGER NOT NULL,
     NAME VARCHAR(32) NOT NULL,
-    COMPANYID INTEGER REFERENCES COMPANIES NOT NULL,
+    EMP_OF_THE_MONTH INTEGER,
+    COMPANYID INTEGER REFERENCES companies,
     CONSTRAINT DEPTS_PK PRIMARY KEY (ID)
 );
 
@@ -90,11 +82,11 @@ CREATE TABLE persons (
     LASTNAME VARCHAR(32) NOT NULL,
     MIDDLENAME VARCHAR(32),
     BIRTHDATE VARCHAR(32) NOT NULL,
-    STREET VARCHAR(64) NOT NULL,
-    CITY VARCHAR(64) NOT NULL,
-    STATE CHAR(2) NOT NULL,
-    ZIPCODE CHAR(5) NOT NULL,
-    COUNTRY VARCHAR(64) NOT NULL,
+    STREET VARCHAR(64),
+    CITY VARCHAR(64),
+    STATE CHAR(2),
+    ZIPCODE CHAR(5),
+    COUNTRY VARCHAR(64),
     HIREDATE VARCHAR(32) NOT NULL,
     WEEKLYHOURS FLOAT NOT NULL,
     DEPARTMENT INTEGER REFERENCES departments NOT NULL,
@@ -141,6 +133,11 @@ CREATE TABLE employee_phoneno_type (
     TYPE VARCHAR(16) NOT NULL
 );
 
+ALTER TABLE departments (
+    ADD CONSTRAINT EMP_MO_FK FOREIGN KEY
+        (EMP_OF_THE_MONTH) REFERENCES persons(PERSONID)
+);
+
 -------------------------
 --fieldtypes
 -------------------------
@@ -149,6 +146,61 @@ CREATE TABLE employee_phoneno_type (
 --inheritance
 -------------------------
 
+CREATE TABLE AllPersist (
+    KEY_VALUE INTEGER NOT NULL,
+    DOUBLE_B DOUBLE,
+    FLOAT_E FLOAT,
+    SHORT_F SMALLINT,
+    SECOND_OBJ INTEGER,
+    THIRD_OBJ INTEGER,
+    INT_H INTEGER,
+    CONSTRAINT AllPersist_PK PRIMARY KEY (KEY_VALUE),
+    FOREIGN KEY (SECOND_OBJ) REFERENCES AllPersist (KEY_VALUE),
+    FOREIGN KEY (THIRD_OBJ) REFERENCES AllPersist (KEY_VALUE)
+);
+
+CREATE TABLE TopNonPersistB (
+    KEY_VALUE INTEGER NOT NULL,
+    DOUBLE_B DOUBLE,
+    INT_B INTEGER,
+    FLOAT_E FLOAT,
+    SHORT_F SMALLINT,
+    SECOND_OBJ INTEGER,
+    THIRD_OBJ INTEGER,
+    INT_H INTEGER,
+    CONSTRAINT TopNonPersistB_PK PRIMARY KEY (KEY_VALUE),
+    FOREIGN KEY (SECOND_OBJ) REFERENCES TopNonPersistB (KEY_VALUE),
+    FOREIGN KEY (THIRD_OBJ) REFERENCES TopNonPersistB (KEY_VALUE)
+);
+
+CREATE TABLE TopPersist (
+    KEY_VALUE INTEGER NOT NULL,
+    DOUBLE_B DOUBLE,
+    INT_B INTEGER,
+    FLOAT_E FLOAT,
+    SHORT_F SMALLINT,
+    SECOND_OBJ INTEGER,
+    THIRD_OBJ INTEGER,
+    INT_H INTEGER,
+    CONSTRAINT TopPersist_PK PRIMARY KEY (KEY_VALUE),
+    FOREIGN KEY (SECOND_OBJ) REFERENCES TopPersist (KEY_VALUE),
+    FOREIGN KEY (THIRD_OBJ) REFERENCES TopPersist (KEY_VALUE)
+);
+
+CREATE TABLE FieldSameName (
+    KEY_VALUE INTEGER NOT NULL,
+    N2 DOUBLE,
+    N3 INTEGER,
+    FSN2_N3 FLOAT,
+    FSN3_N1 SMALLINT,
+    FSN3_N2 INTEGER,
+    FSN3_N3 INTEGER,
+    FSN4_N3 INTEGER,
+    CONSTRAINT FieldSameName_PK PRIMARY KEY (KEY_VALUE),
+    FOREIGN KEY (FSN3_N2) REFERENCES FieldSameName (KEY_VALUE),
+    FOREIGN KEY (FSN3_N3) REFERENCES FieldSameName (KEY_VALUE)
+);
+
 -------------------------
 --instancecallbacks
 -------------------------