qayyumabro

CREATE TABLE `cities_pk` ( 
  `id` INT NOT NULL AUTO_INCREMENT , `name` VARCHAR(100) NOT NULL , PRIMARY KEY (`id`)
) ENGINE = MyISAM;

INSERT INTO cities_pk(name) values('Islamabad');
INSERT INTO cities_pk(name) values('Karachi');
INSERT INTO cities_pk(name) values('Lahore');
INSERT INTO cities_pk(name) values('Abbaspur');
INSERT INTO cities_pk(name) values('Abbottabad');
INSERT INTO cities_pk(name) values('Abdul Hakim');

qayyumabro

DROP TABLE IF EXISTS location;

CREATE TABLE IF NOT EXISTS `location` (
  `locId` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `country` varchar(2) DEFAULT NULL,
  `region` varchar(2) DEFAULT NULL,
  `city` varchar(1000) DEFAULT NULL,
  `postalCode` varchar(10) DEFAULT NULL,
  `latitude` float DEFAULT NULL,
  `longitude` float DEFAULT NULL,