Project

General

Profile

Revision ed506dcb

IDed506dcb597b060599d46b76d21580ac25cd7fcd
Parent 30451d3c
Child 58c5052a

Added by Andreas Müller over 2 years ago

fix #6089 Remove taxonomicParentCache and taxonomicChildrenCount, fix Testdata

View differences:

cdmlib-test/src/main/resources/dbscripts/001-cdm.h2.sql
4206 4206
    USENAMECACHE BOOLEAN NOT NULL,
4207 4207
    EXCLUDED BOOLEAN,
4208 4208
    TAXONSTATUSUNKNOWN BOOLEAN,
4209
    TAXONOMICCHILDRENCOUNT INTEGER,
4210 4209
    UNPLACED BOOLEAN,
4211 4210
    CREATEDBY_ID INTEGER,
4212 4211
    UPDATEDBY_ID INTEGER,
4213 4212
    NAME_ID INTEGER,
4214
    SEC_ID INTEGER,
4215
    TAXONOMICPARENTCACHE_ID INTEGER
4213
    SEC_ID INTEGER
4216 4214
);
4217 4215
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONBASE;
4218 4216
CREATE INDEX PUBLIC.TAXONBASETITLECACHEINDEX ON PUBLIC.TAXONBASE(TITLECACHE);
......
4242 4240
    SEC_ID INTEGER,
4243 4241
    EXCLUDED BOOLEAN,
4244 4242
    TAXONSTATUSUNKNOWN BOOLEAN,
4245
    TAXONOMICCHILDRENCOUNT INTEGER,
4246
    UNPLACED BOOLEAN,
4247
    TAXONOMICPARENTCACHE_ID INTEGER
4243
    UNPLACED BOOLEAN
4248 4244
);
4249 4245
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONBASE_AUD;
4250 4246
CREATE CACHED TABLE PUBLIC.TAXONBASE_ANNOTATION(
......
6405 6401
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_MARKER ADD CONSTRAINT PUBLIC.FK8E6106C7777265A1 FOREIGN KEY(MARKERS_ID) REFERENCES PUBLIC.MARKER(ID) NOCHECK;
6406 6402
ALTER TABLE PUBLIC.REFERENCE ADD CONSTRAINT PUBLIC.FK404D5F2B697665E FOREIGN KEY(AUTHORSHIP_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;
6407 6403
ALTER TABLE PUBLIC.CLASSIFICATION_CREDIT_AUD ADD CONSTRAINT PUBLIC.FK48AC64334869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6408
ALTER TABLE PUBLIC.TAXONBASE ADD CONSTRAINT PUBLIC.FK9249B49B7C7B5AED FOREIGN KEY(TAXONOMICPARENTCACHE_ID) REFERENCES PUBLIC.TAXONBASE(ID) NOCHECK;
6409 6404
ALTER TABLE PUBLIC.AGENTBASE_ADDRESS ADD CONSTRAINT PUBLIC.FK1EDFF7EB50751EC5 FOREIGN KEY(CONTACT_ADDRESSES_ID) REFERENCES PUBLIC.ADDRESS(ID) NOCHECK;
6410 6405
ALTER TABLE PUBLIC.HYBRIDRELATIONSHIP_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.FKACE71ECB34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6411 6406
ALTER TABLE PUBLIC.GATHERINGEVENT_AUD ADD CONSTRAINT PUBLIC.FK3EC034434869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

Also available in: Unified diff

Add picture from clipboard (Maximum size: 40 MB)