Project

General

Profile

« Previous | Next » 

Revision 8c34728e

Added by Andreas Müller over 8 years ago

Update to hibernate 5 for cdmlib-io #4716

View differences:

cdmlib-io/pom.xml
35 35 
  </build>
36 36 
  <dependencies>
37 37 
    <dependency>
38 
      <groupId>eu.etaxonomy</groupId>
39 
      <artifactId>cdmlib-persistence</artifactId>
40 
      <type>test-jar</type>
41 
      <scope>test</scope>
42 
      <version>${project.version}</version>
43 
    </dependency>
38 
        <groupId>eu.etaxonomy</groupId>
39 
        <artifactId>cdmlib-test</artifactId>
40 
        <scope>test</scope>
41 
        <version>${project.version}</version>
42 
    </dependency>
43 
<!--     <dependency> -->
44 
<!--       <groupId>eu.etaxonomy</groupId> -->
45 
<!--       <artifactId>cdmlib-persistence</artifactId> -->
46 
<!--       <type>test-jar</type> -->
47 
<!--       <scope>test</scope> -->
48 
<!--       <version>${project.version}</version> -->
49 
<!--     </dependency> -->
44 50 
    <dependency>
45 51 
      <groupId>eu.etaxonomy</groupId>
46 52 
      <artifactId>cdmlib-ext</artifactId>
......
49 55 
        <groupId>com.google.guava</groupId>
50 56 
        <artifactId>guava</artifactId>
51 57 
    </dependency>
52 
    <dependency>
53 
      <groupId>org.unitils</groupId>
54 
      <artifactId>unitils-core</artifactId>
55 
      <scope>test</scope>
56 
    </dependency>
57 
    <dependency>
58 
      <groupId>org.unitils</groupId>
59 
      <artifactId>unitils-database</artifactId>
60 
      <exclusions>
61 
        <exclusion>
62 
          <groupId>commons-dbcp</groupId>
63 
          <artifactId>commons-dbcp</artifactId>
64 
        </exclusion>
65 
      </exclusions>
66 
      <scope>test</scope>
67 
    </dependency>
68 
    <dependency>
69 
      <groupId>org.unitils</groupId>
70 
      <artifactId>unitils-dbmaintainer</artifactId>
71 
      <scope>test</scope>
72 
    </dependency>
73 
    <dependency>
74 
      <groupId>org.unitils</groupId>
75 
      <artifactId>unitils-dbunit</artifactId>
76 
      <scope>test</scope>
77 
    </dependency>
78 
    <dependency>
79 
      <groupId>org.unitils</groupId>
80 
      <artifactId>unitils-easymock</artifactId>
81 
      <scope>test</scope>
82 
    </dependency>
83 
    <dependency>
84 
      <groupId>org.unitils</groupId>
85 
      <artifactId>unitils-mock</artifactId>
86 
      <scope>test</scope>
87 
    </dependency>
88 
    <dependency>
89 
      <groupId>org.unitils</groupId>
90 
      <artifactId>unitils-inject</artifactId>
91 
      <scope>test</scope>
92 
    </dependency>
93 
    <dependency>
94 
      <groupId>org.unitils</groupId>
95 
      <artifactId>unitils-orm</artifactId>
96 
      <exclusions>
97 
        <exclusion>
98 
          <groupId>javax.persistence</groupId>
99 
          <artifactId>persistence-api</artifactId>
100 
        </exclusion>
101 
      </exclusions>
102 
      <scope>test</scope>
103 
    </dependency>
104 
    <dependency>
105 
      <groupId>org.unitils</groupId>
106 
      <artifactId>unitils-spring</artifactId>
107 
      <scope>test</scope>
108 
    </dependency>
109 
    <dependency>
110 
      <groupId>org.dbunit</groupId>
111 
      <artifactId>dbunit</artifactId>
112 
    </dependency>
113 
    <dependency>
114 
      <groupId>com.carrotsearch</groupId>
115 
      <artifactId>junit-benchmarks</artifactId>
116 
      <scope>test</scope>
117 
    </dependency>
58 
<!--     <dependency> -->
59 
<!--       <groupId>org.unitils</groupId> -->
60 
<!--       <artifactId>unitils-core</artifactId> -->
61 
<!--       <scope>test</scope> -->
62 
<!--     </dependency> -->
63 
<!--     <dependency> -->
64 
<!--       <groupId>org.unitils</groupId> -->
65 
<!--       <artifactId>unitils-database</artifactId> -->
66 
<!--       <exclusions> -->
67 
<!--         <exclusion> -->
68 
<!--           <groupId>commons-dbcp</groupId> -->
69 
<!--           <artifactId>commons-dbcp</artifactId> -->
70 
<!--         </exclusion> -->
71 
<!--       </exclusions> -->
72 
<!--       <scope>test</scope> -->
73 
<!--     </dependency> -->
74 
<!--     <dependency> -->
75 
<!--       <groupId>org.unitils</groupId> -->
76 
<!--       <artifactId>unitils-dbmaintainer</artifactId> -->
77 
<!--       <scope>test</scope> -->
78 
<!--     </dependency> -->
79 
<!--     <dependency> -->
80 
<!--       <groupId>org.unitils</groupId> -->
81 
<!--       <artifactId>unitils-dbunit</artifactId> -->
82 
<!--       <scope>test</scope> -->
83 
<!--     </dependency> -->
84 
<!--     <dependency> -->
85 
<!--       <groupId>org.unitils</groupId> -->
86 
<!--       <artifactId>unitils-easymock</artifactId> -->
87 
<!--       <scope>test</scope> -->
88 
<!--     </dependency> -->
89 
<!--     <dependency> -->
90 
<!--       <groupId>org.unitils</groupId> -->
91 
<!--       <artifactId>unitils-mock</artifactId> -->
92 
<!--       <scope>test</scope> -->
93 
<!--     </dependency> -->
94 
<!--     <dependency> -->
95 
<!--       <groupId>org.unitils</groupId> -->
96 
<!--       <artifactId>unitils-inject</artifactId> -->
97 
<!--       <scope>test</scope> -->
98 
<!--     </dependency> -->
99 
<!--     <dependency> -->
100 
<!--       <groupId>org.unitils</groupId> -->
101 
<!--       <artifactId>unitils-orm</artifactId> -->
102 
<!--       <exclusions> -->
103 
<!--         <exclusion> -->
104 
<!--           <groupId>javax.persistence</groupId> -->
105 
<!--           <artifactId>persistence-api</artifactId> -->
106 
<!--         </exclusion> -->
107 
<!--       </exclusions> -->
108 
<!--       <scope>test</scope> -->
109 
<!--     </dependency> -->
110 
<!--     <dependency> -->
111 
<!--       <groupId>org.unitils</groupId> -->
112 
<!--       <artifactId>unitils-spring</artifactId> -->
113 
<!--       <scope>test</scope> -->
114 
<!--     </dependency> -->
115 
<!--     <dependency> -->
116 
<!--       <groupId>org.dbunit</groupId> -->
117 
<!--       <artifactId>dbunit</artifactId> -->
118 
<!--     </dependency> -->
119 
<!--     <dependency> -->
120 
<!--       <groupId>com.carrotsearch</groupId> -->
121 
<!--       <artifactId>junit-benchmarks</artifactId> -->
122 
<!--       <scope>test</scope> -->
123 
<!--     </dependency> -->
118 124 
    <dependency>
119 125 
      <groupId>xmlunit</groupId>
120 126 
      <artifactId>xmlunit</artifactId>
......
132 138 
      <artifactId>identificationKeyAPI</artifactId>
133 139 
    </dependency>
134 140 
		<dependency>
135 
 			<groupId>org.apache.jena</groupId>
136 
 			<artifactId>jena-tdb</artifactId>
137
138 
		</dependency>
141 
 		<groupId>org.apache.jena</groupId>
142 
 		<artifactId>jena-tdb</artifactId>
143 
	</dependency>
139 144 
  </dependencies>
140 145 
</project>
141 146 

  		












  

    
      cdmlib-io/src/test/java/eu/etaxonomy/cdm/io/excel/taxa/NormalExplicitImportTest.java
    
  





  29
  29
  
    
import org.junit.Before;


  		




  30
  30
  
    
import org.junit.Test;


  		




  31
  31
  
    
import org.unitils.dbunit.annotation.DataSet;


  		




  
  32
  
    
import org.unitils.dbunit.annotation.DataSets;


  		




  32
  33
  
    
import org.unitils.spring.annotation.SpringBeanByName;


  		




  33
  34
  
    
import org.unitils.spring.annotation.SpringBeanByType;


  		




  34
  35
  
    

  		




  ......




  56
  57
  
    
import eu.etaxonomy.cdm.model.taxon.Taxon;


  		




  57
  58
  
    
import eu.etaxonomy.cdm.model.taxon.TaxonNode;


  		




  58
  59
  
    
import eu.etaxonomy.cdm.test.integration.CdmTransactionalIntegrationTest;


  		




  
  60
  
    
import eu.etaxonomy.cdm.test.unitils.CleanSweepInsertLoadStrategy;


  		




  59
  61
  
    

  		




  60
  62
  
    
/**


  		




  61
  63
  
    
 * @author a.mueller


  		




  62
  64
  
    
 * @created 26.08.2009


  		




  63
  
  
    
 * @version 1.0


  		




  64
  65
  
    
 */


  		




  65
  66
  
    
public class NormalExplicitImportTest extends CdmTransactionalIntegrationTest{


  		




  66
  67
  
    
	@SuppressWarnings("unused")


  		




  ......




