X-Git-Url: https://gitweb.michael.orlitzky.com/?a=blobdiff_plain;f=test%2Fsql%2Fagendav-fixtures.sql;h=535f02333c23d70aad20198519a23393a5440bd7;hb=93f4125437702363b25b6825d6f20e98b1e319a9;hp=49bed6ac6a584cda93fd5ab2d636948b8c09a21d;hpb=80199942f91013b48ec65bd89b9890c07ff973f3;p=mailshears.git

diff --git a/test/sql/agendav-fixtures.sql b/test/sql/agendav-fixtures.sql
index 49bed6a..535f023 100644
--- a/test/sql/agendav-fixtures.sql
+++ b/test/sql/agendav-fixtures.sql
@@ -1,17 +1,34 @@
 /* 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);