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