Drop Uniq Key on Racktables DB

mysql> show databases;

+----------------------------+
| Database                   |
+----------------------------+
| information_schema |
| mysql                          |
| racktables_db           |
+----------------------------+
5 rows in set (0.00 sec)
use racktables_db;
mysql> describe Object;
+--------------------+-----------------------+------+-------+---------+---------------------+
| Field                 | Type                     | Null | Key    | Default | Extra                |
+--------------------+-----------------------+------+-------+---------+---------------------+
| id                       | int(10) unsigned | NO   | PRI   | NULL | auto_increment |
| name                | char(255)             | YES |          | NULL |                            |
| label                  | char(255)            | YES |          | NULL |                             |
| objtype_id        | int(10) unsigned | NO    | MUL | 1        |                            |
| asset_no          | char(64)              | YES  | UNI   | NULL |                            |
| has_problems | enum('yes','no')   | NO   |           | no      |                            |
| comment          | text                       | YES |           | NULL |                           |
+--------------------+-----------------------+------+--------+---------+--------------------+
7 rows in set (0.00 sec)

mysql> show create table Object;
+--------+----------------------------------------------------------------------------------------------------+
| Table  | Create Table                                                                                                       |
+--------+----------------------------------------------------------------------------------------------------+
| Object | CREATE TABLE `Object` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` char(255) default NULL,
`label` char(255) default NULL,
`objtype_id` int(10) unsigned NOT NULL default '1',
`asset_no` char(64) default NULL,
`has_problems` enum('yes','no') NOT NULL default 'no',
`comment` text,
PRIMARY KEY (`id`),
UNIQUE KEY `asset_no` (`asset_no`),
KEY `id-tid` (`id`,`objtype_id`),
KEY `type_id` (`objtype_id`,`id`)
) ENGINE=InnoDB AUTO_INCREMENT=157 DEFAULT CHARSET=utf8 |
+--------+----------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> alter table Object drop index asset_no;
Query OK, 101 rows affected (0.05 sec)
Records: 101 Duplicates: 0 Warnings: 0