Project

General

Profile

Revision 9794

Added by Jing Tao over 4 years ago

Add a upgrade script for 2.8.0

View differences:

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

Also available in: Unified diff