db-ojb-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From arm...@apache.org
Subject cvs commit: db-ojb/src/test/org/apache/ojb/quick-db OJB.script
Date Sat, 26 Jun 2004 23:47:27 GMT
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


Mime
View raw message