X-Git-Url: http://gitweb.michael.orlitzky.com/?p=mailshears.git;a=blobdiff_plain;f=test%2Fsql%2Fpostfixadmin-fixtures.sql;h=922c91217bfbbb6356feca2f5cc1a12cc4d53f2e;hp=2ca6d594b0bbc9e2c36cda94858d994a62ba037b;hb=a2d3dd9ee4838fb99557718b4bcdc11c8d1372fd;hpb=ef77e919fa61bb5ba7924d49a171dc3a05410a33 diff --git a/test/sql/postfixadmin-fixtures.sql b/test/sql/postfixadmin-fixtures.sql index 2ca6d59..922c912 100644 --- a/test/sql/postfixadmin-fixtures.sql +++ b/test/sql/postfixadmin-fixtures.sql @@ -24,11 +24,8 @@ INSERT INTO mailbox (username, domain, local_part) VALUES ('carol@example.net', 'example.net', 'carol'); /* Each mailbox has an alias pointing to (at least) itself. */ -INSERT INTO alias (address, goto, domain) - VALUES ('alice@example.com', 'alice@example.com', 'example.com'); INSERT INTO alias (address, goto, domain) VALUES ('bob@example.com', 'bob@example.com', 'example.com'); - INSERT INTO alias (address, goto, domain) VALUES ('adam@example.net', 'adam@example.net', 'example.net'); INSERT INTO alias (address, goto, domain) @@ -36,6 +33,13 @@ INSERT INTO alias (address, goto, domain) INSERT INTO alias (address, goto, domain) VALUES ('carol@example.net', 'carol@example.net', 'example.net'); +/* Alice is aliased to some other people, too. */ +INSERT INTO alias (address, goto, domain) + VALUES + ('alice@example.com', + 'alice@example.com,adam@example.net,bob@example.com,carol@example.net', + 'example.com'); + /* Create a domain admin for both example.com and example.net. */ INSERT INTO domain_admins (username, domain) VALUES ('admin@example.com', 'example.com');