在线情况
楼主
  • 头像
  • 级别
  • 徽章
  • 职务总版主
  • 声望+46
  • 积分17058
  • 经验1434897
  • 文章25379
  • 注册2003-01-20
[微信登录]相关文档
[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
LeadBBS 官方论坛(asp论坛)感谢您的参与
在线情况
2
  • 头像
  • 级别
  • 徽章
  • 职务总版主
  • 声望+46
  • 积分17058
  • 经验1434897
  • 文章25379
  • 注册2003-01-20
[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]
LeadBBS 官方论坛(asp论坛)感谢您的参与
在线情况
3
  • 头像
  • 级别
  • 徽章
  • 职务总版主
  • 声望+46
  • 积分17058
  • 经验1434897
  • 文章25379
  • 注册2003-01-20
[P]微信分享接口,sha1加密,可使用 sha1.asp文件中的 hex_sha1 加密函数[/P]
LeadBBS 官方论坛(asp论坛)感谢您的参与
Page created in 0.0117 seconds with 6 queries.