701840 - mdn: examine unique index on table

Status: RESOLVED FIXED

(Data & BI Services Team :: DB: MySQL, task)

Description

[Luke Crouch [:groovecoder]]

For bug 700673 we need to know if the actioncounters_actioncounterunique table has the right unique index. Give us a

show create table actioncounters_actioncounterunique;

Comment 1

[Dave Miller [:justdave]]

What site is this for?  developer.mozilla.org's database has no such table.

Comment 2

[Dave Miller [:justdave]]

Take that back, it's using more than one database.  And there's no docs saying so.

Here you go:

CREATE TABLE `actioncounters_actioncounterunique` (
  `id` int(11) NOT NULL auto_increment,
  `content_type_id` int(11) NOT NULL,
  `object_pk` varchar(32) NOT NULL,
  `name` varchar(64) NOT NULL,
  `total` int(11) default '0',
  `ip` varchar(40) default NULL,
  `user_agent` varchar(255) default NULL,
  `user_id` int(11) default NULL,
  `modified` datetime default NULL,
  `unique_hash` varchar(32),
  PRIMARY KEY  (`id`),
  KEY `actioncounters_actioncounterunique_e4470c6e` (`content_type_id`),
  KEY `actioncounters_actioncounterunique_52094d6e` (`name`),
  KEY `actioncounters_actioncounterunique_49a8a8f2` (`ip`),
  KEY `actioncounters_actioncounterunique_c8b0e61e` (`user_agent`),
  KEY `actioncounters_actioncounterunique_fbfc09f1` (`user_id`),
  KEY `actioncounters_actioncounterunique_9b44d0ac` (`unique_hash`)
) ENGINE=MyISAM AUTO_INCREMENT=408895 DEFAULT CHARSET=utf8

Comment 3

[Dave Miller [:justdave]]

fwiw, all those indexes that have "unique" in the name don't actually appear to be defined as unique.