DROP TABLE IF EXISTS city; CREATE TABLE city ( city_id int(14) NOT NULL auto_increment, city_name varchar(255) NOT NULL, city_timestamp timestamp(14), PRIMARY KEY (city_id) );
# # Dumping data for table "city" #
INSERT INTO city VALUES( "1", "London", "20000917122625"); INSERT INTO city VALUES( "2", "London", "20000917122626"); INSERT INTO city VALUES( "3", "London", "20000917122626"); INSERT INTO city VALUES( "4", "London", "20000917122627"); INSERT INTO city VALUES( "5", "Paris", "20000917122631"); INSERT INTO city VALUES( "6", "Paris", "20000917122632"); INSERT INTO city VALUES( "7", "New York", "20000917122644"); INSERT INTO city VALUES( "8", "New York", "20000917122645"); INSERT INTO city VALUES( "9", "New York", "20000917122646"); INSERT INTO city VALUES( "10", "New York", "20000917122646"); INSERT INTO city VALUES( "11", "New York", "20000917122647"); INSERT INTO city VALUES( "12", "Hong Kong", "20000917122654");