Revision 6658
Added by ben leinfelder about 13 years ago
src/upgrade-db-to-2.0.0-oracle.sql | ||
---|---|---|
68 | 68 |
CREATE INDEX xml_path_index_idx4 ON xml_path_index (nodedatadate); |
69 | 69 |
|
70 | 70 |
/* |
71 |
* Register the DataONE schemas
|
|
71 |
* Register the new schema
|
|
72 | 72 |
*/ |
73 | 73 |
INSERT INTO xml_catalog (entry_type, public_id, system_id) |
74 |
VALUES ('Schema', 'http://ns.dataone.org/service/types/0.6.4', '/schema/D1_SCHEMA_0_6_4/dataoneTypes.xsd'); |
|
75 |
|
|
76 |
INSERT INTO xml_catalog (entry_type, public_id, system_id) |
|
77 | 74 |
VALUES ('Schema', '@eml2_1_1namespace@', '/schema/eml-2.1.1/eml.xsd'); |
78 | 75 |
|
79 | 76 |
/* |
src/loaddtdschema-oracle.sql | ||
---|---|---|
50 | 50 |
INSERT INTO xml_catalog (entry_type, public_id, system_id) |
51 | 51 |
VALUES ('Schema', '@eml2_1_1namespace@', '/schema/eml-2.1.1/eml.xsd'); |
52 | 52 |
INSERT INTO xml_catalog (entry_type, public_id, system_id) |
53 |
VALUES ('Schema', '/schema/RegistryService/RegistryEntryType.xsd', '/schema/RegistryService/RegistryEntryType.xsd'); |
|
54 |
INSERT INTO xml_catalog (entry_type, public_id, system_id) |
|
55 |
VALUES ('Schema', 'http://ns.dataone.org/service/types/0.6.4', '/schema/D1_SCHEMA_0_6_4/dataoneTypes.xsd'); |
|
53 |
VALUES ('Schema', '/schema/RegistryService/RegistryEntryType.xsd', '/schema/RegistryService/RegistryEntryType.xsd'); |
|
56 | 54 |
INSERT INTO db_version (version, status, date_created) |
57 | 55 |
VALUES ('2.0.0',1,CURRENT_DATE); |
src/upgrade-db-to-2.0.0-postgres.sql | ||
---|---|---|
72 | 72 |
ALTER TABLE acces_log ADD COLUMN user_agent VARCHAR(512); |
73 | 73 |
|
74 | 74 |
/* |
75 |
* Register the DataONE schemas
|
|
75 |
* Register the new schema
|
|
76 | 76 |
*/ |
77 |
|
|
78 | 77 |
INSERT INTO xml_catalog (entry_type, public_id, system_id) |
79 |
VALUES ('Schema', 'http://ns.dataone.org/service/types/0.6.4', '/schema/D1_SCHEMA_0_6_4/dataoneTypes.xsd'); |
|
80 |
|
|
81 |
INSERT INTO xml_catalog (entry_type, public_id, system_id) |
|
82 | 78 |
VALUES ('Schema', '@eml2_1_1namespace@', '/schema/eml-2.1.1/eml.xsd'); |
83 | 79 |
/* |
84 | 80 |
* update the database version |
src/loaddtdschema-postgres.sql | ||
---|---|---|
51 | 51 |
VALUES ('Schema', '@eml2_1_1namespace@', '/schema/eml-2.1.1/eml.xsd'); |
52 | 52 |
INSERT INTO xml_catalog (entry_type, public_id, system_id) |
53 | 53 |
VALUES ('Schema', 'http://ecoinformatics.org/registryentry-1.0.0', '/schema/RegistryService/RegistryEntryType.xsd'); |
54 |
INSERT INTO xml_catalog (entry_type, public_id, system_id) |
|
55 |
VALUES ('Schema', 'http://ns.dataone.org/service/types/0.6.4', '/schema/D1_SCHEMA_0_6_4/dataoneTypes.xsd'); |
|
56 | 54 |
INSERT INTO db_version (version, status, date_created) |
57 | 55 |
VALUES ('2.0.0',1,CURRENT_DATE); |
Also available in: Unified diff
remove DataONE schema reference in xml_catalog