Query

db.sqlite3 — core_users_groups

SQL

CREATE TABLE "core_users_groups"  (
  "id" integer NOT NULL PRIMARY KEY AUTOINCREMENT,
  "user_id" bigint NOT NULL REFERENCES "core_users" ("id") DEFERRABLE INITIALLY DEFERRED,
  "group_id" integer NOT NULL REFERENCES "auth_group" ("id") DEFERRABLE INITIALLY DEFERRED
)

+ Add column

Columns

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

Foreign Keys

Column Destination
group_id auth_group.id
user_id core_users.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
core_users_groups_group_id_a85c7d38 group_id SQL 
CREATE INDEX "core_users_groups_group_id_a85c7d38"
ON "core_users_groups" ("group_id")
Drop
core_users_groups_user_id_acee482b user_id SQL 
CREATE INDEX "core_users_groups_user_id_acee482b"
ON "core_users_groups" ("user_id")
Drop
core_users_groups_user_id_group_id_61a6cd7e_uniq
  • user_id
  • group_id
 ✓ SQL 
CREATE UNIQUE INDEX "core_users_groups_user_id_group_id_61a6cd7e_uniq"
ON "core_users_groups" ("user_id", "group_id")
Drop