final implementation of MaterialOrMethodEvent, Cloning, PreservationMethod, ... ...

[cdmlib.git] / cdmlib-ext / src / test / resources / dbscripts / 001-cdm.h2.sql

diff --git a/cdmlib-ext/src/test/resources/dbscripts/001-cdm.h2.sql b/cdmlib-ext/src/test/resources/dbscripts/001-cdm.h2.sql
index 89ed4af6a0245d8cd49099b1166ead4ea594cdc1..96ccbb9040dab64ed1e0f11f207395f0abe76c5f 100644 (file)
--- a/cdmlib-ext/src/test/resources/dbscripts/001-cdm.h2.sql
+++ b/cdmlib-ext/src/test/resources/dbscripts/001-cdm.h2.sql
@@ -466,12 +466,12 @@ CREATE CACHED TABLE PUBLIC.CDMMETADATA(
     CREATEDBY_ID INTEGER
 );
 -- 3 +/- SELECT COUNT(*) FROM PUBLIC.CDMMETADATA;
-CREATE CACHED TABLE PUBLIC.CDMPREFERENCES(
-    SUBJECT VARCHAR(255),
-    PREDICATE VARCHAR(255),
+CREATE CACHED TABLE PUBLIC.CDMPREFERENCE(
+    KEY_SUBJECT VARCHAR(100),
+    KEY_PREDICATE VARCHAR(100),
     VALUE VARCHAR(1023)
 );
--- 3 +/- SELECT COUNT(*) FROM PUBLIC.CDMMETADATA;
+-- 3 +/- SELECT COUNT(*) FROM PUBLIC.CDMPREFERENCE;
 CREATE CACHED TABLE PUBLIC.CLASSIFICATION(
     ID INTEGER NOT NULL,
     CREATED TIMESTAMP,
@@ -598,72 +598,6 @@ CREATE CACHED TABLE PUBLIC.CLASSIFICATION_TAXONNODE_AUD(
     REVTYPE TINYINT
 );
 
-CREATE TABLE PUBLIC.CLONING (
-       ID INTEGER NOT NULL,
-    UUID VARCHAR(36),
-    CREATED TIMESTAMP,
-    UPDATED TIMESTAMP,
-    CREATEDBY_ID INTEGER,
-    UPDATEDBY_ID INTEGER,
-    DESCRIPTION VARCHAR(255),
-    TIMEPERIOD_END VARCHAR(255),
-    TIMEPERIOD_FREETEXT VARCHAR(255),
-    TIMEPERIOD_START VARCHAR(255),
-       STRAIN VARCHAR(255),
-    METHOD_ID INTEGER,
-    ACTOR_ID INTEGER,
-    FORWARDPRIMER_ID INTEGER,
-    REVERSEPRIMER_ID INTEGER,
-    PRIMARY KEY (ID)
-);
-
-CREATE TABLE PUBLIC.CLONING_AUD (
-       ID INTEGER NOT NULL,
-    REV INTEGER NOT NULL,
-    REVTYPE TINYINT,
-    CREATED TIMESTAMP,
-    UUID VARCHAR(36),
-    UPDATED TIMESTAMP,
-    DESCRIPTION VARCHAR(255),
-    TIMEPERIOD_END VARCHAR(255),
-    TIMEPERIOD_FREETEXT VARCHAR(255),
-    TIMEPERIOD_START VARCHAR(255),
-       METHOD_ID INTEGER,
-    STRAIN VARCHAR(255),
-    CREATEDBY_ID INTEGER,
-    UPDATEDBY_ID INTEGER,
-    ACTOR_ID INTEGER,
-    FORWARDPRIMER_ID INTEGER,
-    REVERSEPRIMER_ID INTEGER
-);
-
-
-CREATE TABLE PUBLIC.CLONING_ANNOTATION (
-    CLONING_ID INTEGER NOT NULL,
-    ANNOTATIONS_ID INTEGER NOT NULL,
-    PRIMARY KEY (CLONING_ID, ANNOTATIONS_ID)
-);
-
-CREATE TABLE PUBLIC.CLONING_ANNOTATION_AUD (
-    REV INTEGER NOT NULL,
-    REVTYPE TINYINT,
-    CLONING_ID INTEGER NOT NULL,
-    ANNOTATIONS_ID INTEGER NOT NULL
-);
-
-CREATE TABLE PUBLIC.CLONING_MARKER (
-    CLONING_ID INTEGER NOT NULL,
-    MARKERS_ID INTEGER NOT NULL,
-    PRIMARY KEY (CLONING_ID, MARKERS_ID)
-);
-
-CREATE TABLE PUBLIC.CLONING_MARKER_AUD (
-    REV INTEGER NOT NULL,
-    REVTYPE TINYINT,
-    CLONING_ID INTEGER NOT NULL,
-    MARKERS_ID INTEGER NOT NULL
-);
-
 -- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_TAXONNODE_AUD;
 CREATE CACHED TABLE PUBLIC.COLLECTION(
     ID INTEGER NOT NULL,
@@ -2190,52 +2124,74 @@ CREATE CACHED TABLE PUBLIC.MARKER_AUD(
     MARKERTYPE_ID INTEGER
 );
 
-CREATE TABLE MATERIALANDMETHOD (
+CREATE TABLE MATERIALORMETHODEVENT (
     ID INTEGER NOT NULL,
+    DTYPE VARCHAR(255),
     CREATED TIMESTAMP,
     UUID VARCHAR(36),
     UPDATED TIMESTAMP,
-    MATERIALMETHODTERM BINARY(255),
     MATERIALMETHODTEXT VARCHAR(255),
+    DESCRIPTION VARCHAR(255),
+    TIMEPERIOD_END VARCHAR(255),
+    TIMEPERIOD_FREETEXT VARCHAR(255),
+    TIMEPERIOD_START VARCHAR(255),
+       STRAIN VARCHAR(255),
+    TEMPERATURE DOUBLE,
     CREATEDBY_ID INTEGER,
     UPDATEDBY_ID INTEGER,
+    MATERIALMETHODTERM_ID INTEGER,
+    ACTOR_ID INTEGER,
+    FORWARDPRIMER_ID INTEGER,
+    REVERSEPRIMER_ID INTEGER,
+    MEDIUM_ID INTEGER,
     PRIMARY KEY (ID)
 );
 
-CREATE TABLE MATERIALANDMETHOD_AUD (
+CREATE TABLE MATERIALORMETHODEVENT_AUD (
     ID INTEGER NOT NULL,
+    DTYPE VARCHAR(255),
     CREATED TIMESTAMP,
     UUID VARCHAR(36),
     UPDATED TIMESTAMP,
-    MATERIALMETHODTERM BINARY(255),
     MATERIALMETHODTEXT VARCHAR(255),
+    DESCRIPTION VARCHAR(255),
+    TIMEPERIOD_END VARCHAR(255),
+    TIMEPERIOD_FREETEXT VARCHAR(255),
+    TIMEPERIOD_START VARCHAR(255),
+       STRAIN VARCHAR(255),
+    TEMPERATURE DOUBLE,
     CREATEDBY_ID INTEGER,
     UPDATEDBY_ID INTEGER,
+    MATERIALMETHODTERM_ID INTEGER,
+    ACTOR_ID INTEGER,
+    FORWARDPRIMER_ID INTEGER,
+    REVERSEPRIMER_ID INTEGER,
+    MEDIUM_ID INTEGER
 );
 
-CREATE TABLE MATERIALANDMETHOD_ANNOTATION (
-    MATERIALANDMETHOD_ID INTEGER NOT NULL,
+CREATE TABLE MATERIALORMETHODEVENT_ANNOTATION (
+    MATERIALORMETHODEVENT_ID INTEGER NOT NULL,
     ANNOTATIONS_ID INTEGER NOT NULL,
-    PRIMARY KEY (MATERIALANDMETHOD_ID, ANNOTATIONS_ID)
+    PRIMARY KEY (MATERIALORMETHODEVENT_ID, ANNOTATIONS_ID)
 );
 
-CREATE TABLE MATERIALANDMETHOD_ANNOTATION_AUD (
+CREATE TABLE MATERIALORMETHODEVENT_ANNOTATION_AUD (
     REV INTEGER NOT NULL,
     REVTYPE TINYINT,
-    MATERIALANDMETHOD_ID INTEGER NOT NULL,
+    MATERIALORMETHODEVENT_ID INTEGER NOT NULL,
     ANNOTATIONS_ID INTEGER NOT NULL,
 );
 
-CREATE TABLE MATERIALANDMETHOD_MARKER (
-    MATERIALANDMETHOD_ID INTEGER NOT NULL,
+CREATE TABLE MATERIALORMETHODEVENT_MARKER (
+    MATERIALORMETHODEVENT_ID INTEGER NOT NULL,
     MARKERS_ID INTEGER NOT NULL,
-    PRIMARY KEY (MATERIALANDMETHOD_ID, MARKERS_ID)
+    PRIMARY KEY (MATERIALORMETHODEVENT_ID, MARKERS_ID)
 );
 
-CREATE TABLE MATERIALANDMETHOD_MARKER_AUD (
+CREATE TABLE MATERIALORMETHODEVENT_MARKER_AUD (
     REV INTEGER NOT NULL,
     REVTYPE TINYINT,
-    MATERIALANDMETHOD_ID INTEGER NOT NULL,
+    MATERIALORMETHODEVENT_ID INTEGER NOT NULL,
     MARKERS_ID INTEGER NOT NULL,
 );
 
@@ -3420,7 +3376,7 @@ CREATE TABLE SINGLEREAD (
     UPDATEDBY_ID INTEGER,
     ACTOR_ID INTEGER,
     AMPLIFICATION_ID INTEGER,
-    MATERIALANDMETHOD_ID INTEGER,
+    MATERIALORMETHOD_ID INTEGER,
     PHEROGRAM_ID INTEGER,
     PRIMER_ID INTEGER,
     PRIMARY KEY (ID)
@@ -3443,7 +3399,7 @@ CREATE TABLE SINGLEREAD_AUD (
     UPDATEDBY_ID INTEGER,
     ACTOR_ID INTEGER,
     AMPLIFICATION_ID INTEGER,
-    MATERIALANDMETHOD_ID INTEGER,
+    MATERIALORMETHOD_ID INTEGER,
     PHEROGRAM_ID INTEGER,
     PRIMER_ID INTEGER
 );