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_3._2.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 | </TableAdapter>
|
---|
63 | <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UserGroupTableAdapter" GeneratorDataComponentClassName="UserGroupTableAdapter" Name="UserGroup" UserDataComponentName="UserGroupTableAdapter">
|
---|
64 | <MainSource>
|
---|
65 | <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">
|
---|
66 | <DeleteCommand>
|
---|
67 | <DbCommand CommandType="Text" ModifiedByUser="false">
|
---|
68 | <CommandText>DELETE FROM [dbo].[UserGroup] WHERE (([PermissionOwnerId] = @Original_PermissionOwnerId))</CommandText>
|
---|
69 | <Parameters>
|
---|
70 | <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" />
|
---|
71 | </Parameters>
|
---|
72 | </DbCommand>
|
---|
73 | </DeleteCommand>
|
---|
74 | <InsertCommand>
|
---|
75 | <DbCommand CommandType="Text" ModifiedByUser="false">
|
---|
76 | <CommandText>INSERT INTO [dbo].[UserGroup] ([PermissionOwnerId]) VALUES (@PermissionOwnerId);
|
---|
77 | SELECT PermissionOwnerId FROM UserGroup WHERE (PermissionOwnerId = @PermissionOwnerId)</CommandText>
|
---|
78 | <Parameters>
|
---|
79 | <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" />
|
---|
80 | </Parameters>
|
---|
81 | </DbCommand>
|
---|
82 | </InsertCommand>
|
---|
83 | <SelectCommand>
|
---|
84 | <DbCommand CommandType="Text" ModifiedByUser="true">
|
---|
85 | <CommandText>SELECT * FROM dbo.UserGroup</CommandText>
|
---|
86 | <Parameters />
|
---|
87 | </DbCommand>
|
---|
88 | </SelectCommand>
|
---|
89 | <UpdateCommand>
|
---|
90 | <DbCommand CommandType="Text" ModifiedByUser="false">
|
---|
91 | <CommandText>UPDATE [dbo].[UserGroup] SET [PermissionOwnerId] = @PermissionOwnerId WHERE (([PermissionOwnerId] = @Original_PermissionOwnerId));
|
---|
92 | SELECT PermissionOwnerId FROM UserGroup WHERE (PermissionOwnerId = @PermissionOwnerId)</CommandText>
|
---|
93 | <Parameters>
|
---|
94 | <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" />
|
---|
95 | <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" />
|
---|
96 | </Parameters>
|
---|
97 | </DbCommand>
|
---|
98 | </UpdateCommand>
|
---|
99 | </DbSource>
|
---|
100 | </MainSource>
|
---|
101 | <Mappings>
|
---|
102 | <Mapping SourceColumn="PermissionOwnerId" DataSetColumn="PermissionOwnerId" />
|
---|
103 | </Mappings>
|
---|
104 | <Sources />
|
---|
105 | </TableAdapter>
|
---|
106 | <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="HLUserTableAdapter" GeneratorDataComponentClassName="HLUserTableAdapter" Name="HLUser" UserDataComponentName="HLUserTableAdapter">
|
---|
107 | <MainSource>
|
---|
108 | <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">
|
---|
109 | <DeleteCommand>
|
---|
110 | <DbCommand CommandType="Text" ModifiedByUser="false">
|
---|
111 | <CommandText>DELETE FROM [dbo].[HLUser] 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].[HLUser] ([PermissionOwnerId], [Password], [Login], [MailAddress]) VALUES (@PermissionOwnerId, @Password, @Login, @MailAddress);
|
---|
120 | SELECT PermissionOwnerId, Password, Login, MailAddress FROM HLUser 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 | <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Password" Precision="0" ProviderType="VarBinary" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
124 | <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" />
|
---|
125 | <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" />
|
---|
126 | </Parameters>
|
---|
127 | </DbCommand>
|
---|
128 | </InsertCommand>
|
---|
129 | <SelectCommand>
|
---|
130 | <DbCommand CommandType="Text" ModifiedByUser="true">
|
---|
131 | <CommandText>SELECT * FROM dbo.HLUser</CommandText>
|
---|
132 | <Parameters />
|
---|
133 | </DbCommand>
|
---|
134 | </SelectCommand>
|
---|
135 | <UpdateCommand>
|
---|
136 | <DbCommand CommandType="Text" ModifiedByUser="false">
|
---|
137 | <CommandText>UPDATE [dbo].[HLUser] SET [PermissionOwnerId] = @PermissionOwnerId, [Password] = @Password, [Login] = @Login, [MailAddress] = @MailAddress WHERE (([PermissionOwnerId] = @Original_PermissionOwnerId));
|
---|
138 | SELECT PermissionOwnerId, Password, Login, MailAddress FROM HLUser WHERE (PermissionOwnerId = @PermissionOwnerId)</CommandText>
|
---|
139 | <Parameters>
|
---|
140 | <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" />
|
---|
141 | <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Password" Precision="0" ProviderType="VarBinary" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
142 | <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" />
|
---|
143 | <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" />
|
---|
144 | <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" />
|
---|
145 | </Parameters>
|
---|
146 | </DbCommand>
|
---|
147 | </UpdateCommand>
|
---|
148 | </DbSource>
|
---|
149 | </MainSource>
|
---|
150 | <Mappings>
|
---|
151 | <Mapping SourceColumn="PermissionOwnerId" DataSetColumn="PermissionOwnerId" />
|
---|
152 | <Mapping SourceColumn="Password" DataSetColumn="Password" />
|
---|
153 | <Mapping SourceColumn="Login" DataSetColumn="Login" />
|
---|
154 | <Mapping SourceColumn="MailAddress" DataSetColumn="MailAddress" />
|
---|
155 | </Mappings>
|
---|
156 | <Sources />
|
---|
157 | </TableAdapter>
|
---|
158 | <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PermissionTableAdapter" GeneratorDataComponentClassName="PermissionTableAdapter" Name="Permission" UserDataComponentName="PermissionTableAdapter">
|
---|
159 | <MainSource>
|
---|
160 | <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">
|
---|
161 | <DeleteCommand>
|
---|
162 | <DbCommand CommandType="Text" ModifiedByUser="false">
|
---|
163 | <CommandText>DELETE FROM [dbo].[Permission] WHERE (([PermissionId] = @Original_PermissionId))</CommandText>
|
---|
164 | <Parameters>
|
---|
165 | <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" />
|
---|
166 | </Parameters>
|
---|
167 | </DbCommand>
|
---|
168 | </DeleteCommand>
|
---|
169 | <InsertCommand>
|
---|
170 | <DbCommand CommandType="Text" ModifiedByUser="false">
|
---|
171 | <CommandText>INSERT INTO [dbo].[Permission] ([PermissionId], [Name], [Description], [Plugin]) VALUES (@PermissionId, @Name, @Description, @Plugin);
|
---|
172 | SELECT PermissionId, Name, Description, Plugin FROM Permission WHERE (PermissionId = @PermissionId)</CommandText>
|
---|
173 | <Parameters>
|
---|
174 | <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" />
|
---|
175 | <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarBinary" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
176 | <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="VarBinary" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
177 | <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" />
|
---|
178 | </Parameters>
|
---|
179 | </DbCommand>
|
---|
180 | </InsertCommand>
|
---|
181 | <SelectCommand>
|
---|
182 | <DbCommand CommandType="Text" ModifiedByUser="true">
|
---|
183 | <CommandText>SELECT * FROM dbo.Permission</CommandText>
|
---|
184 | <Parameters />
|
---|
185 | </DbCommand>
|
---|
186 | </SelectCommand>
|
---|
187 | <UpdateCommand>
|
---|
188 | <DbCommand CommandType="Text" ModifiedByUser="false">
|
---|
189 | <CommandText>UPDATE [dbo].[Permission] SET [PermissionId] = @PermissionId, [Name] = @Name, [Description] = @Description, [Plugin] = @Plugin WHERE (([PermissionId] = @Original_PermissionId));
|
---|
190 | SELECT PermissionId, Name, Description, Plugin FROM Permission WHERE (PermissionId = @PermissionId)</CommandText>
|
---|
191 | <Parameters>
|
---|
192 | <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" />
|
---|
193 | <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarBinary" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
194 | <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="VarBinary" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
195 | <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" />
|
---|
196 | <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" />
|
---|
197 | </Parameters>
|
---|
198 | </DbCommand>
|
---|
199 | </UpdateCommand>
|
---|
200 | </DbSource>
|
---|
201 | </MainSource>
|
---|
202 | <Mappings>
|
---|
203 | <Mapping SourceColumn="PermissionId" DataSetColumn="PermissionId" />
|
---|
204 | <Mapping SourceColumn="Name" DataSetColumn="Name" />
|
---|
205 | <Mapping SourceColumn="Description" DataSetColumn="Description" />
|
---|
206 | <Mapping SourceColumn="Plugin" DataSetColumn="Plugin" />
|
---|
207 | </Mappings>
|
---|
208 | <Sources />
|
---|
209 | </TableAdapter>
|
---|
210 | <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PermissionOwnerTableAdapter" GeneratorDataComponentClassName="PermissionOwnerTableAdapter" Name="PermissionOwner" UserDataComponentName="PermissionOwnerTableAdapter">
|
---|
211 | <MainSource>
|
---|
212 | <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">
|
---|
213 | <DeleteCommand>
|
---|
214 | <DbCommand CommandType="Text" ModifiedByUser="false">
|
---|
215 | <CommandText>DELETE FROM [dbo].[PermissionOwner] WHERE (([PermissionOwnerId] = @Original_PermissionOwnerId))</CommandText>
|
---|
216 | <Parameters>
|
---|
217 | <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" />
|
---|
218 | </Parameters>
|
---|
219 | </DbCommand>
|
---|
220 | </DeleteCommand>
|
---|
221 | <InsertCommand>
|
---|
222 | <DbCommand CommandType="Text" ModifiedByUser="false">
|
---|
223 | <CommandText>INSERT INTO [dbo].[PermissionOwner] ([PermissionOwnerId], [Name]) VALUES (@PermissionOwnerId, @Name);
|
---|
224 | SELECT PermissionOwnerId, Name FROM PermissionOwner WHERE (PermissionOwnerId = @PermissionOwnerId)</CommandText>
|
---|
225 | <Parameters>
|
---|
226 | <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" />
|
---|
227 | <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarBinary" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
228 | </Parameters>
|
---|
229 | </DbCommand>
|
---|
230 | </InsertCommand>
|
---|
231 | <SelectCommand>
|
---|
232 | <DbCommand CommandType="Text" ModifiedByUser="true">
|
---|
233 | <CommandText>SELECT * FROM dbo.PermissionOwner</CommandText>
|
---|
234 | <Parameters />
|
---|
235 | </DbCommand>
|
---|
236 | </SelectCommand>
|
---|
237 | <UpdateCommand>
|
---|
238 | <DbCommand CommandType="Text" ModifiedByUser="false">
|
---|
239 | <CommandText>UPDATE [dbo].[PermissionOwner] SET [PermissionOwnerId] = @PermissionOwnerId, [Name] = @Name WHERE (([PermissionOwnerId] = @Original_PermissionOwnerId));
|
---|
240 | SELECT PermissionOwnerId, Name FROM PermissionOwner WHERE (PermissionOwnerId = @PermissionOwnerId)</CommandText>
|
---|
241 | <Parameters>
|
---|
242 | <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" />
|
---|
243 | <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarBinary" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
|
---|
244 | <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" />
|
---|
245 | </Parameters>
|
---|
246 | </DbCommand>
|
---|
247 | </UpdateCommand>
|
---|
248 | </DbSource>
|
---|
249 | </MainSource>
|
---|
250 | <Mappings>
|
---|
251 | <Mapping SourceColumn="PermissionOwnerId" DataSetColumn="PermissionOwnerId" />
|
---|
252 | <Mapping SourceColumn="Name" DataSetColumn="Name" />
|
---|
253 | </Mappings>
|
---|
254 | <Sources />
|
---|
255 | </TableAdapter>
|
---|
256 | <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PermissionOwner_UserGroupTableAdapter" GeneratorDataComponentClassName="PermissionOwner_UserGroupTableAdapter" Name="PermissionOwner_UserGroup" UserDataComponentName="PermissionOwner_UserGroupTableAdapter">
|
---|
257 | <MainSource>
|
---|
258 | <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">
|
---|
259 | <DeleteCommand>
|
---|
260 | <DbCommand CommandType="Text" ModifiedByUser="false">
|
---|
261 | <CommandText>DELETE FROM [dbo].[PermissionOwner_UserGroup] WHERE (([PermissionOwnerId] = @Original_PermissionOwnerId) AND ([UserGroupId] = @Original_UserGroupId))</CommandText>
|
---|
262 | <Parameters>
|
---|
263 | <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" />
|
---|
264 | <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" />
|
---|
265 | </Parameters>
|
---|
266 | </DbCommand>
|
---|
267 | </DeleteCommand>
|
---|
268 | <InsertCommand>
|
---|
269 | <DbCommand CommandType="Text" ModifiedByUser="false">
|
---|
270 | <CommandText>INSERT INTO [dbo].[PermissionOwner_UserGroup] ([PermissionOwnerId], [UserGroupId]) VALUES (@PermissionOwnerId, @UserGroupId);
|
---|
271 | SELECT PermissionOwnerId, UserGroupId FROM PermissionOwner_UserGroup WHERE (PermissionOwnerId = @PermissionOwnerId) AND (UserGroupId = @UserGroupId)</CommandText>
|
---|
272 | <Parameters>
|
---|
273 | <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" />
|
---|
274 | <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" />
|
---|
275 | </Parameters>
|
---|
276 | </DbCommand>
|
---|
277 | </InsertCommand>
|
---|
278 | <SelectCommand>
|
---|
279 | <DbCommand CommandType="Text" ModifiedByUser="true">
|
---|
280 | <CommandText>SELECT * FROM dbo.PermissionOwner_UserGroup</CommandText>
|
---|
281 | <Parameters />
|
---|
282 | </DbCommand>
|
---|
283 | </SelectCommand>
|
---|
284 | <UpdateCommand>
|
---|
285 | <DbCommand CommandType="Text" ModifiedByUser="false">
|
---|
286 | <CommandText>UPDATE [dbo].[PermissionOwner_UserGroup] SET [PermissionOwnerId] = @PermissionOwnerId, [UserGroupId] = @UserGroupId WHERE (([PermissionOwnerId] = @Original_PermissionOwnerId) AND ([UserGroupId] = @Original_UserGroupId));
|
---|
287 | SELECT PermissionOwnerId, UserGroupId FROM PermissionOwner_UserGroup WHERE (PermissionOwnerId = @PermissionOwnerId) AND (UserGroupId = @UserGroupId)</CommandText>
|
---|
288 | <Parameters>
|
---|
289 | <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" />
|
---|
290 | <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" />
|
---|
291 | <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" />
|
---|
292 | <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" />
|
---|
293 | </Parameters>
|
---|
294 | </DbCommand>
|
---|
295 | </UpdateCommand>
|
---|
296 | </DbSource>
|
---|
297 | </MainSource>
|
---|
298 | <Mappings>
|
---|
299 | <Mapping SourceColumn="PermissionOwnerId" DataSetColumn="PermissionOwnerId" />
|
---|
300 | <Mapping SourceColumn="UserGroupId" DataSetColumn="UserGroupId" />
|
---|
301 | </Mappings>
|
---|
302 | <Sources />
|
---|
303 | </TableAdapter>
|
---|
304 | </Tables>
|
---|
305 | <Sources />
|
---|
306 | </DataSource>
|
---|
307 | </xs:appinfo>
|
---|
308 | </xs:annotation>
|
---|
309 | <xs:element name="dsSecurity" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_DataSetName="dsSecurity" msprop:Generator_UserDSName="dsSecurity" msprop:EnableTableAdapterManager="true">
|
---|
310 | <xs:complexType>
|
---|
311 | <xs:choice minOccurs="0" maxOccurs="unbounded">
|
---|
312 | <xs:element name="GrantedPermissions" msprop:Generator_UserTableName="GrantedPermissions" msprop:Generator_RowDeletedName="GrantedPermissionsRowDeleted" msprop:Generator_TableClassName="GrantedPermissionsDataTable" msprop:Generator_RowChangedName="GrantedPermissionsRowChanged" msprop:Generator_RowClassName="GrantedPermissionsRow" msprop:Generator_RowChangingName="GrantedPermissionsRowChanging" msprop:Generator_RowEvArgName="GrantedPermissionsRowChangeEvent" msprop:Generator_RowEvHandlerName="GrantedPermissionsRowChangeEventHandler" msprop:Generator_TablePropName="GrantedPermissions" msprop:Generator_TableVarName="tableGrantedPermissions" msprop:Generator_RowDeletingName="GrantedPermissionsRowDeleting">
|
---|
313 | <xs:complexType>
|
---|
314 | <xs:sequence>
|
---|
315 | <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" />
|
---|
316 | <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" />
|
---|
317 | <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" />
|
---|
318 | </xs:sequence>
|
---|
319 | </xs:complexType>
|
---|
320 | </xs:element>
|
---|
321 | <xs:element name="UserGroup" msprop:Generator_UserTableName="UserGroup" msprop:Generator_RowDeletedName="UserGroupRowDeleted" msprop:Generator_TableClassName="UserGroupDataTable" msprop:Generator_RowChangedName="UserGroupRowChanged" msprop:Generator_RowClassName="UserGroupRow" msprop:Generator_RowChangingName="UserGroupRowChanging" msprop:Generator_RowEvArgName="UserGroupRowChangeEvent" msprop:Generator_RowEvHandlerName="UserGroupRowChangeEventHandler" msprop:Generator_TablePropName="UserGroup" msprop:Generator_TableVarName="tableUserGroup" msprop:Generator_RowDeletingName="UserGroupRowDeleting">
|
---|
322 | <xs:complexType>
|
---|
323 | <xs:sequence>
|
---|
324 | <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" />
|
---|
325 | </xs:sequence>
|
---|
326 | </xs:complexType>
|
---|
327 | </xs:element>
|
---|
328 | <xs:element name="HLUser" msprop:Generator_UserTableName="HLUser" msprop:Generator_RowDeletedName="HLUserRowDeleted" msprop:Generator_TableClassName="HLUserDataTable" msprop:Generator_RowChangedName="HLUserRowChanged" msprop:Generator_RowClassName="HLUserRow" msprop:Generator_RowChangingName="HLUserRowChanging" msprop:Generator_RowEvArgName="HLUserRowChangeEvent" msprop:Generator_RowEvHandlerName="HLUserRowChangeEventHandler" msprop:Generator_TablePropName="HLUser" msprop:Generator_TableVarName="tableHLUser" msprop:Generator_RowDeletingName="HLUserRowDeleting">
|
---|
329 | <xs:complexType>
|
---|
330 | <xs:sequence>
|
---|
331 | <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" />
|
---|
332 | <xs:element name="Password" msprop:Generator_UserColumnName="Password" msprop:Generator_ColumnPropNameInRow="Password" msprop:Generator_ColumnVarNameInTable="columnPassword" msprop:Generator_ColumnPropNameInTable="PasswordColumn" type="xs:base64Binary" minOccurs="0" />
|
---|
333 | <xs:element name="Login" msprop:Generator_UserColumnName="Login" msprop:Generator_ColumnPropNameInRow="Login" msprop:Generator_ColumnVarNameInTable="columnLogin" msprop:Generator_ColumnPropNameInTable="LoginColumn" minOccurs="0">
|
---|
334 | <xs:simpleType>
|
---|
335 | <xs:restriction base="xs:string">
|
---|
336 | <xs:maxLength value="2147483647" />
|
---|
337 | </xs:restriction>
|
---|
338 | </xs:simpleType>
|
---|
339 | </xs:element>
|
---|
340 | <xs:element name="MailAddress" msprop:Generator_UserColumnName="MailAddress" msprop:Generator_ColumnPropNameInRow="MailAddress" msprop:Generator_ColumnVarNameInTable="columnMailAddress" msprop:Generator_ColumnPropNameInTable="MailAddressColumn" minOccurs="0">
|
---|
341 | <xs:simpleType>
|
---|
342 | <xs:restriction base="xs:string">
|
---|
343 | <xs:maxLength value="2147483647" />
|
---|
344 | </xs:restriction>
|
---|
345 | </xs:simpleType>
|
---|
346 | </xs:element>
|
---|
347 | </xs:sequence>
|
---|
348 | </xs:complexType>
|
---|
349 | </xs:element>
|
---|
350 | <xs:element name="Permission" msprop:Generator_UserTableName="Permission" msprop:Generator_RowDeletedName="PermissionRowDeleted" msprop:Generator_TableClassName="PermissionDataTable" msprop:Generator_RowChangedName="PermissionRowChanged" msprop:Generator_RowClassName="PermissionRow" msprop:Generator_RowChangingName="PermissionRowChanging" msprop:Generator_RowEvArgName="PermissionRowChangeEvent" msprop:Generator_RowEvHandlerName="PermissionRowChangeEventHandler" msprop:Generator_TablePropName="Permission" msprop:Generator_TableVarName="tablePermission" msprop:Generator_RowDeletingName="PermissionRowDeleting">
|
---|
351 | <xs:complexType>
|
---|
352 | <xs:sequence>
|
---|
353 | <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" />
|
---|
354 | <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn" type="xs:base64Binary" minOccurs="0" />
|
---|
355 | <xs:element name="Description" msprop:Generator_UserColumnName="Description" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" type="xs:base64Binary" minOccurs="0" />
|
---|
356 | <xs:element name="Plugin" msprop:Generator_UserColumnName="Plugin" msprop:Generator_ColumnPropNameInRow="Plugin" msprop:Generator_ColumnVarNameInTable="columnPlugin" msprop:Generator_ColumnPropNameInTable="PluginColumn" minOccurs="0">
|
---|
357 | <xs:simpleType>
|
---|
358 | <xs:restriction base="xs:string">
|
---|
359 | <xs:maxLength value="2147483647" />
|
---|
360 | </xs:restriction>
|
---|
361 | </xs:simpleType>
|
---|
362 | </xs:element>
|
---|
363 | </xs:sequence>
|
---|
364 | </xs:complexType>
|
---|
365 | </xs:element>
|
---|
366 | <xs:element name="PermissionOwner" msprop:Generator_UserTableName="PermissionOwner" msprop:Generator_RowDeletedName="PermissionOwnerRowDeleted" msprop:Generator_TableClassName="PermissionOwnerDataTable" msprop:Generator_RowChangedName="PermissionOwnerRowChanged" msprop:Generator_RowClassName="PermissionOwnerRow" msprop:Generator_RowChangingName="PermissionOwnerRowChanging" msprop:Generator_RowEvArgName="PermissionOwnerRowChangeEvent" msprop:Generator_RowEvHandlerName="PermissionOwnerRowChangeEventHandler" msprop:Generator_TablePropName="PermissionOwner" msprop:Generator_TableVarName="tablePermissionOwner" msprop:Generator_RowDeletingName="PermissionOwnerRowDeleting">
|
---|
367 | <xs:complexType>
|
---|
368 | <xs:sequence>
|
---|
369 | <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" />
|
---|
370 | <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn" type="xs:base64Binary" minOccurs="0" />
|
---|
371 | </xs:sequence>
|
---|
372 | </xs:complexType>
|
---|
373 | </xs:element>
|
---|
374 | <xs:element name="PermissionOwner_UserGroup" msprop:Generator_UserTableName="PermissionOwner_UserGroup" msprop:Generator_RowDeletedName="PermissionOwner_UserGroupRowDeleted" msprop:Generator_TableClassName="PermissionOwner_UserGroupDataTable" 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_TablePropName="PermissionOwner_UserGroup" msprop:Generator_TableVarName="tablePermissionOwner_UserGroup" msprop:Generator_RowDeletingName="PermissionOwner_UserGroupRowDeleting">
|
---|
375 | <xs:complexType>
|
---|
376 | <xs:sequence>
|
---|
377 | <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" />
|
---|
378 | <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" />
|
---|
379 | </xs:sequence>
|
---|
380 | </xs:complexType>
|
---|
381 | </xs:element>
|
---|
382 | </xs:choice>
|
---|
383 | </xs:complexType>
|
---|
384 | <xs:unique name="Constraint1" msdata:PrimaryKey="true">
|
---|
385 | <xs:selector xpath=".//mstns:GrantedPermissions" />
|
---|
386 | <xs:field xpath="mstns:PermissionId" />
|
---|
387 | <xs:field xpath="mstns:PermissionOwnerId" />
|
---|
388 | <xs:field xpath="mstns:EntityId" />
|
---|
389 | </xs:unique>
|
---|
390 | <xs:unique name="UserGroup_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
---|
391 | <xs:selector xpath=".//mstns:UserGroup" />
|
---|
392 | <xs:field xpath="mstns:PermissionOwnerId" />
|
---|
393 | </xs:unique>
|
---|
394 | <xs:unique name="HLUser_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
---|
395 | <xs:selector xpath=".//mstns:HLUser" />
|
---|
396 | <xs:field xpath="mstns:PermissionOwnerId" />
|
---|
397 | </xs:unique>
|
---|
398 | <xs:unique name="Permission_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
---|
399 | <xs:selector xpath=".//mstns:Permission" />
|
---|
400 | <xs:field xpath="mstns:PermissionId" />
|
---|
401 | </xs:unique>
|
---|
402 | <xs:unique name="PermissionOwner_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
---|
403 | <xs:selector xpath=".//mstns:PermissionOwner" />
|
---|
404 | <xs:field xpath="mstns:PermissionOwnerId" />
|
---|
405 | </xs:unique>
|
---|
406 | <xs:unique name="PermissionOwner_UserGroup_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
---|
407 | <xs:selector xpath=".//mstns:PermissionOwner_UserGroup" />
|
---|
408 | <xs:field xpath="mstns:PermissionOwnerId" />
|
---|
409 | <xs:field xpath="mstns:UserGroupId" />
|
---|
410 | </xs:unique>
|
---|
411 | </xs:element>
|
---|
412 | <xs:annotation>
|
---|
413 | <xs:appinfo>
|
---|
414 | <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" />
|
---|
415 | <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" />
|
---|
416 | <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" />
|
---|
417 | <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" />
|
---|
418 | <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" />
|
---|
419 | <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" />
|
---|
420 | </xs:appinfo>
|
---|
421 | </xs:annotation>
|
---|
422 | </xs:schema> |
---|