Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Default Zones for Latvia #1055

Closed
xguntis opened this issue Dec 5, 2013 · 2 comments
Closed

Default Zones for Latvia #1055

xguntis opened this issue Dec 5, 2013 · 2 comments

Comments

@xguntis
Copy link
Contributor

xguntis commented Dec 5, 2013

I think it would be great, if with the new Opencart release we could have correct zones for Latvia (country_id = 117). They are changed already since March 30, 2010 according to http://likumi.lv/doc.php?id=207512

I am adding the code that I am using for each new installation. The only problem is - i don't know how to make an update script, as the old zones and new ones cannot be mapped - there are more new zones than old ones.

This is the code that i am using on each new installation:

DELETE FROM `zone` WHERE `country_id`='117';

INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0661405', 'Ainaži, Salacgrīvas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0320201', 'Aizkraukle, Aizkraukles novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0320200', 'Aizkraukles novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0640605', 'Aizpute, Aizputes novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0640600', 'Aizputes novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0560805', 'Aknīste, Aknīstes novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0560800', 'Aknīstes novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0661007', 'Aloja, Alojas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0661000', 'Alojas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0624200', 'Alsungas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0360201', 'Alūksne, Alūksnes novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0360200', 'Alūksnes novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0424701', 'Amatas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0360805', 'Ape, Apes novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0360800', 'Apes novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0460805', 'Auce, Auces novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0460800', 'Auces novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0804400', 'Ādažu novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0804900', 'Babītes novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0800605', 'Baldone, Baldones novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0800600', 'Baldones novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0800807', 'Baloži, Ķekavas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0384400', 'Baltinavas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0380201', 'Balvi, Balvu novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0380200', 'Balvu novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0400201', 'Bauska, Bauskas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0400200', 'Bauskas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0964700', 'Beverīnas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0840605', 'Brocēni, Brocēnu novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0840601', 'Brocēnu novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0967101', 'Burtnieku novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0805200', 'Carnikavas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0700807', 'Cesvaine, Cesvaines novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0700800', 'Cesvaines novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0420201', 'Cēsis, Cēsu novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0420200', 'Cēsu novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0684901', 'Ciblas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0601009', 'Dagda, Dagdas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0601000', 'Dagdas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0050000', 'Daugavpils', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0440200', 'Daugavpils novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0460201', 'Dobele, Dobeles novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0460200', 'Dobeles novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0885100', 'Dundagas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0640807', 'Durbe, Durbes novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0640801', 'Durbes novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0905100', 'Engures novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0705500', 'Ērgļu novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0806000', 'Garkalnes novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0641009', 'Grobiņa, Grobiņas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0641000', 'Grobiņas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0500201', 'Gulbene, Gulbenes novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0500200', 'Gulbenes novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0406400', 'Iecavas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0740605', 'Ikšķile, Ikšķiles novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0740600', 'Ikšķiles novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0440807', 'Ilūkste, Ilūkstes novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0440801', 'Ilūkstes novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0801800', 'Inčukalna novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0321007', 'Jaunjelgava, Jaunjelgavas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0321000', 'Jaunjelgavas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0425700', 'Jaunpiebalgas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0905700', 'Jaunpils novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0090000', 'Jelgava', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0540200', 'Jelgavas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0110000', 'Jēkabpils', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0560200', 'Jēkabpils novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0130000', 'Jūrmala', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0540211', 'Kalnciems, Jelgavas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0901211', 'Kandava, Kandavas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0901201', 'Kandavas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0681009', 'Kārsava, Kārsavas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0681000', 'Kārsavas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0960200', 'Kocēnu novads (bij. Valmieras)', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0326100', 'Kokneses novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0600201', 'Krāslava, Krāslavas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0600202', 'Krāslavas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0806900', 'Krimuldas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0566900', 'Krustpils novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0620201', 'Kuldīga, Kuldīgas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0620200', 'Kuldīgas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0741001', 'Ķeguma novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0741009', 'Ķegums, Ķeguma novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0800800', 'Ķekavas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0741413', 'Lielvārde, Lielvārdes novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0741401', 'Lielvārdes novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0170000', 'Liepāja', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0660201', 'Limbaži, Limbažu novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0660200', 'Limbažu novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0421211', 'Līgatne, Līgatnes novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0421200', 'Līgatnes novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0761211', 'Līvāni, Līvānu novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0761201', 'Līvānu novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0701413', 'Lubāna, Lubānas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0701400', 'Lubānas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0680201', 'Ludza, Ludzas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0680200', 'Ludzas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0700201', 'Madona, Madonas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0700200', 'Madonas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0961011', 'Mazsalaca, Mazsalacas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0961000', 'Mazsalacas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0807400', 'Mālpils novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0807600', 'Mārupes novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0887600', 'Mērsraga novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0967300', 'Naukšēnu novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0327100', 'Neretas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0647900', 'Nīcas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0740201', 'Ogre, Ogres novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0740202', 'Ogres novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0801009', 'Olaine, Olaines novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0801000', 'Olaines novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0546701', 'Ozolnieku novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0427500', 'Pārgaujas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0641413', 'Pāvilosta, Pāvilostas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0641401', 'Pāvilostas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0980213', 'Piltene, Ventspils novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0321413', 'Pļaviņas, Pļaviņu novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0321400', 'Pļaviņu novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0760201', 'Preiļi, Preiļu novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0760202', 'Preiļu novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0641615', 'Priekule, Priekules novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0641600', 'Priekules novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0427300', 'Priekuļu novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0427700', 'Raunas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0210000', 'Rēzekne', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0780200', 'Rēzeknes novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0766300', 'Riebiņu novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0010000', 'Rīga', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0888300', 'Rojas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0808400', 'Ropažu novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0648500', 'Rucavas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0387500', 'Rugāju novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0407700', 'Rundāles novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0961615', 'Rūjiena, Rūjienas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0961600', 'Rūjienas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0880213', 'Sabile, Talsu novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0661415', 'Salacgrīva, Salacgrīvas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0661400', 'Salacgrīvas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0568700', 'Salas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0801200', 'Salaspils novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0801211', 'Salaspils, Salaspils novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0840200', 'Saldus novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0840201', 'Saldus, Saldus novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0801413', 'Saulkrasti, Saulkrastu novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0801400', 'Saulkrastu novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0941813', 'Seda, Strenču novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0809200', 'Sējas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0801615', 'Sigulda, Siguldas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0801601', 'Siguldas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0328200', 'Skrīveru novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0621209', 'Skrunda, Skrundas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0621200', 'Skrundas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0941615', 'Smiltene, Smiltenes novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0941600', 'Smiltenes novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0661017', 'Staicele, Alojas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0880215', 'Stende, Talsu novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0809600', 'Stopiņu novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0941817', 'Strenči, Strenču novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0941800', 'Strenču novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0440815', 'Subate, Ilūkstes novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0880201', 'Talsi, Talsu novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0880200', 'Talsu novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0468900', 'Tērvetes novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0900200', 'Tukuma novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0900201', 'Tukums, Tukuma novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0649300', 'Vaiņodes novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0880217', 'Valdemārpils, Talsu novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0940201', 'Valka, Valkas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0940200', 'Valkas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0250000', 'Valmiera', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0801817', 'Vangaži, Inčukalna novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0701817', 'Varakļāni, Varakļānu novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0701800', 'Varakļānu novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0769101', 'Vārkavas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0429300', 'Vecpiebalgas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0409500', 'Vecumnieku novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0270000', 'Ventspils', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0980200', 'Ventspils novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0561815', 'Viesīte, Viesītes novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0561800', 'Viesītes novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0381615', 'Viļaka, Viļakas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0381600', 'Viļakas novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0781817', 'Viļāni, Viļānu novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0781800', 'Viļānu novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0681817', 'Zilupe, Zilupes novads', '1');
INSERT INTO `zone` (`country_id`, `code`, `name`, `status`) VALUES ('117', '0681801', 'Zilupes novads', '1');
@danielkerr
Copy link
Member

any chance you can push a commit for this?

@danielkerr
Copy link
Member

added in latest commit

danielkerr added a commit that referenced this issue Dec 6, 2013
@danielkerr
fix for
5dc7907 
#1055
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@xguntis @danielkerr