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;