Django - syncdb doesn't create tables

Question

I added a many-to-many field to an existing model and was expecting syncdb to create a new table, but there's nothing there. This is what the model looks like:

class Author(models.Model):
    first_name = models.CharField(max_length=50)
    last_name = models.CharField(max_length=50)
    email = models.EmailField()

    def __unicode__(self):
        return "{0} {1}".format(self.first_name, self.last_name)

class Book(models.Model):
    title = models.CharField(max_length=100)
    authors = models.ManyToManyField(Author)

    def __unicode__(self):
        return self.title

Running sql myapp prints the correct statements with the new table, but this is not reflected when I run syncdb. validate also returns no errors. Does anyone know what could be the matter here? Or a better diagnostic?

Alasdair · Accepted Answer · 2012-12-24 01:45:12Z

15

The syncdb command does not create many to many tables for existing models by design. This decision is explained on ticket 2229.

That leaves you with a few options.

If you don't have any data in your Book model, drop the table and rerun syncdb. Django will recreate the book table and the many to many table.
Use the dbshell command, and create the many to many joining table using the output of sql myapp.
If you're doing multiple schema migrations with Django, make friends with South.

edited Dec 24, 2012 at 1:45

answered Dec 24, 2012 at 1:28

Alasdair

310k59 gold badges605 silver badges534 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

edu222 · Accepted Answer · 2012-12-28 15:00:16Z

5

I found this explanation at the django docs useful: SchemaEvolution.

The de facto standard for database migration is Django South.

Its not perfect, but, it works pretty well. You should always check(and edit if necessary) your migration file before running it, to make sure that it actually does what it supposed to do. You can check out their tutorial here.

Also, if you run:

python manage.py inspectdb > somefile.txt

You can get quickly check out if your database structure is matching your django models.

edited Dec 28, 2012 at 15:00

answered Dec 24, 2012 at 2:46

edu222

4961 gold badge8 silver badges21 bronze badges

Collectives™ on Stack Overflow

Django - syncdb doesn't create tables

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related