Revision 55936b8f
Added by Andreas Müller almost 6 years ago
| cdmlib-test/src/main/resources/dbscripts/001-cdm.h2.sql | ||
|---|---|---|
| 4483 | 4483 |
BASIONYMAUTHORSHIP_ID INTEGER, |
| 4484 | 4484 |
COMBINATIONAUTHORSHIP_ID INTEGER, |
| 4485 | 4485 |
EXBASIONYMAUTHORSHIP_ID INTEGER, |
| 4486 |
EXCOMBINATIONAUTHORSHIP_ID INTEGER |
|
| 4486 |
EXCOMBINATIONAUTHORSHIP_ID INTEGER, |
|
| 4487 |
INBASIONYMAUTHORSHIP_ID INTEGER, |
|
| 4488 |
INCOMBINATIONAUTHORSHIP_ID INTEGER |
|
| 4487 | 4489 |
); |
| 4488 | 4490 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAME; |
| 4489 | 4491 |
CREATE INDEX PUBLIC.TAXONNAMEBASETITLECACHEINDEX ON PUBLIC.TAXONNAME(TITLECACHE); |
| ... | ... | |
| 4537 | 4539 |
ORIGINALPUBLICATIONYEAR INTEGER, |
| 4538 | 4540 |
PUBLICATIONYEAR INTEGER, |
| 4539 | 4541 |
NAMEAPPROBATION VARCHAR(255), |
| 4540 |
SUBGENUSAUTHORSHIP VARCHAR(255) |
|
| 4542 |
SUBGENUSAUTHORSHIP VARCHAR(255), |
|
| 4543 |
INBASIONYMAUTHORSHIP_ID INTEGER, |
|
| 4544 |
INCOMBINATIONAUTHORSHIP_ID INTEGER |
|
| 4541 | 4545 |
); |
| 4542 | 4546 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAME_AUD; |
| 4543 | 4547 |
CREATE CACHED TABLE PUBLIC.TAXONNAME_ANNOTATION( |
Also available in: Unified diff
fix #6943 add zoological in-authors to TaxonName