Differences

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

--- install:upgrade:5.4.x-to-5.5.0 [2021/04/01 10:14] – created miconda
+++ install:upgrade:5.4.x-to-5.5.0 [2021/10/04 15:40] (current) – henningw
@@ Line 30: / Line 30: @@
 ==== Renamed Modules ====
-  * none
+=== userblacklist to userblocklist ===
+  * https://www.kamailio.org/docs/modules/5.5.x/modules/userblocklist.html
+Impacted resources:
+  * version table, userblacklist and globalblacklist entries renamed to userblocklist and globalblocklist
+  * database table **globalblacklist** renamed to **globalblocklist** - its definition is now:
+<code>
+CREATE TABLE globalblocklist (
+  id int(10) unsigned NOT NULL AUTO_INCREMENT,
+  prefix varchar(64) NOT NULL DEFAULT '',
+  allowlist tinyint(1) NOT NULL DEFAULT 0,
+  description varchar(255) DEFAULT NULL,
+  PRIMARY KEY (id),
+  KEY globalblocklist_idx (prefix)
+);
+</code>
+Note also the changes in the column names and indexes.
+  * database table **userblacklist** renamed to **userblocklist** - its definition is now:
+<code>
+CREATE TABLE userblocklist (
+  id int(10) unsigned NOT NULL AUTO_INCREMENT,
+  username varchar(64) NOT NULL DEFAULT '',
+  domain varchar(64) NOT NULL DEFAULT '',
+  prefix varchar(64) NOT NULL DEFAULT '',
+  allowlist tinyint(1) NOT NULL DEFAULT 0,
+  PRIMARY KEY (id),
+  KEY userblocklist_idx (username,domain,prefix)
+);
+</code>
+Note also the changes in the column names and indexes.
 ===== Internal Libraries =====
@@ Line 48: / 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 56: / 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>