Project

General

Profile

Download (432 Bytes) Statistics
| Revision:

dnet45/modules/dnet-openaireplus-workflows/trunk/src/main/resources/eu/dnetlib/msro/openaireplus/workflows/repo-hi/hostedbyMapJournalIntersection/sql/pangaea_preparetable.sql @ 52330

1 
DROP TABLE IF EXISTS pangaea_temp_journals;
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 dsm_datasources (id)
7 
);
(3-3/3)