/* 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');