membership数据库的架构
SP.NET 2.0 提供了许多十分有用的新特性,如MemberShip、RoleManager、Profile等等,可以很方便的在自己的应用程序中使用,解决登录认证、用户注册、权限管理等问题。
1 - AspNetDB数据库的安装。
在Visual Studio 2005菜单中选择Tool->命令提示->运行ASPNET_RegSql.Exe文件,按照提示即可顺利安装成功。
2 - Web.Config中的配置
可参考如下配置:
3 - MemberShip数据库结构
1 - AspNetDB数据库的安装。
在Visual Studio 2005菜单中选择Tool->命令提示->运行ASPNET_RegSql.Exe文件,按照提示即可顺利安装成功。
2 - Web.Config中的配置
可参考如下配置:
<membership defaultProvider="AspNetSqlMembershipProvider">
<providers>
<add connectionStringName="ConnectionString" enablePasswordRetrieval="true" enablePasswordReset="true" requiresQuestionAndAnswer="false" applicationName="SigooFramework" requiresUniqueEmail="false" passwordFormat="Clear" minRequiredPasswordLength="1" passwordStrengthRegularExpression="" minRequiredNonalphanumericCharacters="0" name="AspNetSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider, System.Web" />
</providers>
</membership>
<roleManager enabled="true" cacheRolesInCookie="true" defaultProvider="AspNetSqlRoleProvider">
<providers>
<add connectionStringName="ConnectionString" applicationName="SigooFramework" name="AspNetSqlRoleProvider" type="System.Web.Security.SqlRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
</providers>
</roleManager>
![membership数据库的架构 - yeliang_mail - 流浪的博客](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![membership数据库的架构 - yeliang_mail - 流浪的博客](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![membership数据库的架构 - yeliang_mail - 流浪的博客](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![membership数据库的架构 - yeliang_mail - 流浪的博客](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![membership数据库的架构 - yeliang_mail - 流浪的博客](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![membership数据库的架构 - yeliang_mail - 流浪的博客](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![membership数据库的架构 - yeliang_mail - 流浪的博客](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![membership数据库的架构 - yeliang_mail - 流浪的博客](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![membership数据库的架构 - yeliang_mail - 流浪的博客](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
3 - MemberShip数据库结构
aspnet_Applications | ||||||||
代码 | 注释 | 类型 | 长度 | 小数 | 默认值 | 标识 | 主键 | 空值 |
ApplicationId | uniqueidentifier | 16 | 0 | (newid()) | ![]() |
![]() |
![]() | |
ApplicationName | nvarchar | 512 | 0 | ![]() |
![]() |
![]() | ||
LoweredApplicationName | nvarchar | 512 | 0 | ![]() |
![]() |
![]() | ||
Description | nvarchar | 512 | 0 | ![]() |
![]() |
![]() |
TOP
aspnet_Membership | ||||||||
代码 | 注释 | 类型 | 长度 | 小数 | 默认值 | 标识 | 主键 | 空值 |
UserId | uniqueidentifier | 16 | 0 | ![]() |
![]() |
![]() | ||
ApplicationId | uniqueidentifier | 16 | 0 | ![]() |
![]() |
![]() | ||
Password | nvarchar | 256 | 0 | ![]() |
![]() |
![]() | ||
PasswordFormat | int | 4 | 0 | ((0)) | ![]() |
![]() |
![]() | |
PasswordSalt | nvarchar | 256 | 0 | ![]() |
![]() |
![]() | ||
MobilePIN | nvarchar | 32 | 0 | ![]() |
![]() |
![]() | ||
nvarchar | 512 | 0 | ![]() |
![]() |
![]() | |||
LoweredEmail | nvarchar | 512 | 0 | ![]() |
![]() |
![]() | ||
PasswordQuestion | nvarchar | 512 | 0 | ![]() |
![]() |
![]() | ||
PasswordAnswer | nvarchar | 256 | 0 | ![]() |
![]() |
![]() | ||
IsApproved | bit | 1 | 0 | ![]() |
![]() |
![]() | ||
IsLockedOut | bit | 1 | 0 | ![]() |
![]() |
![]() | ||
CreateDate | datetime | 8 | 3 | ![]() |
![]() |
![]() | ||
LastLoginDate | datetime | 8 | 3 | ![]() |
![]() |
![]() | ||
LastPasswordChangedDate | datetime | 8 | 3 | ![]() |
![]() |
![]() | ||
LastLockoutDate | datetime | 8 | 3 | ![]() |
![]() |
![]() | ||
FailedPasswordAttemptCount | int | 4 | 0 | ![]() |
![]() |
![]() | ||
FailedPasswordAttemptWindowStart | datetime | 8 | 3 | ![]() |
![]() |
![]() | ||
FailedPasswordAnswerAttemptCount | int | 4 | 0 | ![]() |
![]() |
![]() | ||
FailedPasswordAnswerAttemptWindowStart | datetime | 8 | 3 | ![]() |
![]() |
![]() | ||
Comment | ntext | 3000 | 0 | ![]() |
![]() |
![]() |
TOP
aspnet_Paths | ||||||||
代码 | 注释 | 类型 | 长度 | 小数 | 默认值 | 标识 | 主键 | 空值 |
PathId | uniqueidentifier | 16 | 0 | (newid()) | ![]() |
![]() |
![]() | |
ApplicationId | uniqueidentifier | 16 | 0 | ![]() |
![]() |
![]() | ||
Path | nvarchar | 512 | 0 | ![]() |
![]() |
![]() | ||
LoweredPath | nvarchar | 512 | 0 | ![]() |
![]() |
![]() |
TOP
aspnet_PersonalizationAllUsers | ||||||||
代码 | 注释 | 类型 | 长度 | 小数 | 默认值 | 标识 | 主键 | 空值 |
PathId | uniqueidentifier | 16 | 0 | ![]() |
![]() |
![]() | ||
PageSettings | image | 6000 | 0 | ![]() |
![]() |
![]() | ||
LastUpdatedDate | datetime | 8 | 3 | ![]() |
![]() |
![]() |
TOP
aspnet_PersonalizationPerUser | ||||||||
代码 | 注释 | 类型 | 长度 | 小数 | 默认值 | 标识 | 主键 | 空值 |
Id | uniqueidentifier | 16 | 0 | (newid()) | ![]() |
![]() |
![]() | |
PathId | uniqueidentifier | 16 | 0 | ![]() |
![]() |
![]() | ||
UserId | uniqueidentifier | 16 | 0 | ![]() |
![]() |
![]() | ||
PageSettings | image | 6000 | 0 | ![]() |
![]() |
![]() | ||
LastUpdatedDate | datetime | 8 | 3 | ![]() |
![]() |
![]() |
TOP
aspnet_Profile | ||||||||
代码 | 注释 | 类型 | 长度 | 小数 | 默认值 | 标识 | 主键 | 空值 |
UserId | uniqueidentifier | 16 | 0 | ![]() |
![]() |
![]() | ||
PropertyNames | ntext | 6000 | 0 | ![]() |
![]() |
![]() | ||
PropertyValuesString | ntext | 6000 | 0 | ![]() |
![]() |
![]() | ||
PropertyValuesBinary | image | 6000 | 0 | ![]() |
![]() |
![]() | ||
LastUpdatedDate | datetime | 8 | 3 | ![]() |
![]() |
![]() |
TOP
aspnet_Roles | ||||||||
代码 | 注释 | 类型 | 长度 | 小数 | 默认值 | 标识 | 主键 | 空值 |
RoleId | uniqueidentifier | 16 | 0 | (newid()) | ![]() |
![]() |
![]() | |
ApplicationId | uniqueidentifier | 16 | 0 | ![]() |
![]() |
![]() | ||
RoleName | nvarchar | 512 | 0 | ![]() |
![]() |
![]() | ||
LoweredRoleName | nvarchar | 512 | 0 | ![]() |
![]() |
![]() | ||
Description | nvarchar | 512 | 0 | ![]() |
![]() |
![]() |
TOP
aspnet_SchemaVersions | ||||||||
代码 | 注释 | 类型 | 长度 | 小数 | 默认值 | 标识 | 主键 | 空值 |
Feature | nvarchar | 256 | 0 | ![]() |
![]() |
![]() | ||
CompatibleSchemaVersion | nvarchar | 256 | 0 | ![]() |
![]() |
![]() | ||
IsCurrentVersion | bit | 1 | 0 | ![]() |
![]() |
![]() |
TOP
aspnet_Users | ||||||||
代码 | 注释 | 类型 | 长度 | 小数 | 默认值 | 标识 | 主键 | 空值 |
UserId | uniqueidentifier | 16 | 0 | (newid()) | ![]() |
![]() |
![]() | |
ApplicationId | uniqueidentifier | 16 | 0 | ![]() |
![]() |
![]() | ||
UserName | nvarchar | 512 | 0 | ![]() |
![]() |
![]() | ||
LoweredUserName | nvarchar | 512 | 0 | ![]() |
![]() |
![]() | ||
MobileAlias | nvarchar | 32 | 0 | (NULL) | ![]() |
![]() |
![]() | |
IsAnonymous | bit | 1 | 0 | ((0)) | ![]() |
![]() |
![]() | |
LastActivityDate | datetime | 8 | 3 | ![]() |
![]() |
![]() |
TOP
aspnet_UsersInRoles | ||||||||
代码 | 注释 | 类型 | 长度 | 小数 | 默认值 | 标识 | 主键 | 空值 |
UserId | uniqueidentifier | 16 | 0 | ![]() |
![]() |
![]() | ||
RoleId | uniqueidentifier | 16 | 0 | ![]() |
![]() |
![]() |
TOP
aspnet_WebEvent_Events | ||||||||
代码 | 注释 | 类型 | 长度 | 小数 | 默认值 | 标识 | 主键 | 空值 |
EventId | char | 32 | 0 | ![]() |
![]() |
![]() | ||
EventTimeUtc | datetime | 8 | 3 | ![]() |
![]() |
![]() | ||
EventTime | datetime | 8 | 3 | ![]() |
![]() |
![]() | ||
EventType | nvarchar | 512 | 0 | ![]() |
![]() |
![]() | ||
EventSequence | decimal | 9 | 0 | ![]() |
![]() |
![]() | ||
EventOccurrence | decimal | 9 | 0 | ![]() |
![]() |
![]() | ||
EventCode | int | 4 | 0 | ![]() |
![]() |
![]() | ||
EventDetailCode | int | 4 | 0 | ![]() |
![]() |
![]() | ||
Message | nvarchar | 2048 | 0 | ![]() |
![]() |
![]() | ||
ApplicationPath | nvarchar | 512 | 0 | ![]() |
![]() |
![]() | ||
ApplicationVirtualPath | nvarchar | 512 | 0 | ![]() |
![]() |
![]() | ||
MachineName | nvarchar | 512 | 0 | ![]() |
![]() |
![]() | ||
RequestUrl | nvarchar | 2048 | 0 | ![]() |
![]() |
![]() | ||
ExceptionType | nvarchar | 512 | 0 | ![]() |
![]() |
![]() | ||
Details | ntext | 16 | 0 |