Differences

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

--- install:3.1.x-to-3.2.x [2011/09/27 19:50] – [modules/lcr] miconda
+++ install:3.1.x-to-3.2.x [2012/03/02 22:26] (current) – Fix typo acc -> htable. tr
@@ 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 70: / Line 75: @@
 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";

Trace: