Project

General

Profile

« Previous | Next » 

Revision 48139

Added by Alessia Bardi almost 7 years ago

integrated (hopefully) all required changes from dnet40

View differences:

patch-fundingpaths.sql
1 1 
CREATE TABLE IF NOT EXISTS fundingpaths (
2 
	_dnet_resource_identifier_ character varying(2048) DEFAULT 'temp_'||md5(clock_timestamp()::text)||'_'||md5(random()::text),
3 
	id                         character varying(512) PRIMARY KEY,
4 
	path                       text NOT NULL,
5 
	funder                     character varying(512) REFERENCES organizations(id),
6 
	jurisdiction               character varying(16),
7 
	description 			   character varying(512),
8 
	optional1                  character varying(255),
9 
	optional2                  character varying(255)
2 
	_dnet_resource_identifier_ CHARACTER VARYING(2048) DEFAULT 'temp_' || md5(clock_timestamp() :: TEXT) || '_' || md5(random() :: TEXT),
3 
	id                         CHARACTER VARYING(512) PRIMARY KEY,
4 
	path                       TEXT NOT NULL,
5 
	funder                     CHARACTER VARYING(512) REFERENCES organizations (id),
6 
	jurisdiction               CHARACTER VARYING(16),
7 
	description                CHARACTER VARYING(512),
8 
	optional1                  CHARACTER VARYING(255),
9 
	optional2                  CHARACTER VARYING(255)
10 10 
);
11 11 

  		




  12
  12
  
    
CREATE TABLE IF NOT EXISTS project_fundingpath (


  		




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


  		




  14
  
  
    
	funding                    character varying(255) NOT NULL REFERENCES fundingpaths(id),


  		




  15
  
  
    
	project                    character varying(255) NOT NULL REFERENCES projects(id),


  		




  16
  
  
    
	startdate                  date,


  		




  17
  
  
    
	enddate                    date,


  		




  18
  
  
    
	semanticclass              character varying(255) REFERENCES class(code),


  		




  19
  
  
    
	semanticscheme             character varying(255) REFERENCES scheme(code),


  		




  20
  
  
    
	optional1                  character varying(255),


  		




  21
  
  
    
	optional2                  character varying(255),


  		




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


  		




  
  14
  
    
	funding                    CHARACTER VARYING(255) NOT NULL REFERENCES fundingpaths (id),


  		




  
  15
  
    
	project                    CHARACTER VARYING(255) NOT NULL REFERENCES projects (id),


  		




  
  16
  
    
	startdate                  DATE,


  		




  
  17
  
    
	enddate                    DATE,


  		




  
  18
  
    
	semanticclass              CHARACTER VARYING(255) REFERENCES class (code),


  		




  
  19
  
    
	semanticscheme             CHARACTER VARYING(255) REFERENCES scheme (code),


  		




  
  20
  
    
	optional1                  CHARACTER VARYING(255),


  		




  
  21
  
    
	optional2                  CHARACTER VARYING(255),


  		




  22
  22
  
    
	PRIMARY KEY (funding, project)


  		




  23
  23
  
    
);


  		




  24
  24
  
    

  		




  25
  
  
    
update datasources set namespaceprefix = 'wt__________' where id = 'openaire____::wellcometrust';


  		




  
  25
  
    
UPDATE datasources


  		




  
  26
  
    
SET namespaceprefix = 'wt__________'


  		




  
  27
  
    
WHERE id = 'openaire____::wellcometrust';


  		












Also available in:  Unified diff