diff options
Diffstat (limited to 'db updates.sql')
| -rw-r--r-- | db updates.sql | 4 |
1 files changed, 0 insertions, 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: |