Mailing.create API - Remove default value 'api.mailing_job.create'=>1

[civicrm-core.git] / xml / templates / civicrm_state_province.tpl

diff --git a/xml/templates/civicrm_state_province.tpl b/xml/templates/civicrm_state_province.tpl
index af6c153ae48f67767c821ca86a933617eb80b263..296786b001c5effa8063811999e0c285ebd5c73b 100644 (file)
--- a/xml/templates/civicrm_state_province.tpl
+++ b/xml/templates/civicrm_state_province.tpl
@@ -1538,17 +1538,17 @@ INSERT INTO civicrm_state_province (id, country_id, abbreviation, name) VALUES
 (3053, 1099, "TB", "Tatabánya"),
 (3054, 1099, "ZE", "Zalaegerszeg"),
 (3055, 1102, "BA", "Bali"),
-(3056, 1102, "BB", "Kepulauan Bangka Belitung"), -- changed from "Bangka Belitung"
+(3056, 1102, "BB", "Kepulauan Bangka Belitung"),
 (3057, 1102, "BT", "Banten"),
 (3058, 1102, "BE", "Bengkulu"),
 (3059, 1102, "GO", "Gorontalo"),
-(3060, 1102, "PB", "Papua Barat"), -- changed from "IJ" and "Irian Jaya"
+(3060, 1102, "PB", "Papua Barat"),
 (3061, 1102, "JA", "Jambi"),
 (3062, 1102, "JB", "Jawa Barat"),
 (3063, 1102, "JT", "Jawa Tengah"),
 (3064, 1102, "JI", "Jawa Timur"),
 (3065, 1102, "KB", "Kalimantan Barat"),
-(3066, 1102, "KT", "Kalimantan Timur"),
+(3066, 1102, "KI", "Kalimantan Timur"),
 (3067, 1102, "KS", "Kalimantan Selatan"),
 (3068, 1102, "KR", "Kepulauan Riau"),
 (3069, 1102, "LA", "Lampung"),
@@ -1565,9 +1565,9 @@ INSERT INTO civicrm_state_province (id, country_id, abbreviation, name) VALUES
 (3080, 1102, "SB", "Sumatra Barat"),
 (3081, 1102, "SS", "Sumatra Selatan"),
 (3082, 1102, "SU", "Sumatera Utara"),
-(3083, 1102, "JK", "DKI Jakarta"), -- changed from "Jakarta Raya" 
+(3083, 1102, "JK", "DKI Jakarta"),
 (3084, 1102, "AC", "Aceh"),
-(3085, 1102, "YO", "DI Yogyakarta"), -- changed from "Yogyakarta"
+(3085, 1102, "YO", "DI Yogyakarta"),
 (3086, 1105, "C", "Cork"),
 (3087, 1105, "CE", "Clare"),
 (3088, 1105, "CN", "Cavan"),
@@ -2833,7 +2833,7 @@ INSERT INTO civicrm_state_province (id, country_id, abbreviation, name) VALUES
 (4380, 1180, "SH", "Saint Helena"),
 (4381, 1180, "AC", "Ascension"),
 (4382, 1180, "TA", "Tristan da Cunha"),
-(4383, 1193, "001", "Ajdovscina"),
+(4383, 1193, "001", "Ajdovščina"),
 (4384, 1193, "002", "Beltinci"),
 (4385, 1193, "148", "Benedikt"),
 (4386, 1193, "149", "Bistrica ob Sotli"),
@@ -2842,21 +2842,21 @@ INSERT INTO civicrm_state_province (id, country_id, abbreviation, name) VALUES
 (4389, 1193, "004", "Bohinj"),
 (4390, 1193, "005", "Borovnica"),
 (4391, 1193, "006", "Bovec"),
-(4392, 1193, "151", "Braslovce"),
+(4392, 1193, "151", "Braslovče"),
 (4393, 1193, "007", "Brda"),
 (4394, 1193, "008", "Brezovica"),
