From fc329ec4b1f0ad1adfe73f8f5adeca308f296977 Mon Sep 17 00:00:00 2001
From: David Marshall <dmarshal@yahoo-inc.com>
Date: Sat, 15 Jan 2011 01:11:57 +0100
Subject: Bug 625190: Typo and Missing FK in Bugzilla::DB::Schema r/a=mkanat

---
 Bugzilla/DB/Schema.pm | 9 ++++++---
 1 file changed, 6 insertions(+), 3 deletions(-)

(limited to 'Bugzilla')

diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm
index 59f99d245..e2c1d22e4 100644
--- a/Bugzilla/DB/Schema.pm
+++ b/Bugzilla/DB/Schema.pm
@@ -279,8 +279,8 @@ use constant ABSTRACT_SCHEMA => {
             target_milestone    => {TYPE => 'varchar(20)',
                                     NOTNULL => 1, DEFAULT => "'---'"},
             qa_contact          => {TYPE => 'INT3',
-                                    REERENCES => {TABLE  => 'profiles',
-                                                  COLUMN => 'userid'}},
+                                    REFERENCES => {TABLE  => 'profiles',
+                                                   COLUMN => 'userid'}},
             status_whiteboard   => {TYPE => 'MEDIUMTEXT', NOTNULL => 1,
                                     DEFAULT => "''"},
             lastdiffed          => {TYPE => 'DATETIME'},
@@ -494,7 +494,10 @@ use constant ABSTRACT_SCHEMA => {
 
     bug_see_also => {
         FIELDS => [
-            bug_id => {TYPE => 'INT3', NOTNULL => 1},
+            bug_id => {TYPE => 'INT3', NOTNULL => 1,
+                       REFERENCES => {TABLE  => 'bugs',
+                                      COLUMN => 'bug_id',
+                                      DELETE => 'CASCADE'}},
             value  => {TYPE => 'varchar(255)', NOTNULL => 1},
         ],
         INDEXES => [
-- 
cgit v1.2.3-24-g4f1b