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/05/15 23:02:17 UTC
cvs commit: db-ojb/src/test/org/apache/ojb/quick-db OJB.properties OJB.script
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')