user city schema

CREATE TABLE `city` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `name` VARCHAR(50) NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE INDEX `name` (`name`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
;


CREATE TABLE `user` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `city_id` INT(11) NOT NULL,
    PRIMARY KEY (`id`),
    INDEX `city_id` (`city_id`),
    CONSTRAINT `city_id` FOREIGN KEY (`city_id`) REFERENCES `city` (`id`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
;