Differences

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

--- install:upgrade:5.4.x-to-5.5.0 [2021/04/27 09:32] – [Renamed Modules] miconda
+++ install:upgrade:5.4.x-to-5.5.0 [2021/10/04 15:40] (current) – henningw
@@ Line 36: / Line 36: @@
 Impacted resources:
+  * version table, userblacklist and globalblacklist entries renamed to userblocklist and globalblocklist
   * database table **globalblacklist** renamed to **globalblocklist** - its definition is now:
@@ Line 48: / Line 49: @@
 );
 </code>
+Note also the changes in the column names and indexes.
   * database table **userblacklist** renamed to **userblocklist** - its definition is now:
@@ Line 62: / Line 66: @@
 );
 </code>
+Note also the changes in the column names and indexes.
 ===== Internal Libraries =====
@@ Line 78: / Line 85: @@
 ==== 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 =====
@@ Line 86: / Line 94: @@
 <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>