Project

General

Profile

« Previous | Next » 

Revision 8655

Added by ben leinfelder almost 11 years ago

simple upgrade scripts for version 2.4.1

View differences:

src/upgrade-db-to-2.4.1-postgres.sql
1 

  		




  
  2
  
    
/*


  		




  
  3
  
    
 * update the database version


  		




  
  4
  
    
 */


  		




  
  5
  
    
UPDATE db_version SET status=0;


  		




  
  6
  
    

  		




  
  7
  
    
INSERT INTO db_version (version, status, date_created) 


  		




  
  8
  
    
  VALUES ('2.4.1', 1, CURRENT_DATE);


  		




  0
  9
  
    

  		












  

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





  
  1
  
    

  		




  
  2
  
    
/*


  		




  
  3
  
    
 * update the database version


  		




  
  4
  
    
 */


  		




  
  5
  
    
UPDATE db_version SET status=0;


  		




  
  6
  
    

  		




  
  7
  
    
INSERT INTO db_version (version, status, date_created) 


  		




  
  8
  
    
  VALUES ('2.4.1', 1, CURRENT_DATE);


  		




  0
  9
  
    

  		












Also available in:  Unified diff