21 lines
683 B
MySQL
21 lines
683 B
MySQL
|
CREATE TABLE `auth_user_groups` (
|
|||
|
|
`id` BIGINT(20) NOT NULL AUTO_INCREMENT,
|
|||
|
|
`user_id` INT(11) NOT NULL,
|
|||
|
|
`group_id` INT(11) NOT NULL,
|
|||
|
|
PRIMARY KEY (id)
|
|||
|
|
)
|
|||
|
|
ENGINE = INNODB,
|
|||
|
|
CHARACTER SET utf8mb4,
|
|||
|
|
COLLATE utf8mb4_general_ci,
|
|||
|
|
ROW_FORMAT = DYNAMIC;
|
|||
|
|
|
|||
|
|
ALTER TABLE `auth_user_groups`
|
|||
|
|
ADD UNIQUE INDEX auth_user_groups_user_id_group_id_94350c0c_uniq(user_id, group_id);
|
|||
|
|
|
|||
|
|
ALTER TABLE `auth_user_groups`
|
|||
|
|
ADD CONSTRAINT `auth_user_groups_group_id_97559544_fk_auth_group_id` FOREIGN KEY (group_id)
|
|||
|
|
REFERENCES auth_group(id);
|
|||
|
|
|
|||
|
|
ALTER TABLE `auth_user_groups`
|
|||
|
|
ADD CONSTRAINT `auth_user_groups_user_id_6a12ed8b_fk_auth_user_id` FOREIGN KEY (user_id)
|
|||
|
|
REFERENCES auth_user(id);
|