· 6 years ago · May 21, 2019, 01:16 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 PRIMARY KEY (`id`)
6)
7 ENGINE InnoDB
8 CHARACTER SET `utf8mb4`
9 COLLATE `utf8mb4_general_ci`;