[1.7.x] Fixed #22460 -- Explicity remove constraints when dropping a related field.

Backport of 0e45669fa9 from master

1 files changed, 10 insertions, 2 deletions

diff --git a/django/db/backends/schema.py b/django/db/backends/schema.py
index d5bb08e12c..63b0725e22 100644
--- a/django/db/backends/schema.py
+++ b/django/db/backends/schema.py
@@ -442,8 +442,16 @@ class BaseDatabaseSchemaEditor(object):
         # It might not actually have a column behind it
         if field.db_parameters(connection=self.connection)['type'] is None:
             return
-        # Get the column's definition
-        definition, params = self.column_sql(model, field)
+        # Drop any FK constraints, MySQL requires explicit deletion
+        if field.rel:
+            fk_names = self._constraint_names(model, [field.column], foreign_key=True)
+            for fk_name in fk_names:
+                self.execute(
+                    self.sql_delete_fk % {
+                        "table": self.quote_name(model._meta.db_table),
+                        "name": fk_name,
+                    }
+                )
         # Delete the column
         sql = self.sql_delete_column % {
             "table": self.quote_name(model._meta.db_table),