modules/ims_qos: added patch for flow-description bug when request originates from...
[sip-router] / src / lib / srdb2 / schema / phonebook.xml
1 <?xml version="1.0" encoding="UTF-8"?>
2 <!DOCTYPE table PUBLIC "-//iptel.org//DTD DBSchema V1.0//EN"
3   "http://iptel.org/dbschema/dtd/1.0/dbschema.dtd" [
4
5 <!ENTITY % entities SYSTEM "entities.xml">
6 %entities;
7
8 ]>
9
10 <table role="serweb">
11   <name>phonebook</name>
12   <version>1</version>
13
14   <description>
15         Phonebook entries of users.
16   </description>
17   <column id="pb.id">
18         <name>id</name>
19         <type>unsigned int</type>
20         <type db="mysql">INT AUTO_INCREMENT</type>
21         <type db="postgres">SERIAL</type>
22         <type db="dbtext">int,auto</type>
23         <description>
24           Unique id of the row. The value is auto generated by the databsae
25           server.
26         </description>
27   </column>
28
29   <column id="pb.uid">
30         <name>uid</name>
31         <name db="oracle">uuid</name>
32         <type>string</type>
33         <size>&id_len;</size>
34         <description>
35           UID (Unique ID) of the user who owns the entry.
36         </description>
37   </column>
38
39   <column>
40         <name>fname</name>
41         <type>string</type>
42         <size>32</size>
43         <null/>
44         <description>
45           First name of the phonebook contact.
46         </description>
47   </column>
48
49   <column>
50         <name>lname</name>
51         <type>string</type>
52         <size>32</size>
53         <null/>
54         <description>
55           Last name of the phonebook contact.
56         </description>
57   </column>
58
59   <column>
60         <name>sip_uri</name>
61         <type>string</type>
62         <size>&uri_len;</size>
63         <description>
64           SIP URI of the phonebook contact.
65         </description>
66   </column>
67
68   <index>
69         <name>pb_idx</name>
70         <unique/>
71         <colref linkend="pb.id"/>
72   </index>
73   <index>
74         <name>pb_uid</name>
75         <colref linkend="pb.uid"/>
76   </index>
77 </table>