Tickets :: Comment on [#7971] rampage table index error

* Your Email Address
* Spam protection	Enter the letters below: . .. .. .. . . \|\ \|\| \|\|_/ \| \| \| \| \\|\|/\\|\| \\|/\\|\__\|
Comment	> the type id is the same: > > +-----------+-----------------------------------------------+---------+ > > \| object_id \| object_name \| type_id \| > > +-----------+-----------------------------------------------+---------+ > > \| 1 \| 20090209224113.11603rqwzfxp9iih@myip \| 2 \| > > \| 2 \| 20090209234236.14139w80iit4xxss@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; > >
Attachment
Watch this ticket