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 ar...@apache.org on 2004/06/14 14:27:15 UTC
cvs commit: db-ojb/src/test/org/apache/ojb/quick-db OJB.properties OJB.script
arminw 2004/06/14 05:27:15
Modified: src/test/org/apache/ojb/quick-db OJB.properties OJB.script
Log:
update quick db scripts
Revision Changes Path
1.32 +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.31
retrieving revision 1.32
diff -u -r1.31 -r1.32
--- OJB.properties 22 Mar 2004 08:12:09 -0000 1.31
+++ OJB.properties 14 Jun 2004 12:27:15 -0000 1.32
@@ -1,5 +1,5 @@
#HSQL database
-#Sun Mar 21 12:26:00 CET 2004
+#Mon Jun 14 14:19:11 CEST 2004
sql.strict_fk=true
readonly=false
sql.strong_fk=true
1.32 +406 -378 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.31
retrieving revision 1.32
diff -u -r1.31 -r1.32
--- OJB.script 22 Mar 2004 08:12:09 -0000 1.31
+++ OJB.script 14 Jun 2004 12:27:15 -0000 1.32
@@ -1,378 +1,406 @@
-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(15,2),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 BATCH_MAIN_OBJ(OBJ_ID BIGINT NOT NULL PRIMARY KEY,NAME VARCHAR(100))
-CREATE TABLE BATCH_SUB_OBJ(OBJ_ID BIGINT NOT NULL PRIMARY KEY,FK_MAIN_ID BIGINT,NAME VARCHAR(100),CONSTRAINT BATCH_SUB_OBJ_FK_1 FOREIGN KEY(FK_MAIN_ID) REFERENCES BATCH_MAIN_OBJ(OBJ_ID))
-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 REF_WINE(OBJ_ID VARCHAR(100) NOT NULL PRIMARY KEY,REGION_NAME VARCHAR(100),REGION_COUNTRY VARCHAR(100),VINTAGE VARCHAR(100),GRAPE VARCHAR(100))
-CREATE TABLE REF_REGION(NAME VARCHAR(100) NOT NULL,COUNTRY VARCHAR(100) NOT NULL,DESCRIPTION VARCHAR(100),CONSTRAINT SYS_PK_REF_REGION PRIMARY KEY(NAME,COUNTRY))
-CREATE TABLE READTEST_ACCOUNT(OJB_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100),FK_REF INTEGER)
-CREATE TABLE READTEST_BUYER(OJB_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100),FK_REF INTEGER)
-CREATE TABLE READTEST_ADDRESS(OJB_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100),FK_REF INTEGER)
-CREATE TABLE READTEST_ADDRESS_TYPE(OJB_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100),FK_REF INTEGER)
-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,CONSTRAINT COLLECTION_COLLECTIBLE_A_FK_1 FOREIGN KEY(GAT_ID) REFERENCES COLLECTION_GATHERER(GAT_ID))
-CREATE TABLE COLLECTION_COLLECTIBLE_BASE(COL_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),GAT_ID INTEGER,CONSTRAINT COLLECTION_COLLECTIBLE_BASE_FK_1 FOREIGN KEY(GAT_ID) REFERENCES COLLECTION_GATHERER(GAT_ID))
-CREATE TABLE COLLECTION_COLLECTIBLE_B(COL_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),GAT_ID INTEGER,CONSTRAINT COLLECTION_COLLECTIBLE_B_FK_1 FOREIGN KEY(GAT_ID) REFERENCES COLLECTION_GATHERER(GAT_ID))
-CREATE TABLE COLLECTION_COLLECTIBLE_C(COL_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),GAT_ID INTEGER,EXTENT_NAME VARCHAR(150),CONSTRAINT COLLECTION_COLLECTIBLE_C_FK_1 FOREIGN KEY(GAT_ID) REFERENCES COLLECTION_GATHERER(GAT_ID))
-CREATE TABLE COLLECTION_COLLECTIBLE_CC(COL_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),GAT_ID INTEGER,EXTENT_NAME VARCHAR(150),CONSTRAINT COLLECTION_COLLECTIBLE_CC_FK_1 FOREIGN KEY(GAT_ID) REFERENCES COLLECTION_GATHERER(GAT_ID))
-CREATE TABLE COLLECTION_COLLECTIBLE_CCC(COL_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),GAT_ID INTEGER,EXTENT_NAME VARCHAR(150),CONSTRAINT COLLECTION_COLLECTIBLE_CCC_FK_1 FOREIGN KEY(GAT_ID) REFERENCES COLLECTION_GATHERER(GAT_ID))
-CREATE TABLE COLLECTION_COLLECTIBLE_D(COL_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),OJB_CONCRETE_CLASS VARCHAR(150),GAT_ID INTEGER,CONSTRAINT COLLECTION_COLLECTIBLE_D_FK_1 FOREIGN KEY(GAT_ID) REFERENCES COLLECTION_GATHERER(GAT_ID))
-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 COL_BOOKSHELFS(PK INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100))
-CREATE TABLE COL_BOOKS(PK INTEGER NOT NULL,BOOKSHELF_FK INTEGER NOT NULL,CONSTRAINT SYS_PK_COL_BOOKS PRIMARY KEY(PK,BOOKSHELF_FK))
-CREATE TABLE COL_DVDS(PK INTEGER NOT NULL,BOOKSHELF_FK INTEGER NOT NULL,CONSTRAINT SYS_PK_COL_DVDS PRIMARY KEY(PK,BOOKSHELF_FK))
-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 TAB_COMPONENT(PK_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),PARENT_ID INTEGER,CHILD_ID INTEGER,GROUP_ID INTEGER)
-CREATE TABLE TAB_GROUP(PK_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150))
-CREATE TABLE MULTIPLE_OBJECT(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150))
-CREATE TABLE LOCK_MULTI(OJB_ID INTEGER NOT NULL PRIMARY KEY,VERSION INTEGER,REF_ID INTEGER,NAME VARCHAR(250))
-CREATE TABLE LOCK_MULTI_REF(OJB_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250),VERSION INTEGER)
-CREATE TABLE CRT_EMPLOYEE(EMPLOYEE_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150))
-CREATE TABLE CRT_MEMBER(ROLE_ID INTEGER NOT NULL PRIMARY KEY,EMPLOYEE_ID INTEGER,NAME VARCHAR(150),CONSTRAINT CRT_MEMBER_FK_1 FOREIGN KEY(EMPLOYEE_ID) REFERENCES CRT_EMPLOYEE(EMPLOYEE_ID))
-CREATE TABLE CRT_LEADER(ROLE_ID INTEGER NOT NULL PRIMARY KEY,EMPLOYEE_ID INTEGER,NAME VARCHAR(150),CONSTRAINT CRT_LEADER_FK_1 FOREIGN KEY(EMPLOYEE_ID) REFERENCES CRT_EMPLOYEE(EMPLOYEE_ID))
-CREATE TABLE CRT_PROJECT(PROJECT_ID INTEGER NOT NULL PRIMARY KEY,ENGINEER_ID INTEGER,NAME VARCHAR(150),CONSTRAINT CRT_PROJECT_FK_1 FOREIGN KEY(ENGINEER_ID) REFERENCES CRT_LEADER(ROLE_ID))
-CREATE TABLE CRT_SUB_PROJECT(SUB_ID INTEGER NOT NULL PRIMARY KEY,PROJECT_ID INTEGER,TUTOR_ID INTEGER,NAME VARCHAR(150),CONSTRAINT CRT_SUB_PROJECT_FK_1 FOREIGN KEY(PROJECT_ID) REFERENCES CRT_PROJECT(PROJECT_ID),CONSTRAINT CRT_SUB_PROJECT_FK_2 FOREIGN KEY(TUTOR_ID) REFERENCES CRT_MEMBER(ROLE_ID))
-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,CONSTRAINT OTM_ADDRESS_DESC_FK_1 FOREIGN KEY(ADDRESS_ID) REFERENCES OTM_ADDRESS(ID),CONSTRAINT OTM_ADDRESS_DESC_FK_2 FOREIGN KEY(PERSON_ID) REFERENCES OTM_PERSON(ID))
-CREATE TABLE OTM_PERSON2(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(60))
-CREATE TABLE OTM_PERSON3(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(60))
-CREATE TABLE OTM_ADDRESS2(ID INTEGER NOT NULL PRIMARY KEY,PERSON_ID INTEGER)
-CREATE TABLE OTM_DEBITOR(ID INTEGER NOT NULL PRIMARY KEY,PERSON_ID INTEGER)
-CREATE TABLE OJB_HL_SEQ(TABLENAME VARCHAR(175) NOT NULL,FIELDNAME VARCHAR(70) NOT NULL,MAX_KEY BIGINT,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)
-ALTER TABLE MAMMAL ADD CONSTRAINT MAMMAL_FK_1 FOREIGN KEY(ZOOID) REFERENCES ZOO(ZOOID)
-ALTER TABLE REPTILE ADD CONSTRAINT REPTILE_FK_1 FOREIGN KEY(ZOOID) REFERENCES ZOO(ZOOID)
-ALTER TABLE REF_WINE ADD CONSTRAINT REF_WINE_FK_1 FOREIGN KEY(REGION_NAME,REGION_COUNTRY) REFERENCES REF_REGION(NAME,COUNTRY)
-ALTER TABLE OTM_PERSON ADD CONSTRAINT OTM_PERSON_FK_1 FOREIGN KEY(MAIN_ADDRESS_ID) REFERENCES OTM_ADDRESS(ID)
-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')
+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 AUTO_INCREMENT(INT_ID INTEGER,INTEGER_ID INTEGER,STR_ID VARCHAR(255))
+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(15,2),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 NUMBER_ACCURACY_TEST(OBJ_ID INTEGER NOT NULL PRIMARY KEY,SCALE_TWO DECIMAL(15,6),SCALE_FOUR DECIMAL(15,6))
+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 BATCH_MAIN_OBJ(OBJ_ID BIGINT NOT NULL PRIMARY KEY,NAME VARCHAR(100))
+CREATE TABLE BATCH_SUB_OBJ(OBJ_ID BIGINT NOT NULL PRIMARY KEY,FK_MAIN_ID BIGINT,NAME VARCHAR(100),CONSTRAINT BATCH_SUB_OBJ_FK_1 FOREIGN KEY(FK_MAIN_ID) REFERENCES BATCH_MAIN_OBJ(OBJ_ID))
+CREATE TABLE CACHE_TEST(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100))
+CREATE TABLE LOCAL_CACHE_TEST(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100),FK_FATHER INTEGER,FK_GRANDFATHER INTEGER,FK_CHILD INTEGER,FK_GRANDCHILD INTEGER)
+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 REF_WINE(OBJ_ID VARCHAR(100) NOT NULL PRIMARY KEY,REGION_NAME VARCHAR(150),REGION_COUNTRY VARCHAR(150),VINTAGE VARCHAR(150),GRAPE VARCHAR(150))
+CREATE TABLE REF_REGION(NAME VARCHAR(150) NOT NULL,COUNTRY VARCHAR(150) NOT NULL,DESCRIPTION VARCHAR(150),CONSTRAINT SYS_PK_REF_REGION PRIMARY KEY(NAME,COUNTRY))
+CREATE TABLE REF_OBJ_A(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),FK_REF INTEGER)
+CREATE TABLE REF_OBJ_B(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),FK_REF INTEGER)
+CREATE TABLE REF_OBJ_C(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),FK_REF INTEGER)
+CREATE TABLE PKFK_PERSON(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150))
+CREATE TABLE PKFK_PERSON_DETAIL(OBJ_ID INTEGER NOT NULL PRIMARY KEY,PROFILE VARCHAR(150),FK_GENDER VARCHAR(150))
+CREATE TABLE PKFK_GENDER(TYPE VARCHAR(150) NOT NULL PRIMARY KEY)
+CREATE TABLE READTEST_ACCOUNT(OJB_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),FK_REF INTEGER)
+CREATE TABLE READTEST_BUYER(OJB_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),FK_REF INTEGER)
+CREATE TABLE READTEST_ADDRESS(OJB_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),FK_REF INTEGER)
+CREATE TABLE READTEST_ADDRESS_TYPE(OJB_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),FK_REF INTEGER)
+CREATE TABLE M2N_TEST_ACTOR(OBJ_ID INTEGER NOT NULL,OBJ_ID2 INTEGER NOT NULL,NAME VARCHAR(150),CONSTRAINT SYS_PK_M2N_TEST_ACTOR PRIMARY KEY(OBJ_ID,OBJ_ID2))
+CREATE TABLE M2N_TEST_MOVIE(OBJ_ID_INT INTEGER NOT NULL,OBJ_ID2_INT INTEGER NOT NULL,OBJ_ID_STR VARCHAR(150) NOT NULL,TITLE VARCHAR(150),DESCRIPTION VARCHAR(250),CONSTRAINT SYS_PK_M2N_TEST_MOVIE PRIMARY KEY(OBJ_ID_INT,OBJ_ID2_INT,OBJ_ID_STR))
+CREATE TABLE M2N_TEST_ROLE(ACTOR_ID INTEGER NOT NULL,ACTOR_ID2 INTEGER NOT NULL,MOVIE_ID_INT INTEGER NOT NULL,MOVIE_ID2_INT INTEGER NOT NULL,MOVIE_ID_STR VARCHAR(150) NOT NULL,CONSTRAINT SYS_PK_M2N_TEST_ROLE PRIMARY KEY(ACTOR_ID,ACTOR_ID2,MOVIE_ID_INT,MOVIE_ID2_INT,MOVIE_ID_STR),CONSTRAINT M2N_TEST_ROLE_FK_1 FOREIGN KEY(ACTOR_ID,ACTOR_ID2) REFERENCES M2N_TEST_ACTOR(OBJ_ID,OBJ_ID2),CONSTRAINT M2N_TEST_ROLE_FK_2 FOREIGN KEY(MOVIE_ID_INT,MOVIE_ID2_INT,MOVIE_ID_STR) REFERENCES M2N_TEST_MOVIE(OBJ_ID_INT,OBJ_ID2_INT,OBJ_ID_STR))
+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,CONSTRAINT COLLECTION_COLLECTIBLE_A_FK_1 FOREIGN KEY(GAT_ID) REFERENCES COLLECTION_GATHERER(GAT_ID))
+CREATE TABLE COLLECTION_COLLECTIBLE_BASE(COL_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),GAT_ID INTEGER,CONSTRAINT COLLECTION_COLLECTIBLE_BASE_FK_1 FOREIGN KEY(GAT_ID) REFERENCES COLLECTION_GATHERER(GAT_ID))
+CREATE TABLE COLLECTION_COLLECTIBLE_B(COL_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),GAT_ID INTEGER,CONSTRAINT COLLECTION_COLLECTIBLE_B_FK_1 FOREIGN KEY(GAT_ID) REFERENCES COLLECTION_GATHERER(GAT_ID))
+CREATE TABLE COLLECTION_COLLECTIBLE_C(COL_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),GAT_ID INTEGER,EXTENT_NAME VARCHAR(150),CONSTRAINT COLLECTION_COLLECTIBLE_C_FK_1 FOREIGN KEY(GAT_ID) REFERENCES COLLECTION_GATHERER(GAT_ID))
+CREATE TABLE COLLECTION_COLLECTIBLE_CC(COL_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),GAT_ID INTEGER,EXTENT_NAME VARCHAR(150),CONSTRAINT COLLECTION_COLLECTIBLE_CC_FK_1 FOREIGN KEY(GAT_ID) REFERENCES COLLECTION_GATHERER(GAT_ID))
+CREATE TABLE COLLECTION_COLLECTIBLE_CCC(COL_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),GAT_ID INTEGER,EXTENT_NAME VARCHAR(150),CONSTRAINT COLLECTION_COLLECTIBLE_CCC_FK_1 FOREIGN KEY(GAT_ID) REFERENCES COLLECTION_GATHERER(GAT_ID))
+CREATE TABLE COLLECTION_COLLECTIBLE_D(COL_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),OJB_CONCRETE_CLASS VARCHAR(150),GAT_ID INTEGER,CONSTRAINT COLLECTION_COLLECTIBLE_D_FK_1 FOREIGN KEY(GAT_ID) REFERENCES COLLECTION_GATHERER(GAT_ID))
+CREATE TABLE COLLECTION_2_PROJECT(PRO_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150))
+CREATE TABLE COLLECTION_2_SUB_PROJECT(SUB_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),FK_PRO_ID INTEGER,CONSTRAINT COLLECTION_2_SUB_PROJECT_FK_1 FOREIGN KEY(FK_PRO_ID) REFERENCES COLLECTION_2_PROJECT(PRO_ID))
+CREATE TABLE COLLECTION_2_DEVELOPER(DEV_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),FK_PRO_ID INTEGER,CONSTRAINT COLLECTION_2_DEVELOPER_FK_1 FOREIGN KEY(FK_PRO_ID) REFERENCES COLLECTION_2_PROJECT(PRO_ID))
+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 COL_BOOKSHELFS(PK INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100))
+CREATE TABLE COL_BOOKS(PK INTEGER NOT NULL,BOOKSHELF_FK INTEGER NOT NULL,CONSTRAINT SYS_PK_COL_BOOKS PRIMARY KEY(PK,BOOKSHELF_FK))
+CREATE TABLE COL_DVDS(PK INTEGER NOT NULL,BOOKSHELF_FK INTEGER NOT NULL,CONSTRAINT SYS_PK_COL_DVDS PRIMARY KEY(PK,BOOKSHELF_FK))
+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 TAB_COMPONENT(PK_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),PARENT_ID INTEGER,CHILD_ID INTEGER,GROUP_ID INTEGER)
+CREATE TABLE TAB_GROUP(PK_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150))
+CREATE TABLE INHERITANCE_MULTI_EMPLOYEE(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),FK_ADDRESS INTEGER)
+CREATE TABLE INHERITANCE_MULTI_EXECUTIVE(OBJ_ID INTEGER NOT NULL PRIMARY KEY,SUPER_ID INTEGER,MANAGER_ID INTEGER,DEPARTMENT VARCHAR(150),CONSTRAINT INHERITANCE_MULTI_EXECUTIVE_FK_1 FOREIGN KEY(SUPER_ID) REFERENCES INHERITANCE_MULTI_EMPLOYEE(OBJ_ID))
+CREATE TABLE INHERITANCE_MULTI_MANAGER(OBJ_ID INTEGER NOT NULL PRIMARY KEY,SUPER_ID INTEGER,CONSTRAINT INHERITANCE_MULTI_MANAGER_FK_1 FOREIGN KEY(SUPER_ID) REFERENCES INHERITANCE_MULTI_EXECUTIVE(OBJ_ID))
+CREATE TABLE INHERITANCE_MULTI_ADDRESS(OBJ_ID INTEGER NOT NULL PRIMARY KEY,STREET VARCHAR(150))
+CREATE TABLE RUNTIME_SETTING_MAIN(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),FK_REF INTEGER)
+CREATE TABLE RUNTIME_SETTING_ONE(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150))
+CREATE TABLE RUNTIME_SETTING_MANY(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),FK_MAIN INTEGER,CONSTRAINT RUNTIME_SETTING_MANY_FK_1 FOREIGN KEY(FK_MAIN) REFERENCES RUNTIME_SETTING_MAIN(OBJ_ID))
+CREATE TABLE MULTIPLE_OBJECT(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150))
+CREATE TABLE LOCK_MULTI(OJB_ID INTEGER NOT NULL PRIMARY KEY,VERSION INTEGER,REF_ID INTEGER,NAME VARCHAR(250))
+CREATE TABLE LOCK_MULTI_REF(OJB_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250),VERSION INTEGER)
+CREATE TABLE CRT_EMPLOYEE(EMPLOYEE_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150))
+CREATE TABLE CRT_MEMBER(ROLE_ID INTEGER NOT NULL PRIMARY KEY,EMPLOYEE_ID INTEGER,NAME VARCHAR(150),CONSTRAINT CRT_MEMBER_FK_1 FOREIGN KEY(EMPLOYEE_ID) REFERENCES CRT_EMPLOYEE(EMPLOYEE_ID))
+CREATE TABLE CRT_LEADER(ROLE_ID INTEGER NOT NULL PRIMARY KEY,EMPLOYEE_ID INTEGER,NAME VARCHAR(150),CONSTRAINT CRT_LEADER_FK_1 FOREIGN KEY(EMPLOYEE_ID) REFERENCES CRT_EMPLOYEE(EMPLOYEE_ID))
+CREATE TABLE CRT_PROJECT(PROJECT_ID INTEGER NOT NULL PRIMARY KEY,ENGINEER_ID INTEGER,NAME VARCHAR(150),CONSTRAINT CRT_PROJECT_FK_1 FOREIGN KEY(ENGINEER_ID) REFERENCES CRT_LEADER(ROLE_ID))
+CREATE TABLE CRT_SUB_PROJECT(SUB_ID INTEGER NOT NULL PRIMARY KEY,PROJECT_ID INTEGER,TUTOR_ID INTEGER,NAME VARCHAR(150),CONSTRAINT CRT_SUB_PROJECT_FK_1 FOREIGN KEY(PROJECT_ID) REFERENCES CRT_PROJECT(PROJECT_ID),CONSTRAINT CRT_SUB_PROJECT_FK_2 FOREIGN KEY(TUTOR_ID) REFERENCES CRT_MEMBER(ROLE_ID))
+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,CONSTRAINT OTM_ADDRESS_DESC_FK_1 FOREIGN KEY(ADDRESS_ID) REFERENCES OTM_ADDRESS(ID),CONSTRAINT OTM_ADDRESS_DESC_FK_2 FOREIGN KEY(PERSON_ID) REFERENCES OTM_PERSON(ID))
+CREATE TABLE OTM_PERSON2(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(60))
+CREATE TABLE OTM_PERSON3(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(60))
+CREATE TABLE OTM_ADDRESS2(ID INTEGER NOT NULL PRIMARY KEY,PERSON_ID INTEGER)
+CREATE TABLE OTM_DEBITOR(ID INTEGER NOT NULL PRIMARY KEY,PERSON_ID INTEGER)
+CREATE TABLE P_A_TABLE(ID BIGINT NOT NULL PRIMARY KEY,A_ATTRIB INTEGER)
+CREATE TABLE P_B_TABLE(ID BIGINT NOT NULL PRIMARY KEY,B_ATTRIB INTEGER,A_ID BIGINT,CONSTRAINT P_B_TABLE_FK_1 FOREIGN KEY(A_ID) REFERENCES P_A_TABLE(ID))
+CREATE TABLE P_C_TABLE(ID BIGINT NOT NULL PRIMARY KEY,C_ATTRIB INTEGER,C1_ATTRIB INTEGER,B_ID BIGINT,D_ID BIGINT,CONSTRAINT P_C_TABLE_FK_1 FOREIGN KEY(B_ID) REFERENCES P_B_TABLE(ID))
+CREATE TABLE P_D_TABLE(ID BIGINT NOT NULL PRIMARY KEY,D_ATTRIB INTEGER)
+CREATE TABLE OJB_HL_SEQ(TABLENAME VARCHAR(175) NOT NULL,FIELDNAME VARCHAR(70) NOT NULL,MAX_KEY BIGINT,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)
+ALTER TABLE MAMMAL ADD CONSTRAINT MAMMAL_FK_1 FOREIGN KEY(ZOOID) REFERENCES ZOO(ZOOID)
+ALTER TABLE REPTILE ADD CONSTRAINT REPTILE_FK_1 FOREIGN KEY(ZOOID) REFERENCES ZOO(ZOOID)
+ALTER TABLE REF_WINE ADD CONSTRAINT REF_WINE_FK_1 FOREIGN KEY(REGION_NAME,REGION_COUNTRY) REFERENCES REF_REGION(NAME,COUNTRY)
+ALTER TABLE INHERITANCE_MULTI_EMPLOYEE ADD CONSTRAINT INHERITANCE_MULTI_EMPLOYEE_FK_1 FOREIGN KEY(FK_ADDRESS) REFERENCES INHERITANCE_MULTI_ADDRESS(OBJ_ID)
+ALTER TABLE RUNTIME_SETTING_MAIN ADD CONSTRAINT RUNTIME_SETTING_MAIN_FK_1 FOREIGN KEY(FK_REF) REFERENCES RUNTIME_SETTING_ONE(OBJ_ID)
+ALTER TABLE OTM_PERSON ADD CONSTRAINT OTM_PERSON_FK_1 FOREIGN KEY(MAIN_ADDRESS_ID) REFERENCES OTM_ADDRESS(ID)
+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')
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org