# Generated by Django 4.2.7 on 2026-01-10 06:30

from django.db import migrations, models
import django.db.models.deletion


class Migration(migrations.Migration):

    dependencies = [
        ('exams', '0001_initial'),
    ]

    operations = [
        migrations.CreateModel(
            name='SchoolSubjectGradeSummary',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('year', models.PositiveIntegerField(db_index=True)),
                ('subject_code', models.CharField(db_index=True, max_length=50)),
                ('sex', models.CharField(db_index=True, max_length=1)),
                ('grade', models.CharField(db_index=True, max_length=3)),
                ('total', models.PositiveIntegerField()),
                ('school', models.ForeignKey(db_column='school_code', on_delete=django.db.models.deletion.CASCADE, to='exams.school', to_field='school_code')),
            ],
            options={
                'db_table': 'school_subject_grade_summary',
                'indexes': [models.Index(fields=['year', 'school'], name='school_subj_year_d87679_idx'), models.Index(fields=['subject_code', 'year'], name='school_subj_subject_93edf5_idx'), models.Index(fields=['school', 'subject_code', 'year'], name='school_subj_school__8bdf76_idx')],
                'unique_together': {('year', 'school', 'subject_code', 'sex', 'grade')},
            },
        ),
        migrations.CreateModel(
            name='SchoolDivisionSummary',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('year', models.PositiveIntegerField(db_index=True)),
                ('sex', models.CharField(db_index=True, max_length=1)),
                ('division', models.CharField(db_index=True, max_length=5)),
                ('total', models.PositiveIntegerField()),
                ('school', models.ForeignKey(db_column='school_code', on_delete=django.db.models.deletion.CASCADE, to='exams.school', to_field='school_code')),
            ],
            options={
                'db_table': 'school_division_summary',
                'indexes': [models.Index(fields=['year', 'school'], name='school_divi_year_df8d7e_idx'), models.Index(fields=['year', 'division'], name='school_divi_year_ff2583_idx')],
                'unique_together': {('year', 'school', 'sex', 'division')},
            },
        ),
    ]