搭建虛擬域和虛擬用戶的LINUX開源郵件系統(tǒng)POSTFIX DOVECOT CYRUS

本文格式為Word版，下載可任意編輯——搭建虛擬域和虛擬用戶的LINUX開源郵件系統(tǒng)POSTFIXDOVECOTCYRUSprompt

CREATETABLEalias(

addressvarchar(255)NOTNULLdefault'',gototextNOTNULL,

domainvarchar(255)NOTNULLdefault'',

createddatetimeNOTNULLdefault'0000-00-0000:00:00',modifieddatetimeNOTNULLdefault'0000-00-0000:00:00',activetinyint(1)NOTNULLdefault'1',

PRIMARYKEY(address),KEYaddress(address)

)TYPE=MyISAMCOMMENT='PostfixAdmin-VirtualAliases';

CreatetheDomaintable

Postfixisusingthe\and\column.Courierisnotusingthistable.

Copyandpastethesqlstatementtoyourmysql>prompt

CREATETABLEdomain(

domainvarchar(255)NOTNULLdefault'',descriptionvarchar(255)NOTNULLdefault'',aliasesint(10)NOTNULLdefault'0',mailboxesint(10)NOTNULLdefault'0',maxquotaint(10)NOTNULLdefault'0',transportvarchar(255)defaultNULL,backupmxtinyint(1)NOTNULLdefault'0',

createddatetimeNOTNULLdefault'0000-00-0000:00:00',modifieddatetimeNOTNULLdefault'0000-00-0000:00:00',activetinyint(1)NOTNULLdefault'1',PRIMARYKEY(domain),KEYdomain(domain)

)TYPE=MyISAMCOMMENT='PostfixAdmin-VirtualDomains';

CreatetheDomainAdminTable

Tablestructurefortabledomain_admins.Thistableisusedtocreateindividualadministratorsforeachvirtualdomain.PostfixorCourierisnotusingthistable.Copyandpastethesqlstatementtoyourmysql>prompt.

CREATETABLEdomain_admins(

usernamevarchar(255)NOTNULLdefault'',domainvarchar(255)NOTNULLdefault'',

createddatetimeNOTNULLdefault'0000-00-0000:00:00',activetinyint(1)NOTNULLdefault'1',KEYusername(username)

)TYPE=MyISAMCOMMENT='PostfixAdmin-DomainAdmins';

CreatetheMailboxTable

Postfixisusingthe\and\columnwhileCourierisusingthe\sername\,\,\and\column.Copyandpastethesqlstatementtoyourmysql>prompt.

CREATETABLEmailbox(

usernamevarchar(255)NOTNULLdefault'',passwordvarchar(255)NOTNULLdefault'',namevarchar(255)NOTNULLdefault'',maildirvarchar(255)NOTNULLdefault'',quotaint(10)NOTNULLdefault'0',domainvarchar(255)NOTNULLdefault'',

createddatetimeNOTNULLdefault'0000-00-0000:00:00',modifieddatetimeNOTNULLdefault'0000-00-0000:00:00',activetinyint(1)NOTNULLdefault'1',PRIMARYKEY(username),KEYusername(username)

)TYPE=MyISAMCOMMENT='PostfixAdmin-VirtualMailboxes';

CreatetheLogTable

PostfixorCourierisnotusingthistable.Insteadthistableisusedtologtheactivitiesofdomainadministratorsandmailboxusers.

Copyandpastethesqlstatementtoyourmysql>prompt.

CREATETABLEl