# Generated by Django 6.1.1 on 2026-10-01 16:14

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


class Migration(migrations.Migration):

    initial = True

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

    operations = [
        migrations.CreateModel(
            name='TransferWindow',
            fields=[
                ('id', models.BigAutoField(primary_key=True, serialize=False)),
                ('name', models.CharField(max_length=100)),
                ('window_type', models.CharField(choices=[('SUMMER', 'Summer'), ('WINTER', 'Winter'), ('SPECIAL', 'Special')], max_length=10)),
                ('start_at', models.DateTimeField()),
                ('end_at', models.DateTimeField()),
                ('status', models.CharField(choices=[('SCHEDULED', 'Scheduled'), ('OPEN', 'Open'), ('CLOSED', 'Closed'), ('CANCELLED', 'Cancelled')], default='SCHEDULED', max_length=12)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('opened_at', models.DateTimeField(blank=True, null=True)),
                ('closed_at', models.DateTimeField(blank=True, null=True)),
                ('cancelled_at', models.DateTimeField(blank=True, null=True)),
                ('season', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='transfer_windows', to='seasons.season')),
            ],
            options={
                'ordering': ['start_at', 'id'],
                'indexes': [models.Index(fields=['season', 'status'], name='tw_season_status_idx'), models.Index(fields=['start_at', 'end_at'], name='tw_dates_idx'), models.Index(fields=['window_type'], name='tw_type_idx')],
                'constraints': [models.CheckConstraint(condition=models.Q(('start_at__lt', models.F('end_at'))), name='tw_start_before_end'), models.UniqueConstraint(fields=('season', 'name'), name='unique_tw_name_per_season')],
            },
        ),
    ]