Project

General

Profile

« Previous | Next » 

Revision 6945

Added by ben leinfelder over 12 years ago

add "IF EXISTS" clause to identifier table drop in case it does not exist on the given deployment (as is the case on the KNB)

View differences:

src/upgrade-db-to-2.0.0-oracle.sql
37 37 
		FOREIGN KEY (guid) REFERENCES systemMetadata DEFERRABLE
38 38 
);
39 39 

  		




  40
  
  
    
DROP TABLE identifier;


  		




  
  40
  
    
DROP TABLE IF EXISTS identifier;


  		




  41
  41
  
    

  		




  42
  42
  
    
CREATE TABLE identifier (


  		




  43
  43
  
    
   guid   VARCHAR2(2000), -- the globally unique string identifier


  		












  

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





  39
  39
  
    
/*


  		




  40
  40
  
    
 * Remove the old Identifier table (pre-2.0)


  		




  41
  41
  
    
 */


  		




  42
  
  
    
DROP TABLE identifier;


  		




  
  42
  
    
DROP TABLE IF EXISTS identifier;


  		




  43
  43
  
    
/*


  		




  44
  44
  
    
 * Create the new one (DataONE features)


  		




  45
  45
  
    
 */


  		












Also available in:  Unified diff