Revision 2279
Added by Matt Jones almost 20 years ago
src/upgrade-db-to-1.4.sql | ||
---|---|---|
96 | 96 |
* Modify the xml_index.path to the new larger size |
97 | 97 |
*/ |
98 | 98 |
ALTER TABLE xml_index MODIFY (path VARCHAR2(1000)); |
99 |
|
|
100 |
/* |
|
101 |
* Update the XML_CATALOG table with new entries, and change old ones |
|
102 |
*/ |
|
103 |
INSERT INTO xml_catalog (entry_type, public_id, system_id) |
|
104 |
VALUES ('Schema', '@eml2_0_1namespace@', '@systemidserver@@html-path@/schema/eml-2.0.1/eml.xsd'); |
|
105 |
UPDATE xml_catalog |
|
106 |
SET system_id = '@systemidserver@@html-path@/schema/eml-2.0.0/eml.xsd' |
|
107 |
WHERE public_id = '@eml2_0_0namespace@'; |
|
108 |
UPDATE xml_catalog |
|
109 |
SET system_id = '@systemidserver@@html-path@/schema/eml-2.0.0/stmml.xsd' |
|
110 |
WHERE public_id = '@stmmlnamespace@'; |
src/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
Added lines for updating xml_catalog in the upgrade script to point to the
new schema locations.