-(4395, 1193, "009", "Brezica"),
+(4395, 1193, "009", "Brežice"),
 (4396, 1193, "152", "Cankova"),
 (4397, 1193, "011", "Celje"),
 (4398, 1193, "012", "Cerklje na Gorenjskem"),
 (4399, 1193, "013", "Cerknica"),
 (4400, 1193, "014", "Cerkno"),
 (4401, 1193, "153", "Cerkvenjak"),
-(4402, 1193, "015", "Crensovci"),
-(4403, 1193, "016", "Crna na Koroskem"),
-(4404, 1193, "017", "Crnomelj"),
+(4402, 1193, "015", "Črenšovci"),
+(4403, 1193, "016", "Črna na Koroškem"),
+(4404, 1193, "017", "Črnomelj"),
 (4405, 1193, "018", "Destrnik"),
-(4406, 1193, "019", "Divaca"),
+(4406, 1193, "019", "Divača"),
 (4407, 1193, "154", "Dobje"),
 (4408, 1193, "020", "Dobrepolje"),
 (4409, 1193, "155", "Dobrna"),
@@ -2864,37 +2864,37 @@ INSERT INTO civicrm_state_province (id, country_id, abbreviation, name) VALUES
 (4411, 1193, "156", "Dobrovnik"),
 (4412, 1193, "022", "Dol pri Ljubljani"),
 (4413, 1193, "157", "Dolenjske Toplice"),
-(4414, 1193, "023", "Domzale"),
+(4414, 1193, "023", "Domžale"),
 (4415, 1193, "024", "Dornava"),
 (4416, 1193, "025", "Dravograd"),
 (4417, 1193, "026", "Duplek"),
 (4418, 1193, "027", "Gorenja vas-Poljane"),
-(4419, 1193, "028", "Gorsnica"),
+(4419, 1193, "028", "Gorišnica"),
 (4420, 1193, "029", "Gornja Radgona"),
 (4421, 1193, "030", "Gornji Grad"),
 (4422, 1193, "031", "Gornji Petrovci"),
 (4423, 1193, "158", "Grad"),
 (4424, 1193, "032", "Grosuplje"),
 (4425, 1193, "159", "Hajdina"),
-(4426, 1193, "160", "Hoce-Slivnica"),
-(4427, 1193, "161", "Hodos"),
-(4428, 1193, "162", "Jorjul"),
+(4426, 1193, "160", "Hoče-Slivnica"),
+(4427, 1193, "161", "Hodoš"),
+(4428, 1193, "162", "Horjul"),
 (4429, 1193, "034", "Hrastnik"),
 (4430, 1193, "035", "Hrpelje-Kozina"),
 (4431, 1193, "036", "Idrija"),
 (4432, 1193, "037", "Ig"),
-(4433, 1193, "038", "IIrska Bistrica"),
-(4434, 1193, "039", "Ivancna Gorica"),
+(4433, 1193, "038", "Ilirska Bistrica"),
+(4434, 1193, "039", "Ivančna Gorica"),
 (4435, 1193, "040", "Izola"),
 (4436, 1193, "041", "Jesenice"),
 (4437, 1193, "163", "Jezersko"),
-(4438, 1193, "042", "Jursinci"),
+(4438, 1193, "042", "Juršinci"),
 (4439, 1193, "043", "Kamnik"),
 (4440, 1193, "044", "Kanal"),
-(4441, 1193, "045", "Kidricevo"),
+(4441, 1193, "045", "Kidričevo"),
 (4442, 1193, "046", "Kobarid"),
 (4443, 1193, "047", "Kobilje"),
-(4444, 1193, "048", "Jovevje"),
+(4444, 1193, "048", "Kočevje"),
 (4445, 1193, "049", "Komen"),
 (4446, 1193, "164", "Komenda"),
 (4447, 1193, "050", "Koper"),
@@ -2902,11 +2902,11 @@ INSERT INTO civicrm_state_province (id, country_id, abbreviation, name) VALUES
 (4449, 1193, "051", "Kozje"),
 (4450, 1193, "052", "Kranj"),
 (4451, 1193, "053", "Kranjska Gora"),
