# ########################################################################
# pipelinedeals_production.conversations
# ########################################################################

# conversations_deals is a duplicate of index_conversations_on_deal_id
# Key definitions:
#   KEY `conversations_deals` (`deal_id`),
#   KEY `index_conversations_on_deal_id` (`deal_id`),
# Column types:
#	  `deal_id` int(11) default null
# To remove this duplicate index, execute:
ALTER TABLE `pipelinedeals_production`.`conversations` DROP INDEX `conversations_deals`;

# ########################################################################
# pipelinedeals_production.custom_field_value_arrays
# ########################################################################

# index_custom_field_value_arrays_on_custom_field_label_id_9 is a duplicate of cfrdd_label_9_id
# Key definitions:
#   KEY `index_custom_field_value_arrays_on_custom_field_label_id_9` (`custom_field_label_id_9`),
#   KEY `cfrdd_label_9_id` (`custom_field_label_id_9`),
# Column types:
#	  `custom_field_label_id_9` int(11) default null
# To remove this duplicate index, execute:
ALTER TABLE `pipelinedeals_production`.`custom_field_value_arrays` DROP INDEX `index_custom_field_value_arrays_on_custom_field_label_id_9`;

# cfrdd_label_8_id is a duplicate of index_custom_field_value_arrays_on_custom_field_label_id_8
# Key definitions:
#   KEY `cfrdd_label_8_id` (`custom_field_label_id_8`),
#   KEY `index_custom_field_value_arrays_on_custom_field_label_id_8` (`custom_field_label_id_8`),
# Column types:
#	  `custom_field_label_id_8` int(11) default null
# To remove this duplicate index, execute:
ALTER TABLE `pipelinedeals_production`.`custom_field_value_arrays` DROP INDEX `cfrdd_label_8_id`;

# cfrdd_label_7_id is a duplicate of index_custom_field_value_arrays_on_custom_field_label_id_7
# Key definitions:
#   KEY `cfrdd_label_7_id` (`custom_field_label_id_7`),
#   KEY `index_custom_field_value_arrays_on_custom_field_label_id_7` (`custom_field_label_id_7`),
# Column types:
#	  `custom_field_label_id_7` int(11) default null
# To remove this duplicate index, execute:
ALTER TABLE `pipelinedeals_production`.`custom_field_value_arrays` DROP INDEX `cfrdd_label_7_id`;

# index_custom_field_value_arrays_on_custom_field_label_id_6 is a duplicate of cfrdd_label_6_id
# Key definitions:
#   KEY `index_custom_field_value_arrays_on_custom_field_label_id_6` (`custom_field_label_id_6`),
#   KEY `cfrdd_label_6_id` (`custom_field_label_id_6`),
# Column types:
#	  `custom_field_label_id_6` int(11) default null
# To remove this duplicate index, execute:
ALTER TABLE `pipelinedeals_production`.`custom_field_value_arrays` DROP INDEX `index_custom_field_value_arrays_on_custom_field_label_id_6`;

# cfrdd_label_5_id is a duplicate of index_custom_field_value_arrays_on_custom_field_label_id_5
# Key definitions:
#   KEY `cfrdd_label_5_id` (`custom_field_label_id_5`),
#   KEY `index_custom_field_value_arrays_on_custom_field_label_id_5` (`custom_field_label_id_5`),
# Column types:
#	  `custom_field_label_id_5` int(11) default null
# To remove this duplicate index, execute:
ALTER TABLE `pipelinedeals_production`.`custom_field_value_arrays` DROP INDEX `cfrdd_label_5_id`;

# cfrdd_label_4_id is a duplicate of index_custom_field_value_arrays_on_custom_field_label_id_4
# Key definitions:
#   KEY `cfrdd_label_4_id` (`custom_field_label_id_4`),
#   KEY `index_custom_field_value_arrays_on_custom_field_label_id_4` (`custom_field_label_id_4`),
# Column types:
#	  `custom_field_label_id_4` int(11) default null
# To remove this duplicate index, execute:
ALTER TABLE `pipelinedeals_production`.`custom_field_value_arrays` DROP INDEX `cfrdd_label_4_id`;

