Module: kamailio Branch: master Commit: a4a9b6d27ae35ee651840a683a5d70ba52ec232f URL: https://github.com/kamailio/kamailio/commit/a4a9b6d27ae35ee651840a683a5d70ba...

Author: Victor Seva linuxmaniac@torreviejawireless.org Committer: Victor Seva linuxmaniac@torreviejawireless.org Date: 2015-04-21T16:24:02+02:00

kamctl: upgrade silo schema

---

Modified: utils/kamctl/db_berkeley/kamailio/silo Modified: utils/kamctl/db_sqlite/msilo-create.sql Modified: utils/kamctl/dbtext/kamailio/silo Modified: utils/kamctl/mysql/msilo-create.sql Modified: utils/kamctl/oracle/msilo-create.sql Modified: utils/kamctl/postgres/msilo-create.sql

---

Diff: https://github.com/kamailio/kamailio/commit/a4a9b6d27ae35ee651840a683a5d70ba... Patch: https://github.com/kamailio/kamailio/commit/a4a9b6d27ae35ee651840a683a5d70ba...

---

diff --git a/utils/kamctl/db_berkeley/kamailio/silo b/utils/kamctl/db_berkeley/kamailio/silo index fe5d419..41ff819 100644 --- a/utils/kamctl/db_berkeley/kamailio/silo +++ b/utils/kamctl/db_berkeley/kamailio/silo @@ -7,4 +7,4 @@ METADATA_READONLY METADATA_LOGFLAGS 0 METADATA_DEFAULTS -NIL|''|''|''|''|0|0|0|'text/plain'|''|''|''|0 +NIL|''|''|''|''|0|0|0|'text/plain'|NIL|NIL|''|0 diff --git a/utils/kamctl/db_sqlite/msilo-create.sql b/utils/kamctl/db_sqlite/msilo-create.sql index af2fdaa..693955a 100644 --- a/utils/kamctl/db_sqlite/msilo-create.sql +++ b/utils/kamctl/db_sqlite/msilo-create.sql @@ -9,8 +9,8 @@ CREATE TABLE silo ( exp_time INTEGER DEFAULT 0 NOT NULL, snd_time INTEGER DEFAULT 0 NOT NULL, ctype VARCHAR(32) DEFAULT 'text/plain' NOT NULL, - body BLOB DEFAULT '' NOT NULL, - extra_hdrs TEXT DEFAULT '' NOT NULL, + body BLOB, + extra_hdrs TEXT, callid VARCHAR(128) DEFAULT '' NOT NULL, status INTEGER DEFAULT 0 NOT NULL ); diff --git a/utils/kamctl/dbtext/kamailio/silo b/utils/kamctl/dbtext/kamailio/silo index fe19d9b..6e1f609 100644 --- a/utils/kamctl/dbtext/kamailio/silo +++ b/utils/kamctl/dbtext/kamailio/silo @@ -1 +1 @@ -id(int,auto) src_addr(string) dst_addr(string) username(string) domain(string) inc_time(int) exp_time(int) snd_time(int) ctype(string) body(string) extra_hdrs(string) callid(string) status(int) +id(int,auto) src_addr(string) dst_addr(string) username(string) domain(string) inc_time(int) exp_time(int) snd_time(int) ctype(string) body(string,null) extra_hdrs(string,null) callid(string) status(int) diff --git a/utils/kamctl/mysql/msilo-create.sql b/utils/kamctl/mysql/msilo-create.sql index 58c0f5c..32cd478 100644 --- a/utils/kamctl/mysql/msilo-create.sql +++ b/utils/kamctl/mysql/msilo-create.sql @@ -9,8 +9,8 @@ CREATE TABLE silo ( exp_time INT DEFAULT 0 NOT NULL, snd_time INT DEFAULT 0 NOT NULL, ctype VARCHAR(32) DEFAULT 'text/plain' NOT NULL, - body BLOB DEFAULT '' NOT NULL, - extra_hdrs TEXT DEFAULT '' NOT NULL, + body BLOB, + extra_hdrs TEXT, callid VARCHAR(128) DEFAULT '' NOT NULL, status INT DEFAULT 0 NOT NULL ); diff --git a/utils/kamctl/oracle/msilo-create.sql b/utils/kamctl/oracle/msilo-create.sql index 25c4293..b11a9d5 100644 --- a/utils/kamctl/oracle/msilo-create.sql +++ b/utils/kamctl/oracle/msilo-create.sql @@ -9,8 +9,8 @@ CREATE TABLE silo ( exp_time NUMBER(10) DEFAULT 0 NOT NULL, snd_time NUMBER(10) DEFAULT 0 NOT NULL, ctype VARCHAR2(32) DEFAULT 'text/plain', - body BLOB DEFAULT '', - extra_hdrs CLOB DEFAULT '', + body BLOB, + extra_hdrs CLOB, callid VARCHAR2(128) DEFAULT '', status NUMBER(10) DEFAULT 0 NOT NULL ); diff --git a/utils/kamctl/postgres/msilo-create.sql b/utils/kamctl/postgres/msilo-create.sql index 9dd4deb..e228c99 100644 --- a/utils/kamctl/postgres/msilo-create.sql +++ b/utils/kamctl/postgres/msilo-create.sql @@ -9,8 +9,8 @@ CREATE TABLE silo ( exp_time INTEGER DEFAULT 0 NOT NULL, snd_time INTEGER DEFAULT 0 NOT NULL, ctype VARCHAR(32) DEFAULT 'text/plain' NOT NULL, - body BYTEA DEFAULT '' NOT NULL, - extra_hdrs TEXT DEFAULT '' NOT NULL, + body BYTEA, + extra_hdrs TEXT, callid VARCHAR(128) DEFAULT '' NOT NULL, status INTEGER DEFAULT 0 NOT NULL );