Revision 840abdb1
Added by Andreas Müller almost 9 years ago
cdmlib-io/src/test/resources/dbscripts/001-cdm.h2.sql | ||
---|---|---|
4379 | 4379 |
HOMOTYPICALGROUP_ID INTEGER, |
4380 | 4380 |
NOMENCLATURALREFERENCE_ID INTEGER, |
4381 | 4381 |
RANK_ID INTEGER, |
4382 |
BASIONYMAUTHORTEAM_ID INTEGER,
|
|
4383 |
COMBINATIONAUTHORTEAM_ID INTEGER,
|
|
4384 |
EXBASIONYMAUTHORTEAM_ID INTEGER,
|
|
4385 |
EXCOMBINATIONAUTHORTEAM_ID INTEGER
|
|
4382 |
BASIONYMAUTHORSHIP_ID INTEGER,
|
|
4383 |
COMBINATIONAUTHORSHIP_ID INTEGER,
|
|
4384 |
EXBASIONYMAUTHORSHIP_ID INTEGER,
|
|
4385 |
EXCOMBINATIONAUTHORSHIP_ID INTEGER
|
|
4386 | 4386 |
); |
4387 | 4387 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE; |
4388 | 4388 |
CREATE INDEX PUBLIC.TAXONNAMEBASETITLECACHEINDEX ON PUBLIC.TAXONNAMEBASE(TITLECACHE); |
... | ... | |
4426 | 4426 |
PROTECTEDNAMECACHE BOOLEAN, |
4427 | 4427 |
SPECIFICEPITHET VARCHAR(255), |
4428 | 4428 |
TRINOMHYBRID BOOLEAN, |
4429 |
BASIONYMAUTHORTEAM_ID INTEGER,
|
|
4430 |
COMBINATIONAUTHORTEAM_ID INTEGER,
|
|
4431 |
EXBASIONYMAUTHORTEAM_ID INTEGER,
|
|
4432 |
EXCOMBINATIONAUTHORTEAM_ID INTEGER,
|
|
4429 |
BASIONYMAUTHORSHIP_ID INTEGER,
|
|
4430 |
COMBINATIONAUTHORSHIP_ID INTEGER,
|
|
4431 |
EXBASIONYMAUTHORSHIP_ID INTEGER,
|
|
4432 |
EXCOMBINATIONAUTHORSHIP_ID INTEGER,
|
|
4433 | 4433 |
ANAMORPHIC BOOLEAN, |
4434 | 4434 |
CULTIVARNAME VARCHAR(255), |
4435 | 4435 |
BREED VARCHAR(255), |
... | ... | |
5760 | 5760 |
ALTER TABLE PUBLIC.TAXONBASE_RIGHTSINFO ADD CONSTRAINT PUBLIC.FK65CF621B9C9D39 FOREIGN KEY(TAXONBASE_ID) REFERENCES PUBLIC.TAXONBASE(ID) NOCHECK; |
5761 | 5761 |
ALTER TABLE PUBLIC.MEDIA_MARKER ADD CONSTRAINT PUBLIC.FKD21E7935C2C29593 FOREIGN KEY(MEDIA_ID) REFERENCES PUBLIC.MEDIA(ID) NOCHECK; |
5762 | 5762 |
--ALTER TABLE PUBLIC.SEQUENCE_CREDIT_AUD ADD CONSTRAINT PUBLIC.FK4B22838834869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK; |
5763 |
ALTER TABLE PUBLIC.TAXONNAMEBASE ADD CONSTRAINT PUBLIC.FKB4870C67F90DF03 FOREIGN KEY(EXBASIONYMAUTHORTEAM_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;
|
|
5763 |
ALTER TABLE PUBLIC.TAXONNAMEBASE ADD CONSTRAINT PUBLIC.FKB4870C67F90DF03 FOREIGN KEY(EXBASIONYMAUTHORSHIP_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;
|
|
5764 | 5764 |
ALTER TABLE PUBLIC.ORIGINALSOURCEBASE_MARKER ADD CONSTRAINT PUBLIC.FKB3FFDC7C777265A1 FOREIGN KEY(MARKERS_ID) REFERENCES PUBLIC.MARKER(ID) NOCHECK; |
5765 | 5765 |
--ALTER TABLE PUBLIC.SEQUENCE_EXTENSION ADD CONSTRAINT PUBLIC.FK7BE66D41927DE9DF FOREIGN KEY(EXTENSIONS_ID) REFERENCES PUBLIC.EXTENSION(ID) NOCHECK; |
5766 | 5766 |
ALTER TABLE PUBLIC.MEDIA_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.FK99ABA37B34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK; |
... | ... | |
5940 | 5940 |
ALTER TABLE PUBLIC.SYNONYMRELATIONSHIP_MARKER ADD CONSTRAINT PUBLIC.FK7A439066777265A1 FOREIGN KEY(MARKERS_ID) REFERENCES PUBLIC.MARKER(ID) NOCHECK; |
5941 | 5941 |
ALTER TABLE PUBLIC.WORKINGSET_MARKER ADD CONSTRAINT PUBLIC.FK9CB22CC8777265A1 FOREIGN KEY(MARKERS_ID) REFERENCES PUBLIC.MARKER(ID) NOCHECK; |
5942 | 5942 |
--ALTER TABLE PUBLIC.SEQUENCE_MEDIA_AUD ADD CONSTRAINT PUBLIC.FK20025CB734869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK; |
5943 |
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;
|
|
5944 | 5944 |
ALTER TABLE PUBLIC.DEFINEDTERMBASE_RIGHTSINFO ADD CONSTRAINT PUBLIC.FK921A01F0C13F7B21 FOREIGN KEY(RIGHTS_ID) REFERENCES PUBLIC.RIGHTSINFO(ID) NOCHECK; |
5945 | 5945 |
ALTER TABLE PUBLIC.INDIVIDUALASSOCIATION_LANGUAGESTRING ADD CONSTRAINT PUBLIC.FKB5C75EC02BEBA58D FOREIGN KEY(DESCRIPTION_ID) REFERENCES PUBLIC.LANGUAGESTRING(ID) NOCHECK; |
5946 | 5946 |
ALTER TABLE PUBLIC.CLASSIFICATION ADD CONSTRAINT PUBLIC.FKDB110006BC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK; |
... | ... | |
6098 | 6098 |
ALTER TABLE PUBLIC.TAXONNAMEBASE_TYPEDESIGNATIONBASE ADD CONSTRAINT PUBLIC.FKC0D6BBB5C7DF530C FOREIGN KEY(TYPEDESIGNATIONS_ID) REFERENCES PUBLIC.TYPEDESIGNATIONBASE(ID) NOCHECK; |
6099 | 6099 |
ALTER TABLE PUBLIC.POLYTOMOUSKEYNODE ADD CONSTRAINT PUBLIC.FK860775A808998FB FOREIGN KEY(PARENT_ID) REFERENCES PUBLIC.POLYTOMOUSKEYNODE(ID) NOCHECK; |
6100 | 6100 |
ALTER TABLE PUBLIC.ANNOTATION ADD CONSTRAINT PUBLIC.FK1A21C74F4FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK; |
6101 |
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;
|
|
6102 | 6102 |
ALTER TABLE PUBLIC.NAMERELATIONSHIP_MARKER_AUD ADD CONSTRAINT PUBLIC.FKCD68D66734869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK; |
6103 | 6103 |
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE ADD CONSTRAINT PUBLIC.FK38FE7671BC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK; |
6104 | 6104 |
ALTER TABLE PUBLIC.INSTITUTIONALMEMBERSHIP ADD CONSTRAINT PUBLIC.FK3C8E1FF9BC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK; |
... | ... | |
6480 | 6480 |
ALTER TABLE PUBLIC.REPRESENTATION_AUD ADD CONSTRAINT PUBLIC.FK294D143E34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK; |
6481 | 6481 |
ALTER TABLE PUBLIC.USERACCOUNT ADD CONSTRAINT PUBLIC.FKB3F13C24FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK; |
6482 | 6482 |
ALTER TABLE PUBLIC.TAXONNAMEBASE_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.FK7A38D54734869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK; |
6483 |
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;
|
|
6484 | 6484 |
ALTER TABLE PUBLIC.TAXONNAMEBASE ADD CONSTRAINT PUBLIC.FKB4870C6D7BE55A0 FOREIGN KEY(RANK_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK; |
6485 | 6485 |
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_CREDIT ADD CONSTRAINT PUBLIC.FK7E3A1D863B8A5ABA FOREIGN KEY(SPECIMENOROBSERVATIONBASE_ID) REFERENCES PUBLIC.SPECIMENOROBSERVATIONBASE(ID) NOCHECK; |
6486 | 6486 |
ALTER TABLE PUBLIC.ADDRESS_AUD ADD CONSTRAINT PUBLIC.FK115657A534869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK; |
Also available in: Unified diff
rename authorTeam -> authorship #4332 for name authors