  229
  230
  
    
	}


  		




  230
  231
  
    

  		




  231
  232
  
    
	@Test


  		




  232
  
  
    
	@DataSet(value="NormalExplicitImportTest.testUuid.xml")


  		




  233
  
  
    
	public void testUUID() throws URISyntaxException{


  		




  
  233
  
    
//	@DataSet(value="NormalExplicitImportTest.testUuid.xml")


  		




  
  234
  
    
    @DataSets({


  		




  
  235
  
    
        @DataSet(loadStrategy=CleanSweepInsertLoadStrategy.class, value="/eu/etaxonomy/cdm/io/ClearDB_with_Terms_DataSet.xml"),


  		




  
  236
  
    
        @DataSet(value="/eu/etaxonomy/cdm/io/TermsDataSet-with_auditing_info.xml"),


  		




  
  237
  
    
        @DataSet(value="NormalExplicitImportTest.testUuid.xml"),


  		




  
  238
  
    
    })


  		




  
  239
  
    
	public void testUUID(){


  		




  234
  240
  
    
		UUID taxonUuid = UUID.fromString("aafce7fe-0c5f-42ed-814b-4c7c2c715660");


  		




  235
  241
  
    
		UUID synonymUuid = UUID.fromString("fc4a995b-37a9-4984-afe6-e352c6c04d92");


  		




  236
  242
  
    

  		












  

    
      cdmlib-io/src/test/java/eu/etaxonomy/cdm/io/specimen/abcd206/in/AbcdGgbnImportTest.java
    
  





  553
  553
  
    
     * Should just check that no NPEs occur when some fields are missing.


  		




  554
  554
  
    
     */


  		




  555
  555
  
    
    @Test


  		




  
  556
  
    
//    @DataSets({


  		




  
  557
  
    
//        @DataSet(loadStrategy=CleanSweepInsertLoadStrategy.class, value="../../../BlankDataSet.xml"),


  		




  
  558
  
    
//    })


  		




  556
  559
  
    
    @DataSets({


  		




  557
  
  
    
        @DataSet(loadStrategy=CleanSweepInsertLoadStrategy.class, value="../../../BlankDataSet.xml"),


  		




  
  560
  
    
        @DataSet(loadStrategy=CleanSweepInsertLoadStrategy.class, value="/eu/etaxonomy/cdm/io/ClearDB_with_Terms_DataSet.xml"),


  		




  
  561
  
    
        @DataSet(value="/eu/etaxonomy/cdm/io/TermsDataSet-with_auditing_info.xml"),


  		




  558
  562
  
    
    })


  		




  559
  563
  
    
    public void testImportGgbnSparseData(){


  		




  560
  564
  
    
        String inputFile = "/eu/etaxonomy/cdm/io/specimen/abcd206/in/db6_sparse_data.xml";


  		












  

    
      cdmlib-io/src/test/resources/dbscripts/001-cdm.h2.sql
    
  





  1
  
  
    
SET CLUSTER '';


  		




  2
  
  
    
SET DEFAULT_TABLE_TYPE 0;


  		




  3
  
  
    
SET WRITE_DELAY 500;


  		




  4
  
  
    
SET DEFAULT_LOCK_TIMEOUT 2000;


  		




  5
  
  
    
SET CACHE_SIZE 16384;


  		




  6
  
  
    
;


  		




  7
  
  
    
CREATE USER IF NOT EXISTS EDIT PASSWORD '' ADMIN;


  		




  8
  
  
    
CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_10A55F0A_EE57_42DB_8046_6240A60AD0EC START WITH 4 BELONGS_TO_TABLE;


  		




  9
  
  
    

  		




  10
  
  
    

  		




  11
  
  
    
CREATE CACHED TABLE PUBLIC.ADDRESS(


  		




  12
  
  
    
    ID INTEGER NOT NULL,


  		




  13
  
  
    
    CREATED TIMESTAMP,


  		




  14
  
  
    
    UUID VARCHAR(36),


  		




  15
  
  
    
    UPDATED TIMESTAMP,


  		




  16
  
  
    
    LOCALITY VARCHAR(255),


  		




  17
  
  
    
    LOCATION_ERRORRADIUS INTEGER,


  		




  18
  
  
    
    LOCATION_LATITUDE DOUBLE,


  		




  19
  
  
    
    LOCATION_LONGITUDE DOUBLE,


  		




  20
  
  
    
    POBOX VARCHAR(255),


  		




  21
  
  
    
    POSTCODE VARCHAR(255),


  		




  22
  
  
    
    REGION VARCHAR(255),


  		




  23
  
  
    
    STREET VARCHAR(255),


  		




  24
  
  
    
    CREATEDBY_ID INTEGER,


  		




  25
  
  
    
    UPDATEDBY_ID INTEGER,


  		




  26
  
  
    
    COUNTRY_ID INTEGER,


  		




  27
  
  
    
    LOCATION_REFERENCESYSTEM_ID INTEGER


  		




  28
  
  
    
);


  		




  29
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ADDRESS;


  		




  30
  
  
    
CREATE CACHED TABLE PUBLIC.ADDRESS_AUD(


  		




  31
  
  
    
    ID INTEGER NOT NULL,


  		




  32
  
  
    
    REV INTEGER NOT NULL,


  		




  33
  
  
    
    REVTYPE TINYINT,


  		




  34
  
  
    
    CREATED TIMESTAMP,


  		




  35
  
  
    
    UUID VARCHAR(36),


  		




  36
  
  
    
    UPDATED TIMESTAMP,


  		




  37
  
  
    
    LOCALITY VARCHAR(255),


  		




  38
  
  
    
    LOCATION_ERRORRADIUS INTEGER,


  		




  39
  
  
    
    LOCATION_LATITUDE DOUBLE,


  		




  40
  
  
    
    LOCATION_LONGITUDE DOUBLE,


  		




  41
  
  
    
    POBOX VARCHAR(255),


  		




  42
  
  
    
    POSTCODE VARCHAR(255),


  		




  43
  
  
    
    REGION VARCHAR(255),


  		




  44
  
  
    
    STREET VARCHAR(255),


  		




  45
  
  
    
    CREATEDBY_ID INTEGER,


  		




  46
  
  
    
    UPDATEDBY_ID INTEGER,


  		




  47
  
  
    
    COUNTRY_ID INTEGER,


  		




  48
  
  
    
    LOCATION_REFERENCESYSTEM_ID INTEGER


  		




  49
  
  
    
);


  		




  50
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ADDRESS_AUD;


  		




  51
  
  
    
CREATE CACHED TABLE PUBLIC.AGENTBASE(


  		




  52
  
  
    
    DTYPE VARCHAR(31) NOT NULL,


  		




  53
  
  
    
    ID INTEGER NOT NULL,


  		




  54
  
  
    
    CREATED TIMESTAMP,


  		




  55
  
  
    
    UUID VARCHAR(36),


  		




  56
  
  
    
    UPDATED TIMESTAMP,


  		




  57
  
  
    
    LSID_AUTHORITY VARCHAR(255),


  		




  58
  
  
    
    LSID_LSID VARCHAR(255),


  		




  59
  
  
    
    LSID_NAMESPACE VARCHAR(255),


  		




  60
  
  
    
    LSID_OBJECT VARCHAR(255),


  		




  61
  
  
    
    LSID_REVISION VARCHAR(255),


  		




  62
  
  
    
    PROTECTEDTITLECACHE BOOLEAN NOT NULL,


  		




  63
  
  
    
    TITLECACHE VARCHAR(255),


  		




  64
  
  
    
	PROTECTEDCOLLECTORTITLECACHE BOOLEAN NOT NULL,


  		




  65
  
  
    
	COLLECTORTITLE VARCHAR(255),


  		




  66
  
  
    
	PROTECTEDNOMENCLATURALTITLECACHE BOOLEAN,


  		




  67
  
  
    
    NOMENCLATURALTITLE VARCHAR(255),


  		




  68
  
  
    
    CODE VARCHAR(255),


  		




  69
  
  
    
    NAME VARCHAR(255),


  		




  70
  
  
    
    FIRSTNAME VARCHAR(255),


  		




  71
  
  
    
    LASTNAME VARCHAR(255),


  		




  72
  
  
    
    LIFESPAN_END VARCHAR(255),


  		




  73
  
  
    
    LIFESPAN_FREETEXT VARCHAR(255),


  		




  74
  
  
    
    LIFESPAN_START VARCHAR(255),


  		




  75
  
  
    
    PREFIX VARCHAR(255),


  		




  76
  
  
    
    SUFFIX VARCHAR(255),


  		




  77
  
  
    
	HASMOREMEMBERS BOOLEAN,


  		




  78
  
  
    
    CREATEDBY_ID INTEGER,


  		




  79
  
  
    
    UPDATEDBY_ID INTEGER,


  		




  80
  
  
    
    ISPARTOF_ID INTEGER


  		




  81
  
  
    
);


  		




  82
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE;


  		




  83
  
  
    
CREATE INDEX PUBLIC.AGENTTITLECACHEINDEX ON PUBLIC.AGENTBASE(TITLECACHE);


  		




  84
  
  
    
CREATE CACHED TABLE PUBLIC.AGENTBASE_AUD(


  		




  85
  
  
    
    DTYPE VARCHAR(31) NOT NULL,


  		




  86
  
  
    
    ID INTEGER NOT NULL,


  		




  87
  
  
    
    REV INTEGER NOT NULL,


  		




  88
  
  
    
    REVTYPE TINYINT,


  		




  89
  
  
    
    CREATED TIMESTAMP,


  		




  90
  
  
    
    UUID VARCHAR(36),


  		




  91
  
  
    
    UPDATED TIMESTAMP,


  		




  92
  
  
    
    LSID_AUTHORITY VARCHAR(255),


  		




  93
  
  
    
    LSID_LSID VARCHAR(255),


  		




  94
  
  
    
    LSID_NAMESPACE VARCHAR(255),


  		




  95
  
  
    
    LSID_OBJECT VARCHAR(255),


  		




  96
  
  
    
    LSID_REVISION VARCHAR(255),


  		




  97
  
  
    
    PROTECTEDTITLECACHE BOOLEAN,


  		




  98
  
  
    
    TITLECACHE VARCHAR(255),


  		




  99
  
  
    
    PROTECTEDCOLLECTORTITLECACHE BOOLEAN NOT NULL,


  		




  100
  
  
    
	COLLECTORTITLE VARCHAR(255),


  		




  101
  
  
    
    NOMENCLATURALTITLE VARCHAR(255),


  		




  102
  
  
    
    PROTECTEDNOMENCLATURALTITLECACHE BOOLEAN,


  		




  103
  
  
    
    FIRSTNAME VARCHAR(255),


  		




  104
  
  
    
    LASTNAME VARCHAR(255),


  		




  105
  
  
    
    LIFESPAN_END VARCHAR(255),


  		




  106
  
  
    
    LIFESPAN_FREETEXT VARCHAR(255),


  		




  107
  
  
    
    LIFESPAN_START VARCHAR(255),


  		




  108
  
  
    
    PREFIX VARCHAR(255),


  		




  109
  
  
    
    SUFFIX VARCHAR(255),


  		




  110
  
  
    
    CODE VARCHAR(255),


  		




  111
  
  
    
    NAME VARCHAR(255),	


  		




  112
  
  
    
	HASMOREMEMBERS BOOLEAN,


  		




  113
  
  
    
    CREATEDBY_ID INTEGER,


  		




  114
  
  
    
    UPDATEDBY_ID INTEGER,


  		




  115
  
  
    
   	ISPARTOF_ID INTEGER,


  		




  116
  
  
    

  		




  117
  
  
    
);


  		




  118
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_AUD;


  		




  119
  
  
    
CREATE CACHED TABLE PUBLIC.AGENTBASE_ADDRESS(


  		




  120
  
  
    
    AGENTBASE_ID INTEGER NOT NULL,


  		




  121
  
  
    
    CONTACT_ADDRESSES_ID INTEGER NOT NULL


  		




  122
  
  
    
);


  		




  123
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_ADDRESS;


  		




  124
  
  
    
CREATE CACHED TABLE PUBLIC.AGENTBASE_ADDRESS_AUD(


  		




  125
  
  
    
    REV INTEGER NOT NULL,


  		




  126
  
  
    
    AGENTBASE_ID INTEGER NOT NULL,


  		




  127
  
  
    
    CONTACT_ADDRESSES_ID INTEGER NOT NULL,


  		




  128
  
  
    
    REVTYPE TINYINT


  		




  129
  
  
    
);


  		




  130
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_ADDRESS_AUD;


  		




  131
  
  
    
CREATE CACHED TABLE PUBLIC.AGENTBASE_AGENTBASE(


  		




  132
  
  
    
    AGENTBASE_ID INTEGER NOT NULL,


  		




  133
  
  
    
    TEAMMEMBERS_ID INTEGER NOT NULL,


  		




  134
  
  
    
    SORTINDEX INTEGER NOT NULL


  		




  135
  
  
    
);


  		




  136
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_AGENTBASE;


  		




  137
  
  
    
CREATE CACHED TABLE PUBLIC.AGENTBASE_AGENTBASE_AUD(


  		




  138
  
  
    
    REV INTEGER NOT NULL,


  		




  139
  
  
    
    AGENTBASE_ID INTEGER NOT NULL,


  		




  140
  
  
    
    TEAMMEMBERS_ID INTEGER NOT NULL,


  		




  141
  
  
    
    SORTINDEX INTEGER NOT NULL,


  		




  142
  
  
    
    REVTYPE TINYINT


  		




  143
  
  
    
);


  		




  144
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_AGENTBASE_AUD;


  		




  145
  
  
    
CREATE CACHED TABLE PUBLIC.AGENTBASE_ANNOTATION(


  		




  146
  
  
    
    AGENTBASE_ID INTEGER NOT NULL,


  		




  147
  
  
    
    ANNOTATIONS_ID INTEGER NOT NULL


  		




  148
  
  
    
);


  		




  149
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_ANNOTATION;


  		




  150
  
  
    
CREATE CACHED TABLE PUBLIC.AGENTBASE_ANNOTATION_AUD(


  		




  151
  
  
    
    REV INTEGER NOT NULL,


  		




  152
  
  
    
    AGENTBASE_ID INTEGER NOT NULL,


  		




  153
  
  
    
    ANNOTATIONS_ID INTEGER NOT NULL,


  		




  154
  
  
    
    REVTYPE TINYINT


  		




  155
  
  
    
);


  		




  156
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_ANNOTATION_AUD;


  		




  157
  
  
    
CREATE CACHED TABLE PUBLIC.AGENTBASE_CREDIT(


  		




  158
  
  
    
    AGENTBASE_ID INTEGER NOT NULL,


  		




  159
  
  
    
    CREDITS_ID INTEGER NOT NULL,


  		




  160
  
  
    
    SORTINDEX INTEGER NOT NULL


  		




  161
  
  
    
);


  		




  162
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_CREDIT;


  		




  163
  
  
    
CREATE CACHED TABLE PUBLIC.AGENTBASE_CREDIT_AUD(


  		




  164
  
  
    
    REV INTEGER NOT NULL,


  		




  165
  
  
    
    AGENTBASE_ID INTEGER NOT NULL,


  		




  166
  
  
    
    CREDITS_ID INTEGER NOT NULL,


  		




  167
  
  
    
    SORTINDEX INTEGER NOT NULL,


  		




  168
  
  
    
    REVTYPE TINYINT


  		




  169
  
  
    
);


  		




  170
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_CREDIT_AUD;


  		




  171
  
  
    
CREATE CACHED TABLE PUBLIC.AGENTBASE_DEFINEDTERMBASE(


  		




  172
  
  
    
    AGENTBASE_ID INTEGER NOT NULL,


  		




  173
  
  
    
    TYPES_ID INTEGER NOT NULL


  		




  174
  
  
    
);


  		




  175
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_DEFINEDTERMBASE;


  		




  176
  
  
    
CREATE CACHED TABLE PUBLIC.AGENTBASE_DEFINEDTERMBASE_AUD(


  		




  177
  
  
    
    REV INTEGER NOT NULL,


  		




  178
  
  
    
    AGENTBASE_ID INTEGER NOT NULL,


  		




  179
  
  
    
    TYPES_ID INTEGER NOT NULL,


  		




  180
  
  
    
    REVTYPE TINYINT


  		




  181
  
  
    
);


  		




  182
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_DEFINEDTERMBASE_AUD;


  		




  183
  
  
    
CREATE CACHED TABLE PUBLIC.AGENTBASE_EXTENSION(


  		




  184
  
  
    
    AGENTBASE_ID INTEGER NOT NULL,


  		




  185
  
  
    
    EXTENSIONS_ID INTEGER NOT NULL


  		




  186
  
  
    
);


  		




  187
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_EXTENSION;


  		




  188
  
  
    
CREATE CACHED TABLE PUBLIC.AGENTBASE_EXTENSION_AUD(


  		




  189
  
  
    
    REV INTEGER NOT NULL,


  		




  190
  
  
    
    AGENTBASE_ID INTEGER NOT NULL,


  		




  191
  
  
    
    EXTENSIONS_ID INTEGER NOT NULL,


  		




  192
  
  
    
    REVTYPE TINYINT


  		




  193
  
  
    
);


  		




  194
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_EXTENSION_AUD;


  		




  195
  
  
    
CREATE CACHED TABLE PUBLIC.AGENTBASE_IDENTIFIER(


  		




  196
  
  
    
    AGENTBASE_ID INTEGER NOT NULL,


  		




  197
  
  
    
    IDENTIFIERS_ID INTEGER NOT NULL,


  		




  198
  
  
    
    SORTINDEX INTEGER NOT NULL


  		




  199
  
  
    
);


  		




  200
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_IDENTIFIER;


  		




  201
  
  
    
CREATE CACHED TABLE PUBLIC.AGENTBASE_IDENTIFIER_AUD(


  		




  202
  
  
    
    REV INTEGER NOT NULL,


  		




  203
  
  
    
    AGENTBASE_ID INTEGER NOT NULL,


  		




  204
  
  
    
    IDENTIFIERS_ID INTEGER NOT NULL,


  		




  205
  
  
    
    SORTINDEX INTEGER NOT NULL,


  		




  206
  
  
    
    REVTYPE TINYINT


  		




  207
  
  
    
);


  		




  208
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_IDENTIFIER_AUD;


  		




  209
  
  
    
CREATE CACHED TABLE PUBLIC.AGENTBASE_MARKER(


  		




  210
  
  
    
    AGENTBASE_ID INTEGER NOT NULL,


  		




  211
  
  
    
    MARKERS_ID INTEGER NOT NULL


  		




  212
  
  
    
);


  		




  213
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_MARKER;


  		




  214
  
  
    
CREATE CACHED TABLE PUBLIC.AGENTBASE_MARKER_AUD(


  		




  215
  
  
    
    REV INTEGER NOT NULL,


  		




  216
  
  
    
    AGENTBASE_ID INTEGER NOT NULL,


  		




  217
  
  
    
    MARKERS_ID INTEGER NOT NULL,


  		




  218
  
  
    
    REVTYPE TINYINT


  		




  219
  
  
    
);


  		




  220
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_MARKER_AUD;


  		




  221
  
  
    
CREATE CACHED TABLE PUBLIC.AGENTBASE_MEDIA(


  		




  222
  
  
    
    AGENTBASE_ID INTEGER NOT NULL,


  		




  223
  
  
    
    MEDIA_ID INTEGER NOT NULL


  		




  224
  
  
    
);


  		




  225
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_MEDIA;


  		




  226
  
  
    
CREATE CACHED TABLE PUBLIC.AGENTBASE_MEDIA_AUD(


  		




  227
  
  
    
    REV INTEGER NOT NULL,


  		




  228
  
  
    
    AGENTBASE_ID INTEGER NOT NULL,


  		




  229
  
  
    
    MEDIA_ID INTEGER NOT NULL,


  		




  230
  
  
    
    REVTYPE TINYINT


  		




  231
  
  
    
);


  		




  232
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_MEDIA_AUD;


  		




  233
  
  
    
CREATE CACHED TABLE PUBLIC.AGENTBASE_ORIGINALSOURCEBASE(


  		




  234
  
  
    
    AGENTBASE_ID INTEGER NOT NULL,


  		




  235
  
  
    
    SOURCES_ID INTEGER NOT NULL


  		




  236
  
  
    
);


  		




  237
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_ORIGINALSOURCEBASE;


  		




  238
  
  
    
CREATE CACHED TABLE PUBLIC.AGENTBASE_ORIGINALSOURCEBASE_AUD(


  		




  239
  
  
    
    REV INTEGER NOT NULL,


  		




  240
  
  
    
    AGENTBASE_ID INTEGER NOT NULL,


  		




  241
  
  
    
    SOURCES_ID INTEGER NOT NULL,


  		




  242
  
  
    
    REVTYPE TINYINT


  		




  243
  
  
    
);


  		




  244
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_ORIGINALSOURCEBASE_AUD;


  		




  245
  
  
    
CREATE CACHED TABLE PUBLIC.AGENTBASE_RIGHTSINFO(


  		




  246
  
  
    
    AGENTBASE_ID INTEGER NOT NULL,


  		




  247
  
  
    
    RIGHTS_ID INTEGER NOT NULL


  		




  248
  
  
    
);


  		




  249
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_RIGHTSINFO;


  		




  250
  
  
    
CREATE CACHED TABLE PUBLIC.AGENTBASE_RIGHTSINFO_AUD(


  		




  251
  
  
    
    REV INTEGER NOT NULL,


  		




  252
  
  
    
    AGENTBASE_ID INTEGER NOT NULL,


  		




  253
  
  
    
    RIGHTS_ID INTEGER NOT NULL,


  		




  254
  
  
    
    REVTYPE TINYINT


  		




  255
  
  
    
);


  		




  256
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_RIGHTSINFO_AUD;


  		




  257
  
  
    
CREATE CACHED TABLE PUBLIC.AGENTBASE_CONTACT_EMAILADDRESSES(


  		




  258
  
  
    
    AGENTBASE_ID INTEGER NOT NULL,


  		




  259
  
  
    
    CONTACT_EMAILADDRESSES_ELEMENT VARCHAR(255)


  		




  260
  
  
    
);


  		




  261
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_CONTACT_EMAILADDRESSES;


  		




  262
  
  
    
CREATE CACHED TABLE PUBLIC.AGENTBASE_CONTACT_EMAILADDRESSES_AUD(


  		




  263
  
  
    
    REV INTEGER NOT NULL,


  		




  264
  
  
    
    AGENTBASE_ID INTEGER NOT NULL,


  		




  265
  
  
    
    CONTACT_EMAILADDRESSES_ELEMENT VARCHAR(255) NOT NULL,


  		




  266
  
  
    
    REVTYPE TINYINT


  		




  267
  
  
    
);


  		




  268
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_CONTACT_EMAILADDRESSES_AUD;


  		




  269
  
  
    
CREATE CACHED TABLE PUBLIC.AGENTBASE_CONTACT_FAXNUMBERS(


  		




  270
  
  
    
    AGENTBASE_ID INTEGER NOT NULL,


  		




  271
  
  
    
    CONTACT_FAXNUMBERS_ELEMENT VARCHAR(255)


  		




  272
  
  
    
);


  		




  273
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_CONTACT_FAXNUMBERS;


  		




  274
  
  
    
CREATE CACHED TABLE PUBLIC.AGENTBASE_CONTACT_FAXNUMBERS_AUD(


  		




  275
  
  
    
    REV INTEGER NOT NULL,


  		




  276
  
  
    
    AGENTBASE_ID INTEGER NOT NULL,


  		




  277
  
  
    
    CONTACT_FAXNUMBERS_ELEMENT VARCHAR(255) NOT NULL,


  		




  278
  
  
    
    REVTYPE TINYINT


  		




  279
  
  
    
);


  		




  280
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_CONTACT_FAXNUMBERS_AUD;


  		




  281
  
  
    
CREATE CACHED TABLE PUBLIC.AGENTBASE_CONTACT_PHONENUMBERS(


  		




  282
  
  
    
    AGENTBASE_ID INTEGER NOT NULL,


  		




  283
  
  
    
    CONTACT_PHONENUMBERS_ELEMENT VARCHAR(255)


  		




  284
  
  
    
);


  		




  285
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_CONTACT_PHONENUMBERS;


  		




  286
  
  
    
CREATE CACHED TABLE PUBLIC.AGENTBASE_CONTACT_PHONENUMBERS_AUD(


  		




  287
  
  
    
    REV INTEGER NOT NULL,


  		




  288
  
  
    
    AGENTBASE_ID INTEGER NOT NULL,


  		




  289
  
  
    
    CONTACT_PHONENUMBERS_ELEMENT VARCHAR(255) NOT NULL,


  		




  290
  
  
    
    REVTYPE TINYINT


  		




  291
  
  
    
);


  		




  292
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_CONTACT_PHONENUMBERS_AUD;


  		




  293
  
  
    
CREATE CACHED TABLE PUBLIC.AGENTBASE_CONTACT_URLS(


  		




  294
  
  
    
    AGENTBASE_ID INTEGER NOT NULL,


  		




  295
  
  
    
    CONTACT_URLS_ELEMENT VARCHAR(255)


  		




  296
  
  
    
);


  		




  297
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_CONTACT_URLS;


  		




  298
  
  
    
CREATE CACHED TABLE PUBLIC.AGENTBASE_CONTACT_URLS_AUD(


  		




  299
  
  
    
    REV INTEGER NOT NULL,


  		




  300
  
  
    
    AGENTBASE_ID INTEGER NOT NULL,


  		




  301
  
  
    
    CONTACT_URLS_ELEMENT VARCHAR(255) NOT NULL,


  		




  302
  
  
    
    REVTYPE TINYINT


  		




  303
  
  
    
);


  		




  304
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_CONTACT_URLS_AUD;


  		




  305
  
  
    

  		




  306
  
  
    
CREATE TABLE AMPLIFICATION (


  		




  307
  
  
    
     ID INTEGER NOT NULL,


  		




  308
  
  
    
     CREATED TIMESTAMP,


  		




  309
  
  
    
     UUID VARCHAR(36),


  		




  310
  
  
    
     UPDATED TIMESTAMP,


  		




  311
  
  
    
     DESCRIPTION VARCHAR(255),


  		




  312
  
  
    
     TIMEPERIOD_END VARCHAR(255),


  		




  313
  
  
    
     TIMEPERIOD_FREETEXT VARCHAR(255),


  		




  314
  
  
    
     TIMEPERIOD_START VARCHAR(255),


  		




  315
  
  
    
     ELECTROPHORESISVOLTAGE DOUBLE,


  		




  316
  
  
    
     GELCONCENTRATION DOUBLE,


  		




  317
  
  
    
     GELRUNNINGTIME DOUBLE,


  		




  318
  
  
    
     LADDERUSED VARCHAR(255),


  		




  319
  
  
    
	 LABELCACHE VARCHAR(255),


  		




  320
  
  
    
     CREATEDBY_ID INTEGER,


  		




  321
  
  
    
     UPDATEDBY_ID INTEGER,


  		




  322
  
  
    
     ACTOR_ID INTEGER,


  		




  323
  
  
    
     FORWARDPRIMER_ID INTEGER,


  		




  324
  
  
    
     DNAMARKER_ID INTEGER,


  		




  325
  
  
    
     PURIFICATION_ID INTEGER,


  		




  326
  
  
    
     INSTITUTION_ID INTEGER,


  		




  327
  
  
    
	 REVERSEPRIMER_ID INTEGER,


  		




  328
  
  
    
     PRIMARY KEY (ID)


  		




  329
  
  
    
);


  		




  330
  
  
    

  		




  331
  
  
    
CREATE TABLE AMPLIFICATION_AUD (


  		




  332
  
  
    
    ID INTEGER NOT NULL,


  		




  333
  
  
    
    REV INTEGER NOT NULL,


  		




  334
  
  
    
    REVTYPE TINYINT,


  		




  335
  
  
    
    CREATED TIMESTAMP,


  		




  336
  
  
    
    UUID VARCHAR(36),


  		




  337
  
  
    
    UPDATED TIMESTAMP,


  		




  338
  
  
    
    DESCRIPTION VARCHAR(255),


  		




  339
  
  
    
    TIMEPERIOD_END VARCHAR(255),


  		




  340
  
  
    
    TIMEPERIOD_FREETEXT VARCHAR(255),


  		




  341
  
  
    
    TIMEPERIOD_START VARCHAR(255),


  		




  342
  
  
    
    ELECTROPHORESISVOLTAGE DOUBLE,


  		




  343
  
  
    
    GELCONCENTRATION DOUBLE,


  		




  344
  
  
    
    GELRUNNINGTIME DOUBLE,


  		




  345
  
  
    
    LADDERUSED VARCHAR(255),


  		




  346
  
  
    
    LABELCACHE VARCHAR(255),


  		




  347
  
  
    
    CREATEDBY_ID INTEGER,


  		




  348
  
  
    
    UPDATEDBY_ID INTEGER,


  		




  349
  
  
    
    ACTOR_ID INTEGER,


  		




  350
  
  
    
    FORWARDPRIMER_ID INTEGER,


  		




  351
  
  
    
    DNAMARKER_ID INTEGER,


  		




  352
  
  
    
    PURIFICATION_ID INTEGER,


  		




  353
  
  
    
    INSTITUTION_ID INTEGER,


  		




  354
  
  
    
	REVERSEPRIMER_ID INTEGER,


  		




  355
  
  
    
    PRIMARY KEY (ID)


  		




  356
  
  
    
);


  		




  357
  
  
    

  		




  358
  
  
    
CREATE TABLE AMPLIFICATION_ANNOTATION (


  		




  359
  
  
    
    AMPLIFICATION_ID INTEGER NOT NULL,


  		




  360
  
  
    
    ANNOTATIONS_ID INTEGER NOT NULL,


  		




  361
  
  
    
    PRIMARY KEY (AMPLIFICATION_ID, ANNOTATIONS_ID)


  		




  362
  
  
    
);


  		




  363
  
  
    

  		




  364
  
  
    
CREATE TABLE AMPLIFICATION_ANNOTATION_AUD (


  		




  365
  
  
    
    REV INTEGER NOT NULL,


  		




  366
  
  
    
    REVTYPE TINYINT,


  		




  367
  
  
    
    AMPLIFICATION_ID INTEGER NOT NULL,


  		




  368
  
  
    
    ANNOTATIONS_ID INTEGER NOT NULL


  		




  369
  
  
    
);


  		




  370
  
  
    

  		




  371
  
  
    
CREATE TABLE AMPLIFICATION_MARKER (


  		




  372
  
  
    
    AMPLIFICATION_ID INTEGER NOT NULL,


  		




  373
  
  
    
    MARKERS_ID INTEGER NOT NULL,


  		




  374
  
  
    
    PRIMARY KEY (AMPLIFICATION_ID, MARKERS_ID)


  		




  375
  
  
    
);


  		




  376
  
  
    

  		




  377
  
  
    
CREATE TABLE AMPLIFICATION_MARKER_AUD (


  		




  378
  
  
    
    REV INTEGER NOT NULL,


  		




  379
  
  
    
    REVTYPE TINYINT,


  		




  380
  
  
    
    AMPLIFICATION_ID INTEGER NOT NULL,


  		




  381
  
  
    
    MARKERS_ID INTEGER NOT NULL,


  		




  382
  
  
    
);


  		




  383
  
  
    

  		




  384
  
  
    
CREATE TABLE AMPLIFICATIONRESULT (


  		




  385
  
  
    
     ID INTEGER NOT NULL,


  		




  386
  
  
    
     CREATED TIMESTAMP,


  		




  387
  
  
    
     UUID VARCHAR(36),


  		




  388
  
  
    
     UPDATED TIMESTAMP,


  		




  389
  
  
    
     SUCCESSTEXT VARCHAR(255),


  		




  390
  
  
    
     SUCCESSFUL BOOLEAN,


  		




  391
  
  
    
     CREATEDBY_ID INTEGER,


  		




  392
  
  
    
     UPDATEDBY_ID INTEGER,


  		




  393
  
  
    
     CLONING_ID INTEGER,


  		




  394
  
  
    
     DNASAMPLE_ID INTEGER,


  		




  395
  
  
    
	 AMPLIFICATION_ID INTEGER,


  		




  396
  
  
    
	 GELPHOTO_ID INTEGER,


  		




  397
  
  
    
     PRIMARY KEY (ID)


  		




  398
  
  
    
);


  		




  399
  
  
    

  		




  400
  
  
    
CREATE TABLE AMPLIFICATIONRESULT_AUD (


  		




  401
  
  
    
     ID INTEGER NOT NULL,


  		




  402
  
  
    
	 REV INTEGER NOT NULL,


  		




  403
  
  
    
     REVTYPE TINYINT,


  		




  404
  
  
    
     CREATED TIMESTAMP,


  		




  405
  
  
    
     UUID VARCHAR(36),


  		




  406
  
  
    
     UPDATED TIMESTAMP,


  		




  407
  
  
    
     SUCCESSTEXT VARCHAR(255),


  		




  408
  
  
    
     SUCCESSFUL BOOLEAN,


  		




  409
  
  
    
     CREATEDBY_ID INTEGER,


  		




  410
  
  
    
     UPDATEDBY_ID INTEGER,


  		




  411
  
  
    
     CLONING_ID INTEGER,


  		




  412
  
  
    
     DNASAMPLE_ID INTEGER,


  		




  413
  
  
    
     AMPLIFICATION_ID INTEGER,


  		




  414
  
  
    
	 GELPHOTO_ID INTEGER,


  		




  415
  
  
    
     PRIMARY KEY (ID)


  		




  416
  
  
    
);


  		




  417
  
  
    

  		




  418
  
  
    
CREATE TABLE AMPLIFICATIONRESULT_ANNOTATION (


  		




  419
  
  
    
    AMPLIFICATIONRESULT_ID INTEGER NOT NULL,


  		




  420
  
  
    
    ANNOTATIONS_ID INTEGER NOT NULL,


  		




  421
  
  
    
    PRIMARY KEY (AMPLIFICATIONRESULT_ID, ANNOTATIONS_ID)


  		




  422
  
  
    
);


  		




  423
  
  
    

  		




  424
  
  
    
CREATE TABLE AMPLIFICATIONRESULT_ANNOTATION_AUD (


  		




  425
  
  
    
    REV INTEGER NOT NULL,


  		




  426
  
  
    
    REVTYPE TINYINT,


  		




  427
  
  
    
    AMPLIFICATIONRESULT_ID INTEGER NOT NULL,


  		




  428
  
  
    
    ANNOTATIONS_ID INTEGER NOT NULL


  		




  429
  
  
    
);


  		




  430
  
  
    

  		




  431
  
  
    
CREATE TABLE AMPLIFICATIONRESULT_MARKER (


  		




  432
  
  
    
    AMPLIFICATIONRESULT_ID INTEGER NOT NULL,


  		




  433
  
  
    
    MARKERS_ID INTEGER NOT NULL,


  		




  434
  
  
    
    PRIMARY KEY (AMPLIFICATIONRESULT_ID, MARKERS_ID)


  		




  435
  
  
    
);


  		




  436
  
  
    

  		




  437
  
  
    
CREATE TABLE AMPLIFICATIONRESULT_MARKER_AUD (


  		




  438
  
  
    
    REV INTEGER NOT NULL,


  		




  439
  
  
    
    REVTYPE TINYINT,


  		




  440
  
  
    
    AMPLIFICATIONRESULT_ID INTEGER NOT NULL,


  		




  441
  
  
    
    MARKERS_ID INTEGER NOT NULL,


  		




  442
  
  
    
);


  		




  443
  
  
    

  		




  444
  
  
    

  		




  445
  
  
    
CREATE CACHED TABLE PUBLIC.ANNOTATION(


  		




  446
  
  
    
    ID INTEGER NOT NULL,


  		




  447
  
  
    
    CREATED TIMESTAMP,


  		




  448
  
  
    
    UUID VARCHAR(36),


  		




  449
  
  
    
    UPDATED TIMESTAMP,


  		




  450
  
  
    
    TEXT CLOB,


  		




  451
  
  
    
    ANNOTATEDOBJ_TYPE VARCHAR(255),


  		




  452
  
  
    
    ANNOTATEDOBJ_ID INTEGER NOT NULL,


  		




  453
  
  
    
    LINKBACKURI CLOB,


  		




  454
  
  
    
    CREATEDBY_ID INTEGER,


  		




  455
  
  
    
    UPDATEDBY_ID INTEGER,


  		




  456
  
  
    
    LANGUAGE_ID INTEGER,


  		




  457
  
  
    
    ANNOTATIONTYPE_ID INTEGER,


  		




  458
  
  
    
    COMMENTATOR_ID INTEGER


  		




  459
  
  
    
);


  		




  460
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ANNOTATION;


  		




  461
  
  
    
CREATE CACHED TABLE PUBLIC.ANNOTATION_AUD(


  		




  462
  
  
    
    ID INTEGER NOT NULL,


  		




  463
  
  
    
    REV INTEGER NOT NULL,


  		




  464
  
  
    
    REVTYPE TINYINT,


  		




  465
  
  
    
    CREATED TIMESTAMP,


  		




  466
  
  
    
    UUID VARCHAR(36),


  		




  467
  
  
    
    UPDATED TIMESTAMP,


  		




  468
  
  
    
    TEXT CLOB,


  		




  469
  
  
    
    LINKBACKURI CLOB,


  		




  470
  
  
    
    CREATEDBY_ID INTEGER,


  		




  471
  
  
    
    UPDATEDBY_ID INTEGER,


  		




  472
  
  
    
    LANGUAGE_ID INTEGER,


  		




  473
  
  
    
    ANNOTATIONTYPE_ID INTEGER,


  		




  474
  
  
    
    COMMENTATOR_ID INTEGER


  		




  475
  
  
    
);


  		




  476
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ANNOTATION_AUD;


  		




  477
  
  
    
CREATE CACHED TABLE PUBLIC.ANNOTATION_ANNOTATION(


  		




  478
  
  
    
    ANNOTATION_ID INTEGER NOT NULL,


  		




  479
  
  
    
    ANNOTATIONS_ID INTEGER NOT NULL


  		




  480
  
  
    
);


  		




  481
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ANNOTATION_ANNOTATION;


  		




  482
  
  
    
CREATE CACHED TABLE PUBLIC.ANNOTATION_ANNOTATION_AUD(


  		




  483
  
  
    
    REV INTEGER NOT NULL,


  		




  484
  
  
    
    ANNOTATION_ID INTEGER NOT NULL,


  		




  485
  
  
    
    ANNOTATIONS_ID INTEGER NOT NULL,


  		




  486
  
  
    
    REVTYPE TINYINT


  		




  487
  
  
    
);


  		




  488
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ANNOTATION_ANNOTATION_AUD;


  		




  489
  
  
    
CREATE CACHED TABLE PUBLIC.ANNOTATION_MARKER(


  		




  490
  
  
    
    ANNOTATION_ID INTEGER NOT NULL,


  		




  491
  
  
    
    MARKERS_ID INTEGER NOT NULL


  		




  492
  
  
    
);


  		




  493
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ANNOTATION_MARKER;


  		




  494
  
  
    
CREATE CACHED TABLE PUBLIC.ANNOTATION_MARKER_AUD(


  		




  495
  
  
    
    REV INTEGER NOT NULL,


  		




  496
  
  
    
    ANNOTATION_ID INTEGER NOT NULL,


  		




  497
  
  
    
    MARKERS_ID INTEGER NOT NULL,


  		




  498
  
  
    
    REVTYPE TINYINT


  		




  499
  
  
    
);


  		




  500
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ANNOTATION_MARKER_AUD;


  		




  501
  
  
    
CREATE CACHED TABLE PUBLIC.AUDITEVENT(


  		




  502
  
  
    
    REVISIONNUMBER INTEGER DEFAULT (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_10A55F0A_EE57_42DB_8046_6240A60AD0EC) NOT NULL NULL_TO_DEFAULT SEQUENCE PUBLIC.SYSTEM_SEQUENCE_10A55F0A_EE57_42DB_8046_6240A60AD0EC,


  		




  503
  
  
    
    DATE TIMESTAMP,


  		




  504
  
  
    
    TIMESTAMP BIGINT,


  		




  505
  
  
    
    UUID VARCHAR(255)


  		




  506
  
  
    
);


  		




  507
  
  
    
-- 3 +/- SELECT COUNT(*) FROM PUBLIC.AUDITEVENT;


  		




  508
  
  
    
CREATE CACHED TABLE PUBLIC.CDM_VIEW(


  		




  509
  
  
    
    ID INTEGER NOT NULL,


  		




  510
  
  
    
    CREATED TIMESTAMP,


  		




  511
  
  
    
    UUID VARCHAR(36),


  		




  512
  
  
    
    DESCRIPTION VARCHAR(255),


  		




  513
  
  
    
    NAME VARCHAR(255),


  		




  514
  
  
    
    CREATEDBY_ID INTEGER,


  		




  515
  
  
    
    REFERENCE_ID INTEGER


  		




  516
  
  
    
);


  		




  517
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CDM_VIEW;


  		




  518
  
  
    
CREATE CACHED TABLE PUBLIC.CDM_VIEW_CDM_VIEW(


  		




  519
  
  
    
    CDM_VIEW_ID INTEGER NOT NULL,


  		




  520
  
  
    
    SUPERVIEWS_ID INTEGER NOT NULL


  		




  521
  
  
    
);


  		




  522
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CDM_VIEW_CDM_VIEW;


  		




  523
  
  
    
CREATE CACHED TABLE PUBLIC.CDMMETADATA(


  		




  524
  
  
    
    ID INTEGER NOT NULL,


  		




  525
  
  
    
    CREATED TIMESTAMP,


  		




  526
  
  
    
    UUID VARCHAR(36),


  		




  527
  
  
    
    PROPERTYNAME INTEGER,


  		




  528
  
  
    
    VALUE VARCHAR(255),


  		




  529
  
  
    
    CREATEDBY_ID INTEGER


  		




  530
  
  
    
);


  		




  531
  
  
    
-- 3 +/- SELECT COUNT(*) FROM PUBLIC.CDMMETADATA;


  		




  532
  
  
    
CREATE CACHED TABLE PUBLIC.CDMPREFERENCE(


  		




  533
  
  
    
    KEY_SUBJECT VARCHAR(100),


  		




  534
  
  
    
    KEY_PREDICATE VARCHAR(100),


  		




  535
  
  
    
    VALUE VARCHAR(1023)


  		




  536
  
  
    
);


  		




  537
  
  
    
-- 3 +/- SELECT COUNT(*) FROM PUBLIC.CDMPREFERENCE;


  		




  538
  
  
    
CREATE CACHED TABLE PUBLIC.CLASSIFICATION(


  		




  539
  
  
    
    ID INTEGER NOT NULL,


  		




  540
  
  
    
    CREATED TIMESTAMP,


  		




  541
  
  
    
    UUID VARCHAR(36),


  		




  542
  
  
    
    UPDATED TIMESTAMP,


  		




  543
  
  
    
    LSID_AUTHORITY VARCHAR(255),


  		




  544
  
  
    
    LSID_LSID VARCHAR(255),


  		




  545
  
  
    
    LSID_NAMESPACE VARCHAR(255),


  		




  546
  
  
    
    LSID_OBJECT VARCHAR(255),


  		




  547
  
  
    
    LSID_REVISION VARCHAR(255),


  		




  548
  
  
    
    PROTECTEDTITLECACHE BOOLEAN NOT NULL,


  		




  549
  
  
    
    TITLECACHE VARCHAR(255),


  		




  550
  
  
    
    MICROREFERENCE VARCHAR(255),


  		




  551
  
  
    
    TIMEPERIOD_START VARCHAR(255),


  		




  552
  
  
    
    TIMEPERIOD_FREETEXT VARCHAR(255),


  		




  553
  
  
    
    TIMEPERIOD_END VARCHAR(255),


  		




  554
  
  
    
    CREATEDBY_ID INTEGER,


  		




  555
  
  
    
    UPDATEDBY_ID INTEGER,


  		




  556
  
  
    
    NAME_ID INTEGER,


  		




  557
  
  
    
    REFERENCE_ID INTEGER,


  		




  558
  
  
    
    ROOTNODE_ID INTEGER


  		




  559
  
  
    
);


  		




  560
  
  
    
-- 1 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION;


  		




  561
  
  
    
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_AUD(


  		




  562
  
  
    
    ID INTEGER NOT NULL,


  		




  563
  
  
    
    REV INTEGER NOT NULL,


  		




  564
  
  
    
    REVTYPE TINYINT,


  		




  565
  
  
    
    CREATED TIMESTAMP,


  		




  566
  
  
    
    UUID VARCHAR(36),


  		




  567
  
  
    
    UPDATED TIMESTAMP,


  		




  568
  
  
    
    LSID_AUTHORITY VARCHAR(255),


  		




  569
  
  
    
    LSID_LSID VARCHAR(255),


  		




  570
  
  
    
    LSID_NAMESPACE VARCHAR(255),


  		




  571
  
  
    
    LSID_OBJECT VARCHAR(255),


  		




  572
  
  
    
    LSID_REVISION VARCHAR(255),


  		




  573
  
  
    
    PROTECTEDTITLECACHE BOOLEAN,


  		




  574
  
  
    
    TITLECACHE VARCHAR(255),


  		




  575
  
  
    
    MICROREFERENCE VARCHAR(255),


  		




  576
  
  
    
    TIMEPERIOD_START VARCHAR(255),


  		




  577
  
  
    
    TIMEPERIOD_FREETEXT VARCHAR(255),


  		




  578
  
  
    
    TIMEPERIOD_END VARCHAR(255),


  		




  579
  
  
    
    CREATEDBY_ID INTEGER,


  		




  580
  
  
    
    UPDATEDBY_ID INTEGER,


  		




  581
  
  
    
    NAME_ID INTEGER,


  		




  582
  
  
    
    REFERENCE_ID INTEGER,


  		




  583
  
  
    
    ROOTNODE_ID INTEGER


  		




  584
  
  
    
);


  		




  585
  
  
    
-- 1 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_AUD;


  		




  586
  
  
    
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_ANNOTATION(


  		




  587
  
  
    
    CLASSIFICATION_ID INTEGER NOT NULL,


  		




  588
  
  
    
    ANNOTATIONS_ID INTEGER NOT NULL


  		




  589
  
  
    
);


  		




  590
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_ANNOTATION;


  		




  591
  
  
    
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_ANNOTATION_AUD(


  		




  592
  
  
    
    REV INTEGER NOT NULL,


  		




  593
  
  
    
    CLASSIFICATION_ID INTEGER NOT NULL,


  		




  594
  
  
    
    ANNOTATIONS_ID INTEGER NOT NULL,


  		




  595
  
  
    
    REVTYPE TINYINT


  		




  596
  
  
    
);


  		




  597
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_ANNOTATION_AUD;


  		




  598
  
  
    
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_CREDIT(


  		




  599
  
  
    
    CLASSIFICATION_ID INTEGER NOT NULL,


  		




  600
  
  
    
    CREDITS_ID INTEGER NOT NULL,


  		




  601
  
  
    
    SORTINDEX INTEGER NOT NULL


  		




  602
  
  
    
);


  		




  603
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_CREDIT;


  		




  604
  
  
    
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_CREDIT_AUD(


  		




  605
  
  
    
    REV INTEGER NOT NULL,


  		




  606
  
  
    
    CLASSIFICATION_ID INTEGER NOT NULL,


  		




  607
  
  
    
    CREDITS_ID INTEGER NOT NULL,


  		




  608
  
  
    
    SORTINDEX INTEGER NOT NULL,


  		




  609
  
  
    
    REVTYPE TINYINT


  		




  610
  
  
    
);


  		




  611
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_CREDIT_AUD;


  		




  612
  
  
    

  		




  613
  
  
    
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_DESCRIPTION(


  		




  614
  
  
    
    CLASSIFICATION_ID INTEGER NOT NULL,


  		




  615
  
  
    
   	DESCRIPTION_ID INTEGER NOT NULL,


  		




  616
  
  
    
   	DESCRIPTION_MAPKEY_ID INTEGER NOT NULL


  		




  617
  
  
    
);


  		




  618
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_DESCRIPTION;


  		




  619
  
  
    
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_DESCRIPTION_AUD(


  		




  620
  
  
    
    REV INTEGER NOT NULL,


  		




  621
  
  
    
    CLASSIFICATION_ID INTEGER NOT NULL,


  		




  622
  
  
    
    DESCRIPTION_ID INTEGER NOT NULL,


  		




  623
  
  
    
    DESCRIPTION_MAPKEY_ID INTEGER NOT NULL,


  		




  624
  
  
    
    REVTYPE TINYINT


  		




  625
  
  
    
);


  		




  626
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_DESCRIPTION_AUD;


  		




  627
  
  
    

  		




  628
  
  
    
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_EXTENSION(


  		




  629
  
  
    
    CLASSIFICATION_ID INTEGER NOT NULL,


  		




  630
  
  
    
    EXTENSIONS_ID INTEGER NOT NULL


  		




  631
  
  
    
);


  		




  632
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_EXTENSION;


  		




  633
  
  
    
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_EXTENSION_AUD(


  		




  634
  
  
    
    REV INTEGER NOT NULL,


  		




  635
  
  
    
    CLASSIFICATION_ID INTEGER NOT NULL,


  		




  636
  
  
    
    EXTENSIONS_ID INTEGER NOT NULL,


  		




  637
  
  
    
    REVTYPE TINYINT


  		




  638
  
  
    
);


  		




  639
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_EXTENSION_AUD;


  		




  640
  
  
    
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_GEOSCOPE(


  		




  641
  
  
    
    CLASSIFICATION_ID INTEGER NOT NULL,


  		




  642
  
  
    
    GEOSCOPES_ID INTEGER NOT NULL


  		




  643
  
  
    
);


  		




  644
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_GEOSCOPE;


  		




  645
  
  
    
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_GEOSCOPE_AUD(


  		




  646
  
  
    
    REV INTEGER NOT NULL,


  		




  647
  
  
    
    CLASSIFICATION_ID INTEGER NOT NULL,


  		




  648
  
  
    
    GEOSCOPES_ID INTEGER NOT NULL,


  		




  649
  
  
    
    REVTYPE TINYINT


  		




  650
  
  
    
);


  		




  651
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_GEOSCOPE_AUD;


  		




  652
  
  
    
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_IDENTIFIER(


  		




  653
  
  
    
    CLASSIFICATION_ID INTEGER NOT NULL,


  		




  654
  
  
    
    IDENTIFIERS_ID INTEGER NOT NULL,


  		




  655
  
  
    
    SORTINDEX INTEGER NOT NULL


  		




  656
  
  
    
);


  		




  657
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_IDENTIFIER;


  		




  658
  
  
    
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_IDENTIFIER_AUD(


  		




  659
  
  
    
    REV INTEGER NOT NULL,


  		




  660
  
  
    
    CLASSIFICATION_ID INTEGER NOT NULL,


  		




  661
  
  
    
    IDENTIFIERS_ID INTEGER NOT NULL,


  		




  662
  
  
    
    SORTINDEX INTEGER NOT NULL,


  		




  663
  
  
    
    REVTYPE TINYINT


  		




  664
  
  
    
);


  		




  665
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_IDENTIFIER_AUD;


  		




  666
  
  
    
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_MARKER(


  		




  667
  
  
    
    CLASSIFICATION_ID INTEGER NOT NULL,


  		




  668
  
  
    
    MARKERS_ID INTEGER NOT NULL


  		




  669
  
  
    
);


  		




  670
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_MARKER;


  		




  671
  
  
    
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_MARKER_AUD(


  		




  672
  
  
    
    REV INTEGER NOT NULL,


  		




  673
  
  
    
    CLASSIFICATION_ID INTEGER NOT NULL,


  		




  674
  
  
    
    MARKERS_ID INTEGER NOT NULL,


  		




  675
  
  
    
    REVTYPE TINYINT


  		




  676
  
  
    
);


  		




  677
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_MARKER_AUD;


  		




  678
  
  
    
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_ORIGINALSOURCEBASE(


  		




  679
  
  
    
    CLASSIFICATION_ID INTEGER NOT NULL,


  		




  680
  
  
    
    SOURCES_ID INTEGER NOT NULL


  		




  681
  
  
    
);


  		




  682
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_ORIGINALSOURCEBASE;


  		




  683
  
  
    
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_ORIGINALSOURCEBASE_AUD(


  		




  684
  
  
    
    REV INTEGER NOT NULL,


  		




  685
  
  
    
    CLASSIFICATION_ID INTEGER NOT NULL,


  		




  686
  
  
    
    SOURCES_ID INTEGER NOT NULL,


  		




  687
  
  
    
    REVTYPE TINYINT


  		




  688
  
  
    
);


  		




  689
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_ORIGINALSOURCEBASE_AUD;


  		




  690
  
  
    
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_RIGHTSINFO(


  		




  691
  
  
    
    CLASSIFICATION_ID INTEGER NOT NULL,


  		




  692
  
  
    
    RIGHTS_ID INTEGER NOT NULL


  		




  693
  
  
    
);


  		




  694
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_RIGHTSINFO;


  		




  695
  
  
    
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_RIGHTSINFO_AUD(


  		




  696
  
  
    
    REV INTEGER NOT NULL,


  		




  697
  
  
    
    CLASSIFICATION_ID INTEGER NOT NULL,


  		




  698
  
  
    
    RIGHTS_ID INTEGER NOT NULL,


  		




  699
  
  
    
    REVTYPE TINYINT


  		




  700
  
  
    
);


  		




  701
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_RIGHTSINFO_AUD;


  		




  702
  
  
    

  		




  703
  
  
    
CREATE CACHED TABLE PUBLIC.COLLECTION(


  		




  704
  
  
    
    ID INTEGER NOT NULL,


  		




  705
  
  
    
    CREATED TIMESTAMP,


  		




  706
  
  
    
    UUID VARCHAR(36),


  		




  707
  
  
    
    UPDATED TIMESTAMP,


  		




  708
  
  
    
    LSID_AUTHORITY VARCHAR(255),


  		




  709
  
  
    
    LSID_LSID VARCHAR(255),


  		




  710
  
  
    
    LSID_NAMESPACE VARCHAR(255),


  		




  711
  
  
    
    LSID_OBJECT VARCHAR(255),


  		




  712
  
  
    
    LSID_REVISION VARCHAR(255),


  		




  713
  
  
    
    PROTECTEDTITLECACHE BOOLEAN NOT NULL,


  		




  714
  
  
    
    TITLECACHE VARCHAR(255),


  		




  715
  
  
    
    CODE VARCHAR(255),


  		




  716
  
  
    
    CODESTANDARD VARCHAR(255),


  		




  717
  
  
    
    NAME VARCHAR(255),


  		




  718
  
  
    
    TOWNORLOCATION VARCHAR(255),


  		




  719
  
  
    
    CREATEDBY_ID INTEGER,


  		




  720
  
  
    
    UPDATEDBY_ID INTEGER,


  		




  721
  
  
    
    INSTITUTE_ID INTEGER,


  		




  722
  
  
    
    SUPERCOLLECTION_ID INTEGER


  		




  723
  
  
    
);


  		




  724
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION;


  		




  725
  
  
    
CREATE INDEX PUBLIC.COLLECTIONTITLECACHEINDEX ON PUBLIC.COLLECTION(TITLECACHE);


  		




  726
  
  
    
CREATE CACHED TABLE PUBLIC.COLLECTION_AUD(


  		




  727
  
  
    
    ID INTEGER NOT NULL,


  		




  728
  
  
    
    REV INTEGER NOT NULL,


  		




  729
  
  
    
    REVTYPE TINYINT,


  		




  730
  
  
    
    CREATED TIMESTAMP,


  		




  731
  
  
    
    UUID VARCHAR(36),


  		




  732
  
  
    
    UPDATED TIMESTAMP,


  		




  733
  
  
    
    LSID_AUTHORITY VARCHAR(255),


  		




  734
  
  
    
    LSID_LSID VARCHAR(255),


  		




  735
  
  
    
    LSID_NAMESPACE VARCHAR(255),


  		




  736
  
  
    
    LSID_OBJECT VARCHAR(255),


  		




  737
  
  
    
    LSID_REVISION VARCHAR(255),


  		




  738
  
  
    
    PROTECTEDTITLECACHE BOOLEAN,


  		




  739
  
  
    
    TITLECACHE VARCHAR(255),


  		




  740
  
  
    
    CODE VARCHAR(255),


  		




  741
  
  
    
    CODESTANDARD VARCHAR(255),


  		




  742
  
  
    
    NAME VARCHAR(255),


  		




  743
  
  
    
    TOWNORLOCATION VARCHAR(255),


  		




  744
  
  
    
    CREATEDBY_ID INTEGER,


  		




  745
  
  
    
    UPDATEDBY_ID INTEGER,


  		




  746
  
  
    
    INSTITUTE_ID INTEGER,


  		




  747
  
  
    
    SUPERCOLLECTION_ID INTEGER


  		




  748
  
  
    
);


  		




  749
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_AUD;


  		




  750
  
  
    
CREATE CACHED TABLE PUBLIC.COLLECTION_ANNOTATION(


  		




  751
  
  
    
    COLLECTION_ID INTEGER NOT NULL,


  		




  752
  
  
    
    ANNOTATIONS_ID INTEGER NOT NULL


  		




  753
  
  
    
);


  		




  754
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_ANNOTATION;


  		




  755
  
  
    
CREATE CACHED TABLE PUBLIC.COLLECTION_ANNOTATION_AUD(


  		




  756
  
  
    
    REV INTEGER NOT NULL,


  		




  757
  
  
    
    COLLECTION_ID INTEGER NOT NULL,


  		




  758
  
  
    
    ANNOTATIONS_ID INTEGER NOT NULL,


  		




  759
  
  
    
    REVTYPE TINYINT


  		




  760
  
  
    
);


  		




  761
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_ANNOTATION_AUD;


  		




  762
  
  
    
CREATE CACHED TABLE PUBLIC.COLLECTION_CREDIT(


  		




  763
  
  
    
    COLLECTION_ID INTEGER NOT NULL,


  		




  764
  
  
    
    CREDITS_ID INTEGER NOT NULL,


  		




  765
  
  
    
    SORTINDEX INTEGER NOT NULL


  		




  766
  
  
    
);


  		




  767
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_CREDIT;


  		




  768
  
  
    
CREATE CACHED TABLE PUBLIC.COLLECTION_CREDIT_AUD(


  		




  769
  
  
    
    REV INTEGER NOT NULL,


  		




  770
  
  
    
    COLLECTION_ID INTEGER NOT NULL,


  		




  771
  
  
    
    CREDITS_ID INTEGER NOT NULL,


  		




  772
  
  
    
    SORTINDEX INTEGER NOT NULL,


  		




  773
  
  
    
    REVTYPE TINYINT


  		




  774
  
  
    
);


  		




  775
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_CREDIT_AUD;


  		




  776
  
  
    
CREATE CACHED TABLE PUBLIC.COLLECTION_EXTENSION(


  		




  777
  
  
    
    COLLECTION_ID INTEGER NOT NULL,


  		




  778
  
  
    
    EXTENSIONS_ID INTEGER NOT NULL


  		




  779
  
  
    
);


  		




  780
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_EXTENSION;


  		




  781
  
  
    
CREATE CACHED TABLE PUBLIC.COLLECTION_EXTENSION_AUD(


  		




  782
  
  
    
    REV INTEGER NOT NULL,


  		




  783
  
  
    
    COLLECTION_ID INTEGER NOT NULL,


  		




  784
  
  
    
    EXTENSIONS_ID INTEGER NOT NULL,


  		




  785
  
  
    
    REVTYPE TINYINT


  		




  786
  
  
    
);


  		




  787
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_EXTENSION_AUD;


  		




  788
  
  
    
CREATE CACHED TABLE PUBLIC.COLLECTION_IDENTIFIER(


  		




  789
  
  
    
    COLLECTION_ID INTEGER NOT NULL,


  		




  790
  
  
    
    IDENTIFIERS_ID INTEGER NOT NULL,


  		




  791
  
  
    
    SORTINDEX INTEGER NOT NULL


  		




  792
  
  
    
);


  		




  793
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_IDENTIFIER;


  		




  794
  
  
    
CREATE CACHED TABLE PUBLIC.COLLECTION_IDENTIFIER_AUD(


  		




  795
  
  
    
    REV INTEGER NOT NULL,


  		




  796
  
  
    
    COLLECTION_ID INTEGER NOT NULL,


  		




  797
  
  
    
    IDENTIFIERS_ID INTEGER NOT NULL,


  		




  798
  
  
    
    SORTINDEX INTEGER NOT NULL,


  		




  799
  
  
    
    REVTYPE TINYINT


  		




  800
  
  
    
);


  		




  801
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_IDENTIFIER_AUD;


  		




  802
  
  
    
CREATE CACHED TABLE PUBLIC.COLLECTION_MARKER(


  		




  803
  
  
    
    COLLECTION_ID INTEGER NOT NULL,


  		




  804
  
  
    
    MARKERS_ID INTEGER NOT NULL


  		




  805
  
  
    
);


  		




  806
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_MARKER;


  		




  807
  
  
    
CREATE CACHED TABLE PUBLIC.COLLECTION_MARKER_AUD(


  		




  808
  
  
    
    REV INTEGER NOT NULL,


  		




  809
  
  
    
    COLLECTION_ID INTEGER NOT NULL,


  		




  810
  
  
    
    MARKERS_ID INTEGER NOT NULL,


  		




  811
  
  
    
    REVTYPE TINYINT


  		




  812
  
  
    
);


  		




  813
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_MARKER_AUD;


  		




  814
  
  
    
CREATE CACHED TABLE PUBLIC.COLLECTION_MEDIA(


  		




  815
  
  
    
    COLLECTION_ID INTEGER NOT NULL,


  		




  816
  
  
    
    MEDIA_ID INTEGER NOT NULL


  		




  817
  
  
    
);


  		




  818
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_MEDIA;


  		




  819
  
  
    
CREATE CACHED TABLE PUBLIC.COLLECTION_MEDIA_AUD(


  		




  820
  
  
    
    REV INTEGER NOT NULL,


  		




  821
  
  
    
    COLLECTION_ID INTEGER NOT NULL,


  		




  822
  
  
    
    MEDIA_ID INTEGER NOT NULL,


  		




  823
  
  
    
    REVTYPE TINYINT


  		




  824
  
  
    
);


  		




  825
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_MEDIA_AUD;


  		




  826
  
  
    
CREATE CACHED TABLE PUBLIC.COLLECTION_ORIGINALSOURCEBASE(


  		




  827
  
  
    
    COLLECTION_ID INTEGER NOT NULL,


  		




  828
  
  
    
    SOURCES_ID INTEGER NOT NULL


  		




  829
  
  
    
);


  		




  830
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_ORIGINALSOURCEBASE;


  		




  831
  
  
    
CREATE CACHED TABLE PUBLIC.COLLECTION_ORIGINALSOURCEBASE_AUD(


  		




  832
  
  
    
    REV INTEGER NOT NULL,


  		




  833
  
  
    
    COLLECTION_ID INTEGER NOT NULL,


  		




  834
  
  
    
    SOURCES_ID INTEGER NOT NULL,


  		




  835
  
  
    
    REVTYPE TINYINT


  		




  836
  
  
    
);


  		




  837
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_ORIGINALSOURCEBASE_AUD;


  		




  838
  
  
    
CREATE CACHED TABLE PUBLIC.COLLECTION_RIGHTSINFO(


  		




  839
  
  
    
    COLLECTION_ID INTEGER NOT NULL,


  		




  840
  
  
    
    RIGHTS_ID INTEGER NOT NULL


  		




  841
  
  
    
);


  		




  842
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_RIGHTSINFO;


  		




  843
  
  
    
CREATE CACHED TABLE PUBLIC.COLLECTION_RIGHTSINFO_AUD(


  		




  844
  
  
    
    REV INTEGER NOT NULL,


  		




  845
  
  
    
    COLLECTION_ID INTEGER NOT NULL,


  		




  846
  
  
    
    RIGHTS_ID INTEGER NOT NULL,


  		




  847
  
  
    
    REVTYPE TINYINT


  		




  848
  
  
    
);


  		




  849
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_RIGHTSINFO_AUD;


  		




  850
  
  
    
CREATE CACHED TABLE PUBLIC.CREDIT(


  		




  851
  
  
    
    ID INTEGER NOT NULL,


  		




  852
  
  
    
    CREATED TIMESTAMP,


  		




  853
  
  
    
    UUID VARCHAR(36),


  		




  854
  
  
    
    UPDATED TIMESTAMP,


  		




  855
  
  
    
    TEXT CLOB,


  		




  856
  
  
    
    ABBREVIATEDTEXT VARCHAR(255),


  		




  857
  
  
    
    CREATEDBY_ID INTEGER,


  		




  858
  
  
    
    UPDATEDBY_ID INTEGER,


  		




  859
  
  
    
    LANGUAGE_ID INTEGER,


  		




  860
  
  
    
    AGENT_ID INTEGER


  		




  861
  
  
    
);


  		




  862
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CREDIT;


  		




  863
  
  
    
CREATE CACHED TABLE PUBLIC.CREDIT_AUD(


  		




  864
  
  
    
    ID INTEGER NOT NULL,


  		




  865
  
  
    
    REV INTEGER NOT NULL,


  		




  866
  
  
    
    REVTYPE TINYINT,


  		




  867
  
  
    
    CREATED TIMESTAMP,


  		




  868
  
  
    
    UUID VARCHAR(36),


  		




  869
  
  
    
    UPDATED TIMESTAMP,


  		




  870
  
  
    
    TEXT CLOB,


  		




  871
  
  
    
    ABBREVIATEDTEXT VARCHAR(255),


  		




  872
  
  
    
    CREATEDBY_ID INTEGER,


  		




  873
  
  
    
    UPDATEDBY_ID INTEGER,


  		




  874
  
  
    
    LANGUAGE_ID INTEGER,


  		




  875
  
  
    
    AGENT_ID INTEGER


  		




  876
  
  
    
);


  		




  877
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CREDIT_AUD;


  		




  878
  
  
    
CREATE CACHED TABLE PUBLIC.CREDIT_ANNOTATION(


  		




  879
  
  
    
    CREDIT_ID INTEGER NOT NULL,


  		




  880
  
  
    
    ANNOTATIONS_ID INTEGER NOT NULL


  		




  881
  
  
    
);


  		




  882
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CREDIT_ANNOTATION;


  		




  883
  
  
    
CREATE CACHED TABLE PUBLIC.CREDIT_ANNOTATION_AUD(


  		




  884
  
  
    
    REV INTEGER NOT NULL,


  		




  885
  
  
    
    CREDIT_ID INTEGER NOT NULL,


  		




  886
  
  
    
    ANNOTATIONS_ID INTEGER NOT NULL,


  		




  887
  
  
    
    REVTYPE TINYINT


  		




  888
  
  
    
);


  		




  889
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CREDIT_ANNOTATION_AUD;


  		




  890
  
  
    
CREATE CACHED TABLE PUBLIC.CREDIT_MARKER(


  		




  891
  
  
    
    CREDIT_ID INTEGER NOT NULL,


  		




  892
  
  
    
    MARKERS_ID INTEGER NOT NULL


  		




  893
  
  
    
);


  		




  894
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CREDIT_MARKER;


  		




  895
  
  
    
CREATE CACHED TABLE PUBLIC.CREDIT_MARKER_AUD(


  		




  896
  
  
    
    REV INTEGER NOT NULL,


  		




  897
  
  
    
    CREDIT_ID INTEGER NOT NULL,


  		




  898
  
  
    
    MARKERS_ID INTEGER NOT NULL,


  		




  899
  
  
    
    REVTYPE TINYINT


  		




  900
  
  
    
);


  		




  901
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CREDIT_MARKER_AUD;


  		




  902
  
  
    
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE(


  		




  903
  
  
    
    DTYPE VARCHAR(31) NOT NULL,


  		




  904
  
  
    
    ID INTEGER NOT NULL,


  		




  905
  
  
    
    CREATED TIMESTAMP,


  		




  906
  
  
    
    UUID VARCHAR(36),


  		




  907
  
  
    
    UPDATED TIMESTAMP,


  		




  908
  
  
    
    TERMTYPE VARCHAR(4),


  		




  909
  
  
    
    IDINVOCABULARY VARCHAR(255),


  		




  910
  
  
    
    LSID_AUTHORITY VARCHAR(255),


  		




  911
  
  
    
    LSID_LSID VARCHAR(255),


  		




  912
  
  
    
    LSID_NAMESPACE VARCHAR(255),


  		




  913
  
  
    
    LSID_OBJECT VARCHAR(255),


  		




  914
  
  
    
    LSID_REVISION VARCHAR(255),


  		




  915
  
  
    
    PROTECTEDTITLECACHE BOOLEAN NOT NULL,


  		




  916
  
  
    
    TITLECACHE VARCHAR(255),


  		




  917
  
  
    
    URI CLOB,


  		




  918
  
  
    
    ISO639_1 VARCHAR(2),


  		




  919
  
  
    
    RANKCLASS VARCHAR(4) NOT NULL,


  		




  920
  
  
    
    ISTECHNICAL BOOLEAN,


  		




  921
  
  
    
    ABSENCETERM BOOLEAN NOT NULL,


  		




  922
  
  
    
    ORDERINDEX INTEGER,


  		




  923
  
  
    
    SYMMETRICAL BOOLEAN,


  		




  924
  
  
    
    TRANSITIVE BOOLEAN,


  		




  925
  
  
    
    DEFAULTCOLOR VARCHAR(255),


  		




  926
  
  
    
    SUPPORTSCATEGORICALDATA BOOLEAN,


  		




  927
  
  
    
    SUPPORTSCOMMONTAXONNAME BOOLEAN,


  		




  928
  
  
    
    SUPPORTSDISTRIBUTION BOOLEAN,


  		




  929
  
  
    
    SUPPORTSINDIVIDUALASSOCIATION BOOLEAN,


  		




  930
  
  
    
    SUPPORTSQUANTITATIVEDATA BOOLEAN,


  		




  931
  
  
    
    SUPPORTSTAXONINTERACTION BOOLEAN,


  		




  932
  
  
    
    SUPPORTSTEXTDATA BOOLEAN,


  		




  933
  
  
    
    POINTAPPROXIMATION_ERRORRADIUS INTEGER,


  		




  934
  
  
    
    POINTAPPROXIMATION_LATITUDE DOUBLE,


  		




  935
  
  
    
    POINTAPPROXIMATION_LONGITUDE DOUBLE,


  		




  936
  
  
    
    VALIDPERIOD_END VARCHAR(255),


  		




  937
  
  
    
    VALIDPERIOD_FREETEXT VARCHAR(255),


  		




  938
  
  
    
    VALIDPERIOD_START VARCHAR(255),


  		




  939
  
  
    
    ISO3166_A2 VARCHAR(2),


  		




  940
  
  
    
    CREATEDBY_ID INTEGER,


  		




  941
  
  
    
    UPDATEDBY_ID INTEGER,


  		




  942
  
  
    
    KINDOF_ID INTEGER,


  		




  943
  
  
    
    PARTOF_ID INTEGER,


  		




  944
  
  
    
    VOCABULARY_ID INTEGER,


  		




  945
  
  
    
    LEVEL_ID INTEGER,


  		




  946
  
  
    
    POINTAPPROXIMATION_REFERENCESYSTEM_ID INTEGER,


  		




  947
  
  
    
    SHAPE_ID INTEGER,


  		




  948
  
  
    
    TYPE_ID INTEGER


  		




  949
  
  
    
);


  		




  950
  
  
    
-- 2084 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE;


  		




  951
  
  
    
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_AUD(


  		




  952
  
  
    
    DTYPE VARCHAR(31) NOT NULL,


  		




  953
  
  
    
    ID INTEGER NOT NULL,


  		




  954
  
  
    
    REV INTEGER NOT NULL,


  		




  955
  
  
    
    REVTYPE TINYINT,


  		




  956
  
  
    
    CREATED TIMESTAMP,


  		




  957
  
  
    
    UUID VARCHAR(36),


  		




  958
  
  
    
    UPDATED TIMESTAMP,


  		




  959
  
  
    
    TERMTYPE VARCHAR(4),


  		




  960
  
  
    
    IDINVOCABULARY VARCHAR(255),


  		




  961
  
  
    
    LSID_AUTHORITY VARCHAR(255),


  		




  962
  
  
    
    LSID_LSID VARCHAR(255),


  		




  963
  
  
    
    LSID_NAMESPACE VARCHAR(255),


  		




  964
  
  
    
    LSID_OBJECT VARCHAR(255),


  		




  965
  
  
    
    LSID_REVISION VARCHAR(255),


  		




  966
  
  
    
    PROTECTEDTITLECACHE BOOLEAN,


  		




  967
  
  
    
    TITLECACHE VARCHAR(255),


  		




  968
  
  
    
    URI CLOB,


  		




  969
  
  
    
    CREATEDBY_ID INTEGER,


  		




  970
  
  
    
    UPDATEDBY_ID INTEGER,


  		




  971
  
  
    
    KINDOF_ID INTEGER,


  		




  972
  
  
    
    PARTOF_ID INTEGER,


  		




  973
  
  
    
    VOCABULARY_ID INTEGER,


  		




  974
  
  
    
    ORDERINDEX INTEGER,


  		




  975
  
  
    
    ISO639_1 VARCHAR(2),


  		




  976
  
  
    
    RANKCLASS VARCHAR(4) NOT NULL,


  		




  977
  
  
    
    SUPPORTSCATEGORICALDATA BOOLEAN,


  		




  978
  
  
    
    SUPPORTSCOMMONTAXONNAME BOOLEAN,


  		




  979
  
  
    
    SUPPORTSDISTRIBUTION BOOLEAN,


  		




  980
  
  
    
    SUPPORTSINDIVIDUALASSOCIATION BOOLEAN,


  		




  981
  
  
    
    SUPPORTSQUANTITATIVEDATA BOOLEAN,


  		




  982
  
  
    
    SUPPORTSTAXONINTERACTION BOOLEAN,


  		




  983
  
  
    
    SUPPORTSTEXTDATA BOOLEAN,


  		




  984
  
  
    
    ISTECHNICAL BOOLEAN,


  		




  985
  
  
    
    ABSENCETERM BOOLEAN NOT NULL,


  		




  986
  
  
    
    DEFAULTCOLOR VARCHAR(255),


  		




  987
  
  
    
    POINTAPPROXIMATION_ERRORRADIUS INTEGER,


  		




  988
  
  
    
    POINTAPPROXIMATION_LATITUDE DOUBLE,


  		




  989
  
  
    
    POINTAPPROXIMATION_LONGITUDE DOUBLE,


  		




  990
  
  
    
    VALIDPERIOD_END VARCHAR(255),


  		




  991
  
  
    
    VALIDPERIOD_FREETEXT VARCHAR(255),


  		




  992
  
  
    
    VALIDPERIOD_START VARCHAR(255),


  		




  993
  
  
    
    LEVEL_ID INTEGER,


  		




  994
  
  
    
    POINTAPPROXIMATION_REFERENCESYSTEM_ID INTEGER,


  		




  995
  
  
    
    SHAPE_ID INTEGER,


  		




  996
  
  
    
    TYPE_ID INTEGER,


  		




  997
  
  
    
    ISO3166_A2 VARCHAR(2),


  		




  998
  
  
    
    SYMMETRICAL BOOLEAN,


  		




  999
  
  
    
    TRANSITIVE BOOLEAN


  		




  1000
  
  
    
);


  		




  1001
  
  
    
-- 2084 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_AUD;


  		




  1002
  
  
    
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_ANNOTATION(


  		




  1003
  
  
    
    DEFINEDTERMBASE_ID INTEGER NOT NULL,


  		




  1004
  
  
    
    ANNOTATIONS_ID INTEGER NOT NULL


  		




  1005
  
  
    
);


  		




  1006
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_ANNOTATION;


  		




  1007
  
  
    
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_ANNOTATION_AUD(


  		




  1008
  
  
    
    REV INTEGER NOT NULL,


  		




  1009
  
  
    
    DEFINEDTERMBASE_ID INTEGER NOT NULL,


  		




  1010
  
  
    
    ANNOTATIONS_ID INTEGER NOT NULL,


  		




  1011
  
  
    
    REVTYPE TINYINT


  		




  1012
  
  
    
);


  		




  1013
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_ANNOTATION_AUD;


  		




  1014
  
  
    
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_CONTINENT(


  		




  1015
  
  
    
    DEFINEDTERMBASE_ID INTEGER NOT NULL,


  		




  1016
  
  
    
    CONTINENTS_ID INTEGER NOT NULL


  		




  1017
  
  
    
);


  		




  1018
  
  
    
-- 242 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_CONTINENT;


  		




  1019
  
  
    
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_CONTINENT_AUD(


  		




  1020
  
  
    
    REV INTEGER NOT NULL,


  		




  1021
  
  
    
    DEFINEDTERMBASE_ID INTEGER NOT NULL,


  		




  1022
  
  
    
    CONTINENTS_ID INTEGER NOT NULL,


  		




  1023
  
  
    
    REVTYPE TINYINT


  		




  1024
  
  
    
);


  		




  1025
  
  
    
-- 242 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_CONTINENT_AUD;


  		




  1026
  
  
    
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_CREDIT(


  		




  1027
  
  
    
    DEFINEDTERMBASE_ID INTEGER NOT NULL,


  		




  1028
  
  
    
    CREDITS_ID INTEGER NOT NULL,


  		




  1029
  
  
    
    SORTINDEX INTEGER NOT NULL


  		




  1030
  
  
    
);


  		




  1031
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_CREDIT;


  		




  1032
  
  
    
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_CREDIT_AUD(


  		




  1033
  
  
    
    REV INTEGER NOT NULL,


  		




  1034
  
  
    
    DEFINEDTERMBASE_ID INTEGER NOT NULL,


  		




  1035
  
  
    
    CREDITS_ID INTEGER NOT NULL,


  		




  1036
  
  
    
    SORTINDEX INTEGER NOT NULL,


  		




  1037
  
  
    
    REVTYPE TINYINT


  		




  1038
  
  
    
);


  		




  1039
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_CREDIT_AUD;


  		




  1040
  
  
    
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_EXTENSION(


  		




  1041
  
  
    
    DEFINEDTERMBASE_ID INTEGER NOT NULL,


  		




  1042
  
  
    
    EXTENSIONS_ID INTEGER NOT NULL


  		




  1043
  
  
    
);


  		




  1044
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_EXTENSION;


  		




  1045
  
  
    
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_EXTENSION_AUD(


  		




  1046
  
  
    
    REV INTEGER NOT NULL,


  		




  1047
  
  
    
    DEFINEDTERMBASE_ID INTEGER NOT NULL,


  		




  1048
  
  
    
    EXTENSIONS_ID INTEGER NOT NULL,


  		




  1049
  
  
    
    REVTYPE TINYINT


  		




  1050
  
  
    
);


  		




  1051
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_EXTENSION_AUD;


  		




  1052
  
  
    
                                                                                                     


  		




  1053
  
  
    
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_IDENTIFIER(


  		




  1054
  
  
    
    DEFINEDTERMBASE_ID INTEGER NOT NULL,


  		




  1055
  
  
    
    IDENTIFIERS_ID INTEGER NOT NULL,


  		




  1056
  
  
    
    SORTINDEX INTEGER NOT NULL


  		




  1057
  
  
    
);


  		




  1058
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_IDENTIFIER;


  		




  1059
  
  
    
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_IDENTIFIER_AUD(


  		




  1060
  
  
    
    REV INTEGER NOT NULL,


  		




  1061
  
  
    
    DEFINEDTERMBASE_ID INTEGER NOT NULL,


  		




  1062
  
  
    
    IDENTIFIERS_ID INTEGER NOT NULL,


  		




  1063
  
  
    
    SORTINDEX INTEGER NOT NULL,


  		




  1064
  
  
    
    REVTYPE TINYINT


  		




  1065
  
  
    
);


  		




  1066
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_IDENTIFIER_AUD;


  		




  1067
  
  
    

  		




  1068
  
  
    
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_MARKER(


  		




  1069
  
  
    
    DEFINEDTERMBASE_ID INTEGER NOT NULL,


  		




  1070
  
  
    
    MARKERS_ID INTEGER NOT NULL


  		




  1071
  
  
    
);


  		




  1072
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_MARKER;


  		




  1073
  
  
    
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_MARKER_AUD(


  		




  1074
  
  
    
    REV INTEGER NOT NULL,


  		




  1075
  
  
    
    DEFINEDTERMBASE_ID INTEGER NOT NULL,


  		




  1076
  
  
    
    MARKERS_ID INTEGER NOT NULL,


  		




  1077
  
  
    
    REVTYPE TINYINT


  		




  1078
  
  
    
);


  		




  1079
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_MARKER_AUD;


  		




  1080
  
  
    
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_MEASUREMENTUNIT(


  		




  1081
  
  
    
    DEFINEDTERMBASE_ID INTEGER NOT NULL,


  		




  1082
  
  
    
    RECOMMENDEDMEASUREMENTUNITS_ID INTEGER NOT NULL


  		




  1083
  
  
    
);


  		




  1084
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_MEASUREMENTUNIT;


  		




  1085
  
  
    
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_MEASUREMENTUNIT_AUD(


  		




  1086
  
  
    
    REV INTEGER NOT NULL,


  		




  1087
  
  
    
    DEFINEDTERMBASE_ID INTEGER NOT NULL,


  		




  1088
  
  
    
    RECOMMENDEDMEASUREMENTUNITS_ID INTEGER NOT NULL,


  		




  1089
  
  
    
    REVTYPE TINYINT


  		




  1090
  
  
    
);


  		




  1091
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_MEASUREMENTUNIT_AUD;


  		




  1092
  
  
    
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_MEDIA(


  		




  1093
  
  
    
    DEFINEDTERMBASE_ID INTEGER NOT NULL,


  		




  1094
  
  
    
    MEDIA_ID INTEGER NOT NULL


  		




  1095
  
  
    
);


  		




  1096
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_MEDIA;


  		




  1097
  
  
    
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_MEDIA_AUD(


  		




  1098
  
  
    
    REV INTEGER NOT NULL,


  		




  1099
  
  
    
    DEFINEDTERMBASE_ID INTEGER NOT NULL,


  		




  1100
  
  
    
    MEDIA_ID INTEGER NOT NULL,


  		




  1101
  
  
    
    REVTYPE TINYINT


  		




  1102
  
  
    
);


  		




  1103
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_MEDIA_AUD;


  		




  1104
  
  
    
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_ORIGINALSOURCEBASE(


  		




  1105
  
  
    
    DEFINEDTERMBASE_ID INTEGER NOT NULL,


  		




  1106
  
  
    
    SOURCES_ID INTEGER NOT NULL


  		




  1107
  
  
    
);


  		




  1108
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_ORIGINALSOURCEBASE;


  		




  1109
  
  
    
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_ORIGINALSOURCEBASE_AUD(


  		




  1110
  
  
    
    REV INTEGER NOT NULL,


  		




  1111
  
  
    
    DEFINEDTERMBASE_ID INTEGER NOT NULL,


  		




  1112
  
  
    
    SOURCES_ID INTEGER NOT NULL,


  		




  1113
  
  
    
    REVTYPE TINYINT


  		




  1114
  
  
    
);


  		




  1115
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_ORIGINALSOURCEBASE_AUD;


  		




  1116
  
  
    
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_RECOMMENDEDMODIFIERENUMERATION(


  		




  1117
  
  
    
    DEFINEDTERMBASE_ID INTEGER NOT NULL,


  		




  1118
  
  
    
    RECOMMENDEDMODIFIERENUMERATION_ID INTEGER NOT NULL


  		




  1119
  
  
    
);


  		




  1120
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_RECOMMENDEDMODIFIERENUMERATION;


  		




  1121
  
  
    
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_RECOMMENDEDMODIFIERENUMERATION_AUD(


  		




  1122
  
  
    
    REV INTEGER NOT NULL,


  		




  1123
  
  
    
    DEFINEDTERMBASE_ID INTEGER NOT NULL,


  		




  1124
  
  
    
    RECOMMENDEDMODIFIERENUMERATION_ID INTEGER NOT NULL,


  		




  1125
  
  
    
    REVTYPE TINYINT


  		




  1126
  
  
    
);


  		




  1127
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_RECOMMENDEDMODIFIERENUMERATION_AUD;


  		




  1128
  
  
    
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_REPRESENTATION(


  		




  1129
  
  
    
    DEFINEDTERMBASE_ID INTEGER NOT NULL,


  		




  1130
  
  
    
    REPRESENTATIONS_ID INTEGER NOT NULL


  		




  1131
  
  
    
);


  		




  1132
  
  
    
-- 2084 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_REPRESENTATION;


  		




  1133
  
  
    
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_REPRESENTATION_AUD(


  		




  1134
  
  
    
    REV INTEGER NOT NULL,


  		




  1135
  
  
    
    DEFINEDTERMBASE_ID INTEGER NOT NULL,


  		




  1136
  
  
    
    REPRESENTATIONS_ID INTEGER NOT NULL,


  		




  1137
  
  
    
    REVTYPE TINYINT


  		




  1138
  
  
    
);


  		




  1139
  
  
    
-- 2084 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_REPRESENTATION_AUD;


  		




  1140
  
  
    
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_RIGHTSINFO(


  		




  1141
  
  
    
    DEFINEDTERMBASE_ID INTEGER NOT NULL,


  		




  1142
  
  
    
    RIGHTS_ID INTEGER NOT NULL


  		




  1143
  
  
    
);


  		




  1144
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_RIGHTSINFO;


  		




  1145
  
  
    
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_RIGHTSINFO_AUD(


  		




  1146
  
  
    
    REV INTEGER NOT NULL,


  		




  1147
  
  
    
    DEFINEDTERMBASE_ID INTEGER NOT NULL,


  		




  1148
  
  
    
    RIGHTS_ID INTEGER NOT NULL,


  		




  1149
  
  
    
    REVTYPE TINYINT


  		




  1150
  
  
    
);


  		




  1151
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_RIGHTSINFO_AUD;


  		




  1152
  
  
    
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_STATISTICALMEASURE(


  		




  1153
  
  
    
    DEFINEDTERMBASE_ID INTEGER NOT NULL,


  		




  1154
  
  
    
    RECOMMENDEDSTATISTICALMEASURES_ID INTEGER NOT NULL


  		




  1155
  
  
    
);


  		




  1156
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_STATISTICALMEASURE;


  		




  1157
  
  
    
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_STATISTICALMEASURE_AUD(


  		




  1158
  
  
    
    REV INTEGER NOT NULL,


  		




  1159
  
  
    
    DEFINEDTERMBASE_ID INTEGER NOT NULL,


  		




  1160
  
  
    
    RECOMMENDEDSTATISTICALMEASURES_ID INTEGER NOT NULL,


  		




  1161
  
  
    
    REVTYPE TINYINT


  		




  1162
  
  
    
);


  		




  1163
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_STATISTICALMEASURE_AUD;


  		




  1164
  
  
    
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_SUPPORTEDCATEGORICALENUMERATION(


  		




  1165
  
  
    
    DEFINEDTERMBASE_ID INTEGER NOT NULL,


  		




  1166
  
  
    
    SUPPORTEDCATEGORICALENUMERATIONS_ID INTEGER NOT NULL


  		




  1167
  
  
    
);


  		




  1168
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_SUPPORTEDCATEGORICALENUMERATION;


  		




  1169
  
  
    
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_SUPPORTEDCATEGORICALENUMERATION_AUD(


  		




  1170
  
  
    
    REV INTEGER NOT NULL,


  		




  1171
  
  
    
    DEFINEDTERMBASE_ID INTEGER NOT NULL,


  		




  1172
  
  
    
    SUPPORTEDCATEGORICALENUMERATIONS_ID INTEGER NOT NULL,


  		




  1173
  
  
    
    REVTYPE TINYINT


  		




  1174
  
  
    
);


  		




  1175
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_SUPPORTEDCATEGORICALENUMERATION_AUD;


  		




  1176
  
  
    
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_COUNTRY(


  		




  1177
  
  
    
    DEFINEDTERMBASE_ID INTEGER NOT NULL,


  		




  1178
  
  
    
    COUNTRIES_ID INTEGER NOT NULL


  		




  1179
  
  
    
);


  		




  1180
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_COUNTRY;


  		




  1181
  
  
    
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_COUNTRY_AUD(


  		




  1182
  
  
    
    REV INTEGER NOT NULL,


  		




  1183
  
  
    
    DEFINEDTERMBASE_ID INTEGER NOT NULL,


  		




  1184
  
  
    
    COUNTRIES_ID INTEGER NOT NULL,


  		




  1185
  
  
    
    REVTYPE TINYINT


  		




  1186
  
  
    
);


  		




  1187
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_COUNTRY_AUD;


  		




  1188
  
  
    
CREATE CACHED TABLE PUBLIC.DERIVATIONEVENT(


  		




  1189
  
  
    
    ID INTEGER NOT NULL,


  		




  1190
  
  
    
    CREATED TIMESTAMP,


  		




  1191
  
  
    
    UUID VARCHAR(36),


  		




  1192
  
  
    
    UPDATED TIMESTAMP,


  		




  1193
  
  
    
    DESCRIPTION VARCHAR(255),


  		




  1194
  
  
    
    TIMEPERIOD_END VARCHAR(255),


  		




  1195
  
  
    
    TIMEPERIOD_FREETEXT VARCHAR(255),


  		




  1196
  
  
    
    TIMEPERIOD_START VARCHAR(255),


  		




  1197
  
  
    
    CREATEDBY_ID INTEGER,


  		




  1198
  
  
    
    UPDATEDBY_ID INTEGER,


  		




  1199
  
  
    
    ACTOR_ID INTEGER,


  		




  1200
  
  
    
    INSTITUTION_ID INTEGER,


  		




  1201
  
  
    
	TYPE_ID INTEGER


  		




  1202
  
  
    
);


  		




  1203
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DERIVATIONEVENT;


  		




  1204
  
  
    
CREATE CACHED TABLE PUBLIC.DERIVATIONEVENT_AUD(


  		




  1205
  
  
    
    ID INTEGER NOT NULL,


  		




  1206
  
  
    
    REV INTEGER NOT NULL,


  		




  1207
  
  
    
    REVTYPE TINYINT,


  		




  1208
  
  
    
    CREATED TIMESTAMP,


  		




  1209
  
  
    
    UUID VARCHAR(36),


  		




  1210
  
  
    
    UPDATED TIMESTAMP,


  		




  1211
  
  
    
    DESCRIPTION VARCHAR(255),


  		




  1212
  
  
    
    TIMEPERIOD_END VARCHAR(255),


  		




  1213
  
  
    
    TIMEPERIOD_FREETEXT VARCHAR(255),


  		




  1214
  
  
    
    TIMEPERIOD_START VARCHAR(255),


  		




  1215
  
  
    
    CREATEDBY_ID INTEGER,


  		




  1216
  
  
    
    UPDATEDBY_ID INTEGER,


  		




  1217
  
  
    
    ACTOR_ID INTEGER,


  		




  1218
  
  
    
    INSTITUTION_ID INTEGER,


  		




  1219
  
  
    
	TYPE_ID INTEGER


  		




  1220
  
  
    
);


  		




  1221
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DERIVATIONEVENT_AUD;


  		




  1222
  
  
    
CREATE CACHED TABLE PUBLIC.DERIVATIONEVENT_ANNOTATION(


  		




  1223
  
  
    
    DERIVATIONEVENT_ID INTEGER NOT NULL,


  		




  1224
  
  
    
    ANNOTATIONS_ID INTEGER NOT NULL


  		




  1225
  
  
    
);


  		




  1226
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DERIVATIONEVENT_ANNOTATION;


  		




  1227
  
  
    
CREATE CACHED TABLE PUBLIC.DERIVATIONEVENT_ANNOTATION_AUD(


  		




  1228
  
  
    
    REV INTEGER NOT NULL,


  		




  1229
  
  
    
    DERIVATIONEVENT_ID INTEGER NOT NULL,


  		




  1230
  
  
    
    ANNOTATIONS_ID INTEGER NOT NULL,


  		




  1231
  
  
    
    REVTYPE TINYINT


  		




  1232
  
  
    
);


  		




  1233
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DERIVATIONEVENT_ANNOTATION_AUD;


  		




  1234
  
  
    
CREATE CACHED TABLE PUBLIC.DERIVATIONEVENT_MARKER(


  		




  1235
  
  
    
    DERIVATIONEVENT_ID INTEGER NOT NULL,


  		




  1236
  
  
    
    MARKERS_ID INTEGER NOT NULL


  		




  1237
  
  
    
);


  		




  1238
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DERIVATIONEVENT_MARKER;


  		




  1239
  
  
    
CREATE CACHED TABLE PUBLIC.DERIVATIONEVENT_MARKER_AUD(


  		




  1240
  
  
    
    REV INTEGER NOT NULL,


  		




  1241
  
  
    
    DERIVATIONEVENT_ID INTEGER NOT NULL,


  		




  1242
  
  
    
    MARKERS_ID INTEGER NOT NULL,


  		




  1243
  
  
    
    REVTYPE TINYINT


  		




  1244
  
  
    
);


  		




  1245
  
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DERIVATIONEVENT_MARKER_AUD;


  		




  1246
  
  
    
CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE(


  		




  1247
  
  
    
    DTYPE VARCHAR(31) NOT NULL,


  		




  1248
  
  
    
    ID INTEGER NOT NULL,


  		








... This diff was truncated because it exceeds the maximum size that can be displayed.



Also available in:  Unified diff