CREATE TABLE `state` (
    `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    `country_id` INT(10) UNSIGNED NOT NULL,
    `name` VARCHAR(255) NOT NULL,
    `total_branches` MEDIUMINT(8) UNSIGNED NOT NULL,
    `total_banks` MEDIUMINT(8) UNSIGNED NOT NULL,
    `total_cities` MEDIUMINT(8) UNSIGNED NOT NULL,
    `seo_title` TEXT NOT NULL,
    `seo_description` TEXT NOT NULL,
    `slug` VARCHAR(255) NOT NULL,
    `ansi_code` CHAR(2) NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE INDEX `ansi_code_UNIQUE` (`ansi_code`),
    UNIQUE INDEX `slug` (`slug`),
    INDEX `state_country_fk_idx` (`country_id`),
    INDEX `key_slug` (`slug`) USING HASH,
    CONSTRAINT `state_country_fk` FOREIGN KEY (`country_id`) REFERENCES `country` (`id`) ON UPDATE NO ACTION ON DELETE NO ACTION
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=51
;