Revision ace720cf
Add MediaSpecimen (still missing schema updater and tests) #3614
cdmlib-io/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