diff options
author | Dan McGee <dan@archlinux.org> | 2011-03-01 17:21:06 +0100 |
---|---|---|
committer | Lukas Fleischer <archlinux@cryptocrack.de> | 2011-03-04 10:29:14 +0100 |
commit | f9eba12312fc6a1758f7f1051a8f30b435175f94 (patch) | |
tree | db44e5216dfee88d12fbf3e5f1e772b6dcfc27b0 /web/lib/config.inc.proto | |
parent | abd41bbb51ea2340bd06648cc0cd5b9144cce91e (diff) | |
download | aur-f9eba12312fc6a1758f7f1051a8f30b435175f94.tar.gz aur-f9eba12312fc6a1758f7f1051a8f30b435175f94.tar.xz |
Ensure users can be deleted when foreign keys are present
This change is necessary to prevent this:
mysql> delete from Users where ID = 112;
ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (`aur`.`Packages`, CONSTRAINT `Packages_ibfk_2` FOREIGN KEY (`SubmitterUID`) REFERENCES `Users` (`ID`) ON DELETE NO ACTION)
As a bonus, due to foreign keys, orphaning of packages will be
automatic.
Signed-off-by: Dan McGee <dan@archlinux.org>
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
Diffstat (limited to 'web/lib/config.inc.proto')
0 files changed, 0 insertions, 0 deletions