Add some fixture code.
[mailshears.git] / 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