Revision 8609
Added by Chris Jones over 10 years ago
loaddtdschema-postgres.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 '%/dryad/%'; |
|
10 | 19 |
INSERT INTO xml_catalog (entry_type, public_id, system_id) |
11 | 20 |
VALUES ('DTD', '-//ecoinformatics.org//eml-access-@eml-version@//EN', |
12 | 21 |
'/dtd/eml-access-@eml-version@.dtd'); |
Also available in: Unified diff
Add DataONE, Dublin Core, and Dryad schemas during the 2.4.0 upgrade, and be sure to remove the appropriate entries before inserting to avoid duplicate rows.