Revision f6d5e560
Added by Andreas Müller almost 10 years ago
| cdmlib-persistence/src/test/resources/dbscripts/001-cdm.h2.sql | ||
|---|---|---|
| 560 | 560 |
REVTYPE TINYINT |
| 561 | 561 |
); |
| 562 | 562 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_CREDIT_AUD; |
| 563 |
|
|
| 564 |
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_DESCRIPTION( |
|
| 565 |
CLASSIFICATION_ID INTEGER NOT NULL, |
|
| 566 |
DESCRIPTION_ID INTEGER NOT NULL, |
|
| 567 |
DESCRIPTION_MAPKEY_ID INTEGER NOT NULL |
|
| 568 |
); |
|
| 569 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_DESCRIPTION; |
|
| 570 |
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_DESCRIPTION_AUD( |
|
| 571 |
REV INTEGER NOT NULL, |
|
| 572 |
CLASSIFICATION_ID INTEGER NOT NULL, |
|
| 573 |
DESCRIPTION_ID INTEGER NOT NULL, |
|
| 574 |
DESCRIPTION_MAPKEY_ID INTEGER NOT NULL, |
|
| 575 |
REVTYPE TINYINT |
|
| 576 |
); |
|
| 577 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_DESCRIPTION_AUD; |
|
| 578 |
|
|
| 563 | 579 |
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_EXTENSION( |
| 564 | 580 |
CLASSIFICATION_ID INTEGER NOT NULL, |
| 565 | 581 |
EXTENSIONS_ID INTEGER NOT NULL |
Also available in: Unified diff
add i18n description for Classification. #4428