modules/ims_qos: added patch for flow-description bug when request originates from...
[sip-router] / src / lib / srdb1 / schema / sca.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="sca_susbcriptions" xmlns:db="http://docbook.org/ns/docbook">
11     <name>sca_subscriptions</name>
12     <version>2</version>
13     <type db="mysql">&MYSQL_TABLE_TYPE;</type>
14     <description>
15         <db:para>This table is used by the sca module to store active subscriptions. At startup time, the sca module loads unexpired subscriptions into its subscription hash table. More information about the sca module can be found at: &KAMAILIO_MOD_DOC;sca.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="subscriber">
30         <name>subscriber</name>
31         <type>string</type>
32         <size>255</size>
33         <description>URI of SCA subscriber</description>
34     </column>
35
36     <column id="aor">
37         <name>aor</name>
38         <type>string</type>
39         <size>255</size>
40         <description>SCA Address-of-Record for the group</description>
41     </column>
42
43     <column id="event">
44         <name>event</name>
45         <type>int</type>
46         <default>0</default>
47         <description>SCA event type. 0 - call-info, 1 - line-seize</description>
48     </column>
49
50     <column id="expires">
51         <name>expires</name>
52         <type>int</type>
53         <size>&expires_len;</size>
54         <default>0</default>
55         <description>Epoch time of SCA subscription expiration</description>
56     </column>
57
58     <column id="state">
59         <name>state</name>
60         <type>int</type>
61         <default>0</default>
62         <description>SCA subscription state, 0 - active</description>
63     </column>
64
65     <column id="app_idx">
66         <name>app_idx</name>
67         <type>int</type>
68         <default>0</default>
69         <description>Seized line appearance index</description>
70     </column> 
71
72     <column id="call_id">
73         <name>call_id</name>
74         <type>string</type>
75         <size>&callid_len;</size>
76         <description>Call-ID value for subscription dialog</description>
77     </column>
78
79     <column id="from_tag">
80         <name>from_tag</name>
81         <type>string</type>
82         <size>&domain_len;</size>
83         <description>From-tag for subscription dialog</description>
84     </column>
85
86     <column id="to_tag">
87         <name>to_tag</name>
88         <type>string</type>
89         <size>&domain_len;</size>
90         <description>To-tag for subscription dialog</description>
91     </column>
92
93     <column id="record_route">
94         <name>record_route</name>
95         <type>text</type>
96         <null />
97         <description>Subscription Record-Route values</description>
98     </column>
99
100     <column id="notify_cseq">
101         <name>notify_cseq</name>
102         <type>int</type>
103         <size>&cseq_len;</size>
104         <description>Cseq for NOTIFYs sent to subscriber</description>
105     </column>
106
107     <column id="subscribe_cseq">
108         <name>subscribe_cseq</name>
109         <type>int</type>
110         <size>&cseq_len;</size>
111         <description>Cseq for SUBSCRIBEs sent from subscriber</description>
112     </column>
113
114     <column id="server_id">
115         <name>server_id</name>
116         <type>int</type>
117         <size>11</size>
118         <default>0</default>
119         <description>The value of server_id from configuration file</description>
120     </column>
121
122     <index>
123         <name>sca_subscriptions_idx</name>
124         <colref linkend="subscriber" />
125         <colref linkend="call_id" />
126         <colref linkend="from_tag" />
127         <colref linkend="to_tag" />
128         <unique />
129     </index>
130
131     <index>
132         <name>sca_expires_idx</name>
133         <colref linkend="server_id" />
134         <colref linkend="expires" />
135     </index>
136
137     <index>
138         <name>sca_subscribers_idx</name>
139         <colref linkend="subscriber" />
140         <colref linkend="event" />
141     </index>
142 </table>