· 9 years ago · Dec 04, 2016, 06:26 PM
1Skip to content
2Personal Open source Business Explore
3Sign upSign inPricingBlogSupport
4This repository
5Search
6 Watch 3 Star 3 Fork 2 Kondi60PL/Pluginy-Minecraft-Bukkit
7 Code Issues 0 Pull requests 0 Projects 0 Pulse Graphs
8Branch: master Find file Copy pathPluginy-Minecraft-Bukkit/Wszystkie pluginy [1]/myhard tabele.sql
988c0568 on 3 Apr 2015
10@Kondi60PL Kondi60PL Pluginy
111 contributor
12RawBlameHistory
13189 lines (171 sloc) 5.4 KB
14CREATE TABLE IF NOT EXISTS `accounts` (
15 `id` int(11) NOT NULL AUTO_INCREMENT,
16 `uuid` varchar(36) NOT NULL,
17 `nick` varchar(255) NOT NULL,
18 `password` varchar(255) DEFAULT NULL,
19 `lastIp` varchar(255) NOT NULL,
20 `firstIP` varchar(255) NOT NULL,
21 `premium` int(1) NOT NULL,
22 `lastPlayed` bigint(255) NOT NULL,
23 `firstPlayed` bigint(255) NOT NULL,
24 PRIMARY KEY (`id`)
25);
26
27
28CREATE TABLE IF NOT EXISTS `deaths` (
29 `id` int(10) NOT NULL AUTO_INCREMENT,
30 `player` varchar(32) NOT NULL,
31 `killer` varchar(32) NOT NULL,
32 `time` bigint(20) NOT NULL,
33 PRIMARY KEY (`id`)
34);
35
36CREATE TABLE IF NOT EXISTS `st_alliances` (
37 `id` int(10) NOT NULL AUTO_INCREMENT,
38 `guild_1` varchar(4) NOT NULL,
39 `guild_2` varchar(4) NOT NULL,
40 PRIMARY KEY (`id`)
41);
42
43
44CREATE TABLE IF NOT EXISTS `st_guilds` (
45 `id` int(10) NOT NULL AUTO_INCREMENT,
46 `tag` varchar(4) COLLATE utf8_polish_ci NOT NULL,
47 `name` varchar(32) COLLATE utf8_polish_ci NOT NULL,
48 `owner` varchar(36) COLLATE utf8_polish_ci NOT NULL,
49 `leader` varchar(36) COLLATE utf8_polish_ci NOT NULL,
50 `cuboidWorld` varchar(32) COLLATE utf8_polish_ci NOT NULL,
51 `cuboidX` int(10) NOT NULL,
52 `cuboidZ` int(10) NOT NULL,
53 `cuboidSize` int(10) NOT NULL,
54 `homeWorld` varchar(32) COLLATE utf8_polish_ci NOT NULL,
55 `homeX` int(10) NOT NULL,
56 `homeY` int(10) NOT NULL,
57 `homeZ` int(10) NOT NULL,
58 `createTime` bigint(13) NOT NULL DEFAULT '0',
59 `expireTime` bigint(13) NOT NULL DEFAULT '0',
60 `pvp` int(1) NOT NULL DEFAULT '0',
61 PRIMARY KEY (`id`)
62);
63
64CREATE TABLE IF NOT EXISTS `st_admin_logs` (
65 `id` int(10) NOT NULL AUTO_INCREMENT,
66 `uuid` varchar(36) NOT NULL,
67 `time` bigint(13) NOT NULL,
68 `command` varchar(255) NOT NULL,
69 PRIMARY KEY (`id`)
70);
71
72CREATE TABLE IF NOT EXISTS `st_backups` (
73 `id` int(10) NOT NULL AUTO_INCREMENT,
74 `uuid` varchar(36) NOT NULL,
75 `time` bigint(13) NOT NULL,
76 `armor` text NOT NULL,
77 `inventory` text NOT NULL,
78 `enderchest` text NOT NULL,
79 `location` varchar(255) NOT NULL DEFAULT '',
80 PRIMARY KEY (`id`,`uuid`)
81);
82
83CREATE TABLE IF NOT EXISTS `st_backups` (
84 `id` int(10) NOT NULL AUTO_INCREMENT,
85 `uuid` varchar(36) NOT NULL,
86 `time` bigint(13) NOT NULL,
87 `armor` text NOT NULL,
88 `inventory` text NOT NULL,
89 `enderchest` text NOT NULL,
90 `location` varchar(255) NOT NULL DEFAULT '',
91 PRIMARY KEY (`id`,`uuid`)
92);
93
94CREATE TABLE IF NOT EXISTS `st_bans` (
95 `id` int(10) NOT NULL AUTO_INCREMENT,
96 `uuid` varchar(36) NOT NULL,
97 `admin` varchar(255) NOT NULL,
98 `reason` varchar(255) CHARACTER SET utf8 COLLATE utf8_polish_ci NOT NULL,
99 `createTime` bigint(13) NOT NULL,
100 `expireTime` bigint(13) NOT NULL DEFAULT '0',
101 `unban` int(1) NOT NULL DEFAULT '0',
102 PRIMARY KEY (`id`),
103 UNIQUE KEY `id` (`id`,`uuid`)
104);
105
106CREATE TABLE IF NOT EXISTS `st_blacklisted` (
107 `id` int(10) NOT NULL AUTO_INCREMENT,
108 `uuid` varchar(36) NOT NULL,
109 `reason` varchar(255) CHARACTER SET utf8 COLLATE utf8_polish_ci NOT NULL,
110 PRIMARY KEY (`id`)
111);
112
113CREATE TABLE IF NOT EXISTS `st_codes` (
114 `id` int(10) NOT NULL AUTO_INCREMENT,
115 `code` varchar(8) NOT NULL,
116 `time` bigint(13) NOT NULL DEFAULT '0',
117 `nick` varchar(16) DEFAULT NULL,
118 PRIMARY KEY (`id`),
119 UNIQUE KEY `code` (`code`)
120);
121
122CREATE TABLE IF NOT EXISTS `st_hardcore` (
123 `id` int(11) NOT NULL AUTO_INCREMENT,
124 `uuid` varchar(255) NOT NULL,
125 `ban_start_time` bigint(255) NOT NULL,
126 `ban_end_time` bigint(255) NOT NULL,
127 `desc` varchar(255) NOT NULL,
128 `ip` varchar(255) NOT NULL,
129 `unban` int(1) NOT NULL,
130 PRIMARY KEY (`id`)
131);
132
133CREATE TABLE IF NOT EXISTS `st_ipbans` (
134 `id` int(10) NOT NULL AUTO_INCREMENT,
135 `ip` varchar(32) NOT NULL,
136 `admin` varchar(255) NOT NULL,
137 `reason` varchar(255) CHARACTER SET utf8 COLLATE utf8_polish_ci NOT NULL,
138 `createTime` bigint(13) NOT NULL,
139 `expireTime` bigint(13) NOT NULL DEFAULT '0',
140 `unban` int(1) NOT NULL DEFAULT '0',
141 PRIMARY KEY (`id`),
142 UNIQUE KEY `id` (`id`,`ip`)
143);
144
145CREATE TABLE IF NOT EXISTS `st_members` (
146 `id` int(10) NOT NULL AUTO_INCREMENT,
147 `uuid` varchar(36) COLLATE utf8_polish_ci NOT NULL,
148 `tag` varchar(4) COLLATE utf8_polish_ci NOT NULL,
149 PRIMARY KEY (`id`),
150 UNIQUE KEY `uuid` (`uuid`)
151);
152
153CREATE TABLE IF NOT EXISTS `st_ubcodes` (
154 `id` int(10) NOT NULL AUTO_INCREMENT,
155 `code` varchar(16) NOT NULL,
156 `nickname` varchar(32) DEFAULT NULL,
157 `time` bigint(13) NOT NULL DEFAULT '-1',
158 `used` int(1) NOT NULL DEFAULT '0',
159 PRIMARY KEY (`id`),
160 UNIQUE KEY `code` (`code`)
161);
162
163CREATE TABLE IF NOT EXISTS `st_unbanlogs` (
164 `id` int(11) NOT NULL AUTO_INCREMENT,
165 `nick` varchar(32) NOT NULL,
166 `time` bigint(20) NOT NULL,
167 `code` varchar(16) NOT NULL,
168 PRIMARY KEY (`id`)
169);
170
171CREATE TABLE IF NOT EXISTS `st_users` (
172 `id` int(10) NOT NULL AUTO_INCREMENT,
173 `uuid` varchar(36) NOT NULL,
174 `lastName` varchar(16) NOT NULL,
175 `gamemode` int(1) NOT NULL,
176 `fly` int(1) NOT NULL,
177 `god` int(1) NOT NULL,
178 `lastWorld` varchar(32) NOT NULL,
179 `lastX` int(10) NOT NULL,
180 `lastY` int(10) NOT NULL,
181 `lastZ` int(10) NOT NULL,
182 `homeWorld` varchar(32) NOT NULL,
183 `homeX` int(10) NOT NULL,
184 `homeY` int(10) NOT NULL,
185 `homeZ` int(10) NOT NULL,
186 `kills` int(10) NOT NULL,
187 `deaths` int(10) NOT NULL,
188 `logouts` int(10) NOT NULL,
189 `points` int(10) NOT NULL,
190 `timePlay` int(10) NOT NULL,
191 `firstIp` varchar(32) NOT NULL,
192 `lastIp` varchar(32) NOT NULL,
193 PRIMARY KEY (`uuid`),
194 UNIQUE KEY `id` (`id`)
195);
196
197CREATE TABLE IF NOT EXISTS `st_whitelisted` (
198 `id` int(10) NOT NULL AUTO_INCREMENT,
199 `uuid` varchar(36) NOT NULL,
200 PRIMARY KEY (`id`),
201 UNIQUE KEY `uuid` (`uuid`)
202);
203Contact GitHub API Training Shop Blog About
204© 2016 GitHub, Inc. Terms Privacy Security Status Help