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 Thu, 15 May 2003 21:02:17 GMT
thma        2003/05/15 14:02:17

  Modified:    src/test/org/apache/ojb/quick-db OJB.properties OJB.script
  Log:
  added latest changes to quick db
  
  Revision  Changes    Path
  1.18      +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.17
  retrieving revision 1.18
  diff -u -r1.17 -r1.18
  --- OJB.properties	22 Apr 2003 10:57:23 -0000	1.17
  +++ OJB.properties	15 May 2003 21:02:17 -0000	1.18
  @@ -1,5 +1,5 @@
   #HSQL database
  -#Fri Apr 18 21:00:28 CEST 2003
  +#Thu May 15 22:16:03 CEST 2003
   sql.strict_fk=true
   readonly=false
   sql.strong_fk=true
  
  
  
  1.19      +14 -10    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.18
  retrieving revision 1.19
  diff -u -r1.18 -r1.19
  --- OJB.script	22 Apr 2003 10:57:22 -0000	1.18
  +++ OJB.script	15 May 2003 21:02:17 -0000	1.19
  @@ -47,6 +47,7 @@
   CREATE TABLE PAPER(ID INTEGER NOT NULL PRIMARY KEY,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))
   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))
  @@ -169,9 +170,9 @@
   INSERT INTO ARTIKEL VALUES(2,'Chang',1,1,'24 - 12 oz bottles',19.89E0,17,40,25,0)
   INSERT INTO ARTIKEL VALUES(3,'Aniseed Syrup',1,2,'12 - 550 ml bottles',10.2E0,13,70,25,0)
   INSERT INTO ARTIKEL VALUES(4,'Chef Antons Cajun Seasoning',2,2,'48 - 6 oz jars',22.0E0,53,0,0,0)
  -INSERT INTO ARTIKEL VALUES(5,'Chef Anton\u00b4s Gumbo Mix',2,2,'36 boxes',21.35E0,0,0,0,1)
  -INSERT INTO ARTIKEL VALUES(6,'Grandma\u00b4s Boysenberry Spread',3,2,'12 - 8 oz jars',25.0E0,120,0,25,0)
  -INSERT INTO ARTIKEL VALUES(7,'Uncle Bob\u00b4s Organic Dried Pears',3,7,'12 - 1 lb pkgs.',30.0E0,15,0,10,0)
  +INSERT INTO ARTIKEL VALUES(5,'Chef Anton\u017ds Gumbo Mix',2,2,'36 boxes',21.35E0,0,0,0,1)
  +INSERT INTO ARTIKEL VALUES(6,'Grandma\u017ds Boysenberry Spread',3,2,'12 - 8 oz jars',25.0E0,120,0,25,0)
  +INSERT INTO ARTIKEL VALUES(7,'Uncle Bob\u017ds Organic Dried Pears',3,7,'12 - 1 lb pkgs.',30.0E0,15,0,10,0)
   INSERT INTO ARTIKEL VALUES(8,'Northwoods Cranberry Sauce',3,2,'12 - 12 oz jars',40.0E0,6,0,0,0)
   INSERT INTO ARTIKEL VALUES(9,'Mishi Kobe Niku',4,6,'18 - 500 g pkgs.',97.0E0,29,0,0,1)
   INSERT INTO ARTIKEL VALUES(10,'Ikura',4,8,'12 - 200 ml jars',31.0E0,31,0,0,0)
  @@ -184,9 +185,9 @@
   INSERT INTO ARTIKEL VALUES(17,'Alice Mutton',7,6,'20 - 1 kg tins',39.0E0,0,0,0,1)
   INSERT INTO ARTIKEL VALUES(18,'Carnarvon Tigers',7,8,'16 kg pkg.',62.5E0,42,0,0,0)
   INSERT INTO ARTIKEL VALUES(19,'Teatime Chocolate Biscuits',8,3,'10 boxes x 12 pieces',9.2E0,25,0,5,0)
  -INSERT INTO ARTIKEL VALUES(20,'Sir Rodney\u00b4s Marmalade',8,3,'30 gift boxes',81.0E0,40,0,0,0)
  -INSERT INTO ARTIKEL VALUES(21,'Sir Rodney\u00b4s Scones',8,3,'24 pkgs. x 4 pieces',10.0E0,3,40,5,0)
  -INSERT INTO ARTIKEL VALUES(22,'Gustaf\u00b4s Kn\u00e4ckebr\u00f6d',9,5,'24 - 500 g pkgs.',21.0E0,104,0,25,0)
  +INSERT INTO ARTIKEL VALUES(20,'Sir Rodney\u017ds Marmalade',8,3,'30 gift boxes',81.0E0,40,0,0,0)
  +INSERT INTO ARTIKEL VALUES(21,'Sir Rodney\u017ds Scones',8,3,'24 pkgs. x 4 pieces',10.0E0,3,40,5,0)
  +INSERT INTO ARTIKEL VALUES(22,'Gustaf\u017ds Kn\u00e4ckebr\u00f6d',9,5,'24 - 500 g pkgs.',21.0E0,104,0,25,0)
   INSERT INTO ARTIKEL VALUES(23,'Tunnbr\u00f6d',9,5,'12 - 250 g pkgs.',9.0E0,61,0,25,0)
   INSERT INTO ARTIKEL VALUES(24,'Guaran\u00e1 Fant\u00e1stica',10,1,'12 - 355 ml cans',4.5E0,20,0,0,1)
   INSERT INTO ARTIKEL VALUES(25,'NuNuCa Nu\u00df-Nougat-Creme',11,3,'20 - 450 g glasses',14.0E0,76,0,30,0)
  @@ -205,7 +206,7 @@
   INSERT INTO ARTIKEL VALUES(38,'C\u00f4te de Blaye',18,1,'12 - 75 cl bottles',263.5E0,17,0,15,0)
   INSERT INTO ARTIKEL VALUES(39,'Chartreuse verte',18,1,'750 cc per bottle',18.0E0,69,0,5,0)
   INSERT INTO ARTIKEL VALUES(40,'Boston Crab Meat',19,8,'24 - 4 oz tins',18.4E0,123,0,30,0)
  -INSERT INTO ARTIKEL VALUES(41,'Jack\u00b4s New England Clam Chowder',19,8,'12 - 12 oz cans',9.65E0,85,0,10,0)
  +INSERT INTO ARTIKEL VALUES(41,'Jack\u017ds New England Clam Chowder',19,8,'12 - 12 oz cans',9.65E0,85,0,10,0)
   INSERT INTO ARTIKEL VALUES(42,'Singaporean Hokkien Fried Mee',20,5,'32 - 1 kg pkgs.',14.0E0,26,0,0,1)
   INSERT INTO ARTIKEL VALUES(43,'Ipoh Coffee',20,1,'16 - 500 g tins',46.0E0,17,10,25,0)
   INSERT INTO ARTIKEL VALUES(44,'Gula Malacca',20,2,'20 - 2 kg bags',19.45E0,27,0,15,0)
  @@ -225,7 +226,7 @@
   INSERT INTO ARTIKEL VALUES(58,'Escargots de Bourgogne',27,8,'24 pieces',13.25E0,62,0,20,0)
   INSERT INTO ARTIKEL VALUES(59,'Raclette Courdavault',28,4,'5 kg pkg.',55.0E0,79,0,0,0)
   INSERT INTO ARTIKEL VALUES(60,'Camembert Pierrot',28,4,'15 - 300 g rounds',34.0E0,19,0,0,0)
  -INSERT INTO ARTIKEL VALUES(61,'Sirop d\u00b4\u00e9rable',29,2,'24 - 500 ml bottles',28.5E0,113,0,25,0)
  +INSERT INTO ARTIKEL VALUES(61,'Sirop d\u017d\u00e9rable',29,2,'24 - 500 ml bottles',28.5E0,113,0,25,0)
   INSERT INTO ARTIKEL VALUES(62,'Tarte au sucre',29,3,'48 pies',49.3E0,17,0,0,0)
   INSERT INTO ARTIKEL VALUES(63,'Vegie-spread',7,2,'15 - 625 g jars',43.9E0,24,0,5,0)
   INSERT INTO ARTIKEL VALUES(64,'Wimmers gute Semmelkn\u00f6del',12,5,'20 bags x 4 pieces',33.25E0,22,80,30,0)
  @@ -244,8 +245,8 @@
   INSERT INTO ARTIKEL VALUES(77,'Original Frankfurter gr\u00fcne So\u00dfe',12,2,'12 boxes',13.0E0,32,0,15,0)
   INSERT INTO BOOKS VALUES(100,'Hamlet',12,5,'12 boxes',34.0E0,32,0,15,0,'1234567890','W.
Shakespeare')
   INSERT INTO BOOKS VALUES(101,'Faust',12,5,'12 boxes',56.0E0,32,0,15,0,'1234567890','J.W.
v. Goethe')
  -INSERT INTO CDS VALUES(200,'Mama\u00b4s Gun',12,5,'12 boxes',23.0E0,32,0,15,0,'Motown Records','Erykah
Badu')
  -INSERT INTO CDS VALUES(201,'STREETSOUL',12,5,'12 boxes',25.0E0,32,0,15,0,'Virgin Records','Guru\u00b4s
Jazzmatazz')
  +INSERT INTO CDS VALUES(200,'Mama\u017ds Gun',12,5,'12 boxes',23.0E0,32,0,15,0,'Motown Records','Erykah
Badu')
  +INSERT INTO CDS VALUES(201,'STREETSOUL',12,5,'12 boxes',25.0E0,32,0,15,0,'Virgin Records','Guru\u017ds
Jazzmatazz')
   INSERT INTO CDS VALUES(202,'Beyond Skin',12,5,'12 boxes',25.0E0,32,0,15,0,'Outcaste Records','Nitin
Sawhney')
   INSERT INTO ORDER_POSITION VALUES(1,1,5)
   INSERT INTO ORDER_POSITION VALUES(2,1,100)
  @@ -299,9 +300,12 @@
   INSERT INTO TOPIC VALUES(11,'Sellers')
   INSERT INTO CATEGORY VALUES(1,'Cars')
   INSERT INTO CATEGORY VALUES(2,'Sports')
  +INSERT INTO AREA VALUES(20,'Human')
  +INSERT INTO AREA VALUES(21,'NotHuman')
   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(10,20)
   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')
  
  
  

Mime
View raw message