# index_custom_field_value_arrays_on_custom_field_label_id_3 is a duplicate of cfrdd_label_3_id
# Key definitions:
#   KEY `index_custom_field_value_arrays_on_custom_field_label_id_3` (`custom_field_label_id_3`),
#   KEY `cfrdd_label_3_id` (`custom_field_label_id_3`),
# Column types:
#	  `custom_field_label_id_3` int(11) default null
# To remove this duplicate index, execute:
ALTER TABLE `pipelinedeals_production`.`custom_field_value_arrays` DROP INDEX `index_custom_field_value_arrays_on_custom_field_label_id_3`;

# index_custom_field_value_arrays_on_custom_field_label_id_2 is a duplicate of cfrdd_label_2_id
# Key definitions:
#   KEY `index_custom_field_value_arrays_on_custom_field_label_id_2` (`custom_field_label_id_2`),
#   KEY `cfrdd_label_2_id` (`custom_field_label_id_2`),
# Column types:
#	  `custom_field_label_id_2` int(11) default null
# To remove this duplicate index, execute:
ALTER TABLE `pipelinedeals_production`.`custom_field_value_arrays` DROP INDEX `index_custom_field_value_arrays_on_custom_field_label_id_2`;

# cfrdd_label_25_id is a duplicate of index_custom_field_value_arrays_on_custom_field_label_id_25
# Key definitions:
#   KEY `cfrdd_label_25_id` (`custom_field_label_id_25`),
#   KEY `index_custom_field_value_arrays_on_custom_field_label_id_25` (`custom_field_label_id_25`),
# Column types:
#	  `custom_field_label_id_25` int(11) default null
# To remove this duplicate index, execute:
ALTER TABLE `pipelinedeals_production`.`custom_field_value_arrays` DROP INDEX `cfrdd_label_25_id`;

# index_custom_field_value_arrays_on_custom_field_label_id_24 is a duplicate of cfrdd_label_24_id
# Key definitions:
#   KEY `index_custom_field_value_arrays_on_custom_field_label_id_24` (`custom_field_label_id_24`),
#   KEY `cfrdd_label_24_id` (`custom_field_label_id_24`),
# Column types:
#	  `custom_field_label_id_24` int(11) default null
# To remove this duplicate index, execute:
ALTER TABLE `pipelinedeals_production`.`custom_field_value_arrays` DROP INDEX `index_custom_field_value_arrays_on_custom_field_label_id_24`;

# index_custom_field_value_arrays_on_custom_field_label_id_23 is a duplicate of cfrdd_label_23_id
# Key definitions:
#   KEY `index_custom_field_value_arrays_on_custom_field_label_id_23` (`custom_field_label_id_23`),
#   KEY `cfrdd_label_23_id` (`custom_field_label_id_23`),
# Column types:
#	  `custom_field_label_id_23` int(11) default null
# To remove this duplicate index, execute:
ALTER TABLE `pipelinedeals_production`.`custom_field_value_arrays` DROP INDEX `index_custom_field_value_arrays_on_custom_field_label_id_23`;

# cfrdd_label_22_id is a duplicate of index_custom_field_value_arrays_on_custom_field_label_id_22
# Key definitions:
#   KEY `cfrdd_label_22_id` (`custom_field_label_id_22`),
#   KEY `index_custom_field_value_arrays_on_custom_field_label_id_22` (`custom_field_label_id_22`),
# Column types:
#	  `custom_field_label_id_22` int(11) default null
# To remove this duplicate index, execute:
ALTER TABLE `pipelinedeals_production`.`custom_field_value_arrays` DROP INDEX `cfrdd_label_22_id`;

# cfrdd_label_21_id is a duplicate of index_custom_field_value_arrays_on_custom_field_label_id_21
# Key definitions:
#   KEY `cfrdd_label_21_id` (`custom_field_label_id_21`),
#   KEY `index_custom_field_value_arrays_on_custom_field_label_id_21` (`custom_field_label_id_21`),
# Column types:
#	  `custom_field_label_id_21` int(11) default null
# To remove this duplicate index, execute:
ALTER TABLE `pipelinedeals_production`.`custom_field_value_arrays` DROP INDEX `cfrdd_label_21_id`;

# cfrdd_label_20_id is a duplicate of index_custom_field_value_arrays_on_custom_field_label_id_20
# Key definitions:
#   KEY `cfrdd_label_20_id` (`custom_field_label_id_20`),
#   KEY `index_custom_field_value_arrays_on_custom_field_label_id_20` (`custom_field_label_id_20`),
# Column types:
#	  `custom_field_label_id_20` int(11) default null
# To remove this duplicate index, execute:
ALTER TABLE `pipelinedeals_production`.`custom_field_value_arrays` DROP INDEX `cfrdd_label_20_id`;

