Project

General

Profile

« Previous | Next » 

Revision 5547

Added by berkley about 14 years ago

updated DB scripts for D1 schemas

View differences:

src/loaddtdschema-oracle.sql
49 49 
  VALUES ('Schema', '@eml2_1_0namespace@', '/schema/eml-2.1.0/eml.xsd');
50 50 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
51 51 
  VALUES ('Schema', '/schema/RegistryService/RegistryEntryType.xsd', '/schema/RegistryService/RegistryEntryType.xsd');
52 

  		




  52
  53
  
    
INSERT INTO xml_catalog (entry_type, public_id, system_id)


  		




  53
  
  
    
  VALUES ('Schema', 'http://www.loc.gov/METS/', '/schema/D1_SCHEMA_0_4/dryadMetsAny.xsd');


  		




  
  54
  
    
  VALUES ('Schema', 'http://dataone.org/service/types/SystemMetadata/0.1', '/schema/D1_SCHEMA_0_4/systemmetadata.xsd');


  		




  
  55
  
    
INSERT INTO xml_catalog (entry_type, public_id, system_id)


  		




  
  56
  
    
  VALUES ('Schema', 'http://dataone.org/service/types/common/0.1', '/schema/D1_SCHEMA_0_4/common.xsd');


  		




  54
  57
  
    
  


  		




  55
  58
  
    
INSERT INTO db_version (version, status, date_created) 


  		




  56
  
  
    
  VALUES ('1.9.2',1,CURRENT_DATE);


  		




  
  59
  
    
  VALUES ('1.10.0',1,CURRENT_DATE);


  		












  

    
      src/upgrade-db-to-1.10.0-postgres.sql
    
  





  22
  22
  
    
  VALUES ('Schema', 'http://dataone.org/service/types/SystemMetadata/0.1', '/schema/D1_SCHEMA_0_4/systemmetadata.xsd');


  		




  23
  23
  
    
INSERT INTO xml_catalog (entry_type, public_id, system_id)


  		




  24
  24
  
    
  VALUES ('Schema', 'http://dataone.org/service/types/common/0.1', '/schema/D1_SCHEMA_0_4/common.xsd');


  		




  25
  
  
    
INSERT INTO xml_catalog (entry_type, public_id, system_id)


  		




  26
  
  
    
  VALUES ('Schema', 'http://www.loc.gov/METS/', '/schema/D1_SCHEMA_0_4/dryadMetsAny.xsd');


  		




  27
  25
  
    
  


  		




  28
  26
  
    
/*


  		




  29
  27
  
    
 * update the database version


  		












  

    
      src/loaddtdschema-postgres.sql
    
  





  49
  49
  
    
  VALUES ('Schema', '@eml2_1_0namespace@', '/schema/eml-2.1.0/eml.xsd');


  		




  50
  50
  
    
INSERT INTO xml_catalog (entry_type, public_id, system_id)


  		




  51
  51
  
    
  VALUES ('Schema', 'http://ecoinformatics.org/registryentry-1.0.0', '/schema/RegistryService/RegistryEntryType.xsd');


  		




  
  52
  
    

  		




  52
  53
  
    
INSERT INTO xml_catalog (entry_type, public_id, system_id)


  		




  53
  
  
    
  VALUES ('Schema', 'http://dataone.org/service/types/SystemMetadata/0.1', '/schema/D1_SCHEMA_0_1/systemmetadata.xsd');


  		




  
  54
  
    
  VALUES ('Schema', 'http://dataone.org/service/types/SystemMetadata/0.1', '/schema/D1_SCHEMA_0_4/systemmetadata.xsd');


  		




  54
  55
  
    
INSERT INTO xml_catalog (entry_type, public_id, system_id)


  		




  55
  
  
    
  VALUES ('Schema', 'http://dataone.org/service/types/common/0.1', '/schema/D1_SCHEMA_0_1/common.xsd');


  		




  56
  
  
    
INSERT INTO xml_catalog (entry_type, public_id, system_id)


  		




  57
  
  
    
  VALUES ('Schema', 'http://www.loc.gov/METS/', '/schema/D1_SCHEMA_0_4/dryadMetsAny.xsd');


  		




  
  56
  
    
  VALUES ('Schema', 'http://dataone.org/service/types/common/0.1', '/schema/D1_SCHEMA_0_4/common.xsd');


  		




  58
  57
  
    

  		




  59
  58
  
    
INSERT INTO db_version (version, status, date_created) 


  		




  60
  59
  
    
  VALUES ('1.10.0',1,CURRENT_DATE);


  		












  

    
      src/upgrade-db-to-1.10.0-oracle.sql
    
  





  20
  20
  
    
  VALUES ('Schema', 'http://dataone.org/service/types/SystemMetadata/0.1', '/schema/D1_SCHEMA_0_4/systemmetadata.xsd');


  		




  21
  21
  
    
INSERT INTO xml_catalog (entry_type, public_id, system_id)


  		




  22
  22
  
    
  VALUES ('Schema', 'http://dataone.org/service/types/common/0.1', '/schema/D1_SCHEMA_0_4/common.xsd');


  		




  23
  
  
    
INSERT INTO xml_catalog (entry_type, public_id, system_id)


  		




  24
  
  
    
  VALUES ('Schema', 'http://www.loc.gov/METS/', '/schema/D1_SCHEMA_0_4/dryadMetsAny.xsd');


  		




  25
  23
  
    
  


  		




  26
  24
  
    
/*


  		




  27
  25
  
    
 * update the database version


  		












  

    
      src/edu/ucsb/nceas/metacat/dataone/CrudService.java
    
  





  61
  61
  
    
import org.jibx.runtime.IUnmarshallingContext;


  		




  62
  62
  
    
import org.jibx.runtime.JiBXException;


  		




  63
  63
  
    

  		




  
  64
  
    
import org.dataone.service.types.Identifier;


  		




  
  65
  
    

  		




  64
  66
  
    
import com.gc.iotools.stream.is.InputStreamFromOutputStream;


  		




  65
  67
  
    

  		




  66
  68
  
    
import edu.ucsb.nceas.metacat.AccessionNumberException;


  		












Also available in:  Unified diff