f11a2582986e7afdd89b6c3b27c4127d4a1f6622
[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>10.6</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>12</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>text</type>
25                     <length>40</length>
26                     <notnull>false</notnull>
27                 </field>
28                 <field>
29                     <name>title</name>
30                     <type>text</type>
31                     <length>255</length>
32                     <notnull>true</notnull>
33                 </field>
34                 <field>
35                     <name>number</name>
36                     <type>text</type>
37                     <length>128</length>
38                 </field>
39                 <field>
40                     <name>description</name>
41                     <type>text</type>
42                 </field>
43                 <field>
44                     <name>budget</name>
45                     <type>float</type>
46                 </field>
47                 <field>
48                     <name>budget_unit</name>
49                     <type>text</type>
50                     <length>128</length>
51                 </field>
52                 <field>
53                     <name>price</name>
54                     <type>float</type>
55                 </field>
56                 <field>
57                     <name>price_unit</name>
58                     <type>text</type>
59                     <length>128</length>
60                 </field>
61                 <field>
62                     <name>is_open</name>
63                     <type>boolean</type>
64                     <default>true</default>
65                 </field>
66                 <field>
67                     <name>is_billable</name>
68                     <type>boolean</type>
69                     <default>true</default>
70                 </field>
71                 <field>
72                     <name>billed_in</name>
73                     <type>text</type>
74                     <length>255</length>
75                     <notnull>false</notnull>
76                 </field>
77                 <field>
78                     <name>invoice_id</name>
79                     <type>text</type>
80                     <length>40</length>
81                     <notnull>false</notnull>
82                 </field>
83                 <field>
84                     <name>status</name>
85                     <type>text</type>
86                     <length>32</length>
87                     <default>not yet billed</default>
88                     <!-- gettext('not yet billed') -->
89                     <!-- gettext('to bill') -->
90                     <!-- gettext('billed') -->
91                     <notnull>true</notnull>
92                 </field>
93                 <field>
94                     <name>cleared_at</name>
95                     <type>datetime</type>
96                 </field>
97                 <field>
98                     <name>deadline</name>
99                     <type>text</type>
100                     <length>255</length>
101                     <notnull>false</notnull>
102                 </field>
103                 <field>
104                     <name>created_by</name>
105                     <type>text</type>
106                     <length>40</length>
107                 </field>
108                 <field>
109                     <name>creation_time</name>
110                     <type>datetime</type>
111                 </field> 
112                 <field>
113                     <name>last_modified_by</name>
114                     <type>text</type>
115                     <length>40</length>
116                 </field>
117                 <field>
118                     <name>last_modified_time</name>
119                     <type>datetime</type>
120                 </field>
121                 <field>
122                     <name>is_deleted</name>
123                     <type>boolean</type>
124                     <default>false</default>
125                 </field>
126                 <field>
127                     <name>deleted_by</name>
128                     <type>text</type>
129                     <length>40</length>
130                 </field>
131                 <field>
132                     <name>deleted_time</name>
133                     <type>datetime</type>
134                 </field>
135                 <field>
136                     <name>seq</name>
137                     <type>integer</type>
138                     <notnull>true</notnull>
139                     <default>0</default>
140                 </field>
141                 <index>
142                     <name>id</name>
143                     <primary>true</primary>
144                     <field>
145                         <name>id</name>
146                     </field>
147                 </index>
148                 <index>
149                     <name>title</name>
150                     <field>
151                         <name>title</name>
152                     </field>
153                 </index>
154                 <index>
155                     <name>number</name>
156                     <field>
157                         <name>number</name>
158                     </field>
159                 </index>
160                 <index>
161                     <name>timeaccount::container_id--container::id</name>
162                     <field>
163                         <name>container_id</name>
164                     </field>
165                     <foreign>true</foreign>
166                     <reference>
167                         <table>container</table>
168                         <field>id</field>
169                     </reference>
170                 </index>
171                 <index>
172                     <name>description</name>
173                     <fulltext>true</fulltext>
174                     <field>
175                         <name>description</name>
176                     </field>
177                 </index>
178             </declaration>
179         </table>
180         <table>
181             <name>timetracker_timesheet</name>
182             <version>6</version>
183             <declaration>
184                 <field>
185                     <name>id</name>
186                     <type>text</type>
187                     <length>40</length>
188                     <notnull>true</notnull>
189                 </field>
190                 <field>
191                     <name>account_id</name>
192                     <type>text</type>
193                     <length>40</length>
194                     <notnull>true</notnull>
195                 </field>
196                 <field>
197                     <name>timeaccount_id</name>
198                     <type>text</type>
199                     <length>40</length>
200                     <notnull>false</notnull>
201                 </field>
202                 <field>
203                     <name>is_billable</name>
204                     <type>boolean</type>
205                     <default>true</default>
206                 </field>
207                 <field>
208                     <name>billed_in</name>
209                     <type>text</type>
210                     <length>255</length>
211                     <notnull>false</notnull>
212                 </field>
213                 <field>
214                     <name>invoice_id</name>
215                     <type>text</type>
216                     <length>40</length>
217                     <notnull>false</notnull>
218                 </field>
219                 <field>
220                     <name>is_cleared</name>
221                     <type>boolean</type>
222                     <default>false</default>
223                 </field>
224                 <field>
225                     <name>start_date</name>
226                     <type>date</type>
227                 </field>
228                 <field>
229                     <name>start_time</name>
230                     <type>time</type>
231                 </field>
232                 <field>
233                     <name>duration</name>
234                     <type>integer</type>
235                 </field>
236                 <field>
237                     <name>description</name>
238                     <type>text</type>
239                 </field>
240                 <field>
241                     <name>created_by</name>
242                     <type>text</type>
243                     <length>40</length>
244                 </field>
245                 <field>
246                     <name>creation_time</name>
247                     <type>datetime</type>
248                 </field> 
249                 <field>
250                     <name>last_modified_by</name>
251                     <type>text</type>
252                     <length>40</length>
253                 </field>
254                 <field>
255                     <name>last_modified_time</name>
256                     <type>datetime</type>
257                 </field>
258                 <field>
259                     <name>is_deleted</name>
260                     <type>boolean</type>
261                     <default>false</default>
262                 </field>
263                 <field>
264                     <name>deleted_by</name>
265                     <type>text</type>
266                     <length>40</length>
267                 </field>
268                 <field>
269                     <name>deleted_time</name>
270                     <type>datetime</type>
271                 </field>
272                 <field>
273                     <name>seq</name>
274                     <type>integer</type>
275                     <notnull>true</notnull>
276                     <default>0</default>
277                 </field>
278                 <index>
279                     <name>id</name>
280                     <primary>true</primary>
281                     <field>
282                         <name>id</name>
283                     </field>
284                 </index>
285                 <index>
286                     <name>start_date</name>
287                     <field>
288                         <name>start_date</name>
289                     </field>
290                 </index>
291                 <index>
292                     <name>timesheet::timeaccount_id--timeaccount::id</name>
293                     <field>
294                         <name>timeaccount_id</name>
295                     </field>
296                     <foreign>true</foreign>
297                     <reference>
298                         <table>timetracker_timeaccount</table>
299                         <field>id</field>
300                     </reference>
301                 </index>
302                 <index>
303                     <name>description</name>
304                     <fulltext>true</fulltext>
305                     <field>
306                         <name>description</name>
307                     </field>
308                 </index>
309             </declaration>
310         </table>
311         <table>
312             <name>timetracker_timeaccount_fav</name>
313             <version>1</version>
314             <declaration>
315                 <field>
316                     <name>id</name>
317                     <type>text</type>
318                     <length>40</length>
319                     <notnull>true</notnull>
320                 </field>
321                 <field>
322                     <name>account_id</name>
323                     <type>text</type>
324                     <length>40</length>
325                     <notnull>true</notnull>
326                 </field>
327                 <field>
328                     <name>timeaccount_id</name>
329                     <type>text</type>
330                     <length>40</length>
331                     <notnull>false</notnull>
332                 </field>
333                 <field>
334                     <name>created_by</name>
335                     <type>text</type>
336                     <length>40</length>
337                 </field>
338                 <field>
339                     <name>creation_time</name>
340                     <type>datetime</type>
341                 </field>
342                 <field>
343                     <name>last_modified_by</name>
344                     <type>text</type>
345                     <length>40</length>
346                 </field>
347                 <field>
348                     <name>last_modified_time</name>
349                     <type>datetime</type>
350                 </field>
351                 <field>
352                     <name>is_deleted</name>
353                     <type>boolean</type>
354                     <default>false</default>
355                 </field>
356                 <field>
357                     <name>deleted_by</name>
358                     <type>text</type>
359                     <length>40</length>
360                 </field>
361                 <field>
362                     <name>deleted_time</name>
363                     <type>datetime</type>
364                 </field>
365                 <index>
366                     <name>id</name>
367                     <primary>true</primary>
368                     <field>
369                         <name>id</name>
370                     </field>
371                 </index>
372                 <index>
373                     <name>timesheet_favorites--timesheet_id::id</name>
374                     <field>
375                         <name>timeaccount_id</name>
376                     </field>
377                     <foreign>true</foreign>
378                     <reference>
379                         <table>timetracker_timeaccount</table>
380                         <field>id</field>
381                     </reference>
382                 </index>
383                 <index>
384                     <name>timesheet_favorites--account_id::id</name>
385                     <field>
386                         <name>account_id</name>
387                     </field>
388                     <foreign>true</foreign>
389                     <reference>
390                         <table>accounts</table>
391                         <field>id</field>
392                         <ondelete>CASCADE</ondelete>
393                     </reference>
394                 </index>
395             </declaration>
396         </table>
397     </tables>
398 </application>
399