This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | Next revision Both sides next revision | ||
install:upgrade:5.4.x-to-5.5.0 [2021/04/27 11:32] miconda [Renamed Modules] |
install:upgrade:5.4.x-to-5.5.0 [2021/04/27 12:20] miconda [MySQL Database Structure] |
||
---|---|---|---|
Line 86: | Line 86: | ||
<code sql> | <code sql> | ||
- | ... | + | -- topos_d table |
+ | ALTER TABLE topos_d ADD COLUMN x_context varchar(64) NOT NULL DEFAULT ''; | ||
+ | UPDATE version SET table_version=2 WHERE TABLE_NAME=' | ||
+ | |||
+ | -- topos_t table | ||
+ | ALTER TABLE topos_t ADD COLUMN x_context varchar(64) NOT NULL DEFAULT ''; | ||
+ | UPDATE version SET table_version=2 WHERE TABLE_NAME=' | ||
+ | |||
+ | -- uacreg table | ||
+ | ALTER TABLE uacreg ADD COLUMN contact_addr varchar(255) NOT NULL DEFAULT ''; | ||
+ | |||
+ | -- IMPORTANT: see also the notes about the userblocklist module | ||
</ | </ |