Revision 8617
Added by Chris Jones about 10 years ago
| upgrade-db-to-2.4.0-postgres.sql | ||
|---|---|---|
| 182 | 182 |
AND system_id LIKE '%/dc/%'; |
| 183 | 183 |
DELETE FROM xml_catalog |
| 184 | 184 |
WHERE entry_type LIKE 'Schema' |
| 185 |
AND system_id LIKE '%/dwc/%'; |
|
| 186 |
DELETE FROM xml_catalog |
|
| 187 |
WHERE entry_type LIKE 'Schema' |
|
| 185 | 188 |
AND system_id LIKE '%/dryad/%'; |
| 186 | 189 |
INSERT INTO xml_catalog (entry_type, public_id, system_id) |
| 187 | 190 |
VALUES ('Schema', 'http://ns.dataone.org/service/types/v1', '/schema/dataone/dataoneTypes.xsd');
|
| ... | ... | |
| 197 | 200 |
VALUES ('Schema', 'http://purl.org/dc/elements/1.1/', '/schema/dc/dc.xsd');
|
| 198 | 201 |
INSERT INTO xml_catalog (entry_type, public_id, system_id) |
| 199 | 202 |
VALUES ('Schema', 'http://purl.org/dc/dcmitype/', '/schema/dc/dcmitype.xsd');
|
| 203 |
INSERT INTO xml_catalog (entry_type, public_id, system_id) |
|
| 204 |
VALUES ('Schema', 'http://rs.tdwg.org/dwc/terms/', '/schema/dwc/tdwg_dwcterms.xsd');
|
|
| 200 | 205 |
|
| 201 | 206 |
/* |
| 202 | 207 |
* update the database version |
Also available in: Unified diff
Add in Darwin Core schema support into xml_catalog, and insert it on upgrade as well. The schemas are cached in lib/schema/dwc, and Matt and Ben noted that the tdwg_basetypes.xsd and tdwg_dwctypes.xsd are part of the same namespace, but are xs:include'd rather than imported via namespace.