· 6 years ago · Jul 03, 2019, 06:50 PM
1CREATE TABLE IF NOT EXISTS `player_skills` (
2 `player_id` int(11) NOT NULL,
3 `skill_spending_points` int(10) unsigned NOT NULL DEFAULT 0,
4 `vitality_level` int(10) unsigned NOT NULL DEFAULT 0,
5 `energy_level` int(10) unsigned NOT NULL DEFAULT 0,
6 `agility_level` int(10) unsigned NOT NULL DEFAULT 0,
7 `luck_level` int(10) unsigned NOT NULL DEFAULT 0,
8 FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
9) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8;