jvBCuqJ6

1CREATE TABLE IF NOT EXISTS `cities` (
2`id` int(11) NOT NULL,
3  `zone_id` int(11) NOT NULL,
4  `state_id` int(11) NOT NULL,
5  `name` varchar(255) NOT NULL,
6  `code` varchar(255) NOT NULL,
7  `total_sample` int(11) NOT NULL,
8  `population` int(11) NOT NULL,
9  `is_active` tinyint(1) NOT NULL,
10  `created` datetime NOT NULL,
11  `modified` datetime NOT NULL
12) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
13
14--
15-- Dumping data for table `cities`
16--
17
18INSERT INTO `cities` (`id`, `zone_id`, `state_id`, `name`, `code`, `total_sample`, `population`, `is_active`, `created`, `modified`) VALUES
19(1, 2, 2, 'avadi', '15018', 10, 100, 1, '2016-10-03 00:00:00', '2016-10-03 00:00:00');