summaryrefslogtreecommitdiffstats
path: root/Bugzilla/DB
diff options
context:
space:
mode:
authormiketosh <michael.j.tosh@lmco.com>2011-10-23 14:18:04 +0200
committerFrédéric Buclin <LpSolit@gmail.com>2011-10-23 14:18:04 +0200
commit5173b6cbadea03c8525218f09794b3f74ab12d96 (patch)
tree05aaf3f5230a04647ca371480dae85f974d035de /Bugzilla/DB
parentce3970fd0a2890b88485c2723e7af1633544c741 (diff)
downloadbugzilla-5173b6cbadea03c8525218f09794b3f74ab12d96.tar.gz
bugzilla-5173b6cbadea03c8525218f09794b3f74ab12d96.tar.xz
Bug 690173: Cannot delete user accounts due to FK on audit_log
r/a=mkanat
Diffstat (limited to 'Bugzilla/DB')
-rw-r--r--Bugzilla/DB/Schema.pm3
1 files changed, 2 insertions, 1 deletions
diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm
index 33527c367..6d9a33ef7 100644
--- a/Bugzilla/DB/Schema.pm
+++ b/Bugzilla/DB/Schema.pm
@@ -516,7 +516,8 @@ use constant ABSTRACT_SCHEMA => {
FIELDS => [
user_id => {TYPE => 'INT3',
REFERENCES => {TABLE => 'profiles',
- COLUMN => 'userid'}},
+ COLUMN => 'userid',
+ DELETE => 'SET NULL'}},
class => {TYPE => 'varchar(255)', NOTNULL => 1},
object_id => {TYPE => 'INT4', NOTNULL => 1},
field => {TYPE => 'varchar(64)', NOTNULL => 1},