Revision f53fe150
Added by Andreas Müller almost 6 years ago
| cdmlib-test/src/main/resources/dbscripts/001-cdm.h2.sql | ||
|---|---|---|
| 1951 | 1951 |
); |
| 1952 | 1952 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.EXTENSION_AUD; |
| 1953 | 1953 |
CREATE CACHED TABLE PUBLIC.EXTERNALLINK( |
| 1954 |
-- DTYPE VARCHAR(31) NOT NULL, |
|
| 1955 | 1954 |
ID INTEGER NOT NULL, |
| 1956 | 1955 |
CREATED TIMESTAMP, |
| 1957 | 1956 |
UUID VARCHAR(36), |
| 1958 | 1957 |
UPDATED TIMESTAMP, |
| 1959 | 1958 |
SIZE INTEGER, |
| 1960 | 1959 |
URI CLOB, |
| 1960 |
LINKTYPE VARCHAR(10), |
|
| 1961 | 1961 |
CREATEDBY_ID INTEGER, |
| 1962 | 1962 |
UPDATEDBY_ID INTEGER, |
| 1963 | 1963 |
SORTINDEX INTEGER |
| 1964 | 1964 |
); |
| 1965 | 1965 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIAREPRESENTATIONPART; |
| 1966 | 1966 |
CREATE CACHED TABLE PUBLIC.EXTERNALLINK_AUD( |
| 1967 |
-- DTYPE VARCHAR(31) NOT NULL, |
|
| 1968 | 1967 |
ID INTEGER NOT NULL, |
| 1969 | 1968 |
REV INTEGER NOT NULL, |
| 1970 | 1969 |
REVTYPE TINYINT, |
| ... | ... | |
| 1973 | 1972 |
UPDATED TIMESTAMP, |
| 1974 | 1973 |
SIZE INTEGER, |
| 1975 | 1974 |
URI CLOB, |
| 1975 |
LINKTYPE VARCHAR(10), |
|
| 1976 | 1976 |
CREATEDBY_ID INTEGER, |
| 1977 | 1977 |
UPDATEDBY_ID INTEGER, |
| 1978 | 1978 |
); |
| ... | ... | |
| 3268 | 3268 |
REVTYPE TINYINT |
| 3269 | 3269 |
); |
| 3270 | 3270 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ORIGINALSOURCEBASE_ANNOTATION_AUD; |
| 3271 |
CREATE CACHED TABLE PUBLIC.ORIGINALSOURCEBASE_EXTERNALLINK( |
|
| 3272 |
ORIGINALSOURCEBASE_ID INTEGER NOT NULL, |
|
| 3273 |
LINKS_ID INTEGER NOT NULL |
|
| 3274 |
); |
|
| 3275 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ORIGINALSOURCEBASE_EXTERNALLINK; |
|
| 3276 |
CREATE CACHED TABLE PUBLIC.ORIGINALSOURCEBASE_EXTERNALLINK_AUD( |
|
| 3277 |
REV INTEGER NOT NULL, |
|
| 3278 |
ORIGINALSOURCEBASE_ID INTEGER NOT NULL, |
|
| 3279 |
LINKS_ID INTEGER NOT NULL, |
|
| 3280 |
REVTYPE TINYINT |
|
| 3281 |
); |
|
| 3282 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ORIGINALSOURCEBASE_EXTERNALLINK_AUD; |
|
| 3271 | 3283 |
CREATE CACHED TABLE PUBLIC.ORIGINALSOURCEBASE_MARKER( |
| 3272 | 3284 |
ORIGINALSOURCEBASE_ID INTEGER NOT NULL, |
| 3273 | 3285 |
MARKERS_ID INTEGER NOT NULL |
Also available in: Unified diff
ref #6588 adapt test schema to originalsource.links and externallink.linktype