Return-Path: Mailing-List: contact ojb-dev-help@db.apache.org; run by ezmlm Delivered-To: mailing list ojb-dev@db.apache.org Received: (qmail 50852 invoked by uid 500); 2 Jun 2003 15:17:38 -0000 Received: (qmail 50806 invoked from network); 2 Jun 2003 15:17:37 -0000 Received: from icarus.apache.org (208.185.179.13) by daedalus.apache.org with SMTP; 2 Jun 2003 15:17:37 -0000 Received: (qmail 72354 invoked by uid 1524); 2 Jun 2003 15:17:36 -0000 Date: 2 Jun 2003 15:17:36 -0000 Message-ID: <20030602151736.72353.qmail@icarus.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 thma 2003/06/02 08:17:36 Modified: src/test/org/apache/ojb/quick-db OJB.properties OJB.script Log: update to latest versio of testdata Revision Changes Path 1.19 +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.18 retrieving revision 1.19 diff -u -r1.18 -r1.19 --- OJB.properties 15 May 2003 21:02:17 -0000 1.18 +++ OJB.properties 2 Jun 2003 15:17:35 -0000 1.19 @@ -1,5 +1,5 @@ #HSQL database -#Thu May 15 22:16:03 CEST 2003 +#Mon Jun 02 15:13:18 CEST 2003 sql.strict_fk=true readonly=false sql.strong_fk=true 1.20 +4 -3 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.19 retrieving revision 1.20 diff -u -r1.19 -r1.20 --- OJB.script 15 May 2003 21:02:17 -0000 1.19 +++ OJB.script 2 Jun 2003 15:17:35 -0000 1.20 @@ -44,7 +44,7 @@ CREATE TABLE CONV_REFERED(PK1 INTEGER NOT NULL PRIMARY KEY,TEST_ID INTEGER) CREATE TABLE SITE(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100),SITEYEAR INTEGER,SEMESTER INTEGER,CONSTRAINT SYS_CT_3 UNIQUE(NAME)) CREATE TABLE NEWS(ID INTEGER NOT NULL PRIMARY KEY,HEADLINE VARCHAR(50)) -CREATE TABLE PAPER(ID INTEGER NOT NULL PRIMARY KEY,ISSUEDATE VARCHAR(50),AUTHOR VARCHAR(50)) +CREATE TABLE PAPER(ID INTEGER NOT NULL PRIMARY KEY,HEADLINE VARCHAR(50),ISSUEDATE VARCHAR(50),AUTHOR VARCHAR(50)) CREATE TABLE TOPIC(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(50)) CREATE TABLE CATEGORY(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(50)) CREATE TABLE AREA(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(50)) @@ -76,6 +76,7 @@ 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) CREATE TABLE COLLECTION_COLLECTIBLE_BC(COL_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),GAT_ID INTEGER,EXTENT_NAME VARCHAR(150)) +CREATE TABLE READONLY_TEST(OBJ_ID DECIMAL NOT NULL PRIMARY KEY,NAME VARCHAR(150),RO_STRING VARCHAR(150),RO_LONG DECIMAL) 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_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) @@ -294,8 +295,8 @@ INSERT INTO NEWS VALUES(1,'Healf Care News (NONE)') INSERT INTO NEWS VALUES(2,'Ferrai for sale (CARS - BUYERS)') INSERT INTO NEWS VALUES(3,'Brazil World Cup Champion ! (SPORTS)') -INSERT INTO PAPER VALUES(10,'today','NONE') -INSERT INTO PAPER VALUES(11,'yesterday','SALES MAN') +INSERT INTO PAPER VALUES(10,'NONE','today','NONE') +INSERT INTO PAPER VALUES(11,'SALES','yesterday','SALES MAN') INSERT INTO TOPIC VALUES(10,'Buyers') INSERT INTO TOPIC VALUES(11,'Sellers') INSERT INTO CATEGORY VALUES(1,'Cars')