Project

General

Profile

« Previous | Next » 

Revision 9926

Added by Jing Tao over 8 years ago

Put the formatid and nonamespace_schema_location into one record for fgdc.

View differences:

src/upgrade-db-to-2.7.2-postgres.sql
9 9
 */
10 10
ALTER TABLE xml_catalog ADD COLUMN no_namespace_schema_location VARCHAR(2000);
11 11

  
12
/*
13
 * Add a formatid indicates it is a fgdc document without namespace
14
 */
15
INSERT INTO xml_catalog (entry_type, format_id, system_id) VALUES ('Schema', 'FGDC-STD-001-1998', '/schema/fgdc-std-001-1998/fgdc-std-001-1998.xsd');
16 12

  
17 13
/*
18
 * Add the columns with the no_namespace_schema_location referring the fgdc documents
14
 * Add the columns with the no_namespace_schema_location and format id referring the fgdc documents
19 15
 */
20
INSERT INTO xml_catalog (entry_type, no_namespace_schema_location, system_id) VALUES ('Schema', 'https://www.fgdc.gov/schemas/metadata/fgdc-std-001-1998.xsd', '/schema/fgdc-std-001-1998/fgdc-std-001-1998.xsd');
21
INSERT INTO xml_catalog (entry_type, no_namespace_schema_location, system_id) VALUES ('Schema', 'http://www.fgdc.gov/schemas/metadata/fgdc-std-001-1998.xsd', '/schema/fgdc-std-001-1998/fgdc-std-001-1998.xsd'); 
22
INSERT INTO xml_catalog (entry_type, no_namespace_schema_location, system_id) VALUES ('Schema', 'https://www.fgdc.gov/metadata/fgdc-std-001-1998.xsd', '/schema/fgdc-std-001-1998/fgdc-std-001-1998.xsd'); 
23
INSERT INTO xml_catalog (entry_type, no_namespace_schema_location, system_id) VALUES ('Schema', 'http://www.fgdc.gov/metadata/fgdc-std-001-1998.xsd', '/schema/fgdc-std-001-1998/fgdc-std-001-1998.xsd');
16
INSERT INTO xml_catalog (entry_type, format_id, no_namespace_schema_location, system_id) VALUES ('Schema', 'FGDC-STD-001-1998', 'https://www.fgdc.gov/schemas/metadata/fgdc-std-001-1998.xsd', '/schema/fgdc-std-001-1998/fgdc-std-001-1998.xsd');
17
INSERT INTO xml_catalog (entry_type, format_id, no_namespace_schema_location, system_id) VALUES ('Schema', 'FGDC-STD-001-1998', 'http://www.fgdc.gov/schemas/metadata/fgdc-std-001-1998.xsd', '/schema/fgdc-std-001-1998/fgdc-std-001-1998.xsd'); 
18
INSERT INTO xml_catalog (entry_type, format_id, no_namespace_schema_location, system_id) VALUES ('Schema', 'FGDC-STD-001-1998', 'https://www.fgdc.gov/metadata/fgdc-std-001-1998.xsd', '/schema/fgdc-std-001-1998/fgdc-std-001-1998.xsd'); 
19
INSERT INTO xml_catalog (entry_type, format_id, no_namespace_schema_location, system_id) VALUES ('Schema', 'FGDC-STD-001-1998', 'http://www.fgdc.gov/metadata/fgdc-std-001-1998.xsd', '/schema/fgdc-std-001-1998/fgdc-std-001-1998.xsd');
24 20

  
25 21
/*
26 22
 * update the database version

Also available in: Unified diff