Parent Directory | Revision Log | Patch
--- incubator/jdo/trunk/tck20/test/sql/derby/schema2.sql 2005/04/21 20:34:10 164116 +++ incubator/jdo/trunk/tck20/test/sql/derby/schema2.sql 2005/04/21 20:42:43 164117 @@ -146,6 +146,66 @@ ALTER TABLE departments ( --inheritance ------------------------- +CREATE TABLE AllPersist ( + KEY_VALUE INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY, + DOUBLE_B DOUBLE, + INT_B INTEGER, + FLOAT_E FLOAT, + SHORT_F SMALLINT, + SECOND_OBJ INTEGER, + THIRD_OBJ INTEGER, + INT_H INTEGER, + DISCRIMINATOR varchar(64) NOT NULL, + 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 GENERATED ALWAYS AS IDENTITY, + DOUBLE_B DOUBLE, + INT_B INTEGER, + FLOAT_E FLOAT, + SHORT_F SMALLINT, + SECOND_OBJ INTEGER, + THIRD_OBJ INTEGER, + INT_H INTEGER, + DISCRIMINATOR varchar(64) NOT NULL, + 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 GENERATED ALWAYS AS IDENTITY, + DOUBLE_B DOUBLE, + INT_B INTEGER, + FLOAT_E FLOAT, + SHORT_F SMALLINT, + SECOND_OBJ INTEGER, + THIRD_OBJ INTEGER, + INT_H INTEGER, + DISCRIMINATOR varchar(64) NOT NULL, + 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 GENERATED ALWAYS AS IDENTITY, + N2 DOUBLE, + N3 INTEGER, + FSN2_N3 FLOAT, + FSN3_N1 SMALLINT, + FSN3_N2 INTEGER, + FSN3_N3 INTEGER, + FSN4_N3 INTEGER, + DISCRIMINATOR varchar(64) NOT NULL, + CONSTRAINT FieldSameName_PK PRIMARY KEY (KEY_VALUE), + FOREIGN KEY (FSN3_N2) REFERENCES FieldSameName (KEY_VALUE), + FOREIGN KEY (FSN3_N3) REFERENCES FieldSameName (KEY_VALUE) +); + ------------------------- --instancecallbacks -------------------------
infrastructure at apache.org | ViewVC Help |
Powered by ViewVC 1.1.26 |