User Tools

Site Tools


install:upgrade:stable-to-devel

Differences

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

Link to this comparison view

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='3' WHERE table_name='lcr_rule'; UPDATE version SET table_version='3' WHERE table_name='lcr_rule';
 +</code>
 +
 +<code sql>
 +ALTER TABLE location MODIFY contact VARCHAR(512) NOT NULL DEFAULT '';
 +UPDATE version SET table_version='9' WHERE table_name='location';
 </code> </code>
install/upgrade/stable-to-devel.txt ยท Last modified: 2022/04/15 08:39 by miconda