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

18 Dec 2018

Module: kamailio
Branch: master
Commit: ff943c681f1888bb106e85a170df371136410341
URL: https://github.com/kamailio/kamailio/commit/ff943c681f1888bb106e85a170df3711...
Author: Jose Luis Verdeguer pepeluxx@gmail.com
Committer: Daniel-Constantin Mierla miconda@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/ff943c681f1888bb106e85a170df3711...
Patch: https://github.com/kamailio/kamailio/commit/ff943c681f1888bb106e85a170df3711...
---

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>

    