Project

General

Profile

« Previous | Next » 

Revision ed3f9971

Added by Andreas Müller almost 6 years ago

fix #2335 Make WorkingSet IdentifiableEntity

View differences:

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