Revision 2279
Added by Matt Jones over 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.