You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-dev@db.apache.org by ar...@apache.org on 2003/12/11 21:13:23 UTC
cvs commit: db-ojb/src/test/org/apache/ojb/quick-db OJB.script OJB.properties
arminw 2003/12/11 12:13:23
Modified: src/test/org/apache/ojb repository_junit_odmg.xml
src/test/org/apache/ojb/odmg LockingTest.java AllTests.java
src/schema ojbtest-schema.xml
src/test/org/apache/ojb/quick-db OJB.script OJB.properties
Added: src/test/org/apache/ojb/odmg LockingMultithreadedTest.java
Log:
add multithreaded locking test against odmg api
Revision Changes Path
1.2 +73 -1 db-ojb/src/test/org/apache/ojb/repository_junit_odmg.xml
Index: repository_junit_odmg.xml
===================================================================
RCS file: /home/cvs/db-ojb/src/test/org/apache/ojb/repository_junit_odmg.xml,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- repository_junit_odmg.xml 9 Dec 2003 13:46:46 -0000 1.1
+++ repository_junit_odmg.xml 11 Dec 2003 20:13:23 -0000 1.2
@@ -793,4 +793,76 @@
</reference-descriptor>
</class-descriptor>
+
+ <!-- ************************************************* -->
+ <!-- Multithreaded lock test -->
+ <!-- ************************************************* -->
+ <class-descriptor
+ class="org.apache.ojb.odmg.LockingMultithreadedTest$LockObject"
+ table="LOCK_MULTI"
+ >
+ <field-descriptor
+ name="id"
+ column="OJB_ID"
+ jdbc-type="INTEGER"
+ primarykey="true"
+ autoincrement="true"
+ />
+
+ <field-descriptor
+ name="name"
+ column="NAME"
+ jdbc-type="VARCHAR"
+ />
+
+ <field-descriptor
+ name="refId"
+ column="REF_ID"
+ jdbc-type="INTEGER"
+ access="anonymous"
+ />
+
+ <field-descriptor
+ name="version"
+ column="VERSION"
+ jdbc-type="INTEGER"
+ locking="false"
+ />
+
+ <reference-descriptor
+ name="reference"
+ class-ref="org.apache.ojb.odmg.LockingMultithreadedTest$LockObjectRef"
+ proxy="false"
+ auto-retrieve="true"
+ auto-update="true"
+ auto-delete="true">
+ <foreignkey field-ref="refId"/>
+ </reference-descriptor>
+ </class-descriptor>
+
+ <class-descriptor
+ class="org.apache.ojb.odmg.LockingMultithreadedTest$LockObjectRef"
+ table="LOCK_MULTI_REF"
+ >
+ <field-descriptor
+ name="id"
+ column="OJB_ID"
+ jdbc-type="INTEGER"
+ primarykey="true"
+ autoincrement="true"
+ />
+
+ <field-descriptor
+ name="name"
+ column="NAME"
+ jdbc-type="VARCHAR"
+ />
+
+ <field-descriptor
+ name="version"
+ column="VERSION"
+ jdbc-type="INTEGER"
+ locking="false"
+ />
+ </class-descriptor>
<!-- Mapping of classes used in junit tests and tutorials ends here -->
1.11 +0 -6 db-ojb/src/test/org/apache/ojb/odmg/LockingTest.java
Index: LockingTest.java
===================================================================
RCS file: /home/cvs/db-ojb/src/test/org/apache/ojb/odmg/LockingTest.java,v
retrieving revision 1.10
retrieving revision 1.11
diff -u -r1.10 -r1.11
--- LockingTest.java 9 Dec 2003 13:46:46 -0000 1.10
+++ LockingTest.java 11 Dec 2003 20:13:23 -0000 1.11
@@ -208,10 +208,4 @@
broker.close();
assertEquals("Wrong number of objects wrote to DB", loops, result);
}
-
- public void testMultithreadedLocking()
- {
- fail("Test is not implemented. We need a test case check locking in multithreaded test case." +
- "User post message about locking deadlock.");
- }
}
1.16 +1 -0 db-ojb/src/test/org/apache/ojb/odmg/AllTests.java
Index: AllTests.java
===================================================================
RCS file: /home/cvs/db-ojb/src/test/org/apache/ojb/odmg/AllTests.java,v
retrieving revision 1.15
retrieving revision 1.16
diff -u -r1.15 -r1.16
--- AllTests.java 26 Oct 2003 17:18:33 -0000 1.15
+++ AllTests.java 11 Dec 2003 20:13:23 -0000 1.16
@@ -27,6 +27,7 @@
suite.addTestSuite(DListTest.class);
suite.addTestSuite(DMapTest.class);
suite.addTestSuite(LockingTest.class);
+ suite.addTestSuite(LockingMultithreadedTest.class);
suite.addTestSuite(LockTestSerializable.class);
suite.addTestSuite(LockTestRepeatableReads.class);
suite.addTestSuite(LockTestCommitedReads.class);
1.1 db-ojb/src/test/org/apache/ojb/odmg/LockingMultithreadedTest.java
Index: LockingMultithreadedTest.java
===================================================================
package org.apache.ojb.odmg;
import org.apache.ojb.broker.JUnitExtensions;
import org.apache.ojb.broker.TestHelper;
import org.apache.ojb.broker.util.logging.LoggerFactory;
import org.odmg.Database;
import org.odmg.Implementation;
import org.odmg.LockNotGrantedException;
import org.odmg.Transaction;
/**
* Test odmg-locking implementation with multiple threads.
* Different threads try to update the same instance / or a copy
* of the same object.
*
* @author <a href="mailto:armin@codeAuLait.de">Armin Waibel</a>
* @version $Id: LockingMultithreadedTest.java,v 1.1 2003/12/11 20:13:23 arminw Exp $
*/
public class LockingMultithreadedTest extends JUnitExtensions.MultiThreadedTestCase
{
private static int threadCount;
private static Implementation odmg;
private static Database db;
public static void main(String[] args)
{
String[] arr = {LockingMultithreadedTest.class.getName()};
junit.textui.TestRunner.main(arr);
}
public LockingMultithreadedTest(String s)
{
super(s);
}
protected void setUp() throws Exception
{
super.setUp();
}
protected void tearDown() throws Exception
{
super.tearDown();
}
public void testLockingOfObject() throws Exception
{
/*
odmg api is threadsafe, so we can share Implementation instance
among the different threads
*/
odmg = OJB.getInstance();
db = odmg.newDatabase();
db.open(TestHelper.DEF_DATABASE_NAME, Database.OPEN_READ_WRITE);
LockObject targetObject = createLockObjectWithRef();
storeObject(targetObject);
// number of concurrent threads to run
int threads = 6;
// number of updates each thread performs against the object
int objectUpdates = 30;
TestCaseRunnable tct [] = new TestCaseRunnable[threads];
for (int i = 0; i < threads; i++)
{
/*
several threads try to lock the same object (shared object),
the other threads lock deep copies of the shared object
*/
if (i % 2 == 0)
tct[i] = new LockHandle(targetObject, objectUpdates);
else
tct[i] = new LockHandle(targetObject.makeCopy(), objectUpdates);
}
// run test classes
runTestCaseRunnables(tct);
System.out.println("*** Result of multithreaded lock test ***");
System.out.println(targetObject.getName());
System.out.println(targetObject.getReference().getName());
}
private LockObject createLockObjectWithRef()
{
int number = newThreadKey();
LockObject lo = new LockObject();
lo.setName("mod by thread: " + number);
LockObjectRef lor = new LockObjectRef();
lor.setName("mod by thread: " + number);
lo.setReference(lor);
return lo;
}
private void storeObject(Object obj) throws Exception
{
Transaction tx = odmg.newTransaction();
tx.begin();
tx.lock(obj, Transaction.WRITE);
tx.commit();
}
public static synchronized int newThreadKey()
{
return threadCount++;
}
//=======================================================================
// inner classes
//=======================================================================
class LockHandle extends JUnitExtensions.MultiThreadedTestCase.TestCaseRunnable
{
LockObject obj;
int threadNumber;
int objectUpdates = 30;
public LockHandle(LockObject obj, int objectUpdates)
{
super();
this.objectUpdates = objectUpdates;
this.obj = obj;
}
public void runTestCase() throws Throwable
{
threadNumber = newThreadKey();
Transaction tx = odmg.newTransaction();
for (int i = 0; i < objectUpdates; i++)
{
tx.begin();
updateObject(tx, obj);
tx.commit();
}
}
private int counter = 0;
private static final int maxAttemps = 100;
private static final int nearMax = (int) (maxAttemps * 0.7);
private void updateObject(Transaction tx, LockObject obj) throws Exception
{
try
{
tx.lock(obj, Transaction.WRITE);
updateName(obj);
updateName(obj.getReference());
}
catch (LockNotGrantedException e)
{
if (counter < maxAttemps)
{
counter++;
if (counter > nearMax)
LoggerFactory.getDefaultLogger().warn("### thread " + threadNumber
+ " waits " + counter + " times. Maximal attempts are " + maxAttemps);
Thread.sleep(10);
updateObject(tx, obj);
}
else
{
LoggerFactory.getDefaultLogger().error("* Can't lock given object, will throw exception" +
" for thread number " + threadNumber + " *");
throw e;
}
}
finally
{
counter = 0;
}
}
private void updateName(LockObject obj)
{
if (obj.getName().length() < 230)
{
obj.setName(obj.getName() + "-" + threadNumber);
}
else
{
obj.setName("carryOver, mod by thread: " + threadNumber);
}
}
private void updateName(LockObjectRef obj)
{
if (obj.getName().length() < 230)
{
obj.setName(obj.getName() + "-" + threadNumber);
}
else
{
obj.setName("carryOver, mod by thread: " + threadNumber);
}
}
}
public static class LockObject
{
private Integer id;
private String name;
private Integer version;
private LockObjectRef reference;
public LockObject()
{
}
private LockObject(Integer id, String name, Integer version, LockObjectRef reference)
{
this.id = id;
this.name = name;
this.version = version;
this.reference = reference;
}
public LockObject makeCopy()
{
return new LockObject(id, name, version, reference != null ? reference.makeCopy() : null);
}
public Integer getId()
{
return id;
}
public void setId(Integer id)
{
this.id = id;
}
public String getName()
{
return name;
}
public void setName(String name)
{
this.name = name;
}
public Integer getVersion()
{
return version;
}
public void setVersion(Integer version)
{
this.version = version;
}
public LockObjectRef getReference()
{
return reference;
}
public void setReference(LockObjectRef reference)
{
this.reference = reference;
}
}
public static class LockObjectRef
{
private Integer id;
private String name;
private Integer version;
public LockObjectRef()
{
}
private LockObjectRef(Integer id, String name, Integer version)
{
this.id = id;
this.name = name;
this.version = version;
}
public LockObjectRef makeCopy()
{
return new LockObjectRef(id, name, version);
}
public Integer getId()
{
return id;
}
public void setId(Integer id)
{
this.id = id;
}
public String getName()
{
return name;
}
public void setName(String name)
{
this.name = name;
}
public Integer getVersion()
{
return version;
}
public void setVersion(Integer version)
{
this.version = version;
}
}
}
1.58 +17 -0 db-ojb/src/schema/ojbtest-schema.xml
Index: ojbtest-schema.xml
===================================================================
RCS file: /home/cvs/db-ojb/src/schema/ojbtest-schema.xml,v
retrieving revision 1.57
retrieving revision 1.58
diff -u -r1.57 -r1.58
--- ojbtest-schema.xml 9 Dec 2003 13:46:47 -0000 1.57
+++ ojbtest-schema.xml 11 Dec 2003 20:13:23 -0000 1.58
@@ -918,6 +918,23 @@
<!-- =================================================== -->
+ <!-- Multithreaded lock test - odmg -->
+ <!-- =================================================== -->
+ <table name="LOCK_MULTI">
+ <column name="OJB_ID" required="true" primaryKey="true" type="INTEGER"/>
+ <column name="VERSION" type="INTEGER"/>
+ <column name="REF_ID" type="INTEGER"/>
+ <column name="NAME" type="VARCHAR" size="250"/>
+ </table>
+
+ <table name="LOCK_MULTI_REF">
+ <column name="OJB_ID" required="true" primaryKey="true" type="INTEGER"/>
+ <column name="NAME" type="VARCHAR" size="250"/>
+ <column name="VERSION" type="INTEGER"/>
+ </table>
+
+
+ <!-- =================================================== -->
<!-- Complex test model tables -->
<!-- =================================================== -->
<table name="CRT_EMPLOYEE">
1.28 +358 -347 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.27
retrieving revision 1.28
diff -u -r1.27 -r1.28
--- OJB.script 6 Dec 2003 19:06:24 -0000 1.27
+++ OJB.script 11 Dec 2003 20:13:23 -0000 1.28
@@ -1,347 +1,358 @@
-CREATE TABLE KATEGORIEN(KATEGORIE_NR INTEGER NOT NULL PRIMARY KEY,KATEGORIENAME VARCHAR(60),BESCHREIBUNG VARCHAR(60))
-CREATE TABLE ARTIKEL(ARTIKEL_NR INTEGER NOT NULL PRIMARY KEY,ARTIKELNAME VARCHAR(60),LIEFERANTEN_NR INTEGER,KATEGORIE_NR INTEGER,LIEFEREINHEIT VARCHAR(30),EINZELPREIS FLOAT,LAGERBESTAND INTEGER,BESTELLTEEINHEITEN INTEGER,MINDESTBESTAND INTEGER,AUSLAUFARTIKEL INTEGER,CONSTRAINT ARTIKEL_FK_1 FOREIGN KEY(KATEGORIE_NR) REFERENCES KATEGORIEN(KATEGORIE_NR))
-CREATE TABLE BOOKS(ARTIKEL_NR INTEGER NOT NULL PRIMARY KEY,ARTIKELNAME VARCHAR(60),LIEFERANTEN_NR INTEGER,KATEGORIE_NR INTEGER,LIEFEREINHEIT VARCHAR(30),EINZELPREIS FLOAT,LAGERBESTAND INTEGER,BESTELLTEEINHEITEN INTEGER,MINDESTBESTAND INTEGER,AUSLAUFARTIKEL INTEGER,ISBN VARCHAR(10),AUTHOR VARCHAR(50),CONSTRAINT BOOKS_FK_1 FOREIGN KEY(KATEGORIE_NR) REFERENCES KATEGORIEN(KATEGORIE_NR))
-CREATE TABLE CDS(ARTIKEL_NR INTEGER NOT NULL PRIMARY KEY,ARTIKELNAME VARCHAR(60),LIEFERANTEN_NR INTEGER,KATEGORIE_NR INTEGER,LIEFEREINHEIT VARCHAR(30),EINZELPREIS FLOAT,LAGERBESTAND INTEGER,BESTELLTEEINHEITEN INTEGER,MINDESTBESTAND INTEGER,AUSLAUFARTIKEL INTEGER,LABEL VARCHAR(50),MUSICIANS VARCHAR(250),CONSTRAINT CDS_FK_1 FOREIGN KEY(KATEGORIE_NR) REFERENCES KATEGORIEN(KATEGORIE_NR))
-CREATE TABLE ORDER_POSITION(ID INTEGER NOT NULL PRIMARY KEY,ORDER_ID INTEGER,ARTICLE_ID INTEGER)
-CREATE TABLE TREE(ID INTEGER NOT NULL PRIMARY KEY,DATA VARCHAR(50),PARENT_ID INTEGER)
-CREATE TABLE TREEGROUP(ID INTEGER NOT NULL PRIMARY KEY,DATA VARCHAR(50),PARENT_ID INTEGER,GROUP_ID INTEGER)
-CREATE TABLE AB_TABLE(ID INTEGER NOT NULL PRIMARY KEY,CLASS_NAME VARCHAR(60),VALUE_ INTEGER,A_FIELD VARCHAR(60),B_FIELD VARCHAR(60))
-CREATE TABLE PRODUCT(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100),PRICE FLOAT,STOCK INTEGER)
-CREATE TABLE PERSON(ID INTEGER NOT NULL PRIMARY KEY,FIRSTNAME VARCHAR(50),LASTNAME VARCHAR(50))
-CREATE TABLE PROJECT(ID INTEGER NOT NULL PRIMARY KEY,TITLE VARCHAR(50),DESCRIPTION VARCHAR(250))
-CREATE TABLE PERSON_PROJECT(PERSON_ID INTEGER NOT NULL,PROJECT_ID INTEGER NOT NULL,ROLENAME VARCHAR(20),CONSTRAINT SYS_PK_PERSON_PROJECT PRIMARY KEY(PERSON_ID,PROJECT_ID),CONSTRAINT PERSON_PROJECT_FK_1 FOREIGN KEY(PERSON_ID) REFERENCES PERSON(ID),CONSTRAINT PERSON_PROJECT_FK_2 FOREIGN KEY(PROJECT_ID) REFERENCES PROJECT(ID))
-CREATE TABLE TASK(TASK_ID INTEGER NOT NULL PRIMARY KEY,PERSON_ID INTEGER,PROJECT_ID INTEGER,TASKNAME VARCHAR(20),CONSTRAINT TASK_FK_1 FOREIGN KEY(PERSON_ID,PROJECT_ID) REFERENCES PERSON_PROJECT(PERSON_ID,PROJECT_ID))
-CREATE TABLE FAMILY_MEMBER(ID INTEGER NOT NULL PRIMARY KEY,FIRSTNAME VARCHAR(50),LASTNAME VARCHAR(50),MOTHER_ID INTEGER,FATHER_ID INTEGER)
-CREATE TABLE LOCKED_BY_VERSION(ID INTEGER NOT NULL PRIMARY KEY,VALUE_ VARCHAR(60),VERSION_ INTEGER)
-CREATE TABLE LOCKED_BY_TIMESTAMP(ID INTEGER NOT NULL PRIMARY KEY,VALUE_ VARCHAR(60),TIMESTAMP_ TIMESTAMP)
-CREATE TABLE BLOB_TEST(ID INTEGER NOT NULL PRIMARY KEY,BLOB_VALUE_ LONGVARBINARY,CLOB_VALUE_ VARCHAR)
-CREATE TABLE MDTEST_MASTER(MASTERID INTEGER NOT NULL PRIMARY KEY,MASTER_TEXT VARCHAR(255))
-CREATE TABLE MDTEST_DETAIL_FKINPK(MASTERID INTEGER NOT NULL,DETAILID INTEGER NOT NULL,DETAIL_TEXT VARCHAR(255),CONSTRAINT SYS_PK_MDTEST_DETAIL_FKINPK PRIMARY KEY(MASTERID,DETAILID),CONSTRAINT MDTEST_DETAIL_FKINPK_FK_1 FOREIGN KEY(MASTERID) REFERENCES MDTEST_MASTER(MASTERID))
-CREATE TABLE MDTEST_DETAIL_FKNOPK(DETAILID INTEGER NOT NULL PRIMARY KEY,MASTERID INTEGER,DETAIL_TEXT VARCHAR(255),CONSTRAINT MDTEST_DETAIL_FKNOPK_FK_1 FOREIGN KEY(MASTERID) REFERENCES MDTEST_MASTER(MASTERID))
-CREATE TABLE POINT_TABLE(ID INTEGER NOT NULL PRIMARY KEY,X INTEGER,Y INTEGER)
-CREATE TABLE GRAPH_NODE(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(50),LOCATION INTEGER)
-CREATE TABLE GRAPH_EDGE(ID INTEGER NOT NULL PRIMARY KEY,SOURCE INTEGER,SINK INTEGER)
-CREATE TABLE TESTCLASSA(ID VARCHAR(48) NOT NULL PRIMARY KEY,VALUE1 VARCHAR(64),VALUE2 VARCHAR(64),VALUE3 INTEGER,BOID VARCHAR(48))
-CREATE TABLE TESTCLASSB(ID VARCHAR(48) NOT NULL PRIMARY KEY,VALUE1 VARCHAR(64),AOID VARCHAR(48))
-CREATE TABLE RELATEDTOCONTRACT(PK VARCHAR(48) NOT NULL PRIMARY KEY,RELATEDVALUE1 VARCHAR(64),RELATEDVALUE2 INTEGER,RELATEDVALUE3 TIMESTAMP)
-CREATE TABLE CONTRACT(PK VARCHAR(48) NOT NULL PRIMARY KEY,FK_TO_RELATED VARCHAR(48),CONTRACT_VALUE1 VARCHAR(64),CONTRACT_VALUE2 INTEGER,CONTRACT_VALUE3 VARCHAR(64),CONTRACT_VALUE4 TIMESTAMP,CONSTRAINT CONTRACT_FK_1 FOREIGN KEY(FK_TO_RELATED) REFERENCES RELATEDTOCONTRACT(PK))
-CREATE TABLE VERSION(PK VARCHAR(48) NOT NULL PRIMARY KEY,FK_TO_CONTRACT VARCHAR(48),VERSION_VALUE1 VARCHAR(64),VERSION_VALUE2 INTEGER,VERSION_VALUE3 TIMESTAMP,CONSTRAINT VERSION_FK_1 FOREIGN KEY(FK_TO_CONTRACT) REFERENCES CONTRACT(PK))
-CREATE TABLE EFFECTIVENESS(PK VARCHAR(48) NOT NULL PRIMARY KEY,FK_TO_VERSION VARCHAR(48),EFF_VALUE1 VARCHAR(64),EFF_VALUE2 INTEGER,EFF_VALUE3 TIMESTAMP,CONSTRAINT EFFECTIVENESS_FK_1 FOREIGN KEY(FK_TO_VERSION) REFERENCES VERSION(PK))
-CREATE TABLE MULTIMAPPEDTABLE(ID INTEGER NOT NULL PRIMARY KEY,VALUE1 VARCHAR(64),VALUE2 INTEGER,VALUE3 TIMESTAMP,VALUE4 VARCHAR(64),VALUE5 INTEGER,VALUE6 TIMESTAMP,VALUE7 VARCHAR(64),OJBCONCRETECLASS VARCHAR(64))
-CREATE TABLE EXTENT_TEST_A(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100))
-CREATE TABLE EXTENT_TEST_B(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100))
-CREATE TABLE EXTENT_TEST_C(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100))
-CREATE TABLE EXTENT_TEST_D(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100))
-CREATE TABLE TABLE_1(PK INTEGER NOT NULL PRIMARY KEY,FK_TO_RELATED INTEGER)
-CREATE TABLE TABLE_2(PK INTEGER NOT NULL PRIMARY KEY)
-CREATE TABLE BIDIR_A(PK VARCHAR(48) NOT NULL PRIMARY KEY,FK_TO_B VARCHAR(48))
-CREATE TABLE BIDIR_B(PK VARCHAR(48) NOT NULL PRIMARY KEY,FK_TO_A VARCHAR(48),CONSTRAINT BIDIR_B_FK_1 FOREIGN KEY(FK_TO_A) REFERENCES BIDIR_A(PK))
-CREATE TABLE MAMMAL(ANIMALID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(60),AGE INTEGER,NUMLEGS INTEGER,ZOOID INTEGER)
-CREATE TABLE REPTILE(ANIMALID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(60),AGE INTEGER,COLOR VARCHAR(60),ZOOID INTEGER)
-CREATE TABLE ZOO(ZOOID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(60))
-CREATE TABLE FISH(FOODID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(60),CALORIES INTEGER,TYPEOFWATER VARCHAR(60))
-CREATE TABLE SALAD(FOODID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(60),CALORIES INTEGER,COLOR VARCHAR(60))
-CREATE TABLE GOURMET(GOURMETID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(60))
-CREATE TABLE GOURMET_FOOD(GOURMET_ID INTEGER NOT NULL,FOOD_ID INTEGER NOT NULL,CONSTRAINT SYS_PK_GOURMET_FOOD PRIMARY KEY(GOURMET_ID,FOOD_ID))
-CREATE TABLE GUIDTEST(GUID_ VARCHAR(60) NOT NULL PRIMARY KEY,GUIDVALUE VARCHAR(60))
-CREATE TABLE CONV_REFERER(PK1 INTEGER NOT NULL PRIMARY KEY,REF1 INTEGER,TEST_ID INTEGER)
-CREATE TABLE CONV_REFERED(PK1 INTEGER NOT NULL PRIMARY KEY,TEST_ID INTEGER)
-CREATE TABLE SITE(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100),SITEYEAR INTEGER,SEMESTER INTEGER,CONSTRAINT SYS_CT_3 UNIQUE(NAME))
-CREATE TABLE ODMG_DLIST(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100),RND_NAME VARCHAR(100))
-CREATE TABLE ROLLBACK_ONE(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100),DESCRIPTION VARCHAR(100))
-CREATE TABLE ROLLBACK_TWO(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100),DESCRIPTION VARCHAR(100))
-CREATE TABLE NEWS(ID INTEGER NOT NULL PRIMARY KEY,HEADLINE VARCHAR(50))
-CREATE TABLE PAPER(ID INTEGER NOT NULL PRIMARY KEY,HEADLINE VARCHAR(50),ISSUEDATE VARCHAR(50),AUTHOR VARCHAR(50))
-CREATE TABLE TOPIC(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(50))
-CREATE TABLE CATEGORY(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(50))
-CREATE TABLE AREA(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(50))
-CREATE TABLE CONTENT_QUALIFIER(CONTENT_ID INTEGER NOT NULL,QUALIFIER_ID INTEGER NOT NULL,CONSTRAINT SYS_PK_CONTENT_QUALIFIER PRIMARY KEY(CONTENT_ID,QUALIFIER_ID))
-CREATE TABLE SM_TAB_A(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
-CREATE TABLE SM_TAB_AA(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
-CREATE TABLE SM_TAB_AB(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
-CREATE TABLE SM_TAB_AAA(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
-CREATE TABLE SM_TAB_B(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
-CREATE TABLE SM_TAB_BB(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
-CREATE TABLE SM_SAME_TAB(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
-CREATE TABLE SM_AUTO_NAMING(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
-CREATE TABLE SM_TAB_MAX_A(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
-CREATE TABLE SM_TAB_MAX_AA(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
-CREATE TABLE SM_TAB_MAX_AB(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
-CREATE TABLE SM_TAB_MAX_AAA(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
-CREATE TABLE SM_TAB_MAX_B(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
-CREATE TABLE SM_TAB_MAX_BB(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
-CREATE TABLE SM_KEY(INT_KEY INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250),STRING_KEY VARCHAR(250),LONG_KEY BIGINT,INTEGER_KEY INTEGER)
-CREATE TABLE SM_MT_TEST_A(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100))
-CREATE TABLE SM_MT_TEST_B(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100))
-CREATE TABLE EJB_CATEGORY(CATEGORY_ID INTEGER NOT NULL PRIMARY KEY,CATEGORY_NAME VARCHAR(80),DESCRIPTION VARCHAR(255))
-CREATE TABLE EJB_ARTICLE(ARTICLE_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(80),PRICE DECIMAL,DESCRIPTION VARCHAR(255),CATEGORY_ID INTEGER)
-CREATE TABLE EJB_PERSON(PERSON_ID INTEGER NOT NULL PRIMARY KEY,FIRST_NAME VARCHAR(80),LAST_NAME VARCHAR(80),GRADE VARCHAR(80))
-CREATE TABLE FIELD_CONVERSION_NODE(NODE_ID DECIMAL(15) NOT NULL,NODE_STATE INTEGER NOT NULL,PARENT_UID DECIMAL(15),CONSTRAINT SYS_PK_FIELD_CONVERSION_NODE PRIMARY KEY(NODE_ID,NODE_STATE))
-CREATE TABLE CONVERSION_VO(PK_WITH_AUTO INTEGER NOT NULL,PK_WITHOUT_AUTO INTEGER NOT NULL,NORMAL_WITH_AUTO INTEGER,NORMAL_WITHOUT_AUTO INTEGER,CONSTRAINT SYS_PK_CONVERSION_VO PRIMARY KEY(PK_WITH_AUTO,PK_WITHOUT_AUTO))
-CREATE TABLE PERF_ARTICLE(ARTICLE_ID INTEGER NOT NULL PRIMARY KEY,ARTICLE_NAME VARCHAR(150),MINIMUM_STOCK INTEGER,PRICE DOUBLE,UNIT VARCHAR(20),STOCK INTEGER,SUPPLIER_ID INTEGER,PRODUCT_GROUP_ID INTEGER)
-CREATE TABLE CACHE_TEST(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100))
-CREATE TABLE REF_REPOSITORY(REP_ID INTEGER NOT NULL PRIMARY KEY,REF_FK INTEGER,REFA_FK INTEGER,REFB_FK INTEGER,ANIMAL_FK INTEGER,NAME VARCHAR(100))
-CREATE TABLE REF_REPOSITORY_FK(REP_ID INTEGER NOT NULL,REF_FK INTEGER NOT NULL,REFA_FK INTEGER NOT NULL,REFB_FK INTEGER NOT NULL,NAME VARCHAR(100),CONSTRAINT SYS_PK_REF_REPOSITORY_FK PRIMARY KEY(REP_ID,REF_FK,REFA_FK,REFB_FK))
-CREATE TABLE REF_REFERENCE(REF_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100),OJB_CONCRETE_CLASS VARCHAR(100),REF_NAME_A VARCHAR(100),REF_NAME_B VARCHAR(100))
-CREATE TABLE REF_ANIMAL(A_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100),CLASS_NAME VARCHAR(100),LENGTH_ DOUBLE)
-CREATE TABLE COLLECTION_GATHERER(GAT_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150))
-CREATE TABLE COLLECTION_COLLECTIBLE_A(COL_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),GAT_ID INTEGER)
-CREATE TABLE COLLECTION_COLLECTIBLE_BASE(COL_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),GAT_ID INTEGER)
-CREATE TABLE COLLECTION_COLLECTIBLE_B(COL_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),GAT_ID INTEGER)
-CREATE TABLE COLLECTION_COLLECTIBLE_C(COL_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),GAT_ID INTEGER,EXTENT_NAME VARCHAR(150))
-CREATE TABLE COLLECTION_COLLECTIBLE_D(COL_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),OJB_CONCRETE_CLASS VARCHAR(150),GAT_ID INTEGER)
-CREATE TABLE READONLY_TEST(OBJ_ID DECIMAL NOT NULL PRIMARY KEY,NAME VARCHAR(150),RO_STRING VARCHAR(150),RO_LONG DECIMAL)
-CREATE TABLE TABLE_E(ID INTEGER NOT NULL PRIMARY KEY,SOMESUPERVALUE INTEGER)
-CREATE TABLE TABLE_F(ID INTEGER NOT NULL PRIMARY KEY,E_ID INTEGER,SOMEVALUE INTEGER,CONSTRAINT TABLE_F_FK_1 FOREIGN KEY(E_ID) REFERENCES TABLE_E(ID))
-CREATE TABLE TABLE_G(ID INTEGER NOT NULL PRIMARY KEY,F_ID INTEGER,SOMESUBVALUE INTEGER,CONSTRAINT TABLE_G_FK_1 FOREIGN KEY(F_ID) REFERENCES TABLE_F(ID))
-CREATE TABLE TABLE_F1(ID INTEGER NOT NULL PRIMARY KEY,SOMEVALUE INTEGER,CONSTRAINT TABLE_F1_FK_1 FOREIGN KEY(ID) REFERENCES TABLE_E(ID))
-CREATE TABLE TABLE_G1(ID INTEGER NOT NULL PRIMARY KEY,SOMESUBVALUE INTEGER,CONSTRAINT TABLE_G1_FK_1 FOREIGN KEY(ID) REFERENCES TABLE_F1(ID))
-CREATE TABLE ABSTRACT_COLLECTION_Z(OBJ_ID INTEGER NOT NULL PRIMARY KEY,CONTAINER_ID INTEGER,NAME VARCHAR(150),SOMEVALUE INTEGER)
-CREATE TABLE ABSTRACT_COLLECTION_ZZ(OBJ_ID INTEGER NOT NULL PRIMARY KEY,CONTAINER_ID INTEGER,NAME VARCHAR(150),ZZ_NAME VARCHAR(150),SOMEVALUE INTEGER)
-CREATE TABLE XCONTAINER(OBJ_ID INTEGER NOT NULL PRIMARY KEY)
-CREATE TABLE NESTED_FIELDS_TAB(OBJ_ID DECIMAL NOT NULL PRIMARY KEY,NAME VARCHAR(150),NESTED_VALUE VARCHAR(150),NESTED_DESCRIPTION VARCHAR(150))
-CREATE TABLE NESTED_FIELDS_ENTRY(OBJ_ID INTEGER NOT NULL PRIMARY KEY,FK_ID DECIMAL,NAME VARCHAR(150))
-CREATE TABLE OTM_PERSON(ID INTEGER NOT NULL PRIMARY KEY,FIRSTNAME VARCHAR(60),LASTNAME VARCHAR(60),MAIN_ADDRESS_ID INTEGER)
-CREATE TABLE OTM_ADDRESS(ID INTEGER NOT NULL PRIMARY KEY,COUNTRY VARCHAR(60),CITY VARCHAR(60),STREET VARCHAR(60))
-CREATE TABLE OTM_ADDRESS_DESC(ID INTEGER NOT NULL PRIMARY KEY,DESCRIPTION VARCHAR(60),PERSON_ID INTEGER,ADDRESS_ID INTEGER)
-CREATE TABLE OJB_HL_SEQ(TABLENAME VARCHAR(175) NOT NULL,FIELDNAME VARCHAR(70) NOT NULL,MAX_KEY INTEGER,GRAB_SIZE INTEGER,VERSION INTEGER,CONSTRAINT SYS_PK_OJB_HL_SEQ PRIMARY KEY(TABLENAME,FIELDNAME))
-CREATE TABLE OJB_LOCKENTRY(OID_ VARCHAR(250) NOT NULL,TX_ID VARCHAR(50) NOT NULL,TIMESTAMP_ TIMESTAMP,ISOLATIONLEVEL INTEGER,LOCKTYPE INTEGER,CONSTRAINT SYS_PK_OJB_LOCKENTRY PRIMARY KEY(OID_,TX_ID))
-CREATE TABLE OJB_NRM(NAME VARCHAR(250) NOT NULL PRIMARY KEY,OID_ LONGVARBINARY)
-CREATE TABLE OJB_DLIST(ID INTEGER NOT NULL PRIMARY KEY,SIZE_ INTEGER)
-CREATE TABLE OJB_DLIST_ENTRIES(ID INTEGER NOT NULL PRIMARY KEY,DLIST_ID INTEGER,POSITION_ INTEGER,OID_ LONGVARBINARY)
-CREATE TABLE OJB_DSET(ID INTEGER NOT NULL PRIMARY KEY,SIZE_ INTEGER)
-CREATE TABLE OJB_DSET_ENTRIES(ID INTEGER NOT NULL PRIMARY KEY,DLIST_ID INTEGER,POSITION_ INTEGER,OID_ LONGVARBINARY)
-CREATE TABLE OJB_DMAP(ID INTEGER NOT NULL PRIMARY KEY,SIZE_ INTEGER)
-CREATE TABLE OJB_DMAP_ENTRIES(ID INTEGER NOT NULL PRIMARY KEY,DMAP_ID INTEGER,KEY_OID BINARY,VALUE_OID BINARY)
-ALTER TABLE TABLE_1 ADD CONSTRAINT TABLE_1_FK_1 FOREIGN KEY(FK_TO_RELATED) REFERENCES TABLE_2(PK)
-ALTER TABLE BIDIR_A ADD CONSTRAINT BIDIR_A_FK_1 FOREIGN KEY(FK_TO_B) REFERENCES BIDIR_B(PK)
-GRANT ALL ON CLASS "java.lang.Math" TO PUBLIC
-GRANT ALL ON CLASS "org.hsqldb.Library" TO PUBLIC
-CREATE USER SA PASSWORD "" ADMIN
-CREATE ALIAS DAYNAME FOR "org.hsqldb.Library.dayname"
-CREATE ALIAS SPACE FOR "org.hsqldb.Library.space"
-CREATE ALIAS SUBSTRING FOR "org.hsqldb.Library.substring"
-CREATE ALIAS HEXTORAW FOR "org.hsqldb.Library.hexToRaw"
-CREATE ALIAS SQRT FOR "java.lang.Math.sqrt"
-CREATE ALIAS ABS FOR "org.hsqldb.Library.abs"
-CREATE ALIAS POWER FOR "java.lang.Math.pow"
-CREATE ALIAS CHAR FOR "org.hsqldb.Library.character"
-CREATE ALIAS CONCAT FOR "org.hsqldb.Library.concat"
-CREATE ALIAS PI FOR "org.hsqldb.Library.pi"
-CREATE ALIAS RAWTOHEX FOR "org.hsqldb.Library.rawToHex"
-CREATE ALIAS SECOND FOR "org.hsqldb.Library.second"
-CREATE ALIAS TRUNCATE FOR "org.hsqldb.Library.truncate"
-CREATE ALIAS MONTH FOR "org.hsqldb.Library.month"
-CREATE ALIAS LOWER FOR "org.hsqldb.Library.lcase"
-CREATE ALIAS ATAN2 FOR "java.lang.Math.atan2"
-CREATE ALIAS REPEAT FOR "org.hsqldb.Library.repeat"
-CREATE ALIAS DAYOFMONTH FOR "org.hsqldb.Library.dayofmonth"
-CREATE ALIAS TAN FOR "java.lang.Math.tan"
-CREATE ALIAS RADIANS FOR "java.lang.Math.toRadians"
-CREATE ALIAS FLOOR FOR "java.lang.Math.floor"
-CREATE ALIAS NOW FOR "org.hsqldb.Library.now"
-CREATE ALIAS ACOS FOR "java.lang.Math.acos"
-CREATE ALIAS DAYOFWEEK FOR "org.hsqldb.Library.dayofweek"
-CREATE ALIAS CEILING FOR "java.lang.Math.ceil"
-CREATE ALIAS DAYOFYEAR FOR "org.hsqldb.Library.dayofyear"
-CREATE ALIAS LCASE FOR "org.hsqldb.Library.lcase"
-CREATE ALIAS WEEK FOR "org.hsqldb.Library.week"
-CREATE ALIAS SOUNDEX FOR "org.hsqldb.Library.soundex"
-CREATE ALIAS ASIN FOR "java.lang.Math.asin"
-CREATE ALIAS LOCATE FOR "org.hsqldb.Library.locate"
-CREATE ALIAS EXP FOR "java.lang.Math.exp"
-CREATE ALIAS MONTHNAME FOR "org.hsqldb.Library.monthname"
-CREATE ALIAS YEAR FOR "org.hsqldb.Library.year"
-CREATE ALIAS LEFT FOR "org.hsqldb.Library.left"
-CREATE ALIAS ROUNDMAGIC FOR "org.hsqldb.Library.roundMagic"
-CREATE ALIAS BITOR FOR "org.hsqldb.Library.bitor"
-CREATE ALIAS LTRIM FOR "org.hsqldb.Library.ltrim"
-CREATE ALIAS COT FOR "org.hsqldb.Library.cot"
-CREATE ALIAS COS FOR "java.lang.Math.cos"
-CREATE ALIAS MOD FOR "org.hsqldb.Library.mod"
-CREATE ALIAS SIGN FOR "org.hsqldb.Library.sign"
-CREATE ALIAS DEGREES FOR "java.lang.Math.toDegrees"
-CREATE ALIAS LOG FOR "java.lang.Math.log"
-CREATE ALIAS SIN FOR "java.lang.Math.sin"
-CREATE ALIAS CURTIME FOR "org.hsqldb.Library.curtime"
-CREATE ALIAS DIFFERENCE FOR "org.hsqldb.Library.difference"
-CREATE ALIAS INSERT FOR "org.hsqldb.Library.insert"
-CREATE ALIAS SUBSTR FOR "org.hsqldb.Library.substring"
-CREATE ALIAS DATABASE FOR "org.hsqldb.Library.database"
-CREATE ALIAS MINUTE FOR "org.hsqldb.Library.minute"
-CREATE ALIAS HOUR FOR "org.hsqldb.Library.hour"
-CREATE ALIAS IDENTITY FOR "org.hsqldb.Library.identity"
-CREATE ALIAS QUARTER FOR "org.hsqldb.Library.quarter"
-CREATE ALIAS CURDATE FOR "org.hsqldb.Library.curdate"
-CREATE ALIAS BITAND FOR "org.hsqldb.Library.bitand"
-CREATE ALIAS USER FOR "org.hsqldb.Library.user"
-CREATE ALIAS UCASE FOR "org.hsqldb.Library.ucase"
-CREATE ALIAS RTRIM FOR "org.hsqldb.Library.rtrim"
-CREATE ALIAS LOG10 FOR "org.hsqldb.Library.log10"
-CREATE ALIAS RIGHT FOR "org.hsqldb.Library.right"
-CREATE ALIAS ATAN FOR "java.lang.Math.atan"
-CREATE ALIAS UPPER FOR "org.hsqldb.Library.ucase"
-CREATE ALIAS ASCII FOR "org.hsqldb.Library.ascii"
-CREATE ALIAS RAND FOR "java.lang.Math.random"
-CREATE ALIAS LENGTH FOR "org.hsqldb.Library.length"
-CREATE ALIAS ROUND FOR "org.hsqldb.Library.round"
-CREATE ALIAS REPLACE FOR "org.hsqldb.Library.replace"
-INSERT INTO KATEGORIEN VALUES(1,'Beverages','Alles leckere zum S\u00fcffeln')
-INSERT INTO KATEGORIEN VALUES(2,'Spices','Gew\u00fcrze, Dressings etc.')
-INSERT INTO KATEGORIEN VALUES(3,'Meat','')
-INSERT INTO KATEGORIEN VALUES(4,'Liquors','')
-INSERT INTO KATEGORIEN VALUES(5,'Books','Strange Books...')
-INSERT INTO KATEGORIEN VALUES(6,'bread','')
-INSERT INTO KATEGORIEN VALUES(7,'Fruits','Fr\u00fcchte etc.')
-INSERT INTO KATEGORIEN VALUES(8,'Dairy Products','Kat 8')
-INSERT INTO ARTIKEL VALUES(1,'Chai',1,1,'10 boxes x 20 bags',18.53E0,39,0,10,0)
-INSERT INTO ARTIKEL VALUES(2,'Chang',1,1,'24 - 12 oz bottles',19.89E0,17,40,25,0)
-INSERT INTO ARTIKEL VALUES(3,'Aniseed Syrup',1,2,'12 - 550 ml bottles',10.2E0,13,70,25,0)
-INSERT INTO ARTIKEL VALUES(4,'Chef Antons Cajun Seasoning',2,2,'48 - 6 oz jars',22.0E0,53,0,0,0)
-INSERT INTO ARTIKEL VALUES(5,'Chef Anton\u017ds Gumbo Mix',2,2,'36 boxes',21.35E0,0,0,0,1)
-INSERT INTO ARTIKEL VALUES(6,'Grandma\u017ds Boysenberry Spread',3,2,'12 - 8 oz jars',25.0E0,120,0,25,0)
-INSERT INTO ARTIKEL VALUES(7,'Uncle Bob\u017ds Organic Dried Pears',3,7,'12 - 1 lb pkgs.',30.0E0,15,0,10,0)
-INSERT INTO ARTIKEL VALUES(8,'Northwoods Cranberry Sauce',3,2,'12 - 12 oz jars',40.0E0,6,0,0,0)
-INSERT INTO ARTIKEL VALUES(9,'Mishi Kobe Niku',4,6,'18 - 500 g pkgs.',97.0E0,29,0,0,1)
-INSERT INTO ARTIKEL VALUES(10,'Ikura',4,8,'12 - 200 ml jars',31.0E0,31,0,0,0)
-INSERT INTO ARTIKEL VALUES(11,'Queso Cabrales',5,4,'1 kg pkg.',21.0E0,22,30,30,0)
-INSERT INTO ARTIKEL VALUES(12,'Queso Manchego La Pastora',5,4,'10 - 500 g pkgs.',38.0E0,86,0,0,0)
-INSERT INTO ARTIKEL VALUES(13,'Konbu',6,8,'2 kg box',6.0E0,24,0,5,0)
-INSERT INTO ARTIKEL VALUES(14,'Tofu',6,7,'40 - 100 g pkgs.',23.25E0,35,0,0,0)
-INSERT INTO ARTIKEL VALUES(15,'Genen Shouyu',6,2,'24 - 250 ml bottles',15.5E0,39,0,5,0)
-INSERT INTO ARTIKEL VALUES(16,'Pavlova',7,3,'32 - 500 g boxes',17.45E0,29,0,10,0)
-INSERT INTO ARTIKEL VALUES(17,'Alice Mutton',7,6,'20 - 1 kg tins',39.0E0,0,0,0,1)
-INSERT INTO ARTIKEL VALUES(18,'Carnarvon Tigers',7,8,'16 kg pkg.',62.5E0,42,0,0,0)
-INSERT INTO ARTIKEL VALUES(19,'Teatime Chocolate Biscuits',8,3,'10 boxes x 12 pieces',9.2E0,25,0,5,0)
-INSERT INTO ARTIKEL VALUES(20,'Sir Rodney\u017ds Marmalade',8,3,'30 gift boxes',81.0E0,40,0,0,0)
-INSERT INTO ARTIKEL VALUES(21,'Sir Rodney\u017ds Scones',8,3,'24 pkgs. x 4 pieces',10.0E0,3,40,5,0)
-INSERT INTO ARTIKEL VALUES(22,'Gustaf\u017ds Kn\u00e4ckebr\u00f6d',9,5,'24 - 500 g pkgs.',21.0E0,104,0,25,0)
-INSERT INTO ARTIKEL VALUES(23,'Tunnbr\u00f6d',9,5,'12 - 250 g pkgs.',9.0E0,61,0,25,0)
-INSERT INTO ARTIKEL VALUES(24,'Guaran\u00e1 Fant\u00e1stica',10,1,'12 - 355 ml cans',4.5E0,20,0,0,1)
-INSERT INTO ARTIKEL VALUES(25,'NuNuCa Nu\u00df-Nougat-Creme',11,3,'20 - 450 g glasses',14.0E0,76,0,30,0)
-INSERT INTO ARTIKEL VALUES(26,'Gumb\u00e4r Gummib\u00e4rchen',11,3,'100 - 250 g bags',31.23E0,15,0,0,0)
-INSERT INTO ARTIKEL VALUES(27,'Schoggi Schokolade',11,3,'100 - 100 g pieces',43.9E0,49,0,30,0)
-INSERT INTO ARTIKEL VALUES(28,'R\u00f6ssle Sauerkraut',12,7,'25 - 825 g cans',45.6E0,26,0,0,1)
-INSERT INTO ARTIKEL VALUES(29,'Th\u00fcringer Rostbratwurst',12,6,'50 bags x 30 sausgs.',123.79E0,0,0,0,1)
-INSERT INTO ARTIKEL VALUES(30,'Nord-Ost Matjeshering',13,8,'10 - 200 g glasses',25.89E0,10,0,15,0)
-INSERT INTO ARTIKEL VALUES(31,'Gorgonzola Telino',14,4,'12 - 100 g pkgs',12.5E0,0,70,20,0)
-INSERT INTO ARTIKEL VALUES(32,'Mascarpone Fabioli',14,4,'24 - 200 g pkgs.',32.0E0,9,40,25,0)
-INSERT INTO ARTIKEL VALUES(33,'Geitost',15,4,'500 g',2.5E0,112,0,20,0)
-INSERT INTO ARTIKEL VALUES(34,'Sasquatch Ale',16,1,'24 - 12 oz bottles',14.0E0,111,0,15,0)
-INSERT INTO ARTIKEL VALUES(35,'Steeleye Stout',16,1,'24 - 12 oz bottles',18.0E0,20,0,15,0)
-INSERT INTO ARTIKEL VALUES(36,'Inlagd Sill',17,8,'24 - 250 g jars',19.0E0,112,0,20,0)
-INSERT INTO ARTIKEL VALUES(37,'Gravad lax',17,8,'12 - 500 g pkgs.',26.0E0,11,50,25,0)
-INSERT INTO ARTIKEL VALUES(38,'C\u00f4te de Blaye',18,1,'12 - 75 cl bottles',263.5E0,17,0,15,0)
-INSERT INTO ARTIKEL VALUES(39,'Chartreuse verte',18,1,'750 cc per bottle',18.0E0,69,0,5,0)
-INSERT INTO ARTIKEL VALUES(40,'Boston Crab Meat',19,8,'24 - 4 oz tins',18.4E0,123,0,30,0)
-INSERT INTO ARTIKEL VALUES(41,'Jack\u017ds New England Clam Chowder',19,8,'12 - 12 oz cans',9.65E0,85,0,10,0)
-INSERT INTO ARTIKEL VALUES(42,'Singaporean Hokkien Fried Mee',20,5,'32 - 1 kg pkgs.',14.0E0,26,0,0,1)
-INSERT INTO ARTIKEL VALUES(43,'Ipoh Coffee',20,1,'16 - 500 g tins',46.0E0,17,10,25,0)
-INSERT INTO ARTIKEL VALUES(44,'Gula Malacca',20,2,'20 - 2 kg bags',19.45E0,27,0,15,0)
-INSERT INTO ARTIKEL VALUES(45,'R\u00f8gede sild',21,8,'1k pkg.',9.5E0,5,70,15,0)
-INSERT INTO ARTIKEL VALUES(46,'Spegesild',21,8,'4 - 450 g glasses',12.0E0,95,0,0,0)
-INSERT INTO ARTIKEL VALUES(47,'Zaanse koeken',22,3,'10 - 4 oz boxes',9.5E0,36,0,0,0)
-INSERT INTO ARTIKEL VALUES(48,'Chocolade',22,3,'10 pkgs.',12.75E0,15,70,25,0)
-INSERT INTO ARTIKEL VALUES(49,'Maxilaku',23,3,'24 - 50 g pkgs.',20.0E0,10,60,15,0)
-INSERT INTO ARTIKEL VALUES(50,'Valkoinen suklaa',23,3,'12 - 100 g bars',16.25E0,65,0,30,0)
-INSERT INTO ARTIKEL VALUES(51,'Manjimup Dried Apples',24,7,'50 - 300 g pkgs.',53.0E0,20,0,10,0)
-INSERT INTO ARTIKEL VALUES(52,'Filo Mix',24,5,'16 - 2 kg boxes',7.0E0,38,0,25,0)
-INSERT INTO ARTIKEL VALUES(53,'Perth Pasties',24,6,'48 pieces',32.8E0,0,0,0,1)
-INSERT INTO ARTIKEL VALUES(54,'Tourti\u00e8re',25,6,'16 pies',7.45E0,21,0,10,0)
-INSERT INTO ARTIKEL VALUES(55,'P\u00e2t\u00e9 chinois',25,6,'24 boxes x 2 pies',24.0E0,115,0,20,0)
-INSERT INTO ARTIKEL VALUES(56,'Gnocchi di nonna Alice',26,5,'24 - 250 g pkgs.',38.0E0,21,10,30,0)
-INSERT INTO ARTIKEL VALUES(57,'Ravioli Angelo',26,5,'24 - 250 g pkgs.',19.5E0,36,0,20,0)
-INSERT INTO ARTIKEL VALUES(58,'Escargots de Bourgogne',27,8,'24 pieces',13.25E0,62,0,20,0)
-INSERT INTO ARTIKEL VALUES(59,'Raclette Courdavault',28,4,'5 kg pkg.',55.0E0,79,0,0,0)
-INSERT INTO ARTIKEL VALUES(60,'Camembert Pierrot',28,4,'15 - 300 g rounds',34.0E0,19,0,0,0)
-INSERT INTO ARTIKEL VALUES(61,'Sirop d\u017d\u00e9rable',29,2,'24 - 500 ml bottles',28.5E0,113,0,25,0)
-INSERT INTO ARTIKEL VALUES(62,'Tarte au sucre',29,3,'48 pies',49.3E0,17,0,0,0)
-INSERT INTO ARTIKEL VALUES(63,'Vegie-spread',7,2,'15 - 625 g jars',43.9E0,24,0,5,0)
-INSERT INTO ARTIKEL VALUES(64,'Wimmers gute Semmelkn\u00f6del',12,5,'20 bags x 4 pieces',33.25E0,22,80,30,0)
-INSERT INTO ARTIKEL VALUES(65,'Louisiana Fiery Hot Pepper Sauce',2,2,'32 - 8 oz bottles',21.05E0,76,0,0,0)
-INSERT INTO ARTIKEL VALUES(66,'Louisiana Hot Spiced Okra',2,2,'24 - 8 oz jars',17.0E0,4,100,20,0)
-INSERT INTO ARTIKEL VALUES(67,'Laughing Lumberjack Lager',16,1,'24 - 12 oz bottles',14.0E0,52,0,10,0)
-INSERT INTO ARTIKEL VALUES(68,'Scottish Longbreads',8,3,'10 boxes x 8 pieces',12.5E0,6,10,15,0)
-INSERT INTO ARTIKEL VALUES(69,'Gudbrandsdalsost',15,4,'10 kg pkg.',36.0E0,26,0,15,0)
-INSERT INTO ARTIKEL VALUES(70,'Outback Lager',7,1,'24 - 355 ml bottles',15.0E0,15,10,30,0)
-INSERT INTO ARTIKEL VALUES(71,'Fl\u00f8temysost',15,4,'10 - 500 g pkgs.',21.5E0,26,0,0,0)
-INSERT INTO ARTIKEL VALUES(72,'Mozzarella di Giovanni',14,4,'24 - 200 g pkgs.',34.8E0,14,0,0,0)
-INSERT INTO ARTIKEL VALUES(73,'R\u00f6d Kaviar',17,8,'24 - 150 g jars',15.0E0,101,0,5,0)
-INSERT INTO ARTIKEL VALUES(74,'Longlife Tofu',4,7,'5 kg pkg.',10.0E0,4,20,5,0)
-INSERT INTO ARTIKEL VALUES(75,'Rh\u00f6nbr\u00e4u Klosterbier',12,1,'24 - 0.5 l bottles',7.75E0,125,0,25,0)
-INSERT INTO ARTIKEL VALUES(76,'Lakkalik\u00f6\u00f6ri',23,1,'500 ml',18.0E0,57,0,20,0)
-INSERT INTO ARTIKEL VALUES(77,'Original Frankfurter gr\u00fcne So\u00dfe',12,2,'12 boxes',13.0E0,32,0,15,0)
-INSERT INTO BOOKS VALUES(100,'Hamlet',12,5,'12 boxes',34.0E0,32,0,15,0,'1234567890','W. Shakespeare')
-INSERT INTO BOOKS VALUES(101,'Faust',12,5,'12 boxes',56.0E0,32,0,15,0,'1234567890','J.W. v. Goethe')
-INSERT INTO CDS VALUES(200,'Mama\u017ds Gun',12,5,'12 boxes',23.0E0,32,0,15,0,'Motown Records','Erykah Badu')
-INSERT INTO CDS VALUES(201,'STREETSOUL',12,5,'12 boxes',25.0E0,32,0,15,0,'Virgin Records','Guru\u017ds Jazzmatazz')
-INSERT INTO CDS VALUES(202,'Beyond Skin',12,5,'12 boxes',25.0E0,32,0,15,0,'Outcaste Records','Nitin Sawhney')
-INSERT INTO ORDER_POSITION VALUES(1,1,5)
-INSERT INTO ORDER_POSITION VALUES(2,1,100)
-INSERT INTO ORDER_POSITION VALUES(3,1,200)
-INSERT INTO PERSON VALUES(1,'tom','tom')
-INSERT INTO PERSON VALUES(2,'bob','bob')
-INSERT INTO PERSON VALUES(3,'albert','albert')
-INSERT INTO PERSON VALUES(4,'bertrand','bertrand')
-INSERT INTO PERSON VALUES(5,'cindy','cindy')
-INSERT INTO PERSON VALUES(6,'dorothy','dorothy')
-INSERT INTO PERSON VALUES(7,'eugen','eugen')
-INSERT INTO PERSON VALUES(8,'frido','frido')
-INSERT INTO PERSON VALUES(9,'guido','guido')
-INSERT INTO PERSON VALUES(10,'hank','hank')
-INSERT INTO PROJECT VALUES(1,'OJB','OJB')
-INSERT INTO PROJECT VALUES(2,'SODA','SODA')
-INSERT INTO PROJECT VALUES(3,'HSQLDB','HSQLDB')
-INSERT INTO PROJECT VALUES(4,'XERCES','XERCES')
-INSERT INTO PROJECT VALUES(5,'Linux','Linux')
-INSERT INTO PROJECT VALUES(6,'mySQL','mySQL')
-INSERT INTO PERSON_PROJECT VALUES(1,1,'founder')
-INSERT INTO PERSON_PROJECT VALUES(1,2,'friend')
-INSERT INTO PERSON_PROJECT VALUES(2,1,'developer')
-INSERT INTO PERSON_PROJECT VALUES(2,2,'lead')
-INSERT INTO PERSON_PROJECT VALUES(2,3,'developer')
-INSERT INTO PERSON_PROJECT VALUES(3,2,'tester')
-INSERT INTO PERSON_PROJECT VALUES(3,4,'user')
-INSERT INTO PERSON_PROJECT VALUES(3,5,'developer')
-INSERT INTO PERSON_PROJECT VALUES(4,1,'developer')
-INSERT INTO PERSON_PROJECT VALUES(5,2,'tester')
-INSERT INTO PERSON_PROJECT VALUES(5,4,'lead')
-INSERT INTO PERSON_PROJECT VALUES(7,4,'lead')
-INSERT INTO PERSON_PROJECT VALUES(7,5,'founder')
-INSERT INTO PERSON_PROJECT VALUES(7,6,'tester')
-INSERT INTO TASK VALUES(1,2,1,'Initial Layout')
-INSERT INTO TASK VALUES(2,2,1,'Initial Spec')
-INSERT INTO TASK VALUES(3,2,2,'Project Cleanup')
-INSERT INTO TASK VALUES(4,2,3,'Testing Scripts')
-INSERT INTO CONV_REFERER VALUES(1,50,10)
-INSERT INTO CONV_REFERER VALUES(2,51,11)
-INSERT INTO CONV_REFERER VALUES(3,52,12)
-INSERT INTO CONV_REFERED VALUES(50,60)
-INSERT INTO CONV_REFERED VALUES(51,61)
-INSERT INTO CONV_REFERED VALUES(52,62)
-INSERT INTO NEWS VALUES(1,'Healf Care News (NONE)')
-INSERT INTO NEWS VALUES(2,'Ferrai for sale (CARS - BUYERS)')
-INSERT INTO NEWS VALUES(3,'Brazil World Cup Champion ! (SPORTS)')
-INSERT INTO PAPER VALUES(10,'NONE','today','NONE')
-INSERT INTO PAPER VALUES(11,'SALES','yesterday','SALES MAN')
-INSERT INTO TOPIC VALUES(10,'Buyers')
-INSERT INTO TOPIC VALUES(11,'Sellers')
-INSERT INTO CATEGORY VALUES(1,'Cars')
-INSERT INTO CATEGORY VALUES(2,'Sports')
-INSERT INTO AREA VALUES(20,'Human')
-INSERT INTO AREA VALUES(21,'NotHuman')
-INSERT INTO CONTENT_QUALIFIER VALUES(2,1)
-INSERT INTO CONTENT_QUALIFIER VALUES(2,10)
-INSERT INTO CONTENT_QUALIFIER VALUES(3,2)
-INSERT INTO CONTENT_QUALIFIER VALUES(10,20)
-INSERT INTO CONTENT_QUALIFIER VALUES(11,11)
-INSERT INTO SM_TAB_MAX_A VALUES(120,'A')
-INSERT INTO SM_TAB_MAX_A VALUES(121,'A')
-INSERT INTO SM_TAB_MAX_AA VALUES(101,'AA')
-INSERT INTO SM_TAB_MAX_AA VALUES(102,'AA')
-INSERT INTO SM_TAB_MAX_AB VALUES(99,'AB')
-INSERT INTO SM_TAB_MAX_AAA VALUES(123,'AAA')
-INSERT INTO SM_TAB_MAX_B VALUES(115,'B')
-INSERT INTO SM_TAB_MAX_B VALUES(116,'B')
-INSERT INTO SM_TAB_MAX_BB VALUES(130,'BB')
-INSERT INTO SM_TAB_MAX_BB VALUES(131,'BB')
+CREATE TABLE KATEGORIEN(KATEGORIE_NR INTEGER NOT NULL PRIMARY KEY,KATEGORIENAME VARCHAR(60),BESCHREIBUNG VARCHAR(60))
+CREATE TABLE ARTIKEL(ARTIKEL_NR INTEGER NOT NULL PRIMARY KEY,ARTIKELNAME VARCHAR(60),LIEFERANTEN_NR INTEGER,KATEGORIE_NR INTEGER,LIEFEREINHEIT VARCHAR(30),EINZELPREIS FLOAT,LAGERBESTAND INTEGER,BESTELLTEEINHEITEN INTEGER,MINDESTBESTAND INTEGER,AUSLAUFARTIKEL INTEGER,CONSTRAINT ARTIKEL_FK_1 FOREIGN KEY(KATEGORIE_NR) REFERENCES KATEGORIEN(KATEGORIE_NR))
+CREATE TABLE BOOKS(ARTIKEL_NR INTEGER NOT NULL PRIMARY KEY,ARTIKELNAME VARCHAR(60),LIEFERANTEN_NR INTEGER,KATEGORIE_NR INTEGER,LIEFEREINHEIT VARCHAR(30),EINZELPREIS FLOAT,LAGERBESTAND INTEGER,BESTELLTEEINHEITEN INTEGER,MINDESTBESTAND INTEGER,AUSLAUFARTIKEL INTEGER,ISBN VARCHAR(10),AUTHOR VARCHAR(50),CONSTRAINT BOOKS_FK_1 FOREIGN KEY(KATEGORIE_NR) REFERENCES KATEGORIEN(KATEGORIE_NR))
+CREATE TABLE CDS(ARTIKEL_NR INTEGER NOT NULL PRIMARY KEY,ARTIKELNAME VARCHAR(60),LIEFERANTEN_NR INTEGER,KATEGORIE_NR INTEGER,LIEFEREINHEIT VARCHAR(30),EINZELPREIS FLOAT,LAGERBESTAND INTEGER,BESTELLTEEINHEITEN INTEGER,MINDESTBESTAND INTEGER,AUSLAUFARTIKEL INTEGER,LABEL VARCHAR(50),MUSICIANS VARCHAR(250),CONSTRAINT CDS_FK_1 FOREIGN KEY(KATEGORIE_NR) REFERENCES KATEGORIEN(KATEGORIE_NR))
+CREATE TABLE ORDER_POSITION(ID INTEGER NOT NULL PRIMARY KEY,ORDER_ID INTEGER,ARTICLE_ID INTEGER)
+CREATE TABLE TREE(ID INTEGER NOT NULL PRIMARY KEY,DATA VARCHAR(50),PARENT_ID INTEGER)
+CREATE TABLE TREEGROUP(ID INTEGER NOT NULL PRIMARY KEY,DATA VARCHAR(50),PARENT_ID INTEGER,GROUP_ID INTEGER)
+CREATE TABLE AB_TABLE(ID INTEGER NOT NULL PRIMARY KEY,CLASS_NAME VARCHAR(60),VALUE_ INTEGER,A_FIELD VARCHAR(60),B_FIELD VARCHAR(60))
+CREATE TABLE PRODUCT(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100),PRICE FLOAT,STOCK INTEGER)
+CREATE TABLE PERSON(ID INTEGER NOT NULL PRIMARY KEY,FIRSTNAME VARCHAR(50),LASTNAME VARCHAR(50))
+CREATE TABLE PROJECT(ID INTEGER NOT NULL PRIMARY KEY,TITLE VARCHAR(50),DESCRIPTION VARCHAR(250))
+CREATE TABLE PERSON_PROJECT(PERSON_ID INTEGER NOT NULL,PROJECT_ID INTEGER NOT NULL,ROLENAME VARCHAR(20),CONSTRAINT SYS_PK_PERSON_PROJECT PRIMARY KEY(PERSON_ID,PROJECT_ID),CONSTRAINT PERSON_PROJECT_FK_1 FOREIGN KEY(PERSON_ID) REFERENCES PERSON(ID),CONSTRAINT PERSON_PROJECT_FK_2 FOREIGN KEY(PROJECT_ID) REFERENCES PROJECT(ID))
+CREATE TABLE TASK(TASK_ID INTEGER NOT NULL PRIMARY KEY,PERSON_ID INTEGER,PROJECT_ID INTEGER,TASKNAME VARCHAR(20),CONSTRAINT TASK_FK_1 FOREIGN KEY(PERSON_ID,PROJECT_ID) REFERENCES PERSON_PROJECT(PERSON_ID,PROJECT_ID))
+CREATE TABLE FAMILY_MEMBER(ID INTEGER NOT NULL PRIMARY KEY,FIRSTNAME VARCHAR(50),LASTNAME VARCHAR(50),MOTHER_ID INTEGER,FATHER_ID INTEGER)
+CREATE TABLE LOCKED_BY_VERSION(ID INTEGER NOT NULL PRIMARY KEY,VALUE_ VARCHAR(60),VERSION_ INTEGER)
+CREATE TABLE LOCKED_BY_TIMESTAMP(ID INTEGER NOT NULL PRIMARY KEY,VALUE_ VARCHAR(60),TIMESTAMP_ TIMESTAMP)
+CREATE TABLE BLOB_TEST(ID INTEGER NOT NULL PRIMARY KEY,BLOB_VALUE_ LONGVARBINARY,CLOB_VALUE_ VARCHAR)
+CREATE TABLE MDTEST_MASTER(MASTERID INTEGER NOT NULL PRIMARY KEY,MASTER_TEXT VARCHAR(255))
+CREATE TABLE MDTEST_DETAIL_FKINPK(MASTERID INTEGER NOT NULL,DETAILID INTEGER NOT NULL,DETAIL_TEXT VARCHAR(255),CONSTRAINT SYS_PK_MDTEST_DETAIL_FKINPK PRIMARY KEY(MASTERID,DETAILID),CONSTRAINT MDTEST_DETAIL_FKINPK_FK_1 FOREIGN KEY(MASTERID) REFERENCES MDTEST_MASTER(MASTERID))
+CREATE TABLE MDTEST_DETAIL_FKNOPK(DETAILID INTEGER NOT NULL PRIMARY KEY,MASTERID INTEGER,DETAIL_TEXT VARCHAR(255),CONSTRAINT MDTEST_DETAIL_FKNOPK_FK_1 FOREIGN KEY(MASTERID) REFERENCES MDTEST_MASTER(MASTERID))
+CREATE TABLE POINT_TABLE(ID INTEGER NOT NULL PRIMARY KEY,X INTEGER,Y INTEGER)
+CREATE TABLE GRAPH_NODE(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(50),LOCATION INTEGER)
+CREATE TABLE GRAPH_EDGE(ID INTEGER NOT NULL PRIMARY KEY,SOURCE INTEGER,SINK INTEGER)
+CREATE TABLE TESTCLASSA(ID VARCHAR(48) NOT NULL PRIMARY KEY,VALUE1 VARCHAR(64),VALUE2 VARCHAR(64),VALUE3 INTEGER,BOID VARCHAR(48))
+CREATE TABLE TESTCLASSB(ID VARCHAR(48) NOT NULL PRIMARY KEY,VALUE1 VARCHAR(64),AOID VARCHAR(48))
+CREATE TABLE RELATEDTOCONTRACT(PK VARCHAR(48) NOT NULL PRIMARY KEY,RELATEDVALUE1 VARCHAR(64),RELATEDVALUE2 INTEGER,RELATEDVALUE3 TIMESTAMP)
+CREATE TABLE CONTRACT(PK VARCHAR(48) NOT NULL PRIMARY KEY,FK_TO_RELATED VARCHAR(48),CONTRACT_VALUE1 VARCHAR(64),CONTRACT_VALUE2 INTEGER,CONTRACT_VALUE3 VARCHAR(64),CONTRACT_VALUE4 TIMESTAMP,CONSTRAINT CONTRACT_FK_1 FOREIGN KEY(FK_TO_RELATED) REFERENCES RELATEDTOCONTRACT(PK))
+CREATE TABLE VERSION(PK VARCHAR(48) NOT NULL PRIMARY KEY,FK_TO_CONTRACT VARCHAR(48),VERSION_VALUE1 VARCHAR(64),VERSION_VALUE2 INTEGER,VERSION_VALUE3 TIMESTAMP,CONSTRAINT VERSION_FK_1 FOREIGN KEY(FK_TO_CONTRACT) REFERENCES CONTRACT(PK))
+CREATE TABLE EFFECTIVENESS(PK VARCHAR(48) NOT NULL PRIMARY KEY,FK_TO_VERSION VARCHAR(48),EFF_VALUE1 VARCHAR(64),EFF_VALUE2 INTEGER,EFF_VALUE3 TIMESTAMP,CONSTRAINT EFFECTIVENESS_FK_1 FOREIGN KEY(FK_TO_VERSION) REFERENCES VERSION(PK))
+CREATE TABLE MULTIMAPPEDTABLE(ID INTEGER NOT NULL PRIMARY KEY,VALUE1 VARCHAR(64),VALUE2 INTEGER,VALUE3 TIMESTAMP,VALUE4 VARCHAR(64),VALUE5 INTEGER,VALUE6 TIMESTAMP,VALUE7 VARCHAR(64),OJBCONCRETECLASS VARCHAR(64))
+CREATE TABLE EXTENT_TEST_A(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100))
+CREATE TABLE EXTENT_TEST_B(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100))
+CREATE TABLE EXTENT_TEST_C(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100))
+CREATE TABLE EXTENT_TEST_D(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100))
+CREATE TABLE TABLE_1(PK INTEGER NOT NULL PRIMARY KEY,FK_TO_RELATED INTEGER)
+CREATE TABLE TABLE_2(PK INTEGER NOT NULL PRIMARY KEY)
+CREATE TABLE BIDIR_A(PK VARCHAR(48) NOT NULL PRIMARY KEY,FK_TO_B VARCHAR(48))
+CREATE TABLE BIDIR_B(PK VARCHAR(48) NOT NULL PRIMARY KEY,FK_TO_A VARCHAR(48),CONSTRAINT BIDIR_B_FK_1 FOREIGN KEY(FK_TO_A) REFERENCES BIDIR_A(PK))
+CREATE TABLE MAMMAL(ANIMALID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(60),AGE INTEGER,NUMLEGS INTEGER,ZOOID INTEGER)
+CREATE TABLE REPTILE(ANIMALID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(60),AGE INTEGER,COLOR VARCHAR(60),ZOOID INTEGER)
+CREATE TABLE ZOO(ZOOID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(60))
+CREATE TABLE FISH(FOODID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(60),CALORIES INTEGER,TYPEOFWATER VARCHAR(60))
+CREATE TABLE SALAD(FOODID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(60),CALORIES INTEGER,COLOR VARCHAR(60))
+CREATE TABLE GOURMET(GOURMETID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(60))
+CREATE TABLE GOURMET_FOOD(GOURMET_ID INTEGER NOT NULL,FOOD_ID INTEGER NOT NULL,CONSTRAINT SYS_PK_GOURMET_FOOD PRIMARY KEY(GOURMET_ID,FOOD_ID))
+CREATE TABLE GUIDTEST(GUID_ VARCHAR(60) NOT NULL PRIMARY KEY,GUIDVALUE VARCHAR(60))
+CREATE TABLE CONV_REFERER(PK1 INTEGER NOT NULL PRIMARY KEY,REF1 INTEGER,TEST_ID INTEGER)
+CREATE TABLE CONV_REFERED(PK1 INTEGER NOT NULL PRIMARY KEY,TEST_ID INTEGER)
+CREATE TABLE SITE(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100),SITEYEAR INTEGER,SEMESTER INTEGER,CONSTRAINT SYS_CT_3 UNIQUE(NAME))
+CREATE TABLE ODMG_DLIST(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100),RND_NAME VARCHAR(100))
+CREATE TABLE ROLLBACK_ONE(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100),DESCRIPTION VARCHAR(100))
+CREATE TABLE ROLLBACK_TWO(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100),DESCRIPTION VARCHAR(100))
+CREATE TABLE NEWS(ID INTEGER NOT NULL PRIMARY KEY,HEADLINE VARCHAR(50))
+CREATE TABLE PAPER(ID INTEGER NOT NULL PRIMARY KEY,HEADLINE VARCHAR(50),ISSUEDATE VARCHAR(50),AUTHOR VARCHAR(50))
+CREATE TABLE TOPIC(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(50))
+CREATE TABLE CATEGORY(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(50))
+CREATE TABLE AREA(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(50))
+CREATE TABLE CONTENT_QUALIFIER(CONTENT_ID INTEGER NOT NULL,QUALIFIER_ID INTEGER NOT NULL,CONSTRAINT SYS_PK_CONTENT_QUALIFIER PRIMARY KEY(CONTENT_ID,QUALIFIER_ID))
+CREATE TABLE SM_TAB_A(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
+CREATE TABLE SM_TAB_AA(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
+CREATE TABLE SM_TAB_AB(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
+CREATE TABLE SM_TAB_AAA(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
+CREATE TABLE SM_TAB_B(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
+CREATE TABLE SM_TAB_BB(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
+CREATE TABLE SM_SAME_TAB(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
+CREATE TABLE SM_AUTO_NAMING(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
+CREATE TABLE SM_TAB_MAX_A(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
+CREATE TABLE SM_TAB_MAX_AA(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
+CREATE TABLE SM_TAB_MAX_AB(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
+CREATE TABLE SM_TAB_MAX_AAA(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
+CREATE TABLE SM_TAB_MAX_B(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
+CREATE TABLE SM_TAB_MAX_BB(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
+CREATE TABLE SM_KEY(INT_KEY INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250),STRING_KEY VARCHAR(250),LONG_KEY BIGINT,INTEGER_KEY INTEGER)
+CREATE TABLE SM_MT_TEST_A(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100))
+CREATE TABLE SM_MT_TEST_B(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100))
+CREATE TABLE EJB_CATEGORY(CATEGORY_ID INTEGER NOT NULL PRIMARY KEY,CATEGORY_NAME VARCHAR(80),DESCRIPTION VARCHAR(255))
+CREATE TABLE EJB_ARTICLE(ARTICLE_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(80),PRICE DECIMAL,DESCRIPTION VARCHAR(255),CATEGORY_ID INTEGER)
+CREATE TABLE EJB_PERSON(PERSON_ID INTEGER NOT NULL PRIMARY KEY,FIRST_NAME VARCHAR(80),LAST_NAME VARCHAR(80),GRADE VARCHAR(80))
+CREATE TABLE FIELD_CONVERSION_NODE(NODE_ID DECIMAL(15) NOT NULL,NODE_STATE INTEGER NOT NULL,PARENT_UID DECIMAL(15),CONSTRAINT SYS_PK_FIELD_CONVERSION_NODE PRIMARY KEY(NODE_ID,NODE_STATE))
+CREATE TABLE CONVERSION_VO(PK_WITH_AUTO INTEGER NOT NULL,PK_WITHOUT_AUTO INTEGER NOT NULL,NORMAL_WITH_AUTO INTEGER,NORMAL_WITHOUT_AUTO INTEGER,CONSTRAINT SYS_PK_CONVERSION_VO PRIMARY KEY(PK_WITH_AUTO,PK_WITHOUT_AUTO))
+CREATE TABLE PERF_ARTICLE(ARTICLE_ID INTEGER NOT NULL PRIMARY KEY,ARTICLE_NAME VARCHAR(150),MINIMUM_STOCK INTEGER,PRICE DOUBLE,UNIT VARCHAR(20),STOCK INTEGER,SUPPLIER_ID INTEGER,PRODUCT_GROUP_ID INTEGER)
+CREATE TABLE CACHE_TEST(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100))
+CREATE TABLE REF_REPOSITORY(REP_ID INTEGER NOT NULL PRIMARY KEY,REF_FK INTEGER,REFA_FK INTEGER,REFB_FK INTEGER,ANIMAL_FK INTEGER,NAME VARCHAR(100))
+CREATE TABLE REF_REPOSITORY_FK(REP_ID INTEGER NOT NULL,REF_FK INTEGER NOT NULL,REFA_FK INTEGER NOT NULL,REFB_FK INTEGER NOT NULL,NAME VARCHAR(100),CONSTRAINT SYS_PK_REF_REPOSITORY_FK PRIMARY KEY(REP_ID,REF_FK,REFA_FK,REFB_FK))
+CREATE TABLE REF_REFERENCE(REF_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100),OJB_CONCRETE_CLASS VARCHAR(100),REF_NAME_A VARCHAR(100),REF_NAME_B VARCHAR(100))
+CREATE TABLE REF_ANIMAL(A_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100),CLASS_NAME VARCHAR(100),LENGTH_ DOUBLE)
+CREATE TABLE COLLECTION_GATHERER(GAT_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150))
+CREATE TABLE COLLECTION_COLLECTIBLE_A(COL_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),GAT_ID INTEGER,CONSTRAINT COLLECTION_COLLECTIBLE_A_FK_1 FOREIGN KEY(GAT_ID) REFERENCES COLLECTION_GATHERER(GAT_ID))
+CREATE TABLE COLLECTION_COLLECTIBLE_BASE(COL_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),GAT_ID INTEGER,CONSTRAINT COLLECTION_COLLECTIBLE_BASE_FK_1 FOREIGN KEY(GAT_ID) REFERENCES COLLECTION_GATHERER(GAT_ID))
+CREATE TABLE COLLECTION_COLLECTIBLE_B(COL_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),GAT_ID INTEGER,CONSTRAINT COLLECTION_COLLECTIBLE_B_FK_1 FOREIGN KEY(GAT_ID) REFERENCES COLLECTION_GATHERER(GAT_ID))
+CREATE TABLE COLLECTION_COLLECTIBLE_C(COL_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),GAT_ID INTEGER,EXTENT_NAME VARCHAR(150),CONSTRAINT COLLECTION_COLLECTIBLE_C_FK_1 FOREIGN KEY(GAT_ID) REFERENCES COLLECTION_GATHERER(GAT_ID))
+CREATE TABLE COLLECTION_COLLECTIBLE_CC(COL_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),GAT_ID INTEGER,EXTENT_NAME VARCHAR(150),CONSTRAINT COLLECTION_COLLECTIBLE_CC_FK_1 FOREIGN KEY(GAT_ID) REFERENCES COLLECTION_GATHERER(GAT_ID))
+CREATE TABLE COLLECTION_COLLECTIBLE_CCC(COL_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),GAT_ID INTEGER,EXTENT_NAME VARCHAR(150),CONSTRAINT COLLECTION_COLLECTIBLE_CCC_FK_1 FOREIGN KEY(GAT_ID) REFERENCES COLLECTION_GATHERER(GAT_ID))
+CREATE TABLE COLLECTION_COLLECTIBLE_D(COL_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),OJB_CONCRETE_CLASS VARCHAR(150),GAT_ID INTEGER,CONSTRAINT COLLECTION_COLLECTIBLE_D_FK_1 FOREIGN KEY(GAT_ID) REFERENCES COLLECTION_GATHERER(GAT_ID))
+CREATE TABLE READONLY_TEST(OBJ_ID DECIMAL NOT NULL PRIMARY KEY,NAME VARCHAR(150),RO_STRING VARCHAR(150),RO_LONG DECIMAL)
+CREATE TABLE TABLE_E(ID INTEGER NOT NULL PRIMARY KEY,SOMESUPERVALUE INTEGER)
+CREATE TABLE TABLE_F(ID INTEGER NOT NULL PRIMARY KEY,E_ID INTEGER,SOMEVALUE INTEGER,CONSTRAINT TABLE_F_FK_1 FOREIGN KEY(E_ID) REFERENCES TABLE_E(ID))
+CREATE TABLE TABLE_G(ID INTEGER NOT NULL PRIMARY KEY,F_ID INTEGER,SOMESUBVALUE INTEGER,CONSTRAINT TABLE_G_FK_1 FOREIGN KEY(F_ID) REFERENCES TABLE_F(ID))
+CREATE TABLE TABLE_F1(ID INTEGER NOT NULL PRIMARY KEY,SOMEVALUE INTEGER,CONSTRAINT TABLE_F1_FK_1 FOREIGN KEY(ID) REFERENCES TABLE_E(ID))
+CREATE TABLE TABLE_G1(ID INTEGER NOT NULL PRIMARY KEY,SOMESUBVALUE INTEGER,CONSTRAINT TABLE_G1_FK_1 FOREIGN KEY(ID) REFERENCES TABLE_F1(ID))
+CREATE TABLE ABSTRACT_COLLECTION_Z(OBJ_ID INTEGER NOT NULL PRIMARY KEY,CONTAINER_ID INTEGER,NAME VARCHAR(150),SOMEVALUE INTEGER)
+CREATE TABLE ABSTRACT_COLLECTION_ZZ(OBJ_ID INTEGER NOT NULL PRIMARY KEY,CONTAINER_ID INTEGER,NAME VARCHAR(150),ZZ_NAME VARCHAR(150),SOMEVALUE INTEGER)
+CREATE TABLE XCONTAINER(OBJ_ID INTEGER NOT NULL PRIMARY KEY)
+CREATE TABLE NESTED_FIELDS_TAB(OBJ_ID DECIMAL NOT NULL PRIMARY KEY,NAME VARCHAR(150),NESTED_VALUE VARCHAR(150),NESTED_DESCRIPTION VARCHAR(150))
+CREATE TABLE NESTED_FIELDS_ENTRY(OBJ_ID INTEGER NOT NULL PRIMARY KEY,FK_ID DECIMAL,NAME VARCHAR(150))
+CREATE TABLE TAB_COMPONENT(PK_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),PARENT_ID INTEGER,CHILD_ID INTEGER,GROUP_ID INTEGER)
+CREATE TABLE TAB_GROUP(PK_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150))
+CREATE TABLE LOCK_MULTI(OJB_ID INTEGER NOT NULL PRIMARY KEY,VERSION INTEGER,REF_ID INTEGER,NAME VARCHAR(250))
+CREATE TABLE LOCK_MULTI_REF(OJB_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250),VERSION INTEGER)
+CREATE TABLE CRT_EMPLOYEE(EMPLOYEE_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150))
+CREATE TABLE CRT_MEMBER(ROLE_ID INTEGER NOT NULL PRIMARY KEY,EMPLOYEE_ID INTEGER,NAME VARCHAR(150),CONSTRAINT CRT_MEMBER_FK_1 FOREIGN KEY(EMPLOYEE_ID) REFERENCES CRT_EMPLOYEE(EMPLOYEE_ID))
+CREATE TABLE CRT_LEADER(ROLE_ID INTEGER NOT NULL PRIMARY KEY,EMPLOYEE_ID INTEGER,NAME VARCHAR(150),CONSTRAINT CRT_LEADER_FK_1 FOREIGN KEY(EMPLOYEE_ID) REFERENCES CRT_EMPLOYEE(EMPLOYEE_ID))
+CREATE TABLE CRT_PROJECT(PROJECT_ID INTEGER NOT NULL PRIMARY KEY,ENGINEER_ID INTEGER,NAME VARCHAR(150),CONSTRAINT CRT_PROJECT_FK_1 FOREIGN KEY(ENGINEER_ID) REFERENCES CRT_LEADER(ROLE_ID))
+CREATE TABLE CRT_SUB_PROJECT(SUB_ID INTEGER NOT NULL PRIMARY KEY,PROJECT_ID INTEGER,TUTOR_ID INTEGER,NAME VARCHAR(150),CONSTRAINT CRT_SUB_PROJECT_FK_1 FOREIGN KEY(PROJECT_ID) REFERENCES CRT_PROJECT(PROJECT_ID),CONSTRAINT CRT_SUB_PROJECT_FK_2 FOREIGN KEY(TUTOR_ID) REFERENCES CRT_MEMBER(ROLE_ID))
+CREATE TABLE OTM_PERSON(ID INTEGER NOT NULL PRIMARY KEY,FIRSTNAME VARCHAR(60),LASTNAME VARCHAR(60),MAIN_ADDRESS_ID INTEGER)
+CREATE TABLE OTM_ADDRESS(ID INTEGER NOT NULL PRIMARY KEY,COUNTRY VARCHAR(60),CITY VARCHAR(60),STREET VARCHAR(60))
+CREATE TABLE OTM_ADDRESS_DESC(ID INTEGER NOT NULL PRIMARY KEY,DESCRIPTION VARCHAR(60),PERSON_ID INTEGER,ADDRESS_ID INTEGER)
+CREATE TABLE OJB_HL_SEQ(TABLENAME VARCHAR(175) NOT NULL,FIELDNAME VARCHAR(70) NOT NULL,MAX_KEY INTEGER,GRAB_SIZE INTEGER,VERSION INTEGER,CONSTRAINT SYS_PK_OJB_HL_SEQ PRIMARY KEY(TABLENAME,FIELDNAME))
+CREATE TABLE OJB_LOCKENTRY(OID_ VARCHAR(250) NOT NULL,TX_ID VARCHAR(50) NOT NULL,TIMESTAMP_ TIMESTAMP,ISOLATIONLEVEL INTEGER,LOCKTYPE INTEGER,CONSTRAINT SYS_PK_OJB_LOCKENTRY PRIMARY KEY(OID_,TX_ID))
+CREATE TABLE OJB_NRM(NAME VARCHAR(250) NOT NULL PRIMARY KEY,OID_ LONGVARBINARY)
+CREATE TABLE OJB_DLIST(ID INTEGER NOT NULL PRIMARY KEY,SIZE_ INTEGER)
+CREATE TABLE OJB_DLIST_ENTRIES(ID INTEGER NOT NULL PRIMARY KEY,DLIST_ID INTEGER,POSITION_ INTEGER,OID_ LONGVARBINARY)
+CREATE TABLE OJB_DSET(ID INTEGER NOT NULL PRIMARY KEY,SIZE_ INTEGER)
+CREATE TABLE OJB_DSET_ENTRIES(ID INTEGER NOT NULL PRIMARY KEY,DLIST_ID INTEGER,POSITION_ INTEGER,OID_ LONGVARBINARY)
+CREATE TABLE OJB_DMAP(ID INTEGER NOT NULL PRIMARY KEY,SIZE_ INTEGER)
+CREATE TABLE OJB_DMAP_ENTRIES(ID INTEGER NOT NULL PRIMARY KEY,DMAP_ID INTEGER,KEY_OID BINARY,VALUE_OID BINARY)
+ALTER TABLE TABLE_1 ADD CONSTRAINT TABLE_1_FK_1 FOREIGN KEY(FK_TO_RELATED) REFERENCES TABLE_2(PK)
+ALTER TABLE BIDIR_A ADD CONSTRAINT BIDIR_A_FK_1 FOREIGN KEY(FK_TO_B) REFERENCES BIDIR_B(PK)
+GRANT ALL ON CLASS "java.lang.Math" TO PUBLIC
+GRANT ALL ON CLASS "org.hsqldb.Library" TO PUBLIC
+CREATE USER SA PASSWORD "" ADMIN
+CREATE ALIAS DAYNAME FOR "org.hsqldb.Library.dayname"
+CREATE ALIAS SPACE FOR "org.hsqldb.Library.space"
+CREATE ALIAS SUBSTRING FOR "org.hsqldb.Library.substring"
+CREATE ALIAS HEXTORAW FOR "org.hsqldb.Library.hexToRaw"
+CREATE ALIAS SQRT FOR "java.lang.Math.sqrt"
+CREATE ALIAS ABS FOR "org.hsqldb.Library.abs"
+CREATE ALIAS POWER FOR "java.lang.Math.pow"
+CREATE ALIAS CHAR FOR "org.hsqldb.Library.character"
+CREATE ALIAS CONCAT FOR "org.hsqldb.Library.concat"
+CREATE ALIAS PI FOR "org.hsqldb.Library.pi"
+CREATE ALIAS RAWTOHEX FOR "org.hsqldb.Library.rawToHex"
+CREATE ALIAS SECOND FOR "org.hsqldb.Library.second"
+CREATE ALIAS TRUNCATE FOR "org.hsqldb.Library.truncate"
+CREATE ALIAS MONTH FOR "org.hsqldb.Library.month"
+CREATE ALIAS LOWER FOR "org.hsqldb.Library.lcase"
+CREATE ALIAS ATAN2 FOR "java.lang.Math.atan2"
+CREATE ALIAS REPEAT FOR "org.hsqldb.Library.repeat"
+CREATE ALIAS DAYOFMONTH FOR "org.hsqldb.Library.dayofmonth"
+CREATE ALIAS TAN FOR "java.lang.Math.tan"
+CREATE ALIAS RADIANS FOR "java.lang.Math.toRadians"
+CREATE ALIAS FLOOR FOR "java.lang.Math.floor"
+CREATE ALIAS NOW FOR "org.hsqldb.Library.now"
+CREATE ALIAS ACOS FOR "java.lang.Math.acos"
+CREATE ALIAS DAYOFWEEK FOR "org.hsqldb.Library.dayofweek"
+CREATE ALIAS CEILING FOR "java.lang.Math.ceil"
+CREATE ALIAS DAYOFYEAR FOR "org.hsqldb.Library.dayofyear"
+CREATE ALIAS LCASE FOR "org.hsqldb.Library.lcase"
+CREATE ALIAS WEEK FOR "org.hsqldb.Library.week"
+CREATE ALIAS SOUNDEX FOR "org.hsqldb.Library.soundex"
+CREATE ALIAS ASIN FOR "java.lang.Math.asin"
+CREATE ALIAS LOCATE FOR "org.hsqldb.Library.locate"
+CREATE ALIAS EXP FOR "java.lang.Math.exp"
+CREATE ALIAS MONTHNAME FOR "org.hsqldb.Library.monthname"
+CREATE ALIAS YEAR FOR "org.hsqldb.Library.year"
+CREATE ALIAS LEFT FOR "org.hsqldb.Library.left"
+CREATE ALIAS ROUNDMAGIC FOR "org.hsqldb.Library.roundMagic"
+CREATE ALIAS BITOR FOR "org.hsqldb.Library.bitor"
+CREATE ALIAS LTRIM FOR "org.hsqldb.Library.ltrim"
+CREATE ALIAS COT FOR "org.hsqldb.Library.cot"
+CREATE ALIAS COS FOR "java.lang.Math.cos"
+CREATE ALIAS MOD FOR "org.hsqldb.Library.mod"
+CREATE ALIAS SIGN FOR "org.hsqldb.Library.sign"
+CREATE ALIAS DEGREES FOR "java.lang.Math.toDegrees"
+CREATE ALIAS LOG FOR "java.lang.Math.log"
+CREATE ALIAS SIN FOR "java.lang.Math.sin"
+CREATE ALIAS CURTIME FOR "org.hsqldb.Library.curtime"
+CREATE ALIAS DIFFERENCE FOR "org.hsqldb.Library.difference"
+CREATE ALIAS INSERT FOR "org.hsqldb.Library.insert"
+CREATE ALIAS SUBSTR FOR "org.hsqldb.Library.substring"
+CREATE ALIAS DATABASE FOR "org.hsqldb.Library.database"
+CREATE ALIAS MINUTE FOR "org.hsqldb.Library.minute"
+CREATE ALIAS HOUR FOR "org.hsqldb.Library.hour"
+CREATE ALIAS IDENTITY FOR "org.hsqldb.Library.identity"
+CREATE ALIAS QUARTER FOR "org.hsqldb.Library.quarter"
+CREATE ALIAS CURDATE FOR "org.hsqldb.Library.curdate"
+CREATE ALIAS BITAND FOR "org.hsqldb.Library.bitand"
+CREATE ALIAS USER FOR "org.hsqldb.Library.user"
+CREATE ALIAS UCASE FOR "org.hsqldb.Library.ucase"
+CREATE ALIAS RTRIM FOR "org.hsqldb.Library.rtrim"
+CREATE ALIAS LOG10 FOR "org.hsqldb.Library.log10"
+CREATE ALIAS RIGHT FOR "org.hsqldb.Library.right"
+CREATE ALIAS ATAN FOR "java.lang.Math.atan"
+CREATE ALIAS UPPER FOR "org.hsqldb.Library.ucase"
+CREATE ALIAS ASCII FOR "org.hsqldb.Library.ascii"
+CREATE ALIAS RAND FOR "java.lang.Math.random"
+CREATE ALIAS LENGTH FOR "org.hsqldb.Library.length"
+CREATE ALIAS ROUND FOR "org.hsqldb.Library.round"
+CREATE ALIAS REPLACE FOR "org.hsqldb.Library.replace"
+INSERT INTO KATEGORIEN VALUES(1,'Beverages','Alles leckere zum S\u00fcffeln')
+INSERT INTO KATEGORIEN VALUES(2,'Spices','Gew\u00fcrze, Dressings etc.')
+INSERT INTO KATEGORIEN VALUES(3,'Meat','')
+INSERT INTO KATEGORIEN VALUES(4,'Liquors','')
+INSERT INTO KATEGORIEN VALUES(5,'Books','Strange Books...')
+INSERT INTO KATEGORIEN VALUES(6,'bread','')
+INSERT INTO KATEGORIEN VALUES(7,'Fruits','Fr\u00fcchte etc.')
+INSERT INTO KATEGORIEN VALUES(8,'Dairy Products','Kat 8')
+INSERT INTO ARTIKEL VALUES(1,'Chai',1,1,'10 boxes x 20 bags',18.53E0,39,0,10,0)
+INSERT INTO ARTIKEL VALUES(2,'Chang',1,1,'24 - 12 oz bottles',19.89E0,17,40,25,0)
+INSERT INTO ARTIKEL VALUES(3,'Aniseed Syrup',1,2,'12 - 550 ml bottles',10.2E0,13,70,25,0)
+INSERT INTO ARTIKEL VALUES(4,'Chef Antons Cajun Seasoning',2,2,'48 - 6 oz jars',22.0E0,53,0,0,0)
+INSERT INTO ARTIKEL VALUES(5,'Chef Anton\u00b4s Gumbo Mix',2,2,'36 boxes',21.35E0,0,0,0,1)
+INSERT INTO ARTIKEL VALUES(6,'Grandma\u00b4s Boysenberry Spread',3,2,'12 - 8 oz jars',25.0E0,120,0,25,0)
+INSERT INTO ARTIKEL VALUES(7,'Uncle Bob\u00b4s Organic Dried Pears',3,7,'12 - 1 lb pkgs.',30.0E0,15,0,10,0)
+INSERT INTO ARTIKEL VALUES(8,'Northwoods Cranberry Sauce',3,2,'12 - 12 oz jars',40.0E0,6,0,0,0)
+INSERT INTO ARTIKEL VALUES(9,'Mishi Kobe Niku',4,6,'18 - 500 g pkgs.',97.0E0,29,0,0,1)
+INSERT INTO ARTIKEL VALUES(10,'Ikura',4,8,'12 - 200 ml jars',31.0E0,31,0,0,0)
+INSERT INTO ARTIKEL VALUES(11,'Queso Cabrales',5,4,'1 kg pkg.',21.0E0,22,30,30,0)
+INSERT INTO ARTIKEL VALUES(12,'Queso Manchego La Pastora',5,4,'10 - 500 g pkgs.',38.0E0,86,0,0,0)
+INSERT INTO ARTIKEL VALUES(13,'Konbu',6,8,'2 kg box',6.0E0,24,0,5,0)
+INSERT INTO ARTIKEL VALUES(14,'Tofu',6,7,'40 - 100 g pkgs.',23.25E0,35,0,0,0)
+INSERT INTO ARTIKEL VALUES(15,'Genen Shouyu',6,2,'24 - 250 ml bottles',15.5E0,39,0,5,0)
+INSERT INTO ARTIKEL VALUES(16,'Pavlova',7,3,'32 - 500 g boxes',17.45E0,29,0,10,0)
+INSERT INTO ARTIKEL VALUES(17,'Alice Mutton',7,6,'20 - 1 kg tins',39.0E0,0,0,0,1)
+INSERT INTO ARTIKEL VALUES(18,'Carnarvon Tigers',7,8,'16 kg pkg.',62.5E0,42,0,0,0)
+INSERT INTO ARTIKEL VALUES(19,'Teatime Chocolate Biscuits',8,3,'10 boxes x 12 pieces',9.2E0,25,0,5,0)
+INSERT INTO ARTIKEL VALUES(20,'Sir Rodney\u00b4s Marmalade',8,3,'30 gift boxes',81.0E0,40,0,0,0)
+INSERT INTO ARTIKEL VALUES(21,'Sir Rodney\u00b4s Scones',8,3,'24 pkgs. x 4 pieces',10.0E0,3,40,5,0)
+INSERT INTO ARTIKEL VALUES(22,'Gustaf\u00b4s Kn\u00e4ckebr\u00f6d',9,5,'24 - 500 g pkgs.',21.0E0,104,0,25,0)
+INSERT INTO ARTIKEL VALUES(23,'Tunnbr\u00f6d',9,5,'12 - 250 g pkgs.',9.0E0,61,0,25,0)
+INSERT INTO ARTIKEL VALUES(24,'Guaran\u00e1 Fant\u00e1stica',10,1,'12 - 355 ml cans',4.5E0,20,0,0,1)
+INSERT INTO ARTIKEL VALUES(25,'NuNuCa Nu\u00df-Nougat-Creme',11,3,'20 - 450 g glasses',14.0E0,76,0,30,0)
+INSERT INTO ARTIKEL VALUES(26,'Gumb\u00e4r Gummib\u00e4rchen',11,3,'100 - 250 g bags',31.23E0,15,0,0,0)
+INSERT INTO ARTIKEL VALUES(27,'Schoggi Schokolade',11,3,'100 - 100 g pieces',43.9E0,49,0,30,0)
+INSERT INTO ARTIKEL VALUES(28,'R\u00f6ssle Sauerkraut',12,7,'25 - 825 g cans',45.6E0,26,0,0,1)
+INSERT INTO ARTIKEL VALUES(29,'Th\u00fcringer Rostbratwurst',12,6,'50 bags x 30 sausgs.',123.79E0,0,0,0,1)
+INSERT INTO ARTIKEL VALUES(30,'Nord-Ost Matjeshering',13,8,'10 - 200 g glasses',25.89E0,10,0,15,0)
+INSERT INTO ARTIKEL VALUES(31,'Gorgonzola Telino',14,4,'12 - 100 g pkgs',12.5E0,0,70,20,0)
+INSERT INTO ARTIKEL VALUES(32,'Mascarpone Fabioli',14,4,'24 - 200 g pkgs.',32.0E0,9,40,25,0)
+INSERT INTO ARTIKEL VALUES(33,'Geitost',15,4,'500 g',2.5E0,112,0,20,0)
+INSERT INTO ARTIKEL VALUES(34,'Sasquatch Ale',16,1,'24 - 12 oz bottles',14.0E0,111,0,15,0)
+INSERT INTO ARTIKEL VALUES(35,'Steeleye Stout',16,1,'24 - 12 oz bottles',18.0E0,20,0,15,0)
+INSERT INTO ARTIKEL VALUES(36,'Inlagd Sill',17,8,'24 - 250 g jars',19.0E0,112,0,20,0)
+INSERT INTO ARTIKEL VALUES(37,'Gravad lax',17,8,'12 - 500 g pkgs.',26.0E0,11,50,25,0)
+INSERT INTO ARTIKEL VALUES(38,'C\u00f4te de Blaye',18,1,'12 - 75 cl bottles',263.5E0,17,0,15,0)
+INSERT INTO ARTIKEL VALUES(39,'Chartreuse verte',18,1,'750 cc per bottle',18.0E0,69,0,5,0)
+INSERT INTO ARTIKEL VALUES(40,'Boston Crab Meat',19,8,'24 - 4 oz tins',18.4E0,123,0,30,0)
+INSERT INTO ARTIKEL VALUES(41,'Jack\u00b4s New England Clam Chowder',19,8,'12 - 12 oz cans',9.65E0,85,0,10,0)
+INSERT INTO ARTIKEL VALUES(42,'Singaporean Hokkien Fried Mee',20,5,'32 - 1 kg pkgs.',14.0E0,26,0,0,1)
+INSERT INTO ARTIKEL VALUES(43,'Ipoh Coffee',20,1,'16 - 500 g tins',46.0E0,17,10,25,0)
+INSERT INTO ARTIKEL VALUES(44,'Gula Malacca',20,2,'20 - 2 kg bags',19.45E0,27,0,15,0)
+INSERT INTO ARTIKEL VALUES(45,'R\u00f8gede sild',21,8,'1k pkg.',9.5E0,5,70,15,0)
+INSERT INTO ARTIKEL VALUES(46,'Spegesild',21,8,'4 - 450 g glasses',12.0E0,95,0,0,0)
+INSERT INTO ARTIKEL VALUES(47,'Zaanse koeken',22,3,'10 - 4 oz boxes',9.5E0,36,0,0,0)
+INSERT INTO ARTIKEL VALUES(48,'Chocolade',22,3,'10 pkgs.',12.75E0,15,70,25,0)
+INSERT INTO ARTIKEL VALUES(49,'Maxilaku',23,3,'24 - 50 g pkgs.',20.0E0,10,60,15,0)
+INSERT INTO ARTIKEL VALUES(50,'Valkoinen suklaa',23,3,'12 - 100 g bars',16.25E0,65,0,30,0)
+INSERT INTO ARTIKEL VALUES(51,'Manjimup Dried Apples',24,7,'50 - 300 g pkgs.',53.0E0,20,0,10,0)
+INSERT INTO ARTIKEL VALUES(52,'Filo Mix',24,5,'16 - 2 kg boxes',7.0E0,38,0,25,0)
+INSERT INTO ARTIKEL VALUES(53,'Perth Pasties',24,6,'48 pieces',32.8E0,0,0,0,1)
+INSERT INTO ARTIKEL VALUES(54,'Tourti\u00e8re',25,6,'16 pies',7.45E0,21,0,10,0)
+INSERT INTO ARTIKEL VALUES(55,'P\u00e2t\u00e9 chinois',25,6,'24 boxes x 2 pies',24.0E0,115,0,20,0)
+INSERT INTO ARTIKEL VALUES(56,'Gnocchi di nonna Alice',26,5,'24 - 250 g pkgs.',38.0E0,21,10,30,0)
+INSERT INTO ARTIKEL VALUES(57,'Ravioli Angelo',26,5,'24 - 250 g pkgs.',19.5E0,36,0,20,0)
+INSERT INTO ARTIKEL VALUES(58,'Escargots de Bourgogne',27,8,'24 pieces',13.25E0,62,0,20,0)
+INSERT INTO ARTIKEL VALUES(59,'Raclette Courdavault',28,4,'5 kg pkg.',55.0E0,79,0,0,0)
+INSERT INTO ARTIKEL VALUES(60,'Camembert Pierrot',28,4,'15 - 300 g rounds',34.0E0,19,0,0,0)
+INSERT INTO ARTIKEL VALUES(61,'Sirop d\u00b4\u00e9rable',29,2,'24 - 500 ml bottles',28.5E0,113,0,25,0)
+INSERT INTO ARTIKEL VALUES(62,'Tarte au sucre',29,3,'48 pies',49.3E0,17,0,0,0)
+INSERT INTO ARTIKEL VALUES(63,'Vegie-spread',7,2,'15 - 625 g jars',43.9E0,24,0,5,0)
+INSERT INTO ARTIKEL VALUES(64,'Wimmers gute Semmelkn\u00f6del',12,5,'20 bags x 4 pieces',33.25E0,22,80,30,0)
+INSERT INTO ARTIKEL VALUES(65,'Louisiana Fiery Hot Pepper Sauce',2,2,'32 - 8 oz bottles',21.05E0,76,0,0,0)
+INSERT INTO ARTIKEL VALUES(66,'Louisiana Hot Spiced Okra',2,2,'24 - 8 oz jars',17.0E0,4,100,20,0)
+INSERT INTO ARTIKEL VALUES(67,'Laughing Lumberjack Lager',16,1,'24 - 12 oz bottles',14.0E0,52,0,10,0)
+INSERT INTO ARTIKEL VALUES(68,'Scottish Longbreads',8,3,'10 boxes x 8 pieces',12.5E0,6,10,15,0)
+INSERT INTO ARTIKEL VALUES(69,'Gudbrandsdalsost',15,4,'10 kg pkg.',36.0E0,26,0,15,0)
+INSERT INTO ARTIKEL VALUES(70,'Outback Lager',7,1,'24 - 355 ml bottles',15.0E0,15,10,30,0)
+INSERT INTO ARTIKEL VALUES(71,'Fl\u00f8temysost',15,4,'10 - 500 g pkgs.',21.5E0,26,0,0,0)
+INSERT INTO ARTIKEL VALUES(72,'Mozzarella di Giovanni',14,4,'24 - 200 g pkgs.',34.8E0,14,0,0,0)
+INSERT INTO ARTIKEL VALUES(73,'R\u00f6d Kaviar',17,8,'24 - 150 g jars',15.0E0,101,0,5,0)
+INSERT INTO ARTIKEL VALUES(74,'Longlife Tofu',4,7,'5 kg pkg.',10.0E0,4,20,5,0)
+INSERT INTO ARTIKEL VALUES(75,'Rh\u00f6nbr\u00e4u Klosterbier',12,1,'24 - 0.5 l bottles',7.75E0,125,0,25,0)
+INSERT INTO ARTIKEL VALUES(76,'Lakkalik\u00f6\u00f6ri',23,1,'500 ml',18.0E0,57,0,20,0)
+INSERT INTO ARTIKEL VALUES(77,'Original Frankfurter gr\u00fcne So\u00dfe',12,2,'12 boxes',13.0E0,32,0,15,0)
+INSERT INTO BOOKS VALUES(100,'Hamlet',12,5,'12 boxes',34.0E0,32,0,15,0,'1234567890','W. Shakespeare')
+INSERT INTO BOOKS VALUES(101,'Faust',12,5,'12 boxes',56.0E0,32,0,15,0,'1234567890','J.W. v. Goethe')
+INSERT INTO CDS VALUES(200,'Mama\u00b4s Gun',12,5,'12 boxes',23.0E0,32,0,15,0,'Motown Records','Erykah Badu')
+INSERT INTO CDS VALUES(201,'STREETSOUL',12,5,'12 boxes',25.0E0,32,0,15,0,'Virgin Records','Guru\u00b4s Jazzmatazz')
+INSERT INTO CDS VALUES(202,'Beyond Skin',12,5,'12 boxes',25.0E0,32,0,15,0,'Outcaste Records','Nitin Sawhney')
+INSERT INTO ORDER_POSITION VALUES(1,1,5)
+INSERT INTO ORDER_POSITION VALUES(2,1,100)
+INSERT INTO ORDER_POSITION VALUES(3,1,200)
+INSERT INTO PERSON VALUES(1,'tom','tom')
+INSERT INTO PERSON VALUES(2,'bob','bob')
+INSERT INTO PERSON VALUES(3,'albert','albert')
+INSERT INTO PERSON VALUES(4,'bertrand','bertrand')
+INSERT INTO PERSON VALUES(5,'cindy','cindy')
+INSERT INTO PERSON VALUES(6,'dorothy','dorothy')
+INSERT INTO PERSON VALUES(7,'eugen','eugen')
+INSERT INTO PERSON VALUES(8,'frido','frido')
+INSERT INTO PERSON VALUES(9,'guido','guido')
+INSERT INTO PERSON VALUES(10,'hank','hank')
+INSERT INTO PROJECT VALUES(1,'OJB','OJB')
+INSERT INTO PROJECT VALUES(2,'SODA','SODA')
+INSERT INTO PROJECT VALUES(3,'HSQLDB','HSQLDB')
+INSERT INTO PROJECT VALUES(4,'XERCES','XERCES')
+INSERT INTO PROJECT VALUES(5,'Linux','Linux')
+INSERT INTO PROJECT VALUES(6,'mySQL','mySQL')
+INSERT INTO PERSON_PROJECT VALUES(1,1,'founder')
+INSERT INTO PERSON_PROJECT VALUES(1,2,'friend')
+INSERT INTO PERSON_PROJECT VALUES(2,1,'developer')
+INSERT INTO PERSON_PROJECT VALUES(2,2,'lead')
+INSERT INTO PERSON_PROJECT VALUES(2,3,'developer')
+INSERT INTO PERSON_PROJECT VALUES(3,2,'tester')
+INSERT INTO PERSON_PROJECT VALUES(3,4,'user')
+INSERT INTO PERSON_PROJECT VALUES(3,5,'developer')
+INSERT INTO PERSON_PROJECT VALUES(4,1,'developer')
+INSERT INTO PERSON_PROJECT VALUES(5,2,'tester')
+INSERT INTO PERSON_PROJECT VALUES(5,4,'lead')
+INSERT INTO PERSON_PROJECT VALUES(7,4,'lead')
+INSERT INTO PERSON_PROJECT VALUES(7,5,'founder')
+INSERT INTO PERSON_PROJECT VALUES(7,6,'tester')
+INSERT INTO TASK VALUES(1,2,1,'Initial Layout')
+INSERT INTO TASK VALUES(2,2,1,'Initial Spec')
+INSERT INTO TASK VALUES(3,2,2,'Project Cleanup')
+INSERT INTO TASK VALUES(4,2,3,'Testing Scripts')
+INSERT INTO CONV_REFERER VALUES(1,50,10)
+INSERT INTO CONV_REFERER VALUES(2,51,11)
+INSERT INTO CONV_REFERER VALUES(3,52,12)
+INSERT INTO CONV_REFERED VALUES(50,60)
+INSERT INTO CONV_REFERED VALUES(51,61)
+INSERT INTO CONV_REFERED VALUES(52,62)
+INSERT INTO NEWS VALUES(1,'Healf Care News (NONE)')
+INSERT INTO NEWS VALUES(2,'Ferrai for sale (CARS - BUYERS)')
+INSERT INTO NEWS VALUES(3,'Brazil World Cup Champion ! (SPORTS)')
+INSERT INTO PAPER VALUES(10,'NONE','today','NONE')
+INSERT INTO PAPER VALUES(11,'SALES','yesterday','SALES MAN')
+INSERT INTO TOPIC VALUES(10,'Buyers')
+INSERT INTO TOPIC VALUES(11,'Sellers')
+INSERT INTO CATEGORY VALUES(1,'Cars')
+INSERT INTO CATEGORY VALUES(2,'Sports')
+INSERT INTO AREA VALUES(20,'Human')
+INSERT INTO AREA VALUES(21,'NotHuman')
+INSERT INTO CONTENT_QUALIFIER VALUES(2,1)
+INSERT INTO CONTENT_QUALIFIER VALUES(2,10)
+INSERT INTO CONTENT_QUALIFIER VALUES(3,2)
+INSERT INTO CONTENT_QUALIFIER VALUES(10,20)
+INSERT INTO CONTENT_QUALIFIER VALUES(11,11)
+INSERT INTO SM_TAB_MAX_A VALUES(120,'A')
+INSERT INTO SM_TAB_MAX_A VALUES(121,'A')
+INSERT INTO SM_TAB_MAX_AA VALUES(101,'AA')
+INSERT INTO SM_TAB_MAX_AA VALUES(102,'AA')
+INSERT INTO SM_TAB_MAX_AB VALUES(99,'AB')
+INSERT INTO SM_TAB_MAX_AAA VALUES(123,'AAA')
+INSERT INTO SM_TAB_MAX_B VALUES(115,'B')
+INSERT INTO SM_TAB_MAX_B VALUES(116,'B')
+INSERT INTO SM_TAB_MAX_BB VALUES(130,'BB')
+INSERT INTO SM_TAB_MAX_BB VALUES(131,'BB')
1.27 +1 -1 db-ojb/src/test/org/apache/ojb/quick-db/OJB.properties
Index: OJB.properties
===================================================================
RCS file: /home/cvs/db-ojb/src/test/org/apache/ojb/quick-db/OJB.properties,v
retrieving revision 1.26
retrieving revision 1.27
diff -u -r1.26 -r1.27
--- OJB.properties 6 Dec 2003 19:06:24 -0000 1.26
+++ OJB.properties 11 Dec 2003 20:13:23 -0000 1.27
@@ -1,5 +1,5 @@
#HSQL database
-#Sat Dec 06 19:38:27 CET 2003
+#Thu Dec 11 20:51:56 CET 2003
sql.strict_fk=true
readonly=false
sql.strong_fk=true
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org