db-ojb-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From t...@apache.org
Subject cvs commit: db-ojb/src/test/org/apache/ojb/quick-db OJB.properties OJB.script
Date Mon, 23 Feb 2004 12:12:09 GMT
thma        2004/02/23 04:12:09

  Modified:    src/test/org/apache/ojb/quick-db OJB.properties OJB.script
  Log:
  update testbed
  
  Revision  Changes    Path
  1.30      +1 -1      db-ojb/src/test/org/apache/ojb/quick-db/OJB.properties
  
  Index: OJB.properties
  ===================================================================
  RCS file: /home/cvs/db-ojb/src/test/org/apache/ojb/quick-db/OJB.properties,v
  retrieving revision 1.29
  retrieving revision 1.30
  diff -u -r1.29 -r1.30
  --- OJB.properties	8 Jan 2004 14:48:50 -0000	1.29
  +++ OJB.properties	23 Feb 2004 12:12:09 -0000	1.30
  @@ -1,5 +1,5 @@
   #HSQL database
  -#Thu Jan 08 13:41:09 CET 2004
  +#Mon Feb 23 11:22:14 CET 2004
   sql.strict_fk=true
   readonly=false
   sql.strong_fk=true
  
  
  
  1.30      +14 -2     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.29
  retrieving revision 1.30
  diff -u -r1.29 -r1.30
  --- OJB.script	13 Dec 2003 12:11:27 -0000	1.29
  +++ OJB.script	23 Feb 2004 12:12:09 -0000	1.30
  @@ -79,11 +79,19 @@
   CREATE TABLE FIELD_CONVERSION_NODE(NODE_ID DECIMAL(15) NOT NULL,NODE_STATE INTEGER NOT
NULL,PARENT_UID DECIMAL(15),CONSTRAINT SYS_PK_FIELD_CONVERSION_NODE PRIMARY KEY(NODE_ID,NODE_STATE))
   CREATE TABLE CONVERSION_VO(PK_WITH_AUTO INTEGER NOT NULL,PK_WITHOUT_AUTO INTEGER NOT NULL,NORMAL_WITH_AUTO
INTEGER,NORMAL_WITHOUT_AUTO INTEGER,CONSTRAINT SYS_PK_CONVERSION_VO PRIMARY KEY(PK_WITH_AUTO,PK_WITHOUT_AUTO))
   CREATE TABLE PERF_ARTICLE(ARTICLE_ID INTEGER NOT NULL PRIMARY KEY,ARTICLE_NAME VARCHAR(150),MINIMUM_STOCK
INTEGER,PRICE DOUBLE,UNIT VARCHAR(20),STOCK INTEGER,SUPPLIER_ID INTEGER,PRODUCT_GROUP_ID INTEGER)
  +CREATE TABLE BATCH_MAIN_OBJ(OBJ_ID BIGINT NOT NULL PRIMARY KEY,NAME VARCHAR(100))
  +CREATE TABLE BATCH_SUB_OBJ(OBJ_ID BIGINT NOT NULL PRIMARY KEY,FK_MAIN_ID BIGINT,NAME VARCHAR(100),CONSTRAINT
BATCH_SUB_OBJ_FK_1 FOREIGN KEY(FK_MAIN_ID) REFERENCES BATCH_MAIN_OBJ(OBJ_ID))
   CREATE TABLE CACHE_TEST(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100))
   CREATE TABLE REF_REPOSITORY(REP_ID INTEGER NOT NULL PRIMARY KEY,REF_FK INTEGER,REFA_FK
INTEGER,REFB_FK INTEGER,ANIMAL_FK INTEGER,NAME VARCHAR(100))
   CREATE TABLE REF_REPOSITORY_FK(REP_ID INTEGER NOT NULL,REF_FK INTEGER NOT NULL,REFA_FK
INTEGER NOT NULL,REFB_FK INTEGER NOT NULL,NAME VARCHAR(100),CONSTRAINT SYS_PK_REF_REPOSITORY_FK
PRIMARY KEY(REP_ID,REF_FK,REFA_FK,REFB_FK))
   CREATE TABLE REF_REFERENCE(REF_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100),OJB_CONCRETE_CLASS
VARCHAR(100),REF_NAME_A VARCHAR(100),REF_NAME_B VARCHAR(100))
   CREATE TABLE REF_ANIMAL(A_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100),CLASS_NAME
VARCHAR(100),LENGTH_ DOUBLE)
  +CREATE TABLE REF_WINE(OBJ_ID VARCHAR(100) NOT NULL PRIMARY KEY,REGION_NAME VARCHAR(100),REGION_COUNTRY
VARCHAR(100),VINTAGE VARCHAR(100),GRAPE VARCHAR(100))
  +CREATE TABLE REF_REGION(NAME VARCHAR(100) NOT NULL,COUNTRY VARCHAR(100) NOT NULL,DESCRIPTION
VARCHAR(100),CONSTRAINT SYS_PK_REF_REGION PRIMARY KEY(NAME,COUNTRY))
  +CREATE TABLE READTEST_ACCOUNT(OJB_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100),FK_REF
INTEGER)
  +CREATE TABLE READTEST_BUYER(OJB_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100),FK_REF
INTEGER)
  +CREATE TABLE READTEST_ADDRESS(OJB_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100),FK_REF
INTEGER)
  +CREATE TABLE READTEST_ADDRESS_TYPE(OJB_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100),FK_REF
