DROP TABLE IF EXISTS `region`;

CREATE TABLE `region` (
`region_id` INTEGER PRIMARY KEY AUTOINCREMENT,
`country_id` INT NOT NULL,
`name` TEXT NOT NULL,
`code` TEXT NOT NULL,
`status` TINYINT NOT NULL DEFAULT '1'
-- PRIMARY KEY (`region_id`)
);

CREATE INDEX `region_country_id` ON `region` (`country_id`);
