· 6 years ago · Mar 12, 2019, 05:18 PM
1 String sb = ("create table if not exists `" + MySQLSettings.MySQLUsersTableName + "` (") +
2 "`id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT, " +
3 "`uuid` text not null, " +
4 "`firstName` varchar(16) not null, " +
5 "`lastName` varchar(16) not null, " +
6 "`groupType` text not null, " +
7 "`rank` int not null, " +
8 "`kills` int not null, " +
9 "`deaths` int not null, " +
10 "`assists` int not null, " +
11 "`protTime` bigint not null, " +
12 "`namemc` text not null, " +
13 "`kitVipTime` bigint not null, " +
14 "`kitYouTubeTime` bigint not null, " +
15 "`diggingLevel` int not null, " +
16 "`diggingExp` int not null, " +
17 "`turboDrop` bigint not null, " +
18 "`turboExp` bigint not null, " +
19 "`depositKoks` int not null, " +
20 "`depositRefil` int not null, " +
21 "`depositPearl` int not null, " +
22 "`minedStone` int not null, " +
23 "`consumedKox` int not null, " +
24 "`consumedRef` int not null, " +
25 "`minedObsidian` int not null, " +
26 "`firstJoin` bigint not null, " +
27 "`homeX` int not null, " +
28 "`homeY` int not null, " +
29 "`homeZ` int not null, " +
30 "`incognito` text not null, " +
31 "`boughtKeys` int not null, " +
32 "`lastJoin` bigint not null, " +
33 "`timePlayed` int not null, " +
34 "`blockPlaced` int not null, " +
35 "`depositGoldOre` int not null, "+
36 "`awards_stone` text not null, "+
37 "`awards_place` text not null, "+
38 "`awards_distance` text not null, "+
39 "`awards_time` text not null, "+
40 "`awards_case` text not null, "+
41 "`awards_kills` text not null, "+
42 "`awards_obs` text not null, "+
43 "`awards_cx` text not null, "+
44 "`awards_kox` text not null, "+
45 "`distance` int not null, "+
46 "`caseOpen` int not null, "+
47 "`cxOpen` int not null);";
48 Main.dataBaseInterface.update(true, sb);