# Generated by Django 6.1.1 on 2026-11-03 20:38

from django.contrib.postgres.operations import BtreeGistExtension
import django.contrib.postgres.constraints
import django.contrib.postgres.fields.ranges
from django.db import migrations, models


class Migration(migrations.Migration):

    dependencies = [
        ('club_finance', '0008_remove_journalline_cf_gl_line_nonnegative_and_more'),
        ('clubs', '0012_clubdefaultlineup_tactical_plan_and_more'),
        ('seasons', '0007_seasonautomationpolicy_continental_enabled'),
    ]

    operations = [
        BtreeGistExtension(),
        migrations.AddConstraint(
            model_name='accountingperiod',
            constraint=django.contrib.postgres.constraints.ExclusionConstraint(expressions=[(models.F('club'), '='), (models.Func(models.F('starts_at'), models.F('ends_at'), models.Value('[)'), function='TSTZRANGE', output_field=django.contrib.postgres.fields.ranges.DateTimeRangeField()), '&&')], name='cf_period_no_overlap'),
        ),
        migrations.AddConstraint(
            model_name='clubbudget',
            constraint=models.UniqueConstraint(condition=models.Q(('status', 'ACTIVE')), fields=('club', 'period'), name='cf_one_active_budget'),
        ),
    ]
