| 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';
|