Return-Path: Delivered-To: apmail-db-ojb-dev-archive@www.apache.org Received: (qmail 94171 invoked from network); 22 Mar 2004 08:12:11 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12) by minotaur-2.apache.org with SMTP; 22 Mar 2004 08:12:11 -0000 Received: (qmail 44248 invoked by uid 500); 22 Mar 2004 08:11:46 -0000 Delivered-To: apmail-db-ojb-dev-archive@db.apache.org Received: (qmail 44208 invoked by uid 500); 22 Mar 2004 08:11:46 -0000 Mailing-List: contact ojb-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "OJB Developers List" Reply-To: "OJB Developers List" Delivered-To: mailing list ojb-dev@db.apache.org Received: (qmail 44195 invoked by uid 500); 22 Mar 2004 08:11:46 -0000 Received: (qmail 44192 invoked from network); 22 Mar 2004 08:11:46 -0000 Received: from unknown (HELO minotaur.apache.org) (209.237.227.194) by daedalus.apache.org with SMTP; 22 Mar 2004 08:11:46 -0000 Received: (qmail 94147 invoked by uid 1524); 22 Mar 2004 08:12:09 -0000 Date: 22 Mar 2004 08:12:09 -0000 Message-ID: <20040322081209.94146.qmail@minotaur.apache.org> From: thma@apache.org To: db-ojb-cvs@apache.org Subject: cvs commit: db-ojb/src/test/org/apache/ojb/quick-db OJB.properties OJB.script X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N thma 2004/03/22 00:12:09 Modified: src/test/org/apache/ojb/quick-db OJB.properties OJB.script Log: update testbed Revision Changes Path 1.31 +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.30 retrieving revision 1.31 diff -u -r1.30 -r1.31 --- OJB.properties 23 Feb 2004 12:12:09 -0000 1.30 +++ OJB.properties 22 Mar 2004 08:12:09 -0000 1.31 @@ -1,5 +1,5 @@ #HSQL database -#Mon Feb 23 11:22:14 CET 2004 +#Sun Mar 21 12:26:00 CET 2004 sql.strict_fk=true readonly=false sql.strong_fk=true 1.31 +7 -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.30 retrieving revision 1.31 diff -u -r1.30 -r1.31 --- OJB.script 23 Feb 2004 12:12:09 -0000 1.30 +++ OJB.script 22 Mar 2004 08:12:09 -0000 1.31 @@ -74,7 +74,7 @@ CREATE TABLE SM_MT_TEST_A(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100)) CREATE TABLE SM_MT_TEST_B(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100)) CREATE TABLE EJB_CATEGORY(CATEGORY_ID INTEGER NOT NULL PRIMARY KEY,CATEGORY_NAME VARCHAR(80),DESCRIPTION VARCHAR(255)) -CREATE TABLE EJB_ARTICLE(ARTICLE_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(80),PRICE DECIMAL,DESCRIPTION VARCHAR(255),CATEGORY_ID INTEGER) +CREATE TABLE EJB_ARTICLE(ARTICLE_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(80),PRICE DECIMAL(15,2),DESCRIPTION VARCHAR(255),CATEGORY_ID INTEGER) CREATE TABLE EJB_PERSON(PERSON_ID INTEGER NOT NULL PRIMARY KEY,FIRST_NAME VARCHAR(80),LAST_NAME VARCHAR(80),GRADE VARCHAR(80)) 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)) @@ -126,7 +126,11 @@ CREATE TABLE CRT_SUB_PROJECT(SUB_ID INTEGER NOT NULL PRIMARY KEY,PROJECT_ID INTEGER,TUTOR_ID INTEGER,NAME VARCHAR(150),CONSTRAINT CRT_SUB_PROJECT_FK_1 FOREIGN KEY(PROJECT_ID) REFERENCES CRT_PROJECT(PROJECT_ID),CONSTRAINT CRT_SUB_PROJECT_FK_2 FOREIGN KEY(TUTOR_ID) REFERENCES CRT_MEMBER(ROLE_ID)) 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 OTM_ADDRESS_DESC(ID INTEGER NOT NULL PRIMARY KEY,DESCRIPTION VARCHAR(60),PERSON_ID INTEGER,ADDRESS_ID INTEGER,CONSTRAINT OTM_ADDRESS_DESC_FK_1 FOREIGN KEY(ADDRESS_ID) REFERENCES OTM_ADDRESS(ID),CONSTRAINT OTM_ADDRESS_DESC_FK_2 FOREIGN KEY(PERSON_ID) REFERENCES OTM_PERSON(ID)) +CREATE TABLE OTM_PERSON2(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(60)) +CREATE TABLE OTM_PERSON3(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(60)) +CREATE TABLE OTM_ADDRESS2(ID INTEGER NOT NULL PRIMARY KEY,PERSON_ID INTEGER) +CREATE TABLE OTM_DEBITOR(ID INTEGER NOT NULL PRIMARY KEY,PERSON_ID INTEGER) 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) @@ -141,6 +145,7 @@ 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) +ALTER TABLE OTM_PERSON ADD CONSTRAINT OTM_PERSON_FK_1 FOREIGN KEY(MAIN_ADDRESS_ID) REFERENCES OTM_ADDRESS(ID) GRANT ALL ON CLASS "java.lang.Math" TO PUBLIC GRANT ALL ON CLASS "org.hsqldb.Library" TO PUBLIC CREATE USER SA PASSWORD "" ADMIN --------------------------------------------------------------------- To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org For additional commands, e-mail: ojb-dev-help@db.apache.org