11.5 Zones. Països. Estats. Activació automàtica

  • 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);

 

Aquesta entrada ha esta publicada en Emprenedoria. Afegeix a les adreces d'interès l'enllaç permanent.

Els comentaris estan tancats.