Project

General

Profile

« Previous | Next » 

Revision 9846

Added by Jing Tao almost 8 years ago

Add the update 2.7.1 sql to the trunk.

View differences:

src/upgrade-db-to-2.7.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
/*
8
 * update the database version
9
 */
10
UPDATE db_version SET status=0;
11

  
12
INSERT INTO db_version (version, status, date_created) 
13
  VALUES ('2.7.1', 1, CURRENT_DATE);

Also available in: Unified diff