X-Git-Url: https://fbox.kageds.com/gitweb/NEATEST.git/blobdiff_plain/0db63183acd08a45ae907a2adedf10e4cb7ce09b..20dbf92bc0579668c40523cd06f2add91ddf9b98:/NEA/NEADataSet.xsd

diff --git a/NEA/NEADataSet.xsd b/NEA/NEADataSet.xsd
index 9b98cc1..daef810 100644
--- a/NEA/NEADataSet.xsd
+++ b/NEA/NEADataSet.xsd
@@ -209,7 +209,7 @@
                 </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" />
@@ -217,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="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="Binary" Direction="Input" ParameterName="Icon" Precision="0" ProviderType="LongVarBinary" Scale="0" Size="0" SourceColumn="Icon" SourceColumnNullMapping="false" SourceVersion="Current" />
                     </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">
-                    <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" />
@@ -239,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="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="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" />
@@ -264,9 +264,9 @@
               <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="Icon" DataSetColumn="Icon" />
             </Mappings>
             <Sources />
           </TableAdapter>
@@ -604,7 +604,7 @@
   <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" />
@@ -648,7 +648,7 @@
             </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" />
@@ -658,7 +658,7 @@
             </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" />
@@ -667,7 +667,7 @@
             </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" />
@@ -695,13 +695,6 @@
                   </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">
@@ -710,10 +703,11 @@
                 </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: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" />
@@ -722,7 +716,7 @@
             </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" />
@@ -737,14 +731,14 @@
             </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: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" />
@@ -803,7 +797,7 @@
             </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: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" />
@@ -825,7 +819,7 @@
             </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: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" />
@@ -879,12 +873,12 @@
   </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="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="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="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