# # PUT a todo into the database # TYPE=PUT HEADER=User-Agent: DAViCal Testing/1.12.x HEADER=Content-Type: text/calendar; charset=utf-8 AUTH=user1:user1 HEAD BEGINDATA BEGIN:VCALENDAR PRODID:-//Puck Handcrafted VCAL//NONSGML Sunbird//EN VERSION:2.0 BEGIN:VTODO UID:19980901T130000Z-123405@host.com DTSTAMP:19980901T130000Z DTSTART:19980415T133000Z DUE:19980516T045959Z SUMMARY:Status is not set, CLASS set, from PUT CLASS:CONFIDENTIAL CATEGORIES:FAMILY,FINANCE PRIORITY:1 END:VTODO END:VCALENDAR ENDDATA URL=http://regression.host/caldav.php/user1/events/hand-crafted-vtodo-1.ics QUERY SELECT caldav_data.user_no, caldav_data.dav_etag, caldav_type, logged_user, uid, dtstamp, dtstart, dtstart_orig, dtend, dtend_orig, due, summary, location, description, priority, class, transp, rrule, url, percent_complete, status, caldav_data AS " CalDAV Data" FROM caldav_data JOIN calendar_item AS ci USING(dav_name) WHERE caldav_data.dav_name = '/user1/events/hand-crafted-vtodo-1.ics'; ENDQUERY