Advertisement
Guest User

Untitled

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