2 # Attempt to put an event containing many overrides
5 URL=http://regression.host/caldav.php/User%20Six/home/c0f7c860-1345-012d-125f-002421a2359e.ics
7 HEADER=Content-Type: text/calendar; charset=utf-8
12 PRODID:-//Mozilla.org/NONSGML Mozilla Calendar V1.1//EN
16 X-LIC-LOCATION:Europe/Zagreb
21 DTSTART:19700329T020000
22 RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=3
28 DTSTART:19701025T030000
29 RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=10
33 CREATED:20101126T133639Z
34 LAST-MODIFIED:20101126T133639Z
35 DTSTAMP:20101126T133640Z
36 UID:KOrganizer-1348288421.174
37 SUMMARY:Kosarkaska utakmica
38 DTSTART;TZID=Europe/Zagreb:20101128T110000
39 DTEND;TZID=Europe/Zagreb:20101128T130000
40 LOCATION:Zagrebacki velesajam
44 CREATED:20110402T095510Z
45 LAST-MODIFIED:20110402T095533Z
46 DTSTAMP:20110402T095533Z
47 UID:9fc3d340-fd02-4198-9b7f-bd9b339fdf01
49 DTSTART;TZID=Europe/Zagreb:20110329T193000
50 DTEND;TZID=Europe/Zagreb:20110329T220000
54 CREATED:20110406T222101Z
55 LAST-MODIFIED:20110406T222129Z
56 DTSTAMP:20110406T222129Z
57 UID:b5185f5f-c60d-43e2-8727-d73b05f0b403
59 DTSTART;TZID=Europe/Zagreb:20110408T180000
60 DTEND;TZID=Europe/Zagreb:20110408T210000
64 CREATED:20110405T141057Z
65 LAST-MODIFIED:20110410T105121Z
66 DTSTAMP:20110410T105121Z
67 UID:ad2e3d46-338c-4123-bfed-edf0d06a3f5d
69 DTSTART;TZID=Europe/Zagreb:20110411T120000
70 DTEND;TZID=Europe/Zagreb:20110411T130000
74 CREATED:20110406T222101Z
75 LAST-MODIFIED:20110412T145952Z
76 DTSTAMP:20110412T145952Z
77 UID:97f37cf2-a89a-4eb9-aff7-024e21d4ac63
79 DTSTART;TZID=Europe/Zagreb:20110413T200000
80 DTEND;TZID=Europe/Zagreb:20110413T230000
84 CREATED:20110417T133012Z
85 LAST-MODIFIED:20110417T133033Z
86 DTSTAMP:20110417T133033Z
87 UID:d98993b2-3fc1-4f40-a3b7-1744f2eff118
89 DTSTART;TZID=Europe/Zagreb:20110419T193000
90 DTEND;TZID=Europe/Zagreb:20110419T223000
94 CREATED:20110320T103444Z
95 LAST-MODIFIED:20110509T075204Z
96 DTSTAMP:20110509T075204Z
97 UID:d9600248-ff59-45aa-a08b-d16d09f7443c
99 DTSTART;TZID=Europe/Zagreb:20110509T150000
100 DTEND;TZID=Europe/Zagreb:20110509T160000
105 CREATED:20110320T103420Z
106 LAST-MODIFIED:20110320T103436Z
107 DTSTAMP:20110320T103436Z
108 UID:bf913c7d-8e42-4d30-989b-3f86c3e7f130
110 DTSTART;TZID=Europe/Zagreb:20110322T200000
111 DTEND;TZID=Europe/Zagreb:20110322T230000
115 CREATED:20110414T134428Z
116 LAST-MODIFIED:20110414T134446Z
117 DTSTAMP:20110414T134446Z
118 UID:6d870107-9251-4eb1-baff-9cc9c9d995a0
120 DTSTART;TZID=Europe/Zagreb:20110415T120000
121 DTEND;TZID=Europe/Zagreb:20110415T130000
125 CREATED:20110320T103444Z
126 LAST-MODIFIED:20110320T103513Z
127 DTSTAMP:20110320T103513Z
128 UID:b79f6edf-3b11-439f-85af-7eca5d5e7d6e
130 DTSTART;TZID=Europe/Zagreb:20110321T150000
131 DTEND;TZID=Europe/Zagreb:20110321T160000
136 CREATED:20110405T141057Z
137 LAST-MODIFIED:20110405T141143Z
138 DTSTAMP:20110405T141143Z
139 UID:3bc03dfc-c7e1-4500-ae67-a17c309025e8
140 SUMMARY:Vaterpolo PMF
141 DTSTART;TZID=Europe/Zagreb:20110406T133000
142 DTEND;TZID=Europe/Zagreb:20110406T143000
146 CREATED:20110430T093717Z
147 LAST-MODIFIED:20110430T093741Z
148 DTSTAMP:20110430T093741Z
149 UID:d0fe1e24-25c9-4f1a-a1a5-7e4c38b2a4bd
151 DTSTART;TZID=Europe/Zagreb:20110427T193000
152 DTEND;TZID=Europe/Zagreb:20110427T223000
156 CREATED:20110430T093903Z
157 LAST-MODIFIED:20110503T141014Z
158 DTSTAMP:20110503T141014Z
159 UID:e8835dcb-9c58-446c-8020-1d14e299994b
161 DTSTART;TZID=Europe/Zagreb:20110506T190000
162 DTEND;TZID=Europe/Zagreb:20110506T220000
163 DESCRIPTION:protiv VIDRE\; dvorana u podsusedu
169 CREATED:20110320T103444Z
170 LAST-MODIFIED:20110503T141104Z
171 DTSTAMP:20110503T141104Z
172 UID:631e6b38-c41c-49c6-8902-357650d1332c
174 DTSTART;TZID=Europe/Zagreb:20110502T150000
175 DTEND;TZID=Europe/Zagreb:20110502T160000
180 CREATED:20110320T103444Z
181 LAST-MODIFIED:20110412T145824Z
182 DTSTAMP:20110412T145824Z
183 UID:2f32a2e1-f739-4c1a-920b-a605cc969e25
185 DTSTART;TZID=Europe/Zagreb:20110411T150000
186 DTEND;TZID=Europe/Zagreb:20110411T160000
191 CREATED:20110414T134428Z
192 LAST-MODIFIED:20110416T203013Z
193 DTSTAMP:20110416T203013Z
194 UID:63d93f32-aa1d-4aaf-b0c6-f332689c395b
196 DTSTART;TZID=Europe/Zagreb:20110415T140000
197 DTEND;TZID=Europe/Zagreb:20110415T150000
203 CREATED:20110320T103444Z
204 LAST-MODIFIED:20110417T195943Z
205 DTSTAMP:20110417T195943Z
206 UID:96d9a904-21da-44cf-a818-ace2e24117f3
208 DTSTART;TZID=Europe/Zagreb:20110418T150000
209 DTEND;TZID=Europe/Zagreb:20110418T160000
214 CREATED:20110513T180125Z
215 LAST-MODIFIED:20110513T180150Z
216 DTSTAMP:20110513T180150Z
217 UID:6541bbc5-5054-4482-9656-781fccb1c9c0
219 DTSTART;TZID=Europe/Zagreb:20110513T160000
220 DTEND;TZID=Europe/Zagreb:20110513T170000
221 DESCRIPTION:s filom u dvorani Precko
225 CREATED:20110520T201034Z
226 LAST-MODIFIED:20110520T201057Z
227 DTSTAMP:20110520T201057Z
228 UID:585e23cf-ef43-459a-9ad7-f05ceadc369e
230 DTSTART;TZID=Europe/Zagreb:20110524T190000
231 DTEND;TZID=Europe/Zagreb:20110524T220000
235 CREATED:20110311T213444Z
236 LAST-MODIFIED:20110311T213526Z
237 DTSTAMP:20110311T213526Z
238 UID:abe35ff2-22ca-4abc-84ed-75cd594f152a
240 DTSTART;TZID=Europe/Zagreb:20110311T190000
241 DTEND;TZID=Europe/Zagreb:20110311T220000
243 DESCRIPTION:igramo protiv STK Rugvice
247 CREATED:20110314T195438Z
248 LAST-MODIFIED:20110314T195500Z
249 DTSTAMP:20110314T195500Z
250 UID:f1a6d3ca-6070-453f-ae7d-10e204569461
252 DTSTART;TZID=Europe/Zagreb:20110317T200000
253 DTEND;TZID=Europe/Zagreb:20110317T210000
254 DESCRIPTION:protiv Mladih purgera
258 CREATED:20110320T103444Z
259 LAST-MODIFIED:20110328T181956Z
260 DTSTAMP:20110328T181956Z
261 UID:db31907b-1b8a-4f70-aa8e-e2c86ffc125a
263 DTSTART;TZID=Europe/Zagreb:20110328T150000
264 DTEND;TZID=Europe/Zagreb:20110328T160000
269 CREATED:20110602T091841Z
270 LAST-MODIFIED:20110602T091933Z
271 DTSTAMP:20110602T091933Z
272 UID:158bce95-0f67-4cfc-9cc0-df42603a7497
274 DTSTART;TZID=Europe/Zagreb:20110606T193000
275 DTEND;TZID=Europe/Zagreb:20110606T230000
279 CREATED:20110603T144349Z
280 LAST-MODIFIED:20110603T144405Z
281 DTSTAMP:20110603T144405Z
282 UID:e0b1fbe6-885e-447b-8811-0d0dafc7cc9a
284 DTSTART;TZID=Europe/Zagreb:20110603T100000
285 DTEND;TZID=Europe/Zagreb:20110603T130000
289 CREATED:20110605T191628Z
290 LAST-MODIFIED:20110605T191643Z
291 DTSTAMP:20110605T191643Z
292 UID:d59ca055-4396-442c-af99-5c45cfd8e75d
294 DTSTART;TZID=Europe/Zagreb:20110604T180000
295 DTEND;TZID=Europe/Zagreb:20110604T210000
299 CREATED:20110607T222032Z
300 LAST-MODIFIED:20110607T222045Z
301 DTSTAMP:20110607T222045Z
302 UID:6ec29b6e-c8f3-40b3-87d3-d7ebe742a8cc
304 DTSTART;TZID=Europe/Zagreb:20110606T150000
305 DTEND;TZID=Europe/Zagreb:20110606T160000
309 CREATED:20111007T155910Z
310 LAST-MODIFIED:20111007T155930Z
311 DTSTAMP:20111007T155930Z
312 UID:807b2e3b-6bc1-4fd4-8002-6a4a3d6ab210
314 DTSTART;TZID=Europe/Zagreb:20111010T200000
315 DTEND;TZID=Europe/Zagreb:20111010T230000
319 CREATED:20111009T102456Z
320 LAST-MODIFIED:20111009T102524Z
321 DTSTAMP:20111009T102524Z
322 UID:17848910-224e-4b2e-82a1-880e7579fc09
324 DTSTART;TZID=Europe/Zagreb:20111009T190000
325 DTEND;TZID=Europe/Zagreb:20111009T210000
327 DESCRIPTION:trening s najmanom na faksu
331 CREATED:20111010T141132Z
332 LAST-MODIFIED:20111010T141158Z
333 DTSTAMP:20111010T141158Z
334 UID:1dc66abb-d265-4115-bed1-8647076b6a6e
336 DTSTART;TZID=Europe/Zagreb:20111014T203000
337 DTEND;TZID=Europe/Zagreb:20111014T230000
338 DESCRIPTION:Odra Vex dizajn
342 CREATED:20111014T073351Z
343 LAST-MODIFIED:20111014T073406Z
344 DTSTAMP:20111014T073406Z
345 UID:40881d4c-03b1-4bd6-9486-47c88e42d4a9
347 DTSTART;TZID=Europe/Zagreb:20111011T190000
348 DTEND;TZID=Europe/Zagreb:20111011T200000
352 CREATED:20111015T174624Z
353 LAST-MODIFIED:20111015T174705Z
354 DTSTAMP:20111015T174705Z
355 UID:9d8b6e90-6ba9-4bec-8000-e1f9609b84a7
357 DTSTART;TZID=Europe/Zagreb:20111015T170000
358 DTEND;TZID=Europe/Zagreb:20111015T190000
362 CREATED:20111016T111311Z
363 LAST-MODIFIED:20111016T111339Z
364 DTSTAMP:20111016T111339Z
365 UID:8f2601db-6537-40aa-91b5-3bff62c6aaeb
367 DTSTART;TZID=Europe/Zagreb:20111018T193000
368 DTEND;TZID=Europe/Zagreb:20111018T220000
372 CREATED:20111022T125946Z
373 LAST-MODIFIED:20111022T130003Z
374 DTSTAMP:20111022T130003Z
375 UID:c606f5b2-4519-4b4c-9010-96ca6d301e70
377 DTSTART;TZID=Europe/Zagreb:20111022T100000
378 DTEND;TZID=Europe/Zagreb:20111022T120000
382 CREATED:20111022T125946Z
383 LAST-MODIFIED:20111022T130030Z
384 DTSTAMP:20111022T130030Z
385 UID:178d87de-d399-422f-955c-3d8867a7f384
387 DTSTART;TZID=Europe/Zagreb:20111023T100000
388 DTEND;TZID=Europe/Zagreb:20111023T120000
392 CREATED:20111007T155910Z
393 LAST-MODIFIED:20111026T212929Z
394 DTSTAMP:20111026T212929Z
395 UID:104e403e-9639-4316-813f-e843520901a5
397 DTSTART;TZID=Europe/Zagreb:20111028T203000
398 DTEND;TZID=Europe/Zagreb:20111028T233000
402 CREATED:20111111T094915Z
403 LAST-MODIFIED:20111111T094932Z
404 DTSTAMP:20111111T094932Z
405 UID:64804e8e-fef5-46e3-b2a2-b494d9120dc1
407 DTSTART;TZID=Europe/Zagreb:20111111T190000
408 DTEND;TZID=Europe/Zagreb:20111111T213000
412 CREATED:20111113T175921Z
413 LAST-MODIFIED:20111113T175937Z
414 DTSTAMP:20111113T175937Z
415 UID:72181664-03b7-4789-90a0-8bbec9300b5c
417 DTSTART;TZID=Europe/Zagreb:20111116T193000
418 DTEND;TZID=Europe/Zagreb:20111116T220000
422 CREATED:20111126T133916Z
423 LAST-MODIFIED:20111126T133937Z
424 DTSTAMP:20111126T133937Z
425 UID:f3f56428-d648-4d8a-9174-57927d74e346
427 DTSTART;TZID=Europe/Zagreb:20111124T193000
428 DTEND;TZID=Europe/Zagreb:20111124T223000
432 CREATED:20111126T133916Z
433 LAST-MODIFIED:20111126T134122Z
434 DTSTAMP:20111126T134122Z
435 UID:548df49b-2451-4224-bd7b-5780dd93a19e
437 DTSTART;TZID=Europe/Zagreb:20111201T193000
438 DTEND;TZID=Europe/Zagreb:20111201T223000
442 CREATED:20111014T073351Z
443 LAST-MODIFIED:20111127T154401Z
444 DTSTAMP:20111127T154401Z
445 UID:154529bd-dcd2-43ad-900e-050a4d22f3a1
447 RRULE:FREQ=WEEKLY;UNTIL=20111220T180000Z;BYDAY=MO,TH
448 DTSTART;TZID=Europe/Zagreb:20111013T190000
449 DTEND;TZID=Europe/Zagreb:20111013T200000
455 CREATED:20111126T134122Z
456 LAST-MODIFIED:20111126T134129Z
457 DTSTAMP:20111126T134129Z
458 UID:154529bd-dcd2-43ad-900e-050a4d22f3a1
460 RECURRENCE-ID;TZID=Europe/Zagreb:20111201T190000
461 DTSTART;TZID=Europe/Zagreb:20111130T190000
462 DTEND;TZID=Europe/Zagreb:20111130T200000
468 CREATED:20111127T154352Z
469 LAST-MODIFIED:20111127T154401Z
470 DTSTAMP:20111127T154401Z
471 UID:154529bd-dcd2-43ad-900e-050a4d22f3a1
473 RECURRENCE-ID;TZID=Europe/Zagreb:20111205T190000
474 DTSTART;TZID=Europe/Zagreb:20111206T190000
475 DTEND;TZID=Europe/Zagreb:20111206T200000
484 SELECT caldav_data.caldav_data AS "Event Data", caldav_data.dav_name, caldav_data.dav_etag, dtstart, summary, description
485 FROM caldav_data JOIN calendar_item USING(dav_name)
486 WHERE caldav_data.dav_name ~ 'c0f7c860-1345-012d-125f-002421a2359e.ics'