1
|
CREATE TABLE IF NOT EXISTS fundingpaths (
|
2
|
_dnet_resource_identifier_ CHARACTER VARYING(2048) DEFAULT 'temp_' || md5(clock_timestamp() :: TEXT) || '_' || md5(random() :: TEXT),
|
3
|
id CHARACTER VARYING(512) PRIMARY KEY,
|
4
|
path TEXT NOT NULL,
|
5
|
funder CHARACTER VARYING(512) REFERENCES organizations (id),
|
6
|
jurisdiction CHARACTER VARYING(16),
|
7
|
description CHARACTER VARYING(512),
|
8
|
optional1 CHARACTER VARYING(255),
|
9
|
optional2 CHARACTER VARYING(255)
|
10
|
);
|
11
|
|
12
|
CREATE TABLE IF NOT EXISTS project_fundingpath (
|
13
|
_dnet_resource_identifier_ CHARACTER VARYING(2048) DEFAULT 'temp_' || md5(clock_timestamp() :: TEXT) || '_' || md5(random() :: TEXT),
|
14
|
funding CHARACTER VARYING(255) NOT NULL REFERENCES fundingpaths (id),
|
15
|
project CHARACTER VARYING(255) NOT NULL REFERENCES projects (id),
|
16
|
startdate DATE,
|
17
|
enddate DATE,
|
18
|
semanticclass CHARACTER VARYING(255) REFERENCES class (code),
|
19
|
semanticscheme CHARACTER VARYING(255) REFERENCES scheme (code),
|
20
|
optional1 CHARACTER VARYING(255),
|
21
|
optional2 CHARACTER VARYING(255),
|
22
|
PRIMARY KEY (funding, project)
|
23
|
);
|
24
|
|
25
|
UPDATE datasources
|
26
|
SET namespaceprefix = 'wt__________'
|
27
|
WHERE id = 'openaire____::wellcometrust';
|