Project

General

Profile

« Previous | Next » 

Revision 5398

Added by Matt Jones about 14 years ago

Removing drop statements from upgrade scripts because the systemmetadata table
does not exist in 1.9.2, so these objects can't be dropped on upgrade.

View differences:

src/upgrade-db-to-1.10.0-postgres.sql
1 1 
DROP TABLE identifier;
2 2 
DROP SEQUENCE identifier_id_seq;
3 
DROP TABLE systemMetadata;
4 
DROP SEQUENCE systemMetadata_id_seq;
5 3 

  		




  6
  4
  
    
CREATE TABLE systemMetadata (


  		




  7
  5
  
    
   guid   text,          -- the globally unique string identifier


  		












  

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





  1
  1
  
    
DROP SEQUENCE identifier_id_seq;


  		




  2
  2
  
    
DROP TRIGGER identifier_before_insert;


  		




  3
  3
  
    
DROP TABLE identifier;


  		




  4
  
  
    
DROP SEQUENCE systemMetadata_id_seq;


  		




  5
  
  
    
DROP TRIGGER systemMetadata_before_insert;


  		




  6
  
  
    
DROP TABLE systemMetadata;


  		




  7
  4
  
    

  		




  8
  5
  
    
CREATE TABLE systemMetadata (


  		




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


  		












Also available in:  Unified diff