]> fbox.kageds.com Git - NEATEST.git/blobdiff - NEA/NEADataSet.xsd
projects / NEATEST.git / blobdiff
? search:
summary | shortlog | log | commit | commitdiff | tree
raw | inline | side by side
Profile Pic saved to OLE Object working
[NEATEST.git] / NEA / NEADataSet.xsd
diff --git a/NEA/NEADataSet.xsd b/NEA/NEADataSet.xsd
index 27dfc0661927113b76025b89f22f1cb20ea28f9d..aae99a09d8c0eb2ad6e31d13aacda1b788910823 100644 (file)
--- a/NEA/NEADataSet.xsd
+++ b/NEA/NEADataSet.xsd
@@ -2,9 +2,10 @@
 <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="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="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">
         <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" />
         <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">
         </Connections>
         <Tables>
           <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AchievementTableAdapter" GeneratorDataComponentClassName="AchievementTableAdapter" Name="Achievement" UserDataComponentName="AchievementTableAdapter">
@@ -410,90 +411,62 @@
             </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="NEAConnectionString_accdb (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="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">
                 <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="String" Direction="Input" ParameterName="ProfilePic" Precision="0" ProviderType="LongVarWChar" 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>
                   <DbCommand CommandType="Text" ModifiedByUser="false">
                     </Parameters>
                   </DbCommand>
                 </InsertCommand>
                 <SelectCommand>
                   <DbCommand CommandType="Text" ModifiedByUser="false">
-                    <CommandText>SELECT UserDetailsID, FirstName, LastName, AddressLine1, Town, Postcode, CardNumber, CVC, IGN, Email, ProfilePic FROM User_Details</CommandText>
+                    <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="String" Direction="Input" ParameterName="ProfilePic" Precision="0" ProviderType="LongVarWChar" 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>
             <Sources />
           </TableAdapter>
           <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UsersTableAdapter" GeneratorDataComponentClassName="UsersTableAdapter" Name="Users" UserDataComponentName="UsersTableAdapter">
             <MainSource>
             </Mappings>
             <Sources />
           </TableAdapter>
           <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UsersTableAdapter" GeneratorDataComponentClassName="UsersTableAdapter" Name="Users" UserDataComponentName="UsersTableAdapter">
             <MainSource>
-              <DbSource ConnectionRef="NEAConnectionString_accdb (MySettings)" DbObjectName="Users" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
+              <DbSource ConnectionRef="NEAConnectionString2 (MySettings)" DbObjectName="Users" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                 <DeleteCommand>
                   <DbCommand CommandType="Text" ModifiedByUser="false">
                     <CommandText>DELETE FROM `Users` WHERE ((`UserID` = ?) AND ((? = 1 AND `User_DetailsID` IS NULL) OR (`User_DetailsID` = ?)))</CommandText>
                 <DeleteCommand>
                   <DbCommand CommandType="Text" ModifiedByUser="false">
                     <CommandText>DELETE FROM `Users` WHERE ((`UserID` = ?) AND ((? = 1 AND `User_DetailsID` IS NULL) OR (`User_DetailsID` = ?)))</CommandText>
@@ -515,8 +488,9 @@
                   </DbCommand>
                 </InsertCommand>
                 <SelectCommand>
                   </DbCommand>
                 </InsertCommand>
                 <SelectCommand>
-                  <DbCommand CommandType="Text" ModifiedByUser="false">
-                    <CommandText>SELECT UserID, User_DetailsID, Username, [Password] FROM Users</CommandText>
+                  <DbCommand CommandType="Text" ModifiedByUser="true">
+                    <CommandText>SELECT        Users.*
+FROM            Users</CommandText>
                     <Parameters />
                   </DbCommand>
                 </SelectCommand>
                     <Parameters />
                   </DbCommand>
                 </SelectCommand>
@@ -543,58 +517,107 @@
             </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        User_Details.*
+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>
             </Mappings>
-            <Sources />
+            <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>
           </TableAdapter>
         </Tables>
         <Sources />
           </TableAdapter>
         </Tables>
         <Sources />
@@ -744,99 +767,93 @@
             </xs:sequence>
           </xs:complexType>
         </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="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: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:element name="FirstName" msprop:Generator_ColumnVarNameInTable="columnFirstName" msprop:Generator_ColumnPropNameInRow="FirstName" msprop:Generator_ColumnPropNameInTable="FirstNameColumn" msprop:Generator_UserColumnName="FirstName" minOccurs="0">
+              <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:simpleType>
                   <xs:restriction base="xs:string">
                     <xs:maxLength value="536870910" />
                   </xs:restriction>
                 </xs:simpleType>
               </xs:element>
