Read/Write pictures to Games table

[NEATEST.git] / NEA / NEADataSet.xsd

diff --git a/NEA/NEADataSet.xsd b/NEA/NEADataSet.xsd
index aae99a09d8c0eb2ad6e31d13aacda1b788910823..daef810527e63b77b50eab71f4ee7a167c39fbf2 100644 (file)
--- a/NEA/NEADataSet.xsd
+++ b/NEA/NEADataSet.xsd
@@ -2,15 +2,14 @@
 <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">
   <xs:annotation>
     <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
 <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">
   <xs:annotation>
     <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">

-      <DataSource DefaultConnectionIndex="1" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
+      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">

         <Connections>
         <Connections>

-          <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" />

           <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="NEAConnectionString2" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="NEAConnectionString2 (MySettings)" PropertyReference="ApplicationSettings.NEA.MySettings.GlobalReference.Default.NEAConnectionString2" Provider="System.Data.OleDb" />
         </Connections>
         <Tables>
           <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AchievementTableAdapter" GeneratorDataComponentClassName="AchievementTableAdapter" Name="Achievement" UserDataComponentName="AchievementTableAdapter">
             <MainSource>
           <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="NEAConnectionString2" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="NEAConnectionString2 (MySettings)" PropertyReference="ApplicationSettings.NEA.MySettings.GlobalReference.Default.NEAConnectionString2" Provider="System.Data.OleDb" />
         </Connections>
         <Tables>
           <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AchievementTableAdapter" GeneratorDataComponentClassName="AchievementTableAdapter" Name="Achievement" UserDataComponentName="AchievementTableAdapter">
             <MainSource>

-              <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">
+              <DbSource ConnectionRef="NEAConnectionString2 (MySettings)" DbObjectName="Achievement" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">

                 <DeleteCommand>
                   <DbCommand CommandType="Text" ModifiedByUser="false">
                     <CommandText>DELETE FROM `Achievement` WHERE ((`AchievementID` = ?) AND ((? = 1 AND `GameID` IS NULL) OR (`GameID` = ?)) AND ((? = 1 AND `UserID` IS NULL) OR (`UserID` = ?)))</CommandText>
                 <DeleteCommand>
                   <DbCommand CommandType="Text" ModifiedByUser="false">
                     <CommandText>DELETE FROM `Achievement` WHERE ((`AchievementID` = ?) AND ((? = 1 AND `GameID` IS NULL) OR (`GameID` = ?)) AND ((? = 1 AND `UserID` IS NULL) OR (`UserID` = ?)))</CommandText>


@@ -78,7 +77,7 @@
           </TableAdapter>
           <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DOWTableAdapter" GeneratorDataComponentClassName="DOWTableAdapter" Name="DOW" UserDataComponentName="DOWTableAdapter">
             <MainSource>
           </TableAdapter>
           <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DOWTableAdapter" GeneratorDataComponentClassName="DOWTableAdapter" Name="DOW" UserDataComponentName="DOWTableAdapter">
             <MainSource>

-              <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">
+              <DbSource ConnectionRef="NEAConnectionString2 (MySettings)" DbObjectName="DOW" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">

                 <DeleteCommand>
                   <DbCommand CommandType="Text" ModifiedByUser="false">
                     <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>
                 <DeleteCommand>
                   <DbCommand CommandType="Text" ModifiedByUser="false">
                     <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>


@@ -138,7 +137,7 @@
           </TableAdapter>
           <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="FriendsTableAdapter" GeneratorDataComponentClassName="FriendsTableAdapter" Name="Friends" UserDataComponentName="FriendsTableAdapter">
             <MainSource>
           </TableAdapter>
           <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="FriendsTableAdapter" GeneratorDataComponentClassName="FriendsTableAdapter" Name="Friends" UserDataComponentName="FriendsTableAdapter">
             <MainSource>

-              <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">
+              <DbSource ConnectionRef="NEAConnectionString2 (MySettings)" DbObjectName="Friends" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">

                 <DeleteCommand>
                   <DbCommand CommandType="Text" ModifiedByUser="false">
                     <CommandText>DELETE FROM `Friends` WHERE ((`ID` = ?) AND ((? = 1 AND `FriendID` IS NULL) OR (`FriendID` = ?)) AND ((? = 1 AND `UserID` IS NULL) OR (`UserID` = ?)))</CommandText>
                 <DeleteCommand>
                   <DbCommand CommandType="Text" ModifiedByUser="false">
                     <CommandText>DELETE FROM `Friends` WHERE ((`ID` = ?) AND ((? = 1 AND `FriendID` IS NULL) OR (`FriendID` = ?)) AND ((? = 1 AND `UserID` IS NULL) OR (`UserID` = ?)))</CommandText>


@@ -191,7 +190,7 @@
           </TableAdapter>
           <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="GamesTableAdapter" GeneratorDataComponentClassName="GamesTableAdapter" Name="Games" UserDataComponentName="GamesTableAdapter">
             <MainSource>
           </TableAdapter>
           <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="GamesTableAdapter" GeneratorDataComponentClassName="GamesTableAdapter" Name="Games" UserDataComponentName="GamesTableAdapter">
             <MainSource>

-              <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">
+              <DbSource ConnectionRef="NEAConnectionString2 (MySettings)" DbObjectName="Games" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">

                 <DeleteCommand>
                   <DbCommand CommandType="Text" ModifiedByUser="false">
                     <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>
                 <DeleteCommand>
                   <DbCommand CommandType="Text" ModifiedByUser="false">
                     <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>


@@ -210,7 +209,7 @@
                 </DeleteCommand>
                 <InsertCommand>
                   <DbCommand CommandType="Text" ModifiedByUser="false">
                 </DeleteCommand>
                 <InsertCommand>
                   <DbCommand CommandType="Text" ModifiedByUser="false">

