modules/ims_qos: added patch for flow-description bug when request originates from...
[sip-router] / src / lib / srdb1 / schema / pr_pua.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="pua" xmlns:db="http://docbook.org/ns/docbook">
11     <name>pua</name>
12     <version>7</version>
13     <type db="mysql">&MYSQL_TABLE_TYPE;</type>
14     <description>
15         <db:para>Table for the presence related pua module. More information can be found at: &KAMAILIO_MOD_DOC;pua.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="pres_uri">
30         <name>pres_uri</name>
31         <type>string</type>
32         <size>&uri_len;</size>
33         <description>URI</description>
34         <natural/>
35     </column>
36
37     <column id="pres_id">
38         <name>pres_id</name>
39         <type>string</type>
40         <size>255</size>
41         <description>ID</description>
42     </column>
43
44     <column>
45         <name>event</name>
46         <type>int</type>
47         <size>11</size>
48         <description>Event</description>
49         <natural/>
50     </column>
51
52     <column id="expires">
53         <name>expires</name>
54         <type>int</type>
55         <size>&expires_len;</size>
56         <description>Expires</description>
57     </column>
58
59     <column>
60         <name>desired_expires</name>
61         <type>int</type>
62         <size>&expires_len;</size>
63         <description>Desired Expires</description>
64     </column>
65
66     <column>
67         <name>flag</name>
68         <type>int</type>
69         <size>&flag_len;</size>
70         <description>Flags</description>
71     </column>
72
73     <column id="etag">
74         <name>etag</name>
75         <type>string</type>
76         <size>&domain_len;</size>
77         <description>Etag</description>
78     </column>
79
80     <column id="tuple_id">
81         <name>tuple_id</name>
82         <type>string</type>
83         <size>&domain_len;</size>
84         <null/>
85         <description>Tuple ID</description>
86     </column>
87
88     <column>
89         <name>watcher_uri</name>
90         <type>string</type>
91         <size>&uri_len;</size>
92         <description>Watcher URI</description>
93     </column>
94
95     <column id="call_id">
96         <name>call_id</name>
97         <type>string</type>
98         <size>&callid_len;</size>
99         <description>Call ID</description>
100     </column>
101
102     <column id="to_tag">
103         <name>to_tag</name>
104         <type>string</type>
105         <size>&domain_len;</size>
106         <description>To tag</description>
107     </column>
108
109     <column id="from_tag">
110         <name>from_tag</name>
111         <type>string</type>
112         <size>&domain_len;</size>
113         <description>To tag</description>
114     </column>
115
116     <column>
117         <name>cseq</name>
118         <type>int</type>
119         <size>&cseq_len;</size>
120     </column>
121
122     <column>
123         <name>record_route</name>
124         <type>text</type>
125         <null/>
126         <description>Record route</description>
127     </column>
128
129     <column>
130         <name>contact</name>
131         <type>string</type>
132         <size>&uri_len;</size>
133         <description>Contact</description>
134     </column>
135
136     <column>
137         <name>remote_contact</name>
138         <type>string</type>
139         <size>&uri_len;</size>
140         <description>Remote contact</description>
141     </column>
142
143     <column>
144         <name>version</name>
145         <type>int</type>
146         <size>11</size>
147         </column>
148         <column>
149         <name>extra_headers</name>
150         <type>text</type>
151         <description>Extra Headers</description>
152     </column>
153
154     <index>
155         <name>pua_idx</name>
156         <colref linkend="etag"/>
157         <colref linkend="tuple_id"/>
158         <colref linkend="call_id"/>
159         <colref linkend="from_tag"/>
160         <unique/>
161     </index>
162
163     <index>
164         <name>expires_idx</name>
165         <colref linkend="expires"/>
166     </index>
167
168     <index>
169         <name>dialog1_idx</name>
170         <colref linkend="pres_id"/>
171         <colref linkend="pres_uri"/>
172     </index>
173
174    <index>
175         <name>dialog2_idx</name>
176         <colref linkend="call_id"/>
177         <colref linkend="from_tag"/>
178     </index>
179
180     <index>
181         <name>record_idx</name>
182         <colref linkend="pres_id"/>
183     </index>
184 </table>