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, 27 Aug 2005 14:31:34 GMT
arminw      2005/08/27 07:31:34

  Modified:    src/test/org/apache/ojb/quick-db OJB.properties OJB.script
  Log:
  merge 1.x trunk with 1.0.x branch
  
  Revision  Changes    Path
  1.33      +17 -13    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.32
  retrieving revision 1.33
  diff -u -r1.32 -r1.33
  --- OJB.properties	14 Jun 2004 12:27:15 -0000	1.32
  +++ OJB.properties	27 Aug 2005 14:31:34 -0000	1.33
  @@ -1,16 +1,20 @@
   #HSQL database
  -#Mon Jun 14 14:19:11 CEST 2004
  -sql.strict_fk=true
  -readonly=false
  -sql.strong_fk=true
  -hsqldb.version=1.7.1
  -version=1.7.1
  -hsqldb.cache_scale=14
  -sql.compare_in_locale=false
  -sql.month=true
  -hsqldb.log_size=200
  +#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
  -hsqldb.cache_version=1.7.0
  -hsqldb.original_version=1.7.1
  -hsqldb.compatible_version=1.7.0
  +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
  +sql.enforce_strict_size=false
  +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
  
  
  
  1.34      +98 -127   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.33
  retrieving revision 1.34
  diff -u -r1.33 -r1.34
  --- OJB.script	26 Jun 2004 23:47:26 -0000	1.33
  +++ OJB.script	27 Aug 2005 14:31:34 -0000	1.34
  @@ -1,44 +1,47 @@
  -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 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(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 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(50),LOCATION 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(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 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 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 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 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 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))
  @@ -52,8 +55,8 @@
   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 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))
  @@ -78,9 +81,10 @@
   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 DOUBLE,UNIT VARCHAR(20),STOCK INTEGER,SUPPLIER_ID INTEGER,PRODUCT_GROUP_ID INTEGER)
  +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))
  @@ -89,21 +93,27 @@
   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 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))
  @@ -117,7 +127,10 @@
   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 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))
  @@ -129,27 +142,50 @@
   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 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_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 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_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_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))
  @@ -159,8 +195,10 @@
   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 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)
  @@ -168,85 +206,12 @@
   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
  +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
  -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"
  +SET WRITE_DELAY 60
   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','')
  @@ -255,6 +220,7 @@
   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 KATEGORIEN VALUES(4711,'Random Articles','Used for MetadataMultithreadedTest')
   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)
  @@ -332,6 +298,9 @@
   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 ARTIKEL VALUES(4711,'Proxied Article 1',12,4711,'1 Java class',1.3E0,5,0,1,0)
  +INSERT INTO ARTIKEL VALUES(4712,'Proxied Article 2',12,4711,'1 Java class',1.5E0,2,0,0,0)
  +INSERT INTO ARTIKEL VALUES(4713,'Proxied Article 3',12,4711,'1 Java class',1.9E0,7,0,5,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')
  @@ -385,10 +354,10 @@
   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 TOPIC VALUES(10,'Buyers',NULL)
  +INSERT INTO TOPIC VALUES(11,'Sellers',NULL)
  +INSERT INTO CATEGORY VALUES(1,'Cars',NULL)
  +INSERT INTO CATEGORY VALUES(2,'Sports',NULL)
   INSERT INTO AREA VALUES(20,'Human')
   INSERT INTO AREA VALUES(21,'NotHuman')
   INSERT INTO CONTENT_QUALIFIER VALUES(2,1)
  @@ -406,3 +375,5 @@
   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')
  +INSERT INTO INITIALIZABLE_OBJECT VALUES(1)
  +INSERT INTO INITIALIZABLE_OBJECT VALUES(2)
  \ No newline at end of file
  
  
  

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