install:upgrade:5.1.x-to-5.2.0
Differences
This shows you the differences between two versions of the page.
| Next revisionBoth sides next revision | |||
| install:upgrade:5.1.x-to-5.2.0 [2018/11/23 08:35] – created miconda | install:upgrade:5.1.x-to-5.2.0 [2018/11/28 07:56] – [MySQL Database Structure] miconda | ||
|---|---|---|---|
| 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; | ||
| </ | </ | ||
install/upgrade/5.1.x-to-5.2.0.txt · Last modified: 2018/11/28 08:53 by miconda