Slide 19
Slide 19 text
Data
CREATE TABLE `cities` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`latitude` double DEFAULT NULL,
`longitude` double DEFAULT NULL,
`seo_name` varchar(255) DEFAULT NULL,
`country_id` int(11) DEFAULT NULL,
`inhabitants` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `index_cities_on_seo_name` (`seo_name`),
KEY `index_cities_on_country_id` (`country_id`),
) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8;