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.script OJB.properties
Date Fri, 11 Apr 2003 21:00:28 GMT
thma        2003/04/11 14:00:28

  Modified:    src/test/org/apache/ojb/quick-db OJB.script OJB.properties
  Log:
  include latest changes to testdata
  
  Revision  Changes    Path
  1.17      +18 -0     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.16
  retrieving revision 1.17
  diff -u -r1.16 -r1.17
  --- OJB.script	3 Apr 2003 20:35:26 -0000	1.16
  +++ OJB.script	11 Apr 2003 21:00:28 -0000	1.17
  @@ -43,6 +43,11 @@
   CREATE TABLE CONV_REFERER(PK1 INTEGER NOT NULL PRIMARY KEY,REF1 INTEGER,TEST_ID INTEGER)
   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,DATE 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 CONTENT_QUALIFIER(CONTENT_ID INTEGER NOT NULL,QUALIFIER_ID INTEGER NOT NULL,CONSTRAINT
SYS_PK_CONTENT_QUALIFIER PRIMARY KEY(CONTENT_ID,QUALIFIER_ID))
   CREATE TABLE SM_TAB_A(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
   CREATE TABLE SM_TAB_AA(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
   CREATE TABLE SM_TAB_AB(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
  @@ -285,6 +290,19 @@
   INSERT INTO CONV_REFERED VALUES(50,60)
   INSERT INTO CONV_REFERED VALUES(51,61)
   INSERT INTO CONV_REFERED VALUES(52,62)
  +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 TOPIC VALUES(10,'Buyers')
  +INSERT INTO TOPIC VALUES(11,'Sellers')
  +INSERT INTO CATEGORY VALUES(1,'Cars')
  +INSERT INTO CATEGORY VALUES(2,'Sports')
  +INSERT INTO CONTENT_QUALIFIER VALUES(2,1)
  +INSERT INTO CONTENT_QUALIFIER VALUES(2,10)
  +INSERT INTO CONTENT_QUALIFIER VALUES(3,2)
  +INSERT INTO CONTENT_QUALIFIER VALUES(11,11)
   INSERT INTO SM_TAB_MAX_A VALUES(120,'A')
   INSERT INTO SM_TAB_MAX_A VALUES(121,'A')
   INSERT INTO SM_TAB_MAX_AA VALUES(101,'AA')
  
  
  
  1.16      +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.15
  retrieving revision 1.16
  diff -u -r1.15 -r1.16
  --- OJB.properties	3 Apr 2003 20:35:26 -0000	1.15
  +++ OJB.properties	11 Apr 2003 21:00:28 -0000	1.16
  @@ -1,5 +1,5 @@
   #HSQL database
  -#Thu Apr 03 21:09:19 CEST 2003
  +#Fri Apr 11 22:52:31 CEST 2003
   sql.strict_fk=true
   readonly=false
   sql.strong_fk=true
  
  
  

Mime
View raw message