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