· 6 years ago · Jul 03, 2019, 05:12 PM
1CREATE TABLE IF NOT EXISTS `pokemons` (
2 `id` int(11) NOT NULL,
3 `player_id` int(11) NOT NULL,
4 `name` varchar(255) NOT NULL,
5 `nick` varchar(255) NOT NULL,
6 `gender` int(11) NOT NULL DEFAULT '0',
7 `health` int(11) NOT NULL DEFAULT '150',
8 `level` int(11) NOT NULL DEFAULT '1',
9 `boost` int(11) NOT NULL DEFAULT '1',
10 `experience` bigint(20) NOT NULL DEFAULT '0',
11 `ivs` varchar(255) NOT NULL,
12 `skills` varchar(255) NOT NULL,
13 `spells` varchar(255) NOT NULL,
14 `conditions`` varchar(255) NOT NULL,
15 FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
16) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8;