Revision 034d3d7a
Added by Cherian Mathew over 8 years ago
| src/test/resources/dbscripts/001-cdm.h2.sql | ||
|---|---|---|
| 61 | 61 |
LSID_REVISION VARCHAR(255), |
| 62 | 62 |
PROTECTEDTITLECACHE BOOLEAN NOT NULL, |
| 63 | 63 |
TITLECACHE VARCHAR(255), |
| 64 |
PROTECTEDCOLLECTORTITLECACHE BOOLEAN NOT NULL, |
|
| 65 |
COLLECTORTITLE VARCHAR(255), |
|
| 66 |
PROTECTEDNOMENCLATURALTITLECACHE BOOLEAN, |
|
| 67 |
NOMENCLATURALTITLE VARCHAR(255), |
|
| 64 | 68 |
CODE VARCHAR(255), |
| 65 | 69 |
NAME VARCHAR(255), |
| 66 |
NOMENCLATURALTITLE VARCHAR(255), |
|
| 67 | 70 |
FIRSTNAME VARCHAR(255), |
| 68 | 71 |
LASTNAME VARCHAR(255), |
| 69 | 72 |
LIFESPAN_END VARCHAR(255), |
| ... | ... | |
| 71 | 74 |
LIFESPAN_START VARCHAR(255), |
| 72 | 75 |
PREFIX VARCHAR(255), |
| 73 | 76 |
SUFFIX VARCHAR(255), |
| 74 |
PROTECTEDNOMENCLATURALTITLECACHE BOOLEAN, |
|
| 75 | 77 |
CREATEDBY_ID INTEGER, |
| 76 | 78 |
UPDATEDBY_ID INTEGER, |
| 77 | 79 |
ISPARTOF_ID INTEGER |
| ... | ... | |
| 95 | 97 |
TITLECACHE VARCHAR(255), |
| 96 | 98 |
CREATEDBY_ID INTEGER, |
| 97 | 99 |
UPDATEDBY_ID INTEGER, |
| 100 |
PROTECTEDCOLLECTORTITLECACHE BOOLEAN NOT NULL, |
|
| 101 |
COLLECTORTITLE VARCHAR(255), |
|
| 98 | 102 |
NOMENCLATURALTITLE VARCHAR(255), |
| 99 | 103 |
PROTECTEDNOMENCLATURALTITLECACHE BOOLEAN, |
| 100 | 104 |
FIRSTNAME VARCHAR(255), |
| ... | ... | |
| 1678 | 1682 |
SETOFREFERENCES_ID INTEGER NOT NULL, |
| 1679 | 1683 |
REVTYPE TINYINT |
| 1680 | 1684 |
); |
| 1685 |
|
|
| 1681 | 1686 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DETERMINATIONEVENT_REFERENCE_AUD; |
| 1682 | 1687 |
CREATE CACHED TABLE PUBLIC.DNAQUALITY( |
| 1683 | 1688 |
ID INTEGER NOT NULL, |
| ... | ... | |
| 1713 | 1718 |
QUALITYTERM_ID INTEGER |
| 1714 | 1719 |
); |
| 1715 | 1720 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DNAQUALITY_AUD; |
| 1716 |
CREATE CACHED TABLE PUBLIC.ENTITYVALIDATIONRESULT( |
|
| 1721 |
|
|
| 1722 |
CREATE CACHED TABLE PUBLIC.ENTITYVALIDATION( |
|
| 1717 | 1723 |
ID INTEGER NOT NULL, |
| 1718 | 1724 |
UUID VARCHAR(36), |
| 1719 | 1725 |
CREATED TIMESTAMP, |
| 1720 | 1726 |
VALIDATEDENTITYID INTEGER, |
| 1721 | 1727 |
VALIDATEDENTITYUUID VARCHAR(36), |
| 1722 | 1728 |
VALIDATEDENTITYCLASS VARCHAR(255), |
| 1729 |
VALIDATIONCOUNT INTEGER, |
|
| 1730 |
UPDATED TIMESTAMP, |
|
| 1723 | 1731 |
USERFRIENDLYDESCRIPTION VARCHAR(255), |
| 1724 | 1732 |
USERFRIENDLYTYPENAME VARCHAR(255), |
| 1725 | 1733 |
CREATEDBY_ID INTEGER, |
| 1726 | 1734 |
UPDATEDBY_ID INTEGER, |
| 1727 |
CRUDEVENTTYPE VARCHAR(24) |
|
| 1735 |
CRUDEVENTTYPE VARCHAR(24), |
|
| 1736 |
STATUS VARCHAR(16) |
|
| 1728 | 1737 |
); |
| 1729 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ENTITYVALIDATIONRESULT; |
|
| 1738 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ENTITYVALIDATION; |
|
| 1739 |
|
|
| 1730 | 1740 |
CREATE CACHED TABLE PUBLIC.ENTITYCONSTRAINTVIOLATION( |
| 1731 | 1741 |
ID INTEGER NOT NULL, |
| 1732 | 1742 |
UUID VARCHAR(36), |
| ... | ... | |
| 1737 | 1747 |
SEVERITY VARCHAR(24), |
| 1738 | 1748 |
MESSAGE VARCHAR(255), |
| 1739 | 1749 |
VALIDATOR VARCHAR(255), |
| 1750 |
VALIDATIONGROUP VARCHAR(63), |
|
| 1740 | 1751 |
CREATEDBY_ID INTEGER, |
| 1741 | 1752 |
UPDATEDBY_ID INTEGER, |
| 1742 |
ENTITYVALIDATIONRESULT_ID INTEGER
|
|
| 1753 |
ENTITYVALIDATION_ID INTEGER |
|
| 1743 | 1754 |
); |
| 1744 | 1755 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ENTITYCONSTRAINTVIOLATION; |
| 1756 |
|
|
| 1745 | 1757 |
CREATE CACHED TABLE PUBLIC.EXTENSION( |
| 1746 | 1758 |
ID INTEGER NOT NULL, |
| 1747 | 1759 |
CREATED TIMESTAMP, |
| ... | ... | |
| 2202 | 2214 |
TYPE_ID INTEGER |
| 2203 | 2215 |
); |
| 2204 | 2216 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.IDENTIFIER_AUD; |
| 2217 |
CREATE CACHED TABLE PUBLIC.IDENTIFIER_ANNOTATION( |
|
| 2218 |
IDENTIFIER_ID INTEGER NOT NULL, |
|
| 2219 |
ANNOTATIONS_ID INTEGER NOT NULL |
|
| 2220 |
); |
|
| 2221 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.IDENTIFIER_ANNOTATION; |
|
| 2222 |
CREATE CACHED TABLE PUBLIC.IDENTIFIER_ANNOTATION_AUD( |
|
| 2223 |
REV INTEGER NOT NULL, |
|
| 2224 |
IDENTIFIER_ID INTEGER NOT NULL, |
|
| 2225 |
ANNOTATIONS_ID INTEGER NOT NULL, |
|
| 2226 |
REVTYPE TINYINT |
|
| 2227 |
); |
|
| 2228 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.IDENTIFIER_ANNOTATION_AUD; |
|
| 2229 |
CREATE CACHED TABLE PUBLIC.IDENTIFIER_MARKER( |
|
| 2230 |
IDENTIFIER_ID INTEGER NOT NULL, |
|
| 2231 |
MARKERS_ID INTEGER NOT NULL |
|
| 2232 |
); |
|
| 2233 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.IDENTIFIER_MARKER; |
|
| 2234 |
CREATE CACHED TABLE PUBLIC.IDENTIFIER_MARKER_AUD( |
|
| 2235 |
REV INTEGER NOT NULL, |
|
| 2236 |
IDENTIFIER_ID INTEGER NOT NULL, |
|
| 2237 |
MARKERS_ID INTEGER NOT NULL, |
|
| 2238 |
REVTYPE TINYINT |
|
| 2239 |
); |
|
| 2240 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.IDENTIFIER_MARKER_AUD; |
|
| 2241 |
CREATE CACHED TABLE PUBLIC.INTEXTREFERENCE( |
|
| 2242 |
ID INTEGER NOT NULL, |
|
| 2243 |
UUID VARCHAR(36), |
|
| 2244 |
CREATED TIMESTAMP, |
|
| 2245 |
UPDATED TIMESTAMP, |
|
| 2246 |
CREATEDBY_ID INTEGER, |
|
| 2247 |
UPDATEDBY_ID INTEGER, |
|
| 2248 |
STARTPOS INT, |
|
| 2249 |
ENDPOS INT, |
|
| 2250 |
AGENT_ID INT, |
|
| 2251 |
ANNOTATION_ID INT, |
|
| 2252 |
LANGUAGESTRING_ID INT, |
|
| 2253 |
MEDIA_ID INT, |
|
| 2254 |
OCCURRENCE_ID INT, |
|
| 2255 |
REFERENCE_ID INT, |
|
| 2256 |
TAXON_ID INT, |
|
| 2257 |
TAXONNAME_ID INT |
|
| 2258 |
); |
|
| 2259 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.INTEXTREFERENCE; |
|
| 2260 |
CREATE CACHED TABLE PUBLIC.INTEXTREFERENCE_AUD( |
|
| 2261 |
ID INTEGER NOT NULL, |
|
| 2262 |
REV INTEGER NOT NULL, |
|
| 2263 |
REVTYPE TINYINT, |
|
| 2264 |
UUID VARCHAR(36), |
|
| 2265 |
CREATED TIMESTAMP, |
|
| 2266 |
UPDATED TIMESTAMP, |
|
| 2267 |
CREATEDBY_ID INTEGER, |
|
| 2268 |
UPDATEDBY_ID INTEGER, |
|
| 2269 |
STARTPOS INT, |
|
| 2270 |
ENDPOS INT, |
|
| 2271 |
AGENT_ID INT, |
|
| 2272 |
ANNOTATION_ID INT, |
|
| 2273 |
LANGUAGESTRING_ID INT, |
|
| 2274 |
MEDIA_ID INT, |
|
| 2275 |
OCCURRENCE_ID INT, |
|
| 2276 |
REFERENCE_ID INT, |
|
| 2277 |
TAXON_ID INT, |
|
| 2278 |
TAXONNAME_ID INT |
|
| 2279 |
); |
|
| 2280 |
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.INTEXTREFERENCE_AUD; |
|
| 2281 |
|
|
| 2205 | 2282 |
CREATE CACHED TABLE PUBLIC.INDIVIDUALASSOCIATION_LANGUAGESTRING_AUD( |
| 2206 | 2283 |
REV INTEGER NOT NULL, |
| 2207 | 2284 |
DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL, |
Also available in: Unified diff
testing fixes :