Project

General

Profile

Revision 2638be38

ID2638be38d1f2f957820ca1906df2aa1795123eb2
Parent 398bcf3e
Child 69f17e7e

Added by Andreas Müller over 4 years ago

migrate to hibernate 5 for cdmlib-services and cdmlib-ext #4716

  • (except for hibernate search tests)
  • including new spring-config structure

View differences:

.gitignore
95 95
cdmlib-services/src/test/resources/eu/etaxonomy/cdm/service/dataset.xsd
96 96
cdmlib-services/target
97 97
cdmlib-services/testTaxonNodeByNameComparator-dump.xml
98
cdmlib-test/.classpath
99
cdmlib-test/.project
100
cdmlib-test/.settings
101
cdmlib-test/bin
102
cdmlib-test/target
98 103
/latestChanges.patch
99 104
/target
100 105
/testANTLR
cdmlib-ext/pom.xml
25 25
  		<groupId>eu.etaxonomy</groupId>
26 26
  		<artifactId>cdmlib-services</artifactId>
27 27
  	</dependency>
28
  	<dependency>
29
  		<groupId>eu.etaxonomy</groupId>
30
  		<artifactId>cdmlib-persistence</artifactId>
31
  		<type>test-jar</type>
32
  		<scope>test</scope>
33
  		<version>${project.version}</version>
34
    </dependency>
35 28
    <dependency>
36
      <groupId>org.unitils</groupId>
37
      <artifactId>unitils-core</artifactId>
38
      <scope>test</scope>
39
    </dependency>
40
<!--     probably most unitis dependencies can be deleted from here -->
41
    <dependency>
42
      <groupId>org.unitils</groupId>
43
      <artifactId>unitils-database</artifactId>
44
      <exclusions>
45
      	<exclusion>
46
      		<groupId>commons-dbcp</groupId>
47
      		<artifactId>commons-dbcp</artifactId>
48
      	</exclusion>
49
      </exclusions>
50
      <scope>test</scope>
51
    </dependency>
52
    <dependency>
53
      <groupId>org.unitils</groupId>
54
      <artifactId>unitils-dbmaintainer</artifactId>
55
      <scope>test</scope>
56
    </dependency>
57
    <dependency>
58
      <groupId>org.unitils</groupId>
59
      <artifactId>unitils-dbunit</artifactId>
60
      <scope>test</scope>
61
    </dependency>
62
     <dependency>
63
      <groupId>org.unitils</groupId>
64
      <artifactId>unitils-easymock</artifactId>
65
      <scope>test</scope>
29
        <groupId>eu.etaxonomy</groupId>
30
        <artifactId>cdmlib-test</artifactId>
31
        <scope>test</scope>
32
        <version>${project.version}</version>
66 33
    </dependency>
67
    <dependency>
68
      <groupId>org.unitils</groupId>
69
      <artifactId>unitils-mock</artifactId>
70
      <scope>test</scope>
71
    </dependency>
72
    <dependency>
73
      <groupId>org.unitils</groupId>
74
      <artifactId>unitils-inject</artifactId>
75
      <scope>test</scope>
76
    </dependency>
77
     <dependency>
78
      <groupId>org.unitils</groupId>
79
      <artifactId>unitils-spring</artifactId>
80
      <scope>test</scope>
81
    </dependency>
82
    <dependency>
83
      <groupId>org.dbunit</groupId>
84
      <artifactId>dbunit</artifactId>
85
    </dependency> 
86
    <dependency>
87
      <groupId>xmlunit</groupId>
88
      <artifactId>xmlunit</artifactId>
89
  	</dependency>
34
<!--   	<dependency> -->
35
<!--   		<groupId>eu.etaxonomy</groupId> -->
36
<!--   		<artifactId>cdmlib-persistence</artifactId> -->
37
<!--   		<type>test-jar</type> -->
38
<!--   		<scope>test</scope> -->
39
<!--   		<version>${project.version}</version> -->
40
<!--     </dependency> -->
41
<!--     <dependency> -->
42
<!--       <groupId>org.unitils</groupId> -->
43
<!--       <artifactId>unitils-core</artifactId> -->
44
<!--       <scope>test</scope> -->
45
<!--     </dependency> -->
46
<!--     probably most unitils dependencies can be deleted from here -->
47
<!--     <dependency> -->
48
<!--       <groupId>org.unitils</groupId> -->
49
<!--       <artifactId>unitils-database</artifactId> -->
50
<!--       <exclusions> -->
51
<!--       	<exclusion> -->
52
<!--       		<groupId>commons-dbcp</groupId> -->
53
<!--       		<artifactId>commons-dbcp</artifactId> -->
54
<!--       	</exclusion> -->
55
<!--       </exclusions> -->
56
<!--       <scope>test</scope> -->
57
<!--     </dependency> -->
58
<!--     <dependency> -->
59
<!--       <groupId>org.unitils</groupId> -->
60
<!--       <artifactId>unitils-dbmaintainer</artifactId> -->
61
<!--       <scope>test</scope> -->
62
<!--     </dependency> -->
63
<!--     <dependency> -->
64
<!--       <groupId>org.unitils</groupId> -->
65
<!--       <artifactId>unitils-dbunit</artifactId> -->
66
<!--       <scope>test</scope> -->
67
<!--     </dependency> -->
68
<!--      <dependency> -->
69
<!--       <groupId>org.unitils</groupId> -->
70
<!--       <artifactId>unitils-easymock</artifactId> -->
71
<!--       <scope>test</scope> -->
72
<!--     </dependency> -->
73
<!--     <dependency> -->
74
<!--       <groupId>org.unitils</groupId> -->
75
<!--       <artifactId>unitils-mock</artifactId> -->
76
<!--       <scope>test</scope> -->
77
<!--     </dependency> -->
78
<!--     <dependency> -->
79
<!--       <groupId>org.unitils</groupId> -->
80
<!--       <artifactId>unitils-inject</artifactId> -->
81
<!--       <scope>test</scope> -->
82
<!--     </dependency> -->
83
<!--      <dependency> -->
84
<!--       <groupId>org.unitils</groupId> -->
85
<!--       <artifactId>unitils-spring</artifactId> -->
86
<!--       <scope>test</scope> -->
87
<!--     </dependency> -->
88
<!--     <dependency> -->
89
<!--       <groupId>org.dbunit</groupId> -->
90
<!--       <artifactId>dbunit</artifactId> -->
91
<!--     </dependency>  -->
92
<!--     <dependency> -->
93
<!--       <groupId>xmlunit</groupId> -->
94
<!--       <artifactId>xmlunit</artifactId> -->
95
<!--   	</dependency> -->
90 96

  
91 97
    <dependency>
92 98
	    <groupId>org.apache.httpcomponents</groupId>
......
94 100
	</dependency>
95 101
	<dependency>
96 102
        <groupId>net.sf.json-lib</groupId>
97
                <artifactId>json-lib</artifactId>
98
				<classifier>jdk15</classifier>
103
        <artifactId>json-lib</artifactId>
104
		<classifier>jdk15</classifier>
99 105
    </dependency>
100 106
    <dependency>
101 107
        <groupId>com.fasterxml.jackson.core</groupId>
