django -- 联合索引

一、定义：

from django.db import models

# Create your models here.

class Person(models.Model):

    first_name = models.CharField(max_length=100)

    last_name  = models.CharField(max_length=100)

    class Meta():

        index_together = ["first_name", "last_name"]

二、生成目标SQL：

python3 manage.py makemigrations polls

Migrations for 'polls':

  polls/migrations/0001_initial.py

    - Create model Person

    - Alter index_together for person (1 constraint(s))

三、查看目标SQL：

python3 manage.py sqlmigrate polls 0001

BEGIN;

--

-- Create model Person

--

CREATE TABLE "polls_person" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "first_name" varchar(100) NOT NULL, "last_name" varchar(100) NOT NULL);

--

-- Alter index_together for person (1 constraint(s))

--

CREATE INDEX "polls_person_first_name_last_name_0c87f2f4_idx" ON "polls_person" ("first_name", "last_name");

COMMIT;