dnet45/modules/dnet-openaireplus-workflows/branches/dismiss_repo_profiles/src/main/resources/eu/dnetlib/msro/openaireplus/workflows/repo-hi/hostedbyMapJournalIntersection/sql/pangaea_preparetable.sql @ 61861
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_services (id) |
7 |
);
|
- « Previous
- 1
- 2
- 3
- Next »