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