pc9CJuU7

1StringBuilder stringBuilder = new StringBuilder();
2
3        stringBuilder.append("CREATE TABLE IF NOT EXISTS `{P}users`");
4        stringBuilder.append("(`id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,");
5        stringBuilder.append("`name` varchar(32) NOT NULL,");
6        stringBuilder.append("`points` int(11) NOT NULL,");
7        stringBuilder.append("`kills` int(11) NOT NULL,");
8        stringBuilder.append("`deaths` int(11) NOT NULL,");
9        stringBuilder.append("`asyst` int(11) NOT NULL,");
10        stringBuilder.append("`logout` int(11) NOT NULL,");
11        stringBuilder.append("`kox` int(11) NOT NULL,");
12        stringBuilder.append("`koxeat int(11) NOT NULL,");
13        stringBuilder.append("`refil int(11) NOT NULL,");
14        stringBuilder.append("`refileat int(11) NOT NULL,");
15        stringBuilder.append("`perly int(11) NOT NULL,");
16        stringBuilder.append("`perlycyk int(11) NOT NULL,");
17        stringBuilder.append("`strzaly int(11) NOT NULL,");
18        stringBuilder.append("`caseopen int(11) NOT NULL,");
19        stringBuilder.append("`jajopen int(11) NOT NULL,");
20        stringBuilder.append("`zdrapkaopen int(11) NOT NULL,");
21        stringBuilder.append("`cobblexopen int(11) NOT NULL,");
22        stringBuilder.append("`join int(11) NOT NULL,");
23        stringBuilder.append("`time` bigint(22) NOT NULL,");
24        stringBuilder.append("`timelast` bigint(22) NOT NULL,");
25        stringBuilder.append("`firstIP` varchar(64) NOT NULL,");
26        stringBuilder.append("`lastIP` varchar(64) NOT NULL,");
27        stringBuilder.append("`firstJoin` bigint(22) NOT NULL,");
28        stringBuilder.append("`kit_start` bigint(64) NOT NULL,");
29        stringBuilder.append("`kit_yt` bigint(22) NOT NULL,");
30        stringBuilder.append("`kit_tw` bigint(22) NOT NULL,");
31        stringBuilder.append("`kit_vip` bigint(22) NOT NULL,");
32        stringBuilder.append("`kit_svip` bigint(22) NOT NULL,");
33        stringBuilder.append("`turboDrop` bigint(22) NOT NULL,");
34        stringBuilder.append("`turboExp` bigint(22) NOT NULL,");
35        stringBuilder.append("`home` varchar(255) NOT NULL,");
36        stringBuilder.append("`lastKill` varchar(32) NOT NULL,");
37        stringBuilder.append("`lastKillTime` bigint(22) NOT NULL,");
38        stringBuilder.append("`god` int(1) NOT NULL,");
39        stringBuilder.append("`lvl` int(11) NOT NULL,");
40        stringBuilder.append("`exp` int(11) NOT NULL);");
41
42z
43
44store.update(true, "CREATE TABLE IF NOT EXISTS `{P}users` (" + (store.getStoreMode() == StoreMode.MYSQL ? "`id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT," : "`id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,") + "`name` varchar(32) NOT NULL,`points` int(11) NOT NULL,`coins` int(11) NOT NULL, `kills` int(11) NOT NULL, `deaths` int(11) NOT NULL, `asyst` int(11) NOT NULL, `logout` int(11) NOT NULL, `kox` int(11) NOT NULL, `koxeat` int(11) NOT NULL, `refil` int(11) NOT NULL, `refileat` int(11) NOT NULL, `perly` int(11) NOT NULL, `perlycyk` int(11) NOT NULL, `strzaly` int(11) NOT NULL, `caseopen` int(11) NOT NULL, `jajopen` int(11) NOT NULL, `zdrapkaopen` int(11) NOT NULL, `cobblexopen` int(11) NOT NULL, `join` int(11) NOT NULL, `time` bigint(22) NOT NULL, `timelast` bigint(22) NOT NULL, " + "`firstIP` varchar(64) NOT NULL, `lastIP` varchar(64) NOT NULL, `firstJoin` bigint(22) NOT NULL, `kit_start` bigint(64) NOT NULL, `kit_yt` bigint(22) NOT NULL, `kit_tw` bigint(22) NOT NULL, " + "`kit_vip` bigint(22) NOT NULL, `kit_svip` bigint(22) NOT NULL, `turboDrop` bigint(22) NOT NULL, `turboExp` bigint(22) NOT NULL, `home` varchar(255) NOT NULL, `lastKill` varchar(32) NOT NULL, `lastKillTime` bigint(22) NOT NULL, `god` int(1) NOT NULL, `lvl` int(11) NOT NULL, `exp` int(11) NOT NULL);");