Project

General

Profile

« Previous | Next » 

Revision 9483

Added by Jing Tao over 7 years ago

Add a policy_id in the smReplicationPolicy table to help preserver the order of the nodes list.

View differences:

upgrade-db-to-2.6.0-postgres.sql
4 4 
SELECT setval('xml_catalog_id_seq', (SELECT max(catalog_id) from xml_catalog));
5 5 

  		




  6
  6
  
    
/*


  		




  
  7
  
    
 * Add a new column policy_id in the smReplicationPolicy table


  		




  
  8
  
    
 */


  		




  
  9
  
    
CREATE SEQUENCE policy_id_seq;


  		




  
  10
  
    
ALTER TABLE smReplicationPolicy ADD COLUMN policy_id INT8 default nextval('policy_id_seq');


  		




  
  11
  
    
UPDATE smReplicationPolicy SET policy_id=nextval('policy_id_seq');


  		




  
  12
  
    

  		




  
  13
  
    
/*


  		




  7
  14
  
    
 * update the database version


  		




  8
  15
  
    
 */


  		




  9
  16
  
    
UPDATE db_version SET status=0;


  		












Also available in:  Unified diff