modules/ims_qos: added patch for flow-description bug when request originates from...
[sip-router] / lib / srdb1 / schema / lcr_rule.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="lcr_rule" xmlns:db="http://docbook.org/ns/docbook">
11     <name>lcr_rule</name>
12     <version>2</version>
13     <type db="mysql">&MYSQL_TABLE_TYPE;</type>
14     <description>
15         <db:para>This table is used by the lcr (Least Cost Routing)
16             module to store routing rules.
17             More information can be found at: &KAMAILIO_MOD_DOC;lcr.html.
18         </db:para>
19     </description>
20
21     <column id="id">
22         <name>id</name>
23         <type>unsigned int</type>
24         <size>&table_id_len;</size>
25         <autoincrement/>
26         <primary/>
27         <type db="dbtext">int,auto</type>
28     </column>
29
30     <column id="lcr_id">
31         <name>lcr_id</name>
32         <type>unsigned short</type>
33         <description>LCR instance identifier</description>
34     </column>
35
36     <column id="prefix">
37         <name>prefix</name>
38         <type>string</type>
39         <size>16</size>
40         <null/>
41         <default><null/></default>
42         <description>Prefix of Request URI user part</description>
43         <natural/>
44     </column>
45
46     <column id="from_uri">
47         <name>from_uri</name>
48         <type>string</type>
49         <size>&domain_len;</size>
50         <null/>
51         <default><null/></default>
52         <description>PCRE regular expression that is matched to caller's URI</description>
53     </column>
54
55     <column id="request_uri">
56         <name>request_uri</name>
57         <type>string</type>
58         <size>&domain_len;</size>
59         <null/>
60         <default><null/></default>
61         <description>PCRE regular expression that is matched to full request URI</description>
62     </column>
63
64     <column id="stopper">
65         <name>stopper</name>
66         <type>unsigned int</type>
67         <default>0</default>
68         <description>Tells if rule is "stopper" rule</description>
69     </column>
70
71     <column id="enabled">
72         <name>enabled</name>
73         <type>unsigned int</type>
74         <default>1</default>
75         <description>Tells if rule is enabled</description>
76     </column>
77
78     <index>
79         <name>lcr_id_prefix_from_uri_idx</name>
80         <colref linkend="lcr_id"/>
81         <colref linkend="prefix"/>
82         <colref linkend="from_uri"/>
83         <unique/>
84     </index>
85
86 </table>