Query

db.sqlite3 — auth_group_permissions

SQL

CREATE TABLE "auth_group_permissions"  (
  "id" integer NOT NULL PRIMARY KEY AUTOINCREMENT,
  "group_id" integer NOT NULL REFERENCES "auth_group" ("id") DEFERRABLE INITIALLY DEFERRED,
  "permission_id" integer NOT NULL REFERENCES "auth_permission" ("id") DEFERRABLE INITIALLY DEFERRED
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
group_id INTEGER Rename | Drop
permission_id INTEGER Rename | Drop

Foreign Keys

Column Destination
permission_id auth_permission.id
group_id auth_group.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
auth_group_permissions_group_id_b120cbf9 group_id SQL 
CREATE INDEX "auth_group_permissions_group_id_b120cbf9"
ON "auth_group_permissions" ("group_id")
Drop
auth_group_permissions_group_id_permission_id_0cd325b0_uniq
  • group_id
  • permission_id
 ✓ SQL 
CREATE UNIQUE INDEX "auth_group_permissions_group_id_permission_id_0cd325b0_uniq"
ON "auth_group_permissions" ("group_id", "permission_id")
Drop
auth_group_permissions_permission_id_84c5c92e permission_id SQL 
CREATE INDEX "auth_group_permissions_permission_id_84c5c92e"
ON "auth_group_permissions" ("permission_id")
Drop