Revision 8617
Added by Chris Jones over 10 years ago
loaddtdschema-oracle.sql | ||
---|---|---|
7 | 7 |
DELETE FROM xml_catalog |
8 | 8 |
WHERE entry_type LIKE 'Schema' |
9 | 9 |
AND system_id LIKE '%eml%'; |
10 |
DELETE FROM xml_catalog |
|
11 |
WHERE entry_type LIKE 'Schema' |
|
12 |
AND system_id LIKE '%/dataone/%'; |
|
13 |
DELETE FROM xml_catalog |
|
14 |
WHERE entry_type LIKE 'Schema' |
|
15 |
AND system_id LIKE '%/dc/%'; |
|
16 |
DELETE FROM xml_catalog |
|
17 |
WHERE entry_type LIKE 'Schema' |
|
18 |
AND system_id LIKE '%/dwc/%'; |
|
19 |
DELETE FROM xml_catalog |
|
20 |
WHERE entry_type LIKE 'Schema' |
|
21 |
AND system_id LIKE '%/dryad/%'; |
|
10 | 22 |
INSERT INTO xml_catalog (entry_type, public_id, system_id) |
11 | 23 |
VALUES ('DTD', '-//ecoinformatics.org//eml-access-@eml-version@//EN', |
12 | 24 |
'/dtd/eml-access-@eml-version@.dtd'); |
... | ... | |
107 | 119 |
VALUES ('Schema', 'http://purl.org/dc/elements/1.1/', '/schema/dc/dc.xsd'); |
108 | 120 |
INSERT INTO xml_catalog (entry_type, public_id, system_id) |
109 | 121 |
VALUES ('Schema', 'http://purl.org/dc/dcmitype/', '/schema/dc/dcmitype.xsd'); |
122 |
INSERT INTO xml_catalog (entry_type, public_id, system_id) |
|
123 |
VALUES ('Schema', 'http://rs.tdwg.org/dwc/terms/', '/schema/dwc/tdwg_dwcterms.xsd'); |
|
110 | 124 |
|
111 | 125 |
INSERT INTO db_version (version, status, date_created) |
112 | 126 |
VALUES ('2.4.0',1,CURRENT_DATE); |
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.