Adding a field to an existing Django model

I have a little website with a few users and I'd like to add a field to one of my models (and hence tables.) The problem is that syncdb of course won't touch the existing models and I'm trying to figure out how to add this field to the model/table without having to repopulate the entire thing.

Example:

class Newspaper(models.Model):
    name = models.CharField()

class UserProfile(models.Model):
    user = models.ForeignKey(user, unique=True)
    reads = models.ManyToManyField(Newspaper)

Now I'd like to add a URL field (blank=True) to the Newspaper model without breaking the user profiles.

Any ideas?


There's no built-in way to do this. However there are a number of third-party projects that will do it for you. The two leading ones are called South and django-evolution, although there are various others as well (including one I've been involved with, dmigrations).

I would definitely recommend South - it has a number of really neat features and works really well.


You could try getting the SQL for your new field using:

manage.py sql appname

Where appname is the name of the application in which your newspaper class lives.

Then, you could manually add a field to your appname_newspaper table, using ALTER TABLE. I'm not aware of a way to do this directly with Django, since Django does not support migrations.


2015 answer:

Run the following:

python manage.py makemigrations
python manage.py migrate