5abf7a67b2dc5b83b6ea3e45dc4ecf713a1f43d8
[mailshears.git] / test / sql / davical-fixtures.sql
1 /* Add a DAViCal record for one user. */
2 INSERT INTO usr (user_no, username) VALUES (17, 'alice@example.com');
3
4 /* Create a settings record for that user -- these should be linked
5 * via a foreign key.
6 */
7 INSERT INTO usr_setting (user_no, setting_name, setting_value)
8 VALUES (17, 'dumb setting', 'its dumb value');
9
10 /* Create a "Person" principal type... */
11 INSERT INTO principal_type (principal_type_id, principal_type_desc)
12 VALUES (1, 'Person');
13
14 /* ...and assign it to the new user. */
15 INSERT INTO principal (type_id, user_no, displayname, default_privileges)
16 VALUES (1, 17, 'Alice', '000000000001111000000000');