Attachment 297568 Details for Bug 436921 – add FKs in dependencies table

[patch] add FKs in dependencies table

patch.diff (text/plain), 1.05 KB, created by Tony Fu on 2008-03-11 06:37:33 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Tony Fu

Created: 2008-03-11 06:37:33 UTC

Size: 1.05 KB

patch

obsolete

>Index: Schema.pm
>===================================================================
>RCS file: /cvsroot/mozilla/webtools/bugzilla/Bugzilla/DB/Schema.pm,v
>retrieving revision 1.97
>diff -u -r1.97 Schema.pm
>--- Schema.pm	9 Jan 2008 15:14:02 -0000	1.97
>+++ Schema.pm	11 Mar 2008 06:19:33 -0000
>@@ -343,8 +343,14 @@
> 
>     dependencies => {
>         FIELDS => [
>-            blocked   => {TYPE => 'INT3', NOTNULL => 1},
>-            dependson => {TYPE => 'INT3', NOTNULL => 1},
>+            blocked   => {TYPE => 'INT3', NOTNULL => 1,
>+                          REFERENCES    =>  {TABLE  =>   'bugs',
>+                                            COLUMN  =>  'bug_id',
>+                                            DELETE => 'CASCADE'}},
>+            dependson => {TYPE => 'INT3', NOTNULL => 1,
>+                          REFERENCES    =>  {TABLE  =>   'bugs',
>+                                            COLUMN  =>  'bug_id',
>+                                            DELETE => 'CASCADE'}},
>         ],
>         INDEXES => [
>             dependencies_blocked_idx   => ['blocked'],

Actions: View | Diff

Attachments on bug 436921: 297568