cleanup remove tabs
[tine20] / tine20 / Timetracker / Setup / setup.xml
1 <?xml version="1.0" encoding="utf-8"?>
2 <application>
3     <name>Timetracker</name>
4     <!-- gettext('Timetracker') -->   
5     <version>8.0</version>
6     <order>60</order>
7     <status>enabled</status>
8     <depends>
9         <application>Tinebase</application>
10     </depends>
11     <tables>
12         <table>
13             <name>timetracker_timeaccount</name>
14             <version>9</version>
15             <declaration>
16                 <field>
17                     <name>id</name>
18                     <type>text</type>
19                     <length>40</length>
20                     <notnull>true</notnull>
21                 </field>
22                 <field>
23                     <name>container_id</name>
24                     <type>integer</type>
25                     <notnull>false</notnull>
26                 </field>
27                 <field>
28                     <name>title</name>
29                     <type>text</type>
30                     <length>256</length>
31                     <notnull>true</notnull>
32                 </field>
33                 <field>
34                     <name>number</name>
35                     <type>text</type>
36                     <length>128</length>
37                 </field>
38                 <field>
39                     <name>description</name>
40                     <type>text</type>
41                 </field>
42                 <field>
43                     <name>budget</name>
44                     <type>float</type>
45                 </field>
46                 <field>
47                     <name>budget_unit</name>
48                     <type>text</type>
49                     <length>128</length>
50                 </field>
51                 <field>
52                     <name>price</name>
53                     <type>float</type>
54                 </field>
55                 <field>
56                     <name>price_unit</name>
57                     <type>text</type>
58                     <length>128</length>
59                 </field>
60                 <field>
61                     <name>is_open</name>
62                     <type>boolean</type>
63                     <default>true</default>
64                 </field>
65                 <field>
66                     <name>is_billable</name>
67                     <type>boolean</type>
68                     <default>true</default>
69                 </field>
70                 <field>
71                     <name>billed_in</name>
72                     <type>text</type>
73                     <length>256</length>
74                     <notnull>false</notnull>
75                 </field>
76                 <field>
77                     <name>status</name>
78                     <type>text</type>
79                     <length>32</length>
80                     <default>not yet billed</default>
81                     <!-- gettext('not yet billed') -->
82                     <!-- gettext('to bill') -->
83                     <!-- gettext('billed') -->
84                     <notnull>true</notnull>
85                 </field>
86                 <field>
87                     <name>cleared_at</name>
88                     <type>datetime</type>
89                 </field>
90                 <field>
91                     <name>deadline</name>
92                     <type>text</type>
93                     <length>256</length>
94                     <notnull>false</notnull>
95                 </field>
96                 <field>
97                     <name>created_by</name>
98                     <type>text</type>
99                     <length>40</length>
100                 </field>
101                 <field>
102                     <name>creation_time</name>
103                     <type>datetime</type>
104                 </field> 
105                 <field>
106                     <name>last_modified_by</name>
107                     <type>text</type>
108                     <length>40</length>
109                 </field>
110                 <field>
111                     <name>last_modified_time</name>
112                     <type>datetime</type>
113                 </field>
114                 <field>
115                     <name>is_deleted</name>
116                     <type>boolean</type>
117                     <default>false</default>
118                 </field>
119                 <field>
120                     <name>deleted_by</name>
121                     <type>text</type>
122                     <length>40</length>
123                 </field>
124                 <field>
125                     <name>deleted_time</name>
126                     <type>datetime</type>
127                 </field>
128                 <field>
129                     <name>seq</name>
130                     <type>integer</type>
131                     <notnull>true</notnull>
132                     <default>0</default>
133                 </field>
134                 <index>
135                     <name>id</name>
136                     <primary>true</primary>
137                     <field>
138                         <name>id</name>
139                     </field>
140                 </index>
141                 <index>
142                     <name>title</name>
143                     <field>
144                         <name>title</name>
145                     </field>
146                 </index>
147                 <index>
148                     <name>number</name>
149                     <field>
150                         <name>number</name>
151                     </field>
152                 </index>
153                 <index>
154                     <name>timeaccount::container_id--container::id</name>
155                     <field>
156                         <name>container_id</name>
157                     </field>
158                     <foreign>true</foreign>
159                     <reference>
160                         <table>container</table>
161                         <field>id</field>
162                     </reference>
163                 </index>
164             </declaration>
165         </table>
166         <table>
167             <name>timetracker_timesheet</name>
168             <version>3</version>
169             <declaration>
170                 <field>
171                     <name>id</name>
172                     <type>text</type>
173                     <length>40</length>
174                     <notnull>true</notnull>
175                 </field>
176                 <field>
177                     <name>account_id</name>
178                     <type>text</type>
179                     <length>40</length>
180                     <notnull>true</notnull>
181                 </field>
182                 <field>
183                     <name>timeaccount_id</name>
184                     <type>text</type>
185                     <length>40</length>
186                     <notnull>false</notnull>
187                 </field>
188                 <field>
189                     <name>is_billable</name>
190                     <type>boolean</type>
191                     <default>true</default>
192                 </field>
193                 <field>
194                     <name>billed_in</name>
195                     <type>text</type>
196                     <length>256</length>
197                     <notnull>false</notnull>
198                 </field>
199                 <field>
200                     <name>is_cleared</name>
201                     <type>boolean</type>
202                     <default>false</default>
203                 </field>
204                 <field>
205                     <name>cleared_time</name>
206                     <type>datetime</type>
207                 </field>
208                 <field>
209                     <name>start_date</name>
210                     <type>date</type>
211                 </field>
212                 <field>
213                     <name>start_time</name>
214                     <type>time</type>
215                 </field>
216                 <field>
217                     <name>duration</name>
218                     <type>integer</type>
219                 </field>
220                 <field>
221                     <name>description</name>
222                     <type>text</type>
223                 </field>
224                 <field>
225                     <name>created_by</name>
226                     <type>text</type>
227                     <length>40</length>
228                 </field>
229                 <field>
230                     <name>creation_time</name>
231                     <type>datetime</type>
232                 </field> 
233                 <field>
234                     <name>last_modified_by</name>
235                     <type>text</type>
236                     <length>40</length>
237                 </field>
238                 <field>
239                     <name>last_modified_time</name>
240                     <type>datetime</type>
241                 </field>
242                 <field>
243                     <name>is_deleted</name>
244                     <type>boolean</type>
245                     <default>false</default>
246                 </field>
247                 <field>
248                     <name>deleted_by</name>
249                     <type>text</type>
250                     <length>40</length>
251                 </field>
252                 <field>
253                     <name>deleted_time</name>
254                     <type>datetime</type>
255                 </field>
256                 <field>
257                     <name>seq</name>
258                     <type>integer</type>
259                     <notnull>true</notnull>
260                     <default>0</default>
261                 </field>
262                 <index>
263                     <name>id</name>
264                     <primary>true</primary>
265                     <field>
266                         <name>id</name>
267                     </field>
268                 </index>
269                 <index>
270                     <name>start_date</name>
271                     <field>
272                         <name>start_date</name>
273                     </field>
274                 </index>
275                 <index>
276                     <name>timesheet::timeaccount_id--timeaccount::id</name>
277                     <field>
278                         <name>timeaccount_id</name>
279                     </field>
280                     <foreign>true</foreign>
281                     <reference>
282                         <table>timetracker_timeaccount</table>
283                         <field>id</field>
284                     </reference>
285                 </index>
286             </declaration>
287         </table>
288     </tables>
289 </application>
290