Project

General

Profile

« Previous | Next » 

Revision 9926

Added by Jing Tao almost 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