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/07 18:07] miconda [Database] |
install:upgrade:5.0.x-to-5.1.0 [2017/12/08 20:38] miconda [MySQL Database Structure] |
||
---|---|---|---|
Line 47: | Line 47: | ||
ALTER TABLE location MODIFY contact VARCHAR(512) NOT NULL DEFAULT ''; | ALTER TABLE location MODIFY contact VARCHAR(512) NOT NULL DEFAULT ''; | ||
UPDATE version SET table_version=' | UPDATE version SET table_version=' | ||
+ | </ | ||
+ | |||
+ | <code sql> | ||
+ | ALTER TABLE domain_attrs DROP INDEX domain_attrs_idx; | ||
+ | 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 ''; | ||
+ | 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); | ||
</ | </ |