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
