# Generated by Django 6.0.4 on 2026-04-15 16:51

from django.db import migrations, models


class Migration(migrations.Migration):

    dependencies = [
        ('app', '0001_initial'),
        ('auth', '0012_alter_user_first_name_max_length'),
    ]

    operations = [
        migrations.AddIndex(
            model_name='activitylog',
            index=models.Index(fields=['group', '-performed_at'], name='activity_group_date_idx'),
        ),
        migrations.AddIndex(
            model_name='activitylog',
            index=models.Index(fields=['action'], name='activity_action_idx'),
        ),
        migrations.AddIndex(
            model_name='activitylog',
            index=models.Index(fields=['performed_by'], name='activity_performed_by_idx'),
        ),
        migrations.AddIndex(
            model_name='activitylog',
            index=models.Index(fields=['performed_at'], name='activity_performed_at_idx'),
        ),
        migrations.AddIndex(
            model_name='activitylog',
            index=models.Index(fields=['group', 'action'], name='activity_group_action_idx'),
        ),
        migrations.AddIndex(
            model_name='activitylog',
            index=models.Index(fields=['affected_object_type', 'affected_object_id'], name='activity_object_idx'),
        ),
        migrations.AddIndex(
            model_name='contribution',
            index=models.Index(fields=['group', '-payment_date'], name='contrib_group_date_idx'),
        ),
        migrations.AddIndex(
            model_name='contribution',
            index=models.Index(fields=['member', '-payment_date'], name='contrib_member_date_idx'),
        ),
        migrations.AddIndex(
            model_name='contribution',
            index=models.Index(fields=['reference_number'], name='contrib_ref_idx'),
        ),
        migrations.AddIndex(
            model_name='contribution',
            index=models.Index(fields=['payment_date'], name='contrib_payment_date_idx'),
        ),
        migrations.AddIndex(
            model_name='contribution',
            index=models.Index(fields=['group', 'member'], name='contrib_group_member_idx'),
        ),
        migrations.AddIndex(
            model_name='contribution',
            index=models.Index(fields=['recorded_by'], name='contrib_recorded_by_idx'),
        ),
        migrations.AddIndex(
            model_name='disbursement',
            index=models.Index(fields=['group', '-disbursement_date'], name='disburse_group_date_idx'),
        ),
        migrations.AddIndex(
            model_name='disbursement',
            index=models.Index(fields=['recipient_phone'], name='disburse_recipient_phone_idx'),
        ),
        migrations.AddIndex(
            model_name='disbursement',
            index=models.Index(fields=['disbursement_date'], name='disburse_date_idx'),
        ),
        migrations.AddIndex(
            model_name='disbursement',
            index=models.Index(fields=['reason'], name='disburse_reason_idx'),
        ),
        migrations.AddIndex(
            model_name='disbursement',
            index=models.Index(fields=['group', 'recipient_phone'], name='disburse_group_recipient_idx'),
        ),
        migrations.AddIndex(
            model_name='disbursement',
            index=models.Index(fields=['initiated_by'], name='disburse_initiated_by_idx'),
        ),
        migrations.AddIndex(
            model_name='group',
            index=models.Index(fields=['name'], name='group_name_idx'),
        ),
        migrations.AddIndex(
            model_name='group',
            index=models.Index(fields=['chairperson'], name='group_chairperson_idx'),
        ),
        migrations.AddIndex(
            model_name='group',
            index=models.Index(fields=['-created_at'], name='group_created_at_idx'),
        ),
        migrations.AddIndex(
            model_name='group',
            index=models.Index(fields=['m_koba_number'], name='group_mkoba_idx'),
        ),
        migrations.AddIndex(
            model_name='group',
            index=models.Index(fields=['is_active'], name='group_active_idx'),
        ),
        migrations.AddIndex(
            model_name='groupleader',
            index=models.Index(fields=['group', 'is_active'], name='groupleader_group_active_idx'),
        ),
        migrations.AddIndex(
            model_name='groupleader',
            index=models.Index(fields=['leader', 'is_active'], name='groupleader_leader_active_idx'),
        ),
        migrations.AddIndex(
            model_name='groupleader',
            index=models.Index(fields=['position'], name='groupleader_position_idx'),
        ),
        migrations.AddIndex(
            model_name='groupleader',
            index=models.Index(fields=['appointed_at'], name='groupleader_appointed_idx'),
        ),
        migrations.AddIndex(
            model_name='leader',
            index=models.Index(fields=['phone_number'], name='leader_phone_idx'),
        ),
        migrations.AddIndex(
            model_name='leader',
            index=models.Index(fields=['-created_at'], name='leader_created_at_idx'),
        ),
        migrations.AddIndex(
            model_name='leader',
            index=models.Index(fields=['full_name'], name='leader_name_idx'),
        ),
        migrations.AddIndex(
            model_name='leader',
            index=models.Index(fields=['is_active'], name='leader_active_idx'),
        ),
        migrations.AddIndex(
            model_name='member',
            index=models.Index(fields=['group', 'is_active'], name='member_group_active_idx'),
        ),
        migrations.AddIndex(
            model_name='member',
            index=models.Index(fields=['phone_number'], name='member_phone_idx'),
        ),
        migrations.AddIndex(
            model_name='member',
            index=models.Index(fields=['full_name'], name='member_name_idx'),
        ),
        migrations.AddIndex(
            model_name='member',
            index=models.Index(fields=['group', 'full_name'], name='member_group_name_idx'),
        ),
        migrations.AddIndex(
            model_name='member',
            index=models.Index(fields=['secret_pin'], name='member_pin_idx'),
        ),
        migrations.AddIndex(
            model_name='member',
            index=models.Index(fields=['joined_at'], name='member_joined_at_idx'),
        ),
        migrations.AddIndex(
            model_name='membersummary',
            index=models.Index(fields=['group', '-total_contributed'], name='summary_group_contributed_idx'),
        ),
        migrations.AddIndex(
            model_name='membersummary',
            index=models.Index(fields=['member'], name='summary_member_idx'),
        ),
        migrations.AddIndex(
            model_name='membersummary',
            index=models.Index(fields=['group', 'member'], name='summary_group_member_idx'),
        ),
        migrations.AddIndex(
            model_name='membersummary',
            index=models.Index(fields=['last_contribution_date'], name='summary_last_contrib_date_idx'),
        ),
    ]