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