Project

General

Profile

« Previous | Next » 

Revision 48139

Added by Alessia Bardi almost 7 years ago

integrated (hopefully) all required changes from dnet40

View differences:

dataciteSets_prepareTables.sql
1 1 
DROP TABLE IF EXISTS datacite_temp_sets;
2 2 
CREATE TABLE IF NOT EXISTS datacite_temp_sets (
3 
	_dnet_resource_identifier_ character varying(2048) DEFAULT 'temp_'||md5(clock_timestamp()::text)||'_'||md5(random()::text),
4 
	id                         character varying(255) PRIMARY KEY,
5 
	setname                    character varying(255),
6 
	setname_cleaned            character varying(255),
7 
	setspec                    character varying(255),
8 
	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 
	setname                    CHARACTER VARYING(255),
6 
	setname_cleaned            CHARACTER VARYING(255),
7 
	setspec                    CHARACTER VARYING(255),
8 
	oa_source_id               CHARACTER VARYING(255) REFERENCES datasources (id)
9 9 
);
10 10 

  		




  11
  11
  
    
DROP TABLE IF EXISTS datacite_temp_datarepos;


  		




  12
  12
  
    

  		




  13
  13
  
    
CREATE TABLE IF NOT EXISTS datacite_temp_datarepos (


  		




  14
  
  
    
	_dnet_resource_identifier_ character varying(2048) DEFAULT 'temp_'||md5(clock_timestamp()::text)||'_'||md5(random()::text),


  		




  15
  
  
    
	id                         character varying(255) PRIMARY KEY,


  		




  16
  
  
    
	name                       character varying(512) NOT NULL,


  		




  17
  
  
    
	name_cleaned               character varying(512) NOT NULL,


  		




  18
  
  
    
	class                      character varying(255)


  		




  
  14
  
    
	_dnet_resource_identifier_ CHARACTER VARYING(2048) DEFAULT 'temp_' || md5(clock_timestamp() :: TEXT) || '_' || md5(random() :: TEXT),


  		




  
  15
  
    
	id                         CHARACTER VARYING(255) PRIMARY KEY,


  		




  
  16
  
    
	name                       CHARACTER VARYING(512) NOT NULL,


  		




  
  17
  
    
	name_cleaned               CHARACTER VARYING(512) NOT NULL,


  		




  
  18
  
    
	class                      CHARACTER VARYING(255)


  		




  19
  19
  
    
);


  		




  20
  20
  
    

  		




  21
  21
  
    
--CREATE INDEX datacite_sets__dnet_resource_identifier__idx ON datacite_sets (_dnet_resource_identifier_);


  		




  22
  
  
    
CREATE INDEX datacite_temp_datarepos__dnet_resource_identifier__idx ON datacite_temp_datarepos (_dnet_resource_identifier_);


  		




  
  22
  
    
CREATE INDEX datacite_temp_datarepos__dnet_resource_identifier__idx


  		




  
  23
  
    
	ON datacite_temp_datarepos (_dnet_resource_identifier_);


  		












Also available in:  Unified diff