1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 | | PHP-Quelltext 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'); |