[P]微信登录申请地址：[/P][P][URL=https://open.weixin.qq.com/]https://open.weixin.qq.com/[/URL][/P][P]审核费用300，需要企业性质认证才能使用。[/P][P]
[/P]
[upload=16293,0]QQ截图20170403232509.jpg[/upload]


/* 为了防止任何可能出现的数据丢失问题，您应该先仔细检查此脚本，然后再在数据库设计器的上下文之外运行此脚本。*/
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.LeadBBS_AppLogin ADD
     unionid varchar(50) NOT NULL CONSTRAINT DF_LeadBBS_AppLogin_unionid DEFAULT ''
GO
DECLARE @v sql_variant
SET @v = N'微信登录和公众号等的通用关联id'
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'TABLE', N'LeadBBS_AppLogin', N'COLUMN', N'unionid'
GO
CREATE NONCLUSTERED INDEX IX_LeadBBS_AppLogin ON dbo.LeadBBS_AppLogin
     (
     UserID
     ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
ALTER TABLE dbo.LeadBBS_AppLogin SET (LOCK_ESCALATION = TABLE)
GO
COMMIT

[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]

[P]微信分享接口,sha1加密,可使用 sha1.asp文件中的 hex_sha1 加密函数[/P]