Revision 10136
Added by Jing Tao about 8 years ago
| src/upgrade-db-to-2.8.1-postgres.sql | ||
|---|---|---|
| 3 | 3 |
*/ |
| 4 | 4 |
SELECT setval('xml_catalog_id_seq', (SELECT max(catalog_id) from xml_catalog));
|
| 5 | 5 |
|
| 6 |
INSERT INTO xml_catalog (entry_type, format_id, no_namespace_schema_location, system_id) SELECT 'NoNamespaceSchema', 'FGDC-STD-001.1-1999', 'https://water.usgs.gov/GIS/metadata/usgswrd/fgdc-std-001-1998.xsd', '/schema/fgdc-bdp/fgdc-std-001.1-1999.xsd' WHERE NOT EXISTS (SELECT * FROM xml_catalog WHERE entry_type='NoNamespaceSchema' AND format_id='FGDC-STD-001.1-1999' AND no_namespace_schema_location='https://water.usgs.gov/GIS/metadata/usgswrd/fgdc-std-001-1998.xsd' AND system_id='/schema/fgdc-bdp/fgdc-std-001.1-1999.xsd'); |
|
| 7 |
|
|
| 6 | 8 |
/* |
| 7 | 9 |
* update the database version |
| 8 | 10 |
*/ |
Also available in: Unified diff
Add the sql to register schema files for the format id fgdc-st-001.1-1999.