Project

General

Profile

« Previous | Next » 

Revision 9857

Added by Lauren Walker about 7 years ago

Merge changes from 2.7 branch

View differences:

upgrade-db-to-2.7.1-postgres.sql
1 1 
/*
2 
 * Add onedcx XML schema to xml_catalog table
3 
 */
4 
 INSERT INTO xml_catalog (entry_type, public_id, system_id) VALUES ('Schema', 'http://ns.dataone.org/metadata/schema/onedcx/v1.0', '/schema/onedcx/onedcx.xsd');
5 

  		




  
  6
  
    
/*


  		




  2
  7
  
    
 * Ensure xml_catalog sequence is at table max


  		




  3
  8
  
    
 */


  		




  4
  9
  
    
SELECT setval('xml_catalog_id_seq', (SELECT max(catalog_id) from xml_catalog));


  		




  ......




  10
  15
  
    
UPDATE db_version SET status=0;


  		




  11
  16
  
    

  		




  12
  17
  
    
INSERT INTO db_version (version, status, date_created) 


  		




  13
  
  
    
  VALUES ('2.7.1', 1, CURRENT_DATE);


  		




  
  18
  
    
  VALUES ('2.7.1', 1, CURRENT_DATE);


  		




  14
  19
  
    

  		












Also available in:  Unified diff