2 files changed, 59 insertions, 9 deletions
diff --git a/archaeological_files/migrations/0018_auto_20190206_1522.py b/archaeological_files/migrations/0018_auto_20190206_1522.py
new file mode 100644
index 000000000..321920c61
--- /dev/null
+++ b/archaeological_files/migrations/0018_auto_20190206_1522.py
@@ -0,0 +1,41 @@
+# -*- coding: utf-8 -*-
+# Generated by Django 1.11.10 on 2019-02-06 15:22
+from __future__ import unicode_literals
+
+from django.db import migrations, models
+import django.db.models.deletion
+
+
+class Migration(migrations.Migration):
+
+    dependencies = [
+        ('archaeological_files', '0017_auto_20190111_1755'),
+    ]
+
+    operations = [
+        migrations.AlterField(
+            model_name='file',
+            name='main_town',
+            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='file_main', to='ishtar_common.Town', verbose_name='Commune principale'),
+        ),
+        migrations.AlterField(
+            model_name='file',
+            name='permit_type',
+            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='archaeological_files.PermitType', verbose_name='Type de permis'),
+        ),
+        migrations.AlterField(
+            model_name='file',
+            name='related_file',
+            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='archaeological_files.File', verbose_name='Dossier li\xe9 \xe0'),
+        ),
+        migrations.AlterField(
+            model_name='file',
+            name='requested_operation_type',
+            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to='ishtar_common.OperationType', verbose_name="Type d'op\xe9ration demand\xe9e"),
+        ),
+        migrations.AlterField(
+            model_name='file',
+            name='saisine_type',
+            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='archaeological_files.SaisineType', verbose_name='Type de saisine'),
+        ),
+    ]
diff --git a/archaeological_files/models.py b/archaeological_files/models.py
index a9c14cb3a..1d60b9c17 100644
--- a/archaeological_files/models.py
+++ b/archaeological_files/models.py
@@ -24,8 +24,7 @@ from django.contrib.gis.db import models
 from django.core.cache import cache
 from django.db.models import Q, Count, Sum
 from django.db.models.signals import post_save, m2m_changed, post_delete
-from django.utils.translation import ugettext_lazy as _, pgettext_lazy, \
-    activate, deactivate
+from django.utils.translation import ugettext_lazy as _, pgettext_lazy
 
 from ishtar_common.utils import cached_label_changed, get_cache, \
     get_current_year, m2m_historization_changed
@@ -257,12 +256,17 @@ class File(ClosedItem, BaseHistorizedItem, OwnPerms, ValueGetter,
         verbose_name=_(u"Planning service organization"),
         on_delete=models.SET_NULL,)  # service instructeur
     permit_type = models.ForeignKey(
-        PermitType, verbose_name=_(u"Permit type"), blank=True, null=True)
+        PermitType, verbose_name=_(u"Permit type"), blank=True, null=True,
+        on_delete=models.SET_NULL
+    )
     permit_reference = models.TextField(_(u"Permit reference"), blank=True,
                                         null=True)
     end_date = models.DateField(_(u"Closing date"), null=True, blank=True)
-    main_town = models.ForeignKey(Town, verbose_name=_(u"Main town"), null=True,
-                                  blank=True, related_name='file_main')
+    main_town = models.ForeignKey(
+        Town, verbose_name=_(u"Main town"), null=True, blank=True,
+        related_name='file_main',
+        on_delete=models.SET_NULL
+    )
     towns = models.ManyToManyField(Town, verbose_name=_(u"Towns"),
                                    related_name='file', blank=True)
     creation_date = models.DateField(
@@ -270,11 +274,14 @@ class File(ClosedItem, BaseHistorizedItem, OwnPerms, ValueGetter,
         null=True)
     reception_date = models.DateField(_(u'Reception date'), blank=True,
                                       null=True)
-    related_file = models.ForeignKey("File", verbose_name=_(u"Related file"),
-                                     blank=True, null=True)
+    related_file = models.ForeignKey(
+        "File", verbose_name=_(u"Related file"), blank=True, null=True,
+        on_delete=models.SET_NULL
+    )
     if settings.COUNTRY == 'fr':
         saisine_type = models.ForeignKey(
             SaisineType, blank=True, null=True,
+            on_delete=models.SET_NULL,
             verbose_name=u"Type de saisine")
         instruction_deadline = models.DateField(_(u'Instruction deadline'),
                                                 blank=True, null=True)
@@ -292,8 +299,9 @@ class File(ClosedItem, BaseHistorizedItem, OwnPerms, ValueGetter,
     departments = models.ManyToManyField(
         Department, verbose_name=_(u"Departments"), blank=True)
     requested_operation_type = models.ForeignKey(
-        OperationType, related_name='+', null=True,
-        blank=True, verbose_name=_(u"Requested operation type"))
+        OperationType, related_name='+',
+        on_delete=models.SET_NULL,
+        null=True, blank=True, verbose_name=_(u"Requested operation type"))
     organization = models.ForeignKey(
         Organization, blank=True, null=True, verbose_name=_(u"Organization"),
         related_name='files', on_delete=models.SET_NULL)
@@ -721,6 +729,7 @@ class FileByDepartment(models.Model):
     """
     file = models.ForeignKey(File, verbose_name=_(u"File"))
     department = models.ForeignKey(Department, verbose_name=_(u"Department"),
+                                   on_delete=models.DO_NOTHING,
                                    blank=True, null=True)
 
     class Meta: