Project

General

Profile

« Previous | Next » 

Revision 6583

Added by ben leinfelder about 13 years ago

drop old identifier when upgrading from 1.9.5 to 2.0.0

View differences:

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

  		




  
  39
  
    
DROP TABLE identifier;


  		




  
  40
  
    

  		




  39
  41
  
    
CREATE TABLE identifier (


  		




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


  		




  41
  43
  
    
   docid  VARCHAR2(250),  -- the local document id #


  		












  

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





  35
  35
  
    
		FOREIGN KEY (guid) REFERENCES systemMetadata


  		




  36
  36
  
    
);


  		




  37
  37
  
    

  		




  
  38
  
    
/*


  		




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


  		




  
  40
  
    
 */


  		




  
  41
  
    
DROP TABLE identifier;


  		




  
  42
  
    
/*


  		




  
  43
  
    
 * Create the new one (DataONE features)


  		




  
  44
  
    
 */


  		




  38
  45
  
    
CREATE TABLE identifier (


  		




  39
  46
  
    
   guid   text,          -- the globally unique string identifier


  		




  40
  47
  
    
   docid  VARCHAR(250),  -- the local document id #


  		












Also available in:  Unified diff