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