DROP TABLE IF EXISTS cities;
CREATE TABLE cities (
	id INT(5) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
	zipcode VARCHAR(5) NOT NULL,
	city VARCHAR(255) NOT NULL,
	date_update DATETIME NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE INDEX idx_date_update ON cities (date_update) USING BTREE;