modules/ims_qos: added patch for flow-description bug when request originates from...
[sip-router] / src / lib / srdb1 / schema / globalblacklist.xml
1 <?xml version="1.0" encoding="UTF-8"?>
2 <!DOCTYPE table PUBLIC "-//kamailio.org//DTD DBSchema V1.1//EN" 
3   "http://kamailio.org/pub/kamailio/dbschema/dtd/1.1/dbschema.dtd" [
4
5 <!ENTITY % entities SYSTEM "entities.xml">
6 %entities;
7
8 ]>
9
10 <table id="globalblacklist" xmlns:db="http://docbook.org/ns/docbook">
11     <name>globalblacklist</name>
12     <version>1</version>
13     <type db="mysql">&MYSQL_TABLE_TYPE;</type>
14     <description>
15         <db:para>This table is used by the userblacklist module for the global blacklists. More information is available at: &KAMAILIO_MOD_DOC;userblacklist.html
16         </db:para>
17     </description>
18
19     <column id="id">
20         <name>id</name>
21         <type>unsigned int</type>
22         <size>&table_id_len;</size>
23         <autoincrement/>
24         <primary/>
25         <type db="dbtext">int,auto</type>
26         <description>unique ID</description>
27     </column>
28
29     <column id="prefix">
30         <name>prefix</name>
31         <type>string</type>
32         <size>&user_len;</size>
33         <default/>
34         <description>The prefix that is matched for the blacklist.</description>
35     </column>
36
37     <column>
38         <name>whitelist</name>
39         <type>char</type>
40         <size>1</size>
41         <default>0</default>
42         <description>Specify if this a blacklist (0) or a whitelist (1) entry.</description>
43     </column>
44
45      <column>
46         <name>description</name>
47         <type>string</type>
48         <size>&description_len;</size>
49         <null/>
50         <default><null/></default>
51         <description>A comment for the entry.</description>
52     </column>
53
54     <index>
55         <name>globalblacklist_idx</name>
56         <colref linkend="prefix"/>
57     </index>
58 </table>