· 9 years ago · Dec 09, 2016, 06:36 PM
1CREATE TABLE IF NOT EXISTS `pk_drop` (
2 `id` int(10) NOT NULL AUTO_INCREMENT,
3 `uuid` varchar(36) NOT NULL,
4 `lastName` varchar(16) NOT NULL,
5 `expireTime` bigint(13) NOT NULL,
6 `turbodrop` int(10) NOT NULL,
7 `bonusdrop` int(10) NOT NULL,
8 `lvl` int(10) NOT NULL,
9 `exp` int(10) NOT NULL,
10 `diamenty` int(10) NOT NULL,
11 `szmaragdy` int(10) NOT NULL,
12 `zloto` int(10) NOT NULL,
13 `zelazo` int(10) NOT NULL,
14 `piasek` int(10) NOT NULL,
15 `wegiel` int(10) NOT NULL,
16 `redstone` int(10) NOT NULL,
17 `lapis` int(10) NOT NULL,
18 `proch` int(10) NOT NULL,
19 `perly` int(10) NOT NULL,
20 `slimeball` int(10) NOT NULL,
21 `jablka` int(10) NOT NULL,
22 `ksiazki` int(10) NOT NULL,
23 `skrzynki` int(10) NOT NULL,
24 `coinsy` int(10) NOT NULL,
25 `cobble` int(10) NOT NULL,
26 PRIMARY KEY (`uuid`),
27 UNIQUE KEY `id` (`id`)
28);