- -- phpMyAdmin SQL Dump
- -- version 4.5.4.1
- -- http://www.phpmyadmin.net
- --
- -- Host: sql.pukawka.pl
- -- Czas generowania: 04 Lip 2018, 23:38
- -- Wersja serwera: 10.1.24-MariaDB-1~wheezy
- -- Wersja PHP: 5.6.30-0+deb8u1
- SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
- SET time_zone = "+00:00";
- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
- /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
- /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
- /*!40101 SET NAMES utf8mb4 */;
- --
- -- Baza danych: `700674_pluginy`
- --
- -- --------------------------------------------------------
- --
- -- Struktura tabeli dla tabeli `allianceData`
- --
- CREATE TABLE `allianceData` (
- `guild1` char(36) COLLATE utf8_polish_ci NOT NULL,
- `guild2` char(36) COLLATE utf8_polish_ci NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
- -- --------------------------------------------------------
- --
- -- Struktura tabeli dla tabeli `aPermissionData`
- --
- CREATE TABLE `aPermissionData` (
- `guildUUID` char(36) COLLATE utf8_polish_ci NOT NULL,
- `allianceUUID` char(36) COLLATE utf8_polish_ci NOT NULL,
- `build` int(1) NOT NULL,
- `destroy` int(1) NOT NULL,
- `pourOutWater` int(1) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
- -- --------------------------------------------------------
- --
- -- Struktura tabeli dla tabeli `cuboidData`
- --
- CREATE TABLE `cuboidData` (
- `uuid` char(36) COLLATE utf8_polish_ci NOT NULL,
- `center` char(36) COLLATE utf8_polish_ci NOT NULL,
- `radius` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
- --
- -- Zrzut danych tabeli `cuboidData`
- --
- INSERT INTO `cuboidData` (`uuid`, `center`, `radius`) VALUES
- ('d8668527-ae33-42c5-a1b5-33d2250c488d', 'world;-22;88;322', 25),
- ('93813a21-c4fe-4245-9ee7-5af6eacd373d', 'world;694;79;-65', 25);
- -- --------------------------------------------------------
- --
- -- Struktura tabeli dla tabeli `guildData`
- --
- CREATE TABLE `guildData` (
- `uuid` char(36) COLLATE utf8_polish_ci NOT NULL,
- `tag` char(4) COLLATE utf8_polish_ci NOT NULL,
- `name` char(36) COLLATE utf8_polish_ci NOT NULL,
- `createDate` char(36) COLLATE utf8_polish_ci NOT NULL,
- `expireTime` bigint(22) NOT NULL,
- `home` char(36) COLLATE utf8_polish_ci NOT NULL,
- `winWars` int(11) NOT NULL,
- `loseWars` int(11) NOT NULL,
- `drawWars` int(11) NOT NULL,
- `position` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
- -- --------------------------------------------------------
- --
- -- Struktura tabeli dla tabeli `memberData`
- --
- CREATE TABLE `memberData` (
- `user` char(36) COLLATE utf8_polish_ci NOT NULL,
- `guild` char(36) COLLATE utf8_polish_ci NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
- --
- -- Zrzut danych tabeli `memberData`
- --
- INSERT INTO `memberData` (`user`, `guild`) VALUES
- ('2fcbde39-b580-347c-8426-b3fc9ac90847', 'd8668527-ae33-42c5-a1b5-33d2250c488d'),
- ('e57bea21-8079-31a5-8572-765fe1f1a96c', '93813a21-c4fe-4245-9ee7-5af6eacd373d');
- -- --------------------------------------------------------
- --
- -- Struktura tabeli dla tabeli `permissionData`
- --
- CREATE TABLE `permissionData` (
- `uuid` char(36) COLLATE utf8_polish_ci NOT NULL,
- `invite` int(1) NOT NULL,
- `kick` int(1) NOT NULL,
- `home` int(1) NOT NULL,
- `permission` int(1) NOT NULL,
- `alliance` int(1) NOT NULL,
- `war` int(1) NOT NULL,
- `build` int(1) NOT NULL,
- `destroy` int(1) NOT NULL,
- `chest` int(1) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
- --
- -- Zrzut danych tabeli `permissionData`
- --
- INSERT INTO `permissionData` (`uuid`, `invite`, `kick`, `home`, `permission`, `alliance`, `war`, `build`, `destroy`, `chest`) VALUES
- ('2fcbde39-b580-347c-8426-b3fc9ac90847', 0, 0, 1, 0, 0, 0, 1, 1, 0),
- ('e57bea21-8079-31a5-8572-765fe1f1a96c', 0, 0, 1, 0, 0, 0, 1, 1, 0);
- -- --------------------------------------------------------
- --
- -- Struktura tabeli dla tabeli `userData`
- --
- CREATE TABLE `userData` (
- `uuid` char(36) COLLATE utf8_polish_ci NOT NULL,
- `nick` char(36) COLLATE utf8_polish_ci NOT NULL,
- `ip` char(36) COLLATE utf8_polish_ci NOT NULL,
- `firstJoinDate` char(36) COLLATE utf8_polish_ci NOT NULL,
- `goldenApple` int(11) NOT NULL,
- `enchantedGoldenApple` int(11) NOT NULL,
- `pearl` int(11) NOT NULL,
- `monster` int(11) NOT NULL,
- `lvl` int(11) NOT NULL,
- `dpoints` int(11) NOT NULL,
- `points` int(11) NOT NULL,
- `kills` int(11) NOT NULL,
- `deaths` int(11) NOT NULL,
- `assists` int(11) NOT NULL,
- `position` int(11) NOT NULL,
- `essences` int(11) NOT NULL,
- `mvp` int(11) NOT NULL,
- `playTime` bigint(22) NOT NULL,
- `stone` bigint(20) NOT NULL,
- `obsidian` bigint(22) NOT NULL,
- `blocks` bigint(22) NOT NULL,
- `gamemode` int(1) NOT NULL,
- `vanish` int(1) NOT NULL,
- `godmode` int(1) NOT NULL,
- `fly` int(1) NOT NULL,
- `online` int(1) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
- --
- -- Zrzut danych tabeli `userData`
- --
- /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
- /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
- /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;