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
|
optional1 character varying(255),
|
8
|
optional2 character varying(255)
|
9
|
);
|
10
|
|
11
|
CREATE TABLE IF NOT EXISTS project_fundingpath (
|
12
|
_dnet_resource_identifier_ character varying(2048) DEFAULT 'temp_'||md5(clock_timestamp()::text)||'_'||md5(random()::text),
|
13
|
funding character varying(255) NOT NULL REFERENCES fundingpaths(id),
|
14
|
project character varying(255) NOT NULL REFERENCES projects(id),
|
15
|
startdate date,
|
16
|
enddate date,
|
17
|
semanticclass character varying(255) REFERENCES class(code),
|
18
|
semanticscheme character varying(255) REFERENCES scheme(code),
|
19
|
optional1 character varying(255),
|
20
|
optional2 character varying(255),
|
21
|
PRIMARY KEY (funding, project)
|
22
|
);
|
23
|
|
24
|
update datasources set namespaceprefix = 'wt__________' where id = 'openaire____::wellcometrust';
|