0001_initial.py 36.3 KB
Newer Older
1
# Generated by Django 2.0.3 on 2018-08-30 20:53
2 3 4 5 6 7 8 9 10 11 12 13 14 15

import backend.utils.friendly_path
from django.conf import settings
import django.contrib.postgres.fields.jsonb
import django.core.validators
from django.db import migrations, models
import django.db.models.deletion


class Migration(migrations.Migration):

    initial = True

    dependencies = [
16
        ('contenttypes', '0002_remove_content_type_name'),
17 18 19 20 21 22 23 24
        migrations.swappable_dependency(settings.AUTH_USER_MODEL),
    ]

    operations = [
        migrations.CreateModel(
            name='Campus',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
25 26
                ('moderated_on', models.DateTimeField(null=True)),
                ('updated_on', models.DateTimeField(null=True)),
27
                ('usefull_links', django.contrib.postgres.fields.jsonb.JSONField(blank=True, default=list)),
28 29 30 31 32 33 34 35 36 37 38
                ('is_main_campus', models.BooleanField()),
                ('name', models.CharField(max_length=200, null=True)),
                ('comment', models.TextField(blank=True, null=True)),
                ('lat', models.DecimalField(decimal_places=6, max_digits=10, validators=[django.core.validators.MinValueValidator(-85.05112878), django.core.validators.MaxValueValidator(85.05112878)])),
                ('lon', models.DecimalField(decimal_places=6, max_digits=10, validators=[django.core.validators.MinValueValidator(-180), django.core.validators.MaxValueValidator(180)])),
            ],
        ),
        migrations.CreateModel(
            name='City',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
39 40
                ('moderated_on', models.DateTimeField(null=True)),
                ('updated_on', models.DateTimeField(null=True)),
41 42 43 44
                ('name', models.CharField(max_length=200)),
                ('local_name', models.CharField(blank=True, max_length=200, null=True)),
                ('area', models.CharField(blank=True, max_length=200, null=True)),
            ],
45 46 47
            options={
                'abstract': False,
            },
