User Tools

Site Tools


install:upgrade:stable-to-devel

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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:43]
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 '-' (dash/minus) in the name were renamed to remove it, respectively:
 +
 +  * 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 int(11) NOT NULL DEFAULT '0'; 
-  ADD COLUMN server_id INTEGER DEFAULT 0 NOT NULL, +ALTER TABLE sca_subscriptions DROP INDEX sca_expires_idx; # was INDEX (expires) 
-  DROP INDEX sca_expires_idx, +ALTER TABLE sca_subscriptions ADD INDEX sca_expires_idx (server_id,expires);
-  ADD INDEX sca_expires_idx (server_id, expires);+
 UPDATE version SET table_version=2 WHERE table_name="sca_subscriptions"; UPDATE version SET table_version=2 WHERE table_name="sca_subscriptions";
 +
 +--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 ''; -- was varchar(25) NOT NULL DEFAULT ''
 +ALTER TABLE subscriber CHANGE COLUMN ha1 ha1 varchar(128) NOT NULL DEFAULT ''; -- was varchar(64) NOT NULL DEFAULT ''
 +ALTER TABLE subscriber CHANGE COLUMN ha1b ha1b varchar(128) NOT NULL DEFAULT ''; -- was varchar(64) NOT NULL DEFAULT ''
 +
 +--table: uacreg
 +ALTER TABLE uacreg CHANGE COLUMN auth_proxy auth_proxy varchar(128) NOT NULL DEFAULT ''; -- was varchar(64) NOT NULL DEFAULT ''
 +ALTER TABLE uacreg CHANGE COLUMN l_domain l_domain varchar(64) NOT NULL DEFAULT ''; -- was varchar(128) NOT NULL DEFAULT ''
 +ALTER TABLE uacreg CHANGE COLUMN r_domain r_domain varchar(64) NOT NULL DEFAULT ''; -- was varchar(128) NOT NULL DEFAULT ''
 +ALTER TABLE uacreg ADD COLUMN auth_ha1 varchar(128) NOT NULL DEFAULT '';
 +
 </code> </code>
install/upgrade/stable-to-devel.txt · Last modified: 2022/04/15 08:39 by miconda