Fix the new AgenDAV fixtures SQL.

[mailshears.git] / test / sql / agendav-fixtures.sql

diff --git a/test/sql/agendav-fixtures.sql b/test/sql/agendav-fixtures.sql
index 76cdba18ac79add7b19071a8875e96b11dc4f36f..5af6cdb11ca188177ba3935a181e2d1f678e86cf 100644 (file)
--- a/test/sql/agendav-fixtures.sql
+++ b/test/sql/agendav-fixtures.sql
@@ -1,4 +1,17 @@
 /* Add an AgenDAV record for one user only. */
 INSERT INTO prefs (username, options) VALUES ('adam@example.net', 'herp');
 /* Add an AgenDAV record for one user only. */
 INSERT INTO prefs (username, options) VALUES ('adam@example.net', 'herp');

-INSERT INTO shared (user_from, user_which, calendar)
-  VALUES ('adam@example.net', 'beth@example.net', 'derp');
+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:{}',
+         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)
+  VALUES ('/caldav.php/booger%40example.com/',
+          '/carol%40example.net/',
+         '/caldav.php/booger%40example.com/calendar-default',
+         'a:0:{}',
+         true);