This shows you the differences between two versions of the page.
Next revision Both sides next revision | |||
install:upgrade:5.1.x-to-5.2.0 [2018/11/23 09:35] miconda created |
install:upgrade:5.1.x-to-5.2.0 [2018/11/28 08:56] miconda [MySQL Database Structure] |
||
---|---|---|---|
Line 82: | Line 82: | ||
<code sql> | <code sql> | ||
+ | -- location table - optional update | ||
+ | ALTER TABLE location_attrs CHANGE COLUMN avalue avalue varchar(512) NOT NULL DEFAULT ''; | ||
+ | |||
+ | -- presentity table | ||
+ | ALTER TABLE presentity CHANGE COLUMN etag etag varchar(128) NOT NULL; | ||
ALTER TABLE presentity ADD COLUMN ruid VARCHAR(64); | ALTER TABLE presentity ADD COLUMN ruid VARCHAR(64); | ||
CREATE UNIQUE INDEX ruid_idx ON presentity (ruid); | CREATE UNIQUE INDEX ruid_idx ON presentity (ruid); | ||
UPDATE version SET table_version=5 WHERE table_name=' | UPDATE version SET table_version=5 WHERE table_name=' | ||
+ | |||
+ | -- pua table - optional update | ||
+ | ALTER TABLE pua CHANGE COLUMN etag etag varchar(128) NOT NULL; | ||
+ | |||
+ | -- subscriber table - optional update | ||
+ | ALTER TABLE subscriber DROP COLUMN rpid; | ||
+ | ALTER TABLE subscriber DROP COLUMN email_address; | ||
+ | |||
+ | -- xcap table - optional update | ||
+ | ALTER TABLE xcap CHANGE COLUMN etag etag varchar(128) NOT NULL; | ||
</ | </ |