9 lines
326 B
SQL
9 lines
326 B
SQL
CREATE TABLE IF NOT EXISTS `user_skills` (
|
|
`id` INT AUTO_INCREMENT PRIMARY KEY,
|
|
`user_id` int(11) unsigned NOT NULL,
|
|
`skill_id` int(11) NOT NULL,
|
|
`progress` INT DEFAULT 0,
|
|
FOREIGN KEY (user_id) REFERENCES users(id),
|
|
FOREIGN KEY (skill_id) REFERENCES skills(id)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
|