diff options
| author | Patrick Davison <snapwilliam@gmail.com> | 2013-05-29 23:51:32 -0700 |
|---|---|---|
| committer | Patrick Davison <snapwilliam@gmail.com> | 2013-05-29 23:51:32 -0700 |
| commit | 0de677ff1e4506b098738aa1b8729f908fcd718e (patch) | |
| tree | 8e865692cd24ad6bf3d784119d1b9332690510be /db updates.sql | |
| parent | d55563d890113b3ab3c49b513a34124e1df8c704 (diff) | |
| download | pathery-0de677ff1e4506b098738aa1b8729f908fcd718e.tar.xz | |
Drop userData - depreciated.
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: |