Project

General

Profile

« Previous | Next » 

Revision 39219

Added by Sandro La Bruzzo over 8 years ago

added wf for generation of intersetction with pid

View differences:

DOIResolver.sql
10 10 
	completion_status VARCHAR(50)
11 11 
);
12 12 

  		




  
  13
  
    
CREATE TABLE IF NOT EXISTS pid_tmp(


  		




  
  14
  
    
	 pid   VARCHAR(1000),


  		




  
  15
  
    
	 ds_id  VARCHAR(250) 


  		




  
  16
  
    
);


  		




  
  17
  
    

  		




  13
  18
  
    
CREATE TABLE IF NOT EXISTS dli_object_tmp(


  		




  14
  19
  
    
	dli_identifier varchar(1000),


  		




  15
  20
  
    
	pid VARCHAR(250),


  		




  ......




  25
  30
  
    
CREATE TABLE IF NOT EXISTS dli_datasource (


  		




  26
  31
  
    
	ds_id VARCHAR(250) PRIMARY KEY,


  		




  27
  32
  
    
	name VARCHAR(250) NOT NULL,


  		




  28
  
  
    
	web  VARCHAR(250)


  		




  
  33
  
    
	web  VARCHAR(250), 


  		




  
  34
  
    
	exportable boolean DEFAULT true


  		




  29
  35
  
    
);


  		




  30
  36
  
    

  		




  31
  37
  
    

  		




  ......




  165
  171
  
    
insert into dli_datasource (ds_id,name)  values ('system', 'System Deduction');


  		




  166
  172
  
    
insert into dli_datasource (ds_id,name)  values ('opnres', 'OpenAIRE Resolver');


  		




  167
  173
  
    
insert into dli_datasource (ds_id,name)  values ('ands', 'Australian National Data Service');


  		




  
  174
  
    
insert into dli_datasource (ds_id,name,exportable)  values ('chrs', 'Chorus', false);


  		




  168
  175
  
    

  		




  169
  
  
    

  		




  170
  
  
    

  		












Also available in:  Unified diff