# Generated by Django 6.0.3 on 2026-03-31 18:57

import django.db.models.deletion
import phonenumber_field.modelfields
from django.db import migrations, models


class Migration(migrations.Migration):

    initial = True

    dependencies = [
    ]

    operations = [
        migrations.CreateModel(
            name='AboutUniversity',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('title', models.CharField(max_length=255)),
                ('title_uz', models.CharField(max_length=255, null=True)),
                ('title_ru', models.CharField(max_length=255, null=True)),
                ('title_en', models.CharField(max_length=255, null=True)),
                ('description', models.TextField()),
                ('description_uz', models.TextField(null=True)),
                ('description_ru', models.TextField(null=True)),
                ('description_en', models.TextField(null=True)),
                ('image', models.ImageField(blank=True, null=True, upload_to='about/')),
            ],
        ),
        migrations.CreateModel(
            name='Author',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('full_name', models.CharField(max_length=150)),
                ('position', models.CharField(blank=True, max_length=150)),
            ],
        ),
        migrations.CreateModel(
            name='BachelorCategory',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('title', models.CharField(max_length=255)),
                ('title_uz', models.CharField(max_length=255, null=True)),
                ('title_ru', models.CharField(max_length=255, null=True)),
                ('title_en', models.CharField(max_length=255, null=True)),
                ('icon', models.CharField(blank=True, help_text='Icon nomi (ixtiyoriy)', max_length=50)),
                ('order', models.PositiveIntegerField(default=0)),
            ],
            options={
                'verbose_name': 'Bakalavr kategoriya',
                'verbose_name_plural': 'Bakalavr kategoriyalar',
                'ordering': ['order'],
            },
        ),
        migrations.CreateModel(
            name='CallLink',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('link_facebook', models.CharField(blank=True, max_length=50, verbose_name='facebook-link')),
                ('link_telegram', models.CharField(blank=True, max_length=50, verbose_name='telegram-link')),
                ('link_instagram', models.CharField(blank=True, max_length=50, verbose_name='instagram-link')),
                ('link_youtobe', models.CharField(blank=True, max_length=50, verbose_name='youtobe-link')),
            ],
            options={
                'verbose_name': 'Aloqa Linklar',
                'verbose_name_plural': 'Aloqa Linklar',
            },
        ),
        migrations.CreateModel(
            name='CallUserCategory',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=150, verbose_name='F.I.SH')),
                ('rang', models.CharField(max_length=150, verbose_name='lavozimi')),
                ('tell', phonenumber_field.modelfields.PhoneNumberField(max_length=128, region=None, unique=True, verbose_name='Tell number')),
                ('mail', models.EmailField(blank=True, max_length=254, null=True, verbose_name='email')),
            ],
            options={
                'verbose_name': "Aloqa Bo'limlar bilan bog'lanish",
                'verbose_name_plural': "Aloqa Bo'limlar bilan bog'lanish",
            },
        ),
        migrations.CreateModel(
            name='ContactMessage',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=150)),
                ('phone', models.CharField(max_length=50)),
                ('email', models.EmailField(max_length=254)),
                ('message', models.TextField()),
                ('created_at', models.DateTimeField(auto_now_add=True)),
            ],
            options={
                'verbose_name': 'Xabar',
                'verbose_name_plural': 'Xabarlar',
                'ordering': ['-created_at'],
            },
        ),
        migrations.CreateModel(
            name='CooperationProgram',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('title', models.CharField(max_length=255, verbose_name='Dastur')),
                ('title_uz', models.CharField(max_length=255, null=True, verbose_name='Dastur')),
                ('title_ru', models.CharField(max_length=255, null=True, verbose_name='Dastur')),
                ('title_en', models.CharField(max_length=255, null=True, verbose_name='Dastur')),
                ('description', models.TextField(verbose_name='Tavsif')),
                ('description_uz', models.TextField(null=True, verbose_name='Tavsif')),
                ('description_ru', models.TextField(null=True, verbose_name='Tavsif')),
                ('description_en', models.TextField(null=True, verbose_name='Tavsif')),
                ('icon', models.CharField(blank=True, help_text='Icon nomi (masalan: exchange, diploma)', max_length=50)),
                ('order', models.PositiveIntegerField(default=0)),
            ],
            options={
                'verbose_name': 'Hamkorlik dasturi',
                'verbose_name_plural': 'Hamkorlik dasturlari',
                'ordering': ['order'],
            },
        ),
        migrations.CreateModel(
            name='EkranImages',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('img', models.ImageField(upload_to='ekran_IMG/')),
            ],
            options={
                'verbose_name': 'Ekran Rasmi',
                'verbose_name_plural': 'Ekran Rasmlari',
            },
        ),
        migrations.CreateModel(
            name='galareyaIMG',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('img', models.FileField(upload_to='galareya/')),
            ],
            options={
                'verbose_name': 'Galareya rasmi',
                'verbose_name_plural': 'Galareya rasmi',
            },
        ),
        migrations.CreateModel(
            name='MasterCategory',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('title', models.CharField(max_length=255)),
                ('title_uz', models.CharField(max_length=255, null=True)),
                ('title_ru', models.CharField(max_length=255, null=True)),
                ('title_en', models.CharField(max_length=255, null=True)),
                ('description', models.TextField(blank=True)),
                ('description_uz', models.TextField(blank=True, null=True)),
                ('description_ru', models.TextField(blank=True, null=True)),
                ('description_en', models.TextField(blank=True, null=True)),
                ('duration', models.PositiveIntegerField(default=2)),
                ('order', models.PositiveIntegerField(default=0)),
            ],
            options={
                'verbose_name': 'Magistratura turi',
                'verbose_name_plural': 'Magistratura turlari',
                'ordering': ['order'],
            },
        ),
        migrations.CreateModel(
            name='PartnerCountry',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=150, verbose_name='Davlat')),
                ('name_uz', models.CharField(max_length=150, null=True, verbose_name='Davlat')),
                ('name_ru', models.CharField(max_length=150, null=True, verbose_name='Davlat')),
                ('name_en', models.CharField(max_length=150, null=True, verbose_name='Davlat')),
                ('flag', models.ImageField(blank=True, null=True, upload_to='countries/', verbose_name='Bayroq')),
                ('university_count', models.PositiveIntegerField(default=0, verbose_name='Universitetlar soni')),
                ('order', models.PositiveIntegerField(default=0, verbose_name='Tartib')),
            ],
            options={
                'verbose_name': 'Hamkor davlat',
                'verbose_name_plural': 'Hamkor davlatlar',
                'ordering': ['order'],
            },
        ),
        migrations.CreateModel(
            name='ProjectCategory',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=100, verbose_name='Loyiha kategoriyasi')),
                ('name_uz', models.CharField(max_length=100, null=True, verbose_name='Loyiha kategoriyasi')),
                ('name_ru', models.CharField(max_length=100, null=True, verbose_name='Loyiha kategoriyasi')),
                ('name_en', models.CharField(max_length=100, null=True, verbose_name='Loyiha kategoriyasi')),
            ],
        ),
        migrations.CreateModel(
            name='PublicationStat',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('title', models.CharField(max_length=255, verbose_name='Nashrlar')),
                ('title_uz', models.CharField(max_length=255, null=True, verbose_name='Nashrlar')),
                ('title_ru', models.CharField(max_length=255, null=True, verbose_name='Nashrlar')),
                ('title_en', models.CharField(max_length=255, null=True, verbose_name='Nashrlar')),
                ('count', models.PositiveIntegerField(verbose_name='Qiymat')),
                ('year', models.PositiveIntegerField(default=2024, verbose_name='Yil')),
            ],
        ),
        migrations.CreateModel(
            name='Rector',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('full_name', models.CharField(max_length=255, verbose_name='F.I.Sh')),
                ('full_name_uz', models.CharField(max_length=255, null=True, verbose_name='F.I.Sh')),
                ('full_name_ru', models.CharField(max_length=255, null=True, verbose_name='F.I.Sh')),
                ('full_name_en', models.CharField(max_length=255, null=True, verbose_name='F.I.Sh')),
                ('position', models.CharField(max_length=255, verbose_name='Lavozimi')),
                ('position_uz', models.CharField(max_length=255, null=True, verbose_name='Lavozimi')),
                ('position_ru', models.CharField(max_length=255, null=True, verbose_name='Lavozimi')),
                ('position_en', models.CharField(max_length=255, null=True, verbose_name='Lavozimi')),
                ('image', models.ImageField(upload_to='rector/photo/', verbose_name='Rasm')),
                ('academic_degree', models.CharField(max_length=255, verbose_name='Ilmiy darajasi')),
                ('academic_degree_uz', models.CharField(max_length=255, null=True, verbose_name='Ilmiy darajasi')),
                ('academic_degree_ru', models.CharField(max_length=255, null=True, verbose_name='Ilmiy darajasi')),
                ('academic_degree_en', models.CharField(max_length=255, null=True, verbose_name='Ilmiy darajasi')),
                ('experience_years', models.PositiveIntegerField(verbose_name='Ish staji (yil)')),
                ('publications_count', models.PositiveIntegerField(verbose_name='Nashrlar soni')),
                ('email', models.EmailField(max_length=254, verbose_name='Elektron pochta')),
                ('phone', models.CharField(max_length=50, verbose_name='Telefon raqami')),
                ('office_location', models.CharField(max_length=255, verbose_name='Qabul joyi')),
                ('office_location_uz', models.CharField(max_length=255, null=True, verbose_name='Qabul joyi')),
                ('office_location_ru', models.CharField(max_length=255, null=True, verbose_name='Qabul joyi')),
                ('office_location_en', models.CharField(max_length=255, null=True, verbose_name='Qabul joyi')),
                ('reception_days', models.CharField(max_length=255, verbose_name='Qabul kunlari')),
                ('reception_days_uz', models.CharField(max_length=255, null=True, verbose_name='Qabul kunlari')),
                ('reception_days_ru', models.CharField(max_length=255, null=True, verbose_name='Qabul kunlari')),
                ('reception_days_en', models.CharField(max_length=255, null=True, verbose_name='Qabul kunlari')),
                ('reception_time', models.CharField(max_length=100, verbose_name='Qabul vaqti')),
                ('reception_time_uz', models.CharField(max_length=100, null=True, verbose_name='Qabul vaqti')),
                ('reception_time_ru', models.CharField(max_length=100, null=True, verbose_name='Qabul vaqti')),
                ('reception_time_en', models.CharField(max_length=100, null=True, verbose_name='Qabul vaqti')),
                ('biography', models.TextField(verbose_name='Tarjimai hol')),
                ('biography_uz', models.TextField(null=True, verbose_name='Tarjimai hol')),
                ('biography_ru', models.TextField(null=True, verbose_name='Tarjimai hol')),
                ('biography_en', models.TextField(null=True, verbose_name='Tarjimai hol')),
                ('is_active', models.BooleanField(default=True, verbose_name='Faol')),
                ('created_at', models.DateTimeField(auto_now_add=True, verbose_name='Yaratilgan sana')),
            ],
            options={
                'verbose_name': 'Rektor',
                'verbose_name_plural': 'Rektor va prorektorlar',
            },
        ),
        migrations.CreateModel(
            name='ResearchCenter',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=255)),
                ('name_uz', models.CharField(max_length=255, null=True)),
                ('name_ru', models.CharField(max_length=255, null=True)),
                ('name_en', models.CharField(max_length=255, null=True)),
                ('description', models.TextField(blank=True)),
                ('description_uz', models.TextField(blank=True, null=True)),
                ('description_ru', models.TextField(blank=True, null=True)),
                ('description_en', models.TextField(blank=True, null=True)),
                ('order', models.PositiveIntegerField(default=0)),
            ],
            options={
                'verbose_name': 'Ilmiy markaz',
                'verbose_name_plural': 'Ilmiy markazlar',
                'ordering': ['order'],
            },
        ),
        migrations.CreateModel(
            name='ScientificStat',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('title', models.CharField(max_length=150, verbose_name='Ilmiy statistika')),
                ('title_uz', models.CharField(max_length=150, null=True, verbose_name='Ilmiy statistika')),
                ('title_ru', models.CharField(max_length=150, null=True, verbose_name='Ilmiy statistika')),
                ('title_en', models.CharField(max_length=150, null=True, verbose_name='Ilmiy statistika')),
                ('value', models.CharField(max_length=50, verbose_name='Qiymat')),
                ('order', models.PositiveIntegerField(default=0, verbose_name='Tartib')),
            ],
            options={
                'verbose_name': 'Ilmiy statistika',
                'verbose_name_plural': 'Ilmiy statistikalar',
                'ordering': ['order'],
            },
        ),
        migrations.CreateModel(
            name='UniversityAchievement',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('title', models.CharField(max_length=255)),
                ('title_uz', models.CharField(max_length=255, null=True)),
                ('title_ru', models.CharField(max_length=255, null=True)),
                ('title_en', models.CharField(max_length=255, null=True)),
                ('description', models.CharField(blank=True, max_length=255)),
                ('description_uz', models.CharField(blank=True, max_length=255, null=True)),
                ('description_ru', models.CharField(blank=True, max_length=255, null=True)),
                ('description_en', models.CharField(blank=True, max_length=255, null=True)),
                ('year', models.PositiveIntegerField(blank=True, null=True)),
                ('icon', models.CharField(blank=True, max_length=50)),
                ('order', models.PositiveIntegerField(default=0)),
            ],
            options={
                'verbose_name': 'Yutuq',
                'verbose_name_plural': 'Yutuqlar',
                'ordering': ['order'],
            },
        ),
        migrations.CreateModel(
            name='UniversityHistory',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('year', models.PositiveIntegerField()),
                ('title', models.CharField(max_length=255)),
                ('title_uz', models.CharField(max_length=255, null=True)),
                ('title_ru', models.CharField(max_length=255, null=True)),
                ('title_en', models.CharField(max_length=255, null=True)),
                ('description', models.TextField()),
                ('description_uz', models.TextField(null=True)),
                ('description_ru', models.TextField(null=True)),
                ('description_en', models.TextField(null=True)),
                ('order', models.PositiveIntegerField(default=0)),
            ],
            options={
                'verbose_name': 'Universitet tarixi',
                'verbose_name_plural': 'Universitet tarixi',
                'ordering': ['year'],
            },
        ),
        migrations.CreateModel(
            name='UniversityStructure',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('title', models.CharField(max_length=255)),
                ('title_uz', models.CharField(max_length=255, null=True)),
                ('title_ru', models.CharField(max_length=255, null=True)),
                ('title_en', models.CharField(max_length=255, null=True)),
                ('description', models.CharField(blank=True, max_length=255)),
                ('description_uz', models.CharField(blank=True, max_length=255, null=True)),
                ('description_ru', models.CharField(blank=True, max_length=255, null=True)),
                ('description_en', models.CharField(blank=True, max_length=255, null=True)),
                ('count', models.CharField(blank=True, max_length=50)),
                ('icon', models.CharField(blank=True, max_length=50)),
                ('order', models.PositiveIntegerField(default=0)),
            ],
            options={
                'verbose_name': 'Tuzilma',
                'verbose_name_plural': 'Universitet tuzilmasi',
                'ordering': ['order'],
            },
        ),
        migrations.CreateModel(
            name='UniversityValue',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('type', models.CharField(choices=[('mission', 'Missiya'), ('vision', 'Viziya'), ('values', 'Qadriyatlar')], max_length=20)),
                ('title', models.CharField(max_length=255)),
                ('title_uz', models.CharField(max_length=255, null=True)),
                ('title_ru', models.CharField(max_length=255, null=True)),
                ('title_en', models.CharField(max_length=255, null=True)),
                ('description', models.TextField()),
                ('description_uz', models.TextField(null=True)),
                ('description_ru', models.TextField(null=True)),
                ('description_en', models.TextField(null=True)),
                ('order', models.PositiveIntegerField(default=0)),
            ],
            options={
                'verbose_name': 'Missiya/Viziya/Qadriyat',
                'verbose_name_plural': 'Missiya, Viziya va Qadriyatlar',
                'ordering': ['type', 'order'],
            },
        ),
        migrations.CreateModel(
            name='AboutFeature',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('title', models.CharField(max_length=255)),
                ('title_uz', models.CharField(max_length=255, null=True)),
                ('title_ru', models.CharField(max_length=255, null=True)),
                ('title_en', models.CharField(max_length=255, null=True)),
                ('description', models.CharField(max_length=255)),
                ('description_uz', models.CharField(max_length=255, null=True)),
                ('description_ru', models.CharField(max_length=255, null=True)),
                ('description_en', models.CharField(max_length=255, null=True)),
                ('icon', models.CharField(blank=True, max_length=50)),
                ('order', models.PositiveIntegerField(default=0)),
                ('about', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='features', to='app.aboutuniversity')),
            ],
            options={
                'ordering': ['order'],
            },
        ),
        migrations.CreateModel(
            name='BachelorProgram',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=255)),
                ('name_uz', models.CharField(max_length=255, null=True)),
                ('name_ru', models.CharField(max_length=255, null=True)),
                ('name_en', models.CharField(max_length=255, null=True)),
                ('code', models.CharField(blank=True, help_text='Yo‘nalish kodi (ixtiyoriy)', max_length=50)),
                ('duration', models.PositiveIntegerField(default=4, help_text='Yil')),
                ('order', models.PositiveIntegerField(default=0)),
                ('category', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='programs', to='app.bachelorcategory')),
            ],
            options={
                'verbose_name': 'Bakalavr yo‘nalishi',
                'verbose_name_plural': 'Bakalavr yo‘nalishlari',
                'ordering': ['order'],
            },
        ),
        migrations.CreateModel(
            name='Elon',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('title', models.CharField(max_length=255)),
                ('title_uz', models.CharField(max_length=255, null=True)),
                ('title_ru', models.CharField(max_length=255, null=True)),
                ('title_en', models.CharField(max_length=255, null=True)),
                ('slug', models.SlugField(blank=True, unique=True)),
                ('published_date', models.DateField(auto_now_add=True)),
                ('main_image', models.ImageField(blank=True, null=True, upload_to='elons/main/')),
                ('short_description', models.TextField()),
                ('short_description_uz', models.TextField(null=True)),
                ('short_description_ru', models.TextField(null=True)),
                ('short_description_en', models.TextField(null=True)),
                ('content', models.TextField()),
                ('content_uz', models.TextField(null=True)),
                ('content_ru', models.TextField(null=True)),
                ('content_en', models.TextField(null=True)),
                ('quote', models.TextField(blank=True)),
                ('quote_uz', models.TextField(blank=True, null=True)),
                ('quote_ru', models.TextField(blank=True, null=True)),
                ('quote_en', models.TextField(blank=True, null=True)),
                ('quote_author', models.CharField(blank=True, max_length=255)),
                ('quote_author_uz', models.CharField(blank=True, max_length=255, null=True)),
                ('quote_author_ru', models.CharField(blank=True, max_length=255, null=True)),
                ('quote_author_en', models.CharField(blank=True, max_length=255, null=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('author', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='elons', to='app.author')),
            ],
        ),
        migrations.CreateModel(
            name='ElonAccreditationStep',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('title', models.CharField(max_length=255)),
                ('title_uz', models.CharField(max_length=255, null=True)),
                ('title_ru', models.CharField(max_length=255, null=True)),
                ('title_en', models.CharField(max_length=255, null=True)),
                ('elon', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='accreditation_steps', to='app.elon')),
            ],
        ),
        migrations.CreateModel(
            name='ElonImage',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('image', models.ImageField(upload_to='elons/gallery/')),
                ('caption', models.CharField(blank=True, max_length=255)),
                ('elon', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='gallery', to='app.elon')),
            ],
        ),
        migrations.CreateModel(
            name='ElonImportantFact',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('text', models.CharField(max_length=255)),
                ('text_uz', models.CharField(max_length=255, null=True)),
                ('text_ru', models.CharField(max_length=255, null=True)),
                ('text_en', models.CharField(max_length=255, null=True)),
                ('elon', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='important_facts', to='app.elon')),
            ],
        ),
        migrations.CreateModel(
            name='MasterProgram',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=255)),
                ('name_uz', models.CharField(max_length=255, null=True)),
                ('name_ru', models.CharField(max_length=255, null=True)),
                ('name_en', models.CharField(max_length=255, null=True)),
                ('duration', models.PositiveIntegerField(default=2)),
                ('order', models.PositiveIntegerField(default=0)),
                ('category', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='programs', to='app.mastercategory')),
            ],
            options={
                'verbose_name': 'Magistratura yo‘nalishi',
                'verbose_name_plural': 'Magistratura yo‘nalishlari',
                'ordering': ['order'],
            },
        ),
        migrations.CreateModel(
            name='News',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('title', models.CharField(max_length=255)),
                ('title_uz', models.CharField(max_length=255, null=True)),
                ('title_ru', models.CharField(max_length=255, null=True)),
                ('title_en', models.CharField(max_length=255, null=True)),
                ('slug', models.SlugField(blank=True, unique=True)),
                ('published_date', models.DateField()),
                ('main_image', models.ImageField(upload_to='news/main/')),
                ('short_description', models.TextField()),
                ('short_description_uz', models.TextField(null=True)),
                ('short_description_ru', models.TextField(null=True)),
                ('short_description_en', models.TextField(null=True)),
                ('content', models.TextField()),
                ('content_uz', models.TextField(null=True)),
                ('content_ru', models.TextField(null=True)),
                ('content_en', models.TextField(null=True)),
                ('quote', models.TextField(blank=True)),
                ('quote_uz', models.TextField(blank=True, null=True)),
                ('quote_ru', models.TextField(blank=True, null=True)),
                ('quote_en', models.TextField(blank=True, null=True)),
                ('quote_author', models.CharField(blank=True, max_length=255)),
                ('quote_author_uz', models.CharField(blank=True, max_length=255, null=True)),
                ('quote_author_ru', models.CharField(blank=True, max_length=255, null=True)),
                ('quote_author_en', models.CharField(blank=True, max_length=255, null=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('author', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='news', to='app.author')),
            ],
        ),
        migrations.CreateModel(
            name='NewsAccreditationStep',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('title', models.CharField(max_length=255)),
                ('title_uz', models.CharField(max_length=255, null=True)),
                ('title_ru', models.CharField(max_length=255, null=True)),
                ('title_en', models.CharField(max_length=255, null=True)),
                ('news', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='accreditation_steps', to='app.news')),
            ],
        ),
        migrations.CreateModel(
            name='NewsImage',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('image', models.ImageField(upload_to='news/gallery/')),
                ('caption', models.CharField(blank=True, max_length=255)),
                ('news', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='gallery', to='app.news')),
            ],
        ),
        migrations.CreateModel(
            name='NewsImportantFact',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('text', models.CharField(max_length=255)),
                ('text_uz', models.CharField(max_length=255, null=True)),
                ('text_ru', models.CharField(max_length=255, null=True)),
                ('text_en', models.CharField(max_length=255, null=True)),
                ('news', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='important_facts', to='app.news')),
            ],
        ),
        migrations.CreateModel(
            name='PartnerUniversity',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=255, verbose_name='Universitet')),
                ('name_uz', models.CharField(max_length=255, null=True, verbose_name='Universitet')),
                ('name_ru', models.CharField(max_length=255, null=True, verbose_name='Universitet')),
                ('name_en', models.CharField(max_length=255, null=True, verbose_name='Universitet')),
                ('country', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='universities', to='app.partnercountry')),
            ],
        ),
        migrations.CreateModel(
            name='Project',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('title', models.CharField(max_length=255, verbose_name='Loyiha')),
                ('title_uz', models.CharField(max_length=255, null=True, verbose_name='Loyiha')),
                ('title_ru', models.CharField(max_length=255, null=True, verbose_name='Loyiha')),
                ('title_en', models.CharField(max_length=255, null=True, verbose_name='Loyiha')),
                ('description', models.TextField(verbose_name='Tavsif')),
                ('description_uz', models.TextField(null=True, verbose_name='Tavsif')),
                ('description_ru', models.TextField(null=True, verbose_name='Tavsif')),
                ('description_en', models.TextField(null=True, verbose_name='Tavsif')),
                ('start_year', models.PositiveIntegerField(verbose_name='Boshlanish yili')),
                ('end_year', models.PositiveIntegerField(verbose_name='Tugash yili')),
                ('budget', models.DecimalField(blank=True, decimal_places=2, max_digits=12, null=True)),
                ('participants', models.PositiveIntegerField(default=0, verbose_name='Ishtirokchilar')),
                ('location', models.CharField(blank=True, max_length=255, verbose_name='Manzil')),
                ('location_uz', models.CharField(blank=True, max_length=255, null=True, verbose_name='Manzil')),
                ('location_ru', models.CharField(blank=True, max_length=255, null=True, verbose_name='Manzil')),
                ('location_en', models.CharField(blank=True, max_length=255, null=True, verbose_name='Manzil')),
                ('progress', models.PositiveIntegerField(default=0, help_text='Foizda (0-100)', verbose_name='Jarayon')),
                ('is_active', models.BooleanField(default=True)),
                ('order', models.PositiveIntegerField(default=0)),
                ('category', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='projects', to='app.projectcategory')),
            ],
            options={
                'verbose_name': 'Loyiha',
                'verbose_name_plural': 'Loyihalar',
                'ordering': ['order'],
            },
        ),
        migrations.CreateModel(
            name='RectorEducation',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('start_year', models.PositiveIntegerField(verbose_name='Boshlanish yili')),
                ('end_year', models.PositiveIntegerField(verbose_name='Tugash yili')),
                ('degree', models.CharField(max_length=255, verbose_name='Darajasi')),
                ('degree_uz', models.CharField(max_length=255, null=True, verbose_name='Darajasi')),
                ('degree_ru', models.CharField(max_length=255, null=True, verbose_name='Darajasi')),
                ('degree_en', models.CharField(max_length=255, null=True, verbose_name='Darajasi')),
                ('institution', models.CharField(max_length=255, verbose_name='OTM')),
                ('institution_uz', models.CharField(max_length=255, null=True, verbose_name='OTM')),
                ('institution_ru', models.CharField(max_length=255, null=True, verbose_name='OTM')),
                ('institution_en', models.CharField(max_length=255, null=True, verbose_name='OTM')),
                ('specialization', models.CharField(max_length=255, verbose_name='Specializatsiya')),
                ('specialization_uz', models.CharField(max_length=255, null=True, verbose_name='Specializatsiya')),
                ('specialization_ru', models.CharField(max_length=255, null=True, verbose_name='Specializatsiya')),
                ('specialization_en', models.CharField(max_length=255, null=True, verbose_name='Specializatsiya')),
                ('rector', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='educations', to='app.rector', verbose_name='Rektor')),
            ],
            options={
                'verbose_name': 'Rektor Talim olgan OTM',
                'verbose_name_plural': 'Rektor Talim olgan OTMLar',
            },
        ),
        migrations.CreateModel(
            name='RectorExperience',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('start_year', models.CharField(max_length=20, verbose_name='Boshlanish yili')),
                ('position', models.CharField(max_length=255, verbose_name='Lavozimi')),
                ('position_uz', models.CharField(max_length=255, null=True, verbose_name='Lavozimi')),
                ('position_ru', models.CharField(max_length=255, null=True, verbose_name='Lavozimi')),
                ('position_en', models.CharField(max_length=255, null=True, verbose_name='Lavozimi')),
                ('organization', models.CharField(max_length=255, verbose_name='Ish joyi')),
                ('organization_uz', models.CharField(max_length=255, null=True, verbose_name='Ish joyi')),
                ('organization_ru', models.CharField(max_length=255, null=True, verbose_name='Ish joyi')),
                ('organization_en', models.CharField(max_length=255, null=True, verbose_name='Ish joyi')),
                ('responsibilities', models.TextField(verbose_name='Ish imkoniyatlari')),
                ('responsibilities_uz', models.TextField(null=True, verbose_name='Ish imkoniyatlari')),
                ('responsibilities_ru', models.TextField(null=True, verbose_name='Ish imkoniyatlari')),
                ('responsibilities_en', models.TextField(null=True, verbose_name='Ish imkoniyatlari')),
                ('rector', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='experiences', to='app.rector', verbose_name='Rektor')),
            ],
            options={
                'verbose_name': 'Rektor Mexnat-faoliyati',
                'verbose_name_plural': 'Rektor Mexnat-faoliyatlar',
            },
        ),
        migrations.CreateModel(
            name='RectorScientificStat',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('articles', models.PositiveIntegerField(verbose_name='Nashrlar soni')),
                ('books', models.PositiveIntegerField(verbose_name='Kitoblar soni')),
                ('phd_supervisions', models.PositiveIntegerField(verbose_name='PhD taqdim etilgan soni')),
                ('awards', models.PositiveIntegerField(verbose_name='Yoshlar olimi')),
                ('rector', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, related_name='scientific_stat', to='app.rector', verbose_name='Rektor')),
            ],
            options={
                'verbose_name': 'Rektor Ilmiy statistika',
                'verbose_name_plural': 'Rektor Ilmiy statistikalar',
            },
        ),
        migrations.CreateModel(
            name='RectorSocialLink',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('platform', models.CharField(max_length=50, verbose_name='Platforma')),
                ('url', models.URLField(verbose_name='Link')),
                ('rector', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='social_links', to='app.rector', verbose_name='Rektor')),
            ],
            options={
                'verbose_name': 'Rektor Ijtimoiy tarmoq linki',
                'verbose_name_plural': 'Rektor Ijtimoiy tarmoq linklari',
            },
        ),
    ]
