dn: cn=something,ou=example.com,dc=my,dc=dcroot
sn: Lastname
cn: Firstname
objectClass: top
objectClass: person
objectClass: inetOrgPerson
objectClass: qmailUser
mail: something@example.com
mailAlternateAddress: someting2@example.com
mailAlternateAddress: someting3@example.com
mailForwardingAddress: something2@example.net
mailForwardingAddress: something3@example.net
mailMessageStore: example.com/something/
mailQuotaSize: 500000000
uid: something@example.com
userPassword:: e01ENX0yVDhySXFLNkhsNFJwaFZxelBzblJRPT0=

-- create account, user is able to login but unable to receive email as it doesn't have alias entries yet.
INSERT INTO mailbox(username, password, name, storagebasedirectory, storagenode, maildir, quota, domain, active, local_part, created)
VALUES('something@example.com', 'e01ENX0yVDhySXFLNkhsNFJwaFZxelBzblJRPT0=', 'Firstname Lastname', '/var/vmail', 'vmail1', 'example.com/something/', '500', 'example.com', '1', 'something', NOW());

-- point email address to the account (now emails go to the account available via eg IMAP)
INSERT INTO alias (address, goto, domain, created, active)
VALUES ('something@example.com', 'something@example.com,something2@example.net,something3@example.net','example.com', NOW(), 1);

-- now all mailAlternateAddresses needs to be inserted as alias entries each in it's own row
INSERT INTO alias (address, goto, domain, created, active)
VALUES ('something@example.com', 'something@example.com,something2@example.net,something3@example.net','example.com', NOW(), 1);
INSERT INTO alias (address, goto, domain, created, active)
VALUES ('something2@example.com', 'something@example.com,something2@example.net,something3@example.net','example.com', NOW(), 1);
INSERT INTO alias (address, goto, domain, created, active)
VALUES ('something3@example.com', 'something@example.com,something2@example.net,something3@example.net','example.com', NOW(), 1);