]>
gitweb.michael.orlitzky.com - mailshears.git/blob - 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');
4 /* Create a settings record for that user -- these should be linked
7 INSERT INTO usr_setting (user_no
, setting_name
, setting_value
)
8 VALUES (17, 'dumb setting', 'its dumb value');
10 /* Create a "Person" principal type... */
11 INSERT INTO principal_type (principal_type_id
, principal_type_desc
)
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');
18 /* Now here's another user. */
19 INSERT INTO usr (user_no
, username
) VALUES (18, 'booger@example.com');
20 INSERT INTO usr_setting (user_no
, setting_name
, setting_value
)
21 VALUES (18, 'dumb setting', 'its dumb value');
22 INSERT INTO principal (type_id
, user_no
, displayname
, default_privileges
)
23 VALUES (1, 18, 'Booger', '000000000001111000000000');