| 1 | <?xml version="1.0" encoding="utf-8"?><Database Name="HeuristicLab.Authentication" Class="UserManagementDataContext" xmlns="http://schemas.microsoft.com/linqtosql/dbml/2007">
|
|---|
| 2 | <Connection Mode="AppSettings" ConnectionString="Data Source=.\SQLEXPRESS;Initial Catalog=HeuristicLab.Authentication;Integrated Security=True" SettingsObjectName="HeuristicLab.Services.Authentication.DataAccess.Properties.Settings" SettingsPropertyName="HeuristicLab_AuthenticationConnectionString" Provider="System.Data.SqlClient" />
|
|---|
| 3 | <Table Name="dbo.aspnet_Applications" Member="aspnet_Applications">
|
|---|
| 4 | <Type Name="aspnet_Application">
|
|---|
| 5 | <Column Name="ApplicationName" Type="System.String" DbType="NVarChar(256) NOT NULL" CanBeNull="false" />
|
|---|
| 6 | <Column Name="LoweredApplicationName" Type="System.String" DbType="NVarChar(256) NOT NULL" CanBeNull="false" />
|
|---|
| 7 | <Column Name="ApplicationId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 8 | <Column Name="Description" Type="System.String" DbType="NVarChar(256)" CanBeNull="true" />
|
|---|
| 9 | <Association Name="aspnet_Application_aspnet_Membership" Member="aspnet_Memberships" ThisKey="ApplicationId" OtherKey="ApplicationId" Type="aspnet_Membership" />
|
|---|
| 10 | <Association Name="aspnet_Application_aspnet_Role" Member="aspnet_Roles" ThisKey="ApplicationId" OtherKey="ApplicationId" Type="aspnet_Role" />
|
|---|
| 11 | <Association Name="aspnet_Application_aspnet_User" Member="aspnet_Users" ThisKey="ApplicationId" OtherKey="ApplicationId" Type="aspnet_User" />
|
|---|
| 12 | </Type>
|
|---|
| 13 | </Table>
|
|---|
| 14 | <Table Name="dbo.aspnet_Membership" Member="aspnet_Memberships">
|
|---|
| 15 | <Type Name="aspnet_Membership">
|
|---|
| 16 | <Column Name="ApplicationId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
|
|---|
| 17 | <Column Name="UserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 18 | <Column Name="Password" Type="System.String" DbType="NVarChar(128) NOT NULL" CanBeNull="false" />
|
|---|
| 19 | <Column Name="PasswordFormat" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|---|
| 20 | <Column Name="PasswordSalt" Type="System.String" DbType="NVarChar(128) NOT NULL" CanBeNull="false" />
|
|---|
| 21 | <Column Name="MobilePIN" Type="System.String" DbType="NVarChar(16)" CanBeNull="true" />
|
|---|
| 22 | <Column Name="Email" Type="System.String" DbType="NVarChar(256)" CanBeNull="true" />
|
|---|
| 23 | <Column Name="LoweredEmail" Type="System.String" DbType="NVarChar(256)" CanBeNull="true" />
|
|---|
| 24 | <Column Name="PasswordQuestion" Type="System.String" DbType="NVarChar(256)" CanBeNull="true" />
|
|---|
| 25 | <Column Name="PasswordAnswer" Type="System.String" DbType="NVarChar(128)" CanBeNull="true" />
|
|---|
| 26 | <Column Name="IsApproved" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
|
|---|
| 27 | <Column Name="IsLockedOut" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
|
|---|
| 28 | <Column Name="CreateDate" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
|
|---|
| 29 | <Column Name="LastLoginDate" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
|
|---|
| 30 | <Column Name="LastPasswordChangedDate" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
|
|---|
| 31 | <Column Name="LastLockoutDate" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
|
|---|
| 32 | <Column Name="FailedPasswordAttemptCount" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|---|
| 33 | <Column Name="FailedPasswordAttemptWindowStart" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
|
|---|
| 34 | <Column Name="FailedPasswordAnswerAttemptCount" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|---|
| 35 | <Column Name="FailedPasswordAnswerAttemptWindowStart" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
|
|---|
| 36 | <Column Name="Comment" Type="System.String" DbType="NText" CanBeNull="true" UpdateCheck="Never" />
|
|---|
| 37 | <Association Name="aspnet_Application_aspnet_Membership" Member="aspnet_Application" ThisKey="ApplicationId" OtherKey="ApplicationId" Type="aspnet_Application" IsForeignKey="true" />
|
|---|
| 38 | <Association Name="aspnet_User_aspnet_Membership" Member="aspnet_User" ThisKey="UserId" OtherKey="UserId" Type="aspnet_User" IsForeignKey="true" />
|
|---|
| 39 | </Type>
|
|---|
| 40 | </Table>
|
|---|
| 41 | <Table Name="dbo.aspnet_Roles" Member="aspnet_Roles">
|
|---|
| 42 | <Type Name="aspnet_Role">
|
|---|
| 43 | <Column Name="ApplicationId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
|
|---|
| 44 | <Column Name="RoleId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 45 | <Column Name="RoleName" Type="System.String" DbType="NVarChar(256) NOT NULL" CanBeNull="false" />
|
|---|
| 46 | <Column Name="LoweredRoleName" Type="System.String" DbType="NVarChar(256) NOT NULL" CanBeNull="false" />
|
|---|
| 47 | <Column Name="Description" Type="System.String" DbType="NVarChar(256)" CanBeNull="true" />
|
|---|
| 48 | <Association Name="aspnet_Role_aspnet_UsersInRole" Member="aspnet_UsersInRoles" ThisKey="RoleId" OtherKey="RoleId" Type="aspnet_UsersInRole" />
|
|---|
| 49 | <Association Name="aspnet_Application_aspnet_Role" Member="aspnet_Application" ThisKey="ApplicationId" OtherKey="ApplicationId" Type="aspnet_Application" IsForeignKey="true" />
|
|---|
| 50 | </Type>
|
|---|
| 51 | </Table>
|
|---|
| 52 | <Table Name="dbo.aspnet_Users" Member="aspnet_Users">
|
|---|
| 53 | <Type Name="aspnet_User">
|
|---|
| 54 | <Column Name="ApplicationId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
|
|---|
| 55 | <Column Name="UserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 56 | <Column Name="UserName" Type="System.String" DbType="NVarChar(256) NOT NULL" CanBeNull="false" />
|
|---|
| 57 | <Column Name="LoweredUserName" Type="System.String" DbType="NVarChar(256) NOT NULL" CanBeNull="false" />
|
|---|
| 58 | <Column Name="MobileAlias" Type="System.String" DbType="NVarChar(16)" CanBeNull="true" />
|
|---|
| 59 | <Column Name="IsAnonymous" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
|
|---|
| 60 | <Column Name="LastActivityDate" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
|
|---|
| 61 | <Association Name="aspnet_User_aspnet_Membership" Member="aspnet_Membership" ThisKey="UserId" OtherKey="UserId" Type="aspnet_Membership" Cardinality="One" />
|
|---|
| 62 | <Association Name="aspnet_User_aspnet_UsersInRole" Member="aspnet_UsersInRoles" ThisKey="UserId" OtherKey="UserId" Type="aspnet_UsersInRole" />
|
|---|
| 63 | <Association Name="aspnet_Application_aspnet_User" Member="aspnet_Application" ThisKey="ApplicationId" OtherKey="ApplicationId" Type="aspnet_Application" IsForeignKey="true" />
|
|---|
| 64 | </Type>
|
|---|
| 65 | </Table>
|
|---|
| 66 | <Table Name="dbo.aspnet_UsersInRoles" Member="aspnet_UsersInRoles">
|
|---|
| 67 | <Type Name="aspnet_UsersInRole">
|
|---|
| 68 | <Column Name="UserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 69 | <Column Name="RoleId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 70 | <Association Name="aspnet_Role_aspnet_UsersInRole" Member="aspnet_Role" ThisKey="RoleId" OtherKey="RoleId" Type="aspnet_Role" IsForeignKey="true" />
|
|---|
| 71 | <Association Name="aspnet_User_aspnet_UsersInRole" Member="aspnet_User" ThisKey="UserId" OtherKey="UserId" Type="aspnet_User" IsForeignKey="true" />
|
|---|
| 72 | </Type>
|
|---|
| 73 | </Table>
|
|---|
| 74 | <Function Name="dbo.aspnet_Membership_SetPassword" Method="aspnet_Membership_SetPassword">
|
|---|
| 75 | <Parameter Name="ApplicationName" Parameter="applicationName" Type="System.String" DbType="NVarChar(256)" />
|
|---|
| 76 | <Parameter Name="UserName" Parameter="userName" Type="System.String" DbType="NVarChar(256)" />
|
|---|
| 77 | <Parameter Name="NewPassword" Parameter="newPassword" Type="System.String" DbType="NVarChar(128)" />
|
|---|
| 78 | <Parameter Name="PasswordSalt" Parameter="passwordSalt" Type="System.String" DbType="NVarChar(128)" />
|
|---|
| 79 | <Parameter Name="CurrentTimeUtc" Parameter="currentTimeUtc" Type="System.DateTime" DbType="DateTime" />
|
|---|
| 80 | <Parameter Name="PasswordFormat" Parameter="passwordFormat" Type="System.Int32" DbType="Int" />
|
|---|
| 81 | <Return Type="System.Int32" />
|
|---|
| 82 | </Function>
|
|---|
| 83 | </Database> |
|---|
