2,306
edits
Changes
Jump to navigation
Jump to search
Line 127:
Line 127: − + − <nowiki></nowiki>+ − + + + + +
→Create your first email account and domain
=== Create your first email account and domain ===
=== Create your first email account and domain ===
<nowiki>INSERT INTO domains VALUES(NULL,'mydomain.com','local','My nice domain for local delivery',1,NOW(),NOW());</nowiki>
==== Domain ====
<nowiki>INSERT INTO domains VALUES(NULL,'herrerosolis.com','local','My personal domain',1,NOW(),NOW());</nowiki>
<nowiki>INSERT INTO mailboxes VALUES(NULL,1,'joe',MD5('password - choose a good one'),'My account for joe@mydomain.com',1,NOW(),NOW());</nowiki>
==== User ====
<nowiki>INSERT INTO mailboxes VALUES(NULL,1,'joe',MD5('password - choose a good one'),'My account for joe@herrerosolis.com',1,NOW(),NOW());</nowiki>
==== Alias ====
<nowiki>insert into aliases values (null, 1, 'support', 'ceo@mydomain.com', 'Redirecting support@ to the CEO. It will be a good experience', 1, NOW(), NOW() );</nowiki>
=== Create a database-account to access the database ===
=== Create a database-account to access the database ===