Lines 526-531
DROP TABLE IF EXISTS `cities`;
Link Here
|
526 |
CREATE TABLE `cities` ( |
526 |
CREATE TABLE `cities` ( |
527 |
`cityid` int(11) NOT NULL auto_increment, |
527 |
`cityid` int(11) NOT NULL auto_increment, |
528 |
`city_name` varchar(100) NOT NULL default '', |
528 |
`city_name` varchar(100) NOT NULL default '', |
|
|
529 |
`city_state` VARCHAR( 100 ) NULL DEFAULT NULL, |
530 |
`city_country` VARCHAR( 100 ) NULL DEFAULT NULL, |
529 |
`city_zipcode` varchar(20) default NULL, |
531 |
`city_zipcode` varchar(20) default NULL, |
530 |
PRIMARY KEY (`cityid`) |
532 |
PRIMARY KEY (`cityid`) |
531 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
533 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
532 |
- |
|
|