1 drop index downloads_idx;
2 create index frsdlstatsgroupagg_day_dls on frs_dlstats_group_agg (day,downloads);
3 create index projectweeklymetric_ranking on project_weekly_metric(ranking);
4 create index users_status on users(status);
6 create index support_groupid_assignedto_status on support(group_id,assigned_to,support_status_id);
7 create index support_groupid_assignedto on support(group_id,assigned_to);
8 create index support_groupid_status on support(group_id,support_status_id);
10 create index patch_groupid_assignedto_status on patch(group_id,assigned_to,patch_status_id);
11 create index patch_groupid_assignedto on patch(group_id,assigned_to);
12 create index patch_groupid_status on patch(group_id,patch_status_id);
14 create index projecttask_projid_status on project_task(group_project_id,status_id);
16 create index forummonitoredforums_user on forum_monitored_forums(user_id);
18 create index filemodulemonitor_userid on filemodule_monitor(user_id);
19 create index support_status_assignedto on support(support_status_id,assigned_to);
20 create index bug_status_assignedto on bug(status_id,assigned_to);