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.script OJB.properties
Date Thu, 11 Dec 2003 20:13:23 GMT
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


Mime
View raw message