asp.net-mvc – 如何手动创建简单的成员资格sql表?
发布时间:2020-12-16 04:13:31 所属栏目:asp.Net 来源:网络整理
导读:我正在寻找一个类似于Aspnet_regsql.exe for ASP .NET Membership的工具,仅适用于simpleMemberShip Provider.在运行时创建表太晚了,导致客户端程序使用相同的表. UserProfilewebpages_Membershipwebpages_OAuthMembershipwebpages_Roleswebpages_UsersInRole
我正在寻找一个类似于Aspnet_regsql.exe for ASP .NET Membership的工具,仅适用于simpleMemberShip Provider.在运行时创建表太晚了,导致客户端程序使用相同的表.
UserProfile webpages_Membership webpages_OAuthMembership webpages_Roles webpages_UsersInRoles 任何建议都会很棒 解决方法
在开发人员计算机上运行应用程序后,您可以使用SQL Management Studio自行创建脚本:
示例来自我所做的类似任务(注意日期,不确定是否有任何更改). 注意:您需要像创建任何生产系统一样创建数据库并执行常规权限设置等. /****** Object: Table [dbo].[UserProfile] Script Date: 12/06/2012 18:18:37 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[UserProfile]( [UserId] [int] IDENTITY(1,1) NOT NULL,[UserName] [nvarchar](56) NOT NULL,PRIMARY KEY CLUSTERED ( [UserId] ASC )WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],UNIQUE NONCLUSTERED ( [UserName] ASC )WITH (PAD_INDEX = OFF,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[webpages_Membership] Script Date: 12/06/2012 18:18:52 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[webpages_Membership]( [UserId] [int] NOT NULL,[CreateDate] [datetime] NULL,[ConfirmationToken] [nvarchar](128) NULL,[IsConfirmed] [bit] NULL,[LastPasswordFailureDate] [datetime] NULL,[PasswordFailuresSinceLastSuccess] [int] NOT NULL,[Password] [nvarchar](128) NOT NULL,[PasswordChangedDate] [datetime] NULL,[PasswordSalt] [nvarchar](128) NOT NULL,[PasswordVerificationToken] [nvarchar](128) NULL,[PasswordVerificationTokenExpirationDate] [datetime] NULL,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO ALTER TABLE [dbo].[webpages_Membership] ADD DEFAULT ((0)) FOR [IsConfirmed] GO ALTER TABLE [dbo].[webpages_Membership] ADD DEFAULT ((0)) FOR [PasswordFailuresSinceLastSuccess] GO /****** Object: Table [dbo].[webpages_OAuthMembership] Script Date: 12/06/2012 18:19:11 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[webpages_OAuthMembership]( [Provider] [nvarchar](30) NOT NULL,[ProviderUserId] [nvarchar](100) NOT NULL,[UserId] [int] NOT NULL,PRIMARY KEY CLUSTERED ( [Provider] ASC,[ProviderUserId] ASC )WITH (PAD_INDEX = OFF,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[webpages_Roles] Script Date: 12/06/2012 18:19:26 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[webpages_Roles]( [RoleId] [int] IDENTITY(1,[RoleName] [nvarchar](256) NOT NULL,PRIMARY KEY CLUSTERED ( [RoleId] ASC )WITH (PAD_INDEX = OFF,UNIQUE NONCLUSTERED ( [RoleName] ASC )WITH (PAD_INDEX = OFF,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[webpages_UsersInRoles] Script Date: 12/06/2012 18:19:39 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[webpages_UsersInRoles]( [UserId] [int] NOT NULL,[RoleId] [int] NOT NULL,PRIMARY KEY CLUSTERED ( [UserId] ASC,[RoleId] ASC )WITH (PAD_INDEX = OFF,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO ALTER TABLE [dbo].[webpages_UsersInRoles] WITH CHECK ADD CONSTRAINT [fk_RoleId] FOREIGN KEY([RoleId]) REFERENCES [dbo].[webpages_Roles] ([RoleId]) GO ALTER TABLE [dbo].[webpages_UsersInRoles] CHECK CONSTRAINT [fk_RoleId] GO ALTER TABLE [dbo].[webpages_UsersInRoles] WITH CHECK ADD CONSTRAINT [fk_UserId] FOREIGN KEY([UserId]) REFERENCES [dbo].[UserProfile] ([UserId]) GO ALTER TABLE [dbo].[webpages_UsersInRoles] CHECK CONSTRAINT [fk_UserId] GO (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |
相关内容
- WeihanLi.Npoi 近期更新
- asp.net – 为customvalidator设置errormessage?
- asp.net-mvc – TDD工作单元模式Moq无法实例化类错误的代理
- SignalR在asp.net core下使用
- asp-classic – 经典的ASP页面是否会运行在Windows 7之后的
- asp.net – 在Web.config中是否可以在指定目录中注册所有用
- asp.net-core – 哪些.NET框架版本支持.NET Framework(CLR)
- ASP.NET MVC中的Session以及处理方式
- 带有MS Chart的ASP.NET禁用垂直线
- ASP.net网络资源与图像
推荐文章
站长推荐
- asp.net-mvc – ASP.NET MVC Ajax.BeginForm不起
- asp.net-mvc – 实体框架删除记录
- asp-classic – 如何从此ADODB.Recordset获取插入
- asp.net-mvc-4 – 如果使用实体连接字符串(与SQL
- asp.net-mvc – 如何在ASP.NET MVC中维护Html.Ch
- asp.net-mvc – 覆盖EditorForModel模板
- asp.net-mvc – 应用程序服务层作为静态类
- asp.net – 客户端缓存vs Cookie
- 在ASP.NET MVC中DRY原理实际上是什么样的?
- asp.net – 选择下拉列表项目findbytext没有区分
热点阅读