[微信登录]相关文档

楼主 spiderman 于 2017-04-03 22:49:19

[微信登录]相关文档

[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

1楼 spiderman 于 2017-04-29 20:09:02

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

2楼 spiderman 于 2017-07-19 14:53:07

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

平台互联