[Tickets #7971] Re: rampage table index error

[bugs at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/7971
------------------------------------------------------------------------------
  Ticket             | 7971
  Updated By         | horde at smartsector.hu
  Summary            | rampage table index error
  Queue              | Kronolith
  Version            | Git master
  Type               | Bug
  State              | Feedback
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             | Michael Rubinsky, Chuck Hagenbuch
------------------------------------------------------------------------------


horde at smartsector.hu (2009-02-09 19:34) wrote:

the type id is the same:
+-----------+-----------------------------------------------+---------+
| object_id | object_name                                   | type_id |
+-----------+-----------------------------------------------+---------+
|         1 | 20090209224113.11603rqwzfxp9iih at myip |       2 |
|         2 | 20090209234236.14139w80iit4xxss at myip |       2 |
+-----------+-----------------------------------------------+---------+

I simply drop the index:
alter table rampage_objects drop index rampage_objects_type_object_name;

the creation method was not very professional :)
i create the SQL command by hand form the xml becasue this looked like  
the fastest way for me.

CREATE TABLE `rampage_objects` (
   `object_id` int(10) unsigned NOT NULL auto_increment,
   `object_name` varchar(255) NOT NULL,
   `type_id` int(10) unsigned NOT NULL,
   PRIMARY KEY  (`object_id`),
   UNIQUE KEY `rampage_objects_type_object_name` (`type_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;