id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
25551	makemigrations when adding a ForeignKey to a newly created model along with a unique_together constraint must create fields before the unique_together constraint	Suriya Subramanian	avojnovicDk	"When adding a new model and a `ForeignKey` to it as well a `unique_together` constraint for the `ForeignKey` field, Django migrations should create the field before applying the `unique_together` constraint.

In the example below, I am adding a new `Author` model, a field to this model and a `unique_together` constraint for this field.

{{{#!diff
 from django.db import models
 
+class Author(models.Model):
+    name = models.CharField(max_length=255)
+
 class Book(models.Model):
     name = models.CharField(max_length=255)
+    author = models.ForeignKey(Author, null=True)
+    class Meta:
+        unique_together = (
+            ('name', 'author'),
+        )
}}}

Django's migrations framework produces the following summary output:

{{{
Migrations for 'testapp':
  0002_auto_20151013_1354.py:
    - Create model Author
    - Alter unique_together for book (1 constraint(s))
    - Add field author to book
}}}

Here's the relevant portion of the migrations file:

{{{#!python
    operations = [
        migrations.CreateModel(
            name='Author',
            fields=[
                ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
                ('name', models.CharField(max_length=255)),
            ],
        ),
        migrations.AlterUniqueTogether(
            name='book',
            unique_together=set([('name', 'author')]),
        ),
        migrations.AddField(
            model_name='book',
            name='author',
            field=models.ForeignKey(to='testapp.Author', null=True),
        ),
    ]
}}}

This migration fails with the following stacktrace:
{{{
Operations to perform:
  Apply all migrations: testapp
Running migrations:
  Rendering model states... DONE
  Applying testapp.0002_auto_20151013_1354...Traceback (most recent call last):
  File ""./manage.py"", line 10, in <module>
    execute_from_command_line(sys.argv)
  File ""/home/vagrant/testunique-env/local/lib/python2.7/site-packages/django/core/management/__init__.py"", line 351, in execute_from_command_line
    utility.execute()
  File ""/home/vagrant/testunique-env/local/lib/python2.7/site-packages/django/core/management/__init__.py"", line 343, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File ""/home/vagrant/testunique-env/local/lib/python2.7/site-packages/django/core/management/base.py"", line 394, in run_from_argv
    self.execute(*args, **cmd_options)
  File ""/home/vagrant/testunique-env/local/lib/python2.7/site-packages/django/core/management/base.py"", line 445, in execute
    output = self.handle(*args, **options)
  File ""/home/vagrant/testunique-env/local/lib/python2.7/site-packages/django/core/management/commands/migrate.py"", line 222, in handle
    executor.migrate(targets, plan, fake=fake, fake_initial=fake_initial)
  File ""/home/vagrant/testunique-env/local/lib/python2.7/site-packages/django/db/migrations/executor.py"", line 110, in migrate
    self.apply_migration(states[migration], migration, fake=fake, fake_initial=fake_initial)
  File ""/home/vagrant/testunique-env/local/lib/python2.7/site-packages/django/db/migrations/executor.py"", line 148, in apply_migration
    state = migration.apply(state, schema_editor)
  File ""/home/vagrant/testunique-env/local/lib/python2.7/site-packages/django/db/migrations/migration.py"", line 115, in apply
    operation.database_forwards(self.app_label, schema_editor, old_state, project_state)
  File ""/home/vagrant/testunique-env/local/lib/python2.7/site-packages/django/db/migrations/operations/models.py"", line 359, in database_forwards
    getattr(new_model._meta, self.option_name, set()),
  File ""/home/vagrant/testunique-env/local/lib/python2.7/site-packages/django/db/backends/sqlite3/schema.py"", line 219, in alter_unique_together
    self._remake_table(model, override_uniques=new_unique_together)
  File ""/home/vagrant/testunique-env/local/lib/python2.7/site-packages/django/db/backends/sqlite3/schema.py"", line 140, in _remake_table
    self.create_model(temp_model)
  File ""/home/vagrant/testunique-env/local/lib/python2.7/site-packages/django/db/backends/base/schema.py"", line 272, in create_model
    columns = [model._meta.get_field(field).column for field in fields]
  File ""/home/vagrant/testunique-env/local/lib/python2.7/site-packages/django/db/models/options.py"", line 554, in get_field
    raise FieldDoesNotExist('%s has no field named %r' % (self.object_name, field_name))
django.core.exceptions.FieldDoesNotExist: Book has no field named u'author'
}}}"	Bug	closed	Migrations	1.8	Normal	fixed			Accepted	1	0	0	0	0	0