Revision 8609
Added by Chris Jones about 10 years ago
| upgrade-db-to-2.4.0-postgres.sql | ||
|---|---|---|
| 172 | 172 |
DROP TABLE IF EXISTS current_documents; |
| 173 | 173 |
DROP TABLE IF EXISTS restore_documents; |
| 174 | 174 |
|
| 175 |
/* Register schemas |
|
| 176 |
*/ |
|
| 177 |
DELETE FROM xml_catalog |
|
| 178 |
WHERE entry_type LIKE 'Schema' |
|
| 179 |
AND system_id LIKE '%/dataone/%'; |
|
| 180 |
DELETE FROM xml_catalog |
|
| 181 |
WHERE entry_type LIKE 'Schema' |
|
| 182 |
AND system_id LIKE '%/dc/%'; |
|
| 183 |
DELETE FROM xml_catalog |
|
| 184 |
WHERE entry_type LIKE 'Schema' |
|
| 185 |
AND system_id LIKE '%/dryad/%'; |
|
| 186 |
INSERT INTO xml_catalog (entry_type, public_id, system_id) |
|
| 187 |
VALUES ('Schema', 'http://ns.dataone.org/service/types/v1', '/schema/dataone/dataoneTypes.xsd');
|
|
| 188 |
INSERT INTO xml_catalog (entry_type, public_id, system_id) |
|
| 189 |
VALUES ('Schema', 'http://ns.dataone.org/service/types/v1.1', '/schema/dataone/dataoneTypes_v1.1.xsd');
|
|
| 190 |
INSERT INTO xml_catalog (entry_type, public_id, system_id) |
|
| 191 |
VALUES ('Schema', 'http://purl.org/dryad/schema/terms/v3.1', '/schema/dryad/dryad.xsd');
|
|
| 192 |
INSERT INTO xml_catalog (entry_type, public_id, system_id) |
|
| 193 |
VALUES ('Schema', 'http://purl.org/dryad/schema/dryad-bibo/v3.1', '/schema/dryad/dryad-bibo.xsd');
|
|
| 194 |
INSERT INTO xml_catalog (entry_type, public_id, system_id) |
|
| 195 |
VALUES ('Schema', 'http://purl.org/dc/terms/', '/schema/dc/dcterms.xsd');
|
|
| 196 |
INSERT INTO xml_catalog (entry_type, public_id, system_id) |
|
| 197 |
VALUES ('Schema', 'http://purl.org/dc/elements/1.1/', '/schema/dc/dc.xsd');
|
|
| 198 |
INSERT INTO xml_catalog (entry_type, public_id, system_id) |
|
| 199 |
VALUES ('Schema', 'http://purl.org/dc/dcmitype/', '/schema/dc/dcmitype.xsd');
|
|
| 200 |
|
|
| 175 | 201 |
/* |
| 176 | 202 |
* update the database version |
| 177 | 203 |
*/ |
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.