· 6 years ago · May 20, 2019, 01:20 PM
1CREATE TABLE IF NOT EXISTS `locality` (
2 `id` INT(11) UNSIGNED AUTO_INCREMENT,
3 `locality` VARCHAR(255) NOT NULL,
4 `parent_id` INT(11) UNSIGNED NOT NULL,
5 `active` TINYINT(1) DEFAULT 1 NOT NULL,
6 INDEX route_active_index (active),
7 PRIMARY KEY (`id`)
8)
9 ENGINE InnoDB
10 CHARACTER SET `utf8mb4`
11 COLLATE `utf8mb4_general_ci`;