🗃️ operation: operator_reference 20 -> 200 character - add operator_reference search criteria (refs #5965)

1 files changed, 29 insertions, 0 deletions

diff --git a/archaeological_operations/migrations/0118_operator_reference_length.py b/archaeological_operations/migrations/0118_operator_reference_length.py
new file mode 100644
index 000000000..875d7a442
--- /dev/null
+++ b/archaeological_operations/migrations/0118_operator_reference_length.py
@@ -0,0 +1,29 @@
+# Generated by Django 2.2.24 on 2024-06-06 16:09
+
+from django.db import migrations, models
+
+
+class Migration(migrations.Migration):
+
+    dependencies = [
+        ('archaeological_operations', '0117_data_migration_culturalattributiontype'),
+    ]
+
+    operations = [
+        migrations.RunSQL(
+            "UPDATE archaeological_operations_operation SET operator_reference='' WHERE operator_reference IS NULL;"
+        ),
+        migrations.RunSQL(
+            "UPDATE archaeological_operations_historicaloperation SET operator_reference='' WHERE operator_reference IS NULL;"
+        ),
+        migrations.AlterField(
+            model_name='historicaloperation',
+            name='operator_reference',
+            field=models.CharField(blank=True, default='', max_length=200, verbose_name='Operator reference'),
+        ),
+        migrations.AlterField(
+            model_name='operation',
+            name='operator_reference',
+            field=models.CharField(blank=True, default='', max_length=200, verbose_name='Operator reference'),
+        ),
+    ]