48 49 50 51
        ),
        migrations.CreateModel(
            name='Country',
            fields=[
52 53
                ('moderated_on', models.DateTimeField(null=True)),
                ('updated_on', models.DateTimeField(null=True)),
54 55 56 57 58 59 60 61 62 63
                ('name', models.CharField(max_length=200)),
                ('iso_alpha2_code', models.CharField(max_length=2, primary_key=True, serialize=False)),
                ('iso_alpha3_code', models.CharField(max_length=3, unique=True)),
                ('region_name', models.CharField(max_length=200)),
                ('region_un_code', models.CharField(max_length=3)),
                ('sub_region_name', models.CharField(blank=True, max_length=200, null=True)),
                ('sub_region_un_code', models.CharField(blank=True, max_length=3, null=True)),
                ('intermediate_region_name', models.CharField(blank=True, max_length=200, null=True)),
                ('intermediate_region_un_code', models.CharField(blank=True, max_length=3, null=True)),
            ],
64 65 66
            options={
                'abstract': False,
            },
67 68 69 70 71
        ),
        migrations.CreateModel(
            name='CountryDri',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
72 73
                ('moderated_on', models.DateTimeField(null=True)),
                ('updated_on', models.DateTimeField(null=True)),
74
                ('comment', models.TextField(blank=True)),
75
                ('usefull_links', django.contrib.postgres.fields.jsonb.JSONField(blank=True, default=list)),
76 77 78 79 80 81 82 83 84
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='CountryScholarship',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
85 86
                ('moderated_on', models.DateTimeField(null=True)),
                ('updated_on', models.DateTimeField(null=True)),
87
                ('comment', models.TextField(blank=True)),
88
                ('usefull_links', django.contrib.postgres.fields.jsonb.JSONField(blank=True, default=list)),
89 90 91 92 93 94 95 96 97 98 99
                ('type', models.CharField(max_length=200)),
                ('amount_min', models.DecimalField(decimal_places=2, max_digits=20, validators=[django.core.validators.MinValueValidator(0)])),
                ('amount_max', models.DecimalField(decimal_places=2, max_digits=20, validators=[django.core.validators.MinValueValidator(0)])),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='Currency',
            fields=[
100 101
                ('moderated_on', models.DateTimeField(null=True)),
                ('updated_on', models.DateTimeField(null=True)),
102 103 104 105
                ('code', models.CharField(max_length=15, primary_key=True, serialize=False)),
                ('name', models.CharField(max_length=100)),
                ('symbol', models.CharField(max_length=5)),
                ('one_USD_in_this_currency', models.DecimalField(decimal_places=6, max_digits=20, validators=[django.core.validators.MinValueValidator(0)])),
106 107
                ('moderated_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)),
                ('updated_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)),
108
            ],
109 110 111
            options={
                'abstract': False,
            },
112 113 114 115
        ),
        migrations.CreateModel(
            name='Department',
            fields=[
116 117
                ('moderated_on', models.DateTimeField(null=True)),
                ('updated_on', models.DateTimeField(null=True)),
118 119 120
                ('code', models.CharField(max_length=6, primary_key=True, serialize=False)),
                ('name', models.CharField(max_length=100)),
                ('active', models.BooleanField()),
121 122
                ('moderated_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)),
                ('updated_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)),
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
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='ForTestingModeration',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('moderated_on', models.DateTimeField(null=True)),
                ('updated_on', models.DateTimeField(null=True)),
                ('aaa', models.CharField(max_length=100)),
                ('moderated_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)),
                ('updated_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='ForTestingVersioning',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('moderated_on', models.DateTimeField(null=True)),
                ('updated_on', models.DateTimeField(null=True)),
                ('bbb', models.CharField(max_length=100)),
                ('moderated_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)),
                ('updated_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)),
            ],
            options={
                'abstract': False,
            },
155 156 157 158 159
        ),
        migrations.CreateModel(
            name='Offer',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
160 161
                ('moderated_on', models.DateTimeField(null=True)),
                ('updated_on', models.DateTimeField(null=True)),
162 163 164
                ('nb_seats_offered', models.PositiveIntegerField()),
                ('nb_seats_offered_exchange', models.PositiveIntegerField(null=True)),
                ('nb_seats_offered_double_degree', models.PositiveIntegerField(null=True)),
165 166 167 168 169 170 171 172 173 174 175 176
                ('moderated_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)),
            ],
        ),
        migrations.CreateModel(
            name='PendingModeration',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('object_id', models.CharField(max_length=100)),
                ('updated_on', models.DateTimeField(null=True)),
                ('new_object', django.contrib.postgres.fields.jsonb.JSONField(default=dict)),
                ('content_type', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='contenttypes.ContentType')),
                ('updated_by', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
177 178 179 180 181 182
            ],
        ),
        migrations.CreateModel(
            name='PreviousDeparture',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
183 184
                ('moderated_on', models.DateTimeField(null=True)),
                ('updated_on', models.DateTimeField(null=True)),
185 186 187
                ('Utc_departure_id', models.IntegerField()),
                ('is_anonymous', models.BooleanField()),
                ('courses', django.contrib.postgres.fields.jsonb.JSONField(null=True)),
188
                ('moderated_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)),
189
            ],
190 191 192
            options={
                'abstract': False,
            },
193 194 195 196 197
        ),
        migrations.CreateModel(
            name='PreviousDepartureFeedback',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
198 199
                ('moderated_on', models.DateTimeField(null=True)),
                ('updated_on', models.DateTimeField(null=True)),
200 201
                ('is_anonymous', models.BooleanField(default=True)),
                ('is_public', models.BooleanField(default=False)),
202
                ('courses_and_courses_feedback', django.contrib.postgres.fields.jsonb.JSONField(default=dict)),
203 204 205 206 207
                ('adequation_comment', models.TextField()),
                ('integration_comment', models.TextField()),
                ('adequation_grate', models.PositiveIntegerField(validators=[django.core.validators.MaxValueValidator(20)])),
                ('integration_grade', models.PositiveIntegerField(validators=[django.core.validators.MaxValueValidator(20)])),
                ('departure', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, to='backend.PreviousDeparture')),
208 209 210
                ('moderated_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)),
                ('owner', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
                ('updated_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)),
211 212 213 214 215 216 217 218 219
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='Recommendation',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
220 221
                ('moderated_on', models.DateTimeField(null=True)),
                ('updated_on', models.DateTimeField(null=True)),
222 223 224 225 226
                ('is_anonymous', models.BooleanField(default=True)),
                ('is_public', models.BooleanField(default=False)),
                ('order_in_list', models.PositiveIntegerField()),
                ('comment', models.TextField(blank=True, null=True)),
                ('grade', models.PositiveIntegerField(null=True, validators=[django.core.validators.MaxValueValidator(20)])),
227 228
                ('moderated_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)),
                ('owner', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
229 230 231 232 233 234
            ],
        ),
        migrations.CreateModel(
            name='RecommendationList',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
235 236
                ('moderated_on', models.DateTimeField(null=True)),
                ('updated_on', models.DateTimeField(null=True)),
237 238 239 240
                ('is_anonymous', models.BooleanField(default=True)),
                ('is_public', models.BooleanField(default=False)),
                ('public', models.BooleanField()),
                ('title', models.CharField(max_length=200)),
241 242 243
                ('moderated_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)),
                ('owner', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
                ('updated_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)),
244 245 246 247 248
            ],
        ),
        migrations.CreateModel(
            name='Semester',
            fields=[
249 250
                ('moderated_on', models.DateTimeField(null=True)),
                ('updated_on', models.DateTimeField(null=True)),
251
                ('code', models.CharField(max_length=6, primary_key=True, serialize=False)),
252 253
                ('moderated_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)),
                ('updated_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)),
254
            ],
255 256 257
            options={
                'abstract': False,
            },
258 259 260 261 262
        ),
        migrations.CreateModel(
            name='Specialty',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
263 264
                ('moderated_on', models.DateTimeField(null=True)),
                ('updated_on', models.DateTimeField(null=True)),
265 266 267 268
                ('code', models.CharField(max_length=6)),
                ('name', models.CharField(max_length=100)),
                ('active', models.BooleanField()),
                ('department', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='backend.Department')),
269 270 271 272 273 274 275 276 277 278
                ('moderated_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)),
                ('updated_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)),
            ],
        ),
        migrations.CreateModel(
            name='Tag',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('moderated_on', models.DateTimeField(null=True)),
                ('updated_on', models.DateTimeField(null=True)),
279
                ('name', models.CharField(max_length=100, unique=True)),
280 281 282
                ('config', django.contrib.postgres.fields.jsonb.JSONField(blank=True, default=dict)),
                ('moderated_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)),
                ('updated_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)),
283
            ],
284 285 286
            options={
                'abstract': False,
            },
287 288 289 290 291
        ),
        migrations.CreateModel(
            name='University',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
292 293
                ('moderated_on', models.DateTimeField(null=True)),
                ('updated_on', models.DateTimeField(null=True)),
294 295 296 297 298 299 300 301 302 303 304 305 306
                ('name', models.CharField(max_length=200)),
                ('acronym', models.CharField(blank=True, max_length=20, null=True)),
                ('logo', models.ImageField(default='path/to/my/default/image.jpg', max_length=250, upload_to=backend.utils.friendly_path.friendly_path('uploads/universities/logos/', 'name'))),
                ('website', models.URLField(null=True)),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='UniversityDri',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
307 308
                ('moderated_on', models.DateTimeField(null=True)),
                ('updated_on', models.DateTimeField(null=True)),
309
                ('comment', models.TextField(blank=True)),
310
                ('usefull_links', django.contrib.postgres.fields.jsonb.JSONField(blank=True, default=list)),
311
                ('moderated_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)),
312 313 314 315 316 317 318 319 320
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='UniversityScholarship',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
321 322
                ('moderated_on', models.DateTimeField(null=True)),
                ('updated_on', models.DateTimeField(null=True)),
323
                ('comment', models.TextField(blank=True)),
324
                ('usefull_links', django.contrib.postgres.fields.jsonb.JSONField(blank=True, default=list)),
325 326 327 328
                ('type', models.CharField(max_length=200)),
                ('amount_min', models.DecimalField(decimal_places=2, max_digits=20, validators=[django.core.validators.MinValueValidator(0)])),
                ('amount_max', models.DecimalField(decimal_places=2, max_digits=20, validators=[django.core.validators.MinValueValidator(0)])),
                ('currency', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='backend.Currency')),
329
                ('moderated_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)),
330 331 332 333 334 335 336 337 338
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='UserData',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
339 340 341
                ('moderated_on', models.DateTimeField(null=True)),
                ('updated_on', models.DateTimeField(null=True)),
                ('contact_info', django.contrib.postgres.fields.jsonb.JSONField(default=dict)),
342
                ('contact_info_is_public', models.BooleanField(default=False)),
343 344
                ('config', django.contrib.postgres.fields.jsonb.JSONField(default=dict)),
                ('other_data', django.contrib.postgres.fields.jsonb.JSONField(default=dict)),
345 346 347 348 349 350
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
351
            name='CampusTaggedItem',
352
            fields=[
353 354 355 356 357 358
                ('moderated_on', models.DateTimeField(null=True)),
                ('updated_on', models.DateTimeField(null=True)),
                ('campus', models.OneToOneField(on_delete=django.db.models.deletion.PROTECT, primary_key=True, related_name='city_items', serialize=False, to='backend.Campus')),
                ('moderated_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)),
                ('tag', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='+', to='backend.Tag')),
                ('updated_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)),
359 360 361
            ],
        ),
        migrations.CreateModel(
362
            name='CityTaggedItem',
363
            fields=[
364 365 366 367 368 369
                ('moderated_on', models.DateTimeField(null=True)),
                ('updated_on', models.DateTimeField(null=True)),
                ('city', models.OneToOneField(on_delete=django.db.models.deletion.PROTECT, primary_key=True, related_name='city_items', serialize=False, to='backend.City')),
                ('moderated_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)),
                ('tag', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='+', to='backend.Tag')),
                ('updated_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)),
370 371 372
            ],
        ),
        migrations.CreateModel(
373
            name='CountryTaggedItem',
374
            fields=[
375 376
                ('moderated_on', models.DateTimeField(null=True)),
                ('updated_on', models.DateTimeField(null=True)),
377
                ('country', models.OneToOneField(on_delete=django.db.models.deletion.PROTECT, primary_key=True, related_name='country_items', serialize=False, to='backend.Country')),
378 379 380
                ('moderated_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)),
                ('tag', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='+', to='backend.Tag')),
                ('updated_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)),
381 382 383 384 385
            ],
        ),
        migrations.CreateModel(
            name='UniversityInfo',
            fields=[
386 387
                ('moderated_on', models.DateTimeField(null=True)),
                ('updated_on', models.DateTimeField(null=True)),
388
                ('comment', models.TextField(blank=True)),
389
                ('usefull_links', django.contrib.postgres.fields.jsonb.JSONField(blank=True, default=list)),
390 391 392 393
                ('university', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, primary_key=True, related_name='university_info', serialize=False, to='backend.University')),
                ('cost_exchange', models.DecimalField(decimal_places=2, max_digits=20, null=True, validators=[django.core.validators.MinValueValidator(0)])),
                ('cost_double_degree', models.DecimalField(decimal_places=2, max_digits=20, null=True, validators=[django.core.validators.MinValueValidator(0)])),
                ('costs_currency', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='backend.Currency')),
394 395
                ('moderated_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)),
                ('updated_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)),
396 397 398 399 400 401 402 403
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='UniversitySemestersDates',
            fields=[
404 405
                ('moderated_on', models.DateTimeField(null=True)),
                ('updated_on', models.DateTimeField(null=True)),
406
                ('comment', models.TextField(blank=True)),
407
                ('usefull_links', django.contrib.postgres.fields.jsonb.JSONField(blank=True, default=list)),
408 409 410 411 412
                ('university', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, primary_key=True, related_name='university_semesters_dates', serialize=False, to='backend.University')),
                ('spring_begin', models.DateField(blank=True, null=True)),
                ('spring_end', models.DateField(blank=True, null=True)),
                ('autumn_begin', models.DateField(blank=True, null=True)),
                ('autumn_end', models.DateField(blank=True, null=True)),
413 414
                ('moderated_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)),
                ('updated_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)),
415 416 417 418 419 420
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
421
            name='UniversityTaggedItem',
422
            fields=[
423 424 425 426 427 428
                ('moderated_on', models.DateTimeField(null=True)),
                ('updated_on', models.DateTimeField(null=True)),
                ('university', models.OneToOneField(on_delete=django.db.models.deletion.PROTECT, primary_key=True, related_name='city_items', serialize=False, to='backend.University')),
                ('moderated_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)),
                ('tag', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='+', to='backend.Tag')),
                ('updated_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)),
429
            ],
430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449
        ),
        migrations.AddField(
            model_name='userdata',
            name='black_list',
            field=models.ManyToManyField(blank=True, related_name='_userdata_black_list_+', to='backend.University'),
        ),
        migrations.AddField(
            model_name='userdata',
            name='moderated_by',
            field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL),
        ),
        migrations.AddField(
            model_name='userdata',
            name='owner',
            field=models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL),
        ),
        migrations.AddField(
            model_name='userdata',
            name='updated_by',
            field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL),
450 451 452 453 454 455
        ),
        migrations.AddField(
            model_name='universityscholarship',
            name='university',
            field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='univScholarship', to='backend.University'),
        ),
456 457 458 459 460
        migrations.AddField(
            model_name='universityscholarship',
            name='updated_by',
            field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL),
        ),
461 462 463 464 465
        migrations.AddField(
            model_name='universitydri',
            name='university',
            field=models.ManyToManyField(related_name='university_dri', to='backend.University'),
        ),
466 467 468 469 470 471 472 473 474 475 476 477 478 479 480
        migrations.AddField(
            model_name='universitydri',
            name='updated_by',
            field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL),
        ),
        migrations.AddField(
            model_name='university',
            name='moderated_by',
            field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL),
        ),
        migrations.AddField(
            model_name='university',
            name='updated_by',
            field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL),
        ),
481 482 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497
        migrations.AddField(
            model_name='recommendation',
            name='parent_list',
            field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='recommendations', to='backend.RecommendationList'),
        ),
        migrations.AddField(
            model_name='recommendation',
            name='specialty',
            field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='backend.Specialty'),
        ),
        migrations.AddField(
            model_name='recommendation',
            name='university',
            field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='backend.University'),
        ),
        migrations.AddField(
            model_name='recommendation',
498 499
            name='updated_by',
            field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL),
500 501 502 503 504 505 506 507 508 509 510 511 512 513 514 515
        ),
        migrations.AddField(
            model_name='previousdeparture',
            name='semester',
            field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='backend.Semester'),
        ),
        migrations.AddField(
            model_name='previousdeparture',
            name='specialty',
            field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='backend.Specialty'),
        ),
        migrations.AddField(
            model_name='previousdeparture',
            name='university',
            field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='backend.University'),
        ),
516 517 518 519 520
        migrations.AddField(
            model_name='previousdeparture',
            name='updated_by',
            field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL),
        ),
521 522 523 524 525 526 527 528 529 530 531 532 533 534 535 536 537 538 539 540
        migrations.AddField(
            model_name='previousdeparture',
            name='user',
            field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL),
        ),
        migrations.AddField(
            model_name='offer',
            name='semester',
            field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='backend.Semester'),
        ),
        migrations.AddField(
            model_name='offer',
            name='specialty',
            field=models.ManyToManyField(related_name='has_seats_at_univ', to='backend.Specialty'),
        ),
        migrations.AddField(
            model_name='offer',
            name='university',
            field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='backend.University'),
        ),
541 542 543 544 545
        migrations.AddField(
            model_name='offer',
            name='updated_by',
            field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL),
        ),
546 547 548 549 550 551 552 553 554 555
        migrations.AddField(
            model_name='countryscholarship',
            name='country',
            field=models.ManyToManyField(related_name='country_scholarhip', to='backend.Country'),
        ),
        migrations.AddField(
            model_name='countryscholarship',
            name='currency',
            field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='backend.Currency'),
        ),
556 557 558 559 560 561 562 563 564 565
        migrations.AddField(
            model_name='countryscholarship',
            name='moderated_by',
            field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL),
        ),
        migrations.AddField(
            model_name='countryscholarship',
            name='updated_by',
            field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL),
        ),
