ref #6258 , ref #6529 adapt test dll for Registration and WorkingSet

diff --git a/cdmlib-test/src/main/resources/dbscripts/001-cdm.h2.sql b/cdmlib-test/src/main/resources/dbscripts/001-cdm.h2.sql
index 18785c7c09e6c4213e32d522d3f0ea167980f377..5f77a0cba7c67ee7aaef2fd7612b81ea1fec9625 100644 (file)
--- a/cdmlib-test/src/main/resources/dbscripts/001-cdm.h2.sql
+++ b/cdmlib-test/src/main/resources/dbscripts/001-cdm.h2.sql
@@ -3534,6 +3534,89 @@ CREATE CACHED TABLE PUBLIC.REFERENCE_RIGHTSINFO_AUD(
     REVTYPE TINYINT
 );
 -- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_RIGHTSINFO_AUD;
+CREATE CACHED TABLE PUBLIC.REGISTRATION(
+    ID INTEGER NOT NULL,
+    CREATED TIMESTAMP,
+    UUID VARCHAR(36),
+    UPDATED TIMESTAMP,
+       IDENTIFIER VARCHAR(255),
+       REGISTRATIONDATE TIMESTAMP,
+       SPECIFICIDENTIFIER VARCHAR(255),
+       STATUS VARCHAR(255),
+    CREATEDBY_ID INTEGER,
+    UPDATEDBY_ID INTEGER,
+       INSTITUTION_ID INTEGER,
+       NAME_ID INTEGER,
+       SUBMITTER_ID INTEGER
+);
+-- 2175 +/- SELECT COUNT(*) FROM PUBLIC.REGISTRATION;
+CREATE CACHED TABLE PUBLIC.REGISTRATION_AUD(
+    ID INTEGER NOT NULL,
+    REV INTEGER NOT NULL,
+    REVTYPE TINYINT,
+    CREATED TIMESTAMP,
+    UUID VARCHAR(36),
+    UPDATED TIMESTAMP,
+       IDENTIFIER VARCHAR(255),
+       REGISTRATIONDATE TIMESTAMP,
+       SPECIFICIDENTIFIER VARCHAR(255),
+       STATUS VARCHAR(255),
+    CREATEDBY_ID INTEGER,
+    UPDATEDBY_ID INTEGER,
+       INSTITUTION_ID INTEGER,
+       NAME_ID INTEGER,
+       SUBMITTER_ID INTEGER
+);
+-- 2175 +/- SELECT COUNT(*) FROM PUBLIC.REGISTRATION_AUD;
+CREATE CACHED TABLE PUBLIC.REGISTRATION_ANNOTATION(
+    REGISTRATION_ID INTEGER NOT NULL,
+    ANNOTATIONS_ID INTEGER NOT NULL
+);
+-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REGISTRATION_ANNOTATION;
+CREATE CACHED TABLE PUBLIC.REGISTRATION_ANNOTATION_AUD(
+    REV INTEGER NOT NULL,
+    REGISTRATION_ID INTEGER NOT NULL,
+    ANNOTATIONS_ID INTEGER NOT NULL,
+    REVTYPE TINYINT
+);
+-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REPRESENTATION_ANNOTATION_AUD;
+CREATE CACHED TABLE PUBLIC.REGISTRATION_MARKER(
+    REGISTRATION_ID INTEGER NOT NULL,
+    MARKERS_ID INTEGER NOT NULL
+);
+-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REGISTRATION_MARKER;
+CREATE CACHED TABLE PUBLIC.REGISTRATION_MARKER_AUD(
+    REV INTEGER NOT NULL,
+    REGISTRATION_ID INTEGER NOT NULL,
+    MARKERS_ID INTEGER NOT NULL,
+    REVTYPE TINYINT
+);
+-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REGISTRATION_MARKER_AUD;
+CREATE CACHED TABLE PUBLIC.REGISTRATION_REGISTRATION(
+    REGISTRATION_ID INTEGER NOT NULL,
+    BLOCKEDBY_ID INTEGER NOT NULL
+);
+-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REGISTRATION_REGISTRATION;
+CREATE CACHED TABLE PUBLIC.REGISTRATION_REGISTRATION_AUD(
+    REV INTEGER NOT NULL,
+    REGISTRATION_ID INTEGER NOT NULL,
+    BLOCKEDBY_ID INTEGER NOT NULL,
+    REVTYPE TINYINT
+);
+-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REGISTRATION_REGISTRATION_AUD;
+CREATE CACHED TABLE PUBLIC.REGISTRATION_TYPEDESIGNATIONBASE(
+    REGISTRATION_ID INTEGER NOT NULL,
+    TYPEDESIGNATIONS_ID INTEGER NOT NULL
+);
+-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REGISTRATION_TYPEDESIGNATIONBASE;
+CREATE CACHED TABLE PUBLIC.REGISTRATION_TYPEDESIGNATIONBASE_AUD(
+    REV INTEGER NOT NULL,
+    REGISTRATION_ID INTEGER NOT NULL,
+    TYPEDESIGNATIONS_ID INTEGER NOT NULL,
+    REVTYPE TINYINT
+);
+-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REGISTRATION_TYPEDESIGNATIONBASE_AUD;
+
 CREATE CACHED TABLE PUBLIC.RELATIONSHIPTERMBASE_INVERSEREPRESENTATION(
     RELATIONSHIPTERMBASE_ID INTEGER NOT NULL,
     INVERSEREPRESENTATIONS_ID INTEGER NOT NULL
@@ -4956,7 +5039,9 @@ CREATE CACHED TABLE PUBLIC.WORKINGSET(
     UPDATED TIMESTAMP,
     CREATEDBY_ID INTEGER,
     UPDATEDBY_ID INTEGER,
-    DESCRIPTIVESYSTEM_ID INTEGER
+    DESCRIPTIVESYSTEM_ID INTEGER,
+       MAXRANK_ID INTEGER,
+       MINRANK_ID INTEGER
 );
 -- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET;
 CREATE CACHED TABLE PUBLIC.WORKINGSET_AUD(
@@ -4969,7 +5054,9 @@ CREATE CACHED TABLE PUBLIC.WORKINGSET_AUD(
     UPDATED TIMESTAMP,
     CREATEDBY_ID INTEGER,
     UPDATEDBY_ID INTEGER,
-    DESCRIPTIVESYSTEM_ID INTEGER
+    DESCRIPTIVESYSTEM_ID INTEGER,
+       MAXRANK_ID INTEGER,
+       MINRANK_ID INTEGER
 );
 -- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_AUD;
 CREATE CACHED TABLE PUBLIC.WORKINGSET_ANNOTATION(
@@ -5008,6 +5095,18 @@ CREATE CACHED TABLE PUBLIC.WORKINGSET_MARKER_AUD(
     REVTYPE TINYINT
 );
 -- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_MARKER_AUD;
+CREATE CACHED TABLE PUBLIC.WORKINGSET_NAMEDAREA(
+    WORKINGSET_ID INTEGER NOT NULL,
+    GEOFILTER_ID INTEGER NOT NULL
+);
+-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_NAMEDAREA;
+CREATE CACHED TABLE PUBLIC.WORKINGSET_NAMEDAREA_AUD(
+    REV INTEGER NOT NULL,
+    WORKINGSET_ID INTEGER NOT NULL,
+    GEOFILTER_ID INTEGER NOT NULL,
+    REVTYPE TINYINT
+);
+-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_NAMEDAREA_AUD;
 CREATE CACHED TABLE PUBLIC.WORKINGSET_REPRESENTATION(
     WORKINGSET_ID INTEGER NOT NULL,
     REPRESENTATIONS_ID INTEGER NOT NULL
@@ -5020,6 +5119,18 @@ CREATE CACHED TABLE PUBLIC.WORKINGSET_REPRESENTATION_AUD(
     REVTYPE TINYINT
 );
 -- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_REPRESENTATION_AUD;
+CREATE CACHED TABLE PUBLIC.WORKINGSET_TAXONNODE(
+    WORKINGSET_ID INTEGER NOT NULL,
+    TAXONSUBTREEFILTER_ID INTEGER NOT NULL
+);
+-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_TAXONNODE;
+CREATE CACHED TABLE PUBLIC.WORKINGSET_TAXONNODE_AUD(
+    REV INTEGER NOT NULL,
+    WORKINGSET_ID INTEGER NOT NULL,
+    TAXONSUBTREEFILTER_ID INTEGER NOT NULL,
+    REVTYPE TINYINT
+);
+-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_TAXONNODE_AUD;
 CREATE CACHED TABLE PUBLIC.HIBERNATE_SEQUENCES(
     SEQUENCE_NAME VARCHAR(255) NOT NULL,
     NEXT_VAL BIGINT