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, 02 Jun 2003 15:17:36 GMT
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')
  
  
  

Mime
View raw message