[1638] | 1 | <?xml version="1.0" encoding="utf-8"?>
|
---|
| 2 | <xs:schema id="dsSecurity" targetNamespace="http://tempuri.org/dsSecurity.xsd" xmlns:mstns="http://tempuri.org/dsSecurity.xsd" xmlns="http://tempuri.org/dsSecurity.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
|
---|
| 3 | <xs:annotation>
|
---|
| 4 | <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
|
---|
| 5 | <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
|
---|
| 6 | <Connections>
|
---|
[1656] | 7 | <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="HeuristicLab_SecurityConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="HeuristicLab_SecurityConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.HeuristicLab.Security.ADODataAccess.Properties.Settings.GlobalReference.Default.HeuristicLab_SecurityConnectionString" Provider="System.Data.SqlClient" />
|
---|
[1638] | 8 | </Connections>
|
---|
| 9 | <Tables>
|
---|
| 10 | <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="GrantedPermissionsTableAdapter" GeneratorDataComponentClassName="GrantedPermissionsTableAdapter" Name="GrantedPermissions" UserDataComponentName="GrantedPermissionsTableAdapter">
|
---|
| 11 | <MainSource>
|
---|
| 12 | <DbSource ConnectionRef="HeuristicLab_SecurityConnectionString (Settings)" DbObjectName="[HeuristicLab.Security].dbo.GrantedPermissions" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
---|
| 13 | <DeleteCommand>
|
---|
| 14 | <DbCommand CommandType="Text" ModifiedByUser="false">
|
---|
| 15 | <CommandText>DELETE FROM [dbo].[GrantedPermissions] WHERE (([PermissionId] = @Original_PermissionId) AND ([PermissionOwnerId] = @Original_PermissionOwnerId) AND ([EntityId] = @Original_EntityId))</CommandText>
|
---|
| 16 | <Parameters>
|
---|
| 17 | <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_PermissionId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PermissionId" SourceColumnNullMapping="false" SourceVersion="Original" />
|
---|
| 18 | <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_PermissionOwnerId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PermissionOwnerId" SourceColumnNullMapping="false" SourceVersion="Original" />
|
---|
| 19 | <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_EntityId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="EntityId" SourceColumnNullMapping="false" SourceVersion="Original" />
|
---|
| 20 | </Parameters>
|
---|
| 21 | </DbCommand>
|
---|
| 22 | </DeleteCommand>
|
---|
| 23 | <InsertCommand>
|
---|
| 24 | <DbCommand CommandType="Text" ModifiedByUser="false">
|
---|
| 25 | <CommandText>INSERT INTO [dbo].[GrantedPermissions] ([PermissionId], [PermissionOwnerId], [EntityId]) VALUES (@PermissionId, @PermissionOwnerId, @EntityId);
|
---|
| 26 | SELECT PermissionId, PermissionOwnerId, EntityId FROM GrantedPermissions WHERE (EntityId = @EntityId) AND (PermissionId = @PermissionId) AND (PermissionOwnerId = @PermissionOwnerId)</CommandText>
|
---|
| 27 | <Parameters>
|
---|
| 28 | <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@PermissionId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PermissionId" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
| 29 | <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@PermissionOwnerId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PermissionOwnerId" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
| 30 | <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@EntityId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="EntityId" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
| 31 | </Parameters>
|
---|
| 32 | </DbCommand>
|
---|
| 33 | </InsertCommand>
|
---|
| 34 | <SelectCommand>
|
---|
| 35 | <DbCommand CommandType="Text" ModifiedByUser="true">
|
---|
| 36 | <CommandText>SELECT * FROM dbo.GrantedPermissions</CommandText>
|
---|
| 37 | <Parameters />
|
---|
| 38 | </DbCommand>
|
---|
| 39 | </SelectCommand>
|
---|
| 40 | <UpdateCommand>
|
---|
| 41 | <DbCommand CommandType="Text" ModifiedByUser="false">
|
---|
| 42 | <CommandText>UPDATE [dbo].[GrantedPermissions] SET [PermissionId] = @PermissionId, [PermissionOwnerId] = @PermissionOwnerId, [EntityId] = @EntityId WHERE (([PermissionId] = @Original_PermissionId) AND ([PermissionOwnerId] = @Original_PermissionOwnerId) AND ([EntityId] = @Original_EntityId));
|
---|
| 43 | SELECT PermissionId, PermissionOwnerId, EntityId FROM GrantedPermissions WHERE (EntityId = @EntityId) AND (PermissionId = @PermissionId) AND (PermissionOwnerId = @PermissionOwnerId)</CommandText>
|
---|
| 44 | <Parameters>
|
---|
| 45 | <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@PermissionId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PermissionId" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
| 46 | <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@PermissionOwnerId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PermissionOwnerId" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
| 47 | <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@EntityId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="EntityId" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
| 48 | <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_PermissionId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PermissionId" SourceColumnNullMapping="false" SourceVersion="Original" />
|
---|
| 49 | <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_PermissionOwnerId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PermissionOwnerId" SourceColumnNullMapping="false" SourceVersion="Original" />
|
---|
| 50 | <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_EntityId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="EntityId" SourceColumnNullMapping="false" SourceVersion="Original" />
|
---|
| 51 | </Parameters>
|
---|
| 52 | </DbCommand>
|
---|
| 53 | </UpdateCommand>
|
---|
| 54 | </DbSource>
|
---|
| 55 | </MainSource>
|
---|
| 56 | <Mappings>
|
---|
| 57 | <Mapping SourceColumn="PermissionId" DataSetColumn="PermissionId" />
|
---|
| 58 | <Mapping SourceColumn="PermissionOwnerId" DataSetColumn="PermissionOwnerId" />
|
---|
| 59 | <Mapping SourceColumn="EntityId" DataSetColumn="EntityId" />
|
---|
| 60 | </Mappings>
|
---|
[1720] | 61 | <Sources>
|
---|
| 62 | <DbSource ConnectionRef="HeuristicLab_SecurityConnectionString (Settings)" DbObjectName="[HeuristicLab.Security].dbo.GrantedPermissions" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByEntityId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByEntityId" GeneratorSourceName="FillByEntityId" GetMethodModifier="Public" GetMethodName="GetDataByEntityId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByEntityId" UserSourceName="FillByEntityId">
|
---|
| 63 | <SelectCommand>
|
---|
| 64 | <DbCommand CommandType="Text" ModifiedByUser="true">
|
---|
| 65 | <CommandText>SELECT * FROM dbo.GrantedPermissions WHERE EntityId = @EntityId</CommandText>
|
---|
| 66 | <Parameters>
|
---|
| 67 | <Parameter AllowDbNull="false" AutogeneratedName="EntityId" ColumnName="EntityId" DataSourceName="[HeuristicLab.Security].dbo.GrantedPermissions" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@EntityId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="EntityId" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
| 68 | </Parameters>
|
---|
| 69 | </DbCommand>
|
---|
| 70 | </SelectCommand>
|
---|
| 71 | </DbSource>
|
---|
| 72 | <DbSource ConnectionRef="HeuristicLab_SecurityConnectionString (Settings)" DbObjectName="[HeuristicLab.Security].dbo.GrantedPermissions" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByPermissionId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByPermissionId" GeneratorSourceName="FillByPermissionId" GetMethodModifier="Public" GetMethodName="GetDataByPermissionId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByPermissionId" UserSourceName="FillByPermissionId">
|
---|
| 73 | <SelectCommand>
|
---|
| 74 | <DbCommand CommandType="Text" ModifiedByUser="true">
|
---|
| 75 | <CommandText>SELECT * FROM dbo.GrantedPermissions WHERE PermissionId = @PermissionId</CommandText>
|
---|
| 76 | <Parameters>
|
---|
| 77 | <Parameter AllowDbNull="false" AutogeneratedName="PermissionId" ColumnName="PermissionId" DataSourceName="[HeuristicLab.Security].dbo.GrantedPermissions" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@PermissionId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="PermissionId" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
| 78 | </Parameters>
|
---|
| 79 | </DbCommand>
|
---|
| 80 | </SelectCommand>
|
---|
| 81 | </DbSource>
|
---|
| 82 | <DbSource ConnectionRef="HeuristicLab_SecurityConnectionString (Settings)" DbObjectName="[HeuristicLab.Security].dbo.GrantedPermissions" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByPermissionOwnerId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByPermissionOwnerId" GeneratorSourceName="FillByPermissionOwnerId" GetMethodModifier="Public" GetMethodName="GetDataByPermissionOwnerId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByPermissionOwnerId" UserSourceName="FillByPermissionOwnerId">
|
---|
| 83 | <SelectCommand>
|
---|
| 84 | <DbCommand CommandType="Text" ModifiedByUser="true">
|
---|
| 85 | <CommandText>SELECT * FROM dbo.GrantedPermissions WHERE PermissionOwnerId = @PermissionOwnerId</CommandText>
|
---|
| 86 | <Parameters>
|
---|
| 87 | <Parameter AllowDbNull="false" AutogeneratedName="PermissionOwnerId" ColumnName="PermissionOwnerId" DataSourceName="[HeuristicLab.Security].dbo.GrantedPermissions" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@PermissionOwnerId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="PermissionOwnerId" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
| 88 | </Parameters>
|
---|
| 89 | </DbCommand>
|
---|
| 90 | </SelectCommand>
|
---|
| 91 | </DbSource>
|
---|
| 92 | <DbSource ConnectionRef="HeuristicLab_SecurityConnectionString (Settings)" DbObjectName="[HeuristicLab.Security].dbo.GrantedPermissions" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByPermissionPermissionOwnerEntityId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByPermissionPermissionOwnerEntityId" GeneratorSourceName="FillByPermissionPermissionOwnerEntityId" GetMethodModifier="Public" GetMethodName="GetDataByPermissionPermissionOwnerEntityId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByPermissionPermissionOwnerEntityId" UserSourceName="FillByPermissionPermissionOwnerEntityId">
|
---|
| 93 | <SelectCommand>
|
---|
| 94 | <DbCommand CommandType="Text" ModifiedByUser="true">
|
---|
| 95 | <CommandText>SELECT * FROM dbo.GrantedPermissions WHERE PermissionId = @PermissionId AND PermissionOwnerId = @PermissionOwnerId AND EntityId = @EntityId</CommandText>
|
---|
| 96 | <Parameters>
|
---|
| 97 | <Parameter AllowDbNull="false" AutogeneratedName="PermissionId" ColumnName="PermissionId" DataSourceName="[HeuristicLab.Security].dbo.GrantedPermissions" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@PermissionId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="PermissionId" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
| 98 | <Parameter AllowDbNull="false" AutogeneratedName="PermissionOwnerId" ColumnName="PermissionOwnerId" DataSourceName="[HeuristicLab.Security].dbo.GrantedPermissions" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@PermissionOwnerId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="PermissionOwnerId" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
| 99 | <Parameter AllowDbNull="false" AutogeneratedName="EntityId" ColumnName="EntityId" DataSourceName="[HeuristicLab.Security].dbo.GrantedPermissions" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@EntityId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="EntityId" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
| 100 | </Parameters>
|
---|
| 101 | </DbCommand>
|
---|
| 102 | </SelectCommand>
|
---|
| 103 | </DbSource>
|
---|
| 104 | </Sources>
|
---|
[1638] | 105 | </TableAdapter>
|
---|
| 106 | <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UserGroupTableAdapter" GeneratorDataComponentClassName="UserGroupTableAdapter" Name="UserGroup" UserDataComponentName="UserGroupTableAdapter">
|
---|
| 107 | <MainSource>
|
---|
| 108 | <DbSource ConnectionRef="HeuristicLab_SecurityConnectionString (Settings)" DbObjectName="[HeuristicLab.Security].dbo.UserGroup" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
---|
| 109 | <DeleteCommand>
|
---|
| 110 | <DbCommand CommandType="Text" ModifiedByUser="false">
|
---|
| 111 | <CommandText>DELETE FROM [dbo].[UserGroup] WHERE (([PermissionOwnerId] = @Original_PermissionOwnerId))</CommandText>
|
---|
| 112 | <Parameters>
|
---|
| 113 | <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_PermissionOwnerId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PermissionOwnerId" SourceColumnNullMapping="false" SourceVersion="Original" />
|
---|
| 114 | </Parameters>
|
---|
| 115 | </DbCommand>
|
---|
| 116 | </DeleteCommand>
|
---|
| 117 | <InsertCommand>
|
---|
| 118 | <DbCommand CommandType="Text" ModifiedByUser="false">
|
---|
| 119 | <CommandText>INSERT INTO [dbo].[UserGroup] ([PermissionOwnerId]) VALUES (@PermissionOwnerId);
|
---|
| 120 | SELECT PermissionOwnerId FROM UserGroup WHERE (PermissionOwnerId = @PermissionOwnerId)</CommandText>
|
---|
| 121 | <Parameters>
|
---|
| 122 | <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@PermissionOwnerId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PermissionOwnerId" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
| 123 | </Parameters>
|
---|
| 124 | </DbCommand>
|
---|
| 125 | </InsertCommand>
|
---|
| 126 | <SelectCommand>
|
---|
| 127 | <DbCommand CommandType="Text" ModifiedByUser="true">
|
---|
| 128 | <CommandText>SELECT * FROM dbo.UserGroup</CommandText>
|
---|
| 129 | <Parameters />
|
---|
| 130 | </DbCommand>
|
---|
| 131 | </SelectCommand>
|
---|
| 132 | <UpdateCommand>
|
---|
| 133 | <DbCommand CommandType="Text" ModifiedByUser="false">
|
---|
| 134 | <CommandText>UPDATE [dbo].[UserGroup] SET [PermissionOwnerId] = @PermissionOwnerId WHERE (([PermissionOwnerId] = @Original_PermissionOwnerId));
|
---|
| 135 | SELECT PermissionOwnerId FROM UserGroup WHERE (PermissionOwnerId = @PermissionOwnerId)</CommandText>
|
---|
| 136 | <Parameters>
|
---|
| 137 | <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@PermissionOwnerId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PermissionOwnerId" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
| 138 | <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_PermissionOwnerId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PermissionOwnerId" SourceColumnNullMapping="false" SourceVersion="Original" />
|
---|
| 139 | </Parameters>
|
---|
| 140 | </DbCommand>
|
---|
| 141 | </UpdateCommand>
|
---|
| 142 | </DbSource>
|
---|
| 143 | </MainSource>
|
---|
| 144 | <Mappings>
|
---|
| 145 | <Mapping SourceColumn="PermissionOwnerId" DataSetColumn="PermissionOwnerId" />
|
---|
| 146 | </Mappings>
|
---|
[1656] | 147 | <Sources>
|
---|
| 148 | <DbSource ConnectionRef="HeuristicLab_SecurityConnectionString (Settings)" DbObjectName="[HeuristicLab.Security].dbo.UserGroup" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillById" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataById" GeneratorSourceName="FillById" GetMethodModifier="Public" GetMethodName="GetDataById" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataById" UserSourceName="FillById">
|
---|
| 149 | <SelectCommand>
|
---|
| 150 | <DbCommand CommandType="Text" ModifiedByUser="true">
|
---|
| 151 | <CommandText>SELECT * FROM dbo.UserGroup WHERE PermissionOwnerId = @Id</CommandText>
|
---|
| 152 | <Parameters>
|
---|
| 153 | <Parameter AllowDbNull="false" AutogeneratedName="Id" ColumnName="PermissionOwnerId" DataSourceName="[HeuristicLab.Security].dbo.UserGroup" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="PermissionOwnerId" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
| 154 | </Parameters>
|
---|
| 155 | </DbCommand>
|
---|
| 156 | </SelectCommand>
|
---|
| 157 | </DbSource>
|
---|
[1724] | 158 | <DbSource ConnectionRef="HeuristicLab_SecurityConnectionString (Settings)" DbObjectName="[HeuristicLab.Security].dbo.UserGroup" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByMemberOf" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByMemberOf" GeneratorSourceName="FillByMemberOf" GetMethodModifier="Public" GetMethodName="GetDataByMemberOf" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByMemberOf" UserSourceName="FillByMemberOf">
|
---|
| 159 | <SelectCommand>
|
---|
| 160 | <DbCommand CommandType="Text" ModifiedByUser="true">
|
---|
| 161 | <CommandText>SELECT * FROM UserGroup WHERE EXISTS (SELECT * FROM PermissionOwner_UserGroup WHERE PermissionOwner_UserGroup.PermissionOwnerId = @PermissionOwnerId AND PermissionOwner_UserGroup.UserGroupId = UserGroup.PermissionOwnerId)</CommandText>
|
---|
| 162 | <Parameters>
|
---|
| 163 | <Parameter AllowDbNull="false" AutogeneratedName="PermissionOwnerId" ColumnName="PermissionOwnerId" DataSourceName="[HeuristicLab.Security].dbo.UserGroup" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@PermissionOwnerId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="PermissionOwnerId" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
| 164 | </Parameters>
|
---|
| 165 | </DbCommand>
|
---|
| 166 | </SelectCommand>
|
---|
| 167 | </DbSource>
|
---|
[1656] | 168 | </Sources>
|
---|
[1638] | 169 | </TableAdapter>
|
---|
| 170 | <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="HLUserTableAdapter" GeneratorDataComponentClassName="HLUserTableAdapter" Name="HLUser" UserDataComponentName="HLUserTableAdapter">
|
---|
| 171 | <MainSource>
|
---|
| 172 | <DbSource ConnectionRef="HeuristicLab_SecurityConnectionString (Settings)" DbObjectName="[HeuristicLab.Security].dbo.HLUser" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
---|
| 173 | <DeleteCommand>
|
---|
| 174 | <DbCommand CommandType="Text" ModifiedByUser="false">
|
---|
[1656] | 175 | <CommandText>DELETE FROM [HLUser] WHERE (([PermissionOwnerId] = @Original_PermissionOwnerId))</CommandText>
|
---|
[1638] | 176 | <Parameters>
|
---|
| 177 | <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_PermissionOwnerId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PermissionOwnerId" SourceColumnNullMapping="false" SourceVersion="Original" />
|
---|
| 178 | </Parameters>
|
---|
| 179 | </DbCommand>
|
---|
| 180 | </DeleteCommand>
|
---|
| 181 | <InsertCommand>
|
---|
| 182 | <DbCommand CommandType="Text" ModifiedByUser="false">
|
---|
[1656] | 183 | <CommandText>INSERT INTO [HLUser] ([PermissionOwnerId], [Password], [Login], [MailAddress]) VALUES (@PermissionOwnerId, @Password, @Login, @MailAddress);
|
---|
[1638] | 184 | SELECT PermissionOwnerId, Password, Login, MailAddress FROM HLUser WHERE (PermissionOwnerId = @PermissionOwnerId)</CommandText>
|
---|
| 185 | <Parameters>
|
---|
| 186 | <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@PermissionOwnerId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PermissionOwnerId" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
[1656] | 187 | <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
[1638] | 188 | <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Login" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Login" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
| 189 | <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MailAddress" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MailAddress" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
| 190 | </Parameters>
|
---|
| 191 | </DbCommand>
|
---|
| 192 | </InsertCommand>
|
---|
| 193 | <SelectCommand>
|
---|
| 194 | <DbCommand CommandType="Text" ModifiedByUser="true">
|
---|
[1656] | 195 | <CommandText>SELECT * FROM HLUser</CommandText>
|
---|
[1638] | 196 | <Parameters />
|
---|
| 197 | </DbCommand>
|
---|
| 198 | </SelectCommand>
|
---|
| 199 | <UpdateCommand>
|
---|
| 200 | <DbCommand CommandType="Text" ModifiedByUser="false">
|
---|
[1656] | 201 | <CommandText>UPDATE [HLUser] SET [PermissionOwnerId] = @PermissionOwnerId, [Password] = @Password, [Login] = @Login, [MailAddress] = @MailAddress WHERE (([PermissionOwnerId] = @Original_PermissionOwnerId));
|
---|
[1638] | 202 | SELECT PermissionOwnerId, Password, Login, MailAddress FROM HLUser WHERE (PermissionOwnerId = @PermissionOwnerId)</CommandText>
|
---|
| 203 | <Parameters>
|
---|
| 204 | <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@PermissionOwnerId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PermissionOwnerId" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
[1656] | 205 | <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
[1638] | 206 | <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Login" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Login" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
| 207 | <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MailAddress" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MailAddress" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
| 208 | <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_PermissionOwnerId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PermissionOwnerId" SourceColumnNullMapping="false" SourceVersion="Original" />
|
---|
| 209 | </Parameters>
|
---|
| 210 | </DbCommand>
|
---|
| 211 | </UpdateCommand>
|
---|
| 212 | </DbSource>
|
---|
| 213 | </MainSource>
|
---|
| 214 | <Mappings>
|
---|
| 215 | <Mapping SourceColumn="PermissionOwnerId" DataSetColumn="PermissionOwnerId" />
|
---|
| 216 | <Mapping SourceColumn="Password" DataSetColumn="Password" />
|
---|
| 217 | <Mapping SourceColumn="Login" DataSetColumn="Login" />
|
---|
| 218 | <Mapping SourceColumn="MailAddress" DataSetColumn="MailAddress" />
|
---|
| 219 | </Mappings>
|
---|
[1656] | 220 | <Sources>
|
---|
| 221 | <DbSource ConnectionRef="HeuristicLab_SecurityConnectionString (Settings)" DbObjectName="[HeuristicLab.Security].dbo.HLUser" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillById" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataById" GeneratorSourceName="FillById" GetMethodModifier="Public" GetMethodName="GetDataById" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataById" UserSourceName="FillById">
|
---|
| 222 | <SelectCommand>
|
---|
| 223 | <DbCommand CommandType="Text" ModifiedByUser="true">
|
---|
| 224 | <CommandText>SELECT * FROM HLUser WHERE PermissionOwnerId = @Id</CommandText>
|
---|
| 225 | <Parameters>
|
---|
| 226 | <Parameter AllowDbNull="false" AutogeneratedName="Id" ColumnName="PermissionOwnerId" DataSourceName="[HeuristicLab.Security].dbo.HLUser" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="PermissionOwnerId" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
| 227 | </Parameters>
|
---|
| 228 | </DbCommand>
|
---|
| 229 | </SelectCommand>
|
---|
| 230 | </DbSource>
|
---|
[1729] | 231 | <DbSource ConnectionRef="HeuristicLab_SecurityConnectionString (Settings)" DbObjectName="[HeuristicLab.Security].dbo.HLUser" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByLogin" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByLogin" GeneratorSourceName="FillByLogin" GetMethodModifier="Public" GetMethodName="GetDataByLogin" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByLogin" UserSourceName="FillByLogin">
|
---|
| 232 | <SelectCommand>
|
---|
| 233 | <DbCommand CommandType="Text" ModifiedByUser="true">
|
---|
| 234 | <CommandText>SELECT * FROM HLUser WHERE Login = @Login</CommandText>
|
---|
| 235 | <Parameters>
|
---|
| 236 | <Parameter AllowDbNull="true" AutogeneratedName="Login" ColumnName="Login" DataSourceName="[HeuristicLab.Security].dbo.HLUser" DataTypeServer="varchar(MAX)" DbType="AnsiString" Direction="Input" ParameterName="@Login" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumn="Login" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
| 237 | </Parameters>
|
---|
| 238 | </DbCommand>
|
---|
| 239 | </SelectCommand>
|
---|
| 240 | </DbSource>
|
---|
[1656] | 241 | </Sources>
|
---|
[1638] | 242 | </TableAdapter>
|
---|
| 243 | <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PermissionTableAdapter" GeneratorDataComponentClassName="PermissionTableAdapter" Name="Permission" UserDataComponentName="PermissionTableAdapter">
|
---|
| 244 | <MainSource>
|
---|
| 245 | <DbSource ConnectionRef="HeuristicLab_SecurityConnectionString (Settings)" DbObjectName="[HeuristicLab.Security].dbo.Permission" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
---|
| 246 | <DeleteCommand>
|
---|
| 247 | <DbCommand CommandType="Text" ModifiedByUser="false">
|
---|
[1656] | 248 | <CommandText>DELETE FROM [Permission] WHERE (([PermissionId] = @Original_PermissionId))</CommandText>
|
---|
[1638] | 249 | <Parameters>
|
---|
| 250 | <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_PermissionId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PermissionId" SourceColumnNullMapping="false" SourceVersion="Original" />
|
---|
| 251 | </Parameters>
|
---|
| 252 | </DbCommand>
|
---|
| 253 | </DeleteCommand>
|
---|
| 254 | <InsertCommand>
|
---|
| 255 | <DbCommand CommandType="Text" ModifiedByUser="false">
|
---|
[1656] | 256 | <CommandText>INSERT INTO [Permission] ([PermissionId], [Name], [Description], [Plugin]) VALUES (@PermissionId, @Name, @Description, @Plugin);
|
---|
[1638] | 257 | SELECT PermissionId, Name, Description, Plugin FROM Permission WHERE (PermissionId = @PermissionId)</CommandText>
|
---|
| 258 | <Parameters>
|
---|
| 259 | <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@PermissionId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PermissionId" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
[1656] | 260 | <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
| 261 | <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
[1638] | 262 | <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Plugin" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Plugin" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
| 263 | </Parameters>
|
---|
| 264 | </DbCommand>
|
---|
| 265 | </InsertCommand>
|
---|
| 266 | <SelectCommand>
|
---|
| 267 | <DbCommand CommandType="Text" ModifiedByUser="true">
|
---|
[1656] | 268 | <CommandText>SELECT * FROM Permission</CommandText>
|
---|
[1638] | 269 | <Parameters />
|
---|
| 270 | </DbCommand>
|
---|
| 271 | </SelectCommand>
|
---|
| 272 | <UpdateCommand>
|
---|
| 273 | <DbCommand CommandType="Text" ModifiedByUser="false">
|
---|
[1656] | 274 | <CommandText>UPDATE [Permission] SET [PermissionId] = @PermissionId, [Name] = @Name, [Description] = @Description, [Plugin] = @Plugin WHERE (([PermissionId] = @Original_PermissionId));
|
---|
[1638] | 275 | SELECT PermissionId, Name, Description, Plugin FROM Permission WHERE (PermissionId = @PermissionId)</CommandText>
|
---|
| 276 | <Parameters>
|
---|
| 277 | <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@PermissionId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PermissionId" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
[1656] | 278 | <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
| 279 | <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
[1638] | 280 | <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Plugin" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Plugin" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
| 281 | <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_PermissionId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PermissionId" SourceColumnNullMapping="false" SourceVersion="Original" />
|
---|
| 282 | </Parameters>
|
---|
| 283 | </DbCommand>
|
---|
| 284 | </UpdateCommand>
|
---|
| 285 | </DbSource>
|
---|
| 286 | </MainSource>
|
---|
| 287 | <Mappings>
|
---|
| 288 | <Mapping SourceColumn="PermissionId" DataSetColumn="PermissionId" />
|
---|
| 289 | <Mapping SourceColumn="Name" DataSetColumn="Name" />
|
---|
| 290 | <Mapping SourceColumn="Description" DataSetColumn="Description" />
|
---|
| 291 | <Mapping SourceColumn="Plugin" DataSetColumn="Plugin" />
|
---|
| 292 | </Mappings>
|
---|
[1656] | 293 | <Sources>
|
---|
| 294 | <DbSource ConnectionRef="HeuristicLab_SecurityConnectionString (Settings)" DbObjectName="[HeuristicLab.Security].dbo.Permission" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillById" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataById" GeneratorSourceName="FillById" GetMethodModifier="Public" GetMethodName="GetDataById" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataById" UserSourceName="FillById">
|
---|
| 295 | <SelectCommand>
|
---|
| 296 | <DbCommand CommandType="Text" ModifiedByUser="true">
|
---|
| 297 | <CommandText>SELECT Description, Name, PermissionId, Plugin FROM Permission WHERE (PermissionId = @Id)</CommandText>
|
---|
| 298 | <Parameters>
|
---|
| 299 | <Parameter AllowDbNull="false" AutogeneratedName="Id" ColumnName="PermissionId" DataSourceName="[HeuristicLab.Security].dbo.Permission" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="PermissionId" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
| 300 | </Parameters>
|
---|
| 301 | </DbCommand>
|
---|
| 302 | </SelectCommand>
|
---|
| 303 | </DbSource>
|
---|
| 304 | </Sources>
|
---|
[1638] | 305 | </TableAdapter>
|
---|
| 306 | <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PermissionOwnerTableAdapter" GeneratorDataComponentClassName="PermissionOwnerTableAdapter" Name="PermissionOwner" UserDataComponentName="PermissionOwnerTableAdapter">
|
---|
| 307 | <MainSource>
|
---|
| 308 | <DbSource ConnectionRef="HeuristicLab_SecurityConnectionString (Settings)" DbObjectName="[HeuristicLab.Security].dbo.PermissionOwner" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
---|
| 309 | <DeleteCommand>
|
---|
| 310 | <DbCommand CommandType="Text" ModifiedByUser="false">
|
---|
[1656] | 311 | <CommandText>DELETE FROM [PermissionOwner] WHERE (([PermissionOwnerId] = @Original_PermissionOwnerId))</CommandText>
|
---|
[1638] | 312 | <Parameters>
|
---|
| 313 | <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_PermissionOwnerId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PermissionOwnerId" SourceColumnNullMapping="false" SourceVersion="Original" />
|
---|
| 314 | </Parameters>
|
---|
| 315 | </DbCommand>
|
---|
| 316 | </DeleteCommand>
|
---|
| 317 | <InsertCommand>
|
---|
| 318 | <DbCommand CommandType="Text" ModifiedByUser="false">
|
---|
[1656] | 319 | <CommandText>INSERT INTO [PermissionOwner] ([PermissionOwnerId], [Name]) VALUES (@PermissionOwnerId, @Name);
|
---|
[1638] | 320 | SELECT PermissionOwnerId, Name FROM PermissionOwner WHERE (PermissionOwnerId = @PermissionOwnerId)</CommandText>
|
---|
| 321 | <Parameters>
|
---|
| 322 | <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@PermissionOwnerId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PermissionOwnerId" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
[1656] | 323 | <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
[1638] | 324 | </Parameters>
|
---|
| 325 | </DbCommand>
|
---|
| 326 | </InsertCommand>
|
---|
| 327 | <SelectCommand>
|
---|
| 328 | <DbCommand CommandType="Text" ModifiedByUser="true">
|
---|
[1656] | 329 | <CommandText>SELECT * FROM PermissionOwner</CommandText>
|
---|
[1638] | 330 | <Parameters />
|
---|
| 331 | </DbCommand>
|
---|
| 332 | </SelectCommand>
|
---|
| 333 | <UpdateCommand>
|
---|
| 334 | <DbCommand CommandType="Text" ModifiedByUser="false">
|
---|
[1656] | 335 | <CommandText>UPDATE [PermissionOwner] SET [PermissionOwnerId] = @PermissionOwnerId, [Name] = @Name WHERE (([PermissionOwnerId] = @Original_PermissionOwnerId));
|
---|
[1638] | 336 | SELECT PermissionOwnerId, Name FROM PermissionOwner WHERE (PermissionOwnerId = @PermissionOwnerId)</CommandText>
|
---|
| 337 | <Parameters>
|
---|
| 338 | <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@PermissionOwnerId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PermissionOwnerId" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
[1656] | 339 | <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
[1638] | 340 | <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_PermissionOwnerId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PermissionOwnerId" SourceColumnNullMapping="false" SourceVersion="Original" />
|
---|
| 341 | </Parameters>
|
---|
| 342 | </DbCommand>
|
---|
| 343 | </UpdateCommand>
|
---|
| 344 | </DbSource>
|
---|
| 345 | </MainSource>
|
---|
| 346 | <Mappings>
|
---|
| 347 | <Mapping SourceColumn="PermissionOwnerId" DataSetColumn="PermissionOwnerId" />
|
---|
| 348 | <Mapping SourceColumn="Name" DataSetColumn="Name" />
|
---|
| 349 | </Mappings>
|
---|
[1656] | 350 | <Sources>
|
---|
| 351 | <DbSource ConnectionRef="HeuristicLab_SecurityConnectionString (Settings)" DbObjectName="[HeuristicLab.Security].dbo.PermissionOwner" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillById" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataById" GeneratorSourceName="FillById" GetMethodModifier="Public" GetMethodName="GetDataById" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataById" UserSourceName="FillById">
|
---|
| 352 | <SelectCommand>
|
---|
| 353 | <DbCommand CommandType="Text" ModifiedByUser="true">
|
---|
[1729] | 354 | <CommandText>SELECT Name, PermissionOwnerId FROM PermissionOwner WHERE (PermissionOwnerId = @Id)</CommandText>
|
---|
[1656] | 355 | <Parameters>
|
---|
[1729] | 356 | <Parameter AllowDbNull="false" AutogeneratedName="Id" ColumnName="PermissionOwnerId" DataSourceName="[HeuristicLab.Security].dbo.PermissionOwner" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="PermissionOwnerId" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
[1656] | 357 | </Parameters>
|
---|
| 358 | </DbCommand>
|
---|
| 359 | </SelectCommand>
|
---|
| 360 | </DbSource>
|
---|
| 361 | <DbSource ConnectionRef="HeuristicLab_SecurityConnectionString (Settings)" DbObjectName="[HeuristicLab.Security].dbo.PermissionOwner" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByName" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByName" GeneratorSourceName="FillByName" GetMethodModifier="Public" GetMethodName="GetDataByName" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByName" UserSourceName="FillByName">
|
---|
| 362 | <SelectCommand>
|
---|
| 363 | <DbCommand CommandType="Text" ModifiedByUser="true">
|
---|
| 364 | <CommandText>SELECT Name, PermissionOwnerId FROM PermissionOwner WHERE (Name = @Name)</CommandText>
|
---|
| 365 | <Parameters>
|
---|
| 366 | <Parameter AllowDbNull="true" AutogeneratedName="Name" ColumnName="Name" DataSourceName="[HeuristicLab.Security].dbo.PermissionOwner" DataTypeServer="varchar(MAX)" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
| 367 | </Parameters>
|
---|
| 368 | </DbCommand>
|
---|
| 369 | </SelectCommand>
|
---|
| 370 | </DbSource>
|
---|
| 371 | </Sources>
|
---|
[1638] | 372 | </TableAdapter>
|
---|
| 373 | <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PermissionOwner_UserGroupTableAdapter" GeneratorDataComponentClassName="PermissionOwner_UserGroupTableAdapter" Name="PermissionOwner_UserGroup" UserDataComponentName="PermissionOwner_UserGroupTableAdapter">
|
---|
| 374 | <MainSource>
|
---|
| 375 | <DbSource ConnectionRef="HeuristicLab_SecurityConnectionString (Settings)" DbObjectName="[HeuristicLab.Security].dbo.PermissionOwner_UserGroup" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
---|
| 376 | <DeleteCommand>
|
---|
| 377 | <DbCommand CommandType="Text" ModifiedByUser="false">
|
---|
[1729] | 378 | <CommandText>DELETE FROM [dbo].[PermissionOwner_UserGroup] WHERE (([UserGroupId] = @Original_UserGroupId) AND ([PermissionOwnerId] = @Original_PermissionOwnerId))</CommandText>
|
---|
[1638] | 379 | <Parameters>
|
---|
[1729] | 380 | <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_UserGroupId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="UserGroupId" SourceColumnNullMapping="false" SourceVersion="Original" />
|
---|
[1638] | 381 | <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_PermissionOwnerId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PermissionOwnerId" SourceColumnNullMapping="false" SourceVersion="Original" />
|
---|
| 382 | </Parameters>
|
---|
| 383 | </DbCommand>
|
---|
| 384 | </DeleteCommand>
|
---|
| 385 | <InsertCommand>
|
---|
| 386 | <DbCommand CommandType="Text" ModifiedByUser="false">
|
---|
[1729] | 387 | <CommandText>INSERT INTO [dbo].[PermissionOwner_UserGroup] ([UserGroupId], [PermissionOwnerId]) VALUES (@UserGroupId, @PermissionOwnerId);
|
---|
| 388 | SELECT UserGroupId, PermissionOwnerId FROM PermissionOwner_UserGroup WHERE (PermissionOwnerId = @PermissionOwnerId) AND (UserGroupId = @UserGroupId)</CommandText>
|
---|
[1638] | 389 | <Parameters>
|
---|
[1729] | 390 | <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@UserGroupId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="UserGroupId" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
[1638] | 391 | <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@PermissionOwnerId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PermissionOwnerId" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
| 392 | </Parameters>
|
---|
| 393 | </DbCommand>
|
---|
| 394 | </InsertCommand>
|
---|
| 395 | <SelectCommand>
|
---|
| 396 | <DbCommand CommandType="Text" ModifiedByUser="true">
|
---|
| 397 | <CommandText>SELECT * FROM dbo.PermissionOwner_UserGroup</CommandText>
|
---|
| 398 | <Parameters />
|
---|
| 399 | </DbCommand>
|
---|
| 400 | </SelectCommand>
|
---|
| 401 | <UpdateCommand>
|
---|
| 402 | <DbCommand CommandType="Text" ModifiedByUser="false">
|
---|
[1729] | 403 | <CommandText>UPDATE [dbo].[PermissionOwner_UserGroup] SET [UserGroupId] = @UserGroupId, [PermissionOwnerId] = @PermissionOwnerId WHERE (([UserGroupId] = @Original_UserGroupId) AND ([PermissionOwnerId] = @Original_PermissionOwnerId));
|
---|
| 404 | SELECT UserGroupId, PermissionOwnerId FROM PermissionOwner_UserGroup WHERE (PermissionOwnerId = @PermissionOwnerId) AND (UserGroupId = @UserGroupId)</CommandText>
|
---|
[1638] | 405 | <Parameters>
|
---|
[1729] | 406 | <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@UserGroupId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="UserGroupId" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
[1638] | 407 | <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@PermissionOwnerId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PermissionOwnerId" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
[1729] | 408 | <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_UserGroupId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="UserGroupId" SourceColumnNullMapping="false" SourceVersion="Original" />
|
---|
[1638] | 409 | <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_PermissionOwnerId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PermissionOwnerId" SourceColumnNullMapping="false" SourceVersion="Original" />
|
---|
| 410 | </Parameters>
|
---|
| 411 | </DbCommand>
|
---|
| 412 | </UpdateCommand>
|
---|
| 413 | </DbSource>
|
---|
| 414 | </MainSource>
|
---|
| 415 | <Mappings>
|
---|
| 416 | <Mapping SourceColumn="PermissionOwnerId" DataSetColumn="PermissionOwnerId" />
|
---|
| 417 | <Mapping SourceColumn="UserGroupId" DataSetColumn="UserGroupId" />
|
---|
| 418 | </Mappings>
|
---|
[1656] | 419 | <Sources>
|
---|
| 420 | <DbSource ConnectionRef="HeuristicLab_SecurityConnectionString (Settings)" DbObjectName="[HeuristicLab.Security].dbo.PermissionOwner_UserGroup" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByPermissionOwnerId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByPermissionOwnerId" GeneratorSourceName="FillByPermissionOwnerId" GetMethodModifier="Public" GetMethodName="GetDataByPermissionOwnerId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByPermissionOwnerId" UserSourceName="FillByPermissionOwnerId">
|
---|
| 421 | <SelectCommand>
|
---|
| 422 | <DbCommand CommandType="Text" ModifiedByUser="true">
|
---|
[1729] | 423 | <CommandText>SELECT PermissionOwnerId, UserGroupId FROM PermissionOwner_UserGroup WHERE (PermissionOwnerId = @PermissionOwnerId)</CommandText>
|
---|
[1656] | 424 | <Parameters>
|
---|
| 425 | <Parameter AllowDbNull="false" AutogeneratedName="PermissionOwnerId" ColumnName="PermissionOwnerId" DataSourceName="[HeuristicLab.Security].dbo.PermissionOwner_UserGroup" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@PermissionOwnerId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="PermissionOwnerId" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
| 426 | </Parameters>
|
---|
| 427 | </DbCommand>
|
---|
| 428 | </SelectCommand>
|
---|
| 429 | </DbSource>
|
---|
| 430 | <DbSource ConnectionRef="HeuristicLab_SecurityConnectionString (Settings)" DbObjectName="[HeuristicLab.Security].dbo.PermissionOwner_UserGroup" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByPermissionOwnerUserGroupId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByPermissionOwnerUserGroupId" GeneratorSourceName="FillByPermissionOwnerUserGroupId" GetMethodModifier="Public" GetMethodName="GetDataByPermissionOwnerUserGroupId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByPermissionOwnerUserGroupId" UserSourceName="FillByPermissionOwnerUserGroupId">
|
---|
| 431 | <SelectCommand>
|
---|
| 432 | <DbCommand CommandType="Text" ModifiedByUser="true">
|
---|
[1729] | 433 | <CommandText>SELECT PermissionOwnerId, UserGroupId FROM PermissionOwner_UserGroup WHERE (PermissionOwnerId = @PermissionOwnerId) AND (UserGroupId = @UserGroupId)</CommandText>
|
---|
[1656] | 434 | <Parameters>
|
---|
| 435 | <Parameter AllowDbNull="false" AutogeneratedName="PermissionOwnerId" ColumnName="PermissionOwnerId" DataSourceName="[HeuristicLab.Security].dbo.PermissionOwner_UserGroup" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@PermissionOwnerId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="PermissionOwnerId" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
| 436 | <Parameter AllowDbNull="false" AutogeneratedName="UserGroupId" ColumnName="UserGroupId" DataSourceName="[HeuristicLab.Security].dbo.PermissionOwner_UserGroup" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@UserGroupId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="UserGroupId" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
| 437 | </Parameters>
|
---|
| 438 | </DbCommand>
|
---|
| 439 | </SelectCommand>
|
---|
| 440 | </DbSource>
|
---|
| 441 | <DbSource ConnectionRef="HeuristicLab_SecurityConnectionString (Settings)" DbObjectName="[HeuristicLab.Security].dbo.PermissionOwner_UserGroup" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByUserGroupId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByUserGroupId" GeneratorSourceName="FillByUserGroupId" GetMethodModifier="Public" GetMethodName="GetDataByUserGroupId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByUserGroupId" UserSourceName="FillByUserGroupId">
|
---|
| 442 | <SelectCommand>
|
---|
| 443 | <DbCommand CommandType="Text" ModifiedByUser="true">
|
---|
[1729] | 444 | <CommandText>SELECT PermissionOwnerId, UserGroupId FROM PermissionOwner_UserGroup WHERE (UserGroupId = @UserGroupId)</CommandText>
|
---|
[1656] | 445 | <Parameters>
|
---|
| 446 | <Parameter AllowDbNull="false" AutogeneratedName="UserGroupId" ColumnName="UserGroupId" DataSourceName="[HeuristicLab.Security].dbo.PermissionOwner_UserGroup" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@UserGroupId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="UserGroupId" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
| 447 | </Parameters>
|
---|
| 448 | </DbCommand>
|
---|
| 449 | </SelectCommand>
|
---|
| 450 | </DbSource>
|
---|
| 451 | </Sources>
|
---|
[1638] | 452 | </TableAdapter>
|
---|
| 453 | </Tables>
|
---|
| 454 | <Sources />
|
---|
| 455 | </DataSource>
|
---|
| 456 | </xs:appinfo>
|
---|
| 457 | </xs:annotation>
|
---|
[1656] | 458 | <xs:element name="dsSecurity" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="dsSecurity" msprop:Generator_DataSetName="dsSecurity" msprop:EnableTableAdapterManager="true">
|
---|
[1638] | 459 | <xs:complexType>
|
---|
| 460 | <xs:choice minOccurs="0" maxOccurs="unbounded">
|
---|
[1656] | 461 | <xs:element name="GrantedPermissions" msprop:Generator_UserTableName="GrantedPermissions" msprop:Generator_RowDeletedName="GrantedPermissionsRowDeleted" msprop:Generator_RowChangedName="GrantedPermissionsRowChanged" msprop:Generator_RowClassName="GrantedPermissionsRow" msprop:Generator_RowChangingName="GrantedPermissionsRowChanging" msprop:Generator_RowEvArgName="GrantedPermissionsRowChangeEvent" msprop:Generator_RowEvHandlerName="GrantedPermissionsRowChangeEventHandler" msprop:Generator_TableClassName="GrantedPermissionsDataTable" msprop:Generator_TableVarName="tableGrantedPermissions" msprop:Generator_RowDeletingName="GrantedPermissionsRowDeleting" msprop:Generator_TablePropName="GrantedPermissions">
|
---|
[1638] | 462 | <xs:complexType>
|
---|
| 463 | <xs:sequence>
|
---|
[1724] | 464 | <xs:element name="PermissionId" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="PermissionId" msprop:Generator_ColumnPropNameInRow="PermissionId" msprop:Generator_ColumnVarNameInTable="columnPermissionId" msprop:Generator_ColumnPropNameInTable="PermissionIdColumn" type="xs:string" />
|
---|
| 465 | <xs:element name="PermissionOwnerId" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="PermissionOwnerId" msprop:Generator_ColumnPropNameInRow="PermissionOwnerId" msprop:Generator_ColumnVarNameInTable="columnPermissionOwnerId" msprop:Generator_ColumnPropNameInTable="PermissionOwnerIdColumn" type="xs:string" />
|
---|
| 466 | <xs:element name="EntityId" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="EntityId" msprop:Generator_ColumnPropNameInRow="EntityId" msprop:Generator_ColumnVarNameInTable="columnEntityId" msprop:Generator_ColumnPropNameInTable="EntityIdColumn" type="xs:string" />
|
---|
[1638] | 467 | </xs:sequence>
|
---|
| 468 | </xs:complexType>
|
---|
| 469 | </xs:element>
|
---|
[1656] | 470 | <xs:element name="UserGroup" msprop:Generator_UserTableName="UserGroup" msprop:Generator_RowDeletedName="UserGroupRowDeleted" msprop:Generator_RowChangedName="UserGroupRowChanged" msprop:Generator_RowClassName="UserGroupRow" msprop:Generator_RowChangingName="UserGroupRowChanging" msprop:Generator_RowEvArgName="UserGroupRowChangeEvent" msprop:Generator_RowEvHandlerName="UserGroupRowChangeEventHandler" msprop:Generator_TableClassName="UserGroupDataTable" msprop:Generator_TableVarName="tableUserGroup" msprop:Generator_RowDeletingName="UserGroupRowDeleting" msprop:Generator_TablePropName="UserGroup">
|
---|
[1638] | 471 | <xs:complexType>
|
---|
| 472 | <xs:sequence>
|
---|
[1724] | 473 | <xs:element name="PermissionOwnerId" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="PermissionOwnerId" msprop:Generator_ColumnPropNameInRow="PermissionOwnerId" msprop:Generator_ColumnVarNameInTable="columnPermissionOwnerId" msprop:Generator_ColumnPropNameInTable="PermissionOwnerIdColumn" type="xs:string" />
|
---|
[1638] | 474 | </xs:sequence>
|
---|
| 475 | </xs:complexType>
|
---|
| 476 | </xs:element>
|
---|
[1656] | 477 | <xs:element name="HLUser" msprop:Generator_UserTableName="HLUser" msprop:Generator_RowDeletedName="HLUserRowDeleted" msprop:Generator_RowChangedName="HLUserRowChanged" msprop:Generator_RowClassName="HLUserRow" msprop:Generator_RowChangingName="HLUserRowChanging" msprop:Generator_RowEvArgName="HLUserRowChangeEvent" msprop:Generator_RowEvHandlerName="HLUserRowChangeEventHandler" msprop:Generator_TableClassName="HLUserDataTable" msprop:Generator_TableVarName="tableHLUser" msprop:Generator_RowDeletingName="HLUserRowDeleting" msprop:Generator_TablePropName="HLUser">
|
---|
[1638] | 478 | <xs:complexType>
|
---|
| 479 | <xs:sequence>
|
---|
[1724] | 480 | <xs:element name="PermissionOwnerId" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="PermissionOwnerId" msprop:Generator_ColumnPropNameInRow="PermissionOwnerId" msprop:Generator_ColumnVarNameInTable="columnPermissionOwnerId" msprop:Generator_ColumnPropNameInTable="PermissionOwnerIdColumn" type="xs:string" />
|
---|
| 481 | <xs:element name="Password" msprop:Generator_UserColumnName="Password" msprop:Generator_ColumnVarNameInTable="columnPassword" msprop:Generator_ColumnPropNameInRow="Password" msprop:Generator_ColumnPropNameInTable="PasswordColumn" minOccurs="0">
|
---|
[1638] | 482 | <xs:simpleType>
|
---|
| 483 | <xs:restriction base="xs:string">
|
---|
| 484 | <xs:maxLength value="2147483647" />
|
---|
| 485 | </xs:restriction>
|
---|
| 486 | </xs:simpleType>
|
---|
| 487 | </xs:element>
|
---|
[1724] | 488 | <xs:element name="Login" msprop:Generator_UserColumnName="Login" msprop:Generator_ColumnVarNameInTable="columnLogin" msprop:Generator_ColumnPropNameInRow="Login" msprop:Generator_ColumnPropNameInTable="LoginColumn" minOccurs="0">
|
---|
[1638] | 489 | <xs:simpleType>
|
---|
| 490 | <xs:restriction base="xs:string">
|
---|
| 491 | <xs:maxLength value="2147483647" />
|
---|
| 492 | </xs:restriction>
|
---|
| 493 | </xs:simpleType>
|
---|
| 494 | </xs:element>
|
---|
[1724] | 495 | <xs:element name="MailAddress" msprop:Generator_UserColumnName="MailAddress" msprop:Generator_ColumnVarNameInTable="columnMailAddress" msprop:Generator_ColumnPropNameInRow="MailAddress" msprop:Generator_ColumnPropNameInTable="MailAddressColumn" minOccurs="0">
|
---|
[1656] | 496 | <xs:simpleType>
|
---|
| 497 | <xs:restriction base="xs:string">
|
---|
| 498 | <xs:maxLength value="2147483647" />
|
---|
| 499 | </xs:restriction>
|
---|
| 500 | </xs:simpleType>
|
---|
| 501 | </xs:element>
|
---|
[1638] | 502 | </xs:sequence>
|
---|
| 503 | </xs:complexType>
|
---|
| 504 | </xs:element>
|
---|
[1656] | 505 | <xs:element name="Permission" msprop:Generator_UserTableName="Permission" msprop:Generator_RowDeletedName="PermissionRowDeleted" msprop:Generator_RowChangedName="PermissionRowChanged" msprop:Generator_RowClassName="PermissionRow" msprop:Generator_RowChangingName="PermissionRowChanging" msprop:Generator_RowEvArgName="PermissionRowChangeEvent" msprop:Generator_RowEvHandlerName="PermissionRowChangeEventHandler" msprop:Generator_TableClassName="PermissionDataTable" msprop:Generator_TableVarName="tablePermission" msprop:Generator_RowDeletingName="PermissionRowDeleting" msprop:Generator_TablePropName="Permission">
|
---|
[1638] | 506 | <xs:complexType>
|
---|
| 507 | <xs:sequence>
|
---|
[1724] | 508 | <xs:element name="PermissionId" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="PermissionId" msprop:Generator_ColumnPropNameInRow="PermissionId" msprop:Generator_ColumnVarNameInTable="columnPermissionId" msprop:Generator_ColumnPropNameInTable="PermissionIdColumn" type="xs:string" />
|
---|
| 509 | <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" minOccurs="0">
|
---|
[1638] | 510 | <xs:simpleType>
|
---|
| 511 | <xs:restriction base="xs:string">
|
---|
| 512 | <xs:maxLength value="2147483647" />
|
---|
| 513 | </xs:restriction>
|
---|
| 514 | </xs:simpleType>
|
---|
| 515 | </xs:element>
|
---|
[1724] | 516 | <xs:element name="Description" msprop:Generator_UserColumnName="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" minOccurs="0">
|
---|
[1656] | 517 | <xs:simpleType>
|
---|
| 518 | <xs:restriction base="xs:string">
|
---|
| 519 | <xs:maxLength value="2147483647" />
|
---|
| 520 | </xs:restriction>
|
---|
| 521 | </xs:simpleType>
|
---|
| 522 | </xs:element>
|
---|
[1724] | 523 | <xs:element name="Plugin" msprop:Generator_UserColumnName="Plugin" msprop:Generator_ColumnVarNameInTable="columnPlugin" msprop:Generator_ColumnPropNameInRow="Plugin" msprop:Generator_ColumnPropNameInTable="PluginColumn" minOccurs="0">
|
---|
[1656] | 524 | <xs:simpleType>
|
---|
| 525 | <xs:restriction base="xs:string">
|
---|
| 526 | <xs:maxLength value="2147483647" />
|
---|
| 527 | </xs:restriction>
|
---|
| 528 | </xs:simpleType>
|
---|
| 529 | </xs:element>
|
---|
[1638] | 530 | </xs:sequence>
|
---|
| 531 | </xs:complexType>
|
---|
| 532 | </xs:element>
|
---|
[1656] | 533 | <xs:element name="PermissionOwner" msprop:Generator_UserTableName="PermissionOwner" msprop:Generator_RowDeletedName="PermissionOwnerRowDeleted" msprop:Generator_RowChangedName="PermissionOwnerRowChanged" msprop:Generator_RowClassName="PermissionOwnerRow" msprop:Generator_RowChangingName="PermissionOwnerRowChanging" msprop:Generator_RowEvArgName="PermissionOwnerRowChangeEvent" msprop:Generator_RowEvHandlerName="PermissionOwnerRowChangeEventHandler" msprop:Generator_TableClassName="PermissionOwnerDataTable" msprop:Generator_TableVarName="tablePermissionOwner" msprop:Generator_RowDeletingName="PermissionOwnerRowDeleting" msprop:Generator_TablePropName="PermissionOwner">
|
---|
[1638] | 534 | <xs:complexType>
|
---|
| 535 | <xs:sequence>
|
---|
[1724] | 536 | <xs:element name="PermissionOwnerId" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="PermissionOwnerId" msprop:Generator_ColumnPropNameInRow="PermissionOwnerId" msprop:Generator_ColumnVarNameInTable="columnPermissionOwnerId" msprop:Generator_ColumnPropNameInTable="PermissionOwnerIdColumn" type="xs:string" />
|
---|
| 537 | <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" minOccurs="0">
|
---|
[1656] | 538 | <xs:simpleType>
|
---|
| 539 | <xs:restriction base="xs:string">
|
---|
| 540 | <xs:maxLength value="2147483647" />
|
---|
| 541 | </xs:restriction>
|
---|
| 542 | </xs:simpleType>
|
---|
| 543 | </xs:element>
|
---|
[1638] | 544 | </xs:sequence>
|
---|
| 545 | </xs:complexType>
|
---|
| 546 | </xs:element>
|
---|
[1656] | 547 | <xs:element name="PermissionOwner_UserGroup" msprop:Generator_UserTableName="PermissionOwner_UserGroup" msprop:Generator_RowDeletedName="PermissionOwner_UserGroupRowDeleted" msprop:Generator_RowChangedName="PermissionOwner_UserGroupRowChanged" msprop:Generator_RowClassName="PermissionOwner_UserGroupRow" msprop:Generator_RowChangingName="PermissionOwner_UserGroupRowChanging" msprop:Generator_RowEvArgName="PermissionOwner_UserGroupRowChangeEvent" msprop:Generator_RowEvHandlerName="PermissionOwner_UserGroupRowChangeEventHandler" msprop:Generator_TableClassName="PermissionOwner_UserGroupDataTable" msprop:Generator_TableVarName="tablePermissionOwner_UserGroup" msprop:Generator_RowDeletingName="PermissionOwner_UserGroupRowDeleting" msprop:Generator_TablePropName="PermissionOwner_UserGroup">
|
---|
[1638] | 548 | <xs:complexType>
|
---|
| 549 | <xs:sequence>
|
---|
[1724] | 550 | <xs:element name="PermissionOwnerId" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="PermissionOwnerId" msprop:Generator_ColumnPropNameInRow="PermissionOwnerId" msprop:Generator_ColumnVarNameInTable="columnPermissionOwnerId" msprop:Generator_ColumnPropNameInTable="PermissionOwnerIdColumn" type="xs:string" />
|
---|
| 551 | <xs:element name="UserGroupId" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="UserGroupId" msprop:Generator_ColumnPropNameInRow="UserGroupId" msprop:Generator_ColumnVarNameInTable="columnUserGroupId" msprop:Generator_ColumnPropNameInTable="UserGroupIdColumn" type="xs:string" />
|
---|
[1638] | 552 | </xs:sequence>
|
---|
| 553 | </xs:complexType>
|
---|
| 554 | </xs:element>
|
---|
| 555 | </xs:choice>
|
---|
| 556 | </xs:complexType>
|
---|
| 557 | <xs:unique name="Constraint1" msdata:PrimaryKey="true">
|
---|
| 558 | <xs:selector xpath=".//mstns:GrantedPermissions" />
|
---|
| 559 | <xs:field xpath="mstns:PermissionId" />
|
---|
| 560 | <xs:field xpath="mstns:PermissionOwnerId" />
|
---|
| 561 | <xs:field xpath="mstns:EntityId" />
|
---|
| 562 | </xs:unique>
|
---|
| 563 | <xs:unique name="UserGroup_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
---|
| 564 | <xs:selector xpath=".//mstns:UserGroup" />
|
---|
| 565 | <xs:field xpath="mstns:PermissionOwnerId" />
|
---|
| 566 | </xs:unique>
|
---|
| 567 | <xs:unique name="HLUser_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
---|
| 568 | <xs:selector xpath=".//mstns:HLUser" />
|
---|
| 569 | <xs:field xpath="mstns:PermissionOwnerId" />
|
---|
| 570 | </xs:unique>
|
---|
| 571 | <xs:unique name="Permission_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
---|
| 572 | <xs:selector xpath=".//mstns:Permission" />
|
---|
| 573 | <xs:field xpath="mstns:PermissionId" />
|
---|
| 574 | </xs:unique>
|
---|
| 575 | <xs:unique name="PermissionOwner_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
---|
| 576 | <xs:selector xpath=".//mstns:PermissionOwner" />
|
---|
| 577 | <xs:field xpath="mstns:PermissionOwnerId" />
|
---|
| 578 | </xs:unique>
|
---|
| 579 | <xs:unique name="PermissionOwner_UserGroup_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
---|
| 580 | <xs:selector xpath=".//mstns:PermissionOwner_UserGroup" />
|
---|
| 581 | <xs:field xpath="mstns:PermissionOwnerId" />
|
---|
| 582 | <xs:field xpath="mstns:UserGroupId" />
|
---|
| 583 | </xs:unique>
|
---|
| 584 | </xs:element>
|
---|
| 585 | <xs:annotation>
|
---|
| 586 | <xs:appinfo>
|
---|
| 587 | <msdata:Relationship name="R_49" msdata:parent="Permission" msdata:child="GrantedPermissions" msdata:parentkey="PermissionId" msdata:childkey="PermissionId" msprop:Generator_UserRelationName="R_49" msprop:Generator_RelationVarName="relationR_49" msprop:Generator_UserChildTable="GrantedPermissions" msprop:Generator_UserParentTable="Permission" msprop:Generator_ParentPropName="PermissionRow" msprop:Generator_ChildPropName="GetGrantedPermissionsRows" />
|
---|
| 588 | <msdata:Relationship name="R_50" msdata:parent="PermissionOwner" msdata:child="GrantedPermissions" msdata:parentkey="PermissionOwnerId" msdata:childkey="PermissionOwnerId" msprop:Generator_UserRelationName="R_50" msprop:Generator_RelationVarName="relationR_50" msprop:Generator_UserChildTable="GrantedPermissions" msprop:Generator_UserParentTable="PermissionOwner" msprop:Generator_ParentPropName="PermissionOwnerRow" msprop:Generator_ChildPropName="GetGrantedPermissionsRows" />
|
---|
| 589 | <msdata:Relationship name="UserGroup_is_a_PermissionOwner" msdata:parent="PermissionOwner" msdata:child="UserGroup" msdata:parentkey="PermissionOwnerId" msdata:childkey="PermissionOwnerId" msprop:Generator_UserRelationName="UserGroup_is_a_PermissionOwner" msprop:Generator_RelationVarName="relationUserGroup_is_a_PermissionOwner" msprop:Generator_UserChildTable="UserGroup" msprop:Generator_UserParentTable="PermissionOwner" msprop:Generator_ParentPropName="PermissionOwnerRow" msprop:Generator_ChildPropName="GetUserGroupRows" />
|
---|
| 590 | <msdata:Relationship name="User_is_a_PermissionOwner" msdata:parent="PermissionOwner" msdata:child="HLUser" msdata:parentkey="PermissionOwnerId" msdata:childkey="PermissionOwnerId" msprop:Generator_UserRelationName="User_is_a_PermissionOwner" msprop:Generator_RelationVarName="relationUser_is_a_PermissionOwner" msprop:Generator_UserChildTable="HLUser" msprop:Generator_UserParentTable="PermissionOwner" msprop:Generator_ParentPropName="PermissionOwnerRow" msprop:Generator_ChildPropName="GetHLUserRows" />
|
---|
| 591 | <msdata:Relationship name="R_44" msdata:parent="PermissionOwner" msdata:child="PermissionOwner_UserGroup" msdata:parentkey="PermissionOwnerId" msdata:childkey="PermissionOwnerId" msprop:Generator_UserRelationName="R_44" msprop:Generator_RelationVarName="relationR_44" msprop:Generator_UserChildTable="PermissionOwner_UserGroup" msprop:Generator_UserParentTable="PermissionOwner" msprop:Generator_ParentPropName="PermissionOwnerRow" msprop:Generator_ChildPropName="GetPermissionOwner_UserGroupRows" />
|
---|
| 592 | <msdata:Relationship name="R_57" msdata:parent="UserGroup" msdata:child="PermissionOwner_UserGroup" msdata:parentkey="PermissionOwnerId" msdata:childkey="UserGroupId" msprop:Generator_UserRelationName="R_57" msprop:Generator_RelationVarName="relationR_57" msprop:Generator_UserChildTable="PermissionOwner_UserGroup" msprop:Generator_UserParentTable="UserGroup" msprop:Generator_ParentPropName="UserGroupRow" msprop:Generator_ChildPropName="GetPermissionOwner_UserGroupRows" />
|
---|
| 593 | </xs:appinfo>
|
---|
| 594 | </xs:annotation>
|
---|
| 595 | </xs:schema> |
---|