Revision ed3f9971
Added by Andreas Müller almost 6 years ago
cdmlib-test/src/main/resources/dbscripts/001-cdm.h2.sql | ||
---|---|---|
5127 | 5127 |
REVTYPE TINYINT |
5128 | 5128 |
); |
5129 | 5129 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_ANNOTATION_AUD; |
5130 |
CREATE CACHED TABLE PUBLIC.WORKINGSET_CREDIT( |
|
5131 |
WORKINGSET_ID INTEGER NOT NULL, |
|
5132 |
CREDITS_ID INTEGER NOT NULL, |
|
5133 |
SORTINDEX INTEGER NOT NULL |
|
5134 |
); |
|
5135 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_CREDIT; |
|
5136 |
CREATE CACHED TABLE PUBLIC.WORKINGSET_CREDIT_AUD( |
|
5137 |
REV INTEGER NOT NULL, |
|
5138 |
WORKINGSET_ID INTEGER NOT NULL, |
|
5139 |
CREDITS_ID INTEGER NOT NULL, |
|
5140 |
SORTINDEX INTEGER NOT NULL, |
|
5141 |
REVTYPE TINYINT |
|
5142 |
); |
|
5143 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_CREDIT_AUD; |
|
5130 | 5144 |
CREATE CACHED TABLE PUBLIC.WORKINGSET_DESCRIPTIONBASE( |
5131 | 5145 |
WORKINGSETS_ID INTEGER NOT NULL, |
5132 | 5146 |
DESCRIPTIONS_ID INTEGER NOT NULL |
... | ... | |
5139 | 5153 |
REVTYPE TINYINT |
5140 | 5154 |
); |
5141 | 5155 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_DESCRIPTIONBASE_AUD; |
5156 |
CREATE CACHED TABLE PUBLIC.WORKINGSET_EXTENSION( |
|
5157 |
WORKINGSET_ID INTEGER NOT NULL, |
|
5158 |
EXTENSIONS_ID INTEGER NOT NULL |
|
5159 |
); |
|
5160 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_EXTENSION; |
|
5161 |
CREATE CACHED TABLE PUBLIC.MEDIA_WORKINGSET_AUD( |
|
5162 |
REV INTEGER NOT NULL, |
|
5163 |
WORKINGSET_ID INTEGER NOT NULL, |
|
5164 |
EXTENSIONS_ID INTEGER NOT NULL, |
|
5165 |
REVTYPE TINYINT |
|
5166 |
); |
|
5167 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_EXTENSION_AUD; |
|
5168 |
CREATE CACHED TABLE PUBLIC.WORKINGSET_IDENTIFIER( |
|
5169 |
WORKINGSET_ID INTEGER NOT NULL, |
|
5170 |
IDENTIFIERS_ID INTEGER NOT NULL, |
|
5171 |
SORTINDEX INTEGER NOT NULL |
|
5172 |
); |
|
5173 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_IDENTIFIER; |
|
5174 |
CREATE CACHED TABLE PUBLIC.WORKINGSET_IDENTIFIER_AUD( |
|
5175 |
REV INTEGER NOT NULL, |
|
5176 |
WORKINGSET_ID INTEGER NOT NULL, |
|
5177 |
IDENTIFIERS_ID INTEGER NOT NULL, |
|
5178 |
SORTINDEX INTEGER NOT NULL, |
|
5179 |
REVTYPE TINYINT |
|
5180 |
); |
|
5181 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_IDENTIFIER_AUD; |
|
5142 | 5182 |
CREATE CACHED TABLE PUBLIC.WORKINGSET_MARKER( |
5143 | 5183 |
WORKINGSET_ID INTEGER NOT NULL, |
5144 | 5184 |
MARKERS_ID INTEGER NOT NULL |
... | ... | |
5163 | 5203 |
REVTYPE TINYINT |
5164 | 5204 |
); |
5165 | 5205 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_NAMEDAREA_AUD; |
5206 |
CREATE CACHED TABLE PUBLIC.WORKINGSET_ORIGINALSOURCEBASE( |
|
5207 |
WORKINGSET_ID INTEGER NOT NULL, |
|
5208 |
SOURCES_ID INTEGER NOT NULL |
|
5209 |
); |
|
5210 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_ORIGINALSOURCEBASE; |
|
5211 |
CREATE CACHED TABLE PUBLIC.WORKINGSET_ORIGINALSOURCEBASE_AUD( |
|
5212 |
REV INTEGER NOT NULL, |
|
5213 |
WORKINGSET_ID INTEGER NOT NULL, |
|
5214 |
SOURCES_ID INTEGER NOT NULL, |
|
5215 |
REVTYPE TINYINT |
|
5216 |
); |
|
5217 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_ORIGINALSOURCEBASE_AUD; |
|
5166 | 5218 |
CREATE CACHED TABLE PUBLIC.WORKINGSET_REPRESENTATION( |
5167 | 5219 |
WORKINGSET_ID INTEGER NOT NULL, |
5168 | 5220 |
REPRESENTATIONS_ID INTEGER NOT NULL |
... | ... | |
5175 | 5227 |
REVTYPE TINYINT |
5176 | 5228 |
); |
5177 | 5229 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_REPRESENTATION_AUD; |
5230 |
CREATE CACHED TABLE PUBLIC.WORKINGSET_RIGHTSINFO( |
|
5231 |
WORKINGSET_ID INTEGER NOT NULL, |
|
5232 |
RIGHTS_ID INTEGER NOT NULL |
|
5233 |
); |
|
5234 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_RIGHTSINFO; |
|
5235 |
CREATE CACHED TABLE PUBLIC.WORKINGSET_RIGHTSINFO_AUD( |
|
5236 |
REV INTEGER NOT NULL, |
|
5237 |
WORKINGSET_ID INTEGER NOT NULL, |
|
5238 |
RIGHTS_ID INTEGER NOT NULL, |
|
5239 |
REVTYPE TINYINT |
|
5240 |
); |
|
5241 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_RIGHTSINFO_AUD; |
|
5178 | 5242 |
CREATE CACHED TABLE PUBLIC.WORKINGSET_TAXONNODE( |
5179 | 5243 |
WORKINGSET_ID INTEGER NOT NULL, |
5180 | 5244 |
TAXONSUBTREEFILTER_ID INTEGER NOT NULL |
Also available in: Unified diff
fix #2335 Make WorkingSet IdentifiableEntity