This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | Last revision Both sides next revision | ||
install:upgrade:5.2.x-to-5.3.0 [2019/09/16 10:35] miconda [MySQL Database Structure] |
install:upgrade:5.2.x-to-5.3.0 [2019/09/16 10:39] miconda [MySQL Database Structure] |
||
---|---|---|---|
Line 138: | Line 138: | ||
ALTER TABLE topos_t CHANGE COLUMN a_srcaddr a_srcaddr varchar(255) NOT NULL DEFAULT ''; | ALTER TABLE topos_t CHANGE COLUMN a_srcaddr a_srcaddr varchar(255) NOT NULL DEFAULT ''; | ||
+ | -- uacreg table | ||
ALTER TABLE uacreg CHANGE COLUMN auth_proxy auth_proxy varchar(255) NOT NULL DEFAULT ''; | ALTER TABLE uacreg CHANGE COLUMN auth_proxy auth_proxy varchar(255) NOT NULL DEFAULT ''; | ||
ALTER TABLE uacreg ADD COLUMN socket varchar(128) NOT NULL DEFAULT ''; | ALTER TABLE uacreg ADD COLUMN socket varchar(128) NOT NULL DEFAULT ''; | ||
+ | UPDATE version SET table_version=4 WHERE TABLE_NAME=' | ||
+ | |||
+ | -- usr_preferences table | ||
ALTER TABLE usr_preferences CHANGE COLUMN username username varchar(255) NOT NULL DEFAULT ' | ALTER TABLE usr_preferences CHANGE COLUMN username username varchar(255) NOT NULL DEFAULT ' | ||
+ | |||
+ | -- watchers table | ||
ALTER TABLE watchers CHANGE COLUMN presentity_uri presentity_uri varchar(255) NOT NULL; -- # was varchar(128) NOT NULL | ALTER TABLE watchers CHANGE COLUMN presentity_uri presentity_uri varchar(255) NOT NULL; -- # was varchar(128) NOT NULL | ||
</ | </ |