Project

General

Profile

« Previous | Next » 

Revision 8319

Added by Jing Tao over 10 years ago

Add two scripts to update the db to 2.2.2

View differences:

src/upgrade-db-to-2.2.2-oracle.sql
1 
/*
2 
 * update the database version
3 
 */
4 
UPDATE db_version SET status=0;
5 

  		




  
  6
  
    
INSERT INTO db_version (version, status, date_created) 


  		




  
  7
  
    
  VALUES ('2.2.2', 1, CURRENT_DATE);


  		












  

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





  
  1
  
    
/*


  		




  
  2
  
    
 * update the database version


  		




  
  3
  
    
 */


  		




  
  4
  
    
UPDATE db_version SET status=0;


  		




  
  5
  
    

  		




  
  6
  
    
INSERT INTO db_version (version, status, date_created) 


  		




  
  7
  
    
  VALUES ('2.2.2', 1, CURRENT_DATE);


  		












Also available in:  Unified diff