331zcBF2

1CREATE TABLE IF NOT EXISTS `player_knows` (
2  `player_id` int(11) NOT NULL,
3  `caught_exp` bigint(20) unsigned NOT NULL DEFAULT 0,
4  `caught_level` int(10) unsigned NOT NULL DEFAULT 0,
5  FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
6) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8;
7
8CREATE TABLE IF NOT EXISTS `player_professions` (
9  `player_id` int(11) NOT NULL,
10  `fishing_exp` bigint(20) unsigned NOT NULL DEFAULT 0,
11  `fishing_level` int(10) unsigned NOT NULL DEFAULT 0,
12  `adventurer_exp` bigint(20) unsigned NOT NULL DEFAULT 0,
13  `adventurer_level` int(10) unsigned NOT NULL DEFAULT 0,
14  `professor_exp` bigint(20) unsigned NOT NULL DEFAULT 0,
15  `professor_level` int(10) unsigned NOT NULL DEFAULT 0,
16  `stylist_exp` bigint(20) unsigned NOT NULL DEFAULT 0,
17  `stylist_level` int(10) unsigned NOT NULL DEFAULT 0,
18  FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
19) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8;