Project

General

Profile

Statistics
| Branch: | Tag: | Revision:

cdmlib / cdmlib-test / src / main / resources / dbscripts / 001-cdm.h2.sql @ db727ae6

History | View | Annotate | Download (370 KB)

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
        INITIALS VARCHAR(50),
72
    LASTNAME VARCHAR(255),
73
    LIFESPAN_END VARCHAR(255),
74
    LIFESPAN_FREETEXT VARCHAR(255),
75
    LIFESPAN_START VARCHAR(255),
76
    PREFIX VARCHAR(255),
77
    SUFFIX VARCHAR(255),
78
        HASMOREMEMBERS BOOLEAN,
79
    CREATEDBY_ID INTEGER,
80
    UPDATEDBY_ID INTEGER,
81
    ISPARTOF_ID INTEGER
82
);
83
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE;
84
CREATE INDEX PUBLIC.AGENTTITLECACHEINDEX ON PUBLIC.AGENTBASE(TITLECACHE);
85
CREATE CACHED TABLE PUBLIC.AGENTBASE_AUD(
86
    DTYPE VARCHAR(31) NOT NULL,
87
    ID INTEGER NOT NULL,
88
    REV INTEGER NOT NULL,
89
    REVTYPE TINYINT,
90
    CREATED TIMESTAMP,
91
    UUID VARCHAR(36),
92
    UPDATED TIMESTAMP,
93
    LSID_AUTHORITY VARCHAR(255),
94
    LSID_LSID VARCHAR(255),
95
    LSID_NAMESPACE VARCHAR(255),
96
    LSID_OBJECT VARCHAR(255),
97
    LSID_REVISION VARCHAR(255),
98
    PROTECTEDTITLECACHE BOOLEAN,
99
    TITLECACHE VARCHAR(255),
100
    PROTECTEDCOLLECTORTITLECACHE BOOLEAN NOT NULL,
101
        COLLECTORTITLE VARCHAR(255),
102
    NOMENCLATURALTITLE VARCHAR(255),
103
    PROTECTEDNOMENCLATURALTITLECACHE BOOLEAN,
104
    FIRSTNAME VARCHAR(255),
105
    INITIALS VARCHAR(50),
106
        LASTNAME VARCHAR(255),
107
    LIFESPAN_END VARCHAR(255),
108
    LIFESPAN_FREETEXT VARCHAR(255),
109
    LIFESPAN_START VARCHAR(255),
110
    PREFIX VARCHAR(255),
111
    SUFFIX VARCHAR(255),
112
    CODE VARCHAR(255),
113
    NAME VARCHAR(255),        
114
        HASMOREMEMBERS BOOLEAN,
115
    CREATEDBY_ID INTEGER,
116
    UPDATEDBY_ID INTEGER,
117
           ISPARTOF_ID INTEGER,
118

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

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

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

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

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

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

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

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

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

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

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

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

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

    
446

    
447
CREATE CACHED TABLE PUBLIC.ANNOTATION(
448
    ID INTEGER NOT NULL,
449
    CREATED TIMESTAMP,
450
    UUID VARCHAR(36),
451
    UPDATED TIMESTAMP,
452
    TEXT CLOB,
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 VARCHAR(20),
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
        ALLOWOVERRIDE BOOLEAN NOT NULL
537
);
538
-- 3 +/- SELECT COUNT(*) FROM PUBLIC.CDMPREFERENCE;
539
CREATE CACHED TABLE PUBLIC.CLASSIFICATION(
540
    ID INTEGER NOT NULL,
541
    CREATED TIMESTAMP,
542
    UUID VARCHAR(36),
543
    UPDATED TIMESTAMP,
544
    LSID_AUTHORITY VARCHAR(255),
545
    LSID_LSID VARCHAR(255),
546
    LSID_NAMESPACE VARCHAR(255),
547
    LSID_OBJECT VARCHAR(255),
548
    LSID_REVISION VARCHAR(255),
549
    PROTECTEDTITLECACHE BOOLEAN NOT NULL,
550
    TITLECACHE VARCHAR(255),
551
    MICROREFERENCE VARCHAR(255),
552
    TIMEPERIOD_START VARCHAR(255),
553
    TIMEPERIOD_FREETEXT VARCHAR(255),
554
    TIMEPERIOD_END VARCHAR(255),
555
    CREATEDBY_ID INTEGER,
556
    UPDATEDBY_ID INTEGER,
557
    NAME_ID INTEGER,
558
    REFERENCE_ID INTEGER,
559
    ROOTNODE_ID INTEGER
560
);
561
-- 1 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION;
562
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_AUD(
563
    ID INTEGER NOT NULL,
564
    REV INTEGER NOT NULL,
565
    REVTYPE TINYINT,
566
    CREATED TIMESTAMP,
567
    UUID VARCHAR(36),
568
    UPDATED TIMESTAMP,
569
    LSID_AUTHORITY VARCHAR(255),
570
    LSID_LSID VARCHAR(255),
571
    LSID_NAMESPACE VARCHAR(255),
572
    LSID_OBJECT VARCHAR(255),
573
    LSID_REVISION VARCHAR(255),
574
    PROTECTEDTITLECACHE BOOLEAN,
575
    TITLECACHE VARCHAR(255),
576
    MICROREFERENCE VARCHAR(255),
577
    TIMEPERIOD_START VARCHAR(255),
578
    TIMEPERIOD_FREETEXT VARCHAR(255),
579
    TIMEPERIOD_END VARCHAR(255),
580
    CREATEDBY_ID INTEGER,
581
    UPDATEDBY_ID INTEGER,
582
    NAME_ID INTEGER,
583
    REFERENCE_ID INTEGER,
584
    ROOTNODE_ID INTEGER
585
);
586
-- 1 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_AUD;
587
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_ANNOTATION(
588
    CLASSIFICATION_ID INTEGER NOT NULL,
589
    ANNOTATIONS_ID INTEGER NOT NULL
590
);
591
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_ANNOTATION;
592
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_ANNOTATION_AUD(
593
    REV INTEGER NOT NULL,
594
    CLASSIFICATION_ID INTEGER NOT NULL,
595
    ANNOTATIONS_ID INTEGER NOT NULL,
596
    REVTYPE TINYINT
597
);
598
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_ANNOTATION_AUD;
599
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_CREDIT(
600
    CLASSIFICATION_ID INTEGER NOT NULL,
601
    CREDITS_ID INTEGER NOT NULL,
602
    SORTINDEX INTEGER NOT NULL
603
);
604
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_CREDIT;
605
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_CREDIT_AUD(
606
    REV INTEGER NOT NULL,
607
    CLASSIFICATION_ID INTEGER NOT NULL,
608
    CREDITS_ID INTEGER NOT NULL,
609
    SORTINDEX INTEGER NOT NULL,
610
    REVTYPE TINYINT
611
);
612
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_CREDIT_AUD;
613

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

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

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

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

    
1342
CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_IDENTIFIER(
1343
    DESCRIPTIONBASE_ID INTEGER NOT NULL,
1344
    IDENTIFIERS_ID INTEGER NOT NULL,
1345
    SORTINDEX INTEGER NOT NULL
1346
);
1347
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_IDENTIFIER;
1348
CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_IDENTIFIER_AUD(
1349
    REV INTEGER NOT NULL,
1350
    DESCRIPTIONBASE_ID INTEGER NOT NULL,
1351
    IDENTIFIERS_ID INTEGER NOT NULL,
1352
    SORTINDEX INTEGER NOT NULL,
1353
    REVTYPE TINYINT
1354
);
1355
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_IDENTIFIER_AUD;
1356

    
1357
CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_FEATURE(
1358
    DESCRIPTIONBASE_ID INTEGER NOT NULL,
1359
    DESCRIPTIVESYSTEM_ID INTEGER NOT NULL
1360
);
1361
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_FEATURE;
1362
CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_FEATURE_AUD(
1363
    REV INTEGER NOT NULL,
1364
    DESCRIPTIONBASE_ID INTEGER NOT NULL,
1365
    DESCRIPTIVESYSTEM_ID INTEGER NOT NULL,
1366
    REVTYPE TINYINT
1367
);
1368
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_FEATURE_AUD;
1369
CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_GEOSCOPE(
1370
    TAXONDESCRIPTION_ID INTEGER NOT NULL,
1371
    GEOSCOPES_ID INTEGER NOT NULL
1372
);
1373
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_GEOSCOPE;
1374
CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_GEOSCOPE_AUD(
1375
    REV INTEGER NOT NULL,
1376
    TAXONDESCRIPTION_ID INTEGER NOT NULL,
1377
    GEOSCOPES_ID INTEGER NOT NULL,
1378
    REVTYPE TINYINT
1379
);
1380
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_GEOSCOPE_AUD;
1381
CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_MARKER(
1382
    DESCRIPTIONBASE_ID INTEGER NOT NULL,
1383
    MARKERS_ID INTEGER NOT NULL
1384
);
1385
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_MARKER;
1386
CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_MARKER_AUD(
1387
    REV INTEGER NOT NULL,
1388
    DESCRIPTIONBASE_ID INTEGER NOT NULL,
1389
    MARKERS_ID INTEGER NOT NULL,
1390
    REVTYPE TINYINT
1391
);
1392
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_MARKER_AUD;
1393
CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_ORIGINALSOURCEBASE(
1394
    DESCRIPTIONBASE_ID INTEGER NOT NULL,
1395
    SOURCES_ID INTEGER NOT NULL
1396
);
1397
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_ORIGINALSOURCEBASE;
1398
CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_ORIGINALSOURCEBASE_AUD(
1399
    REV INTEGER NOT NULL,
1400
    DESCRIPTIONBASE_ID INTEGER NOT NULL,
1401
    SOURCES_ID INTEGER NOT NULL,
1402
    REVTYPE TINYINT
1403
);
1404
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_ORIGINALSOURCEBASE_AUD;
1405
CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_REFERENCE(
1406
    DESCRIPTIONBASE_ID INTEGER NOT NULL,
1407
    DESCRIPTIONSOURCES_ID INTEGER NOT NULL
1408
);
1409
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_REFERENCE;
1410
CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_REFERENCE_AUD(
1411
    REV INTEGER NOT NULL,
1412
    DESCRIPTIONBASE_ID INTEGER NOT NULL,
1413
    DESCRIPTIONSOURCES_ID INTEGER NOT NULL,
1414
    REVTYPE TINYINT
1415
);
1416
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_REFERENCE_AUD;
1417
CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_RIGHTSINFO(
1418
    DESCRIPTIONBASE_ID INTEGER NOT NULL,
1419
    RIGHTS_ID INTEGER NOT NULL
1420
);
1421
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_RIGHTSINFO;
1422
CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_RIGHTSINFO_AUD(
1423
    REV INTEGER NOT NULL,
1424
    DESCRIPTIONBASE_ID INTEGER NOT NULL,
1425
    RIGHTS_ID INTEGER NOT NULL,
1426
    REVTYPE TINYINT
1427
);
1428
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_RIGHTSINFO_AUD;
1429
CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_SCOPE(
1430
    TAXONDESCRIPTION_ID INTEGER NOT NULL,
1431
    SCOPES_ID INTEGER NOT NULL
1432
);
1433
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_SCOPE;
1434
CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_SCOPE_AUD(
1435
    REV INTEGER NOT NULL,
1436
    TAXONDESCRIPTION_ID INTEGER NOT NULL,
1437
    SCOPES_ID INTEGER NOT NULL,
1438
    REVTYPE TINYINT
1439
);
1440
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_SCOPE_AUD;
1441
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE(
1442
    DTYPE VARCHAR(31) NOT NULL,
1443
    ID INTEGER NOT NULL,
1444
    CREATED TIMESTAMP,
1445
    UUID VARCHAR(36),
1446
    UPDATED TIMESTAMP,
1447
    NAME VARCHAR(255),
1448
    TIMEPERIOD_START VARCHAR(255),
1449
    TIMEPERIOD_END VARCHAR(255),
1450
    TIMEPERIOD_FREETEXT VARCHAR(255),
1451
    ORDERRELEVANT BOOLEAN,
1452
--  MINIMUM DOUBLE,
1453
--        MAXIMUM DOUBLE,
1454
--        AVERAGE DOUBLE,
1455
--        TYPCALLOWERBOUNDARY DOUBLE,
1456
--        TYPCALHIGHERBOUNDARY DOUBLE,
1457
--        VARIANCE DOUBLE,
1458
--        STANDARDDEVIATION DOUBLE,
1459
--        SINGLEVALUE DOUBLE,
1460
--        SAMPLESIZE INTEGER,
1461
        UNKNOWNDATA BOOLEAN,
1462
    CREATEDBY_ID INTEGER,
1463
    UPDATEDBY_ID INTEGER,
1464
    FEATURE_ID INTEGER,
1465
    INDESCRIPTION_ID INTEGER,
1466
    AREA_ID INTEGER,
1467
    LANGUAGE_ID INTEGER,
1468
    STATUS_ID INTEGER,
1469
    ASSOCIATEDSPECIMENOROBSERVATION_ID INTEGER,
1470
    UNIT_ID INTEGER,
1471
    TAXON2_ID INTEGER,
1472
    FORMAT_ID INTEGER,
1473
        
1474
);
1475
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE;
1476
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_AUD(
1477
    DTYPE VARCHAR(31) NOT NULL,
1478
    ID INTEGER NOT NULL,
1479
    REV INTEGER NOT NULL,
1480
    REVTYPE TINYINT,
1481
    CREATED TIMESTAMP,
1482
    UUID VARCHAR(36),
1483
    UPDATED TIMESTAMP,
1484
    NAME VARCHAR(255),
1485
    TIMEPERIOD_START VARCHAR(255),
1486
    TIMEPERIOD_END VARCHAR(255),
1487
    TIMEPERIOD_FREETEXT VARCHAR(255),
1488
--  MINIMUM DOUBLE,
1489
--        MAXIMUM DOUBLE,
1490
--        AVERAGE DOUBLE,
1491
--        TYPCALLOWERBOUNDARY DOUBLE,
1492
--        TYPCALHIGHERBOUNDARY DOUBLE,
1493
--        VARIANCE DOUBLE,
1494
--        STANDARDDEVIATION DOUBLE,
1495
--        SINGLEVALUE DOUBLE,
1496
--        SAMPLESIZE INTEGER,
1497
    ORDERRELEVANT BOOLEAN,
1498
    UNKNOWNDATA BOOLEAN,
1499
    CREATEDBY_ID INTEGER,
1500
    UPDATEDBY_ID INTEGER,
1501
    FEATURE_ID INTEGER,
1502
    INDESCRIPTION_ID INTEGER,
1503
    AREA_ID INTEGER,
1504
    STATUS_ID INTEGER,
1505
    TAXON2_ID INTEGER,
1506
    UNIT_ID INTEGER,
1507
    FORMAT_ID INTEGER,
1508
    ASSOCIATEDSPECIMENOROBSERVATION_ID INTEGER,
1509
    LANGUAGE_ID INTEGER
1510
);
1511
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_AUD;
1512
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_ANNOTATION(
1513
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
1514
    ANNOTATIONS_ID INTEGER NOT NULL
1515
);
1516
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_ANNOTATION;
1517
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_ANNOTATION_AUD(
1518
    REV INTEGER NOT NULL,
1519
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
1520
    ANNOTATIONS_ID INTEGER NOT NULL,
1521
    REVTYPE TINYINT
1522
);
1523
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_ANNOTATION_AUD;
1524
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_LANGUAGESTRING(
1525
    TEXTDATA_ID INTEGER NOT NULL,
1526
    MULTILANGUAGETEXT_ID INTEGER NOT NULL,
1527
    MULTILANGUAGETEXT_MAPKEY_ID INTEGER NOT NULL
1528
);
1529
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_LANGUAGESTRING;
1530
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_LANGUAGESTRING_AUD(
1531
    REV INTEGER NOT NULL,
1532
    TEXTDATA_ID INTEGER NOT NULL,
1533
    MULTILANGUAGETEXT_ID INTEGER NOT NULL,
1534
    MULTILANGUAGETEXT_MAPKEY_ID INTEGER NOT NULL,
1535
    REVTYPE TINYINT
1536
);
1537
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_LANGUAGESTRING_AUD;
1538
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MARKER(
1539
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
1540
    MARKERS_ID INTEGER NOT NULL
1541
);
1542
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_MARKER;
1543
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MARKER_AUD(
1544
    REV INTEGER NOT NULL,
1545
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
1546
    MARKERS_ID INTEGER NOT NULL,
1547
    REVTYPE TINYINT
1548
);
1549
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_MARKER_AUD;
1550
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MEDIA(
1551
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
1552
    MEDIA_ID INTEGER NOT NULL,
1553
    SORTINDEX INTEGER NOT NULL
1554
);
1555
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_MEDIA;
1556
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MEDIA_AUD(
1557
    REV INTEGER NOT NULL,
1558
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
1559
    MEDIA_ID INTEGER NOT NULL,
1560
    SORTINDEX INTEGER NOT NULL,
1561
    REVTYPE TINYINT
1562
);
1563
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_MEDIA_AUD;
1564
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MODIFIER(
1565
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
1566
    MODIFIERS_ID INTEGER NOT NULL
1567
);
1568
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_MODIFIER;
1569
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MODIFIER_AUD(
1570
    REV INTEGER NOT NULL,
1571
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
1572
    MODIFIERS_ID INTEGER NOT NULL,
1573
    REVTYPE TINYINT
1574
);
1575
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_MODIFIER_AUD;
1576
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MODIFYINGTEXT(
1577
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
1578
    MODIFYINGTEXT_ID INTEGER NOT NULL,
1579
    MODIFYINGTEXT_MAPKEY_ID INTEGER NOT NULL
1580
);
1581
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_MODIFYINGTEXT;
1582
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MODIFYINGTEXT_AUD(
1583
    REV INTEGER NOT NULL,
1584
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
1585
    MODIFYINGTEXT_ID INTEGER NOT NULL,
1586
    MODIFYINGTEXT_MAPKEY_ID INTEGER NOT NULL,
1587
    REVTYPE TINYINT
1588
);
1589
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_MODIFYINGTEXT_AUD;
1590
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_ORIGINALSOURCEBASE(
1591
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
1592
    SOURCES_ID INTEGER NOT NULL
1593
);
1594
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_ORIGINALSOURCEBASE;
1595
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_ORIGINALSOURCEBASE_AUD(
1596
    REV INTEGER NOT NULL,
1597
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
1598
    SOURCES_ID INTEGER NOT NULL,
1599
    REVTYPE TINYINT
1600
);
1601
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_ORIGINALSOURCEBASE_AUD;
1602
CREATE CACHED TABLE PUBLIC.DETERMINATIONEVENT(
1603
    ID INTEGER NOT NULL,
1604
    CREATED TIMESTAMP,
1605
    UUID VARCHAR(36),
1606
    UPDATED TIMESTAMP,
1607
    DESCRIPTION VARCHAR(255),
1608
    TIMEPERIOD_END VARCHAR(255),
1609
    TIMEPERIOD_FREETEXT VARCHAR(255),
1610
    TIMEPERIOD_START VARCHAR(255),
1611
    PREFERREDFLAG BOOLEAN NOT NULL,
1612
    CREATEDBY_ID INTEGER,
1613
    UPDATEDBY_ID INTEGER,
1614
    ACTOR_ID INTEGER,
1615
    IDENTIFIEDUNIT_ID INTEGER,
1616
    MODIFIER_ID INTEGER,
1617
    TAXON_ID INTEGER,
1618
        TAXONNAME_ID INTEGER
1619
);
1620
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DETERMINATIONEVENT;
1621
CREATE CACHED TABLE PUBLIC.DETERMINATIONEVENT_AUD(
1622
    ID INTEGER NOT NULL,
1623
    REV INTEGER NOT NULL,
1624
    REVTYPE TINYINT,
1625
    CREATED TIMESTAMP,
1626
    UUID VARCHAR(36),
1627
    UPDATED TIMESTAMP,
1628
    DESCRIPTION VARCHAR(255),
1629
    TIMEPERIOD_END VARCHAR(255),
1630
    TIMEPERIOD_FREETEXT VARCHAR(255),
1631
    TIMEPERIOD_START VARCHAR(255),
1632
    PREFERREDFLAG BOOLEAN,
1633
    CREATEDBY_ID INTEGER,
1634
    UPDATEDBY_ID INTEGER,
1635
    ACTOR_ID INTEGER,
1636
    IDENTIFIEDUNIT_ID INTEGER,
1637
    MODIFIER_ID INTEGER,
1638
    TAXON_ID INTEGER,
1639
        TAXONNAME_ID INTEGER
1640
);
1641
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DETERMINATIONEVENT_AUD;
1642
CREATE CACHED TABLE PUBLIC.DETERMINATIONEVENT_ANNOTATION(
1643
    DETERMINATIONEVENT_ID INTEGER NOT NULL,
1644
    ANNOTATIONS_ID INTEGER NOT NULL
1645
);
1646
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DETERMINATIONEVENT_ANNOTATION;
1647
CREATE CACHED TABLE PUBLIC.DETERMINATIONEVENT_ANNOTATION_AUD(
1648
    REV INTEGER NOT NULL,
1649
    DETERMINATIONEVENT_ID INTEGER NOT NULL,
1650
    ANNOTATIONS_ID INTEGER NOT NULL,
1651
    REVTYPE TINYINT
1652
);
1653
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DETERMINATIONEVENT_ANNOTATION_AUD;
1654
CREATE CACHED TABLE PUBLIC.DETERMINATIONEVENT_MARKER(
1655
    DETERMINATIONEVENT_ID INTEGER NOT NULL,
1656
    MARKERS_ID INTEGER NOT NULL
1657
);
1658
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DETERMINATIONEVENT_MARKER;
1659
CREATE CACHED TABLE PUBLIC.DETERMINATIONEVENT_MARKER_AUD(
1660
    REV INTEGER NOT NULL,
1661
    DETERMINATIONEVENT_ID INTEGER NOT NULL,
1662
    MARKERS_ID INTEGER NOT NULL,
1663
    REVTYPE TINYINT
1664
);
1665
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DETERMINATIONEVENT_MARKER_AUD;
1666
CREATE CACHED TABLE PUBLIC.DETERMINATIONEVENT_REFERENCE(
1667
    DETERMINATIONEVENT_ID INTEGER NOT NULL,
1668
    SETOFREFERENCES_ID INTEGER NOT NULL
1669
);
1670
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DETERMINATIONEVENT_REFERENCE;
1671
CREATE CACHED TABLE PUBLIC.DETERMINATIONEVENT_REFERENCE_AUD(
1672
    REV INTEGER NOT NULL,
1673
    DETERMINATIONEVENT_ID INTEGER NOT NULL,
1674
    SETOFREFERENCES_ID INTEGER NOT NULL,
1675
    REVTYPE TINYINT
1676
);
1677

    
1678
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DETERMINATIONEVENT_REFERENCE_AUD;
1679
CREATE CACHED TABLE PUBLIC.DNAQUALITY(
1680
    ID INTEGER NOT NULL,
1681
    CREATED TIMESTAMP,
1682
    UUID VARCHAR(36) NOT NULL,
1683
    UPDATED TIMESTAMP,
1684
    PURIFICATIONMETHOD VARCHAR(255),
1685
    RATIOOFABSORBANCE260_230 DOUBLE,
1686
    RATIOOFABSORBANCE260_280 DOUBLE,
1687
    QUALITYCHECKDATE TIMESTAMP,
1688
    CONCENTRATION DOUBLE,
1689
    CREATEDBY_ID INTEGER,
1690
    UPDATEDBY_ID INTEGER,
1691
    CONCENTRATIONUNIT_ID INTEGER,
1692
    QUALITYTERM_ID INTEGER,
1693
    TYPEDPURIFICATIONMETHOD_ID INTEGER
1694
);
1695
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DNAQUALITY;
1696
CREATE CACHED TABLE PUBLIC.DNAQUALITY_AUD(
1697
    ID INTEGER NOT NULL,
1698
    REV INTEGER NOT NULL,
1699
    REVTYPE TINYINT,
1700
    CREATED TIMESTAMP,
1701
    UUID VARCHAR(36) NOT NULL,
1702
    UPDATED TIMESTAMP,
1703
    PURIFICATIONMETHOD VARCHAR(255),
1704
    RATIOOFABSORBANCE260_230 DOUBLE,
1705
    RATIOOFABSORBANCE260_280 DOUBLE,
1706
    QUALITYCHECKDATE TIMESTAMP,
1707
    CONCENTRATION DOUBLE,
1708
    CREATEDBY_ID INTEGER,
1709
    UPDATEDBY_ID INTEGER,
1710
    CONCENTRATIONUNIT_ID INTEGER,
1711
    QUALITYTERM_ID INTEGER,
1712
    TYPEDPURIFICATIONMETHOD_ID INTEGER
1713
);
1714
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DNAQUALITY_AUD;
1715

    
1716
CREATE CACHED TABLE PUBLIC.ENTITYVALIDATION(
1717
    ID INTEGER NOT NULL,
1718
    UUID VARCHAR(36),
1719
    CREATED TIMESTAMP,
1720
    VALIDATEDENTITYID INTEGER,
1721
    VALIDATEDENTITYUUID VARCHAR(36),
1722
    VALIDATEDENTITYCLASS VARCHAR(255),
1723
    VALIDATIONCOUNT INTEGER,
1724
    UPDATED TIMESTAMP,
1725
    USERFRIENDLYDESCRIPTION VARCHAR(255),
1726
    USERFRIENDLYTYPENAME VARCHAR(255),
1727
    CREATEDBY_ID INTEGER,
1728
    UPDATEDBY_ID INTEGER,
1729
    CRUDEVENTTYPE VARCHAR(24),
1730
    STATUS VARCHAR(16)
1731
);
1732
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ENTITYVALIDATION;
1733

    
1734
CREATE CACHED TABLE PUBLIC.ENTITYCONSTRAINTVIOLATION(
1735
    ID INTEGER NOT NULL,
1736
    UUID VARCHAR(36),
1737
    CREATED TIMESTAMP,
1738
    PROPERTYPATH VARCHAR(255),
1739
    USERFRIENDLYFIELDNAME VARCHAR(255),
1740
    INVALIDVALUE VARCHAR(255),
1741
    SEVERITY VARCHAR(24),
1742
    MESSAGE VARCHAR(255),
1743
    VALIDATOR VARCHAR(255),
1744
    VALIDATIONGROUP VARCHAR(63),
1745
    CREATEDBY_ID INTEGER,
1746
    UPDATEDBY_ID INTEGER,
1747
    ENTITYVALIDATION_ID INTEGER
1748
);
1749
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ENTITYCONSTRAINTVIOLATION;
1750

    
1751
CREATE CACHED TABLE PUBLIC.EXTENSION(
1752
    ID INTEGER NOT NULL,
1753
    CREATED TIMESTAMP,
1754
    UUID VARCHAR(36),
1755
    UPDATED TIMESTAMP,
1756
    VALUE CLOB,
1757
    CREATEDBY_ID INTEGER,
1758
    UPDATEDBY_ID INTEGER,
1759
    TYPE_ID INTEGER
1760
);
1761
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.EXTENSION;
1762
CREATE CACHED TABLE PUBLIC.EXTENSION_AUD(
1763
    ID INTEGER NOT NULL,
1764
    REV INTEGER NOT NULL,
1765
    REVTYPE TINYINT,
1766
    CREATED TIMESTAMP,
1767
    UUID VARCHAR(36),
1768
    UPDATED TIMESTAMP,
1769
    VALUE CLOB,
1770
    CREATEDBY_ID INTEGER,
1771
    UPDATEDBY_ID INTEGER,
1772
    TYPE_ID INTEGER
1773
);
1774
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.EXTENSION_AUD;
1775
CREATE CACHED TABLE PUBLIC.EXTERNALLINK(
1776
--    DTYPE VARCHAR(31) NOT NULL,
1777
    ID INTEGER NOT NULL,
1778
    CREATED TIMESTAMP,
1779
    UUID VARCHAR(36),
1780
    UPDATED TIMESTAMP,
1781
    SIZE INTEGER,
1782
    URI CLOB,
1783
    CREATEDBY_ID INTEGER,
1784
    UPDATEDBY_ID INTEGER,
1785
    SORTINDEX INTEGER
1786
);
1787
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIAREPRESENTATIONPART;
1788
CREATE CACHED TABLE PUBLIC.EXTERNALLINK_AUD(
1789
--    DTYPE VARCHAR(31) NOT NULL,
1790
    ID INTEGER NOT NULL,
1791
    REV INTEGER NOT NULL,
1792
    REVTYPE TINYINT,
1793
    CREATED TIMESTAMP,
1794
    UUID VARCHAR(36),
1795
    UPDATED TIMESTAMP,
1796
    SIZE INTEGER,
1797
    URI CLOB,
1798
    CREATEDBY_ID INTEGER,
1799
    UPDATEDBY_ID INTEGER,
1800
);
1801
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIAREPRESENTATIONPART_AUD;
1802
CREATE CACHED TABLE PUBLIC.EXTERNALLINK_LANGUAGESTRING(
1803
    EXTERNALLINK_ID INTEGER NOT NULL,
1804
    DESCRIPTION_ID INTEGER NOT NULL,
1805
    DESCRIPTION_MAPKEY_ID INTEGER NOT NULL
1806
);
1807
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.EXTERNALLINK_LANGUAGESTRING;
1808
CREATE CACHED TABLE PUBLIC.EXTERNALLINK_LANGUAGESTRING_AUD(
1809
    REV INTEGER NOT NULL,
1810
    EXTERNALLINK_ID INTEGER NOT NULL,
1811
    DESCRIPTION_ID INTEGER NOT NULL,
1812
    DESCRIPTION_MAPKEY_ID INTEGER NOT NULL,
1813
    REVTYPE TINYINT
1814
);
1815
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.EXTERNALLINK_LANGUAGESTRING_AUD;
1816
CREATE CACHED TABLE PUBLIC.FEATURENODE(
1817
    ID INTEGER NOT NULL,
1818
    CREATED TIMESTAMP,
1819
    UUID VARCHAR(36),
1820
    UPDATED TIMESTAMP,
1821
    SORTINDEX INTEGER,
1822
    TREEINDEX VARCHAR(255),
1823
    CREATEDBY_ID INTEGER,
1824
    UPDATEDBY_ID INTEGER,
1825
    FEATURE_ID INTEGER,
1826
    FEATURETREE_ID INTEGER,
1827
    PARENT_ID INTEGER
1828
);
1829
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.FEATURENODE;
1830
CREATE CACHED TABLE PUBLIC.FEATURENODE_AUD(
1831
    ID INTEGER NOT NULL,
1832
    REV INTEGER NOT NULL,
1833
    REVTYPE TINYINT,
1834
    CREATED TIMESTAMP,
1835
    UUID VARCHAR(36),
1836
    UPDATED TIMESTAMP,
1837
    SORTINDEX INTEGER,
1838
    TREEINDEX VARCHAR(255),
1839
    CREATEDBY_ID INTEGER,
1840
    UPDATEDBY_ID INTEGER,
1841
    FEATURE_ID INTEGER,
1842
    FEATURETREE_ID INTEGER,
1843
    PARENT_ID INTEGER
1844
);
1845
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.FEATURENODE_AUD;
1846
CREATE CACHED TABLE PUBLIC.FEATURENODE_DEFINEDTERMBASE_INAPPLICABLEIF(
1847
    FEATURENODE_ID INTEGER NOT NULL,
1848
    INAPPLICABLEIF_ID INTEGER NOT NULL
1849
);
1850
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.FEATURENODE_DEFINEDTERMBASE_INAPPLICABLEIF;
1851
CREATE CACHED TABLE PUBLIC.FEATURENODE_DEFINEDTERMBASE_INAPPLICABLEIF_AUD(
1852
    REV INTEGER NOT NULL,
1853
    FEATURENODE_ID INTEGER NOT NULL,
1854
    INAPPLICABLEIF_ID INTEGER NOT NULL,
1855
    REVTYPE TINYINT
1856
);
1857
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.FEATURENODE_DEFINEDTERMBASE_INAPPLICABLEIF_AUD;
1858
CREATE CACHED TABLE PUBLIC.FEATURENODE_DEFINEDTERMBASE_ONLYAPPLICABLE(
1859
    FEATURENODE_ID INTEGER NOT NULL,
1860
    ONLYAPPLICABLEIF_ID INTEGER NOT NULL
1861
);
1862
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.FEATURENODE_DEFINEDTERMBASE_ONLYAPPLICABLE;
1863
CREATE CACHED TABLE PUBLIC.FEATURENODE_DEFINEDTERMBASE_ONLYAPPLICABLE_AUD(
1864
    REV INTEGER NOT NULL,
1865
    FEATURENODE_ID INTEGER NOT NULL,
1866
    ONLYAPPLICABLEIF_ID INTEGER NOT NULL,
1867
    REVTYPE TINYINT
1868
);
1869
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.FEATURENODE_DEFINEDTERMBASE_ONLYAPPLICABLE_AUD;
1870
CREATE CACHED TABLE PUBLIC.FEATURETREE(
1871
    ID INTEGER NOT NULL,
1872
    CREATED TIMESTAMP,
1873
    UUID VARCHAR(36),
1874
    UPDATED TIMESTAMP,
1875
    LSID_AUTHORITY VARCHAR(255),
1876
    LSID_LSID VARCHAR(255),
1877
    LSID_NAMESPACE VARCHAR(255),
1878
    LSID_OBJECT VARCHAR(255),
1879
    LSID_REVISION VARCHAR(255),
1880
    PROTECTEDTITLECACHE BOOLEAN NOT NULL,
1881
    TITLECACHE VARCHAR(255),
1882
    CREATEDBY_ID INTEGER,
1883
    UPDATEDBY_ID INTEGER,
1884
    ROOT_ID INTEGER
1885
);
1886
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.FEATURETREE;
1887
CREATE CACHED TABLE PUBLIC.FEATURETREE_AUD(
1888
    ID INTEGER NOT NULL,
1889
    REV INTEGER NOT NULL,
1890
    REVTYPE TINYINT,
1891
    CREATED TIMESTAMP,
1892
    UUID VARCHAR(36),
1893
    UPDATED TIMESTAMP,
1894
    LSID_AUTHORITY VARCHAR(255),
1895
    LSID_LSID VARCHAR(255),
1896
    LSID_NAMESPACE VARCHAR(255),
1897
    LSID_OBJECT VARCHAR(255),
1898
    LSID_REVISION VARCHAR(255),
1899
    PROTECTEDTITLECACHE BOOLEAN,
1900
    TITLECACHE VARCHAR(255),
1901
    CREATEDBY_ID INTEGER,
1902
    UPDATEDBY_ID INTEGER,
1903
    ROOT_ID INTEGER
1904
);
1905
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.FEATURETREE_AUD;
1906
CREATE CACHED TABLE PUBLIC.FEATURETREE_ANNOTATION(
1907
    FEATURETREE_ID INTEGER NOT NULL,
1908
    ANNOTATIONS_ID INTEGER NOT NULL
1909
);
1910
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.FEATURETREE_ANNOTATION;
1911
CREATE CACHED TABLE PUBLIC.FEATURETREE_ANNOTATION_AUD(
1912
    REV INTEGER NOT NULL,
1913
    FEATURETREE_ID INTEGER NOT NULL,
1914
    ANNOTATIONS_ID INTEGER NOT NULL,
1915
    REVTYPE TINYINT
1916
);
1917
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.FEATURETREE_ANNOTATION_AUD;
1918
CREATE CACHED TABLE PUBLIC.FEATURETREE_CREDIT(
1919
    FEATURETREE_ID INTEGER NOT NULL,
1920
    CREDITS_ID INTEGER NOT NULL,
1921
    SORTINDEX INTEGER NOT NULL
1922
);
1923
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.FEATURETREE_CREDIT;
1924
CREATE CACHED TABLE PUBLIC.FEATURETREE_CREDIT_AUD(
1925
    REV INTEGER NOT NULL,
1926
    FEATURETREE_ID INTEGER NOT NULL,
1927
    CREDITS_ID INTEGER NOT NULL,
1928
    SORTINDEX INTEGER NOT NULL,
1929
    REVTYPE TINYINT
1930
);
1931
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.FEATURETREE_CREDIT_AUD;
1932
CREATE CACHED TABLE PUBLIC.FEATURETREE_EXTENSION(
1933
    FEATURETREE_ID INTEGER NOT NULL,
1934
    EXTENSIONS_ID INTEGER NOT NULL
1935
);
1936
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.FEATURETREE_EXTENSION;
1937
CREATE CACHED TABLE PUBLIC.FEATURETREE_EXTENSION_AUD(
1938
    REV INTEGER NOT NULL,
1939
    FEATURETREE_ID INTEGER NOT NULL,
1940
    EXTENSIONS_ID INTEGER NOT NULL,
1941
    REVTYPE TINYINT
1942
);
1943
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.FEATURETREE_EXTENSION_AUD;
1944
CREATE CACHED TABLE PUBLIC.FEATURETREE_IDENTIFIER(
1945
    FEATURETREE_ID INTEGER NOT NULL,
1946
    IDENTIFIERS_ID INTEGER NOT NULL,
1947
    SORTINDEX INTEGER NOT NULL
1948
);
1949
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.FEATURETREE_IDENTIFIER;
1950
CREATE CACHED TABLE PUBLIC.FEATURETREE_IDENTIFIER_AUD(
1951
    REV INTEGER NOT NULL,
1952
    FEATURETREE_ID INTEGER NOT NULL,
1953
    IDENTIFIERS_ID INTEGER NOT NULL,
1954
    SORTINDEX INTEGER NOT NULL,
1955
    REVTYPE TINYINT
1956
);
1957
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.FEATURETREE_IDENTIFIER_AUD;
1958
CREATE CACHED TABLE PUBLIC.FEATURETREE_MARKER(
1959
    FEATURETREE_ID INTEGER NOT NULL,
1960
    MARKERS_ID INTEGER NOT NULL
1961
);
1962
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.FEATURETREE_MARKER;
1963
CREATE CACHED TABLE PUBLIC.FEATURETREE_MARKER_AUD(
1964
    REV INTEGER NOT NULL,
1965
    FEATURETREE_ID INTEGER NOT NULL,
1966
    MARKERS_ID INTEGER NOT NULL,
1967
    REVTYPE TINYINT
1968
);
1969
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.FEATURETREE_MARKER_AUD;
1970
CREATE CACHED TABLE PUBLIC.FEATURETREE_ORIGINALSOURCEBASE(
1971
    FEATURETREE_ID INTEGER NOT NULL,
1972
    SOURCES_ID INTEGER NOT NULL
1973
);
1974
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.FEATURETREE_ORIGINALSOURCEBASE;
1975
CREATE CACHED TABLE PUBLIC.FEATURETREE_ORIGINALSOURCEBASE_AUD(
1976
    REV INTEGER NOT NULL,
1977
    FEATURETREE_ID INTEGER NOT NULL,
1978
    SOURCES_ID INTEGER NOT NULL,
1979
    REVTYPE TINYINT
1980
);
1981
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.FEATURETREE_ORIGINALSOURCEBASE_AUD;
1982
CREATE CACHED TABLE PUBLIC.FEATURETREE_REPRESENTATION(
1983
    FEATURETREE_ID INTEGER NOT NULL,
1984
    REPRESENTATIONS_ID INTEGER NOT NULL
1985
);
1986
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.FEATURETREE_REPRESENTATION;
1987
CREATE CACHED TABLE PUBLIC.FEATURETREE_REPRESENTATION_AUD(
1988
    REV INTEGER NOT NULL,
1989
    FEATURETREE_ID INTEGER NOT NULL,
1990
    REPRESENTATIONS_ID INTEGER NOT NULL,
1991
    REVTYPE TINYINT
1992
);
1993
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.FEATURETREE_REPRESENTATION_AUD;
1994
CREATE CACHED TABLE PUBLIC.FEATURETREE_RIGHTSINFO(
1995
    FEATURETREE_ID INTEGER NOT NULL,
1996
    RIGHTS_ID INTEGER NOT NULL
1997
);
1998
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.FEATURETREE_RIGHTSINFO;
1999
CREATE CACHED TABLE PUBLIC.FEATURETREE_RIGHTSINFO_AUD(
2000
    REV INTEGER NOT NULL,
2001
    FEATURETREE_ID INTEGER NOT NULL,
2002
    RIGHTS_ID INTEGER NOT NULL,
2003
    REVTYPE TINYINT
2004
);
2005
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.FEATURETREE_RIGHTSINFO_AUD;
2006
CREATE CACHED TABLE PUBLIC.GATHERINGEVENT(
2007
    ID INTEGER NOT NULL,
2008
    CREATED TIMESTAMP,
2009
    UUID VARCHAR(36),
2010
    UPDATED TIMESTAMP,
2011
    DESCRIPTION VARCHAR(255),
2012
    TIMEPERIOD_END VARCHAR(255),
2013
    TIMEPERIOD_FREETEXT VARCHAR(255),
2014
    TIMEPERIOD_START VARCHAR(255),
2015
    ABSOLUTEELEVATION INTEGER,
2016
    ABSOLUTEELEVATIONMAX INTEGER,
2017
    ABSOLUTEELEVATIONTEXT VARCHAR(30),
2018
    COLLECTINGMETHOD VARCHAR(255),
2019
    DISTANCETOGROUND DOUBLE,
2020
    DISTANCETOGROUNDMAX DOUBLE,
2021
    DISTANCETOGROUNDTEXT VARCHAR(30),
2022
    DISTANCETOWATERSURFACE DOUBLE,
2023
    DISTANCETOWATERSURFACEMAX DOUBLE,
2024
    DISTANCETOWATERSURFACETEXT VARCHAR(30),
2025
    EXACTLOCATION_ERRORRADIUS INTEGER,
2026
    EXACTLOCATION_LATITUDE DOUBLE,
2027
    EXACTLOCATION_LONGITUDE DOUBLE,
2028
    CREATEDBY_ID INTEGER,
2029
    UPDATEDBY_ID INTEGER,
2030
    ACTOR_ID INTEGER,
2031
    COUNTRY_ID INTEGER,
2032
    EXACTLOCATION_REFERENCESYSTEM_ID INTEGER,
2033
    LOCALITY_ID INTEGER
2034
);
2035
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.GATHERINGEVENT;
2036
CREATE CACHED TABLE PUBLIC.GATHERINGEVENT_AUD(
2037
    ID INTEGER NOT NULL,
2038
    REV INTEGER NOT NULL,
2039
    REVTYPE TINYINT,
2040
    CREATED TIMESTAMP,
2041
    UUID VARCHAR(36),
2042
    UPDATED TIMESTAMP,
2043
    DESCRIPTION VARCHAR(255),
2044
    TIMEPERIOD_END VARCHAR(255),
2045
    TIMEPERIOD_FREETEXT VARCHAR(255),
2046
    TIMEPERIOD_START VARCHAR(255),
2047
    ABSOLUTEELEVATION INTEGER,
2048
    ABSOLUTEELEVATIONMAX INTEGER,
2049
    ABSOLUTEELEVATIONTEXT VARCHAR(30),
2050
    COLLECTINGMETHOD VARCHAR(255),
2051
    DISTANCETOGROUND DOUBLE,
2052
    DISTANCETOGROUNDMAX DOUBLE,
2053
    DISTANCETOGROUNDTEXT VARCHAR(30),
2054
    DISTANCETOWATERSURFACE DOUBLE,
2055
    DISTANCETOWATERSURFACEMAX DOUBLE,
2056
    DISTANCETOWATERSURFACETEXT VARCHAR(30),
2057
    EXACTLOCATION_ERRORRADIUS INTEGER,
2058
    EXACTLOCATION_LATITUDE DOUBLE,
2059
    EXACTLOCATION_LONGITUDE DOUBLE,
2060
    CREATEDBY_ID INTEGER,
2061
    UPDATEDBY_ID INTEGER,
2062
    ACTOR_ID INTEGER,
2063
    COUNTRY_ID INTEGER,
2064
    EXACTLOCATION_REFERENCESYSTEM_ID INTEGER,
2065
    LOCALITY_ID INTEGER
2066
);
2067
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.GATHERINGEVENT_AUD;
2068
CREATE CACHED TABLE PUBLIC.GATHERINGEVENT_ANNOTATION(
2069
    GATHERINGEVENT_ID INTEGER NOT NULL,
2070
    ANNOTATIONS_ID INTEGER NOT NULL
2071
);
2072
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.GATHERINGEVENT_ANNOTATION;
2073
CREATE CACHED TABLE PUBLIC.GATHERINGEVENT_ANNOTATION_AUD(
2074
    REV INTEGER NOT NULL,
2075
    GATHERINGEVENT_ID INTEGER NOT NULL,
2076
    ANNOTATIONS_ID INTEGER NOT NULL,
2077
    REVTYPE TINYINT
2078
);
2079
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.GATHERINGEVENT_ANNOTATION_AUD;
2080
CREATE CACHED TABLE PUBLIC.GATHERINGEVENT_DEFINEDTERMBASE(
2081
    GATHERINGEVENT_ID INTEGER NOT NULL,
2082
    COLLECTINGAREAS_ID INTEGER NOT NULL
2083
);
2084
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.GATHERINGEVENT_DEFINEDTERMBASE;
2085
CREATE CACHED TABLE PUBLIC.GATHERINGEVENT_DEFINEDTERMBASE_AUD(
2086
    REV INTEGER NOT NULL,
2087
    GATHERINGEVENT_ID INTEGER NOT NULL,
2088
    COLLECTINGAREAS_ID INTEGER NOT NULL,
2089
    REVTYPE TINYINT
2090
);
2091
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.GATHERINGEVENT_DEFINEDTERMBASE_AUD;
2092
CREATE CACHED TABLE PUBLIC.GATHERINGEVENT_MARKER(
2093
    GATHERINGEVENT_ID INTEGER NOT NULL,
2094
    MARKERS_ID INTEGER NOT NULL
2095
);
2096
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.GATHERINGEVENT_MARKER;
2097
CREATE CACHED TABLE PUBLIC.GATHERINGEVENT_MARKER_AUD(
2098
    REV INTEGER NOT NULL,
2099
    GATHERINGEVENT_ID INTEGER NOT NULL,
2100
    MARKERS_ID INTEGER NOT NULL,
2101
    REVTYPE TINYINT
2102
);
2103
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.GATHERINGEVENT_MARKER_AUD;
2104
CREATE CACHED TABLE PUBLIC.GRANTEDAUTHORITYIMPL(
2105
    ID INTEGER NOT NULL,
2106
    CREATED TIMESTAMP,
2107
    UUID VARCHAR(36),
2108
    AUTHORITY VARCHAR(255) NOT NULL,
2109
    CREATEDBY_ID INTEGER
2110
);
2111
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.GRANTEDAUTHORITYIMPL;
2112
CREATE CACHED TABLE PUBLIC.HOMOTYPICALGROUP(
2113
    ID INTEGER NOT NULL,
2114
    CREATED TIMESTAMP,
2115
    UUID VARCHAR(36),
2116
    UPDATED TIMESTAMP,
2117
    CREATEDBY_ID INTEGER,
2118
    UPDATEDBY_ID INTEGER
2119
);
2120
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.HOMOTYPICALGROUP;
2121
CREATE CACHED TABLE PUBLIC.HOMOTYPICALGROUP_AUD(
2122
    ID INTEGER NOT NULL,
2123
    REV INTEGER NOT NULL,
2124
    REVTYPE TINYINT,
2125
    CREATED TIMESTAMP,
2126
    UUID VARCHAR(36),
2127
    UPDATED TIMESTAMP,
2128
    CREATEDBY_ID INTEGER,
2129
    UPDATEDBY_ID INTEGER
2130
);
2131
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.HOMOTYPICALGROUP_AUD;
2132
CREATE CACHED TABLE PUBLIC.HOMOTYPICALGROUP_ANNOTATION(
2133
    HOMOTYPICALGROUP_ID INTEGER NOT NULL,
2134
    ANNOTATIONS_ID INTEGER NOT NULL
2135
);
2136
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.HOMOTYPICALGROUP_ANNOTATION;
2137
CREATE CACHED TABLE PUBLIC.HOMOTYPICALGROUP_ANNOTATION_AUD(
2138
    REV INTEGER NOT NULL,
2139
    HOMOTYPICALGROUP_ID INTEGER NOT NULL,
2140
    ANNOTATIONS_ID INTEGER NOT NULL,
2141
    REVTYPE TINYINT
2142
);
2143
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.HOMOTYPICALGROUP_ANNOTATION_AUD;
2144
CREATE CACHED TABLE PUBLIC.HOMOTYPICALGROUP_MARKER(
2145
    HOMOTYPICALGROUP_ID INTEGER NOT NULL,
2146
    MARKERS_ID INTEGER NOT NULL
2147
);
2148
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.HOMOTYPICALGROUP_MARKER;
2149
CREATE CACHED TABLE PUBLIC.HOMOTYPICALGROUP_MARKER_AUD(
2150
    REV INTEGER NOT NULL,
2151
    HOMOTYPICALGROUP_ID INTEGER NOT NULL,
2152
    MARKERS_ID INTEGER NOT NULL,
2153
    REVTYPE TINYINT
2154
);
2155
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.HOMOTYPICALGROUP_MARKER_AUD;
2156
CREATE CACHED TABLE PUBLIC.HYBRIDRELATIONSHIP(
2157
    ID INTEGER NOT NULL,
2158
    CREATED TIMESTAMP,
2159
    UUID VARCHAR(36),
2160
    UPDATED TIMESTAMP,
2161
    CITATIONMICROREFERENCE VARCHAR(255),
2162
    ORIGINALNAMESTRING VARCHAR(255),
2163
    DOUBTFUL BOOLEAN NOT NULL,
2164
    RULECONSIDERED VARCHAR(255),
2165
    CREATEDBY_ID INTEGER,
2166
    UPDATEDBY_ID INTEGER,
2167
    CITATION_ID INTEGER,
2168
    RELATEDFROM_ID INTEGER,
2169
    RELATEDTO_ID INTEGER,
2170
    TYPE_ID INTEGER
2171
);
2172
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.HYBRIDRELATIONSHIP;
2173
CREATE CACHED TABLE PUBLIC.HYBRIDRELATIONSHIP_AUD(
2174
    ID INTEGER NOT NULL,
2175
    REV INTEGER NOT NULL,
2176
    REVTYPE TINYINT,
2177
    CREATED TIMESTAMP,
2178
    UUID VARCHAR(36),
2179
    UPDATED TIMESTAMP,
2180
    CITATIONMICROREFERENCE VARCHAR(255),
2181
    ORIGINALNAMESTRING VARCHAR(255),
2182
    DOUBTFUL BOOLEAN,
2183
    RULECONSIDERED VARCHAR(255),
2184
    CREATEDBY_ID INTEGER,
2185
    UPDATEDBY_ID INTEGER,
2186
    CITATION_ID INTEGER,
2187
    RELATEDFROM_ID INTEGER,
2188
    RELATEDTO_ID INTEGER,
2189
    TYPE_ID INTEGER
2190
);
2191
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.HYBRIDRELATIONSHIP_AUD;
2192
CREATE CACHED TABLE PUBLIC.HYBRIDRELATIONSHIP_ANNOTATION(
2193
    HYBRIDRELATIONSHIP_ID INTEGER NOT NULL,
2194
    ANNOTATIONS_ID INTEGER NOT NULL
2195
);
2196
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.HYBRIDRELATIONSHIP_ANNOTATION;
2197
CREATE CACHED TABLE PUBLIC.HYBRIDRELATIONSHIP_ANNOTATION_AUD(
2198
    REV INTEGER NOT NULL,
2199
    HYBRIDRELATIONSHIP_ID INTEGER NOT NULL,
2200
    ANNOTATIONS_ID INTEGER NOT NULL,
2201
    REVTYPE TINYINT
2202
);
2203
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.HYBRIDRELATIONSHIP_ANNOTATION_AUD;
2204
CREATE CACHED TABLE PUBLIC.HYBRIDRELATIONSHIP_MARKER(
2205
    HYBRIDRELATIONSHIP_ID INTEGER NOT NULL,
2206
    MARKERS_ID INTEGER NOT NULL
2207
);
2208
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.HYBRIDRELATIONSHIP_MARKER;
2209
CREATE CACHED TABLE PUBLIC.HYBRIDRELATIONSHIP_MARKER_AUD(
2210
    REV INTEGER NOT NULL,
2211
    HYBRIDRELATIONSHIP_ID INTEGER NOT NULL,
2212
    MARKERS_ID INTEGER NOT NULL,
2213
    REVTYPE TINYINT
2214
);
2215
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.HYBRIDRELATIONSHIP_MARKER_AUD;
2216
CREATE CACHED TABLE PUBLIC.INDIVIDUALSASSOCIATION_LANGUAGESTRING(
2217
    INDIVIDUALSASSOCIATION_ID INTEGER NOT NULL,
2218
    DESCRIPTION_ID INTEGER NOT NULL,
2219
    DESCRIPTION_MAPKEY_ID INTEGER NOT NULL
2220
);
2221
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.INDIVIDUALSASSOCIATION_LANGUAGESTRING;
2222
CREATE CACHED TABLE PUBLIC.INDIVIDUALSASSOCIATION_LANGUAGESTRING_AUD(
2223
    REV INTEGER NOT NULL,
2224
    INDIVIDUALSASSOCIATION_ID INTEGER NOT NULL,
2225
    DESCRIPTION_ID INTEGER NOT NULL,
2226
    DESCRIPTION_MAPKEY_ID INTEGER NOT NULL,
2227
    REVTYPE TINYINT
2228
);
2229
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.INDIVIDUALSASSOCIATION_LANGUAGESTRING_AUD;
2230
CREATE CACHED TABLE PUBLIC.IDENTIFIER(
2231
    ID INTEGER NOT NULL,
2232
    UUID VARCHAR(36),
2233
    CREATED TIMESTAMP,
2234
    UPDATED TIMESTAMP,
2235
    IDENTIFIER VARCHAR(800),
2236
    CREATEDBY_ID INTEGER,
2237
    UPDATEDBY_ID INTEGER,
2238
          TYPE_ID INTEGER  
2239
);
2240
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.IDENTIFIER;
2241
CREATE CACHED TABLE PUBLIC.IDENTIFIER_AUD(
2242
        ID INTEGER NOT NULL,
2243
    REV INTEGER NOT NULL,
2244
    REVTYPE TINYINT,
2245
    UUID VARCHAR(36),
2246
    CREATED TIMESTAMP,
2247
    UPDATED TIMESTAMP,
2248
    IDENTIFIER VARCHAR(800),
2249
    CREATEDBY_ID INTEGER,
2250
    UPDATEDBY_ID INTEGER,
2251
          TYPE_ID INTEGER  
2252
);
2253
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.IDENTIFIER_AUD;
2254
CREATE CACHED TABLE PUBLIC.IDENTIFIER_ANNOTATION(
2255
    IDENTIFIER_ID INTEGER NOT NULL,
2256
    ANNOTATIONS_ID INTEGER NOT NULL
2257
);
2258
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.IDENTIFIER_ANNOTATION;
2259
CREATE CACHED TABLE PUBLIC.IDENTIFIER_ANNOTATION_AUD(
2260
    REV INTEGER NOT NULL,
2261
    IDENTIFIER_ID INTEGER NOT NULL,
2262
    ANNOTATIONS_ID INTEGER NOT NULL,
2263
    REVTYPE TINYINT
2264
);
2265
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.IDENTIFIER_ANNOTATION_AUD;
2266
CREATE CACHED TABLE PUBLIC.IDENTIFIER_MARKER(
2267
    IDENTIFIER_ID INTEGER NOT NULL,
2268
    MARKERS_ID INTEGER NOT NULL
2269
);
2270
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.IDENTIFIER_MARKER;
2271
CREATE CACHED TABLE PUBLIC.IDENTIFIER_MARKER_AUD(
2272
    REV INTEGER NOT NULL,
2273
    IDENTIFIER_ID INTEGER NOT NULL,
2274
    MARKERS_ID INTEGER NOT NULL,
2275
    REVTYPE TINYINT
2276
);
2277
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.IDENTIFIER_MARKER_AUD;
2278
CREATE CACHED TABLE PUBLIC.INTEXTREFERENCE(
2279
    ID INTEGER NOT NULL,
2280
    UUID VARCHAR(36),
2281
    CREATED TIMESTAMP,
2282
    UPDATED TIMESTAMP,
2283
    CREATEDBY_ID INTEGER,
2284
    UPDATEDBY_ID INTEGER,
2285
          STARTPOS INT,
2286
          ENDPOS INT,
2287
          AGENT_ID INT,
2288
          ANNOTATION_ID INT,
2289
          LANGUAGESTRING_ID INT,
2290
          MEDIA_ID INT,
2291
          OCCURRENCE_ID INT,
2292
          REFERENCE_ID INT,
2293
          TAXON_ID INT,
2294
          TAXONNAME_ID INT,
2295
        KEY_ID INT
2296
);
2297
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.INTEXTREFERENCE;
2298
CREATE CACHED TABLE PUBLIC.INTEXTREFERENCE_AUD(
2299
    ID INTEGER NOT NULL,
2300
    REV INTEGER NOT NULL,
2301
    REVTYPE TINYINT,
2302
    UUID VARCHAR(36),
2303
    CREATED TIMESTAMP,
2304
    UPDATED TIMESTAMP,
2305
    CREATEDBY_ID INTEGER,
2306
    UPDATEDBY_ID INTEGER,
2307
          STARTPOS INT,
2308
          ENDPOS INT,
2309
          AGENT_ID INT,
2310
          ANNOTATION_ID INT,
2311
          LANGUAGESTRING_ID INT,
2312
          MEDIA_ID INT,
2313
          OCCURRENCE_ID INT,
2314
          REFERENCE_ID INT,
2315
          TAXON_ID INT,
2316
          TAXONNAME_ID INT,
2317
        KEY_ID INT
2318
);
2319
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.INTEXTREFERENCE_AUD;
2320
CREATE CACHED TABLE PUBLIC.INSTITUTIONALMEMBERSHIP(
2321
    ID INTEGER NOT NULL,
2322
    CREATED TIMESTAMP,
2323
    UUID VARCHAR(36),
2324
    UPDATED TIMESTAMP,
2325
    DEPARTMENT VARCHAR(255),
2326
    PERIOD_END VARCHAR(255),
2327
    PERIOD_FREETEXT VARCHAR(255),
2328
    PERIOD_START VARCHAR(255),
2329
    ROLE VARCHAR(255),
2330
    CREATEDBY_ID INTEGER,
2331
    UPDATEDBY_ID INTEGER,
2332
    INSTITUTE_ID INTEGER,
2333
    PERSON_ID INTEGER
2334
);
2335
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.INSTITUTIONALMEMBERSHIP;
2336
CREATE CACHED TABLE PUBLIC.INSTITUTIONALMEMBERSHIP_AUD(
2337
    ID INTEGER NOT NULL,
2338
    REV INTEGER NOT NULL,
2339
    REVTYPE TINYINT,
2340
    CREATED TIMESTAMP,
2341
    UUID VARCHAR(36),
2342
    UPDATED TIMESTAMP,
2343
    DEPARTMENT VARCHAR(255),
2344
    PERIOD_END VARCHAR(255),
2345
    PERIOD_FREETEXT VARCHAR(255),
2346
    PERIOD_START VARCHAR(255),
2347
    ROLE VARCHAR(255),
2348
    CREATEDBY_ID INTEGER,
2349
    UPDATEDBY_ID INTEGER,
2350
    INSTITUTE_ID INTEGER,
2351
    PERSON_ID INTEGER
2352
);
2353
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.INSTITUTIONALMEMBERSHIP_AUD;
2354
CREATE CACHED TABLE PUBLIC.KEYSTATEMENT(
2355
    ID INTEGER NOT NULL,
2356
    CREATED TIMESTAMP,
2357
    UUID VARCHAR(36),
2358
    UPDATED TIMESTAMP,
2359
    CREATEDBY_ID INTEGER,
2360
    UPDATEDBY_ID INTEGER
2361
);
2362
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.KEYSTATEMENT;
2363
CREATE CACHED TABLE PUBLIC.KEYSTATEMENT_AUD(
2364
    ID INTEGER NOT NULL,
2365
    REV INTEGER NOT NULL,
2366
    REVTYPE TINYINT,
2367
    CREATED TIMESTAMP,
2368
    UUID VARCHAR(36),
2369
    UPDATED TIMESTAMP,
2370
    CREATEDBY_ID INTEGER,
2371
    UPDATEDBY_ID INTEGER
2372
);
2373
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.KEYSTATEMENT_AUD;
2374
CREATE CACHED TABLE PUBLIC.KEYSTATEMENT_LANGUAGESTRING(
2375
    KEYSTATEMENT_ID INTEGER NOT NULL,
2376
    LABEL_ID INTEGER NOT NULL,
2377
    LABEL_MAPKEY_ID INTEGER NOT NULL
2378
);
2379
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.KEYSTATEMENT_LANGUAGESTRING;
2380
CREATE CACHED TABLE PUBLIC.KEYSTATEMENT_LANGUAGESTRING_AUD(
2381
    REV INTEGER NOT NULL,
2382
    KEYSTATEMENT_ID INTEGER NOT NULL,
2383
    LABEL_ID INTEGER NOT NULL,
2384
    LABEL_MAPKEY_ID INTEGER NOT NULL,
2385
    REVTYPE TINYINT
2386
);
2387
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.KEYSTATEMENT_LANGUAGESTRING_AUD;
2388
CREATE CACHED TABLE PUBLIC.LSIDAUTHORITY(
2389
    ID INTEGER NOT NULL,
2390
    CREATED TIMESTAMP,
2391
    UUID VARCHAR(36),
2392
    AUTHORITY VARCHAR(255),
2393
    AUTHORITYWSDL CLOB,
2394
    PORT INTEGER NOT NULL,
2395
    SERVER VARCHAR(255),
2396
    URL VARCHAR(255),
2397
    CREATEDBY_ID INTEGER
2398
);
2399
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.LSIDAUTHORITY;
2400
CREATE CACHED TABLE PUBLIC.LSIDAUTHORITY_NAMESPACES(
2401
    LSIDAUTHORITY_ID INTEGER NOT NULL,
2402
    NAMESPACES_ELEMENT VARCHAR(255),
2403
    NAMESPACES_MAPKEY VARCHAR(255) NOT NULL
2404
);
2405
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.LSIDAUTHORITY_NAMESPACES;
2406
CREATE CACHED TABLE PUBLIC.LANGUAGESTRING(
2407
    ID INTEGER NOT NULL,
2408
    CREATED TIMESTAMP,
2409
    UUID VARCHAR(36),
2410
    UPDATED TIMESTAMP,
2411
    TEXT CLOB,
2412
    CREATEDBY_ID INTEGER,
2413
    UPDATEDBY_ID INTEGER,
2414
    LANGUAGE_ID INTEGER
2415
);
2416
-- 1 +/- SELECT COUNT(*) FROM PUBLIC.LANGUAGESTRING;
2417
CREATE CACHED TABLE PUBLIC.LANGUAGESTRING_AUD(
2418
    ID INTEGER NOT NULL,
2419
    REV INTEGER NOT NULL,
2420
    REVTYPE TINYINT,
2421
    CREATED TIMESTAMP,
2422
    UUID VARCHAR(36),
2423
    UPDATED TIMESTAMP,
2424
    TEXT CLOB,
2425
    CREATEDBY_ID INTEGER,
2426
    UPDATEDBY_ID INTEGER,
2427
    LANGUAGE_ID INTEGER
2428
);
2429
-- 1 +/- SELECT COUNT(*) FROM PUBLIC.LANGUAGESTRING_AUD;
2430
CREATE CACHED TABLE PUBLIC.LANGUAGESTRING_ANNOTATION(
2431
    LANGUAGESTRING_ID INTEGER NOT NULL,
2432
    ANNOTATIONS_ID INTEGER NOT NULL
2433
);
2434
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.LANGUAGESTRING_ANNOTATION;
2435
CREATE CACHED TABLE PUBLIC.LANGUAGESTRING_ANNOTATION_AUD(
2436
    REV INTEGER NOT NULL,
2437
    LANGUAGESTRING_ID INTEGER NOT NULL,
2438
    ANNOTATIONS_ID INTEGER NOT NULL,
2439
    REVTYPE TINYINT
2440
);
2441
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.LANGUAGESTRING_ANNOTATION_AUD;
2442
CREATE CACHED TABLE PUBLIC.LANGUAGESTRING_MARKER(
2443
    LANGUAGESTRING_ID INTEGER NOT NULL,
2444
    MARKERS_ID INTEGER NOT NULL
2445
);
2446
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.LANGUAGESTRING_MARKER;
2447
CREATE CACHED TABLE PUBLIC.LANGUAGESTRING_MARKER_AUD(
2448
    REV INTEGER NOT NULL,
2449
    LANGUAGESTRING_ID INTEGER NOT NULL,
2450
    MARKERS_ID INTEGER NOT NULL,
2451
    REVTYPE TINYINT
2452
);
2453
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.LANGUAGESTRING_MARKER_AUD;
2454
CREATE CACHED TABLE PUBLIC.LOCUS(
2455
    ID INTEGER NOT NULL,
2456
    CREATED TIMESTAMP,
2457
    UUID VARCHAR(36),
2458
    UPDATED TIMESTAMP,
2459
    DESCRIPTION VARCHAR(255),
2460
    NAME VARCHAR(255),
2461
    CREATEDBY_ID INTEGER,
2462
    UPDATEDBY_ID INTEGER
2463
);
2464
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.LOCUS;
2465
CREATE CACHED TABLE PUBLIC.LOCUS_AUD(
2466
    ID INTEGER NOT NULL,
2467
    REV INTEGER NOT NULL,
2468
    REVTYPE TINYINT,
2469
    CREATED TIMESTAMP,
2470
    UUID VARCHAR(36),
2471
    UPDATED TIMESTAMP,
2472
    DESCRIPTION VARCHAR(255),
2473
    NAME VARCHAR(255),
2474
    CREATEDBY_ID INTEGER,
2475
    UPDATEDBY_ID INTEGER
2476
);
2477
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.LOCUS_AUD;
2478
CREATE CACHED TABLE PUBLIC.MARKER(
2479
    ID INTEGER NOT NULL,
2480
    CREATED TIMESTAMP,
2481
    UUID VARCHAR(36),
2482
    UPDATED TIMESTAMP,
2483
    FLAG BOOLEAN NOT NULL,
2484
    CREATEDBY_ID INTEGER,
2485
    UPDATEDBY_ID INTEGER,
2486
    MARKERTYPE_ID INTEGER
2487
);
2488
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MARKER;
2489
CREATE CACHED TABLE PUBLIC.MARKER_AUD(
2490
    ID INTEGER NOT NULL,
2491
    REV INTEGER NOT NULL,
2492
    REVTYPE TINYINT,
2493
    CREATED TIMESTAMP,
2494
    UUID VARCHAR(36),
2495
    UPDATED TIMESTAMP,
2496
    FLAG BOOLEAN,
2497
    CREATEDBY_ID INTEGER,
2498
    UPDATEDBY_ID INTEGER,
2499
    MARKERTYPE_ID INTEGER
2500
);
2501

    
2502
CREATE TABLE MATERIALORMETHODEVENT (
2503
    ID INTEGER NOT NULL,
2504
    DTYPE VARCHAR(255),
2505
    CREATED TIMESTAMP,
2506
    UUID VARCHAR(36),
2507
    UPDATED TIMESTAMP,
2508
    MATERIALMETHODTEXT VARCHAR(255),
2509
    DESCRIPTION VARCHAR(255),
2510
    TIMEPERIOD_END VARCHAR(255),
2511
    TIMEPERIOD_FREETEXT VARCHAR(255),
2512
    TIMEPERIOD_START VARCHAR(255),
2513
        STRAIN VARCHAR(255),
2514
    TEMPERATURE DOUBLE,
2515
    CREATEDBY_ID INTEGER,
2516
    UPDATEDBY_ID INTEGER,
2517
    DEFINEDMATERIALORMETHOD_ID INTEGER,
2518
    ACTOR_ID INTEGER,
2519
    FORWARDPRIMER_ID INTEGER,
2520
    REVERSEPRIMER_ID INTEGER,
2521
    MEDIUM_ID INTEGER,
2522
    PRIMARY KEY (ID)
2523
);
2524

    
2525
CREATE TABLE MATERIALORMETHODEVENT_AUD (
2526
    ID INTEGER NOT NULL,
2527
    REV INTEGER NOT NULL,
2528
    REVTYPE TINYINT,
2529
        DTYPE VARCHAR(255),
2530
    CREATED TIMESTAMP,
2531
    UUID VARCHAR(36),
2532
    UPDATED TIMESTAMP,
2533
    MATERIALMETHODTEXT VARCHAR(255),
2534
    DESCRIPTION VARCHAR(255),
2535
    TIMEPERIOD_END VARCHAR(255),
2536
    TIMEPERIOD_FREETEXT VARCHAR(255),
2537
    TIMEPERIOD_START VARCHAR(255),
2538
        STRAIN VARCHAR(255),
2539
    TEMPERATURE DOUBLE,
2540
    CREATEDBY_ID INTEGER,
2541
    UPDATEDBY_ID INTEGER,
2542
    DEFINEDMATERIALORMETHOD_ID INTEGER,
2543
    ACTOR_ID INTEGER,
2544
    FORWARDPRIMER_ID INTEGER,
2545
    REVERSEPRIMER_ID INTEGER,
2546
    MEDIUM_ID INTEGER
2547
);
2548

    
2549
CREATE TABLE MATERIALORMETHODEVENT_ANNOTATION (
2550
    MATERIALORMETHODEVENT_ID INTEGER NOT NULL,
2551
    ANNOTATIONS_ID INTEGER NOT NULL,
2552
    PRIMARY KEY (MATERIALORMETHODEVENT_ID, ANNOTATIONS_ID)
2553
);
2554

    
2555
CREATE TABLE MATERIALORMETHODEVENT_ANNOTATION_AUD (
2556
    REV INTEGER NOT NULL,
2557
    REVTYPE TINYINT,
2558
    MATERIALORMETHODEVENT_ID INTEGER NOT NULL,
2559
    ANNOTATIONS_ID INTEGER NOT NULL,
2560
);
2561

    
2562
CREATE TABLE MATERIALORMETHODEVENT_MARKER (
2563
    MATERIALORMETHODEVENT_ID INTEGER NOT NULL,
2564
    MARKERS_ID INTEGER NOT NULL,
2565
    PRIMARY KEY (MATERIALORMETHODEVENT_ID, MARKERS_ID)
2566
);
2567

    
2568
CREATE TABLE MATERIALORMETHODEVENT_MARKER_AUD (
2569
    REV INTEGER NOT NULL,
2570
    REVTYPE TINYINT,
2571
    MATERIALORMETHODEVENT_ID INTEGER NOT NULL,
2572
    MARKERS_ID INTEGER NOT NULL,
2573
);
2574

    
2575
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MARKER_AUD;
2576
CREATE CACHED TABLE PUBLIC.MEDIA(
2577
    DTYPE VARCHAR(31) NOT NULL,
2578
    ID INTEGER NOT NULL,
2579
    CREATED TIMESTAMP,
2580
    UUID VARCHAR(36),
2581
    UPDATED TIMESTAMP,
2582
    LSID_AUTHORITY VARCHAR(255),
2583
    LSID_LSID VARCHAR(255),
2584
    LSID_NAMESPACE VARCHAR(255),
2585
    LSID_OBJECT VARCHAR(255),
2586
    LSID_REVISION VARCHAR(255),
2587
    PROTECTEDTITLECACHE BOOLEAN NOT NULL,
2588
    TITLECACHE VARCHAR(255),
2589
    MEDIACREATED TIMESTAMP,
2590
    CITATIONMICROREFERENCE VARCHAR(255),
2591
    CREATEDBY_ID INTEGER,
2592
    UPDATEDBY_ID INTEGER,
2593
    ARTIST_ID INTEGER,
2594
    CITATION_ID INTEGER
2595
);
2596
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA;
2597
CREATE CACHED TABLE PUBLIC.MEDIAKEY_COVEREDTAXON(
2598
    MEDIAKEY_ID INTEGER NOT NULL,
2599
    COVEREDTAXA_ID INTEGER NOT NULL
2600
);
2601
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIAKEY_COVEREDTAXON;
2602
CREATE CACHED TABLE PUBLIC.MEDIAKEY_COVEREDTAXON_AUD(
2603
    REV INTEGER NOT NULL,
2604
    MEDIAKEY_ID INTEGER NOT NULL,
2605
    COVEREDTAXA_ID INTEGER NOT NULL,
2606
    REVTYPE TINYINT
2607
);
2608
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIAKEY_COVEREDTAXON_AUD;
2609
CREATE CACHED TABLE PUBLIC.MEDIAKEY_NAMEDAREA(
2610
    MEDIAKEY_ID INTEGER NOT NULL,
2611
    GEOGRAPHICALSCOPE_ID INTEGER NOT NULL
2612
);
2613
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIAKEY_NAMEDAREA;
2614
CREATE CACHED TABLE PUBLIC.MEDIAKEY_NAMEDAREA_AUD(
2615
    REV INTEGER NOT NULL,
2616
    MEDIAKEY_ID INTEGER NOT NULL,
2617
    GEOGRAPHICALSCOPE_ID INTEGER NOT NULL,
2618
    REVTYPE TINYINT
2619
);
2620
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIAKEY_NAMEDAREA_AUD;
2621
CREATE CACHED TABLE PUBLIC.MEDIAKEY_SCOPE(
2622
    MEDIAKEY_ID INTEGER NOT NULL,
2623
    SCOPERESTRICTIONS_ID INTEGER NOT NULL
2624
);
2625
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIAKEY_SCOPE;
2626
CREATE CACHED TABLE PUBLIC.MEDIAKEY_SCOPE_AUD(
2627
    REV INTEGER NOT NULL,
2628
    MEDIAKEY_ID INTEGER NOT NULL,
2629
    SCOPERESTRICTIONS_ID INTEGER NOT NULL,
2630
    REVTYPE TINYINT
2631
);
2632
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIAKEY_SCOPE_AUD;
2633
CREATE CACHED TABLE PUBLIC.MEDIAKEY_TAXONSCOPE(
2634
    MEDIAKEY_ID INTEGER NOT NULL,
2635
    TAXONOMICSCOPE_ID INTEGER NOT NULL
2636
);
2637
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIAKEY_TAXONSCOPE;
2638
CREATE CACHED TABLE PUBLIC.MEDIAKEY_TAXONSCOPE_AUD(
2639
    REV INTEGER NOT NULL,
2640
    MEDIAKEY_ID INTEGER NOT NULL,
2641
    TAXONOMICSCOPE_ID INTEGER NOT NULL,
2642
    REVTYPE TINYINT
2643
);
2644
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIAKEY_TAXONSCOPE_AUD;
2645
CREATE CACHED TABLE PUBLIC.MEDIAREPRESENTATION(
2646
    ID INTEGER NOT NULL,
2647
    CREATED TIMESTAMP,
2648
    UUID VARCHAR(36),
2649
    UPDATED TIMESTAMP,
2650
    MIMETYPE VARCHAR(255),
2651
    SUFFIX VARCHAR(255),
2652
    CREATEDBY_ID INTEGER,
2653
    UPDATEDBY_ID INTEGER,
2654
    MEDIA_ID INTEGER
2655
);
2656
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIAREPRESENTATION;
2657
CREATE CACHED TABLE PUBLIC.MEDIAREPRESENTATIONPART(
2658
    DTYPE VARCHAR(31) NOT NULL,
2659
    ID INTEGER NOT NULL,
2660
    CREATED TIMESTAMP,
2661
    UUID VARCHAR(36),
2662
    UPDATED TIMESTAMP,
2663
    SIZE INTEGER,
2664
    URI CLOB,
2665
    DURATION INTEGER,
2666
    HEIGHT INTEGER,
2667
    WIDTH INTEGER,
2668
    CREATEDBY_ID INTEGER,
2669
    UPDATEDBY_ID INTEGER,
2670
    REPRESENTATION_ID INTEGER NOT NULL,
2671
    SORTINDEX INTEGER
2672
);
2673
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIAREPRESENTATIONPART;
2674
CREATE CACHED TABLE PUBLIC.MEDIAREPRESENTATIONPART_AUD(
2675
    DTYPE VARCHAR(31) NOT NULL,
2676
    ID INTEGER NOT NULL,
2677
    REV INTEGER NOT NULL,
2678
    REVTYPE TINYINT,
2679
    CREATED TIMESTAMP,
2680
    UUID VARCHAR(36),
2681
    UPDATED TIMESTAMP,
2682
    SIZE INTEGER,
2683
    URI CLOB,
2684
    CREATEDBY_ID INTEGER,
2685
    UPDATEDBY_ID INTEGER,
2686
    REPRESENTATION_ID INTEGER,
2687
    DURATION INTEGER,
2688
    HEIGHT INTEGER,
2689
    WIDTH INTEGER
2690
);
2691
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIAREPRESENTATIONPART_AUD;
2692
CREATE CACHED TABLE PUBLIC.MEDIAREPRESENTATION_AUD(
2693
    ID INTEGER NOT NULL,
2694
    REV INTEGER NOT NULL,
2695
    REVTYPE TINYINT,
2696
    CREATED TIMESTAMP,
2697
    UUID VARCHAR(36),
2698
    UPDATED TIMESTAMP,
2699
    MIMETYPE VARCHAR(255),
2700
    SUFFIX VARCHAR(255),
2701
    CREATEDBY_ID INTEGER,
2702
    UPDATEDBY_ID INTEGER,
2703
    MEDIA_ID INTEGER
2704
);
2705
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIAREPRESENTATION_AUD;
2706
CREATE CACHED TABLE PUBLIC.MEDIAREPRESENTATION_MEDIAREPRESENTATIONPART_AUD(
2707
    REV INTEGER NOT NULL,
2708
    REPRESENTATION_ID INTEGER NOT NULL,
2709
    ID INTEGER NOT NULL,
2710
    SORTINDEX INTEGER NOT NULL,
2711
    REVTYPE TINYINT
2712
);
2713
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIAREPRESENTATION_MEDIAREPRESENTATIONPART_AUD;
2714
CREATE CACHED TABLE PUBLIC.MEDIA_AUD(
2715
    DTYPE VARCHAR(31) NOT NULL,
2716
    ID INTEGER NOT NULL,
2717
    REV INTEGER NOT NULL,
2718
    REVTYPE TINYINT,
2719
    CREATED TIMESTAMP,
2720
    UUID VARCHAR(36),
2721
    UPDATED TIMESTAMP,
2722
    LSID_AUTHORITY VARCHAR(255),
2723
    LSID_LSID VARCHAR(255),
2724
    LSID_NAMESPACE VARCHAR(255),
2725
    LSID_OBJECT VARCHAR(255),
2726
    LSID_REVISION VARCHAR(255),
2727
    PROTECTEDTITLECACHE BOOLEAN,
2728
    TITLECACHE VARCHAR(255),
2729
    MEDIACREATED TIMESTAMP,
2730
    CREATEDBY_ID INTEGER,
2731
    UPDATEDBY_ID INTEGER,
2732
    ARTIST_ID INTEGER,
2733
    CITATIONMICROREFERENCE VARCHAR(255),
2734
    CITATION_ID INTEGER
2735
);
2736
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_AUD;
2737
CREATE CACHED TABLE PUBLIC.MEDIA_ANNOTATION(
2738
    MEDIA_ID INTEGER NOT NULL,
2739
    ANNOTATIONS_ID INTEGER NOT NULL
2740
);
2741
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_ANNOTATION;
2742
CREATE CACHED TABLE PUBLIC.MEDIA_ANNOTATION_AUD(
2743
    REV INTEGER NOT NULL,
2744
    MEDIA_ID INTEGER NOT NULL,
2745
    ANNOTATIONS_ID INTEGER NOT NULL,
2746
    REVTYPE TINYINT
2747
);
2748
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_ANNOTATION_AUD;
2749
CREATE CACHED TABLE PUBLIC.MEDIA_CREDIT(
2750
    MEDIA_ID INTEGER NOT NULL,
2751
    CREDITS_ID INTEGER NOT NULL,
2752
    SORTINDEX INTEGER NOT NULL
2753
);
2754
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_CREDIT;
2755
CREATE CACHED TABLE PUBLIC.MEDIA_CREDIT_AUD(
2756
    REV INTEGER NOT NULL,
2757
    MEDIA_ID INTEGER NOT NULL,
2758
    CREDITS_ID INTEGER NOT NULL,
2759
    SORTINDEX INTEGER NOT NULL,
2760
    REVTYPE TINYINT
2761
);
2762
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_CREDIT_AUD;
2763
CREATE CACHED TABLE PUBLIC.MEDIA_DESCRIPTION(
2764
    MEDIA_ID INTEGER NOT NULL,
2765
    DESCRIPTION_ID INTEGER NOT NULL,
2766
    DESCRIPTION_MAPKEY_ID INTEGER NOT NULL
2767
);
2768
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_DESCRIPTION;
2769
CREATE CACHED TABLE PUBLIC.MEDIA_DESCRIPTION_AUD(
2770
    REV INTEGER NOT NULL,
2771
    MEDIA_ID INTEGER NOT NULL,
2772
    DESCRIPTION_ID INTEGER NOT NULL,
2773
    DESCRIPTION_MAPKEY_ID INTEGER NOT NULL,
2774
    REVTYPE TINYINT
2775
);
2776
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_DESCRIPTION_AUD;
2777
CREATE CACHED TABLE PUBLIC.MEDIA_EXTENSION(
2778
    MEDIA_ID INTEGER NOT NULL,
2779
    EXTENSIONS_ID INTEGER NOT NULL
2780
);
2781
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_EXTENSION;
2782
CREATE CACHED TABLE PUBLIC.MEDIA_EXTENSION_AUD(
2783
    REV INTEGER NOT NULL,
2784
    MEDIA_ID INTEGER NOT NULL,
2785
    EXTENSIONS_ID INTEGER NOT NULL,
2786
    REVTYPE TINYINT
2787
);
2788
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_EXTENSION_AUD;
2789
CREATE CACHED TABLE PUBLIC.MEDIA_IDENTIFIER(
2790
    MEDIA_ID INTEGER NOT NULL,
2791
    IDENTIFIERS_ID INTEGER NOT NULL,
2792
    SORTINDEX INTEGER NOT NULL
2793
);
2794
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_IDENTIFIER;
2795
CREATE CACHED TABLE PUBLIC.MEDIA_IDENTIFIER_AUD(
2796
    REV INTEGER NOT NULL,
2797
    MEDIA_ID INTEGER NOT NULL,
2798
    IDENTIFIERS_ID INTEGER NOT NULL,
2799
    SORTINDEX INTEGER NOT NULL,
2800
    REVTYPE TINYINT
2801
);
2802
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_IDENTIFIER_AUD;
2803
CREATE CACHED TABLE PUBLIC.MEDIA_LANGUAGESTRING(
2804
    MEDIA_ID INTEGER NOT NULL,
2805
    TITLE_ID INTEGER NOT NULL,
2806
    TITLE_MAPKEY_ID INTEGER NOT NULL
2807
);
2808
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_LANGUAGESTRING;
2809
CREATE CACHED TABLE PUBLIC.MEDIA_LANGUAGESTRING_AUD(
2810
    REV INTEGER NOT NULL,
2811
    MEDIA_ID INTEGER NOT NULL,
2812
    TITLE_ID INTEGER NOT NULL,
2813
    TITLE_MAPKEY_ID INTEGER NOT NULL,
2814
    REVTYPE TINYINT
2815
);
2816
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_LANGUAGESTRING_AUD;
2817
CREATE CACHED TABLE PUBLIC.MEDIA_MARKER(
2818
    MEDIA_ID INTEGER NOT NULL,
2819
    MARKERS_ID INTEGER NOT NULL
2820
);
2821
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_MARKER;
2822
CREATE CACHED TABLE PUBLIC.MEDIA_MARKER_AUD(
2823
    REV INTEGER NOT NULL,
2824
    MEDIA_ID INTEGER NOT NULL,
2825
    MARKERS_ID INTEGER NOT NULL,
2826
    REVTYPE TINYINT
2827
);
2828
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_MARKER_AUD;
2829
CREATE CACHED TABLE PUBLIC.MEDIA_ORIGINALSOURCEBASE(
2830
    MEDIA_ID INTEGER NOT NULL,
2831
    SOURCES_ID INTEGER NOT NULL
2832
);
2833
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_ORIGINALSOURCEBASE;
2834
CREATE CACHED TABLE PUBLIC.MEDIA_ORIGINALSOURCEBASE_AUD(
2835
    REV INTEGER NOT NULL,
2836
    MEDIA_ID INTEGER NOT NULL,
2837
    SOURCES_ID INTEGER NOT NULL,
2838
    REVTYPE TINYINT
2839
);
2840
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_ORIGINALSOURCEBASE_AUD;
2841
CREATE CACHED TABLE PUBLIC.MEDIA_REPRESENTATION(
2842
    MEDIAKEY_ID INTEGER NOT NULL,
2843
    KEYREPRESENTATIONS_ID INTEGER NOT NULL
2844
);
2845
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_REPRESENTATION;
2846
CREATE CACHED TABLE PUBLIC.MEDIA_REPRESENTATION_AUD(
2847
    REV INTEGER NOT NULL,
2848
    MEDIAKEY_ID INTEGER NOT NULL,
2849
    KEYREPRESENTATIONS_ID INTEGER NOT NULL,
2850
    REVTYPE TINYINT
2851
);
2852
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_REPRESENTATION_AUD;
2853
CREATE CACHED TABLE PUBLIC.MEDIA_RIGHTSINFO(
2854
    MEDIA_ID INTEGER NOT NULL,
2855
    RIGHTS_ID INTEGER NOT NULL
2856
);
2857
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_RIGHTSINFO;
2858
CREATE CACHED TABLE PUBLIC.MEDIA_RIGHTSINFO_AUD(
2859
    REV INTEGER NOT NULL,
2860
    MEDIA_ID INTEGER NOT NULL,
2861
    RIGHTS_ID INTEGER NOT NULL,
2862
    REVTYPE TINYINT
2863
);
2864
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_RIGHTSINFO_AUD;
2865
CREATE CACHED TABLE PUBLIC.MEDIA_SEQUENCE(
2866
    PHYLOGENETICTREE_ID INTEGER NOT NULL,
2867
    USEDSEQUENCES_ID INTEGER NOT NULL
2868
);
2869
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_SEQUENCE;
2870
CREATE CACHED TABLE PUBLIC.MEDIA_SEQUENCE_AUD(
2871
    REV INTEGER NOT NULL,
2872
    PHYLOGENETICTREE_ID INTEGER NOT NULL,
2873
    USEDSEQUENCES_ID INTEGER NOT NULL,
2874
    REVTYPE TINYINT
2875
);
2876
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_SEQUENCE_AUD;
2877
CREATE CACHED TABLE PUBLIC.MULTIACCESSKEY_COVEREDTAXON(
2878
    MULTIACCESSKEY_ID INTEGER NOT NULL,
2879
    COVEREDTAXA_ID INTEGER NOT NULL
2880
);
2881
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MULTIACCESSKEY_COVEREDTAXON;
2882
CREATE CACHED TABLE PUBLIC.MULTIACCESSKEY_COVEREDTAXON_AUD(
2883
    REV INTEGER NOT NULL,
2884
    MULTIACCESSKEY_ID INTEGER NOT NULL,
2885
    COVEREDTAXA_ID INTEGER NOT NULL,
2886
    REVTYPE TINYINT
2887
);
2888
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MULTIACCESSKEY_COVEREDTAXON_AUD;
2889
CREATE CACHED TABLE PUBLIC.MULTIACCESSKEY_NAMEDAREA(
2890
    MULTIACCESSKEY_ID INTEGER NOT NULL,
2891
    GEOGRAPHICALSCOPE_ID INTEGER NOT NULL
2892
);
2893
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MULTIACCESSKEY_NAMEDAREA;
2894
CREATE CACHED TABLE PUBLIC.MULTIACCESSKEY_NAMEDAREA_AUD(
2895
    REV INTEGER NOT NULL,
2896
    MULTIACCESSKEY_ID INTEGER NOT NULL,
2897
    GEOGRAPHICALSCOPE_ID INTEGER NOT NULL,
2898
    REVTYPE TINYINT
2899
);
2900
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MULTIACCESSKEY_NAMEDAREA_AUD;
2901
CREATE CACHED TABLE PUBLIC.MULTIACCESSKEY_SCOPE(
2902
    MULTIACCESSKEY_ID INTEGER NOT NULL,
2903
    SCOPERESTRICTIONS_ID INTEGER NOT NULL
2904
);
2905
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MULTIACCESSKEY_SCOPE;
2906
CREATE CACHED TABLE PUBLIC.MULTIACCESSKEY_SCOPE_AUD(
2907
    REV INTEGER NOT NULL,
2908
    MULTIACCESSKEY_ID INTEGER NOT NULL,
2909
    SCOPERESTRICTIONS_ID INTEGER NOT NULL,
2910
    REVTYPE TINYINT
2911
);
2912
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MULTIACCESSKEY_SCOPE_AUD;
2913
CREATE CACHED TABLE PUBLIC.MULTIACCESSKEY_TAXONSCOPE(
2914
    MULTIACCESSKEY_ID INTEGER NOT NULL,
2915
    TAXONOMICSCOPE_ID INTEGER NOT NULL
2916
);
2917
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MULTIACCESSKEY_TAXON;
2918
CREATE CACHED TABLE PUBLIC.MULTIACCESSKEY_TAXONSCOPE_AUD(
2919
    REV INTEGER NOT NULL,
2920
    MULTIACCESSKEY_ID INTEGER NOT NULL,
2921
    TAXONOMICSCOPE_ID INTEGER NOT NULL,
2922
    REVTYPE TINYINT
2923
);
2924
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MULTIACCESSKEY_TAXONSCOPE_AUD;
2925
CREATE CACHED TABLE PUBLIC.NAMERELATIONSHIP(
2926
    ID INTEGER NOT NULL,
2927
    CREATED TIMESTAMP,
2928
    UUID VARCHAR(36),
2929
    UPDATED TIMESTAMP,
2930
    CITATIONMICROREFERENCE VARCHAR(255),
2931
    ORIGINALNAMESTRING VARCHAR(255),
2932
    DOUBTFUL BOOLEAN NOT NULL,
2933
    RULECONSIDERED VARCHAR(255),
2934
    CREATEDBY_ID INTEGER,
2935
    UPDATEDBY_ID INTEGER,
2936
    CITATION_ID INTEGER,
2937
    RELATEDFROM_ID INTEGER,
2938
    RELATEDTO_ID INTEGER,
2939
    TYPE_ID INTEGER
2940
);
2941
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.NAMERELATIONSHIP;
2942
CREATE CACHED TABLE PUBLIC.NAMERELATIONSHIP_AUD(
2943
    ID INTEGER NOT NULL,
2944
    REV INTEGER NOT NULL,
2945
    REVTYPE TINYINT,
2946
    CREATED TIMESTAMP,
2947
    UUID VARCHAR(36),
2948
    UPDATED TIMESTAMP,
2949
    CITATIONMICROREFERENCE VARCHAR(255),
2950
    ORIGINALNAMESTRING VARCHAR(255),
2951
    DOUBTFUL BOOLEAN,
2952
    RULECONSIDERED VARCHAR(255),
2953
    CREATEDBY_ID INTEGER,
2954
    UPDATEDBY_ID INTEGER,
2955
    CITATION_ID INTEGER,
2956
    RELATEDFROM_ID INTEGER,
2957
    RELATEDTO_ID INTEGER,
2958
    TYPE_ID INTEGER
2959
);
2960
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.NAMERELATIONSHIP_AUD;
2961
CREATE CACHED TABLE PUBLIC.NAMERELATIONSHIP_ANNOTATION(
2962
    NAMERELATIONSHIP_ID INTEGER NOT NULL,
2963
    ANNOTATIONS_ID INTEGER NOT NULL
2964
);
2965
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.NAMERELATIONSHIP_ANNOTATION;
2966
CREATE CACHED TABLE PUBLIC.NAMERELATIONSHIP_ANNOTATION_AUD(
2967
    REV INTEGER NOT NULL,
2968
    NAMERELATIONSHIP_ID INTEGER NOT NULL,
2969
    ANNOTATIONS_ID INTEGER NOT NULL,
2970
    REVTYPE TINYINT
2971
);
2972
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.NAMERELATIONSHIP_ANNOTATION_AUD;
2973
CREATE CACHED TABLE PUBLIC.NAMERELATIONSHIP_MARKER(
2974
    NAMERELATIONSHIP_ID INTEGER NOT NULL,
2975
    MARKERS_ID INTEGER NOT NULL
2976
);
2977
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.NAMERELATIONSHIP_MARKER;
2978
CREATE CACHED TABLE PUBLIC.NAMERELATIONSHIP_MARKER_AUD(
2979
    REV INTEGER NOT NULL,
2980
    NAMERELATIONSHIP_ID INTEGER NOT NULL,
2981
    MARKERS_ID INTEGER NOT NULL,
2982
    REVTYPE TINYINT
2983
);
2984
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.NAMERELATIONSHIP_MARKER_AUD;
2985
CREATE CACHED TABLE PUBLIC.NOMENCLATURALSTATUS(
2986
    ID INTEGER NOT NULL,
2987
    CREATED TIMESTAMP,
2988
    UUID VARCHAR(36),
2989
    UPDATED TIMESTAMP,
2990
    CITATIONMICROREFERENCE VARCHAR(255),
2991
    ORIGINALNAMESTRING VARCHAR(255),
2992
    RULECONSIDERED VARCHAR(255),
2993
    CREATEDBY_ID INTEGER,
2994
    UPDATEDBY_ID INTEGER,
2995
    CITATION_ID INTEGER,
2996
    TYPE_ID INTEGER
2997
);
2998
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.NOMENCLATURALSTATUS;
2999
CREATE CACHED TABLE PUBLIC.NOMENCLATURALSTATUS_AUD(
3000
    ID INTEGER NOT NULL,
3001
    REV INTEGER NOT NULL,
3002
    REVTYPE TINYINT,
3003
    CREATED TIMESTAMP,
3004
    UUID VARCHAR(36),
3005
    UPDATED TIMESTAMP,
3006
    CITATIONMICROREFERENCE VARCHAR(255),
3007
    ORIGINALNAMESTRING VARCHAR(255),
3008
    RULECONSIDERED VARCHAR(255),
3009
    CREATEDBY_ID INTEGER,
3010
    UPDATEDBY_ID INTEGER,
3011
    CITATION_ID INTEGER,
3012
    TYPE_ID INTEGER
3013
);
3014
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.NOMENCLATURALSTATUS_AUD;
3015
CREATE CACHED TABLE PUBLIC.NOMENCLATURALSTATUS_ANNOTATION(
3016
    NOMENCLATURALSTATUS_ID INTEGER NOT NULL,
3017
    ANNOTATIONS_ID INTEGER NOT NULL
3018
);
3019
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.NOMENCLATURALSTATUS_ANNOTATION;
3020
CREATE CACHED TABLE PUBLIC.NOMENCLATURALSTATUS_ANNOTATION_AUD(
3021
    REV INTEGER NOT NULL,
3022
    NOMENCLATURALSTATUS_ID INTEGER NOT NULL,
3023
    ANNOTATIONS_ID INTEGER NOT NULL,
3024
    REVTYPE TINYINT
3025
);
3026
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.NOMENCLATURALSTATUS_ANNOTATION_AUD;
3027
CREATE CACHED TABLE PUBLIC.NOMENCLATURALSTATUS_MARKER(
3028
    NOMENCLATURALSTATUS_ID INTEGER NOT NULL,
3029
    MARKERS_ID INTEGER NOT NULL
3030
);
3031
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.NOMENCLATURALSTATUS_MARKER;
3032
CREATE CACHED TABLE PUBLIC.NOMENCLATURALSTATUS_MARKER_AUD(
3033
    REV INTEGER NOT NULL,
3034
    NOMENCLATURALSTATUS_ID INTEGER NOT NULL,
3035
    MARKERS_ID INTEGER NOT NULL,
3036
    REVTYPE TINYINT
3037
);
3038
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.NOMENCLATURALSTATUS_MARKER_AUD;
3039
CREATE CACHED TABLE PUBLIC.ORIGINALSOURCEBASE(
3040
    DTYPE VARCHAR(31) NOT NULL,
3041
    ID INTEGER NOT NULL,
3042
    CREATED TIMESTAMP,
3043
    UUID VARCHAR(36),
3044
    UPDATED TIMESTAMP,
3045
    SOURCETYPE VARCHAR(4) NOT NULL,
3046
    CITATIONMICROREFERENCE VARCHAR(255),
3047
    ORIGINALNAMESTRING VARCHAR(255),
3048
    IDINSOURCE VARCHAR(255),
3049
    IDNAMESPACE VARCHAR(255),
3050
    CREATEDBY_ID INTEGER,
3051
    UPDATEDBY_ID INTEGER,
3052
    CITATION_ID INTEGER,
3053
    NAMEUSEDINSOURCE_ID INTEGER
3054
);
3055
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ORIGINALSOURCEBASE;
3056
CREATE CACHED TABLE PUBLIC.ORIGINALSOURCEBASE_AUD(
3057
    DTYPE VARCHAR(31) NOT NULL,
3058
    ID INTEGER NOT NULL,
3059
    REV INTEGER NOT NULL,
3060
    REVTYPE TINYINT,
3061
    CREATED TIMESTAMP,
3062
    UUID VARCHAR(36),
3063
    UPDATED TIMESTAMP,
3064
           SOURCETYPE VARCHAR(4) NOT NULL,
3065
    CITATIONMICROREFERENCE VARCHAR(255),
3066
    ORIGINALNAMESTRING VARCHAR(255),
3067
    IDINSOURCE VARCHAR(255),
3068
    IDNAMESPACE VARCHAR(255),
3069
    CREATEDBY_ID INTEGER,
3070
    UPDATEDBY_ID INTEGER,
3071
    CITATION_ID INTEGER,
3072
    NAMEUSEDINSOURCE_ID INTEGER
3073
);
3074
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ORIGINALSOURCEBASE_AUD;
3075
CREATE CACHED TABLE PUBLIC.ORIGINALSOURCEBASE_ANNOTATION(
3076
    ORIGINALSOURCEBASE_ID INTEGER NOT NULL,
3077
    ANNOTATIONS_ID INTEGER NOT NULL
3078
);
3079
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ORIGINALSOURCEBASE_ANNOTATION;
3080
CREATE CACHED TABLE PUBLIC.ORIGINALSOURCEBASE_ANNOTATION_AUD(
3081
    REV INTEGER NOT NULL,
3082
    ORIGINALSOURCEBASE_ID INTEGER NOT NULL,
3083
    ANNOTATIONS_ID INTEGER NOT NULL,
3084
    REVTYPE TINYINT
3085
);
3086
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ORIGINALSOURCEBASE_ANNOTATION_AUD;
3087
CREATE CACHED TABLE PUBLIC.ORIGINALSOURCEBASE_MARKER(
3088
    ORIGINALSOURCEBASE_ID INTEGER NOT NULL,
3089
    MARKERS_ID INTEGER NOT NULL
3090
);
3091
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ORIGINALSOURCEBASE_MARKER;
3092
CREATE CACHED TABLE PUBLIC.ORIGINALSOURCEBASE_MARKER_AUD(
3093
    REV INTEGER NOT NULL,
3094
    ORIGINALSOURCEBASE_ID INTEGER NOT NULL,
3095
    MARKERS_ID INTEGER NOT NULL,
3096
    REVTYPE TINYINT
3097
);
3098
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ORIGINALSOURCEBASE_MARKER_AUD;
3099
CREATE CACHED TABLE PUBLIC.PERMISSIONGROUP(
3100
    ID INTEGER NOT NULL,
3101
    CREATED TIMESTAMP,
3102
    UUID VARCHAR(36),
3103
    NAME VARCHAR(255) NOT NULL,
3104
    CREATEDBY_ID INTEGER
3105
);
3106
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.PERMISSIONGROUP;
3107
CREATE CACHED TABLE PUBLIC.PERMISSIONGROUP_GRANTEDAUTHORITYIMPL(
3108
    GROUP_ID INTEGER NOT NULL,
3109
    GRANTEDAUTHORITIES_ID INTEGER NOT NULL
3110
);
3111
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.PERMISSIONGROUP_GRANTEDAUTHORITYIMPL;
3112
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY(
3113
    ID INTEGER NOT NULL,
3114
    CREATED TIMESTAMP,
3115
    UUID VARCHAR(36),
3116
    UPDATED TIMESTAMP,
3117
    LSID_AUTHORITY VARCHAR(255),
3118
    LSID_LSID VARCHAR(255),
3119
    LSID_NAMESPACE VARCHAR(255),
3120
    LSID_OBJECT VARCHAR(255),
3121
    LSID_REVISION VARCHAR(255),
3122
    PROTECTEDTITLECACHE BOOLEAN NOT NULL,
3123
    TITLECACHE VARCHAR(255),
3124
    STARTNUMBER INTEGER,
3125
    CREATEDBY_ID INTEGER,
3126
    UPDATEDBY_ID INTEGER,
3127
    ROOT_ID INTEGER
3128
);
3129
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY;
3130
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEYNODE(
3131
    ID INTEGER NOT NULL,
3132
    CREATED TIMESTAMP,
3133
    UUID VARCHAR(36),
3134
    UPDATED TIMESTAMP,
3135
    NODENUMBER INTEGER,
3136
    SORTINDEX INTEGER,
3137
    CREATEDBY_ID INTEGER,
3138
    UPDATEDBY_ID INTEGER,
3139
    FEATURE_ID INTEGER,
3140
    KEY_ID INTEGER,
3141
    OTHERNODE_ID INTEGER,
3142
    PARENT_ID INTEGER,
3143
    QUESTION_ID INTEGER,
3144
    STATEMENT_ID INTEGER,
3145
    SUBKEY_ID INTEGER,
3146
    TAXON_ID INTEGER
3147
);
3148
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEYNODE;
3149
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEYNODE_AUD(
3150
    ID INTEGER NOT NULL,
3151
    REV INTEGER NOT NULL,
3152
    REVTYPE TINYINT,
3153
    CREATED TIMESTAMP,
3154
    UUID VARCHAR(36),
3155
    UPDATED TIMESTAMP,
3156
    NODENUMBER INTEGER,
3157
    SORTINDEX INTEGER,
3158
    CREATEDBY_ID INTEGER,
3159
    UPDATEDBY_ID INTEGER,
3160
    FEATURE_ID INTEGER,
3161
    KEY_ID INTEGER,
3162
    OTHERNODE_ID INTEGER,
3163
    PARENT_ID INTEGER,
3164
    QUESTION_ID INTEGER,
3165
    STATEMENT_ID INTEGER,
3166
    SUBKEY_ID INTEGER,
3167
    TAXON_ID INTEGER
3168
);
3169
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEYNODE_AUD;
3170
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEYNODE_LANGUAGESTRING(
3171
    POLYTOMOUSKEYNODE_ID INTEGER NOT NULL,
3172
    MODIFYINGTEXT_ID INTEGER NOT NULL,
3173
    MODIFYINGTEXT_MAPKEY_ID INTEGER NOT NULL
3174
);
3175
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEYNODE_LANGUAGESTRING;
3176
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEYNODE_LANGUAGESTRING_AUD(
3177
    REV INTEGER NOT NULL,
3178
    POLYTOMOUSKEYNODE_ID INTEGER NOT NULL,
3179
    MODIFYINGTEXT_ID INTEGER NOT NULL,
3180
    MODIFYINGTEXT_MAPKEY_ID INTEGER NOT NULL,
3181
    REVTYPE TINYINT
3182
);
3183
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEYNODE_LANGUAGESTRING_AUD;
3184
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_AUD(
3185
    ID INTEGER NOT NULL,
3186
    REV INTEGER NOT NULL,
3187
    REVTYPE TINYINT,
3188
    CREATED TIMESTAMP,
3189
    UUID VARCHAR(36),
3190
    UPDATED TIMESTAMP,
3191
    LSID_AUTHORITY VARCHAR(255),
3192
    LSID_LSID VARCHAR(255),
3193
    LSID_NAMESPACE VARCHAR(255),
3194
    LSID_OBJECT VARCHAR(255),
3195
    LSID_REVISION VARCHAR(255),
3196
    PROTECTEDTITLECACHE BOOLEAN,
3197
    TITLECACHE VARCHAR(255),
3198
    STARTNUMBER INTEGER,
3199
    CREATEDBY_ID INTEGER,
3200
    UPDATEDBY_ID INTEGER,
3201
    ROOT_ID INTEGER
3202
);
3203
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_AUD;
3204
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_ANNOTATION(
3205
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
3206
    ANNOTATIONS_ID INTEGER NOT NULL
3207
);
3208
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_ANNOTATION;
3209
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_ANNOTATION_AUD(
3210
    REV INTEGER NOT NULL,
3211
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
3212
    ANNOTATIONS_ID INTEGER NOT NULL,
3213
    REVTYPE TINYINT
3214
);
3215
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_ANNOTATION_AUD;
3216
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_CREDIT(
3217
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
3218
    CREDITS_ID INTEGER NOT NULL,
3219
    SORTINDEX INTEGER NOT NULL
3220
);
3221
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_CREDIT;
3222
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_CREDIT_AUD(
3223
    REV INTEGER NOT NULL,
3224
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
3225
    CREDITS_ID INTEGER NOT NULL,
3226
    SORTINDEX INTEGER NOT NULL,
3227
    REVTYPE TINYINT
3228
);
3229
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_CREDIT_AUD;
3230
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_EXTENSION(
3231
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
3232
    EXTENSIONS_ID INTEGER NOT NULL
3233
);
3234
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_EXTENSION;
3235
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_EXTENSION_AUD(
3236
    REV INTEGER NOT NULL,
3237
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
3238
    EXTENSIONS_ID INTEGER NOT NULL,
3239
    REVTYPE TINYINT
3240
);
3241
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_EXTENSION_AUD;
3242
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_IDENTIFIER(
3243
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
3244
    IDENTIFIERS_ID INTEGER NOT NULL,
3245
    SORTINDEX INTEGER NOT NULL
3246
);
3247
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_IDENTIFIER;
3248
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_IDENTIFIER_AUD(
3249
    REV INTEGER NOT NULL,
3250
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
3251
    IDENTIFIERS_ID INTEGER NOT NULL,
3252
    SORTINDEX INTEGER NOT NULL,
3253
    REVTYPE TINYINT
3254
);
3255
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_IDENTIFIER_AUD;
3256
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_MARKER(
3257
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
3258
    MARKERS_ID INTEGER NOT NULL
3259
);
3260
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_MARKER;
3261
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_MARKER_AUD(
3262
    REV INTEGER NOT NULL,
3263
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
3264
    MARKERS_ID INTEGER NOT NULL,
3265
    REVTYPE TINYINT
3266
);
3267
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_MARKER_AUD;
3268
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_NAMEDAREA(
3269
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
3270
    GEOGRAPHICALSCOPE_ID INTEGER NOT NULL
3271
);
3272
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_NAMEDAREA;
3273
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_NAMEDAREA_AUD(
3274
    REV INTEGER NOT NULL,
3275
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
3276
    GEOGRAPHICALSCOPE_ID INTEGER NOT NULL,
3277
    REVTYPE TINYINT
3278
);
3279
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_NAMEDAREA_AUD;
3280
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_ORIGINALSOURCEBASE(
3281
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
3282
    SOURCES_ID INTEGER NOT NULL
3283
);
3284
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_ORIGINALSOURCEBASE;
3285
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_ORIGINALSOURCEBASE_AUD(
3286
    REV INTEGER NOT NULL,
3287
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
3288
    SOURCES_ID INTEGER NOT NULL,
3289
    REVTYPE TINYINT
3290
);
3291
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_ORIGINALSOURCEBASE_AUD;
3292
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_RIGHTSINFO(
3293
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
3294
    RIGHTS_ID INTEGER NOT NULL
3295
);
3296
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_RIGHTSINFO;
3297
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_RIGHTSINFO_AUD(
3298
    REV INTEGER NOT NULL,
3299
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
3300
    RIGHTS_ID INTEGER NOT NULL,
3301
    REVTYPE TINYINT
3302
);
3303
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_RIGHTSINFO_AUD;
3304
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_SCOPE(
3305
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
3306
    SCOPERESTRICTIONS_ID INTEGER NOT NULL
3307
);
3308
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_SCOPE;
3309
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_SCOPE_AUD(
3310
    REV INTEGER NOT NULL,
3311
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
3312
    SCOPERESTRICTIONS_ID INTEGER NOT NULL,
3313
    REVTYPE TINYINT
3314
);
3315
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_SCOPE_AUD;
3316
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_TAXON(
3317
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
3318
    TAXON_ID INTEGER NOT NULL
3319
);
3320
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_TAXON;
3321
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_TAXONBASE(
3322
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
3323
    COVEREDTAXA_ID INTEGER NOT NULL
3324
);
3325
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_TAXONBASE;
3326
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_TAXONBASE_AUD(
3327
    REV INTEGER NOT NULL,
3328
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
3329
    COVEREDTAXA_ID INTEGER NOT NULL,
3330
    REVTYPE TINYINT
3331
);
3332
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_TAXONBASE_AUD;
3333
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_TAXON_AUD(
3334
    REV INTEGER NOT NULL,
3335
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
3336
    TAXON_ID INTEGER NOT NULL,
3337
    REVTYPE TINYINT
3338
);
3339
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_TAXON_AUD;
3340

    
3341
CREATE TABLE PRIMER (
3342
    ID INTEGER NOT NULL,
3343
    CREATED TIMESTAMP,
3344
    UUID VARCHAR(36),
3345
    UPDATED TIMESTAMP,
3346
    LABEL VARCHAR(255),
3347
        SEQUENCE_LENGTH INTEGER,
3348
        SEQUENCE_STRING CLOB,
3349
    CREATEDBY_ID INTEGER,
3350
    UPDATEDBY_ID INTEGER,
3351
    DNAMARKER_ID INTEGER,
3352
        PUBLISHEDIN_ID INTEGER,
3353
        PRIMARY KEY (ID)
3354
);
3355
CREATE TABLE PRIMER_AUD (
3356
    ID INTEGER NOT NULL,
3357
    CREATED TIMESTAMP,
3358
    UUID VARCHAR(36),
3359
    UPDATED TIMESTAMP,
3360
    LABEL VARCHAR(255),
3361
    SEQUENCE_LENGTH INTEGER,
3362
    SEQUENCE_STRING CLOB,
3363
    CREATEDBY_ID INTEGER,
3364
    UPDATEDBY_ID INTEGER,
3365
        DNAMARKER_ID INTEGER,
3366
        PUBLISHEDIN_ID INTEGER,
3367
);
3368

    
3369
CREATE TABLE PRIMER_ANNOTATION (
3370
    PRIMER_ID INTEGER NOT NULL,
3371
    ANNOTATIONS_ID INTEGER NOT NULL,
3372
    PRIMARY KEY (PRIMER_ID, ANNOTATIONS_ID)
3373
);
3374
CREATE TABLE PRIMER_ANNOTATION_AUD (
3375
    PRIMER_ID INTEGER NOT NULL,
3376
    ANNOTATIONS_ID INTEGER NOT NULL
3377
);
3378

    
3379
CREATE TABLE PRIMER_MARKER (
3380
    PRIMER_ID INTEGER NOT NULL,
3381
    MARKERS_ID INTEGER NOT NULL,
3382
    PRIMARY KEY (PRIMER_ID, MARKERS_ID)
3383
);
3384
CREATE TABLE PRIMER_MARKER_AUD (
3385
    PRIMER_ID INTEGER NOT NULL,
3386
    MARKERS_ID INTEGER NOT NULL
3387
);
3388

    
3389

    
3390
CREATE CACHED TABLE PUBLIC.REFERENCE(
3391
    ID INTEGER NOT NULL,
3392
    CREATED TIMESTAMP,
3393
    UUID VARCHAR(36),
3394
    UPDATED TIMESTAMP,
3395
    LSID_AUTHORITY VARCHAR(255),
3396
    LSID_LSID VARCHAR(255),
3397
    LSID_NAMESPACE VARCHAR(255),
3398
    LSID_OBJECT VARCHAR(255),
3399
    LSID_REVISION VARCHAR(255),
3400
    PROTECTEDTITLECACHE BOOLEAN NOT NULL,
3401
    TITLECACHE VARCHAR(800),
3402
    DATEPUBLISHED_END VARCHAR(255),
3403
    DATEPUBLISHED_FREETEXT VARCHAR(255),
3404
    DATEPUBLISHED_START VARCHAR(255),
3405
    EDITION VARCHAR(255),
3406
    EDITOR VARCHAR(255),
3407
    ISBN VARCHAR(255),
3408
    ISSN VARCHAR(255),
3409
    DOI VARCHAR(255),
3410
    NOMENCLATURALLYRELEVANT BOOLEAN NOT NULL,
3411
    ORGANIZATION VARCHAR(255),
3412
    PAGES VARCHAR(255),
3413
    PARSINGPROBLEM INTEGER NOT NULL,
3414
    PLACEPUBLISHED VARCHAR(255),
3415
    PROBLEMENDS INTEGER NOT NULL,
3416
    PROBLEMSTARTS INTEGER NOT NULL,
3417
    PUBLISHER VARCHAR(255),
3418
    REFERENCEABSTRACT CLOB,
3419
    SERIESPART VARCHAR(255),
3420
    TITLE CLOB,
3421
    ABBREVTITLE VARCHAR(255),
3422
    ABBREVTITLECACHE CLOB,
3423
    PROTECTEDABBREVTITLECACHE BOOLEAN,
3424
    REFTYPE VARCHAR(4),
3425
    URI CLOB,
3426
    VOLUME VARCHAR(255),
3427
    ACCESSED TIMESTAMP,
3428
    LASTRETRIEVED TIMESTAMP,
3429
    EXTERNALID VARCHAR(255),
3430
    EXTERNALLINK CLOB,
3431
    AUTHORITYTYPE  VARCHAR(10) NOT NULL,
3432
    CREATEDBY_ID INTEGER,
3433
    UPDATEDBY_ID INTEGER,
3434
    AUTHORSHIP_ID INTEGER,
3435
    INREFERENCE_ID INTEGER,
3436
    INSTITUTION_ID INTEGER,
3437
    SCHOOL_ID INTEGER
3438
);
3439
-- 1 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE;
3440
CREATE INDEX PUBLIC.REFERENCETITLECACHEINDEX ON PUBLIC.REFERENCE(TITLECACHE);
3441
CREATE CACHED TABLE PUBLIC.REFERENCE_AUD(
3442
    ID INTEGER NOT NULL,
3443
    REV INTEGER NOT NULL,
3444
    REVTYPE TINYINT,
3445
    CREATED TIMESTAMP,
3446
    UUID VARCHAR(36),
3447
    UPDATED TIMESTAMP,
3448
    LSID_AUTHORITY VARCHAR(255),
3449
    LSID_LSID VARCHAR(255),
3450
    LSID_NAMESPACE VARCHAR(255),
3451
    LSID_OBJECT VARCHAR(255),
3452
    LSID_REVISION VARCHAR(255),
3453
    PROTECTEDTITLECACHE BOOLEAN,
3454
    TITLECACHE VARCHAR(800),
3455
    DATEPUBLISHED_END VARCHAR(255),
3456
    DATEPUBLISHED_FREETEXT VARCHAR(255),
3457
    DATEPUBLISHED_START VARCHAR(255),
3458
    EDITION VARCHAR(255),
3459
    EDITOR VARCHAR(255),
3460
    ISBN VARCHAR(255),
3461
    ISSN VARCHAR(255),
3462
    DOI VARCHAR(255),
3463
    NOMENCLATURALLYRELEVANT BOOLEAN,
3464
    ORGANIZATION VARCHAR(255),
3465
    PAGES VARCHAR(255),
3466
    PARSINGPROBLEM INTEGER,
3467
    PLACEPUBLISHED VARCHAR(255),
3468
    PROBLEMENDS INTEGER,
3469
    PROBLEMSTARTS INTEGER,
3470
    PUBLISHER VARCHAR(255),
3471
    REFERENCEABSTRACT CLOB,
3472
    SERIESPART VARCHAR(255),
3473
    TITLE CLOB,
3474
    ABBREVTITLE VARCHAR(255),
3475
    ABBREVTITLECACHE CLOB,
3476
    PROTECTEDABBREVTITLECACHE BOOLEAN,
3477
    REFTYPE  VARCHAR(4),
3478
    URI CLOB,
3479
    VOLUME VARCHAR(255),
3480
    ACCESSED TIMESTAMP,
3481
    LASTRETRIEVED TIMESTAMP,
3482
    EXTERNALID VARCHAR(255),
3483
    EXTERNALLINK CLOB,
3484
    AUTHORITYTYPE  VARCHAR(10) NOT NULL,
3485
    CREATEDBY_ID INTEGER,
3486
    UPDATEDBY_ID INTEGER,
3487
    AUTHORSHIP_ID INTEGER,
3488
    INREFERENCE_ID INTEGER,
3489
    INSTITUTION_ID INTEGER,
3490
    SCHOOL_ID INTEGER
3491
);
3492
-- 1 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_AUD;
3493
CREATE CACHED TABLE PUBLIC.REFERENCE_ANNOTATION(
3494
    REFERENCE_ID INTEGER NOT NULL,
3495
    ANNOTATIONS_ID INTEGER NOT NULL
3496
);
3497
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_ANNOTATION;
3498
CREATE CACHED TABLE PUBLIC.REFERENCE_ANNOTATION_AUD(
3499
    REV INTEGER NOT NULL,
3500
    REFERENCE_ID INTEGER NOT NULL,
3501
    ANNOTATIONS_ID INTEGER NOT NULL,
3502
    REVTYPE TINYINT
3503
);
3504
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_ANNOTATION_AUD;
3505
CREATE CACHED TABLE PUBLIC.REFERENCE_CREDIT(
3506
    REFERENCE_ID INTEGER NOT NULL,
3507
    CREDITS_ID INTEGER NOT NULL,
3508
    SORTINDEX INTEGER NOT NULL
3509
);
3510
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_CREDIT;
3511
CREATE CACHED TABLE PUBLIC.REFERENCE_CREDIT_AUD(
3512
    REV INTEGER NOT NULL,
3513
    REFERENCE_ID INTEGER NOT NULL,
3514
    CREDITS_ID INTEGER NOT NULL,
3515
    SORTINDEX INTEGER NOT NULL,
3516
    REVTYPE TINYINT
3517
);
3518
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_CREDIT_AUD;
3519
CREATE CACHED TABLE PUBLIC.REFERENCE_EXTENSION(
3520
    REFERENCE_ID INTEGER NOT NULL,
3521
    EXTENSIONS_ID INTEGER NOT NULL
3522
);
3523
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_EXTENSION;
3524
CREATE CACHED TABLE PUBLIC.REFERENCE_EXTENSION_AUD(
3525
    REV INTEGER NOT NULL,
3526
    REFERENCE_ID INTEGER NOT NULL,
3527
    EXTENSIONS_ID INTEGER NOT NULL,
3528
    REVTYPE TINYINT
3529
);
3530
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_EXTENSION_AUD;
3531
CREATE CACHED TABLE PUBLIC.REFERENCE_IDENTIFIER(
3532
    REFERENCE_ID INTEGER NOT NULL,
3533
    IDENTIFIERS_ID INTEGER NOT NULL,
3534
    SORTINDEX INTEGER NOT NULL
3535
);
3536
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_IDENTIFIER;
3537
CREATE CACHED TABLE PUBLIC.REFERENCE_IDENTIFIER_AUD(
3538
    REV INTEGER NOT NULL,
3539
    REFERENCE_ID INTEGER NOT NULL,
3540
    IDENTIFIERS_ID INTEGER NOT NULL,
3541
    SORTINDEX INTEGER NOT NULL,
3542
    REVTYPE TINYINT
3543
);
3544
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_IDENTIFIER_AUD;
3545
CREATE CACHED TABLE PUBLIC.REFERENCE_MARKER(
3546
    REFERENCE_ID INTEGER NOT NULL,
3547
    MARKERS_ID INTEGER NOT NULL
3548
);
3549
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_MARKER;
3550
CREATE CACHED TABLE PUBLIC.REFERENCE_MARKER_AUD(
3551
    REV INTEGER NOT NULL,
3552
    REFERENCE_ID INTEGER NOT NULL,
3553
    MARKERS_ID INTEGER NOT NULL,
3554
    REVTYPE TINYINT
3555
);
3556
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_MARKER_AUD;
3557
CREATE CACHED TABLE PUBLIC.REFERENCE_MEDIA(
3558
    REFERENCE_ID INTEGER NOT NULL,
3559
    MEDIA_ID INTEGER NOT NULL
3560
);
3561
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_MEDIA;
3562
CREATE CACHED TABLE PUBLIC.REFERENCE_MEDIA_AUD(
3563
    REV INTEGER NOT NULL,
3564
    REFERENCE_ID INTEGER NOT NULL,
3565
    MEDIA_ID INTEGER NOT NULL,
3566
    REVTYPE TINYINT
3567
);
3568
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_MEDIA_AUD;
3569
CREATE CACHED TABLE PUBLIC.REFERENCE_ORIGINALSOURCEBASE(
3570
    REFERENCE_ID INTEGER NOT NULL,
3571
    SOURCES_ID INTEGER NOT NULL
3572
);
3573
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_ORIGINALSOURCEBASE;
3574
CREATE CACHED TABLE PUBLIC.REFERENCE_ORIGINALSOURCEBASE_AUD(
3575
    REV INTEGER NOT NULL,
3576
    REFERENCE_ID INTEGER NOT NULL,
3577
    SOURCES_ID INTEGER NOT NULL,
3578
    REVTYPE TINYINT
3579
);
3580
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_ORIGINALSOURCEBASE_AUD;
3581
CREATE CACHED TABLE PUBLIC.REFERENCE_RIGHTSINFO(
3582
    REFERENCE_ID INTEGER NOT NULL,
3583
    RIGHTS_ID INTEGER NOT NULL
3584
);
3585
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_RIGHTSINFO;
3586
CREATE CACHED TABLE PUBLIC.REFERENCE_RIGHTSINFO_AUD(
3587
    REV INTEGER NOT NULL,
3588
    REFERENCE_ID INTEGER NOT NULL,
3589
    RIGHTS_ID INTEGER NOT NULL,
3590
    REVTYPE TINYINT
3591
);
3592
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_RIGHTSINFO_AUD;
3593
CREATE CACHED TABLE PUBLIC.REGISTRATION(
3594
    ID INTEGER NOT NULL,
3595
    CREATED TIMESTAMP,
3596
    UUID VARCHAR(36),
3597
    UPDATED TIMESTAMP,
3598
        IDENTIFIER VARCHAR(255),
3599
        REGISTRATIONDATE TIMESTAMP,
3600
        SPECIFICIDENTIFIER VARCHAR(255),
3601
        STATUS VARCHAR(255),
3602
    CREATEDBY_ID INTEGER,
3603
    UPDATEDBY_ID INTEGER,
3604
        INSTITUTION_ID INTEGER,
3605
        NAME_ID INTEGER,
3606
        SUBMITTER_ID INTEGER
3607
);
3608
-- 2175 +/- SELECT COUNT(*) FROM PUBLIC.REGISTRATION;
3609
CREATE CACHED TABLE PUBLIC.REGISTRATION_AUD(
3610
    ID INTEGER NOT NULL,
3611
    REV INTEGER NOT NULL,
3612
    REVTYPE TINYINT,
3613
    CREATED TIMESTAMP,
3614
    UUID VARCHAR(36),
3615
    UPDATED TIMESTAMP,
3616
        IDENTIFIER VARCHAR(255),
3617
        REGISTRATIONDATE TIMESTAMP,
3618
        SPECIFICIDENTIFIER VARCHAR(255),
3619
        STATUS VARCHAR(255),
3620
    CREATEDBY_ID INTEGER,
3621
    UPDATEDBY_ID INTEGER,
3622
        INSTITUTION_ID INTEGER,
3623
        NAME_ID INTEGER,
3624
        SUBMITTER_ID INTEGER
3625
);
3626
-- 2175 +/- SELECT COUNT(*) FROM PUBLIC.REGISTRATION_AUD;
3627
CREATE CACHED TABLE PUBLIC.REGISTRATION_ANNOTATION(
3628
    REGISTRATION_ID INTEGER NOT NULL,
3629
    ANNOTATIONS_ID INTEGER NOT NULL
3630
);
3631
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REGISTRATION_ANNOTATION;
3632
CREATE CACHED TABLE PUBLIC.REGISTRATION_ANNOTATION_AUD(
3633
    REV INTEGER NOT NULL,
3634
    REGISTRATION_ID INTEGER NOT NULL,
3635
    ANNOTATIONS_ID INTEGER NOT NULL,
3636
    REVTYPE TINYINT
3637
);
3638
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REPRESENTATION_ANNOTATION_AUD;
3639
CREATE CACHED TABLE PUBLIC.REGISTRATION_MARKER(
3640
    REGISTRATION_ID INTEGER NOT NULL,
3641
    MARKERS_ID INTEGER NOT NULL
3642
);
3643
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REGISTRATION_MARKER;
3644
CREATE CACHED TABLE PUBLIC.REGISTRATION_MARKER_AUD(
3645
    REV INTEGER NOT NULL,
3646
    REGISTRATION_ID INTEGER NOT NULL,
3647
    MARKERS_ID INTEGER NOT NULL,
3648
    REVTYPE TINYINT
3649
);
3650
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REGISTRATION_MARKER_AUD;
3651
CREATE CACHED TABLE PUBLIC.REGISTRATION_REGISTRATION(
3652
    REGISTRATION_ID INTEGER NOT NULL,
3653
    BLOCKEDBY_ID INTEGER NOT NULL
3654
);
3655
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REGISTRATION_REGISTRATION;
3656
CREATE CACHED TABLE PUBLIC.REGISTRATION_REGISTRATION_AUD(
3657
    REV INTEGER NOT NULL,
3658
    REGISTRATION_ID INTEGER NOT NULL,
3659
    BLOCKEDBY_ID INTEGER NOT NULL,
3660
    REVTYPE TINYINT
3661
);
3662
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REGISTRATION_REGISTRATION_AUD;
3663
CREATE CACHED TABLE PUBLIC.REGISTRATION_TYPEDESIGNATIONBASE(
3664
    REGISTRATIONS_ID INTEGER NOT NULL,
3665
    TYPEDESIGNATIONS_ID INTEGER NOT NULL
3666
);
3667
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REGISTRATION_TYPEDESIGNATIONBASE;
3668
CREATE CACHED TABLE PUBLIC.REGISTRATION_TYPEDESIGNATIONBASE_AUD(
3669
    REV INTEGER NOT NULL,
3670
    REGISTRATIONS_ID INTEGER NOT NULL,
3671
    TYPEDESIGNATIONS_ID INTEGER NOT NULL,
3672
    REVTYPE TINYINT
3673
);
3674
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REGISTRATION_TYPEDESIGNATIONBASE_AUD;
3675

    
3676
CREATE CACHED TABLE PUBLIC.TERMBASE_INVERSEREPRESENTATION(
3677
    TERM_ID INTEGER NOT NULL,
3678
    INVERSEREPRESENTATIONS_ID INTEGER NOT NULL
3679
);
3680
-- 54 +/- SELECT COUNT(*) FROM PUBLIC.TERMBASE_INVERSEREPRESENTATION;
3681
CREATE CACHED TABLE PUBLIC.TERMBASE_INVERSEREPRESENTATION_AUD(
3682
    REV INTEGER NOT NULL,
3683
    TERM_ID INTEGER NOT NULL,
3684
    INVERSEREPRESENTATIONS_ID INTEGER NOT NULL,
3685
    REVTYPE TINYINT
3686
);
3687
-- 54 +/- SELECT COUNT(*) FROM PUBLIC.TERMBASE_INVERSEREPRESENTATION_AUD;
3688
CREATE CACHED TABLE PUBLIC.REPRESENTATION(
3689
    ID INTEGER NOT NULL,
3690
    CREATED TIMESTAMP,
3691
    UUID VARCHAR(36),
3692
    UPDATED TIMESTAMP,
3693
    TEXT CLOB,
3694
    ABBREVIATEDLABEL VARCHAR(255),
3695
    LABEL VARCHAR(255),
3696
    CREATEDBY_ID INTEGER,
3697
    UPDATEDBY_ID INTEGER,
3698
    LANGUAGE_ID INTEGER
3699
);
3700
-- 2175 +/- SELECT COUNT(*) FROM PUBLIC.REPRESENTATION;
3701
CREATE CACHED TABLE PUBLIC.REPRESENTATION_AUD(
3702
    ID INTEGER NOT NULL,
3703
    REV INTEGER NOT NULL,
3704
    REVTYPE TINYINT,
3705
    CREATED TIMESTAMP,
3706
    UUID VARCHAR(36),
3707
    UPDATED TIMESTAMP,
3708
    TEXT CLOB,
3709
    ABBREVIATEDLABEL VARCHAR(255),
3710
    LABEL VARCHAR(255),
3711
    CREATEDBY_ID INTEGER,
3712
    UPDATEDBY_ID INTEGER,
3713
    LANGUAGE_ID INTEGER
3714
);
3715
-- 2175 +/- SELECT COUNT(*) FROM PUBLIC.REPRESENTATION_AUD;
3716
CREATE CACHED TABLE PUBLIC.REPRESENTATION_ANNOTATION(
3717
    REPRESENTATION_ID INTEGER NOT NULL,
3718
    ANNOTATIONS_ID INTEGER NOT NULL
3719
);
3720
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REPRESENTATION_ANNOTATION;
3721
CREATE CACHED TABLE PUBLIC.REPRESENTATION_ANNOTATION_AUD(
3722
    REV INTEGER NOT NULL,
3723
    REPRESENTATION_ID INTEGER NOT NULL,
3724
    ANNOTATIONS_ID INTEGER NOT NULL,
3725
    REVTYPE TINYINT
3726
);
3727
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REPRESENTATION_ANNOTATION_AUD;
3728
CREATE CACHED TABLE PUBLIC.REPRESENTATION_MARKER(
3729
    REPRESENTATION_ID INTEGER NOT NULL,
3730
    MARKERS_ID INTEGER NOT NULL
3731
);
3732
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REPRESENTATION_MARKER;
3733
CREATE CACHED TABLE PUBLIC.REPRESENTATION_MARKER_AUD(
3734
    REV INTEGER NOT NULL,
3735
    REPRESENTATION_ID INTEGER NOT NULL,
3736
    MARKERS_ID INTEGER NOT NULL,
3737
    REVTYPE TINYINT
3738
);
3739
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REPRESENTATION_MARKER_AUD;
3740
CREATE CACHED TABLE PUBLIC.RIGHTSINFO(
3741
    ID INTEGER NOT NULL,
3742
    CREATED TIMESTAMP,
3743
    UUID VARCHAR(36),
3744
    UPDATED TIMESTAMP,
3745
    TEXT CLOB,
3746
    ABBREVIATEDTEXT VARCHAR(255),
3747
    URI CLOB,
3748
    CREATEDBY_ID INTEGER,
3749
    UPDATEDBY_ID INTEGER,
3750
    LANGUAGE_ID INTEGER,
3751
    AGENT_ID INTEGER,
3752
    TYPE_ID INTEGER
3753
);
3754
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.RIGHTSINFO;
3755
CREATE CACHED TABLE PUBLIC.RIGHTSINFO_AUD(
3756
    ID INTEGER NOT NULL,
3757
    REV INTEGER NOT NULL,
3758
    REVTYPE TINYINT,
3759
    CREATED TIMESTAMP,
3760
    UUID VARCHAR(36),
3761
    UPDATED TIMESTAMP,
3762
    TEXT CLOB,
3763
    ABBREVIATEDTEXT VARCHAR(255),
3764
    URI CLOB,
3765
    CREATEDBY_ID INTEGER,
3766
    UPDATEDBY_ID INTEGER,
3767
    LANGUAGE_ID INTEGER,
3768
    AGENT_ID INTEGER,
3769
    TYPE_ID INTEGER
3770
);
3771
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.RIGHTSINFO_AUD;
3772
CREATE CACHED TABLE PUBLIC.RIGHTSINFO_ANNOTATION(
3773
    RIGHTS_ID INTEGER NOT NULL,
3774
    ANNOTATIONS_ID INTEGER NOT NULL
3775
);
3776
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.RIGHTSINFO_ANNOTATION;
3777
CREATE CACHED TABLE PUBLIC.RIGHTSINFO_ANNOTATION_AUD(
3778
    REV INTEGER NOT NULL,
3779
    RIGHTS_ID INTEGER NOT NULL,
3780
    ANNOTATIONS_ID INTEGER NOT NULL,
3781
    REVTYPE TINYINT
3782
);
3783
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.RIGHTSINFO_ANNOTATION_AUD;
3784
CREATE CACHED TABLE PUBLIC.RIGHTSINFO_MARKER(
3785
    RIGHTS_ID INTEGER NOT NULL,
3786
    MARKERS_ID INTEGER NOT NULL
3787
);
3788
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.RIGHTSINFO_MARKER;
3789
CREATE CACHED TABLE PUBLIC.RIGHTSINFO_MARKER_AUD(
3790
    REV INTEGER NOT NULL,
3791
    RIGHTS_ID INTEGER NOT NULL,
3792
    MARKERS_ID INTEGER NOT NULL,
3793
    REVTYPE TINYINT
3794
);
3795

    
3796
CREATE TABLE SEQUENCE (
3797
    ID INTEGER NOT NULL,
3798
    CREATED TIMESTAMP,
3799
    UUID VARCHAR(36),
3800
    UPDATED TIMESTAMP,
3801
    BARCODESEQUENCEPART_LENGTH INTEGER,
3802
    BARCODESEQUENCEPART_STRING CLOB,
3803
    BOLDPROCESSID VARCHAR(255),
3804
    CONSENSUSSEQUENCE_LENGTH INTEGER,
3805
    CONSENSUSSEQUENCE_STRING CLOB,
3806
    GENETICACCESSIONNUMBER VARCHAR(255),
3807
    HAPLOTYPE VARCHAR(255),
3808
    ISBARCODE BOOLEAN,
3809
    CREATEDBY_ID INTEGER,
3810
    UPDATEDBY_ID INTEGER,
3811
    CONTIGFILE_ID INTEGER,
3812
    DNASAMPLE_ID INTEGER,
3813
    DNAMARKER_ID INTEGER,
3814
    PRIMARY KEY (ID)
3815
);
3816
CREATE TABLE SEQUENCE_AUD (
3817
    ID INTEGER NOT NULL,
3818
    REV INTEGER NOT NULL,
3819
    REVTYPE TINYINT,
3820
    CREATED TIMESTAMP,
3821
    UUID VARCHAR(36),
3822
    UPDATED TIMESTAMP,
3823
    BARCODESEQUENCEPART_LENGTH INTEGER,
3824
    BARCODESEQUENCEPART_STRING CLOB,
3825
    BOLDPROCESSID VARCHAR(255),
3826
    CONSENSUSSEQUENCE_LENGTH INTEGER,
3827
    CONSENSUSSEQUENCE_STRING CLOB,
3828
    GENETICACCESSIONNUMBER VARCHAR(255),
3829
    HAPLOTYPE VARCHAR(255),
3830
    ISBARCODE BOOLEAN,
3831
    CREATEDBY_ID INTEGER,
3832
    UPDATEDBY_ID INTEGER,
3833
    CONTIGFILE_ID INTEGER,
3834
    DNASAMPLE_ID INTEGER,
3835
    DNAMARKER_ID INTEGER
3836
);
3837

    
3838
CREATE TABLE SEQUENCE_ANNOTATION (
3839
    SEQUENCE_ID INTEGER NOT NULL,
3840
    ANNOTATIONS_ID INTEGER NOT NULL,
3841
    PRIMARY KEY (SEQUENCE_ID, ANNOTATIONS_ID)
3842
);
3843
CREATE TABLE SEQUENCE_ANNOTATION_AUD (
3844
    REV INTEGER NOT NULL,
3845
    REVTYPE TINYINT,
3846
    SEQUENCE_ID INTEGER NOT NULL,
3847
    ANNOTATIONS_ID INTEGER NOT NULL
3848
);
3849

    
3850
CREATE TABLE SEQUENCE_MARKER (
3851
    SEQUENCE_ID INTEGER NOT NULL,
3852
    MARKERS_ID INTEGER NOT NULL,
3853
    PRIMARY KEY (SEQUENCE_ID, MARKERS_ID)
3854
);
3855
CREATE TABLE SEQUENCE_MARKER_AUD (
3856
    REV INTEGER NOT NULL,
3857
    REVTYPE TINYINT,
3858
    SEQUENCE_ID INTEGER NOT NULL,
3859
    MARKERS_ID INTEGER NOT NULL
3860
);
3861
CREATE TABLE SEQUENCE_REFERENCE (
3862
    SEQUENCE_ID INTEGER NOT NULL,
3863
    CITATIONS_ID INTEGER NOT NULL,
3864
    PRIMARY KEY (SEQUENCE_ID, CITATIONS_ID)
3865
);
3866
CREATE TABLE SEQUENCE_REFERENCE_AUD (
3867
    REV INTEGER NOT NULL,
3868
    REVTYPE TINYINT,
3869
    SEQUENCE_ID INTEGER NOT NULL,
3870
    CITATIONS_ID INTEGER NOT NULL
3871
);
3872

    
3873
CREATE TABLE SINGLEREADALIGNMENT (
3874
    ID INTEGER NOT NULL,
3875
    CREATED TIMESTAMP,
3876
    UUID VARCHAR(36),
3877
    UPDATED TIMESTAMP,
3878
        EDITEDSEQUENCE CLOB,
3879
        SHIFTS CLOB,
3880
    REVERSECOMPLEMENT BIT,
3881
        FIRSTSEQPOSITION INTEGER,
3882
        LEFTCUTPOSITION INTEGER,
3883
        RIGHTCUTPOSITION INTEGER,
3884
        CREATEDBY_ID INTEGER,
3885
    UPDATEDBY_ID INTEGER,
3886
    CONSENSUSALIGNMENT_ID INTEGER NULL,
3887
    SINGLEREAD_ID INTEGER NOT NULL,
3888
    PRIMARY KEY (ID)
3889
);
3890

    
3891
CREATE TABLE SINGLEREADALIGNMENT_AUD (
3892
    ID INTEGER NOT NULL,
3893
    REV INTEGER NOT NULL,
3894
    REVTYPE TINYINT,
3895
    CREATED TIMESTAMP,
3896
    UUID VARCHAR(36),
3897
    UPDATED TIMESTAMP,
3898
        EDITEDSEQUENCE CLOB,
3899
        SHIFTS CLOB,
3900
    REVERSECOMPLEMENT BIT,
3901
        FIRSTSEQPOSITION INTEGER,
3902
        LEFTCUTPOSITION INTEGER,
3903
        RIGHTCUTPOSITION INTEGER,
3904
        CREATEDBY_ID INTEGER,
3905
    UPDATEDBY_ID INTEGER,
3906
    CONSENSUSALIGNMENT_ID INTEGER NULL,
3907
    SINGLEREAD_ID INTEGER NOT NULL
3908
);
3909

    
3910
CREATE TABLE SINGLEREAD (
3911
    ID INTEGER NOT NULL,
3912
    CREATED TIMESTAMP,
3913
    UUID VARCHAR(36),
3914
    UPDATED TIMESTAMP,
3915
    DESCRIPTION VARCHAR(255),
3916
    TIMEPERIOD_END VARCHAR(255),
3917
    TIMEPERIOD_FREETEXT VARCHAR(255),
3918
    TIMEPERIOD_START VARCHAR(255),
3919
    DIRECTION VARCHAR(3),
3920
    SEQUENCE_LENGTH INTEGER,
3921
    SEQUENCE_STRING CLOB,
3922
    CREATEDBY_ID INTEGER,
3923
    UPDATEDBY_ID INTEGER,
3924
    ACTOR_ID INTEGER,
3925
    AMPLIFICATIONRESULT_ID INTEGER,
3926
    MATERIALORMETHOD_ID INTEGER,
3927
    PHEROGRAM_ID INTEGER,
3928
    PRIMER_ID INTEGER,
3929
    PRIMARY KEY (ID)
3930
);
3931
CREATE TABLE SINGLEREAD_AUD (
3932
    ID INTEGER NOT NULL,
3933
    REV INTEGER NOT NULL,
3934
    REVTYPE TINYINT,
3935
    CREATED TIMESTAMP,
3936
    UUID VARCHAR(36),
3937
    UPDATED TIMESTAMP,
3938
    DESCRIPTION VARCHAR(255),
3939
    TIMEPERIOD_END VARCHAR(255),
3940
    TIMEPERIOD_FREETEXT VARCHAR(255),
3941
    TIMEPERIOD_START VARCHAR(255),
3942
    DIRECTION VARCHAR(3),
3943
    SEQUENCE_LENGTH INTEGER,
3944
    SEQUENCE_STRING CLOB,
3945
    CREATEDBY_ID INTEGER,
3946
    UPDATEDBY_ID INTEGER,
3947
    ACTOR_ID INTEGER,
3948
    AMPLIFICATIONRESULT_ID INTEGER,
3949
    MATERIALORMETHOD_ID INTEGER,
3950
    PHEROGRAM_ID INTEGER,
3951
    PRIMER_ID INTEGER
3952
);
3953

    
3954
CREATE TABLE SINGLEREAD_ANNOTATION (
3955
    SINGLEREAD_ID INTEGER NOT NULL,
3956
    ANNOTATIONS_ID INTEGER NOT NULL,
3957
    PRIMARY KEY (SINGLEREAD_ID, ANNOTATIONS_ID)
3958
);
3959
CREATE TABLE SINGLEREAD_ANNOTATION_AUD (
3960
    REV INTEGER NOT NULL,
3961
    REVTYPE TINYINT,
3962
    SINGLEREAD_ID INTEGER NOT NULL,
3963
    ANNOTATIONS_ID INTEGER NOT NULL
3964
);
3965

    
3966
CREATE TABLE SINGLEREAD_MARKER (
3967
    SINGLEREAD_ID INTEGER NOT NULL,
3968
    MARKERS_ID INTEGER NOT NULL,
3969
    PRIMARY KEY (SINGLEREAD_ID, MARKERS_ID)
3970
);
3971

    
3972
CREATE TABLE SINGLEREAD_MARKER_AUD (
3973
    REV INTEGER NOT NULL,
3974
    REVTYPE TINYINT,
3975
    SINGLEREAD_ID INTEGER NOT NULL,
3976
    MARKERS_ID INTEGER NOT NULL
3977
);
3978

    
3979
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE(
3980
    DTYPE VARCHAR(31) NOT NULL,
3981
    ID INTEGER NOT NULL,
3982
    CREATED TIMESTAMP,
3983
    UUID VARCHAR(36),
3984
    UPDATED TIMESTAMP,
3985
    RECORDBASIS  VARCHAR(4) NOT NULL,
3986
    LSID_AUTHORITY VARCHAR(255),
3987
    LSID_LSID VARCHAR(255),
3988
    LSID_NAMESPACE VARCHAR(255),
3989
    LSID_OBJECT VARCHAR(255),
3990
    LSID_REVISION VARCHAR(255),
3991
    PROTECTEDTITLECACHE BOOLEAN NOT NULL,
3992
    TITLECACHE VARCHAR(255),
3993
    PROTECTEDIDENTITYCACHE BOOLEAN,
3994
    IDENTITYCACHE VARCHAR(255),
3995
    PUBLISH BOOLEAN,
3996
    INDIVIDUALCOUNT INTEGER,
3997
        PREFERREDSTABLEURI CLOB,
3998
    ACCESSIONNUMBER VARCHAR(255),
3999
    BARCODE VARCHAR(255),
4000
    CATALOGNUMBER VARCHAR(255),
4001
    COLLECTORSNUMBER VARCHAR(255),
4002
    EXSICCATUM VARCHAR(255),
4003
    ORIGINALLABELINFO CLOB,
4004
    FIELDNOTES VARCHAR(255),
4005
    FIELDNUMBER VARCHAR(255),
4006
    CREATEDBY_ID INTEGER,
4007
    UPDATEDBY_ID INTEGER,
4008
    LIFESTAGE_ID INTEGER,
4009
    SEX_ID INTEGER,
4010
    KINDOFUNIT_ID INTEGER,
4011
    COLLECTION_ID INTEGER,
4012
    DERIVEDFROM_ID INTEGER,
4013
    STOREDUNDER_ID INTEGER,
4014
    PRESERVATION_ID INTEGER,
4015
    GATHERINGEVENT_ID INTEGER,
4016
    PRIMARYCOLLECTOR_ID INTEGER,
4017
    MEDIASPECIMEN_ID INTEGER,
4018
    DNAQUALITY_ID INTEGER
4019
);
4020
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE;
4021
CREATE INDEX PUBLIC.SPECIMENOROBSERVATIONBASETITLECACHEINDEX ON PUBLIC.SPECIMENOROBSERVATIONBASE(TITLECACHE);
4022
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_AUD(
4023
    DTYPE VARCHAR(31) NOT NULL,
4024
    ID INTEGER NOT NULL,
4025
    REV INTEGER NOT NULL,
4026
    REVTYPE TINYINT,
4027
    CREATED TIMESTAMP,
4028
    UUID VARCHAR(36),
4029
    UPDATED TIMESTAMP,
4030
    RECORDBASIS  VARCHAR(4) NOT NULL,
4031
    LSID_AUTHORITY VARCHAR(255),
4032
    LSID_LSID VARCHAR(255),
4033
    LSID_NAMESPACE VARCHAR(255),
4034
    LSID_OBJECT VARCHAR(255),
4035
    LSID_REVISION VARCHAR(255),
4036
    PROTECTEDTITLECACHE BOOLEAN,
4037
    TITLECACHE VARCHAR(255),
4038
    PROTECTEDIDENTITYCACHE BOOLEAN NULL,
4039
    IDENTITYCACHE VARCHAR(255),
4040
        PUBLISH BOOLEAN,
4041
    INDIVIDUALCOUNT INTEGER,
4042
    PREFERREDSTABLEURI CLOB,
4043
    ACCESSIONNUMBER VARCHAR(255),
4044
    BARCODE VARCHAR(255),
4045
    CATALOGNUMBER VARCHAR(255),
4046
    COLLECTORSNUMBER VARCHAR(255),
4047
    EXSICCATUM VARCHAR(255),
4048
    ORIGINALLABELINFO CLOB,
4049
    FIELDNOTES VARCHAR(255),
4050
    FIELDNUMBER VARCHAR(255),
4051
    CREATEDBY_ID INTEGER,
4052
    UPDATEDBY_ID INTEGER,
4053
    LIFESTAGE_ID INTEGER,
4054
    SEX_ID INTEGER,
4055
    KINDOFUNIT_ID INTEGER,
4056
    COLLECTION_ID INTEGER,
4057
    DERIVEDFROM_ID INTEGER,
4058
    STOREDUNDER_ID INTEGER,
4059
    PRESERVATION_ID INTEGER,
4060
    GATHERINGEVENT_ID INTEGER,
4061
    PRIMARYCOLLECTOR_ID INTEGER,
4062
    MEDIASPECIMEN_ID INTEGER,
4063
    DNAQUALITY_ID INTEGER
4064
);
4065
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_AUD;
4066
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_ANNOTATION(
4067
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
4068
    ANNOTATIONS_ID INTEGER NOT NULL
4069
);
4070
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_ANNOTATION;
4071
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_ANNOTATION_AUD(
4072
    REV INTEGER NOT NULL,
4073
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
4074
    ANNOTATIONS_ID INTEGER NOT NULL,
4075
    REVTYPE TINYINT
4076
);
4077
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_ANNOTATION_AUD;
4078
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_CREDIT(
4079
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
4080
    CREDITS_ID INTEGER NOT NULL,
4081
    SORTINDEX INTEGER NOT NULL
4082
);
4083
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_CREDIT;
4084
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_CREDIT_AUD(
4085
    REV INTEGER NOT NULL,
4086
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
4087
    CREDITS_ID INTEGER NOT NULL,
4088
    SORTINDEX INTEGER NOT NULL,
4089
    REVTYPE TINYINT
4090
);
4091
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_CREDIT_AUD;
4092
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_DERIVATIONEVENT(
4093
    ORIGINALS_ID INTEGER NOT NULL,
4094
    DERIVATIONEVENTS_ID INTEGER NOT NULL
4095
);
4096
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_DERIVATIONEVENT;
4097
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_DERIVATIONEVENT_AUD(
4098
    REV INTEGER NOT NULL,
4099
    ORIGINALS_ID INTEGER NOT NULL,
4100
    DERIVATIONEVENTS_ID INTEGER NOT NULL,
4101
    REVTYPE TINYINT
4102
);
4103
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_DERIVATIONEVENT_AUD;
4104
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_EXTENSION(
4105
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
4106
    EXTENSIONS_ID INTEGER NOT NULL
4107
);
4108
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_EXTENSION;
4109
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_EXTENSION_AUD(
4110
    REV INTEGER NOT NULL,
4111
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
4112
    EXTENSIONS_ID INTEGER NOT NULL,
4113
    REVTYPE TINYINT
4114
);
4115
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_EXTENSION_AUD;
4116

    
4117
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_IDENTIFIER(
4118
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
4119
    IDENTIFIERS_ID INTEGER NOT NULL,
4120
    SORTINDEX INTEGER NOT NULL
4121
);
4122
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_IDENTIFIER;
4123
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_IDENTIFIER_AUD(
4124
    REV INTEGER NOT NULL,
4125
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
4126
    IDENTIFIERS_ID INTEGER NOT NULL,
4127
    SORTINDEX INTEGER NOT NULL,
4128
    REVTYPE TINYINT
4129
);
4130
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_IDENTIFIER_AUD;
4131

    
4132
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_LANGUAGESTRING(
4133
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
4134
    DEFINITION_ID INTEGER NOT NULL,
4135
    DEFINITION_MAPKEY_ID INTEGER NOT NULL
4136
);
4137
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_LANGUAGESTRING;
4138
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_LANGUAGESTRING_AUD(
4139
    REV INTEGER NOT NULL,
4140
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
4141
    DEFINITION_ID INTEGER NOT NULL,
4142
    DEFINITION_MAPKEY_ID INTEGER NOT NULL,
4143
    REVTYPE TINYINT
4144
);
4145
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_LANGUAGESTRING_AUD;
4146
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_MARKER(
4147
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
4148
    MARKERS_ID INTEGER NOT NULL
4149
);
4150
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_MARKER;
4151
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_MARKER_AUD(
4152
    REV INTEGER NOT NULL,
4153
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
4154
    MARKERS_ID INTEGER NOT NULL,
4155
    REVTYPE TINYINT
4156
);
4157
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_MARKER_AUD;
4158
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_ORIGINALSOURCEBASE(
4159
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
4160
    SOURCES_ID INTEGER NOT NULL
4161
);
4162
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_ORIGINALSOURCEBASE;
4163
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_ORIGINALSOURCEBASE_AUD(
4164
    REV INTEGER NOT NULL,
4165
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
4166
    SOURCES_ID INTEGER NOT NULL,
4167
    REVTYPE TINYINT
4168
);
4169
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_ORIGINALSOURCEBASE_AUD;
4170
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_RIGHTSINFO(
4171
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
4172
    RIGHTS_ID INTEGER NOT NULL
4173
);
4174
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_RIGHTSINFO;
4175
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_RIGHTSINFO_AUD(
4176
    REV INTEGER NOT NULL,
4177
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
4178
    RIGHTS_ID INTEGER NOT NULL,
4179
    REVTYPE TINYINT
4180
);
4181
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_RIGHTSINFO_AUD;
4182

    
4183
CREATE CACHED TABLE PUBLIC.STATEDATA(
4184
    ID INTEGER NOT NULL,
4185
    CREATED TIMESTAMP,
4186
    UUID VARCHAR(36),
4187
    UPDATED TIMESTAMP,
4188
    CREATEDBY_ID INTEGER,
4189
    UPDATEDBY_ID INTEGER,
4190
        CATEGORICALDATA_ID INTEGER,
4191
    STATE_ID INTEGER
4192
);
4193
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATEDATA;
4194
CREATE CACHED TABLE PUBLIC.STATEDATA_AUD(
4195
    ID INTEGER NOT NULL,
4196
    REV INTEGER NOT NULL,
4197
    REVTYPE TINYINT,
4198
    CREATED TIMESTAMP,
4199
    UUID VARCHAR(36),
4200
    UPDATED TIMESTAMP,
4201
    CREATEDBY_ID INTEGER,
4202
    UPDATEDBY_ID INTEGER,
4203
        CATEGORICALDATA_ID INTEGER,
4204
    STATE_ID INTEGER
4205
);
4206
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATEDATA_AUD;
4207
CREATE CACHED TABLE PUBLIC.STATEDATA_DEFINEDTERMBASE(
4208
    STATEDATA_ID INTEGER NOT NULL,
4209
    MODIFIERS_ID INTEGER NOT NULL
4210
);
4211
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATEDATA_DEFINEDTERMBASE;
4212
CREATE CACHED TABLE PUBLIC.STATEDATA_DEFINEDTERMBASE_AUD(
4213
    REV INTEGER NOT NULL,
4214
    STATEDATA_ID INTEGER NOT NULL,
4215
    MODIFIERS_ID INTEGER NOT NULL,
4216
    REVTYPE TINYINT
4217
);
4218
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATEDATA_DEFINEDTERMBASE_AUD;
4219
CREATE CACHED TABLE PUBLIC.STATEDATA_LANGUAGESTRING(
4220
    STATEDATA_ID INTEGER NOT NULL,
4221
    MODIFYINGTEXT_ID INTEGER NOT NULL,
4222
    MODIFYINGTEXT_MAPKEY_ID INTEGER NOT NULL
4223
);
4224
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATEDATA_LANGUAGESTRING;
4225
CREATE CACHED TABLE PUBLIC.STATEDATA_LANGUAGESTRING_AUD(
4226
    REV INTEGER NOT NULL,
4227
    STATEDATA_ID INTEGER NOT NULL,
4228
    MODIFYINGTEXT_ID INTEGER NOT NULL,
4229
    MODIFYINGTEXT_MAPKEY_ID INTEGER NOT NULL,
4230
    REVTYPE TINYINT
4231
);
4232
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATEDATA_LANGUAGESTRING_AUD;
4233
CREATE CACHED TABLE PUBLIC.STATISTICALMEASUREMENTVALUE(
4234
    ID INTEGER NOT NULL,
4235
    CREATED TIMESTAMP,
4236
    UUID VARCHAR(36),
4237
    UPDATED TIMESTAMP,
4238
    VALUE DOUBLE NOT NULL,
4239
    CREATEDBY_ID INTEGER,
4240
    UPDATEDBY_ID INTEGER,
4241
        QUANTITATIVEDATA_ID INTEGER,
4242
    TYPE_ID INTEGER
4243
);
4244
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATISTICALMEASUREMENTVALUE;
4245
CREATE CACHED TABLE PUBLIC.STATISTICALMEASUREMENTVALUE_AUD(
4246
    ID INTEGER NOT NULL,
4247
    REV INTEGER NOT NULL,
4248
    REVTYPE TINYINT,
4249
    CREATED TIMESTAMP,
4250
    UUID VARCHAR(36),
4251
    UPDATED TIMESTAMP,
4252
    VALUE DOUBLE,
4253
    CREATEDBY_ID INTEGER,
4254
    UPDATEDBY_ID INTEGER,
4255
        QUANTITATIVEDATA_ID INTEGER,
4256
    TYPE_ID INTEGER
4257
);
4258
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATISTICALMEASUREMENTVALUE_AUD;
4259
CREATE CACHED TABLE PUBLIC.STATISTICALMEASUREMENTVALUE_DEFINEDTERMBASE(
4260
    STATISTICALMEASUREMENTVALUE_ID INTEGER NOT NULL,
4261
    MODIFIERS_ID INTEGER NOT NULL
4262
);
4263
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATISTICALMEASUREMENTVALUE_DEFINEDTERMBASE;
4264
CREATE CACHED TABLE PUBLIC.STATISTICALMEASUREMENTVALUE_DEFINEDTERMBASE_AUD(
4265
    REV INTEGER NOT NULL,
4266
    STATISTICALMEASUREMENTVALUE_ID INTEGER NOT NULL,
4267
    MODIFIERS_ID INTEGER NOT NULL,
4268
    REVTYPE TINYINT
4269
);
4270
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATISTICALMEASUREMENTVALUE_DEFINEDTERMBASE_AUD;
4271
CREATE CACHED TABLE PUBLIC.TAXONBASE(
4272
    DTYPE VARCHAR(31) NOT NULL,
4273
    ID INTEGER NOT NULL,
4274
    CREATED TIMESTAMP,
4275
    UUID VARCHAR(36),
4276
    UPDATED TIMESTAMP,
4277
    LSID_AUTHORITY VARCHAR(255),
4278
    LSID_LSID VARCHAR(255),
4279
    LSID_NAMESPACE VARCHAR(255),
4280
    LSID_OBJECT VARCHAR(255),
4281
    LSID_REVISION VARCHAR(255),
4282
        SECMICROREFERENCE VARCHAR(255),
4283
    PROTECTEDTITLECACHE BOOLEAN NOT NULL,
4284
    TITLECACHE VARCHAR(255),
4285
    APPENDEDPHRASE VARCHAR(255),
4286
    DOUBTFUL BOOLEAN NOT NULL,
4287
    PUBLISH BOOLEAN,
4288
    USENAMECACHE BOOLEAN NOT NULL,
4289
    EXCLUDED BOOLEAN,
4290
    TAXONSTATUSUNKNOWN BOOLEAN,
4291
    UNPLACED BOOLEAN,
4292
        PARTIAL BOOLEAN NOT NULL,
4293
    PROPARTE BOOLEAN NOT NULL,
4294
    CREATEDBY_ID INTEGER,
4295
    UPDATEDBY_ID INTEGER,
4296
    NAME_ID INTEGER,
4297
    SEC_ID INTEGER,
4298
        ACCEPTEDTAXON_ID INTEGER,
4299
        TYPE_ID INTEGER
4300
);
4301
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONBASE;
4302
CREATE INDEX PUBLIC.TAXONBASETITLECACHEINDEX ON PUBLIC.TAXONBASE(TITLECACHE);
4303
CREATE CACHED TABLE PUBLIC.TAXONBASE_AUD(
4304
    DTYPE VARCHAR(31) NOT NULL,
4305
    ID INTEGER NOT NULL,
4306
    REV INTEGER NOT NULL,
4307
    REVTYPE TINYINT,
4308
    CREATED TIMESTAMP,
4309
    UUID VARCHAR(36),
4310
    UPDATED TIMESTAMP,
4311
    LSID_AUTHORITY VARCHAR(255),
4312
    LSID_LSID VARCHAR(255),
4313
    LSID_NAMESPACE VARCHAR(255),
4314
    LSID_OBJECT VARCHAR(255),
4315
    LSID_REVISION VARCHAR(255),
4316
    PROTECTEDTITLECACHE BOOLEAN,
4317
    TITLECACHE VARCHAR(255),
4318
    APPENDEDPHRASE VARCHAR(255),
4319
        SECMICROREFERENCE VARCHAR(255),
4320
    DOUBTFUL BOOLEAN,
4321
    PUBLISH BOOLEAN,
4322
        PARTIAL BOOLEAN NOT NULL,
4323
    PROPARTE BOOLEAN NOT NULL,
4324
    USENAMECACHE BOOLEAN,
4325
    CREATEDBY_ID INTEGER,
4326
    UPDATEDBY_ID INTEGER,
4327
    NAME_ID INTEGER,
4328
    SEC_ID INTEGER,
4329
    EXCLUDED BOOLEAN,
4330
    TAXONSTATUSUNKNOWN BOOLEAN,
4331
    UNPLACED BOOLEAN,
4332
        ACCEPTEDTAXON_ID INTEGER,
4333
        TYPE_ID INTEGER
4334
);
4335
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONBASE_AUD;
4336
CREATE CACHED TABLE PUBLIC.TAXONBASE_ANNOTATION(
4337
    TAXONBASE_ID INTEGER NOT NULL,
4338
    ANNOTATIONS_ID INTEGER NOT NULL
4339
);
4340
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONBASE_ANNOTATION;
4341
CREATE CACHED TABLE PUBLIC.TAXONBASE_ANNOTATION_AUD(
4342
    REV INTEGER NOT NULL,
4343
    TAXONBASE_ID INTEGER NOT NULL,
4344
    ANNOTATIONS_ID INTEGER NOT NULL,
4345
    REVTYPE TINYINT
4346
);
4347
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONBASE_ANNOTATION_AUD;
4348
CREATE CACHED TABLE PUBLIC.TAXONBASE_CREDIT(
4349
    TAXONBASE_ID INTEGER NOT NULL,
4350
    CREDITS_ID INTEGER NOT NULL,
4351
    SORTINDEX INTEGER NOT NULL
4352
);
4353
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONBASE_CREDIT;
4354
CREATE CACHED TABLE PUBLIC.TAXONBASE_CREDIT_AUD(
4355
    REV INTEGER NOT NULL,
4356
    TAXONBASE_ID INTEGER NOT NULL,
4357
    CREDITS_ID INTEGER NOT NULL,
4358
    SORTINDEX INTEGER NOT NULL,
4359
    REVTYPE TINYINT
4360
);
4361
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONBASE_CREDIT_AUD;
4362
CREATE CACHED TABLE PUBLIC.TAXONBASE_EXTENSION(
4363