You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-dev@db.apache.org by ar...@apache.org on 2004/06/27 01:47:27 UTC
cvs commit: db-ojb/src/test/org/apache/ojb/quick-db OJB.script
arminw 2004/06/26 16:47:27
Modified: src/test/org/apache/ojb/quick-db OJB.script
Log:
update quick-db
Revision Changes Path
1.33 +3 -1 db-ojb/src/test/org/apache/ojb/quick-db/OJB.script
Index: OJB.script
===================================================================
RCS file: /home/cvs/db-ojb/src/test/org/apache/ojb/quick-db/OJB.script,v
retrieving revision 1.32
retrieving revision 1.33
diff -u -r1.32 -r1.33
--- OJB.script 14 Jun 2004 12:27:15 -0000 1.32
+++ OJB.script 26 Jun 2004 23:47:26 -0000 1.33
@@ -104,13 +104,15 @@
CREATE TABLE M2N_TEST_ACTOR(OBJ_ID INTEGER NOT NULL,OBJ_ID2 INTEGER NOT NULL,NAME VARCHAR(150),CONSTRAINT SYS_PK_M2N_TEST_ACTOR PRIMARY KEY(OBJ_ID,OBJ_ID2))
CREATE TABLE M2N_TEST_MOVIE(OBJ_ID_INT INTEGER NOT NULL,OBJ_ID2_INT INTEGER NOT NULL,OBJ_ID_STR VARCHAR(150) NOT NULL,TITLE VARCHAR(150),DESCRIPTION VARCHAR(250),CONSTRAINT SYS_PK_M2N_TEST_MOVIE PRIMARY KEY(OBJ_ID_INT,OBJ_ID2_INT,OBJ_ID_STR))
CREATE TABLE M2N_TEST_ROLE(ACTOR_ID INTEGER NOT NULL,ACTOR_ID2 INTEGER NOT NULL,MOVIE_ID_INT INTEGER NOT NULL,MOVIE_ID2_INT INTEGER NOT NULL,MOVIE_ID_STR VARCHAR(150) NOT NULL,CONSTRAINT SYS_PK_M2N_TEST_ROLE PRIMARY KEY(ACTOR_ID,ACTOR_ID2,MOVIE_ID_INT,MOVIE_ID2_INT,MOVIE_ID_STR),CONSTRAINT M2N_TEST_ROLE_FK_1 FOREIGN KEY(ACTOR_ID,ACTOR_ID2) REFERENCES M2N_TEST_ACTOR(OBJ_ID,OBJ_ID2),CONSTRAINT M2N_TEST_ROLE_FK_2 FOREIGN KEY(MOVIE_ID_INT,MOVIE_ID2_INT,MOVIE_ID_STR) REFERENCES M2N_TEST_MOVIE(OBJ_ID_INT,OBJ_ID2_INT,OBJ_ID_STR))
+CREATE TABLE M2N_NODE(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150))
+CREATE TABLE M2N_KINDSHIP(PARENT_ID INTEGER NOT NULL,CHILD_ID INTEGER NOT NULL,CONSTRAINT SYS_PK_M2N_KINDSHIP PRIMARY KEY(PARENT_ID,CHILD_ID))
CREATE TABLE COLLECTION_GATHERER(GAT_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150))
CREATE TABLE COLLECTION_COLLECTIBLE_A(COL_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),GAT_ID INTEGER,CONSTRAINT COLLECTION_COLLECTIBLE_A_FK_1 FOREIGN KEY(GAT_ID) REFERENCES COLLECTION_GATHERER(GAT_ID))
CREATE TABLE COLLECTION_COLLECTIBLE_BASE(COL_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),GAT_ID INTEGER,CONSTRAINT COLLECTION_COLLECTIBLE_BASE_FK_1 FOREIGN KEY(GAT_ID) REFERENCES COLLECTION_GATHERER(GAT_ID))
CREATE TABLE COLLECTION_COLLECTIBLE_B(COL_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),GAT_ID INTEGER,CONSTRAINT COLLECTION_COLLECTIBLE_B_FK_1 FOREIGN KEY(GAT_ID) REFERENCES COLLECTION_GATHERER(GAT_ID))
CREATE TABLE COLLECTION_COLLECTIBLE_C(COL_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),GAT_ID INTEGER,EXTENT_NAME VARCHAR(150),CONSTRAINT COLLECTION_COLLECTIBLE_C_FK_1 FOREIGN KEY(GAT_ID) REFERENCES COLLECTION_GATHERER(GAT_ID))
CREATE TABLE COLLECTION_COLLECTIBLE_CC(COL_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),GAT_ID INTEGER,EXTENT_NAME VARCHAR(150),CONSTRAINT COLLECTION_COLLECTIBLE_CC_FK_1 FOREIGN KEY(GAT_ID) REFERENCES COLLECTION_GATHERER(GAT_ID))
-CREATE TABLE COLLECTION_COLLECTIBLE_CCC(COL_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),GAT_ID INTEGER,EXTENT_NAME VARCHAR(150),CONSTRAINT COLLECTION_COLLECTIBLE_CCC_FK_1 FOREIGN KEY(GAT_ID) REFERENCES COLLECTION_GATHERER(GAT_ID))
+CREATE TABLE COLLECTION_COLLECTIBLE_C2(COL_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),GAT_ID INTEGER,EXTENT_NAME VARCHAR(150),CONSTRAINT COLLECTION_COLLECTIBLE_C2_FK_1 FOREIGN KEY(GAT_ID) REFERENCES COLLECTION_GATHERER(GAT_ID))
CREATE TABLE COLLECTION_COLLECTIBLE_D(COL_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),OJB_CONCRETE_CLASS VARCHAR(150),GAT_ID INTEGER,CONSTRAINT COLLECTION_COLLECTIBLE_D_FK_1 FOREIGN KEY(GAT_ID) REFERENCES COLLECTION_GATHERER(GAT_ID))
CREATE TABLE COLLECTION_2_PROJECT(PRO_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150))
CREATE TABLE COLLECTION_2_SUB_PROJECT(SUB_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),FK_PRO_ID INTEGER,CONSTRAINT COLLECTION_2_SUB_PROJECT_FK_1 FOREIGN KEY(FK_PRO_ID) REFERENCES COLLECTION_2_PROJECT(PRO_ID))
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org