Project

General

Profile

« Previous | Next » 

Revision 48139

Added by Alessia Bardi almost 7 years ago

integrated (hopefully) all required changes from dnet40

View differences:

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