Project

General

Profile

« Previous | Next » 

Revision 9212

Added by Jing Tao about 9 years ago

Add the code to add dataone schema v2 in the xml_catalog table.

View differences:

upgrade-db-to-2.5.0-postgres.sql
4 4 
ALTER TABLE systemMetadata ADD COLUMN series_id text;
5 5 

  		




  6
  6
  
    
/*


  		




  
  7
  
    
 * Add an entry for dataone schema v2


  		




  
  8
  
    
 */


  		




  
  9
  
    
INSERT INTO xml_catalog (entry_type, public_id, system_id)


  		




  
  10
  
    
  VALUES ('Schema', 'http://ns.dataone.org/service/types/v2.0', '/schema/dataone/dataoneTypes_v2.0.xsd');


  		




  
  11
  
    
/*


  		




  7
  12
  
    
 * update the database version


  		




  8
  13
  
    
 */


  		




  9
  14
  
    
UPDATE db_version SET status=0;


  		












Also available in:  Unified diff