"""
Migration to add database indexes for commonly filtered fields in reports.

This migration adds indexes to improve query performance for:
- Date range filtering (disbursement_date, due_date)
- Status filtering (status, is_deleted, is_rolled_over)
- Branch filtering (borrower__branch_id)
- Product filtering (application__loan_product_id)

Note: This migration is now a no-op since the tables use Grazuri schema names.
Indexes should be added directly to the database if needed.
"""

from django.db import migrations, models


class Migration(migrations.Migration):

    dependencies = [
        ('reports', '0001_initial'),
        ('loans', '0001_initial'),  # Adjust based on your actual migration
    ]

    operations = [
        # No-op migration - tables use Grazuri schema names (loan_info, etc.)
        # Indexes can be added manually if needed
        migrations.RunSQL(
            sql=migrations.RunSQL.noop,
            reverse_sql=migrations.RunSQL.noop,
        ),
    ]