# index_custom_field_value_arrays_on_custom_field_label_id_1 is a duplicate of cfrdd_label_1_id
# Key definitions:
#   KEY `index_custom_field_value_arrays_on_custom_field_label_id_1` (`custom_field_label_id_1`),
#   KEY `cfrdd_label_1_id` (`custom_field_label_id_1`),
# Column types:
#	  `custom_field_label_id_1` int(11) default null
# To remove this duplicate index, execute:
ALTER TABLE `pipelinedeals_production`.`custom_field_value_arrays` DROP INDEX `index_custom_field_value_arrays_on_custom_field_label_id_1`;

# index_custom_field_value_arrays_on_custom_field_label_id_19 is a duplicate of cfrdd_label_19_id
# Key definitions:
#   KEY `index_custom_field_value_arrays_on_custom_field_label_id_19` (`custom_field_label_id_19`),
#   KEY `cfrdd_label_19_id` (`custom_field_label_id_19`),
# Column types:
#	  `custom_field_label_id_19` int(11) default null
# To remove this duplicate index, execute:
ALTER TABLE `pipelinedeals_production`.`custom_field_value_arrays` DROP INDEX `index_custom_field_value_arrays_on_custom_field_label_id_19`;

# cfrdd_label_18_id is a duplicate of index_custom_field_value_arrays_on_custom_field_label_id_18
# Key definitions:
#   KEY `cfrdd_label_18_id` (`custom_field_label_id_18`),
#   KEY `index_custom_field_value_arrays_on_custom_field_label_id_18` (`custom_field_label_id_18`),
# Column types:
#	  `custom_field_label_id_18` int(11) default null
# To remove this duplicate index, execute:
ALTER TABLE `pipelinedeals_production`.`custom_field_value_arrays` DROP INDEX `cfrdd_label_18_id`;

# cfrdd_label_17_id is a duplicate of index_custom_field_value_arrays_on_custom_field_label_id_17
# Key definitions:
#   KEY `cfrdd_label_17_id` (`custom_field_label_id_17`),
#   KEY `index_custom_field_value_arrays_on_custom_field_label_id_17` (`custom_field_label_id_17`),
# Column types:
#	  `custom_field_label_id_17` int(11) default null
# To remove this duplicate index, execute:
ALTER TABLE `pipelinedeals_production`.`custom_field_value_arrays` DROP INDEX `cfrdd_label_17_id`;

# cfrdd_label_16_id is a duplicate of index_custom_field_value_arrays_on_custom_field_label_id_16
# Key definitions:
#   KEY `cfrdd_label_16_id` (`custom_field_label_id_16`),
#   KEY `index_custom_field_value_arrays_on_custom_field_label_id_16` (`custom_field_label_id_16`),
# Column types:
#	  `custom_field_label_id_16` int(11) default null
# To remove this duplicate index, execute:
ALTER TABLE `pipelinedeals_production`.`custom_field_value_arrays` DROP INDEX `cfrdd_label_16_id`;

# index_custom_field_value_arrays_on_custom_field_label_id_15 is a duplicate of cfrdd_label_15_id
# Key definitions:
#   KEY `index_custom_field_value_arrays_on_custom_field_label_id_15` (`custom_field_label_id_15`),
#   KEY `cfrdd_label_15_id` (`custom_field_label_id_15`),
# Column types:
#	  `custom_field_label_id_15` int(11) default null
# To remove this duplicate index, execute:
ALTER TABLE `pipelinedeals_production`.`custom_field_value_arrays` DROP INDEX `index_custom_field_value_arrays_on_custom_field_label_id_15`;

# cfrdd_label_14_id is a duplicate of index_custom_field_value_arrays_on_custom_field_label_id_14
# Key definitions:
#   KEY `cfrdd_label_14_id` (`custom_field_label_id_14`),
#   KEY `index_custom_field_value_arrays_on_custom_field_label_id_14` (`custom_field_label_id_14`),
# Column types:
#	  `custom_field_label_id_14` int(11) default null
# To remove this duplicate index, execute:
ALTER TABLE `pipelinedeals_production`.`custom_field_value_arrays` DROP INDEX `cfrdd_label_14_id`;