INTEGER)
   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))
  @@ -108,6 +116,7 @@
   CREATE TABLE NESTED_FIELDS_ENTRY(OBJ_ID INTEGER NOT NULL PRIMARY KEY,FK_ID DECIMAL,NAME
VARCHAR(150))
   CREATE TABLE TAB_COMPONENT(PK_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),PARENT_ID
INTEGER,CHILD_ID INTEGER,GROUP_ID INTEGER)
   CREATE TABLE TAB_GROUP(PK_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150))
  +CREATE TABLE MULTIPLE_OBJECT(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150))
   CREATE TABLE LOCK_MULTI(OJB_ID INTEGER NOT NULL PRIMARY KEY,VERSION INTEGER,REF_ID INTEGER,NAME
VARCHAR(250))
   CREATE TABLE LOCK_MULTI_REF(OJB_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250),VERSION
INTEGER)
   CREATE TABLE CRT_EMPLOYEE(EMPLOYEE_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150))
  @@ -118,7 +127,7 @@
   CREATE TABLE OTM_PERSON(ID INTEGER NOT NULL PRIMARY KEY,FIRSTNAME VARCHAR(60),LASTNAME
VARCHAR(60),MAIN_ADDRESS_ID INTEGER)
   CREATE TABLE OTM_ADDRESS(ID INTEGER NOT NULL PRIMARY KEY,COUNTRY VARCHAR(60),CITY VARCHAR(60),STREET
VARCHAR(60))
   CREATE TABLE OTM_ADDRESS_DESC(ID INTEGER NOT NULL PRIMARY KEY,DESCRIPTION VARCHAR(60),PERSON_ID
INTEGER,ADDRESS_ID INTEGER)
  -CREATE TABLE OJB_HL_SEQ(TABLENAME VARCHAR(175) NOT NULL,FIELDNAME VARCHAR(70) NOT NULL,MAX_KEY
INTEGER,GRAB_SIZE INTEGER,VERSION INTEGER,CONSTRAINT SYS_PK_OJB_HL_SEQ PRIMARY KEY(TABLENAME,FIELDNAME))
  +CREATE TABLE OJB_HL_SEQ(TABLENAME VARCHAR(175) NOT NULL,FIELDNAME VARCHAR(70) NOT NULL,MAX_KEY
BIGINT,GRAB_SIZE INTEGER,VERSION INTEGER,CONSTRAINT SYS_PK_OJB_HL_SEQ PRIMARY KEY(TABLENAME,FIELDNAME))
   CREATE TABLE OJB_LOCKENTRY(OID_ VARCHAR(250) NOT NULL,TX_ID VARCHAR(50) NOT NULL,TIMESTAMP_
TIMESTAMP,ISOLATIONLEVEL INTEGER,LOCKTYPE INTEGER,CONSTRAINT SYS_PK_OJB_LOCKENTRY PRIMARY
KEY(OID_,TX_ID))
   CREATE TABLE OJB_NRM(NAME VARCHAR(250) NOT NULL PRIMARY KEY,OID_ LONGVARBINARY)
   CREATE TABLE OJB_DLIST(ID INTEGER NOT NULL PRIMARY KEY,SIZE_ INTEGER)
  @@ -129,6 +138,9 @@
   CREATE TABLE OJB_DMAP_ENTRIES(ID INTEGER NOT NULL PRIMARY KEY,DMAP_ID INTEGER,KEY_OID BINARY,VALUE_OID
BINARY)
   ALTER TABLE TABLE_1 ADD CONSTRAINT TABLE_1_FK_1 FOREIGN KEY(FK_TO_RELATED) REFERENCES TABLE_2(PK)
   ALTER TABLE BIDIR_A ADD CONSTRAINT BIDIR_A_FK_1 FOREIGN KEY(FK_TO_B) REFERENCES BIDIR_B(PK)
  +ALTER TABLE MAMMAL ADD CONSTRAINT MAMMAL_FK_1 FOREIGN KEY(ZOOID) REFERENCES ZOO(ZOOID)
  +ALTER TABLE REPTILE ADD CONSTRAINT REPTILE_FK_1 FOREIGN KEY(ZOOID) REFERENCES ZOO(ZOOID)
  +ALTER TABLE REF_WINE ADD CONSTRAINT REF_WINE_FK_1 FOREIGN KEY(REGION_NAME,REGION_COUNTRY)
REFERENCES REF_REGION(NAME,COUNTRY)
   GRANT ALL ON CLASS "java.lang.Math" TO PUBLIC
   GRANT ALL ON CLASS "org.hsqldb.Library" TO PUBLIC
   CREATE USER SA PASSWORD "" ADMIN
  @@ -302,7 +314,7 @@
   INSERT INTO PERSON VALUES(7,'eugen','eugen')
   INSERT INTO PERSON VALUES(8,'frido','frido')
   INSERT INTO PERSON VALUES(9,'guido','guido')
  -INSERT INTO PERSON VALUES(10,'hank','hank')
  +INSERT INTO PERSON VALUES(10,'hank%','hank')
   INSERT INTO PROJECT VALUES(1,'OJB','OJB')
   INSERT INTO PROJECT VALUES(2,'SODA','SODA')
   INSERT INTO PROJECT VALUES(3,'HSQLDB','HSQLDB')
  
  
  

---------------------------------------------------------------------
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