This shows you the differences between two versions of the page.
Next revision | Previous revision Next revision Both sides next revision | ||
install:upgrade:5.0.x-to-5.1.0 [2017/11/18 17:02] miconda created |
install:upgrade:5.0.x-to-5.1.0 [2017/12/08 20:38] miconda [MySQL Database Structure] |
||
---|---|---|---|
Line 1: | Line 1: | ||
====== Upgrade Kamailio from v5.0.x to v5.1.0 (stable) ====== | ====== Upgrade Kamailio from v5.0.x to v5.1.0 (stable) ====== | ||
- | The page contains the details about the changes that were made to old components during the development of v5.1.0 compared with what existed in v5.0.x. It does not include the brand new modules, focusing on how to upgrade database and configuration file from v5.0.x to run with Kamailio | + | The page contains the details about the changes that were made to old components during the development of v5.1.0 compared with what existed in v5.0.x. It does not include the brand new modules, focusing on how to upgrade database and configuration file from v5.0.x to run with Kamailio |
===== Previous Stable Release ===== | ===== Previous Stable Release ===== | ||
Line 34: | Line 34: | ||
===== Database ===== | ===== Database ===== | ||
+ | * increased size of dialplan table repl_exp field to 256 chars | ||
==== MySQL Database Structure ==== | ==== MySQL Database Structure ==== | ||
Line 47: | Line 47: | ||
ALTER TABLE location MODIFY contact VARCHAR(512) NOT NULL DEFAULT ''; | ALTER TABLE location MODIFY contact VARCHAR(512) NOT NULL DEFAULT ''; | ||
UPDATE version SET table_version=' | UPDATE version SET table_version=' | ||
+ | </ | ||
+ | |||
+ | <code sql> | ||
+ | ALTER TABLE domain_attrs DROP INDEX domain_attrs_idx; | ||
+ | ALTER TABLE domain_attrs ADD INDEX domain_attrs_idx (did,name); | ||
+ | -- ALTER TABLE lcr_rule ADD COLUMN mt_tvalue varchar(128) DEFAULT NULL; | ||
+ | -- ALTER TABLE location CHANGE COLUMN contact contact varchar(512) NOT NULL DEFAULT ''; | ||
+ | ALTER TABLE topos_d ADD INDEX b_uuid_idx (b_uuid); | ||
+ | ALTER TABLE topos_d ADD INDEX a_uuid_idx (a_uuid); | ||
+ | ALTER TABLE topos_t ADD INDEX a_uuid_idx (a_uuid); | ||
+ | ALTER TABLE topos_t ADD INDEX x_vbranch_idx (x_vbranch); | ||
</ | </ |