Differences

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

--- install:3.1.x-to-3.2.x [2011/10/03 23:44]
miconda [modules_k/acc]
+++ 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 75: / 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: