crm.fsf.org/20131203/files/sites/all/modules-old/civicrm/CRM/Upgrade/Incremental/sql/4.6.alpha3.mysql.tpl

   1 {* CRM-16846 - This file may have been accidentally skipped and so is conditionally re-run during 4.6.6 upgrade *}
   2
   3 -- Use proper names for Slovenian municipalities
   4 UPDATE `civicrm_state_province` SET `name` = (N'Ajdovščina') WHERE `id` = 4383;
   5 UPDATE `civicrm_state_province` SET `name` = (N'Braslovče') WHERE `id` = 4392;
   6 UPDATE `civicrm_state_province` SET `name` = (N'Brežice') WHERE `id` = 4395;
   7 UPDATE `civicrm_state_province` SET `name` = (N'Črenšovci') WHERE `id` = 4402;
   8 UPDATE `civicrm_state_province` SET `name` = (N'Črna na Koroškem') WHERE `id` = 4403;
   9 UPDATE `civicrm_state_province` SET `name` = (N'Črnomelj') WHERE `id` = 4404;
  10 UPDATE `civicrm_state_province` SET `name` = (N'Divača') WHERE `id` = 4406;
  11 UPDATE `civicrm_state_province` SET `name` = (N'Domžale') WHERE `id` = 4414;
  12 UPDATE `civicrm_state_province` SET `name` = (N'Gorišnica') WHERE `id` = 4419;
  13 UPDATE `civicrm_state_province` SET `name` = (N'Hoče-Slivnica') WHERE `id` = 4426;
  14 UPDATE `civicrm_state_province` SET `name` = (N'Hodoš') WHERE `id` = 4427;
  15 UPDATE `civicrm_state_province` SET `name` = (N'Horjul') WHERE `id` = 4428;
  16 UPDATE `civicrm_state_province` SET `name` = (N'Ilirska Bistrica') WHERE `id` = 4433;
  17 UPDATE `civicrm_state_province` SET `name` = (N'Ivančna Gorica') WHERE `id` = 4434;
  18 UPDATE `civicrm_state_province` SET `name` = (N'Juršinci') WHERE `id` = 4438;
  19 UPDATE `civicrm_state_province` SET `name` = (N'Kidričevo') WHERE `id` = 4441;
  20 UPDATE `civicrm_state_province` SET `name` = (N'Kočevje') WHERE `id` = 4444;
  21 UPDATE `civicrm_state_province` SET `name` = (N'Križevci') WHERE `id` = 4452;
  22 UPDATE `civicrm_state_province` SET `name` = (N'Krško') WHERE `id` = 4453;
  23 UPDATE `civicrm_state_province` SET `name` = (N'Laško') WHERE `id` = 4456;
  24 UPDATE `civicrm_state_province` SET `name` = (N'Loška dolina') WHERE `id` = 4464;
  25 UPDATE `civicrm_state_province` SET `name` = (N'Loški Potok') WHERE `id` = 4465;
  26 UPDATE `civicrm_state_province` SET `name` = (N'Luče') WHERE `id` = 4467;
  27 UPDATE `civicrm_state_province` SET `name` = (N'Majšperk') WHERE `id` = 4469;
  28 UPDATE `civicrm_state_province` SET `name` = (N'Mengeš') WHERE `id` = 4473;
  29 UPDATE `civicrm_state_province` SET `name` = (N'Mežica') WHERE `id` = 4475;
  30 UPDATE `civicrm_state_province` SET `name` = (N'Miklavž na Dravskem polju') WHERE `id` = 4476;
  31 UPDATE `civicrm_state_province` SET `name` = (N'Mirna Peč') WHERE `id` = 4478;
  32 UPDATE `civicrm_state_province` SET `name` = (N'Moravče') WHERE `id` = 4480;
  33 UPDATE `civicrm_state_province` SET `name` = (N'Novo mesto') WHERE `id` = 4488;
  34 UPDATE `civicrm_state_province` SET `name` = (N'Sveti Andraž v Slovenskih goricah') WHERE `id` = 4490;
  35 UPDATE `civicrm_state_province` SET `name` = (N'Šalovci') WHERE `id` = 4492;
  36 UPDATE `civicrm_state_province` SET `name` = (N'Šempeter-Vrtojba') WHERE `id` = 4493;
  37 UPDATE `civicrm_state_province` SET `name` = (N'Šenčur') WHERE `id` = 4494;
  38 UPDATE `civicrm_state_province` SET `name` = (N'Šentilj') WHERE `id` = 4495;
  39 UPDATE `civicrm_state_province` SET `name` = (N'Šentjernej') WHERE `id` = 4496;
  40 UPDATE `civicrm_state_province` SET `name` = (N'Šentjur') WHERE `id` = 4497;
  41 UPDATE `civicrm_state_province` SET `name` = (N'Škocjan') WHERE `id` = 4498;
  42 UPDATE `civicrm_state_province` SET `name` = (N'Škofja Loka') WHERE `id` = 4499;
  43 UPDATE `civicrm_state_province` SET `name` = (N'Škofljica') WHERE `id` = 4500;
  44 UPDATE `civicrm_state_province` SET `name` = (N'Šmarje pri Jelšah') WHERE `id` = 4501;
  45 UPDATE `civicrm_state_province` SET `name` = (N'Šmartno ob Paki') WHERE `id` = 4502;
  46 UPDATE `civicrm_state_province` SET `name` = (N'Šmartno pri Litiji') WHERE `id` = 4503;
  47 UPDATE `civicrm_state_province` SET `name` = (N'Šoštanj') WHERE `id` = 4504;
  48 UPDATE `civicrm_state_province` SET `name` = (N'Štore') WHERE `id` = 4505;
  49 UPDATE `civicrm_state_province` SET `name` = (N'Tišina') WHERE `id` = 4507;
  50 UPDATE `civicrm_state_province` SET `name` = (N'Trbovlje') WHERE `id` = 4509;
  51 UPDATE `civicrm_state_province` SET `name` = (N'Tržič') WHERE `id` = 4512;
  52 UPDATE `civicrm_state_province` SET `name` = (N'Turnišče') WHERE `id` = 4514;
  53 UPDATE `civicrm_state_province` SET `name` = (N'Velike Lašče') WHERE `id` = 4517;
  54 UPDATE `civicrm_state_province` SET `name` = (N'Veržej') WHERE `id` = 4518;
  55 UPDATE `civicrm_state_province` SET `name` = (N'Zavrč') WHERE `id` = 4527;
  56 UPDATE `civicrm_state_province` SET `name` = (N'Zreče') WHERE `id` = 4528;
  57 UPDATE `civicrm_state_province` SET `name` = (N'Žalec') WHERE `id` = 4529;
  58 UPDATE `civicrm_state_province` SET `name` = (N'Železniki') WHERE `id` = 4530;
  59 UPDATE `civicrm_state_province` SET `name` = (N'Žetale') WHERE `id` = 4531;
  60 UPDATE `civicrm_state_province` SET `name` = (N'Žiri') WHERE `id` = 4532;
  61 UPDATE `civicrm_state_province` SET `name` = (N'Žirovnica') WHERE `id` = 4533;
  62 UPDATE `civicrm_state_province` SET `name` = (N'Žužemberk') WHERE `id` = 4534;
  63
  64 -- Add missing Slovenian municipalities
  65 INSERT INTO civicrm_state_province (country_id, abbreviation, name)
  66 VALUES
  67   (1193, "86", "Ankaran"),
  68   (1193, "87", "Apače"),
  69   (1193, "88", "Cirkulane"),
  70   (1193, "89", "Gorje"),
  71   (1193, "90", "Kostanjevica na Krki"),
  72   (1193, "91", "Log-Dragomer"),
  73   (1193, "92", "Makole"),
  74   (1193, "93", "Mirna"),
  75   (1193, "94", "Mokronog-Trebelno"),
  76   (1193, "95", "Odranci"),
  77   (1193, "96", "Oplotnica"),
  78   (1193, "97", "Ormož"),
  79   (1193, "98", "Osilnica"),
  80   (1193, "99", "Pesnica"),
  81   (1193, "100", "Piran"),
  82   (1193, "101", "Pivka"),
  83   (1193, "102", "Podčetrtek"),
  84   (1193, "103", "Podlehnik"),
  85   (1193, "104", "Podvelka"),
  86   (1193, "105", "Poljčane"),
  87   (1193, "106", "Polzela"),
  88   (1193, "107", "Postojna"),
  89   (1193, "108", "Prebold"),
  90   (1193, "109", "Preddvor"),
  91   (1193, "110", "Prevalje"),
  92   (1193, "111", "Ptuj"),
  93   (1193, "112", "Puconci"),
  94   (1193, "113", "Rače-Fram"),
  95   (1193, "114", "Radeče"),
  96   (1193, "115", "Radenci"),
  97   (1193, "139", "Radlje ob Dravi"),
  98   (1193, "145", "Radovljica"),
  99   (1193, "171", "Ravne na Koroškem"),
 100   (1193, "172", "Razkrižje"),
 101   (1193, "173", "Rečica ob Savinji"),
 102   (1193, "174", "Renče-Vogrsko"),
 103   (1193, "175", "Ribnica"),
 104   (1193, "176", "Ribnica na Pohorju"),
 105   (1193, "177", "Rogaška Slatina"),
 106   (1193, "178", "Rogašovci"),
 107   (1193, "179", "Rogatec"),
 108   (1193, "180", "Ruše"),
 109   (1193, "195", "Selnica ob Dravi"),
 110   (1193, "196", "Semič"),
 111   (1193, "197", "Šentrupert"),
 112   (1193, "198", "Sevnica"),
 113   (1193, "199", "Sežana"),
 114   (1193, "200", "Slovenj Gradec"),
 115   (1193, "201", "Slovenska Bistrica"),
 116   (1193, "202", "Slovenske Konjice"),
 117   (1193, "203", "Šmarješke Toplice"),
 118   (1193, "204", "Sodražica"),
 119   (1193, "205", "Solčava"),
 120   (1193, "206", "Središče ob Dravi"),
 121   (1193, "207", "Starše"),
 122   (1193, "208", "Straža"),
 123   (1193, "209", "Sveta Trojica v Slovenskih goricah"),
 124   (1193, "210", "Sveti Jurij v Slovenskih goricah"),
 125   (1193, "211", "Sveti Tomaž"),
 126   (1193, "212", "Vodice");