# Generated by Django 6.1.1 on 2026-10-31 19:20

import django.db.models.deletion
import uuid
from django.conf import settings
from django.db import migrations, models


class Migration(migrations.Migration):

    dependencies = [
        ('clubs', '0006_club_regional_federation'),
        ('economy', '0016_governed_friendlies'),
        ('federations', '0013_governed_friendlies'),
        ('matches', '0030_remove_matchlineupentry_lineup_entry_role_slot_and_more'),
        migrations.swappable_dependency(settings.AUTH_USER_MODEL),
    ]

    operations = [
        migrations.CreateModel(
            name='FriendlyGame',
            fields=[
                ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
                ('status', models.CharField(default='PROPOSED', max_length=16)),
                ('version', models.PositiveIntegerField(default=1)),
                ('stake', models.DecimalField(decimal_places=8, default=0, max_digits=24)),
                ('scheduled_at', models.DateTimeField()),
                ('seed', models.PositiveBigIntegerField(null=True)),
                ('engine_key', models.CharField(blank=True, max_length=64)),
                ('engine_version', models.CharField(blank=True, max_length=32)),
                ('state_payload', models.JSONField(default=dict)),
                ('state_hash', models.CharField(blank=True, max_length=64)),
                ('result_payload', models.JSONField(default=dict)),
                ('result_hash', models.CharField(blank=True, max_length=64)),
                ('home_score', models.PositiveSmallIntegerField(null=True)),
                ('away_score', models.PositiveSmallIntegerField(null=True)),
                ('started_at', models.DateTimeField(null=True)),
                ('completed_at', models.DateTimeField(null=True)),
                ('decision_note', models.TextField(blank=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('accepted_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, related_name='accepted_friendlies', to=settings.AUTH_USER_MODEL)),
                ('approved_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, related_name='approved_friendlies', to=settings.AUTH_USER_MODEL)),
                ('away_club', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='away_friendlies', to='clubs.club')),
                ('away_reservation', models.OneToOneField(null=True, on_delete=django.db.models.deletion.PROTECT, related_name='friendly_away_reserve', to='economy.ledgerentry')),
                ('decided_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, related_name='decided_friendlies', to=settings.AUTH_USER_MODEL)),
                ('federation', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='friendlies', to='federations.federation')),
                ('home_club', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='home_friendlies', to='clubs.club')),
                ('home_reservation', models.OneToOneField(null=True, on_delete=django.db.models.deletion.PROTECT, related_name='friendly_home_reserve', to='economy.ledgerentry')),
                ('offered_by_club', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='friendly_offers', to='clubs.club')),
                ('proposed_by', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='proposed_friendlies', to=settings.AUTH_USER_MODEL)),
            ],
        ),
        migrations.CreateModel(
            name='FriendlyAudit',
            fields=[
                ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
                ('action', models.CharField(max_length=32)),
                ('evidence', models.JSONField(default=dict)),
                ('evidence_hash', models.CharField(max_length=64)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('actor', models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, to=settings.AUTH_USER_MODEL)),
                ('game', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='audit', to='matches.friendlygame')),
            ],
            options={
                'ordering': ['created_at', 'id'],
            },
        ),
        migrations.AddIndex(
            model_name='friendlygame',
            index=models.Index(fields=['status', 'scheduled_at'], name='friendly_due_idx'),
        ),
        migrations.AddConstraint(
            model_name='friendlygame',
            constraint=models.CheckConstraint(condition=models.Q(('home_club', models.F('away_club')), _negated=True), name='friendly_distinct_clubs'),
        ),
        migrations.AddConstraint(
            model_name='friendlygame',
            constraint=models.CheckConstraint(condition=models.Q(('stake__gte', 0)), name='friendly_nonnegative_stake'),
        ),
        migrations.AddConstraint(
            model_name='friendlygame',
            constraint=models.CheckConstraint(condition=models.Q(('version__gte', 1)), name='friendly_version_positive'),
        ),
        migrations.AddConstraint(
            model_name='friendlygame',
            constraint=models.CheckConstraint(condition=models.Q(('status__in', ['PROPOSED', 'FUNDED', 'APPROVED', 'RUNNING', 'REVIEW', 'SETTLED', 'VOID', 'DECLINED'])), name='friendly_valid_status'),
        ),
        migrations.AddConstraint(
            model_name='friendlygame',
            constraint=models.CheckConstraint(condition=models.Q(('offered_by_club', models.F('home_club')), ('offered_by_club', models.F('away_club')), _connector='OR'), name='friendly_offering_participant'),
        ),
        migrations.AddConstraint(
            model_name='friendlygame',
            constraint=models.CheckConstraint(condition=models.Q(('status__in', ['PROPOSED', 'DECLINED', 'VOID']), ('accepted_by__isnull', False), _connector='OR'), name='friendly_acceptance_shape'),
        ),
        migrations.AddConstraint(
            model_name='friendlygame',
            constraint=models.CheckConstraint(condition=models.Q(models.Q(('status__in', ['REVIEW', 'SETTLED']), _negated=True), models.Q(('away_score__isnull', False), ('completed_at__isnull', False), ('home_score__isnull', False)), _connector='OR'), name='friendly_result_shape'),
        ),
        migrations.AddConstraint(
            model_name='friendlygame',
            constraint=models.CheckConstraint(condition=models.Q(models.Q(('stake__gt', 0), ('status__in', ['FUNDED', 'APPROVED', 'RUNNING', 'REVIEW', 'SETTLED']), _negated=True), models.Q(('away_reservation__isnull', False), ('home_reservation__isnull', False)), _connector='OR'), name='friendly_funding_shape'),
        ),
    ]
