User Tools
install:upgrade:5.0.x-to-5.1.0
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | Next revision Both sides next revision | ||
|
install:upgrade:5.0.x-to-5.1.0 [2017/12/09 09:27] miconda [MySQL Database Structure] |
install:upgrade:5.0.x-to-5.1.0 [2017/12/09 09:28] miconda [MySQL Database Structure] |
||
|---|---|---|---|
| Line 50: | Line 50: | ||
| <code sql> | <code sql> | ||
| - | ALTER TABLE active_watchers CHANGE COLUMN reason reason varchar(64) DEFAULT NULL; # was varchar(64) NOT NULL | + | ALTER TABLE active_watchers CHANGE COLUMN reason reason varchar(64) DEFAULT NULL; -- # was varchar(64) NOT NULL |
| - | ALTER TABLE domain_attrs DROP INDEX domain_attrs_idx; | + | ALTER TABLE domain_attrs DROP INDEX domain_attrs_idx; |
| ALTER TABLE domain_attrs ADD INDEX domain_attrs_idx (did,name); | 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 lcr_rule ADD COLUMN mt_tvalue varchar(128) DEFAULT NULL; | ||
install/upgrade/5.0.x-to-5.1.0.txt · Last modified: 2017/12/09 09:30 by miconda
Page Tools
