- Estats (activació automàtica per pack de localització)
—————————————————————-
- Estats (activació automàtica per db)
SET NAMES ‘utf8’;
—
— Agregamos las zonas de España
—
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES
(9, ‘Peninsula’, 1),
(10, ‘Canarias’, 1),
(11, ‘Baleares’, 1),
(12, ‘Ceuta y Melilla’, 1);
—
— Activamos los estados en España
—
UPDATE `ps_country` SET `contains_states` = 1 WHERE `id_country` = 6;
—
— Preparamos el campo ISO_CODE para aceptar 5 caracteres
—
ALTER TABLE `ps_state` MODIFY `iso_code` char(5) NOT NULL;
—
— Agregamos las provincias y asignamos su zona
—
INSERT INTO `ps_state` (`id_state`,`id_country`, `id_zone`, `name`, `iso_code`, `tax_behavior`, `active`) VALUES
(501, 6, 9, ‘La Coruña’, ‘C’, 0, 1),
(502, 6, 9, ‘Álava’, ‘VI’, 0, 1),
(503, 6, 9, ‘Albacete’ ,’AB’, 0, 1),
(504, 6, 9, ‘Alicante’, ‘A’, 0, 1),
(505, 6, 9, ‘Almería’, ‘AL’, 0, 1),
(506, 6, 9, ‘Asturias’, ‘O’, 0, 1),
(507, 6, 9, ‘Ávila’, ‘AV’, 0, 1),
(508, 6, 9, ‘Badajoz’, ‘BA’, 0, 1),
(509, 6, 11, ‘Islas Baleares’, ‘PM’, 0, 1),
(510, 6, 9, ‘Barcelona’, ‘B’, 0, 1),
(511, 6, 9, ‘Burgos’, ‘BU’, 0, 1),
(512, 6, 9, ‘Cáceres’, ‘CC’, 0, 1),
(513, 6, 9, ‘Cádiz’, ‘CA’, 0, 1),
(514, 6, 9, ‘Cantabria’, ‘S’, 0, 1),
(515, 6, 9, ‘Castellón’, ‘CS’, 0, 1),
(516, 6, 12, ‘Ceuta’, ‘CE’, 0, 1),
(517, 6, 9, ‘Ciudad Real’, ‘CR’, 0, 1),
(518, 6, 9, ‘Córdoba’, ‘CO’, 0, 1),
(519, 6, 9, ‘Cuenca’, ‘CU’, 0, 1),
(520, 6, 9, ‘Gerona’, ‘GI’, 0, 1),
(521, 6, 9, ‘Granada’, ‘GR’, 0, 1),
(522, 6, 9, ‘Guadalajara’, ‘GU’, 0, 1),
(523, 6, 9, ‘Guipuzcoa’, ‘SS’, 0, 1),
(524, 6, 9, ‘Huelva’, ‘H’, 0, 1),
(525, 6, 9, ‘Huesca’, ‘HU’, 0, 1),
(526, 6, 9, ‘Jaén’, ‘J’, 0, 1),
(527, 6, 9, ‘La Rioja’, ‘LO’, 0, 1),
(528, 6, 10, ‘Las Palmas’, ‘GC’, 0, 1),
(529, 6, 9, ‘León’, ‘LE’, 0, 1),
(530, 6, 9, ‘Lérida’, ‘L’, 0, 1),
(531, 6, 9, ‘Lugo’, ‘LU’, 0, 1),
(532, 6, 9, ‘Madrid’, ‘M’, 0, 1),
(533, 6, 9, ‘Málaga’, ‘MA’, 0, 1),
(534, 6, 12, ‘Melilla’, ‘ML’, 0, 1),
(535, 6, 9, ‘Murcia’, ‘MU’, 0, 1),
(536, 6, 9, ‘Navarra’, ‘NA’, 0, 1),
(537, 6, 9, ‘Orense’, ‘OR’, 0, 1),
(538, 6, 9, ‘Palencia’, ‘P’, 0, 1),
(539, 6, 9, ‘Pontevedra’, ‘PO’, 0, 1),
(540, 6, 9, ‘Salamanca’, ‘SA’, 0, 1),
(541, 6, 10, ‘Santa Cruz de Tenerife’, ‘TF’, 0, 1),
(542, 6, 9, ‘Segovia’, ‘SG’, 0, 1),
(543, 6, 9, ‘Sevilla’, ‘SE’, 0, 1),
(544, 6, 9, ‘Soria’, ‘SO’, 0, 1),
(545, 6, 9, ‘Tarragona’, ‘T’, 0, 1),
(546, 6, 9, ‘Teruel’, ‘TE’, 0, 1),
(547, 6, 9, ‘Toledo’, ‘TO’, 0, 1),
(548, 6, 9, ‘Valencia’, ‘V’, 0, 1),
(549, 6, 9, ‘Valladolid’, ‘VA’, 0, 1),
(550, 6, 9, ‘Vizcaya’, ‘BI’, 0, 1),
(551, 6, 9, ‘Zamora’, ‘ZA’, 0, 1),
(552, 6, 9, ‘Zaragoza’, ‘Z’, 0, 1);