ALTER TABLE `categories` ADD INDEX `url` (`url` (333))<br />ALTER TABLE `categories` ADD INDEX `parentid` (`parentid`)<br />ALTER TABLE `goods` ADD INDEX `url` (`url` (333))<br />ALTER TABLE `goods` ADD INDEX `time` (`time`)<br />ALTER TABLE `goods` ADD INDEX `categoryid` (`categoryid`)<br />ALTER TABLE `goods` ADD INDEX `count` (`count`)<br />ALTER TABLE `goods` ADD INDEX `featured` (`featured`)<br />ALTER TABLE `goods` ADD INDEX `categoryid_time` (`categoryid`, `time`)<br />ALTER TABLE `goods` ADD INDEX `categoryid_count` (`categoryid`, `count`)<br />ALTER TABLE `goods` ADD INDEX `categoryid_id` (`categoryid`, `id`)<br />ALTER TABLE `goods` ADD INDEX `name_categoryid` (`name` (256), `categoryid`)<br />ALTER TABLE `goods` ADD INDEX `categoryid_price` (`categoryid`, `price`)<br />ALTER TABLE `goods` ADD INDEX `categoryid_name` (`categoryid`, `name` (3))<br />ALTER TABLE `goods` ADD INDEX `pusherid_availability` (`pusherId`, `availability`)<br />ALTER TABLE `products_tags` ADD INDEX `product_tag` (`product_id`, `tag_id`)<br />ALTER TABLE `product_pushers` ADD INDEX `categoryid` (`categoryid`)<br />ALTER TABLE `product_pushers` ADD INDEX `last` (`last`)<br />ALTER TABLE `static_pages` ADD INDEX `url` (`url` (333))<br />ALTER TABLE `tags` ADD INDEX `search` (`search`)<br />ALTER TABLE `tags` ADD INDEX `tag` (`tag` (333))<br />ALTER TABLE `tags` ADD INDEX `cnt` (`cnt`)<br />CREATE TABLE `links` (
  `id` int(11) NOT NULL auto_increment,
  `title` text NOT NULL,
  `url` text NOT NULL,
  `active` enum('0','1') NOT NULL,
  `exists` enum('0','1') NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `url` (`url`(333))
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;<br />