Project

General

Profile

« Previous | Next » 

Revision 2279

Added by Matt Jones over 19 years ago

Added lines for updating xml_catalog in the upgrade script to point to the
new schema locations.

View differences:

upgrade-db-to-1.4-postgres.sql
87 87 
 * Modify the xml_index.path to the new larger size
88 88 
 */
89 89 
ALTER TABLE xml_index MODIFY (path VARCHAR(1000));
90 

  		




  
  91
  
    
/*


  		




  
  92
  
    
 * Update the XML_CATALOG table with new entries, and change old ones


  		




  
  93
  
    
 */


  		




  
  94
  
    
INSERT INTO xml_catalog (entry_type, public_id, system_id)


  		




  
  95
  
    
  VALUES ('Schema', '@eml2_0_1namespace@', '@systemidserver@@html-path@/schema/eml-2.0.1/eml.xsd');


  		




  
  96
  
    
UPDATE xml_catalog


  		




  
  97
  
    
  SET system_id = '@systemidserver@@html-path@/schema/eml-2.0.0/eml.xsd'


  		




  
  98
  
    
  WHERE public_id = '@eml2_0_0namespace@';


  		




  
  99
  
    
UPDATE xml_catalog


  		




  
  100
  
    
  SET system_id = '@systemidserver@@html-path@/schema/eml-2.0.0/stmml.xsd'


  		




  
  101
  
    
  WHERE public_id = '@stmmlnamespace@';


  		












Also available in:  Unified diff