# Generated by Django 6.1.1 on 2026-10-07 23:02

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


class Migration(migrations.Migration):

    dependencies = [
        ('academy', '0002_academyprospectclaim_clubyouthteam_and_more'),
        ('clubs', '0003_club_squad_membership'),
        ('federations', '0004_federationcompetitiondraw_and_more'),
        ('leagues', '0005_leaguemembership_youth_team_and_more'),
        ('matches', '0005_fixture_away_youth_team_fixture_competition_type_and_more'),
    ]

    operations = [
        migrations.RemoveConstraint(
            model_name='fixture',
            name='uq_fixture_ordered_pair',
        ),
        migrations.RemoveConstraint(
            model_name='fixture',
            name='uq_fixture_round_home',
        ),
        migrations.RemoveConstraint(
            model_name='fixture',
            name='uq_fixture_round_away',
        ),
        migrations.AddField(
            model_name='fixture',
            name='federation_competition',
            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.PROTECT, related_name='fixtures', to='federations.federationcompetition'),
        ),
        migrations.AlterField(
            model_name='fixture',
            name='competition',
            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.PROTECT, related_name='fixtures', to='leagues.leaguecompetition'),
        ),
        migrations.AddIndex(
            model_name='fixture',
            index=models.Index(fields=['federation_competition', 'round_number'], name='fixture_fed_comp_round_idx'),
        ),
        migrations.AddConstraint(
            model_name='fixture',
            constraint=models.CheckConstraint(condition=models.Q(models.Q(('competition__isnull', False), ('federation_competition__isnull', True)), models.Q(('competition__isnull', True), ('federation_competition__isnull', False)), _connector='OR'), name='fixture_exactly_one_comp'),
        ),
        migrations.AddConstraint(
            model_name='fixture',
            constraint=models.UniqueConstraint(condition=models.Q(('competition__isnull', False)), fields=('competition', 'home_club', 'away_club'), name='uq_fixture_league_pair'),
        ),
        migrations.AddConstraint(
            model_name='fixture',
            constraint=models.UniqueConstraint(condition=models.Q(('competition__isnull', False)), fields=('competition', 'round_number', 'home_club'), name='uq_fixture_league_r_home'),
        ),
        migrations.AddConstraint(
            model_name='fixture',
            constraint=models.UniqueConstraint(condition=models.Q(('competition__isnull', False)), fields=('competition', 'round_number', 'away_club'), name='uq_fixture_league_r_away'),
        ),
        migrations.AddConstraint(
            model_name='fixture',
            constraint=models.UniqueConstraint(condition=models.Q(('federation_competition__isnull', False)), fields=('federation_competition', 'round_number', 'home_club', 'away_club'), name='uq_fixture_fed_pair_round'),
        ),
        migrations.AddConstraint(
            model_name='fixture',
            constraint=models.UniqueConstraint(condition=models.Q(('federation_competition__isnull', False)), fields=('federation_competition', 'round_number', 'home_club'), name='uq_fixture_fed_r_home'),
        ),
        migrations.AddConstraint(
            model_name='fixture',
            constraint=models.UniqueConstraint(condition=models.Q(('federation_competition__isnull', False)), fields=('federation_competition', 'round_number', 'away_club'), name='uq_fixture_fed_r_away'),
        ),
    ]
