]> fbox.kageds.com Git - NEATEST.git/blob - NEA/NEADataSet.xsd
projects / NEATEST.git / blob
? search:
summary | shortlog | log | commit | commitdiff | tree
blame | history | raw | HEAD
Basic Store
[NEATEST.git] / NEA / NEADataSet.xsd
1 <?xml version="1.0" encoding="utf-8"?>
2 <xs:schema id="NEADataSet" targetNamespace="http://tempuri.org/NEADataSet.xsd" xmlns:mstns="http://tempuri.org/NEADataSet.xsd" xmlns="http://tempuri.org/NEADataSet.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="MySettings" AppSettingsPropertyName="NEAConnectionString2" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="NEAConnectionString2 (MySettings)" PropertyReference="ApplicationSettings.NEA.MySettings.GlobalReference.Default.NEAConnectionString2" Provider="System.Data.OleDb" />
8 </Connections>
9 <Tables>
10 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AchievementTableAdapter" GeneratorDataComponentClassName="AchievementTableAdapter" Name="Achievement" UserDataComponentName="AchievementTableAdapter">
11 <MainSource>
12 <DbSource ConnectionRef="NEAConnectionString2 (MySettings)" DbObjectName="Achievement" 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=4.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 `Achievement` WHERE ((`AchievementID` = ?) AND ((? = 1 AND `GameID` IS NULL) OR (`GameID` = ?)) AND ((? = 1 AND `UserID` IS NULL) OR (`UserID` = ?)))</CommandText>
16 <Parameters>
17 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_AchievementID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AchievementID" SourceColumnNullMapping="false" SourceVersion="Original" />
18 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_GameID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GameID" SourceColumnNullMapping="true" SourceVersion="Original" />
19 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_GameID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GameID" SourceColumnNullMapping="false" SourceVersion="Original" />
20 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="true" SourceVersion="Original" />
21 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
22 </Parameters>
23 </DbCommand>
24 </DeleteCommand>
25 <InsertCommand>
26 <DbCommand CommandType="Text" ModifiedByUser="false">
27 <CommandText>INSERT INTO `Achievement` (`GameID`, `UserID`, `Achievment 1`, `Achievment 2`, `Achievment 3`, `Achievment 4`, `Achievment 5`) VALUES (?, ?, ?, ?, ?, ?, ?)</CommandText>
28 <Parameters>
29 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="GameID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GameID" SourceColumnNullMapping="false" SourceVersion="Current" />
30 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
31 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Achievment_1" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Achievment 1" SourceColumnNullMapping="false" SourceVersion="Current" />
32 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Achievment_2" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Achievment 2" SourceColumnNullMapping="false" SourceVersion="Current" />
33 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Achievment_3" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Achievment 3" SourceColumnNullMapping="false" SourceVersion="Current" />
34 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Achievment_4" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Achievment 4" SourceColumnNullMapping="false" SourceVersion="Current" />
35 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Achievment_5" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Achievment 5" SourceColumnNullMapping="false" SourceVersion="Current" />
36 </Parameters>
37 </DbCommand>
38 </InsertCommand>
39 <SelectCommand>
40 <DbCommand CommandType="Text" ModifiedByUser="false">
41 <CommandText>SELECT AchievementID, GameID, UserID, [Achievment 1], [Achievment 2], [Achievment 3], [Achievment 4], [Achievment 5] FROM Achievement</CommandText>
42 <Parameters />
43 </DbCommand>
44 </SelectCommand>
45 <UpdateCommand>
46 <DbCommand CommandType="Text" ModifiedByUser="false">
47 <CommandText>UPDATE `Achievement` SET `GameID` = ?, `UserID` = ?, `Achievment 1` = ?, `Achievment 2` = ?, `Achievment 3` = ?, `Achievment 4` = ?, `Achievment 5` = ? WHERE ((`AchievementID` = ?) AND ((? = 1 AND `GameID` IS NULL) OR (`GameID` = ?)) AND ((? = 1 AND `UserID` IS NULL) OR (`UserID` = ?)))</CommandText>
48 <Parameters>
49 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="GameID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GameID" SourceColumnNullMapping="false" SourceVersion="Current" />
50 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
51 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Achievment_1" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Achievment 1" SourceColumnNullMapping="false" SourceVersion="Current" />
52 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Achievment_2" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Achievment 2" SourceColumnNullMapping="false" SourceVersion="Current" />
53 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Achievment_3" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Achievment 3" SourceColumnNullMapping="false" SourceVersion="Current" />
54 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Achievment_4" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Achievment 4" SourceColumnNullMapping="false" SourceVersion="Current" />
55 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Achievment_5" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Achievment 5" SourceColumnNullMapping="false" SourceVersion="Current" />
56 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_AchievementID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AchievementID" SourceColumnNullMapping="false" SourceVersion="Original" />
57 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_GameID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GameID" SourceColumnNullMapping="true" SourceVersion="Original" />
58 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_GameID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GameID" SourceColumnNullMapping="false" SourceVersion="Original" />
59 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="true" SourceVersion="Original" />
60 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
61 </Parameters>
62 </DbCommand>
63 </UpdateCommand>
64 </DbSource>
65 </MainSource>
66 <Mappings>
67 <Mapping SourceColumn="AchievementID" DataSetColumn="AchievementID" />
68 <Mapping SourceColumn="GameID" DataSetColumn="GameID" />
69 <Mapping SourceColumn="UserID" DataSetColumn="UserID" />
70 <Mapping SourceColumn="Achievment 1" DataSetColumn="Achievment 1" />
71 <Mapping SourceColumn="Achievment 2" DataSetColumn="Achievment 2" />
72 <Mapping SourceColumn="Achievment 3" DataSetColumn="Achievment 3" />
73 <Mapping SourceColumn="Achievment 4" DataSetColumn="Achievment 4" />
74 <Mapping SourceColumn="Achievment 5" DataSetColumn="Achievment 5" />
75 </Mappings>
76 <Sources />
77 </TableAdapter>
78 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DOWTableAdapter" GeneratorDataComponentClassName="DOWTableAdapter" Name="DOW" UserDataComponentName="DOWTableAdapter">
79 <MainSource>
80 <DbSource ConnectionRef="NEAConnectionString2 (MySettings)" DbObjectName="DOW" 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=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
81 <DeleteCommand>
82 <DbCommand CommandType="Text" ModifiedByUser="false">
83 <CommandText>DELETE FROM `DOW` WHERE ((`DOWID` = ?) AND ((? = 1 AND `Start` IS NULL) OR (`Start` = ?)) AND ((? = 1 AND `End` IS NULL) OR (`End` = ?)) AND ((? = 1 AND `GameID` IS NULL) OR (`GameID` = ?)))</CommandText>
84 <Parameters>
85 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_DOWID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="DOWID" SourceColumnNullMapping="false" SourceVersion="Original" />
86 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Start" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Start" SourceColumnNullMapping="true" SourceVersion="Original" />
87 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_Start" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Start" SourceColumnNullMapping="false" SourceVersion="Original" />
88 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_End" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="End" SourceColumnNullMapping="true" SourceVersion="Original" />
89 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_End" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="End" SourceColumnNullMapping="false" SourceVersion="Original" />
90 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_GameID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GameID" SourceColumnNullMapping="true" SourceVersion="Original" />
91 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_GameID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GameID" SourceColumnNullMapping="false" SourceVersion="Original" />
92 </Parameters>
93 </DbCommand>
94 </DeleteCommand>
95 <InsertCommand>
96 <DbCommand CommandType="Text" ModifiedByUser="false">
97 <CommandText>INSERT INTO `DOW` (`Start`, `End`, `GameID`) VALUES (?, ?, ?)</CommandText>
98 <Parameters>
99 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Start" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Start" SourceColumnNullMapping="false" SourceVersion="Current" />
100 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="End" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="End" SourceColumnNullMapping="false" SourceVersion="Current" />
101 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="GameID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GameID" SourceColumnNullMapping="false" SourceVersion="Current" />
102 </Parameters>
103 </DbCommand>
104 </InsertCommand>
105 <SelectCommand>
106 <DbCommand CommandType="Text" ModifiedByUser="false">
107 <CommandText>SELECT DOWID, Start, [End], GameID FROM DOW</CommandText>
108 <Parameters />
109 </DbCommand>
110 </SelectCommand>
111 <UpdateCommand>
112 <DbCommand CommandType="Text" ModifiedByUser="false">
113 <CommandText>UPDATE `DOW` SET `Start` = ?, `End` = ?, `GameID` = ? WHERE ((`DOWID` = ?) AND ((? = 1 AND `Start` IS NULL) OR (`Start` = ?)) AND ((? = 1 AND `End` IS NULL) OR (`End` = ?)) AND ((? = 1 AND `GameID` IS NULL) OR (`GameID` = ?)))</CommandText>
114 <Parameters>
115 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Start" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Start" SourceColumnNullMapping="false" SourceVersion="Current" />
116 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="End" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="End" SourceColumnNullMapping="false" SourceVersion="Current" />
117 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="GameID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GameID" SourceColumnNullMapping="false" SourceVersion="Current" />
118 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_DOWID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="DOWID" SourceColumnNullMapping="false" SourceVersion="Original" />
119 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Start" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Start" SourceColumnNullMapping="true" SourceVersion="Original" />
120 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_Start" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Start" SourceColumnNullMapping="false" SourceVersion="Original" />
121 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_End" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="End" SourceColumnNullMapping="true" SourceVersion="Original" />
122 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_End" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="End" SourceColumnNullMapping="false" SourceVersion="Original" />
123 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_GameID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GameID" SourceColumnNullMapping="true" SourceVersion="Original" />
124 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_GameID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GameID" SourceColumnNullMapping="false" SourceVersion="Original" />
125 </Parameters>
126 </DbCommand>
127 </UpdateCommand>
128 </DbSource>
129 </MainSource>
130 <Mappings>
131 <Mapping SourceColumn="DOWID" DataSetColumn="DOWID" />
132 <Mapping SourceColumn="Start" DataSetColumn="Start" />
133 <Mapping SourceColumn="End" DataSetColumn="End" />
134 <Mapping SourceColumn="GameID" DataSetColumn="GameID" />
135 </Mappings>
136 <Sources />
137 </TableAdapter>
138 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="FriendsTableAdapter" GeneratorDataComponentClassName="FriendsTableAdapter" Name="Friends" UserDataComponentName="FriendsTableAdapter">
139 <MainSource>
140 <DbSource ConnectionRef="NEAConnectionString2 (MySettings)" DbObjectName="Friends" 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=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
141 <DeleteCommand>
142 <DbCommand CommandType="Text" ModifiedByUser="false">
143 <CommandText>DELETE FROM `Friends` WHERE ((`ID` = ?) AND ((? = 1 AND `FriendID` IS NULL) OR (`FriendID` = ?)) AND ((? = 1 AND `UserID` IS NULL) OR (`UserID` = ?)))</CommandText>
144 <Parameters>
145 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
146 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_FriendID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="FriendID" SourceColumnNullMapping="true" SourceVersion="Original" />
147 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_FriendID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="FriendID" SourceColumnNullMapping="false" SourceVersion="Original" />
148 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="true" SourceVersion="Original" />
149 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
150 </Parameters>
151 </DbCommand>
152 </DeleteCommand>
153 <InsertCommand>
154 <DbCommand CommandType="Text" ModifiedByUser="false">
155 <CommandText>INSERT INTO `Friends` (`FriendID`, `UserID`) VALUES (?, ?)</CommandText>
156 <Parameters>
157 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="FriendID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="FriendID" SourceColumnNullMapping="false" SourceVersion="Current" />
158 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
159 </Parameters>
160 </DbCommand>
161 </InsertCommand>
162 <SelectCommand>
163 <DbCommand CommandType="Text" ModifiedByUser="false">
164 <CommandText>SELECT ID, FriendID, UserID FROM Friends</CommandText>
165 <Parameters />
166 </DbCommand>
167 </SelectCommand>
168 <UpdateCommand>
169 <DbCommand CommandType="Text" ModifiedByUser="false">
170 <CommandText>UPDATE `Friends` SET `FriendID` = ?, `UserID` = ? WHERE ((`ID` = ?) AND ((? = 1 AND `FriendID` IS NULL) OR (`FriendID` = ?)) AND ((? = 1 AND `UserID` IS NULL) OR (`UserID` = ?)))</CommandText>
171 <Parameters>
172 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="FriendID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="FriendID" SourceColumnNullMapping="false" SourceVersion="Current" />
173 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
174 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
175 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_FriendID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="FriendID" SourceColumnNullMapping="true" SourceVersion="Original" />
176 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_FriendID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="FriendID" SourceColumnNullMapping="false" SourceVersion="Original" />
177 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="true" SourceVersion="Original" />
178 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
179 </Parameters>
180 </DbCommand>
181 </UpdateCommand>
182 </DbSource>
183 </MainSource>
184 <Mappings>
185 <Mapping SourceColumn="ID" DataSetColumn="ID" />
186 <Mapping SourceColumn="FriendID" DataSetColumn="FriendID" />
187 <Mapping SourceColumn="UserID" DataSetColumn="UserID" />
188 </Mappings>
189 <Sources />
190 </TableAdapter>
191 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="GamesTableAdapter" GeneratorDataComponentClassName="GamesTableAdapter" Name="Games" UserDataComponentName="GamesTableAdapter">
192 <MainSource>
193 <DbSource ConnectionRef="NEAConnectionString2 (MySettings)" DbObjectName="Games" 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=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
194 <DeleteCommand>
195 <DbCommand CommandType="Text" ModifiedByUser="false">
196 <CommandText>DELETE FROM `Games` WHERE ((`GameID` = ?) AND ((? = 1 AND `Price` IS NULL) OR (`Price` = ?)) AND ((? = 1 AND `Rating` IS NULL) OR (`Rating` = ?)) AND ((? = 1 AND `Certificate` IS NULL) OR (`Certificate` = ?)) AND ((? = 1 AND `Theme Colour` IS NULL) OR (`Theme Colour` = ?)))</CommandText>
197 <Parameters>
198 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_GameID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GameID" SourceColumnNullMapping="false" SourceVersion="Original" />
199 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Price" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="true" SourceVersion="Original" />
200 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_Price" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="false" SourceVersion="Original" />
201 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Rating" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Rating" SourceColumnNullMapping="true" SourceVersion="Original" />
202 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Rating" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Rating" SourceColumnNullMapping="false" SourceVersion="Original" />
203 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Certificate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Certificate" SourceColumnNullMapping="true" SourceVersion="Original" />
204 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Certificate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Certificate" SourceColumnNullMapping="false" SourceVersion="Original" />
205 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Theme_Colour" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Theme Colour" SourceColumnNullMapping="true" SourceVersion="Original" />
206 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Theme_Colour" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Theme Colour" SourceColumnNullMapping="false" SourceVersion="Original" />
207 </Parameters>
208 </DbCommand>
209 </DeleteCommand>
210 <InsertCommand>
211 <DbCommand CommandType="Text" ModifiedByUser="false">
212 <CommandText>INSERT INTO `Games` (`Name`, `Price`, `Rating`, `Certificate`, `Dev`, `Publisher`, `Tags`, `Theme Colour`, `Icon`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
213 <Parameters>
214 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Name" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
215 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Price" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="false" SourceVersion="Current" />
216 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Rating" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Rating" SourceColumnNullMapping="false" SourceVersion="Current" />
217 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Certificate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Certificate" SourceColumnNullMapping="false" SourceVersion="Current" />
218 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Dev" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Dev" SourceColumnNullMapping="false" SourceVersion="Current" />
219 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Publisher" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Publisher" SourceColumnNullMapping="false" SourceVersion="Current" />
220 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Tags" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Tags" SourceColumnNullMapping="false" SourceVersion="Current" />
221 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Theme_Colour" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Theme Colour" SourceColumnNullMapping="false" SourceVersion="Current" />
222 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="Icon" Precision="0" ProviderType="LongVarBinary" Scale="0" Size="0" SourceColumn="Icon" SourceColumnNullMapping="false" SourceVersion="Current" />
223 </Parameters>
224 </DbCommand>
225 </InsertCommand>
226 <SelectCommand>
227 <DbCommand CommandType="Text" ModifiedByUser="true">
228 <CommandText>SELECT GameID, Name, Price, Rating, Certificate, Dev, Publisher, Tags, [Theme Colour], Icon FROM Games</CommandText>
229 <Parameters />
230 </DbCommand>
231 </SelectCommand>
232 <UpdateCommand>
233 <DbCommand CommandType="Text" ModifiedByUser="false">
234 <CommandText>UPDATE `Games` SET `Name` = ?, `Price` = ?, `Rating` = ?, `Certificate` = ?, `Dev` = ?, `Publisher` = ?, `Tags` = ?, `Theme Colour` = ?, `Icon` = ? WHERE ((`GameID` = ?) AND ((? = 1 AND `Price` IS NULL) OR (`Price` = ?)) AND ((? = 1 AND `Rating` IS NULL) OR (`Rating` = ?)) AND ((? = 1 AND `Certificate` IS NULL) OR (`Certificate` = ?)) AND ((? = 1 AND `Theme Colour` IS NULL) OR (`Theme Colour` = ?)))</CommandText>
235 <Parameters>
236 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Name" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
237 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Price" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="false" SourceVersion="Current" />
238 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Rating" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Rating" SourceColumnNullMapping="false" SourceVersion="Current" />
239 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Certificate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Certificate" SourceColumnNullMapping="false" SourceVersion="Current" />
240 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Dev" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Dev" SourceColumnNullMapping="false" SourceVersion="Current" />
241 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Publisher" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Publisher" SourceColumnNullMapping="false" SourceVersion="Current" />
242 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Tags" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Tags" SourceColumnNullMapping="false" SourceVersion="Current" />
243 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Theme_Colour" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Theme Colour" SourceColumnNullMapping="false" SourceVersion="Current" />
244 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="Icon" Precision="0" ProviderType="LongVarBinary" Scale="0" Size="0" SourceColumn="Icon" SourceColumnNullMapping="false" SourceVersion="Current" />
245 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_GameID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GameID" SourceColumnNullMapping="false" SourceVersion="Original" />
246 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Price" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="true" SourceVersion="Original" />
247 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_Price" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="false" SourceVersion="Original" />
248 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Rating" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Rating" SourceColumnNullMapping="true" SourceVersion="Original" />
249 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Rating" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Rating" SourceColumnNullMapping="false" SourceVersion="Original" />
250 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Certificate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Certificate" SourceColumnNullMapping="true" SourceVersion="Original" />
251 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Certificate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Certificate" SourceColumnNullMapping="false" SourceVersion="Original" />
252 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Theme_Colour" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Theme Colour" SourceColumnNullMapping="true" SourceVersion="Original" />
253 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Theme_Colour" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Theme Colour" SourceColumnNullMapping="false" SourceVersion="Original" />
254 </Parameters>
255 </DbCommand>
256 </UpdateCommand>
257 </DbSource>
258 </MainSource>
259 <Mappings>
260 <Mapping SourceColumn="GameID" DataSetColumn="GameID" />
261 <Mapping SourceColumn="Name" DataSetColumn="Name" />
262 <Mapping SourceColumn="Price" DataSetColumn="Price" />
263 <Mapping SourceColumn="Rating" DataSetColumn="Rating" />
264 <Mapping SourceColumn="Certificate" DataSetColumn="Certificate" />
265 <Mapping SourceColumn="Dev" DataSetColumn="Dev" />
266 <Mapping SourceColumn="Publisher" DataSetColumn="Publisher" />
267 <Mapping SourceColumn="Tags" DataSetColumn="Tags" />
268 <Mapping SourceColumn="Theme Colour" DataSetColumn="Theme Colour" />
269 <Mapping SourceColumn="Icon" DataSetColumn="Icon" />
270 </Mappings>
271 <Sources />
272 </TableAdapter>
273 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PurchasedTableAdapter" GeneratorDataComponentClassName="PurchasedTableAdapter" Name="Purchased" UserDataComponentName="PurchasedTableAdapter">
274 <MainSource>
275 <DbSource ConnectionRef="NEAConnectionString2 (MySettings)" DbObjectName="Purchased" 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=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
276 <DeleteCommand>
277 <DbCommand CommandType="Text" ModifiedByUser="false">
278 <CommandText>DELETE FROM `Purchased` WHERE ((`PurchaseID` = ?) AND ((? = 1 AND `UserID` IS NULL) OR (`UserID` = ?)) AND ((? = 1 AND `GameID` IS NULL) OR (`GameID` = ?)))</CommandText>
279 <Parameters>
280 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_PurchaseID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="PurchaseID" SourceColumnNullMapping="false" SourceVersion="Original" />
281 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="true" SourceVersion="Original" />
282 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
283 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_GameID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GameID" SourceColumnNullMapping="true" SourceVersion="Original" />
284 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_GameID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GameID" SourceColumnNullMapping="false" SourceVersion="Original" />
285 </Parameters>
286 </DbCommand>
287 </DeleteCommand>
288 <InsertCommand>
289 <DbCommand CommandType="Text" ModifiedByUser="false">
290 <CommandText>INSERT INTO `Purchased` (`UserID`, `GameID`) VALUES (?, ?)</CommandText>
291 <Parameters>
292 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
293 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="GameID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GameID" SourceColumnNullMapping="false" SourceVersion="Current" />
294 </Parameters>
295 </DbCommand>
296 </InsertCommand>
297 <SelectCommand>
298 <DbCommand CommandType="Text" ModifiedByUser="false">
299 <CommandText>SELECT PurchaseID, UserID, GameID FROM Purchased</CommandText>
300 <Parameters />
301 </DbCommand>
302 </SelectCommand>
303 <UpdateCommand>
304 <DbCommand CommandType="Text" ModifiedByUser="false">
305 <CommandText>UPDATE `Purchased` SET `UserID` = ?, `GameID` = ? WHERE ((`PurchaseID` = ?) AND ((? = 1 AND `UserID` IS NULL) OR (`UserID` = ?)) AND ((? = 1 AND `GameID` IS NULL) OR (`GameID` = ?)))</CommandText>
306 <Parameters>
307 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
308 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="GameID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GameID" SourceColumnNullMapping="false" SourceVersion="Current" />
309 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_PurchaseID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="PurchaseID" SourceColumnNullMapping="false" SourceVersion="Original" />
310 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="true" SourceVersion="Original" />
311 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
312 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_GameID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GameID" SourceColumnNullMapping="true" SourceVersion="Original" />
313 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_GameID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GameID" SourceColumnNullMapping="false" SourceVersion="Original" />
314 </Parameters>
315 </DbCommand>
316 </UpdateCommand>
317 </DbSource>
318 </MainSource>
319 <Mappings>
320 <Mapping SourceColumn="PurchaseID" DataSetColumn="PurchaseID" />
321 <Mapping SourceColumn="UserID" DataSetColumn="UserID" />
322 <Mapping SourceColumn="GameID" DataSetColumn="GameID" />
323 </Mappings>
324 <Sources />
325 </TableAdapter>
326 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ReviewsTableAdapter" GeneratorDataComponentClassName="ReviewsTableAdapter" Name="Reviews" UserDataComponentName="ReviewsTableAdapter">
327 <MainSource>
328 <DbSource ConnectionRef="NEAConnectionString2 (MySettings)" DbObjectName="Reviews" 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=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
329 <DeleteCommand>
330 <DbCommand CommandType="Text" ModifiedByUser="false">
331 <CommandText>DELETE FROM `Reviews` WHERE ((`ReviewID` = ?) AND ((? = 1 AND `GameID` IS NULL) OR (`GameID` = ?)))</CommandText>
332 <Parameters>
333 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ReviewID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ReviewID" SourceColumnNullMapping="false" SourceVersion="Original" />
334 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_GameID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GameID" SourceColumnNullMapping="true" SourceVersion="Original" />
335 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_GameID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GameID" SourceColumnNullMapping="false" SourceVersion="Original" />
336 </Parameters>
337 </DbCommand>
338 </DeleteCommand>
339 <InsertCommand>
340 <DbCommand CommandType="Text" ModifiedByUser="false">
341 <CommandText>INSERT INTO `Reviews` (`GameID`, `Review`) VALUES (?, ?)</CommandText>
342 <Parameters>
343 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="GameID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GameID" SourceColumnNullMapping="false" SourceVersion="Current" />
344 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Review" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Review" SourceColumnNullMapping="false" SourceVersion="Current" />
345 </Parameters>
346 </DbCommand>
347 </InsertCommand>
348 <SelectCommand>
349 <DbCommand CommandType="Text" ModifiedByUser="false">
350 <CommandText>SELECT ReviewID, GameID, Review FROM Reviews</CommandText>
351 <Parameters />
352 </DbCommand>
353 </SelectCommand>
354 <UpdateCommand>
355 <DbCommand CommandType="Text" ModifiedByUser="false">
356 <CommandText>UPDATE `Reviews` SET `GameID` = ?, `Review` = ? WHERE ((`ReviewID` = ?) AND ((? = 1 AND `GameID` IS NULL) OR (`GameID` = ?)))</CommandText>
357 <Parameters>
358 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="GameID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GameID" SourceColumnNullMapping="false" SourceVersion="Current" />
359 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Review" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Review" SourceColumnNullMapping="false" SourceVersion="Current" />
360 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ReviewID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ReviewID" SourceColumnNullMapping="false" SourceVersion="Original" />
361 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_GameID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GameID" SourceColumnNullMapping="true" SourceVersion="Original" />
362 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_GameID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GameID" SourceColumnNullMapping="false" SourceVersion="Original" />
363 </Parameters>
364 </DbCommand>
365 </UpdateCommand>
366 </DbSource>
367 </MainSource>
368 <Mappings>
369 <Mapping SourceColumn="ReviewID" DataSetColumn="ReviewID" />
370 <Mapping SourceColumn="GameID" DataSetColumn="GameID" />
371 <Mapping SourceColumn="Review" DataSetColumn="Review" />
372 </Mappings>
373 <Sources />
374 </TableAdapter>
375 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TagsTableAdapter" GeneratorDataComponentClassName="TagsTableAdapter" Name="Tags" UserDataComponentName="TagsTableAdapter">
376 <MainSource>
377 <DbSource ConnectionRef="NEAConnectionString2 (MySettings)" DbObjectName="Tags" 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=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
378 <DeleteCommand>
379 <DbCommand CommandType="Text" ModifiedByUser="false">
380 <CommandText>DELETE FROM `Tags` WHERE ((`ID` = ?))</CommandText>
381 <Parameters>
382 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
383 </Parameters>
384 </DbCommand>
385 </DeleteCommand>
386 <InsertCommand>
387 <DbCommand CommandType="Text" ModifiedByUser="false">
388 <CommandText>INSERT INTO `Tags` DEFAULT VALUES</CommandText>
389 <Parameters />
390 </DbCommand>
391 </InsertCommand>
392 <SelectCommand>
393 <DbCommand CommandType="Text" ModifiedByUser="false">
394 <CommandText>SELECT ID FROM Tags</CommandText>
395 <Parameters />
396 </DbCommand>
397 </SelectCommand>
398 <UpdateCommand>
399 <DbCommand CommandType="Text" ModifiedByUser="false">
400 <CommandText>UPDATE `Tags` WHERE ((`ID` = ?))</CommandText>
401 <Parameters>
402 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
403 </Parameters>
404 </DbCommand>
405 </UpdateCommand>
406 </DbSource>
407 </MainSource>
408 <Mappings>
409 <Mapping SourceColumn="ID" DataSetColumn="ID" />
410 </Mappings>
411 <Sources />
412 </TableAdapter>
413 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="User_DetailsTableAdapter" GeneratorDataComponentClassName="User_DetailsTableAdapter" Name="User_Details" UserDataComponentName="User_DetailsTableAdapter">
414 <MainSource>
415 <DbSource ConnectionRef="NEAConnectionString2 (MySettings)" DbObjectName="User_Details" 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=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
416 <DeleteCommand>
417 <DbCommand CommandType="Text" ModifiedByUser="false">
418 <CommandText>DELETE FROM `User_Details` WHERE ((`UserDetailsID` = ?) AND ((? = 1 AND `Town` IS NULL) OR (`Town` = ?)) AND ((? = 1 AND `CardNumber` IS NULL) OR (`CardNumber` = ?)) AND ((? = 1 AND `CVC` IS NULL) OR (`CVC` = ?)))</CommandText>
419 <Parameters>
420 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_UserDetailsID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserDetailsID" SourceColumnNullMapping="false" SourceVersion="Original" />
421 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Town" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Town" SourceColumnNullMapping="true" SourceVersion="Original" />
422 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Town" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Town" SourceColumnNullMapping="false" SourceVersion="Original" />
423 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CardNumber" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CardNumber" SourceColumnNullMapping="true" SourceVersion="Original" />
424 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_CardNumber" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CardNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
425 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CVC" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CVC" SourceColumnNullMapping="true" SourceVersion="Original" />
426 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_CVC" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CVC" SourceColumnNullMapping="false" SourceVersion="Original" />
427 </Parameters>
428 </DbCommand>
429 </DeleteCommand>
430 <InsertCommand>
431 <DbCommand CommandType="Text" ModifiedByUser="false">
432 <CommandText>INSERT INTO `User_Details` (`FirstName`, `LastName`, `AddressLine1`, `Town`, `Postcode`, `CardNumber`, `CVC`, `IGN`, `Email`, `ProfilePic`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
433 <Parameters>
434 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="FirstName" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="FirstName" SourceColumnNullMapping="false" SourceVersion="Current" />
435 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="LastName" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="LastName" SourceColumnNullMapping="false" SourceVersion="Current" />
436 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="AddressLine1" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="AddressLine1" SourceColumnNullMapping="false" SourceVersion="Current" />
437 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Town" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Town" SourceColumnNullMapping="false" SourceVersion="Current" />
438 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Postcode" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Postcode" SourceColumnNullMapping="false" SourceVersion="Current" />
439 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="CardNumber" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CardNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
440 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="CVC" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CVC" SourceColumnNullMapping="false" SourceVersion="Current" />
441 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IGN" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="IGN" SourceColumnNullMapping="false" SourceVersion="Current" />
442 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Email" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
443 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="ProfilePic" Precision="0" ProviderType="LongVarBinary" Scale="0" Size="0" SourceColumn="ProfilePic" SourceColumnNullMapping="false" SourceVersion="Current" />
444 </Parameters>
445 </DbCommand>
446 </InsertCommand>
447 <SelectCommand>
448 <DbCommand CommandType="Text" ModifiedByUser="true">
449 <CommandText>SELECT UserDetailsID, FirstName, LastName, AddressLine1, Town, Postcode, CardNumber, CVC, IGN, Email, ProfilePic FROM User_Details</CommandText>
450 <Parameters />
451 </DbCommand>
452 </SelectCommand>
453 <UpdateCommand>
454 <DbCommand CommandType="Text" ModifiedByUser="false">
455 <CommandText>UPDATE `User_Details` SET `FirstName` = ?, `LastName` = ?, `AddressLine1` = ?, `Town` = ?, `Postcode` = ?, `CardNumber` = ?, `CVC` = ?, `IGN` = ?, `Email` = ?, `ProfilePic` = ? WHERE ((`UserDetailsID` = ?) AND ((? = 1 AND `Town` IS NULL) OR (`Town` = ?)) AND ((? = 1 AND `CardNumber` IS NULL) OR (`CardNumber` = ?)) AND ((? = 1 AND `CVC` IS NULL) OR (`CVC` = ?)))</CommandText>
456 <Parameters>
457 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="FirstName" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="FirstName" SourceColumnNullMapping="false" SourceVersion="Current" />
458 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="LastName" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="LastName" SourceColumnNullMapping="false" SourceVersion="Current" />
459 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="AddressLine1" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="AddressLine1" SourceColumnNullMapping="false" SourceVersion="Current" />
460 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Town" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Town" SourceColumnNullMapping="false" SourceVersion="Current" />
461 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Postcode" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Postcode" SourceColumnNullMapping="false" SourceVersion="Current" />
462 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="CardNumber" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CardNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
463 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="CVC" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CVC" SourceColumnNullMapping="false" SourceVersion="Current" />
464 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IGN" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="IGN" SourceColumnNullMapping="false" SourceVersion="Current" />
465 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Email" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
466 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="ProfilePic" Precision="0" ProviderType="LongVarBinary" Scale="0" Size="0" SourceColumn="ProfilePic" SourceColumnNullMapping="false" SourceVersion="Current" />
467 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_UserDetailsID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserDetailsID" SourceColumnNullMapping="false" SourceVersion="Original" />
468 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Town" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Town" SourceColumnNullMapping="true" SourceVersion="Original" />
469 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Town" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Town" SourceColumnNullMapping="false" SourceVersion="Original" />
470 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CardNumber" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CardNumber" SourceColumnNullMapping="true" SourceVersion="Original" />
471 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_CardNumber" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CardNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
472 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CVC" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CVC" SourceColumnNullMapping="true" SourceVersion="Original" />
473 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_CVC" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CVC" SourceColumnNullMapping="false" SourceVersion="Original" />
474 </Parameters>
475 </DbCommand>
476 </UpdateCommand>
477 </DbSource>
478 </MainSource>
479 <Mappings>
480 <Mapping SourceColumn="UserDetailsID" DataSetColumn="UserDetailsID" />
481 <Mapping SourceColumn="FirstName" DataSetColumn="FirstName" />
482 <Mapping SourceColumn="LastName" DataSetColumn="LastName" />
483 <Mapping SourceColumn="AddressLine1" DataSetColumn="AddressLine1" />
484 <Mapping SourceColumn="Town" DataSetColumn="Town" />
485 <Mapping SourceColumn="Postcode" DataSetColumn="Postcode" />
486 <Mapping SourceColumn="CardNumber" DataSetColumn="CardNumber" />
487 <Mapping SourceColumn="CVC" DataSetColumn="CVC" />
488 <Mapping SourceColumn="IGN" DataSetColumn="IGN" />
489 <Mapping SourceColumn="Email" DataSetColumn="Email" />
490 <Mapping SourceColumn="ProfilePic" DataSetColumn="ProfilePic" />
491 </Mappings>
492 <Sources />
493 </TableAdapter>
494 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UsersTableAdapter" GeneratorDataComponentClassName="UsersTableAdapter" Name="Users" UserDataComponentName="UsersTableAdapter">
495 <MainSource>
496 <DbSource ConnectionRef="NEAConnectionString2 (MySettings)" DbObjectName="Users" 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=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
497 <DeleteCommand>
498 <DbCommand CommandType="Text" ModifiedByUser="false">
499 <CommandText>DELETE FROM `Users` WHERE ((`UserID` = ?) AND ((? = 1 AND `User_DetailsID` IS NULL) OR (`User_DetailsID` = ?)))</CommandText>
500 <Parameters>
501 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
502 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_User_DetailsID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="User_DetailsID" SourceColumnNullMapping="true" SourceVersion="Original" />
503 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_User_DetailsID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="User_DetailsID" SourceColumnNullMapping="false" SourceVersion="Original" />
504 </Parameters>
505 </DbCommand>
506 </DeleteCommand>
507 <InsertCommand>
508 <DbCommand CommandType="Text" ModifiedByUser="false">
509 <CommandText>INSERT INTO `Users` (`User_DetailsID`, `Username`, `Password`) VALUES (?, ?, ?)</CommandText>
510 <Parameters>
511 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="User_DetailsID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="User_DetailsID" SourceColumnNullMapping="false" SourceVersion="Current" />
512 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Username" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="false" SourceVersion="Current" />
513 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Password" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Current" />
514 </Parameters>
515 </DbCommand>
516 </InsertCommand>
517 <SelectCommand>
518 <DbCommand CommandType="Text" ModifiedByUser="false">
519 <CommandText>SELECT UserID, User_DetailsID, Username, [Password] FROM Users</CommandText>
520 <Parameters />
521 </DbCommand>
522 </SelectCommand>
523 <UpdateCommand>
524 <DbCommand CommandType="Text" ModifiedByUser="false">
525 <CommandText>UPDATE `Users` SET `User_DetailsID` = ?, `Username` = ?, `Password` = ? WHERE ((`UserID` = ?) AND ((? = 1 AND `User_DetailsID` IS NULL) OR (`User_DetailsID` = ?)))</CommandText>
526 <Parameters>
527 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="User_DetailsID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="User_DetailsID" SourceColumnNullMapping="false" SourceVersion="Current" />
528 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Username" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="false" SourceVersion="Current" />
529 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Password" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Current" />
530 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
531 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_User_DetailsID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="User_DetailsID" SourceColumnNullMapping="true" SourceVersion="Original" />
532 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_User_DetailsID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="User_DetailsID" SourceColumnNullMapping="false" SourceVersion="Original" />
533 </Parameters>
534 </DbCommand>
535 </UpdateCommand>
536 </DbSource>
537 </MainSource>
538 <Mappings>
539 <Mapping SourceColumn="UserID" DataSetColumn="UserID" />
540 <Mapping SourceColumn="User_DetailsID" DataSetColumn="User_DetailsID" />
541 <Mapping SourceColumn="Username" DataSetColumn="Username" />
542 <Mapping SourceColumn="Password" DataSetColumn="Password" />
543 </Mappings>
544 <Sources />
545 </TableAdapter>
546 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="WishlistTableAdapter" GeneratorDataComponentClassName="WishlistTableAdapter" Name="Wishlist" UserDataComponentName="WishlistTableAdapter">
547 <MainSource>
548 <DbSource ConnectionRef="NEAConnectionString2 (MySettings)" DbObjectName="Wishlist" 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=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
549 <DeleteCommand>
550 <DbCommand CommandType="Text" ModifiedByUser="false">
551 <CommandText>DELETE FROM `Wishlist` WHERE ((`WishlistID` = ?) AND ((? = 1 AND `UserID` IS NULL) OR (`UserID` = ?)) AND ((? = 1 AND `GameID` IS NULL) OR (`GameID` = ?)))</CommandText>
552 <Parameters>
553 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_WishlistID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="WishlistID" SourceColumnNullMapping="false" SourceVersion="Original" />
554 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="true" SourceVersion="Original" />
555 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
556 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_GameID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GameID" SourceColumnNullMapping="true" SourceVersion="Original" />
557 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_GameID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GameID" SourceColumnNullMapping="false" SourceVersion="Original" />
558 </Parameters>
559 </DbCommand>
560 </DeleteCommand>
561 <InsertCommand>
562 <DbCommand CommandType="Text" ModifiedByUser="false">
563 <CommandText>INSERT INTO `Wishlist` (`UserID`, `GameID`) VALUES (?, ?)</CommandText>
564 <Parameters>
565 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
566 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="GameID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GameID" SourceColumnNullMapping="false" SourceVersion="Current" />
567 </Parameters>
568 </DbCommand>
569 </InsertCommand>
570 <SelectCommand>
571 <DbCommand CommandType="Text" ModifiedByUser="false">
572 <CommandText>SELECT WishlistID, UserID, GameID FROM Wishlist</CommandText>
573 <Parameters />
574 </DbCommand>
575 </SelectCommand>
576 <UpdateCommand>
577 <DbCommand CommandType="Text" ModifiedByUser="false">
578 <CommandText>UPDATE `Wishlist` SET `UserID` = ?, `GameID` = ? WHERE ((`WishlistID` = ?) AND ((? = 1 AND `UserID` IS NULL) OR (`UserID` = ?)) AND ((? = 1 AND `GameID` IS NULL) OR (`GameID` = ?)))</CommandText>
579 <Parameters>
580 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
581 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="GameID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GameID" SourceColumnNullMapping="false" SourceVersion="Current" />
582 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_WishlistID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="WishlistID" SourceColumnNullMapping="false" SourceVersion="Original" />
583 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="true" SourceVersion="Original" />
584 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
585 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_GameID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GameID" SourceColumnNullMapping="true" SourceVersion="Original" />
586 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_GameID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GameID" SourceColumnNullMapping="false" SourceVersion="Original" />
587 </Parameters>
588 </DbCommand>
589 </UpdateCommand>
590 </DbSource>
591 </MainSource>
592 <Mappings>
593 <Mapping SourceColumn="WishlistID" DataSetColumn="WishlistID" />
594 <Mapping SourceColumn="UserID" DataSetColumn="UserID" />
595 <Mapping SourceColumn="GameID" DataSetColumn="GameID" />
596 </Mappings>
597 <Sources />
598 </TableAdapter>
599 </Tables>
600 <Sources />
601 </DataSource>
602 </xs:appinfo>
603 </xs:annotation>
604 <xs:element name="NEADataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="NEADataSet" msprop:Generator_UserDSName="NEADataSet">
605 <xs:complexType>
606 <xs:choice minOccurs="0" maxOccurs="unbounded">
607 <xs:element name="Achievement" msprop:Generator_TableClassName="AchievementDataTable" msprop:Generator_TableVarName="tableAchievement" msprop:Generator_RowChangedName="AchievementRowChanged" msprop:Generator_TablePropName="Achievement" msprop:Generator_RowDeletingName="AchievementRowDeleting" msprop:Generator_RowChangingName="AchievementRowChanging" msprop:Generator_RowEvHandlerName="AchievementRowChangeEventHandler" msprop:Generator_RowDeletedName="AchievementRowDeleted" msprop:Generator_RowClassName="AchievementRow" msprop:Generator_UserTableName="Achievement" msprop:Generator_RowEvArgName="AchievementRowChangeEvent">
608 <xs:complexType>
609 <xs:sequence>
610 <xs:element name="AchievementID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnAchievementID" msprop:Generator_ColumnPropNameInRow="AchievementID" msprop:Generator_ColumnPropNameInTable="AchievementIDColumn" msprop:Generator_UserColumnName="AchievementID" type="xs:int" />
611 <xs:element name="GameID" msprop:Generator_ColumnVarNameInTable="columnGameID" msprop:Generator_ColumnPropNameInRow="GameID" msprop:Generator_ColumnPropNameInTable="GameIDColumn" msprop:Generator_UserColumnName="GameID" type="xs:int" minOccurs="0" />
612 <xs:element name="UserID" msprop:Generator_ColumnVarNameInTable="columnUserID" msprop:Generator_ColumnPropNameInRow="UserID" msprop:Generator_ColumnPropNameInTable="UserIDColumn" msprop:Generator_UserColumnName="UserID" type="xs:int" minOccurs="0" />
613 <xs:element name="Achievment_x0020_1" msprop:Generator_ColumnVarNameInTable="columnAchievment_1" msprop:Generator_ColumnPropNameInRow="Achievment_1" msprop:Generator_ColumnPropNameInTable="Achievment_1Column" msprop:Generator_UserColumnName="Achievment 1" minOccurs="0">
614 <xs:simpleType>
615 <xs:restriction base="xs:string">
616 <xs:maxLength value="536870910" />
617 </xs:restriction>
618 </xs:simpleType>
619 </xs:element>
620 <xs:element name="Achievment_x0020_2" msprop:Generator_ColumnVarNameInTable="columnAchievment_2" msprop:Generator_ColumnPropNameInRow="Achievment_2" msprop:Generator_ColumnPropNameInTable="Achievment_2Column" msprop:Generator_UserColumnName="Achievment 2" minOccurs="0">
621 <xs:simpleType>
622 <xs:restriction base="xs:string">
623 <xs:maxLength value="536870910" />
624 </xs:restriction>
625 </xs:simpleType>
626 </xs:element>
627 <xs:element name="Achievment_x0020_3" msprop:Generator_ColumnVarNameInTable="columnAchievment_3" msprop:Generator_ColumnPropNameInRow="Achievment_3" msprop:Generator_ColumnPropNameInTable="Achievment_3Column" msprop:Generator_UserColumnName="Achievment 3" minOccurs="0">
628 <xs:simpleType>
629 <xs:restriction base="xs:string">
630 <xs:maxLength value="536870910" />
631 </xs:restriction>
632 </xs:simpleType>
633 </xs:element>
634 <xs:element name="Achievment_x0020_4" msprop:Generator_ColumnVarNameInTable="columnAchievment_4" msprop:Generator_ColumnPropNameInRow="Achievment_4" msprop:Generator_ColumnPropNameInTable="Achievment_4Column" msprop:Generator_UserColumnName="Achievment 4" minOccurs="0">
635 <xs:simpleType>
636 <xs:restriction base="xs:string">
637 <xs:maxLength value="536870910" />
638 </xs:restriction>
639 </xs:simpleType>
640 </xs:element>
641 <xs:element name="Achievment_x0020_5" msprop:Generator_ColumnVarNameInTable="columnAchievment_5" msprop:Generator_ColumnPropNameInRow="Achievment_5" msprop:Generator_ColumnPropNameInTable="Achievment_5Column" msprop:Generator_UserColumnName="Achievment 5" minOccurs="0">
642 <xs:simpleType>
643 <xs:restriction base="xs:string">
644 <xs:maxLength value="536870910" />
645 </xs:restriction>
646 </xs:simpleType>
647 </xs:element>
648 </xs:sequence>
649 </xs:complexType>
650 </xs:element>
651 <xs:element name="DOW" msprop:Generator_TableClassName="DOWDataTable" msprop:Generator_TableVarName="tableDOW" msprop:Generator_RowChangedName="DOWRowChanged" msprop:Generator_TablePropName="DOW" msprop:Generator_RowDeletingName="DOWRowDeleting" msprop:Generator_RowChangingName="DOWRowChanging" msprop:Generator_RowEvHandlerName="DOWRowChangeEventHandler" msprop:Generator_RowDeletedName="DOWRowDeleted" msprop:Generator_RowClassName="DOWRow" msprop:Generator_UserTableName="DOW" msprop:Generator_RowEvArgName="DOWRowChangeEvent">
652 <xs:complexType>
653 <xs:sequence>
654 <xs:element name="DOWID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnDOWID" msprop:Generator_ColumnPropNameInRow="DOWID" msprop:Generator_ColumnPropNameInTable="DOWIDColumn" msprop:Generator_UserColumnName="DOWID" type="xs:int" />
655 <xs:element name="Start" msprop:Generator_ColumnVarNameInTable="columnStart" msprop:Generator_ColumnPropNameInRow="Start" msprop:Generator_ColumnPropNameInTable="StartColumn" msprop:Generator_UserColumnName="Start" type="xs:dateTime" minOccurs="0" />
656 <xs:element name="End" msprop:Generator_ColumnVarNameInTable="columnEnd" msprop:Generator_ColumnPropNameInRow="_End" msprop:Generator_ColumnPropNameInTable="EndColumn" msprop:Generator_UserColumnName="End" type="xs:dateTime" minOccurs="0" />
657 <xs:element name="GameID" msprop:Generator_ColumnVarNameInTable="columnGameID" msprop:Generator_ColumnPropNameInRow="GameID" msprop:Generator_ColumnPropNameInTable="GameIDColumn" msprop:Generator_UserColumnName="GameID" type="xs:int" minOccurs="0" />
658 </xs:sequence>
659 </xs:complexType>
660 </xs:element>
661 <xs:element name="Friends" msprop:Generator_TableClassName="FriendsDataTable" msprop:Generator_TableVarName="tableFriends" msprop:Generator_RowChangedName="FriendsRowChanged" msprop:Generator_TablePropName="Friends" msprop:Generator_RowDeletingName="FriendsRowDeleting" msprop:Generator_RowChangingName="FriendsRowChanging" msprop:Generator_RowEvHandlerName="FriendsRowChangeEventHandler" msprop:Generator_RowDeletedName="FriendsRowDeleted" msprop:Generator_RowClassName="FriendsRow" msprop:Generator_UserTableName="Friends" msprop:Generator_RowEvArgName="FriendsRowChangeEvent">
662 <xs:complexType>
663 <xs:sequence>
664 <xs:element name="ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
665 <xs:element name="FriendID" msprop:Generator_ColumnVarNameInTable="columnFriendID" msprop:Generator_ColumnPropNameInRow="FriendID" msprop:Generator_ColumnPropNameInTable="FriendIDColumn" msprop:Generator_UserColumnName="FriendID" type="xs:int" minOccurs="0" />
666 <xs:element name="UserID" msprop:Generator_ColumnVarNameInTable="columnUserID" msprop:Generator_ColumnPropNameInRow="UserID" msprop:Generator_ColumnPropNameInTable="UserIDColumn" msprop:Generator_UserColumnName="UserID" type="xs:int" minOccurs="0" />
667 </xs:sequence>
668 </xs:complexType>
669 </xs:element>
670 <xs:element name="Games" msprop:Generator_TableClassName="GamesDataTable" msprop:Generator_TableVarName="tableGames" msprop:Generator_RowChangedName="GamesRowChanged" msprop:Generator_TablePropName="Games" msprop:Generator_RowDeletingName="GamesRowDeleting" msprop:Generator_RowChangingName="GamesRowChanging" msprop:Generator_RowEvHandlerName="GamesRowChangeEventHandler" msprop:Generator_RowDeletedName="GamesRowDeleted" msprop:Generator_RowClassName="GamesRow" msprop:Generator_UserTableName="Games" msprop:Generator_RowEvArgName="GamesRowChangeEvent">
671 <xs:complexType>
672 <xs:sequence>
673 <xs:element name="GameID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnGameID" msprop:Generator_ColumnPropNameInRow="GameID" msprop:Generator_ColumnPropNameInTable="GameIDColumn" msprop:Generator_UserColumnName="GameID" type="xs:int" />
674 <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name" minOccurs="0">
675 <xs:simpleType>
676 <xs:restriction base="xs:string">
677 <xs:maxLength value="536870910" />
678 </xs:restriction>
679 </xs:simpleType>
680 </xs:element>
681 <xs:element name="Price" msprop:Generator_ColumnVarNameInTable="columnPrice" msprop:Generator_ColumnPropNameInRow="Price" msprop:Generator_ColumnPropNameInTable="PriceColumn" msprop:Generator_UserColumnName="Price" type="xs:decimal" minOccurs="0" />
682 <xs:element name="Rating" msprop:Generator_ColumnVarNameInTable="columnRating" msprop:Generator_ColumnPropNameInRow="Rating" msprop:Generator_ColumnPropNameInTable="RatingColumn" msprop:Generator_UserColumnName="Rating" type="xs:int" minOccurs="0" />
683 <xs:element name="Certificate" msprop:Generator_ColumnVarNameInTable="columnCertificate" msprop:Generator_ColumnPropNameInRow="Certificate" msprop:Generator_ColumnPropNameInTable="CertificateColumn" msprop:Generator_UserColumnName="Certificate" type="xs:int" minOccurs="0" />
684 <xs:element name="Dev" msprop:Generator_ColumnVarNameInTable="columnDev" msprop:Generator_ColumnPropNameInRow="Dev" msprop:Generator_ColumnPropNameInTable="DevColumn" msprop:Generator_UserColumnName="Dev" minOccurs="0">
685 <xs:simpleType>
686 <xs:restriction base="xs:string">
687 <xs:maxLength value="536870910" />
688 </xs:restriction>
689 </xs:simpleType>
690 </xs:element>
691 <xs:element name="Publisher" msprop:Generator_ColumnVarNameInTable="columnPublisher" msprop:Generator_ColumnPropNameInRow="Publisher" msprop:Generator_ColumnPropNameInTable="PublisherColumn" msprop:Generator_UserColumnName="Publisher" minOccurs="0">
692 <xs:simpleType>
693 <xs:restriction base="xs:string">
694 <xs:maxLength value="536870910" />
695 </xs:restriction>
696 </xs:simpleType>
697 </xs:element>
698 <xs:element name="Tags" msprop:Generator_ColumnVarNameInTable="columnTags" msprop:Generator_ColumnPropNameInRow="Tags" msprop:Generator_ColumnPropNameInTable="TagsColumn" msprop:Generator_UserColumnName="Tags" minOccurs="0">
699 <xs:simpleType>
700 <xs:restriction base="xs:string">
701 <xs:maxLength value="536870910" />
702 </xs:restriction>
703 </xs:simpleType>
704 </xs:element>
705 <xs:element name="Theme_x0020_Colour" msprop:Generator_ColumnVarNameInTable="columnTheme_Colour" msprop:Generator_ColumnPropNameInRow="Theme_Colour" msprop:Generator_ColumnPropNameInTable="Theme_ColourColumn" msprop:Generator_UserColumnName="Theme Colour" type="xs:int" minOccurs="0" />
706 <xs:element name="Icon" msprop:Generator_ColumnVarNameInTable="columnIcon" msprop:Generator_ColumnPropNameInRow="Icon" msprop:Generator_ColumnPropNameInTable="IconColumn" msprop:Generator_UserColumnName="Icon" type="xs:base64Binary" minOccurs="0" />
707 </xs:sequence>
708 </xs:complexType>
709 </xs:element>
710 <xs:element name="Purchased" msprop:Generator_TableClassName="PurchasedDataTable" msprop:Generator_TableVarName="tablePurchased" msprop:Generator_RowChangedName="PurchasedRowChanged" msprop:Generator_TablePropName="Purchased" msprop:Generator_RowDeletingName="PurchasedRowDeleting" msprop:Generator_RowChangingName="PurchasedRowChanging" msprop:Generator_RowEvHandlerName="PurchasedRowChangeEventHandler" msprop:Generator_RowDeletedName="PurchasedRowDeleted" msprop:Generator_RowClassName="PurchasedRow" msprop:Generator_UserTableName="Purchased" msprop:Generator_RowEvArgName="PurchasedRowChangeEvent">
711 <xs:complexType>
712 <xs:sequence>
713 <xs:element name="PurchaseID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnPurchaseID" msprop:Generator_ColumnPropNameInRow="PurchaseID" msprop:Generator_ColumnPropNameInTable="PurchaseIDColumn" msprop:Generator_UserColumnName="PurchaseID" type="xs:int" />
714 <xs:element name="UserID" msprop:Generator_ColumnVarNameInTable="columnUserID" msprop:Generator_ColumnPropNameInRow="UserID" msprop:Generator_ColumnPropNameInTable="UserIDColumn" msprop:Generator_UserColumnName="UserID" type="xs:int" minOccurs="0" />
715 <xs:element name="GameID" msprop:Generator_ColumnVarNameInTable="columnGameID" msprop:Generator_ColumnPropNameInRow="GameID" msprop:Generator_ColumnPropNameInTable="GameIDColumn" msprop:Generator_UserColumnName="GameID" type="xs:int" minOccurs="0" />
716 </xs:sequence>
717 </xs:complexType>
718 </xs:element>
719 <xs:element name="Reviews" msprop:Generator_TableClassName="ReviewsDataTable" msprop:Generator_TableVarName="tableReviews" msprop:Generator_RowChangedName="ReviewsRowChanged" msprop:Generator_TablePropName="Reviews" msprop:Generator_RowDeletingName="ReviewsRowDeleting" msprop:Generator_RowChangingName="ReviewsRowChanging" msprop:Generator_RowEvHandlerName="ReviewsRowChangeEventHandler" msprop:Generator_RowDeletedName="ReviewsRowDeleted" msprop:Generator_RowClassName="ReviewsRow" msprop:Generator_UserTableName="Reviews" msprop:Generator_RowEvArgName="ReviewsRowChangeEvent">
720 <xs:complexType>
721 <xs:sequence>
722 <xs:element name="ReviewID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnReviewID" msprop:Generator_ColumnPropNameInRow="ReviewID" msprop:Generator_ColumnPropNameInTable="ReviewIDColumn" msprop:Generator_UserColumnName="ReviewID" type="xs:int" />
723 <xs:element name="GameID" msprop:Generator_ColumnVarNameInTable="columnGameID" msprop:Generator_ColumnPropNameInRow="GameID" msprop:Generator_ColumnPropNameInTable="GameIDColumn" msprop:Generator_UserColumnName="GameID" type="xs:int" minOccurs="0" />
724 <xs:element name="Review" msprop:Generator_ColumnVarNameInTable="columnReview" msprop:Generator_ColumnPropNameInRow="Review" msprop:Generator_ColumnPropNameInTable="ReviewColumn" msprop:Generator_UserColumnName="Review" minOccurs="0">
725 <xs:simpleType>
726 <xs:restriction base="xs:string">
727 <xs:maxLength value="536870910" />
728 </xs:restriction>
729 </xs:simpleType>
730 </xs:element>
731 </xs:sequence>
732 </xs:complexType>
733 </xs:element>
734 <xs:element name="Tags" msprop:Generator_TableClassName="TagsDataTable" msprop:Generator_TableVarName="tableTags" msprop:Generator_RowChangedName="TagsRowChanged" msprop:Generator_TablePropName="Tags" msprop:Generator_RowDeletingName="TagsRowDeleting" msprop:Generator_RowChangingName="TagsRowChanging" msprop:Generator_RowEvHandlerName="TagsRowChangeEventHandler" msprop:Generator_RowDeletedName="TagsRowDeleted" msprop:Generator_RowClassName="TagsRow" msprop:Generator_UserTableName="Tags" msprop:Generator_RowEvArgName="TagsRowChangeEvent">
735 <xs:complexType>
736 <xs:sequence>
737 <xs:element name="ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
738 </xs:sequence>
739 </xs:complexType>
740 </xs:element>
741 <xs:element name="User_Details" msprop:Generator_TableClassName="User_DetailsDataTable" msprop:Generator_TableVarName="tableUser_Details" msprop:Generator_RowChangedName="User_DetailsRowChanged" msprop:Generator_TablePropName="User_Details" msprop:Generator_RowDeletingName="User_DetailsRowDeleting" msprop:Generator_RowChangingName="User_DetailsRowChanging" msprop:Generator_RowEvHandlerName="User_DetailsRowChangeEventHandler" msprop:Generator_RowDeletedName="User_DetailsRowDeleted" msprop:Generator_RowClassName="User_DetailsRow" msprop:Generator_UserTableName="User_Details" msprop:Generator_RowEvArgName="User_DetailsRowChangeEvent">
742 <xs:complexType>
743 <xs:sequence>
744 <xs:element name="UserDetailsID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnUserDetailsID" msprop:Generator_ColumnPropNameInRow="UserDetailsID" msprop:Generator_ColumnPropNameInTable="UserDetailsIDColumn" msprop:Generator_UserColumnName="UserDetailsID" type="xs:int" />
745 <xs:element name="FirstName" msprop:Generator_ColumnVarNameInTable="columnFirstName" msprop:Generator_ColumnPropNameInRow="FirstName" msprop:Generator_ColumnPropNameInTable="FirstNameColumn" msprop:Generator_UserColumnName="FirstName" minOccurs="0">
746 <xs:simpleType>
747 <xs:restriction base="xs:string">
748 <xs:maxLength value="536870910" />
749 </xs:restriction>
750 </xs:simpleType>
751 </xs:element>
752 <xs:element name="LastName" msprop:Generator_ColumnVarNameInTable="columnLastName" msprop:Generator_ColumnPropNameInRow="LastName" msprop:Generator_ColumnPropNameInTable="LastNameColumn" msprop:Generator_UserColumnName="LastName" minOccurs="0">
753 <xs:simpleType>
754 <xs:restriction base="xs:string">
755 <xs:maxLength value="536870910" />
756 </xs:restriction>
757 </xs:simpleType>
758 </xs:element>
759 <xs:element name="AddressLine1" msprop:Generator_ColumnVarNameInTable="columnAddressLine1" msprop:Generator_ColumnPropNameInRow="AddressLine1" msprop:Generator_ColumnPropNameInTable="AddressLine1Column" msprop:Generator_UserColumnName="AddressLine1" minOccurs="0">
760 <xs:simpleType>
761 <xs:restriction base="xs:string">
762 <xs:maxLength value="536870910" />
763 </xs:restriction>
764 </xs:simpleType>
765 </xs:element>
766 <xs:element name="Town" msprop:Generator_ColumnVarNameInTable="columnTown" msprop:Generator_ColumnPropNameInRow="Town" msprop:Generator_ColumnPropNameInTable="TownColumn" msprop:Generator_UserColumnName="Town" minOccurs="0">
767 <xs:simpleType>
768 <xs:restriction base="xs:string">
769 <xs:maxLength value="255" />
770 </xs:restriction>
771 </xs:simpleType>
772 </xs:element>
773 <xs:element name="Postcode" msprop:Generator_ColumnVarNameInTable="columnPostcode" msprop:Generator_ColumnPropNameInRow="Postcode" msprop:Generator_ColumnPropNameInTable="PostcodeColumn" msprop:Generator_UserColumnName="Postcode" minOccurs="0">
774 <xs:simpleType>
775 <xs:restriction base="xs:string">
776 <xs:maxLength value="536870910" />
777 </xs:restriction>
778 </xs:simpleType>
779 </xs:element>
780 <xs:element name="CardNumber" msprop:Generator_ColumnVarNameInTable="columnCardNumber" msprop:Generator_ColumnPropNameInRow="CardNumber" msprop:Generator_ColumnPropNameInTable="CardNumberColumn" msprop:Generator_UserColumnName="CardNumber" type="xs:int" minOccurs="0" />
781 <xs:element name="CVC" msprop:Generator_ColumnVarNameInTable="columnCVC" msprop:Generator_ColumnPropNameInRow="CVC" msprop:Generator_ColumnPropNameInTable="CVCColumn" msprop:Generator_UserColumnName="CVC" type="xs:int" minOccurs="0" />
782 <xs:element name="IGN" msprop:Generator_ColumnVarNameInTable="columnIGN" msprop:Generator_ColumnPropNameInRow="IGN" msprop:Generator_ColumnPropNameInTable="IGNColumn" msprop:Generator_UserColumnName="IGN" minOccurs="0">
783 <xs:simpleType>
784 <xs:restriction base="xs:string">
785 <xs:maxLength value="536870910" />
786 </xs:restriction>
787 </xs:simpleType>
788 </xs:element>
789 <xs:element name="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnPropNameInTable="EmailColumn" msprop:Generator_UserColumnName="Email" minOccurs="0">
790 <xs:simpleType>
791 <xs:restriction base="xs:string">
792 <xs:maxLength value="536870910" />
793 </xs:restriction>
794 </xs:simpleType>
795 </xs:element>
796 <xs:element name="ProfilePic" msprop:Generator_ColumnVarNameInTable="columnProfilePic" msprop:Generator_ColumnPropNameInRow="ProfilePic" msprop:Generator_ColumnPropNameInTable="ProfilePicColumn" msprop:Generator_UserColumnName="ProfilePic" type="xs:base64Binary" minOccurs="0" />
797 </xs:sequence>
798 </xs:complexType>
799 </xs:element>
800 <xs:element name="Users" msprop:Generator_TableClassName="UsersDataTable" msprop:Generator_TableVarName="tableUsers" msprop:Generator_RowChangedName="UsersRowChanged" msprop:Generator_TablePropName="Users" msprop:Generator_RowDeletingName="UsersRowDeleting" msprop:Generator_RowChangingName="UsersRowChanging" msprop:Generator_RowEvHandlerName="UsersRowChangeEventHandler" msprop:Generator_RowDeletedName="UsersRowDeleted" msprop:Generator_RowClassName="UsersRow" msprop:Generator_UserTableName="Users" msprop:Generator_RowEvArgName="UsersRowChangeEvent">
801 <xs:complexType>
802 <xs:sequence>
803 <xs:element name="UserID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnUserID" msprop:Generator_ColumnPropNameInRow="UserID" msprop:Generator_ColumnPropNameInTable="UserIDColumn" msprop:Generator_UserColumnName="UserID" type="xs:int" />
804 <xs:element name="User_DetailsID" msprop:Generator_ColumnVarNameInTable="columnUser_DetailsID" msprop:Generator_ColumnPropNameInRow="User_DetailsID" msprop:Generator_ColumnPropNameInTable="User_DetailsIDColumn" msprop:Generator_UserColumnName="User_DetailsID" type="xs:int" minOccurs="0" />
805 <xs:element name="Username" msprop:Generator_ColumnVarNameInTable="columnUsername" msprop:Generator_ColumnPropNameInRow="Username" msprop:Generator_ColumnPropNameInTable="UsernameColumn" msprop:Generator_UserColumnName="Username" minOccurs="0">
806 <xs:simpleType>
807 <xs:restriction base="xs:string">
808 <xs:maxLength value="536870910" />
809 </xs:restriction>
810 </xs:simpleType>
811 </xs:element>
812 <xs:element name="Password" msprop:Generator_ColumnVarNameInTable="columnPassword" msprop:Generator_ColumnPropNameInRow="Password" msprop:Generator_ColumnPropNameInTable="PasswordColumn" msprop:Generator_UserColumnName="Password" minOccurs="0">
813 <xs:simpleType>
814 <xs:restriction base="xs:string">
815 <xs:maxLength value="536870910" />
816 </xs:restriction>
817 </xs:simpleType>
818 </xs:element>
819 </xs:sequence>
820 </xs:complexType>
821 </xs:element>
822 <xs:element name="Wishlist" msprop:Generator_TableClassName="WishlistDataTable" msprop:Generator_TableVarName="tableWishlist" msprop:Generator_RowChangedName="WishlistRowChanged" msprop:Generator_TablePropName="Wishlist" msprop:Generator_RowDeletingName="WishlistRowDeleting" msprop:Generator_RowChangingName="WishlistRowChanging" msprop:Generator_RowEvHandlerName="WishlistRowChangeEventHandler" msprop:Generator_RowDeletedName="WishlistRowDeleted" msprop:Generator_RowClassName="WishlistRow" msprop:Generator_UserTableName="Wishlist" msprop:Generator_RowEvArgName="WishlistRowChangeEvent">
823 <xs:complexType>
824 <xs:sequence>
825 <xs:element name="WishlistID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnWishlistID" msprop:Generator_ColumnPropNameInRow="WishlistID" msprop:Generator_ColumnPropNameInTable="WishlistIDColumn" msprop:Generator_UserColumnName="WishlistID" type="xs:int" />
826 <xs:element name="UserID" msprop:Generator_ColumnVarNameInTable="columnUserID" msprop:Generator_ColumnPropNameInRow="UserID" msprop:Generator_ColumnPropNameInTable="UserIDColumn" msprop:Generator_UserColumnName="UserID" type="xs:int" minOccurs="0" />
827 <xs:element name="GameID" msprop:Generator_ColumnVarNameInTable="columnGameID" msprop:Generator_ColumnPropNameInRow="GameID" msprop:Generator_ColumnPropNameInTable="GameIDColumn" msprop:Generator_UserColumnName="GameID" type="xs:int" minOccurs="0" />
828 </xs:sequence>
829 </xs:complexType>
830 </xs:element>
831 </xs:choice>
832 </xs:complexType>
833 <xs:unique name="Constraint1" msdata:PrimaryKey="true">
834 <xs:selector xpath=".//mstns:Achievement" />
835 <xs:field xpath="mstns:AchievementID" />
836 </xs:unique>
837 <xs:unique name="DOW_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
838 <xs:selector xpath=".//mstns:DOW" />
839 <xs:field xpath="mstns:DOWID" />
840 </xs:unique>
841 <xs:unique name="Friends_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
842 <xs:selector xpath=".//mstns:Friends" />
843 <xs:field xpath="mstns:ID" />
844 </xs:unique>
845 <xs:unique name="Games_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
846 <xs:selector xpath=".//mstns:Games" />
847 <xs:field xpath="mstns:GameID" />
848 </xs:unique>
849 <xs:unique name="Purchased_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
850 <xs:selector xpath=".//mstns:Purchased" />
851 <xs:field xpath="mstns:PurchaseID" />
852 </xs:unique>
853 <xs:unique name="Reviews_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
854 <xs:selector xpath=".//mstns:Reviews" />
855 <xs:field xpath="mstns:ReviewID" />
856 </xs:unique>
857 <xs:unique name="Tags_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
858 <xs:selector xpath=".//mstns:Tags" />
859 <xs:field xpath="mstns:ID" />
860 </xs:unique>
861 <xs:unique name="User_Details_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
862 <xs:selector xpath=".//mstns:User_Details" />
863 <xs:field xpath="mstns:UserDetailsID" />
864 </xs:unique>
865 <xs:unique name="Users_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
866 <xs:selector xpath=".//mstns:Users" />
867 <xs:field xpath="mstns:UserID" />
868 </xs:unique>
869 <xs:unique name="Wishlist_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
870 <xs:selector xpath=".//mstns:Wishlist" />
871 <xs:field xpath="mstns:WishlistID" />
872 </xs:unique>
873 </xs:element>
874 <xs:annotation>
875 <xs:appinfo>
876 <msdata:Relationship name="GamesAchievement" msdata:parent="Games" msdata:child="Achievement" msdata:parentkey="GameID" msdata:childkey="GameID" msprop:Generator_UserChildTable="Achievement" msprop:Generator_ChildPropName="GetAchievementRows" msprop:Generator_UserRelationName="GamesAchievement" msprop:Generator_ParentPropName="GamesRow" msprop:Generator_RelationVarName="relationGamesAchievement" msprop:Generator_UserParentTable="Games" />
877 <msdata:Relationship name="GamesDOW" msdata:parent="Games" msdata:child="DOW" msdata:parentkey="GameID" msdata:childkey="GameID" msprop:Generator_UserChildTable="DOW" msprop:Generator_ChildPropName="GetDOWRows" msprop:Generator_UserRelationName="GamesDOW" msprop:Generator_ParentPropName="GamesRow" msprop:Generator_RelationVarName="relationGamesDOW" msprop:Generator_UserParentTable="Games" />
878 <msdata:Relationship name="GamesPurchased" msdata:parent="Games" msdata:child="Purchased" msdata:parentkey="GameID" msdata:childkey="GameID" msprop:Generator_UserChildTable="Purchased" msprop:Generator_ChildPropName="GetPurchasedRows" msprop:Generator_UserRelationName="GamesPurchased" msprop:Generator_RelationVarName="relationGamesPurchased" msprop:Generator_UserParentTable="Games" msprop:Generator_ParentPropName="GamesRow" />
879 <msdata:Relationship name="GamesReviews" msdata:parent="Games" msdata:child="Reviews" msdata:parentkey="GameID" msdata:childkey="GameID" msprop:Generator_UserChildTable="Reviews" msprop:Generator_ChildPropName="GetReviewsRows" msprop:Generator_UserRelationName="GamesReviews" msprop:Generator_RelationVarName="relationGamesReviews" msprop:Generator_UserParentTable="Games" msprop:Generator_ParentPropName="GamesRow" />
880 <msdata:Relationship name="User_DetailsUsers" msdata:parent="User_Details" msdata:child="Users" msdata:parentkey="UserDetailsID" msdata:childkey="User_DetailsID" msprop:Generator_UserChildTable="Users" msprop:Generator_ChildPropName="GetUsersRows" msprop:Generator_UserRelationName="User_DetailsUsers" msprop:Generator_RelationVarName="relationUser_DetailsUsers" msprop:Generator_UserParentTable="User_Details" msprop:Generator_ParentPropName="User_DetailsRow" />
881 <msdata:Relationship name="GamesWishlist" msdata:parent="Games" msdata:child="Wishlist" msdata:parentkey="GameID" msdata:childkey="GameID" msprop:Generator_UserChildTable="Wishlist" msprop:Generator_ChildPropName="GetWishlistRows" msprop:Generator_UserRelationName="GamesWishlist" msprop:Generator_RelationVarName="relationGamesWishlist" msprop:Generator_UserParentTable="Games" msprop:Generator_ParentPropName="GamesRow" />
882 </xs:appinfo>
883 </xs:annotation>
884 </xs:schema>
Test