# index_custom_field_value_arrays_on_custom_field_label_id_13 is a duplicate of cfrdd_label_13_id
# Key definitions:
#   KEY `index_custom_field_value_arrays_on_custom_field_label_id_13` (`custom_field_label_id_13`),
#   KEY `cfrdd_label_13_id` (`custom_field_label_id_13`),
# Column types:
#	  `custom_field_label_id_13` int(11) default null
# To remove this duplicate index, execute:
ALTER TABLE `pipelinedeals_production`.`custom_field_value_arrays` DROP INDEX `index_custom_field_value_arrays_on_custom_field_label_id_13`;

# cfrdd_label_12_id is a duplicate of index_custom_field_value_arrays_on_custom_field_label_id_12
# Key definitions:
#   KEY `cfrdd_label_12_id` (`custom_field_label_id_12`),
#   KEY `index_custom_field_value_arrays_on_custom_field_label_id_12` (`custom_field_label_id_12`),
# Column types:
#	  `custom_field_label_id_12` int(11) default null
# To remove this duplicate index, execute:
ALTER TABLE `pipelinedeals_production`.`custom_field_value_arrays` DROP INDEX `cfrdd_label_12_id`;

# index_custom_field_value_arrays_on_custom_field_label_id_11 is a duplicate of cfrdd_label_11_id
# Key definitions:
#   KEY `index_custom_field_value_arrays_on_custom_field_label_id_11` (`custom_field_label_id_11`),
#   KEY `cfrdd_label_11_id` (`custom_field_label_id_11`),
# Column types:
#	  `custom_field_label_id_11` int(11) default null
# To remove this duplicate index, execute:
ALTER TABLE `pipelinedeals_production`.`custom_field_value_arrays` DROP INDEX `index_custom_field_value_arrays_on_custom_field_label_id_11`;

# cfrdd_label_10_id is a duplicate of index_custom_field_value_arrays_on_custom_field_label_id_10
# Key definitions:
#   KEY `cfrdd_label_10_id` (`custom_field_label_id_10`),
#   KEY `index_custom_field_value_arrays_on_custom_field_label_id_10` (`custom_field_label_id_10`),
# Column types:
#	  `custom_field_label_id_10` int(11) default null
# To remove this duplicate index, execute:
ALTER TABLE `pipelinedeals_production`.`custom_field_value_arrays` DROP INDEX `cfrdd_label_10_id`;

# cfrdd_account_id is a duplicate of index_custom_field_value_arrays_on_account_id
# Key definitions:
#   KEY `cfrdd_account_id` (`account_id`),
#   KEY `index_custom_field_value_arrays_on_account_id` (`account_id`),
# Column types:
#	  `account_id` int(11) default null
# To remove this duplicate index, execute:
ALTER TABLE `pipelinedeals_production`.`custom_field_value_arrays` DROP INDEX `cfrdd_account_id`;

# ########################################################################
# pipelinedeals_production.internal_audits
# ########################################################################

# index_audits_on_auditable_id is a left-prefix of auditable_index
# Key definitions:
#   KEY `index_audits_on_auditable_id` (`auditable_id`),
#   KEY `auditable_index` (`auditable_id`,`auditable_type`),
# Column types:
#	  `auditable_id` int(11) default null
#	  `auditable_type` varchar(255) default null
# To remove this duplicate index, execute:
ALTER TABLE `pipelinedeals_production`.`internal_audits` DROP INDEX `index_audits_on_auditable_id`;

# ########################################################################
# pipelinedeals_production.people
# ########################################################################

# index_people_on_contact_ruleset_id is a duplicate of people_contact_ruleset_id
# Key definitions:
#   KEY `index_people_on_contact_ruleset_id` (`contact_ruleset_id`),
#   KEY `people_contact_ruleset_id` (`contact_ruleset_id`),
# Column types:
#	  `contact_ruleset_id` int(11) default null
# To remove this duplicate index, execute:
ALTER TABLE `pipelinedeals_production`.`people` DROP INDEX `index_people_on_contact_ruleset_id`;

# ########################################################################
# Summary of indexes
# ########################################################################

# Size Duplicate Indexes   71286635
# Total Duplicate Indexes  29
# Total Indexes            404