X-Git-Url: http://gitweb.michael.orlitzky.com/?p=mailshears.git;a=blobdiff_plain;f=test%2Fsql%2Fdavical-fixtures.sql;h=8b1f62c9ded5f37a8098888975484bba4869825d;hp=775fa6b608f2710573f6591f94014267f2c3287a;hb=342327326fc5203b34435a7291f5528f214c1717;hpb=e1d4b3dd098d2107bbf5ca84d36c8052706e86a8

diff --git a/test/sql/davical-fixtures.sql b/test/sql/davical-fixtures.sql
index 775fa6b..8b1f62c 100644
--- a/test/sql/davical-fixtures.sql
+++ b/test/sql/davical-fixtures.sql
@@ -6,3 +6,18 @@ INSERT INTO usr (user_no, username) VALUES (17, 'alice@example.com');
  */
 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');