install:upgrade:5.2.x-to-5.3.0
Differences
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 ''; -- # was varchar(128) NOT NULL DEFAULT '' | ALTER TABLE topos_t CHANGE COLUMN a_srcaddr a_srcaddr varchar(255) NOT NULL DEFAULT ''; -- # was varchar(128) NOT NULL DEFAULT '' | ||
| + | -- uacreg table | ||
| ALTER TABLE uacreg CHANGE COLUMN auth_proxy auth_proxy varchar(255) NOT NULL DEFAULT ''; -- # was varchar(128) NOT NULL DEFAULT '' | ALTER TABLE uacreg CHANGE COLUMN auth_proxy auth_proxy varchar(255) NOT NULL DEFAULT ''; -- # was varchar(128) 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='uacreg'; | ||
| + | |||
| + | -- usr_preferences table | ||
| ALTER TABLE usr_preferences CHANGE COLUMN username username varchar(255) NOT NULL DEFAULT '0'; -- # was varchar(128) NOT NULL DEFAULT '0' | ALTER TABLE usr_preferences CHANGE COLUMN username username varchar(255) NOT NULL DEFAULT '0'; -- # was varchar(128) NOT NULL DEFAULT '0' | ||
| + | |||
| + | -- 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 | ||
| </code> | </code> | ||
install/upgrade/5.2.x-to-5.3.0.txt ยท Last modified: 2019/10/17 21:46 by amessina_messinet.com
Page Tools
