This shows you the differences between two versions of the page.
Next revision | Previous revision Next revision Both sides next revision | ||
install:upgrade:4.2.x-to-4.3.0 [2015/06/03 12:10] miconda created |
install:upgrade:4.2.x-to-4.3.0 [2015/07/20 20:00] miconda [Upgrade Old MySQL Database Structure] |
||
---|---|---|---|
Line 18: | Line 18: | ||
===== Modules ===== | ===== Modules ===== | ||
+ | |||
+ | ==== ctl ==== | ||
+ | |||
+ | * default path to control unix socket file is now: / | ||
+ | |||
+ | ==== mi_fifo ==== | ||
+ | |||
+ | * default path to fifo file is now: / | ||
==== rtpengine ==== | ==== rtpengine ==== | ||
Line 50: | Line 58: | ||
<code sql> | <code sql> | ||
-- table: location | -- table: location | ||
- | ALTER TABLE location ADD COLUMN server_id INT(11) DEFAULT 0 NOT NULL; | + | ALTER TABLE location ADD COLUMN |
- | ALTER TABLE location ADD COLUMN connection_id INT(11) DEFAULT 0 NOT NULL; | + | ALTER TABLE location ADD COLUMN |
- | ALTER TABLE location ADD COLUMN keepalive INT(11) DEFAULT 0 NOT NULL; | + | ALTER TABLE location ADD COLUMN |
- | ALTER TABLE location ADD COLUMN partition INT(11) DEFAULT 0 NOT NULL; | + | ALTER TABLE location ADD COLUMN |
DELETE FROM version WHERE table_name=' | DELETE FROM version WHERE table_name=' | ||
INSERT INTO version (`table_name`, | INSERT INTO version (`table_name`, | ||
-- table: presentity | -- table: presentity | ||
- | ALTER TABLE presentity ADD COLUMN priority INT(11) DEFAULT 0 NOT NULL; | + | ALTER TABLE presentity ADD COLUMN |
DELETE FROM version WHERE table_name=' | DELETE FROM version WHERE table_name=' | ||
INSERT INTO version (`table_name`, | INSERT INTO version (`table_name`, | ||
-- table: sip_trace | -- table: sip_trace | ||
- | ALTER TABLE sip_trace ADD COLUMN totag VARCHAR(64) DEFAULT '' | + | ALTER TABLE sip_trace ADD COLUMN |
UPDATE version SET table_version=' | UPDATE version SET table_version=' | ||