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:stable-to-devel [2017/05/15 17:35] jih [MySQL Database Structure] |
install:upgrade:stable-to-devel [2017/09/14 14:46] jih [MySQL Database Structure] |
||
---|---|---|---|
Line 42: | Line 42: | ||
ALTER TABLE lcr_rule ADD COLUMN mt_tvalue VARCHAR(128) DEFAULT NULL AFTER request_uri; | ALTER TABLE lcr_rule ADD COLUMN mt_tvalue VARCHAR(128) DEFAULT NULL AFTER request_uri; | ||
UPDATE version SET table_version=' | UPDATE version SET table_version=' | ||
+ | </ | ||
+ | |||
+ | <code sql> | ||
+ | ALTER TABLE location MODIFY contact VARCHAR(512) NOT NULL DEFAULT ''; | ||
+ | UPDATE version SET table_version=' | ||
</ | </ |