Revision ac5bdc06
Added by Andreas Müller almost 7 years ago
| cdmlib-test/src/main/resources/dbscripts/001-cdm.h2.sql | ||
|---|---|---|
| 3633 | 3633 |
); |
| 3634 | 3634 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REGISTRATION_TYPEDESIGNATIONBASE_AUD; |
| 3635 | 3635 |
|
| 3636 |
CREATE CACHED TABLE PUBLIC.RELATIONSHIPTERMBASE_INVERSEREPRESENTATION(
|
|
| 3637 |
RELATIONSHIPTERMBASE_ID INTEGER NOT NULL,
|
|
| 3636 |
CREATE CACHED TABLE PUBLIC.TERMBASE_INVERSEREPRESENTATION( |
|
| 3637 |
TERM_ID INTEGER NOT NULL,
|
|
| 3638 | 3638 |
INVERSEREPRESENTATIONS_ID INTEGER NOT NULL |
| 3639 | 3639 |
); |
| 3640 |
-- 54 +/- SELECT COUNT(*) FROM PUBLIC.RELATIONSHIPTERMBASE_INVERSEREPRESENTATION;
|
|
| 3641 |
CREATE CACHED TABLE PUBLIC.RELATIONSHIPTERMBASE_INVERSEREPRESENTATION_AUD(
|
|
| 3640 |
-- 54 +/- SELECT COUNT(*) FROM PUBLIC.TERMBASE_INVERSEREPRESENTATION; |
|
| 3641 |
CREATE CACHED TABLE PUBLIC.TERMBASE_INVERSEREPRESENTATION_AUD( |
|
| 3642 | 3642 |
REV INTEGER NOT NULL, |
| 3643 |
RELATIONSHIPTERMBASE_ID INTEGER NOT NULL,
|
|
| 3643 |
TERM_ID INTEGER NOT NULL,
|
|
| 3644 | 3644 |
INVERSEREPRESENTATIONS_ID INTEGER NOT NULL, |
| 3645 | 3645 |
REVTYPE TINYINT |
| 3646 | 3646 |
); |
| 3647 |
-- 54 +/- SELECT COUNT(*) FROM PUBLIC.RELATIONSHIPTERMBASE_INVERSEREPRESENTATION_AUD;
|
|
| 3647 |
-- 54 +/- SELECT COUNT(*) FROM PUBLIC.TERMBASE_INVERSEREPRESENTATION_AUD; |
|
| 3648 | 3648 |
CREATE CACHED TABLE PUBLIC.REPRESENTATION( |
| 3649 | 3649 |
ID INTEGER NOT NULL, |
| 3650 | 3650 |
CREATED TIMESTAMP, |
| ... | ... | |
| 5429 | 5429 |
ALTER TABLE PUBLIC.FEATURETREE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB9F PRIMARY KEY(FEATURETREE_ID, EXTENSIONS_ID); |
| 5430 | 5430 |
--ALTER TABLE PUBLIC.SEQUENCE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX9EB PRIMARY KEY(SEQUENCE_ID, ANNOTATIONS_ID); |
| 5431 | 5431 |
ALTER TABLE PUBLIC.RIGHTSINFO_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX5DE PRIMARY KEY(RIGHTS_ID, ANNOTATIONS_ID); |
| 5432 |
ALTER TABLE PUBLIC.RELATIONSHIPTERMBASE_INVERSEREPRESENTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA96 PRIMARY KEY(RELATIONSHIPTERMBASE_ID, INVERSEREPRESENTATIONS_ID);
|
|
| 5432 |
ALTER TABLE PUBLIC.TERMBASE_INVERSEREPRESENTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA96 PRIMARY KEY(TERM_ID, INVERSEREPRESENTATIONS_ID);
|
|
| 5433 | 5433 |
ALTER TABLE PUBLIC.MEDIA_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA7B PRIMARY KEY(REV, MEDIA_ID, MARKERS_ID); |
| 5434 | 5434 |
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA7D PRIMARY KEY(REV, SPECIMENOROBSERVATIONBASE_ID, ANNOTATIONS_ID); |
| 5435 | 5435 |
ALTER TABLE PUBLIC.TAXONNAME_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXEB6 PRIMARY KEY(TAXONNAME_ID, SOURCES_ID); |
| ... | ... | |
| 5569 | 5569 |
ALTER TABLE PUBLIC.MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX871 PRIMARY KEY(ID); |
| 5570 | 5570 |
ALTER TABLE PUBLIC.GATHERINGEVENT_DEFINEDTERMBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXCC8 PRIMARY KEY(GATHERINGEVENT_ID, COLLECTINGAREAS_ID); |
| 5571 | 5571 |
ALTER TABLE PUBLIC.REFERENCE_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC1 PRIMARY KEY(REV, REFERENCE_ID, SOURCES_ID); |
| 5572 |
ALTER TABLE PUBLIC.RELATIONSHIPTERMBASE_INVERSEREPRESENTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX51 PRIMARY KEY(REV, RELATIONSHIPTERMBASE_ID, INVERSEREPRESENTATIONS_ID);
|
|
| 5572 |
ALTER TABLE PUBLIC.TERMBASE_INVERSEREPRESENTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX51 PRIMARY KEY(REV, TERM_ID, INVERSEREPRESENTATIONS_ID);
|
|
| 5573 | 5573 |
ALTER TABLE PUBLIC.AGENTBASE_ADDRESS_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXCE45 PRIMARY KEY(REV, AGENTBASE_ID, CONTACT_ADDRESSES_ID); |
| 5574 | 5574 |
ALTER TABLE PUBLIC.PERMISSIONGROUP ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXE26 PRIMARY KEY(ID); |
| 5575 | 5575 |
ALTER TABLE PUBLIC.FEATURETREE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX93 PRIMARY KEY(FEATURETREE_ID, ANNOTATIONS_ID); |
| ... | ... | |
| 5765 | 5765 |
ALTER TABLE PUBLIC.HOMOTYPICALGROUP ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC247 UNIQUE(UUID); |
| 5766 | 5766 |
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX688 UNIQUE(SOURCES_ID); |
| 5767 | 5767 |
ALTER TABLE PUBLIC.AGENTBASE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX75 UNIQUE(SOURCES_ID); |
| 5768 |
ALTER TABLE PUBLIC.RELATIONSHIPTERMBASE_INVERSEREPRESENTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA961 UNIQUE(INVERSEREPRESENTATIONS_ID);
|
|
| 5768 |
ALTER TABLE PUBLIC.TERMBASE_INVERSEREPRESENTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA961 UNIQUE(INVERSEREPRESENTATIONS_ID); |
|
| 5769 | 5769 |
ALTER TABLE PUBLIC.USERACCOUNT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC4F06 UNIQUE(UUID, USERNAME); |
| 5770 | 5770 |
ALTER TABLE PUBLIC.ADDRESS ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXE6 UNIQUE(UUID); |
| 5771 | 5771 |
ALTER TABLE PUBLIC.REFERENCE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXE924 UNIQUE(ANNOTATIONS_ID); |
| ... | ... | |
| 6151 | 6151 |
ALTER TABLE PUBLIC.TAXONNODE ADD CONSTRAINT PUBLIC.FK924F5BCC4FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK; |
| 6152 | 6152 |
ALTER TABLE PUBLIC.DEFINEDTERMBASE_MARKER_AUD ADD CONSTRAINT PUBLIC.FKA4B9E0A434869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK; |
| 6153 | 6153 |
ALTER TABLE PUBLIC.CLASSIFICATION ADD CONSTRAINT PUBLIC.FKDB1100064FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK; |
| 6154 |
ALTER TABLE PUBLIC.RELATIONSHIPTERMBASE_INVERSEREPRESENTATION_AUD ADD CONSTRAINT PUBLIC.FK5D248B8434869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
|
|
| 6154 |
ALTER TABLE PUBLIC.TERMBASE_INVERSEREPRESENTATION_AUD ADD CONSTRAINT PUBLIC.FK5D248B8434869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK; |
|
| 6155 | 6155 |
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_MARKER_AUD ADD CONSTRAINT PUBLIC.FKD58E791834869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK; |
| 6156 | 6156 |
ALTER TABLE PUBLIC.DEFINEDTERMBASE_CONTINENT ADD CONSTRAINT PUBLIC.FK45F60AFB3927C853 FOREIGN KEY(CONTINENTS_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK; |
| 6157 | 6157 |
ALTER TABLE PUBLIC.MEDIA_REPRESENTATION ADD CONSTRAINT PUBLIC.FK1B8712C8BE59D760 FOREIGN KEY(MEDIAKEY_ID) REFERENCES PUBLIC.MEDIA(ID) NOCHECK; |
| ... | ... | |
| 6360 | 6360 |
ALTER TABLE PUBLIC.MEDIAKEY_SCOPE_AUD ADD CONSTRAINT PUBLIC.FK63AD1EC134869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK; |
| 6361 | 6361 |
ALTER TABLE PUBLIC.COLLECTION_ANNOTATION ADD CONSTRAINT PUBLIC.FKEA970F70EB62BE9A FOREIGN KEY(COLLECTION_ID) REFERENCES PUBLIC.COLLECTION(ID) NOCHECK; |
| 6362 | 6362 |
ALTER TABLE PUBLIC.DETERMINATIONEVENT_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.FKAFDA5E4834869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK; |
| 6363 |
ALTER TABLE PUBLIC.RELATIONSHIPTERMBASE_INVERSEREPRESENTATION ADD CONSTRAINT PUBLIC.FK98592F33473FB677 FOREIGN KEY(INVERSEREPRESENTATIONS_ID) REFERENCES PUBLIC.REPRESENTATION(ID) NOCHECK;
|
|
| 6363 |
ALTER TABLE PUBLIC.TERMBASE_INVERSEREPRESENTATION ADD CONSTRAINT PUBLIC.FK98592F33473FB677 FOREIGN KEY(INVERSEREPRESENTATIONS_ID) REFERENCES PUBLIC.REPRESENTATION(ID) NOCHECK; |
|
| 6364 | 6364 |
ALTER TABLE PUBLIC.RIGHTSINFO_MARKER ADD CONSTRAINT PUBLIC.FKB739BBA2777265A1 FOREIGN KEY(MARKERS_ID) REFERENCES PUBLIC.MARKER(ID) NOCHECK; |
| 6365 | 6365 |
ALTER TABLE PUBLIC.TYPEDESIGNATIONBASE ADD CONSTRAINT PUBLIC.FK8AC9DCAEAEB7F3BE FOREIGN KEY(CITATION_ID) REFERENCES PUBLIC.REFERENCE(ID) NOCHECK; |
| 6366 | 6366 |
ALTER TABLE PUBLIC.FEATURETREE ADD CONSTRAINT PUBLIC.FK4CF19F944FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK; |
| ... | ... | |
| 6428 | 6428 |
ALTER TABLE PUBLIC.MARKER_AUD ADD CONSTRAINT PUBLIC.FKB951F12B34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK; |
| 6429 | 6429 |
ALTER TABLE PUBLIC.TAXONNODE_MARKER ADD CONSTRAINT PUBLIC.FK395842D777265A1 FOREIGN KEY(MARKERS_ID) REFERENCES PUBLIC.MARKER(ID) NOCHECK; |
| 6430 | 6430 |
ALTER TABLE PUBLIC.STATISTICALMEASUREMENTVALUE ADD CONSTRAINT PUBLIC.FK2DCE02904FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK; |
| 6431 |
ALTER TABLE PUBLIC.RELATIONSHIPTERMBASE_INVERSEREPRESENTATION ADD CONSTRAINT PUBLIC.FK98592F33ECEEF4AF FOREIGN KEY(RELATIONSHIPTERMBASE_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
|
|
| 6431 |
ALTER TABLE PUBLIC.TERMBASE_INVERSEREPRESENTATION ADD CONSTRAINT PUBLIC.FK98592F33ECEEF4AF FOREIGN KEY(TERM_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
|
|
| 6432 | 6432 |
ALTER TABLE PUBLIC.DESCRIPTIONBASE_RIGHTSINFO ADD CONSTRAINT PUBLIC.FK6A2601A9F1DDBFAB FOREIGN KEY(DESCRIPTIONBASE_ID) REFERENCES PUBLIC.DESCRIPTIONBASE(ID) NOCHECK; |
| 6433 | 6433 |
ALTER TABLE PUBLIC.REPRESENTATION ADD CONSTRAINT PUBLIC.FK9C4724EDE8D36B00 FOREIGN KEY(LANGUAGE_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK; |
| 6434 | 6434 |
ALTER TABLE PUBLIC.TAXONRELATIONSHIP ADD CONSTRAINT PUBLIC.FK7482BA02E71EF6CE FOREIGN KEY(RELATEDFROM_ID) REFERENCES PUBLIC.TAXONBASE(ID) NOCHECK; |
Also available in: Unified diff
ref #5817 update test data for rename RelationshipTermBase_inverseRepresentation