From 0de677ff1e4506b098738aa1b8729f908fcd718e Mon Sep 17 00:00:00 2001 From: Patrick Davison Date: Wed, 29 May 2013 23:51:32 -0700 Subject: Drop userData - depreciated. --- db updates.sql | 4 ---- 1 file changed, 4 deletions(-) diff --git a/db updates.sql b/db updates.sql index e3eea2c..ddcf2c8 100644 --- a/db updates.sql +++ b/db updates.sql @@ -44,10 +44,6 @@ ALTER TABLE `unlocks` ENGINE = InnoDB; -- Looks like this was forgotten? DELETE FROM unlocks WHERE userID NOT IN (SELECT ID FROM users); ALTER TABLE `unlocks` ADD FOREIGN KEY ( `userID` ) REFERENCES `users` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE; --- UserData -ALTER TABLE `userData` ENGINE = InnoDB; -- Looks like this was forgotten? -ALTER TABLE `userData` ADD FOREIGN KEY ( `userID` ) REFERENCES `users` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE; - -- END ADD FOREIGN KEY CONSTRAINTS -- This table is depreciated too: -- cgit v1.2.3