Project

General

Profile

« Previous | Next » 

Revision 10302

Added by Jing Tao almost 7 years ago

Add the script to update db.

View differences:

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

Also available in: Unified diff