Project

General

Profile

« Previous | Next » 

Revision 6136

Added by ben leinfelder almost 13 years ago

add option for replicating system metadata (dataone)
https://redmine.dataone.org/issues/1626
also make sure the latest table changes are included in upgrade scripts

View differences:

xmltables-postgres.sql
39 39 
  last_checked DATE,
40 40 
  replicate INT8,
41 41 
  datareplicate INT8,
42 
  systemmetadatareplicate INT8,
42 43 
  hub INT8,
43 44 
  CONSTRAINT xml_replication_pk PRIMARY KEY (serverid)
44 45 
);
45 46 

  		




  46
  
  
    
INSERT INTO xml_replication (server, replicate, datareplicate, hub) VALUES ('localhost', '0', '0', '0');


  		




  
  47
  
    
INSERT INTO xml_replication (server, replicate, datareplicate, systemmetadatareplicate, hub) VALUES ('localhost', '0', '0', '0' '0');


  		




  
  48
  
    
/*


  		




  
  49
  
    
 * ALTER TABLE xml_replication ADD COLUMN systemmetadatareplicate INT8;


  		




  
  50
  
    
 */


  		




  47
  51
  
    

  		




  48
  52
  
    
/*


  		




  49
  53
  
    
 * Nodes -- table to store XML Nodes (both elements and attributes)


  		












Also available in:  Unified diff