User Tools

Site Tools


install:upgrade:5.4.x-to-5.5.0

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next 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:21]
miconda [Renamed Modules]
Line 48: Line 48:
 ); );
 </code> </code>
 +
 +Note also the changes in the column names and indexes.
 +
  
   * database table **userblacklist** renamed to **userblocklist** - its definition is now:   * database table **userblacklist** renamed to **userblocklist** - its definition is now:
Line 62: Line 65:
 ); );
 </code> </code>
 +
 +Note also the changes in the column names and indexes.
 +
 ===== Internal Libraries ===== ===== Internal Libraries =====
  
Line 86: Line 92:
  
 <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_d'; 
 + 
 +-- 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='topos_t'; 
 + 
 +-- uacreg table 
 +ALTER TABLE uacreg ADD COLUMN contact_addr varchar(255) NOT NULL DEFAULT ''; 
 + 
 +-- IMPORTANT: see also the notes about the userblocklist module
 </code> </code>
install/upgrade/5.4.x-to-5.5.0.txt · Last modified: 2021/10/04 17:40 by henningw