# Generated by Django 5.0.2 on 2025-12-02 16:47

from django.db import migrations, models


class Migration(migrations.Migration):

    dependencies = [
        ('supervisor', '0002_supervisor_can_add_stamps_and_more'),
    ]

    operations = [
        # First, set default values in MySQL for existing records
        migrations.RunSQL(
            sql=[
                "ALTER TABLE supervisors MODIFY COLUMN can_add_stamps BOOLEAN NOT NULL DEFAULT 0;",
                "ALTER TABLE supervisors MODIFY COLUMN can_edit_stamps BOOLEAN NOT NULL DEFAULT 0;",
                "ALTER TABLE supervisors MODIFY COLUMN can_delete_stamps BOOLEAN NOT NULL DEFAULT 0;",
            ],
            reverse_sql=[
                "ALTER TABLE supervisors MODIFY COLUMN can_add_stamps BOOLEAN NOT NULL DEFAULT 1;",
                "ALTER TABLE supervisors MODIFY COLUMN can_edit_stamps BOOLEAN NOT NULL DEFAULT 1;",
                "ALTER TABLE supervisors MODIFY COLUMN can_delete_stamps BOOLEAN NOT NULL DEFAULT 1;",
            ],
        ),
        # Then update the model fields
        migrations.AlterField(
            model_name='supervisor',
            name='can_add_stamps',
            field=models.BooleanField(default=False, help_text='Allow users in this supervisor group to add stamps'),
        ),
        migrations.AlterField(
            model_name='supervisor',
            name='can_delete_stamps',
            field=models.BooleanField(default=False, help_text='Allow users in this supervisor group to delete stamps'),
        ),
        migrations.AlterField(
            model_name='supervisor',
            name='can_edit_stamps',
            field=models.BooleanField(default=False, help_text='Allow users in this supervisor group to edit stamps'),
        ),
    ]
