资源描述：
《hmail_创建表sql及各字段意思》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。
1、hMail_创建表sql及各字段意思createtablehm_accounts(accountidintidentity(1,1)notnull,accountdomainidintnotnull,accountadminleveltinyintnotnull,accountaddressvarchar(255)notnull,accountpasswordvarchar(255)notnull,accountactiveintnotnull,accountisadintnotnull,accountaddomainnvarchar(2
2、55)notnull,accountadusernamenvarchar(255)notnull,accountmaxsizeintnotnull,accountvacationmessageontinyintnotnull,accountvacationmessagenvarchar(1000)notnull,accountvacationsubjectnvarchar(200)notnull,accountpwencryptiontinyintnotnull,accountforwardenabledtinyintnotnull,ac
3、countforwardaddressvarchar(255)notnull,accountforwardkeeporiginaltinyintnotnull,accountenablesignaturetinyintnotnull,accountsignatureplaintextntextnotnull,accountsignaturehtmlntextnotnull,accountlastlogontimedatetimenotnull,accountvacationexpirestinyintnotnull,accountvaca
4、tionexpiredatedatetimenotnull,accountpersonfirstnamenvarchar(60)notnull,accountpersonlastnamenvarchar(60)notnull)EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'邮件账号表',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'hm_accounts',
5、@level2type=N'COLUMN',@level2name=N'accountid';GOEXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'域名ID',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'hm_accounts',@level2type=N'COLUMN',@level2name=N'accountdomainid';GOEXECsys.sp
6、_addextendedproperty@name=N'MS_Description',@value=N'域名等级',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'hm_accounts',@level2type=N'COLUMN',@level2name=N'accountadminlevel';GOEXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'帐户地址
7、',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'hm_accounts',@level2type=N'COLUMN',@level2name=N'accountaddress';GOEXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'帐户密码',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TAB
8、LE',@level1name=N'hm_accounts',@level2type=N'COLUMN',@level2name=N'accountpassword';GOEXECsys.sp
