Query

db.sqlite3 — auth_permission

SQL

CREATE TABLE "auth_permission"  (
  "id" integer NOT NULL PRIMARY KEY AUTOINCREMENT,
  "content_type_id" integer NOT NULL REFERENCES "django_content_type" ("id") DEFERRABLE INITIALLY DEFERRED,
  "codename" varchar(100) NOT NULL,
  "name" varchar(255) NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
content_type_id INTEGER Rename | Drop
codename varchar(100) Rename | Drop
name varchar(255) Rename | Drop

Foreign Keys

Column Destination
content_type_id django_content_type.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
auth_permission_content_type_id_2f476e4b content_type_id SQL 
CREATE INDEX "auth_permission_content_type_id_2f476e4b"
ON "auth_permission" ("content_type_id")
Drop
auth_permission_content_type_id_codename_01ab375a_uniq
  • content_type_id
  • codename
 ✓ SQL 
CREATE UNIQUE INDEX "auth_permission_content_type_id_codename_01ab375a_uniq"
ON "auth_permission" ("content_type_id", "codename")
Drop