[sr-dev] git:master:e5067d45: kamctl: generated sql creation scripts for secfilter module

[Daniel-Constantin Mierla]

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

Author: Jose Luis Verdeguer <pepeluxx at gmail.com>
Committer: Daniel-Constantin Mierla <miconda at gmail.com>
Date: 2018-12-18T10:23:10+01:00

kamctl: generated sql creation scripts for secfilter module

---

Added: utils/kamctl/db_sqlite/secfilter-create.sql
Added: utils/kamctl/mysql/secfilter-create.sql
Added: utils/kamctl/oracle/secfilter-create.sql
Added: utils/kamctl/postgres/secfilter-create.sql

---

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

---

diff --git a/utils/kamctl/db_sqlite/secfilter-create.sql b/utils/kamctl/db_sqlite/secfilter-create.sql
new file mode 100644
index 0000000000..6f8af6d5a9
--- /dev/null
+++ b/utils/kamctl/db_sqlite/secfilter-create.sql
@@ -0,0 +1,11 @@
+CREATE TABLE secfilter (
+  id INTEGER PRIMARY KEY NOT NULL,
+  action SMALLINT DEFAULT 0 NOT NULL,
+  type SMALLINT DEFAULT 0 NOT NULL,
+  data VARCHAR(64) DEFAULT '' NOT NULL
+);
+
+CREATE INDEX secfilter_idx ON secfilter (action, type, data);
+
+INSERT INTO version (table_name, table_version) values ('secfilter', '1');
+
diff --git a/utils/kamctl/mysql/secfilter-create.sql b/utils/kamctl/mysql/secfilter-create.sql
new file mode 100644
index 0000000000..9e6eab745f
--- /dev/null
+++ b/utils/kamctl/mysql/secfilter-create.sql
@@ -0,0 +1,11 @@
+CREATE TABLE `secfilter` (
+  `id` INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
+  `action` TINYINT(1) DEFAULT 0 NOT NULL,
+  `type` TINYINT(1) DEFAULT 0 NOT NULL,
+  `data` VARCHAR(64) DEFAULT '' NOT NULL
+);
+
+CREATE INDEX secfilter_idx ON secfilter (`action`, `type`, `data`);
+
+INSERT INTO version (`table_name`, `table_version`) values ('secfilter', '1');
+
diff --git a/utils/kamctl/oracle/secfilter-create.sql b/utils/kamctl/oracle/secfilter-create.sql
new file mode 100644
index 0000000000..539be00a5d
--- /dev/null
+++ b/utils/kamctl/oracle/secfilter-create.sql
@@ -0,0 +1,19 @@
+CREATE TABLE secfilter (
+  id NUMBER(10) PRIMARY KEY,
+  action NUMBER(1) DEFAULT 0 NOT NULL,
+  type NUMBER(1) DEFAULT 0 NOT NULL,
+  data VARCHAR2(64) DEFAULT '' NOT NULL
+);
+
+CREATE OR REPLACE TRIGGER secfilter_tr
+before insert on secfilter FOR EACH ROW
+BEGIN
+  auto_id(:NEW.id);
+END secfilter_tr;
+/
+BEGIN map2users('secfilter'); END;
+/
+CREATE INDEX ORA_secfilter_idx  ON secfilter (action, type, data);
+
+INSERT INTO version (table_name, table_version) values ('secfilter', '1');
+
diff --git a/utils/kamctl/postgres/secfilter-create.sql b/utils/kamctl/postgres/secfilter-create.sql
new file mode 100644
index 0000000000..fc44a806a9
--- /dev/null
+++ b/utils/kamctl/postgres/secfilter-create.sql
@@ -0,0 +1,11 @@
+CREATE TABLE secfilter (
+  id SERIAL PRIMARY KEY NOT NULL,
+  action SMALLINT DEFAULT 0 NOT NULL,
+  type SMALLINT DEFAULT 0 NOT NULL,
+  data VARCHAR(64) DEFAULT '' NOT NULL
+);
+
+CREATE INDEX secfilter_idx ON secfilter (action, type, data);
+
+INSERT INTO version (table_name, table_version) values ('secfilter', '1');
+