-              <xs:element name="LastName" msprop:Generator_ColumnVarNameInTable="columnLastName" msprop:Generator_ColumnPropNameInRow="LastName" msprop:Generator_ColumnPropNameInTable="LastNameColumn" msprop:Generator_UserColumnName="LastName" minOccurs="0">
+              <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:simpleType>
                   <xs:restriction base="xs:string">
                     <xs:maxLength value="536870910" />
                   </xs:restriction>
                 </xs:simpleType>
               </xs:element>
-              <xs:element name="AddressLine1" msprop:Generator_ColumnVarNameInTable="columnAddressLine1" msprop:Generator_ColumnPropNameInRow="AddressLine1" msprop:Generator_ColumnPropNameInTable="AddressLine1Column" msprop:Generator_UserColumnName="AddressLine1" minOccurs="0">
+            </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: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:element name="FirstName" msprop:Generator_ColumnVarNameInTable="columnFirstName" msprop:Generator_ColumnPropNameInRow="FirstName" msprop:Generator_ColumnPropNameInTable="FirstNameColumn" msprop:Generator_UserColumnName="FirstName" minOccurs="0">
                 <xs:simpleType>
                   <xs:restriction base="xs:string">
                     <xs:maxLength value="536870910" />
                   </xs:restriction>
                 </xs:simpleType>
               </xs:element>
                 <xs:simpleType>
                   <xs:restriction base="xs:string">
                     <xs:maxLength value="536870910" />
                   </xs:restriction>
                 </xs:simpleType>
               </xs:element>
-              <xs:element name="Town" msprop:Generator_ColumnVarNameInTable="columnTown" msprop:Generator_ColumnPropNameInRow="Town" msprop:Generator_ColumnPropNameInTable="TownColumn" msprop:Generator_UserColumnName="Town" minOccurs="0">
-                <xs:simpleType>
-                  <xs:restriction base="xs:string">
-                    <xs:maxLength value="255" />
-                  </xs:restriction>
-                </xs:simpleType>
-              </xs:element>
-              <xs:element name="Postcode" msprop:Generator_ColumnVarNameInTable="columnPostcode" msprop:Generator_ColumnPropNameInRow="Postcode" msprop:Generator_ColumnPropNameInTable="PostcodeColumn" msprop:Generator_UserColumnName="Postcode" minOccurs="0">
+              <xs:element name="LastName" msprop:Generator_ColumnVarNameInTable="columnLastName" msprop:Generator_ColumnPropNameInRow="LastName" msprop:Generator_ColumnPropNameInTable="LastNameColumn" msprop:Generator_UserColumnName="LastName" minOccurs="0">
                 <xs:simpleType>
                   <xs:restriction base="xs:string">
                     <xs:maxLength value="536870910" />
                   </xs:restriction>
                 </xs:simpleType>
               </xs:element>
                 <xs:simpleType>
                   <xs:restriction base="xs:string">
                     <xs:maxLength value="536870910" />
                   </xs:restriction>
                 </xs:simpleType>
               </xs:element>
-              <xs:element name="CardNumber" msprop:Generator_ColumnVarNameInTable="columnCardNumber" msprop:Generator_ColumnPropNameInRow="CardNumber" msprop:Generator_ColumnPropNameInTable="CardNumberColumn" msprop:Generator_UserColumnName="CardNumber" type="xs:int" minOccurs="0" />
-              <xs:element name="CVC" msprop:Generator_ColumnVarNameInTable="columnCVC" msprop:Generator_ColumnPropNameInRow="CVC" msprop:Generator_ColumnPropNameInTable="CVCColumn" msprop:Generator_UserColumnName="CVC" type="xs:int" minOccurs="0" />
-              <xs:element name="IGN" msprop:Generator_ColumnVarNameInTable="columnIGN" msprop:Generator_ColumnPropNameInRow="IGN" msprop:Generator_ColumnPropNameInTable="IGNColumn" msprop:Generator_UserColumnName="IGN" minOccurs="0">
+              <xs:element name="AddressLine1" msprop:Generator_ColumnVarNameInTable="columnAddressLine1" msprop:Generator_ColumnPropNameInRow="AddressLine1" msprop:Generator_ColumnPropNameInTable="AddressLine1Column" msprop:Generator_UserColumnName="AddressLine1" minOccurs="0">
                 <xs:simpleType>
                   <xs:restriction base="xs:string">
                     <xs:maxLength value="536870910" />
                   </xs:restriction>
                 </xs:simpleType>
               </xs:element>
                 <xs:simpleType>
                   <xs:restriction base="xs:string">
                     <xs:maxLength value="536870910" />
                   </xs:restriction>
                 </xs:simpleType>
               </xs:element>
