[Django]-Django: create Index: non-unique, multiple column

There is a ticket for this feature. Take a look http://code.djangoproject.com/ticket/5805

You may apply the patch from this ticket yourself.

UPDATE

It’s now in Django: https://docs.djangoproject.com/en/1.5/ref/models/options/#django.db.models.Options.index_together

To follow on from the accepted answer, if you are using South, you can easily add a composite key as follows:

manage.py schemamigration your_app_name name_for_migration –add-index ModelName.first_field_in_index

You can then edit the generated migration file to add the additional fields into the one index (you’ll see it’s just a list of field names that’s needed).

Don’t forget to update the reverse migration as well as the forward one.

It is index_together in django 1.5

See here https://docs.djangoproject.com/en/dev/ref/models/options/#index-together

unique_together might be what you are looking for. Just put it in your Meta class inside your model.

The index_together feature could be deprecated in the futur.

You should use indexes option instead of index_together.

Example of indexes option :

from django.db import models

class Customer(models.Model):
    first_name = models.CharField(max_length=100)
    last_name = models.CharField(max_length=100)

    class Meta:
        indexes = [
            models.Index(fields=['last_name', 'first_name']),
            models.Index(fields=['first_name'], name='first_name_idx'),
        ]

Update for 2022:

The newer indexes option provides more functionality than index_together. index_together was deprecated in Django 4.1.

Usage:

from django.db import models

class Customer(models.Model):
    first_name = models.CharField(max_length=100)
    last_name = models.CharField(max_length=100)

    class Meta:
        indexes = [
            models.Index(fields=['last_name', 'first_name']),
            models.Index(fields=['first_name'], name='first_name_idx'),
        ]

I just wanted to add that as of Django 1.11 there is a new feature, Options.indexes, which will allow you to specify the indexes to create:

Django Options.indexes