Changeset 5257 for branches/UserManagement/HeuristicLab.Services.Authentication.DataAccess/UserManagement.dbml
- Timestamp:
- 01/08/11 14:39:29 (14 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/UserManagement/HeuristicLab.Services.Authentication.DataAccess/UserManagement.dbml
r4647 r5257 8 8 <Column Name="Description" Type="System.String" DbType="NVarChar(256)" CanBeNull="true" /> 9 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 10 <Association Name="aspnet_Application_aspnet_Role" Member="aspnet_Roles" ThisKey="ApplicationId" OtherKey="ApplicationId" Type="aspnet_Role" /> 12 11 <Association Name="aspnet_Application_aspnet_User" Member="aspnet_Users" ThisKey="ApplicationId" OtherKey="ApplicationId" Type="aspnet_User" /> … … 40 39 </Type> 41 40 </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 41 <Table Name="dbo.aspnet_Roles" Member="aspnet_Roles"> 83 42 <Type Name="aspnet_Role"> … … 89 48 <Association Name="aspnet_Role_aspnet_UsersInRole" Member="aspnet_UsersInRoles" ThisKey="RoleId" OtherKey="RoleId" Type="aspnet_UsersInRole" /> 90 49 <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 50 </Type> 99 51 </Table> … … 108 60 <Column Name="LastActivityDate" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" /> 109 61 <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 62 <Association Name="aspnet_User_aspnet_UsersInRole" Member="aspnet_UsersInRoles" ThisKey="UserId" OtherKey="UserId" Type="aspnet_UsersInRole" /> 113 63 <Association Name="aspnet_Application_aspnet_User" Member="aspnet_Application" ThisKey="ApplicationId" OtherKey="ApplicationId" Type="aspnet_Application" IsForeignKey="true" /> … … 122 72 </Type> 123 73 </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"> 74 <Function Name="dbo.aspnet_Membership_ResetPassword" Method="aspnet_Membership_ResetPassword"> 144 75 <Parameter Name="ApplicationName" Parameter="applicationName" Type="System.String" DbType="NVarChar(256)" /> 145 76 <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 <Function Name="dbo.aspnet_Users_CreateUser" Method="aspnet_Users_CreateUser"> 151 <Parameter Name="ApplicationId" Parameter="applicationId" Type="System.Guid" DbType="UniqueIdentifier" /> 152 <Parameter Name="UserName" Parameter="userName" Type="System.String" DbType="NVarChar(256)" /> 153 <Parameter Name="IsUserAnonymous" Parameter="isUserAnonymous" Type="System.Boolean" DbType="Bit" /> 154 <Parameter Name="LastActivityDate" Parameter="lastActivityDate" Type="System.DateTime" DbType="DateTime" /> 155 <Parameter Name="UserId" Parameter="userId" Type="System.Guid" DbType="UniqueIdentifier" Direction="InOut" /> 156 <Return Type="System.Int32" /> 157 </Function> 158 <Function Name="dbo.aspnet_UsersInRoles_AddUsersToRoles" Method="aspnet_UsersInRoles_AddUsersToRoles"> 159 <Parameter Name="ApplicationName" Parameter="applicationName" Type="System.String" DbType="NVarChar(256)" /> 160 <Parameter Name="UserNames" Parameter="userNames" Type="System.String" DbType="NVarChar(4000)" /> 161 <Parameter Name="RoleNames" Parameter="roleNames" Type="System.String" DbType="NVarChar(4000)" /> 77 <Parameter Name="NewPassword" Parameter="newPassword" Type="System.String" DbType="NVarChar(128)" /> 78 <Parameter Name="MaxInvalidPasswordAttempts" Parameter="maxInvalidPasswordAttempts" Type="System.Int32" DbType="Int" /> 79 <Parameter Name="PasswordAttemptWindow" Parameter="passwordAttemptWindow" Type="System.Int32" DbType="Int" /> 80 <Parameter Name="PasswordSalt" Parameter="passwordSalt" Type="System.String" DbType="NVarChar(128)" /> 162 81 <Parameter Name="CurrentTimeUtc" Parameter="currentTimeUtc" Type="System.DateTime" DbType="DateTime" /> 163 <ElementType Name="aspnet_UsersInRoles_AddUsersToRolesResult"> 164 <Column Name="Name" Type="System.String" DbType="NVarChar(256) NOT NULL" CanBeNull="false" /> 165 </ElementType> 166 </Function> 167 <Function Name="dbo.aspnet_UsersInRoles_RemoveUsersFromRoles" Method="aspnet_UsersInRoles_RemoveUsersFromRoles"> 168 <Parameter Name="ApplicationName" Parameter="applicationName" Type="System.String" DbType="NVarChar(256)" /> 169 <Parameter Name="UserNames" Parameter="userNames" Type="System.String" DbType="NVarChar(4000)" /> 170 <Parameter Name="RoleNames" Parameter="roleNames" Type="System.String" DbType="NVarChar(4000)" /> 171 <ElementType Name="aspnet_UsersInRoles_RemoveUsersFromRolesResult"> 172 <Column Name="" Member="Column1" Type="System.String" DbType="NVarChar(1) NOT NULL" CanBeNull="false" /> 173 <Column Name="Name" Type="System.String" DbType="NVarChar(256) NOT NULL" CanBeNull="false" /> 174 </ElementType> 175 </Function> 176 <Function Name="dbo.aspnet_UsersInRoles_IsUserInRole" Method="aspnet_UsersInRoles_IsUserInRole"> 177 <Parameter Name="ApplicationName" Parameter="applicationName" Type="System.String" DbType="NVarChar(256)" /> 178 <Parameter Name="UserName" Parameter="userName" Type="System.String" DbType="NVarChar(256)" /> 179 <Parameter Name="RoleName" Parameter="roleName" Type="System.String" DbType="NVarChar(256)" /> 180 <Return Type="System.Int32" /> 181 </Function> 182 <Function Name="dbo.aspnet_UsersInRoles_GetUsersInRoles" Method="aspnet_UsersInRoles_GetUsersInRoles"> 183 <Parameter Name="ApplicationName" Parameter="applicationName" Type="System.String" DbType="NVarChar(256)" /> 184 <Parameter Name="RoleName" Parameter="roleName" Type="System.String" DbType="NVarChar(256)" /> 185 <ElementType Name="aspnet_UsersInRoles_GetUsersInRolesResult"> 186 <Column Name="UserName" Type="System.String" DbType="NVarChar(256) NOT NULL" CanBeNull="false" /> 187 </ElementType> 188 </Function> 189 <Function Name="dbo.aspnet_UsersInRoles_GetRolesForUser" Method="aspnet_UsersInRoles_GetRolesForUser"> 190 <Parameter Name="ApplicationName" Parameter="applicationName" Type="System.String" DbType="NVarChar(256)" /> 191 <Parameter Name="UserName" Parameter="userName" Type="System.String" DbType="NVarChar(256)" /> 192 <ElementType Name="aspnet_UsersInRoles_GetRolesForUserResult"> 193 <Column Name="RoleName" Type="System.String" DbType="NVarChar(256) NOT NULL" CanBeNull="false" /> 194 </ElementType> 195 </Function> 196 <Function Name="dbo.aspnet_UsersInRoles_FindUsersInRole" Method="aspnet_UsersInRoles_FindUsersInRole"> 197 <Parameter Name="ApplicationName" Parameter="applicationName" Type="System.String" DbType="NVarChar(256)" /> 198 <Parameter Name="RoleName" Parameter="roleName" Type="System.String" DbType="NVarChar(256)" /> 199 <Parameter Name="UserNameToMatch" Parameter="userNameToMatch" Type="System.String" DbType="NVarChar(256)" /> 200 <ElementType Name="aspnet_UsersInRoles_FindUsersInRoleResult"> 201 <Column Name="UserName" Type="System.String" DbType="NVarChar(256) NOT NULL" CanBeNull="false" /> 202 </ElementType> 203 </Function> 204 <Function Name="dbo.aspnet_Roles_CreateRole" Method="aspnet_Roles_CreateRole"> 205 <Parameter Name="ApplicationName" Parameter="applicationName" Type="System.String" DbType="NVarChar(256)" /> 206 <Parameter Name="RoleName" Parameter="roleName" Type="System.String" DbType="NVarChar(256)" /> 207 <Return Type="System.Int32" /> 208 </Function> 209 <Function Name="dbo.aspnet_Roles_DeleteRole" Method="aspnet_Roles_DeleteRole"> 210 <Parameter Name="ApplicationName" Parameter="applicationName" Type="System.String" DbType="NVarChar(256)" /> 211 <Parameter Name="RoleName" Parameter="roleName" Type="System.String" DbType="NVarChar(256)" /> 212 <Parameter Name="DeleteOnlyIfRoleIsEmpty" Parameter="deleteOnlyIfRoleIsEmpty" Type="System.Boolean" DbType="Bit" /> 213 <Return Type="System.Int32" /> 214 </Function> 215 <Function Name="dbo.aspnet_Applications_CreateApplication" Method="aspnet_Applications_CreateApplication"> 216 <Parameter Name="ApplicationName" Parameter="applicationName" Type="System.String" DbType="NVarChar(256)" /> 217 <Parameter Name="ApplicationId" Parameter="applicationId" Type="System.Guid" DbType="UniqueIdentifier" Direction="InOut" /> 218 <Return Type="System.Int32" /> 219 </Function> 220 <Function Name="dbo.aspnet_Roles_RoleExists" Method="aspnet_Roles_RoleExists"> 221 <Parameter Name="ApplicationName" Parameter="applicationName" Type="System.String" DbType="NVarChar(256)" /> 222 <Parameter Name="RoleName" Parameter="roleName" Type="System.String" DbType="NVarChar(256)" /> 223 <Return Type="System.Int32" /> 224 </Function> 225 <Function Name="dbo.aspnet_Roles_GetAllRoles" Method="aspnet_Roles_GetAllRoles"> 226 <Parameter Name="ApplicationName" Parameter="applicationName" Type="System.String" DbType="NVarChar(256)" /> 227 <ElementType Name="aspnet_Roles_GetAllRolesResult"> 228 <Column Name="RoleName" Type="System.String" DbType="NVarChar(256) NOT NULL" CanBeNull="false" /> 229 </ElementType> 230 </Function> 231 <Function Name="dbo.aspnet_Membership_CreateUser" Method="aspnet_Membership_CreateUser"> 232 <Parameter Name="ApplicationName" Parameter="applicationName" Type="System.String" DbType="NVarChar(256)" /> 233 <Parameter Name="UserName" Parameter="userName" Type="System.String" DbType="NVarChar(256)" /> 234 <Parameter Name="Password" Parameter="password" Type="System.String" DbType="NVarChar(128)" /> 235 <Parameter Name="PasswordSalt" Parameter="passwordSalt" Type="System.String" DbType="NVarChar(128)" /> 236 <Parameter Name="Email" Parameter="email" Type="System.String" DbType="NVarChar(256)" /> 237 <Parameter Name="PasswordQuestion" Parameter="passwordQuestion" Type="System.String" DbType="NVarChar(256)" /> 82 <Parameter Name="PasswordFormat" Parameter="passwordFormat" Type="System.Int32" DbType="Int" /> 238 83 <Parameter Name="PasswordAnswer" Parameter="passwordAnswer" Type="System.String" DbType="NVarChar(128)" /> 239 <Parameter Name="IsApproved" Parameter="isApproved" Type="System.Boolean" DbType="Bit" />240 <Parameter Name="CurrentTimeUtc" Parameter="currentTimeUtc" Type="System.DateTime" DbType="DateTime" />241 <Parameter Name="CreateDate" Parameter="createDate" Type="System.DateTime" DbType="DateTime" />242 <Parameter Name="UniqueEmail" Parameter="uniqueEmail" Type="System.Int32" DbType="Int" />243 <Parameter Name="PasswordFormat" Parameter="passwordFormat" Type="System.Int32" DbType="Int" />244 <Parameter Name="UserId" Parameter="userId" Type="System.Guid" DbType="UniqueIdentifier" Direction="InOut" />245 84 <Return Type="System.Int32" /> 246 85 </Function>
Note: See TracChangeset
for help on using the changeset viewer.