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