-(4452, 1193, "166", "Krizevci"),
-(4453, 1193, "054", "Krsko"),
+(4452, 1193, "166", "Križevci"),
+(4453, 1193, "054", "Krško"),
 (4454, 1193, "055", "Kungota"),
 (4455, 1193, "056", "Kuzma"),
-(4456, 1193, "057", "Lasko"),
+(4456, 1193, "057", "Laško"),
 (4457, 1193, "058", "Lenart"),
 (4458, 1193, "059", "Lendava"),
 (4459, 1193, "060", "Litija"),
@@ -2914,23 +2914,23 @@ INSERT INTO civicrm_state_province (id, country_id, abbreviation, name) VALUES
 (4461, 1193, "062", "Ljubno"),
 (4462, 1193, "063", "Ljutomer"),
 (4463, 1193, "064", "Logatec"),
-(4464, 1193, "065", "Loska dolina"),
-(4465, 1193, "066", "Loski Potok"),
+(4464, 1193, "065", "Loška dolina"),
+(4465, 1193, "066", "Loški Potok"),
 (4466, 1193, "167", "Lovrenc na Pohorju"),
-(4467, 1193, "067", "Luce"),
+(4467, 1193, "067", "Luče"),
 (4468, 1193, "068", "Lukovica"),
-(4469, 1193, "069", "Majsperk"),
+(4469, 1193, "069", "Majšperk"),
 (4470, 1193, "070", "Maribor"),
 (4471, 1193, "168", "Markovci"),
 (4472, 1193, "071", "Medvode"),
-(4473, 1193, "072", "Menges"),
+(4473, 1193, "072", "Mengeš"),
 (4474, 1193, "073", "Metlika"),
-(4475, 1193, "074", "Mezica"),
-(4476, 1193, "169", "Miklavz na Dravskern polju"),
+(4475, 1193, "074", "Mežica"),
+(4476, 1193, "169", "Miklavž na Dravskem polju"),
 (4477, 1193, "075", "Miren-Kostanjevica"),
-(4478, 1193, "170", "Mirna Pec"),
+(4478, 1193, "170", "Mirna Peč"),
 (4479, 1193, "076", "Mislinja"),
-(4480, 1193, "077", "Moravce"),
+(4480, 1193, "077", "Moravče"),
 (4481, 1193, "078", "Moravske Toplice"),
 (4482, 1193, "079", "Mozirje"),
 (4483, 1193, "080", "Murska Sobota"),
@@ -2938,37 +2938,37 @@ INSERT INTO civicrm_state_province (id, country_id, abbreviation, name) VALUES
 (4485, 1193, "082", "Naklo"),
 (4486, 1193, "083", "Nazarje"),
 (4487, 1193, "084", "Nova Gorica"),
-(4488, 1193, "085", "Nova mesto"),
+(4488, 1193, "085", "Novo mesto"),
 (4489, 1193, "181", "Sveta Ana"),
-(4490, 1193, "182", "Sveti Andraz v Slovenskih goricah"),
+(4490, 1193, "182", "Sveti Andraž v Slovenskih goricah"),
 (4491, 1193, "116", "Sveti Jurij"),
-(4492, 1193, "033", "Salovci"),
-(4493, 1193, "183", "Sempeter-Vrtojba"),
-(4494, 1193, "117", "Sencur"),
-(4495, 1193, "118", "Sentilj"),
-(4496, 1193, "119", "Sentjernej"),
-(4497, 1193, "120", "Sentjur pri Celju"),
-(4498, 1193, "121", "Skocjan"),
-(4499, 1193, "122", "Skofja Loka"),
-(4500, 1193, "123", "Skoftjica"),
-(4501, 1193, "124", "Smarje pri Jelsah"),
-(4502, 1193, "125", "Smartno ob Paki"),
-(4503, 1193, "194", "Smartno pri Litiji"),
-(4504, 1193, "126", "Sostanj"),
-(4505, 1193, "127", "Store"),
+(4492, 1193, "033", "Šalovci"),
+(4493, 1193, "183", "Šempeter-Vrtojba"),
+(4494, 1193, "117", "Šenčur"),
+(4495, 1193, "118", "Šentilj"),
+(4496, 1193, "119", "Šentjernej"),
+(4497, 1193, "120", "Šentjur"),
+(4498, 1193, "121", "Škocjan"),
+(4499, 1193, "122", "Škofja Loka"),
+(4500, 1193, "123", "Škofljica"),
+(4501, 1193, "124", "Šmarje pri Jelšah"),
+(4502, 1193, "125", "Šmartno ob Paki"),
+(4503, 1193, "194", "Šmartno pri Litiji"),
+(4504, 1193, "126", "Šoštanj"),
+(4505, 1193, "127", "Štore"),
 (4506, 1193, "184", "Tabor"),
