2 # We now have a calendar so we can PUT an event into it...
4 URL=http://regression.host/caldav.php/user1/home/F56B49B10FC923D20FE2DC92D6580340-0.ics
5 HEADER=Content-Type: text/calendar; charset=utf-8
6 HEADER=If-Match: "b000d7defa19ccb7cd21e546b54155ee"
12 PRODID:-//mulberrymail.com//Mulberry v4.0//EN
16 LAST-MODIFIED:20040110T032845Z
17 TZID:New Zealand Standard Time
18 X-LIC-LOCATION:Pacific/Auckland
20 DTSTART:20000404T020000
21 RRULE:FREQ=YEARLY;BYDAY=1SU;BYMONTH=4
27 DTSTART:20001026T020000
28 RRULE:FREQ=YEARLY;BYDAY=1SU;BYMONTH=10
35 DTSTAMP:20061107T031419Z
36 DTSTART;TZID=New Zealand Standard Time:20061025T091500
38 SUMMARY:A first event, modified.
39 UID:B18CBB57295D01D7661A6DD4@D76FAF7B10D9E8D2D41F779C
44 # at time zone 'GMT' AS dtstamp,
46 SELECT caldav_data.user_no, caldav_type, logged_user, uid,
48 dtstart at time zone olson_name as dtstart,
49 dtend at time zone olson_name as dtend,
50 due, summary, location,
51 description, priority, class, transp, rrule, url,
52 percent_complete, tz_id, status,
53 calendar_item.last_modified,
54 caldav_data AS "A1 CalDAV DATA"
55 FROM caldav_data JOIN calendar_item USING(dav_name) JOIN timezones ON (tz_id=tzid)
56 WHERE caldav_data.dav_name ~ '^/user1/home/'