modules/ims_qos: added patch for flow-description bug when request originates from...
[sip-router] / lib / srdb1 / schema / uacreg.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="uacreg" xmlns:db="http://docbook.org/ns/docbook">
11     <name>uacreg</name>
12     <version>3</version>
13     <type db="mysql">&MYSQL_TABLE_TYPE;</type>
14     <description>
15         <db:para>This table is used by theuac module to load user details for remote server registration: &KAMAILIO_MOD_DOC;uac.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="l_uuid">
30         <name>l_uuid</name>
31         <type>string</type>
32         <size>&user_len;</size>
33         <default/>
34         <description>Local unique id used to build and match contact addresses.</description>
35     </column>
36
37     <column id="l_username">
38         <name>l_username</name>
39         <type>string</type>
40         <size>&user_len;</size>
41         <default/>
42         <description>Local username</description>
43     </column>
44
45     <column id="l_domain">
46         <name>l_domain</name>
47         <type>string</type>
48         <size>&domain_len;</size>
49         <default/>
50         <description>Local domain</description>
51     </column>
52
53     <column id="r_username">
54         <name>r_username</name>
55         <type>string</type>
56         <size>&user_len;</size>
57         <default/>
58         <description>Remote username</description>
59     </column>
60
61     <column id="r_domain">
62         <name>r_domain</name>
63         <type>string</type>
64         <size>&domain_len;</size>
65         <default/>
66         <description>Remote domain</description>
67     </column>
68
69     <column id="realm">
70         <name>realm</name>
71         <type>string</type>
72         <size>&realm_len;</size>
73         <default/>
74         <description>Remote username</description>
75     </column>
76
77     <column id="auth_username">
78         <name>auth_username</name>
79         <type>string</type>
80         <size>&user_len;</size>
81         <default/>
82         <description>Authentication username</description>
83     </column>
84
85     <column id="auth_password">
86         <name>auth_password</name>
87         <type>string</type>
88         <size>&password_len;</size>
89         <default/>
90         <description>Authentication password</description>
91     </column>
92
93     <column id="auth_ha1">
94         <name>auth_ha1</name>
95         <type>string</type>
96         <size>&ha1_len;</size>
97         <default/>
98         <description>Hashed (HA1) authentication password</description>
99     </column>
100
101     <column id="auth_proxy">
102         <name>auth_proxy</name>
103         <type>string</type>
104         <size>&uri_len;</size>
105         <default/>
106         <description>Outbound proxy SIP address</description>
107     </column>
108
109     <column id="expires">
110         <name>expires</name>
111         <type>int</type>
112         <default>0</default>
113         <description>Expiration time (in seconds, 0 means disabled)</description>
114     </column>
115
116     <column id="flags">
117         <name>flags</name>
118         <type>int</type>
119         <default>0</default>
120         <description>Flags to control the behavior</description>
121     </column>
122
123     <column id="reg_delay">
124         <name>reg_delay</name>
125         <type>int</type>
126         <default>0</default>
127         <description>Initial registration delay</description>
128     </column>
129
130         <index>
131         <name>l_uuid_idx</name>
132         <colref linkend="l_uuid"/>
133         <unique/>
134     </index>
135 </table>