]>
gitweb.michael.orlitzky.com - mailshears.git/blob - test/sql/postfixadmin-fixtures.sql
1 /* This is a magic record, always included as the first row of the
4 INSERT INTO domain (domain) VALUES ('ALL');
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');
11 * Now create their mailboxes, two in one domain, and three in the
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');
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');
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');
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');
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');