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


class Migration(migrations.Migration):

    dependencies = [
        ('distributor', '0003_alter_distributorglobalpositioncounter_id_and_more'),
        ('schemes', '0007_alter_scheme_id_alter_schemedistribution_id_and_more'),
        migrations.swappable_dependency(settings.AUTH_USER_MODEL),
    ]

    operations = [
        migrations.CreateModel(
            name='BrandAmbassadorEligibility',
            fields=[
                ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
                ('created_at', models.DateTimeField(auto_now_add=True, db_index=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('is_active', models.BooleanField(db_index=True, default=True)),
                ('distributor_count', models.PositiveIntegerField(default=0)),
                ('qualified_at', models.DateTimeField(auto_now_add=True)),
                ('last_distributor_created_at', models.DateTimeField(blank=True, null=True)),
                ('scheme', models.ForeignKey(db_index=True, on_delete=django.db.models.deletion.CASCADE, related_name='ambassador_eligibilities', to='schemes.opportunitybundle')),
                ('user', models.ForeignKey(db_index=True, on_delete=django.db.models.deletion.CASCADE, related_name='ambassador_eligibilities', to=settings.AUTH_USER_MODEL)),
            ],
        ),
        migrations.AddIndex(
            model_name='brandambassadoreligibility',
            index=models.Index(fields=['scheme', 'distributor_count'], name='distributor_scheme__00abc0_idx'),
        ),
        migrations.AddIndex(
            model_name='brandambassadoreligibility',
            index=models.Index(fields=['user', 'scheme'], name='distributor_user_id_5891d0_idx'),
        ),
        migrations.AddIndex(
            model_name='brandambassadoreligibility',
            index=models.Index(fields=['is_active'], name='distributor_is_acti_82bc2f_idx'),
        ),
        migrations.AddConstraint(
            model_name='brandambassadoreligibility',
            constraint=models.UniqueConstraint(fields=('user', 'scheme'), name='uniq_ambassador_user_scheme'),
        ),
    ]