[P]增加登录日志[/P][P]
/****** Object: Table [dbo].[LeadBBS_LoginLog] Script Date: 04/29/2017 20:07:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[LeadBBS_LoginLog](
[ID] [bigint] IDENTITY(1,1) NOT NULL,
[userid] [bigint] NOT NULL,
[logintime] [bigint] NOT NULL,
[ipaddress] [varchar](16) COLLATE Chinese_PRC_CI_AS NOT NULL,
CONSTRAINT [PK_LeadBBS_LoginLog] PRIMARY KEY CLUSTERED
(
[ID] 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 ANSI_PADDING OFF
GO
CREATE NONCLUSTERED INDEX [IX_LeadBBS_LoginLog_userid] ON [dbo].[LeadBBS_LoginLog]
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object: Default [DF_LeadBBS_LoginLog_userid] Script Date: 04/29/2017 20:07:21 ******/
ALTER TABLE [dbo].[LeadBBS_LoginLog] ADD CONSTRAINT [DF_LeadBBS_LoginLog_userid] DEFAULT ((0)) FOR [userid]
GO
/****** Object: Default [DF_LeadBBS_LoginLog_logintime] Script Date: 04/29/2017 20:07:21 ******/
ALTER TABLE [dbo].[LeadBBS_LoginLog] ADD CONSTRAINT [DF_LeadBBS_LoginLog_logintime] DEFAULT ((0)) FOR [logintime]
GO
/****** Object: Default [DF_LeadBBS_LoginLog_ipaddress] Script Date: 04/29/2017 20:07:21 ******/
ALTER TABLE [dbo].[LeadBBS_LoginLog] ADD CONSTRAINT [DF_LeadBBS_LoginLog_ipaddress] DEFAULT ('') FOR [ipaddress]
GO
[/P]