Revision 65df455c
Added by Alexander Oppermann over 9 years ago
| src/test/resources/dbscripts/001-cdm.h2.sql | ||
|---|---|---|
| 309 | 309 |
GELCONCENTRATION DOUBLE, |
| 310 | 310 |
GELRUNNINGTIME DOUBLE, |
| 311 | 311 |
LADDERUSED VARCHAR(255), |
| 312 |
SUCCESSTEXT VARCHAR(255), |
|
| 313 |
SUCCESSFUL BOOLEAN, |
|
| 312 |
LABELCACHE VARCHAR(255), |
|
| 314 | 313 |
CREATEDBY_ID INTEGER, |
| 315 | 314 |
UPDATEDBY_ID INTEGER, |
| 316 | 315 |
ACTOR_ID INTEGER, |
| 317 |
CLONING_ID INTEGER, |
|
| 318 |
DNASAMPLE_ID INTEGER, |
|
| 319 | 316 |
FORWARDPRIMER_ID INTEGER, |
| 320 | 317 |
DNAMARKER_ID INTEGER, |
| 321 | 318 |
PURIFICATION_ID INTEGER, |
| 322 |
REVERSEPRIMER_ID INTEGER,
|
|
| 323 |
GELPHOTO_ID INTEGER,
|
|
| 319 |
INSTITUTION_ID INTEGER,
|
|
| 320 |
REVERSEPRIMER_ID INTEGER,
|
|
| 324 | 321 |
PRIMARY KEY (ID) |
| 325 | 322 |
); |
| 326 | 323 |
|
| ... | ... | |
| 339 | 336 |
GELCONCENTRATION DOUBLE, |
| 340 | 337 |
GELRUNNINGTIME DOUBLE, |
| 341 | 338 |
LADDERUSED VARCHAR(255), |
| 342 |
SUCCESSTEXT VARCHAR(255), |
|
| 343 |
SUCCESSFUL BOOLEAN, |
|
| 339 |
LABELCACHE VARCHAR(255), |
|
| 344 | 340 |
CREATEDBY_ID INTEGER, |
| 345 | 341 |
UPDATEDBY_ID INTEGER, |
| 346 | 342 |
ACTOR_ID INTEGER, |
| 347 |
CLONING_ID INTEGER, |
|
| 348 |
DNASAMPLE_ID INTEGER, |
|
| 349 | 343 |
FORWARDPRIMER_ID INTEGER, |
| 350 | 344 |
DNAMARKER_ID INTEGER, |
| 351 | 345 |
PURIFICATION_ID INTEGER, |
| 352 |
REVERSEPRIMER_ID INTEGER,
|
|
| 353 |
GELPHOTO_ID INTEGER,
|
|
| 346 |
INSTITUTION_ID INTEGER,
|
|
| 347 |
REVERSEPRIMER_ID INTEGER,
|
|
| 354 | 348 |
PRIMARY KEY (ID) |
| 355 | 349 |
); |
| 356 | 350 |
|
| ... | ... | |
| 380 | 374 |
MARKERS_ID INTEGER NOT NULL, |
| 381 | 375 |
); |
| 382 | 376 |
|
| 383 |
CREATE TABLE AMPLIFICATION_SINGLEREAD ( |
|
| 384 |
AMPLIFICATION_ID INTEGER NOT NULL, |
|
| 385 |
SINGLEREADS_ID INTEGER NOT NULL, |
|
| 386 |
PRIMARY KEY (AMPLIFICATION_ID, SINGLEREADS_ID) |
|
| 377 |
CREATE TABLE AMPLIFICATIONRESULT ( |
|
| 378 |
ID INTEGER NOT NULL, |
|
| 379 |
CREATED TIMESTAMP, |
|
| 380 |
UUID VARCHAR(36), |
|
| 381 |
UPDATED TIMESTAMP, |
|
| 382 |
SUCCESSTEXT VARCHAR(255), |
|
| 383 |
SUCCESSFUL BOOLEAN, |
|
| 384 |
CREATEDBY_ID INTEGER, |
|
| 385 |
UPDATEDBY_ID INTEGER, |
|
| 386 |
CLONING_ID INTEGER, |
|
| 387 |
DNASAMPLE_ID INTEGER, |
|
| 388 |
AMPLIFICATION_ID INTEGER, |
|
| 389 |
GELPHOTO_ID INTEGER, |
|
| 390 |
PRIMARY KEY (ID) |
|
| 391 |
); |
|
| 392 |
|
|
| 393 |
CREATE TABLE AMPLIFICATIONRESULT_AUD ( |
|
| 394 |
ID INTEGER NOT NULL, |
|
| 395 |
REV INTEGER NOT NULL, |
|
| 396 |
REVTYPE TINYINT, |
|
| 397 |
CREATED TIMESTAMP, |
|
| 398 |
UUID VARCHAR(36), |
|
| 399 |
UPDATED TIMESTAMP, |
|
| 400 |
SUCCESSTEXT VARCHAR(255), |
|
| 401 |
SUCCESSFUL BOOLEAN, |
|
| 402 |
CREATEDBY_ID INTEGER, |
|
| 403 |
UPDATEDBY_ID INTEGER, |
|
| 404 |
CLONING_ID INTEGER, |
|
| 405 |
DNASAMPLE_ID INTEGER, |
|
| 406 |
AMPLIFICATION_ID INTEGER, |
|
| 407 |
GELPHOTO_ID INTEGER, |
|
| 408 |
PRIMARY KEY (ID) |
|
| 409 |
); |
|
| 410 |
|
|
| 411 |
CREATE TABLE AMPLIFICATIONRESULT_ANNOTATION ( |
|
| 412 |
AMPLIFICATIONRESULT_ID INTEGER NOT NULL, |
|
| 413 |
ANNOTATIONS_ID INTEGER NOT NULL, |
|
| 414 |
PRIMARY KEY (AMPLIFICATIONRESULT_ID, ANNOTATIONS_ID) |
|
| 415 |
); |
|
| 416 |
|
|
| 417 |
CREATE TABLE AMPLIFICATIONRESULT_ANNOTATION_AUD ( |
|
| 418 |
REV INTEGER NOT NULL, |
|
| 419 |
REVTYPE TINYINT, |
|
| 420 |
AMPLIFICATIONRESULT_ID INTEGER NOT NULL, |
|
| 421 |
ANNOTATIONS_ID INTEGER NOT NULL |
|
| 422 |
); |
|
| 423 |
|
|
| 424 |
CREATE TABLE AMPLIFICATIONRESULT_MARKER ( |
|
| 425 |
AMPLIFICATIONRESULT_ID INTEGER NOT NULL, |
|
| 426 |
MARKERS_ID INTEGER NOT NULL, |
|
| 427 |
PRIMARY KEY (AMPLIFICATIONRESULT_ID, MARKERS_ID) |
|
| 387 | 428 |
); |
| 388 | 429 |
|
| 389 |
CREATE TABLE AMPLIFICATION_SINGLEREAD_AUD (
|
|
| 430 |
CREATE TABLE AMPLIFICATIONRESULT_MARKER_AUD (
|
|
| 390 | 431 |
REV INTEGER NOT NULL, |
| 391 | 432 |
REVTYPE TINYINT, |
| 392 |
AMPLIFICATION_ID INTEGER NOT NULL,
|
|
| 393 |
SINGLEREADS_ID INTEGER NOT NULL,
|
|
| 433 |
AMPLIFICATIONRESULT_ID INTEGER NOT NULL,
|
|
| 434 |
MARKERS_ID INTEGER NOT NULL,
|
|
| 394 | 435 |
); |
| 395 | 436 |
|
| 437 |
|
|
| 396 | 438 |
CREATE CACHED TABLE PUBLIC.ANNOTATION( |
| 397 | 439 |
ID INTEGER NOT NULL, |
| 398 | 440 |
CREATED TIMESTAMP, |
| ... | ... | |
| 869 | 911 |
ISO639_1 VARCHAR(2), |
| 870 | 912 |
RANKCLASS VARCHAR(4) NOT NULL, |
| 871 | 913 |
ISTECHNICAL BOOLEAN, |
| 914 |
ABSENCETERM BOOLEAN NOT NULL, |
|
| 872 | 915 |
ORDERINDEX INTEGER, |
| 873 | 916 |
SYMMETRICAL BOOLEAN, |
| 874 | 917 |
TRANSITIVE BOOLEAN, |
| ... | ... | |
| 932 | 975 |
SUPPORTSTAXONINTERACTION BOOLEAN, |
| 933 | 976 |
SUPPORTSTEXTDATA BOOLEAN, |
| 934 | 977 |
ISTECHNICAL BOOLEAN, |
| 978 |
ABSENCETERM BOOLEAN NOT NULL, |
|
| 935 | 979 |
DEFAULTCOLOR VARCHAR(255), |
| 936 | 980 |
POINTAPPROXIMATION_ERRORRADIUS INTEGER, |
| 937 | 981 |
POINTAPPROXIMATION_LATITUDE DOUBLE, |
| ... | ... | |
| 1146 | 1190 |
CREATEDBY_ID INTEGER, |
| 1147 | 1191 |
UPDATEDBY_ID INTEGER, |
| 1148 | 1192 |
ACTOR_ID INTEGER, |
| 1149 |
TYPE_ID INTEGER |
|
| 1193 |
INSTITUTION_ID INTEGER, |
|
| 1194 |
TYPE_ID INTEGER |
|
| 1150 | 1195 |
); |
| 1151 | 1196 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DERIVATIONEVENT; |
| 1152 | 1197 |
CREATE CACHED TABLE PUBLIC.DERIVATIONEVENT_AUD( |
| ... | ... | |
| 1163 | 1208 |
CREATEDBY_ID INTEGER, |
| 1164 | 1209 |
UPDATEDBY_ID INTEGER, |
| 1165 | 1210 |
ACTOR_ID INTEGER, |
| 1166 |
TYPE_ID INTEGER |
|
| 1211 |
INSTITUTION_ID INTEGER, |
|
| 1212 |
TYPE_ID INTEGER |
|
| 1167 | 1213 |
); |
| 1168 | 1214 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DERIVATIONEVENT_AUD; |
| 1169 | 1215 |
CREATE CACHED TABLE PUBLIC.DERIVATIONEVENT_ANNOTATION( |
| ... | ... | |
| 1383 | 1429 |
TIMEPERIOD_END VARCHAR(255), |
| 1384 | 1430 |
TIMEPERIOD_FREETEXT VARCHAR(255), |
| 1385 | 1431 |
ORDERRELEVANT BOOLEAN, |
| 1386 |
UNKNOWNDATA BOOLEAN, |
|
| 1432 |
-- MINIMUM DOUBLE, |
|
| 1433 |
-- MAXIMUM DOUBLE, |
|
| 1434 |
-- AVERAGE DOUBLE, |
|
| 1435 |
-- TYPCALLOWERBOUNDARY DOUBLE, |
|
| 1436 |
-- TYPCALHIGHERBOUNDARY DOUBLE, |
|
| 1437 |
-- VARIANCE DOUBLE, |
|
| 1438 |
-- STANDARDDEVIATION DOUBLE, |
|
| 1439 |
-- SINGLEVALUE DOUBLE, |
|
| 1440 |
-- SAMPLESIZE INTEGER, |
|
| 1441 |
UNKNOWNDATA BOOLEAN, |
|
| 1387 | 1442 |
CREATEDBY_ID INTEGER, |
| 1388 | 1443 |
UPDATEDBY_ID INTEGER, |
| 1389 | 1444 |
FEATURE_ID INTEGER, |
| ... | ... | |
| 1394 | 1449 |
ASSOCIATEDSPECIMENOROBSERVATION_ID INTEGER, |
| 1395 | 1450 |
UNIT_ID INTEGER, |
| 1396 | 1451 |
TAXON2_ID INTEGER, |
| 1397 |
FORMAT_ID INTEGER |
|
| 1452 |
FORMAT_ID INTEGER, |
|
| 1453 |
|
|
| 1398 | 1454 |
); |
| 1399 | 1455 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE; |
| 1400 | 1456 |
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_AUD( |
| ... | ... | |
| 1409 | 1465 |
TIMEPERIOD_START VARCHAR(255), |
| 1410 | 1466 |
TIMEPERIOD_END VARCHAR(255), |
| 1411 | 1467 |
TIMEPERIOD_FREETEXT VARCHAR(255), |
| 1468 |
-- MINIMUM DOUBLE, |
|
| 1469 |
-- MAXIMUM DOUBLE, |
|
| 1470 |
-- AVERAGE DOUBLE, |
|
| 1471 |
-- TYPCALLOWERBOUNDARY DOUBLE, |
|
| 1472 |
-- TYPCALHIGHERBOUNDARY DOUBLE, |
|
| 1473 |
-- VARIANCE DOUBLE, |
|
| 1474 |
-- STANDARDDEVIATION DOUBLE, |
|
| 1475 |
-- SINGLEVALUE DOUBLE, |
|
| 1476 |
-- SAMPLESIZE INTEGER, |
|
| 1412 | 1477 |
ORDERRELEVANT BOOLEAN, |
| 1413 | 1478 |
UNKNOWNDATA BOOLEAN, |
| 1414 | 1479 |
CREATEDBY_ID INTEGER, |
| ... | ... | |
| 1553 | 1618 |
ACTOR_ID INTEGER, |
| 1554 | 1619 |
IDENTIFIEDUNIT_ID INTEGER, |
| 1555 | 1620 |
MODIFIER_ID INTEGER, |
| 1556 |
TAXON_ID INTEGER |
|
| 1621 |
TAXON_ID INTEGER, |
|
| 1622 |
TAXONNAME_ID INTEGER |
|
| 1557 | 1623 |
); |
| 1558 | 1624 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DETERMINATIONEVENT; |
| 1559 | 1625 |
CREATE CACHED TABLE PUBLIC.DETERMINATIONEVENT_AUD( |
| ... | ... | |
| 1573 | 1639 |
ACTOR_ID INTEGER, |
| 1574 | 1640 |
IDENTIFIEDUNIT_ID INTEGER, |
| 1575 | 1641 |
MODIFIER_ID INTEGER, |
| 1576 |
TAXON_ID INTEGER |
|
| 1642 |
TAXON_ID INTEGER, |
|
| 1643 |
TAXONNAME_ID INTEGER |
|
| 1577 | 1644 |
); |
| 1578 | 1645 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DETERMINATIONEVENT_AUD; |
| 1579 | 1646 |
CREATE CACHED TABLE PUBLIC.DETERMINATIONEVENT_ANNOTATION( |
| ... | ... | |
| 3160 | 3227 |
UUID VARCHAR(36), |
| 3161 | 3228 |
UPDATED TIMESTAMP, |
| 3162 | 3229 |
LABEL VARCHAR(255), |
| 3163 |
SEQUENCE_LENGTH INTEGER,
|
|
| 3230 |
SEQUENCE_LENGTH INTEGER,
|
|
| 3164 | 3231 |
SEQUENCE_STRING CLOB, |
| 3165 | 3232 |
CREATEDBY_ID INTEGER, |
| 3166 | 3233 |
UPDATEDBY_ID INTEGER, |
| 3167 |
PUBLISHEDIN_ID INTEGER, |
|
| 3168 |
PRIMARY KEY (ID) |
|
| 3234 |
DNAMARKER_ID INTEGER, |
|
| 3235 |
PUBLISHEDIN_ID INTEGER, |
|
| 3236 |
PRIMARY KEY (ID) |
|
| 3169 | 3237 |
); |
| 3170 | 3238 |
CREATE TABLE PRIMER_AUD ( |
| 3171 | 3239 |
ID INTEGER NOT NULL, |
| ... | ... | |
| 3177 | 3245 |
SEQUENCE_STRING CLOB, |
| 3178 | 3246 |
CREATEDBY_ID INTEGER, |
| 3179 | 3247 |
UPDATEDBY_ID INTEGER, |
| 3180 |
PUBLISHEDIN_ID INTEGER, |
|
| 3248 |
DNAMARKER_ID INTEGER, |
|
| 3249 |
PUBLISHEDIN_ID INTEGER, |
|
| 3181 | 3250 |
); |
| 3182 | 3251 |
|
| 3183 | 3252 |
CREATE TABLE PRIMER_ANNOTATION ( |
| ... | ... | |
| 3593 | 3662 |
CITATIONS_ID INTEGER NOT NULL |
| 3594 | 3663 |
); |
| 3595 | 3664 |
|
| 3596 |
CREATE TABLE SEQUENCE_SINGLEREAD ( |
|
| 3597 |
SEQUENCE_ID INTEGER NOT NULL, |
|
| 3598 |
SINGLEREADS_ID INTEGER NOT NULL, |
|
| 3599 |
PRIMARY KEY (SEQUENCE_ID, SINGLEREADS_ID) |
|
| 3665 |
CREATE TABLE SINGLEREADALIGNMENT ( |
|
| 3666 |
ID INTEGER NOT NULL, |
|
| 3667 |
CREATED TIMESTAMP, |
|
| 3668 |
UUID VARCHAR(36), |
|
| 3669 |
UPDATED TIMESTAMP, |
|
| 3670 |
EDITEDSEQUENCE CLOB, |
|
| 3671 |
SHIFTS CLOB, |
|
| 3672 |
REVERSECOMPLEMENT BIT, |
|
| 3673 |
CREATEDBY_ID INTEGER, |
|
| 3674 |
UPDATEDBY_ID INTEGER, |
|
| 3675 |
CONSENSUSALIGNMENT_ID INTEGER NOT NULL, |
|
| 3676 |
SINGLEREAD_ID INTEGER NOT NULL, |
|
| 3677 |
PRIMARY KEY (CONSENSUSALIGNMENT_ID, SINGLEREAD_ID) |
|
| 3600 | 3678 |
); |
| 3601 |
CREATE TABLE SEQUENCE_SINGLEREAD_AUD ( |
|
| 3679 |
|
|
| 3680 |
CREATE TABLE SINGLEREADALIGNMENT_AUD ( |
|
| 3681 |
ID INTEGER NOT NULL, |
|
| 3602 | 3682 |
REV INTEGER NOT NULL, |
| 3603 | 3683 |
REVTYPE TINYINT, |
| 3604 |
SEQUENCE_ID INTEGER NOT NULL, |
|
| 3605 |
SINGLEREADS_ID INTEGER NOT NULL |
|
| 3684 |
CREATED TIMESTAMP, |
|
| 3685 |
UUID VARCHAR(36), |
|
| 3686 |
UPDATED TIMESTAMP, |
|
| 3687 |
EDITEDSEQUENCE CLOB, |
|
| 3688 |
SHIFTS CLOB, |
|
| 3689 |
REVERSECOMPLEMENT BIT, |
|
| 3690 |
CREATEDBY_ID INTEGER, |
|
| 3691 |
UPDATEDBY_ID INTEGER, |
|
| 3692 |
CONSENSUSALIGNMENT_ID INTEGER NOT NULL, |
|
| 3693 |
SINGLEREAD_ID INTEGER NOT NULL |
|
| 3606 | 3694 |
); |
| 3607 | 3695 |
|
| 3608 | 3696 |
CREATE TABLE SINGLEREAD ( |
| ... | ... | |
| 3620 | 3708 |
CREATEDBY_ID INTEGER, |
| 3621 | 3709 |
UPDATEDBY_ID INTEGER, |
| 3622 | 3710 |
ACTOR_ID INTEGER, |
| 3623 |
AMPLIFICATION_ID INTEGER, |
|
| 3711 |
AMPLIFICATIONRESULT_ID INTEGER,
|
|
| 3624 | 3712 |
MATERIALORMETHOD_ID INTEGER, |
| 3625 | 3713 |
PHEROGRAM_ID INTEGER, |
| 3626 | 3714 |
PRIMER_ID INTEGER, |
| ... | ... | |
| 3643 | 3731 |
CREATEDBY_ID INTEGER, |
| 3644 | 3732 |
UPDATEDBY_ID INTEGER, |
| 3645 | 3733 |
ACTOR_ID INTEGER, |
| 3646 |
AMPLIFICATION_ID INTEGER, |
|
| 3734 |
AMPLIFICATIONRESULT_ID INTEGER,
|
|
| 3647 | 3735 |
MATERIALORMETHOD_ID INTEGER, |
| 3648 | 3736 |
PHEROGRAM_ID INTEGER, |
| 3649 | 3737 |
PRIMER_ID INTEGER |
| ... | ... | |
| 3872 | 3960 |
REVTYPE TINYINT |
| 3873 | 3961 |
); |
| 3874 | 3962 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_RIGHTSINFO_AUD; |
| 3875 |
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_SEQUENCE( |
|
| 3876 |
SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL, |
|
| 3877 |
SEQUENCES_ID INTEGER NOT NULL |
|
| 3878 |
); |
|
| 3879 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_SEQUENCE; |
|
| 3880 |
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_SEQUENCE_AUD( |
|
| 3881 |
REV INTEGER NOT NULL, |
|
| 3882 |
SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL, |
|
| 3883 |
SEQUENCES_ID INTEGER NOT NULL, |
|
| 3884 |
REVTYPE TINYINT |
|
| 3885 |
); |
|
| 3886 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_SEQUENCE_AUD; |
|
| 3963 |
|
|
| 3887 | 3964 |
CREATE CACHED TABLE PUBLIC.STATEDATA( |
| 3888 | 3965 |
ID INTEGER NOT NULL, |
| 3889 | 3966 |
CREATED TIMESTAMP, |
| ... | ... | |
| 4877 | 4954 |
ALTER TABLE PUBLIC.GATHERINGEVENT_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX33F PRIMARY KEY(REV, GATHERINGEVENT_ID, MARKERS_ID); |
| 4878 | 4955 |
ALTER TABLE PUBLIC.TAXONNAMEBASE_NOMENCLATURALSTATUS ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX7D7 PRIMARY KEY(TAXONNAMEBASE_ID, STATUS_ID); |
| 4879 | 4956 |
ALTER TABLE PUBLIC.DEFINEDTERMBASE_CONTINENT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXBAC PRIMARY KEY(DEFINEDTERMBASE_ID, CONTINENTS_ID); |
| 4880 |
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_SEQUENCE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXBAD PRIMARY KEY(REV, SPECIMENOROBSERVATIONBASE_ID, SEQUENCES_ID); |
|
| 4881 | 4957 |
ALTER TABLE PUBLIC.DETERMINATIONEVENT_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXBB0 PRIMARY KEY(DETERMINATIONEVENT_ID, MARKERS_ID); |
| 4882 | 4958 |
ALTER TABLE PUBLIC.TAXONNAMEBASE_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX33C PRIMARY KEY(REV, TAXONNAMEBASE_ID, SOURCES_ID); |
| 4883 | 4959 |
ALTER TABLE PUBLIC.DEFINEDTERMBASE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXFD PRIMARY KEY(DEFINEDTERMBASE_ID, SOURCES_ID); |
| ... | ... | |
| 4941 | 5017 |
ALTER TABLE PUBLIC.POLYTOMOUSKEY_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB599 PRIMARY KEY(ID, REV); |
| 4942 | 5018 |
ALTER TABLE PUBLIC.HOMOTYPICALGROUP ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC24 PRIMARY KEY(ID); |
| 4943 | 5019 |
ALTER TABLE PUBLIC.REFERENCE_MEDIA ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC22 PRIMARY KEY(REFERENCE_ID, MEDIA_ID); |
| 4944 |
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_SEQUENCE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXBE63 PRIMARY KEY(SPECIMENOROBSERVATIONBASE_ID, SEQUENCES_ID); |
|
| 4945 | 5020 |
ALTER TABLE PUBLIC.TAXONNODE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC10 PRIMARY KEY(ID); |
| 4946 | 5021 |
ALTER TABLE PUBLIC.MEDIAREPRESENTATION_MEDIAREPRESENTATIONPART_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX718 PRIMARY KEY(REV, REPRESENTATION_ID, ID, SORTINDEX); |
| 4947 | 5022 |
ALTER TABLE PUBLIC.POLYTOMOUSKEYNODE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC29 PRIMARY KEY(ID, REV); |
| ... | ... | |
| 5476 | 5551 |
ALTER TABLE PUBLIC.FEATURETREE_RIGHTSINFO ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXF96 UNIQUE(RIGHTS_ID); |
| 5477 | 5552 |
ALTER TABLE PUBLIC.TERMVOCABULARY_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC3CBC UNIQUE(EXTENSIONS_ID); |
| 5478 | 5553 |
ALTER TABLE PUBLIC.STATISTICALMEASUREMENTVALUE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX35B UNIQUE(UUID); |
| 5479 |
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_SEQUENCE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXBE634 UNIQUE(SEQUENCES_ID); |
|
| 5480 | 5554 |
ALTER TABLE PUBLIC.TAXONBASE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXFF44 UNIQUE(CREDITS_ID); |
| 5481 | 5555 |
ALTER TABLE PUBLIC.COLLECTION_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXBBE UNIQUE(EXTENSIONS_ID); |
| 5482 | 5556 |
ALTER TABLE PUBLIC.TAXONNAMEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX919B UNIQUE(UUID); |
| ... | ... | |
| 5621 | 5695 |
ALTER TABLE PUBLIC.TAXONNODE_AUD ADD CONSTRAINT PUBLIC.FKE090C39D34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK; |
| 5622 | 5696 |
ALTER TABLE PUBLIC.COLLECTION_MARKER_AUD ADD CONSTRAINT PUBLIC.FK89C7394C34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK; |
| 5623 | 5697 |
ALTER TABLE PUBLIC.DEFINEDTERMBASE_AUD ADD CONSTRAINT PUBLIC.FK86E8953734869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK; |
| 5624 |
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_SEQUENCE ADD CONSTRAINT PUBLIC.FKBBF27B0E35B10F24 FOREIGN KEY(SEQUENCES_ID) REFERENCES PUBLIC.SEQUENCE(ID) NOCHECK; |
|
| 5625 | 5698 |
ALTER TABLE PUBLIC.LSIDAUTHORITY_NAMESPACES ADD CONSTRAINT PUBLIC.FKB04948F64FFCFD94 FOREIGN KEY(LSIDAUTHORITY_ID) REFERENCES PUBLIC.LSIDAUTHORITY(ID) NOCHECK; |
| 5626 | 5699 |
ALTER TABLE PUBLIC.HYBRIDRELATIONSHIP ADD CONSTRAINT PUBLIC.FK9033CE744FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK; |
| 5627 | 5700 |
ALTER TABLE PUBLIC.GATHERINGEVENT_DEFINEDTERMBASE ADD CONSTRAINT PUBLIC.FK69D9A11A7C34B6D6 FOREIGN KEY(COLLECTINGAREAS_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK; |
| ... | ... | |
| 6008 | 6081 |
ALTER TABLE PUBLIC.DEFINEDTERMBASE_RECOMMENDEDMODIFIERENUMERATION_AUD ADD CONSTRAINT PUBLIC.FK780D5C7F34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK; |
| 6009 | 6082 |
ALTER TABLE PUBLIC.TAXONBASE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.FKFB680C819C9D39 FOREIGN KEY(TAXONBASE_ID) REFERENCES PUBLIC.TAXONBASE(ID) NOCHECK; |
| 6010 | 6083 |
ALTER TABLE PUBLIC.INDIVIDUALASSOCIATION_LANGUAGESTRING_AUD ADD CONSTRAINT PUBLIC.FKB1A62C9134869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK; |
| 6011 |
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_SEQUENCE ADD CONSTRAINT PUBLIC.FKBBF27B0E7EE2770E FOREIGN KEY(SPECIMENOROBSERVATIONBASE_ID) REFERENCES PUBLIC.SPECIMENOROBSERVATIONBASE(ID) NOCHECK; |
|
| 6012 | 6084 |
ALTER TABLE PUBLIC.CREDIT ADD CONSTRAINT PUBLIC.FK78CA9719BC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK; |
| 6013 | 6085 |
ALTER TABLE PUBLIC.REFERENCE_MEDIA_AUD ADD CONSTRAINT PUBLIC.FK8318CB8134869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK; |
| 6014 | 6086 |
ALTER TABLE PUBLIC.INDIVIDUALASSOCIATION_LANGUAGESTRING ADD CONSTRAINT PUBLIC.FKB5C75EC028459272 FOREIGN KEY(DESCRIPTION_MAPKEY_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK; |
| ... | ... | |
| 6146 | 6218 |
ALTER TABLE PUBLIC.HYBRIDRELATIONSHIP_ANNOTATION ADD CONSTRAINT PUBLIC.FK2C7E7DFA1E403E0B FOREIGN KEY(ANNOTATIONS_ID) REFERENCES PUBLIC.ANNOTATION(ID) NOCHECK; |
| 6147 | 6219 |
ALTER TABLE PUBLIC.MEDIAREPRESENTATION_MEDIAREPRESENTATIONPART_AUD ADD CONSTRAINT PUBLIC.FK3544378734869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK; |
| 6148 | 6220 |
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MODIFYINGTEXT_AUD ADD CONSTRAINT PUBLIC.FK6C06031834869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK; |
| 6149 |
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_SEQUENCE_AUD ADD CONSTRAINT PUBLIC.FK392E71DF34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK; |
|
| 6150 | 6221 |
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_LANGUAGESTRING ADD CONSTRAINT PUBLIC.FKCFAA93168028C309 FOREIGN KEY(DEFINITION_MAPKEY_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK; |
| 6151 | 6222 |
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE ADD CONSTRAINT PUBLIC.FK21CA3272BC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK; |
| 6152 | 6223 |
ALTER TABLE PUBLIC.LSIDAUTHORITY ADD CONSTRAINT PUBLIC.FK759DB8814FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK; |
Also available in: Unified diff
updated the test dataset to match the new schema