CREATEDBY_ID INTEGER,
UPDATEDBY_ID INTEGER,
NAME_ID INTEGER,
- REFERENCE_ID INTEGER
+ REFERENCE_ID INTEGER,
+ ROOTNODE_ID INTEGER
);
-- 1 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION;
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_AUD(
CREATEDBY_ID INTEGER,
UPDATEDBY_ID INTEGER,
NAME_ID INTEGER,
- REFERENCE_ID INTEGER
+ REFERENCE_ID INTEGER,
+ ROOTNODE_ID INTEGER
);
-- 1 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_AUD;
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_ANNOTATION(
REVTYPE TINYINT
);
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_RIGHTSINFO_AUD;
-CREATE CACHED TABLE PUBLIC.CLASSIFICATION_TAXONNODE(
- CLASSIFICATION_ID INTEGER NOT NULL,
- ROOTNODES_ID INTEGER NOT NULL,
- SORTINDEX INT NOT NULL
-);
--- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_TAXONNODE;
-CREATE CACHED TABLE PUBLIC.CLASSIFICATION_TAXONNODE_AUD(
- REV INTEGER NOT NULL,
- CLASSIFICATION_ID INTEGER NOT NULL,
- ROOTNODES_ID INTEGER NOT NULL,
- SORTINDEX INT NOT NULL,
- REVTYPE TINYINT
-);
--- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_TAXONNODE_AUD;
CREATE CACHED TABLE PUBLIC.COLLECTION(
ID INTEGER NOT NULL,
CREATED TIMESTAMP,
TIMEPERIOD_END VARCHAR(255),
TIMEPERIOD_FREETEXT VARCHAR(255),
ORDERRELEVANT BOOLEAN,
+ UNKNOWNDATA BOOLEAN,
CREATEDBY_ID INTEGER,
UPDATEDBY_ID INTEGER,
FEATURE_ID INTEGER,
TIMEPERIOD_END VARCHAR(255),
TIMEPERIOD_FREETEXT VARCHAR(255),
ORDERRELEVANT BOOLEAN,
+ UNKNOWNDATA BOOLEAN,
CREATEDBY_ID INTEGER,
UPDATEDBY_ID INTEGER,
FEATURE_ID INTEGER,
LSID_REVISION VARCHAR(255),
PROTECTEDTITLECACHE BOOLEAN NOT NULL,
TITLECACHE VARCHAR(255),
- URI CLOB,
CREATEDBY_ID INTEGER,
UPDATEDBY_ID INTEGER,
ROOT_ID INTEGER
LSID_REVISION VARCHAR(255),
PROTECTEDTITLECACHE BOOLEAN,
TITLECACHE VARCHAR(255),
- URI CLOB,
CREATEDBY_ID INTEGER,
UPDATEDBY_ID INTEGER,
ROOT_ID INTEGER
CATALOGNUMBER VARCHAR(255),
COLLECTORSNUMBER VARCHAR(255),
EXSICCATUM VARCHAR(255),
+ ORIGINALLABELINFO CLOB,
FIELDNOTES VARCHAR(255),
FIELDNUMBER VARCHAR(255),
CREATEDBY_ID INTEGER,
CATALOGNUMBER VARCHAR(255),
COLLECTORSNUMBER VARCHAR(255),
EXSICCATUM VARCHAR(255),
+ ORIGINALLABELINFO CLOB,
FIELDNOTES VARCHAR(255),
FIELDNUMBER VARCHAR(255),
CREATEDBY_ID INTEGER,
ALTER TABLE PUBLIC.ORIGINALSOURCEBASE_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXFF PRIMARY KEY(REV, ORIGINALSOURCEBASE_ID, ANNOTATIONS_ID);
ALTER TABLE PUBLIC.AGENTBASE_RIGHTSINFO ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXF1 PRIMARY KEY(AGENTBASE_ID, RIGHTS_ID);
ALTER TABLE PUBLIC.AGENTBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXE8 PRIMARY KEY(AGENTBASE_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.CLASSIFICATION_TAXONNODE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXD7 PRIMARY KEY(CLASSIFICATION_ID, ROOTNODES_ID);
+--ALTER TABLE PUBLIC.CLASSIFICATION_TAXONNODE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXD7 PRIMARY KEY(CLASSIFICATION_ID, ROOTNODES_ID);
ALTER TABLE PUBLIC.DETERMINATIONEVENT_REFERENCE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXD6 PRIMARY KEY(REV, DETERMINATIONEVENT_ID, SETOFREFERENCES_ID);
ALTER TABLE PUBLIC.DERIVATIONEVENT_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXD9 PRIMARY KEY(DERIVATIONEVENT_ID, MARKERS_ID);
ALTER TABLE PUBLIC.TAXONNAMEBASE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXFDC7 PRIMARY KEY(TAXONNAMEBASE_ID, EXTENSIONS_ID);
ALTER TABLE PUBLIC.WORKINGSET_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXEC9 PRIMARY KEY(WORKINGSET_ID, ANNOTATIONS_ID);
ALTER TABLE PUBLIC.TYPEDESIGNATIONBASE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX4F7 PRIMARY KEY(TYPEDESIGNATIONBASE_ID, ANNOTATIONS_ID);
ALTER TABLE PUBLIC.HYBRIDRELATIONSHIP_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXFB3 PRIMARY KEY(REV, HYBRIDRELATIONSHIP_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.CLASSIFICATION_TAXONNODE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX286 PRIMARY KEY(REV, CLASSIFICATION_ID, ROOTNODES_ID);
+--ALTER TABLE PUBLIC.CLASSIFICATION_TAXONNODE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX286 PRIMARY KEY(REV, CLASSIFICATION_ID, ROOTNODES_ID);
ALTER TABLE PUBLIC.FEATURETREE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB9F PRIMARY KEY(FEATURETREE_ID, EXTENSIONS_ID);
--ALTER TABLE PUBLIC.SEQUENCE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX9EB PRIMARY KEY(SEQUENCE_ID, ANNOTATIONS_ID);
ALTER TABLE PUBLIC.RIGHTSINFO_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX5DE PRIMARY KEY(RIGHTSINFO_ID, ANNOTATIONS_ID);
ALTER TABLE PUBLIC.POLYTOMOUSKEY_RIGHTSINFO ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX341F UNIQUE(RIGHTS_ID);
ALTER TABLE PUBLIC.DESCRIPTIONBASE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX63F UNIQUE(ANNOTATIONS_ID);
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXAE96 UNIQUE(MARKERS_ID);
-ALTER TABLE PUBLIC.CLASSIFICATION_TAXONNODE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXD7D UNIQUE(ROOTNODES_ID);
+--ALTER TABLE PUBLIC.CLASSIFICATION_TAXONNODE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXD7D UNIQUE(ROOTNODES_ID);
ALTER TABLE PUBLIC.HYBRIDRELATIONSHIP_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX2820 UNIQUE(ANNOTATIONS_ID);
ALTER TABLE PUBLIC.ANNOTATION_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXAE UNIQUE(ANNOTATIONS_ID);
ALTER TABLE PUBLIC.SEQUENCE_REFERENCE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX7620 UNIQUE(CITATIONS_ID);
ALTER TABLE PUBLIC.MEDIAREPRESENTATIONPART ADD CONSTRAINT PUBLIC.FK67A455444FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
ALTER TABLE PUBLIC.NAMERELATIONSHIP ADD CONSTRAINT PUBLIC.FK5E51083BC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
ALTER TABLE PUBLIC.POLYTOMOUSKEY_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.FK839208C43A6735D9 FOREIGN KEY(SOURCES_ID) REFERENCES PUBLIC.ORIGINALSOURCEBASE(ID) NOCHECK;
-ALTER TABLE PUBLIC.CLASSIFICATION_TAXONNODE ADD CONSTRAINT PUBLIC.FKB0BD86D318929176 FOREIGN KEY(ROOTNODES_ID) REFERENCES PUBLIC.TAXONNODE(ID) NOCHECK;
+--ALTER TABLE PUBLIC.CLASSIFICATION_TAXONNODE ADD CONSTRAINT PUBLIC.FKB0BD86D318929176 FOREIGN KEY(ROOTNODES_ID) REFERENCES PUBLIC.TAXONNODE(ID) NOCHECK;
ALTER TABLE PUBLIC.LANGUAGESTRING ADD CONSTRAINT PUBLIC.FKB5FDC9A94FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
ALTER TABLE PUBLIC.TAXONNAMEBASE_CREDIT ADD CONSTRAINT PUBLIC.FK29BCD8B232D1B9F FOREIGN KEY(CREDITS_ID) REFERENCES PUBLIC.CREDIT(ID) NOCHECK;
ALTER TABLE PUBLIC.POLYTOMOUSKEY ADD CONSTRAINT PUBLIC.FKA9E6B1384FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
ALTER TABLE PUBLIC.AGENTBASE_CONTACT_URLS ADD CONSTRAINT PUBLIC.FK9A9643EC86EFC5D4 FOREIGN KEY(AGENTBASE_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;
ALTER TABLE PUBLIC.FEATURETREE ADD CONSTRAINT PUBLIC.FK4CF19F94BC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
ALTER TABLE PUBLIC.PERMISSIONGROUP_GRANTEDAUTHORITYIMPL ADD CONSTRAINT PUBLIC.FK5311437CA0971A3 FOREIGN KEY(PERMISSIONGROUP_ID) REFERENCES PUBLIC.PERMISSIONGROUP(ID) NOCHECK;
-ALTER TABLE PUBLIC.CLASSIFICATION_TAXONNODE ADD CONSTRAINT PUBLIC.FKB0BD86D384A3CE1B FOREIGN KEY(CLASSIFICATION_ID) REFERENCES PUBLIC.CLASSIFICATION(ID) NOCHECK;
+--ALTER TABLE PUBLIC.CLASSIFICATION_TAXONNODE ADD CONSTRAINT PUBLIC.FKB0BD86D384A3CE1B FOREIGN KEY(CLASSIFICATION_ID) REFERENCES PUBLIC.CLASSIFICATION(ID) NOCHECK;
ALTER TABLE PUBLIC.TAXONNAMEBASE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.FKF746D2763A6735D9 FOREIGN KEY(SOURCES_ID) REFERENCES PUBLIC.ORIGINALSOURCEBASE(ID) NOCHECK;
ALTER TABLE PUBLIC.TAXONRELATIONSHIP ADD CONSTRAINT PUBLIC.FK7482BA02F8991B9D FOREIGN KEY(RELATEDTO_ID) REFERENCES PUBLIC.TAXONBASE(ID) NOCHECK;
ALTER TABLE PUBLIC.FEATURETREE_RIGHTSINFO ADD CONSTRAINT PUBLIC.FK8E50DD0247C496CB FOREIGN KEY(FEATURETREE_ID) REFERENCES PUBLIC.FEATURETREE(ID) NOCHECK;
ALTER TABLE PUBLIC.ANNOTATION_MARKER ADD CONSTRAINT PUBLIC.FKB17EAF4A994CCE20 FOREIGN KEY(ANNOTATION_ID) REFERENCES PUBLIC.ANNOTATION(ID) NOCHECK;
ALTER TABLE PUBLIC.COLLECTION_RIGHTSINFO_AUD ADD CONSTRAINT PUBLIC.FKF5A1106934869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
ALTER TABLE PUBLIC.CLASSIFICATION_EXTENSION ADD CONSTRAINT PUBLIC.FK715D672684A3CE1B FOREIGN KEY(CLASSIFICATION_ID) REFERENCES PUBLIC.CLASSIFICATION(ID) NOCHECK;
-ALTER TABLE PUBLIC.CLASSIFICATION_TAXONNODE_AUD ADD CONSTRAINT PUBLIC.FK7654132434869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
+--ALTER TABLE PUBLIC.CLASSIFICATION_TAXONNODE_AUD ADD CONSTRAINT PUBLIC.FK7654132434869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
ALTER TABLE PUBLIC.MARKER ADD CONSTRAINT PUBLIC.FK88F1805ABC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
ALTER TABLE PUBLIC.FEATURETREE_CREDIT ADD CONSTRAINT PUBLIC.FK7536062447C496CB FOREIGN KEY(FEATURETREE_ID) REFERENCES PUBLIC.FEATURETREE(ID) NOCHECK;
ALTER TABLE PUBLIC.FEATURETREE_ANNOTATION ADD CONSTRAINT PUBLIC.FK5D8B8DA1E403E0B FOREIGN KEY(ANNOTATIONS_ID) REFERENCES PUBLIC.ANNOTATION(ID) NOCHECK;