REPLACE INTO `s_core_countries` (`id`, `countryname`, `countryiso`, `areaID`, `countryen`, `position`, `notice`, `taxfree`, `taxfree_ustid`, `taxfree_ustid_checked`, `active`, `iso3`, `display_state_in_registration`, `force_state_in_registration`) VALUES
(34, 'Großbritannien', 'GB', 3, 'Great Britain', 10, '', 0, 1, 0, 1, 'GBR', 0, 0),
(35, 'Irland', 'IE', 3, 'Ireland', 10, '', 0, 1, 0, 1, 'IRL', 0, 0),
(37, 'Italien', 'IT', 3, 'Italy', 10, '', 0, 1, 0, 1, 'ITA', 0, 0),
(38, 'Luxemburg', 'LU', 3, 'Luxembourg', 10, '', 0, 1, 0, 1, 'LUX', 0, 0),
(39, 'Niederlande', 'NL', 3, 'Netherlands', 10, '', 0, 1, 0, 1, 'NLD', 0, 0),
(41, 'Portugal', 'PT', 3, 'Portugal', 10, '', 0, 1, 0, 1, 'PRT', 0, 0),
(42, 'Schweden', 'SE', 3, 'Sweden', 10, '', 0, 1, 0, 1, 'SWE', 0, 0),
(43, 'Spanien', 'ES', 3, 'Spain', 10, '', 0, 1, 0, 1, 'ESP', 0, 0),
(44, 'Liechtenstein', 'LI', 2, 'Liechtenstein', 100, '', 1, 0, 0, 1, 'LIE', 0, 0),
(45, 'Polen', 'PL', 3, 'Poland', 10, '', 0, 1, 0, 1, 'POL', 0, 0),
(46, 'Ungarn', 'HU', 3, 'Hungary', 10, '', 0, 1, 0, 1, 'HUN', 0, 0),
(47, 'Tschechien', 'CZ', 3, 'Czech Republic', 10, '', 0, 1, 0, 1, 'CZE', 0, 0),
(48, 'Slowakei', 'SK', 3, 'Slovakia', 10, '', 0, 1, 0, 1, 'SVK', 0, 0),
(49, 'Rumänien', 'RO', 3, 'Romania', 10, '', 0, 1, 0, 1, 'ROU', 0, 0),
(50, 'Estland', 'EE', 3, 'Estonia', 10, '', 0, 1, 0, 1, 'EST', 0, 0),
(51, 'Lettland', 'LV', 3, 'Latvia', 10, '', 0, 1, 0, 1, 'LVA', 0, 0),
(56, 'Kanarische Inseln', 'IC', 3, 'Canary Islands ', 10, '', 0, 1, 0, 1, '', 0, 0),
(57, 'Kroatien', 'HR', 3, 'Croatia', 10, '', 0, 1, 0, 1, 'HRV', 0, 0),
(58, 'Litauen', 'LT', 3, 'Lithuania', 10, '', 0, 1, 0, 1, 'LTU', 0, 0),
(59, 'Malta', 'MT', 3, 'Malta', 10, '', 0, 1, 0, 1, 'MLT', 0, 0),
(63, 'Slowenien', 'SI', 3, 'Slovenia', 10, '', 0, 1, 0, 1, 'SVN', 0, 0);
Habe mal ein paar Länder zum Einfügen in die s_core_countries zusammengestellt, kann sich ja jeder erweitern, wie er will.
Wichtig: die areaID muss lauten:
Deutschland 1
Welt 2
Europa 2