-              <xs:element name="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnPropNameInTable="EmailColumn" msprop:Generator_UserColumnName="Email" minOccurs="0">
+              <xs:element name="Town" msprop:Generator_ColumnVarNameInTable="columnTown" msprop:Generator_ColumnPropNameInRow="Town" msprop:Generator_ColumnPropNameInTable="TownColumn" msprop:Generator_UserColumnName="Town" minOccurs="0">
                 <xs:simpleType>
                   <xs:restriction base="xs:string">
                 <xs:simpleType>
                   <xs:restriction base="xs:string">
-                    <xs:maxLength value="536870910" />
+                    <xs:maxLength value="255" />
                   </xs:restriction>
                 </xs:simpleType>
               </xs:element>
                   </xs:restriction>
                 </xs:simpleType>
               </xs:element>
-              <xs:element name="ProfilePic" msprop:Generator_ColumnVarNameInTable="columnProfilePic" msprop:Generator_ColumnPropNameInRow="ProfilePic" msprop:Generator_ColumnPropNameInTable="ProfilePicColumn" msprop:Generator_UserColumnName="ProfilePic" minOccurs="0">
+              <xs:element name="Postcode" msprop:Generator_ColumnVarNameInTable="columnPostcode" msprop:Generator_ColumnPropNameInRow="Postcode" msprop:Generator_ColumnPropNameInTable="PostcodeColumn" msprop:Generator_UserColumnName="Postcode" minOccurs="0">
                 <xs:simpleType>
                   <xs:restriction base="xs:string">
                     <xs:maxLength value="536870910" />
                   </xs:restriction>
                 </xs:simpleType>
               </xs:element>
                 <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="Users" msprop:Generator_TableClassName="UsersDataTable" msprop:Generator_TableVarName="tableUsers" msprop:Generator_TablePropName="Users" msprop:Generator_RowDeletingName="UsersRowDeleting" msprop:Generator_RowChangingName="UsersRowChanging" msprop:Generator_RowEvHandlerName="UsersRowChangeEventHandler" msprop:Generator_RowDeletedName="UsersRowDeleted" msprop:Generator_UserTableName="Users" msprop:Generator_RowChangedName="UsersRowChanged" msprop:Generator_RowEvArgName="UsersRowChangeEvent" msprop:Generator_RowClassName="UsersRow">
-          <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:element name="CardNumber" msprop:Generator_ColumnVarNameInTable="columnCardNumber" msprop:Generator_ColumnPropNameInRow="CardNumber" msprop:Generator_ColumnPropNameInTable="CardNumberColumn" msprop:Generator_UserColumnName="CardNumber" type="xs:int" minOccurs="0" />
+              <xs:element name="CVC" msprop:Generator_ColumnVarNameInTable="columnCVC" msprop:Generator_ColumnPropNameInRow="CVC" msprop:Generator_ColumnPropNameInTable="CVCColumn" msprop:Generator_UserColumnName="CVC" type="xs:int" minOccurs="0" />
+              <xs:element name="IGN" msprop:Generator_ColumnVarNameInTable="columnIGN" msprop:Generator_ColumnPropNameInRow="IGN" msprop:Generator_ColumnPropNameInTable="IGNColumn" msprop:Generator_UserColumnName="IGN" minOccurs="0">
                 <xs:simpleType>
                   <xs:restriction base="xs:string">
                     <xs:maxLength value="536870910" />
                   </xs:restriction>
                 </xs:simpleType>
               </xs:element>
                 <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:element name="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnPropNameInTable="EmailColumn" msprop:Generator_UserColumnName="Email" minOccurs="0">
                 <xs:simpleType>
                   <xs:restriction base="xs:string">
                     <xs:maxLength value="536870910" />
                   </xs:restriction>
                 </xs:simpleType>
               </xs:element>
                 <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_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:element name="ProfilePic" msprop:Generator_ColumnVarNameInTable="columnProfilePic" msprop:Generator_ColumnPropNameInRow="ProfilePic" msprop:Generator_ColumnPropNameInTable="ProfilePicColumn" msprop:Generator_UserColumnName="ProfilePic" type="xs:base64Binary" minOccurs="0" />
             </xs:sequence>
           </xs:complexType>
         </xs:element>
             </xs:sequence>
           </xs:complexType>
         </xs:element>
@@ -870,17 +887,17 @@
       <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="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: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="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:element>
   <xs:annotation>
     </xs:unique>
   </xs:element>
   <xs:annotation>
@@ -889,8 +906,8 @@
       <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="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="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_ParentPropName="User_DetailsRow" msprop:Generator_RelationVarName="relationUser_DetailsUsers" msprop:Generator_UserParentTable="User_Details" />
       <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="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="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" />
     </xs:appinfo>
   </xs:annotation>
 </xs:schema>
\ No newline at end of file
     </xs:appinfo>
   </xs:annotation>
 </xs:schema>
\ No newline at end of file
Test