表名：ZL_MailInfo












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1IDint40是是 否  
2MailTitlenvarchar5000   是 邮件标题
3MailContexttext160   是 邮件内容
4MailSendTimedatetime83   是 邮件发送时间
5MailAddTimedatetime83   是 邮件添加时间
6MailStatebit10   是 邮件状态，true:已发送；false:待发送
7MailAddReestext160   是 收件人邮件地址
8UserIDint40   否0用户ID
9SendMailnvarchar2550   是 发件人邮件地址
10Filesnvarchar5000   是 附件
11MIDint40   是0目标ID

简要说明：

邮件模板表

GO
CREATE TABLE [dbo].[ZL_MailInfo](
[ID] [int] IDENTITY(1,1) NOT NULL,
[MailTitle] [nvarchar](500) NULL,
[MailContext] [text] NULL,
[MailSendTime] [datetime] NULL,
[MailAddTime] [datetime] NULL,
[MailState] [bit] NULL,
[MailAddRees] [text] NULL,
[UserID] [int] NOT NULL DEFAULT (0),
[SendMail] [nvarchar](255) NULL,
[Files] [nvarchar](500) NULL,
[MID] int NULL DEFAULT (0)
CONSTRAINT [PK_ZL_MailInfo] PRIMARY KEY NONCLUSTERED
([ID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

--注意：将清空全表数据

detele from ZL_MailInfo

--注意：将删除整个表

drop table ZL_MailInfo

--注意：清空且复位表ID序列为初始值

TRUNCATE table ZL_MailInfo