Revision 9243
Added by Jing Tao about 9 years ago
src/upgrade-db-to-2.5.0-oracle.sql | ||
---|---|---|
21 | 21 |
*/ |
22 | 22 |
INSERT INTO xml_catalog (entry_type, public_id, system_id) |
23 | 23 |
VALUES ('Schema', 'http://ns.dataone.org/service/types/v2.0', '/schema/dataone/dataoneTypes_v2.0.xsd'); |
24 |
|
|
24 | 25 |
/* |
26 |
* Add entries for iso119139 |
|
27 |
*/ |
|
28 |
INSERT INTO xml_catalog (entry_type, public_id, system_id) |
|
29 |
SELECT 'Schema', 'http://www.isotc211.org/2005/gco', '/schema/isotc211/gco/gco.xsd' WHERE NOT EXISTS (SELECT * FROM xml_catalog where public_id='http://www.isotc211.org/2005/gco'); |
|
30 |
|
|
31 |
INSERT INTO xml_catalog (entry_type, public_id, system_id) |
|
32 |
SELECT 'Schema', 'http://www.isotc211.org/2005/gmd', '/schema/isotc211/gmd/gmd.xsd' WHERE NOT EXISTS (SELECT * FROM xml_catalog where public_id='http://www.isotc211.org/2005/gmd'); |
|
33 |
|
|
34 |
INSERT INTO xml_catalog (entry_type, public_id, system_id) |
|
35 |
SELECT 'Schema', 'http://www.isotc211.org/2005/gmi', '/schema/isotc211/gmi/gmi.xsd' WHERE NOT EXISTS (SELECT * FROM xml_catalog where public_id='http://www.isotc211.org/2005/gmi'); |
|
36 |
|
|
37 |
INSERT INTO xml_catalog (entry_type, public_id, system_id) |
|
38 |
SELECT 'Schema', 'http://www.opengis.net/gml/3.2', '/schema/isotc211/gml321/gml.xsd' WHERE NOT EXISTS (SELECT * FROM xml_catalog where public_id='http://www.opengis.net/gml/3.2'); |
|
39 |
|
|
40 |
INSERT INTO xml_catalog (entry_type, public_id, system_id) |
|
41 |
SELECT 'Schema', 'http://www.opengis.net/gml', '/schema/isotc211/gml311/gml.xsd' WHERE NOT EXISTS (SELECT * FROM xml_catalog where public_id='http://www.opengis.net/gml'); |
|
42 |
|
|
43 |
INSERT INTO xml_catalog (entry_type, public_id, system_id) |
|
44 |
SELECT 'Schema', 'http://www.isotc211.org/2005/gmx', '/schema/isotc211/gmx/gmx.xsd' WHERE NOT EXISTS (SELECT * FROM xml_catalog where public_id='http://www.isotc211.org/2005/gmx'); |
|
45 |
|
|
46 |
INSERT INTO xml_catalog (entry_type, public_id, system_id) |
|
47 |
SELECT 'Schema', 'http://www.isotc211.org/2005/gsr', '/schema/isotc211/gsr/gsr.xsd' WHERE NOT EXISTS (SELECT * FROM xml_catalog where public_id='http://www.isotc211.org/2005/gsr'); |
|
48 |
|
|
49 |
INSERT INTO xml_catalog (entry_type, public_id, system_id) |
|
50 |
SELECT 'Schema', 'http://www.isotc211.org/2005/gss', '/schema/isotc211/gss/gss.xsd' WHERE NOT EXISTS (SELECT * FROM xml_catalog where public_id='http://www.isotc211.org/2005/gss'); |
|
51 |
|
|
52 |
INSERT INTO xml_catalog (entry_type, public_id, system_id) |
|
53 |
SELECT 'Schema', 'http://www.isotc211.org/2005/gts', '/schema/isotc211/gts/gts.xsd' WHERE NOT EXISTS (SELECT * FROM xml_catalog where public_id='http://www.isotc211.org/2005/gts'); |
|
54 |
|
|
55 |
INSERT INTO xml_catalog (entry_type, public_id, system_id) |
|
56 |
SELECT 'Schema', 'http://www.isotc211.org/2005/srv', '/schema/isotc211/srv/srv.xsd' WHERE NOT EXISTS (SELECT * FROM xml_catalog where public_id='http://www.isotc211.org/2005/srv'); |
|
57 |
|
|
58 |
INSERT INTO xml_catalog (entry_type, public_id, system_id) |
|
59 |
SELECT 'Schema', 'http://www.w3.org/1999/xlink', '/schema/isotc211/xlink/xlinks.xsd' WHERE NOT EXISTS (SELECT * FROM xml_catalog where public_id='http://www.w3.org/1999/xlink'); |
|
60 |
|
|
61 |
/* |
|
25 | 62 |
* update the database version |
26 | 63 |
*/ |
27 | 64 |
UPDATE db_version SET status=0; |
Also available in: Unified diff
Add the code to insert entries in xml_catalog for the iso119139 objects.