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 v3.3.0 (unreleased) compared with what existed in v3.2.x. It does not include the brand new modules, focusing on how to upgrade database and configuration file from v3.2.x to run with Kamailio v3.3.0.
These sections presents notes, listed by modules, about the structure of database tables that existed in v3.2.x and changed during development of v3.3.0.
You can use next SQL commands (made for MySQL) to update the structure of existing tables in v3.2.x for v3.3.0:
ALTER TABLE lcr_gw MODIFY ip_addr VARCHAR(47) NOT NULL;
CREATE TABLE domain_attrs ( id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL, did VARCHAR(64) NOT NULL, name VARCHAR(32) NOT NULL, TYPE INT UNSIGNED NOT NULL, VALUE VARCHAR(255) NOT NULL, last_modified DATETIME DEFAULT '1900-01-01 00:00:01' NOT NULL, CONSTRAINT domain_attrs_idx UNIQUE (did, name, VALUE) ) ENGINE=MyISAM; INSERT INTO version (TABLE_NAME, table_version) VALUES ('domain_attrs','1');
ALTER TABLE DOMAIN ADD did VARCHAR(64) DEFAULT NULL; UPDATE version SET table_version=2 WHERE TABLE_NAME='domain';
This is the translation of the above script for PostgreSQL (should work with 9.1.1, but is untested!)
ALTER TABLE lcr_gw ALTER COLUMN ip_addr TYPE VARCHAR(47);