CREATE TABLE `channels` ( `id` tinyint(3) unsigned NOT NULL auto_increment COMMENT 'PKEY for channels', `channel` char(32) NOT NULL COMMENT 'Name of the channel', `network` CHAR(16) NOT NULL COMMENT 'Name of the network', PRIMARY KEY (`id`), UNIQUE KEY `idx_channel` (`channel`, `network`) // Drop the old one, add this one ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Stores the channel names';