Facebook
From Reliable Eider, 5 Years ago, written in Plain Text.
Embed
Download Paste or View Raw
Hits: 220
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.5.4.1
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Host: sql.pukawka.pl
  6. -- Czas generowania: 04 Lip 2018, 23:38
  7. -- Wersja serwera: 10.1.24-MariaDB-1~wheezy
  8. -- Wersja PHP: 5.6.30-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 utf8mb4 */;
  18.  
  19. --
  20. -- Baza danych: `700674_pluginy`
  21. --
  22.  
  23. -- --------------------------------------------------------
  24.  
  25. --
  26. -- Struktura tabeli dla tabeli `allianceData`
  27. --
  28.  
  29. CREATE TABLE `allianceData` (
  30.   `guild1` char(36) COLLATE utf8_polish_ci NOT NULL,
  31.   `guild2` char(36) COLLATE utf8_polish_ci NOT NULL
  32. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
  33.  
  34. -- --------------------------------------------------------
  35.  
  36. --
  37. -- Struktura tabeli dla tabeli `aPermissionData`
  38. --
  39.  
  40. CREATE TABLE `aPermissionData` (
  41.   `guildUUID` char(36) COLLATE utf8_polish_ci NOT NULL,
  42.   `allianceUUID` char(36) COLLATE utf8_polish_ci NOT NULL,
  43.   `build` int(1) NOT NULL,
  44.   `destroy` int(1) NOT NULL,
  45.   `pourOutWater` int(1) NOT NULL
  46. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
  47.  
  48. -- --------------------------------------------------------
  49.  
  50. --
  51. -- Struktura tabeli dla tabeli `cuboidData`
  52. --
  53.  
  54. CREATE TABLE `cuboidData` (
  55.   `uuid` char(36) COLLATE utf8_polish_ci NOT NULL,
  56.   `center` char(36) COLLATE utf8_polish_ci NOT NULL,
  57.   `radius` int(11) NOT NULL
  58. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
  59.  
  60. --
  61. -- Zrzut danych tabeli `cuboidData`
  62. --
  63.  
  64. INSERT INTO `cuboidData` (`uuid`, `center`, `radius`) VALUES
  65. ('d8668527-ae33-42c5-a1b5-33d2250c488d', 'world;-22;88;322', 25),
  66. ('93813a21-c4fe-4245-9ee7-5af6eacd373d', 'world;694;79;-65', 25);
  67.  
  68. -- --------------------------------------------------------
  69.  
  70. --
  71. -- Struktura tabeli dla tabeli `guildData`
  72. --
  73.  
  74. CREATE TABLE `guildData` (
  75.   `uuid` char(36) COLLATE utf8_polish_ci NOT NULL,
  76.   `tag` char(4) COLLATE utf8_polish_ci NOT NULL,
  77.   `name` char(36) COLLATE utf8_polish_ci NOT NULL,
  78.   `createDate` char(36) COLLATE utf8_polish_ci NOT NULL,
  79.   `expireTime` bigint(22) NOT NULL,
  80.   `home` char(36) COLLATE utf8_polish_ci NOT NULL,
  81.   `winWars` int(11) NOT NULL,
  82.   `loseWars` int(11) NOT NULL,
  83.   `drawWars` int(11) NOT NULL,
  84.   `position` int(11) NOT NULL
  85. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
  86.  
  87. -- --------------------------------------------------------
  88.  
  89. --
  90. -- Struktura tabeli dla tabeli `memberData`
  91. --
  92.  
  93. CREATE TABLE `memberData` (
  94.   `user` char(36) COLLATE utf8_polish_ci NOT NULL,
  95.   `guild` char(36) COLLATE utf8_polish_ci NOT NULL
  96. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
  97.  
  98. --
  99. -- Zrzut danych tabeli `memberData`
  100. --
  101.  
  102. INSERT INTO `memberData` (`user`, `guild`) VALUES
  103. ('2fcbde39-b580-347c-8426-b3fc9ac90847', 'd8668527-ae33-42c5-a1b5-33d2250c488d'),
  104. ('e57bea21-8079-31a5-8572-765fe1f1a96c', '93813a21-c4fe-4245-9ee7-5af6eacd373d');
  105.  
  106. -- --------------------------------------------------------
  107.  
  108. --
  109. -- Struktura tabeli dla tabeli `permissionData`
  110. --
  111.  
  112. CREATE TABLE `permissionData` (
  113.   `uuid` char(36) COLLATE utf8_polish_ci NOT NULL,
  114.   `invite` int(1) NOT NULL,
  115.   `kick` int(1) NOT NULL,
  116.   `home` int(1) NOT NULL,
  117.   `permission` int(1) NOT NULL,
  118.   `alliance` int(1) NOT NULL,
  119.   `war` int(1) NOT NULL,
  120.   `build` int(1) NOT NULL,
  121.   `destroy` int(1) NOT NULL,
  122.   `chest` int(1) NOT NULL
  123. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
  124.  
  125. --
  126. -- Zrzut danych tabeli `permissionData`
  127. --
  128.  
  129. INSERT INTO `permissionData` (`uuid`, `invite`, `kick`, `home`, `permission`, `alliance`, `war`, `build`, `destroy`, `chest`) VALUES
  130. ('2fcbde39-b580-347c-8426-b3fc9ac90847', 0, 0, 1, 0, 0, 0, 1, 1, 0),
  131. ('e57bea21-8079-31a5-8572-765fe1f1a96c', 0, 0, 1, 0, 0, 0, 1, 1, 0);
  132.  
  133. -- --------------------------------------------------------
  134.  
  135. --
  136. -- Struktura tabeli dla tabeli `userData`
  137. --
  138.  
  139. CREATE TABLE `userData` (
  140.   `uuid` char(36) COLLATE utf8_polish_ci NOT NULL,
  141.   `nick` char(36) COLLATE utf8_polish_ci NOT NULL,
  142.   `ip` char(36) COLLATE utf8_polish_ci NOT NULL,
  143.   `firstJoinDate` char(36) COLLATE utf8_polish_ci NOT NULL,
  144.   `goldenApple` int(11) NOT NULL,
  145.   `enchantedGoldenApple` int(11) NOT NULL,
  146.   `pearl` int(11) NOT NULL,
  147.   `monster` int(11) NOT NULL,
  148.   `lvl` int(11) NOT NULL,
  149.   `dpoints` int(11) NOT NULL,
  150.   `points` int(11) NOT NULL,
  151.   `kills` int(11) NOT NULL,
  152.   `deaths` int(11) NOT NULL,
  153.   `assists` int(11) NOT NULL,
  154.   `position` int(11) NOT NULL,
  155.   `essences` int(11) NOT NULL,
  156.   `mvp` int(11) NOT NULL,
  157.   `playTime` bigint(22) NOT NULL,
  158.   `stone` bigint(20) NOT NULL,
  159.   `obsidian` bigint(22) NOT NULL,
  160.   `blocks` bigint(22) NOT NULL,
  161.   `gamemode` int(1) NOT NULL,
  162.   `vanish` int(1) NOT NULL,
  163.   `godmode` int(1) NOT NULL,
  164.   `fly` int(1) NOT NULL,
  165.   `online` int(1) NOT NULL
  166. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
  167.  
  168. --
  169. -- Zrzut danych tabeli `userData`
  170. --
  171.  
  172.  
  173. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  174. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  175. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  176.