CREATE TABLE `city` (
    `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
    `state_id` INT(10) UNSIGNED NOT NULL,
    `name` VARCHAR(512) NOT NULL,
    `slug` VARCHAR(512) NOT NULL,
    `total_branches` INT(10) UNSIGNED NOT NULL DEFAULT '0',
    `total_banks` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
    `seo_title` TEXT NOT NULL,
    `seo_description` TEXT NOT NULL,
    PRIMARY KEY (`id`),
    INDEX `city_state_fk` (`state_id`),
    INDEX `total_branches` (`total_branches`),
    INDEX `total_banks` (`total_banks`),
    INDEX `slug` (`slug`) USING HASH,
    INDEX `name_idx` (`name`) USING BTREE,
    FULLTEXT INDEX `name` (`name`),
    CONSTRAINT `city_state_fk` FOREIGN KEY (`state_id`) REFERENCES `state` (`id`) ON UPDATE NO ACTION ON DELETE NO ACTION
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=29726
;