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/02/26 23:43] miconda [MySQL Database Structure] |
install:upgrade:stable-to-devel [2017/02/26 23:49] miconda [MySQL Database Structure] |
||
---|---|---|---|
Line 87: | Line 87: | ||
ALTER TABLE subscriber CHANGE COLUMN ha1 ha1 varchar(128) NOT NULL DEFAULT ''; | ALTER TABLE subscriber CHANGE COLUMN ha1 ha1 varchar(128) NOT NULL DEFAULT ''; | ||
ALTER TABLE subscriber CHANGE COLUMN ha1b ha1b varchar(128) NOT NULL DEFAULT ''; | ALTER TABLE subscriber CHANGE COLUMN ha1b ha1b varchar(128) NOT NULL DEFAULT ''; | ||
+ | UPDATE version SET table_version=7 WHERE table_name=" | ||
+ | |||
--table: uacreg | --table: uacreg | ||
Line 93: | Line 95: | ||
ALTER TABLE uacreg CHANGE COLUMN r_domain r_domain varchar(64) NOT NULL DEFAULT ''; | ALTER TABLE uacreg CHANGE COLUMN r_domain r_domain varchar(64) NOT NULL DEFAULT ''; | ||
ALTER TABLE uacreg ADD COLUMN auth_ha1 varchar(128) NOT NULL DEFAULT ''; | ALTER TABLE uacreg ADD COLUMN auth_ha1 varchar(128) NOT NULL DEFAULT ''; | ||
+ | UPDATE version SET table_version=3 WHERE table_name=" | ||
</ | </ |