install:upgrade:5.2.x-to-5.3.0
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revision | Last revisionBoth sides next revision | ||
| install:upgrade:5.2.x-to-5.3.0 [2019/09/16 08:35] – [MySQL Database Structure] miconda | install:upgrade:5.2.x-to-5.3.0 [2019/09/16 08:39] – [MySQL Database Structure] miconda | ||
|---|---|---|---|
| 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 | ||
| </ | </ | ||
install/upgrade/5.2.x-to-5.3.0.txt · Last modified: 2019/10/17 19:46 by amessina_messinet.com