This is an old revision of the document!
The page contains the details about the changes that were made to old components during the development of v4.3.0 compared with what existed in v4.2.x. It does not include the brand new modules, focusing on how to upgrade database and configuration file from v4.2.x to run with Kamailio devel.
If you look for the guidelines to upgrade to previous stable release, see:
Following tokens are used to mark the changes:
There are several changes to the database structure, in short:
Run following SQL statements in MySQL client to upgrade database structure from v4.2 to v4.3:
-- table: location ALTER TABLE location ADD COLUMN server_id INT(11) DEFAULT 0 NOT NULL; ALTER TABLE location ADD COLUMN connection_id INT(11) DEFAULT 0 NOT NULL; ALTER TABLE location ADD COLUMN keepalive INT(11) DEFAULT 0 NOT NULL; DELETE FROM version WHERE TABLE_NAME='location'; INSERT INTO version (`table_name`, `table_version`) VALUES ('location','7'); -- table: presentity ALTER TABLE presentity ADD COLUMN priority INT(11) DEFAULT 0 NOT NULL; DELETE FROM version WHERE TABLE_NAME='presentity'; INSERT INTO version (`table_name`, `table_version`) VALUES ('presentity','4'); -- table: sip_trace ALTER TABLE sip_trace ADD COLUMN totag VARCHAR(64) DEFAULT '' NOT NULL; UPDATE version SET table_version='4' WHERE TABLE_NAME='sip_trace'; -- table: acc_cdrs -- For previous values -- STRING -> DATETIME ?? -- STRING -> FLOAT ?? ALTER TABLE acc_cdrs MODIFY COLUMN start_time DATETIME DEFAULT '2000-01-01 00:00:00' NOT NULL; ALTER TABLE acc_cdrs MODIFY COLUMN end_time DATETIME DEFAULT '2000-01-01 00:00:00' NOT NULL; ALTER TABLE acc_cdrs MODIFY COLUMN duration FLOAT(10,3) DEFAULT 0 NOT NULL; UPDATE version SET table_version='2' WHERE TABLE_NAME='acc_cdrs'; -- table: silo ALTER TABLE silo ALTER COLUMN body DROP DEFAULT; ALTER TABLE silo ALTER COLUMN extra_hdrs DROP DEFAULT; UPDATE version SET table_version='8' WHERE TABLE_NAME='silo';