From 2541a7dcf12529052a710def2e70afc794f4fbff Mon Sep 17 00:00:00 2001 From: Dave Lawrence Date: Sun, 17 Feb 2013 21:24:56 -0500 Subject: Bug 824346 - The flaginclusions and flagexclusions DB tables have no UNIQUE index r/a=LpSolit --- Bugzilla/DB/Schema.pm | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) (limited to 'Bugzilla/DB') diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm index 058e78a5f..f92d0aeb7 100644 --- a/Bugzilla/DB/Schema.pm +++ b/Bugzilla/DB/Schema.pm @@ -640,8 +640,8 @@ use constant ABSTRACT_SCHEMA => { DELETE => 'CASCADE'}}, ], INDEXES => [ - flaginclusions_type_id_idx => - [qw(type_id product_id component_id)], + flaginclusions_type_id_idx => { FIELDS => [qw(type_id product_id component_id)], + TYPE => 'UNIQUE' }, ], }, @@ -661,8 +661,8 @@ use constant ABSTRACT_SCHEMA => { DELETE => 'CASCADE'}}, ], INDEXES => [ - flagexclusions_type_id_idx => - [qw(type_id product_id component_id)], + flagexclusions_type_id_idx => { FIELDS => [qw(type_id product_id component_id)], + TYPE => 'UNIQUE' }, ], }, -- cgit v1.2.3-24-g4f1b