Project

General

Profile

« Previous | Next » 

Revision 9243

Added by Jing Tao over 9 years ago

Add the code to insert entries in xml_catalog for the iso119139 objects.

View differences:

src/upgrade-db-to-2.5.0-oracle.sql
21 21 
 */
22 22 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
23 23 
  VALUES ('Schema', 'http://ns.dataone.org/service/types/v2.0', '/schema/dataone/dataoneTypes_v2.0.xsd');
24 

  		




  24
  25
  
    
/*


  		




  
  26
  
    
 * Add entries for iso119139


  		




  
  27
  
    
 */


  		




  
  28
  
    
INSERT INTO xml_catalog (entry_type, public_id, system_id)


  		




  
  29
  
    
  SELECT 'Schema', 'http://www.isotc211.org/2005/gco', '/schema/isotc211/gco/gco.xsd' WHERE NOT EXISTS (SELECT * FROM xml_catalog where public_id='http://www.isotc211.org/2005/gco');


  		




  
  30
  
    

  		




  
  31
  
    
INSERT INTO xml_catalog (entry_type, public_id, system_id)


  		




  
  32
  
    
  SELECT 'Schema', 'http://www.isotc211.org/2005/gmd', '/schema/isotc211/gmd/gmd.xsd' WHERE NOT EXISTS (SELECT * FROM xml_catalog where public_id='http://www.isotc211.org/2005/gmd');


  		




  
  33
  
    
  


  		




  
  34
  
    
INSERT INTO xml_catalog (entry_type, public_id, system_id)


  		




  
  35
  
    
  SELECT 'Schema', 'http://www.isotc211.org/2005/gmi', '/schema/isotc211/gmi/gmi.xsd' WHERE NOT EXISTS (SELECT * FROM xml_catalog where public_id='http://www.isotc211.org/2005/gmi');


  		




  
  36
  
    
  


  		




  
  37
  
    
INSERT INTO xml_catalog (entry_type, public_id, system_id)


  		




  
  38
  
    
  SELECT 'Schema', 'http://www.opengis.net/gml/3.2', '/schema/isotc211/gml321/gml.xsd' WHERE NOT EXISTS (SELECT * FROM xml_catalog where public_id='http://www.opengis.net/gml/3.2');


  		




  
  39
  
    

  		




  
  40
  
    
INSERT INTO xml_catalog (entry_type, public_id, system_id)


  		




  
  41
  
    
  SELECT 'Schema', 'http://www.opengis.net/gml', '/schema/isotc211/gml311/gml.xsd' WHERE NOT EXISTS (SELECT * FROM xml_catalog where public_id='http://www.opengis.net/gml');


  		




  
  42
  
    
  


  		




  
  43
  
    
INSERT INTO xml_catalog (entry_type, public_id, system_id)


  		




  
  44
  
    
  SELECT 'Schema', 'http://www.isotc211.org/2005/gmx', '/schema/isotc211/gmx/gmx.xsd' WHERE NOT EXISTS (SELECT * FROM xml_catalog where public_id='http://www.isotc211.org/2005/gmx'); 


  		




  
  45
  
    

  		




  
  46
  
    
INSERT INTO xml_catalog (entry_type, public_id, system_id)


  		




  
  47
  
    
  SELECT 'Schema', 'http://www.isotc211.org/2005/gsr', '/schema/isotc211/gsr/gsr.xsd' WHERE NOT EXISTS (SELECT * FROM xml_catalog where public_id='http://www.isotc211.org/2005/gsr'); 


  		




  
  48
  
    

  		




  
  49
  
    
INSERT INTO xml_catalog (entry_type, public_id, system_id)


  		




  
  50
  
    
  SELECT 'Schema', 'http://www.isotc211.org/2005/gss', '/schema/isotc211/gss/gss.xsd' WHERE NOT EXISTS (SELECT * FROM xml_catalog where public_id='http://www.isotc211.org/2005/gss'); 


  		




  
  51
  
    

  		




  
  52
  
    
INSERT INTO xml_catalog (entry_type, public_id, system_id)


  		




  
  53
  
    
  SELECT 'Schema', 'http://www.isotc211.org/2005/gts', '/schema/isotc211/gts/gts.xsd' WHERE NOT EXISTS (SELECT * FROM xml_catalog where public_id='http://www.isotc211.org/2005/gts'); 


  		




  
  54
  
    
  


  		




  
  55
  
    
INSERT INTO xml_catalog (entry_type, public_id, system_id)


  		




  
  56
  
    
  SELECT 'Schema', 'http://www.isotc211.org/2005/srv', '/schema/isotc211/srv/srv.xsd' WHERE NOT EXISTS (SELECT * FROM xml_catalog where public_id='http://www.isotc211.org/2005/srv'); 


  		




  
  57
  
    

  		




  
  58
  
    
INSERT INTO xml_catalog (entry_type, public_id, system_id)


  		




  
  59
  
    
  SELECT 'Schema', 'http://www.w3.org/1999/xlink', '/schema/isotc211/xlink/xlinks.xsd' WHERE NOT EXISTS (SELECT * FROM xml_catalog where public_id='http://www.w3.org/1999/xlink'); 


  		




  
  60
  
    

  		




  
  61
  
    
/*


  		




  25
  62
  
    
 * update the database version


  		




  26
  63
  
    
 */


  		




  27
  64
  
    
UPDATE db_version SET status=0;


  		












Also available in:  Unified diff