summaryrefslogtreecommitdiffstats
path: root/devel/migrations/0001_squashed_0002_staffgroup.py
blob: b4788118d9414c1f921a67cb3261b1341245188c (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
# -*- coding: utf-8 -*-
# Generated by Django 1.11.15 on 2018-11-17 20:54
from __future__ import unicode_literals

import devel.fields
from django.conf import settings
from django.db import migrations, models
import django.db.models.deletion
import django_countries.fields


class Migration(migrations.Migration):

    initial = True

    dependencies = [
        ('auth', '0001_initial'),
        migrations.swappable_dependency(settings.AUTH_USER_MODEL),
        ('main', '0001_initial'),
    ]

    operations = [
        migrations.CreateModel(
            name='DeveloperKey',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('key', devel.fields.PGPKeyField(max_length=40, unique=True, verbose_name='PGP key fingerprint')),
                ('created', models.DateTimeField()),
                ('expires', models.DateTimeField(blank=True, null=True)),
                ('revoked', models.DateTimeField(blank=True, null=True)),
                ('owner', models.ForeignKey(
                    help_text='The developer this key belongs to',
                    null=True, on_delete=django.db.models.deletion.CASCADE,
                    related_name='all_keys', to=settings.AUTH_USER_MODEL)),
                ('parent', models.ForeignKey(
                    null=True, on_delete=django.db.models.deletion.SET_NULL, to='devel.DeveloperKey')),
            ],
        ),
        migrations.CreateModel(
            name='MasterKey',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('pgp_key', devel.fields.PGPKeyField(
                    help_text='consists of 40 hex digits; use `gpg --fingerprint`',
                    max_length=40, verbose_name='PGP key fingerprint')),
                ('created', models.DateField()),
                ('revoked', models.DateField(blank=True, null=True)),
                ('owner', models.ForeignKey(
                    help_text='The developer holding this master key',
                    on_delete=django.db.models.deletion.CASCADE,
                    related_name='masterkey_owner', to=settings.AUTH_USER_MODEL)),
                ('revoker', models.ForeignKey(
                    help_text='The developer holding the revocation certificate',
                    on_delete=django.db.models.deletion.CASCADE,
                    related_name='masterkey_revoker', to=settings.AUTH_USER_MODEL)),
            ],
            options={
                'ordering': ('created',),
                'get_latest_by': 'created',
            },
        ),
        migrations.CreateModel(
            name='PGPSignature',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('signer', devel.fields.PGPKeyField(
                    db_index=True, max_length=40, verbose_name='Signer key fingerprint')),
                ('signee', devel.fields.PGPKeyField(
                    db_index=True, max_length=40, verbose_name='Signee key fingerprint')),
                ('created', models.DateField()),
                ('expires', models.DateField(blank=True, null=True)),
                ('revoked', models.DateField(blank=True, null=True)),
            ],
            options={
                'ordering': ('signer', 'signee'),
                'get_latest_by': 'created',
                'verbose_name': 'PGP signature',
            },
        ),
        migrations.CreateModel(
            name='UserProfile',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('notify', models.BooleanField(
                    default=True, help_text="When enabled, send user 'flag out-of-date' notifications",
                    verbose_name='Send notifications')),
                ('time_zone', models.CharField(
                    choices=[
                        ('Africa/Abidjan', 'Africa/Abidjan'),
                        ('Africa/Accra', 'Africa/Accra'),
                        ('Africa/Addis_Ababa', 'Africa/Addis_Ababa'),
                        ('Africa/Algiers', 'Africa/Algiers'),
                        ('Africa/Asmara', 'Africa/Asmara'),
                        ('Africa/Bamako', 'Africa/Bamako'),
                        ('Africa/Bangui', 'Africa/Bangui'),
                        ('Africa/Banjul', 'Africa/Banjul'),
                        ('Africa/Bissau', 'Africa/Bissau'),
                        ('Africa/Blantyre', 'Africa/Blantyre'),
                        ('Africa/Brazzaville', 'Africa/Brazzaville'),
                        ('Africa/Bujumbura', 'Africa/Bujumbura'),
                        ('Africa/Cairo', 'Africa/Cairo'),
                        ('Africa/Casablanca', 'Africa/Casablanca'),
                        ('Africa/Ceuta', 'Africa/Ceuta'),
                        ('Africa/Conakry', 'Africa/Conakry'),
                        ('Africa/Dakar', 'Africa/Dakar'),
                        ('Africa/Dar_es_Salaam', 'Africa/Dar_es_Salaam'),
                        ('Africa/Djibouti', 'Africa/Djibouti'),
                        ('Africa/Douala', 'Africa/Douala'),
                        ('Africa/El_Aaiun', 'Africa/El_Aaiun'),
                        ('Africa/Freetown', 'Africa/Freetown'),
                        ('Africa/Gaborone', 'Africa/Gaborone'),
                        ('Africa/Harare', 'Africa/Harare'),
                        ('Africa/Johannesburg', 'Africa/Johannesburg'),
                        ('Africa/Juba', 'Africa/Juba'),
                        ('Africa/Kampala', 'Africa/Kampala'),
                        ('Africa/Khartoum', 'Africa/Khartoum'),
                        ('Africa/Kigali', 'Africa/Kigali'),
                        ('Africa/Kinshasa', 'Africa/Kinshasa'),
                        ('Africa/Lagos', 'Africa/Lagos'),
                        ('Africa/Libreville', 'Africa/Libreville'),
                        ('Africa/Lome', 'Africa/Lome'),
                        ('Africa/Luanda', 'Africa/Luanda'),
                        ('Africa/Lubumbashi', 'Africa/Lubumbashi'),
                        ('Africa/Lusaka', 'Africa/Lusaka'),
                        ('Africa/Malabo', 'Africa/Malabo'),
                        ('Africa/Maputo', 'Africa/Maputo'),
                        ('Africa/Maseru', 'Africa/Maseru'),
                        ('Africa/Mbabane', 'Africa/Mbabane'),
                        ('Africa/Mogadishu', 'Africa/Mogadishu'),
                        ('Africa/Monrovia', 'Africa/Monrovia'),
                        ('Africa/Nairobi', 'Africa/Nairobi'),
                        ('Africa/Ndjamena', 'Africa/Ndjamena'),
                        ('Africa/Niamey', 'Africa/Niamey'),
                        ('Africa/Nouakchott', 'Africa/Nouakchott'),
                        ('Africa/Ouagadougou', 'Africa/Ouagadougou'),
                        ('Africa/Porto-Novo', 'Africa/Porto-Novo'),
                        ('Africa/Sao_Tome', 'Africa/Sao_Tome'),
                        ('Africa/Tripoli', 'Africa/Tripoli'),
                        ('Africa/Tunis', 'Africa/Tunis'),
                        ('Africa/Windhoek', 'Africa/Windhoek'),
                        ('America/Adak', 'America/Adak'),
                        ('America/Anchorage', 'America/Anchorage'),
                        ('America/Anguilla', 'America/Anguilla'),
                        ('America/Antigua', 'America/Antigua'),
                        ('America/Araguaina', 'America/Araguaina'),
                        ('America/Argentina/Buenos_Aires', 'America/Argentina/Buenos_Aires'),
                        ('America/Argentina/Catamarca', 'America/Argentina/Catamarca'),
                        ('America/Argentina/Cordoba', 'America/Argentina/Cordoba'),
                        ('America/Argentina/Jujuy', 'America/Argentina/Jujuy'),
                        ('America/Argentina/La_Rioja', 'America/Argentina/La_Rioja'),
                        ('America/Argentina/Mendoza', 'America/Argentina/Mendoza'),
                        ('America/Argentina/Rio_Gallegos', 'America/Argentina/Rio_Gallegos'),
                        ('America/Argentina/Salta', 'America/Argentina/Salta'),
                        ('America/Argentina/San_Juan', 'America/Argentina/San_Juan'),
                        ('America/Argentina/San_Luis', 'America/Argentina/San_Luis'),
                        ('America/Argentina/Tucuman', 'America/Argentina/Tucuman'),
                        ('America/Argentina/Ushuaia', 'America/Argentina/Ushuaia'),
                        ('America/Aruba', 'America/Aruba'),
                        ('America/Asuncion', 'America/Asuncion'),
                        ('America/Atikokan', 'America/Atikokan'),
                        ('America/Bahia', 'America/Bahia'),
                        ('America/Bahia_Banderas', 'America/Bahia_Banderas'),
                        ('America/Barbados', 'America/Barbados'),
                        ('America/Belem', 'America/Belem'),
                        ('America/Belize', 'America/Belize'),
                        ('America/Blanc-Sablon', 'America/Blanc-Sablon'),
                        ('America/Boa_Vista', 'America/Boa_Vista'),
                        ('America/Bogota', 'America/Bogota'),
                        ('America/Boise', 'America/Boise'),
                        ('America/Cambridge_Bay', 'America/Cambridge_Bay'),
                        ('America/Campo_Grande', 'America/Campo_Grande'),
                        ('America/Cancun', 'America/Cancun'),
                        ('America/Caracas', 'America/Caracas'),
                        ('America/Cayenne', 'America/Cayenne'),
                        ('America/Cayman', 'America/Cayman'),
                        ('America/Chicago', 'America/Chicago'),
                        ('America/Chihuahua', 'America/Chihuahua'),
                        ('America/Costa_Rica', 'America/Costa_Rica'),
                        ('America/Creston', 'America/Creston'),
                        ('America/Cuiaba', 'America/Cuiaba'),
                        ('America/Curacao', 'America/Curacao'),
                        ('America/Danmarkshavn', 'America/Danmarkshavn'),
                        ('America/Dawson', 'America/Dawson'),
                        ('America/Dawson_Creek', 'America/Dawson_Creek'),
                        ('America/Denver', 'America/Denver'),
                        ('America/Detroit', 'America/Detroit'),
                        ('America/Dominica', 'America/Dominica'),
                        ('America/Edmonton', 'America/Edmonton'),
                        ('America/Eirunepe', 'America/Eirunepe'),
                        ('America/El_Salvador', 'America/El_Salvador'),
                        ('America/Fort_Nelson', 'America/Fort_Nelson'),
                        ('America/Fortaleza', 'America/Fortaleza'),
                        ('America/Glace_Bay', 'America/Glace_Bay'),
                        ('America/Godthab', 'America/Godthab'),
                        ('America/Goose_Bay', 'America/Goose_Bay'),
                        ('America/Grand_Turk', 'America/Grand_Turk'),
                        ('America/Grenada', 'America/Grenada'),
                        ('America/Guadeloupe', 'America/Guadeloupe'),
                        ('America/Guatemala', 'America/Guatemala'),
                        ('America/Guayaquil', 'America/Guayaquil'),
                        ('America/Guyana', 'America/Guyana'),
                        ('America/Halifax', 'America/Halifax'),
                        ('America/Havana', 'America/Havana'),
                        ('America/Hermosillo', 'America/Hermosillo'),
                        ('America/Indiana/Indianapolis', 'America/Indiana/Indianapolis'),
                        ('America/Indiana/Knox', 'America/Indiana/Knox'),
                        ('America/Indiana/Marengo', 'America/Indiana/Marengo'),
                        ('America/Indiana/Petersburg', 'America/Indiana/Petersburg'),
                        ('America/Indiana/Tell_City', 'America/Indiana/Tell_City'),
                        ('America/Indiana/Vevay', 'America/Indiana/Vevay'),
                        ('America/Indiana/Vincennes', 'America/Indiana/Vincennes'),
                        ('America/Indiana/Winamac', 'America/Indiana/Winamac'),
                        ('America/Inuvik', 'America/Inuvik'),
                        ('America/Iqaluit', 'America/Iqaluit'),
                        ('America/Jamaica', 'America/Jamaica'),
                        ('America/Juneau', 'America/Juneau'),
                        ('America/Kentucky/Louisville', 'America/Kentucky/Louisville'),
                        ('America/Kentucky/Monticello', 'America/Kentucky/Monticello'),
                        ('America/Kralendijk', 'America/Kralendijk'),
                        ('America/La_Paz', 'America/La_Paz'),
                        ('America/Lima', 'America/Lima'),
                        ('America/Los_Angeles', 'America/Los_Angeles'),
                        ('America/Lower_Princes', 'America/Lower_Princes'),
                        ('America/Maceio', 'America/Maceio'),
                        ('America/Managua', 'America/Managua'),
                        ('America/Manaus', 'America/Manaus'),
                        ('America/Marigot', 'America/Marigot'),
                        ('America/Martinique', 'America/Martinique'),
                        ('America/Matamoros', 'America/Matamoros'),
                        ('America/Mazatlan', 'America/Mazatlan'),
                        ('America/Menominee', 'America/Menominee'),
                        ('America/Merida', 'America/Merida'),
                        ('America/Metlakatla', 'America/Metlakatla'),
                        ('America/Mexico_City', 'America/Mexico_City'),
                        ('America/Miquelon', 'America/Miquelon'),
                        ('America/Moncton', 'America/Moncton'),
                        ('America/Monterrey', 'America/Monterrey'),
                        ('America/Montevideo', 'America/Montevideo'),
                        ('America/Montserrat', 'America/Montserrat'),
                        ('America/Nassau', 'America/Nassau'),
                        ('America/New_York', 'America/New_York'),
                        ('America/Nipigon', 'America/Nipigon'),
                        ('America/Nome', 'America/Nome'),
                        ('America/Noronha', 'America/Noronha'),
                        ('America/North_Dakota/Beulah', 'America/North_Dakota/Beulah'),
                        ('America/North_Dakota/Center', 'America/North_Dakota/Center'),
                        ('America/North_Dakota/New_Salem', 'America/North_Dakota/New_Salem'),
                        ('America/Ojinaga', 'America/Ojinaga'),
                        ('America/Panama', 'America/Panama'),
                        ('America/Pangnirtung', 'America/Pangnirtung'),
                        ('America/Paramaribo', 'America/Paramaribo'),
                        ('America/Phoenix', 'America/Phoenix'),
                        ('America/Port-au-Prince', 'America/Port-au-Prince'),
                        ('America/Port_of_Spain', 'America/Port_of_Spain'),
                        ('America/Porto_Velho', 'America/Porto_Velho'),
                        ('America/Puerto_Rico', 'America/Puerto_Rico'),
                        ('America/Punta_Arenas', 'America/Punta_Arenas'),
                        ('America/Rainy_River', 'America/Rainy_River'),
                        ('America/Rankin_Inlet', 'America/Rankin_Inlet'),
                        ('America/Recife', 'America/Recife'),
                        ('America/Regina', 'America/Regina'),
                        ('America/Resolute', 'America/Resolute'),
                        ('America/Rio_Branco', 'America/Rio_Branco'),
                        ('America/Santarem', 'America/Santarem'),
                        ('America/Santiago', 'America/Santiago'),
                        ('America/Santo_Domingo', 'America/Santo_Domingo'),
                        ('America/Sao_Paulo', 'America/Sao_Paulo'),
                        ('America/Scoresbysund', 'America/Scoresbysund'),
                        ('America/Sitka', 'America/Sitka'),
                        ('America/St_Barthelemy', 'America/St_Barthelemy'),
                        ('America/St_Johns', 'America/St_Johns'),
                        ('America/St_Kitts', 'America/St_Kitts'),
                        ('America/St_Lucia', 'America/St_Lucia'),
                        ('America/St_Thomas', 'America/St_Thomas'),
                        ('America/St_Vincent', 'America/St_Vincent'),
                        ('America/Swift_Current', 'America/Swift_Current'),
                        ('America/Tegucigalpa', 'America/Tegucigalpa'),
                        ('America/Thule', 'America/Thule'),
                        ('America/Thunder_Bay', 'America/Thunder_Bay'),
                        ('America/Tijuana', 'America/Tijuana'),
                        ('America/Toronto', 'America/Toronto'),
                        ('America/Tortola', 'America/Tortola'),
                        ('America/Vancouver', 'America/Vancouver'),
                        ('America/Whitehorse', 'America/Whitehorse'),
                        ('America/Winnipeg', 'America/Winnipeg'),
                        ('America/Yakutat', 'America/Yakutat'),
                        ('America/Yellowknife', 'America/Yellowknife'),
                        ('Antarctica/Casey', 'Antarctica/Casey'),
                        ('Antarctica/Davis', 'Antarctica/Davis'),
                        ('Antarctica/DumontDUrville', 'Antarctica/DumontDUrville'),
                        ('Antarctica/Macquarie', 'Antarctica/Macquarie'),
                        ('Antarctica/Mawson', 'Antarctica/Mawson'),
                        ('Antarctica/McMurdo', 'Antarctica/McMurdo'),
                        ('Antarctica/Palmer', 'Antarctica/Palmer'),
                        ('Antarctica/Rothera', 'Antarctica/Rothera'),
                        ('Antarctica/Syowa', 'Antarctica/Syowa'),
                        ('Antarctica/Troll', 'Antarctica/Troll'),
                        ('Antarctica/Vostok', 'Antarctica/Vostok'),
                        ('Arctic/Longyearbyen', 'Arctic/Longyearbyen'),
                        ('Asia/Aden', 'Asia/Aden'),
                        ('Asia/Almaty', 'Asia/Almaty'),
                        ('Asia/Amman', 'Asia/Amman'),
                        ('Asia/Anadyr', 'Asia/Anadyr'),
                        ('Asia/Aqtau', 'Asia/Aqtau'),
                        ('Asia/Aqtobe', 'Asia/Aqtobe'),
                        ('Asia/Ashgabat', 'Asia/Ashgabat'),
                        ('Asia/Atyrau', 'Asia/Atyrau'),
                        ('Asia/Baghdad', 'Asia/Baghdad'),
                        ('Asia/Bahrain', 'Asia/Bahrain'),
                        ('Asia/Baku', 'Asia/Baku'),
                        ('Asia/Bangkok', 'Asia/Bangkok'),
                        ('Asia/Barnaul', 'Asia/Barnaul'),
                        ('Asia/Beirut', 'Asia/Beirut'),
                        ('Asia/Bishkek', 'Asia/Bishkek'),
                        ('Asia/Brunei', 'Asia/Brunei'),
                        ('Asia/Chita', 'Asia/Chita'),
                        ('Asia/Choibalsan', 'Asia/Choibalsan'),
                        ('Asia/Colombo', 'Asia/Colombo'),
                        ('Asia/Damascus', 'Asia/Damascus'),
                        ('Asia/Dhaka', 'Asia/Dhaka'),
                        ('Asia/Dili', 'Asia/Dili'),
                        ('Asia/Dubai', 'Asia/Dubai'),
                        ('Asia/Dushanbe', 'Asia/Dushanbe'),
                        ('Asia/Famagusta', 'Asia/Famagusta'),
                        ('Asia/Gaza', 'Asia/Gaza'),
                        ('Asia/Hebron', 'Asia/Hebron'),
                        ('Asia/Ho_Chi_Minh', 'Asia/Ho_Chi_Minh'),
                        ('Asia/Hong_Kong', 'Asia/Hong_Kong'),
                        ('Asia/Hovd', 'Asia/Hovd'),
                        ('Asia/Irkutsk', 'Asia/Irkutsk'),
                        ('Asia/Jakarta', 'Asia/Jakarta'),
                        ('Asia/Jayapura', 'Asia/Jayapura'),
                        ('Asia/Jerusalem', 'Asia/Jerusalem'),
                        ('Asia/Kabul', 'Asia/Kabul'),
                        ('Asia/Kamchatka', 'Asia/Kamchatka'),
                        ('Asia/Karachi', 'Asia/Karachi'),
                        ('Asia/Kathmandu', 'Asia/Kathmandu'),
                        ('Asia/Khandyga', 'Asia/Khandyga'),
                        ('Asia/Kolkata', 'Asia/Kolkata'),
                        ('Asia/Krasnoyarsk', 'Asia/Krasnoyarsk'),
                        ('Asia/Kuala_Lumpur', 'Asia/Kuala_Lumpur'),
                        ('Asia/Kuching', 'Asia/Kuching'),
                        ('Asia/Kuwait', 'Asia/Kuwait'),
                        ('Asia/Macau', 'Asia/Macau'),
                        ('Asia/Magadan', 'Asia/Magadan'),
                        ('Asia/Makassar', 'Asia/Makassar'),
                        ('Asia/Manila', 'Asia/Manila'),
                        ('Asia/Muscat', 'Asia/Muscat'),
                        ('Asia/Nicosia', 'Asia/Nicosia'),
                        ('Asia/Novokuznetsk', 'Asia/Novokuznetsk'),
                        ('Asia/Novosibirsk', 'Asia/Novosibirsk'),
                        ('Asia/Omsk', 'Asia/Omsk'),
                        ('Asia/Oral', 'Asia/Oral'),
                        ('Asia/Phnom_Penh', 'Asia/Phnom_Penh'),
                        ('Asia/Pontianak', 'Asia/Pontianak'),
                        ('Asia/Pyongyang', 'Asia/Pyongyang'),
                        ('Asia/Qatar', 'Asia/Qatar'),
                        ('Asia/Qyzylorda', 'Asia/Qyzylorda'),
                        ('Asia/Riyadh', 'Asia/Riyadh'),
                        ('Asia/Sakhalin', 'Asia/Sakhalin'),
                        ('Asia/Samarkand', 'Asia/Samarkand'),
                        ('Asia/Seoul', 'Asia/Seoul'),
                        ('Asia/Shanghai', 'Asia/Shanghai'),
                        ('Asia/Singapore', 'Asia/Singapore'),
                        ('Asia/Srednekolymsk', 'Asia/Srednekolymsk'),
                        ('Asia/Taipei', 'Asia/Taipei'),
                        ('Asia/Tashkent', 'Asia/Tashkent'),
                        ('Asia/Tbilisi', 'Asia/Tbilisi'),
                        ('Asia/Tehran', 'Asia/Tehran'),
                        ('Asia/Thimphu', 'Asia/Thimphu'),
                        ('Asia/Tokyo', 'Asia/Tokyo'),
                        ('Asia/Tomsk', 'Asia/Tomsk'),
                        ('Asia/Ulaanbaatar', 'Asia/Ulaanbaatar'),
                        ('Asia/Urumqi', 'Asia/Urumqi'),
                        ('Asia/Ust-Nera', 'Asia/Ust-Nera'),
                        ('Asia/Vientiane', 'Asia/Vientiane'),
                        ('Asia/Vladivostok', 'Asia/Vladivostok'),
                        ('Asia/Yakutsk', 'Asia/Yakutsk'),
                        ('Asia/Yangon', 'Asia/Yangon'),
                        ('Asia/Yekaterinburg', 'Asia/Yekaterinburg'),
                        ('Asia/Yerevan', 'Asia/Yerevan'),
                        ('Atlantic/Azores', 'Atlantic/Azores'),
                        ('Atlantic/Bermuda', 'Atlantic/Bermuda'),
                        ('Atlantic/Canary', 'Atlantic/Canary'),
                        ('Atlantic/Cape_Verde', 'Atlantic/Cape_Verde'),
                        ('Atlantic/Faroe', 'Atlantic/Faroe'),
                        ('Atlantic/Madeira', 'Atlantic/Madeira'),
                        ('Atlantic/Reykjavik', 'Atlantic/Reykjavik'),
                        ('Atlantic/South_Georgia', 'Atlantic/South_Georgia'),
                        ('Atlantic/St_Helena', 'Atlantic/St_Helena'),
                        ('Atlantic/Stanley', 'Atlantic/Stanley'),
                        ('Australia/Adelaide', 'Australia/Adelaide'),
                        ('Australia/Brisbane', 'Australia/Brisbane'),
                        ('Australia/Broken_Hill', 'Australia/Broken_Hill'),
                        ('Australia/Currie', 'Australia/Currie'),
                        ('Australia/Darwin', 'Australia/Darwin'),
                        ('Australia/Eucla', 'Australia/Eucla'),
                        ('Australia/Hobart', 'Australia/Hobart'),
                        ('Australia/Lindeman', 'Australia/Lindeman'),
                        ('Australia/Lord_Howe', 'Australia/Lord_Howe'),
                        ('Australia/Melbourne', 'Australia/Melbourne'),
                        ('Australia/Perth', 'Australia/Perth'),
                        ('Australia/Sydney', 'Australia/Sydney'),
                        ('Canada/Atlantic', 'Canada/Atlantic'),
                        ('Canada/Central', 'Canada/Central'),
                        ('Canada/Eastern', 'Canada/Eastern'),
                        ('Canada/Mountain', 'Canada/Mountain'),
                        ('Canada/Newfoundland', 'Canada/Newfoundland'),
                        ('Canada/Pacific', 'Canada/Pacific'),
                        ('Europe/Amsterdam', 'Europe/Amsterdam'),
                        ('Europe/Andorra', 'Europe/Andorra'),
                        ('Europe/Astrakhan', 'Europe/Astrakhan'),
                        ('Europe/Athens', 'Europe/Athens'),
                        ('Europe/Belgrade', 'Europe/Belgrade'),
                        ('Europe/Berlin', 'Europe/Berlin'),
                        ('Europe/Bratislava', 'Europe/Bratislava'),
                        ('Europe/Brussels', 'Europe/Brussels'),
                        ('Europe/Bucharest', 'Europe/Bucharest'),
                        ('Europe/Budapest', 'Europe/Budapest'),
                        ('Europe/Busingen', 'Europe/Busingen'),
                        ('Europe/Chisinau', 'Europe/Chisinau'),
                        ('Europe/Copenhagen', 'Europe/Copenhagen'),
                        ('Europe/Dublin', 'Europe/Dublin'),
                        ('Europe/Gibraltar', 'Europe/Gibraltar'),
                        ('Europe/Guernsey', 'Europe/Guernsey'),
                        ('Europe/Helsinki', 'Europe/Helsinki'),
                        ('Europe/Isle_of_Man', 'Europe/Isle_of_Man'),
                        ('Europe/Istanbul', 'Europe/Istanbul'),
                        ('Europe/Jersey', 'Europe/Jersey'),
                        ('Europe/Kaliningrad', 'Europe/Kaliningrad'),
                        ('Europe/Kiev', 'Europe/Kiev'),
                        ('Europe/Kirov', 'Europe/Kirov'),
                        ('Europe/Lisbon', 'Europe/Lisbon'),
                        ('Europe/Ljubljana', 'Europe/Ljubljana'),
                        ('Europe/London', 'Europe/London'),
                        ('Europe/Luxembourg', 'Europe/Luxembourg'),
                        ('Europe/Madrid', 'Europe/Madrid'),
                        ('Europe/Malta', 'Europe/Malta'),
                        ('Europe/Mariehamn', 'Europe/Mariehamn'),
                        ('Europe/Minsk', 'Europe/Minsk'),
                        ('Europe/Monaco', 'Europe/Monaco'),
                        ('Europe/Moscow', 'Europe/Moscow'),
                        ('Europe/Oslo', 'Europe/Oslo'),
                        ('Europe/Paris', 'Europe/Paris'),
                        ('Europe/Podgorica', 'Europe/Podgorica'),
                        ('Europe/Prague', 'Europe/Prague'),
                        ('Europe/Riga', 'Europe/Riga'),
                        ('Europe/Rome', 'Europe/Rome'),
                        ('Europe/Samara', 'Europe/Samara'),
                        ('Europe/San_Marino', 'Europe/San_Marino'),
                        ('Europe/Sarajevo', 'Europe/Sarajevo'),
                        ('Europe/Saratov', 'Europe/Saratov'),
                        ('Europe/Simferopol', 'Europe/Simferopol'),
                        ('Europe/Skopje', 'Europe/Skopje'),
                        ('Europe/Sofia', 'Europe/Sofia'),
                        ('Europe/Stockholm', 'Europe/Stockholm'),
                        ('Europe/Tallinn', 'Europe/Tallinn'),
                        ('Europe/Tirane', 'Europe/Tirane'),
                        ('Europe/Ulyanovsk', 'Europe/Ulyanovsk'),
                        ('Europe/Uzhgorod', 'Europe/Uzhgorod'),
                        ('Europe/Vaduz', 'Europe/Vaduz'),
                        ('Europe/Vatican', 'Europe/Vatican'),
                        ('Europe/Vienna', 'Europe/Vienna'),
                        ('Europe/Vilnius', 'Europe/Vilnius'),
                        ('Europe/Volgograd', 'Europe/Volgograd'),
                        ('Europe/Warsaw', 'Europe/Warsaw'),
                        ('Europe/Zagreb', 'Europe/Zagreb'),
                        ('Europe/Zaporozhye', 'Europe/Zaporozhye'),
                        ('Europe/Zurich', 'Europe/Zurich'),
                        ('GMT', 'GMT'),
                        ('Indian/Antananarivo', 'Indian/Antananarivo'),
                        ('Indian/Chagos', 'Indian/Chagos'),
                        ('Indian/Christmas', 'Indian/Christmas'),
                        ('Indian/Cocos', 'Indian/Cocos'),
                        ('Indian/Comoro', 'Indian/Comoro'),
                        ('Indian/Kerguelen', 'Indian/Kerguelen'),
                        ('Indian/Mahe', 'Indian/Mahe'),
                        ('Indian/Maldives', 'Indian/Maldives'),
                        ('Indian/Mauritius', 'Indian/Mauritius'),
                        ('Indian/Mayotte', 'Indian/Mayotte'),
                        ('Indian/Reunion', 'Indian/Reunion'),
                        ('Pacific/Apia', 'Pacific/Apia'),
                        ('Pacific/Auckland', 'Pacific/Auckland'),
                        ('Pacific/Bougainville', 'Pacific/Bougainville'),
                        ('Pacific/Chatham', 'Pacific/Chatham'),
                        ('Pacific/Chuuk', 'Pacific/Chuuk'),
                        ('Pacific/Easter', 'Pacific/Easter'),
                        ('Pacific/Efate', 'Pacific/Efate'),
                        ('Pacific/Enderbury', 'Pacific/Enderbury'),
                        ('Pacific/Fakaofo', 'Pacific/Fakaofo'),
                        ('Pacific/Fiji', 'Pacific/Fiji'),
                        ('Pacific/Funafuti', 'Pacific/Funafuti'),
                        ('Pacific/Galapagos', 'Pacific/Galapagos'),
                        ('Pacific/Gambier', 'Pacific/Gambier'),
                        ('Pacific/Guadalcanal', 'Pacific/Guadalcanal'),
                        ('Pacific/Guam', 'Pacific/Guam'),
                        ('Pacific/Honolulu', 'Pacific/Honolulu'),
                        ('Pacific/Kiritimati', 'Pacific/Kiritimati'),
                        ('Pacific/Kosrae', 'Pacific/Kosrae'),
                        ('Pacific/Kwajalein', 'Pacific/Kwajalein'),
                        ('Pacific/Majuro', 'Pacific/Majuro'),
                        ('Pacific/Marquesas', 'Pacific/Marquesas'),
                        ('Pacific/Midway', 'Pacific/Midway'),
                        ('Pacific/Nauru', 'Pacific/Nauru'),
                        ('Pacific/Niue', 'Pacific/Niue'),
                        ('Pacific/Norfolk', 'Pacific/Norfolk'),
                        ('Pacific/Noumea', 'Pacific/Noumea'),
                        ('Pacific/Pago_Pago', 'Pacific/Pago_Pago'),
                        ('Pacific/Palau', 'Pacific/Palau'),
                        ('Pacific/Pitcairn', 'Pacific/Pitcairn'),
                        ('Pacific/Pohnpei', 'Pacific/Pohnpei'),
                        ('Pacific/Port_Moresby', 'Pacific/Port_Moresby'),
                        ('Pacific/Rarotonga', 'Pacific/Rarotonga'),
                        ('Pacific/Saipan', 'Pacific/Saipan'),
                        ('Pacific/Tahiti', 'Pacific/Tahiti'),
                        ('Pacific/Tarawa', 'Pacific/Tarawa'),
                        ('Pacific/Tongatapu', 'Pacific/Tongatapu'),
                        ('Pacific/Wake', 'Pacific/Wake'),
                        ('Pacific/Wallis', 'Pacific/Wallis'),
                        ('US/Alaska', 'US/Alaska'),
                        ('US/Arizona', 'US/Arizona'),
                        ('US/Central', 'US/Central'),
                        ('US/Eastern', 'US/Eastern'),
                        ('US/Hawaii', 'US/Hawaii'),
                        ('US/Mountain', 'US/Mountain'),
                        ('US/Pacific', 'US/Pacific'),
                        ('UTC', 'UTC')],
                    default=b'UTC',
                    help_text=b'Used for developer clock page',
                    max_length=100)),
                ('alias', models.CharField(help_text='Required field', max_length=50)),
                ('public_email', models.CharField(help_text='Required field', max_length=50)),
                ('other_contact', models.CharField(blank=True, max_length=100, null=True)),
                ('pgp_key', devel.fields.PGPKeyField(
                    blank=True, help_text='consists of 40 hex digits; use `gpg --fingerprint`',
                    max_length=40, null=True, verbose_name='PGP key fingerprint')),
                ('website', models.CharField(blank=True, max_length=200, null=True)),
                ('yob', models.IntegerField(blank=True, null=True, verbose_name='Year of birth')),
                ('country', django_countries.fields.CountryField(blank=True, max_length=2)),
                ('location', models.CharField(blank=True, max_length=50, null=True)),
                ('languages', models.CharField(blank=True, max_length=50, null=True)),
                ('interests', models.CharField(blank=True, max_length=255, null=True)),
                ('occupation', models.CharField(blank=True, max_length=50, null=True)),
                ('roles', models.CharField(blank=True, max_length=255, null=True)),
                ('favorite_distros', models.CharField(blank=True, max_length=255, null=True)),
                ('picture', models.FileField(
                    default='devs/silhouette.png', help_text='Ideally 125px by 125px', upload_to='devs')),
                ('latin_name', models.CharField(
                    blank=True, help_text='Latin-form name; used only for non-Latin full names',
                    max_length=255, null=True)),
                ('last_modified', models.DateTimeField(editable=False)),
                ('allowed_repos', models.ManyToManyField(blank=True, to='main.Repo')),
                ('user', models.OneToOneField(
                    on_delete=django.db.models.deletion.CASCADE,
                    related_name='userprofile', to=settings.AUTH_USER_MODEL)),
            ],
            options={
                'get_latest_by': 'last_modified',
                'verbose_name': 'additional profile data',
                'verbose_name_plural': 'additional profile data',
                'db_table': 'user_profiles',
            },
        ),
        migrations.CreateModel(
            name='StaffGroup',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=100)),
                ('slug', models.SlugField(max_length=100, unique=True)),
                ('sort_order', models.PositiveIntegerField()),
                ('member_title', models.CharField(max_length=100)),
                ('description', models.TextField(blank=True)),
                ('group', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, to='auth.Group')),
            ],
            options={
                'ordering': ('sort_order',),
            },
        ),
    ]