X-Git-Url: https://fbox.kageds.com/gitweb/NEATEST.git/blobdiff_plain/599222942c6c954fb8eb161aade645f0c38c1a13..f7c7983a5879f2450a792ba5dcbe3009852c7501:/NEA/NEADataSet.xsd?ds=sidebyside diff --git a/NEA/NEADataSet.xsd b/NEA/NEADataSet.xsd index 27dfc06..aae99a0 100644 --- a/NEA/NEADataSet.xsd +++ b/NEA/NEADataSet.xsd @@ -2,9 +2,10 @@ - + + @@ -410,90 +411,62 @@ - + - + - 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` = ?))) + DELETE FROM `Wishlist` WHERE ((`WishlistID` = ?) AND ((? = 1 AND `UserID` IS NULL) OR (`UserID` = ?)) AND ((? = 1 AND `GameID` IS NULL) OR (`GameID` = ?))) - - - - - - - + + + + + - INSERT INTO `User_Details` (`FirstName`, `LastName`, `AddressLine1`, `Town`, `Postcode`, `CardNumber`, `CVC`, `IGN`, `Email`, `ProfilePic`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) + INSERT INTO `Wishlist` (`UserID`, `GameID`) VALUES (?, ?) - - - - - - - - - - + + - SELECT UserDetailsID, FirstName, LastName, AddressLine1, Town, Postcode, CardNumber, CVC, IGN, Email, ProfilePic FROM User_Details + SELECT WishlistID, UserID, GameID FROM Wishlist - 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` = ?))) + UPDATE `Wishlist` SET `UserID` = ?, `GameID` = ? WHERE ((`WishlistID` = ?) AND ((? = 1 AND `UserID` IS NULL) OR (`UserID` = ?)) AND ((? = 1 AND `GameID` IS NULL) OR (`GameID` = ?))) - - - - - - - - - - - - - - - - - + + + + + + + - - - - - - - - - - - + + + - + DELETE FROM `Users` WHERE ((`UserID` = ?) AND ((? = 1 AND `User_DetailsID` IS NULL) OR (`User_DetailsID` = ?))) @@ -515,8 +488,9 @@ - - SELECT UserID, User_DetailsID, Username, [Password] FROM Users + + SELECT Users.* +FROM Users @@ -543,58 +517,107 @@ - + - + - DELETE FROM `Wishlist` WHERE ((`WishlistID` = ?) AND ((? = 1 AND `UserID` IS NULL) OR (`UserID` = ?)) AND ((? = 1 AND `GameID` IS NULL) OR (`GameID` = ?))) + 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` = ?))) - - - - - + + + + + + + - INSERT INTO `Wishlist` (`UserID`, `GameID`) VALUES (?, ?) + INSERT INTO `User_Details` (`FirstName`, `LastName`, `AddressLine1`, `Town`, `Postcode`, `CardNumber`, `CVC`, `IGN`, `Email`, `ProfilePic`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) - - + + + + + + + + + + - - SELECT WishlistID, UserID, GameID FROM Wishlist + + SELECT User_Details.* +FROM User_Details - UPDATE `Wishlist` SET `UserID` = ?, `GameID` = ? WHERE ((`WishlistID` = ?) AND ((? = 1 AND `UserID` IS NULL) OR (`UserID` = ?)) AND ((? = 1 AND `GameID` IS NULL) OR (`GameID` = ?))) + 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` = ?))) - - - - - - - + + + + + + + + + + + + + + + + + - - - + + + + + + + + + + + - + + + + + INSERT INTO `User_Details` (`FirstName`, `LastName`, `AddressLine1`, `Town`, `Postcode`, `CardNumber`, `CVC`, `IGN`, `Email`, `ProfilePic`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) + + + + + + + + + + + + + + + + @@ -744,99 +767,93 @@ - + - - + + + + + + + + + + + + - + - + + + + + + + + - - - - - - - - + - - - + - + - + - + - - - - - - - - - + + + - + - - - - - - - - - + @@ -870,17 +887,17 @@ - - - + + + - - - + + + @@ -889,8 +906,8 @@ - + \ No newline at end of file