Project

General

Profile

Revision 93ad7e54

ID93ad7e545dc77e63b68e434c62c8560a68bb9dfb
Parent 8bbb7d89
Child b45755b5

Added by Andreas Müller almost 2 years ago

fix #8673 Add CdmLinkSource to OriginalSourceBase

View differences:

cdmlib-test/src/main/resources/dbscripts/001-cdm.h2.sql
2307 2307
    REVTYPE TINYINT
2308 2308
);
2309 2309
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.IDENTIFIER_MARKER_AUD;
2310
CREATE CACHED TABLE PUBLIC.INTEXTREFERENCE(
2310
CREATE CACHED TABLE PUBLIC.CDMLINK(
2311
    DTYPE VARCHAR(31) NOT NULL,
2311 2312
    ID INTEGER NOT NULL,
2312 2313
    UUID VARCHAR(36),
2313 2314
    CREATED TIMESTAMP,
......
2325 2326
	SOURCE_ID INT,
2326 2327
  	TAXON_ID INT,
2327 2328
  	TAXONNAME_ID INT,
2328
	KEY_ID INT
2329
	KEY_ID INT,
2330
	DESCRIPTION_ID INT
2329 2331
);
2330 2332
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.INTEXTREFERENCE;
2331
CREATE CACHED TABLE PUBLIC.INTEXTREFERENCE_AUD(
2333
CREATE CACHED TABLE PUBLIC.CDMLINK_AUD(
2334
    DTYPE VARCHAR(31) NOT NULL,
2332 2335
    ID INTEGER NOT NULL,
2333 2336
    REV INTEGER NOT NULL,
2334 2337
    REVTYPE TINYINT,
......
2348 2351
	SOURCE_ID INT,
2349 2352
  	TAXON_ID INT,
2350 2353
  	TAXONNAME_ID INT,
2351
	KEY_ID INT
2354
	KEY_ID INT,
2355
	DESCRIPTION_ID INT
2352 2356
);
2353 2357
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.INTEXTREFERENCE_AUD;
2354 2358
CREATE CACHED TABLE PUBLIC.INSTITUTIONALMEMBERSHIP(
......
3092 3096
    CREATEDBY_ID INTEGER,
3093 3097
    UPDATEDBY_ID INTEGER,
3094 3098
    CITATION_ID INTEGER,
3095
    NAMEUSEDINSOURCE_ID INTEGER
3099
    NAMEUSEDINSOURCE_ID INTEGER,
3100
	CDMSOURCE_ID INTEGER
3096 3101
);
3097 3102
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ORIGINALSOURCEBASE;
3098 3103
CREATE CACHED TABLE PUBLIC.ORIGINALSOURCEBASE_AUD(
......
3111 3116
    CREATEDBY_ID INTEGER,
3112 3117
    UPDATEDBY_ID INTEGER,
3113 3118
    CITATION_ID INTEGER,
3114
    NAMEUSEDINSOURCE_ID INTEGER
3119
    NAMEUSEDINSOURCE_ID INTEGER,
3120
	CDMSOURCE_ID INTEGER
3115 3121
);
3116 3122
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ORIGINALSOURCEBASE_AUD;
3117 3123
CREATE CACHED TABLE PUBLIC.ORIGINALSOURCEBASE_ANNOTATION(

Also available in: Unified diff

Add picture from clipboard (Maximum size: 40 MB)