Differences

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

--- install:upgrade:5.4.x-to-5.5.0 [2021/04/01 12:14]
miconda created
+++ install:upgrade:5.4.x-to-5.5.0 [2021/04/27 12:20]
miconda [MySQL Database Structure]
@@ Line 30: / Line 30: @@
 ==== Renamed Modules ====
-  * none
+=== userblacklist to userblocklist ===
+  * https://www.kamailio.org/docs/modules/5.5.x/modules/userblocklist.html
+Impacted resources:
+  * 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>
+  * 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>
 ===== Internal Libraries =====
@@ Line 56: / Line 86: @@
 <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>

Kamailio SIP Server Wiki

User Tools

Site Tools

Differences

Page Tools