Revision 67a0eae3
Added by Cherian Mathew almost 9 years ago
| src/test/resources/dbscripts/001-cdm.h2.sql | ||
|---|---|---|
| 74 | 74 |
LIFESPAN_START VARCHAR(255), |
| 75 | 75 |
PREFIX VARCHAR(255), |
| 76 | 76 |
SUFFIX VARCHAR(255), |
| 77 |
HASMOREMEMBERS BOOLEAN, |
|
| 77 | 78 |
CREATEDBY_ID INTEGER, |
| 78 | 79 |
UPDATEDBY_ID INTEGER, |
| 79 | 80 |
ISPARTOF_ID INTEGER |
| ... | ... | |
| 95 | 96 |
LSID_REVISION VARCHAR(255), |
| 96 | 97 |
PROTECTEDTITLECACHE BOOLEAN, |
| 97 | 98 |
TITLECACHE VARCHAR(255), |
| 98 |
CREATEDBY_ID INTEGER, |
|
| 99 |
UPDATEDBY_ID INTEGER, |
|
| 100 |
PROTECTEDCOLLECTORTITLECACHE BOOLEAN NOT NULL, |
|
| 99 |
PROTECTEDCOLLECTORTITLECACHE BOOLEAN NOT NULL, |
|
| 101 | 100 |
COLLECTORTITLE VARCHAR(255), |
| 102 | 101 |
NOMENCLATURALTITLE VARCHAR(255), |
| 103 | 102 |
PROTECTEDNOMENCLATURALTITLECACHE BOOLEAN, |
| ... | ... | |
| 109 | 108 |
PREFIX VARCHAR(255), |
| 110 | 109 |
SUFFIX VARCHAR(255), |
| 111 | 110 |
CODE VARCHAR(255), |
| 112 |
NAME VARCHAR(255), |
|
| 113 |
ISPARTOF_ID INTEGER |
|
| 111 |
NAME VARCHAR(255), |
|
| 112 |
HASMOREMEMBERS BOOLEAN, |
|
| 113 |
CREATEDBY_ID INTEGER, |
|
| 114 |
UPDATEDBY_ID INTEGER, |
|
| 115 |
ISPARTOF_ID INTEGER, |
|
| 116 |
|
|
| 114 | 117 |
); |
| 115 | 118 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_AUD; |
| 116 | 119 |
CREATE CACHED TABLE PUBLIC.AGENTBASE_ADDRESS( |
| ... | ... | |
| 1583 | 1586 |
REVTYPE TINYINT |
| 1584 | 1587 |
); |
| 1585 | 1588 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_ORIGINALSOURCEBASE_AUD; |
| 1586 |
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA( |
|
| 1587 |
DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL, |
|
| 1588 |
STATEDATA_ID INTEGER NOT NULL |
|
| 1589 |
); |
|
| 1590 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA; |
|
| 1591 |
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA_AUD( |
|
| 1592 |
REV INTEGER NOT NULL, |
|
| 1593 |
DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL, |
|
| 1594 |
STATEDATA_ID INTEGER NOT NULL, |
|
| 1595 |
REVTYPE TINYINT |
|
| 1596 |
); |
|
| 1597 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA_AUD; |
|
| 1598 |
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE( |
|
| 1599 |
DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL, |
|
| 1600 |
STATISTICALVALUES_ID INTEGER NOT NULL |
|
| 1601 |
); |
|
| 1602 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE; |
|
| 1603 |
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE_AUD( |
|
| 1604 |
REV INTEGER NOT NULL, |
|
| 1605 |
DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL, |
|
| 1606 |
STATISTICALVALUES_ID INTEGER NOT NULL, |
|
| 1607 |
REVTYPE TINYINT |
|
| 1608 |
); |
|
| 1609 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE_AUD; |
|
| 1610 | 1589 |
CREATE CACHED TABLE PUBLIC.DETERMINATIONEVENT( |
| 1611 | 1590 |
ID INTEGER NOT NULL, |
| 1612 | 1591 |
CREATED TIMESTAMP, |
| ... | ... | |
| 3747 | 3726 |
EDITEDSEQUENCE CLOB, |
| 3748 | 3727 |
SHIFTS CLOB, |
| 3749 | 3728 |
REVERSECOMPLEMENT BIT, |
| 3729 |
FIRSTSEQPOSITION INTEGER, |
|
| 3730 |
LEFTCUTPOSITION INTEGER, |
|
| 3731 |
RIGHTCUTPOSITION INTEGER, |
|
| 3750 | 3732 |
CREATEDBY_ID INTEGER, |
| 3751 | 3733 |
UPDATEDBY_ID INTEGER, |
| 3752 | 3734 |
CONSENSUSALIGNMENT_ID INTEGER NOT NULL, |
| ... | ... | |
| 3764 | 3746 |
EDITEDSEQUENCE CLOB, |
| 3765 | 3747 |
SHIFTS CLOB, |
| 3766 | 3748 |
REVERSECOMPLEMENT BIT, |
| 3749 |
FIRSTSEQPOSITION INTEGER, |
|
| 3750 |
LEFTCUTPOSITION INTEGER, |
|
| 3751 |
RIGHTCUTPOSITION INTEGER, |
|
| 3767 | 3752 |
CREATEDBY_ID INTEGER, |
| 3768 | 3753 |
UPDATEDBY_ID INTEGER, |
| 3769 | 3754 |
CONSENSUSALIGNMENT_ID INTEGER NOT NULL, |
| ... | ... | |
| 4045 | 4030 |
UPDATED TIMESTAMP, |
| 4046 | 4031 |
CREATEDBY_ID INTEGER, |
| 4047 | 4032 |
UPDATEDBY_ID INTEGER, |
| 4033 |
CATEGORICALDATA_ID INTEGER, |
|
| 4048 | 4034 |
STATE_ID INTEGER |
| 4049 | 4035 |
); |
| 4050 | 4036 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATEDATA; |
| ... | ... | |
| 4057 | 4043 |
UPDATED TIMESTAMP, |
| 4058 | 4044 |
CREATEDBY_ID INTEGER, |
| 4059 | 4045 |
UPDATEDBY_ID INTEGER, |
| 4046 |
CATEGORICALDATA_ID INTEGER, |
|
| 4060 | 4047 |
STATE_ID INTEGER |
| 4061 | 4048 |
); |
| 4062 | 4049 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATEDATA_AUD; |
| ... | ... | |
| 4094 | 4081 |
VALUE DOUBLE NOT NULL, |
| 4095 | 4082 |
CREATEDBY_ID INTEGER, |
| 4096 | 4083 |
UPDATEDBY_ID INTEGER, |
| 4084 |
QUANTITATIVEDATA_ID INTEGER, |
|
| 4097 | 4085 |
TYPE_ID INTEGER |
| 4098 | 4086 |
); |
| 4099 | 4087 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATISTICALMEASUREMENTVALUE; |
| ... | ... | |
| 4107 | 4095 |
VALUE DOUBLE, |
| 4108 | 4096 |
CREATEDBY_ID INTEGER, |
| 4109 | 4097 |
UPDATEDBY_ID INTEGER, |
| 4098 |
QUANTITATIVEDATA_ID INTEGER, |
|
| 4110 | 4099 |
TYPE_ID INTEGER |
| 4111 | 4100 |
); |
| 4112 | 4101 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATISTICALMEASUREMENTVALUE_AUD; |
| ... | ... | |
| 4390 | 4379 |
HOMOTYPICALGROUP_ID INTEGER, |
| 4391 | 4380 |
NOMENCLATURALREFERENCE_ID INTEGER, |
| 4392 | 4381 |
RANK_ID INTEGER, |
| 4393 |
BASIONYMAUTHORTEAM_ID INTEGER,
|
|
| 4394 |
COMBINATIONAUTHORTEAM_ID INTEGER,
|
|
| 4395 |
EXBASIONYMAUTHORTEAM_ID INTEGER,
|
|
| 4396 |
EXCOMBINATIONAUTHORTEAM_ID INTEGER
|
|
| 4382 |
BASIONYMAUTHORSHIP_ID INTEGER,
|
|
| 4383 |
COMBINATIONAUTHORSHIP_ID INTEGER,
|
|
| 4384 |
EXBASIONYMAUTHORSHIP_ID INTEGER,
|
|
| 4385 |
EXCOMBINATIONAUTHORSHIP_ID INTEGER
|
|
| 4397 | 4386 |
); |
| 4398 | 4387 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE; |
| 4399 | 4388 |
CREATE INDEX PUBLIC.TAXONNAMEBASETITLECACHEINDEX ON PUBLIC.TAXONNAMEBASE(TITLECACHE); |
| ... | ... | |
| 4437 | 4426 |
PROTECTEDNAMECACHE BOOLEAN, |
| 4438 | 4427 |
SPECIFICEPITHET VARCHAR(255), |
| 4439 | 4428 |
TRINOMHYBRID BOOLEAN, |
| 4440 |
BASIONYMAUTHORTEAM_ID INTEGER,
|
|
| 4441 |
COMBINATIONAUTHORTEAM_ID INTEGER,
|
|
| 4442 |
EXBASIONYMAUTHORTEAM_ID INTEGER,
|
|
| 4443 |
EXCOMBINATIONAUTHORTEAM_ID INTEGER,
|
|
| 4429 |
BASIONYMAUTHORSHIP_ID INTEGER,
|
|
| 4430 |
COMBINATIONAUTHORSHIP_ID INTEGER,
|
|
| 4431 |
EXBASIONYMAUTHORSHIP_ID INTEGER,
|
|
| 4432 |
EXCOMBINATIONAUTHORSHIP_ID INTEGER,
|
|
| 4444 | 4433 |
ANAMORPHIC BOOLEAN, |
| 4445 | 4434 |
CULTIVARNAME VARCHAR(255), |
| 4446 | 4435 |
BREED VARCHAR(255), |
| ... | ... | |
| 4580 | 4569 |
TAXON_ID INTEGER |
| 4581 | 4570 |
); |
| 4582 | 4571 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNODE; |
| 4572 |
CREATE CACHED TABLE PUBLIC.TAXONNODEAGENTRELATION( |
|
| 4573 |
ID INTEGER NOT NULL, |
|
| 4574 |
CREATED TIMESTAMP, |
|
| 4575 |
UUID VARCHAR(36), |
|
| 4576 |
UPDATED TIMESTAMP, |
|
| 4577 |
CREATEDBY_ID INTEGER, |
|
| 4578 |
UPDATEDBY_ID INTEGER, |
|
| 4579 |
AGENT_ID INTEGER, |
|
| 4580 |
TAXONNODE_ID INTEGER, |
|
| 4581 |
TYPE_ID INTEGER |
|
| 4582 |
); |
|
| 4583 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNODEAGENTRELATION; |
|
| 4584 |
CREATE CACHED TABLE PUBLIC.TAXONNODEAGENTRELATION_AUD( |
|
| 4585 |
ID INTEGER NOT NULL, |
|
| 4586 |
REV INTEGER NOT NULL, |
|
| 4587 |
REVTYPE TINYINT, |
|
| 4588 |
CREATED TIMESTAMP, |
|
| 4589 |
UUID VARCHAR(36), |
|
| 4590 |
UPDATED TIMESTAMP, |
|
| 4591 |
CREATEDBY_ID INTEGER, |
|
| 4592 |
UPDATEDBY_ID INTEGER, |
|
| 4593 |
AGENT_ID INTEGER, |
|
| 4594 |
TAXONNODE_ID INTEGER, |
|
| 4595 |
TYPE_ID INTEGER |
|
| 4596 |
); |
|
| 4597 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNODEAGENTRELATION_AUD; |
|
| 4598 |
CREATE CACHED TABLE PUBLIC.TAXONNODEAGENTRELATION_ANNOTATION( |
|
| 4599 |
TAXONNODEAGENTRELATION_ID INTEGER NOT NULL, |
|
| 4600 |
ANNOTATIONS_ID INTEGER NOT NULL |
|
| 4601 |
); |
|
| 4602 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNODEAGENTRELATION_ANNOTATION; |
|
| 4603 |
CREATE CACHED TABLE PUBLIC.TAXONNODEAGENTRELATION_ANNOTATION_AUD( |
|
| 4604 |
REV INTEGER NOT NULL, |
|
| 4605 |
TAXONNODEAGENTRELATION_ID INTEGER NOT NULL, |
|
| 4606 |
ANNOTATIONS_ID INTEGER NOT NULL, |
|
| 4607 |
REVTYPE TINYINT |
|
| 4608 |
); |
|
| 4609 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNODEAGENTRELATION_ANNOTATION_AUD; |
|
| 4610 |
CREATE CACHED TABLE PUBLIC.TAXONNODEAGENTRELATION_MARKER( |
|
| 4611 |
TAXONNODEAGENTRELATION_ID INTEGER NOT NULL, |
|
| 4612 |
MARKERS_ID INTEGER NOT NULL |
|
| 4613 |
); |
|
| 4614 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNODEAGENTRELATION_MARKER; |
|
| 4615 |
CREATE CACHED TABLE PUBLIC.TAXONNODEAGENTRELATION_MARKER_AUD( |
|
| 4616 |
REV INTEGER NOT NULL, |
|
| 4617 |
TAXONNODEAGENTRELATION_ID INTEGER NOT NULL, |
|
| 4618 |
MARKERS_ID INTEGER NOT NULL, |
|
| 4619 |
REVTYPE TINYINT |
|
| 4620 |
); |
|
| 4621 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNODEAGENTRELATION_MARKER_AUD; |
|
| 4583 | 4622 |
CREATE CACHED TABLE PUBLIC.TAXONNODE_AUD( |
| 4584 | 4623 |
ID INTEGER NOT NULL, |
| 4585 | 4624 |
REV INTEGER NOT NULL, |
| ... | ... | |
| 5164 | 5203 |
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXAE9 PRIMARY KEY(DESCRIPTIONELEMENTBASE_ID, MARKERS_ID); |
| 5165 | 5204 |
ALTER TABLE PUBLIC.TYPEDESIGNATIONBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX8DC PRIMARY KEY(TYPEDESIGNATIONBASE_ID, MARKERS_ID); |
| 5166 | 5205 |
ALTER TABLE PUBLIC.USERACCOUNT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC4F0 PRIMARY KEY(ID); |
| 5167 |
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXAE8 PRIMARY KEY(REV, DESCRIPTIONELEMENTBASE_ID, STATISTICALVALUES_ID); |
|
| 5168 | 5206 |
ALTER TABLE PUBLIC.DEFINEDTERMBASE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXAE5 PRIMARY KEY(DEFINEDTERMBASE_ID, EXTENSIONS_ID); |
| 5169 | 5207 |
ALTER TABLE PUBLIC.SYNONYMRELATIONSHIP ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX539 PRIMARY KEY(ID); |
| 5170 | 5208 |
ALTER TABLE PUBLIC.GATHERINGEVENT_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX43D PRIMARY KEY(GATHERINGEVENT_ID, MARKERS_ID); |
| ... | ... | |
| 5355 | 5393 |
ALTER TABLE PUBLIC.MEDIA_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX87CF PRIMARY KEY(MEDIA_ID, ANNOTATIONS_ID); |
| 5356 | 5394 |
ALTER TABLE PUBLIC.CLASSIFICATION_RIGHTSINFO_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX8F PRIMARY KEY(REV, CLASSIFICATION_ID, RIGHTS_ID); |
| 5357 | 5395 |
ALTER TABLE PUBLIC.AGENTBASE_CONTACT_PHONENUMBERS_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX95 PRIMARY KEY(REV, AGENTBASE_ID, CONTACT_PHONENUMBERS_ELEMENT); |
| 5358 |
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX8D PRIMARY KEY(DESCRIPTIONELEMENTBASE_ID, STATISTICALVALUES_ID); |
|
| 5359 | 5396 |
ALTER TABLE PUBLIC.DEFINEDTERMBASE_RECOMMENDEDMODIFIERENUMERATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA5 PRIMARY KEY(REV, DEFINEDTERMBASE_ID, RECOMMENDEDMODIFIERENUMERATION_ID); |
| 5360 | 5397 |
ALTER TABLE PUBLIC.KEYSTATEMENT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA6 PRIMARY KEY(ID, REV); |
| 5361 | 5398 |
ALTER TABLE PUBLIC.TAXONNAMEBASE_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX698 PRIMARY KEY(REV, TAXONNAMEBASE_ID, MARKERS_ID); |
| ... | ... | |
| 5402 | 5439 |
ALTER TABLE PUBLIC.MEDIAREPRESENTATIONPART_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX48 PRIMARY KEY(ID, REV); |
| 5403 | 5440 |
ALTER TABLE PUBLIC.COLLECTION_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXBB PRIMARY KEY(COLLECTION_ID, EXTENSIONS_ID); |
| 5404 | 5441 |
ALTER TABLE PUBLIC.FEATURENODE_DEFINEDTERMBASE_INAPPLICABLEIF_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB3 PRIMARY KEY(REV, FEATURENODE_ID, INAPPLICABLEIF_ID); |
| 5405 |
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB0 PRIMARY KEY(REV, DESCRIPTIONELEMENTBASE_ID, STATEDATA_ID); |
|
| 5406 | 5442 |
ALTER TABLE PUBLIC.PERMISSIONGROUP_GRANTEDAUTHORITYIMPL ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB1 PRIMARY KEY(PERMISSIONGROUP_ID, GRANTEDAUTHORITIES_ID); |
| 5407 | 5443 |
ALTER TABLE PUBLIC.DEFINEDTERMBASE_STATISTICALMEASURE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB6 PRIMARY KEY(DEFINEDTERMBASE_ID, RECOMMENDEDSTATISTICALMEASURES_ID); |
| 5408 | 5444 |
ALTER TABLE PUBLIC.POLYTOMOUSKEY_SCOPE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB7 PRIMARY KEY(POLYTOMOUSKEY_ID, SCOPERESTRICTIONS_ID); |
| ... | ... | |
| 5689 | 5725 |
ALTER TABLE PUBLIC.TERMVOCABULARY_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC4D7 UNIQUE(ANNOTATIONS_ID); |
| 5690 | 5726 |
ALTER TABLE PUBLIC.FEATURETREE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB9F0 UNIQUE(EXTENSIONS_ID); |
| 5691 | 5727 |
ALTER TABLE PUBLIC.COLLECTION_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXCFB UNIQUE(ANNOTATIONS_ID); |
| 5692 |
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX8DF UNIQUE(STATISTICALVALUES_ID); |
|
| 5693 | 5728 |
ALTER TABLE PUBLIC.DESCRIPTIONBASE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXED4 UNIQUE(CREDITS_ID); |
| 5694 | 5729 |
ALTER TABLE PUBLIC.TAXONNAMEBASE_NOMENCLATURALSTATUS ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX7D78 UNIQUE(STATUS_ID); |
| 5695 | 5730 |
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_LANGUAGESTRING ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX5094 UNIQUE(MULTILANGUAGETEXT_ID); |
| ... | ... | |
| 5725 | 5760 |
ALTER TABLE PUBLIC.TAXONBASE_RIGHTSINFO ADD CONSTRAINT PUBLIC.FK65CF621B9C9D39 FOREIGN KEY(TAXONBASE_ID) REFERENCES PUBLIC.TAXONBASE(ID) NOCHECK; |
| 5726 | 5761 |
ALTER TABLE PUBLIC.MEDIA_MARKER ADD CONSTRAINT PUBLIC.FKD21E7935C2C29593 FOREIGN KEY(MEDIA_ID) REFERENCES PUBLIC.MEDIA(ID) NOCHECK; |
| 5727 | 5762 |
--ALTER TABLE PUBLIC.SEQUENCE_CREDIT_AUD ADD CONSTRAINT PUBLIC.FK4B22838834869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK; |
| 5728 |
ALTER TABLE PUBLIC.TAXONNAMEBASE ADD CONSTRAINT PUBLIC.FKB4870C67F90DF03 FOREIGN KEY(EXBASIONYMAUTHORTEAM_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK; |
|
| 5729 |
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA_AUD ADD CONSTRAINT PUBLIC.FK1D0A1EBE34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK; |
|
| 5763 |
ALTER TABLE PUBLIC.TAXONNAMEBASE ADD CONSTRAINT PUBLIC.FKB4870C67F90DF03 FOREIGN KEY(EXBASIONYMAUTHORSHIP_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK; |
|
| 5730 | 5764 |
ALTER TABLE PUBLIC.ORIGINALSOURCEBASE_MARKER ADD CONSTRAINT PUBLIC.FKB3FFDC7C777265A1 FOREIGN KEY(MARKERS_ID) REFERENCES PUBLIC.MARKER(ID) NOCHECK; |
| 5731 | 5765 |
--ALTER TABLE PUBLIC.SEQUENCE_EXTENSION ADD CONSTRAINT PUBLIC.FK7BE66D41927DE9DF FOREIGN KEY(EXTENSIONS_ID) REFERENCES PUBLIC.EXTENSION(ID) NOCHECK; |
| 5732 | 5766 |
ALTER TABLE PUBLIC.MEDIA_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.FK99ABA37B34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK; |
| ... | ... | |
| 5906 | 5940 |
ALTER TABLE PUBLIC.SYNONYMRELATIONSHIP_MARKER ADD CONSTRAINT PUBLIC.FK7A439066777265A1 FOREIGN KEY(MARKERS_ID) REFERENCES PUBLIC.MARKER(ID) NOCHECK; |
| 5907 | 5941 |
ALTER TABLE PUBLIC.WORKINGSET_MARKER ADD CONSTRAINT PUBLIC.FK9CB22CC8777265A1 FOREIGN KEY(MARKERS_ID) REFERENCES PUBLIC.MARKER(ID) NOCHECK; |
| 5908 | 5942 |
--ALTER TABLE PUBLIC.SEQUENCE_MEDIA_AUD ADD CONSTRAINT PUBLIC.FK20025CB734869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK; |
| 5909 |
ALTER TABLE PUBLIC.TAXONNAMEBASE ADD CONSTRAINT PUBLIC.FKB4870C662AD57A2 FOREIGN KEY(EXCOMBINATIONAUTHORTEAM_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;
|
|
| 5943 |
ALTER TABLE PUBLIC.TAXONNAMEBASE ADD CONSTRAINT PUBLIC.FKB4870C662AD57A2 FOREIGN KEY(EXCOMBINATIONAUTHORSHIP_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;
|
|
| 5910 | 5944 |
ALTER TABLE PUBLIC.DEFINEDTERMBASE_RIGHTSINFO ADD CONSTRAINT PUBLIC.FK921A01F0C13F7B21 FOREIGN KEY(RIGHTS_ID) REFERENCES PUBLIC.RIGHTSINFO(ID) NOCHECK; |
| 5911 |
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA ADD CONSTRAINT PUBLIC.FK592D6F6D15153604 FOREIGN KEY(STATEDATA_ID) REFERENCES PUBLIC.STATEDATA(ID) NOCHECK; |
|
| 5912 | 5945 |
ALTER TABLE PUBLIC.INDIVIDUALASSOCIATION_LANGUAGESTRING ADD CONSTRAINT PUBLIC.FKB5C75EC02BEBA58D FOREIGN KEY(DESCRIPTION_ID) REFERENCES PUBLIC.LANGUAGESTRING(ID) NOCHECK; |
| 5913 | 5946 |
ALTER TABLE PUBLIC.CLASSIFICATION ADD CONSTRAINT PUBLIC.FKDB110006BC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK; |
| 5914 | 5947 |
ALTER TABLE PUBLIC.DEFINEDTERMBASE_CREDIT ADD CONSTRAINT PUBLIC.FK78FF2B1232D1B9F FOREIGN KEY(CREDITS_ID) REFERENCES PUBLIC.CREDIT(ID) NOCHECK; |
| ... | ... | |
| 5930 | 5963 |
ALTER TABLE PUBLIC.CLASSIFICATION_MARKER ADD CONSTRAINT PUBLIC.FK59778AB3777265A1 FOREIGN KEY(MARKERS_ID) REFERENCES PUBLIC.MARKER(ID) NOCHECK; |
| 5931 | 5964 |
ALTER TABLE PUBLIC.GATHERINGEVENT_ANNOTATION ADD CONSTRAINT PUBLIC.FK76DDD01B1E403E0B FOREIGN KEY(ANNOTATIONS_ID) REFERENCES PUBLIC.ANNOTATION(ID) NOCHECK; |
| 5932 | 5965 |
ALTER TABLE PUBLIC.INSTITUTIONALMEMBERSHIP ADD CONSTRAINT PUBLIC.FK3C8E1FF916B9CA77 FOREIGN KEY(INSTITUTE_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK; |
| 5933 |
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE_AUD ADD CONSTRAINT PUBLIC.FK2DE8E9334869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK; |
|
| 5934 | 5966 |
ALTER TABLE PUBLIC.LANGUAGESTRING_MARKER_AUD ADD CONSTRAINT PUBLIC.FK2331098134869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK; |
| 5935 | 5967 |
ALTER TABLE PUBLIC.REFERENCE_MARKER ADD CONSTRAINT PUBLIC.FK6BEDC7EE8D0FB4DA FOREIGN KEY(REFERENCE_ID) REFERENCES PUBLIC.REFERENCE(ID) NOCHECK; |
| 5936 | 5968 |
ALTER TABLE PUBLIC.TERMVOCABULARY_AUD ADD CONSTRAINT PUBLIC.FKA6ED3B6334869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK; |
| ... | ... | |
| 6029 | 6061 |
ALTER TABLE PUBLIC.MEDIAREPRESENTATION ADD CONSTRAINT PUBLIC.FK1966BDB14FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK; |
| 6030 | 6062 |
ALTER TABLE PUBLIC.DEFINEDTERMBASE_EXTENSION_AUD ADD CONSTRAINT PUBLIC.FK6E6F45734869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK; |
| 6031 | 6063 |
ALTER TABLE PUBLIC.DEFINEDTERMBASE_STATISTICALMEASURE ADD CONSTRAINT PUBLIC.FK6FF15DFCC9CD5B57 FOREIGN KEY(RECOMMENDEDSTATISTICALMEASURES_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK; |
| 6032 |
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA ADD CONSTRAINT PUBLIC.FK592D6F6D987CC6A4 FOREIGN KEY(DESCRIPTIONELEMENTBASE_ID) REFERENCES PUBLIC.DESCRIPTIONELEMENTBASE(ID) NOCHECK; |
|
| 6033 | 6064 |
ALTER TABLE PUBLIC.USERACCOUNT_PERMISSIONGROUP ADD CONSTRAINT PUBLIC.FK812DE753DA9DCB5F FOREIGN KEY(GROUPS_ID) REFERENCES PUBLIC.PERMISSIONGROUP(ID) NOCHECK; |
| 6034 | 6065 |
--ALTER TABLE PUBLIC.SEQUENCE_RIGHTSINFO ADD CONSTRAINT PUBLIC.FK4616A015D57FFDD5 FOREIGN KEY(SEQUENCE_ID) REFERENCES PUBLIC.SEQUENCE(ID) NOCHECK; |
| 6035 | 6066 |
ALTER TABLE PUBLIC.MEDIA_LANGUAGESTRING ADD CONSTRAINT PUBLIC.FK353DB784C2C29593 FOREIGN KEY(MEDIA_ID) REFERENCES PUBLIC.MEDIA(ID) NOCHECK; |
| ... | ... | |
| 6067 | 6098 |
ALTER TABLE PUBLIC.TAXONNAMEBASE_TYPEDESIGNATIONBASE ADD CONSTRAINT PUBLIC.FKC0D6BBB5C7DF530C FOREIGN KEY(TYPEDESIGNATIONS_ID) REFERENCES PUBLIC.TYPEDESIGNATIONBASE(ID) NOCHECK; |
| 6068 | 6099 |
ALTER TABLE PUBLIC.POLYTOMOUSKEYNODE ADD CONSTRAINT PUBLIC.FK860775A808998FB FOREIGN KEY(PARENT_ID) REFERENCES PUBLIC.POLYTOMOUSKEYNODE(ID) NOCHECK; |
| 6069 | 6100 |
ALTER TABLE PUBLIC.ANNOTATION ADD CONSTRAINT PUBLIC.FK1A21C74F4FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK; |
| 6070 |
ALTER TABLE PUBLIC.TAXONNAMEBASE ADD CONSTRAINT PUBLIC.FKB4870C6B14B73EF FOREIGN KEY(COMBINATIONAUTHORTEAM_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;
|
|
| 6101 |
ALTER TABLE PUBLIC.TAXONNAMEBASE ADD CONSTRAINT PUBLIC.FKB4870C6B14B73EF FOREIGN KEY(COMBINATIONAUTHORSHIP_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;
|
|
| 6071 | 6102 |
ALTER TABLE PUBLIC.NAMERELATIONSHIP_MARKER_AUD ADD CONSTRAINT PUBLIC.FKCD68D66734869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK; |
| 6072 | 6103 |
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE ADD CONSTRAINT PUBLIC.FK38FE7671BC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK; |
| 6073 | 6104 |
ALTER TABLE PUBLIC.INSTITUTIONALMEMBERSHIP ADD CONSTRAINT PUBLIC.FK3C8E1FF9BC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK; |
| ... | ... | |
| 6136 | 6167 |
ALTER TABLE PUBLIC.USERACCOUNT_GRANTEDAUTHORITYIMPL ADD CONSTRAINT PUBLIC.FKFD724D851857F6C2 FOREIGN KEY(GRANTEDAUTHORITIES_ID) REFERENCES PUBLIC.GRANTEDAUTHORITYIMPL(ID) NOCHECK; |
| 6137 | 6168 |
ALTER TABLE PUBLIC.LANGUAGESTRING_MARKER ADD CONSTRAINT PUBLIC.FK8DA633B0777265A1 FOREIGN KEY(MARKERS_ID) REFERENCES PUBLIC.MARKER(ID) NOCHECK; |
| 6138 | 6169 |
ALTER TABLE PUBLIC.GATHERINGEVENT_MARKER_AUD ADD CONSTRAINT PUBLIC.FK160DF9F734869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK; |
| 6139 |
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE ADD CONSTRAINT PUBLIC.FK8AF511C2D883945E FOREIGN KEY(STATISTICALVALUES_ID) REFERENCES PUBLIC.STATISTICALMEASUREMENTVALUE(ID) NOCHECK; |
|
| 6140 | 6170 |
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_MARKER ADD CONSTRAINT PUBLIC.FK8E6106C73B8A5ABA FOREIGN KEY(SPECIMENOROBSERVATIONBASE_ID) REFERENCES PUBLIC.SPECIMENOROBSERVATIONBASE(ID) NOCHECK; |
| 6141 | 6171 |
ALTER TABLE PUBLIC.AGENTBASE_ANNOTATION ADD CONSTRAINT PUBLIC.FK44D5F7D81E403E0B FOREIGN KEY(ANNOTATIONS_ID) REFERENCES PUBLIC.ANNOTATION(ID) NOCHECK; |
| 6142 | 6172 |
ALTER TABLE PUBLIC.TAXONNAMEBASE_MARKER ADD CONSTRAINT PUBLIC.FK39E3C1F38C85CF94 FOREIGN KEY(TAXONNAMEBASE_ID) REFERENCES PUBLIC.TAXONNAMEBASE(ID) NOCHECK; |
| ... | ... | |
| 6450 | 6480 |
ALTER TABLE PUBLIC.REPRESENTATION_AUD ADD CONSTRAINT PUBLIC.FK294D143E34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK; |
| 6451 | 6481 |
ALTER TABLE PUBLIC.USERACCOUNT ADD CONSTRAINT PUBLIC.FKB3F13C24FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK; |
| 6452 | 6482 |
ALTER TABLE PUBLIC.TAXONNAMEBASE_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.FK7A38D54734869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK; |
| 6453 |
ALTER TABLE PUBLIC.TAXONNAMEBASE ADD CONSTRAINT PUBLIC.FKB4870C62B4FEDD6 FOREIGN KEY(BASIONYMAUTHORTEAM_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;
|
|
| 6483 |
ALTER TABLE PUBLIC.TAXONNAMEBASE ADD CONSTRAINT PUBLIC.FKB4870C62B4FEDD6 FOREIGN KEY(BASIONYMAUTHORSHIP_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;
|
|
| 6454 | 6484 |
ALTER TABLE PUBLIC.TAXONNAMEBASE ADD CONSTRAINT PUBLIC.FKB4870C6D7BE55A0 FOREIGN KEY(RANK_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK; |
| 6455 | 6485 |
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_CREDIT ADD CONSTRAINT PUBLIC.FK7E3A1D863B8A5ABA FOREIGN KEY(SPECIMENOROBSERVATIONBASE_ID) REFERENCES PUBLIC.SPECIMENOROBSERVATIONBASE(ID) NOCHECK; |
| 6456 | 6486 |
ALTER TABLE PUBLIC.ADDRESS_AUD ADD CONSTRAINT PUBLIC.FK115657A534869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK; |
| ... | ... | |
| 6502 | 6532 |
ALTER TABLE PUBLIC.DETERMINATIONEVENT_REFERENCE ADD CONSTRAINT PUBLIC.FK8FB1ED836BE0BFDA FOREIGN KEY(DETERMINATIONEVENT_ID) REFERENCES PUBLIC.DETERMINATIONEVENT(ID) NOCHECK; |
| 6503 | 6533 |
ALTER TABLE PUBLIC.CDM_VIEW_CDM_VIEW ADD CONSTRAINT PUBLIC.FK230A885F7208BB38 FOREIGN KEY(SUPERVIEWS_ID) REFERENCES PUBLIC.CDM_VIEW(ID) NOCHECK; |
| 6504 | 6534 |
ALTER TABLE PUBLIC.MEDIAREPRESENTATIONPART_AUD ADD CONSTRAINT PUBLIC.FKA75C411534869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK; |
| 6505 |
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE ADD CONSTRAINT PUBLIC.FK8AF511C28F213219 FOREIGN KEY(DESCRIPTIONELEMENTBASE_ID) REFERENCES PUBLIC.DESCRIPTIONELEMENTBASE(ID) NOCHECK; |
|
| 6506 | 6535 |
ALTER TABLE PUBLIC.GATHERINGEVENT_DEFINEDTERMBASE ADD CONSTRAINT PUBLIC.FK69D9A11AF95F225A FOREIGN KEY(GATHERINGEVENT_ID) REFERENCES PUBLIC.GATHERINGEVENT(ID) NOCHECK; |
| 6507 | 6536 |
ALTER TABLE PUBLIC.DEFINEDTERMBASE_RECOMMENDEDMODIFIERENUMERATION ADD CONSTRAINT PUBLIC.FKA72FB5AED0BDAE9B FOREIGN KEY(DEFINEDTERMBASE_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK; |
| 6508 | 6537 |
ALTER TABLE PUBLIC.DETERMINATIONEVENT ADD CONSTRAINT PUBLIC.FK1DB2497AEC8CCAA FOREIGN KEY(TAXON_ID) REFERENCES PUBLIC.TAXONBASE(ID) NOCHECK; |
Also available in: Unified diff
merged from master