Opened 9 years ago
Last modified 9 years ago
#24934 closed Bug
Can't drop or change unique_together index in MySql — at Initial Version
Reported by: | user0007 | Owned by: | nobody |
---|---|---|---|
Component: | Migrations | Version: | 1.8 |
Severity: | Normal | Keywords: | |
Cc: | Triage Stage: | Unreviewed | |
Has patch: | no | Needs documentation: | no |
Needs tests: | no | Patch needs improvement: | no |
Easy pickings: | no | UI/UX: | no |
Description
Hello,
I'm using Django 1.8.2 and Mysql 5.6. I created model with two fields in unique_together:
class Meta: unique_together = ('user', 'product')
the table was created sucessfully. Later I removed unique_together:
class Meta: pass
so Django created migration:
operations = [ migrations.AlterUniqueTogether( name='mymodel', unique_together=set([]), ), ]
but when i try to apply this migrattion I have got an error:
django.db.utils.OperationalError: (1061, "Duplicate key name 'myapp_mymodel_1ba366c5'")
Django is trying to create this index, instead of removed them.
The same situation is when I try to add third field to my unique_together list:
class Meta: unique_together = ('user', 'product', 'category')
django.db.utils.OperationalError: (1061, "Duplicate key name 'myapp_mymodel_1ba366c5'")
Note:
See TracTickets
for help on using tickets.