Pasted

# ########################################################################
# communit_pablo.admin_actions                                            
# ########################################################################
 
# user_id_index is a left-prefix of user_id_action_type_index
# Key definitions:
#   KEY `user_id_index` (`account_id`),
#   KEY `user_id_action_type_index` (`account_id`,`action_type`),
# Column types:
#         `account_id` int(11) default null
#         `action_type` varchar(255) collate utf8_unicode_ci default null
# To remove this duplicate index, execute:
ALTER TABLE `communit_pablo`.`admin_actions` DROP INDEX `user_id_index`;
 
# ########################################################################
# communit_pablo.job_logs                                                 
# ########################################################################
 
# job_user_and_type_index is a left-prefix of job_user_and_type_and_state_index
# Key definitions:
#   KEY `job_user_and_type_index` (`user_id`,`job_type`),
#   KEY `job_user_and_type_and_state_index` (`user_id`,`job_type`,`workflow_state`),
# Column types:
#         `user_id` int(11) default null
#         `job_type` varchar(50) collate utf8_unicode_ci default null
#         `workflow_state` varchar(255) collate utf8_unicode_ci default null
# To remove this duplicate index, execute:
ALTER TABLE `communit_pablo`.`job_logs` DROP INDEX `job_user_and_type_index`;
 
# ########################################################################
# communit_pablo.member_leads                                             
# ########################################################################
 
# member_index is a left-prefix of unique
# Key definitions:
#   KEY `member_index` (`member_id`),
#   UNIQUE KEY `unique` (`member_id`,`s_object_id`),
# Column types:
#         `member_id` int(11) not null
#         `s_object_id` int(11) not null
# To remove this duplicate index, execute:
ALTER TABLE `communit_pablo`.`member_leads` DROP INDEX `member_index`;
 
# ########################################################################
# communit_pablo.monitored_urls                                           
# ########################################################################
 
# user_index is a left-prefix of unique_index
# Key definitions:
#   KEY `user_index` (`user_id`)
#   UNIQUE KEY `unique_index` (`user_id`,`link_object_id`,`monitor_id`),
# Column types:
#         `user_id` int(11) not null
#         `link_object_id` int(11) not null
#         `monitor_id` int(11) not null
# To remove this duplicate index, execute:
ALTER TABLE `communit_pablo`.`monitored_urls` DROP INDEX `user_index`;
 
# ########################################################################
# communit_pablo.s_filters                                                
# ########################################################################
 
# user_id_index is a left-prefix of unique_index
# Key definitions:
#   KEY `user_id_index` (`user_id`)
#   UNIQUE KEY `unique_index` (`user_id`,`filter_text`),
# Column types:
#         `user_id` int(11) default null
#         `filter_text` varchar(255) character set utf8 collate utf8_bin default null
# To remove this duplicate index, execute:
ALTER TABLE `communit_pablo`.`s_filters` DROP INDEX `user_id_index`;
 
# ########################################################################
# communit_pablo.twitter_status_cursors                                   
# ########################################################################
 
# user_status_type_index is a left-prefix of unique_index
# Key definitions:
#   KEY `user_status_type_index` (`user_id`,`status_type`)
#   UNIQUE KEY `unique_index` (`user_id`,`status_type`,`s_object_id`),
# Column types:
#         `user_id` int(11) not null
#         `status_type` int(11) not null
#         `s_object_id` int(11) default '0'
# To remove this duplicate index, execute:
ALTER TABLE `communit_pablo`.`twitter_status_cursors` DROP INDEX `user_status_type_index`;