Project

General

Profile

« Previous | Next » 

Revision 9449

Added by Jing Tao about 9 years ago

Add the sql file for the upgrading.

View differences:

src/upgrade-db-to-2.5.1-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.5.1', 1, CURRENT_DATE);


  		












  

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





  
  1
  
    
/*


  		




  
  2
  
    
 * Ensure xml_catalog sequence is at table max


  		




  
  3
  
    
 */


  		




  
  4
  
    
SELECT setval('xml_catalog_id_seq', (SELECT max(catalog_id) from xml_catalog));


  		




  
  5
  
    

  		




  
  6
  
    
/*


  		




  
  7
  
    
 * update the database version


  		




  
  8
  
    
 */


  		




  
  9
  
    
UPDATE db_version SET status=0;


  		




  
  10
  
    

  		




  
  11
  
    
INSERT INTO db_version (version, status, date_created) 


  		




  
  12
  
    
  VALUES ('2.5.1', 1, CURRENT_DATE);


  		












  

    
      src/upgrade-db-to-2.6.0-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.6.0', 1, CURRENT_DATE);


  		












  

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





  
  1
  
    
/*


  		




  
  2
  
    
 * Ensure xml_catalog sequence is at table max


  		




  
  3
  
    
 */


  		




  
  4
  
    
SELECT setval('xml_catalog_id_seq', (SELECT max(catalog_id) from xml_catalog));


  		




  
  5
  
    

  		




  
  6
  
    
/*


  		




  
  7
  
    
 * update the database version


  		




  
  8
  
    
 */


  		




  
  9
  
    
UPDATE db_version SET status=0;


  		




  
  10
  
    

  		




  
  11
  
    
INSERT INTO db_version (version, status, date_created) 


  		




  
  12
  
    
  VALUES ('2.6.0', 1, CURRENT_DATE);


  		












Also available in:  Unified diff