/* Add an AgenDAV record for one user only. */
INSERT INTO prefs (username, options) VALUES ('adam@example.net', 'herp');
-INSERT INTO shares (owner, calendar, with, options, rw)
+INSERT INTO shares (owner, calendar, "with", options, rw)
VALUES ('/caldav.php/adam%40example.net/',
'/caldav.php/adam%40example.net/calendar-default',
'/beth%40example.net/',
'a:0:{}',
- 0);
+ false);
/* Just kidding, here's another one! */
INSERT INTO prefs (username, options) VALUES ('booger@example.com', 'herp');
-INSERT INTO shares (owner, calendar, with, options, rw)
+INSERT INTO shares (owner, calendar, "with", options, rw)
VALUES ('/caldav.php/booger%40example.com/',
- '/carol%40example.net/',
'/caldav.php/booger%40example.com/calendar-default',
+ '/carol%40example.net/',
+ 'a:0:{}',
+ true);
+
+/* These two are missing a prefs entry to test the removal of "shares"
+ * entries in that situation.
+*/
+INSERT INTO shares (owner, calendar, "with", options, rw)
+ VALUES ('/caldav.php/stinky%40example.com/',
+ '/caldav.php/stinky%40example.com/calendar-default',
+ '/herp%40example.net/',
+ 'a:0:{}',
+ true);
+
+INSERT INTO shares (owner, calendar, "with", options, rw)
+ VALUES ('/caldav.php/goober%40example.com/',
+ '/caldav.php/goober%40example.com/calendar-default',
+ '/derp%40example.net/',
'a:0:{}',
- 1);
+ true);