Skip to content
Find file
Fetching contributors…
Cannot retrieve contributors at this time
15 lines (15 sloc) 326 Bytes
CREATE TABLE IF NOT EXISTS %scities (
`city_id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
`name` VARCHAR(64) NOT NULL,
`population` INT(9) NULL,
`country_id` INT NOT NULL,
`deleted_dt` TIMESTAMP NULL DEFAULT NULL,
INDEX (
`country_id`
),
UNIQUE (
`name`
)
)
ENGINE = MyISAM
COMMENT = 'Cities related to countries';
Jump to Line
Something went wrong with that request. Please try again.