Module: kamailio
Branch: master
Commit: 900f2a1559ea2b83387fc30195c41c6fd47402f7
URL:
https://github.com/kamailio/kamailio/commit/900f2a1559ea2b83387fc30195c41c6…
Author: Daniel-Constantin Mierla <miconda(a)gmail.com>
Committer: Daniel-Constantin Mierla <miconda(a)gmail.com>
Date: 2017-12-09T09:21:46+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/900f2a1559ea2b83387fc30195c41c6…
Patch:
https://github.com/kamailio/kamailio/commit/900f2a1559ea2b83387fc30195c41c6…
---
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,