Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [root@mmtest01 ~]# pt-duplicate-key-checker --database drupal
- # ########################################################################
- # drupal.node
- # ########################################################################
- # nid is a left-prefix of PRIMARY
- # Key definitions:
- # KEY `nid` (`nid`)
- # PRIMARY KEY (`nid`,`vid`),
- # Column types:
- # `nid` int(10) unsigned not null auto_increment
- # `vid` int(10) unsigned not null default '0'
- # To remove this duplicate index, execute:
- ALTER TABLE `drupal`.`node` DROP INDEX `nid`;
- # status is a left-prefix of node_status_type
- # Key definitions:
- # KEY `status` (`status`),
- # KEY `node_status_type` (`status`,`type`,`nid`),
- # Column types:
- # `status` int(11) not null default '1'
- # `type` varchar(32) not null default ''
- # `nid` int(10) unsigned not null auto_increment
- # To remove this duplicate index, execute:
- ALTER TABLE `drupal`.`node` DROP INDEX `status`;
- # ########################################################################
- # drupal.term_hierarchy
- # ########################################################################
- # tid is a left-prefix of PRIMARY
- # Key definitions:
- # KEY `tid` (`tid`),
- # PRIMARY KEY (`tid`,`parent`),
- # Column types:
- # `tid` int(10) unsigned not null default '0'
- # `parent` int(10) unsigned not null default '0'
- # To remove this duplicate index, execute:
- ALTER TABLE `drupal`.`term_hierarchy` DROP INDEX `tid`;
- # ########################################################################
- # drupal.term_node
- # ########################################################################
- # tid is a left-prefix of PRIMARY
- # Key definitions:
- # KEY `tid` (`tid`)
- # PRIMARY KEY (`tid`,`nid`),
- # Column types:
- # `tid` int(10) unsigned not null default '0'
- # `nid` int(10) unsigned not null default '0'
- # To remove this duplicate index, execute:
- ALTER TABLE `drupal`.`term_node` DROP INDEX `tid`;
- # ########################################################################
- # Summary of indexes
- # ########################################################################
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement