[sr-dev] git:master:a4a9b6d2: kamctl: upgrade silo schema

[Victor Seva]

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

Author: Victor Seva <linuxmaniac at torreviejawireless.org>
Committer: Victor Seva <linuxmaniac at 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/a4a9b6d27ae35ee651840a683a5d70ba52ec232f.diff
Patch: https://github.com/kamailio/kamailio/commit/a4a9b6d27ae35ee651840a683a5d70ba52ec232f.patch

---

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
 );