User Tools

Site Tools


install:upgrade:5.2.x-to-5.3.0

Differences

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

Link to this comparison view

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