Fix for re-adding the django_content_type.name column in Django 1.7

README.md

Django 1.8 drops the name field from ContentType in favour of a property on the model itself (see https://docs.djangoproject.com/en/1.8/ref/contrib/contenttypes/#the-contenttype-model).

If you update to 1.8 and then back to 1.7 (for whatever crazy reason..) you will come across exceptions as the name property doesn't exist (and neither does the database field).

These scripts restore that functionality to Django 1.7 (by recreating the field and populating it correctly).

It does not cause any data loss, but as always: Use at your own risk.

add_name_column.sql

ALTER TABLE django_content_type ADD COLUMN name character varying(50) NOT NULL DEFAULT 'run migrate.py';

migrate.py

from django.contrib.contenttypes.models import ContentType
from django.db.models.loading import get_model

def fix_name_column():
    """
    Updates the name column of ContentType to match the model's verbose_name.
    """
    for t in ContentType.objects.all():
        model = get_model(t.app_label, t.model)
        if model is None:
            name = t.model
        else:
            name = unicode(model._meta.verbose_name)
        t.name = name
        t.save()


if __name__ == '__main__':
    fix_name_column()

Thanks, God sent.

How/where do I run that SQL statement?