diff options
| author | Adam Chainz <me@adamj.eu> | 2016-11-05 22:23:57 +0100 |
|---|---|---|
| committer | Simon Charette <charettes@users.noreply.github.com> | 2016-11-05 22:23:57 +0100 |
| commit | c7dddc01d6ca8d8d89f84d26123ecb021aa2a108 (patch) | |
| tree | 13723b505e2cd28a3684bd90a39021865f21597d | |
| parent | d1dbaeaadb659e61c8f351457c25cac1604675bb (diff) | |
Fixed #27441 -- Improved SQL for 'DROP COLUMN' on MySQL
'CASCADE' is an undocumented no-op in MySQL, so to avoid confusion Django no longer outputs it.
| -rw-r--r-- | django/db/backends/mysql/schema.py | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/django/db/backends/mysql/schema.py b/django/db/backends/mysql/schema.py index 4a61807234..f89088ef5b 100644 --- a/django/db/backends/mysql/schema.py +++ b/django/db/backends/mysql/schema.py @@ -9,6 +9,10 @@ class DatabaseSchemaEditor(BaseDatabaseSchemaEditor): sql_alter_column_null = "MODIFY %(column)s %(type)s NULL" sql_alter_column_not_null = "MODIFY %(column)s %(type)s NOT NULL" sql_alter_column_type = "MODIFY %(column)s %(type)s" + + # No 'CASCADE' which works as a no-op in MySQL but is undocumented + sql_delete_column = "ALTER TABLE %(table)s DROP COLUMN %(column)s" + sql_rename_column = "ALTER TABLE %(table)s CHANGE %(old_column)s %(new_column)s %(type)s" sql_delete_unique = "ALTER TABLE %(table)s DROP INDEX %(name)s" |