cdmlib-ext/src/test/resources/dbscripts/001-cdm.h2.sql
1
SET CLUSTER '';
2
SET DEFAULT_TABLE_TYPE 0;
3
SET WRITE_DELAY 500;
4
SET DEFAULT_LOCK_TIMEOUT 2000;
5
SET CACHE_SIZE 16384;
6
;
7
CREATE USER IF NOT EXISTS EDIT PASSWORD '' ADMIN;
8
CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_10A55F0A_EE57_42DB_8046_6240A60AD0EC START WITH 4 BELONGS_TO_TABLE;
9

  
10

  
11
CREATE CACHED TABLE PUBLIC.ADDRESS(
12
    ID INTEGER NOT NULL,
13
    CREATED TIMESTAMP,
14
    UUID VARCHAR(36),
15
    UPDATED TIMESTAMP,
16
    LOCALITY VARCHAR(255),
17
    LOCATION_ERRORRADIUS INTEGER,
18
    LOCATION_LATITUDE DOUBLE,
19
    LOCATION_LONGITUDE DOUBLE,
20
    POBOX VARCHAR(255),
21
    POSTCODE VARCHAR(255),
22
    REGION VARCHAR(255),
23
    STREET VARCHAR(255),
24
    CREATEDBY_ID INTEGER,
25
    UPDATEDBY_ID INTEGER,
26
    COUNTRY_ID INTEGER,
27
    LOCATION_REFERENCESYSTEM_ID INTEGER
28
);
29
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ADDRESS;
30
CREATE CACHED TABLE PUBLIC.ADDRESS_AUD(
31
    ID INTEGER NOT NULL,
32
    REV INTEGER NOT NULL,
33
    REVTYPE TINYINT,
34
    CREATED TIMESTAMP,
35
    UUID VARCHAR(36),
36
    UPDATED TIMESTAMP,
37
    LOCALITY VARCHAR(255),
38
    LOCATION_ERRORRADIUS INTEGER,
39
    LOCATION_LATITUDE DOUBLE,
40
    LOCATION_LONGITUDE DOUBLE,
41
    POBOX VARCHAR(255),
42
    POSTCODE VARCHAR(255),
43
    REGION VARCHAR(255),
44
    STREET VARCHAR(255),
45
    CREATEDBY_ID INTEGER,
46
    UPDATEDBY_ID INTEGER,
47
    COUNTRY_ID INTEGER,
48
    LOCATION_REFERENCESYSTEM_ID INTEGER
49
);
50
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ADDRESS_AUD;
51
CREATE CACHED TABLE PUBLIC.AGENTBASE(
52
    DTYPE VARCHAR(31) NOT NULL,
53
    ID INTEGER NOT NULL,
54
    CREATED TIMESTAMP,
55
    UUID VARCHAR(36),
56
    UPDATED TIMESTAMP,
57
    LSID_AUTHORITY VARCHAR(255),
58
    LSID_LSID VARCHAR(255),
59
    LSID_NAMESPACE VARCHAR(255),
60
    LSID_OBJECT VARCHAR(255),
61
    LSID_REVISION VARCHAR(255),
62
    PROTECTEDTITLECACHE BOOLEAN NOT NULL,
63
    TITLECACHE VARCHAR(255),
64
	PROTECTEDCOLLECTORTITLECACHE BOOLEAN NOT NULL,
65
	COLLECTORTITLE VARCHAR(255),
66
	PROTECTEDNOMENCLATURALTITLECACHE BOOLEAN,
67
    NOMENCLATURALTITLE VARCHAR(255),
68
    CODE VARCHAR(255),
69
    NAME VARCHAR(255),
70
    FIRSTNAME VARCHAR(255),
71
    LASTNAME VARCHAR(255),
72
    LIFESPAN_END VARCHAR(255),
73
    LIFESPAN_FREETEXT VARCHAR(255),
74
    LIFESPAN_START VARCHAR(255),
75
    PREFIX VARCHAR(255),
76
    SUFFIX VARCHAR(255),
77
	HASMOREMEMBERS BOOLEAN,
78
    CREATEDBY_ID INTEGER,
79
    UPDATEDBY_ID INTEGER,
80
    ISPARTOF_ID INTEGER
81
);
82
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE;
83
CREATE INDEX PUBLIC.AGENTTITLECACHEINDEX ON PUBLIC.AGENTBASE(TITLECACHE);
84
CREATE CACHED TABLE PUBLIC.AGENTBASE_AUD(
85
    DTYPE VARCHAR(31) NOT NULL,
86
    ID INTEGER NOT NULL,
87
    REV INTEGER NOT NULL,
88
    REVTYPE TINYINT,
89
    CREATED TIMESTAMP,
90
    UUID VARCHAR(36),
91
    UPDATED TIMESTAMP,
92
    LSID_AUTHORITY VARCHAR(255),
93
    LSID_LSID VARCHAR(255),
94
    LSID_NAMESPACE VARCHAR(255),
95
    LSID_OBJECT VARCHAR(255),
96
    LSID_REVISION VARCHAR(255),
97
    PROTECTEDTITLECACHE BOOLEAN,
98
    TITLECACHE VARCHAR(255),
99
    PROTECTEDCOLLECTORTITLECACHE BOOLEAN NOT NULL,
100
	COLLECTORTITLE VARCHAR(255),
101
    NOMENCLATURALTITLE VARCHAR(255),
102
    PROTECTEDNOMENCLATURALTITLECACHE BOOLEAN,
103
    FIRSTNAME VARCHAR(255),
104
    LASTNAME VARCHAR(255),
105
    LIFESPAN_END VARCHAR(255),
106
    LIFESPAN_FREETEXT VARCHAR(255),
107
    LIFESPAN_START VARCHAR(255),
108
    PREFIX VARCHAR(255),
109
    SUFFIX VARCHAR(255),
110
    CODE VARCHAR(255),
111
    NAME VARCHAR(255),	
112
	HASMOREMEMBERS BOOLEAN,
113
    CREATEDBY_ID INTEGER,
114
    UPDATEDBY_ID INTEGER,
115
   	ISPARTOF_ID INTEGER,
116

  
117
);
118
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_AUD;
119
CREATE CACHED TABLE PUBLIC.AGENTBASE_ADDRESS(
120
    AGENTBASE_ID INTEGER NOT NULL,
121
    CONTACT_ADDRESSES_ID INTEGER NOT NULL
122
);
123
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_ADDRESS;
124
CREATE CACHED TABLE PUBLIC.AGENTBASE_ADDRESS_AUD(
125
    REV INTEGER NOT NULL,
126
    AGENTBASE_ID INTEGER NOT NULL,
127
    CONTACT_ADDRESSES_ID INTEGER NOT NULL,
128
    REVTYPE TINYINT
129
);
130
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_ADDRESS_AUD;
131
CREATE CACHED TABLE PUBLIC.AGENTBASE_AGENTBASE(
132
    AGENTBASE_ID INTEGER NOT NULL,
133
    TEAMMEMBERS_ID INTEGER NOT NULL,
134
    SORTINDEX INTEGER NOT NULL
135
);
136
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_AGENTBASE;
137
CREATE CACHED TABLE PUBLIC.AGENTBASE_AGENTBASE_AUD(
138
    REV INTEGER NOT NULL,
139
    AGENTBASE_ID INTEGER NOT NULL,
140
    TEAMMEMBERS_ID INTEGER NOT NULL,
141
    SORTINDEX INTEGER NOT NULL,
142
    REVTYPE TINYINT
143
);
144
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_AGENTBASE_AUD;
145
CREATE CACHED TABLE PUBLIC.AGENTBASE_ANNOTATION(
146
    AGENTBASE_ID INTEGER NOT NULL,
147
    ANNOTATIONS_ID INTEGER NOT NULL
148
);
149
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_ANNOTATION;
150
CREATE CACHED TABLE PUBLIC.AGENTBASE_ANNOTATION_AUD(
151
    REV INTEGER NOT NULL,
152
    AGENTBASE_ID INTEGER NOT NULL,
153
    ANNOTATIONS_ID INTEGER NOT NULL,
154
    REVTYPE TINYINT
155
);
156
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_ANNOTATION_AUD;
157
CREATE CACHED TABLE PUBLIC.AGENTBASE_CREDIT(
158
    AGENTBASE_ID INTEGER NOT NULL,
159
    CREDITS_ID INTEGER NOT NULL,
160
    SORTINDEX INTEGER NOT NULL
161
);
162
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_CREDIT;
163
CREATE CACHED TABLE PUBLIC.AGENTBASE_CREDIT_AUD(
164
    REV INTEGER NOT NULL,
165
    AGENTBASE_ID INTEGER NOT NULL,
166
    CREDITS_ID INTEGER NOT NULL,
167
    SORTINDEX INTEGER NOT NULL,
168
    REVTYPE TINYINT
169
);
170
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_CREDIT_AUD;
171
CREATE CACHED TABLE PUBLIC.AGENTBASE_DEFINEDTERMBASE(
172
    AGENTBASE_ID INTEGER NOT NULL,
173
    TYPES_ID INTEGER NOT NULL
174
);
175
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_DEFINEDTERMBASE;
176
CREATE CACHED TABLE PUBLIC.AGENTBASE_DEFINEDTERMBASE_AUD(
177
    REV INTEGER NOT NULL,
178
    AGENTBASE_ID INTEGER NOT NULL,
179
    TYPES_ID INTEGER NOT NULL,
180
    REVTYPE TINYINT
181
);
182
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_DEFINEDTERMBASE_AUD;
183
CREATE CACHED TABLE PUBLIC.AGENTBASE_EXTENSION(
184
    AGENTBASE_ID INTEGER NOT NULL,
185
    EXTENSIONS_ID INTEGER NOT NULL
186
);
187
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_EXTENSION;
188
CREATE CACHED TABLE PUBLIC.AGENTBASE_EXTENSION_AUD(
189
    REV INTEGER NOT NULL,
190
    AGENTBASE_ID INTEGER NOT NULL,
191
    EXTENSIONS_ID INTEGER NOT NULL,
192
    REVTYPE TINYINT
193
);
194
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_EXTENSION_AUD;
195
CREATE CACHED TABLE PUBLIC.AGENTBASE_IDENTIFIER(
196
    AGENTBASE_ID INTEGER NOT NULL,
197
    IDENTIFIERS_ID INTEGER NOT NULL,
198
    SORTINDEX INTEGER NOT NULL
199
);
200
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_IDENTIFIER;
201
CREATE CACHED TABLE PUBLIC.AGENTBASE_IDENTIFIER_AUD(
202
    REV INTEGER NOT NULL,
203
    AGENTBASE_ID INTEGER NOT NULL,
204
    IDENTIFIERS_ID INTEGER NOT NULL,
205
    SORTINDEX INTEGER NOT NULL,
206
    REVTYPE TINYINT
207
);
208
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_IDENTIFIER_AUD;
209
CREATE CACHED TABLE PUBLIC.AGENTBASE_MARKER(
210
    AGENTBASE_ID INTEGER NOT NULL,
211
    MARKERS_ID INTEGER NOT NULL
212
);
213
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_MARKER;
214
CREATE CACHED TABLE PUBLIC.AGENTBASE_MARKER_AUD(
215
    REV INTEGER NOT NULL,
216
    AGENTBASE_ID INTEGER NOT NULL,
217
    MARKERS_ID INTEGER NOT NULL,
218
    REVTYPE TINYINT
219
);
220
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_MARKER_AUD;
221
CREATE CACHED TABLE PUBLIC.AGENTBASE_MEDIA(
222
    AGENTBASE_ID INTEGER NOT NULL,
223
    MEDIA_ID INTEGER NOT NULL
224
);
225
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_MEDIA;
226
CREATE CACHED TABLE PUBLIC.AGENTBASE_MEDIA_AUD(
227
    REV INTEGER NOT NULL,
228
    AGENTBASE_ID INTEGER NOT NULL,
229
    MEDIA_ID INTEGER NOT NULL,
230
    REVTYPE TINYINT
231
);
232
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_MEDIA_AUD;
233
CREATE CACHED TABLE PUBLIC.AGENTBASE_ORIGINALSOURCEBASE(
234
    AGENTBASE_ID INTEGER NOT NULL,
235
    SOURCES_ID INTEGER NOT NULL
236
);
237
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_ORIGINALSOURCEBASE;
238
CREATE CACHED TABLE PUBLIC.AGENTBASE_ORIGINALSOURCEBASE_AUD(
239
    REV INTEGER NOT NULL,
240
    AGENTBASE_ID INTEGER NOT NULL,
241
    SOURCES_ID INTEGER NOT NULL,
242
    REVTYPE TINYINT
243
);
244
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_ORIGINALSOURCEBASE_AUD;
245
CREATE CACHED TABLE PUBLIC.AGENTBASE_RIGHTSINFO(
246
    AGENTBASE_ID INTEGER NOT NULL,
247
    RIGHTS_ID INTEGER NOT NULL
248
);
249
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_RIGHTSINFO;
250
CREATE CACHED TABLE PUBLIC.AGENTBASE_RIGHTSINFO_AUD(
251
    REV INTEGER NOT NULL,
252
    AGENTBASE_ID INTEGER NOT NULL,
253
    RIGHTS_ID INTEGER NOT NULL,
254
    REVTYPE TINYINT
255
);
256
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_RIGHTSINFO_AUD;
257
CREATE CACHED TABLE PUBLIC.AGENTBASE_CONTACT_EMAILADDRESSES(
258
    AGENTBASE_ID INTEGER NOT NULL,
259
    CONTACT_EMAILADDRESSES_ELEMENT VARCHAR(255)
260
);
261
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_CONTACT_EMAILADDRESSES;
262
CREATE CACHED TABLE PUBLIC.AGENTBASE_CONTACT_EMAILADDRESSES_AUD(
263
    REV INTEGER NOT NULL,
264
    AGENTBASE_ID INTEGER NOT NULL,
265
    CONTACT_EMAILADDRESSES_ELEMENT VARCHAR(255) NOT NULL,
266
    REVTYPE TINYINT
267
);
268
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_CONTACT_EMAILADDRESSES_AUD;
269
CREATE CACHED TABLE PUBLIC.AGENTBASE_CONTACT_FAXNUMBERS(
270
    AGENTBASE_ID INTEGER NOT NULL,
271
    CONTACT_FAXNUMBERS_ELEMENT VARCHAR(255)
272
);
273
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_CONTACT_FAXNUMBERS;
274
CREATE CACHED TABLE PUBLIC.AGENTBASE_CONTACT_FAXNUMBERS_AUD(
275
    REV INTEGER NOT NULL,
276
    AGENTBASE_ID INTEGER NOT NULL,
277
    CONTACT_FAXNUMBERS_ELEMENT VARCHAR(255) NOT NULL,
278
    REVTYPE TINYINT
279
);
280
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_CONTACT_FAXNUMBERS_AUD;
281
CREATE CACHED TABLE PUBLIC.AGENTBASE_CONTACT_PHONENUMBERS(
282
    AGENTBASE_ID INTEGER NOT NULL,
283
    CONTACT_PHONENUMBERS_ELEMENT VARCHAR(255)
284
);
285
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_CONTACT_PHONENUMBERS;
286
CREATE CACHED TABLE PUBLIC.AGENTBASE_CONTACT_PHONENUMBERS_AUD(
287
    REV INTEGER NOT NULL,
288
    AGENTBASE_ID INTEGER NOT NULL,
289
    CONTACT_PHONENUMBERS_ELEMENT VARCHAR(255) NOT NULL,
290
    REVTYPE TINYINT
291
);
292
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_CONTACT_PHONENUMBERS_AUD;
293
CREATE CACHED TABLE PUBLIC.AGENTBASE_CONTACT_URLS(
294
    AGENTBASE_ID INTEGER NOT NULL,
295
    CONTACT_URLS_ELEMENT VARCHAR(255)
296
);
297
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_CONTACT_URLS;
298
CREATE CACHED TABLE PUBLIC.AGENTBASE_CONTACT_URLS_AUD(
299
    REV INTEGER NOT NULL,
300
    AGENTBASE_ID INTEGER NOT NULL,
301
    CONTACT_URLS_ELEMENT VARCHAR(255) NOT NULL,
302
    REVTYPE TINYINT
303
);
304
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_CONTACT_URLS_AUD;
305

  
306
CREATE TABLE AMPLIFICATION (
307
     ID INTEGER NOT NULL,
308
     CREATED TIMESTAMP,
309
     UUID VARCHAR(36),
310
     UPDATED TIMESTAMP,
311
     DESCRIPTION VARCHAR(255),
312
     TIMEPERIOD_END VARCHAR(255),
313
     TIMEPERIOD_FREETEXT VARCHAR(255),
314
     TIMEPERIOD_START VARCHAR(255),
315
     ELECTROPHORESISVOLTAGE DOUBLE,
316
     GELCONCENTRATION DOUBLE,
317
     GELRUNNINGTIME DOUBLE,
318
     LADDERUSED VARCHAR(255),
319
	 LABELCACHE VARCHAR(255),
320
     CREATEDBY_ID INTEGER,
321
     UPDATEDBY_ID INTEGER,
322
     ACTOR_ID INTEGER,
323
     FORWARDPRIMER_ID INTEGER,
324
     DNAMARKER_ID INTEGER,
325
     PURIFICATION_ID INTEGER,
326
     INSTITUTION_ID INTEGER,
327
	 REVERSEPRIMER_ID INTEGER,
328
     PRIMARY KEY (ID)
329
);
330

  
331
CREATE TABLE AMPLIFICATION_AUD (
332
    ID INTEGER NOT NULL,
333
    REV INTEGER NOT NULL,
334
    REVTYPE TINYINT,
335
    CREATED TIMESTAMP,
336
    UUID VARCHAR(36),
337
    UPDATED TIMESTAMP,
338
    DESCRIPTION VARCHAR(255),
339
    TIMEPERIOD_END VARCHAR(255),
340
    TIMEPERIOD_FREETEXT VARCHAR(255),
341
    TIMEPERIOD_START VARCHAR(255),
342
    ELECTROPHORESISVOLTAGE DOUBLE,
343
    GELCONCENTRATION DOUBLE,
344
    GELRUNNINGTIME DOUBLE,
345
    LADDERUSED VARCHAR(255),
346
    LABELCACHE VARCHAR(255),
347
    CREATEDBY_ID INTEGER,
348
    UPDATEDBY_ID INTEGER,
349
    ACTOR_ID INTEGER,
350
    FORWARDPRIMER_ID INTEGER,
351
    DNAMARKER_ID INTEGER,
352
    PURIFICATION_ID INTEGER,
353
    INSTITUTION_ID INTEGER,
354
	REVERSEPRIMER_ID INTEGER,
355
    PRIMARY KEY (ID)
356
);
357

  
358
CREATE TABLE AMPLIFICATION_ANNOTATION (
359
    AMPLIFICATION_ID INTEGER NOT NULL,
360
    ANNOTATIONS_ID INTEGER NOT NULL,
361
    PRIMARY KEY (AMPLIFICATION_ID, ANNOTATIONS_ID)
362
);
363

  
364
CREATE TABLE AMPLIFICATION_ANNOTATION_AUD (
365
    REV INTEGER NOT NULL,
366
    REVTYPE TINYINT,
367
    AMPLIFICATION_ID INTEGER NOT NULL,
368
    ANNOTATIONS_ID INTEGER NOT NULL
369
);
370

  
371
CREATE TABLE AMPLIFICATION_MARKER (
372
    AMPLIFICATION_ID INTEGER NOT NULL,
373
    MARKERS_ID INTEGER NOT NULL,
374
    PRIMARY KEY (AMPLIFICATION_ID, MARKERS_ID)
375
);
376

  
377
CREATE TABLE AMPLIFICATION_MARKER_AUD (
378
    REV INTEGER NOT NULL,
379
    REVTYPE TINYINT,
380
    AMPLIFICATION_ID INTEGER NOT NULL,
381
    MARKERS_ID INTEGER NOT NULL,
382
);
383

  
384
CREATE TABLE AMPLIFICATIONRESULT (
385
     ID INTEGER NOT NULL,
386
     CREATED TIMESTAMP,
387
     UUID VARCHAR(36),
388
     UPDATED TIMESTAMP,
389
     SUCCESSTEXT VARCHAR(255),
390
     SUCCESSFUL BOOLEAN,
391
     CREATEDBY_ID INTEGER,
392
     UPDATEDBY_ID INTEGER,
393
     CLONING_ID INTEGER,
394
     DNASAMPLE_ID INTEGER,
395
	 AMPLIFICATION_ID INTEGER,
396
	 GELPHOTO_ID INTEGER,
397
     PRIMARY KEY (ID)
398
);
399

  
400
CREATE TABLE AMPLIFICATIONRESULT_AUD (
401
     ID INTEGER NOT NULL,
402
	 REV INTEGER NOT NULL,
403
     REVTYPE TINYINT,
404
     CREATED TIMESTAMP,
405
     UUID VARCHAR(36),
406
     UPDATED TIMESTAMP,
407
     SUCCESSTEXT VARCHAR(255),
408
     SUCCESSFUL BOOLEAN,
409
     CREATEDBY_ID INTEGER,
410
     UPDATEDBY_ID INTEGER,
411
     CLONING_ID INTEGER,
412
     DNASAMPLE_ID INTEGER,
413
     AMPLIFICATION_ID INTEGER,
414
	 GELPHOTO_ID INTEGER,
415
     PRIMARY KEY (ID)
416
);
417

  
418
CREATE TABLE AMPLIFICATIONRESULT_ANNOTATION (
419
    AMPLIFICATIONRESULT_ID INTEGER NOT NULL,
420
    ANNOTATIONS_ID INTEGER NOT NULL,
421
    PRIMARY KEY (AMPLIFICATIONRESULT_ID, ANNOTATIONS_ID)
422
);
423

  
424
CREATE TABLE AMPLIFICATIONRESULT_ANNOTATION_AUD (
425
    REV INTEGER NOT NULL,
426
    REVTYPE TINYINT,
427
    AMPLIFICATIONRESULT_ID INTEGER NOT NULL,
428
    ANNOTATIONS_ID INTEGER NOT NULL
429
);
430

  
431
CREATE TABLE AMPLIFICATIONRESULT_MARKER (
432
    AMPLIFICATIONRESULT_ID INTEGER NOT NULL,
433
    MARKERS_ID INTEGER NOT NULL,
434
    PRIMARY KEY (AMPLIFICATIONRESULT_ID, MARKERS_ID)
435
);
436

  
437
CREATE TABLE AMPLIFICATIONRESULT_MARKER_AUD (
438
    REV INTEGER NOT NULL,
439
    REVTYPE TINYINT,
440
    AMPLIFICATIONRESULT_ID INTEGER NOT NULL,
441
    MARKERS_ID INTEGER NOT NULL,
442
);
443

  
444

  
445
CREATE CACHED TABLE PUBLIC.ANNOTATION(
446
    ID INTEGER NOT NULL,
447
    CREATED TIMESTAMP,
448
    UUID VARCHAR(36),
449
    UPDATED TIMESTAMP,
450
    TEXT CLOB,
451
    ANNOTATEDOBJ_TYPE VARCHAR(255),
452
    ANNOTATEDOBJ_ID INTEGER NOT NULL,
453
    LINKBACKURI CLOB,
454
    CREATEDBY_ID INTEGER,
455
    UPDATEDBY_ID INTEGER,
456
    LANGUAGE_ID INTEGER,
457
    ANNOTATIONTYPE_ID INTEGER,
458
    COMMENTATOR_ID INTEGER
459
);
460
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ANNOTATION;
461
CREATE CACHED TABLE PUBLIC.ANNOTATION_AUD(
462
    ID INTEGER NOT NULL,
463
    REV INTEGER NOT NULL,
464
    REVTYPE TINYINT,
465
    CREATED TIMESTAMP,
466
    UUID VARCHAR(36),
467
    UPDATED TIMESTAMP,
468
    TEXT CLOB,
469
    LINKBACKURI CLOB,
470
    CREATEDBY_ID INTEGER,
471
    UPDATEDBY_ID INTEGER,
472
    LANGUAGE_ID INTEGER,
473
    ANNOTATIONTYPE_ID INTEGER,
474
    COMMENTATOR_ID INTEGER
475
);
476
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ANNOTATION_AUD;
477
CREATE CACHED TABLE PUBLIC.ANNOTATION_ANNOTATION(
478
    ANNOTATION_ID INTEGER NOT NULL,
479
    ANNOTATIONS_ID INTEGER NOT NULL
480
);
481
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ANNOTATION_ANNOTATION;
482
CREATE CACHED TABLE PUBLIC.ANNOTATION_ANNOTATION_AUD(
483
    REV INTEGER NOT NULL,
484
    ANNOTATION_ID INTEGER NOT NULL,
485
    ANNOTATIONS_ID INTEGER NOT NULL,
486
    REVTYPE TINYINT
487
);
488
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ANNOTATION_ANNOTATION_AUD;
489
CREATE CACHED TABLE PUBLIC.ANNOTATION_MARKER(
490
    ANNOTATION_ID INTEGER NOT NULL,
491
    MARKERS_ID INTEGER NOT NULL
492
);
493
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ANNOTATION_MARKER;
494
CREATE CACHED TABLE PUBLIC.ANNOTATION_MARKER_AUD(
495
    REV INTEGER NOT NULL,
496
    ANNOTATION_ID INTEGER NOT NULL,
497
    MARKERS_ID INTEGER NOT NULL,
498
    REVTYPE TINYINT
499
);
500
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ANNOTATION_MARKER_AUD;
501
CREATE CACHED TABLE PUBLIC.AUDITEVENT(
502
    REVISIONNUMBER INTEGER DEFAULT (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_10A55F0A_EE57_42DB_8046_6240A60AD0EC) NOT NULL NULL_TO_DEFAULT SEQUENCE PUBLIC.SYSTEM_SEQUENCE_10A55F0A_EE57_42DB_8046_6240A60AD0EC,
503
    DATE TIMESTAMP,
504
    TIMESTAMP BIGINT,
505
    UUID VARCHAR(255)
506
);
507
-- 3 +/- SELECT COUNT(*) FROM PUBLIC.AUDITEVENT;
508
CREATE CACHED TABLE PUBLIC.CDM_VIEW(
509
    ID INTEGER NOT NULL,
510
    CREATED TIMESTAMP,
511
    UUID VARCHAR(36),
512
    DESCRIPTION VARCHAR(255),
513
    NAME VARCHAR(255),
514
    CREATEDBY_ID INTEGER,
515
    REFERENCE_ID INTEGER
516
);
517
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CDM_VIEW;
518
CREATE CACHED TABLE PUBLIC.CDM_VIEW_CDM_VIEW(
519
    CDM_VIEW_ID INTEGER NOT NULL,
520
    SUPERVIEWS_ID INTEGER NOT NULL
521
);
522
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CDM_VIEW_CDM_VIEW;
523
CREATE CACHED TABLE PUBLIC.CDMMETADATA(
524
    ID INTEGER NOT NULL,
525
    CREATED TIMESTAMP,
526
    UUID VARCHAR(36),
527
    PROPERTYNAME INTEGER,
528
    VALUE VARCHAR(255),
529
    CREATEDBY_ID INTEGER
530
);
531
-- 3 +/- SELECT COUNT(*) FROM PUBLIC.CDMMETADATA;
532
CREATE CACHED TABLE PUBLIC.CDMPREFERENCE(
533
    KEY_SUBJECT VARCHAR(100),
534
    KEY_PREDICATE VARCHAR(100),
535
    VALUE VARCHAR(1023)
536
);
537
-- 3 +/- SELECT COUNT(*) FROM PUBLIC.CDMPREFERENCE;
538
CREATE CACHED TABLE PUBLIC.CLASSIFICATION(
539
    ID INTEGER NOT NULL,
540
    CREATED TIMESTAMP,
541
    UUID VARCHAR(36),
542
    UPDATED TIMESTAMP,
543
    LSID_AUTHORITY VARCHAR(255),
544
    LSID_LSID VARCHAR(255),
545
    LSID_NAMESPACE VARCHAR(255),
546
    LSID_OBJECT VARCHAR(255),
547
    LSID_REVISION VARCHAR(255),
548
    PROTECTEDTITLECACHE BOOLEAN NOT NULL,
549
    TITLECACHE VARCHAR(255),
550
    MICROREFERENCE VARCHAR(255),
551
    TIMEPERIOD_START VARCHAR(255),
552
    TIMEPERIOD_FREETEXT VARCHAR(255),
553
    TIMEPERIOD_END VARCHAR(255),
554
    CREATEDBY_ID INTEGER,
555
    UPDATEDBY_ID INTEGER,
556
    NAME_ID INTEGER,
557
    REFERENCE_ID INTEGER,
558
    ROOTNODE_ID INTEGER
559
);
560
-- 1 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION;
561
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_AUD(
562
    ID INTEGER NOT NULL,
563
    REV INTEGER NOT NULL,
564
    REVTYPE TINYINT,
565
    CREATED TIMESTAMP,
566
    UUID VARCHAR(36),
567
    UPDATED TIMESTAMP,
568
    LSID_AUTHORITY VARCHAR(255),
569
    LSID_LSID VARCHAR(255),
570
    LSID_NAMESPACE VARCHAR(255),
571
    LSID_OBJECT VARCHAR(255),
572
    LSID_REVISION VARCHAR(255),
573
    PROTECTEDTITLECACHE BOOLEAN,
574
    TITLECACHE VARCHAR(255),
575
    MICROREFERENCE VARCHAR(255),
576
    TIMEPERIOD_START VARCHAR(255),
577
    TIMEPERIOD_FREETEXT VARCHAR(255),
578
    TIMEPERIOD_END VARCHAR(255),
579
    CREATEDBY_ID INTEGER,
580
    UPDATEDBY_ID INTEGER,
581
    NAME_ID INTEGER,
582
    REFERENCE_ID INTEGER,
583
    ROOTNODE_ID INTEGER
584
);
585
-- 1 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_AUD;
586
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_ANNOTATION(
587
    CLASSIFICATION_ID INTEGER NOT NULL,
588
    ANNOTATIONS_ID INTEGER NOT NULL
589
);
590
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_ANNOTATION;
591
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_ANNOTATION_AUD(
592
    REV INTEGER NOT NULL,
593
    CLASSIFICATION_ID INTEGER NOT NULL,
594
    ANNOTATIONS_ID INTEGER NOT NULL,
595
    REVTYPE TINYINT
596
);
597
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_ANNOTATION_AUD;
598
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_CREDIT(
599
    CLASSIFICATION_ID INTEGER NOT NULL,
600
    CREDITS_ID INTEGER NOT NULL,
601
    SORTINDEX INTEGER NOT NULL
602
);
603
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_CREDIT;
604
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_CREDIT_AUD(
605
    REV INTEGER NOT NULL,
606
    CLASSIFICATION_ID INTEGER NOT NULL,
607
    CREDITS_ID INTEGER NOT NULL,
608
    SORTINDEX INTEGER NOT NULL,
609
    REVTYPE TINYINT
610
);
611
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_CREDIT_AUD;
612

  
613
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_DESCRIPTION(
614
    CLASSIFICATION_ID INTEGER NOT NULL,
615
   	DESCRIPTION_ID INTEGER NOT NULL,
616
   	DESCRIPTION_MAPKEY_ID INTEGER NOT NULL
617
);
618
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_DESCRIPTION;
619
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_DESCRIPTION_AUD(
620
    REV INTEGER NOT NULL,
621
    CLASSIFICATION_ID INTEGER NOT NULL,
622
    DESCRIPTION_ID INTEGER NOT NULL,
623
    DESCRIPTION_MAPKEY_ID INTEGER NOT NULL,
624
    REVTYPE TINYINT
625
);
626
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_DESCRIPTION_AUD;
627

  
628
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_EXTENSION(
629
    CLASSIFICATION_ID INTEGER NOT NULL,
630
    EXTENSIONS_ID INTEGER NOT NULL
631
);
632
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_EXTENSION;
633
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_EXTENSION_AUD(
634
    REV INTEGER NOT NULL,
635
    CLASSIFICATION_ID INTEGER NOT NULL,
636
    EXTENSIONS_ID INTEGER NOT NULL,
637
    REVTYPE TINYINT
638
);
639
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_EXTENSION_AUD;
640
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_GEOSCOPE(
641
    CLASSIFICATION_ID INTEGER NOT NULL,
642
    GEOSCOPES_ID INTEGER NOT NULL
643
);
644
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_GEOSCOPE;
645
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_GEOSCOPE_AUD(
646
    REV INTEGER NOT NULL,
647
    CLASSIFICATION_ID INTEGER NOT NULL,
648
    GEOSCOPES_ID INTEGER NOT NULL,
649
    REVTYPE TINYINT
650
);
651
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_GEOSCOPE_AUD;
652
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_IDENTIFIER(
653
    CLASSIFICATION_ID INTEGER NOT NULL,
654
    IDENTIFIERS_ID INTEGER NOT NULL,
655
    SORTINDEX INTEGER NOT NULL
656
);
657
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_IDENTIFIER;
658
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_IDENTIFIER_AUD(
659
    REV INTEGER NOT NULL,
660
    CLASSIFICATION_ID INTEGER NOT NULL,
661
    IDENTIFIERS_ID INTEGER NOT NULL,
662
    SORTINDEX INTEGER NOT NULL,
663
    REVTYPE TINYINT
664
);
665
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_IDENTIFIER_AUD;
666
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_MARKER(
667
    CLASSIFICATION_ID INTEGER NOT NULL,
668
    MARKERS_ID INTEGER NOT NULL
669
);
670
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_MARKER;
671
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_MARKER_AUD(
672
    REV INTEGER NOT NULL,
673
    CLASSIFICATION_ID INTEGER NOT NULL,
674
    MARKERS_ID INTEGER NOT NULL,
675
    REVTYPE TINYINT
676
);
677
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_MARKER_AUD;
678
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_ORIGINALSOURCEBASE(
679
    CLASSIFICATION_ID INTEGER NOT NULL,
680
    SOURCES_ID INTEGER NOT NULL
681
);
682
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_ORIGINALSOURCEBASE;
683
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_ORIGINALSOURCEBASE_AUD(
684
    REV INTEGER NOT NULL,
685
    CLASSIFICATION_ID INTEGER NOT NULL,
686
    SOURCES_ID INTEGER NOT NULL,
687
    REVTYPE TINYINT
688
);
689
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_ORIGINALSOURCEBASE_AUD;
690
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_RIGHTSINFO(
691
    CLASSIFICATION_ID INTEGER NOT NULL,
692
    RIGHTS_ID INTEGER NOT NULL
693
);
694
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_RIGHTSINFO;
695
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_RIGHTSINFO_AUD(
696
    REV INTEGER NOT NULL,
697
    CLASSIFICATION_ID INTEGER NOT NULL,
698
    RIGHTS_ID INTEGER NOT NULL,
699
    REVTYPE TINYINT
700
);
701
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_RIGHTSINFO_AUD;
702

  
703
CREATE CACHED TABLE PUBLIC.COLLECTION(
704
    ID INTEGER NOT NULL,
705
    CREATED TIMESTAMP,
706
    UUID VARCHAR(36),
707
    UPDATED TIMESTAMP,
708
    LSID_AUTHORITY VARCHAR(255),
709
    LSID_LSID VARCHAR(255),
710
    LSID_NAMESPACE VARCHAR(255),
711
    LSID_OBJECT VARCHAR(255),
712
    LSID_REVISION VARCHAR(255),
713
    PROTECTEDTITLECACHE BOOLEAN NOT NULL,
714
    TITLECACHE VARCHAR(255),
715
    CODE VARCHAR(255),
716
    CODESTANDARD VARCHAR(255),
717
    NAME VARCHAR(255),
718
    TOWNORLOCATION VARCHAR(255),
719
    CREATEDBY_ID INTEGER,
720
    UPDATEDBY_ID INTEGER,
721
    INSTITUTE_ID INTEGER,
722
    SUPERCOLLECTION_ID INTEGER
723
);
724
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION;
725
CREATE INDEX PUBLIC.COLLECTIONTITLECACHEINDEX ON PUBLIC.COLLECTION(TITLECACHE);
726
CREATE CACHED TABLE PUBLIC.COLLECTION_AUD(
727
    ID INTEGER NOT NULL,
728
    REV INTEGER NOT NULL,
729
    REVTYPE TINYINT,
730
    CREATED TIMESTAMP,
731
    UUID VARCHAR(36),
732
    UPDATED TIMESTAMP,
733
    LSID_AUTHORITY VARCHAR(255),
734
    LSID_LSID VARCHAR(255),
735
    LSID_NAMESPACE VARCHAR(255),
736
    LSID_OBJECT VARCHAR(255),
737
    LSID_REVISION VARCHAR(255),
738
    PROTECTEDTITLECACHE BOOLEAN,
739
    TITLECACHE VARCHAR(255),
740
    CODE VARCHAR(255),
741
    CODESTANDARD VARCHAR(255),
742
    NAME VARCHAR(255),
743
    TOWNORLOCATION VARCHAR(255),
744
    CREATEDBY_ID INTEGER,
745
    UPDATEDBY_ID INTEGER,
746
    INSTITUTE_ID INTEGER,
747
    SUPERCOLLECTION_ID INTEGER
748
);
749
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_AUD;
750
CREATE CACHED TABLE PUBLIC.COLLECTION_ANNOTATION(
751
    COLLECTION_ID INTEGER NOT NULL,
752
    ANNOTATIONS_ID INTEGER NOT NULL
753
);
754
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_ANNOTATION;
755
CREATE CACHED TABLE PUBLIC.COLLECTION_ANNOTATION_AUD(
756
    REV INTEGER NOT NULL,
757
    COLLECTION_ID INTEGER NOT NULL,
758
    ANNOTATIONS_ID INTEGER NOT NULL,
759
    REVTYPE TINYINT
760
);
761
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_ANNOTATION_AUD;
762
CREATE CACHED TABLE PUBLIC.COLLECTION_CREDIT(
763
    COLLECTION_ID INTEGER NOT NULL,
764
    CREDITS_ID INTEGER NOT NULL,
765
    SORTINDEX INTEGER NOT NULL
766
);
767
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_CREDIT;
768
CREATE CACHED TABLE PUBLIC.COLLECTION_CREDIT_AUD(
769
    REV INTEGER NOT NULL,
770
    COLLECTION_ID INTEGER NOT NULL,
771
    CREDITS_ID INTEGER NOT NULL,
772
    SORTINDEX INTEGER NOT NULL,
773
    REVTYPE TINYINT
774
);
775
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_CREDIT_AUD;
776
CREATE CACHED TABLE PUBLIC.COLLECTION_EXTENSION(
777
    COLLECTION_ID INTEGER NOT NULL,
778
    EXTENSIONS_ID INTEGER NOT NULL
779
);
780
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_EXTENSION;
781
CREATE CACHED TABLE PUBLIC.COLLECTION_EXTENSION_AUD(
782
    REV INTEGER NOT NULL,
783
    COLLECTION_ID INTEGER NOT NULL,
784
    EXTENSIONS_ID INTEGER NOT NULL,
785
    REVTYPE TINYINT
786
);
787
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_EXTENSION_AUD;
788
CREATE CACHED TABLE PUBLIC.COLLECTION_IDENTIFIER(
789
    COLLECTION_ID INTEGER NOT NULL,
790
    IDENTIFIERS_ID INTEGER NOT NULL,
791
    SORTINDEX INTEGER NOT NULL
792
);
793
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_IDENTIFIER;
794
CREATE CACHED TABLE PUBLIC.COLLECTION_IDENTIFIER_AUD(
795
    REV INTEGER NOT NULL,
796
    COLLECTION_ID INTEGER NOT NULL,
797
    IDENTIFIERS_ID INTEGER NOT NULL,
798
    SORTINDEX INTEGER NOT NULL,
799
    REVTYPE TINYINT
800
);
801
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_IDENTIFIER_AUD;
802
CREATE CACHED TABLE PUBLIC.COLLECTION_MARKER(
803
    COLLECTION_ID INTEGER NOT NULL,
804
    MARKERS_ID INTEGER NOT NULL
805
);
806
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_MARKER;
807
CREATE CACHED TABLE PUBLIC.COLLECTION_MARKER_AUD(
808
    REV INTEGER NOT NULL,
809
    COLLECTION_ID INTEGER NOT NULL,
810
    MARKERS_ID INTEGER NOT NULL,
811
    REVTYPE TINYINT
812
);
813
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_MARKER_AUD;
814
CREATE CACHED TABLE PUBLIC.COLLECTION_MEDIA(
815
    COLLECTION_ID INTEGER NOT NULL,
816
    MEDIA_ID INTEGER NOT NULL
817
);
818
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_MEDIA;
819
CREATE CACHED TABLE PUBLIC.COLLECTION_MEDIA_AUD(
820
    REV INTEGER NOT NULL,
821
    COLLECTION_ID INTEGER NOT NULL,
822
    MEDIA_ID INTEGER NOT NULL,
823
    REVTYPE TINYINT
824
);
825
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_MEDIA_AUD;
826
CREATE CACHED TABLE PUBLIC.COLLECTION_ORIGINALSOURCEBASE(
827
    COLLECTION_ID INTEGER NOT NULL,
828
    SOURCES_ID INTEGER NOT NULL
829
);
830
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_ORIGINALSOURCEBASE;
831
CREATE CACHED TABLE PUBLIC.COLLECTION_ORIGINALSOURCEBASE_AUD(
832
    REV INTEGER NOT NULL,
833
    COLLECTION_ID INTEGER NOT NULL,
834
    SOURCES_ID INTEGER NOT NULL,
835
    REVTYPE TINYINT
836
);
837
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_ORIGINALSOURCEBASE_AUD;
838
CREATE CACHED TABLE PUBLIC.COLLECTION_RIGHTSINFO(
839
    COLLECTION_ID INTEGER NOT NULL,
840
    RIGHTS_ID INTEGER NOT NULL
841
);
842
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_RIGHTSINFO;
843
CREATE CACHED TABLE PUBLIC.COLLECTION_RIGHTSINFO_AUD(
844
    REV INTEGER NOT NULL,
845
    COLLECTION_ID INTEGER NOT NULL,
846
    RIGHTS_ID INTEGER NOT NULL,
847
    REVTYPE TINYINT
848
);
849
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_RIGHTSINFO_AUD;
850
CREATE CACHED TABLE PUBLIC.CREDIT(
851
    ID INTEGER NOT NULL,
852
    CREATED TIMESTAMP,
853
    UUID VARCHAR(36),
854
    UPDATED TIMESTAMP,
855
    TEXT CLOB,
856
    ABBREVIATEDTEXT VARCHAR(255),
857
    CREATEDBY_ID INTEGER,
858
    UPDATEDBY_ID INTEGER,
859
    LANGUAGE_ID INTEGER,
860
    AGENT_ID INTEGER
861
);
862
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CREDIT;
863
CREATE CACHED TABLE PUBLIC.CREDIT_AUD(
864
    ID INTEGER NOT NULL,
865
    REV INTEGER NOT NULL,
866
    REVTYPE TINYINT,
867
    CREATED TIMESTAMP,
868
    UUID VARCHAR(36),
869
    UPDATED TIMESTAMP,
870
    TEXT CLOB,
871
    ABBREVIATEDTEXT VARCHAR(255),
872
    CREATEDBY_ID INTEGER,
873
    UPDATEDBY_ID INTEGER,
874
    LANGUAGE_ID INTEGER,
875
    AGENT_ID INTEGER
876
);
877
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CREDIT_AUD;
878
CREATE CACHED TABLE PUBLIC.CREDIT_ANNOTATION(
879
    CREDIT_ID INTEGER NOT NULL,
880
    ANNOTATIONS_ID INTEGER NOT NULL
881
);
882
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CREDIT_ANNOTATION;
883
CREATE CACHED TABLE PUBLIC.CREDIT_ANNOTATION_AUD(
884
    REV INTEGER NOT NULL,
885
    CREDIT_ID INTEGER NOT NULL,
886
    ANNOTATIONS_ID INTEGER NOT NULL,
887
    REVTYPE TINYINT
888
);
889
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CREDIT_ANNOTATION_AUD;
890
CREATE CACHED TABLE PUBLIC.CREDIT_MARKER(
891
    CREDIT_ID INTEGER NOT NULL,
892
    MARKERS_ID INTEGER NOT NULL
893
);
894
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CREDIT_MARKER;
895
CREATE CACHED TABLE PUBLIC.CREDIT_MARKER_AUD(
896
    REV INTEGER NOT NULL,
897
    CREDIT_ID INTEGER NOT NULL,
898
    MARKERS_ID INTEGER NOT NULL,
899
    REVTYPE TINYINT
900
);
901
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CREDIT_MARKER_AUD;
902
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE(
903
    DTYPE VARCHAR(31) NOT NULL,
904
    ID INTEGER NOT NULL,
905
    CREATED TIMESTAMP,
906
    UUID VARCHAR(36),
907
    UPDATED TIMESTAMP,
908
    TERMTYPE VARCHAR(4),
909
    IDINVOCABULARY VARCHAR(255),
910
    LSID_AUTHORITY VARCHAR(255),
911
    LSID_LSID VARCHAR(255),
912
    LSID_NAMESPACE VARCHAR(255),
913
    LSID_OBJECT VARCHAR(255),
914
    LSID_REVISION VARCHAR(255),
915
    PROTECTEDTITLECACHE BOOLEAN NOT NULL,
916
    TITLECACHE VARCHAR(255),
917
    URI CLOB,
918
    ISO639_1 VARCHAR(2),
919
    RANKCLASS VARCHAR(4) NOT NULL,
920
    ISTECHNICAL BOOLEAN,
921
    ABSENCETERM BOOLEAN NOT NULL,
922
    ORDERINDEX INTEGER,
923
    SYMMETRICAL BOOLEAN,
924
    TRANSITIVE BOOLEAN,
925
    DEFAULTCOLOR VARCHAR(255),
926
    SUPPORTSCATEGORICALDATA BOOLEAN,
927
    SUPPORTSCOMMONTAXONNAME BOOLEAN,
928
    SUPPORTSDISTRIBUTION BOOLEAN,
929
    SUPPORTSINDIVIDUALASSOCIATION BOOLEAN,
930
    SUPPORTSQUANTITATIVEDATA BOOLEAN,
931
    SUPPORTSTAXONINTERACTION BOOLEAN,
932
    SUPPORTSTEXTDATA BOOLEAN,
933
    POINTAPPROXIMATION_ERRORRADIUS INTEGER,
934
    POINTAPPROXIMATION_LATITUDE DOUBLE,
935
    POINTAPPROXIMATION_LONGITUDE DOUBLE,
936
    VALIDPERIOD_END VARCHAR(255),
937
    VALIDPERIOD_FREETEXT VARCHAR(255),
938
    VALIDPERIOD_START VARCHAR(255),
939
    ISO3166_A2 VARCHAR(2),
940
    CREATEDBY_ID INTEGER,
941
    UPDATEDBY_ID INTEGER,
942
    KINDOF_ID INTEGER,
943
    PARTOF_ID INTEGER,
944
    VOCABULARY_ID INTEGER,
945
    LEVEL_ID INTEGER,
946
    POINTAPPROXIMATION_REFERENCESYSTEM_ID INTEGER,
947
    SHAPE_ID INTEGER,
948
    TYPE_ID INTEGER
949
);
950
-- 2084 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE;
951
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_AUD(
952
    DTYPE VARCHAR(31) NOT NULL,
953
    ID INTEGER NOT NULL,
954
    REV INTEGER NOT NULL,
955
    REVTYPE TINYINT,
956
    CREATED TIMESTAMP,
957
    UUID VARCHAR(36),
958
    UPDATED TIMESTAMP,
959
    TERMTYPE VARCHAR(4),
960
    IDINVOCABULARY VARCHAR(255),
961
    LSID_AUTHORITY VARCHAR(255),
962
    LSID_LSID VARCHAR(255),
963
    LSID_NAMESPACE VARCHAR(255),
964
    LSID_OBJECT VARCHAR(255),
965
    LSID_REVISION VARCHAR(255),
966
    PROTECTEDTITLECACHE BOOLEAN,
967
    TITLECACHE VARCHAR(255),
968
    URI CLOB,
969
    CREATEDBY_ID INTEGER,
970
    UPDATEDBY_ID INTEGER,
971
    KINDOF_ID INTEGER,
972
    PARTOF_ID INTEGER,
973
    VOCABULARY_ID INTEGER,
974
    ORDERINDEX INTEGER,
975
    ISO639_1 VARCHAR(2),
976
    RANKCLASS VARCHAR(4) NOT NULL,
977
    SUPPORTSCATEGORICALDATA BOOLEAN,
978
    SUPPORTSCOMMONTAXONNAME BOOLEAN,
979
    SUPPORTSDISTRIBUTION BOOLEAN,
980
    SUPPORTSINDIVIDUALASSOCIATION BOOLEAN,
981
    SUPPORTSQUANTITATIVEDATA BOOLEAN,
982
    SUPPORTSTAXONINTERACTION BOOLEAN,
983
    SUPPORTSTEXTDATA BOOLEAN,
984
    ISTECHNICAL BOOLEAN,
985
    ABSENCETERM BOOLEAN NOT NULL,
986
    DEFAULTCOLOR VARCHAR(255),
987
    POINTAPPROXIMATION_ERRORRADIUS INTEGER,
988
    POINTAPPROXIMATION_LATITUDE DOUBLE,
989
    POINTAPPROXIMATION_LONGITUDE DOUBLE,
990
    VALIDPERIOD_END VARCHAR(255),
991
    VALIDPERIOD_FREETEXT VARCHAR(255),
992
    VALIDPERIOD_START VARCHAR(255),
993
    LEVEL_ID INTEGER,
994
    POINTAPPROXIMATION_REFERENCESYSTEM_ID INTEGER,
995
    SHAPE_ID INTEGER,
996
    TYPE_ID INTEGER,
997
    ISO3166_A2 VARCHAR(2),
998
    SYMMETRICAL BOOLEAN,
999
    TRANSITIVE BOOLEAN
1000
);
1001
-- 2084 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_AUD;
1002
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_ANNOTATION(
1003
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
1004
    ANNOTATIONS_ID INTEGER NOT NULL
1005
);
1006
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_ANNOTATION;
1007
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_ANNOTATION_AUD(
1008
    REV INTEGER NOT NULL,
1009
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
1010
    ANNOTATIONS_ID INTEGER NOT NULL,
1011
    REVTYPE TINYINT
1012
);
1013
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_ANNOTATION_AUD;
1014
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_CONTINENT(
1015
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
1016
    CONTINENTS_ID INTEGER NOT NULL
1017
);
1018
-- 242 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_CONTINENT;
1019
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_CONTINENT_AUD(
1020
    REV INTEGER NOT NULL,
1021
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
1022
    CONTINENTS_ID INTEGER NOT NULL,
1023
    REVTYPE TINYINT
1024
);
1025
-- 242 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_CONTINENT_AUD;
1026
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_CREDIT(
1027
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
1028
    CREDITS_ID INTEGER NOT NULL,
1029
    SORTINDEX INTEGER NOT NULL
1030
);
1031
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_CREDIT;
1032
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_CREDIT_AUD(
1033
    REV INTEGER NOT NULL,
1034
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
1035
    CREDITS_ID INTEGER NOT NULL,
1036
    SORTINDEX INTEGER NOT NULL,
1037
    REVTYPE TINYINT
1038
);
1039
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_CREDIT_AUD;
1040
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_EXTENSION(
1041
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
1042
    EXTENSIONS_ID INTEGER NOT NULL
1043
);
1044
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_EXTENSION;
1045
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_EXTENSION_AUD(
1046
    REV INTEGER NOT NULL,
1047
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
1048
    EXTENSIONS_ID INTEGER NOT NULL,
1049
    REVTYPE TINYINT
1050
);
1051
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_EXTENSION_AUD;
1052
                                                                                                     
