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
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/10/04 17:40] (current)
henningw
Line 36: Line 36:
 Impacted resources: Impacted resources:
  
 +  * version table, userblacklist and globalblacklist entries renamed to userblocklist and globalblocklist
   * database table **globalblacklist** renamed to **globalblocklist** - its definition is now:   * database table **globalblacklist** renamed to **globalblocklist** - its definition is now:
  
Line 48: Line 49:
 ); );
 </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 66:
 ); );
 </code> </code>
 +
 +Note also the changes in the column names and indexes.
 +
 ===== Internal Libraries ===== ===== Internal Libraries =====
  
Line 78: Line 85:
 ==== 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 94:
  
 <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.1619515954.txt.gz · Last modified: 2021/04/27 11:32 by miconda