test/sql/davical-fixtures.sql

   1 /* Add a DAViCal record for one user. */
   2 INSERT INTO usr (user_no, username) VALUES (17, 'alice@example.com');
   3
   4 /* Create a settings record for that user -- these should be linked
   5  * via a foreign key.
   6  */
   7 INSERT INTO usr_setting (user_no, setting_name, setting_value)
   8   VALUES (17, 'dumb setting', 'its dumb value');
   9
  10 /* Create a "Person" principal type... */
  11 INSERT INTO principal_type (principal_type_id, principal_type_desc)
  12   VALUES (1, 'Person');
  13
  14 /* ...and assign it to the new user. */
  15 INSERT INTO principal (type_id, user_no, displayname, default_privileges)
  16   VALUES (1, 17, 'Alice', '000000000001111000000000');
  17
  18 /* Now here's another user. */
  19 INSERT INTO usr (user_no, username) VALUES (18, 'booger@example.com');
  20 INSERT INTO usr_setting (user_no, setting_name, setting_value)
  21   VALUES (18, 'dumb setting', 'its dumb value');
  22 INSERT INTO principal (type_id, user_no, displayname, default_privileges)
  23   VALUES (1, 18, 'Booger', '000000000001111000000000');