dnet45/modules/dnet-openaireplus-workflows/trunk/src/main/resources/eu/dnetlib/msro/openaireplus/workflows/repo-hi/dataRepositoryByJournal/sql/pangaea_preparetable.sql @ 48139
1 | 33011 | sandro.lab | DROP TABLE IF EXISTS pangaea_temp_journals; |
---|---|---|---|
2 | CREATE TABLE IF NOT EXISTS pangaea_temp_journals ( |
||
3 | 48139 | alessia.ba | _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 | 33011 | sandro.lab | );
|