ZkG56jH7

1/*  User role table */
2CREATE TABLE IF NOT EXISTS user_role (
3  user_id INT NULL ,
4  role_id INT NULL ,
5  CONSTRAINT user_role_user_id_fk
6  FOREIGN KEY (user_id) REFERENCES user (id),
7  CONSTRAINT user_role_role_id_fk
8  FOREIGN KEY (role_id) REFERENCES role (id)
9)
10  ENGINE=InnoDB;
11
12CREATE INDEX user_role_role_id_fk ON user_role (role_id);
13
14CREATE INDEX user_role_user_id_fk ON user_role (user_id);