2 # PUT an caldav4j regression testing event into the database
4 # Note that although this event appears to refer to the NY time
5 # zone it does not reference it, since DTSTART/DTEND are VALLUE=DATE
6 # which may not reference a timezone.
9 URL=http://regression.host/caldav.php/user1/collection/All_Day_NY_JAN1.ics
10 HEADER=Content-Type: text/calendar
11 HEADER=User-Agent: Jakarta Commons-HttpClient/3.0
17 PRODID:-//OSAF//NONSGML Scoooby Server//EN
22 LAST-MODIFIED:20051220T211408Z
24 DTSTART:20051030T060000
30 DTSTART:20060402T010000
37 DTSTART;VALUE=DATE:20060101
38 DTEND;VALUE=DATE:20060102
39 SUMMARY:All_Day_NY_JAN1
40 UID:C68DADAD-37CE-44F7-8A37-52E1D02E29CA
42 DTSTAMP:20090515T095326Z
49 SELECT caldav_data.user_no, caldav_data.dav_etag, caldav_type, logged_user,
50 uid, dtstamp, dtstart, dtend, due, summary, location,
51 description, priority, class, transp, rrule, url,
52 percent_complete, tz_id, status,
53 caldav_data AS " CalDAV Data", calendar_item.last_modified
54 FROM caldav_data LEFT JOIN calendar_item USING(dav_name) LEFT JOIN timezones ON (tz_id=tzid)
55 WHERE caldav_data.dav_name =
56 '/user1/collection/All_Day_NY_JAN1.ics'