Project

General

Profile

« Previous | Next » 

Revision 9924

Added by Jing Tao over 8 years ago

Add the code to create a new column on xml_catalog table.
Register the nonamespace format id or uni on the xml_catalog table.

View differences:

src/loaddtdschema-postgres.sql
170 170 
INSERT INTO xml_catalog (entry_type, public_id, format_id, system_id) VALUES ('Schema', 'http://www.isotc211.org/2005/srv', 'http://www.isotc211.org/2005/gmd-noaa', '/schema/isotc211-noaa/srv/srv.xsd');
171 171 
INSERT INTO xml_catalog (entry_type, public_id, format_id, system_id) VALUES ('Schema', 'http://www.w3.org/1999/xlink', 'http://www.isotc211.org/2005/gmd-noaa', '/schema/isotc211-noaa/xlink/xlinks.xsd');
172 172 
INSERT INTO xml_catalog (entry_type, public_id, system_id) VALUES ('Schema', 'http://ns.dataone.org/metadata/schema/onedcx/v1.0', '/schema/onedcx/onedcx.xsd');
173 
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');
174 
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');
175 
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');
176 
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');
177 
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');
173 178 

  		




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


  		




  175
  180
  
    
  VALUES ('2.8.0',1,CURRENT_DATE);


  		












  

    
      src/xmltables-postgres.sql
    
  





  131
  131
  
    
	public_id VARCHAR(500),	-- the unique id for this type


  		




  132
  132
  
    
	system_id VARCHAR(1000),	-- the local location of the object


  		




  133
  133
  
    
  format_id VARCHAR(1000),  -- the format id from dataone 


  		




  
  134
  
    
  no_namespace_schema_location VARCHAR(2000), -- the identifier for a no-namespace schema


  		




  134
  135
  
    
   CONSTRAINT xml_catalog_pk PRIMARY KEY (catalog_id),


  		




  135
  136
  
    
   CONSTRAINT xml_catalog_uk UNIQUE


  		




  136
  137
  
    
              (entry_type, source_doctype, target_doctype, public_id, format_id)


  		












Also available in:  Unified diff