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

Module: kamailio Branch: master Commit: ff943c681f1888bb106e85a170df371136410341 URL: https://github.com/kamailio/kamailio/commit/ff943c681f1888bb106e85a170df371… Author: Jose Luis Verdeguer &lt;pepeluxx(a)gmail.com&gt; Committer: Daniel-Constantin Mierla &lt;miconda(a)gmail.com&gt; 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/ff943c681f1888bb106e85a170df371… Patch: https://github.com/kamailio/kamailio/commit/ff943c681f1888bb106e85a170df371… --- 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>