1 |
34996
|
michele.ar
|
CREATE TABLE IF NOT EXISTS fundingpaths (
|
2 |
48139
|
alessia.ba
|
_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 |
34996
|
michele.ar
|
);
|
11 |
|
|
|
12 |
|
|
CREATE TABLE IF NOT EXISTS project_fundingpath (
|
13 |
48139
|
alessia.ba
|
_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 |
34996
|
michele.ar
|
PRIMARY KEY (funding, project)
|
23 |
|
|
);
|
24 |
35175
|
michele.ar
|
|
25 |
48139
|
alessia.ba
|
UPDATE datasources
|
26 |
|
|
SET namespaceprefix = 'wt__________'
|
27 |
|
|
WHERE id = 'openaire____::wellcometrust';
|