]>
gitweb.michael.orlitzky.com - mailshears.git/blob - test/sql/davical-fixtures.sql
5abf7a67b2dc5b83b6ea3e45dc4ecf713a1f43d8
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');