db-ojb-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From arm...@apache.org
Subject cvs commit: db-ojb/src/test/org/apache/ojb/quick-db OJB.properties OJB.script
Date Sat, 24 Sep 2005 12:34:32 GMT
arminw      2005/09/24 05:34:32

  Modified:    src/test/org/apache/ojb/faraway-db OJB_FarAway.properties
                        OJB_FarAway.script
               src/test/org/apache/ojb/quick-db OJB.properties OJB.script
  Log:
  update hsqldb configuration (update to hsqldb 1.8.0.2) files to fix errors in tests-suite
  
  Revision  Changes    Path
  1.4       +13 -16    db-ojb/src/test/org/apache/ojb/faraway-db/OJB_FarAway.properties
  
  Index: OJB_FarAway.properties
  ===================================================================
  RCS file: /home/cvs/db-ojb/src/test/org/apache/ojb/faraway-db/OJB_FarAway.properties,v
  retrieving revision 1.3
  retrieving revision 1.4
  diff -u -r1.3 -r1.4
  --- OJB_FarAway.properties	31 Aug 2005 16:33:59 -0000	1.3
  +++ OJB_FarAway.properties	24 Sep 2005 12:34:32 -0000	1.4
  @@ -1,20 +1,17 @@
  -#HSQL database
  -#Sat Aug 27 15:54:02 CEST 2005
  -hsqldb.cache_file_scale=1
  -runtime.gc_interval=0
  -hsqldb.first_identity=0
  -version=1.7.3
  -modified=no
  +#HSQL Database Engine
  +#Sat Sep 24 14:15:50 CEST 2005
   hsqldb.script_format=0
  -sql.enforce_size=false
  -hsqldb.cache_size_scale=10
  -hsqldb.cache_scale=14
  -hsqldb.version=1.7.3
  -hsqldb.log_size=200
  +runtime.gc_interval=0
   sql.enforce_strict_size=false
  +hsqldb.cache_size_scale=8
   readonly=false
  -hsqldb.compatible_version=1.7.2
  -hsqldb.original_version=1.7.3
  -sql.compare_in_locale=false
   hsqldb.nio_data_file=true
  -hsqldb.cache_version=1.7.0
  \ No newline at end of file
  +hsqldb.cache_scale=14
  +version=1.8.0
  +hsqldb.default_table_type=memory
  +hsqldb.cache_file_scale=1
  +hsqldb.log_size=200
  +modified=no
  +hsqldb.cache_version=1.7.0
  +hsqldb.original_version=1.8.0
  +hsqldb.compatible_version=1.8.0
  
  
  
  1.9       +20 -85    db-ojb/src/test/org/apache/ojb/faraway-db/OJB_FarAway.script
  
  Index: OJB_FarAway.script
  ===================================================================
  RCS file: /home/cvs/db-ojb/src/test/org/apache/ojb/faraway-db/OJB_FarAway.script,v
  retrieving revision 1.8
  retrieving revision 1.9
  diff -u -r1.8 -r1.9
  --- OJB_FarAway.script	27 Aug 2005 12:42:41 -0000	1.8
  +++ OJB_FarAway.script	24 Sep 2005 12:34:32 -0000	1.9
  @@ -1,85 +1,20 @@
  -CREATE TABLE FAR_AWAY(ID INTEGER PRIMARY KEY,NAME VARCHAR(50),DESCRIPTION VARCHAR(250), REFERENCE_ID INTEGER)
  -CREATE TABLE MULTIPLE_OBJECT_REF(OBJ_ID INTEGER PRIMARY KEY, NAME VARCHAR(50), REF_ID INTEGER)
  -CREATE TABLE CACHE_TEST(OBJ_ID INTEGER PRIMARY KEY, NAME VARCHAR(150))
  -CREATE TABLE FAR_AWAY_REFERENCE(ID INTEGER PRIMARY KEY,NAME VARCHAR(50))
  -CREATE TABLE OJB_HL_SEQ(TABLENAME VARCHAR(250) NOT NULL,MAX_KEY INTEGER,GRAB_SIZE INTEGER,VERSION INTEGER,CONSTRAINT SYS_PK_OJB_HL_SEQ PRIMARY KEY(TABLENAME))
  -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 LONGVARBINARY,VALUE_OID LONGVARBINARY)
  -CREATE TABLE SM_KEY(INT_KEY INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250),STRING_KEY VARCHAR(250),LONG_KEY BIGINT,INTEGER_KEY INTEGER)
  -GRANT ALL ON CLASS "org.hsqldb.Library" TO PUBLIC
  -GRANT ALL ON CLASS "java.lang.Math" 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"
  +CREATE MEMORY TABLE FAR_AWAY(ID INTEGER PRIMARY KEY,NAME VARCHAR(50),DESCRIPTION VARCHAR(250), REFERENCE_ID INTEGER)
  +CREATE MEMORY TABLE MULTIPLE_OBJECT_REF(OBJ_ID INTEGER PRIMARY KEY, NAME VARCHAR(50), REF_ID INTEGER)
  +CREATE MEMORY TABLE CACHE_TEST(OBJ_ID INTEGER PRIMARY KEY, NAME VARCHAR(150))
  +CREATE MEMORY TABLE FAR_AWAY_REFERENCE(ID INTEGER PRIMARY KEY,NAME VARCHAR(50))
  +CREATE MEMORY TABLE OJB_HL_SEQ(TABLENAME VARCHAR(250) NOT NULL,MAX_KEY INTEGER,GRAB_SIZE INTEGER,VERSION INTEGER,CONSTRAINT SYS_PK_OJB_HL_SEQ PRIMARY KEY(TABLENAME))
  +CREATE MEMORY 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 MEMORY TABLE OJB_NRM(NAME VARCHAR(250) NOT NULL PRIMARY KEY,OID_ LONGVARBINARY)
  +CREATE MEMORY TABLE OJB_DLIST(ID INTEGER NOT NULL PRIMARY KEY,SIZE_ INTEGER)
  +CREATE MEMORY TABLE OJB_DLIST_ENTRIES(ID INTEGER NOT NULL PRIMARY KEY,DLIST_ID INTEGER,POSITION_ INTEGER,OID_ LONGVARBINARY)
  +CREATE MEMORY TABLE OJB_DSET(ID INTEGER NOT NULL PRIMARY KEY,SIZE_ INTEGER)
  +CREATE MEMORY TABLE OJB_DSET_ENTRIES(ID INTEGER NOT NULL PRIMARY KEY,DLIST_ID INTEGER,POSITION_ INTEGER,OID_ LONGVARBINARY)
  +CREATE MEMORY TABLE OJB_DMAP(ID INTEGER NOT NULL PRIMARY KEY,SIZE_ INTEGER)
  +CREATE MEMORY TABLE OJB_DMAP_ENTRIES(ID INTEGER NOT NULL PRIMARY KEY,DMAP_ID INTEGER,KEY_OID LONGVARBINARY,VALUE_OID LONGVARBINARY)
  +CREATE MEMORY TABLE SM_KEY(INT_KEY INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250),STRING_KEY VARCHAR(250),LONG_KEY BIGINT,INTEGER_KEY INTEGER)
  +
  +
  +CREATE USER SA PASSWORD ""
  +GRANT DBA TO SA
  +SET WRITE_DELAY 20
  +SET SCHEMA PUBLIC
  \ No newline at end of file
  
  
  
  1.34      +13 -16    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.33
  retrieving revision 1.34
  diff -u -r1.33 -r1.34
  --- OJB.properties	27 Aug 2005 14:31:34 -0000	1.33
  +++ OJB.properties	24 Sep 2005 12:34:32 -0000	1.34
  @@ -1,20 +1,17 @@
  -#HSQL database
  -#Sat Aug 27 15:54:02 CEST 2005
  -hsqldb.cache_file_scale=1
  -runtime.gc_interval=0
  -hsqldb.first_identity=0
  -version=1.7.3
  -modified=no
  +#HSQL Database Engine
  +#Sat Sep 24 14:15:50 CEST 2005
   hsqldb.script_format=0
  -sql.enforce_size=false
  -hsqldb.cache_size_scale=10
  -hsqldb.cache_scale=14
  -hsqldb.version=1.7.3
  -hsqldb.log_size=200
  +runtime.gc_interval=0
   sql.enforce_strict_size=false
  +hsqldb.cache_size_scale=8
   readonly=false
  -hsqldb.compatible_version=1.7.2
  -hsqldb.original_version=1.7.3
  -sql.compare_in_locale=false
   hsqldb.nio_data_file=true
  -hsqldb.cache_version=1.7.0
  \ No newline at end of file
  +hsqldb.cache_scale=14
  +version=1.8.0
  +hsqldb.default_table_type=memory
  +hsqldb.cache_file_scale=1
  +hsqldb.log_size=200
  +modified=no
  +hsqldb.cache_version=1.7.0
  +hsqldb.original_version=1.8.0
  +hsqldb.compatible_version=1.8.0
  
  
  
  1.35      +218 -211  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.34
  retrieving revision 1.35
  diff -u -r1.34 -r1.35
  --- OJB.script	27 Aug 2005 14:31:34 -0000	1.34
  +++ OJB.script	24 Sep 2005 12:34:32 -0000	1.35
  @@ -1,217 +1,224 @@
  -CREATE TABLE KATEGORIEN(KATEGORIE_NR INTEGER NOT NULL PRIMARY KEY,KATEGORIENAME VARCHAR(150),BESCHREIBUNG VARCHAR(150))
  -CREATE TABLE ARTIKEL(ARTIKEL_NR INTEGER NOT NULL PRIMARY KEY,ARTIKELNAME VARCHAR(150),LIEFERANTEN_NR INTEGER,KATEGORIE_NR INTEGER,LIEFEREINHEIT VARCHAR(150),EINZELPREIS FLOAT,LAGERBESTAND INTEGER,BESTELLTEEINHEITEN INTEGER,MINDESTBESTAND INTEGER,AUSLAUFARTIKEL INTEGER,CONSTRAINT ARTIKEL_FK_1 FOREIGN KEY(KATEGORIE_NR) REFERENCES KATEGORIEN(KATEGORIE_NR))
  -CREATE TABLE QUOTED_ARTICLE(ARTICLE_ID INTEGER NOT NULL PRIMARY KEY,ARTICLE_NAME VARCHAR(150),GROUP_ID INTEGER,UNIT VARCHAR(150),PRICE FLOAT,STOCK INTEGER,CONSTRAINT QUOTED_ARTICLE_FK_1 FOREIGN KEY(GROUP_ID) REFERENCES KATEGORIEN(KATEGORIE_NR))
  -CREATE TABLE BOOKS(ARTIKEL_NR INTEGER NOT NULL PRIMARY KEY,ARTIKELNAME VARCHAR(150),LIEFERANTEN_NR INTEGER,KATEGORIE_NR INTEGER,LIEFEREINHEIT VARCHAR(150),EINZELPREIS FLOAT,LAGERBESTAND INTEGER,BESTELLTEEINHEITEN INTEGER,MINDESTBESTAND INTEGER,AUSLAUFARTIKEL INTEGER,ISBN VARCHAR(10),AUTHOR VARCHAR(150),CONSTRAINT BOOKS_FK_1 FOREIGN KEY(KATEGORIE_NR) REFERENCES KATEGORIEN(KATEGORIE_NR))
  -CREATE TABLE CDS(ARTIKEL_NR INTEGER NOT NULL PRIMARY KEY,ARTIKELNAME VARCHAR(150),LIEFERANTEN_NR INTEGER,KATEGORIE_NR INTEGER,LIEFEREINHEIT VARCHAR(150),EINZELPREIS FLOAT,LAGERBESTAND INTEGER,BESTELLTEEINHEITEN INTEGER,MINDESTBESTAND INTEGER,AUSLAUFARTIKEL INTEGER,LABEL VARCHAR(150),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(150),PARENT_ID INTEGER)
  -CREATE TABLE TREEGROUP(ID INTEGER NOT NULL PRIMARY KEY,DATA VARCHAR(150),PARENT_ID INTEGER,GROUP_ID INTEGER)
  -CREATE TABLE AB_TABLE(ID INTEGER NOT NULL PRIMARY KEY,CLASS_NAME VARCHAR(150),VALUE_ INTEGER,A_FIELD VARCHAR(150),B_FIELD VARCHAR(150))
  -CREATE TABLE L_TABLE(ID INTEGER NOT NULL PRIMARY KEY,L_VALUE INTEGER)
  -CREATE TABLE O_TABLE(ID INTEGER NOT NULL PRIMARY KEY,O_VALUE INTEGER)
  -CREATE TABLE PRODUCT(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),PRICE FLOAT,STOCK INTEGER)
  -CREATE TABLE PERSON(ID INTEGER NOT NULL PRIMARY KEY,FIRSTNAME VARCHAR(150),LASTNAME VARCHAR(150))
  -CREATE TABLE PROJECT(ID INTEGER NOT NULL PRIMARY KEY,TITLE VARCHAR(150),DESCRIPTION VARCHAR(250))
  -CREATE TABLE PERSON_PROJECT(PERSON_ID INTEGER NOT NULL,PROJECT_ID INTEGER NOT NULL,ROLENAME VARCHAR(150),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(150))
  -CREATE TABLE FAMILY_MEMBER(ID INTEGER NOT NULL PRIMARY KEY,FIRSTNAME VARCHAR(150),LASTNAME VARCHAR(150),MOTHER_ID INTEGER,FATHER_ID INTEGER)
  -CREATE TABLE LOCKED_BY_VERSION(ID INTEGER NOT NULL PRIMARY KEY,VALUE_ VARCHAR(150),VERSION_ INTEGER)
  -CREATE TABLE LOCKED_BY_TIMESTAMP(ID INTEGER NOT NULL PRIMARY KEY,VALUE_ VARCHAR(150),TIMESTAMP_ TIMESTAMP)
  -CREATE TABLE CHARACTER_TEST(ID INTEGER NOT NULL PRIMARY KEY,CHAR_1 VARCHAR(1),CHAR_10 VARCHAR(10),VARCHAR_1 VARCHAR(1),VARCHAR_10 VARCHAR(10))
  -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(150),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(150),VALUE2 VARCHAR(150),VALUE3 INTEGER,BOID VARCHAR(48))
  -CREATE TABLE TESTCLASSB(ID VARCHAR(48) NOT NULL PRIMARY KEY,VALUE1 VARCHAR(150),AOID VARCHAR(48))
  -CREATE TABLE RELATEDTOCONTRACT(PK VARCHAR(48) NOT NULL PRIMARY KEY,RELATEDVALUE1 VARCHAR(150),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,CLASS_NAME VARCHAR(128) NOT NULL,NAME VARCHAR(100),CONSTRAINT SYS_PK_EXTENT_TEST_A PRIMARY KEY(OBJ_ID,CLASS_NAME))
  -CREATE TABLE EXTENT_TEST_B(OBJ_ID INTEGER NOT NULL,CLASS_NAME VARCHAR(128) NOT NULL,NAME VARCHAR(100),CONSTRAINT SYS_PK_EXTENT_TEST_B PRIMARY KEY(OBJ_ID,CLASS_NAME))
  -CREATE TABLE EXTENT_TEST_C(OBJ_ID INTEGER NOT NULL,CLASS_NAME VARCHAR(128) NOT NULL,NAME VARCHAR(100),CONSTRAINT SYS_PK_EXTENT_TEST_C PRIMARY KEY(OBJ_ID,CLASS_NAME))
  -CREATE TABLE EXTENT_TEST_D(OBJ_ID INTEGER NOT NULL,CLASS_NAME VARCHAR(128) NOT NULL,NAME VARCHAR(100),D_FIELD VARCHAR(100),CONSTRAINT SYS_PK_EXTENT_TEST_D PRIMARY KEY(OBJ_ID,CLASS_NAME))
  -CREATE TABLE TABLE_2(PK INTEGER NOT NULL PRIMARY KEY)
  -CREATE TABLE TABLE_1(PK INTEGER NOT NULL PRIMARY KEY,FK_TO_RELATED INTEGER,CONSTRAINT TABLE_1_FK_1 FOREIGN KEY(FK_TO_RELATED) REFERENCES TABLE_2(PK))
  -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 ZOO(ZOOID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(60))
  -CREATE TABLE MAMMAL(ANIMALID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(60),AGE INTEGER,NUMLEGS INTEGER,ZOOID INTEGER,CONSTRAINT MAMMAL_FK_1 FOREIGN KEY(ZOOID) REFERENCES ZOO(ZOOID))
  -CREATE TABLE REPTILE(ANIMALID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(60),AGE INTEGER,COLOR VARCHAR(60),ZOOID INTEGER,CONSTRAINT REPTILE_FK_1 FOREIGN KEY(ZOOID) REFERENCES ZOO(ZOOID))
  -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),IMPORTANCE VARCHAR(50))
  -CREATE TABLE CATEGORY(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(50),DESCRIPTION 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 FIELD_CONVERSION_NODE_NOINC(NODE_ID DECIMAL(15) NOT NULL PRIMARY KEY)
  -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 FLOAT,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_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_WINE(OBJ_ID VARCHAR(100) NOT NULL PRIMARY KEY,REGION_NAME VARCHAR(150),REGION_COUNTRY VARCHAR(150),VINTAGE VARCHAR(150),GRAPE VARCHAR(150),CONSTRAINT REF_WINE_FK_1 FOREIGN KEY(REGION_NAME,REGION_COUNTRY) REFERENCES REF_REGION(NAME,COUNTRY))
  -CREATE TABLE REF_OBJ_A(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),FK_COL_REF INTEGER,FK_REF INTEGER)
  -CREATE TABLE REF_OBJ_B(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),FK_COL_REF INTEGER,FK_REF INTEGER)
  -CREATE TABLE REF_OBJ_C(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),NAME_C VARCHAR(150),FK_COL_REF INTEGER,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_INVOICE(OJB_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),INVOICE_NUMBER VARCHAR(150),FK_REF INTEGER)
  -CREATE TABLE READTEST_ARTICLE(OJB_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),DESCRIPTION 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 M2N_TEST_ROLE_2(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_2 PRIMARY KEY(ACTOR_ID,ACTOR_ID2,MOVIE_ID_INT,MOVIE_ID2_INT,MOVIE_ID_STR),CONSTRAINT M2N_TEST_ROLE_2_FK_1 FOREIGN KEY(ACTOR_ID,ACTOR_ID2) REFERENCES M2N_TEST_ACTOR(OBJ_ID,OBJ_ID2),CONSTRAINT M2N_TEST_ROLE_2_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 M2N_OFFICE(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150))
  -CREATE TABLE M2N_OFFICE_COUNTY(OFFICE_ID INTEGER NOT NULL,COUNTY_ID VARCHAR(150) NOT NULL,CONSTRAINT SYS_PK_M2N_OFFICE_COUNTY PRIMARY KEY(OFFICE_ID,COUNTY_ID))
  -CREATE TABLE M2N_COUNTY(OBJ_ID VARCHAR(150) NOT NULL PRIMARY KEY,NAME VARCHAR(150))
  -CREATE TABLE M2N_NODE(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150))
  -CREATE TABLE M2N_KINDSHIP(PARENT_ID INTEGER NOT NULL,CHILD_ID INTEGER NOT NULL,CONSTRAINT SYS_PK_M2N_KINDSHIP PRIMARY KEY(PARENT_ID,CHILD_ID))
  -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_C2(COL_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),GAT_ID INTEGER,EXTENT_NAME VARCHAR(150),CONSTRAINT COLLECTION_COLLECTIBLE_C2_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 PB_AWARE_OBJECT(ID_ INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),FK_REF INTEGER)
  -CREATE TABLE PB_AWARE_REF(ID_ INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150))
  -CREATE TABLE PB_AWARE_COLL(ID_ INTEGER NOT NULL PRIMARY KEY,FK_PB_AWARE INTEGER,NAME VARCHAR(150))
  -CREATE TABLE READONLY_TEST(OBJ_ID DECIMAL(15) NOT NULL PRIMARY KEY,NAME VARCHAR(150),RO_STRING VARCHAR(150),RO_LONG DECIMAL(15))
  -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(15) 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(15),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_COMPANY(OBJ_ID DECIMAL(15) NOT NULL PRIMARY KEY,NAME VARCHAR(150))
  -CREATE TABLE INHERITANCE_ADDRESS(OBJ_ID INTEGER NOT NULL PRIMARY KEY,STREET VARCHAR(150),FK_EMPLOYEE_1 INTEGER,FK_EMPLOYEE_2 DECIMAL(15))
  -CREATE TABLE INHERITANCE_EMPLOYEE(OBJ_ID INTEGER NOT NULL,OBJ_ID_2 DECIMAL(15) NOT NULL,NAME VARCHAR(150),FK_ADDRESS INTEGER,CONSTRAINT SYS_PK_INHERITANCE_EMPLOYEE PRIMARY KEY(OBJ_ID,OBJ_ID_2),CONSTRAINT INHERITANCE_EMPLOYEE_FK_1 FOREIGN KEY(FK_ADDRESS) REFERENCES INHERITANCE_ADDRESS(OBJ_ID))
  -CREATE TABLE INHERITANCE_EXECUTIVE(OBJ_ID INTEGER NOT NULL,OBJ_ID_2 DECIMAL(15) NOT NULL,SUPER_ID INTEGER,SUPER_ID_2 DECIMAL(15),MANAGER_ID INTEGER,MANAGER_ID_2 DECIMAL(15),DEPARTMENT VARCHAR(150),CONSTRAINT SYS_PK_INHERITANCE_EXECUTIVE PRIMARY KEY(OBJ_ID,OBJ_ID_2),CONSTRAINT INHERITANCE_EXECUTIVE_FK_1 FOREIGN KEY(SUPER_ID,SUPER_ID_2) REFERENCES INHERITANCE_EMPLOYEE(OBJ_ID,OBJ_ID_2))
  -CREATE TABLE INHERITANCE_MANAGER(OBJ_ID INTEGER NOT NULL,OBJ_ID_2 DECIMAL(15) NOT NULL,FK_CONSORTIUM INTEGER,SUPER_ID INTEGER,SUPER_ID_2 DECIMAL(15),CONSTRAINT SYS_PK_INHERITANCE_MANAGER PRIMARY KEY(OBJ_ID,OBJ_ID_2),CONSTRAINT INHERITANCE_MANAGER_FK_1 FOREIGN KEY(SUPER_ID,SUPER_ID_2) REFERENCES INHERITANCE_EXECUTIVE(OBJ_ID,OBJ_ID_2))
  -CREATE TABLE INHERITANCE_SHAREHOLDER(OBJ_ID INTEGER NOT NULL,OBJ_ID_2 DECIMAL(15) NOT NULL,SHARE_ INTEGER,SUPER_ID INTEGER,SUPER_ID_2 DECIMAL(15),CONSTRAINT SYS_PK_INHERITANCE_SHAREHOLDER PRIMARY KEY(OBJ_ID,OBJ_ID_2),CONSTRAINT INHERITANCE_SHAREHOLDER_FK_1 FOREIGN KEY(SUPER_ID,SUPER_ID_2) REFERENCES INHERITANCE_MANAGER(OBJ_ID,OBJ_ID_2))
  -CREATE TABLE INHERITANCE_EMPLOYEE_ADDRESS(EMPLOYEE_ID_1 INTEGER NOT NULL,EMPLOYEE_ID_2 DECIMAL(15) NOT NULL,ADDRESS_ID INTEGER NOT NULL,CONSTRAINT SYS_PK_INHERITANCE_EMPLOYEE_ADDRESS PRIMARY KEY(EMPLOYEE_ID_1,EMPLOYEE_ID_2,ADDRESS_ID))
  -CREATE TABLE INHERITANCE_CONSORTIUM(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150))
  -CREATE TABLE INHERITANCE_ENTITY(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150))
  -CREATE TABLE INHERITANCE_ANIMAL(OBJ_ID INTEGER NOT NULL PRIMARY KEY,WEIGHT INTEGER,NAME VARCHAR(150),FK_PARENT INTEGER)
  -CREATE TABLE INHERITANCE_DOG(OBJ_ID INTEGER NOT NULL PRIMARY KEY,LEGS INTEGER)
  -CREATE TABLE INHERITANCE_FOOD(OBJ_ID INTEGER NOT NULL PRIMARY KEY,FK_ANIMAL INTEGER)
  -CREATE TABLE TREE_EXTENDED_NODE(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),PARENT_ID INTEGER,CHILD_ID INTEGER,CONSTRAINT TREE_EXTENDED_NODE_FK_1 FOREIGN KEY(CHILD_ID) REFERENCES TREE_EXTENDED_NODE(OBJ_ID),CONSTRAINT TREE_EXTENDED_NODE_FK_2 FOREIGN KEY(PARENT_ID) REFERENCES TREE_EXTENDED_NODE(OBJ_ID))
  -CREATE TABLE RUNTIME_SETTING_ONE(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150))
  -CREATE TABLE RUNTIME_SETTING_MAIN(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),FK_REF INTEGER,CONSTRAINT RUNTIME_SETTING_MAIN_FK_1 FOREIGN KEY(FK_REF) REFERENCES RUNTIME_SETTING_ONE(OBJ_ID))
  -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 IC_BOOK(OJB_ID INTEGER NOT NULL PRIMARY KEY,TITLE VARCHAR(250),P_DATE TIMESTAMP,COVER LONGVARBINARY,PUBLISHER_FK INTEGER,OJB_VERSION INTEGER)
  -CREATE TABLE IC_AUTHOR(OJB_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250),OJB_VERSION INTEGER)
  -CREATE TABLE IC_PUBLISHER(OJB_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250),OJB_VERSION INTEGER)
  -CREATE TABLE IC_PUBLICATION(BOOK_ID INTEGER NOT NULL,AUTHOR_ID INTEGER NOT NULL,CONSTRAINT SYS_PK_IC_PUBLICATION PRIMARY KEY(BOOK_ID,AUTHOR_ID))
  -CREATE TABLE IC_REVIEW(OJB_ID INTEGER NOT NULL PRIMARY KEY,SUMMARY VARCHAR(250),FK_BOOK INTEGER,OJB_VERSION INTEGER,AUTHOR_FK INTEGER)
  -CREATE TABLE CT_SHOP(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250),DETAIL_FK INTEGER)
  -CREATE TABLE CT_DETAIL(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250),SHOP_FK INTEGER)
  -CREATE TABLE CT_DISTRIBUTOR(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
  -CREATE TABLE CT_PRODUCT(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250),SHOP_FK INTEGER,SUB_PRODUCT_FK INTEGER,CONSTRAINT CT_PRODUCT_FK_1 FOREIGN KEY(SUB_PRODUCT_FK) REFERENCES CT_PRODUCT(OBJ_ID),CONSTRAINT CT_PRODUCT_FK_2 FOREIGN KEY(SHOP_FK) REFERENCES CT_SHOP(OBJ_ID))
  -CREATE TABLE CT_SHOP_DISTRIBUTOR(SHOP_ID INTEGER,DISTRIBUTOR_ID INTEGER,CONSTRAINT CT_SHOP_DISTRIBUTOR_FK_1 FOREIGN KEY(SHOP_ID) REFERENCES CT_SHOP(OBJ_ID),CONSTRAINT CT_SHOP_DISTRIBUTOR_FK_2 FOREIGN KEY(DISTRIBUTOR_ID) REFERENCES CT_DISTRIBUTOR(OBJ_ID))
  -CREATE TABLE CT_OBJECT_A(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250),FK_ID INTEGER)
  -CREATE TABLE CT_OBJECT_AA(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250),FK_ID INTEGER)
  -CREATE TABLE CT_OBJECT_AAA(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250),FK_ID INTEGER,FK_ID_A INTEGER)
  -CREATE TABLE CT_OBJECT_AAAA(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250),FK_ID 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_ADDRESS(ID INTEGER NOT NULL PRIMARY KEY,COUNTRY VARCHAR(60),CITY VARCHAR(60),STREET VARCHAR(60))
  -CREATE TABLE OTM_PERSON(ID INTEGER NOT NULL PRIMARY KEY,FIRSTNAME VARCHAR(60),LASTNAME VARCHAR(60),MAIN_ADDRESS_ID INTEGER,CONSTRAINT OTM_PERSON_FK_1 FOREIGN KEY(MAIN_ADDRESS_ID) REFERENCES OTM_ADDRESS(ID))
  -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 INITIALIZABLE_OBJECT(ID BIGINT NOT NULL PRIMARY KEY)
  -CREATE TABLE KATEGORIEN_2(KATEGORIE_NR INTEGER NOT NULL PRIMARY KEY,KATEGORIE_NAME VARCHAR(150),BESCHREIBUNG VARCHAR(150),CONSTRAINT SYS_CT_5 UNIQUE(KATEGORIE_NAME))
  -CREATE TABLE ARTIKEL_2(ARTIKEL_NR INTEGER NOT NULL PRIMARY KEY,ARTIKELNAME VARCHAR(150),LIEFERANTEN_NR INTEGER,KATNAME VARCHAR(150),LIEFEREINHEIT VARCHAR(150),EINZELPREIS FLOAT,LAGERBESTAND INTEGER,BESTELLTEEINHEITEN INTEGER,MINDESTBESTAND INTEGER,AUSLAUFARTIKEL INTEGER,CONSTRAINT ARTIKEL_2_FK_1 FOREIGN KEY(KATNAME) REFERENCES KATEGORIEN_2(KATEGORIE_NAME))
  -CREATE TABLE OJB_HL_SEQ(TABLENAME VARCHAR(250) NOT NULL PRIMARY KEY,MAX_KEY BIGINT,GRAB_SIZE INTEGER,VERSION INTEGER)
  -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)
  +CREATE SCHEMA PUBLIC AUTHORIZATION DBA
  +CREATE MEMORY TABLE KATEGORIEN(KATEGORIE_NR INTEGER NOT NULL PRIMARY KEY,KATEGORIENAME VARCHAR(150),BESCHREIBUNG VARCHAR(150))
  +CREATE MEMORY TABLE ARTIKEL(ARTIKEL_NR INTEGER NOT NULL PRIMARY KEY,ARTIKELNAME VARCHAR(150),LIEFERANTEN_NR INTEGER,KATEGORIE_NR INTEGER,LIEFEREINHEIT VARCHAR(150),EINZELPREIS FLOAT,LAGERBESTAND INTEGER,BESTELLTEEINHEITEN INTEGER,MINDESTBESTAND INTEGER,AUSLAUFARTIKEL INTEGER,CONSTRAINT ARTIKEL_FK_1 FOREIGN KEY(KATEGORIE_NR) REFERENCES KATEGORIEN(KATEGORIE_NR))
  +CREATE MEMORY TABLE QUOTED_ARTICLE(ARTICLE_ID INTEGER NOT NULL PRIMARY KEY,ARTICLE_NAME VARCHAR(150),GROUP_ID INTEGER,UNIT VARCHAR(150),PRICE FLOAT,STOCK INTEGER,CONSTRAINT QUOTED_ARTICLE_FK_1 FOREIGN KEY(GROUP_ID) REFERENCES KATEGORIEN(KATEGORIE_NR))
  +CREATE MEMORY TABLE BOOKS(ARTIKEL_NR INTEGER NOT NULL PRIMARY KEY,ARTIKELNAME VARCHAR(150),LIEFERANTEN_NR INTEGER,KATEGORIE_NR INTEGER,LIEFEREINHEIT VARCHAR(150),EINZELPREIS FLOAT,LAGERBESTAND INTEGER,BESTELLTEEINHEITEN INTEGER,MINDESTBESTAND INTEGER,AUSLAUFARTIKEL INTEGER,ISBN VARCHAR(10),AUTHOR VARCHAR(150),CONSTRAINT BOOKS_FK_1 FOREIGN KEY(KATEGORIE_NR) REFERENCES KATEGORIEN(KATEGORIE_NR))
  +CREATE MEMORY TABLE CDS(ARTIKEL_NR INTEGER NOT NULL PRIMARY KEY,ARTIKELNAME VARCHAR(150),LIEFERANTEN_NR INTEGER,KATEGORIE_NR INTEGER,LIEFEREINHEIT VARCHAR(150),EINZELPREIS FLOAT,LAGERBESTAND INTEGER,BESTELLTEEINHEITEN INTEGER,MINDESTBESTAND INTEGER,AUSLAUFARTIKEL INTEGER,LABEL VARCHAR(150),MUSICIANS VARCHAR(250),CONSTRAINT CDS_FK_1 FOREIGN KEY(KATEGORIE_NR) REFERENCES KATEGORIEN(KATEGORIE_NR))
  +CREATE MEMORY TABLE ORDER_POSITION(ID INTEGER NOT NULL PRIMARY KEY,ORDER_ID INTEGER,ARTICLE_ID INTEGER)
  +CREATE MEMORY TABLE TREE(ID INTEGER NOT NULL PRIMARY KEY,DATA VARCHAR(150),PARENT_ID INTEGER)
  +CREATE MEMORY TABLE TREEGROUP(ID INTEGER NOT NULL PRIMARY KEY,DATA VARCHAR(150),PARENT_ID INTEGER,GROUP_ID INTEGER)
  +CREATE MEMORY TABLE AB_TABLE(ID INTEGER NOT NULL PRIMARY KEY,CLASS_NAME VARCHAR(150),VALUE_ INTEGER,A_FIELD VARCHAR(150),B_FIELD VARCHAR(150))
  +CREATE MEMORY TABLE L_TABLE(ID INTEGER NOT NULL PRIMARY KEY,L_VALUE INTEGER)
  +CREATE MEMORY TABLE O_TABLE(ID INTEGER NOT NULL PRIMARY KEY,O_VALUE INTEGER)
  +CREATE MEMORY TABLE PRODUCT(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),PRICE FLOAT,STOCK INTEGER)
  +CREATE MEMORY TABLE PERSON(ID INTEGER NOT NULL PRIMARY KEY,FIRSTNAME VARCHAR(150),LASTNAME VARCHAR(150))
  +CREATE MEMORY TABLE PROJECT(ID INTEGER NOT NULL PRIMARY KEY,TITLE VARCHAR(150),DESCRIPTION VARCHAR(250))
  +CREATE MEMORY TABLE PERSON_PROJECT(PERSON_ID INTEGER NOT NULL,PROJECT_ID INTEGER NOT NULL,ROLENAME VARCHAR(150),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 MEMORY TABLE TASK(TASK_ID INTEGER NOT NULL PRIMARY KEY,PERSON_ID INTEGER,PROJECT_ID INTEGER,TASKNAME VARCHAR(150))
  +CREATE MEMORY TABLE FAMILY_MEMBER(ID INTEGER NOT NULL PRIMARY KEY,FIRSTNAME VARCHAR(150),LASTNAME VARCHAR(150),MOTHER_ID INTEGER,FATHER_ID INTEGER)
  +CREATE MEMORY TABLE LOCKED_BY_VERSION(ID INTEGER NOT NULL PRIMARY KEY,VALUE_ VARCHAR(150),VERSION_ INTEGER)
  +CREATE MEMORY TABLE LOCKED_BY_TIMESTAMP(ID INTEGER NOT NULL PRIMARY KEY,VALUE_ VARCHAR(150),TIMESTAMP_ TIMESTAMP)
  +CREATE MEMORY TABLE CHARACTER_TEST(ID INTEGER NOT NULL PRIMARY KEY,CHAR_1 VARCHAR(1),CHAR_10 VARCHAR(10),VARCHAR_1 VARCHAR(1),VARCHAR_10 VARCHAR(10))
  +CREATE MEMORY TABLE MDTEST_MASTER(MASTERID INTEGER NOT NULL PRIMARY KEY,MASTER_TEXT VARCHAR(255))
  +CREATE MEMORY TABLE MDTEST_DETAIL_FKINPK(MASTERID INTEGER NOT NULL,DETAILID INTEGER NOT NULL,DETAIL_TEXT VARCHAR(255),PRIMARY KEY(MASTERID,DETAILID),CONSTRAINT MDTEST_DETAIL_FKINPK_FK_1 FOREIGN KEY(MASTERID) REFERENCES MDTEST_MASTER(MASTERID))
  +CREATE MEMORY 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 MEMORY TABLE POINT_TABLE(ID INTEGER NOT NULL PRIMARY KEY,X INTEGER,Y INTEGER)
  +CREATE MEMORY TABLE GRAPH_NODE(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),LOCATION INTEGER)
  +CREATE MEMORY TABLE GRAPH_EDGE(ID INTEGER NOT NULL PRIMARY KEY,SOURCE INTEGER,SINK INTEGER)
  +CREATE MEMORY TABLE TESTCLASSA(ID VARCHAR(48) NOT NULL PRIMARY KEY,VALUE1 VARCHAR(150),VALUE2 VARCHAR(150),VALUE3 INTEGER,BOID VARCHAR(48))
  +CREATE MEMORY TABLE TESTCLASSB(ID VARCHAR(48) NOT NULL PRIMARY KEY,VALUE1 VARCHAR(150),AOID VARCHAR(48))
  +CREATE MEMORY TABLE RELATEDTOCONTRACT(PK VARCHAR(48) NOT NULL PRIMARY KEY,RELATEDVALUE1 VARCHAR(150),RELATEDVALUE2 INTEGER,RELATEDVALUE3 TIMESTAMP)
  +CREATE MEMORY 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 MEMORY 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 MEMORY 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 MEMORY 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 MEMORY TABLE EXTENT_TEST_A(OBJ_ID INTEGER NOT NULL,CLASS_NAME VARCHAR(128) NOT NULL,NAME VARCHAR(100),PRIMARY KEY(OBJ_ID,CLASS_NAME))
  +CREATE MEMORY TABLE EXTENT_TEST_B(OBJ_ID INTEGER NOT NULL,CLASS_NAME VARCHAR(128) NOT NULL,NAME VARCHAR(100),PRIMARY KEY(OBJ_ID,CLASS_NAME))
  +CREATE MEMORY TABLE EXTENT_TEST_C(OBJ_ID INTEGER NOT NULL,CLASS_NAME VARCHAR(128) NOT NULL,NAME VARCHAR(100),PRIMARY KEY(OBJ_ID,CLASS_NAME))
  +CREATE MEMORY TABLE EXTENT_TEST_D(OBJ_ID INTEGER NOT NULL,CLASS_NAME VARCHAR(128) NOT NULL,NAME VARCHAR(100),D_FIELD VARCHAR(100),PRIMARY KEY(OBJ_ID,CLASS_NAME))
  +CREATE MEMORY TABLE TABLE_2(PK INTEGER NOT NULL PRIMARY KEY)
  +CREATE MEMORY TABLE TABLE_1(PK INTEGER NOT NULL PRIMARY KEY,FK_TO_RELATED INTEGER,CONSTRAINT TABLE_1_FK_1 FOREIGN KEY(FK_TO_RELATED) REFERENCES TABLE_2(PK))
  +CREATE MEMORY TABLE BIDIR_A(PK VARCHAR(48) NOT NULL PRIMARY KEY,FK_TO_B VARCHAR(48))
  +CREATE MEMORY 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 MEMORY TABLE ZOO(ZOOID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(60))
  +CREATE MEMORY TABLE MAMMAL(ANIMALID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(60),AGE INTEGER,NUMLEGS INTEGER,ZOOID INTEGER,CONSTRAINT MAMMAL_FK_1 FOREIGN KEY(ZOOID) REFERENCES ZOO(ZOOID))
  +CREATE MEMORY TABLE REPTILE(ANIMALID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(60),AGE INTEGER,COLOR VARCHAR(60),ZOOID INTEGER,CONSTRAINT REPTILE_FK_1 FOREIGN KEY(ZOOID) REFERENCES ZOO(ZOOID))
  +CREATE MEMORY TABLE FISH(FOODID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(60),CALORIES INTEGER,TYPEOFWATER VARCHAR(60))
  +CREATE MEMORY TABLE SALAD(FOODID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(60),CALORIES INTEGER,COLOR VARCHAR(60))
  +CREATE MEMORY TABLE GOURMET(GOURMETID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(60))
  +CREATE MEMORY TABLE GOURMET_FOOD(GOURMET_ID INTEGER NOT NULL,FOOD_ID INTEGER NOT NULL,PRIMARY KEY(GOURMET_ID,FOOD_ID))
  +CREATE MEMORY TABLE GUIDTEST(GUID_ VARCHAR(60) NOT NULL PRIMARY KEY,GUIDVALUE VARCHAR(60))
  +CREATE MEMORY TABLE CONV_REFERER(PK1 INTEGER NOT NULL PRIMARY KEY,REF1 INTEGER,TEST_ID INTEGER)
  +CREATE MEMORY TABLE CONV_REFERED(PK1 INTEGER NOT NULL PRIMARY KEY,TEST_ID INTEGER)
  +CREATE MEMORY TABLE SITE(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100),SITEYEAR INTEGER,SEMESTER INTEGER,CONSTRAINT SYS_CT_97 UNIQUE(NAME))
  +CREATE MEMORY TABLE ODMG_DLIST(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100),RND_NAME VARCHAR(100))
  +CREATE MEMORY TABLE ROLLBACK_ONE(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100),DESCRIPTION VARCHAR(100))
  +CREATE MEMORY TABLE ROLLBACK_TWO(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100),DESCRIPTION VARCHAR(100))
  +CREATE MEMORY TABLE NEWS(ID INTEGER NOT NULL PRIMARY KEY,HEADLINE VARCHAR(50))
  +CREATE MEMORY TABLE PAPER(ID INTEGER NOT NULL PRIMARY KEY,HEADLINE VARCHAR(50),ISSUEDATE VARCHAR(50),AUTHOR VARCHAR(50))
  +CREATE MEMORY TABLE TOPIC(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(50),IMPORTANCE VARCHAR(50))
  +CREATE MEMORY TABLE CATEGORY(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(50),DESCRIPTION VARCHAR(50))
  +CREATE MEMORY TABLE AREA(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(50))
  +CREATE MEMORY TABLE CONTENT_QUALIFIER(CONTENT_ID INTEGER NOT NULL,QUALIFIER_ID INTEGER NOT NULL,PRIMARY KEY(CONTENT_ID,QUALIFIER_ID))
  +CREATE MEMORY TABLE SM_TAB_A(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
  +CREATE MEMORY TABLE SM_TAB_AA(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
  +CREATE MEMORY TABLE SM_TAB_AB(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
  +CREATE MEMORY TABLE SM_TAB_AAA(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
  +CREATE MEMORY TABLE SM_TAB_B(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
  +CREATE MEMORY TABLE SM_TAB_BB(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
  +CREATE MEMORY TABLE SM_SAME_TAB(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
  +CREATE MEMORY TABLE SM_AUTO_NAMING(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
  +CREATE MEMORY TABLE SM_TAB_MAX_A(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
  +CREATE MEMORY TABLE SM_TAB_MAX_AA(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
  +CREATE MEMORY TABLE SM_TAB_MAX_AB(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
  +CREATE MEMORY TABLE SM_TAB_MAX_AAA(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
  +CREATE MEMORY TABLE SM_TAB_MAX_B(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
  +CREATE MEMORY TABLE SM_TAB_MAX_BB(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
  +CREATE MEMORY TABLE SM_KEY(INT_KEY INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250),STRING_KEY VARCHAR(250),LONG_KEY BIGINT,INTEGER_KEY INTEGER)
  +CREATE MEMORY TABLE SM_MT_TEST_A(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100))
  +CREATE MEMORY TABLE SM_MT_TEST_B(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100))
  +CREATE MEMORY TABLE AUTO_INCREMENT(INT_ID INTEGER,INTEGER_ID INTEGER,STR_ID VARCHAR(255))
  +CREATE MEMORY TABLE EJB_CATEGORY(CATEGORY_ID INTEGER NOT NULL PRIMARY KEY,CATEGORY_NAME VARCHAR(80),DESCRIPTION VARCHAR(255))
  +CREATE MEMORY TABLE EJB_ARTICLE(ARTICLE_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(80),PRICE DECIMAL(15,2),DESCRIPTION VARCHAR(255),CATEGORY_ID INTEGER)
  +CREATE MEMORY TABLE EJB_PERSON(PERSON_ID INTEGER NOT NULL PRIMARY KEY,FIRST_NAME VARCHAR(80),LAST_NAME VARCHAR(80),GRADE VARCHAR(80))
  +CREATE MEMORY TABLE FIELD_CONVERSION_NODE(NODE_ID DECIMAL(15) NOT NULL,NODE_STATE INTEGER NOT NULL,PARENT_UID DECIMAL(15),PRIMARY KEY(NODE_ID,NODE_STATE))
  +CREATE MEMORY TABLE FIELD_CONVERSION_NODE_NOINC(NODE_ID DECIMAL(15) NOT NULL PRIMARY KEY)
  +CREATE MEMORY TABLE CONVERSION_VO(PK_WITH_AUTO INTEGER NOT NULL,PK_WITHOUT_AUTO INTEGER NOT NULL,NORMAL_WITH_AUTO INTEGER,NORMAL_WITHOUT_AUTO INTEGER,PRIMARY KEY(PK_WITH_AUTO,PK_WITHOUT_AUTO))
  +CREATE MEMORY TABLE NUMBER_ACCURACY_TEST(OBJ_ID INTEGER NOT NULL PRIMARY KEY,SCALE_TWO DECIMAL(15,6),SCALE_FOUR DECIMAL(15,6))
  +CREATE MEMORY TABLE PERF_ARTICLE(ARTICLE_ID INTEGER NOT NULL PRIMARY KEY,ARTICLE_NAME VARCHAR(150),MINIMUM_STOCK INTEGER,PRICE FLOAT,UNIT VARCHAR(20),STOCK INTEGER,SUPPLIER_ID INTEGER,PRODUCT_GROUP_ID INTEGER)
  +CREATE MEMORY TABLE BATCH_MAIN_OBJ(OBJ_ID BIGINT NOT NULL PRIMARY KEY,NAME VARCHAR(100))
  +CREATE MEMORY 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 MEMORY TABLE CACHE_TEST(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100))
  +CREATE MEMORY 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 MEMORY 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 MEMORY 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),PRIMARY KEY(REP_ID,REF_FK,REFA_FK,REFB_FK))
  +CREATE MEMORY 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 MEMORY TABLE REF_ANIMAL(A_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100),CLASS_NAME VARCHAR(100),LENGTH_ DOUBLE)
  +CREATE MEMORY TABLE REF_REGION(NAME VARCHAR(150) NOT NULL,COUNTRY VARCHAR(150) NOT NULL,DESCRIPTION VARCHAR(150),PRIMARY KEY(NAME,COUNTRY))
  +CREATE MEMORY 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),CONSTRAINT REF_WINE_FK_1 FOREIGN KEY(REGION_NAME,REGION_COUNTRY) REFERENCES REF_REGION(NAME,COUNTRY))
  +CREATE MEMORY TABLE REF_OBJ_A(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),FK_COL_REF INTEGER,FK_REF INTEGER)
  +CREATE MEMORY TABLE REF_OBJ_B(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),FK_COL_REF INTEGER,FK_REF INTEGER)
  +CREATE MEMORY TABLE REF_OBJ_C(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),NAME_C VARCHAR(150),FK_COL_REF INTEGER,FK_REF INTEGER)
  +CREATE MEMORY TABLE PKFK_PERSON(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150))
  +CREATE MEMORY TABLE PKFK_PERSON_DETAIL(OBJ_ID INTEGER NOT NULL PRIMARY KEY,PROFILE VARCHAR(150),FK_GENDER VARCHAR(150))
  +CREATE MEMORY TABLE PKFK_GENDER(TYPE VARCHAR(150) NOT NULL PRIMARY KEY)
  +CREATE MEMORY TABLE READTEST_ACCOUNT(OJB_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),FK_REF INTEGER)
  +CREATE MEMORY TABLE READTEST_BUYER(OJB_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),FK_REF INTEGER)
  +CREATE MEMORY TABLE READTEST_INVOICE(OJB_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),INVOICE_NUMBER VARCHAR(150),FK_REF INTEGER)
  +CREATE MEMORY TABLE READTEST_ARTICLE(OJB_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),DESCRIPTION VARCHAR(150),FK_REF INTEGER)
  +CREATE MEMORY TABLE READTEST_ADDRESS(OJB_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),FK_REF INTEGER)
  +CREATE MEMORY TABLE READTEST_ADDRESS_TYPE(OJB_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),FK_REF INTEGER)
  +CREATE MEMORY TABLE M2N_TEST_ACTOR(OBJ_ID INTEGER NOT NULL,OBJ_ID2 INTEGER NOT NULL,NAME VARCHAR(150),PRIMARY KEY(OBJ_ID,OBJ_ID2))
  +CREATE MEMORY 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),PRIMARY KEY(OBJ_ID_INT,OBJ_ID2_INT,OBJ_ID_STR))
  +CREATE MEMORY 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,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 MEMORY TABLE M2N_TEST_ROLE_2(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,PRIMARY KEY(ACTOR_ID,ACTOR_ID2,MOVIE_ID_INT,MOVIE_ID2_INT,MOVIE_ID_STR),CONSTRAINT M2N_TEST_ROLE_2_FK_1 FOREIGN KEY(ACTOR_ID,ACTOR_ID2) REFERENCES M2N_TEST_ACTOR(OBJ_ID,OBJ_ID2),CONSTRAINT M2N_TEST_ROLE_2_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 MEMORY TABLE M2N_OFFICE(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150))
  +CREATE MEMORY TABLE M2N_OFFICE_COUNTY(OFFICE_ID INTEGER NOT NULL,COUNTY_ID VARCHAR(150) NOT NULL,PRIMARY KEY(OFFICE_ID,COUNTY_ID))
  +CREATE MEMORY TABLE M2N_COUNTY(OBJ_ID VARCHAR(150) NOT NULL PRIMARY KEY,NAME VARCHAR(150))
  +CREATE MEMORY TABLE M2N_NODE(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150))
  +CREATE MEMORY TABLE M2N_KINDSHIP(PARENT_ID INTEGER NOT NULL,CHILD_ID INTEGER NOT NULL,PRIMARY KEY(PARENT_ID,CHILD_ID))
  +CREATE MEMORY TABLE COLLECTION_GATHERER(GAT_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150))
  +CREATE MEMORY 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 MEMORY 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 MEMORY 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 MEMORY 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 MEMORY 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 MEMORY TABLE COLLECTION_COLLECTIBLE_C2(COL_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),GAT_ID INTEGER,EXTENT_NAME VARCHAR(150),CONSTRAINT COLLECTION_COLLECTIBLE_C2_FK_1 FOREIGN KEY(GAT_ID) REFERENCES COLLECTION_GATHERER(GAT_ID))
  +CREATE MEMORY 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 MEMORY TABLE COLLECTION_2_PROJECT(PRO_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150))
  +CREATE MEMORY 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 MEMORY 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 MEMORY TABLE PB_AWARE_OBJECT(ID_ INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),FK_REF INTEGER)
  +CREATE MEMORY TABLE PB_AWARE_REF(ID_ INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150))
  +CREATE MEMORY TABLE PB_AWARE_COLL(ID_ INTEGER NOT NULL PRIMARY KEY,FK_PB_AWARE INTEGER,NAME VARCHAR(150))
  +CREATE MEMORY TABLE READONLY_TEST(OBJ_ID DECIMAL(15) NOT NULL PRIMARY KEY,NAME VARCHAR(150),RO_STRING VARCHAR(150),RO_LONG DECIMAL(15))
  +CREATE MEMORY TABLE TABLE_E(ID INTEGER NOT NULL PRIMARY KEY,SOMESUPERVALUE INTEGER)
  +CREATE MEMORY 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 MEMORY 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 MEMORY TABLE TABLE_F1(ID INTEGER NOT NULL PRIMARY KEY,SOMEVALUE INTEGER,CONSTRAINT TABLE_F1_FK_1 FOREIGN KEY(ID) REFERENCES TABLE_E(ID))
  +CREATE MEMORY TABLE TABLE_G1(ID INTEGER NOT NULL PRIMARY KEY,SOMESUBVALUE INTEGER,CONSTRAINT TABLE_G1_FK_1 FOREIGN KEY(ID) REFERENCES TABLE_F1(ID))
  +CREATE MEMORY TABLE ABSTRACT_COLLECTION_Z(OBJ_ID INTEGER NOT NULL PRIMARY KEY,CONTAINER_ID INTEGER,NAME VARCHAR(150),SOMEVALUE INTEGER)
  +CREATE MEMORY TABLE ABSTRACT_COLLECTION_ZZ(OBJ_ID INTEGER NOT NULL PRIMARY KEY,CONTAINER_ID INTEGER,NAME VARCHAR(150),ZZ_NAME VARCHAR(150),SOMEVALUE INTEGER)
  +CREATE MEMORY TABLE XCONTAINER(OBJ_ID INTEGER NOT NULL PRIMARY KEY)
  +CREATE MEMORY TABLE COL_BOOKSHELFS(PK INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100))
  +CREATE MEMORY TABLE COL_BOOKS(PK INTEGER NOT NULL,BOOKSHELF_FK INTEGER NOT NULL,PRIMARY KEY(PK,BOOKSHELF_FK))
  +CREATE MEMORY TABLE COL_DVDS(PK INTEGER NOT NULL,BOOKSHELF_FK INTEGER NOT NULL,PRIMARY KEY(PK,BOOKSHELF_FK))
  +CREATE MEMORY TABLE NESTED_FIELDS_TAB(OBJ_ID DECIMAL(15) NOT NULL PRIMARY KEY,NAME VARCHAR(150),NESTED_VALUE VARCHAR(150),NESTED_DESCRIPTION VARCHAR(150))
  +CREATE MEMORY TABLE NESTED_FIELDS_ENTRY(OBJ_ID INTEGER NOT NULL PRIMARY KEY,FK_ID DECIMAL(15),NAME VARCHAR(150))
  +CREATE MEMORY TABLE TAB_COMPONENT(PK_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),PARENT_ID INTEGER,CHILD_ID INTEGER,GROUP_ID INTEGER)
  +CREATE MEMORY TABLE TAB_GROUP(PK_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150))
  +CREATE MEMORY TABLE INHERITANCE_COMPANY(OBJ_ID DECIMAL(15) NOT NULL PRIMARY KEY,NAME VARCHAR(150))
  +CREATE MEMORY TABLE INHERITANCE_ADDRESS(OBJ_ID INTEGER NOT NULL PRIMARY KEY,STREET VARCHAR(150),FK_EMPLOYEE_1 INTEGER,FK_EMPLOYEE_2 DECIMAL(15))
  +CREATE MEMORY TABLE INHERITANCE_EMPLOYEE(OBJ_ID INTEGER NOT NULL,OBJ_ID_2 DECIMAL(15) NOT NULL,NAME VARCHAR(150),FK_ADDRESS INTEGER,PRIMARY KEY(OBJ_ID,OBJ_ID_2),CONSTRAINT INHERITANCE_EMPLOYEE_FK_1 FOREIGN KEY(FK_ADDRESS) REFERENCES INHERITANCE_ADDRESS(OBJ_ID))
  +CREATE MEMORY TABLE INHERITANCE_EXECUTIVE(OBJ_ID INTEGER NOT NULL,OBJ_ID_2 DECIMAL(15) NOT NULL,SUPER_ID INTEGER,SUPER_ID_2 DECIMAL(15),MANAGER_ID INTEGER,MANAGER_ID_2 DECIMAL(15),DEPARTMENT VARCHAR(150),PRIMARY KEY(OBJ_ID,OBJ_ID_2),CONSTRAINT INHERITANCE_EXECUTIVE_FK_1 FOREIGN KEY(SUPER_ID,SUPER_ID_2) REFERENCES INHERITANCE_EMPLOYEE(OBJ_ID,OBJ_ID_2))
  +CREATE MEMORY TABLE INHERITANCE_MANAGER(OBJ_ID INTEGER NOT NULL,OBJ_ID_2 DECIMAL(15) NOT NULL,FK_CONSORTIUM INTEGER,SUPER_ID INTEGER,SUPER_ID_2 DECIMAL(15),PRIMARY KEY(OBJ_ID,OBJ_ID_2),CONSTRAINT INHERITANCE_MANAGER_FK_1 FOREIGN KEY(SUPER_ID,SUPER_ID_2) REFERENCES INHERITANCE_EXECUTIVE(OBJ_ID,OBJ_ID_2))
  +CREATE MEMORY TABLE INHERITANCE_SHAREHOLDER(OBJ_ID INTEGER NOT NULL,OBJ_ID_2 DECIMAL(15) NOT NULL,SHARE_ INTEGER,SUPER_ID INTEGER,SUPER_ID_2 DECIMAL(15),PRIMARY KEY(OBJ_ID,OBJ_ID_2),CONSTRAINT INHERITANCE_SHAREHOLDER_FK_1 FOREIGN KEY(SUPER_ID,SUPER_ID_2) REFERENCES INHERITANCE_MANAGER(OBJ_ID,OBJ_ID_2))
  +CREATE MEMORY TABLE INHERITANCE_EMPLOYEE_ADDRESS(EMPLOYEE_ID_1 INTEGER NOT NULL,EMPLOYEE_ID_2 DECIMAL(15) NOT NULL,ADDRESS_ID INTEGER NOT NULL,PRIMARY KEY(EMPLOYEE_ID_1,EMPLOYEE_ID_2,ADDRESS_ID))
  +CREATE MEMORY TABLE INHERITANCE_CONSORTIUM(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150))
  +CREATE MEMORY TABLE INHERITANCE_ENTITY(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150))
  +CREATE MEMORY TABLE INHERITANCE_ANIMAL(OBJ_ID INTEGER NOT NULL PRIMARY KEY,WEIGHT INTEGER,NAME VARCHAR(150),FK_PARENT INTEGER)
  +CREATE MEMORY TABLE INHERITANCE_DOG(OBJ_ID INTEGER NOT NULL PRIMARY KEY,LEGS INTEGER)
  +CREATE MEMORY TABLE INHERITANCE_FOOD(OBJ_ID INTEGER NOT NULL PRIMARY KEY,FK_ANIMAL INTEGER)
  +CREATE MEMORY TABLE TREE_EXTENDED_NODE(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),PARENT_ID INTEGER,CHILD_ID INTEGER,CONSTRAINT TREE_EXTENDED_NODE_FK_1 FOREIGN KEY(CHILD_ID) REFERENCES TREE_EXTENDED_NODE(OBJ_ID),CONSTRAINT TREE_EXTENDED_NODE_FK_2 FOREIGN KEY(PARENT_ID) REFERENCES TREE_EXTENDED_NODE(OBJ_ID))
  +CREATE MEMORY TABLE RUNTIME_SETTING_ONE(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150))
  +CREATE MEMORY TABLE RUNTIME_SETTING_MAIN(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),FK_REF INTEGER,CONSTRAINT RUNTIME_SETTING_MAIN_FK_1 FOREIGN KEY(FK_REF) REFERENCES RUNTIME_SETTING_ONE(OBJ_ID))
  +CREATE MEMORY 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 MEMORY TABLE MULTIPLE_OBJECT(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150))
  +CREATE MEMORY TABLE LOCK_MULTI(OJB_ID INTEGER NOT NULL PRIMARY KEY,VERSION INTEGER,REF_ID INTEGER,NAME VARCHAR(250))
  +CREATE MEMORY TABLE LOCK_MULTI_REF(OJB_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250),VERSION INTEGER)
  +CREATE MEMORY TABLE IC_BOOK(OJB_ID INTEGER NOT NULL PRIMARY KEY,TITLE VARCHAR(250),P_DATE TIMESTAMP,COVER LONGVARBINARY,PUBLISHER_FK INTEGER,OJB_VERSION INTEGER)
  +CREATE MEMORY TABLE IC_AUTHOR(OJB_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250),OJB_VERSION INTEGER)
  +CREATE MEMORY TABLE IC_PUBLISHER(OJB_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250),OJB_VERSION INTEGER)
  +CREATE MEMORY TABLE IC_PUBLICATION(BOOK_ID INTEGER NOT NULL,AUTHOR_ID INTEGER NOT NULL,PRIMARY KEY(BOOK_ID,AUTHOR_ID))
  +CREATE MEMORY TABLE IC_REVIEW(OJB_ID INTEGER NOT NULL PRIMARY KEY,SUMMARY VARCHAR(250),FK_BOOK INTEGER,OJB_VERSION INTEGER,AUTHOR_FK INTEGER)
  +CREATE MEMORY TABLE CT_SHOP(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250),DETAIL_FK INTEGER)
  +CREATE MEMORY TABLE CT_DETAIL(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250),SHOP_FK INTEGER)
  +CREATE MEMORY TABLE CT_DISTRIBUTOR(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
  +CREATE MEMORY TABLE CT_PRODUCT(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250),SHOP_FK INTEGER,SUB_PRODUCT_FK INTEGER,CONSTRAINT CT_PRODUCT_FK_1 FOREIGN KEY(SUB_PRODUCT_FK) REFERENCES CT_PRODUCT(OBJ_ID),CONSTRAINT CT_PRODUCT_FK_2 FOREIGN KEY(SHOP_FK) REFERENCES CT_SHOP(OBJ_ID))
  +CREATE MEMORY TABLE CT_SHOP_DISTRIBUTOR(SHOP_ID INTEGER,DISTRIBUTOR_ID INTEGER,CONSTRAINT CT_SHOP_DISTRIBUTOR_FK_1 FOREIGN KEY(SHOP_ID) REFERENCES CT_SHOP(OBJ_ID),CONSTRAINT CT_SHOP_DISTRIBUTOR_FK_2 FOREIGN KEY(DISTRIBUTOR_ID) REFERENCES CT_DISTRIBUTOR(OBJ_ID))
  +CREATE MEMORY TABLE CT_OBJECT_A(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250),FK_ID INTEGER)
  +CREATE MEMORY TABLE CT_OBJECT_AA(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250),FK_ID INTEGER)
  +CREATE MEMORY TABLE CT_OBJECT_AAA(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250),FK_ID INTEGER,FK_ID_A INTEGER)
  +CREATE MEMORY TABLE CT_OBJECT_AAAA(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250),FK_ID INTEGER)
  +CREATE MEMORY TABLE CRT_EMPLOYEE(EMPLOYEE_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150))
  +CREATE MEMORY 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 MEMORY 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 MEMORY 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 MEMORY 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 MEMORY TABLE OTM_ADDRESS(ID INTEGER NOT NULL PRIMARY KEY,COUNTRY VARCHAR(60),CITY VARCHAR(60),STREET VARCHAR(60))
  +CREATE MEMORY TABLE OTM_PERSON(ID INTEGER NOT NULL PRIMARY KEY,FIRSTNAME VARCHAR(60),LASTNAME VARCHAR(60),MAIN_ADDRESS_ID INTEGER,CONSTRAINT OTM_PERSON_FK_1 FOREIGN KEY(MAIN_ADDRESS_ID) REFERENCES OTM_ADDRESS(ID))
  +CREATE MEMORY 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 MEMORY TABLE OTM_PERSON2(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(60))
  +CREATE MEMORY TABLE OTM_PERSON3(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(60))
  +CREATE MEMORY TABLE OTM_ADDRESS2(ID INTEGER NOT NULL PRIMARY KEY,PERSON_ID INTEGER)
  +CREATE MEMORY TABLE OTM_DEBITOR(ID INTEGER NOT NULL PRIMARY KEY,PERSON_ID INTEGER)
  +CREATE MEMORY TABLE P_A_TABLE(ID BIGINT NOT NULL PRIMARY KEY,A_ATTRIB INTEGER)
  +CREATE MEMORY 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 MEMORY 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 MEMORY TABLE P_D_TABLE(ID BIGINT NOT NULL PRIMARY KEY,D_ATTRIB INTEGER)
  +CREATE MEMORY TABLE INITIALIZABLE_OBJECT(ID BIGINT NOT NULL PRIMARY KEY)
  +CREATE MEMORY TABLE KATEGORIEN_2(KATEGORIE_NR INTEGER NOT NULL PRIMARY KEY,KATEGORIE_NAME VARCHAR(150),BESCHREIBUNG VARCHAR(150),CONSTRAINT SYS_CT_246 UNIQUE(KATEGORIE_NAME))
  +CREATE MEMORY TABLE ARTIKEL_2(ARTIKEL_NR INTEGER NOT NULL PRIMARY KEY,ARTIKELNAME VARCHAR(150),LIEFERANTEN_NR INTEGER,KATNAME VARCHAR(150),LIEFEREINHEIT VARCHAR(150),EINZELPREIS FLOAT,LAGERBESTAND INTEGER,BESTELLTEEINHEITEN INTEGER,MINDESTBESTAND INTEGER,AUSLAUFARTIKEL INTEGER,CONSTRAINT ARTIKEL_2_FK_1 FOREIGN KEY(KATNAME) REFERENCES KATEGORIEN_2(KATEGORIE_NAME))
  +CREATE MEMORY TABLE CONTAINER(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),PARENTID INTEGER,CONSTRAINT CONTAINER_FK_1 FOREIGN KEY(PARENTID) REFERENCES CONTAINER(ID))
  +CREATE MEMORY TABLE FACTORYCREATEDOBJECT(ID INTEGER NOT NULL PRIMARY KEY,VALUE_ INTEGER,NAME VARCHAR(150))
  +CREATE MEMORY TABLE FACTORYCREATEDBASEOBJECT(ID INTEGER NOT NULL PRIMARY KEY,VALUE_ INTEGER,NAME VARCHAR(150))
  +CREATE MEMORY TABLE FACTORYCREATEDSUBOBJECT(ID INTEGER NOT NULL PRIMARY KEY,SUPERID INTEGER,CONSTRAINT FACTORYCREATEDSUBOBJECT_FK_1 FOREIGN KEY(SUPERID) REFERENCES FACTORYCREATEDBASEOBJECT(ID))
  +CREATE MEMORY TABLE OJB_HL_SEQ(TABLENAME VARCHAR(250) NOT NULL PRIMARY KEY,MAX_KEY BIGINT,GRAB_SIZE INTEGER,VERSION INTEGER)
  +CREATE MEMORY TABLE OJB_NRM(NAME VARCHAR(250) NOT NULL PRIMARY KEY,OID_ LONGVARBINARY)
  +CREATE MEMORY TABLE OJB_DLIST(ID INTEGER NOT NULL PRIMARY KEY,SIZE_ INTEGER)
  +CREATE MEMORY TABLE OJB_DLIST_ENTRIES(ID INTEGER NOT NULL PRIMARY KEY,DLIST_ID INTEGER,POSITION_ INTEGER,OID_ LONGVARBINARY)
  +CREATE MEMORY TABLE OJB_DSET(ID INTEGER NOT NULL PRIMARY KEY,SIZE_ INTEGER)
  +CREATE MEMORY TABLE OJB_DSET_ENTRIES(ID INTEGER NOT NULL PRIMARY KEY,DLIST_ID INTEGER,POSITION_ INTEGER,OID_ LONGVARBINARY)
  +CREATE MEMORY TABLE OJB_DMAP(ID INTEGER NOT NULL PRIMARY KEY,SIZE_ INTEGER)
  +CREATE MEMORY TABLE OJB_DMAP_ENTRIES(ID INTEGER NOT NULL PRIMARY KEY,DMAP_ID INTEGER,KEY_OID BINARY,VALUE_OID BINARY)
   ALTER TABLE CT_SHOP ADD CONSTRAINT CT_SHOP_FK_1 FOREIGN KEY(DETAIL_FK) REFERENCES CT_DETAIL(OBJ_ID)
   ALTER TABLE CT_OBJECT_A ADD CONSTRAINT CT_OBJECT_A_FK_1 FOREIGN KEY(FK_ID) REFERENCES CT_OBJECT_AA(OBJ_ID)
   ALTER TABLE CT_OBJECT_AA ADD CONSTRAINT CT_OBJECT_AA_FK_1 FOREIGN KEY(FK_ID) REFERENCES CT_OBJECT_AAA(OBJ_ID)
   ALTER TABLE CT_OBJECT_AAA ADD CONSTRAINT CT_OBJECT_AAA_FK_1 FOREIGN KEY(FK_ID) REFERENCES CT_OBJECT_AAAA(OBJ_ID)
  -CREATE USER SA PASSWORD "" ADMIN
  -SET WRITE_DELAY 60
  +CREATE USER SA PASSWORD ""
  +GRANT DBA TO SA
  +SET WRITE_DELAY 20
  +SET SCHEMA PUBLIC
   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','')
  @@ -376,4 +383,4 @@
   INSERT INTO SM_TAB_MAX_BB VALUES(130,'BB')
   INSERT INTO SM_TAB_MAX_BB VALUES(131,'BB')
   INSERT INTO INITIALIZABLE_OBJECT VALUES(1)
  -INSERT INTO INITIALIZABLE_OBJECT VALUES(2)
  \ No newline at end of file
  +INSERT INTO INITIALIZABLE_OBJECT VALUES(2)
  
  
  

---------------------------------------------------------------------
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