Project

General

Profile

« Previous | Next » 

Revision 8617

Added by Chris Jones about 10 years ago

Add in Darwin Core schema support into xml_catalog, and insert it on upgrade as well. The schemas are cached in lib/schema/dwc, and Matt and Ben noted that the tdwg_basetypes.xsd and tdwg_dwctypes.xsd are part of the same namespace, but are xs:include'd rather than imported via namespace.

View differences:

upgrade-db-to-2.4.0-oracle.sql
62 62 
AND sm.obsoleted_by IS NOT null
63 63 
AND sm.archived = 'true';
64 64 

  		




  
  65
  
    
/* Register schemas


  		




  
  66
  
    
*/


  		




  
  67
  
    
DELETE FROM xml_catalog 


  		




  
  68
  
    
      WHERE entry_type LIKE 'Schema'


  		




  
  69
  
    
        AND system_id LIKE '%/dataone/%';


  		




  
  70
  
    
DELETE FROM xml_catalog 


  		




  
  71
  
    
      WHERE entry_type LIKE 'Schema'


  		




  
  72
  
    
        AND system_id LIKE '%/dc/%';


  		




  
  73
  
    
DELETE FROM xml_catalog 


  		




  
  74
  
    
      WHERE entry_type LIKE 'Schema'


  		




  
  75
  
    
        AND system_id LIKE '%/dwc/%';


  		




  
  76
  
    
DELETE FROM xml_catalog 


  		




  
  77
  
    
      WHERE entry_type LIKE 'Schema'


  		




  
  78
  
    
        AND system_id LIKE '%/dryad/%';                


  		




  
  79
  
    
INSERT INTO xml_catalog (entry_type, public_id, system_id)


  		




  
  80
  
    
  VALUES ('Schema', 'http://ns.dataone.org/service/types/v1', '/schema/dataone/dataoneTypes.xsd');


  		




  
  81
  
    
INSERT INTO xml_catalog (entry_type, public_id, system_id)


  		




  
  82
  
    
  VALUES ('Schema', 'http://ns.dataone.org/service/types/v1.1', '/schema/dataone/dataoneTypes_v1.1.xsd');


  		




  
  83
  
    
INSERT INTO xml_catalog (entry_type, public_id, system_id)


  		




  
  84
  
    
  VALUES ('Schema', 'http://purl.org/dryad/schema/terms/v3.1', '/schema/dryad/dryad.xsd');


  		




  
  85
  
    
INSERT INTO xml_catalog (entry_type, public_id, system_id)


  		




  
  86
  
    
  VALUES ('Schema', 'http://purl.org/dryad/schema/dryad-bibo/v3.1', '/schema/dryad/dryad-bibo.xsd');


  		




  
  87
  
    
INSERT INTO xml_catalog (entry_type, public_id, system_id)


  		




  
  88
  
    
  VALUES ('Schema', 'http://purl.org/dc/terms/', '/schema/dc/dcterms.xsd');


  		




  
  89
  
    
INSERT INTO xml_catalog (entry_type, public_id, system_id)


  		




  
  90
  
    
  VALUES ('Schema', 'http://purl.org/dc/elements/1.1/', '/schema/dc/dc.xsd');


  		




  
  91
  
    
INSERT INTO xml_catalog (entry_type, public_id, system_id)


  		




  
  92
  
    
  VALUES ('Schema', 'http://purl.org/dc/dcmitype/', '/schema/dc/dcmitype.xsd');


  		




  
  93
  
    
INSERT INTO xml_catalog (entry_type, public_id, system_id)


  		




  
  94
  
    
  VALUES ('Schema', 'http://rs.tdwg.org/dwc/terms/', '/schema/dwc/tdwg_dwcterms.xsd');


  		




  
  95
  
    

  		




  65
  96
  
    
/*


  		




  66
  97
  
    
 * update the database version


  		




  67
  98
  
    
 */


  		












Also available in:  Unified diff