Revision 3016
Added by sgarg over 18 years ago
src/upgrade-db-to-1.6.sql | ||
---|---|---|
230 | 230 |
/** Drop xml_nodes_2 table */ |
231 | 231 |
DROP TABLE xml_nodes_2; |
232 | 232 |
|
233 |
/** Done */ |
|
234 | 233 |
|
235 | 234 |
|
235 |
/** Update xml_catalog so that eml-2.0.1 stylesheets are used for displaying eml-2.0.0 documents */ |
|
236 |
UPDATE xml_catalog SET system_id='http://knb.msi.ucsb.edu/knb/schema/eml-2.0.0/eml.xsd' WHERE public_id = 'eml://ecoinformatics.org/eml-2.0.0'; |
|
237 |
|
|
238 |
|
|
239 |
/** Done */ |
src/loaddtdschema.sql | ||
---|---|---|
40 | 40 |
INSERT INTO xml_catalog (entry_type, public_id, system_id) |
41 | 41 |
VALUES ('Schema', '@eml2_0_1namespace@', '@systemidserver@@html-path@/schema/eml-2.0.1/eml.xsd'); |
42 | 42 |
INSERT INTO xml_catalog (entry_type, public_id, system_id) |
43 |
VALUES ('Schema', '@eml2_0_0namespace@', '@systemidserver@@html-path@/schema/eml-2.0.0/eml.xsd');
|
|
43 |
VALUES ('Schema', '@eml2_0_0namespace@', '@systemidserver@@html-path@/schema/eml-2.0.1/eml.xsd');
|
|
44 | 44 |
INSERT INTO xml_catalog (entry_type, public_id, system_id) |
45 |
VALUES ('Schema', '@stmmlnamespace@', '@systemidserver@@html-path@/schema/eml-2.0.0/stmml.xsd');
|
|
45 |
VALUES ('Schema', '@stmmlnamespace@', '@systemidserver@@html-path@/schema/eml-2.0.1/stmml.xsd');
|
|
46 | 46 |
INSERT INTO xml_catalog (entry_type, public_id, system_id) |
47 | 47 |
VALUES ('Schema', 'metadata', '@systemidserver@@html-path@/schema/fgdc-std-001/fgdc-std-001-1998.xsd'); |
src/loadschema.sql | ||
---|---|---|
1 | 1 |
INSERT INTO xml_catalog (entry_type, public_id, system_id) |
2 | 2 |
VALUES ('Schema', '@eml2_0_1namespace@', '@systemidserver@@html-path@/schema/eml-2.0.1/eml.xsd'); |
3 | 3 |
INSERT INTO xml_catalog (entry_type, public_id, system_id) |
4 |
VALUES ('Schema', '@eml2_0_0namespace@', '@systemidserver@@html-path@/schema/eml-2.0.0/eml.xsd');
|
|
4 |
VALUES ('Schema', '@eml2_0_0namespace@', '@systemidserver@@html-path@/schema/eml-2.0.1/eml.xsd');
|
|
5 | 5 |
INSERT INTO xml_catalog (entry_type, public_id, system_id) |
6 |
VALUES ('Schema', '@stmmlnamespace@', '@systemidserver@@html-path@/schema/eml-2.0.0/stmml.xsd'); |
|
6 |
VALUES ('Schema', '@stmmlnamespace@', '@systemidserver@@html-path@/schema/eml-2.0.1/stmml.xsd'); |
Also available in: Unified diff
Modified the sql commands such that eml-2.0.1 stylesheets are used for displaying eml-2.0.0 documents