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