cleanup remove tabs
[tine20] / tine20 / Phone / Setup / setup.xml
1 <?xml version="1.0" encoding="utf-8"?>
2 <application>
3     <name>Phone</name>
4     <version>8.0</version>
5     <order>11</order>
6     <depends>
7         <application>Admin</application>
8         <application>Voipmanager</application>
9     </depends>
10     <tables>
11         <table>
12             <name>phone_extensions</name>
13             <version>2</version>
14             <declaration>
15                 <field>
16                     <name>id</name>
17                     <type>integer</type>
18                     <autoincrement>true</autoincrement>
19                 </field>
20                 <field>
21                     <name>account_id</name>
22                     <type>text</type>
23                     <length>40</length>
24                     <notnull>true</notnull>
25                 </field>
26                 <field>
27                     <name>device</name>
28                     <type>text</type>
29                     <length>128</length>
30                     <notnull>true</notnull>
31                 </field>
32                 <field>
33                     <name>context</name>
34                     <type>text</type>
35                     <length>128</length>
36                     <notnull>true</notnull>
37                 </field>
38                 <field>
39                     <name>callerid</name>
40                     <type>text</type>
41                     <length>128</length>
42                     <notnull>true</notnull>
43                 </field>
44                 <index>
45                     <name>id</name>
46                     <primary>true</primary>
47                     <field>
48                         <name>id</name>
49                     </field>
50                 </index>
51                 <index>
52                     <name>account_id-device-context</name>
53                     <unique>true</unique>
54                     <field>
55                         <name>account_id</name>
56                     </field>
57                     <field>
58                         <name>device</name>
59                     </field>
60                     <field>
61                         <name>context</name>
62                     </field>
63                 </index>
64             </declaration>
65         </table>
66         <table>
67             <!-- @todo add constraints to phone_id/line_id? -->
68             <name>phone_callhistory</name>
69             <version>2</version>
70             <declaration>
71                 <field>
72                     <name>id</name>
73                     <type>text</type>
74                     <length>40</length>
75                     <notnull>true</notnull>
76                 </field>
77                 <field>
78                     <name>line_id</name>
79                     <type>text</type>
80                     <length>40</length>
81                     <notnull>true</notnull>
82                 </field>
83                 <field>
84                     <name>phone_id</name>
85                     <type>text</type>
86                     <length>40</length>
87                     <notnull>true</notnull>
88                 </field>
89                 <field>
90                     <name>callerid</name>
91                     <type>text</type>
92                     <length>80</length>
93                     <notnull>false</notnull>
94                 </field>
95                 <field>
96                     <name>start</name>
97                     <type>datetime</type>
98                 </field>
99                 <field>
100                     <name>connected</name>
101                     <type>datetime</type>
102                 </field>
103                 <field>
104                     <name>disconnected</name>
105                     <type>datetime</type>
106                 </field>
107                 <field>
108                     <name>duration</name>
109                     <type>integer</type>
110                 </field>
111                 <field>
112                     <name>ringing</name>
113                     <type>integer</type>
114                 </field>
115                 <field>
116                     <name>direction</name>
117                     <type>text</type>
118                     <length>32</length>
119                     <default>in</default>
120                     <notnull>true</notnull>
121                 </field>
122                 <field>
123                     <name>source</name>
124                     <type>text</type>
125                     <length>64</length>
126                     <notnull>true</notnull>
127                 </field>
128                 <field>
129                     <name>destination</name>
130                     <type>text</type>
131                     <length>64</length>
132                     <notnull>true</notnull>
133                 </field>
134                 <index>
135                     <name>id</name>
136                     <primary>true</primary>
137                     <field>
138                         <name>id</name>
139                     </field>
140                     <field>
141                         <name>phone_id</name>
142                     </field>
143                 </index>
144             </declaration>
145         </table>
146     </tables>
147 </application>