Project

General

Profile

Revision 2279

Added by Matt Jones over 16 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