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 Sat, 06 Dec 2003 19:06:24 GMT
thma        2003/12/06 11:06:24

  Modified:    src/test/org/apache/ojb/quick-db OJB.properties OJB.script
  Log:
  update the quick db for the junit-quick target
  
  Revision  Changes    Path
  1.26      +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.25
  retrieving revision 1.26
  diff -u -r1.25 -r1.26
  --- OJB.properties	5 Sep 2003 22:14:04 -0000	1.25
  +++ OJB.properties	6 Dec 2003 19:06:24 -0000	1.26
  @@ -1,5 +1,5 @@
   #HSQL database
  -#Sat Sep 06 00:12:18 CEST 2003
  +#Sat Dec 06 19:38:27 CET 2003
   sql.strict_fk=true
   readonly=false
   sql.strong_fk=true
  
  
  
  1.27      +347 -342  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.26
  retrieving revision 1.27
  diff -u -r1.26 -r1.27
  --- OJB.script	5 Sep 2003 22:14:04 -0000	1.26
  +++ OJB.script	6 Dec 2003 19:06:24 -0000	1.27
  @@ -1,342 +1,347 @@
  -CREATE TABLE KATEGORIEN(KATEGORIE_NR INTEGER NOT NULL PRIMARY KEY,KATEGORIENAME VARCHAR(60),BESCHREIBUNG VARCHAR(60))
  -CREATE TABLE ARTIKEL(ARTIKEL_NR INTEGER NOT NULL PRIMARY KEY,ARTIKELNAME VARCHAR(60),LIEFERANTEN_NR INTEGER,KATEGORIE_NR INTEGER,LIEFEREINHEIT VARCHAR(30),EINZELPREIS FLOAT,LAGERBESTAND INTEGER,BESTELLTEEINHEITEN INTEGER,MINDESTBESTAND INTEGER,AUSLAUFARTIKEL INTEGER,CONSTRAINT ARTIKEL_FK_1 FOREIGN KEY(KATEGORIE_NR) REFERENCES KATEGORIEN(KATEGORIE_NR))
  -CREATE TABLE BOOKS(ARTIKEL_NR INTEGER NOT NULL PRIMARY KEY,ARTIKELNAME VARCHAR(60),LIEFERANTEN_NR INTEGER,KATEGORIE_NR INTEGER,LIEFEREINHEIT VARCHAR(30),EINZELPREIS FLOAT,LAGERBESTAND INTEGER,BESTELLTEEINHEITEN INTEGER,MINDESTBESTAND INTEGER,AUSLAUFARTIKEL INTEGER,ISBN VARCHAR(10),AUTHOR VARCHAR(50),CONSTRAINT BOOKS_FK_1 FOREIGN KEY(KATEGORIE_NR) REFERENCES KATEGORIEN(KATEGORIE_NR))
  -CREATE TABLE CDS(ARTIKEL_NR INTEGER NOT NULL PRIMARY KEY,ARTIKELNAME VARCHAR(60),LIEFERANTEN_NR INTEGER,KATEGORIE_NR INTEGER,LIEFEREINHEIT VARCHAR(30),EINZELPREIS FLOAT,LAGERBESTAND INTEGER,BESTELLTEEINHEITEN INTEGER,MINDESTBESTAND INTEGER,AUSLAUFARTIKEL INTEGER,LABEL VARCHAR(50),MUSICIANS VARCHAR(250),CONSTRAINT CDS_FK_1 FOREIGN KEY(KATEGORIE_NR) REFERENCES KATEGORIEN(KATEGORIE_NR))
  -CREATE TABLE ORDER_POSITION(ID INTEGER NOT NULL PRIMARY KEY,ORDER_ID INTEGER,ARTICLE_ID INTEGER)
  -CREATE TABLE TREE(ID INTEGER NOT NULL PRIMARY KEY,DATA VARCHAR(50),PARENT_ID INTEGER)
  -CREATE TABLE TREEGROUP(ID INTEGER NOT NULL PRIMARY KEY,DATA VARCHAR(50),PARENT_ID INTEGER,GROUP_ID INTEGER)
  -CREATE TABLE AB_TABLE(ID INTEGER NOT NULL PRIMARY KEY,CLASS_NAME VARCHAR(60),VALUE_ INTEGER,A_FIELD VARCHAR(60),B_FIELD VARCHAR(60))
  -CREATE TABLE PRODUCT(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100),PRICE FLOAT,STOCK INTEGER)
  -CREATE TABLE PERSON(ID INTEGER NOT NULL PRIMARY KEY,FIRSTNAME VARCHAR(50),LASTNAME VARCHAR(50))
  -CREATE TABLE PROJECT(ID INTEGER NOT NULL PRIMARY KEY,TITLE VARCHAR(50),DESCRIPTION VARCHAR(250))
  -CREATE TABLE PERSON_PROJECT(PERSON_ID INTEGER NOT NULL,PROJECT_ID INTEGER NOT NULL,ROLENAME VARCHAR(20),CONSTRAINT SYS_PK_PERSON_PROJECT PRIMARY KEY(PERSON_ID,PROJECT_ID),CONSTRAINT PERSON_PROJECT_FK_1 FOREIGN KEY(PERSON_ID) REFERENCES PERSON(ID),CONSTRAINT PERSON_PROJECT_FK_2 FOREIGN KEY(PROJECT_ID) REFERENCES PROJECT(ID))
  -CREATE TABLE TASK(TASK_ID INTEGER NOT NULL PRIMARY KEY,PERSON_ID INTEGER,PROJECT_ID INTEGER,TASKNAME VARCHAR(20),CONSTRAINT TASK_FK_1 FOREIGN KEY(PERSON_ID,PROJECT_ID) REFERENCES PERSON_PROJECT(PERSON_ID,PROJECT_ID))
  -CREATE TABLE FAMILY_MEMBER(ID INTEGER NOT NULL PRIMARY KEY,FIRSTNAME VARCHAR(50),LASTNAME VARCHAR(50),MOTHER_ID INTEGER,FATHER_ID INTEGER)
  -CREATE TABLE LOCKED_BY_VERSION(ID INTEGER NOT NULL PRIMARY KEY,VALUE_ VARCHAR(60),VERSION_ INTEGER)
  -CREATE TABLE LOCKED_BY_TIMESTAMP(ID INTEGER NOT NULL PRIMARY KEY,VALUE_ VARCHAR(60),TIMESTAMP_ TIMESTAMP)
  -CREATE TABLE BLOB_TEST(ID INTEGER NOT NULL PRIMARY KEY,BLOB_VALUE_ LONGVARBINARY,CLOB_VALUE_ VARCHAR)
  -CREATE TABLE MDTEST_MASTER(MASTERID INTEGER NOT NULL PRIMARY KEY,MASTER_TEXT VARCHAR(255))
  -CREATE TABLE MDTEST_DETAIL_FKINPK(MASTERID INTEGER NOT NULL,DETAILID INTEGER NOT NULL,DETAIL_TEXT VARCHAR(255),CONSTRAINT SYS_PK_MDTEST_DETAIL_FKINPK PRIMARY KEY(MASTERID,DETAILID),CONSTRAINT MDTEST_DETAIL_FKINPK_FK_1 FOREIGN KEY(MASTERID) REFERENCES MDTEST_MASTER(MASTERID))
  -CREATE TABLE MDTEST_DETAIL_FKNOPK(DETAILID INTEGER NOT NULL PRIMARY KEY,MASTERID INTEGER,DETAIL_TEXT VARCHAR(255),CONSTRAINT MDTEST_DETAIL_FKNOPK_FK_1 FOREIGN KEY(MASTERID) REFERENCES MDTEST_MASTER(MASTERID))
  -CREATE TABLE POINT_TABLE(ID INTEGER NOT NULL PRIMARY KEY,X INTEGER,Y INTEGER)
  -CREATE TABLE GRAPH_NODE(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(50),LOCATION INTEGER)
  -CREATE TABLE GRAPH_EDGE(ID INTEGER NOT NULL PRIMARY KEY,SOURCE INTEGER,SINK INTEGER)
  -CREATE TABLE TESTCLASSA(ID VARCHAR(48) NOT NULL PRIMARY KEY,VALUE1 VARCHAR(64),VALUE2 VARCHAR(64),VALUE3 INTEGER,BOID VARCHAR(48))
  -CREATE TABLE TESTCLASSB(ID VARCHAR(48) NOT NULL PRIMARY KEY,VALUE1 VARCHAR(64),AOID VARCHAR(48))
  -CREATE TABLE RELATEDTOCONTRACT(PK VARCHAR(48) NOT NULL PRIMARY KEY,RELATEDVALUE1 VARCHAR(64),RELATEDVALUE2 INTEGER,RELATEDVALUE3 TIMESTAMP)
  -CREATE TABLE CONTRACT(PK VARCHAR(48) NOT NULL PRIMARY KEY,FK_TO_RELATED VARCHAR(48),CONTRACT_VALUE1 VARCHAR(64),CONTRACT_VALUE2 INTEGER,CONTRACT_VALUE3 VARCHAR(64),CONTRACT_VALUE4 TIMESTAMP,CONSTRAINT CONTRACT_FK_1 FOREIGN KEY(FK_TO_RELATED) REFERENCES RELATEDTOCONTRACT(PK))
  -CREATE TABLE VERSION(PK VARCHAR(48) NOT NULL PRIMARY KEY,FK_TO_CONTRACT VARCHAR(48),VERSION_VALUE1 VARCHAR(64),VERSION_VALUE2 INTEGER,VERSION_VALUE3 TIMESTAMP,CONSTRAINT VERSION_FK_1 FOREIGN KEY(FK_TO_CONTRACT) REFERENCES CONTRACT(PK))
  -CREATE TABLE EFFECTIVENESS(PK VARCHAR(48) NOT NULL PRIMARY KEY,FK_TO_VERSION VARCHAR(48),EFF_VALUE1 VARCHAR(64),EFF_VALUE2 INTEGER,EFF_VALUE3 TIMESTAMP,CONSTRAINT EFFECTIVENESS_FK_1 FOREIGN KEY(FK_TO_VERSION) REFERENCES VERSION(PK))
  -CREATE TABLE MULTIMAPPEDTABLE(ID INTEGER NOT NULL PRIMARY KEY,VALUE1 VARCHAR(64),VALUE2 INTEGER,VALUE3 TIMESTAMP,VALUE4 VARCHAR(64),VALUE5 INTEGER,VALUE6 TIMESTAMP,VALUE7 VARCHAR(64),OJBCONCRETECLASS VARCHAR(64))
  -CREATE TABLE EXTENT_TEST_A(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100))
  -CREATE TABLE EXTENT_TEST_B(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100))
  -CREATE TABLE EXTENT_TEST_C(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100))
  -CREATE TABLE EXTENT_TEST_D(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100))
  -CREATE TABLE TABLE_1(PK INTEGER NOT NULL PRIMARY KEY,FK_TO_RELATED INTEGER)
  -CREATE TABLE TABLE_2(PK INTEGER NOT NULL PRIMARY KEY)
  -CREATE TABLE BIDIR_A(PK VARCHAR(48) NOT NULL PRIMARY KEY,FK_TO_B VARCHAR(48))
  -CREATE TABLE BIDIR_B(PK VARCHAR(48) NOT NULL PRIMARY KEY,FK_TO_A VARCHAR(48),CONSTRAINT BIDIR_B_FK_1 FOREIGN KEY(FK_TO_A) REFERENCES BIDIR_A(PK))
  -CREATE TABLE MAMMAL(ANIMALID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(60),AGE INTEGER,NUMLEGS INTEGER,ZOOID INTEGER)
  -CREATE TABLE REPTILE(ANIMALID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(60),AGE INTEGER,COLOR VARCHAR(60),ZOOID INTEGER)
  -CREATE TABLE ZOO(ZOOID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(60))
  -CREATE TABLE FISH(FOODID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(60),CALORIES INTEGER,TYPEOFWATER VARCHAR(60))
  -CREATE TABLE SALAD(FOODID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(60),CALORIES INTEGER,COLOR VARCHAR(60))
  -CREATE TABLE GOURMET(GOURMETID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(60))
  -CREATE TABLE GOURMET_FOOD(GOURMET_ID INTEGER NOT NULL,FOOD_ID INTEGER NOT NULL,CONSTRAINT SYS_PK_GOURMET_FOOD PRIMARY KEY(GOURMET_ID,FOOD_ID))
  -CREATE TABLE GUIDTEST(GUID_ VARCHAR(60) NOT NULL PRIMARY KEY,GUIDVALUE VARCHAR(60))
  -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 ODMG_DLIST(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100),RND_NAME VARCHAR(100))
  -CREATE TABLE NEWS(ID INTEGER NOT NULL PRIMARY KEY,HEADLINE 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))
  -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))
  -CREATE TABLE SM_TAB_AAA(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
  -CREATE TABLE SM_TAB_B(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
  -CREATE TABLE SM_TAB_BB(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
  -CREATE TABLE SM_SAME_TAB(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
  -CREATE TABLE SM_AUTO_NAMING(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
  -CREATE TABLE SM_TAB_MAX_A(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
  -CREATE TABLE SM_TAB_MAX_AA(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
  -CREATE TABLE SM_TAB_MAX_AB(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
  -CREATE TABLE SM_TAB_MAX_AAA(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
  -CREATE TABLE SM_TAB_MAX_B(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
  -CREATE TABLE SM_TAB_MAX_BB(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
  -CREATE TABLE SM_KEY(INT_KEY INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250),STRING_KEY VARCHAR(250),LONG_KEY BIGINT,INTEGER_KEY INTEGER)
  -CREATE TABLE SM_MT_TEST_A(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100))
  -CREATE TABLE SM_MT_TEST_B(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100))
  -CREATE TABLE EJB_CATEGORY(CATEGORY_ID INTEGER NOT NULL PRIMARY KEY,CATEGORY_NAME VARCHAR(80),DESCRIPTION VARCHAR(255))
  -CREATE TABLE EJB_ARTICLE(ARTICLE_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(80),PRICE DECIMAL,DESCRIPTION VARCHAR(255),CATEGORY_ID INTEGER)
  -CREATE TABLE EJB_PERSON(PERSON_ID INTEGER NOT NULL PRIMARY KEY,FIRST_NAME VARCHAR(80),LAST_NAME VARCHAR(80),GRADE VARCHAR(80))
  -CREATE TABLE FIELD_CONVERSION_NODE(NODE_ID DECIMAL(15) NOT NULL,NODE_STATE INTEGER NOT NULL,PARENT_UID DECIMAL(15),CONSTRAINT SYS_PK_FIELD_CONVERSION_NODE PRIMARY KEY(NODE_ID,NODE_STATE))
  -CREATE TABLE CONVERSION_VO(PK_WITH_AUTO INTEGER NOT NULL,PK_WITHOUT_AUTO INTEGER NOT NULL,NORMAL_WITH_AUTO INTEGER,NORMAL_WITHOUT_AUTO INTEGER,CONSTRAINT SYS_PK_CONVERSION_VO PRIMARY KEY(PK_WITH_AUTO,PK_WITHOUT_AUTO))
  -CREATE TABLE PERF_ARTICLE(ARTICLE_ID INTEGER NOT NULL PRIMARY KEY,ARTICLE_NAME VARCHAR(150),MINIMUM_STOCK INTEGER,PRICE DOUBLE,UNIT VARCHAR(20),STOCK INTEGER,SUPPLIER_ID INTEGER,PRODUCT_GROUP_ID INTEGER)
  -CREATE TABLE CACHE_TEST(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100))
  -CREATE TABLE REF_REPOSITORY(REP_ID INTEGER NOT NULL PRIMARY KEY,REF_FK INTEGER,REFA_FK INTEGER,REFB_FK INTEGER,ANIMAL_FK INTEGER,NAME VARCHAR(100))
  -CREATE TABLE REF_REPOSITORY_FK(REP_ID INTEGER NOT NULL,REF_FK INTEGER NOT NULL,REFA_FK INTEGER NOT NULL,REFB_FK INTEGER NOT NULL,NAME VARCHAR(100),CONSTRAINT SYS_PK_REF_REPOSITORY_FK PRIMARY KEY(REP_ID,REF_FK,REFA_FK,REFB_FK))
  -CREATE TABLE REF_REFERENCE(REF_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100),REF_NAME_A VARCHAR(100),REF_NAME_B VARCHAR(100))
  -CREATE TABLE REF_ANIMAL(A_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100),CLASS_NAME VARCHAR(100),LENGTH_ DOUBLE)
  -CREATE TABLE REF_FISH(A_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100),CLASS_NAME VARCHAR(100),LENGTH_ DOUBLE)
  -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_BASE(COL_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),GAT_ID INTEGER)
  -CREATE TABLE COLLECTION_COLLECTIBLE_B(COL_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),GAT_ID INTEGER)
  -CREATE TABLE COLLECTION_COLLECTIBLE_C(COL_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),GAT_ID INTEGER,EXTENT_NAME VARCHAR(150))
  -CREATE TABLE COLLECTION_COLLECTIBLE_D(COL_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),OJB_CONCRETE_CLASS VARCHAR(150),GAT_ID INTEGER)
  -CREATE TABLE READONLY_TEST(OBJ_ID DECIMAL NOT NULL PRIMARY KEY,NAME VARCHAR(150),RO_STRING VARCHAR(150),RO_LONG DECIMAL)
  -CREATE TABLE TABLE_E(ID INTEGER NOT NULL PRIMARY KEY,SOMESUPERVALUE INTEGER)
  -CREATE TABLE TABLE_F(ID INTEGER NOT NULL PRIMARY KEY,E_ID INTEGER,SOMEVALUE INTEGER)
  -CREATE TABLE ABSTRACT_COLLECTION_Z(OBJ_ID INTEGER NOT NULL PRIMARY KEY,CONTAINER_ID INTEGER,NAME VARCHAR(150),SOMEVALUE INTEGER)
  -CREATE TABLE ABSTRACT_COLLECTION_ZZ(OBJ_ID INTEGER NOT NULL PRIMARY KEY,CONTAINER_ID INTEGER,NAME VARCHAR(150),ZZ_NAME VARCHAR(150),SOMEVALUE INTEGER)
  -CREATE TABLE XCONTAINER(OBJ_ID INTEGER NOT NULL PRIMARY KEY)
  -CREATE TABLE NESTED_FIELDS_TAB(OBJ_ID DECIMAL NOT NULL PRIMARY KEY,NAME VARCHAR(150),NESTED_VALUE VARCHAR(150),NESTED_DESCRIPTION VARCHAR(150))
  -CREATE TABLE OTM_PERSON(ID INTEGER NOT NULL PRIMARY KEY,FIRSTNAME VARCHAR(60),LASTNAME VARCHAR(60),MAIN_ADDRESS_ID INTEGER)
  -CREATE TABLE OTM_ADDRESS(ID INTEGER NOT NULL PRIMARY KEY,COUNTRY VARCHAR(60),CITY VARCHAR(60),STREET VARCHAR(60))
  -CREATE TABLE OTM_ADDRESS_DESC(ID INTEGER NOT NULL PRIMARY KEY,DESCRIPTION VARCHAR(60),PERSON_ID INTEGER,ADDRESS_ID INTEGER)
  -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)
  -CREATE TABLE OJB_DLIST(ID INTEGER NOT NULL PRIMARY KEY,SIZE_ INTEGER)
  -CREATE TABLE OJB_DLIST_ENTRIES(ID INTEGER NOT NULL PRIMARY KEY,DLIST_ID INTEGER,POSITION_ INTEGER,OID_ LONGVARBINARY)
  -CREATE TABLE OJB_DSET(ID INTEGER NOT NULL PRIMARY KEY,SIZE_ INTEGER)
  -CREATE TABLE OJB_DSET_ENTRIES(ID INTEGER NOT NULL PRIMARY KEY,DLIST_ID INTEGER,POSITION_ INTEGER,OID_ LONGVARBINARY)
  -CREATE TABLE OJB_DMAP(ID INTEGER NOT NULL PRIMARY KEY,SIZE_ INTEGER)
  -CREATE TABLE OJB_DMAP_ENTRIES(ID INTEGER NOT NULL PRIMARY KEY,DMAP_ID INTEGER,KEY_OID BINARY,VALUE_OID BINARY)
  -ALTER TABLE TABLE_1 ADD CONSTRAINT TABLE_1_FK_1 FOREIGN KEY(FK_TO_RELATED) REFERENCES TABLE_2(PK)
  -ALTER TABLE BIDIR_A ADD CONSTRAINT BIDIR_A_FK_1 FOREIGN KEY(FK_TO_B) REFERENCES BIDIR_B(PK)
  -GRANT ALL ON CLASS "java.lang.Math" TO PUBLIC
  -GRANT ALL ON CLASS "org.hsqldb.Library" TO PUBLIC
  -CREATE USER SA PASSWORD "" ADMIN
  -CREATE ALIAS DAYNAME FOR "org.hsqldb.Library.dayname"
  -CREATE ALIAS SPACE FOR "org.hsqldb.Library.space"
  -CREATE ALIAS SUBSTRING FOR "org.hsqldb.Library.substring"
  -CREATE ALIAS HEXTORAW FOR "org.hsqldb.Library.hexToRaw"
  -CREATE ALIAS SQRT FOR "java.lang.Math.sqrt"
  -CREATE ALIAS ABS FOR "org.hsqldb.Library.abs"
  -CREATE ALIAS POWER FOR "java.lang.Math.pow"
  -CREATE ALIAS CHAR FOR "org.hsqldb.Library.character"
  -CREATE ALIAS CONCAT FOR "org.hsqldb.Library.concat"
  -CREATE ALIAS PI FOR "org.hsqldb.Library.pi"
  -CREATE ALIAS RAWTOHEX FOR "org.hsqldb.Library.rawToHex"
  -CREATE ALIAS SECOND FOR "org.hsqldb.Library.second"
  -CREATE ALIAS TRUNCATE FOR "org.hsqldb.Library.truncate"
  -CREATE ALIAS MONTH FOR "org.hsqldb.Library.month"
  -CREATE ALIAS LOWER FOR "org.hsqldb.Library.lcase"
  -CREATE ALIAS ATAN2 FOR "java.lang.Math.atan2"
  -CREATE ALIAS REPEAT FOR "org.hsqldb.Library.repeat"
  -CREATE ALIAS DAYOFMONTH FOR "org.hsqldb.Library.dayofmonth"
  -CREATE ALIAS TAN FOR "java.lang.Math.tan"
  -CREATE ALIAS RADIANS FOR "java.lang.Math.toRadians"
  -CREATE ALIAS FLOOR FOR "java.lang.Math.floor"
  -CREATE ALIAS NOW FOR "org.hsqldb.Library.now"
  -CREATE ALIAS ACOS FOR "java.lang.Math.acos"
  -CREATE ALIAS DAYOFWEEK FOR "org.hsqldb.Library.dayofweek"
  -CREATE ALIAS CEILING FOR "java.lang.Math.ceil"
  -CREATE ALIAS DAYOFYEAR FOR "org.hsqldb.Library.dayofyear"
  -CREATE ALIAS LCASE FOR "org.hsqldb.Library.lcase"
  -CREATE ALIAS WEEK FOR "org.hsqldb.Library.week"
  -CREATE ALIAS SOUNDEX FOR "org.hsqldb.Library.soundex"
  -CREATE ALIAS ASIN FOR "java.lang.Math.asin"
  -CREATE ALIAS LOCATE FOR "org.hsqldb.Library.locate"
  -CREATE ALIAS EXP FOR "java.lang.Math.exp"
  -CREATE ALIAS MONTHNAME FOR "org.hsqldb.Library.monthname"
  -CREATE ALIAS YEAR FOR "org.hsqldb.Library.year"
  -CREATE ALIAS LEFT FOR "org.hsqldb.Library.left"
  -CREATE ALIAS ROUNDMAGIC FOR "org.hsqldb.Library.roundMagic"
  -CREATE ALIAS BITOR FOR "org.hsqldb.Library.bitor"
  -CREATE ALIAS LTRIM FOR "org.hsqldb.Library.ltrim"
  -CREATE ALIAS COT FOR "org.hsqldb.Library.cot"
  -CREATE ALIAS COS FOR "java.lang.Math.cos"
  -CREATE ALIAS MOD FOR "org.hsqldb.Library.mod"
  -CREATE ALIAS SIGN FOR "org.hsqldb.Library.sign"
  -CREATE ALIAS DEGREES FOR "java.lang.Math.toDegrees"
  -CREATE ALIAS LOG FOR "java.lang.Math.log"
  -CREATE ALIAS SIN FOR "java.lang.Math.sin"
  -CREATE ALIAS CURTIME FOR "org.hsqldb.Library.curtime"
  -CREATE ALIAS DIFFERENCE FOR "org.hsqldb.Library.difference"
  -CREATE ALIAS INSERT FOR "org.hsqldb.Library.insert"
  -CREATE ALIAS SUBSTR FOR "org.hsqldb.Library.substring"
  -CREATE ALIAS DATABASE FOR "org.hsqldb.Library.database"
  -CREATE ALIAS MINUTE FOR "org.hsqldb.Library.minute"
  -CREATE ALIAS HOUR FOR "org.hsqldb.Library.hour"
  -CREATE ALIAS IDENTITY FOR "org.hsqldb.Library.identity"
  -CREATE ALIAS QUARTER FOR "org.hsqldb.Library.quarter"
  -CREATE ALIAS CURDATE FOR "org.hsqldb.Library.curdate"
  -CREATE ALIAS BITAND FOR "org.hsqldb.Library.bitand"
  -CREATE ALIAS USER FOR "org.hsqldb.Library.user"
  -CREATE ALIAS UCASE FOR "org.hsqldb.Library.ucase"
  -CREATE ALIAS RTRIM FOR "org.hsqldb.Library.rtrim"
  -CREATE ALIAS LOG10 FOR "org.hsqldb.Library.log10"
  -CREATE ALIAS RIGHT FOR "org.hsqldb.Library.right"
  -CREATE ALIAS ATAN FOR "java.lang.Math.atan"
  -CREATE ALIAS UPPER FOR "org.hsqldb.Library.ucase"
  -CREATE ALIAS ASCII FOR "org.hsqldb.Library.ascii"
  -CREATE ALIAS RAND FOR "java.lang.Math.random"
  -CREATE ALIAS LENGTH FOR "org.hsqldb.Library.length"
  -CREATE ALIAS ROUND FOR "org.hsqldb.Library.round"
  -CREATE ALIAS REPLACE FOR "org.hsqldb.Library.replace"
  -INSERT INTO KATEGORIEN VALUES(1,'Beverages','Alles leckere zum S\u00fcffeln')
  -INSERT INTO KATEGORIEN VALUES(2,'Spices','Gew\u00fcrze, Dressings etc.')
  -INSERT INTO KATEGORIEN VALUES(3,'Meat','')
  -INSERT INTO KATEGORIEN VALUES(4,'Liquors','')
  -INSERT INTO KATEGORIEN VALUES(5,'Books','Strange Books...')
  -INSERT INTO KATEGORIEN VALUES(6,'bread','')
  -INSERT INTO KATEGORIEN VALUES(7,'Fruits','Fr\u00fcchte etc.')
  -INSERT INTO KATEGORIEN VALUES(8,'Dairy Products','Kat 8')
  -INSERT INTO ARTIKEL VALUES(1,'Chai',1,1,'10 boxes x 20 bags',18.53E0,39,0,10,0)
  -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(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)
  -INSERT INTO ARTIKEL VALUES(11,'Queso Cabrales',5,4,'1 kg pkg.',21.0E0,22,30,30,0)
  -INSERT INTO ARTIKEL VALUES(12,'Queso Manchego La Pastora',5,4,'10 - 500 g pkgs.',38.0E0,86,0,0,0)
  -INSERT INTO ARTIKEL VALUES(13,'Konbu',6,8,'2 kg box',6.0E0,24,0,5,0)
  -INSERT INTO ARTIKEL VALUES(14,'Tofu',6,7,'40 - 100 g pkgs.',23.25E0,35,0,0,0)
  -INSERT INTO ARTIKEL VALUES(15,'Genen Shouyu',6,2,'24 - 250 ml bottles',15.5E0,39,0,5,0)
  -INSERT INTO ARTIKEL VALUES(16,'Pavlova',7,3,'32 - 500 g boxes',17.45E0,29,0,10,0)
  -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(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)
  -INSERT INTO ARTIKEL VALUES(26,'Gumb\u00e4r Gummib\u00e4rchen',11,3,'100 - 250 g bags',31.23E0,15,0,0,0)
  -INSERT INTO ARTIKEL VALUES(27,'Schoggi Schokolade',11,3,'100 - 100 g pieces',43.9E0,49,0,30,0)
  -INSERT INTO ARTIKEL VALUES(28,'R\u00f6ssle Sauerkraut',12,7,'25 - 825 g cans',45.6E0,26,0,0,1)
  -INSERT INTO ARTIKEL VALUES(29,'Th\u00fcringer Rostbratwurst',12,6,'50 bags x 30 sausgs.',123.79E0,0,0,0,1)
  -INSERT INTO ARTIKEL VALUES(30,'Nord-Ost Matjeshering',13,8,'10 - 200 g glasses',25.89E0,10,0,15,0)
  -INSERT INTO ARTIKEL VALUES(31,'Gorgonzola Telino',14,4,'12 - 100 g pkgs',12.5E0,0,70,20,0)
  -INSERT INTO ARTIKEL VALUES(32,'Mascarpone Fabioli',14,4,'24 - 200 g pkgs.',32.0E0,9,40,25,0)
  -INSERT INTO ARTIKEL VALUES(33,'Geitost',15,4,'500 g',2.5E0,112,0,20,0)
  -INSERT INTO ARTIKEL VALUES(34,'Sasquatch Ale',16,1,'24 - 12 oz bottles',14.0E0,111,0,15,0)
  -INSERT INTO ARTIKEL VALUES(35,'Steeleye Stout',16,1,'24 - 12 oz bottles',18.0E0,20,0,15,0)
  -INSERT INTO ARTIKEL VALUES(36,'Inlagd Sill',17,8,'24 - 250 g  jars',19.0E0,112,0,20,0)
  -INSERT INTO ARTIKEL VALUES(37,'Gravad lax',17,8,'12 - 500 g pkgs.',26.0E0,11,50,25,0)
  -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(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)
  -INSERT INTO ARTIKEL VALUES(45,'R\u00f8gede sild',21,8,'1k pkg.',9.5E0,5,70,15,0)
  -INSERT INTO ARTIKEL VALUES(46,'Spegesild',21,8,'4 - 450 g glasses',12.0E0,95,0,0,0)
  -INSERT INTO ARTIKEL VALUES(47,'Zaanse koeken',22,3,'10 - 4 oz boxes',9.5E0,36,0,0,0)
  -INSERT INTO ARTIKEL VALUES(48,'Chocolade',22,3,'10 pkgs.',12.75E0,15,70,25,0)
  -INSERT INTO ARTIKEL VALUES(49,'Maxilaku',23,3,'24 - 50 g pkgs.',20.0E0,10,60,15,0)
  -INSERT INTO ARTIKEL VALUES(50,'Valkoinen suklaa',23,3,'12 - 100 g bars',16.25E0,65,0,30,0)
  -INSERT INTO ARTIKEL VALUES(51,'Manjimup Dried Apples',24,7,'50 - 300 g pkgs.',53.0E0,20,0,10,0)
  -INSERT INTO ARTIKEL VALUES(52,'Filo Mix',24,5,'16 - 2 kg boxes',7.0E0,38,0,25,0)
  -INSERT INTO ARTIKEL VALUES(53,'Perth Pasties',24,6,'48 pieces',32.8E0,0,0,0,1)
  -INSERT INTO ARTIKEL VALUES(54,'Tourti\u00e8re',25,6,'16 pies',7.45E0,21,0,10,0)
  -INSERT INTO ARTIKEL VALUES(55,'P\u00e2t\u00e9 chinois',25,6,'24 boxes x 2 pies',24.0E0,115,0,20,0)
  -INSERT INTO ARTIKEL VALUES(56,'Gnocchi di nonna Alice',26,5,'24 - 250 g pkgs.',38.0E0,21,10,30,0)
  -INSERT INTO ARTIKEL VALUES(57,'Ravioli Angelo',26,5,'24 - 250 g pkgs.',19.5E0,36,0,20,0)
  -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(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)
  -INSERT INTO ARTIKEL VALUES(65,'Louisiana Fiery Hot Pepper Sauce',2,2,'32 - 8 oz bottles',21.05E0,76,0,0,0)
  -INSERT INTO ARTIKEL VALUES(66,'Louisiana Hot Spiced Okra',2,2,'24 - 8 oz jars',17.0E0,4,100,20,0)
  -INSERT INTO ARTIKEL VALUES(67,'Laughing Lumberjack Lager',16,1,'24 - 12 oz bottles',14.0E0,52,0,10,0)
  -INSERT INTO ARTIKEL VALUES(68,'Scottish Longbreads',8,3,'10 boxes x 8 pieces',12.5E0,6,10,15,0)
  -INSERT INTO ARTIKEL VALUES(69,'Gudbrandsdalsost',15,4,'10 kg pkg.',36.0E0,26,0,15,0)
  -INSERT INTO ARTIKEL VALUES(70,'Outback Lager',7,1,'24 - 355 ml bottles',15.0E0,15,10,30,0)
  -INSERT INTO ARTIKEL VALUES(71,'Fl\u00f8temysost',15,4,'10 - 500 g pkgs.',21.5E0,26,0,0,0)
  -INSERT INTO ARTIKEL VALUES(72,'Mozzarella di Giovanni',14,4,'24 - 200 g pkgs.',34.8E0,14,0,0,0)
  -INSERT INTO ARTIKEL VALUES(73,'R\u00f6d Kaviar',17,8,'24 - 150 g jars',15.0E0,101,0,5,0)
  -INSERT INTO ARTIKEL VALUES(74,'Longlife Tofu',4,7,'5 kg pkg.',10.0E0,4,20,5,0)
  -INSERT INTO ARTIKEL VALUES(75,'Rh\u00f6nbr\u00e4u Klosterbier',12,1,'24 - 0.5 l bottles',7.75E0,125,0,25,0)
  -INSERT INTO ARTIKEL VALUES(76,'Lakkalik\u00f6\u00f6ri',23,1,'500 ml',18.0E0,57,0,20,0)
  -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(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)
  -INSERT INTO ORDER_POSITION VALUES(3,1,200)
  -INSERT INTO PERSON VALUES(1,'tom','tom')
  -INSERT INTO PERSON VALUES(2,'bob','bob')
  -INSERT INTO PERSON VALUES(3,'albert','albert')
  -INSERT INTO PERSON VALUES(4,'bertrand','bertrand')
  -INSERT INTO PERSON VALUES(5,'cindy','cindy')
  -INSERT INTO PERSON VALUES(6,'dorothy','dorothy')
  -INSERT INTO PERSON VALUES(7,'eugen','eugen')
  -INSERT INTO PERSON VALUES(8,'frido','frido')
  -INSERT INTO PERSON VALUES(9,'guido','guido')
  -INSERT INTO PERSON VALUES(10,'hank','hank')
  -INSERT INTO PROJECT VALUES(1,'OJB','OJB')
  -INSERT INTO PROJECT VALUES(2,'SODA','SODA')
  -INSERT INTO PROJECT VALUES(3,'HSQLDB','HSQLDB')
  -INSERT INTO PROJECT VALUES(4,'XERCES','XERCES')
  -INSERT INTO PROJECT VALUES(5,'Linux','Linux')
  -INSERT INTO PROJECT VALUES(6,'mySQL','mySQL')
  -INSERT INTO PERSON_PROJECT VALUES(1,1,'founder')
  -INSERT INTO PERSON_PROJECT VALUES(1,2,'friend')
  -INSERT INTO PERSON_PROJECT VALUES(2,1,'developer')
  -INSERT INTO PERSON_PROJECT VALUES(2,2,'lead')
  -INSERT INTO PERSON_PROJECT VALUES(2,3,'developer')
  -INSERT INTO PERSON_PROJECT VALUES(3,2,'tester')
  -INSERT INTO PERSON_PROJECT VALUES(3,4,'user')
  -INSERT INTO PERSON_PROJECT VALUES(3,5,'developer')
  -INSERT INTO PERSON_PROJECT VALUES(4,1,'developer')
  -INSERT INTO PERSON_PROJECT VALUES(5,2,'tester')
  -INSERT INTO PERSON_PROJECT VALUES(5,4,'lead')
  -INSERT INTO PERSON_PROJECT VALUES(7,4,'lead')
  -INSERT INTO PERSON_PROJECT VALUES(7,5,'founder')
  -INSERT INTO PERSON_PROJECT VALUES(7,6,'tester')
  -INSERT INTO TASK VALUES(1,2,1,'Initial Layout')
  -INSERT INTO TASK VALUES(2,2,1,'Initial Spec')
  -INSERT INTO TASK VALUES(3,2,2,'Project Cleanup')
  -INSERT INTO TASK VALUES(4,2,3,'Testing Scripts')
  -INSERT INTO CONV_REFERER VALUES(1,50,10)
  -INSERT INTO CONV_REFERER VALUES(2,51,11)
  -INSERT INTO CONV_REFERER VALUES(3,52,12)
  -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,'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')
  -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')
  -INSERT INTO SM_TAB_MAX_AA VALUES(101,'AA')
  -INSERT INTO SM_TAB_MAX_AA VALUES(102,'AA')
  -INSERT INTO SM_TAB_MAX_AB VALUES(99,'AB')
  -INSERT INTO SM_TAB_MAX_AAA VALUES(123,'AAA')
  -INSERT INTO SM_TAB_MAX_B VALUES(115,'B')
  -INSERT INTO SM_TAB_MAX_B VALUES(116,'B')
  -INSERT INTO SM_TAB_MAX_BB VALUES(130,'BB')
  -INSERT INTO SM_TAB_MAX_BB VALUES(131,'BB')
  +CREATE TABLE KATEGORIEN(KATEGORIE_NR INTEGER NOT NULL PRIMARY KEY,KATEGORIENAME VARCHAR(60),BESCHREIBUNG VARCHAR(60))
  +CREATE TABLE ARTIKEL(ARTIKEL_NR INTEGER NOT NULL PRIMARY KEY,ARTIKELNAME VARCHAR(60),LIEFERANTEN_NR INTEGER,KATEGORIE_NR INTEGER,LIEFEREINHEIT VARCHAR(30),EINZELPREIS FLOAT,LAGERBESTAND INTEGER,BESTELLTEEINHEITEN INTEGER,MINDESTBESTAND INTEGER,AUSLAUFARTIKEL INTEGER,CONSTRAINT ARTIKEL_FK_1 FOREIGN KEY(KATEGORIE_NR) REFERENCES KATEGORIEN(KATEGORIE_NR))
  +CREATE TABLE BOOKS(ARTIKEL_NR INTEGER NOT NULL PRIMARY KEY,ARTIKELNAME VARCHAR(60),LIEFERANTEN_NR INTEGER,KATEGORIE_NR INTEGER,LIEFEREINHEIT VARCHAR(30),EINZELPREIS FLOAT,LAGERBESTAND INTEGER,BESTELLTEEINHEITEN INTEGER,MINDESTBESTAND INTEGER,AUSLAUFARTIKEL INTEGER,ISBN VARCHAR(10),AUTHOR VARCHAR(50),CONSTRAINT BOOKS_FK_1 FOREIGN KEY(KATEGORIE_NR) REFERENCES KATEGORIEN(KATEGORIE_NR))
  +CREATE TABLE CDS(ARTIKEL_NR INTEGER NOT NULL PRIMARY KEY,ARTIKELNAME VARCHAR(60),LIEFERANTEN_NR INTEGER,KATEGORIE_NR INTEGER,LIEFEREINHEIT VARCHAR(30),EINZELPREIS FLOAT,LAGERBESTAND INTEGER,BESTELLTEEINHEITEN INTEGER,MINDESTBESTAND INTEGER,AUSLAUFARTIKEL INTEGER,LABEL VARCHAR(50),MUSICIANS VARCHAR(250),CONSTRAINT CDS_FK_1 FOREIGN KEY(KATEGORIE_NR) REFERENCES KATEGORIEN(KATEGORIE_NR))
  +CREATE TABLE ORDER_POSITION(ID INTEGER NOT NULL PRIMARY KEY,ORDER_ID INTEGER,ARTICLE_ID INTEGER)
  +CREATE TABLE TREE(ID INTEGER NOT NULL PRIMARY KEY,DATA VARCHAR(50),PARENT_ID INTEGER)
  +CREATE TABLE TREEGROUP(ID INTEGER NOT NULL PRIMARY KEY,DATA VARCHAR(50),PARENT_ID INTEGER,GROUP_ID INTEGER)
  +CREATE TABLE AB_TABLE(ID INTEGER NOT NULL PRIMARY KEY,CLASS_NAME VARCHAR(60),VALUE_ INTEGER,A_FIELD VARCHAR(60),B_FIELD VARCHAR(60))
  +CREATE TABLE PRODUCT(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100),PRICE FLOAT,STOCK INTEGER)
  +CREATE TABLE PERSON(ID INTEGER NOT NULL PRIMARY KEY,FIRSTNAME VARCHAR(50),LASTNAME VARCHAR(50))
  +CREATE TABLE PROJECT(ID INTEGER NOT NULL PRIMARY KEY,TITLE VARCHAR(50),DESCRIPTION VARCHAR(250))
  +CREATE TABLE PERSON_PROJECT(PERSON_ID INTEGER NOT NULL,PROJECT_ID INTEGER NOT NULL,ROLENAME VARCHAR(20),CONSTRAINT SYS_PK_PERSON_PROJECT PRIMARY KEY(PERSON_ID,PROJECT_ID),CONSTRAINT PERSON_PROJECT_FK_1 FOREIGN KEY(PERSON_ID) REFERENCES PERSON(ID),CONSTRAINT PERSON_PROJECT_FK_2 FOREIGN KEY(PROJECT_ID) REFERENCES PROJECT(ID))
  +CREATE TABLE TASK(TASK_ID INTEGER NOT NULL PRIMARY KEY,PERSON_ID INTEGER,PROJECT_ID INTEGER,TASKNAME VARCHAR(20),CONSTRAINT TASK_FK_1 FOREIGN KEY(PERSON_ID,PROJECT_ID) REFERENCES PERSON_PROJECT(PERSON_ID,PROJECT_ID))
  +CREATE TABLE FAMILY_MEMBER(ID INTEGER NOT NULL PRIMARY KEY,FIRSTNAME VARCHAR(50),LASTNAME VARCHAR(50),MOTHER_ID INTEGER,FATHER_ID INTEGER)
  +CREATE TABLE LOCKED_BY_VERSION(ID INTEGER NOT NULL PRIMARY KEY,VALUE_ VARCHAR(60),VERSION_ INTEGER)
  +CREATE TABLE LOCKED_BY_TIMESTAMP(ID INTEGER NOT NULL PRIMARY KEY,VALUE_ VARCHAR(60),TIMESTAMP_ TIMESTAMP)
  +CREATE TABLE BLOB_TEST(ID INTEGER NOT NULL PRIMARY KEY,BLOB_VALUE_ LONGVARBINARY,CLOB_VALUE_ VARCHAR)
  +CREATE TABLE MDTEST_MASTER(MASTERID INTEGER NOT NULL PRIMARY KEY,MASTER_TEXT VARCHAR(255))
  +CREATE TABLE MDTEST_DETAIL_FKINPK(MASTERID INTEGER NOT NULL,DETAILID INTEGER NOT NULL,DETAIL_TEXT VARCHAR(255),CONSTRAINT SYS_PK_MDTEST_DETAIL_FKINPK PRIMARY KEY(MASTERID,DETAILID),CONSTRAINT MDTEST_DETAIL_FKINPK_FK_1 FOREIGN KEY(MASTERID) REFERENCES MDTEST_MASTER(MASTERID))
  +CREATE TABLE MDTEST_DETAIL_FKNOPK(DETAILID INTEGER NOT NULL PRIMARY KEY,MASTERID INTEGER,DETAIL_TEXT VARCHAR(255),CONSTRAINT MDTEST_DETAIL_FKNOPK_FK_1 FOREIGN KEY(MASTERID) REFERENCES MDTEST_MASTER(MASTERID))
  +CREATE TABLE POINT_TABLE(ID INTEGER NOT NULL PRIMARY KEY,X INTEGER,Y INTEGER)
  +CREATE TABLE GRAPH_NODE(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(50),LOCATION INTEGER)
  +CREATE TABLE GRAPH_EDGE(ID INTEGER NOT NULL PRIMARY KEY,SOURCE INTEGER,SINK INTEGER)
  +CREATE TABLE TESTCLASSA(ID VARCHAR(48) NOT NULL PRIMARY KEY,VALUE1 VARCHAR(64),VALUE2 VARCHAR(64),VALUE3 INTEGER,BOID VARCHAR(48))
  +CREATE TABLE TESTCLASSB(ID VARCHAR(48) NOT NULL PRIMARY KEY,VALUE1 VARCHAR(64),AOID VARCHAR(48))
  +CREATE TABLE RELATEDTOCONTRACT(PK VARCHAR(48) NOT NULL PRIMARY KEY,RELATEDVALUE1 VARCHAR(64),RELATEDVALUE2 INTEGER,RELATEDVALUE3 TIMESTAMP)
  +CREATE TABLE CONTRACT(PK VARCHAR(48) NOT NULL PRIMARY KEY,FK_TO_RELATED VARCHAR(48),CONTRACT_VALUE1 VARCHAR(64),CONTRACT_VALUE2 INTEGER,CONTRACT_VALUE3 VARCHAR(64),CONTRACT_VALUE4 TIMESTAMP,CONSTRAINT CONTRACT_FK_1 FOREIGN KEY(FK_TO_RELATED) REFERENCES RELATEDTOCONTRACT(PK))
  +CREATE TABLE VERSION(PK VARCHAR(48) NOT NULL PRIMARY KEY,FK_TO_CONTRACT VARCHAR(48),VERSION_VALUE1 VARCHAR(64),VERSION_VALUE2 INTEGER,VERSION_VALUE3 TIMESTAMP,CONSTRAINT VERSION_FK_1 FOREIGN KEY(FK_TO_CONTRACT) REFERENCES CONTRACT(PK))
  +CREATE TABLE EFFECTIVENESS(PK VARCHAR(48) NOT NULL PRIMARY KEY,FK_TO_VERSION VARCHAR(48),EFF_VALUE1 VARCHAR(64),EFF_VALUE2 INTEGER,EFF_VALUE3 TIMESTAMP,CONSTRAINT EFFECTIVENESS_FK_1 FOREIGN KEY(FK_TO_VERSION) REFERENCES VERSION(PK))
  +CREATE TABLE MULTIMAPPEDTABLE(ID INTEGER NOT NULL PRIMARY KEY,VALUE1 VARCHAR(64),VALUE2 INTEGER,VALUE3 TIMESTAMP,VALUE4 VARCHAR(64),VALUE5 INTEGER,VALUE6 TIMESTAMP,VALUE7 VARCHAR(64),OJBCONCRETECLASS VARCHAR(64))
  +CREATE TABLE EXTENT_TEST_A(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100))
  +CREATE TABLE EXTENT_TEST_B(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100))
  +CREATE TABLE EXTENT_TEST_C(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100))
  +CREATE TABLE EXTENT_TEST_D(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100))
  +CREATE TABLE TABLE_1(PK INTEGER NOT NULL PRIMARY KEY,FK_TO_RELATED INTEGER)
  +CREATE TABLE TABLE_2(PK INTEGER NOT NULL PRIMARY KEY)
  +CREATE TABLE BIDIR_A(PK VARCHAR(48) NOT NULL PRIMARY KEY,FK_TO_B VARCHAR(48))
  +CREATE TABLE BIDIR_B(PK VARCHAR(48) NOT NULL PRIMARY KEY,FK_TO_A VARCHAR(48),CONSTRAINT BIDIR_B_FK_1 FOREIGN KEY(FK_TO_A) REFERENCES BIDIR_A(PK))
  +CREATE TABLE MAMMAL(ANIMALID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(60),AGE INTEGER,NUMLEGS INTEGER,ZOOID INTEGER)
  +CREATE TABLE REPTILE(ANIMALID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(60),AGE INTEGER,COLOR VARCHAR(60),ZOOID INTEGER)
  +CREATE TABLE ZOO(ZOOID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(60))
  +CREATE TABLE FISH(FOODID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(60),CALORIES INTEGER,TYPEOFWATER VARCHAR(60))
  +CREATE TABLE SALAD(FOODID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(60),CALORIES INTEGER,COLOR VARCHAR(60))
  +CREATE TABLE GOURMET(GOURMETID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(60))
  +CREATE TABLE GOURMET_FOOD(GOURMET_ID INTEGER NOT NULL,FOOD_ID INTEGER NOT NULL,CONSTRAINT SYS_PK_GOURMET_FOOD PRIMARY KEY(GOURMET_ID,FOOD_ID))
  +CREATE TABLE GUIDTEST(GUID_ VARCHAR(60) NOT NULL PRIMARY KEY,GUIDVALUE VARCHAR(60))
  +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 ODMG_DLIST(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100),RND_NAME VARCHAR(100))
  +CREATE TABLE ROLLBACK_ONE(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100),DESCRIPTION VARCHAR(100))
  +CREATE TABLE ROLLBACK_TWO(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100),DESCRIPTION VARCHAR(100))
  +CREATE TABLE NEWS(ID INTEGER NOT NULL PRIMARY KEY,HEADLINE 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))
  +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))
  +CREATE TABLE SM_TAB_AAA(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
  +CREATE TABLE SM_TAB_B(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
  +CREATE TABLE SM_TAB_BB(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
  +CREATE TABLE SM_SAME_TAB(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
  +CREATE TABLE SM_AUTO_NAMING(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
  +CREATE TABLE SM_TAB_MAX_A(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
  +CREATE TABLE SM_TAB_MAX_AA(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
  +CREATE TABLE SM_TAB_MAX_AB(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
  +CREATE TABLE SM_TAB_MAX_AAA(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
  +CREATE TABLE SM_TAB_MAX_B(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
  +CREATE TABLE SM_TAB_MAX_BB(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
  +CREATE TABLE SM_KEY(INT_KEY INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250),STRING_KEY VARCHAR(250),LONG_KEY BIGINT,INTEGER_KEY INTEGER)
  +CREATE TABLE SM_MT_TEST_A(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100))
  +CREATE TABLE SM_MT_TEST_B(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100))
  +CREATE TABLE EJB_CATEGORY(CATEGORY_ID INTEGER NOT NULL PRIMARY KEY,CATEGORY_NAME VARCHAR(80),DESCRIPTION VARCHAR(255))
  +CREATE TABLE EJB_ARTICLE(ARTICLE_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(80),PRICE DECIMAL,DESCRIPTION VARCHAR(255),CATEGORY_ID INTEGER)
  +CREATE TABLE EJB_PERSON(PERSON_ID INTEGER NOT NULL PRIMARY KEY,FIRST_NAME VARCHAR(80),LAST_NAME VARCHAR(80),GRADE VARCHAR(80))
  +CREATE TABLE FIELD_CONVERSION_NODE(NODE_ID DECIMAL(15) NOT NULL,NODE_STATE INTEGER NOT NULL,PARENT_UID DECIMAL(15),CONSTRAINT SYS_PK_FIELD_CONVERSION_NODE PRIMARY KEY(NODE_ID,NODE_STATE))
  +CREATE TABLE CONVERSION_VO(PK_WITH_AUTO INTEGER NOT NULL,PK_WITHOUT_AUTO INTEGER NOT NULL,NORMAL_WITH_AUTO INTEGER,NORMAL_WITHOUT_AUTO INTEGER,CONSTRAINT SYS_PK_CONVERSION_VO PRIMARY KEY(PK_WITH_AUTO,PK_WITHOUT_AUTO))
  +CREATE TABLE PERF_ARTICLE(ARTICLE_ID INTEGER NOT NULL PRIMARY KEY,ARTICLE_NAME VARCHAR(150),MINIMUM_STOCK INTEGER,PRICE DOUBLE,UNIT VARCHAR(20),STOCK INTEGER,SUPPLIER_ID INTEGER,PRODUCT_GROUP_ID INTEGER)
  +CREATE TABLE CACHE_TEST(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100))
  +CREATE TABLE REF_REPOSITORY(REP_ID INTEGER NOT NULL PRIMARY KEY,REF_FK INTEGER,REFA_FK INTEGER,REFB_FK INTEGER,ANIMAL_FK INTEGER,NAME VARCHAR(100))
  +CREATE TABLE REF_REPOSITORY_FK(REP_ID INTEGER NOT NULL,REF_FK INTEGER NOT NULL,REFA_FK INTEGER NOT NULL,REFB_FK INTEGER NOT NULL,NAME VARCHAR(100),CONSTRAINT SYS_PK_REF_REPOSITORY_FK PRIMARY KEY(REP_ID,REF_FK,REFA_FK,REFB_FK))
  +CREATE TABLE REF_REFERENCE(REF_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100),OJB_CONCRETE_CLASS VARCHAR(100),REF_NAME_A VARCHAR(100),REF_NAME_B VARCHAR(100))
  +CREATE TABLE REF_ANIMAL(A_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100),CLASS_NAME VARCHAR(100),LENGTH_ DOUBLE)
  +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_BASE(COL_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),GAT_ID INTEGER)
  +CREATE TABLE COLLECTION_COLLECTIBLE_B(COL_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),GAT_ID INTEGER)
  +CREATE TABLE COLLECTION_COLLECTIBLE_C(COL_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),GAT_ID INTEGER,EXTENT_NAME VARCHAR(150))
  +CREATE TABLE COLLECTION_COLLECTIBLE_D(COL_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),OJB_CONCRETE_CLASS VARCHAR(150),GAT_ID INTEGER)
  +CREATE TABLE READONLY_TEST(OBJ_ID DECIMAL NOT NULL PRIMARY KEY,NAME VARCHAR(150),RO_STRING VARCHAR(150),RO_LONG DECIMAL)
  +CREATE TABLE TABLE_E(ID INTEGER NOT NULL PRIMARY KEY,SOMESUPERVALUE INTEGER)
  +CREATE TABLE TABLE_F(ID INTEGER NOT NULL PRIMARY KEY,E_ID INTEGER,SOMEVALUE INTEGER,CONSTRAINT TABLE_F_FK_1 FOREIGN KEY(E_ID) REFERENCES TABLE_E(ID))
  +CREATE TABLE TABLE_G(ID INTEGER NOT NULL PRIMARY KEY,F_ID INTEGER,SOMESUBVALUE INTEGER,CONSTRAINT TABLE_G_FK_1 FOREIGN KEY(F_ID) REFERENCES TABLE_F(ID))
  +CREATE TABLE TABLE_F1(ID INTEGER NOT NULL PRIMARY KEY,SOMEVALUE INTEGER,CONSTRAINT TABLE_F1_FK_1 FOREIGN KEY(ID) REFERENCES TABLE_E(ID))
  +CREATE TABLE TABLE_G1(ID INTEGER NOT NULL PRIMARY KEY,SOMESUBVALUE INTEGER,CONSTRAINT TABLE_G1_FK_1 FOREIGN KEY(ID) REFERENCES TABLE_F1(ID))
  +CREATE TABLE ABSTRACT_COLLECTION_Z(OBJ_ID INTEGER NOT NULL PRIMARY KEY,CONTAINER_ID INTEGER,NAME VARCHAR(150),SOMEVALUE INTEGER)
  +CREATE TABLE ABSTRACT_COLLECTION_ZZ(OBJ_ID INTEGER NOT NULL PRIMARY KEY,CONTAINER_ID INTEGER,NAME VARCHAR(150),ZZ_NAME VARCHAR(150),SOMEVALUE INTEGER)
  +CREATE TABLE XCONTAINER(OBJ_ID INTEGER NOT NULL PRIMARY KEY)
  +CREATE TABLE NESTED_FIELDS_TAB(OBJ_ID DECIMAL NOT NULL PRIMARY KEY,NAME VARCHAR(150),NESTED_VALUE VARCHAR(150),NESTED_DESCRIPTION VARCHAR(150))
  +CREATE TABLE NESTED_FIELDS_ENTRY(OBJ_ID INTEGER NOT NULL PRIMARY KEY,FK_ID DECIMAL,NAME VARCHAR(150))
  +CREATE TABLE OTM_PERSON(ID INTEGER NOT NULL PRIMARY KEY,FIRSTNAME VARCHAR(60),LASTNAME VARCHAR(60),MAIN_ADDRESS_ID INTEGER)
  +CREATE TABLE OTM_ADDRESS(ID INTEGER NOT NULL PRIMARY KEY,COUNTRY VARCHAR(60),CITY VARCHAR(60),STREET VARCHAR(60))
  +CREATE TABLE OTM_ADDRESS_DESC(ID INTEGER NOT NULL PRIMARY KEY,DESCRIPTION VARCHAR(60),PERSON_ID INTEGER,ADDRESS_ID INTEGER)
  +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)
  +CREATE TABLE OJB_DLIST(ID INTEGER NOT NULL PRIMARY KEY,SIZE_ INTEGER)
  +CREATE TABLE OJB_DLIST_ENTRIES(ID INTEGER NOT NULL PRIMARY KEY,DLIST_ID INTEGER,POSITION_ INTEGER,OID_ LONGVARBINARY)
  +CREATE TABLE OJB_DSET(ID INTEGER NOT NULL PRIMARY KEY,SIZE_ INTEGER)
  +CREATE TABLE OJB_DSET_ENTRIES(ID INTEGER NOT NULL PRIMARY KEY,DLIST_ID INTEGER,POSITION_ INTEGER,OID_ LONGVARBINARY)
  +CREATE TABLE OJB_DMAP(ID INTEGER NOT NULL PRIMARY KEY,SIZE_ INTEGER)
  +CREATE TABLE OJB_DMAP_ENTRIES(ID INTEGER NOT NULL PRIMARY KEY,DMAP_ID INTEGER,KEY_OID BINARY,VALUE_OID BINARY)
  +ALTER TABLE TABLE_1 ADD CONSTRAINT TABLE_1_FK_1 FOREIGN KEY(FK_TO_RELATED) REFERENCES TABLE_2(PK)
  +ALTER TABLE BIDIR_A ADD CONSTRAINT BIDIR_A_FK_1 FOREIGN KEY(FK_TO_B) REFERENCES BIDIR_B(PK)
  +GRANT ALL ON CLASS "java.lang.Math" TO PUBLIC
  +GRANT ALL ON CLASS "org.hsqldb.Library" TO PUBLIC
  +CREATE USER SA PASSWORD "" ADMIN
  +CREATE ALIAS DAYNAME FOR "org.hsqldb.Library.dayname"
  +CREATE ALIAS SPACE FOR "org.hsqldb.Library.space"
  +CREATE ALIAS SUBSTRING FOR "org.hsqldb.Library.substring"
  +CREATE ALIAS HEXTORAW FOR "org.hsqldb.Library.hexToRaw"
  +CREATE ALIAS SQRT FOR "java.lang.Math.sqrt"
  +CREATE ALIAS ABS FOR "org.hsqldb.Library.abs"
  +CREATE ALIAS POWER FOR "java.lang.Math.pow"
  +CREATE ALIAS CHAR FOR "org.hsqldb.Library.character"
  +CREATE ALIAS CONCAT FOR "org.hsqldb.Library.concat"
  +CREATE ALIAS PI FOR "org.hsqldb.Library.pi"
  +CREATE ALIAS RAWTOHEX FOR "org.hsqldb.Library.rawToHex"
  +CREATE ALIAS SECOND FOR "org.hsqldb.Library.second"
  +CREATE ALIAS TRUNCATE FOR "org.hsqldb.Library.truncate"
  +CREATE ALIAS MONTH FOR "org.hsqldb.Library.month"
  +CREATE ALIAS LOWER FOR "org.hsqldb.Library.lcase"
  +CREATE ALIAS ATAN2 FOR "java.lang.Math.atan2"
  +CREATE ALIAS REPEAT FOR "org.hsqldb.Library.repeat"
  +CREATE ALIAS DAYOFMONTH FOR "org.hsqldb.Library.dayofmonth"
  +CREATE ALIAS TAN FOR "java.lang.Math.tan"
  +CREATE ALIAS RADIANS FOR "java.lang.Math.toRadians"
  +CREATE ALIAS FLOOR FOR "java.lang.Math.floor"
  +CREATE ALIAS NOW FOR "org.hsqldb.Library.now"
  +CREATE ALIAS ACOS FOR "java.lang.Math.acos"
  +CREATE ALIAS DAYOFWEEK FOR "org.hsqldb.Library.dayofweek"
  +CREATE ALIAS CEILING FOR "java.lang.Math.ceil"
  +CREATE ALIAS DAYOFYEAR FOR "org.hsqldb.Library.dayofyear"
  +CREATE ALIAS LCASE FOR "org.hsqldb.Library.lcase"
  +CREATE ALIAS WEEK FOR "org.hsqldb.Library.week"
  +CREATE ALIAS SOUNDEX FOR "org.hsqldb.Library.soundex"
  +CREATE ALIAS ASIN FOR "java.lang.Math.asin"
  +CREATE ALIAS LOCATE FOR "org.hsqldb.Library.locate"
  +CREATE ALIAS EXP FOR "java.lang.Math.exp"
  +CREATE ALIAS MONTHNAME FOR "org.hsqldb.Library.monthname"
  +CREATE ALIAS YEAR FOR "org.hsqldb.Library.year"
  +CREATE ALIAS LEFT FOR "org.hsqldb.Library.left"
  +CREATE ALIAS ROUNDMAGIC FOR "org.hsqldb.Library.roundMagic"
  +CREATE ALIAS BITOR FOR "org.hsqldb.Library.bitor"
  +CREATE ALIAS LTRIM FOR "org.hsqldb.Library.ltrim"
  +CREATE ALIAS COT FOR "org.hsqldb.Library.cot"
  +CREATE ALIAS COS FOR "java.lang.Math.cos"
  +CREATE ALIAS MOD FOR "org.hsqldb.Library.mod"
  +CREATE ALIAS SIGN FOR "org.hsqldb.Library.sign"
  +CREATE ALIAS DEGREES FOR "java.lang.Math.toDegrees"
  +CREATE ALIAS LOG FOR "java.lang.Math.log"
  +CREATE ALIAS SIN FOR "java.lang.Math.sin"
  +CREATE ALIAS CURTIME FOR "org.hsqldb.Library.curtime"
  +CREATE ALIAS DIFFERENCE FOR "org.hsqldb.Library.difference"
  +CREATE ALIAS INSERT FOR "org.hsqldb.Library.insert"
  +CREATE ALIAS SUBSTR FOR "org.hsqldb.Library.substring"
  +CREATE ALIAS DATABASE FOR "org.hsqldb.Library.database"
  +CREATE ALIAS MINUTE FOR "org.hsqldb.Library.minute"
  +CREATE ALIAS HOUR FOR "org.hsqldb.Library.hour"
  +CREATE ALIAS IDENTITY FOR "org.hsqldb.Library.identity"
  +CREATE ALIAS QUARTER FOR "org.hsqldb.Library.quarter"
  +CREATE ALIAS CURDATE FOR "org.hsqldb.Library.curdate"
  +CREATE ALIAS BITAND FOR "org.hsqldb.Library.bitand"
  +CREATE ALIAS USER FOR "org.hsqldb.Library.user"
  +CREATE ALIAS UCASE FOR "org.hsqldb.Library.ucase"
  +CREATE ALIAS RTRIM FOR "org.hsqldb.Library.rtrim"
  +CREATE ALIAS LOG10 FOR "org.hsqldb.Library.log10"
  +CREATE ALIAS RIGHT FOR "org.hsqldb.Library.right"
  +CREATE ALIAS ATAN FOR "java.lang.Math.atan"
  +CREATE ALIAS UPPER FOR "org.hsqldb.Library.ucase"
  +CREATE ALIAS ASCII FOR "org.hsqldb.Library.ascii"
  +CREATE ALIAS RAND FOR "java.lang.Math.random"
  +CREATE ALIAS LENGTH FOR "org.hsqldb.Library.length"
  +CREATE ALIAS ROUND FOR "org.hsqldb.Library.round"
  +CREATE ALIAS REPLACE FOR "org.hsqldb.Library.replace"
  +INSERT INTO KATEGORIEN VALUES(1,'Beverages','Alles leckere zum S\u00fcffeln')
  +INSERT INTO KATEGORIEN VALUES(2,'Spices','Gew\u00fcrze, Dressings etc.')
  +INSERT INTO KATEGORIEN VALUES(3,'Meat','')
  +INSERT INTO KATEGORIEN VALUES(4,'Liquors','')
  +INSERT INTO KATEGORIEN VALUES(5,'Books','Strange Books...')
  +INSERT INTO KATEGORIEN VALUES(6,'bread','')
  +INSERT INTO KATEGORIEN VALUES(7,'Fruits','Fr\u00fcchte etc.')
  +INSERT INTO KATEGORIEN VALUES(8,'Dairy Products','Kat 8')
  +INSERT INTO ARTIKEL VALUES(1,'Chai',1,1,'10 boxes x 20 bags',18.53E0,39,0,10,0)
  +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\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)
  +INSERT INTO ARTIKEL VALUES(11,'Queso Cabrales',5,4,'1 kg pkg.',21.0E0,22,30,30,0)
  +INSERT INTO ARTIKEL VALUES(12,'Queso Manchego La Pastora',5,4,'10 - 500 g pkgs.',38.0E0,86,0,0,0)
  +INSERT INTO ARTIKEL VALUES(13,'Konbu',6,8,'2 kg box',6.0E0,24,0,5,0)
  +INSERT INTO ARTIKEL VALUES(14,'Tofu',6,7,'40 - 100 g pkgs.',23.25E0,35,0,0,0)
  +INSERT INTO ARTIKEL VALUES(15,'Genen Shouyu',6,2,'24 - 250 ml bottles',15.5E0,39,0,5,0)
  +INSERT INTO ARTIKEL VALUES(16,'Pavlova',7,3,'32 - 500 g boxes',17.45E0,29,0,10,0)
  +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\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)
  +INSERT INTO ARTIKEL VALUES(26,'Gumb\u00e4r Gummib\u00e4rchen',11,3,'100 - 250 g bags',31.23E0,15,0,0,0)
  +INSERT INTO ARTIKEL VALUES(27,'Schoggi Schokolade',11,3,'100 - 100 g pieces',43.9E0,49,0,30,0)
  +INSERT INTO ARTIKEL VALUES(28,'R\u00f6ssle Sauerkraut',12,7,'25 - 825 g cans',45.6E0,26,0,0,1)
  +INSERT INTO ARTIKEL VALUES(29,'Th\u00fcringer Rostbratwurst',12,6,'50 bags x 30 sausgs.',123.79E0,0,0,0,1)
  +INSERT INTO ARTIKEL VALUES(30,'Nord-Ost Matjeshering',13,8,'10 - 200 g glasses',25.89E0,10,0,15,0)
  +INSERT INTO ARTIKEL VALUES(31,'Gorgonzola Telino',14,4,'12 - 100 g pkgs',12.5E0,0,70,20,0)
  +INSERT INTO ARTIKEL VALUES(32,'Mascarpone Fabioli',14,4,'24 - 200 g pkgs.',32.0E0,9,40,25,0)
  +INSERT INTO ARTIKEL VALUES(33,'Geitost',15,4,'500 g',2.5E0,112,0,20,0)
  +INSERT INTO ARTIKEL VALUES(34,'Sasquatch Ale',16,1,'24 - 12 oz bottles',14.0E0,111,0,15,0)
  +INSERT INTO ARTIKEL VALUES(35,'Steeleye Stout',16,1,'24 - 12 oz bottles',18.0E0,20,0,15,0)
  +INSERT INTO ARTIKEL VALUES(36,'Inlagd Sill',17,8,'24 - 250 g  jars',19.0E0,112,0,20,0)
  +INSERT INTO ARTIKEL VALUES(37,'Gravad lax',17,8,'12 - 500 g pkgs.',26.0E0,11,50,25,0)
  +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\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)
  +INSERT INTO ARTIKEL VALUES(45,'R\u00f8gede sild',21,8,'1k pkg.',9.5E0,5,70,15,0)
  +INSERT INTO ARTIKEL VALUES(46,'Spegesild',21,8,'4 - 450 g glasses',12.0E0,95,0,0,0)
  +INSERT INTO ARTIKEL VALUES(47,'Zaanse koeken',22,3,'10 - 4 oz boxes',9.5E0,36,0,0,0)
  +INSERT INTO ARTIKEL VALUES(48,'Chocolade',22,3,'10 pkgs.',12.75E0,15,70,25,0)
  +INSERT INTO ARTIKEL VALUES(49,'Maxilaku',23,3,'24 - 50 g pkgs.',20.0E0,10,60,15,0)
  +INSERT INTO ARTIKEL VALUES(50,'Valkoinen suklaa',23,3,'12 - 100 g bars',16.25E0,65,0,30,0)
  +INSERT INTO ARTIKEL VALUES(51,'Manjimup Dried Apples',24,7,'50 - 300 g pkgs.',53.0E0,20,0,10,0)
  +INSERT INTO ARTIKEL VALUES(52,'Filo Mix',24,5,'16 - 2 kg boxes',7.0E0,38,0,25,0)
  +INSERT INTO ARTIKEL VALUES(53,'Perth Pasties',24,6,'48 pieces',32.8E0,0,0,0,1)
  +INSERT INTO ARTIKEL VALUES(54,'Tourti\u00e8re',25,6,'16 pies',7.45E0,21,0,10,0)
  +INSERT INTO ARTIKEL VALUES(55,'P\u00e2t\u00e9 chinois',25,6,'24 boxes x 2 pies',24.0E0,115,0,20,0)
  +INSERT INTO ARTIKEL VALUES(56,'Gnocchi di nonna Alice',26,5,'24 - 250 g pkgs.',38.0E0,21,10,30,0)
  +INSERT INTO ARTIKEL VALUES(57,'Ravioli Angelo',26,5,'24 - 250 g pkgs.',19.5E0,36,0,20,0)
  +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\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)
  +INSERT INTO ARTIKEL VALUES(65,'Louisiana Fiery Hot Pepper Sauce',2,2,'32 - 8 oz bottles',21.05E0,76,0,0,0)
  +INSERT INTO ARTIKEL VALUES(66,'Louisiana Hot Spiced Okra',2,2,'24 - 8 oz jars',17.0E0,4,100,20,0)
  +INSERT INTO ARTIKEL VALUES(67,'Laughing Lumberjack Lager',16,1,'24 - 12 oz bottles',14.0E0,52,0,10,0)
  +INSERT INTO ARTIKEL VALUES(68,'Scottish Longbreads',8,3,'10 boxes x 8 pieces',12.5E0,6,10,15,0)
  +INSERT INTO ARTIKEL VALUES(69,'Gudbrandsdalsost',15,4,'10 kg pkg.',36.0E0,26,0,15,0)
  +INSERT INTO ARTIKEL VALUES(70,'Outback Lager',7,1,'24 - 355 ml bottles',15.0E0,15,10,30,0)
  +INSERT INTO ARTIKEL VALUES(71,'Fl\u00f8temysost',15,4,'10 - 500 g pkgs.',21.5E0,26,0,0,0)
  +INSERT INTO ARTIKEL VALUES(72,'Mozzarella di Giovanni',14,4,'24 - 200 g pkgs.',34.8E0,14,0,0,0)
  +INSERT INTO ARTIKEL VALUES(73,'R\u00f6d Kaviar',17,8,'24 - 150 g jars',15.0E0,101,0,5,0)
  +INSERT INTO ARTIKEL VALUES(74,'Longlife Tofu',4,7,'5 kg pkg.',10.0E0,4,20,5,0)
  +INSERT INTO ARTIKEL VALUES(75,'Rh\u00f6nbr\u00e4u Klosterbier',12,1,'24 - 0.5 l bottles',7.75E0,125,0,25,0)
  +INSERT INTO ARTIKEL VALUES(76,'Lakkalik\u00f6\u00f6ri',23,1,'500 ml',18.0E0,57,0,20,0)
  +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\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)
  +INSERT INTO ORDER_POSITION VALUES(3,1,200)
  +INSERT INTO PERSON VALUES(1,'tom','tom')
  +INSERT INTO PERSON VALUES(2,'bob','bob')
  +INSERT INTO PERSON VALUES(3,'albert','albert')
  +INSERT INTO PERSON VALUES(4,'bertrand','bertrand')
  +INSERT INTO PERSON VALUES(5,'cindy','cindy')
  +INSERT INTO PERSON VALUES(6,'dorothy','dorothy')
  +INSERT INTO PERSON VALUES(7,'eugen','eugen')
  +INSERT INTO PERSON VALUES(8,'frido','frido')
  +INSERT INTO PERSON VALUES(9,'guido','guido')
  +INSERT INTO PERSON VALUES(10,'hank','hank')
  +INSERT INTO PROJECT VALUES(1,'OJB','OJB')
  +INSERT INTO PROJECT VALUES(2,'SODA','SODA')
  +INSERT INTO PROJECT VALUES(3,'HSQLDB','HSQLDB')
  +INSERT INTO PROJECT VALUES(4,'XERCES','XERCES')
  +INSERT INTO PROJECT VALUES(5,'Linux','Linux')
  +INSERT INTO PROJECT VALUES(6,'mySQL','mySQL')
  +INSERT INTO PERSON_PROJECT VALUES(1,1,'founder')
  +INSERT INTO PERSON_PROJECT VALUES(1,2,'friend')
  +INSERT INTO PERSON_PROJECT VALUES(2,1,'developer')
  +INSERT INTO PERSON_PROJECT VALUES(2,2,'lead')
  +INSERT INTO PERSON_PROJECT VALUES(2,3,'developer')
  +INSERT INTO PERSON_PROJECT VALUES(3,2,'tester')
  +INSERT INTO PERSON_PROJECT VALUES(3,4,'user')
  +INSERT INTO PERSON_PROJECT VALUES(3,5,'developer')
  +INSERT INTO PERSON_PROJECT VALUES(4,1,'developer')
  +INSERT INTO PERSON_PROJECT VALUES(5,2,'tester')
  +INSERT INTO PERSON_PROJECT VALUES(5,4,'lead')
  +INSERT INTO PERSON_PROJECT VALUES(7,4,'lead')
  +INSERT INTO PERSON_PROJECT VALUES(7,5,'founder')
  +INSERT INTO PERSON_PROJECT VALUES(7,6,'tester')
  +INSERT INTO TASK VALUES(1,2,1,'Initial Layout')
  +INSERT INTO TASK VALUES(2,2,1,'Initial Spec')
  +INSERT INTO TASK VALUES(3,2,2,'Project Cleanup')
  +INSERT INTO TASK VALUES(4,2,3,'Testing Scripts')
  +INSERT INTO CONV_REFERER VALUES(1,50,10)
  +INSERT INTO CONV_REFERER VALUES(2,51,11)
  +INSERT INTO CONV_REFERER VALUES(3,52,12)
  +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,'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')
  +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')
  +INSERT INTO SM_TAB_MAX_AA VALUES(101,'AA')
  +INSERT INTO SM_TAB_MAX_AA VALUES(102,'AA')
  +INSERT INTO SM_TAB_MAX_AB VALUES(99,'AB')
  +INSERT INTO SM_TAB_MAX_AAA VALUES(123,'AAA')
  +INSERT INTO SM_TAB_MAX_B VALUES(115,'B')
  +INSERT INTO SM_TAB_MAX_B VALUES(116,'B')
  +INSERT INTO SM_TAB_MAX_BB VALUES(130,'BB')
  +INSERT INTO SM_TAB_MAX_BB VALUES(131,'BB')
  
  
  

---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org


Mime
View raw message