[sr-dev] git:5.1:98528af1: kamctl: regenerated scripts to create database structure for presence

Daniel-Constantin Mierla miconda at gmail.com
Sat Dec 9 09:24:12 CET 2017


Module: kamailio
Branch: 5.1
Commit: 98528af1b87526395339aa3ed2d176b77b897740
URL: https://github.com/kamailio/kamailio/commit/98528af1b87526395339aa3ed2d176b77b897740

Author: Daniel-Constantin Mierla <miconda at gmail.com>
Committer: Daniel-Constantin Mierla <miconda at gmail.com>
Date: 2017-12-09T09:23:38+01:00

kamctl: regenerated scripts to create database structure for presence

---

Modified: utils/kamctl/db_sqlite/presence-create.sql
Modified: utils/kamctl/dbtext/kamailio/active_watchers
Modified: utils/kamctl/mongodb/kamailio/active_watchers.json
Modified: utils/kamctl/mysql/presence-create.sql
Modified: utils/kamctl/postgres/presence-create.sql

---

Diff:  https://github.com/kamailio/kamailio/commit/98528af1b87526395339aa3ed2d176b77b897740.diff
Patch: https://github.com/kamailio/kamailio/commit/98528af1b87526395339aa3ed2d176b77b897740.patch

---

diff --git a/utils/kamctl/db_sqlite/presence-create.sql b/utils/kamctl/db_sqlite/presence-create.sql
index a84ee99965..c4d01296a7 100644
--- a/utils/kamctl/db_sqlite/presence-create.sql
+++ b/utils/kamctl/db_sqlite/presence-create.sql
@@ -35,7 +35,7 @@ CREATE TABLE active_watchers (
     record_route TEXT,
     expires INTEGER NOT NULL,
     status INTEGER DEFAULT 2 NOT NULL,
-    reason VARCHAR(64) NOT NULL,
+    reason VARCHAR(64),
     version INTEGER DEFAULT 0 NOT NULL,
     socket_info VARCHAR(64) NOT NULL,
     local_contact VARCHAR(128) NOT NULL,
diff --git a/utils/kamctl/dbtext/kamailio/active_watchers b/utils/kamctl/dbtext/kamailio/active_watchers
index b4053a323e..19719b72d5 100644
--- a/utils/kamctl/dbtext/kamailio/active_watchers
+++ b/utils/kamctl/dbtext/kamailio/active_watchers
@@ -1 +1 @@
-id(int,auto) presentity_uri(string) watcher_username(string) watcher_domain(string) to_user(string) to_domain(string) event(string) event_id(string,null) to_tag(string) from_tag(string) callid(string) local_cseq(int) remote_cseq(int) contact(string) record_route(string,null) expires(int) status(int) reason(string) version(int) socket_info(string) local_contact(string) from_user(string) from_domain(string) updated(int) updated_winfo(int) flags(int) user_agent(string) 
+id(int,auto) presentity_uri(string) watcher_username(string) watcher_domain(string) to_user(string) to_domain(string) event(string) event_id(string,null) to_tag(string) from_tag(string) callid(string) local_cseq(int) remote_cseq(int) contact(string) record_route(string,null) expires(int) status(int) reason(string,null) version(int) socket_info(string) local_contact(string) from_user(string) from_domain(string) updated(int) updated_winfo(int) flags(int) user_agent(string) 
diff --git a/utils/kamctl/mongodb/kamailio/active_watchers.json b/utils/kamctl/mongodb/kamailio/active_watchers.json
index adc1d27d0d..123692d988 100644
--- a/utils/kamctl/mongodb/kamailio/active_watchers.json
+++ b/utils/kamctl/mongodb/kamailio/active_watchers.json
@@ -90,7 +90,7 @@
     "reason": {
       "type": "string",
       "default": null,
-      "null": false
+      "null": true
     },
     "version": {
       "type": "int",
diff --git a/utils/kamctl/mysql/presence-create.sql b/utils/kamctl/mysql/presence-create.sql
index c4423b508e..95d85cdc19 100644
--- a/utils/kamctl/mysql/presence-create.sql
+++ b/utils/kamctl/mysql/presence-create.sql
@@ -35,7 +35,7 @@ CREATE TABLE `active_watchers` (
     `record_route` TEXT,
     `expires` INT(11) NOT NULL,
     `status` INT(11) DEFAULT 2 NOT NULL,
-    `reason` VARCHAR(64) NOT NULL,
+    `reason` VARCHAR(64),
     `version` INT(11) DEFAULT 0 NOT NULL,
     `socket_info` VARCHAR(64) NOT NULL,
     `local_contact` VARCHAR(128) NOT NULL,
diff --git a/utils/kamctl/postgres/presence-create.sql b/utils/kamctl/postgres/presence-create.sql
index aa0efc8034..698352ca16 100644
--- a/utils/kamctl/postgres/presence-create.sql
+++ b/utils/kamctl/postgres/presence-create.sql
@@ -35,7 +35,7 @@ CREATE TABLE active_watchers (
     record_route TEXT,
     expires INTEGER NOT NULL,
     status INTEGER DEFAULT 2 NOT NULL,
-    reason VARCHAR(64) NOT NULL,
+    reason VARCHAR(64),
     version INTEGER DEFAULT 0 NOT NULL,
     socket_info VARCHAR(64) NOT NULL,
     local_contact VARCHAR(128) NOT NULL,




More information about the sr-dev mailing list