🗃️ finds - specific tables for recommended treatments

1 files changed, 45 insertions, 0 deletions

diff --git a/archaeological_finds/migrations/0140_recommanded_treatments.py b/archaeological_finds/migrations/0140_recommanded_treatments.py
new file mode 100644
index 000000000..250c2bf74
--- /dev/null
+++ b/archaeological_finds/migrations/0140_recommanded_treatments.py
@@ -0,0 +1,45 @@
+# Generated by Django 2.2.24 on 2025-09-30 11:31
+
+import archaeological_finds.models_treatments
+import django.core.validators
+from django.db import migrations, models
+import django.db.models.deletion
+import ishtar_common.models_common
+import re
+
+
+class Migration(migrations.Migration):
+
+    dependencies = [
+        ('archaeological_finds', '0139_data_migration_owner_ownership'),
+    ]
+    operations = [
+        migrations.AlterField(
+            model_name='find',
+            name='preservation_to_considers',
+            field=models.ManyToManyField(blank=True, related_name='finds_old_recommended', to='archaeological_finds.TreatmentType', verbose_name='Recommended treatments'),
+        ),
+        migrations.CreateModel(
+            name='RecommendedTreatmentType',
+            fields=[
+                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+                ('label', models.TextField(verbose_name='Label')),
+                ('txt_idx', models.TextField(help_text='The slug is the standardized version of the name. It contains only lowercase letters, numbers and hyphens. Each slug must be unique.', unique=True, validators=[django.core.validators.RegexValidator(re.compile('^[-a-zA-Z0-9_]+\\Z'), "Enter a valid 'slug' consisting of letters, numbers, underscores or hyphens.", 'invalid')], verbose_name='Textual ID')),
+                ('comment', models.TextField(blank=True, default='', verbose_name='Comment')),
+                ('available', models.BooleanField(default=True, verbose_name='Available')),
+                ('order', models.IntegerField(default=10, verbose_name='Order')),
+                ('parent', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='archaeological_finds.RecommendedTreatmentType', verbose_name='Parent')),
+            ],
+            options={
+                'verbose_name': 'Recommended treatment type',
+                'verbose_name_plural': 'Recommended treatment types',
+                'ordering': ('parent__order', 'parent__label', 'order', 'label'),
+            },
+            bases=(ishtar_common.models_common.Cached, models.Model),
+        ),
+        migrations.AddField(
+            model_name='find',
+            name='recommended_treatments',
+            field=models.ManyToManyField(blank=True, related_name='finds_recommended', to='archaeological_finds.RecommendedTreatmentType', verbose_name='Recommended treatments'),
+        ),
+    ]