· 8 years ago · Dec 26, 2017, 12:54 PM
1
2SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
3SET time_zone = "+00:00";
4
5
6/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
7/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
8/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
9/*!40101 SET NAMES utf8 */;
10
11--
12-- Baza danych: `XXXXXXXXXXXXXXXXXXXX`
13--
14
15-- --------------------------------------------------------
16
17--
18-- Struktura tabeli dla tabeli `admin`
19--
20
21CREATE TABLE IF NOT EXISTS `admin` (
22 `id` int(11) NOT NULL,
23 `type` text NOT NULL,
24 `val1` text CHARACTER SET utf8 COLLATE utf8_hungarian_ci NOT NULL,
25 `val2` text CHARACTER SET utf8 COLLATE utf8_hungarian_ci NOT NULL,
26 `val3` bigint(20) NOT NULL DEFAULT '0'
27) ENGINE=InnoDB DEFAULT CHARSET=latin1;
28
29-- --------------------------------------------------------
30
31--
32-- Struktura tabeli dla tabeli `ajaxchat`
33--
34
35CREATE TABLE IF NOT EXISTS `ajaxchat` (
36 `id` int(11) unsigned NOT NULL,
37 `user` varchar(50) CHARACTER SET utf8 COLLATE utf8_polish_ci NOT NULL,
38 `message` text CHARACTER SET utf8 COLLATE utf8_polish_ci NOT NULL,
39 `time` bigint(20) NOT NULL,
40 `user_id` int(10) NOT NULL
41) ENGINE=MyISAM DEFAULT CHARSET=utf8;
42
43-- --------------------------------------------------------
44
45--
46-- Struktura tabeli dla tabeli `cert`
47--
48
49CREATE TABLE IF NOT EXISTS `cert` (
50 `id` int(11) NOT NULL,
51 `ip` text NOT NULL,
52 `time` int(11) NOT NULL
53) ENGINE=InnoDB DEFAULT CHARSET=latin1;
54
55-- --------------------------------------------------------
56
57--
58-- Struktura tabeli dla tabeli `copycats`
59--
60
61CREATE TABLE IF NOT EXISTS `copycats` (
62 `ID` int(11) NOT NULL,
63 `owner` int(11) NOT NULL,
64 `lvl` smallint(6) NOT NULL DEFAULT '150',
65 `class` tinyint(4) NOT NULL,
66 `str` mediumint(9) NOT NULL,
67 `dex` mediumint(9) NOT NULL,
68 `intel` mediumint(9) NOT NULL,
69 `wit` mediumint(9) NOT NULL,
70 `luck` mediumint(9) NOT NULL DEFAULT '547'
71) ENGINE=MyISAM DEFAULT CHARSET=utf8;
72
73-- --------------------------------------------------------
74
75--
76-- Struktura tabeli dla tabeli `fortress`
77--
78
79CREATE TABLE IF NOT EXISTS `fortress` (
80 `fortressID` int(11) NOT NULL,
81 `owner` int(11) NOT NULL,
82 `stone` int(11) NOT NULL DEFAULT '0',
83 `wood` int(11) NOT NULL DEFAULT '0',
84 `u1` tinyint(2) NOT NULL DEFAULT '0',
85 `u2` tinyint(4) NOT NULL DEFAULT '0',
86 `u3` tinyint(4) NOT NULL DEFAULT '0',
87 `ul1` tinyint(4) NOT NULL DEFAULT '1',
88 `ul2` tinyint(4) DEFAULT '1',
89 `ul3` tinyint(4) NOT NULL DEFAULT '1',
90 `ut1` tinyint(4) NOT NULL DEFAULT '0',
91 `ut2` tinyint(4) NOT NULL DEFAULT '0',
92 `ut3` tinyint(4) NOT NULL DEFAULT '0',
93 `uttime1` int(11) NOT NULL DEFAULT '0',
94 `uttime2` int(11) NOT NULL DEFAULT '0',
95 `uttime3` int(11) NOT NULL DEFAULT '0',
96 `enemyid` int(11) NOT NULL DEFAULT '0',
97 `enemytime` int(11) NOT NULL DEFAULT '0',
98 `build_id` tinyint(4) NOT NULL DEFAULT '0',
99 `build_start` int(11) NOT NULL DEFAULT '0',
100 `build_end` int(11) NOT NULL DEFAULT '0',
101 `dig_start` int(11) NOT NULL DEFAULT '0',
102 `dig_end` int(11) NOT NULL DEFAULT '0',
103 `gather1` int(11) NOT NULL DEFAULT '0',
104 `gather2` int(11) NOT NULL DEFAULT '0',
105 `gather3` int(11) NOT NULL DEFAULT '0',
106 `hok` tinyint(4) NOT NULL DEFAULT '0',
107 `b0` tinyint(4) NOT NULL DEFAULT '0',
108 `b1` tinyint(4) NOT NULL DEFAULT '0',
109 `b2` tinyint(4) NOT NULL DEFAULT '0',
110 `b3` tinyint(4) NOT NULL DEFAULT '0',
111 `b4` tinyint(4) NOT NULL DEFAULT '0',
112 `b5` tinyint(4) NOT NULL DEFAULT '0',
113 `b6` tinyint(4) NOT NULL DEFAULT '0',
114 `b7` tinyint(4) NOT NULL DEFAULT '0',
115 `b8` tinyint(4) NOT NULL DEFAULT '0',
116 `b9` tinyint(4) NOT NULL DEFAULT '0',
117 `b10` tinyint(4) NOT NULL DEFAULT '0',
118 `b11` tinyint(4) NOT NULL DEFAULT '0'
119) ENGINE=MyISAM DEFAULT CHARSET=utf8;
120
121-- --------------------------------------------------------
122
123--
124-- Struktura tabeli dla tabeli `guildchat`
125--
126
127CREATE TABLE IF NOT EXISTS `guildchat` (
128 `ID` int(11) NOT NULL,
129 `guildID` int(11) NOT NULL,
130 `playerID` int(11) NOT NULL,
131 `message` char(255) NOT NULL,
132 `time` int(11) NOT NULL,
133 `chattime` int(11) NOT NULL,
134 `spec` tinyint(3) NOT NULL DEFAULT '0'
135) ENGINE=MyISAM DEFAULT CHARSET=utf8;
136
137-- --------------------------------------------------------
138
139--
140-- Struktura tabeli dla tabeli `guildfightlogs`
141--
142
143CREATE TABLE IF NOT EXISTS `guildfightlogs` (
144 `ID` int(11) NOT NULL,
145 `guildAttacker` int(11) NOT NULL,
146 `guildDefender` int(11) NOT NULL,
147 `log` mediumtext NOT NULL,
148 `time` int(11) NOT NULL
149) ENGINE=MyISAM DEFAULT CHARSET=utf8;
150
151-- --------------------------------------------------------
152
153--
154-- Struktura tabeli dla tabeli `guildfights`
155--
156
157CREATE TABLE IF NOT EXISTS `guildfights` (
158 `ID` int(11) NOT NULL,
159 `guildAttacker` int(11) NOT NULL,
160 `guildDefender` int(11) NOT NULL,
161 `time` int(11) NOT NULL
162) ENGINE=MyISAM DEFAULT CHARSET=utf8;
163
164-- --------------------------------------------------------
165
166--
167-- Struktura tabeli dla tabeli `guildinvites`
168--
169
170CREATE TABLE IF NOT EXISTS `guildinvites` (
171 `ID` int(11) NOT NULL,
172 `guildID` int(11) NOT NULL,
173 `playerID` int(11) NOT NULL
174) ENGINE=MyISAM DEFAULT CHARSET=utf8;
175
176-- --------------------------------------------------------
177
178--
179-- Struktura tabeli dla tabeli `guilds`
180--
181
182CREATE TABLE IF NOT EXISTS `guilds` (
183 `ID` int(11) NOT NULL,
184 `name` char(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
185 `base` tinyint(4) NOT NULL DEFAULT '10',
186 `treasure` int(11) NOT NULL DEFAULT '0',
187 `instructor` int(11) NOT NULL DEFAULT '0',
188 `silver` int(11) NOT NULL DEFAULT '1000',
189 `mush` int(11) NOT NULL DEFAULT '0',
190 `honor` int(11) NOT NULL DEFAULT '100',
191 `portal` tinyint(4) NOT NULL DEFAULT '0',
192 `portal_hp` bigint(20) NOT NULL DEFAULT '1003472384',
193 `dungeon` tinyint(4) NOT NULL DEFAULT '0',
194 `attack_init` int(11) NOT NULL DEFAULT '0',
195 `event_trigger_count` int(11) NOT NULL DEFAULT '0',
196 `descr` text NOT NULL,
197 `catapult` tinyint(1) NOT NULL DEFAULT '0'
198) ENGINE=MyISAM DEFAULT CHARSET=utf8;
199
200-- --------------------------------------------------------
201
202--
203-- Struktura tabeli dla tabeli `items`
204--
205
206CREATE TABLE IF NOT EXISTS `items` (
207 `ID` int(11) NOT NULL,
208 `owner` int(11) NOT NULL,
209 `slot` int(11) NOT NULL,
210 `type` int(11) NOT NULL,
211 `item_id` int(11) NOT NULL,
212 `dmg_min` int(11) NOT NULL DEFAULT '0',
213 `dmg_max` int(11) NOT NULL DEFAULT '0',
214 `a1` int(11) NOT NULL DEFAULT '0',
215 `a2` int(11) NOT NULL DEFAULT '0',
216 `a3` int(11) NOT NULL DEFAULT '0',
217 `a4` int(11) NOT NULL DEFAULT '0',
218 `a5` int(11) NOT NULL DEFAULT '0',
219 `a6` int(11) DEFAULT '0',
220 `value_silver` int(11) NOT NULL,
221 `value_mush` int(11) NOT NULL DEFAULT '0'
222) ENGINE=MyISAM DEFAULT CHARSET=utf8;
223
224-- --------------------------------------------------------
225
226--
227-- Struktura tabeli dla tabeli `messages`
228--
229
230CREATE TABLE IF NOT EXISTS `messages` (
231 `ID` int(11) NOT NULL,
232 `sender` int(11) NOT NULL,
233 `reciver` int(11) NOT NULL,
234 `time` int(11) NOT NULL,
235 `topic` char(255) NOT NULL DEFAULT '',
236 `message` text NOT NULL,
237 `hasRead` tinyint(1) NOT NULL DEFAULT '0'
238) ENGINE=MyISAM DEFAULT CHARSET=utf8;
239
240-- --------------------------------------------------------
241
242--
243-- Struktura tabeli dla tabeli `playerfightlogs`
244--
245
246CREATE TABLE IF NOT EXISTS `playerfightlogs` (
247 `ID` int(11) NOT NULL,
248 `attacker` int(11) NOT NULL,
249 `defender` int(11) NOT NULL,
250 `log` mediumtext NOT NULL,
251 `time` int(11) NOT NULL
252) ENGINE=MyISAM DEFAULT CHARSET=utf8;
253
254-- --------------------------------------------------------
255
256--
257-- Struktura tabeli dla tabeli `players`
258--
259
260CREATE TABLE IF NOT EXISTS `players` (
261 `ID` int(11) NOT NULL,
262 `name` char(26) NOT NULL,
263 `password` text CHARACTER SET latin1 NOT NULL,
264 `ip` text NOT NULL,
265 `banned` tinyint(1) NOT NULL DEFAULT '0',
266 `email` text NOT NULL,
267 `gframe` tinyint(1) NOT NULL DEFAULT '0',
268 `perm` tinyint(3) NOT NULL DEFAULT '0',
269 `face` char(32) CHARACTER SET latin1 NOT NULL,
270 `description` text NOT NULL,
271 `newday` bigint(20) NOT NULL DEFAULT '0',
272 `ssid` char(32) CHARACTER SET latin1 NOT NULL,
273 `randpw` text NOT NULL,
274 `rand2` text NOT NULL,
275 `wheelcounts` int(11) NOT NULL DEFAULT '0',
276 `newwheel` bigint(20) NOT NULL DEFAULT '0',
277 `poll` int(11) NOT NULL DEFAULT '0',
278 `lvl` smallint(6) NOT NULL DEFAULT '1',
279 `exp` bigint(20) unsigned NOT NULL DEFAULT '0',
280 `quest_dur1` smallint(6) NOT NULL,
281 `quest_dur2` smallint(6) NOT NULL,
282 `quest_dur3` smallint(6) NOT NULL,
283 `quest_exp1` bigint(20) NOT NULL,
284 `quest_exp2` bigint(20) NOT NULL,
285 `quest_exp3` bigint(20) NOT NULL,
286 `quest_silver1` bigint(20) NOT NULL,
287 `quest_silver2` bigint(20) NOT NULL,
288 `quest_silver3` bigint(20) NOT NULL,
289 `str` smallint(6) NOT NULL DEFAULT '10',
290 `dex` smallint(6) NOT NULL DEFAULT '10',
291 `intel` smallint(6) NOT NULL DEFAULT '10',
292 `wit` smallint(6) NOT NULL DEFAULT '10',
293 `luck` smallint(6) NOT NULL DEFAULT '10',
294 `potion_type1` tinyint(4) NOT NULL DEFAULT '0',
295 `potion_type2` tinyint(4) NOT NULL DEFAULT '0',
296 `potion_type3` tinyint(4) NOT NULL DEFAULT '0',
297 `potion_dur1` int(11) NOT NULL DEFAULT '0',
298 `potion_dur2` int(11) NOT NULL DEFAULT '0',
299 `potion_dur3` int(11) NOT NULL DEFAULT '0',
300 `silver` bigint(20) NOT NULL DEFAULT '100',
301 `mush` int(11) NOT NULL DEFAULT '20000',
302 `thirst` smallint(5) NOT NULL DEFAULT '6000',
303 `beers` tinyint(4) NOT NULL DEFAULT '0',
304 `honor` bigint(20) NOT NULL DEFAULT '100',
305 `race` tinyint(1) NOT NULL,
306 `gender` tinyint(1) NOT NULL,
307 `class` tinyint(1) NOT NULL,
308 `mount` tinyint(4) NOT NULL DEFAULT '0',
309 `mount_time` int(11) NOT NULL DEFAULT '0',
310 `album` smallint(6) NOT NULL DEFAULT '-1',
311 `album_data` varchar(1024) CHARACTER SET latin1 NOT NULL,
312 `status` tinyint(4) NOT NULL DEFAULT '0',
313 `status_extra` tinyint(4) NOT NULL DEFAULT '0',
314 `status_time` int(11) NOT NULL DEFAULT '0',
315 `dungeon_time` int(11) NOT NULL DEFAULT '0',
316 `arena_time` int(11) NOT NULL DEFAULT '0',
317 `arena_nme1` int(11) NOT NULL DEFAULT '0',
318 `arena_nme2` int(11) NOT NULL DEFAULT '0',
319 `arena_nme3` int(11) NOT NULL DEFAULT '0',
320 `tower` tinyint(4) NOT NULL DEFAULT '0',
321 `wcaura` smallint(6) NOT NULL DEFAULT '1',
322 `wcexp` smallint(6) NOT NULL DEFAULT '0',
323 `wcdate` int(11) NOT NULL DEFAULT '0',
324 `portal` tinyint(4) NOT NULL DEFAULT '0',
325 `portal_hp` bigint(20) NOT NULL DEFAULT '35938800',
326 `portal_time` smallint(6) NOT NULL DEFAULT '0',
327 `gportal_time` int(11) NOT NULL DEFAULT '0',
328 `guild` int(11) NOT NULL DEFAULT '0',
329 `guild_rank` tinyint(4) NOT NULL DEFAULT '3',
330 `guild_fight` tinyint(4) NOT NULL DEFAULT '0',
331 `event_trigger_count` int(11) NOT NULL DEFAULT '0',
332 `d1` tinyint(4) NOT NULL DEFAULT '2',
333 `d2` tinyint(4) DEFAULT '2',
334 `d3` tinyint(4) NOT NULL DEFAULT '2',
335 `d4` tinyint(4) NOT NULL DEFAULT '2',
336 `d5` tinyint(4) NOT NULL DEFAULT '2',
337 `d6` tinyint(4) NOT NULL DEFAULT '2',
338 `d7` tinyint(4) NOT NULL DEFAULT '2',
339 `d8` tinyint(4) NOT NULL DEFAULT '2',
340 `d9` tinyint(4) NOT NULL DEFAULT '2',
341 `d10` tinyint(4) NOT NULL DEFAULT '2',
342 `d11` tinyint(4) NOT NULL DEFAULT '2',
343 `d12` tinyint(4) NOT NULL DEFAULT '2',
344 `d13` tinyint(4) NOT NULL DEFAULT '2',
345 `d14` tinyint(4) NOT NULL DEFAULT '2',
346 `dd1` tinyint(4) NOT NULL DEFAULT '2',
347 `dd2` tinyint(4) NOT NULL DEFAULT '2',
348 `dd3` tinyint(4) NOT NULL DEFAULT '2',
349 `dd4` tinyint(4) NOT NULL DEFAULT '2',
350 `dd5` tinyint(4) NOT NULL DEFAULT '2',
351 `dd6` tinyint(4) NOT NULL DEFAULT '2',
352 `dd7` tinyint(4) NOT NULL DEFAULT '2',
353 `dd8` tinyint(4) NOT NULL DEFAULT '2',
354 `dd9` tinyint(4) NOT NULL DEFAULT '2',
355 `dd10` tinyint(4) NOT NULL DEFAULT '2',
356 `dd11` tinyint(4) NOT NULL DEFAULT '2',
357 `dd12` tinyint(4) NOT NULL DEFAULT '2',
358 `dd13` tinyint(4) NOT NULL DEFAULT '2',
359 `dd14` tinyint(4) NOT NULL DEFAULT '2',
360 `pets` text NOT NULL,
361 `petsEnemy` text NOT NULL,
362 `lastPetFight` text NOT NULL,
363 `mirror` int(11) NOT NULL DEFAULT '0',
364 `donatesilver` bigint(20) NOT NULL DEFAULT '0',
365 `donatemush` bigint(20) NOT NULL DEFAULT '0',
366 `whisper` text NOT NULL,
367 `fightswon` bigint(20) NOT NULL DEFAULT '0',
368 `questsdone` bigint(20) NOT NULL DEFAULT '0',
369 `workedhours` bigint(20) NOT NULL DEFAULT '0',
370 `goldearned` bigint(20) NOT NULL DEFAULT '0',
371 `maxhonor` bigint(20) NOT NULL DEFAULT '0',
372 `invites` text NOT NULL,
373 `friends` text NOT NULL,
374 `usysclass` varchar(20) NOT NULL DEFAULT '1'
375) ENGINE=MyISAM DEFAULT CHARSET=utf8;
376
377-- --------------------------------------------------------
378
379--
380-- Struktura tabeli dla tabeli `sms`
381--
382
383CREATE TABLE IF NOT EXISTS `sms` (
384 `id` int(11) NOT NULL,
385 `sender` bigint(20) NOT NULL,
386 `mush` bigint(20) NOT NULL,
387 `verified` tinyint(1) NOT NULL DEFAULT '0'
388) ENGINE=InnoDB DEFAULT CHARSET=latin1;
389
390-- --------------------------------------------------------
391
392--
393-- Struktura tabeli dla tabeli `witch`
394--
395
396CREATE TABLE IF NOT EXISTS `witch` (
397 `id` int(11) NOT NULL,
398 `fill` bigint(20) NOT NULL DEFAULT '0',
399 `max` bigint(20) NOT NULL DEFAULT '100000',
400 `event` tinyint(2) NOT NULL DEFAULT '0',
401 `eventtime` bigint(20) NOT NULL DEFAULT '0'
402) ENGINE=InnoDB DEFAULT CHARSET=latin1;
403
404--
405-- Indeksy dla zrzutów tabel
406--
407
408--
409-- Indexes for table `admin`
410--
411ALTER TABLE `admin`
412 ADD PRIMARY KEY (`id`);
413
414--
415-- Indexes for table `ajaxchat`
416--
417ALTER TABLE `ajaxchat`
418 ADD PRIMARY KEY (`id`);
419
420--
421-- Indexes for table `cert`
422--
423ALTER TABLE `cert`
424 ADD PRIMARY KEY (`id`);
425
426--
427-- Indexes for table `copycats`
428--
429ALTER TABLE `copycats`
430 ADD PRIMARY KEY (`ID`), ADD KEY `owner` (`owner`);
431
432--
433-- Indexes for table `fortress`
434--
435ALTER TABLE `fortress`
436 ADD PRIMARY KEY (`fortressID`), ADD KEY `owner` (`owner`), ADD KEY `owner_2` (`owner`);
437
438--
439-- Indexes for table `guildchat`
440--
441ALTER TABLE `guildchat`
442 ADD PRIMARY KEY (`ID`), ADD KEY `guildID` (`guildID`), ADD KEY `chattime` (`chattime`);
443
444--
445-- Indexes for table `guildfightlogs`
446--
447ALTER TABLE `guildfightlogs`
448 ADD PRIMARY KEY (`ID`), ADD KEY `guildAttacker` (`guildAttacker`), ADD KEY `guildDefender` (`guildDefender`), ADD KEY `time` (`time`);
449
450--
451-- Indexes for table `guildfights`
452--
453ALTER TABLE `guildfights`
454 ADD PRIMARY KEY (`ID`), ADD KEY `guildAttacker` (`guildAttacker`), ADD KEY `guildDefender` (`guildDefender`);
455
456--
457-- Indexes for table `guildinvites`
458--
459ALTER TABLE `guildinvites`
460 ADD PRIMARY KEY (`ID`), ADD KEY `guildID` (`guildID`);
461
462--
463-- Indexes for table `guilds`
464--
465ALTER TABLE `guilds`
466 ADD PRIMARY KEY (`ID`), ADD KEY `honor` (`honor`), ADD KEY `name` (`name`);
467
468--
469-- Indexes for table `items`
470--
471ALTER TABLE `items`
472 ADD PRIMARY KEY (`ID`), ADD KEY `owner` (`owner`);
473
474--
475-- Indexes for table `messages`
476--
477ALTER TABLE `messages`
478 ADD PRIMARY KEY (`ID`), ADD KEY `reciver` (`reciver`);
479
480--
481-- Indexes for table `playerfightlogs`
482--
483ALTER TABLE `playerfightlogs`
484 ADD PRIMARY KEY (`ID`), ADD KEY `time` (`time`), ADD KEY `attacker` (`attacker`), ADD KEY `defender` (`defender`);
485
486--
487-- Indexes for table `players`
488--
489ALTER TABLE `players`
490 ADD PRIMARY KEY (`ID`), ADD KEY `ssid` (`ssid`), ADD KEY `guild` (`guild`), ADD KEY `honor` (`honor`), ADD KEY `name` (`name`);
491
492--
493-- Indexes for table `sms`
494--
495ALTER TABLE `sms`
496 ADD PRIMARY KEY (`id`);
497
498--
499-- Indexes for table `witch`
500--
501ALTER TABLE `witch`
502 ADD PRIMARY KEY (`id`);
503
504--
505-- AUTO_INCREMENT for dumped tables
506--
507
508--
509-- AUTO_INCREMENT dla tabeli `admin`
510--
511ALTER TABLE `admin`
512 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
513--
514-- AUTO_INCREMENT dla tabeli `ajaxchat`
515--
516ALTER TABLE `ajaxchat`
517 MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT;
518--
519-- AUTO_INCREMENT dla tabeli `cert`
520--
521ALTER TABLE `cert`
522 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
523--
524-- AUTO_INCREMENT dla tabeli `copycats`
525--
526ALTER TABLE `copycats`
527 MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
528--
529-- AUTO_INCREMENT dla tabeli `fortress`
530--
531ALTER TABLE `fortress`
532 MODIFY `fortressID` int(11) NOT NULL AUTO_INCREMENT;
533--
534-- AUTO_INCREMENT dla tabeli `guildchat`
535--
536ALTER TABLE `guildchat`
537 MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
538--
539-- AUTO_INCREMENT dla tabeli `guildfightlogs`
540--
541ALTER TABLE `guildfightlogs`
542 MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
543--
544-- AUTO_INCREMENT dla tabeli `guildfights`
545--
546ALTER TABLE `guildfights`
547 MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
548--
549-- AUTO_INCREMENT dla tabeli `guildinvites`
550--
551ALTER TABLE `guildinvites`
552 MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
553--
554-- AUTO_INCREMENT dla tabeli `guilds`
555--
556ALTER TABLE `guilds`
557 MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
558--
559-- AUTO_INCREMENT dla tabeli `items`
560--
561ALTER TABLE `items`
562 MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
563--
564-- AUTO_INCREMENT dla tabeli `messages`
565--
566ALTER TABLE `messages`
567 MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
568--
569-- AUTO_INCREMENT dla tabeli `playerfightlogs`
570--
571ALTER TABLE `playerfightlogs`
572 MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
573--
574-- AUTO_INCREMENT dla tabeli `players`
575--
576ALTER TABLE `players`
577 MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
578--
579-- AUTO_INCREMENT dla tabeli `sms`
580--
581ALTER TABLE `sms`
582 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
583/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
584/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
585/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;