This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
install:upgrade:3.3.x-to-4.0.0 [2013/01/23 14:44] miconda [MySQL - Updates to old database tables] |
install:upgrade:3.3.x-to-4.0.0 [2014/02/26 16:54] miconda |
||
---|---|---|---|
Line 7: | Line 7: | ||
These sections presents notes, listed by modules, about changes that need to be made to Kamailio configuration file when upgrading from Kamailio v3.3.x to devel. | These sections presents notes, listed by modules, about changes that need to be made to Kamailio configuration file when upgrading from Kamailio v3.3.x to devel. | ||
- | ==== modules/tm ==== | + | ==== kex ==== |
+ | |||
+ | * km_append_branch() has been replaced with append_branch() from **corex** module | ||
+ | |||
+ | ==== tm ==== | ||
* Changed value of module parameter contacts_avp from AVP definition to XAVP name (string). | * Changed value of module parameter contacts_avp from AVP definition to XAVP name (string). | ||
Line 20: | Line 24: | ||
<code sql> | <code sql> | ||
- | ALTER TABLE active_watchers DROP INDEX active_watchers_pres; | ||
- | ALTER TABLE active_watchers ADD INDEX active_watchers_pres (presentity_uri, | ||
ALTER TABLE address CHANGE COLUMN ip_addr ip_addr varchar(50) NOT NULL; # was varchar(48) NOT NULL | ALTER TABLE address CHANGE COLUMN ip_addr ip_addr varchar(50) NOT NULL; # was varchar(48) NOT NULL | ||
+ | |||
ALTER TABLE aliases CHANGE COLUMN expires expires datetime NOT NULL DEFAULT ' | ALTER TABLE aliases CHANGE COLUMN expires expires datetime NOT NULL DEFAULT ' | ||
ALTER TABLE aliases ADD UNIQUE ruid_idx (ruid); | ALTER TABLE aliases ADD UNIQUE ruid_idx (ruid); | ||
+ | |||
ALTER TABLE lcr_gw CHANGE COLUMN ip_addr ip_addr varchar(50) DEFAULT NULL; # was varchar(47) DEFAULT NULL | ALTER TABLE lcr_gw CHANGE COLUMN ip_addr ip_addr varchar(50) DEFAULT NULL; # was varchar(47) DEFAULT NULL | ||
+ | |||
ALTER TABLE location CHANGE COLUMN path path varchar(512) DEFAULT NULL; # was varchar(128) DEFAULT NULL | ALTER TABLE location CHANGE COLUMN path path varchar(512) DEFAULT NULL; # was varchar(128) DEFAULT NULL | ||
ALTER TABLE location CHANGE COLUMN expires expires datetime NOT NULL DEFAULT ' | ALTER TABLE location CHANGE COLUMN expires expires datetime NOT NULL DEFAULT ' | ||
ALTER TABLE location ADD UNIQUE ruid_idx (ruid); | ALTER TABLE location ADD UNIQUE ruid_idx (ruid); | ||
ALTER TABLE location ADD INDEX expires_idx (expires); | ALTER TABLE location ADD INDEX expires_idx (expires); | ||
+ | |||
+ | ALTER TABLE active_watchers DROP INDEX active_watchers_pres; | ||
+ | ALTER TABLE active_watchers ADD INDEX active_watchers_pres (presentity_uri, | ||
+ | |||
ALTER TABLE pua DROP INDEX tmp_record2_idx; | ALTER TABLE pua DROP INDEX tmp_record2_idx; | ||
ALTER TABLE pua DROP INDEX tmp_dlg2_idx; | ALTER TABLE pua DROP INDEX tmp_dlg2_idx; | ||
Line 39: | Line 48: | ||
ALTER TABLE pua DROP INDEX tmp_dlg1_idx; | ALTER TABLE pua DROP INDEX tmp_dlg1_idx; | ||
ALTER TABLE pua ADD INDEX record_idx (pres_id); | ALTER TABLE pua ADD INDEX record_idx (pres_id); | ||
+ | |||
ALTER TABLE rls_watchers DROP INDEX rls_watchers_delete; | ALTER TABLE rls_watchers DROP INDEX rls_watchers_delete; | ||
+ | |||
ALTER TABLE version ADD UNIQUE table_name_idx (table_name); | ALTER TABLE version ADD UNIQUE table_name_idx (table_name); | ||
Line 46: | Line 57: | ||
ruid varchar(64) NOT NULL DEFAULT '', | ruid varchar(64) NOT NULL DEFAULT '', | ||
username varchar(64) NOT NULL DEFAULT '', | username varchar(64) NOT NULL DEFAULT '', | ||
- | domain varchar(64) DEFAULT NULL, | + | |
aname varchar(64) NOT NULL DEFAULT '', | aname varchar(64) NOT NULL DEFAULT '', | ||
atype int(11) NOT NULL DEFAULT ' | atype int(11) NOT NULL DEFAULT ' | ||
Line 177: | Line 188: | ||
) ENGINE=MyISAM DEFAULT CHARSET=latin1; | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | ||
</ | </ | ||
+ | |||
+ | ===== SER Modules ===== | ||
+ | |||
+ | SER modules that had no equivalent in Kamailio were moved to **modules/ | ||
+ | |||
+ | * auth_db => uid_auth_db | ||
+ | * avp_db => uid_auth_db | ||
+ | * domain => uid_domain | ||
+ | * gflags => uid_gflags | ||
+ | * uri_db => uid_uri_db |