DROP TABLE IF EXISTS phpkit_usermap_countries;
CREATE TABLE phpkit_usermap_countries (
map_from varchar(16) NOT NULL default '',
map_to enum('AT','DE','CH') NOT NULL default 'AT',
PRIMARY KEY (map_from)
) TYPE=MyISAM;

INSERT INTO phpkit_usermap_countries (map_from, map_to) VALUES ('aut', 'AT');
INSERT INTO phpkit_usermap_countries (map_from, map_to) VALUES ('ch', 'CH');
INSERT INTO phpkit_usermap_countries (map_from, map_to) VALUES ('ger', 'DE');
INSERT INTO phpkit_usermap_countries (map_from, map_to) VALUES ('def', 'DE');
INSERT INTO phpkit_usermap_countries (map_from, map_to) VALUES ('Austria', 'AT');
INSERT INTO phpkit_usermap_countries (map_from, map_to) VALUES ('Swizerland', 'CH');
INSERT INTO phpkit_usermap_countries (map_from, map_to) VALUES ('Switzerland', 'CH');
INSERT INTO phpkit_usermap_countries (map_from, map_to) VALUES ('Germany', 'DE');
INSERT INTO phpkit_usermap_countries (map_from, map_to) VALUES ('nw', 'DE');
INSERT INTO phpkit_usermap_countries (map_from, map_to) VALUES ('bw', 'DE');
INSERT INTO phpkit_usermap_countries (map_from, map_to) VALUES ('bay', 'DE');
INSERT INTO phpkit_usermap_countries (map_from, map_to) VALUES ('b', 'DE');
INSERT INTO phpkit_usermap_countries (map_from, map_to) VALUES ('bb', 'DE');
INSERT INTO phpkit_usermap_countries (map_from, map_to) VALUES ('hb', 'DE');
INSERT INTO phpkit_usermap_countries (map_from, map_to) VALUES ('hh', 'DE');
INSERT INTO phpkit_usermap_countries (map_from, map_to) VALUES ('h', 'DE');
INSERT INTO phpkit_usermap_countries (map_from, map_to) VALUES ('mv', 'DE');
INSERT INTO phpkit_usermap_countries (map_from, map_to) VALUES ('n', 'DE');
INSERT INTO phpkit_usermap_countries (map_from, map_to) VALUES ('rp', 'DE');
INSERT INTO phpkit_usermap_countries (map_from, map_to) VALUES ('s', 'DE');
INSERT INTO phpkit_usermap_countries (map_from, map_to) VALUES ('sa', 'DE');
INSERT INTO phpkit_usermap_countries (map_from, map_to) VALUES ('saa', 'DE');
INSERT INTO phpkit_usermap_countries (map_from, map_to) VALUES ('sh', 'DE');
INSERT INTO phpkit_usermap_countries (map_from, map_to) VALUES ('t', 'DE');
INSERT INTO phpkit_usermap_countries (map_from, map_to) VALUES ('oth', 'DE');
INSERT INTO phpkit_usermap_countries (map_from, map_to) VALUES ('00', 'DE');