[sr-dev] git:master:ff943c68: lib/srdb1: added db schema for secfilter module

[Daniel-Constantin Mierla]

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

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

lib/srdb1: added db schema for secfilter module

---

Added: src/lib/srdb1/schema/secfilter.xml

---

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

---

diff --git a/src/lib/srdb1/schema/secfilter.xml b/src/lib/srdb1/schema/secfilter.xml
new file mode 100644
index 0000000000..3e0037da5a
--- /dev/null
+++ b/src/lib/srdb1/schema/secfilter.xml
@@ -0,0 +1,65 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE table PUBLIC "-//kamailio.org//DTD DBSchema V1.1//EN"
+  "http://kamailio.org/pub/kamailio/dbschema/dtd/1.1/dbschema.dtd" [
+
+<!ENTITY % entities SYSTEM "entities.xml">
+%entities;
+
+]>
+
+<table id="secfilter" xmlns:db="http://docbook.org/ns/docbook">
+    <name>secfilter</name>
+    <version>1</version>
+    <type db="mysql">&MYSQL_TABLE_TYPE;</type>
+   <description>
+                <db:para>
+                        This table is used by the secfilter module. It contains the sets of
+                        values used to block or allow messages. More information about the
+                        secfilter module can be found at:
+                        <itemizedlist>
+                        <listitem>
+                        <ulink url="&KAMAILIO_MOD_DOC;secfilter.html">&KAMAILIO_MOD_DOC;secfilter.html</ulink>.
+                        </listitem>
+                        </itemizedlist>
+        </db:para>
+    </description>
+
+    <column id="id">
+        <name>id</name>
+        <type>unsigned int</type>
+        <size>&table_id_len;</size>
+        <autoincrement/>
+        <primary/>
+        <type db="dbtext">int,auto</type>
+        <description>unique ID</description>
+    </column>
+
+    <column id="action">
+        <name>action</name>
+        <type>tinyint</type>
+        <default/>
+        <description>Action to do (0=blacklisted data, 1=whitelisted data, 2=blacklisted destination).</description>
+    </column>
+
+    <column id="type">
+        <name>type</name>
+        <type>tinyint</type>
+        <default/>
+        <description>Type of data (0=user-agent, 1=country, 2=domain, 3=IP address, 4=user).</description>
+    </column>
+
+    <column id="data">
+        <name>data</name>
+        <type>string</type>
+        <size>64</size>
+        <default/>
+        <description>Data value.</description>
+    </column>
+
+    <index>
+        <name>secfilter_idx</name>
+        <colref linkend="action"/>
+        <colref linkend="type"/>
+        <colref linkend="data"/>
+    </index>
+</table>