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