Revision 08f2d5e5
Added by Andreas Kohlbecker over 6 years ago
cdmlib-test/src/main/resources/dbscripts/001-cdm.h2.sql | ||
---|---|---|
3346 | 3346 |
|
3347 | 3347 |
|
3348 | 3348 |
CREATE CACHED TABLE PUBLIC.REFERENCE( |
3349 |
DTYPE VARCHAR(31) NOT NULL, |
|
3350 | 3349 |
ID INTEGER NOT NULL, |
3351 | 3350 |
CREATED TIMESTAMP, |
3352 | 3351 |
UUID VARCHAR(36), |
... | ... | |
3398 | 3397 |
-- 1 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE; |
3399 | 3398 |
CREATE INDEX PUBLIC.REFERENCETITLECACHEINDEX ON PUBLIC.REFERENCE(TITLECACHE); |
3400 | 3399 |
CREATE CACHED TABLE PUBLIC.REFERENCE_AUD( |
3401 |
DTYPE VARCHAR(31) NOT NULL, |
|
3402 | 3400 |
ID INTEGER NOT NULL, |
3403 | 3401 |
REV INTEGER NOT NULL, |
3404 | 3402 |
REVTYPE TINYINT, |
... | ... | |
4396 | 4394 |
); |
4397 | 4395 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONINTERACTION_LANGUAGESTRING_AUD; |
4398 | 4396 |
CREATE CACHED TABLE PUBLIC.TAXONNAME( |
4399 |
DTYPE VARCHAR(31) NOT NULL, |
|
4400 | 4397 |
ID INTEGER NOT NULL, |
4401 | 4398 |
CREATED TIMESTAMP, |
4402 | 4399 |
UUID VARCHAR(36), |
... | ... | |
4449 | 4446 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAME; |
4450 | 4447 |
CREATE INDEX PUBLIC.TAXONNAMEBASETITLECACHEINDEX ON PUBLIC.TAXONNAME(TITLECACHE); |
4451 | 4448 |
CREATE CACHED TABLE PUBLIC.TAXONNAME_AUD( |
4452 |
DTYPE VARCHAR(31) NOT NULL, |
|
4453 | 4449 |
ID INTEGER NOT NULL, |
4454 | 4450 |
REV INTEGER NOT NULL, |
4455 | 4451 |
REVTYPE TINYINT, |
Also available in: Unified diff
ref #6361 removing TaxonName.DTYPE and Reference.DTYPE