| 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_Path" Member="aspnet_Paths" ThisKey="ApplicationId" OtherKey="ApplicationId" Type="aspnet_Path" />
|
|---|
| 11 | <Association Name="aspnet_Application_aspnet_Role" Member="aspnet_Roles" ThisKey="ApplicationId" OtherKey="ApplicationId" Type="aspnet_Role" />
|
|---|
| 12 | <Association Name="aspnet_Application_aspnet_User" Member="aspnet_Users" ThisKey="ApplicationId" OtherKey="ApplicationId" Type="aspnet_User" />
|
|---|
| 13 | </Type>
|
|---|
| 14 | </Table>
|
|---|
| 15 | <Table Name="dbo.aspnet_Membership" Member="aspnet_Memberships">
|
|---|
| 16 | <Type Name="aspnet_Membership">
|
|---|
| 17 | <Column Name="ApplicationId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
|
|---|
| 18 | <Column Name="UserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 19 | <Column Name="Password" Type="System.String" DbType="NVarChar(128) NOT NULL" CanBeNull="false" />
|
|---|
| 20 | <Column Name="PasswordFormat" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|---|
| 21 | <Column Name="PasswordSalt" Type="System.String" DbType="NVarChar(128) NOT NULL" CanBeNull="false" />
|
|---|
| 22 | <Column Name="MobilePIN" Type="System.String" DbType="NVarChar(16)" CanBeNull="true" />
|
|---|
| 23 | <Column Name="Email" Type="System.String" DbType="NVarChar(256)" CanBeNull="true" />
|
|---|
| 24 | <Column Name="LoweredEmail" Type="System.String" DbType="NVarChar(256)" CanBeNull="true" />
|
|---|
| 25 | <Column Name="PasswordQuestion" Type="System.String" DbType="NVarChar(256)" CanBeNull="true" />
|
|---|
| 26 | <Column Name="PasswordAnswer" Type="System.String" DbType="NVarChar(128)" CanBeNull="true" />
|
|---|
| 27 | <Column Name="IsApproved" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
|
|---|
| 28 | <Column Name="IsLockedOut" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
|
|---|
| 29 | <Column Name="CreateDate" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
|
|---|
| 30 | <Column Name="LastLoginDate" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
|
|---|
| 31 | <Column Name="LastPasswordChangedDate" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
|
|---|
| 32 | <Column Name="LastLockoutDate" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
|
|---|
| 33 | <Column Name="FailedPasswordAttemptCount" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|---|
| 34 | <Column Name="FailedPasswordAttemptWindowStart" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
|
|---|
| 35 | <Column Name="FailedPasswordAnswerAttemptCount" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|---|
| 36 | <Column Name="FailedPasswordAnswerAttemptWindowStart" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
|
|---|
| 37 | <Column Name="Comment" Type="System.String" DbType="NText" CanBeNull="true" UpdateCheck="Never" />
|
|---|
| 38 | <Association Name="aspnet_Application_aspnet_Membership" Member="aspnet_Application" ThisKey="ApplicationId" OtherKey="ApplicationId" Type="aspnet_Application" IsForeignKey="true" />
|
|---|
| 39 | <Association Name="aspnet_User_aspnet_Membership" Member="aspnet_User" ThisKey="UserId" OtherKey="UserId" Type="aspnet_User" IsForeignKey="true" />
|
|---|
| 40 | </Type>
|
|---|
| 41 | </Table>
|
|---|
| 42 | <Table Name="dbo.aspnet_Paths" Member="aspnet_Paths">
|
|---|
| 43 | <Type Name="aspnet_Path">
|
|---|
| 44 | <Column Name="ApplicationId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
|
|---|
| 45 | <Column Name="PathId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 46 | <Column Name="Path" Type="System.String" DbType="NVarChar(256) NOT NULL" CanBeNull="false" />
|
|---|
| 47 | <Column Name="LoweredPath" Type="System.String" DbType="NVarChar(256) NOT NULL" CanBeNull="false" />
|
|---|
| 48 | <Association Name="aspnet_Path_aspnet_PersonalizationAllUser" Member="aspnet_PersonalizationAllUser" ThisKey="PathId" OtherKey="PathId" Type="aspnet_PersonalizationAllUser" Cardinality="One" />
|
|---|
| 49 | <Association Name="aspnet_Path_aspnet_PersonalizationPerUser" Member="aspnet_PersonalizationPerUsers" ThisKey="PathId" OtherKey="PathId" Type="aspnet_PersonalizationPerUser" />
|
|---|
| 50 | <Association Name="aspnet_Application_aspnet_Path" Member="aspnet_Application" ThisKey="ApplicationId" OtherKey="ApplicationId" Type="aspnet_Application" IsForeignKey="true" />
|
|---|
| 51 | </Type>
|
|---|
| 52 | </Table>
|
|---|
| 53 | <Table Name="dbo.aspnet_PersonalizationAllUsers" Member="aspnet_PersonalizationAllUsers">
|
|---|
| 54 | <Type Name="aspnet_PersonalizationAllUser">
|
|---|
| 55 | <Column Name="PathId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 56 | <Column Name="PageSettings" Type="System.Data.Linq.Binary" DbType="Image NOT NULL" CanBeNull="false" UpdateCheck="Never" />
|
|---|
| 57 | <Column Name="LastUpdatedDate" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
|
|---|
| 58 | <Association Name="aspnet_Path_aspnet_PersonalizationAllUser" Member="aspnet_Path" ThisKey="PathId" OtherKey="PathId" Type="aspnet_Path" IsForeignKey="true" />
|
|---|
| 59 | </Type>
|
|---|
| 60 | </Table>
|
|---|
| 61 | <Table Name="dbo.aspnet_PersonalizationPerUser" Member="aspnet_PersonalizationPerUsers">
|
|---|
| 62 | <Type Name="aspnet_PersonalizationPerUser">
|
|---|
| 63 | <Column Name="Id" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 64 | <Column Name="PathId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
|
|---|
| 65 | <Column Name="UserId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
|
|---|
| 66 | <Column Name="PageSettings" Type="System.Data.Linq.Binary" DbType="Image NOT NULL" CanBeNull="false" UpdateCheck="Never" />
|
|---|
| 67 | <Column Name="LastUpdatedDate" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
|
|---|
| 68 | <Association Name="aspnet_Path_aspnet_PersonalizationPerUser" Member="aspnet_Path" ThisKey="PathId" OtherKey="PathId" Type="aspnet_Path" IsForeignKey="true" />
|
|---|
| 69 | <Association Name="aspnet_User_aspnet_PersonalizationPerUser" Member="aspnet_User" ThisKey="UserId" OtherKey="UserId" Type="aspnet_User" IsForeignKey="true" />
|
|---|
| 70 | </Type>
|
|---|
| 71 | </Table>
|
|---|
| 72 | <Table Name="dbo.aspnet_Profile" Member="aspnet_Profiles">
|
|---|
| 73 | <Type Name="aspnet_Profile">
|
|---|
| 74 | <Column Name="UserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 75 | <Column Name="PropertyNames" Type="System.String" DbType="NText NOT NULL" CanBeNull="false" UpdateCheck="Never" />
|
|---|
| 76 | <Column Name="PropertyValuesString" Type="System.String" DbType="NText NOT NULL" CanBeNull="false" UpdateCheck="Never" />
|
|---|
| 77 | <Column Name="PropertyValuesBinary" Type="System.Data.Linq.Binary" DbType="Image NOT NULL" CanBeNull="false" UpdateCheck="Never" />
|
|---|
| 78 | <Column Name="LastUpdatedDate" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
|
|---|
| 79 | <Association Name="aspnet_User_aspnet_Profile" Member="aspnet_User" ThisKey="UserId" OtherKey="UserId" Type="aspnet_User" IsForeignKey="true" />
|
|---|
| 80 | </Type>
|
|---|
| 81 | </Table>
|
|---|
| 82 | <Table Name="dbo.aspnet_Roles" Member="aspnet_Roles">
|
|---|
| 83 | <Type Name="aspnet_Role">
|
|---|
| 84 | <Column Name="ApplicationId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
|
|---|
| 85 | <Column Name="RoleId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 86 | <Column Name="RoleName" Type="System.String" DbType="NVarChar(256) NOT NULL" CanBeNull="false" />
|
|---|
| 87 | <Column Name="LoweredRoleName" Type="System.String" DbType="NVarChar(256) NOT NULL" CanBeNull="false" />
|
|---|
| 88 | <Column Name="Description" Type="System.String" DbType="NVarChar(256)" CanBeNull="true" />
|
|---|
| 89 | <Association Name="aspnet_Role_aspnet_UsersInRole" Member="aspnet_UsersInRoles" ThisKey="RoleId" OtherKey="RoleId" Type="aspnet_UsersInRole" />
|
|---|
| 90 | <Association Name="aspnet_Application_aspnet_Role" Member="aspnet_Application" ThisKey="ApplicationId" OtherKey="ApplicationId" Type="aspnet_Application" IsForeignKey="true" />
|
|---|
| 91 | </Type>
|
|---|
| 92 | </Table>
|
|---|
| 93 | <Table Name="dbo.aspnet_SchemaVersions" Member="aspnet_SchemaVersions">
|
|---|
| 94 | <Type Name="aspnet_SchemaVersion">
|
|---|
| 95 | <Column Name="Feature" Type="System.String" DbType="NVarChar(128) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 96 | <Column Name="CompatibleSchemaVersion" Type="System.String" DbType="NVarChar(128) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 97 | <Column Name="IsCurrentVersion" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
|
|---|
| 98 | </Type>
|
|---|
| 99 | </Table>
|
|---|
| 100 | <Table Name="dbo.aspnet_Users" Member="aspnet_Users">
|
|---|
| 101 | <Type Name="aspnet_User">
|
|---|
| 102 | <Column Name="ApplicationId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
|
|---|
| 103 | <Column Name="UserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 104 | <Column Name="UserName" Type="System.String" DbType="NVarChar(256) NOT NULL" CanBeNull="false" />
|
|---|
| 105 | <Column Name="LoweredUserName" Type="System.String" DbType="NVarChar(256) NOT NULL" CanBeNull="false" />
|
|---|
| 106 | <Column Name="MobileAlias" Type="System.String" DbType="NVarChar(16)" CanBeNull="true" />
|
|---|
| 107 | <Column Name="IsAnonymous" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
|
|---|
| 108 | <Column Name="LastActivityDate" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
|
|---|
| 109 | <Association Name="aspnet_User_aspnet_Membership" Member="aspnet_Membership" ThisKey="UserId" OtherKey="UserId" Type="aspnet_Membership" Cardinality="One" />
|
|---|
| 110 | <Association Name="aspnet_User_aspnet_PersonalizationPerUser" Member="aspnet_PersonalizationPerUsers" ThisKey="UserId" OtherKey="UserId" Type="aspnet_PersonalizationPerUser" />
|
|---|
| 111 | <Association Name="aspnet_User_aspnet_Profile" Member="aspnet_Profile" ThisKey="UserId" OtherKey="UserId" Type="aspnet_Profile" Cardinality="One" />
|
|---|
| 112 | <Association Name="aspnet_User_aspnet_UsersInRole" Member="aspnet_UsersInRoles" ThisKey="UserId" OtherKey="UserId" Type="aspnet_UsersInRole" />
|
|---|
| 113 | <Association Name="aspnet_Application_aspnet_User" Member="aspnet_Application" ThisKey="ApplicationId" OtherKey="ApplicationId" Type="aspnet_Application" IsForeignKey="true" />
|
|---|
| 114 | </Type>
|
|---|
| 115 | </Table>
|
|---|
| 116 | <Table Name="dbo.aspnet_UsersInRoles" Member="aspnet_UsersInRoles">
|
|---|
| 117 | <Type Name="aspnet_UsersInRole">
|
|---|
| 118 | <Column Name="UserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 119 | <Column Name="RoleId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 120 | <Association Name="aspnet_Role_aspnet_UsersInRole" Member="aspnet_Role" ThisKey="RoleId" OtherKey="RoleId" Type="aspnet_Role" IsForeignKey="true" />
|
|---|
| 121 | <Association Name="aspnet_User_aspnet_UsersInRole" Member="aspnet_User" ThisKey="UserId" OtherKey="UserId" Type="aspnet_User" IsForeignKey="true" />
|
|---|
| 122 | </Type>
|
|---|
| 123 | </Table>
|
|---|
| 124 | <Table Name="dbo.aspnet_WebEvent_Events" Member="aspnet_WebEvent_Events">
|
|---|
| 125 | <Type Name="aspnet_WebEvent_Event">
|
|---|
| 126 | <Column Name="EventId" Type="System.String" DbType="Char(32) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 127 | <Column Name="EventTimeUtc" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
|
|---|
| 128 | <Column Name="EventTime" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
|
|---|
| 129 | <Column Name="EventType" Type="System.String" DbType="NVarChar(256) NOT NULL" CanBeNull="false" />
|
|---|
| 130 | <Column Name="EventSequence" Type="System.Decimal" DbType="Decimal(19,0) NOT NULL" CanBeNull="false" />
|
|---|
| 131 | <Column Name="EventOccurrence" Type="System.Decimal" DbType="Decimal(19,0) NOT NULL" CanBeNull="false" />
|
|---|
| 132 | <Column Name="EventCode" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|---|
| 133 | <Column Name="EventDetailCode" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|---|
| 134 | <Column Name="Message" Type="System.String" DbType="NVarChar(1024)" CanBeNull="true" />
|
|---|
| 135 | <Column Name="ApplicationPath" Type="System.String" DbType="NVarChar(256)" CanBeNull="true" />
|
|---|
| 136 | <Column Name="ApplicationVirtualPath" Type="System.String" DbType="NVarChar(256)" CanBeNull="true" />
|
|---|
| 137 | <Column Name="MachineName" Type="System.String" DbType="NVarChar(256) NOT NULL" CanBeNull="false" />
|
|---|
| 138 | <Column Name="RequestUrl" Type="System.String" DbType="NVarChar(1024)" CanBeNull="true" />
|
|---|
| 139 | <Column Name="ExceptionType" Type="System.String" DbType="NVarChar(256)" CanBeNull="true" />
|
|---|
| 140 | <Column Name="Details" Type="System.String" DbType="NText" CanBeNull="true" UpdateCheck="Never" />
|
|---|
| 141 | </Type>
|
|---|
| 142 | </Table>
|
|---|
| 143 | <Function Name="dbo.aspnet_Users_DeleteUser" Method="aspnet_Users_DeleteUser">
|
|---|
| 144 | <Parameter Name="ApplicationName" Parameter="applicationName" Type="System.String" DbType="NVarChar(256)" />
|
|---|
| 145 | <Parameter Name="UserName" Parameter="userName" Type="System.String" DbType="NVarChar(256)" />
|
|---|
| 146 | <Parameter Name="TablesToDeleteFrom" Parameter="tablesToDeleteFrom" Type="System.Int32" DbType="Int" />
|
|---|
| 147 | <Parameter Name="NumTablesDeletedFrom" Parameter="numTablesDeletedFrom" Type="System.Int32" DbType="Int" Direction="InOut" />
|
|---|
| 148 | <Return Type="System.Int32" />
|
|---|
| 149 | </Function>
|
|---|
| 150 | </Database> |
|---|
