Project

General

Profile

Revision ace720cf

IDace720cf6b0926c701dc666d52db1f23953abb4f
Parent f7678187
Child bd07c1ce

Added by Andreas Müller over 8 years ago

Add MediaSpecimen (still missing schema updater and tests) #3614

View differences:

cdmlib-ext/src/test/resources/dbscripts/001-cdm.h2.sql
306 306
     MARKER_ID INTEGER,
307 307
     PURIFICATION_ID INTEGER,
308 308
     REVERSEPRIMER_ID INTEGER,
309
     GELPHOTO_ID INTEGER,
309 310
     PRIMARY KEY (ID)
310 311
);
311 312

  
......
335 336
    MARKER_ID INTEGER,
336 337
    PURIFICATION_ID INTEGER,
337 338
    REVERSEPRIMER_ID INTEGER,
339
    GELPHOTO_ID INTEGER,
338 340
    PRIMARY KEY (ID)
339 341
);
340 342

  
......
3501 3503
    STOREDUNDER_ID INTEGER,
3502 3504
    PRESERVATION_ID INTEGER,
3503 3505
    GATHERINGEVENT_ID INTEGER,
3504
    PRIMARYCOLLECTOR_ID INTEGER
3506
    PRIMARYCOLLECTOR_ID INTEGER,
3507
    MEDIASPECIMEN_ID INTEGER
3505 3508
);
3506 3509
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE;
3507 3510
CREATE INDEX PUBLIC.SPECIMENOROBSERVATIONBASETITLECACHEINDEX ON PUBLIC.SPECIMENOROBSERVATIONBASE(TITLECACHE);
......
3540 3543
    STOREDUNDER_ID INTEGER,
3541 3544
    PRESERVATION_ID INTEGER,
3542 3545
    GATHERINGEVENT_ID INTEGER,
3543
    PRIMARYCOLLECTOR_ID INTEGER
3546
    PRIMARYCOLLECTOR_ID INTEGER,
3547
    MEDIASPECIMEN_ID INTEGER
3544 3548
);
3545 3549
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_AUD;
3546 3550
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_ANNOTATION(

Also available in: Unified diff

Add picture from clipboard (Maximum size: 40 MB)