CREATE TABLE `loot_fishing` ( `index` int(11) unsigned NOT NULL auto_increment, `entryid` int(11) unsigned NOT NULL default '0', `itemid` int(11) unsigned NOT NULL default '0', `percentchance` float NOT NULL default '0', `count` int(11) unsigned NOT NULL default '1', PRIMARY KEY (`index`), UNIQUE KEY `index` (`index`)