/* 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'); /* Now here's another user. */ INSERT INTO usr (user_no, username) VALUES (18, 'booger@example.com'); INSERT INTO usr_setting (user_no, setting_name, setting_value) VALUES (18, 'dumb setting', 'its dumb value'); INSERT INTO principal (type_id, user_no, displayname, default_privileges) VALUES (1, 18, 'Booger', '000000000001111000000000');