User Tools

Site Tools


install:upgrade:4.1.x-to-4.2.0

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Last revision Both sides next revision
install:upgrade:4.1.x-to-4.2.0 [2015/01/13 16:05]
klaus3000 [tm]
install:upgrade:4.1.x-to-4.2.0 [2015/10/09 13:08]
klaus3000
Line 80: Line 80:
  
 </code> </code>
 +==== Upgrade Old Postgresql Database Structure ====
 +
 +Run following SQL statements in psql client to upgrade database structure from v4.1 to v4.2:
 +
 +<code>
 +-- table: acc
 +ALTER TABLE acc ALTER COLUMN sip_reason TYPE VARCHAR(128);
 +DELETE FROM version WHERE TABLE_NAME='acc';
 +INSERT INTO version (`table_name`, `table_version`) VALUES ('acc','5');
 + 
 +-- table: dialplan
 +ALTER TABLE dialplan ALTER COLUMN repl_exp TYPE VARCHAR(64); 
 +ALTER TABLE dialplan ALTER COLUMN attrs TYPE VARCHAR(64);
 +DELETE FROM version WHERE TABLE_NAME='dialplan';
 +INSERT INTO version (table_name, table_version) VALUES ('dialplan','2');
 + 
 +-- table: missed_calls
 +ALTER TABLE missed_calls ALTER COLUMN sip_reason TYPE VARCHAR(128);
 +DELETE FROM version WHERE TABLE_NAME='missed_calls';
 +INSERT INTO version (table_name, table_version) VALUES ('missed_calls','4');
 +</code>
 +
install/upgrade/4.1.x-to-4.2.0.txt ยท Last modified: 2015/10/09 13:09 by klaus3000