# Generated by Django 5.0.2 on 2025-12-02 16:54

from django.db import migrations, models


class Migration(migrations.Migration):

    dependencies = [
        ('supervisorgroup', '0001_initial'),
    ]

    operations = [
        # Set default values in MySQL for existing columns
        migrations.RunSQL(
            sql=[
                "ALTER TABLE supervisor_groups MODIFY COLUMN can_add_stamps TINYINT(1) NOT NULL DEFAULT 0;",
                "ALTER TABLE supervisor_groups MODIFY COLUMN can_edit_stamps TINYINT(1) NOT NULL DEFAULT 0;",
                "ALTER TABLE supervisor_groups MODIFY COLUMN can_delete_stamps TINYINT(1) NOT NULL DEFAULT 0;",
            ],
            reverse_sql=[
                "ALTER TABLE supervisor_groups MODIFY COLUMN can_add_stamps TINYINT(1) NOT NULL;",
                "ALTER TABLE supervisor_groups MODIFY COLUMN can_edit_stamps TINYINT(1) NOT NULL;",
                "ALTER TABLE supervisor_groups MODIFY COLUMN can_delete_stamps TINYINT(1) NOT NULL;",
            ],
        ),
        # Tell Django about the fields (columns already exist in DB)
        migrations.SeparateDatabaseAndState(
            database_operations=[],
            state_operations=[
                migrations.AddField(
                    model_name='supervisorgroup',
                    name='can_add_stamps',
                    field=models.BooleanField(default=False, help_text='Allow users in this supervisor group to add stamps'),
                ),
                migrations.AddField(
                    model_name='supervisorgroup',
                    name='can_delete_stamps',
                    field=models.BooleanField(default=False, help_text='Allow users in this supervisor group to delete stamps'),
                ),
                migrations.AddField(
                    model_name='supervisorgroup',
                    name='can_edit_stamps',
                    field=models.BooleanField(default=False, help_text='Allow users in this supervisor group to edit stamps'),
                ),
            ],
        ),
    ]