cleanup remove tabs
[tine20] / tine20 / Calendar / Setup / setup.xml
1 <?xml version="1.0" encoding="utf-8"?>
2 <application>
3     <name>Calendar</name>
4     <!-- gettext('Calendar') -->   
5     <version>8.0</version>
6     <order>15</order>
7     <status>enabled</status>
8     <tables>
9         <!-- events -->
10         <table>
11             <name>cal_events</name>
12             <version>6</version>
13             <declaration>
14                 <field>
15                     <name>id</name>
16                     <type>text</type>
17                     <length>40</length>
18                     <notnull>true</notnull>
19                 </field>
20                 <field>
21                     <name>container_id</name>
22                     <type>integer</type>
23                 </field>
24                 <field>
25                     <name>created_by</name>
26                     <type>text</type>
27                     <length>40</length>
28                 </field>
29                 <field>
30                     <name>creation_time</name>
31                     <type>datetime</type>
32                 </field> 
33                 <field>
34                     <name>last_modified_by</name>
35                     <type>text</type>
36                     <length>40</length>
37                 </field>
38                 <field>
39                     <name>last_modified_time</name>
40                     <type>datetime</type>
41                 </field>
42                 <field>
43                     <name>is_deleted</name>
44                     <type>boolean</type>
45                     <default>false</default>
46                 </field>
47                 <field>
48                     <name>deleted_by</name>
49                     <type>text</type>
50                     <length>40</length>
51                 </field>
52                 <field>
53                     <name>deleted_time</name>
54                     <type>datetime</type>
55                 </field>
56                 <field>
57                     <name>seq</name>
58                     <type>integer</type>
59                     <notnull>true</notnull>
60                     <default>0</default>
61                 </field>
62                 <field>
63                     <name>dtend</name>
64                     <type>datetime</type>
65                     <notnull>true</notnull>
66                 </field>
67                 <field>
68                     <name>transp</name>
69                     <type>text</type>
70                     <length>40</length>
71                     <default>OPAQUE</default>
72                 </field>
73                 <field>
74                     <name>class</name>
75                     <type>text</type>
76                     <length>40</length>
77                     <default>PUBLIC</default>
78                     <notnull>true</notnull>
79                 </field>
80                 <field>
81                     <name>description</name>
82                     <type>clob</type>
83                 </field>
84                 <field>
85                     <name>geo</name>
86                     <type>float</type>
87                 </field>
88                 <field>
89                     <name>location</name>
90                     <type>text</type>
91                     <length>255</length>
92                 </field>
93                     <field>
94                     <name>organizer</name>
95                     <type>text</type>
96                     <length>40</length>
97                 </field>
98                 <field>
99                     <name>priority</name>
100                     <type>integer</type>
101                 </field>
102                 <field>
103                     <name>status</name>
104                     <type>text</type>
105                     <length>255</length>
106                     <notnull>false</notnull>
107                 </field>
108                 <field>
109                     <name>summary</name>
110                     <type>text</type>
111                     <length>255</length>
112                     <notnull>false</notnull>
113                 </field>
114                 <field>
115                     <name>url</name>
116                     <type>text</type>
117                     <length>255</length>
118                     <notnull>false</notnull>
119                 </field>
120                 <field>
121                     <name>uid</name>
122                     <type>text</type>
123                     <length>255</length>
124                     <notnull>true</notnull>
125                 </field>
126                 <field>
127                     <name>dtstart</name>
128                     <type>datetime</type>
129                 </field>
130                 <field>
131                     <name>recurid</name>
132                     <type>text</type>
133                     <length>255</length>
134                 </field>
135                 <field>
136                     <name>rrule</name>
137                     <type>text</type>
138                     <length>255</length>
139                 </field>
140                 <field>
141                     <name>is_all_day_event</name>
142                     <type>boolean</type>
143                     <default>false</default>
144                 </field>
145                 <field>
146                     <name>rrule_until</name>
147                     <type>datetime</type>
148                 </field>
149                 <field>
150                     <name>originator_tz</name>
151                     <type>text</type>
152                     <length>255</length>
153                 </field>
154                 <index>
155                     <name>id</name>
156                     <primary>true</primary>
157                     <field>
158                         <name>id</name>
159                     </field>
160                 </index>
161                 <index>
162                     <name>cal_events::container_id--container::id</name>
163                     <field>
164                         <name>container_id</name>
165                     </field>
166                     <foreign>true</foreign>
167                     <reference>
168                         <table>container</table>
169                         <field>id</field>
170                     </reference>
171                 </index>
172                 <index>
173                     <name>dtstart</name>
174                     <field>
175                         <name>dtstart</name>
176                     </field>
177                 </index>
178                 <index>
179                     <name>dtend</name>
180                     <field>
181                         <name>dtend</name>
182                     </field>
183                 </index>
184                 <index>
185                     <name>organizer</name>
186                     <field>
187                         <name>organizer</name>
188                     </field>
189                 </index>
190                 <index>
191                     <name>uid</name>
192                     <field>
193                         <name>uid</name>
194                     </field>
195                 </index>
196                 <index>
197                     <name>rrule_until</name>
198                     <field>
199                         <name>rrule_until</name>
200                     </field>
201                 </index>
202                 <index>
203                     <name>class</name>
204                     <field>
205                         <name>class</name>
206                     </field>
207                 </index>
208             </declaration>
209         </table>
210         
211         <!-- exceptions (dates when recuring event does not take palce) -->
212         <table>
213             <name>cal_exdate</name>
214             <version>1</version>
215             <declaration>
216                 <field>
217                     <name>id</name>
218                     <type>text</type>
219                     <length>40</length>
220                     <notnull>true</notnull>
221                 </field>
222                 <field>
223                     <name>cal_event_id</name>
224                     <type>text</type>
225                     <length>40</length>
226                     <notnull>true</notnull>
227                 </field>
228                 <field>
229                     <name>exdate</name>
230                     <type>datetime</type>
231                 </field>
232                 <index>
233                     <name>id</name>
234                     <primary>true</primary>
235                     <field>
236                         <name>id</name>
237                     </field>
238                 </index>
239                 <index>
240                     <name>cal_exdate::cal_event_id-cal_events::id</name>
241                     <field>
242                         <name>cal_event_id</name>
243                     </field>
244                     <foreign>true</foreign>
245                     <reference>
246                         <table>cal_events</table>
247                         <field>id</field>
248                         <ondelete>CASCADE</ondelete>
249                         <!-- add onupdate? -->
250                     </reference>
251                 </index>
252                 <index>
253                     <name>exdate</name>
254                     <field>
255                         <name>exdate</name>
256                     </field>
257                 </index>
258             </declaration>
259         </table>
260         
261         <!-- attendee -->
262         <table>
263             <name>cal_attendee</name>
264             <version>4</version>
265             <declaration>
266                 <field>
267                     <name>id</name>
268                     <type>text</type>
269                     <length>40</length>
270                     <notnull>true</notnull>
271                 </field>
272                 <field>
273                     <name>cal_event_id</name>
274                     <type>text</type>
275                     <length>40</length>
276                     <notnull>true</notnull>
277                 </field>
278                 <field>
279                     <name>user_id</name>
280                     <type>text</type>
281                     <length>40</length>
282                     <notnull>true</notnull>
283                 </field>
284                 <field>
285                     <name>user_type</name>
286                     <type>text</type>
287                     <length>32</length>
288                     <default>user</default>
289                     <notnull>true</notnull>
290                 </field>
291                 <field>
292                     <name>role</name>
293                     <type>text</type>
294                     <length>32</length>
295                     <default>REQ</default>
296                     <notnull>true</notnull>
297                 </field>
298                 <field>
299                     <name>quantity</name>
300                     <type>integer</type>
301                     <notnull>true</notnull>
302                     <default>1</default>
303                 </field>
304                 <field>
305                     <name>status</name>
306                     <type>text</type>
307                     <length>32</length>
308                     <default>NEEDS-ACTION</default>
309                     <notnull>true</notnull>
310                 </field>
311                 <field>
312                     <name>status_authkey</name>
313                     <type>text</type>
314                     <length>40</length>
315                     <notnull>true</notnull>
316                 </field>
317                 <field>
318                     <name>displaycontainer_id</name>
319                     <type>integer</type>
320                 </field>
321                 <field>
322                     <name>transp</name>
323                     <type>text</type>
324                     <length>40</length>
325                     <default>OPAQUE</default>
326                 </field>
327                 <field>
328                     <name>alarm_ack_time</name>
329                     <type>datetime</type>
330                 </field>
331                 <field>
332                     <name>alarm_snooze_time</name>
333                     <type>datetime</type>
334                 </field>
335                 <field>
336                     <name>created_by</name>
337                     <type>text</type>
338                     <length>40</length>
339                 </field>
340                 <field>
341                     <name>creation_time</name>
342                     <type>datetime</type>
343                 </field>
344                 <field>
345                     <name>last_modified_by</name>
346                     <type>text</type>
347                     <length>40</length>
348                 </field>
349                 <field>
350                     <name>last_modified_time</name>
351                     <type>datetime</type>
352                 </field>
353                 <field>
354                     <name>is_deleted</name>
355                     <type>boolean</type>
356                     <default>false</default>
357                 </field>
358                 <field>
359                     <name>deleted_by</name>
360                     <type>text</type>
361                     <length>40</length>
362                 </field>
363                 <field>
364                     <name>deleted_time</name>
365                     <type>datetime</type>
366                 </field>
367                 <field>
368                     <name>seq</name>
369                     <type>integer</type>
370                     <notnull>true</notnull>
371                     <default>0</default>
372                 </field>
373                 <index>
374                     <name>id</name>
375                     <primary>true</primary>
376                     <field>
377                         <name>id</name>
378                     </field>
379                 </index>
380                 <index>
381                     <name>cal_attendee::cal_event_id-cal_events::id</name>
382                     <field>
383                         <name>cal_event_id</name>
384                     </field>
385                     <foreign>true</foreign>
386                     <reference>
387                         <table>cal_events</table>
388                         <field>id</field>
389                         <ondelete>CASCADE</ondelete>
390                         <!-- add onupdate? -->
391                     </reference>
392                 </index>
393                 <index>
394                     <name>user_id</name>
395                     <field>
396                         <name>user_id</name>
397                     </field>
398                 </index>
399                 <index>
400                     <name>user_type</name>
401                     <field>
402                         <name>user_type</name>
403                     </field>
404                 </index>
405                 <index>
406                     <name>status</name>
407                     <field>
408                         <name>status</name>
409                     </field>
410                 </index>
411                 <index>
412                     <name>status_authkey</name>
413                     <field>
414                         <name>status_authkey</name>
415                     </field>
416                 </index>
417                 <index>
418                     <name>cal_attendee::displaycontainer_id--container::id</name>
419                     <field>
420                         <name>displaycontainer_id</name>
421                     </field>
422                     <foreign>true</foreign>
423                     <reference>
424                         <table>container</table>
425                         <field>id</field>
426                     </reference>
427                 </index>
428             </declaration>
429         </table>
430         
431         <!-- resources -->
432         <table>
433             <name>cal_resources</name>
434             <version>2</version>
435             <declaration>
436                 <field>
437                     <name>id</name>
438                     <type>text</type>
439                     <length>40</length>
440                     <notnull>true</notnull>
441                 </field>
442                 <field>
443                     <name>container_id</name>
444                     <type>integer</type>
445                 </field>
446                 <field>
447                     <name>created_by</name>
448                     <type>text</type>
449                     <length>40</length>
450                 </field>
451                 <field>
452                     <name>creation_time</name>
453                     <type>datetime</type>
454                 </field> 
455                 <field>
456                     <name>last_modified_by</name>
457                     <type>text</type>
458                     <length>40</length>
459                 </field>
460                 <field>
461                     <name>last_modified_time</name>
462                     <type>datetime</type>
463                 </field>
464                 <field>
465                     <name>is_deleted</name>
466                     <type>boolean</type>
467                     <default>false</default>
468                 </field>
469                 <field>
470                     <name>deleted_by</name>
471                     <type>text</type>
472                     <length>40</length>
473                 </field>            
474                 <field>
475                     <name>deleted_time</name>
476                     <type>datetime</type>
477                 </field>
478                 <field>
479                     <name>seq</name>
480                     <type>integer</type>
481                     <notnull>true</notnull>
482                     <default>0</default>
483                 </field>
484                 <field>
485                     <name>name</name>
486                     <type>text</type>
487                     <length>255</length>
488                     <notnull>true</notnull>
489                 </field>
490                 <field>
491                     <name>description</name>
492                     <type>text</type>
493                 </field>
494                 <field>
495                     <name>email</name>
496                     <type>text</type>
497                     <length>255</length>
498                     <notnull>true</notnull>
499                 </field>
500                 <field>
501                     <name>is_location</name>
502                     <type>boolean</type>
503                     <default>false</default>
504                 </field>
505                 <index>
506                     <name>id</name>
507                     <primary>true</primary>
508                     <field>
509                         <name>id</name>
510                     </field>
511                 </index>
512                 <index>
513                     <name>name</name>
514                     <field>
515                         <name>name</name>
516                     </field>
517                 </index>
518                 <index>
519                     <name>email</name>
520                     <field>
521                         <name>email</name>
522                     </field>
523                 </index>
524                 <index>
525                     <name>is_location</name>
526                     <field>
527                         <name>is_location</name>
528                     </field>
529                 </index>
530                 <index>
531                     <name>cal_resources::container_id--container::id</name>
532                     <field>
533                         <name>container_id</name>
534                     </field>
535                     <foreign>true</foreign>
536                     <reference>
537                         <table>container</table>
538                         <field>id</field>
539                     </reference>
540                 </index>
541             </declaration>
542         </table>
543     </tables>
544 </application>