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>
|
---|
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" />
|
---|
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>
|
---|
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>
|
---|
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>
|
---|
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>
|
---|
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>
|
---|
168 | </Sources>
|
---|
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">
|
---|
175 | <CommandText>DELETE FROM [HLUser] WHERE (([PermissionOwnerId] = @Original_PermissionOwnerId))</CommandText>
|
---|
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">
|
---|
183 | <CommandText>INSERT INTO [HLUser] ([PermissionOwnerId], [Password], [Login], [MailAddress]) VALUES (@PermissionOwnerId, @Password, @Login, @MailAddress);
|
---|
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" />
|
---|
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" />
|
---|
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">
|
---|
195 | <CommandText>SELECT * FROM HLUser</CommandText>
|
---|
196 | <Parameters />
|
---|
197 | </DbCommand>
|
---|
198 | </SelectCommand>
|
---|
199 | <UpdateCommand>
|
---|
200 | <DbCommand CommandType="Text" ModifiedByUser="false">
|
---|
201 | <CommandText>UPDATE [HLUser] SET [PermissionOwnerId] = @PermissionOwnerId, [Password] = @Password, [Login] = @Login, [MailAddress] = @MailAddress WHERE (([PermissionOwnerId] = @Original_PermissionOwnerId));
|
---|
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" />
|
---|
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" />
|
---|
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>
|
---|
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>
|
---|
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>
|
---|
241 | </Sources>
|
---|
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">
|
---|
248 | <CommandText>DELETE FROM [Permission] WHERE (([PermissionId] = @Original_PermissionId))</CommandText>
|
---|
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">
|
---|
256 | <CommandText>INSERT INTO [Permission] ([PermissionId], [Name], [Description], [Plugin]) VALUES (@PermissionId, @Name, @Description, @Plugin);
|
---|
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" />
|
---|
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" />
|
---|
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">
|
---|
268 | <CommandText>SELECT * FROM Permission</CommandText>
|
---|
269 | <Parameters />
|
---|
270 | </DbCommand>
|
---|
271 | </SelectCommand>
|
---|
272 | <UpdateCommand>
|
---|
273 | <DbCommand CommandType="Text" ModifiedByUser="false">
|
---|
274 | <CommandText>UPDATE [Permission] SET [PermissionId] = @PermissionId, [Name] = @Name, [Description] = @Description, [Plugin] = @Plugin WHERE (([PermissionId] = @Original_PermissionId));
|
---|
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" />
|
---|
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" />
|
---|
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>
|
---|
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>
|
---|
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">
|
---|
311 | <CommandText>DELETE FROM [PermissionOwner] WHERE (([PermissionOwnerId] = @Original_PermissionOwnerId))</CommandText>
|
---|
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">
|
---|
319 | <CommandText>INSERT INTO [PermissionOwner] ([PermissionOwnerId], [Name]) VALUES (@PermissionOwnerId, @Name);
|
---|
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" />
|
---|
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" />
|
---|
324 | </Parameters>
|
---|
325 | </DbCommand>
|
---|
326 | </InsertCommand>
|
---|
327 | <SelectCommand>
|
---|
328 | <DbCommand CommandType="Text" ModifiedByUser="true">
|
---|
329 | <CommandText>SELECT * FROM PermissionOwner</CommandText>
|
---|
330 | <Parameters />
|
---|
331 | </DbCommand>
|
---|
332 | </SelectCommand>
|
---|
333 | <UpdateCommand>
|
---|
334 | <DbCommand CommandType="Text" ModifiedByUser="false">
|
---|
335 | <CommandText>UPDATE [PermissionOwner] SET [PermissionOwnerId] = @PermissionOwnerId, [Name] = @Name WHERE (([PermissionOwnerId] = @Original_PermissionOwnerId));
|
---|
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" />
|
---|
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" />
|
---|
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>
|
---|
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">
|
---|
354 | <CommandText>SELECT Name, PermissionOwnerId FROM PermissionOwner WHERE (PermissionOwnerId = @Id)</CommandText>
|
---|
355 | <Parameters>
|
---|
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" />
|
---|
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>
|
---|
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">
|
---|
378 | <CommandText>DELETE FROM [dbo].[PermissionOwner_UserGroup] WHERE (([UserGroupId] = @Original_UserGroupId) AND ([PermissionOwnerId] = @Original_PermissionOwnerId))</CommandText>
|
---|
379 | <Parameters>
|
---|
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" />
|
---|
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">
|
---|
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>
|
---|
389 | <Parameters>
|
---|
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" />
|
---|
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">
|
---|
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>
|
---|
405 | <Parameters>
|
---|
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" />
|
---|
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" />
|
---|
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" />
|
---|
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>
|
---|
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">
|
---|
423 | <CommandText>SELECT PermissionOwnerId, UserGroupId FROM PermissionOwner_UserGroup WHERE (PermissionOwnerId = @PermissionOwnerId)</CommandText>
|
---|
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">
|
---|
433 | <CommandText>SELECT PermissionOwnerId, UserGroupId FROM PermissionOwner_UserGroup WHERE (PermissionOwnerId = @PermissionOwnerId) AND (UserGroupId = @UserGroupId)</CommandText>
|
---|
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">
|
---|
444 | <CommandText>SELECT PermissionOwnerId, UserGroupId FROM PermissionOwner_UserGroup WHERE (UserGroupId = @UserGroupId)</CommandText>
|
---|
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>
|
---|
452 | </TableAdapter>
|
---|
453 | </Tables>
|
---|
454 | <Sources />
|
---|
455 | </DataSource>
|
---|
456 | </xs:appinfo>
|
---|
457 | </xs:annotation>
|
---|
458 | <xs:element name="dsSecurity" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="dsSecurity" msprop:Generator_DataSetName="dsSecurity" msprop:EnableTableAdapterManager="true">
|
---|
459 | <xs:complexType>
|
---|
460 | <xs:choice minOccurs="0" maxOccurs="unbounded">
|
---|
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">
|
---|
462 | <xs:complexType>
|
---|
463 | <xs:sequence>
|
---|
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" />
|
---|
467 | </xs:sequence>
|
---|
468 | </xs:complexType>
|
---|
469 | </xs:element>
|
---|
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">
|
---|
471 | <xs:complexType>
|
---|
472 | <xs:sequence>
|
---|
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" />
|
---|
474 | </xs:sequence>
|
---|
475 | </xs:complexType>
|
---|
476 | </xs:element>
|
---|
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">
|
---|
478 | <xs:complexType>
|
---|
479 | <xs:sequence>
|
---|
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">
|
---|
482 | <xs:simpleType>
|
---|
483 | <xs:restriction base="xs:string">
|
---|
484 | <xs:maxLength value="2147483647" />
|
---|
485 | </xs:restriction>
|
---|
486 | </xs:simpleType>
|
---|
487 | </xs:element>
|
---|
488 | <xs:element name="Login" msprop:Generator_UserColumnName="Login" msprop:Generator_ColumnVarNameInTable="columnLogin" msprop:Generator_ColumnPropNameInRow="Login" msprop:Generator_ColumnPropNameInTable="LoginColumn" minOccurs="0">
|
---|
489 | <xs:simpleType>
|
---|
490 | <xs:restriction base="xs:string">
|
---|
491 | <xs:maxLength value="2147483647" />
|
---|
492 | </xs:restriction>
|
---|
493 | </xs:simpleType>
|
---|
494 | </xs:element>
|
---|
495 | <xs:element name="MailAddress" msprop:Generator_UserColumnName="MailAddress" msprop:Generator_ColumnVarNameInTable="columnMailAddress" msprop:Generator_ColumnPropNameInRow="MailAddress" msprop:Generator_ColumnPropNameInTable="MailAddressColumn" minOccurs="0">
|
---|
496 | <xs:simpleType>
|
---|
497 | <xs:restriction base="xs:string">
|
---|
498 | <xs:maxLength value="2147483647" />
|
---|
499 | </xs:restriction>
|
---|
500 | </xs:simpleType>
|
---|
501 | </xs:element>
|
---|
502 | </xs:sequence>
|
---|
503 | </xs:complexType>
|
---|
504 | </xs:element>
|
---|
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">
|
---|
506 | <xs:complexType>
|
---|
507 | <xs:sequence>
|
---|
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">
|
---|
510 | <xs:simpleType>
|
---|
511 | <xs:restriction base="xs:string">
|
---|
512 | <xs:maxLength value="2147483647" />
|
---|
513 | </xs:restriction>
|
---|
514 | </xs:simpleType>
|
---|
515 | </xs:element>
|
---|
516 | <xs:element name="Description" msprop:Generator_UserColumnName="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" minOccurs="0">
|
---|
517 | <xs:simpleType>
|
---|
518 | <xs:restriction base="xs:string">
|
---|
519 | <xs:maxLength value="2147483647" />
|
---|
520 | </xs:restriction>
|
---|
521 | </xs:simpleType>
|
---|
522 | </xs:element>
|
---|
523 | <xs:element name="Plugin" msprop:Generator_UserColumnName="Plugin" msprop:Generator_ColumnVarNameInTable="columnPlugin" msprop:Generator_ColumnPropNameInRow="Plugin" msprop:Generator_ColumnPropNameInTable="PluginColumn" minOccurs="0">
|
---|
524 | <xs:simpleType>
|
---|
525 | <xs:restriction base="xs:string">
|
---|
526 | <xs:maxLength value="2147483647" />
|
---|
527 | </xs:restriction>
|
---|
528 | </xs:simpleType>
|
---|
529 | </xs:element>
|
---|
530 | </xs:sequence>
|
---|
531 | </xs:complexType>
|
---|
532 | </xs:element>
|
---|
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">
|
---|
534 | <xs:complexType>
|
---|
535 | <xs:sequence>
|
---|
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">
|
---|
538 | <xs:simpleType>
|
---|
539 | <xs:restriction base="xs:string">
|
---|
540 | <xs:maxLength value="2147483647" />
|
---|
541 | </xs:restriction>
|
---|
542 | </xs:simpleType>
|
---|
543 | </xs:element>
|
---|
544 | </xs:sequence>
|
---|
545 | </xs:complexType>
|
---|
546 | </xs:element>
|
---|
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">
|
---|
548 | <xs:complexType>
|
---|
549 | <xs:sequence>
|
---|
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" />
|
---|
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> |
---|