#
# Check for support of PROPPATCH method
#
# Adding the 'owner' property to a collection
#
TYPE=PROPPATCH
HEADER=User-agent: SpecTest PROPPATCH
HEADER=Content-type: text/xml
HEAD

BEGINDATA
<?xml version="1.0" encoding="utf-8" ?> 
<propertyupdate xmlns="DAV:" xmlns:X="urn:mcmillan:bogus:xml:ns:davical"> 
  <set> 
    <prop> 
      <X:arbitrary>A completely bogus property which should be saved.</X:arbitrary>
      <displayname>User One's Not Calendar</displayname> 
    </prop> 
  </set> 
  <remove> 
    <prop> 
      <resourcetype> 
        <calendar xmlns="urn:ietf:params:xml:ns:caldav"/>
      </resourcetype> 
    </prop> 
  </remove> 
</propertyupdate>
ENDDATA

URL=http://regression.host/caldav.php/user1/home/

QUERY
SELECT dav_displayname, is_calendar, resourcetypes,
       modified > (current_timestamp - '120 seconds'::interval) AS changed_recently
  FROM collection WHERE dav_name = '/user1/home/' ORDER BY collection_id
ENDQUERY

QUERY
SELECT dav_name, property_name, property_value, changed_by,
       changed_on > (current_timestamp - '120 seconds'::interval) AS changed_recently
  FROM property
 WHERE dav_name = '/user1/home/'
 ORDER BY dav_name, property_name
ENDQUERY