DROP TABLE IF EXISTS countries;
CREATE TABLE countries (
	id INT(5) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
	label VARCHAR(255) NOT NULL,
	domain VARCHAR(2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
ALTER TABLE cities CHANGE city label VARCHAR(255);
ALTER TABLE cities DROP COLUMN date_update;
ALTER TABLE cities ADD country_id SMALLINT UNSIGNED NOT NULL DEFAULT 0;
ALTER TABLE cities ADD CONSTRAINT fk_country_id FOREIGN KEY (country_id) REFERENCES countries(id);
INSERT INTO countries (id, label, domain) VALUES (NULL, 'France', 'fr');
INSERT INTO countries (id, label, domain) VALUES (NULL, 'Suisse', 'ch');