664914 - Our keys on feedback_opinion are ridiculous

Status: RESOLVED WONTFIX

(Input Graveyard :: Backend, defect)

Description

[Dave Dash [:davedash, :dd] (assign all bugs to mbrandt)]

CREATE TABLE `feedback_opinion` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` smallint(5) unsigned NOT NULL DEFAULT '1',
  `url` varchar(200) NOT NULL,
  `description` longtext NOT NULL,
  `user_agent` varchar(255) NOT NULL,
  `product` smallint(5) unsigned NOT NULL,
  `version` varchar(30) NOT NULL,
  `platform` varchar(30) DEFAULT NULL,
  `locale` varchar(30) NOT NULL,
  `manufacturer` varchar(255) NOT NULL,
  `device` varchar(255) NOT NULL,
  `created` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `cpvp` (`created`,`product`,`version`),
  KEY `product` (`product`,`version`),
  KEY `cpv` (`created`,`product`,`version`),
  KEY `manufacturer` (`manufacturer`,`device`),
  KEY `type` (`type`),
  KEY `created` (`created`),
  KEY `product_2` (`product`),
  KEY `version` (`version`),
  KEY `os` (`platform`),
  KEY `locale` (`locale`)
) ENGINE=InnoDB AUTO_INCREMENT=2135764 DEFAULT CHARSET=utf8 

My guess is get rid of cpvp, but there seems to be a lot of overlap.  CCing mpressman in case he's got some ideas.

Comment 1

[Will Kahn-Greene [:willkg] ET needinfo? me]

This is for the old input. Nixing this as WONTFIX.