Project

General

Profile

« Previous | Next » 

Revision 10461

Added by Jing Tao over 6 years ago

added a new format id for pangaea.

View differences:

loaddtdschema-postgres.sql
176 176 
INSERT INTO xml_catalog (entry_type, format_id, no_namespace_schema_location, system_id) VALUES ('NoNamespaceSchema', 'FGDC-STD-001-1998', 'http://www.fgdc.gov/metadata/fgdc-std-001-1998.xsd', '/schema/fgdc-std-001-1998/fgdc-std-001-1998.xsd');
177 177 
INSERT INTO xml_catalog (entry_type, format_id, no_namespace_schema_location, system_id) VALUES ('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');
178 178 

  		




  
  179
  
    
INSERT INTO xml_catalog (entry_type, public_id, format_id, system_id) 


  		




  
  180
  
    
    SELECT 'Schema', 'http://www.isotc211.org/2005/gmd', 'http://www.isotc211.org/2005/gmd-pangaea', '/schema/isotc211-pangaea/gmd.xsd' WHERE NOT EXISTS (SELECT * FROM xml_catalog WHERE format_id='http://www.isotc211.org/2005/gmd-pangaea' AND public_id='http://www.isotc211.org/2005/gmd');


  		




  
  181
  
    

  		




  
  182
  
    
INSERT INTO xml_catalog (entry_type, public_id, format_id, system_id) 


  		




  
  183
  
    
    SELECT 'Schema', 'http://www.isotc211.org/2005/gss', 'http://www.isotc211.org/2005/gmd-pangaea', '/schema/isotc211-pangaea/gss.xsd' WHERE NOT EXISTS (SELECT * FROM xml_catalog WHERE format_id='http://www.isotc211.org/2005/gmd-pangaea' AND public_id='http://www.isotc211.org/2005/gss');


  		




  
  184
  
    

  		




  
  185
  
    
INSERT INTO xml_catalog (entry_type, public_id, format_id, system_id) 


  		




  
  186
  
    
    SELECT 'Schema', 'http://www.isotc211.org/2005/gsr', 'http://www.isotc211.org/2005/gmd-pangaea', '/schema/isotc211-pangaea/gsr.xsd' WHERE NOT EXISTS (SELECT * FROM xml_catalog WHERE format_id='http://www.isotc211.org/2005/gmd-pangaea' AND public_id='http://www.isotc211.org/2005/gsr');


  		




  
  187
  
    

  		




  
  188
  
    
INSERT INTO xml_catalog (entry_type, public_id, format_id, system_id) 


  		




  
  189
  
    
    SELECT 'Schema', 'http://www.isotc211.org/2005/gts', 'http://www.isotc211.org/2005/gmd-pangaea', '/schema/isotc211-pangaea/gts.xsd' WHERE NOT EXISTS (SELECT * FROM xml_catalog WHERE format_id='http://www.isotc211.org/2005/gmd-pangaea' AND public_id='http://www.isotc211.org/2005/gts');


  		




  
  190
  
    

  		




  
  191
  
    
INSERT INTO xml_catalog (entry_type, public_id, format_id, system_id) 


  		




  
  192
  
    
    SELECT 'Schema', 'http://www.isotc211.org/2005/gco', 'http://www.isotc211.org/2005/gmd-pangaea', '/schema/isotc211-pangaea/gco.xsd' WHERE NOT EXISTS (SELECT * FROM xml_catalog WHERE format_id='http://www.isotc211.org/2005/gmd-pangaea' AND public_id='http://www.isotc211.org/2005/gco');


  		




  
  193
  
    
    


  		




  
  194
  
    
INSERT INTO xml_catalog (entry_type, public_id, format_id, system_id) 


  		




  
  195
  
    
    SELECT 'Schema', 'http://www.w3.org/1999/xlink', 'http://www.isotc211.org/2005/gmd-pangaea', '/schema/isotc211-pangaea/xlinks.xsd' WHERE NOT EXISTS (SELECT * FROM xml_catalog WHERE format_id='http://www.isotc211.org/2005/gmd-pangaea' AND public_id='http://www.w3.org/1999/xlink');


  		




  
  196
  
    
    


  		




  
  197
  
    
INSERT INTO xml_catalog (entry_type, public_id, format_id, system_id) 


  		




  
  198
  
    
    SELECT 'Schema', 'http://www.opengis.net/gml', 'http://www.isotc211.org/2005/gmd-pangaea', '/schema/isotc211-pangaea/gml.xsd' WHERE NOT EXISTS (SELECT * FROM xml_catalog WHERE format_id='http://www.isotc211.org/2005/gmd-pangaea' AND public_id='http://www.opengis.net/gml');


  		




  
  199
  
    

  		




  
  200
  
    

  		




  179
  201
  
    
INSERT INTO db_version (version, status, date_created) 


  		




  180
  202
  
    
  VALUES ('2.9.0',1,CURRENT_DATE);


  		












Also available in:  Unified diff