✨ finds: change donor to m2m

1 files changed, 36 insertions, 0 deletions

diff --git a/archaeological_finds/migrations/0138_donor_to_donors.py b/archaeological_finds/migrations/0138_donor_to_donors.py
new file mode 100644
index 000000000..24ecf65d1
--- /dev/null
+++ b/archaeological_finds/migrations/0138_donor_to_donors.py
@@ -0,0 +1,36 @@
+# Generated by Django 2.2.24 on 2025-08-25 10:14
+
+from django.db import migrations, models
+
+
+SQL_MIGRATE = """
+INSERT INTO archaeological_finds_find_museum_donors
+    (find_id, biographicalnote_id)
+    SELECT id, museum_donor_id FROM archaeological_finds_find
+        WHERE museum_donor_id IS NOT NULL;
+"""
+
+
+class Migration(migrations.Migration):
+
+    dependencies = [
+        ('ishtar_common', '0263_media_exporter'),
+        ('archaeological_finds', '0137_data_migration_treatment_status_inputstatus'),
+    ]
+
+    operations = [
+        migrations.AddField(
+            model_name='find',
+            name='museum_donors',
+            field=models.ManyToManyField(blank=True, related_name='finds_donors', to='ishtar_common.BiographicalNote', verbose_name='Donors, testators or vendors'),
+        ),
+        migrations.RunSQL(SQL_MIGRATE),
+        migrations.RemoveField(
+            model_name='find',
+            name='museum_donor',
+        ),
+        migrations.RemoveField(
+            model_name='historicalfind',
+            name='museum_donor',
+        ),
+    ]