X-Git-Url: http://gitweb.michael.orlitzky.com/?p=mailshears.git;a=blobdiff_plain;f=test%2Fsql%2Fdavical-fixtures.sql;h=5abf7a67b2dc5b83b6ea3e45dc4ecf713a1f43d8;hp=775fa6b608f2710573f6591f94014267f2c3287a;hb=a67e4a902d371c4c3f8b0ccbee4cc66df87b27e4;hpb=a0987dbd47433538e1132a53af0df7502fa0289b;ds=inline

diff --git a/test/sql/davical-fixtures.sql b/test/sql/davical-fixtures.sql
index 775fa6b..5abf7a6 100644
--- a/test/sql/davical-fixtures.sql
+++ b/test/sql/davical-fixtures.sql
@@ -6,3 +6,11 @@ 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');