-(4507, 1193, "010", "Tisina"),
+(4507, 1193, "010", "Tišina"),
 (4508, 1193, "128", "Tolmin"),
-(4509, 1193, "129", "Trbovje"),
+(4509, 1193, "129", "Trbovlje"),
 (4510, 1193, "130", "Trebnje"),
 (4511, 1193, "185", "Trnovska vas"),
-(4512, 1193, "131", "Trzic"),
+(4512, 1193, "131", "Tržič"),
 (4513, 1193, "186", "Trzin"),
-(4514, 1193, "132", "Turnisce"),
+(4514, 1193, "132", "Turnišče"),
 (4515, 1193, "133", "Velenje"),
 (4516, 1193, "187", "Velika Polana"),
-(4517, 1193, "134", "Velika Lasce"),
-(4518, 1193, "188", "Verzej"),
+(4517, 1193, "134", "Velike Lašče"),
+(4518, 1193, "188", "Veržej"),
 (4519, 1193, "135", "Videm"),
 (4520, 1193, "136", "Vipava"),
 (4521, 1193, "137", "Vitanje"),
@@ -2977,14 +2977,14 @@ INSERT INTO civicrm_state_province (id, country_id, abbreviation, name) VALUES
 (4524, 1193, "140", "Vrhnika"),
 (4525, 1193, "141", "Vuzenica"),
 (4526, 1193, "142", "Zagorje ob Savi"),
-(4527, 1193, "143", "Zavrc"),
-(4528, 1193, "144", "Zrece"),
-(4529, 1193, "190", "Zalec"),
-(4530, 1193, "146", "Zelezniki"),
-(4531, 1193, "191", "Zetale"),
-(4532, 1193, "147", "Ziri"),
-(4533, 1193, "192", "Zirovnica"),
-(4534, 1193, "193", "Zuzemberk"),
+(4527, 1193, "143", "Zavrč"),
+(4528, 1193, "144", "Zreče"),
+(4529, 1193, "190", "Žalec"),
+(4530, 1193, "146", "Železniki"),
+(4531, 1193, "191", "Žetale"),
+(4532, 1193, "147", "Žiri"),
+(4533, 1193, "192", "Žirovnica"),
+(4534, 1193, "193", "Žužemberk"),
 (4535, 1192, "BC", "Banskobystrický kraj"),
 (4536, 1192, "BL", "Bratislavský kraj"),
 (4537, 1192, "KI", "Košický kraj"),
@@ -3670,9 +3670,9 @@ INSERT INTO civicrm_state_province (id, country_id, abbreviation, name) VALUES
 (5215, 1165, "_O", "Khan Yunis"),
 (5216, 1165, "_P", "Rafah"),
 
-(5217, 1020, "BRU", "Brussels"), -- missing Belgian province (CRM-3609)
+(5217, 1020, "BRU", "Brussels"),
 
-(5218, 1140, "DIF", "Distrito Federal"), -- missing Mexican province (CRM-4534)
+(5218, 1140, "DIF", "Distrito Federal"),
 (5219, 1208, "TXG", "Taichung City"),
 (5220, 1208, "KHH", "Kaohsiung City"),
 (5221, 1208, "TPE", "Taipei City"),
@@ -3913,6 +3913,69 @@ INSERT INTO civicrm_state_province (id, country_id, abbreviation, name) VALUES
 -- Add missing Peruvian State (Amazonas)
 (NULL, 1169, "AMA", "Amazonas"),
 
