-
Piotr Gawron authoredPiotr Gawron authored
Code owners
Assign users and groups as approvers for specific file changes. Learn more.
0060_remove_subject_country.py 19.33 KiB
# -*- coding: utf-8 -*-
# Generated by Django 1.10.7 on 2017-10-31 09:15
from __future__ import unicode_literals
from django.db import migrations, models
class Migration(migrations.Migration):
dependencies = [
('web', '0059_subject_country_2'),
]
operations = [
migrations.AlterField(
model_name='country',
name='name',
field=models.CharField(max_length=50),
),
migrations.RunSQL('insert into web_country (name, "order") values(\'Afghanistan\', 100);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Albania\', 101);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Algeria\', 102);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Andorra\', 103);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Angola\', 104);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Antigua & Deps\', 105);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Argentina\', 106);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Armenia\', 107);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Australia\', 108);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Austria\', 109);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Azerbaijan\', 110);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Bahamas\', 111);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Bahrain\', 112);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Bangladesh\', 113);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Barbados\', 114);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Belarus\', 115);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Belgium\', 4);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Belize\', 117);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Benin\', 118);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Bhutan\', 119);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Bolivia\', 120);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Bosnia Herzegovina\', 121);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Botswana\', 122);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Brazil\', 123);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Brunei\', 124);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Bulgaria\', 125);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Burkina\', 126);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Burundi\', 127);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Cambodia\', 128);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Cameroon\', 129);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Canada\', 130);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Cape Verde\', 131);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Central African Rep\', 132);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Chad\', 133);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Chile\', 134);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'China\', 135);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Colombia\', 136);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Comoros\', 137);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Congo\', 138);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Congo {Democratic Rep}\', 139);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Costa Rica\', 140);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Croatia\', 141);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Cuba\', 142);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Cyprus\', 143);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Czech Republic\', 144);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Denmark\', 145);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Djibouti\', 146);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Dominica\', 147);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Dominican Republic\', 148);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'East Timor\', 149);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Ecuador\', 150);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Egypt\', 151);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'El Salvador\', 152);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Equatorial Guinea\', 153);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Eritrea\', 154);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Estonia\', 155);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Ethiopia\', 156);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Fiji\', 157);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Finland\', 158);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'France\', 2);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Gabon\', 160);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Gambia\', 161);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Georgia\', 162);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Germany\', 3);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Ghana\', 164);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Greece\', 165);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Grenada\', 166);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Guatemala\', 167);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Guinea\', 168);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Guinea-Bissau\', 169);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Guyana\', 170);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Haiti\', 171);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Honduras\', 172);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Hungary\', 173);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Iceland\', 174);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'India\', 175);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Indonesia\', 176);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Iran\', 177);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Iraq\', 178);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Ireland {Republic}\', 179);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Israel\', 180);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Italy\', 181);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Ivory Coast\', 182);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Jamaica\', 183);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Japan\', 184);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Jordan\', 185);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Kazakhstan\', 186);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Kenya\', 187);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Kiribati\', 188);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Korea North\', 189);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Korea South\', 190);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Kosovo\', 191);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Kuwait\', 192);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Kyrgyzstan\', 193);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Laos\', 194);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Latvia\', 195);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Lebanon\', 196);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Lesotho\', 197);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Liberia\', 198);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Libya\', 199);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Liechtenstein\', 200);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Lithuania\', 201);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Luxembourg\', 1);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Macedonia\', 203);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Madagascar\', 204);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Malawi\', 205);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Malaysia\', 206);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Maldives\', 207);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Mali\', 208);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Malta\', 209);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Marshall Islands\', 210);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Mauritania\', 211);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Mauritius\', 212);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Mexico\', 213);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Micronesia\', 214);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Moldova\', 215);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Monaco\', 216);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Mongolia\', 217);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Montenegro\', 218);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Morocco\', 219);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Mozambique\', 220);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Myanmar, {Burma}\', 221);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Namibia\', 222);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Nauru\', 223);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Nepal\', 224);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Netherlands\', 225);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'New Zealand\', 226);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Nicaragua\', 227);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Niger\', 228);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Nigeria\', 229);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Norway\', 230);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Oman\', 231);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Pakistan\', 232);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Palau\', 233);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Panama\', 234);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Papua New Guinea\', 235);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Paraguay\', 236);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Peru\', 237);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Philippines\', 238);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Poland\', 239);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Portugal\', 240);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Qatar\', 241);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Romania\', 242);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Russian Federation\', 243);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Rwanda\', 244);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'St Kitts & Nevis\', 245);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'St Lucia\', 246);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Saint Vincent & the Grenadines\', 247);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Samoa\', 248);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'San Marino\', 249);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Sao Tome & Principe\', 250);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Saudi Arabia\', 251);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Senegal\', 252);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Serbia\', 253);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Seychelles\', 254);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Sierra Leone\', 255);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Singapore\', 256);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Slovakia\', 257);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Slovenia\', 258);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Solomon Islands\', 259);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Somalia\', 260);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'South Africa\', 261);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'South Sudan\', 262);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Spain\', 263);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Sri Lanka\', 264);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Sudan\', 265);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Suriname\', 266);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Swaziland\', 267);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Sweden\', 268);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Switzerland\', 269);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Syria\', 270);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Taiwan\', 271);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Tajikistan\', 272);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Tanzania\', 273);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Thailand\', 274);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Togo\', 275);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Tonga\', 276);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Trinidad & Tobago\', 277);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Tunisia\', 278);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Turkey\', 279);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Turkmenistan\', 280);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Tuvalu\', 281);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Uganda\', 282);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Ukraine\', 283);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'United Arab Emirates\', 284);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'United Kingdom\', 285);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'United States\', 286);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Uruguay\', 287);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Uzbekistan\', 288);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Vanuatu\', 289);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Vatican City\', 290);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Venezuela\', 291);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Vietnam\', 292);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Yemen\', 293);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Zambia\', 294);'),
migrations.RunSQL('insert into web_country (name, "order") values(\'Zimbabwe\', 295);'),
migrations.RunSQL('update web_subject t set country_2_id = '
'case when (select id from web_country u where t.country=u.name) is Null then 1 '
'else (select id from web_country u where t.country=u.name) end;'),
]