Project

General

Profile

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
 * 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
/*
14
 * update the database version
15
 */
16
UPDATE db_version SET status=0;
17

    
18
INSERT INTO db_version (version, status, date_created) 
19
  VALUES ('2.6.0', 1, CURRENT_DATE);
(97-97/103)