]>
gitweb.michael.orlitzky.com - mailshears.git/blob - test/sql/agendav-fixtures.sql
1 /* Add an AgenDAV record for one user only. */
2 INSERT INTO prefs (username
, options) VALUES ('adam@example.net', 'herp');
3 INSERT INTO shares (owner, calendar
, "with", options, rw
)
4 VALUES ('/caldav.php/adam%40example.net/',
5 '/caldav.php/adam%40example.net/calendar-default',
6 '/beth%40example.net/',
10 /* Just kidding, here's another one! */
11 INSERT INTO prefs (username
, options) VALUES ('booger@example.com', 'herp');
12 INSERT INTO shares (owner, calendar
, "with", options, rw
)
13 VALUES ('/caldav.php/booger%40example.com/',
14 '/caldav.php/booger%40example.com/calendar-default',
15 '/carol%40example.net/',
19 /* These two are missing a prefs entry to test the removal of "shares"
20 * entries in that situation.
22 INSERT INTO shares (owner, calendar
, "with", options, rw
)
23 VALUES ('/caldav.php/stinky%40example.com/',
24 '/caldav.php/stinky%40example.com/calendar-default',
25 '/herp%40example.net/',
29 INSERT INTO shares (owner, calendar
, "with", options, rw
)
30 VALUES ('/caldav.php/goober%40example.com/',
31 '/caldav.php/goober%40example.com/calendar-default',
32 '/derp%40example.net/',