This shows you the differences between two versions of the page.
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: | ||
</ | </ | ||
+ | ==== Upgrade Old Postgresql Database Structure ==== | ||
+ | |||
+ | Run following SQL statements in psql client to upgrade database structure from v4.1 to v4.2: | ||
+ | |||
+ | < | ||
+ | -- table: acc | ||
+ | ALTER TABLE acc ALTER COLUMN sip_reason TYPE VARCHAR(128); | ||
+ | DELETE FROM version WHERE TABLE_NAME=' | ||
+ | INSERT INTO version (`table_name`, | ||
+ | |||
+ | -- 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=' | ||
+ | INSERT INTO version (table_name, | ||
+ | |||
+ | -- table: missed_calls | ||
+ | ALTER TABLE missed_calls ALTER COLUMN sip_reason TYPE VARCHAR(128); | ||
+ | DELETE FROM version WHERE TABLE_NAME=' | ||
+ | INSERT INTO version (table_name, | ||
+ | </ | ||
+ |