From 5173b6cbadea03c8525218f09794b3f74ab12d96 Mon Sep 17 00:00:00 2001
From: miketosh <michael.j.tosh@lmco.com>
Date: Sun, 23 Oct 2011 14:18:04 +0200
Subject: Bug 690173: Cannot delete user accounts due to FK on audit_log
 r/a=mkanat

---
 Bugzilla/DB/Schema.pm | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'Bugzilla/DB/Schema.pm')

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},
-- 
cgit v1.2.3-24-g4f1b