566 567 568 569 570
        migrations.AddField(
            model_name='countrydri',
            name='country',
            field=models.ManyToManyField(related_name='country_dri', to='backend.Country'),
        ),
571 572 573 574 575 576 577 578 579 580 581 582 583 584 585 586 587 588 589 590
        migrations.AddField(
            model_name='countrydri',
            name='moderated_by',
            field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL),
        ),
        migrations.AddField(
            model_name='countrydri',
            name='updated_by',
            field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL),
        ),
        migrations.AddField(
            model_name='country',
            name='moderated_by',
            field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL),
        ),
        migrations.AddField(
            model_name='country',
            name='updated_by',
            field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL),
        ),
591 592 593 594 595
        migrations.AddField(
            model_name='city',
            name='country',
            field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='backend.Country'),
        ),
596 597 598 599 600 601 602 603 604 605
        migrations.AddField(
            model_name='city',
            name='moderated_by',
            field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL),
        ),
        migrations.AddField(
            model_name='city',
            name='updated_by',
            field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL),
        ),
606 607 608 609 610
        migrations.AddField(
            model_name='campus',
            name='city',
            field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='backend.City'),
        ),
611 612 613 614 615
        migrations.AddField(
            model_name='campus',
            name='moderated_by',
            field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL),
        ),
