Want more features on Pastebin? Sign Up, it's FREE!
Guest

Untitled

By: a guest on Aug 1st, 2013  |  syntax: MySQL  |  size: 2.31 KB  |  views: 51  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. [root@mmtest01 ~]# pt-duplicate-key-checker --database drupal
  2.  
  3. # ########################################################################
  4. # drupal.node                                                            
  5. # ########################################################################
  6.  
  7. # nid is a left-prefix of PRIMARY
  8. # Key definitions:
  9. #   KEY `nid` (`nid`)
  10. #   PRIMARY KEY (`nid`,`vid`),
  11. # Column types:
  12. #         `nid` int(10) unsigned not null auto_increment
  13. #         `vid` int(10) unsigned not null default '0'
  14. # To remove this duplicate index, execute:
  15. ALTER TABLE `drupal`.`node` DROP INDEX `nid`;
  16.  
  17. # status is a left-prefix of node_status_type
  18. # Key definitions:
  19. #   KEY `status` (`status`),
  20. #   KEY `node_status_type` (`status`,`type`,`nid`),
  21. # Column types:
  22. #         `status` int(11) not null default '1'
  23. #         `type` varchar(32) not null default ''
  24. #         `nid` int(10) unsigned not null auto_increment
  25. # To remove this duplicate index, execute:
  26. ALTER TABLE `drupal`.`node` DROP INDEX `status`;
  27.  
  28. # ########################################################################
  29. # drupal.term_hierarchy                                                  
  30. # ########################################################################
  31.  
  32. # tid is a left-prefix of PRIMARY
  33. # Key definitions:
  34. #   KEY `tid` (`tid`),
  35. #   PRIMARY KEY (`tid`,`parent`),
  36. # Column types:
  37. #         `tid` int(10) unsigned not null default '0'
  38. #         `parent` int(10) unsigned not null default '0'
  39. # To remove this duplicate index, execute:
  40. ALTER TABLE `drupal`.`term_hierarchy` DROP INDEX `tid`;
  41.  
  42. # ########################################################################
  43. # drupal.term_node                                                        
  44. # ########################################################################
  45.  
  46. # tid is a left-prefix of PRIMARY
  47. # Key definitions:
  48. #   KEY `tid` (`tid`)
  49. #   PRIMARY KEY (`tid`,`nid`),
  50. # Column types:
  51. #         `tid` int(10) unsigned not null default '0'
  52. #         `nid` int(10) unsigned not null default '0'
  53. # To remove this duplicate index, execute:
  54. ALTER TABLE `drupal`.`term_node` DROP INDEX `tid`;
  55.  
  56. # ########################################################################
  57. # Summary of indexes                                                      
  58. # ########################################################################
clone this paste RAW Paste Data