Differences

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

--- install:3.1.x-to-3.2.x [2011/09/26 11:36]
miconda
+++ install:3.1.x-to-3.2.x [2012/03/02 23:26] (current)
tr Fix typo acc -> htable.
@@ Line 12: / Line 12: @@
     * callid column in has now the size varchar(255)
-==== modules_k/acc ====
+==== modules_k/htable ====
   * table **htable**
@@ Line 18: / Line 18: @@
     * new column: expires INT DEFAULT 0 NOT NULL
+==== modules_k/dialog ====
+  * table **dialog_vars**
+    * new table that holds per-dialog custom values
+    * the new table has to be created, see SQL command below
 ==== modules/lcr ====
@@ Line 24: / Line 29: @@
     * Renamed lcr_gw table column 'tag' to 'prefix'.
     * Added new lcr_gw table column 'tag': tag VARCHAR(64) DEFAULT NULL.
+    * Dropped unique index lcr_id_ip_addr_port_hostname_idx
+    * Added new index: CREATE INDEX lcr_id_idx ON lcr_gw (lcr_id);
     * Script modules/lcr/utils/lcr_upgrade_from_3.1.sh can be used to perform the upgrade of lcr_gw table.
@@ Line 59: / Line 66: @@
     * doc column has the type: MEDIUMBLOB
     * doc_uri column has now the size varchar(255)
+==== SQL Commands ====
+You can use next SQL commands (made for MySQL) to update the structure of existing tables in v3.1.x for v3.2.0:
+<code sql>
+ALTER TABLE acc MODIFY callid VARCHAR(255) DEFAULT '' NOT NULL;
+ALTER TABLE missed_calls MODIFY callid VARCHAR(255) DEFAULT '' NOT NULL;
+INSERT INTO version (table_name, table_version) values ('dialog_vars','1');
+CREATE TABLE dialog_vars (
+    id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
+    hash_entry INT(10) UNSIGNED NOT NULL,
+    hash_id INT(10) UNSIGNED NOT NULL,
+    dialog_key VARCHAR(128) NOT NULL,
+    dialog_value VARCHAR(512) NOT NULL
+) ENGINE=MyISAM;
+CREATE INDEX hash_idx ON dialog_vars (hash_entry, hash_id);
+UPDATE version SET table_version=2 WHERE table_name="htable";
+ALTER TABLE htable MODIFY key_value VARCHAR(128) DEFAULT '' NOT NULL;
+ALTER TABLE htable ADD COLUMN expires INT DEFAULT 0 NOT NULL;
+UPDATE version SET table_version=2 WHERE table_name="lcr_gw";
+ALTER TABLE lcr_gw DROP INDEX lcr_id_ip_addr_port_hostname_idx;
+ALTER TABLE lcr_gw ADD prefix VARCHAR(16) DEFAULT NULL;
+ALTER TABLE lcr_gw MODIFY tag VARCHAR(64) DEFAULT NULL;
+CREATE INDEX lcr_id_idx ON lcr_gw (lcr_id);
+ALTER TABLE active_watchers MODIFY callid VARCHAR(255) NOT NULL,
+UPDATE version SET table_version=7 WHERE table_name="pua";
+ALTER TABLE pua MODIFY pres_id VARCHAR(255) NOT NULL;
+ALTER TABLE pua MODIFY call_id VARCHAR(255) NOT NULL;
+UPDATE version SET table_version=1 WHERE table_name="rls_presentity";
+ALTER TABLE rls_presentity MODIFY content_type VARCHAR(255) NOT NULL;
+ALTER TABLE rls_presentity MODIFY callid VARCHAR(255) NOT NULL;
+ALTER TABLE rls_presentity MODIFY contact VARCHAR(128) NOT NULL;
+UPDATE version SET table_version=3 WHERE table_name="sip_trace";
+ALTER TABLE sip_trace ADD COLUMN time_us INT UNSIGNED DEFAULT 0 NOT NULL;
+ALTER TABLE sip_trace MODIFY msg MEDIUMTEXT NOT NULL;
+UPDATE version SET table_version=4 WHERE table_name="xcap";
+ALTER TABLE xcap MODIFY doc MEDIUMBLOB NOT NULL;
+ALTER TABLE xcap MODIFY doc_uri VARCHAR(255) NOT NULL;
+</code>
 ===== Modules =====
@@ Line 72: / Line 129: @@
   * [to|from]_any_gw() syntax has changed from [to|from]_any_gw([ip_addr]) to [to|from]_any_gw([ip_addr, proto]).
+==== modules/rtpproxy ====
+  * force_rtp_proxy() removed
+    * use rtpproxy_offer() when it is SDP offer (mainly on INVITE request) and rtpproxy_answer() when it is SDP answer (mainly on INVITE replies)
+    * new alternative is to use rtpproxy_manage() which does the detection of SDP offer/answer internally
 ==== modules/utils ====
   * New function is_int(pvar) that returns true if pvar argument has integer value.

Trace:

Differences

Navigation

Search

Toolbox

QR Code