--- Add missing Indonesian provinces (Kalimantan Tengah, Sulawesi Barat) and revised outdated names in code above
-(NULL, 1102, "KLTG", "Kalimantan Tengah"), -- added
-(NULL, 1102, "SLBT", "Sulawesi Barat"); -- added
+-- Add missing Indonesian provinces (Kalimantan Tengah, Sulawesi Barat, Kalimantan Utara) and revised outdated names in code above
+(NULL, 1102, "KT", "Kalimantan Tengah"),
+(NULL, 1102, "SR", "Sulawesi Barat"),
+(NULL, 1102, "KU", "Kalimantan Utara"),
+
+-- Add missing Slovenian municipalities
+(NULL, 1193, "86", "Ankaran"),
+(NULL, 1193, "87", "Apače"),
+(NULL, 1193, "88", "Cirkulane"),
+(NULL, 1193, "89", "Gorje"),
+(NULL, 1193, "90", "Kostanjevica na Krki"),
+(NULL, 1193, "91", "Log-Dragomer"),
+(NULL, 1193, "92", "Makole"),
+(NULL, 1193, "93", "Mirna"),
+(NULL, 1193, "94", "Mokronog-Trebelno"),
+(NULL, 1193, "95", "Odranci"),
+(NULL, 1193, "96", "Oplotnica"),
+(NULL, 1193, "97", "Ormož"),
+(NULL, 1193, "98", "Osilnica"),
+(NULL, 1193, "99", "Pesnica"),
+(NULL, 1193, "100", "Piran"),
+(NULL, 1193, "101", "Pivka"),
+(NULL, 1193, "102", "Podčetrtek"),
+(NULL, 1193, "103", "Podlehnik"),
+(NULL, 1193, "104", "Podvelka"),
+(NULL, 1193, "105", "Poljčane"),
+(NULL, 1193, "106", "Polzela"),
+(NULL, 1193, "107", "Postojna"),
+(NULL, 1193, "108", "Prebold"),
+(NULL, 1193, "109", "Preddvor"),
+(NULL, 1193, "110", "Prevalje"),
+(NULL, 1193, "111", "Ptuj"),
+(NULL, 1193, "112", "Puconci"),
+(NULL, 1193, "113", "Rače-Fram"),
+(NULL, 1193, "114", "Radeče"),
+(NULL, 1193, "115", "Radenci"),
+(NULL, 1193, "139", "Radlje ob Dravi"),
+(NULL, 1193, "145", "Radovljica"),
+(NULL, 1193, "171", "Ravne na Koroškem"),
+(NULL, 1193, "172", "Razkrižje"),
+(NULL, 1193, "173", "Rečica ob Savinji"),
+(NULL, 1193, "174", "Renče-Vogrsko"),
+(NULL, 1193, "175", "Ribnica"),
+(NULL, 1193, "176", "Ribnica na Pohorju"),
+(NULL, 1193, "177", "Rogaška Slatina"),
+(NULL, 1193, "178", "Rogašovci"),
+(NULL, 1193, "179", "Rogatec"),
+(NULL, 1193, "180", "Ruše"),
+(NULL, 1193, "195", "Selnica ob Dravi"),
+(NULL, 1193, "196", "Semič"),
+(NULL, 1193, "197", "Šentrupert"),
+(NULL, 1193, "198", "Sevnica"),
+(NULL, 1193, "199", "Sežana"),
+(NULL, 1193, "200", "Slovenj Gradec"),
+(NULL, 1193, "201", "Slovenska Bistrica"),
+(NULL, 1193, "202", "Slovenske Konjice"),
+(NULL, 1193, "203", "Šmarješke Toplice"),
+(NULL, 1193, "204", "Sodražica"),
+(NULL, 1193, "205", "Solčava"),
+(NULL, 1193, "206", "Središče ob Dravi"),
+(NULL, 1193, "207", "Starše"),
+(NULL, 1193, "208", "Straža"),
+(NULL, 1193, "209", "Sveta Trojica v Slovenskih goricah"),
+(NULL, 1193, "210", "Sveti Jurij v Slovenskih goricah"),
+(NULL, 1193, "211", "Sveti Tomaž"),
+(NULL, 1193, "212", "Vodice");