Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # ########################################################################
- # 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`;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement