# Generated by Django 6.1.1 on 2026-10-06 09:09

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


class Migration(migrations.Migration):

    dependencies = [
        ('clubs', '0003_club_squad_membership'),
        ('matches', '0001_initial'),
        ('players', '0002_player_integrity_constraints'),
    ]

    operations = [
        migrations.CreateModel(
            name='MatchLineup',
            fields=[
                ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
                ('formation', models.CharField(choices=[('4-3-3', '4-3-3'), ('4-4-2', '4-4-2')], max_length=10)),
                ('status', models.CharField(choices=[('DRAFT', 'Draft'), ('SUBMITTED', 'Submitted'), ('LOCKED', 'Locked')], default='DRAFT', max_length=12)),
                ('submitted_at', models.DateTimeField(blank=True, null=True)),
                ('locked_at', models.DateTimeField(blank=True, null=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('club', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='match_lineups', to='clubs.club')),
                ('match', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='lineups', to='matches.match')),
            ],
            options={
                'ordering': ['match_id', 'club_id'],
            },
        ),
        migrations.CreateModel(
            name='MatchLineupEntry',
            fields=[
                ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
                ('role', models.CharField(choices=[('STARTER', 'Starter'), ('SUBSTITUTE', 'Substitute')], max_length=12)),
                ('slot', models.CharField(blank=True, default='', max_length=8)),
                ('is_captain', models.BooleanField(default=False)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('lineup', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='entries', to='matches.matchlineup')),
                ('player', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='match_lineup_entries', to='players.player')),
            ],
            options={
                'ordering': ['lineup_id', 'role', 'slot', 'created_at'],
            },
        ),
        migrations.AddIndex(
            model_name='matchlineup',
            index=models.Index(fields=['match', 'status'], name='lineup_match_status_idx'),
        ),
        migrations.AddIndex(
            model_name='matchlineup',
            index=models.Index(fields=['club', 'match'], name='lineup_club_match_idx'),
        ),
        migrations.AddConstraint(
            model_name='matchlineup',
            constraint=models.UniqueConstraint(fields=('match', 'club'), name='uq_match_lineup_club'),
        ),
        migrations.AddConstraint(
            model_name='matchlineup',
            constraint=models.CheckConstraint(condition=models.Q(('formation__in', ['4-3-3', '4-4-2'])), name='lineup_valid_formation'),
        ),
        migrations.AddConstraint(
            model_name='matchlineup',
            constraint=models.CheckConstraint(condition=models.Q(('status__in', ['DRAFT', 'SUBMITTED', 'LOCKED'])), name='lineup_valid_status'),
        ),
        migrations.AddConstraint(
            model_name='matchlineup',
            constraint=models.CheckConstraint(condition=models.Q(models.Q(('locked_at__isnull', True), ('status', 'DRAFT'), ('submitted_at__isnull', True)), models.Q(('locked_at__isnull', True), ('status', 'SUBMITTED'), ('submitted_at__isnull', False)), models.Q(('locked_at__isnull', False), ('status', 'LOCKED'), ('submitted_at__isnull', False)), _connector='OR'), name='lineup_lifecycle'),
        ),
        migrations.AddConstraint(
            model_name='matchlineup',
            constraint=models.CheckConstraint(condition=models.Q(('submitted_at__isnull', True), ('locked_at__isnull', True), ('locked_at__gte', models.F('submitted_at')), _connector='OR'), name='lineup_locked_after_submit'),
        ),
        migrations.AddIndex(
            model_name='matchlineupentry',
            index=models.Index(fields=['lineup', 'role'], name='lineup_entry_role_idx'),
        ),
        migrations.AddIndex(
            model_name='matchlineupentry',
            index=models.Index(fields=['player'], name='lineup_entry_player_idx'),
        ),
        migrations.AddConstraint(
            model_name='matchlineupentry',
            constraint=models.UniqueConstraint(fields=('lineup', 'player'), name='uq_lineup_player'),
        ),
        migrations.AddConstraint(
            model_name='matchlineupentry',
            constraint=models.UniqueConstraint(condition=models.Q(('role', 'STARTER')), fields=('lineup', 'slot'), name='uq_lineup_starting_slot'),
        ),
        migrations.AddConstraint(
            model_name='matchlineupentry',
            constraint=models.UniqueConstraint(condition=models.Q(('is_captain', True)), fields=('lineup',), name='uq_lineup_captain'),
        ),
        migrations.AddConstraint(
            model_name='matchlineupentry',
            constraint=models.CheckConstraint(condition=models.Q(('role__in', ['STARTER', 'SUBSTITUTE'])), name='lineup_entry_valid_role'),
        ),
        migrations.AddConstraint(
            model_name='matchlineupentry',
            constraint=models.CheckConstraint(condition=models.Q(models.Q(('role', 'STARTER'), ('slot__in', ('CM', 'GK', 'LB', 'LCB', 'LCM', 'LM', 'LST', 'LW', 'RB', 'RCB', 'RCM', 'RM', 'RST', 'RW', 'ST'))), models.Q(('is_captain', False), ('role', 'SUBSTITUTE'), ('slot', '')), _connector='OR'), name='lineup_entry_role_slot'),
        ),
    ]