616 617 618
        migrations.AddField(
            model_name='campus',
            name='university',
619 620 621 622 623 624
            field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='univ_campus', to='backend.University'),
        ),
        migrations.AddField(
            model_name='campus',
            name='updated_by',
            field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL),
625 626 627 628 629 630 631
        ),
        migrations.AlterUniqueTogether(
            name='specialty',
            unique_together={('code', 'department')},
        ),
        migrations.AlterUniqueTogether(
            name='recommendationlist',
632
            unique_together={('title', 'owner')},
633 634 635 636 637
        ),
        migrations.AlterUniqueTogether(
            name='recommendation',
            unique_together={('order_in_list', 'parent_list')},
        ),
638 639 640 641
        migrations.AlterUniqueTogether(
            name='pendingmoderation',
            unique_together={('content_type', 'object_id')},
        ),
642 643 644 645 646 647 648 649
        migrations.AlterUniqueTogether(
            name='offer',
            unique_together={('semester', 'university')},
        ),
        migrations.AlterUniqueTogether(
            name='campus',
            unique_together={('is_main_campus', 'university')},
        ),
650 651 652 653 654 655 656 657 658 659 660 661 662 663 664 665
        migrations.AlterUniqueTogether(
            name='universitytaggeditem',
            unique_together={('university', 'tag')},
        ),
        migrations.AlterUniqueTogether(
            name='countrytaggeditem',
            unique_together={('country', 'tag')},
        ),
        migrations.AlterUniqueTogether(
            name='citytaggeditem',
            unique_together={('city', 'tag')},
        ),
        migrations.AlterUniqueTogether(
            name='campustaggeditem',
            unique_together={('campus', 'tag')},
        ),
666
    ]