-- 9900 to 9910
-- main 
-- nada na main
-- domain

ALTER TABLE `Listing_Category` ADD INDEX `category_listing_id` ( `category_id` , `category_root_id` , `listing_id` );
ALTER TABLE `Listing_Summary` ADD INDEX `rating_filter` ( `level` , `status` , `avg_review` ), ADD INDEX `price_filter` ( `level` , `status` , `price` );

CREATE TABLE IF NOT EXISTS `Promotion_LocationCounter` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `location_level` int(11) NOT NULL,
  `location_id` int(11) NOT NULL,
  `count` int(11) NOT NULL,
  `title` varchar(255) CHARACTER SET utf8 NOT NULL,
  `full_friendly_url` varchar(255) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

