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.)