Prestashop – desactivar todos los países

[cc]
UPDATE ps_country SET active=0 WHERE iso_code NOT LIKE ‘GB’
[/cc]

Valor ID de la zona península es: 9

INSERT INTO `ps_state` (`id_state`,`id_country`, `id_zone`, `name`, `iso_code`, `tax_behavior`, `active`) VALUES
(313, 6, 9, ‘La Coruña’, ‘C’, 0, 1),
(314, 6, 9, ‘Álava’, ‘VI’, 0, 1),
(315, 6, 9, ‘Albacete’ ,’AB’, 0, 1),
(316, 6, 9, ‘Alicante’, ‘A’, 0, 1),
(317, 6, 9, ‘Almería’, ‘AL’, 0, 1),
(318, 6, 9, ‘Asturias’, ‘O’, 0, 1),
(319, 6, 9, ‘Ávila’, ‘AV’, 0, 1),
(320, 6, 9, ‘Badajoz’, ‘BA’, 0, 1),
(321, 6, 11, ‘Islas Baleares’, ‘PM’, 0, 1),
(322, 6, 9, ‘Barcelona’, ‘B’, 0, 1),
(323, 6, 9, ‘Burgos’, ‘BU’, 0, 1),
(324, 6, 9, ‘Cáceres’, ‘CC’, 0, 1),
(325, 6, 9, ‘Cádiz’, ‘CA’, 0, 1),
(326, 6, 9, ‘Cantabria’, ‘S’, 0, 1),
(327, 6, 9, ‘Castellón’, ‘CS’, 0, 1),
(328, 6, 12, ‘Ceuta’, ‘CE’, 0, 1),
(329, 6, 9, ‘Ciudad Real’, ‘CR’, 0, 1),
(330, 6, 9, ‘Córdoba’, ‘CO’, 0, 1),
(331, 6, 9, ‘Cuenca’, ‘CU’, 0, 1),
(332, 6, 9, ‘Gerona’, ‘GI’, 0, 1),
(333, 6, 9, ‘Granada’, ‘GR’, 0, 1),
(343, 6, 9, ‘Guadalajara’, ‘GU’, 0, 1),
(345, 6, 9, ‘Guipuzcoa’, ‘SS’, 0, 1),
(346, 6, 9, ‘Huelva’, ‘H’, 0, 1),
(347, 6, 9, ‘Huesca’, ‘HU’, 0, 1),
(348, 6, 9, ‘Jaén’, ‘J’, 0, 1),
(349, 6, 9, ‘La Rioja’, ‘LO’, 0, 1),
(350, 6, 10, ‘Las Palmas’, ‘GC’, 0, 1),
(351, 6, 9, ‘León’, ‘LE’, 0, 1),
(352, 6, 9, ‘Lérida’, ‘L’, 0, 1),
(353, 6, 9, ‘Lugo’, ‘LU’, 0, 1),
(354, 6, 9, ‘Madrid’, ‘M’, 0, 1),
(355, 6, 9, ‘Málaga’, ‘MA’, 0, 1),
(356, 6, 12, ‘Melilla’, ‘ML’, 0, 1),
(357, 6, 9, ‘Murcia’, ‘MU’, 0, 1),
(358, 6, 9, ‘Navarra’, ‘NA’, 0, 1),
(359, 6, 9, ‘Orense’, ‘OR’, 0, 1),
(360, 6, 9, ‘Palencia’, ‘P’, 0, 1),
(361, 6, 9, ‘Pontevedra’, ‘PO’, 0, 1),
(362, 6, 9, ‘Salamanca’, ‘SA’, 0, 1),
(363, 6, 10, ‘Santa Cruz de Tenerife’, ‘TF’, 0, 1),
(364, 6, 9, ‘Segovia’, ‘SG’, 0, 1),
(365, 6, 9, ‘Sevilla’, ‘SE’, 0, 1),
(366, 6, 9, ‘Soria’, ‘SO’, 0, 1),
(367, 6, 9, ‘Tarragona’, ‘T’, 0, 1),
(368, 6, 9, ‘Teruel’, ‘TE’, 0, 1),
(369, 6, 9, ‘Toledo’, ‘TO’, 0, 1),
(370, 6, 9, ‘Valencia’, ‘V’, 0, 1),
(371, 6, 9, ‘Valladolid’, ‘VA’, 0, 1),
(372, 6, 9, ‘Vizcaya’, ‘BI’, 0, 1),
(373, 6, 9, ‘Zamora’, ‘ZA’, 0, 1),
(374, 6, 9, ‘Zaragoza’, ‘Z’, 0, 1);