from django.db import migrations, models


class Migration(migrations.Migration):
    dependencies = [
        ("federations", "0012_draw_generation_governance"),
        ("matches", "0014_live_match_streaming_client_sync"),
    ]

    operations = [
        migrations.AddField(
            model_name="fixture",
            name="draw_generation",
            field=models.PositiveIntegerField(default=1, editable=False),
        ),
        migrations.AddIndex(
            model_name="fixture",
            index=models.Index(fields=["federation_competition", "draw_generation", "round_number"], name="fixture_fed_gen_round_idx"),
        ),
        migrations.RemoveConstraint(model_name="fixture", name="uq_fixture_fed_pair_round"),
        migrations.RemoveConstraint(model_name="fixture", name="uq_fixture_fed_r_home"),
        migrations.RemoveConstraint(model_name="fixture", name="uq_fixture_fed_r_away"),
        migrations.AddConstraint(
            model_name="fixture",
            constraint=models.UniqueConstraint(
                condition=models.Q(("federation_competition__isnull", False)),
                fields=("federation_competition", "draw_generation", "round_number", "home_club", "away_club"),
                name="uq_fixture_fed_gen_pair",
            ),
        ),
        migrations.AddConstraint(
            model_name="fixture",
            constraint=models.UniqueConstraint(
                condition=models.Q(("federation_competition__isnull", False)),
                fields=("federation_competition", "draw_generation", "round_number", "home_club"),
                name="uq_fixture_fed_gen_home",
            ),
        ),
        migrations.AddConstraint(
            model_name="fixture",
            constraint=models.UniqueConstraint(
                condition=models.Q(("federation_competition__isnull", False)),
                fields=("federation_competition", "draw_generation", "round_number", "away_club"),
                name="uq_fixture_fed_gen_away",
            ),
        ),
    ]
