id	summary	reporter	owner	description	type	status	priority	milestone	component	version	resolution	keywords	cc
431	db.alter_column() cannot change default value in MySQL	fcamel@…	andrew	"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.
"	defect	assigned	major	1.0	databaseapi	0.7