TABLE MAIL USER Clause Samples

TABLE MAIL USER. This table defines the mail account for the user specified by the primary keys. CREATE TABLE MAIL_USER ( DOMAIN_KEY INT NOT NULL, // Primary Key USER_KEY INT NOT NULL, // Primary Key PREVIOUS_RECORD INT NOT NULL, ALTER_TIME TIMESTAMP NOT NULL, STATUS INT NOT NULL, FORWARDING INT NOT NULL, AUTORESPOND INT NOT NULL, AUTORESPOND_MESSAGE CHAR(256) NULL, FORWARDING_LIST CHAR(1024) NULL) typedef T_Cmd { word wVersion; int nSize; char szDomainName[32]; int nCommand; }; typedef T_UserNameCmd { word wVersion; int nSize; char szDomainName[32]; int nCommand; char szUserName[32]; char szPassword[16]; char szOldUserName[32]; char szOldPassword[16]; }; typedef T_DomainNameCmd { word wVersion; int nSize; char szDomainName[32]; int nCommand; char szNewDomainName[32]; BOOL bRegisterName; }; typedef T_DNS_Cmd { word wVersion; int nSize; char szDomainName[32]; int nCommand; char szPrimaryNameServer[64]; char szSecondaryNameServer[64]; BYTE pWebServerAddress[4]; }; Virtual Web server needs to send additional data only when information about a user has changed. The following structure is used only for user level calls, typedef T_VirtualWebServerCmd { word wVersion; int nSize; char szDomainName[32]; int nCommand; char szUserName[32]; char szPassword[16]; //Filled only when password has changed. }; Incoming mail server needs to send additional data only when information about a user has changed. The following structure is used only for user level calls, typedef T_IncomingMailServerCmd { word wVersion; int nSize; char szDomainName[32]; int nCommand; char szOldUserName[32]; char szNewUserName[32]; BOOL bEnableAutorespond; BOOL bEnableForwarding; };