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
Last 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/05/24 18:27]
miconda [Misc]
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 78: Line 84:
 ==== Misc ==== ==== Misc ====
  
 +  * **#!substdef "/match/replacement/flags"** evaluates the **replacement** for variables to be coherent with **#!subst**, if there are variables that should not be evaluated during pre-processing phase, use **$$** at the beginning of variable (e.g., **$$var(x)***
 ===== Database ===== ===== Database =====
  
Line 86: Line 93:
  
 <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 ''; 
 +UPDATE version SET table_version=5 WHERE TABLE_NAME='uacreg'; 
 + 
 +-- 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