summaryrefslogtreecommitdiff
path: root/ishtar_common/migrations/0229_auto_20230608_1303.py
blob: c33a422384bf48a6fe2fe768b9fd3585894b7c66 (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
# Generated by Django 2.2.24 on 2023-06-08 13:03

from django.db import migrations, models


COPY_HISTORICALORGANIZATION = """
UPDATE ishtar_common_historicalorganization
SET precise_town_id2 = precise_town_id
"""
COPY_ORGANIZATION = """
UPDATE ishtar_common_organization
SET precise_town_id2 = precise_town_id
"""
COPY_HISTORICALPERSON = """
UPDATE ishtar_common_historicalperson
SET precise_town_id2 = precise_town_id
"""
COPY_PERSON = """
UPDATE ishtar_common_person
SET precise_town_id2 = precise_town_id
"""


class Migration(migrations.Migration):

    dependencies = [
        ('ishtar_common', '0228_auto_20230418_1622'),
    ]

    operations = [
        migrations.AddField(
            model_name='historicalorganization',
            name='precise_town_id2',
            field=models.PositiveIntegerField(blank=True, null=True, verbose_name='Town (precise)'),
        ),
        migrations.AddField(
            model_name='historicalperson',
            name='precise_town_id2',
            field=models.PositiveIntegerField(blank=True, null=True, verbose_name='Town (precise)'),
        ),
        migrations.AddField(
            model_name='organization',
            name='precise_town_id2',
            field=models.PositiveIntegerField(blank=True, null=True, verbose_name='Town (precise)'),
        ),
        migrations.AddField(
            model_name='person',
            name='precise_town_id2',
            field=models.PositiveIntegerField(blank=True, null=True, verbose_name='Town (precise)'),
        ),
        migrations.RunSQL(COPY_PERSON),
        migrations.RunSQL(COPY_HISTORICALPERSON),
        migrations.RunSQL(COPY_ORGANIZATION),
        migrations.RunSQL(COPY_HISTORICALORGANIZATION),
        migrations.RemoveField(
            model_name='historicalorganization',
            name='precise_town',
        ),
        migrations.RemoveField(
            model_name='historicalperson',
            name='precise_town',
        ),
        migrations.RemoveField(
            model_name='organization',
            name='precise_town',
        ),
        migrations.RemoveField(
            model_name='person',
            name='precise_town',
        ),
        migrations.RenameField(
            model_name='historicalorganization',
            old_name='precise_town_id2',
            new_name='precise_town_id'
        ),
        migrations.RenameField(
            model_name='historicalperson',
            old_name='precise_town_id2',
            new_name='precise_town_id'
        ),
        migrations.RenameField(
            model_name='organization',
            old_name='precise_town_id2',
            new_name='precise_town_id'
        ),
        migrations.RenameField(
            model_name='person',
            old_name='precise_town_id2',
            new_name='precise_town_id'
        ),
        migrations.AddField(
            model_name='spatialreferencesystem',
            name='round',
            field=models.IntegerField(default=5, verbose_name='Number of decimal places'),
        ),
        migrations.AddField(
            model_name='spatialreferencesystem',
            name='round_z',
            field=models.IntegerField(default=3, verbose_name='Number of decimal places for Z'),
        ),
    ]