SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [Verification](
	[VerificationID] [int] IDENTITY(1,1) NOT NULL,
	[CategoryID] [int] NULL,
	[InfoID] [varchar](50) NULL CONSTRAINT [DF_Verification_InfoID]  DEFAULT ((0)),
	[Auth] [varchar](128) NULL,
	[IP] [varchar](50) NULL,
	[StartDate] [datetime] NULL,
	[EndDate] [datetime] NULL,
	[Status] [int] NULL CONSTRAINT [DF_Verification_Status]  DEFAULT ((1)),
 CONSTRAINT [PK_Verification] PRIMARY KEY CLUSTERED 
(
	[VerificationID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET IDENTITY_INSERT [Verification] ON 

INSERT [Verification] ([VerificationID], [CategoryID], [InfoID], [Auth], [IP], [StartDate], [EndDate], [Status]) VALUES (1, 20, N'0', N'A5A4C8241D0941218568AA37F4A6978D', N'192.168.0.1', NULL, NULL, 1)
SET IDENTITY_INSERT [Verification] OFF
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键,验证表自增长编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Verification', @level2type=N'COLUMN',@level2name=N'VerificationID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'自定义分类编号,1注册验证,2找回密码验证' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Verification', @level2type=N'COLUMN',@level2name=N'CategoryID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'信息编号,可以为账号或ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Verification', @level2type=N'COLUMN',@level2name=N'InfoID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'验证唯一编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Verification', @level2type=N'COLUMN',@level2name=N'Auth'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'IP地址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Verification', @level2type=N'COLUMN',@level2name=N'IP'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'验证字符有效开始日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Verification', @level2type=N'COLUMN',@level2name=N'StartDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'验证字符有效结束日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Verification', @level2type=N'COLUMN',@level2name=N'EndDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'验证状态,0无效或已使用,1有效(默认),配合验证日期使用' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Verification', @level2type=N'COLUMN',@level2name=N'Status'
GO
