[sr-dev] git:master:59c49af0: kamctl: regenerated db schema for secfilter

[Daniel-Constantin Mierla]

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

Author: Daniel-Constantin Mierla <miconda at gmail.com>
Committer: Daniel-Constantin Mierla <miconda at gmail.com>
Date: 2020-05-07T08:19:36+02:00

kamctl: regenerated db schema for secfilter

---

Modified: utils/kamctl/db_berkeley/kamailio/secfilter
Modified: utils/kamctl/db_sqlite/secfilter-create.sql
Modified: utils/kamctl/mongodb/kamailio/secfilter.json
Modified: utils/kamctl/mysql/secfilter-create.sql
Modified: utils/kamctl/oracle/secfilter-create.sql
Modified: utils/kamctl/postgres/secfilter-create.sql

---

Diff:  https://github.com/kamailio/kamailio/commit/59c49af039f468466b0d853a4ceab8fe7f566215.diff
Patch: https://github.com/kamailio/kamailio/commit/59c49af039f468466b0d853a4ceab8fe7f566215.patch

---

diff --git a/utils/kamctl/db_berkeley/kamailio/secfilter b/utils/kamctl/db_berkeley/kamailio/secfilter
index 38fbb9a05e..b264e5b0a3 100644
--- a/utils/kamctl/db_berkeley/kamailio/secfilter
+++ b/utils/kamctl/db_berkeley/kamailio/secfilter
@@ -7,4 +7,4 @@ METADATA_READONLY
 METADATA_LOGFLAGS
 0
 METADATA_DEFAULTS
-NIL|''|''|''
+NIL|0|0|''
diff --git a/utils/kamctl/db_sqlite/secfilter-create.sql b/utils/kamctl/db_sqlite/secfilter-create.sql
index 476ea46de4..44e1f4e4c2 100644
--- a/utils/kamctl/db_sqlite/secfilter-create.sql
+++ b/utils/kamctl/db_sqlite/secfilter-create.sql
@@ -1,7 +1,7 @@
 CREATE TABLE secfilter (
     id INTEGER PRIMARY KEY NOT NULL,
-    action SMALLINT DEFAULT '' NOT NULL,
-    type SMALLINT DEFAULT '' NOT NULL,
+    action SMALLINT DEFAULT 0 NOT NULL,
+    type SMALLINT DEFAULT 0 NOT NULL,
     data VARCHAR(64) DEFAULT '' NOT NULL
 );
 
diff --git a/utils/kamctl/mongodb/kamailio/secfilter.json b/utils/kamctl/mongodb/kamailio/secfilter.json
index 1f7baf47fc..7c433e929d 100644
--- a/utils/kamctl/mongodb/kamailio/secfilter.json
+++ b/utils/kamctl/mongodb/kamailio/secfilter.json
@@ -9,12 +9,12 @@
     },
     "action": {
       "type": "int",
-      "default": "",
+      "default": 0,
       "null": false
     },
     "type": {
       "type": "int",
-      "default": "",
+      "default": 0,
       "null": false
     },
     "data": {
diff --git a/utils/kamctl/mysql/secfilter-create.sql b/utils/kamctl/mysql/secfilter-create.sql
index 18a67c79b6..9b35b8d570 100644
--- a/utils/kamctl/mysql/secfilter-create.sql
+++ b/utils/kamctl/mysql/secfilter-create.sql
@@ -1,7 +1,7 @@
 CREATE TABLE `secfilter` (
     `id` INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
-    `action` SMALLINT DEFAULT '' NOT NULL,
-    `type` SMALLINT DEFAULT '' NOT NULL,
+    `action` SMALLINT DEFAULT 0 NOT NULL,
+    `type` SMALLINT DEFAULT 0 NOT NULL,
     `data` VARCHAR(64) DEFAULT '' NOT NULL
 );
 
diff --git a/utils/kamctl/oracle/secfilter-create.sql b/utils/kamctl/oracle/secfilter-create.sql
index 684d1c44cf..d980915525 100644
--- a/utils/kamctl/oracle/secfilter-create.sql
+++ b/utils/kamctl/oracle/secfilter-create.sql
@@ -1,7 +1,7 @@
 CREATE TABLE secfilter (
     id NUMBER(10) PRIMARY KEY,
-    action NUMBER(5) DEFAULT '',
-    type NUMBER(5) DEFAULT '',
+    action NUMBER(5) DEFAULT 0 NOT NULL,
+    type NUMBER(5) DEFAULT 0 NOT NULL,
     data VARCHAR2(64) DEFAULT ''
 );
 
diff --git a/utils/kamctl/postgres/secfilter-create.sql b/utils/kamctl/postgres/secfilter-create.sql
index 71badd4ece..ce048396fa 100644
--- a/utils/kamctl/postgres/secfilter-create.sql
+++ b/utils/kamctl/postgres/secfilter-create.sql
@@ -1,7 +1,7 @@
 CREATE TABLE secfilter (
     id SERIAL PRIMARY KEY NOT NULL,
-    action SMALLINT DEFAULT '' NOT NULL,
-    type SMALLINT DEFAULT '' NOT NULL,
+    action SMALLINT DEFAULT 0 NOT NULL,
+    type SMALLINT DEFAULT 0 NOT NULL,
     data VARCHAR(64) DEFAULT '' NOT NULL
 );