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 th...@apache.org on 2003/06/02 17:17:36 UTC
cvs commit: db-ojb/src/test/org/apache/ojb/quick-db OJB.properties OJB.script
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')