/* Add a DAViCal record for one user. */
INSERT INTO usr (user_no, username) VALUES (17, 'alice@example.com');

/* Create a settings record for that user -- these should be linked
 * via a foreign key.
 */
INSERT INTO usr_setting (user_no, setting_name, setting_value)
  VALUES (17, 'dumb setting', 'its dumb value');

/* Create a "Person" principal type... */
INSERT INTO principal_type (principal_type_id, principal_type_desc)
  VALUES (1, 'Person');

/* ...and assign it to the new user. */
INSERT INTO principal (type_id, user_no, displayname, default_privileges)
  VALUES (1, 17, 'Alice', '000000000001111000000000');
