-- 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 */;