Modify ↓
Ticket #431 (assigned defect)
db.alter_column() cannot change default value in MySQL
| Reported by: | fcamel@… | Owned by: | andrew |
|---|---|---|---|
| Priority: | major | Milestone: | 1.0 |
| Component: | databaseapi | Version: | 0.7 |
| Keywords: | Cc: |
Description
Here is my server information:
- mysql 5.0.51a
- ubuntu 8.04
Using db.alter_column() to change the default value works in sqlite3 but fails in MySQL.
models.py:
class Name(models.Model):
n = models.IntegerField(default=3)
Part of the migration script:
class Migration(SchemaMigration):
def forwards(self, orm):
db.alter_column('my_app_name', 'n', models.IntegerField(default=40))
def backwards(self, orm):
db.alter_column('my_app_name', 'n', models.IntegerField(default=3))
After running "migrate" (forward or backward), the default value is changed to None.
Attachments
Change History
Note: See
TracTickets for help on using
tickets.
