Skip to main content

user-roles

SQL​

-- Modify only this SQL create table statement and nothing else
CREATE TABLE usersRoles (
  userId INTEGER NOT NULL,
  roleId INTEGER NOT NULL,
  FOREIGN KEY (userId) REFERENCES users(id),
  FOREIGN KEY (roleId) REFERENCES roles(id),
  CONSTRAINT uc_user_role UNIQUE (userId,roleId)
);