[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