1053
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_IDENTIFIER(
1054
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
1055
    IDENTIFIERS_ID INTEGER NOT NULL,
1056
    SORTINDEX INTEGER NOT NULL
1057
);
1058
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_IDENTIFIER;
1059
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_IDENTIFIER_AUD(
1060
    REV INTEGER NOT NULL,
1061
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
1062
    IDENTIFIERS_ID INTEGER NOT NULL,
1063
    SORTINDEX INTEGER NOT NULL,
1064
    REVTYPE TINYINT
1065
);
1066
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_IDENTIFIER_AUD;
1067

  
1068
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_MARKER(
1069
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
1070
    MARKERS_ID INTEGER NOT NULL
1071
);
1072
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_MARKER;
1073
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_MARKER_AUD(
1074
    REV INTEGER NOT NULL,
1075
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
1076
    MARKERS_ID INTEGER NOT NULL,
1077
    REVTYPE TINYINT
1078
);
1079
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_MARKER_AUD;
1080
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_MEASUREMENTUNIT(
1081
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
1082
    RECOMMENDEDMEASUREMENTUNITS_ID INTEGER NOT NULL
1083
);
1084
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_MEASUREMENTUNIT;
1085
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_MEASUREMENTUNIT_AUD(
1086
    REV INTEGER NOT NULL,
1087
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
1088
    RECOMMENDEDMEASUREMENTUNITS_ID INTEGER NOT NULL,
1089
    REVTYPE TINYINT
1090
);
1091
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_MEASUREMENTUNIT_AUD;
1092
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_MEDIA(
1093
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
1094
    MEDIA_ID INTEGER NOT NULL
1095
);
1096
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_MEDIA;
1097
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_MEDIA_AUD(
1098
    REV INTEGER NOT NULL,
1099
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
1100
    MEDIA_ID INTEGER NOT NULL,
1101
    REVTYPE TINYINT
1102
);
1103
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_MEDIA_AUD;
1104
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_ORIGINALSOURCEBASE(
1105
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
1106
    SOURCES_ID INTEGER NOT NULL
1107
);
1108
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_ORIGINALSOURCEBASE;
1109
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_ORIGINALSOURCEBASE_AUD(
1110
    REV INTEGER NOT NULL,
1111
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
1112
    SOURCES_ID INTEGER NOT NULL,
1113
    REVTYPE TINYINT
1114
);
1115
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_ORIGINALSOURCEBASE_AUD;
1116
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_RECOMMENDEDMODIFIERENUMERATION(
1117
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
1118
    RECOMMENDEDMODIFIERENUMERATION_ID INTEGER NOT NULL
1119
);
1120
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_RECOMMENDEDMODIFIERENUMERATION;
1121
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_RECOMMENDEDMODIFIERENUMERATION_AUD(
1122
    REV INTEGER NOT NULL,
1123
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
1124
    RECOMMENDEDMODIFIERENUMERATION_ID INTEGER NOT NULL,
1125
    REVTYPE TINYINT
1126
);
1127
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_RECOMMENDEDMODIFIERENUMERATION_AUD;
1128
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_REPRESENTATION(
1129
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
1130
    REPRESENTATIONS_ID INTEGER NOT NULL
1131
);
1132
-- 2084 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_REPRESENTATION;
1133
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_REPRESENTATION_AUD(
1134
    REV INTEGER NOT NULL,
1135
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
1136
    REPRESENTATIONS_ID INTEGER NOT NULL,
1137
    REVTYPE TINYINT
1138
);
1139
-- 2084 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_REPRESENTATION_AUD;
1140
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_RIGHTSINFO(
1141
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
1142
    RIGHTS_ID INTEGER NOT NULL
1143
);
1144
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_RIGHTSINFO;
1145
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_RIGHTSINFO_AUD(
1146
    REV INTEGER NOT NULL,
1147
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
1148
    RIGHTS_ID INTEGER NOT NULL,
1149
    REVTYPE TINYINT
1150
);
1151
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_RIGHTSINFO_AUD;
1152
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_STATISTICALMEASURE(
1153
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
1154
    RECOMMENDEDSTATISTICALMEASURES_ID INTEGER NOT NULL
1155
);
1156
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_STATISTICALMEASURE;
1157
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_STATISTICALMEASURE_AUD(
1158
    REV INTEGER NOT NULL,
1159
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
1160
    RECOMMENDEDSTATISTICALMEASURES_ID INTEGER NOT NULL,
1161
    REVTYPE TINYINT
1162
);
1163
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_STATISTICALMEASURE_AUD;
1164
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_SUPPORTEDCATEGORICALENUMERATION(
1165
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
1166
    SUPPORTEDCATEGORICALENUMERATIONS_ID INTEGER NOT NULL
1167
);
1168
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_SUPPORTEDCATEGORICALENUMERATION;
1169
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_SUPPORTEDCATEGORICALENUMERATION_AUD(
1170
    REV INTEGER NOT NULL,
1171
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
1172
    SUPPORTEDCATEGORICALENUMERATIONS_ID INTEGER NOT NULL,
1173
    REVTYPE TINYINT
1174
);
1175
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_SUPPORTEDCATEGORICALENUMERATION_AUD;
1176
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_COUNTRY(
1177
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
1178
    COUNTRIES_ID INTEGER NOT NULL
1179
);
1180
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_COUNTRY;
1181
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_COUNTRY_AUD(
1182
    REV INTEGER NOT NULL,
1183
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
1184
    COUNTRIES_ID INTEGER NOT NULL,
1185
    REVTYPE TINYINT
1186
);
1187
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_COUNTRY_AUD;
1188
CREATE CACHED TABLE PUBLIC.DERIVATIONEVENT(
1189
    ID INTEGER NOT NULL,
1190
    CREATED TIMESTAMP,
1191
    UUID VARCHAR(36),
1192
    UPDATED TIMESTAMP,
1193
    DESCRIPTION VARCHAR(255),
1194
    TIMEPERIOD_END VARCHAR(255),
1195
    TIMEPERIOD_FREETEXT VARCHAR(255),
1196
    TIMEPERIOD_START VARCHAR(255),
1197
    CREATEDBY_ID INTEGER,
1198
    UPDATEDBY_ID INTEGER,
1199
    ACTOR_ID INTEGER,
1200
    INSTITUTION_ID INTEGER,
1201
	TYPE_ID INTEGER
1202
);
1203
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DERIVATIONEVENT;
1204
CREATE CACHED TABLE PUBLIC.DERIVATIONEVENT_AUD(
1205
    ID INTEGER NOT NULL,
1206
    REV INTEGER NOT NULL,
1207
    REVTYPE TINYINT,
1208
    CREATED TIMESTAMP,
1209
    UUID VARCHAR(36),
1210
    UPDATED TIMESTAMP,
1211
    DESCRIPTION VARCHAR(255),
1212
    TIMEPERIOD_END VARCHAR(255),
1213
    TIMEPERIOD_FREETEXT VARCHAR(255),
1214
    TIMEPERIOD_START VARCHAR(255),
1215
    CREATEDBY_ID INTEGER,
1216
    UPDATEDBY_ID INTEGER,
1217
    ACTOR_ID INTEGER,
1218
    INSTITUTION_ID INTEGER,
1219
	TYPE_ID INTEGER
1220
);
1221
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DERIVATIONEVENT_AUD;
1222
CREATE CACHED TABLE PUBLIC.DERIVATIONEVENT_ANNOTATION(
1223
    DERIVATIONEVENT_ID INTEGER NOT NULL,
1224
    ANNOTATIONS_ID INTEGER NOT NULL
1225
);
1226
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DERIVATIONEVENT_ANNOTATION;
1227
CREATE CACHED TABLE PUBLIC.DERIVATIONEVENT_ANNOTATION_AUD(
1228
    REV INTEGER NOT NULL,
1229
    DERIVATIONEVENT_ID INTEGER NOT NULL,
1230
    ANNOTATIONS_ID INTEGER NOT NULL,
1231
    REVTYPE TINYINT
1232
);
1233
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DERIVATIONEVENT_ANNOTATION_AUD;
1234
CREATE CACHED TABLE PUBLIC.DERIVATIONEVENT_MARKER(
1235
    DERIVATIONEVENT_ID INTEGER NOT NULL,
1236
    MARKERS_ID INTEGER NOT NULL
1237
);
1238
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DERIVATIONEVENT_MARKER;
1239
CREATE CACHED TABLE PUBLIC.DERIVATIONEVENT_MARKER_AUD(
1240
    REV INTEGER NOT NULL,
1241
    DERIVATIONEVENT_ID INTEGER NOT NULL,
1242
    MARKERS_ID INTEGER NOT NULL,
1243
    REVTYPE TINYINT
1244
);
1245
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DERIVATIONEVENT_MARKER_AUD;
1246
CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE(
1247
    DTYPE VARCHAR(31) NOT NULL,
1248
    ID INTEGER NOT NULL,
1249
    CREATED TIMESTAMP,
1250
    UUID VARCHAR(36),
1251
    UPDATED TIMESTAMP,
1252
    LSID_AUTHORITY VARCHAR(255),
1253
    LSID_LSID VARCHAR(255),
1254
    LSID_NAMESPACE VARCHAR(255),
1255
    LSID_OBJECT VARCHAR(255),
1256
    LSID_REVISION VARCHAR(255),
1257
    PROTECTEDTITLECACHE BOOLEAN NOT NULL,
1258
    TITLECACHE VARCHAR(255),
1259
    IMAGEGALLERY BOOLEAN NOT NULL,
1260
    CREATEDBY_ID INTEGER,
1261
    UPDATEDBY_ID INTEGER,
1262
    SPECIMEN_ID INTEGER,
1263
    TAXON_ID INTEGER,
1264
    TAXONNAME_ID INTEGER
1265
);
1266
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE;
1267
CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_AUD(
1268
    DTYPE VARCHAR(31) NOT NULL,
1269
    ID INTEGER NOT NULL,
1270
    REV INTEGER NOT NULL,
1271
    REVTYPE TINYINT,
1272
    CREATED TIMESTAMP,
1273
    UUID VARCHAR(36),
1274
    UPDATED TIMESTAMP,
1275
    LSID_AUTHORITY VARCHAR(255),
1276
    LSID_LSID VARCHAR(255),
1277
    LSID_NAMESPACE VARCHAR(255),
1278
    LSID_OBJECT VARCHAR(255),
1279
    LSID_REVISION VARCHAR(255),
1280
    PROTECTEDTITLECACHE BOOLEAN,
1281
    TITLECACHE VARCHAR(255),
1282
    IMAGEGALLERY BOOLEAN,
1283
    CREATEDBY_ID INTEGER,
1284
    UPDATEDBY_ID INTEGER,
1285
    SPECIMEN_ID INTEGER,
1286
    TAXON_ID INTEGER,
1287
    TAXONNAME_ID INTEGER
1288
);
1289
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_AUD;
1290
CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_ANNOTATION(
1291
    DESCRIPTIONBASE_ID INTEGER NOT NULL,
1292
    ANNOTATIONS_ID INTEGER NOT NULL
1293
);
1294
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_ANNOTATION;
1295
CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_ANNOTATION_AUD(
1296
    REV INTEGER NOT NULL,
1297
    DESCRIPTIONBASE_ID INTEGER NOT NULL,
1298
    ANNOTATIONS_ID INTEGER NOT NULL,
1299
    REVTYPE TINYINT
1300
);
1301
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_ANNOTATION_AUD;
1302
CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_CREDIT(
1303
    DESCRIPTIONBASE_ID INTEGER NOT NULL,
1304
    CREDITS_ID INTEGER NOT NULL,
1305
    SORTINDEX INTEGER NOT NULL
1306
);
1307
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_CREDIT;
1308
CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_CREDIT_AUD(
1309
    REV INTEGER NOT NULL,
1310
    DESCRIPTIONBASE_ID INTEGER NOT NULL,
1311
    CREDITS_ID INTEGER NOT NULL,
1312
    SORTINDEX INTEGER NOT NULL,
1313
    REVTYPE TINYINT
1314
);
1315
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_CREDIT_AUD;
1316
CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_EXTENSION(
1317
    DESCRIPTIONBASE_ID INTEGER NOT NULL,
1318
    EXTENSIONS_ID INTEGER NOT NULL
1319
);
1320
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_EXTENSION;
... This diff was truncated because it exceeds the maximum size that can be displayed.

Also available in: Unified diff

Add picture from clipboard (Maximum size: 40 MB)