This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
install:upgrade:stable-to-devel [2016/10/06 08:38] linuxmaniac [MySQL Database Structure] |
install:upgrade:stable-to-devel [2017/02/26 23:49] miconda [MySQL Database Structure] |
||
---|---|---|---|
Line 18: | Line 18: | ||
===== Modules ===== | ===== Modules ===== | ||
+ | |||
+ | ==== Removed Modules ==== | ||
+ | |||
+ | === mi_datagram === | ||
+ | |||
+ | The **jsonrpcs** module can be used instead to execute RPC commands over datagram sockets (unix socket file, IPv4 or IPv6). | ||
+ | |||
+ | === mi_fifo === | ||
+ | |||
+ | The **jsonrpcs** module can be used instead to execute RPC commands over a FIFO file. | ||
+ | |||
+ | === mi_xmlrpc === | ||
+ | |||
+ | The **xmlrpc** module can be used instead to execute RPC commands over HTTP/S XMLRPC. | ||
+ | |||
+ | === pua_mi === | ||
+ | |||
+ | The **pua_rpc** module can be used instead to trigger presence PUBLISH or SUBSCRIBE requests via RPC commands. | ||
+ | |||
+ | ==== Renamed Modules ==== | ||
+ | |||
+ | The module that had a ' | ||
+ | |||
+ | * cpl-c => cplc | ||
+ | * janssonrpc-c => jsonrpcc | ||
+ | * jsonrpc-c => jsonrpcc | ||
+ | * jsonrpc-s => jsonrpcs | ||
+ | ===== Internal Libraries ===== | ||
+ | |||
+ | ==== kcore ==== | ||
+ | |||
+ | The library has been removed. | ||
+ | |||
+ | Parts of its code have been removed or merged into other components. | ||
+ | |||
+ | ==== kmi ==== | ||
+ | |||
+ | The library has been removed. | ||
+ | |||
+ | The entire Management Interface (MI) code was removed. Instead of MI commands use RPC commands. The tool **kamctl** is using now RPC commands via **jsonrpcs** module. | ||
===== Core ===== | ===== Core ===== | ||
Line 31: | Line 71: | ||
<code sql> | <code sql> | ||
+ | |||
+ | --table: dialplan | ||
+ | ALTER TABLE dialplan CHANGE COLUMN repl_exp repl_exp varchar(256) NOT NULL; -- was varchar(64) NOT NULL | ||
+ | |||
--table: sca_subscriptions | --table: sca_subscriptions | ||
- | ALTER TABLE sca_subscriptions | + | ALTER TABLE sca_subscriptions ADD COLUMN server_id |
- | | + | ALTER TABLE sca_subscriptions |
- | DROP INDEX sca_expires_idx, | + | ALTER TABLE sca_subscriptions |
- | ADD INDEX sca_expires_idx (server_id, expires); | + | |
UPDATE version SET table_version=2 WHERE table_name=" | UPDATE version SET table_version=2 WHERE table_name=" | ||
+ | |||
+ | --table: subscriber | ||
+ | ALTER TABLE subscriber CHANGE COLUMN rpid rpid varchar(128) DEFAULT NULL; -- was varchar(64) DEFAULT NULL | ||
+ | ALTER TABLE subscriber CHANGE COLUMN email_address email_address varchar(128) DEFAULT NULL; -- was varchar(64) NOT NULL DEFAULT '' | ||
+ | ALTER TABLE subscriber CHANGE COLUMN password password varchar(64) NOT NULL DEFAULT ''; | ||
+ | ALTER TABLE subscriber CHANGE COLUMN ha1 ha1 varchar(128) NOT NULL DEFAULT ''; | ||
+ | ALTER TABLE subscriber CHANGE COLUMN ha1b ha1b varchar(128) NOT NULL DEFAULT ''; | ||
+ | UPDATE version SET table_version=7 WHERE table_name=" | ||
+ | |||
+ | |||
+ | --table: uacreg | ||
+ | ALTER TABLE uacreg CHANGE COLUMN auth_proxy auth_proxy varchar(128) NOT NULL DEFAULT ''; | ||
+ | ALTER TABLE uacreg CHANGE COLUMN l_domain l_domain varchar(64) NOT NULL DEFAULT ''; | ||
+ | ALTER TABLE uacreg CHANGE COLUMN r_domain r_domain varchar(64) NOT NULL DEFAULT ''; | ||
+ | ALTER TABLE uacreg ADD COLUMN auth_ha1 varchar(128) NOT NULL DEFAULT ''; | ||
+ | UPDATE version SET table_version=3 WHERE table_name=" | ||
+ | |||
</ | </ |