Query

db.sqlite3 — core_user_permissions

SQL

CREATE TABLE "core_user_permissions"  (
  "id" integer NOT NULL PRIMARY KEY AUTOINCREMENT,
  "user_id" bigint NOT NULL REFERENCES "core_users" ("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
user_id bigint Rename | Drop
permission_id INTEGER Rename | Drop

Foreign Keys

Column Destination
permission_id auth_permission.id
user_id core_users.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
core_user_permissions_permission_id_d29765c4 permission_id SQL 
CREATE INDEX "core_user_permissions_permission_id_d29765c4"
ON "core_user_permissions" ("permission_id")
Drop
core_user_permissions_user_id_b8ea600d user_id SQL 
CREATE INDEX "core_user_permissions_user_id_b8ea600d"
ON "core_user_permissions" ("user_id")
Drop
core_user_permissions_user_id_permission_id_c285a933_uniq
  • user_id
  • permission_id
 ✓ SQL 
CREATE UNIQUE INDEX "core_user_permissions_user_id_permission_id_c285a933_uniq"
ON "core_user_permissions" ("user_id", "permission_id")
Drop