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');