X-Git-Url: https://fbox.kageds.com/gitweb/NEATEST.git/blobdiff_plain/61e61981825c73f098cea957e65c7c49dc20cbda..refs/heads/master:/NEA/NEADataSet.xsd?ds=sidebyside diff --git a/NEA/NEADataSet.xsd b/NEA/NEADataSet.xsd index aae99a0..daef810 100644 --- a/NEA/NEADataSet.xsd +++ b/NEA/NEADataSet.xsd @@ -2,15 +2,14 @@ - + - - + DELETE FROM `Achievement` WHERE ((`AchievementID` = ?) AND ((? = 1 AND `GameID` IS NULL) OR (`GameID` = ?)) AND ((? = 1 AND `UserID` IS NULL) OR (`UserID` = ?))) @@ -78,7 +77,7 @@ - + DELETE FROM `DOW` WHERE ((`DOWID` = ?) AND ((? = 1 AND `Start` IS NULL) OR (`Start` = ?)) AND ((? = 1 AND `End` IS NULL) OR (`End` = ?)) AND ((? = 1 AND `GameID` IS NULL) OR (`GameID` = ?))) @@ -138,7 +137,7 @@ - + DELETE FROM `Friends` WHERE ((`ID` = ?) AND ((? = 1 AND `FriendID` IS NULL) OR (`FriendID` = ?)) AND ((? = 1 AND `UserID` IS NULL) OR (`UserID` = ?))) @@ -191,7 +190,7 @@ - + DELETE FROM `Games` WHERE ((`GameID` = ?) AND ((? = 1 AND `Price` IS NULL) OR (`Price` = ?)) AND ((? = 1 AND `Rating` IS NULL) OR (`Rating` = ?)) AND ((? = 1 AND `Certificate` IS NULL) OR (`Certificate` = ?)) AND ((? = 1 AND `Theme Colour` IS NULL) OR (`Theme Colour` = ?))) @@ -210,7 +209,7 @@ - INSERT INTO `Games` (`Name`, `Price`, `Rating`, `Certificate`, `Dev`, `Publisher`, `Icon`, `Tags`, `Theme Colour`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) + INSERT INTO `Games` (`Name`, `Price`, `Rating`, `Certificate`, `Dev`, `Publisher`, `Tags`, `Theme Colour`, `Icon`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) @@ -218,21 +217,21 @@ - + - - SELECT GameID, Name, Price, Rating, Certificate, Dev, Publisher, Icon, Tags, [Theme Colour] FROM Games + + SELECT GameID, Name, Price, Rating, Certificate, Dev, Publisher, Tags, [Theme Colour], Icon FROM Games - 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` = ?))) + 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` = ?))) @@ -240,9 +239,9 @@ - + @@ -265,15 +264,15 @@ - + - + DELETE FROM `Purchased` WHERE ((`PurchaseID` = ?) AND ((? = 1 AND `UserID` IS NULL) OR (`UserID` = ?)) AND ((? = 1 AND `GameID` IS NULL) OR (`GameID` = ?))) @@ -326,7 +325,7 @@ - + DELETE FROM `Reviews` WHERE ((`ReviewID` = ?) AND ((? = 1 AND `GameID` IS NULL) OR (`GameID` = ?))) @@ -375,7 +374,7 @@ - + DELETE FROM `Tags` WHERE ((`ID` = ?)) @@ -411,56 +410,84 @@ - + - + - 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 UserDetailsID, FirstName, LastName, AddressLine1, Town, Postcode, CardNumber, CVC, IGN, Email, ProfilePic 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` = ?))) - - - - - - - + + + + + + + + + + + + + + + + + - - - + + + + + + + + + + + @@ -488,9 +515,8 @@ - - SELECT Users.* -FROM Users + + SELECT UserID, User_DetailsID, Username, [Password] FROM Users @@ -517,107 +543,58 @@ FROM Users - + - + - 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 User_Details.* -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` = ?))) - - - - - - - - - - - - - - - - - + + + + + + + - - - - - - - - - - - + + + - - - - - INSERT INTO `User_Details` (`FirstName`, `LastName`, `AddressLine1`, `Town`, `Postcode`, `CardNumber`, `CVC`, `IGN`, `Email`, `ProfilePic`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) - - - - - - - - - - - - - - - - + @@ -627,7 +604,7 @@ FROM User_Details - + @@ -671,7 +648,7 @@ FROM User_Details - + @@ -681,7 +658,7 @@ FROM User_Details - + @@ -690,7 +667,7 @@ FROM User_Details - + @@ -718,13 +695,6 @@ FROM User_Details - - - - - - - @@ -733,10 +703,11 @@ FROM User_Details + - + @@ -745,7 +716,7 @@ FROM User_Details - + @@ -760,45 +731,14 @@ FROM User_Details - + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + @@ -857,6 +797,37 @@ FROM User_Details + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + @@ -887,27 +858,27 @@ FROM User_Details - - - + + + - - - + + + - - - - - + + + + + \ No newline at end of file