Revision eac82784
Added by Andreas Müller about 5 years ago
cdmlib-test/src/main/resources/dbscripts/001-cdm.h2.sql | ||
---|---|---|
5258 | 5258 |
REVTYPE TINYINT |
5259 | 5259 |
); |
5260 | 5260 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TYPEDESIGNATIONBASE_MARKER_AUD; |
5261 |
CREATE CACHED TABLE PUBLIC.TYPEDESIGNATIONBASE_ORIGINALSOURCEBASE( |
|
5262 |
TYPEDESIGNATIONBASE_ID INTEGER NOT NULL, |
|
5263 |
SOURCES_ID INTEGER NOT NULL |
|
5264 |
); |
|
5265 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAME_ORIGINALSOURCEBASE; |
|
5266 |
CREATE CACHED TABLE PUBLIC.TYPEDESIGNATIONBASE_ORIGINALSOURCEBASE_AUD( |
|
5267 |
REV INTEGER NOT NULL, |
|
5268 |
TYPEDESIGNATIONBASE_ID INTEGER NOT NULL, |
|
5269 |
SOURCES_ID INTEGER NOT NULL, |
|
5270 |
REVTYPE TINYINT |
|
5271 |
); |
|
5272 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAME_ORIGINALSOURCEBASE_AUD; |
|
5273 |
|
|
5261 | 5274 |
CREATE CACHED TABLE PUBLIC.USERACCOUNT( |
5262 | 5275 |
ID INTEGER NOT NULL, |
5263 | 5276 |
CREATED TIMESTAMP, |
Also available in: Unified diff
ref #8017 add sources to TypeDesignationBase (cont.)