From 66146a6e56c9a23cad32a6cbf897018372c07e80 Mon Sep 17 00:00:00 2001 From: "mkanat%bugzilla.org" <> Date: Sun, 29 Jun 2008 00:17:47 +0000 Subject: Bug 429804: Add Foreign Keys to Multiselect fields Patch By Alex Eiser r=mkanat, a=mkanat --- Bugzilla/DB.pm | 14 ++++++++++---- 1 file changed, 10 insertions(+), 4 deletions(-) (limited to 'Bugzilla/DB.pm') diff --git a/Bugzilla/DB.pm b/Bugzilla/DB.pm index 2eba30482..9d4f41546 100644 --- a/Bugzilla/DB.pm +++ b/Bugzilla/DB.pm @@ -674,11 +674,17 @@ sub bz_add_field_tables { $self->_bz_add_field_table($field->name, $self->_bz_schema->FIELD_TABLE_SCHEMA); - if ( $field->type == FIELD_TYPE_MULTI_SELECT ) { - $self->_bz_add_field_table('bug_' . $field->name, - $self->_bz_schema->MULTI_SELECT_VALUE_TABLE); + if ($field->type == FIELD_TYPE_MULTI_SELECT) { + my $ms_table = "bug_" . $field->name; + $self->_bz_add_field_table($ms_table, + $self->_bz_schema->MULTI_SELECT_VALUE_TABLE); + + $self->bz_add_fk($ms_table, 'bug_id', {TABLE => 'bugs', + COLUMN => 'bug_id', + DELETE => 'CASCADE'}); + $self->bz_add_fk($ms_table, 'value', {TABLE => $field->name, + COLUMN => 'value'}); } - } sub bz_drop_field_tables { -- cgit v1.2.3-24-g4f1b