Revision 48139
Added by Alessia Bardi almost 7 years ago
pangaea_preparetable.sql | ||
---|---|---|
1 | 1 |
DROP TABLE IF EXISTS pangaea_temp_journals; |
2 | 2 |
CREATE TABLE IF NOT EXISTS pangaea_temp_journals ( |
3 |
_dnet_resource_identifier_ character varying(2048) DEFAULT 'temp_'||md5(clock_timestamp()::text)||'_'||md5(random()::text),
|
|
4 |
id character varying(255) PRIMARY KEY,
|
|
5 |
issn character varying(255),
|
|
6 |
oa_source_id character varying(255) references datasources(id)
|
|
3 |
_dnet_resource_identifier_ CHARACTER VARYING(2048) DEFAULT 'temp_' || md5(clock_timestamp() :: TEXT) || '_' || md5(random() :: TEXT),
|
|
4 |
id CHARACTER VARYING(255) PRIMARY KEY,
|
|
5 |
issn CHARACTER VARYING(255),
|
|
6 |
oa_source_id CHARACTER VARYING(255) REFERENCES datasources (id)
|
|
7 | 7 |
); |
Also available in: Unified diff
integrated (hopefully) all required changes from dnet40