/* 20:37:24 */ ALTER TABLE `obec` ADD `nazov_okres` VARCHAR(255)  NULL  DEFAULT NULL  AFTER `nazov`;
/* 20:45:39 */ UPDATE obec SET nazov_okres = nazov;
/* 20:45:39 */ UPDATE obec LEFT JOIN okres ON okres.id=obec.okres_id SET nazov_okres = CONCAT(obec.nazov,' (okres: ',okres.nazov,')') WHERE obec.nazov IN ("Abrahámovce","Baškovce","Belá","Beša","Brestov","Brestovec","Brezany","Breznička","Brezovica","Bukovec","Bystrá","Čakanovce","Čelovce","Cernina","Chvojnica","Čierna Lehota","Doľany","Dubová","Dubové","Dúbrava","Gerlachov","Háj","Haniska","Hankovce","Horná Lehota","Horovce","Hosťovce","Hradište","Hrušov","Jablonové","Jakubovany","Jalovec","Jamník","Jánovce","Jasenov","Jesenské","Kamenná Poruba","Kamienka","Klokočov","Kochanovce","Konská","Kravany","Kučín","Kvačany","Lažany","Lipová","Lipovec","Lipovník","Lúčka","Lúčky","Lukačovce","Lukavica","Mikušovce","Nemcovce","Neporadza","Nevidzany","Nižná","Oľšavka","Oreské","Ostrov","Pavlovce","Petrovce","Píla","Ploské","Podhorany","Podhorie","Podhradie","Podlužany","Poproč","Porúbka","Potok","Radošovce","Rákoš","Riečka","Rohožník","Rovné","Rudník","Ruskovce","Rybník","Sása","Selce","Senné","Sklabiňa","Štefanovce","Tomášovce","Trnávka","Vieska","Višňové","Vozokany","Vysoká","Závada","Závadka","Žiar");
