test/sql/postfixadmin-fixtures.sql

   1 /* This is a magic record, always included as the first row of the
   2  * domain table.
   3  */
   4 INSERT INTO domain (domain) VALUES ('ALL');
   5
   6 /* Create two domains, example.com, and example.net. */
   7 INSERT INTO domain (domain) VALUES ('example.com');
   8 INSERT INTO domain (domain) VALUES ('example.net');
   9
  10 /*
  11  * Now create their mailboxes, two in one domain, and three in the
  12  * other.
  13  */
  14 INSERT INTO mailbox (username, domain, local_part)
  15              VALUES ('alice@example.com', 'example.com', 'alice');
  16 INSERT INTO mailbox (username, domain, local_part)
  17              VALUES ('bob@example.com', 'example.com', 'bob');
  18
  19 INSERT INTO mailbox (username, domain, local_part)
  20   VALUES ('adam@example.net', 'example.net', 'adam');
  21 INSERT INTO mailbox (username, domain, local_part)
  22   VALUES ('beth@example.net', 'example.net', 'beth');
  23 INSERT INTO mailbox (username, domain, local_part)
  24   VALUES ('carol@example.net', 'example.net', 'carol');
  25
  26 /* Each mailbox has an alias pointing to (at least) itself. */
  27 INSERT INTO alias (address, goto, domain)
  28   VALUES ('alice@example.com', 'alice@example.com', 'example.com');
  29 INSERT INTO alias (address, goto, domain)
  30   VALUES ('bob@example.com', 'bob@example.com', 'example.com');
  31
  32 INSERT INTO alias (address, goto, domain)
  33   VALUES ('adam@example.net', 'adam@example.net', 'example.net');
  34 INSERT INTO alias (address, goto, domain)
  35   VALUES ('beth@example.net', 'beth@example.net', 'example.net');
  36 INSERT INTO alias (address, goto, domain)
  37   VALUES ('carol@example.net', 'carol@example.net', 'example.net');
  38
  39 /* Create a domain admin for both example.com and example.net. */
  40 INSERT INTO domain_admins (username, domain)
  41   VALUES ('admin@example.com', 'example.com');
  42 INSERT INTO domain_admins (username, domain)
  43   VALUES ('admin@example.com', 'example.net');
  44