summaryrefslogtreecommitdiff
path: root/archaeological_warehouse/migrations/0118_auto_20230807_1106.py
blob: de3ae71391efcf61f4148a2e30bdbe617233f984 (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
# Generated by Django 2.2.24 on 2023-08-07 11:06

from django.db import migrations, models


COPY_HISTORICALWAREHOUSE = """
UPDATE archaeological_warehouse_historicalwarehouse
SET precise_town_id2 = precise_town_id
"""
COPY_WAREHOUSE = """
UPDATE archaeological_warehouse_warehouse
SET precise_town_id2 = precise_town_id
"""


class Migration(migrations.Migration):

    dependencies = [
        ('archaeological_warehouse', '0117_migrate_created'),
    ]

    operations = [
        migrations.AddField(
            model_name='historicalwarehouse',
            name='precise_town_id2',
            field=models.PositiveIntegerField(blank=True, null=True, verbose_name='Town (precise)'),
        ),
        migrations.AddField(
            model_name='warehouse',
            name='precise_town_id2',
            field=models.PositiveIntegerField(blank=True, null=True, verbose_name='Town (precise)'),
        ),
        migrations.RunSQL(COPY_WAREHOUSE),
        migrations.RunSQL(COPY_HISTORICALWAREHOUSE),
        migrations.RemoveField(
            model_name='historicalwarehouse',
            name='precise_town',
        ),
        migrations.RemoveField(
            model_name='warehouse',
            name='precise_town',
        ),
        migrations.RenameField(
            model_name='historicalwarehouse',
            old_name='precise_town_id2',
            new_name='precise_town_id',
        ),
        migrations.RenameField(
            model_name='warehouse',
            old_name='precise_town_id2',
            new_name='precise_town_id',
        ),
    ]