# Generated by Django 5.1.2 on 2025-10-02 21:19

import django_ckeditor_5.fields
from django.db import migrations, models


class Migration(migrations.Migration):

    dependencies = [
        ('base', '0003_page_sectiontemplate_and_more'),
    ]

    operations = [
        migrations.CreateModel(
            name='Guideline',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('title', models.CharField(max_length=255)),
                ('slug', models.SlugField(max_length=255, unique=True)),
                ('country', models.CharField(choices=[('uk', 'United Kingdom'), ('usa', 'United States'), ('canada', 'Canada'), ('australia', 'Australia'), ('germany', 'Germany'), ('france', 'France'), ('netherlands', 'Netherlands'), ('ireland', 'Ireland'), ('new_zealand', 'New Zealand'), ('singapore', 'Singapore'), ('custom', 'Custom Country')], max_length=50)),
                ('study_level', models.CharField(choices=[('undergraduate', 'Undergraduate'), ('postgraduate', 'Postgraduate'), ('phd', 'PhD/Doctorate'), ('diploma', 'Diploma/Certificate'), ('foundation', 'Foundation Program'), ('language', 'Language Course'), ('all', 'All Levels')], max_length=50)),
                ('short_description', models.TextField(help_text='Brief overview (max 500 characters)', max_length=500)),
                ('overview', django_ckeditor_5.fields.CKEditor5Field(help_text='Comprehensive overview of studying in this country')),
                ('eligibility_criteria', django_ckeditor_5.fields.CKEditor5Field(help_text='Academic and other eligibility requirements')),
                ('language_requirements', django_ckeditor_5.fields.CKEditor5Field(help_text='English language proficiency requirements')),
                ('financial_requirements', django_ckeditor_5.fields.CKEditor5Field(help_text='Financial proof and requirements')),
                ('application_process', django_ckeditor_5.fields.CKEditor5Field(help_text='Step-by-step application guide')),
                ('deadline_information', django_ckeditor_5.fields.CKEditor5Field(help_text='Application deadlines and timelines')),
                ('visa_process', django_ckeditor_5.fields.CKEditor5Field(help_text='Student visa application process')),
                ('tuition_fees', django_ckeditor_5.fields.CKEditor5Field(help_text='Typical tuition fees and costs')),
                ('living_costs', django_ckeditor_5.fields.CKEditor5Field(help_text='Cost of living information')),
                ('scholarship_info', django_ckeditor_5.fields.CKEditor5Field(help_text='Available scholarships and funding')),
                ('working_while_studying', django_ckeditor_5.fields.CKEditor5Field(blank=True, help_text='Work rights and opportunities', null=True)),
                ('post_study_options', django_ckeditor_5.fields.CKEditor5Field(blank=True, help_text='Post-study work and settlement options', null=True)),
                ('useful_resources', django_ckeditor_5.fields.CKEditor5Field(blank=True, help_text='Helpful links and resources', null=True)),
                ('featured_image', models.ImageField(blank=True, help_text='Main image for this guideline', null=True, upload_to='guidelines/featured-images/')),
                ('country_flag', models.ImageField(blank=True, help_text='Flag of the country', null=True, upload_to='guidelines/country-flags/')),
                ('status', models.CharField(choices=[('draft', 'Draft'), ('published', 'Published'), ('archived', 'Archived')], default='draft', max_length=20)),
                ('is_featured', models.BooleanField(default=False)),
                ('order', models.PositiveIntegerField(default=0)),
                ('views_count', models.PositiveIntegerField(default=0)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('published_date', models.DateTimeField(blank=True, null=True)),
                ('meta_title', models.CharField(blank=True, max_length=255, null=True)),
                ('meta_description', models.TextField(blank=True, null=True)),
            ],
            options={
                'ordering': ['order', '-published_date', 'title'],
                'indexes': [models.Index(fields=['status', 'published_date'], name='base_guidel_status_b1e636_idx'), models.Index(fields=['country', 'study_level'], name='base_guidel_country_2da275_idx'), models.Index(fields=['is_featured', 'status'], name='base_guidel_is_feat_745298_idx')],
            },
        ),
    ]