# Generated by Django 2.2.24 on 2024-11-19 17:49

from django.db import migrations, models


MAJ_SQL1 = "UPDATE archaeological_finds_treatmentfile SET basket_id=associated_basket_id;"
MAJ_SQL2 = "UPDATE archaeological_finds_historicaltreatmentfile SET basket_id=associated_basket_id;"


class Migration(migrations.Migration):

    dependencies = [
        ('archaeological_finds', '0131_ishtar_users'),
    ]

    operations = [
        migrations.AlterModelOptions(
            name='basefind',
            options={'verbose_name': 'Base find', 'verbose_name_plural': 'Base finds'},
        ),
        migrations.AddField(
            model_name='historicaltreatmentfile',
            name='basket_id',
            field=models.PositiveIntegerField(blank=True, null=True, verbose_name='Basket ID'),
        ),
        migrations.AddField(
            model_name='treatmentfile',
            name='basket_id',
            field=models.PositiveIntegerField(blank=True, null=True, verbose_name='Basket ID'),
        ),
        migrations.RunSQL(MAJ_SQL1),
        migrations.RunSQL(MAJ_SQL2),
        migrations.RemoveField(
            model_name='historicaltreatmentfile',
            name='associated_basket',
        ),
        migrations.RemoveField(
            model_name='treatmentfile',
            name='associated_basket',
        ),
        migrations.RenameField(model_name="treatmentfile", old_name="basket_id", new_name="associated_basket_id"),
        migrations.RenameField(model_name="historicaltreatmentfile", old_name="basket_id", new_name="associated_basket_id"),

        migrations.AddField(
            model_name='treatment',
            name='associated_basket_id',
            field=models.PositiveIntegerField(blank=True, null=True, verbose_name='Basket ID'),
        ),
        migrations.AddField(
            model_name='historicaltreatment',
            name='associated_basket_id',
            field=models.PositiveIntegerField(blank=True, null=True, verbose_name='Basket ID'),
        ),
        migrations.AddField(
            model_name='treatmentfiletype',
            name='is_exhibition',
            field=models.BooleanField(default=False, verbose_name='Is an exhibition'),
        ),
    ]