diff options
| author |   lpsolit%gmail.com <> | 2008-04-12 04:47:12 +0000 |
|---|---|---|
| committer | lpsolit%gmail.com <> | 2008-04-12 04:47:12 +0000 |
| commit | bf99679012539d8c458ca742321c9325300212f8 (patch) | |
| tree | dfbff0eedcc8069d4b18d4665ccc4c5d1776fa71 | |
| parent | Bug 314454: Incorrect SQL query in editproducts.cgi when making a group manda... (diff) | |
| download | bugzilla-bf99679012539d8c458ca742321c9325300212f8.tar.gz bugzilla-bf99679012539d8c458ca742321c9325300212f8.tar.bz2 bugzilla-bf99679012539d8c458ca742321c9325300212f8.zip | |
Bug 427936: Update sanitycheck.cgi to include missing foreign keys cross checks - Patch by Noura Elhawary <nelhawar@redhat.com> r/a=LpSolit
| -rwxr-xr-x | sanitycheck.cgi | 19 |
1 files changed, 14 insertions, 5 deletions
diff --git a/sanitycheck.cgi b/sanitycheck.cgi index 9aa5e345b..1332f75ed 100755 --- a/sanitycheck.cgi +++ b/sanitycheck.cgi @@ -401,7 +401,9 @@ CrossCheck("fielddefs", "id", ['profiles_activity', 'fieldid']); CrossCheck("flagtypes", "id", - ["flags", "type_id"]); + ["flags", "type_id"], + ["flagexclusions", "type_id"], + ["flaginclusions", "type_id"]); CrossCheck("bugs", "bug_id", ["bugs_activity", "bug_id"], @@ -424,7 +426,9 @@ CrossCheck("groups", "id", ["group_group_map", "member_id"], ["group_control_map", "group_id"], ["namedquery_group_map", "group_id"], - ["user_group_map", "group_id"]); + ["user_group_map", "group_id"], + ["flagtypes", "grant_group_id"], + ["flagtypes", "request_group_id"]); CrossCheck("namedqueries", "id", ["namedqueries_link_in_footer", "namedquery_id"], @@ -470,7 +474,9 @@ CrossCheck("products", "id", ["flagexclusions", "product_id", "type_id"]); CrossCheck("components", "id", - ["component_cc", "component_id"]); + ["component_cc", "component_id"], + ["flagexclusions", "component_id", "type_id"], + ["flaginclusions", "component_id", "type_id"]); # Check the former enum types -mkanat@bugzilla.org CrossCheck("bug_status", "value", @@ -495,14 +501,17 @@ CrossCheck('series', 'series_id', ['series_data', 'series_id']); CrossCheck('series_categories', 'id', - ['series', 'category']); + ['series', 'category'], + ["category_group_map", "category_id"], + ["series", "subcategory"]); CrossCheck('whine_events', 'id', ['whine_queries', 'eventid'], ['whine_schedules', 'eventid']); CrossCheck('attachments', 'attach_id', - ['attach_data', 'id']); + ['attach_data', 'id'], + ['bugs_activity', 'attach_id']); CrossCheck('bug_status', 'id', ['status_workflow', 'old_status'], |