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

Module: kamailio Branch: 5.1 Commit: 98528af1b87526395339aa3ed2d176b77b897740 URL: https://github.com/kamailio/kamailio/commit/98528af1b87526395339aa3ed2d176b… Author: Daniel-Constantin Mierla <miconda(a)gmail.com> Committer: Daniel-Constantin Mierla <miconda(a)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/98528af1b87526395339aa3ed2d176b… Patch: https://github.com/kamailio/kamailio/commit/98528af1b87526395339aa3ed2d176b… --- 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,