1# 2# PUT an event with a non-standard timezone 3# 4# There is no CalDAV defined behaviour for this. 5# 6TYPE=PUT 7URL=http://regression.host/caldav.php/user1/home/PUT-eastern-time.ics 8HEADER=User-Agent: DAViCal Testing/0.9.x 9HEADER=Content-Type: text/calendar; charset=utf-8 10 11HEAD 12 13BEGINDATA 14BEGIN:VCALENDAR 15CALSCALE:GREGORIAN 16PRODID:-//Ximian//NONSGML Evolution Calendar//EN 17VERSION:2.0 18BEGIN:VTIMEZONE 19TZID:(UTC-05:00) Eastern Time (US & Canada) 20BEGIN:STANDARD 21DTSTART:16010101T020000 22TZOFFSETFROM:-0400 23TZOFFSETTO:-0500 24RRULE:FREQ=YEARLY;INTERVAL=1;BYDAY=1SU;BYMONTH=11 25END:STANDARD 26BEGIN:DAYLIGHT 27DTSTART:16010101T020000 28TZOFFSETFROM:-0500 29TZOFFSETTO:-0400 30RRULE:FREQ=YEARLY;INTERVAL=1;BYDAY=2SU;BYMONTH=3 31END:DAYLIGHT 32END:VTIMEZONE 33BEGIN:VEVENT 34UID:PUT-eastern-time 35DTSTAMP:20101009T214524Z 36SUMMARY;LANGUAGE=en-US:Psychic's Anonymous Meeting 37DTSTART;TZID="(UTC-05:00) Eastern Time (US & Canada)":20110912T110000 38DTEND;TZID="(UTC-05:00) Eastern Time (US & Canada)":20110912T113000 39LOCATION:You will know when you arrive 40CREATED:20101010T014639 41LAST-MODIFIED:20101010T014639 42END:VEVENT 43END:VCALENDAR 44ENDDATA 45 46QUERY 47SELECT caldav_data.user_no, caldav_data.dav_etag, caldav_type, logged_user, 48 uid, dtstamp, dtstart at time zone olson_name as dtstart, dtend at time zone olson_name as dtend, due, summary, location, 49 description, priority, class, transp, rrule, url, 50 percent_complete, tz_id, status, 51 caldav_data AS " CalDAV Data", calendar_item.last_modified 52FROM caldav_data JOIN calendar_item USING(dav_name) JOIN timezones ON (tz_id=tzid) 53WHERE caldav_data.dav_name = 54'/user1/home/PUT-eastern-time.ics' 55ENDQUERY 56