Differences

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

--- install:upgrade:5.0.x-to-5.1.0 [2017/11/18 16:05] – miconda
+++ install:upgrade:5.0.x-to-5.1.0 [2017/12/08 19:38] – [MySQL Database Structure] miconda
@@ Line 34: / Line 34: @@
 ===== Database =====
+  * increased size of dialplan table repl_exp field to 256 chars
 ==== MySQL Database Structure ====
@@ Line 47: / Line 47: @@
 ALTER TABLE location MODIFY contact VARCHAR(512) NOT NULL DEFAULT '';
 UPDATE version SET table_version='9' WHERE table_name='location';
+</code>
+<code sql>
+ALTER TABLE domain_attrs DROP INDEX domain_attrs_idx; # was UNIQUE (did,name,value)
+ALTER TABLE domain_attrs ADD INDEX domain_attrs_idx (did,name);
+-- ALTER TABLE lcr_rule ADD COLUMN mt_tvalue varchar(128) DEFAULT NULL;
+-- ALTER TABLE location CHANGE COLUMN contact contact varchar(512) NOT NULL DEFAULT ''; # was varchar(255) NOT NULL DEFAULT ''
+ALTER TABLE topos_d ADD INDEX b_uuid_idx (b_uuid);
+ALTER TABLE topos_d ADD INDEX a_uuid_idx (a_uuid);
+ALTER TABLE topos_t ADD INDEX a_uuid_idx (a_uuid);
+ALTER TABLE topos_t ADD INDEX x_vbranch_idx (x_vbranch);
 </code>