diff options
| -rw-r--r-- | archaeological_warehouse/migrations/0118_auto_20230807_1106.py | 53 |
1 files changed, 53 insertions, 0 deletions
diff --git a/archaeological_warehouse/migrations/0118_auto_20230807_1106.py b/archaeological_warehouse/migrations/0118_auto_20230807_1106.py new file mode 100644 index 000000000..de3ae7139 --- /dev/null +++ b/archaeological_warehouse/migrations/0118_auto_20230807_1106.py @@ -0,0 +1,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', + ), + ] |