summaryrefslogtreecommitdiff
path: root/archaeological_finds/migrations/0127_find_treatments_container.py
blob: 0667d34f8895ddb5f6e2db4411ea725c28ddc282 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
# Generated by Django 2.2.24 on 2024-09-02 16:43

from django.db import migrations, models
import django.db.models.deletion

SQL = """
ALTER TABLE archaeological_finds_find_treatments ADD COLUMN full_location TEXT;
ALTER TABLE archaeological_finds_find_treatments ADD COLUMN location_type VARCHAR(1);
"""


class Migration(migrations.Migration):

    dependencies = [
        ('archaeological_finds', '0126_fix_treatment_file_exhibition'),
    ]

    operations = [
        migrations.RunSQL(SQL),
        migrations.AddField(
            model_name='findtreatments',
            name='full_location',
            field=models.TextField(blank=True, default='', verbose_name='Full location')
        ),
        migrations.AddField(
            model_name='findtreatments',
            name='location_type',
            field=models.CharField(choices=[['C', 'Current'], ['R', 'Reference'], ['B', 'Both']], default='C',
                                   max_length=1,
                                   verbose_name='Location type')
        ),
        migrations.AlterModelOptions(
            name='batchtype',
            options={'ordering': ('order', 'label'), 'verbose_name': 'Batch type', 'verbose_name_plural': 'Batch types'},
        ),
        migrations.AlterModelOptions(
            name='checkedtype',
            options={'ordering': ('order', 'label'), 'verbose_name': 'Checked type', 'verbose_name_plural': 'Checked types'},
        ),
        migrations.AlterModelOptions(
            name='materialtypequalitytype',
            options={'ordering': ('order', 'label'), 'verbose_name': 'Material type quality type', 'verbose_name_plural': 'Material type quality types'},
        ),
        migrations.AlterModelOptions(
            name='objecttypequalitytype',
            options={'ordering': ('order', 'label'), 'verbose_name': 'Object type quality type', 'verbose_name_plural': 'Object type quality types'},
        ),
        migrations.AlterField(
            model_name='findbasket',
            name='items',
            field=models.ManyToManyField(blank=True, related_name='basket', to='archaeological_finds.Find', verbose_name='Associated finds'),
        ),
        migrations.AlterField(
            model_name='historicaltreatmentfile',
            name='external_id',
            field=models.CharField(blank=True, max_length=200, null=True, verbose_name='Reference'),
        ),
        migrations.AlterField(
            model_name='treatmentfile',
            name='external_id',
            field=models.CharField(blank=True, max_length=200, null=True, verbose_name='Reference'),
        ),
        migrations.SeparateDatabaseAndState(
            state_operations=[
                migrations.CreateModel(
                    name='FindTreatment',
                    fields=[
                        ('id',
                         models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                        ('full_location', models.TextField(blank=True, default='', verbose_name='Full location')),
                        ('location_type',
                         models.CharField(choices=[['C', 'Current'], ['R', 'Reference'], ['B', 'Both']], default='C',
                                          max_length=1, verbose_name='Location type')),
                    ],
                    options={
                        'verbose_name': 'Find - Treatment',
                        'verbose_name_plural': 'Find - Treatments',
                        'db_table': 'archaeological_finds_find_treatments',
                    },
                ),
                migrations.AlterField(
                    model_name='find',
                    name='treatments',
                    field=models.ManyToManyField(blank=True, help_text='Related treatments when no new find is created',
                                                 related_name='finds', through='archaeological_finds.FindTreatment',
                                                 to='archaeological_finds.Treatment', verbose_name='Treatments'),
                ),
                migrations.AddField(
                    model_name='findtreatment',
                    name='find',
                    field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='archaeological_finds.Find',
                                            verbose_name='Find'),
                ),
                migrations.AddField(
                    model_name='findtreatment',
                    name='treatment',
                    field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE,
                                            to='archaeological_finds.Treatment'),
                ),
            ]
        ),
    ]