-                    <CommandText>INSERT INTO `Games` (`Name`, `Price`, `Rating`, `Certificate`, `Dev`, `Publisher`, `Icon`, `Tags`, `Theme Colour`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
+                    <CommandText>INSERT INTO `Games` (`Name`, `Price`, `Rating`, `Certificate`, `Dev`, `Publisher`, `Tags`, `Theme Colour`, `Icon`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)</CommandText>

                     <Parameters>
                       <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" />
                       <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" />
                     <Parameters>
                       <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" />
                       <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" />


@@ -218,21 +217,21 @@
                       <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" />
                       <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" />
                       <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" />
                       <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" />
                       <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" />
                       <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" />

-                      <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" />

                       <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" />
                       <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" />
                       <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" />
                       <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" />

+                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="Icon" Precision="0" ProviderType="LongVarBinary" Scale="0" Size="0" SourceColumn="Icon" SourceColumnNullMapping="false" SourceVersion="Current" />

                     </Parameters>
                   </DbCommand>
                 </InsertCommand>
                 <SelectCommand>
                     </Parameters>
                   </DbCommand>
                 </InsertCommand>
                 <SelectCommand>

-                  <DbCommand CommandType="Text" ModifiedByUser="false">
-                    <CommandText>SELECT GameID, Name, Price, Rating, Certificate, Dev, Publisher, Icon, Tags, [Theme Colour] FROM Games</CommandText>
+                  <DbCommand CommandType="Text" ModifiedByUser="true">
+                    <CommandText>SELECT GameID, Name, Price, Rating, Certificate, Dev, Publisher, Tags, [Theme Colour], Icon FROM Games</CommandText>

                     <Parameters />
                   </DbCommand>
                 </SelectCommand>
                 <UpdateCommand>
                   <DbCommand CommandType="Text" ModifiedByUser="false">
                     <Parameters />
                   </DbCommand>
                 </SelectCommand>
                 <UpdateCommand>
                   <DbCommand CommandType="Text" ModifiedByUser="false">

-                    <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>
+                    <CommandText>UPDATE `Games` SET `Name` = ?, `Price` = ?, `Rating` = ?, `Certificate` = ?, `Dev` = ?, `Publisher` = ?, `Tags` = ?, `Theme Colour` = ?, `Icon` = ? WHERE ((`GameID` = ?) AND ((? = 1 AND `Price` IS NULL) OR (`Price` = ?)) AND ((? = 1 AND `Rating` IS NULL) OR (`Rating` = ?)) AND ((? = 1 AND `Certificate` IS NULL) OR (`Certificate` = ?)) AND ((? = 1 AND `Theme Colour` IS NULL) OR (`Theme Colour` = ?)))</CommandText>

                     <Parameters>
                       <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" />
                       <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" />
                     <Parameters>
                       <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" />
                       <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" />


@@ -240,9 +239,9 @@
                       <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" />
                       <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" />
                       <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" />
                       <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" />
                       <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" />
                       <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" />

-                      <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" />

                       <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" />
                       <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" />
                       <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" />
                       <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" />

+                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="Icon" Precision="0" ProviderType="LongVarBinary" Scale="0" Size="0" SourceColumn="Icon" SourceColumnNullMapping="false" SourceVersion="Current" />

                       <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" />
                       <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" />
                       <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" />
                       <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" />
                       <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" />
                       <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" />


@@ -265,15 +264,15 @@
               <Mapping SourceColumn="Certificate" DataSetColumn="Certificate" />
               <Mapping SourceColumn="Dev" DataSetColumn="Dev" />
               <Mapping SourceColumn="Publisher" DataSetColumn="Publisher" />
               <Mapping SourceColumn="Certificate" DataSetColumn="Certificate" />
               <Mapping SourceColumn="Dev" DataSetColumn="Dev" />
               <Mapping SourceColumn="Publisher" DataSetColumn="Publisher" />

-              <Mapping SourceColumn="Icon" DataSetColumn="Icon" />

               <Mapping SourceColumn="Tags" DataSetColumn="Tags" />
               <Mapping SourceColumn="Theme Colour" DataSetColumn="Theme Colour" />
               <Mapping SourceColumn="Tags" DataSetColumn="Tags" />
               <Mapping SourceColumn="Theme Colour" DataSetColumn="Theme Colour" />

+              <Mapping SourceColumn="Icon" DataSetColumn="Icon" />

             </Mappings>
             <Sources />
           </TableAdapter>
           <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PurchasedTableAdapter" GeneratorDataComponentClassName="PurchasedTableAdapter" Name="Purchased" UserDataComponentName="PurchasedTableAdapter">
             <MainSource>
             </Mappings>
             <Sources />
           </TableAdapter>
           <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PurchasedTableAdapter" GeneratorDataComponentClassName="PurchasedTableAdapter" Name="Purchased" UserDataComponentName="PurchasedTableAdapter">
             <MainSource>

-              <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">
+              <DbSource ConnectionRef="NEAConnectionString2 (MySettings)" DbObjectName="Purchased" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">

                 <DeleteCommand>
                   <DbCommand CommandType="Text" ModifiedByUser="false">
                     <CommandText>DELETE FROM `Purchased` WHERE ((`PurchaseID` = ?) AND ((? = 1 AND `UserID` IS NULL) OR (`UserID` = ?)) AND ((? = 1 AND `GameID` IS NULL) OR (`GameID` = ?)))</CommandText>
                 <DeleteCommand>
                   <DbCommand CommandType="Text" ModifiedByUser="false">
                     <CommandText>DELETE FROM `Purchased` WHERE ((`PurchaseID` = ?) AND ((? = 1 AND `UserID` IS NULL) OR (`UserID` = ?)) AND ((? = 1 AND `GameID` IS NULL) OR (`GameID` = ?)))</CommandText>


@@ -326,7 +325,7 @@
           </TableAdapter>
           <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ReviewsTableAdapter" GeneratorDataComponentClassName="ReviewsTableAdapter" Name="Reviews" UserDataComponentName="ReviewsTableAdapter">
             <MainSource>
           </TableAdapter>
           <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ReviewsTableAdapter" GeneratorDataComponentClassName="ReviewsTableAdapter" Name="Reviews" UserDataComponentName="ReviewsTableAdapter">
             <MainSource>

-              <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">
+              <DbSource ConnectionRef="NEAConnectionString2 (MySettings)" DbObjectName="Reviews" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">

                 <DeleteCommand>
                   <DbCommand CommandType="Text" ModifiedByUser="false">
                     <CommandText>DELETE FROM `Reviews` WHERE ((`ReviewID` = ?) AND ((? = 1 AND `GameID` IS NULL) OR (`GameID` = ?)))</CommandText>
                 <DeleteCommand>
                   <DbCommand CommandType="Text" ModifiedByUser="false">
                     <CommandText>DELETE FROM `Reviews` WHERE ((`ReviewID` = ?) AND ((? = 1 AND `GameID` IS NULL) OR (`GameID` = ?)))</CommandText>


@@ -375,7 +374,7 @@
           </TableAdapter>
           <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TagsTableAdapter" GeneratorDataComponentClassName="TagsTableAdapter" Name="Tags" UserDataComponentName="TagsTableAdapter">
             <MainSource>
           </TableAdapter>
           <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TagsTableAdapter" GeneratorDataComponentClassName="TagsTableAdapter" Name="Tags" UserDataComponentName="TagsTableAdapter">
             <MainSource>

-              <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">
+              <DbSource ConnectionRef="NEAConnectionString2 (MySettings)" DbObjectName="Tags" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">

                 <DeleteCommand>
                   <DbCommand CommandType="Text" ModifiedByUser="false">
                     <CommandText>DELETE FROM `Tags` WHERE ((`ID` = ?))</CommandText>
                 <DeleteCommand>
                   <DbCommand CommandType="Text" ModifiedByUser="false">
                     <CommandText>DELETE FROM `Tags` WHERE ((`ID` = ?))</CommandText>


@@ -411,56 +410,84 @@
             </Mappings>
             <Sources />
           </TableAdapter>
             </Mappings>
             <Sources />
           </TableAdapter>

-          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="WishlistTableAdapter" GeneratorDataComponentClassName="WishlistTableAdapter" Name="Wishlist" UserDataComponentName="WishlistTableAdapter">
+          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="User_DetailsTableAdapter" GeneratorDataComponentClassName="User_DetailsTableAdapter" Name="User_Details" UserDataComponentName="User_DetailsTableAdapter">

             <MainSource>
             <MainSource>

-              <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">
+              <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">

                 <DeleteCommand>
                   <DbCommand CommandType="Text" ModifiedByUser="false">
                 <DeleteCommand>
                   <DbCommand CommandType="Text" ModifiedByUser="false">

-                    <CommandText>DELETE FROM `Wishlist` WHERE ((`WishlistID` = ?) AND ((? = 1 AND `UserID` IS NULL) OR (`UserID` = ?)) AND ((? = 1 AND `GameID` IS NULL) OR (`GameID` = ?)))</CommandText>
+                    <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>

                     <Parameters>
                     <Parameters>

-                      <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" />
-                      <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" />
-                      <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" />
-                      <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" />
-                      <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" />
+                      <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" />
+                      <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" />
+                      <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" />
+                      <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" />
+                      <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" />
+                      <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" />
+                      <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" />

                     </Parameters>
                   </DbCommand>
                 </DeleteCommand>
                 <InsertCommand>
                   <DbCommand CommandType="Text" ModifiedByUser="false">
                     </Parameters>
                   </DbCommand>
                 </DeleteCommand>
                 <InsertCommand>
                   <DbCommand CommandType="Text" ModifiedByUser="false">

-                    <CommandText>INSERT INTO `Wishlist` (`UserID`, `GameID`) VALUES (?, ?)</CommandText>
+                    <CommandText>INSERT INTO `User_Details` (`FirstName`, `LastName`, `AddressLine1`, `Town`, `Postcode`, `CardNumber`, `CVC`, `IGN`, `Email`, `ProfilePic`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)</CommandText>

                     <Parameters>
                     <Parameters>

-                      <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" />
-                      <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" />
+                      <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" />
+                      <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" />
+                      <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" />
+                      <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" />
+                      <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" />
+                      <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" />
+                      <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" />
+                      <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" />
+                      <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" />
+                      <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" />

                     </Parameters>
                   </DbCommand>
                 </InsertCommand>
                 <SelectCommand>
                     </Parameters>
                   </DbCommand>
                 </InsertCommand>
                 <SelectCommand>

-                  <DbCommand CommandType="Text" ModifiedByUser="false">
-                    <CommandText>SELECT WishlistID, UserID, GameID FROM Wishlist</CommandText>
+                  <DbCommand CommandType="Text" ModifiedByUser="true">
+                    <CommandText>SELECT UserDetailsID, FirstName, LastName, AddressLine1, Town, Postcode, CardNumber, CVC, IGN, Email, ProfilePic FROM User_Details</CommandText>

                     <Parameters />
                   </DbCommand>
                 </SelectCommand>
                 <UpdateCommand>
                   <DbCommand CommandType="Text" ModifiedByUser="false">
                     <Parameters />
                   </DbCommand>
                 </SelectCommand>
                 <UpdateCommand>
                   <DbCommand CommandType="Text" ModifiedByUser="false">

-                    <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>
+                    <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>

                     <Parameters>
                     <Parameters>

-                      <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" />
-                      <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" />
-                      <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" />
-                      <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" />
-                      <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" />
-                      <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" />
-                      <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" />
+                      <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" />
+                      <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" />
+                      <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" />
+                      <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" />
+                      <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" />
+                      <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" />
+                      <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" />
+                      <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" />
+                      <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" />
+                      <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" />
+                      <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" />
+                      <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" />
+                      <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" />
+                      <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" />
+                      <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" />
+                      <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" />
+                      <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" />

                     </Parameters>
                   </DbCommand>
                 </UpdateCommand>
               </DbSource>
             </MainSource>
             <Mappings>
                     </Parameters>
                   </DbCommand>
                 </UpdateCommand>
               </DbSource>
             </MainSource>
             <Mappings>

-              <Mapping SourceColumn="WishlistID" DataSetColumn="WishlistID" />
-              <Mapping SourceColumn="UserID" DataSetColumn="UserID" />
-              <Mapping SourceColumn="GameID" DataSetColumn="GameID" />
+              <Mapping SourceColumn="UserDetailsID" DataSetColumn="UserDetailsID" />
+              <Mapping SourceColumn="FirstName" DataSetColumn="FirstName" />
+              <Mapping SourceColumn="LastName" DataSetColumn="LastName" />
+              <Mapping SourceColumn="AddressLine1" DataSetColumn="AddressLine1" />
+              <Mapping SourceColumn="Town" DataSetColumn="Town" />
+              <Mapping SourceColumn="Postcode" DataSetColumn="Postcode" />
+              <Mapping SourceColumn="CardNumber" DataSetColumn="CardNumber" />
+              <Mapping SourceColumn="CVC" DataSetColumn="CVC" />
+              <Mapping SourceColumn="IGN" DataSetColumn="IGN" />
+              <Mapping SourceColumn="Email" DataSetColumn="Email" />
+              <Mapping SourceColumn="ProfilePic" DataSetColumn="ProfilePic" />

             </Mappings>
             <Sources />
           </TableAdapter>
             </Mappings>
             <Sources />
           </TableAdapter>


@@ -488,9 +515,8 @@
                   </DbCommand>
                 </InsertCommand>
                 <SelectCommand>
                   </DbCommand>
                 </InsertCommand>
                 <SelectCommand>

-                  <DbCommand CommandType="Text" ModifiedByUser="true">
-                    <CommandText>SELECT        Users.*
-FROM            Users</CommandText>
+                  <DbCommand CommandType="Text" ModifiedByUser="false">
+                    <CommandText>SELECT UserID, User_DetailsID, Username, [Password] FROM Users</CommandText>

                     <Parameters />
                   </DbCommand>
                 </SelectCommand>
                     <Parameters />
                   </DbCommand>
                 </SelectCommand>


@@ -517,107 +543,58 @@ FROM            Users</CommandText>
             </Mappings>
             <Sources />
           </TableAdapter>
             </Mappings>
             <Sources />
           </TableAdapter>

-          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="User_DetailsTableAdapter" GeneratorDataComponentClassName="User_DetailsTableAdapter" Name="User_Details" UserDataComponentName="User_DetailsTableAdapter">
+          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="WishlistTableAdapter" GeneratorDataComponentClassName="WishlistTableAdapter" Name="Wishlist" UserDataComponentName="WishlistTableAdapter">

             <MainSource>
             <MainSource>

-              <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">
+              <DbSource ConnectionRef="NEAConnectionString2 (MySettings)" DbObjectName="Wishlist" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">

                 <DeleteCommand>
                   <DbCommand CommandType="Text" ModifiedByUser="false">
                 <DeleteCommand>
                   <DbCommand CommandType="Text" ModifiedByUser="false">

-                    <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>
+                    <CommandText>DELETE FROM `Wishlist` WHERE ((`WishlistID` = ?) AND ((? = 1 AND `UserID` IS NULL) OR (`UserID` = ?)) AND ((? = 1 AND `GameID` IS NULL) OR (`GameID` = ?)))</CommandText>

                     <Parameters>
                     <Parameters>

-                      <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" />
-                      <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" />
-                      <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" />
-                      <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" />
-                      <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" />
-                      <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" />
-                      <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" />
+                      <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" />
+                      <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" />
+                      <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" />
+                      <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" />
+                      <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" />

                     </Parameters>
                   </DbCommand>
                 </DeleteCommand>
                 <InsertCommand>
                   <DbCommand CommandType="Text" ModifiedByUser="false">
                     </Parameters>
                   </DbCommand>
                 </DeleteCommand>
                 <InsertCommand>
                   <DbCommand CommandType="Text" ModifiedByUser="false">

-                    <CommandText>INSERT INTO `User_Details` (`FirstName`, `LastName`, `AddressLine1`, `Town`, `Postcode`, `CardNumber`, `CVC`, `IGN`, `Email`, `ProfilePic`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
+                    <CommandText>INSERT INTO `Wishlist` (`UserID`, `GameID`) VALUES (?, ?)</CommandText>

                     <Parameters>
                     <Parameters>

-                      <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" />
-                      <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" />
-                      <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" />
-                      <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" />
-                      <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" />
-                      <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" />
-                      <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" />
-                      <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" />
-                      <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" />
-                      <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" />
+                      <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" />
+                      <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" />

                     </Parameters>
                   </DbCommand>
                 </InsertCommand>
                 <SelectCommand>
                     </Parameters>
                   </DbCommand>
                 </InsertCommand>
                 <SelectCommand>

-                  <DbCommand CommandType="Text" ModifiedByUser="true">
-                    <CommandText>SELECT        User_Details.*
-FROM            User_Details</CommandText>
+                  <DbCommand CommandType="Text" ModifiedByUser="false">
+                    <CommandText>SELECT WishlistID, UserID, GameID FROM Wishlist</CommandText>

                     <Parameters />
                   </DbCommand>
                 </SelectCommand>
                 <UpdateCommand>
                   <DbCommand CommandType="Text" ModifiedByUser="false">
                     <Parameters />
                   </DbCommand>
                 </SelectCommand>
                 <UpdateCommand>
                   <DbCommand CommandType="Text" ModifiedByUser="false">

-                    <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>
+                    <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>

                     <Parameters>
                     <Parameters>

-                      <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" />
-                      <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" />
-                      <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" />
-                      <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" />
-                      <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" />
-                      <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" />
-                      <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" />
-                      <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" />
-                      <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" />
-                      <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" />
-                      <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" />
-                      <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" />
-                      <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" />
-                      <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" />
-                      <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" />
-                      <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" />
-                      <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" />
+                      <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" />
+                      <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" />
+                      <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" />
+                      <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" />
+                      <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" />
+                      <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" />
+                      <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" />

                     </Parameters>
                   </DbCommand>
                 </UpdateCommand>
               </DbSource>
             </MainSource>
             <Mappings>
                     </Parameters>
                   </DbCommand>
                 </UpdateCommand>
               </DbSource>
             </MainSource>
             <Mappings>

-              <Mapping SourceColumn="UserDetailsID" DataSetColumn="UserDetailsID" />
-              <Mapping SourceColumn="FirstName" DataSetColumn="FirstName" />
-              <Mapping SourceColumn="LastName" DataSetColumn="LastName" />
-              <Mapping SourceColumn="AddressLine1" DataSetColumn="AddressLine1" />
-              <Mapping SourceColumn="Town" DataSetColumn="Town" />
-              <Mapping SourceColumn="Postcode" DataSetColumn="Postcode" />
-              <Mapping SourceColumn="CardNumber" DataSetColumn="CardNumber" />
-              <Mapping SourceColumn="CVC" DataSetColumn="CVC" />
-              <Mapping SourceColumn="IGN" DataSetColumn="IGN" />
-              <Mapping SourceColumn="Email" DataSetColumn="Email" />
-              <Mapping SourceColumn="ProfilePic" DataSetColumn="ProfilePic" />
+              <Mapping SourceColumn="WishlistID" DataSetColumn="WishlistID" />
+              <Mapping SourceColumn="UserID" DataSetColumn="UserID" />
+              <Mapping SourceColumn="GameID" DataSetColumn="GameID" />

             </Mappings>
             </Mappings>

-            <Sources>
-              <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">
-                <InsertCommand>
-                  <DbCommand CommandType="Text" ModifiedByUser="true">
-                    <CommandText>INSERT INTO `User_Details` (`FirstName`, `LastName`, `AddressLine1`, `Town`, `Postcode`, `CardNumber`, `CVC`, `IGN`, `Email`, `ProfilePic`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
-                    <Parameters>
-                      <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" />
-                      <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" />
-                      <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" />
-                      <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" />
-                      <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" />
-                      <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" />
-                      <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" />
-                      <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" />
-                      <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" />
-                      <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" />
-                    </Parameters>
-                  </DbCommand>
-                </InsertCommand>
-              </DbSource>
-            </Sources>
+            <Sources />

           </TableAdapter>
         </Tables>
         <Sources />
           </TableAdapter>
         </Tables>
         <Sources />


@@ -627,7 +604,7 @@ FROM            User_Details</CommandText>
   <xs:element name="NEADataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="NEADataSet" msprop:Generator_UserDSName="NEADataSet">
     <xs:complexType>
       <xs:choice minOccurs="0" maxOccurs="unbounded">
   <xs:element name="NEADataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="NEADataSet" msprop:Generator_UserDSName="NEADataSet">
     <xs:complexType>
       <xs:choice minOccurs="0" maxOccurs="unbounded">

-        <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">
+        <xs:element name="Achievement" msprop:Generator_TableClassName="AchievementDataTable" msprop:Generator_TableVarName="tableAchievement" msprop:Generator_RowChangedName="AchievementRowChanged" msprop:Generator_TablePropName="Achievement" msprop:Generator_RowDeletingName="AchievementRowDeleting" msprop:Generator_RowChangingName="AchievementRowChanging" msprop:Generator_RowEvHandlerName="AchievementRowChangeEventHandler" msprop:Generator_RowDeletedName="AchievementRowDeleted" msprop:Generator_RowClassName="AchievementRow" msprop:Generator_UserTableName="Achievement" msprop:Generator_RowEvArgName="AchievementRowChangeEvent">

           <xs:complexType>
             <xs:sequence>
               <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" />
           <xs:complexType>
             <xs:sequence>
               <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" />


@@ -671,7 +648,7 @@ FROM            User_Details</CommandText>
             </xs:sequence>
           </xs:complexType>
         </xs:element>
             </xs:sequence>
           </xs:complexType>
         </xs:element>

-        <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">
+        <xs:element name="DOW" msprop:Generator_TableClassName="DOWDataTable" msprop:Generator_TableVarName="tableDOW" msprop:Generator_RowChangedName="DOWRowChanged" msprop:Generator_TablePropName="DOW" msprop:Generator_RowDeletingName="DOWRowDeleting" msprop:Generator_RowChangingName="DOWRowChanging" msprop:Generator_RowEvHandlerName="DOWRowChangeEventHandler" msprop:Generator_RowDeletedName="DOWRowDeleted" msprop:Generator_RowClassName="DOWRow" msprop:Generator_UserTableName="DOW" msprop:Generator_RowEvArgName="DOWRowChangeEvent">

           <xs:complexType>
             <xs:sequence>
               <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" />
           <xs:complexType>
             <xs:sequence>
               <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" />


@@ -681,7 +658,7 @@ FROM            User_Details</CommandText>
             </xs:sequence>
           </xs:complexType>
         </xs:element>
             </xs:sequence>
           </xs:complexType>
         </xs:element>

-        <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">
+        <xs:element name="Friends" msprop:Generator_TableClassName="FriendsDataTable" msprop:Generator_TableVarName="tableFriends" msprop:Generator_RowChangedName="FriendsRowChanged" msprop:Generator_TablePropName="Friends" msprop:Generator_RowDeletingName="FriendsRowDeleting" msprop:Generator_RowChangingName="FriendsRowChanging" msprop:Generator_RowEvHandlerName="FriendsRowChangeEventHandler" msprop:Generator_RowDeletedName="FriendsRowDeleted" msprop:Generator_RowClassName="FriendsRow" msprop:Generator_UserTableName="Friends" msprop:Generator_RowEvArgName="FriendsRowChangeEvent">

           <xs:complexType>
             <xs:sequence>
               <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" />
           <xs:complexType>
             <xs:sequence>
               <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" />


@@ -690,7 +667,7 @@ FROM            User_Details</CommandText>
             </xs:sequence>
           </xs:complexType>
         </xs:element>
             </xs:sequence>
           </xs:complexType>
         </xs:element>

-        <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">
+        <xs:element name="Games" msprop:Generator_TableClassName="GamesDataTable" msprop:Generator_TableVarName="tableGames" msprop:Generator_RowChangedName="GamesRowChanged" msprop:Generator_TablePropName="Games" msprop:Generator_RowDeletingName="GamesRowDeleting" msprop:Generator_RowChangingName="GamesRowChanging" msprop:Generator_RowEvHandlerName="GamesRowChangeEventHandler" msprop:Generator_RowDeletedName="GamesRowDeleted" msprop:Generator_RowClassName="GamesRow" msprop:Generator_UserTableName="Games" msprop:Generator_RowEvArgName="GamesRowChangeEvent">

           <xs:complexType>
             <xs:sequence>
               <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" />
           <xs:complexType>
             <xs:sequence>
               <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" />


@@ -718,13 +695,6 @@ FROM            User_Details</CommandText>
                   </xs:restriction>
                 </xs:simpleType>
               </xs:element>
                   </xs:restriction>
                 </xs:simpleType>
               </xs:element>

-              <xs:element name="Icon" msprop:Generator_ColumnVarNameInTable="columnIcon" msprop:Generator_ColumnPropNameInRow="Icon" msprop:Generator_ColumnPropNameInTable="IconColumn" msprop:Generator_UserColumnName="Icon" minOccurs="0">
-                <xs:simpleType>
-                  <xs:restriction base="xs:string">
-                    <xs:maxLength value="536870910" />
-                  </xs:restriction>
-                </xs:simpleType>
-              </xs:element>

               <xs:element name="Tags" msprop:Generator_ColumnVarNameInTable="columnTags" msprop:Generator_ColumnPropNameInRow="Tags" msprop:Generator_ColumnPropNameInTable="TagsColumn" msprop:Generator_UserColumnName="Tags" minOccurs="0">
                 <xs:simpleType>
                   <xs:restriction base="xs:string">
               <xs:element name="Tags" msprop:Generator_ColumnVarNameInTable="columnTags" msprop:Generator_ColumnPropNameInRow="Tags" msprop:Generator_ColumnPropNameInTable="TagsColumn" msprop:Generator_UserColumnName="Tags" minOccurs="0">
                 <xs:simpleType>
                   <xs:restriction base="xs:string">


@@ -733,10 +703,11 @@ FROM            User_Details</CommandText>
                 </xs:simpleType>
               </xs:element>
               <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" />
                 </xs:simpleType>
               </xs:element>
               <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" />

+              <xs:element name="Icon" msprop:Generator_ColumnVarNameInTable="columnIcon" msprop:Generator_ColumnPropNameInRow="Icon" msprop:Generator_ColumnPropNameInTable="IconColumn" msprop:Generator_UserColumnName="Icon" type="xs:base64Binary" minOccurs="0" />

             </xs:sequence>
           </xs:complexType>
         </xs:element>
             </xs:sequence>
           </xs:complexType>
         </xs:element>

-        <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">
+        <xs:element name="Purchased" msprop:Generator_TableClassName="PurchasedDataTable" msprop:Generator_TableVarName="tablePurchased" msprop:Generator_RowChangedName="PurchasedRowChanged" msprop:Generator_TablePropName="Purchased" msprop:Generator_RowDeletingName="PurchasedRowDeleting" msprop:Generator_RowChangingName="PurchasedRowChanging" msprop:Generator_RowEvHandlerName="PurchasedRowChangeEventHandler" msprop:Generator_RowDeletedName="PurchasedRowDeleted" msprop:Generator_RowClassName="PurchasedRow" msprop:Generator_UserTableName="Purchased" msprop:Generator_RowEvArgName="PurchasedRowChangeEvent">

           <xs:complexType>
             <xs:sequence>
               <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" />
           <xs:complexType>
             <xs:sequence>
               <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" />


@@ -745,7 +716,7 @@ FROM            User_Details</CommandText>
             </xs:sequence>
           </xs:complexType>
         </xs:element>
             </xs:sequence>
           </xs:complexType>
         </xs:element>

-        <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">
+        <xs:element name="Reviews" msprop:Generator_TableClassName="ReviewsDataTable" msprop:Generator_TableVarName="tableReviews" msprop:Generator_RowChangedName="ReviewsRowChanged" msprop:Generator_TablePropName="Reviews" msprop:Generator_RowDeletingName="ReviewsRowDeleting" msprop:Generator_RowChangingName="ReviewsRowChanging" msprop:Generator_RowEvHandlerName="ReviewsRowChangeEventHandler" msprop:Generator_RowDeletedName="ReviewsRowDeleted" msprop:Generator_RowClassName="ReviewsRow" msprop:Generator_UserTableName="Reviews" msprop:Generator_RowEvArgName="ReviewsRowChangeEvent">

           <xs:complexType>
             <xs:sequence>
               <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" />
           <xs:complexType>
             <xs:sequence>
               <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" />


@@ -760,45 +731,14 @@ FROM            User_Details</CommandText>
             </xs:sequence>
           </xs:complexType>
         </xs:element>
             </xs:sequence>
           </xs:complexType>
         </xs:element>

-        <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">
+        <xs:element name="Tags" msprop:Generator_TableClassName="TagsDataTable" msprop:Generator_TableVarName="tableTags" msprop:Generator_RowChangedName="TagsRowChanged" msprop:Generator_TablePropName="Tags" msprop:Generator_RowDeletingName="TagsRowDeleting" msprop:Generator_RowChangingName="TagsRowChanging" msprop:Generator_RowEvHandlerName="TagsRowChangeEventHandler" msprop:Generator_RowDeletedName="TagsRowDeleted" msprop:Generator_RowClassName="TagsRow" msprop:Generator_UserTableName="Tags" msprop:Generator_RowEvArgName="TagsRowChangeEvent">

           <xs:complexType>
             <xs:sequence>
               <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" />
             </xs:sequence>
           </xs:complexType>
         </xs:element>
           <xs:complexType>
             <xs:sequence>
               <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" />
             </xs:sequence>
           </xs:complexType>
         </xs:element>

-        <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">
-          <xs:complexType>
-            <xs:sequence>
-              <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" />
-              <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" />
-              <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" />
-            </xs:sequence>
-          </xs:complexType>
-        </xs:element>
-        <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">
-          <xs:complexType>
-            <xs:sequence>
-              <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" />
-              <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" />
-              <xs:element name="Username" msprop:Generator_ColumnVarNameInTable="columnUsername" msprop:Generator_ColumnPropNameInRow="Username" msprop:Generator_ColumnPropNameInTable="UsernameColumn" msprop:Generator_UserColumnName="Username" minOccurs="0">
-                <xs:simpleType>
-                  <xs:restriction base="xs:string">
-                    <xs:maxLength value="536870910" />
-                  </xs:restriction>
-                </xs:simpleType>
-              </xs:element>
-              <xs:element name="Password" msprop:Generator_ColumnVarNameInTable="columnPassword" msprop:Generator_ColumnPropNameInRow="Password" msprop:Generator_ColumnPropNameInTable="PasswordColumn" msprop:Generator_UserColumnName="Password" minOccurs="0">
-                <xs:simpleType>
-                  <xs:restriction base="xs:string">
-                    <xs:maxLength value="536870910" />
-                  </xs:restriction>
-                </xs:simpleType>
-              </xs:element>
-            </xs:sequence>
-          </xs:complexType>
-        </xs:element>
-        <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">
+        <xs:element name="User_Details" msprop:Generator_TableClassName="User_DetailsDataTable" msprop:Generator_TableVarName="tableUser_Details" msprop:Generator_RowChangedName="User_DetailsRowChanged" msprop:Generator_TablePropName="User_Details" msprop:Generator_RowDeletingName="User_DetailsRowDeleting" msprop:Generator_RowChangingName="User_DetailsRowChanging" msprop:Generator_RowEvHandlerName="User_DetailsRowChangeEventHandler" msprop:Generator_RowDeletedName="User_DetailsRowDeleted" msprop:Generator_RowClassName="User_DetailsRow" msprop:Generator_UserTableName="User_Details" msprop:Generator_RowEvArgName="User_DetailsRowChangeEvent">

           <xs:complexType>
             <xs:sequence>
               <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" />
           <xs:complexType>
             <xs:sequence>
               <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" />


@@ -857,6 +797,37 @@ FROM            User_Details</CommandText>
             </xs:sequence>
           </xs:complexType>
         </xs:element>
             </xs:sequence>
           </xs:complexType>
         </xs:element>

+        <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">
+          <xs:complexType>
+            <xs:sequence>
+              <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" />
+              <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" />
+              <xs:element name="Username" msprop:Generator_ColumnVarNameInTable="columnUsername" msprop:Generator_ColumnPropNameInRow="Username" msprop:Generator_ColumnPropNameInTable="UsernameColumn" msprop:Generator_UserColumnName="Username" minOccurs="0">
+                <xs:simpleType>
+                  <xs:restriction base="xs:string">
+                    <xs:maxLength value="536870910" />
+                  </xs:restriction>
+                </xs:simpleType>
+              </xs:element>
+              <xs:element name="Password" msprop:Generator_ColumnVarNameInTable="columnPassword" msprop:Generator_ColumnPropNameInRow="Password" msprop:Generator_ColumnPropNameInTable="PasswordColumn" msprop:Generator_UserColumnName="Password" minOccurs="0">
+                <xs:simpleType>
+                  <xs:restriction base="xs:string">
+                    <xs:maxLength value="536870910" />
+                  </xs:restriction>
+                </xs:simpleType>
+              </xs:element>
+            </xs:sequence>
+          </xs:complexType>
+        </xs:element>
+        <xs:element name="Wishlist" msprop:Generator_TableClassName="WishlistDataTable" msprop:Generator_TableVarName="tableWishlist" msprop:Generator_RowChangedName="WishlistRowChanged" msprop:Generator_TablePropName="Wishlist" msprop:Generator_RowDeletingName="WishlistRowDeleting" msprop:Generator_RowChangingName="WishlistRowChanging" msprop:Generator_RowEvHandlerName="WishlistRowChangeEventHandler" msprop:Generator_RowDeletedName="WishlistRowDeleted" msprop:Generator_RowClassName="WishlistRow" msprop:Generator_UserTableName="Wishlist" msprop:Generator_RowEvArgName="WishlistRowChangeEvent">
+          <xs:complexType>
+            <xs:sequence>
+              <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" />
+              <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" />
+              <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" />
+            </xs:sequence>
+          </xs:complexType>
+        </xs:element>

       </xs:choice>
     </xs:complexType>
     <xs:unique name="Constraint1" msdata:PrimaryKey="true">
       </xs:choice>
     </xs:complexType>
     <xs:unique name="Constraint1" msdata:PrimaryKey="true">


@@ -887,27 +858,27 @@ FROM            User_Details</CommandText>
       <xs:selector xpath=".//mstns:Tags" />
       <xs:field xpath="mstns:ID" />
     </xs:unique>
       <xs:selector xpath=".//mstns:Tags" />
       <xs:field xpath="mstns:ID" />
     </xs:unique>

-    <xs:unique name="Wishlist_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
-      <xs:selector xpath=".//mstns:Wishlist" />
-      <xs:field xpath="mstns:WishlistID" />
+    <xs:unique name="User_Details_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
+      <xs:selector xpath=".//mstns:User_Details" />
+      <xs:field xpath="mstns:UserDetailsID" />

     </xs:unique>
     <xs:unique name="Users_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
       <xs:selector xpath=".//mstns:Users" />
       <xs:field xpath="mstns:UserID" />
     </xs:unique>
     </xs:unique>
     <xs:unique name="Users_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
       <xs:selector xpath=".//mstns:Users" />
       <xs:field xpath="mstns:UserID" />
     </xs:unique>

-    <xs:unique name="User_Details_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
-      <xs:selector xpath=".//mstns:User_Details" />
-      <xs:field xpath="mstns:UserDetailsID" />
+    <xs:unique name="Wishlist_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
+      <xs:selector xpath=".//mstns:Wishlist" />
+      <xs:field xpath="mstns:WishlistID" />

     </xs:unique>
   </xs:element>
   <xs:annotation>
     <xs:appinfo>
     </xs:unique>
   </xs:element>
   <xs:annotation>
     <xs:appinfo>

-      <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" />
-      <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" />
-      <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" />
-      <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" />
-      <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" />
+      <msdata:Relationship name="GamesAchievement" msdata:parent="Games" msdata:child="Achievement" msdata:parentkey="GameID" msdata:childkey="GameID" msprop:Generator_UserChildTable="Achievement" msprop:Generator_ChildPropName="GetAchievementRows" msprop:Generator_UserRelationName="GamesAchievement" msprop:Generator_ParentPropName="GamesRow" msprop:Generator_RelationVarName="relationGamesAchievement" msprop:Generator_UserParentTable="Games" />
+      <msdata:Relationship name="GamesDOW" msdata:parent="Games" msdata:child="DOW" msdata:parentkey="GameID" msdata:childkey="GameID" msprop:Generator_UserChildTable="DOW" msprop:Generator_ChildPropName="GetDOWRows" msprop:Generator_UserRelationName="GamesDOW" msprop:Generator_ParentPropName="GamesRow" msprop:Generator_RelationVarName="relationGamesDOW" msprop:Generator_UserParentTable="Games" />
+      <msdata:Relationship name="GamesPurchased" msdata:parent="Games" msdata:child="Purchased" msdata:parentkey="GameID" msdata:childkey="GameID" msprop:Generator_UserChildTable="Purchased" msprop:Generator_ChildPropName="GetPurchasedRows" msprop:Generator_UserRelationName="GamesPurchased" msprop:Generator_RelationVarName="relationGamesPurchased" msprop:Generator_UserParentTable="Games" msprop:Generator_ParentPropName="GamesRow" />
+      <msdata:Relationship name="GamesReviews" msdata:parent="Games" msdata:child="Reviews" msdata:parentkey="GameID" msdata:childkey="GameID" msprop:Generator_UserChildTable="Reviews" msprop:Generator_ChildPropName="GetReviewsRows" msprop:Generator_UserRelationName="GamesReviews" msprop:Generator_RelationVarName="relationGamesReviews" msprop:Generator_UserParentTable="Games" msprop:Generator_ParentPropName="GamesRow" />

       <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" />
       <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" />

+      <msdata:Relationship name="GamesWishlist" msdata:parent="Games" msdata:child="Wishlist" msdata:parentkey="GameID" msdata:childkey="GameID" msprop:Generator_UserChildTable="Wishlist" msprop:Generator_ChildPropName="GetWishlistRows" msprop:Generator_UserRelationName="GamesWishlist" msprop:Generator_RelationVarName="relationGamesWishlist" msprop:Generator_UserParentTable="Games" msprop:Generator_ParentPropName="GamesRow" />

     </xs:appinfo>
   </xs:annotation>
 </xs:schema>
\ No newline at end of file
     </xs:appinfo>
   </xs:annotation>
 </xs:schema>
\ No newline at end of file