CREATE TABLE `domain` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `added` int(11) DEFAULT NULL,
  `updated` int(11) DEFAULT NULL,
  `expires` date DEFAULT NULL,
  `created` date DEFAULT NULL,
  `paid_till` date DEFAULT NULL,
  `free_date` date DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `registar_id` int(11) DEFAULT NULL,
  `num_subdomains` int(11) DEFAULT NULL,
  `delegated` int(11) DEFAULT '0',
  `zone` varchar(45) DEFAULT NULL,
  `ip_address_id` int(11) DEFAULT NULL,
  `crawled_date` date DEFAULT NULL,
  `liveinternet_traffic_updated_date` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`,`name`),
  UNIQUE KEY `name` (`name`),
  KEY `created` (`created`,`expires`,`delegated`),
  KEY `zone` (`zone`),
  KEY `ip_address_id` (`ip_address_id`),
  KEY `crawled_date` (`crawled_date`),
  KEY `liveinternet_traffic` (`liveinternet_traffic_updated_date`)
) ENGINE=InnoDB AUTO_INCREMENT=10649177 DEFAULT CHARSET=utf8
/*!50100 PARTITION BY KEY (`name`)
PARTITIONS 10 */