g1rN3F6A

1-- phpMyAdmin SQL Dump
2-- version 4.2.12deb2+deb8u2
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Czas generowania: 15 Maj 2018, 14:12
7-- Wersja serwera: 5.5.60-0+deb8u1
8-- Wersja PHP: 5.6.33-0+deb8u1
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET 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: `kscripts_teamspeak`
21--
22CREATE DATABASE IF NOT EXISTS `kscripts_teamspeak` DEFAULT CHARACTER SET utf32 COLLATE utf32_general_ci;
23USE `kscripts_teamspeak`;
24
25-- --------------------------------------------------------
26
27--
28-- Struktura tabeli dla tabeli `actions`
29--
30
31CREATE TABLE IF NOT EXISTS `actions` (
32`id` int(255) NOT NULL,
33  `type` text COLLATE utf8_polish_ci NOT NULL,
34  `clidb` int(255) NOT NULL,
35  `time` int(255) NOT NULL
36) ENGINE=InnoDB AUTO_INCREMENT=287 DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
37
38-- --------------------------------------------------------
39
40--
41-- Struktura tabeli dla tabeli `applications`
42--
43
44CREATE TABLE IF NOT EXISTS `applications` (
45`id` int(11) NOT NULL,
46  `database_id` int(11) NOT NULL,
47  `ip` varchar(35) CHARACTER SET utf8mb4 NOT NULL,
48  `type` int(11) NOT NULL,
49  `message` text CHARACTER SET utf8mb4 NOT NULL,
50  `email` text CHARACTER SET utf8 NOT NULL,
51  `status` int(11) DEFAULT '0',
52  `sendtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
53) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf32;
54
55-- --------------------------------------------------------
56
57--
58-- Struktura tabeli dla tabeli `clientinfo`
59--
60
61CREATE TABLE IF NOT EXISTS `clientinfo` (
62`id` int(10) unsigned NOT NULL,
63  `database_id` int(10) unsigned NOT NULL,
64  `unique_id` varchar(255) CHARACTER SET utf8 NOT NULL,
65  `last_nickname` varchar(255) CHARACTER SET utf8 NOT NULL,
66  `last_active` int(11) NOT NULL,
67  `best_active` int(11) NOT NULL,
68  `info` text CHARACTER SET utf8 NOT NULL,
69  `is_online` tinyint(4) NOT NULL DEFAULT '0',
70  `best_connections` int(11) NOT NULL DEFAULT '0',
71  `country` varchar(4) CHARACTER SET utf8 NOT NULL,
72  `client_base64HashClientUID` text CHARACTER SET utf8 NOT NULL,
73  `client_channel` text CHARACTER SET utf8 NOT NULL,
74  `timespent` int(255) NOT NULL,
75  `afktime` int(255) NOT NULL,
76  `client_created` int(11) NOT NULL,
77  `latestviewers` int(11) NOT NULL DEFAULT '0',
78  `profileviews` int(11) NOT NULL DEFAULT '0',
79  `lastgameschange` int(255) NOT NULL DEFAULT '0',
80  `lastchangegroups` int(255) NOT NULL DEFAULT '0',
81  `channelsaction` int(255) NOT NULL DEFAULT '0'
82) ENGINE=InnoDB AUTO_INCREMENT=34558538 DEFAULT CHARSET=latin1;
83
84-- --------------------------------------------------------
85
86--
87-- Struktura tabeli dla tabeli `events`
88--
89
90CREATE TABLE IF NOT EXISTS `events` (
91`id` int(11) NOT NULL,
92  `title` text CHARACTER SET utf8 NOT NULL,
93  `start` datetime NOT NULL,
94  `end` datetime NOT NULL,
95  `url` text CHARACTER SET utf8mb4 NOT NULL,
96  `className` text CHARACTER SET utf8 NOT NULL
97) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf32;
98
99-- --------------------------------------------------------
100
101--
102-- Struktura tabeli dla tabeli `lol`
103--
104
105CREATE TABLE IF NOT EXISTS `lol` (
106`id` int(11) NOT NULL,
107  `dbid` int(255) NOT NULL,
108  `summonerid` int(255) NOT NULL,
109  `level` int(255) NOT NULL,
110  `name` text NOT NULL,
111  `region` text NOT NULL,
112  `profileicon` int(255) NOT NULL,
113  `division_date` text NOT NULL,
114  `lastscan` int(255) NOT NULL
115) ENGINE=InnoDB DEFAULT CHARSET=latin1;
116
117-- --------------------------------------------------------
118
119--
120-- Struktura tabeli dla tabeli `minecraft`
121--
122
123CREATE TABLE IF NOT EXISTS `minecraft` (
124  `dbid` int(255) NOT NULL,
125  `premium` text NOT NULL,
126  `correct_username` text CHARACTER SET utf8 NOT NULL,
127  `uuid` text NOT NULL
128) ENGINE=InnoDB DEFAULT CHARSET=latin1;
129
130-- --------------------------------------------------------
131
132--
133-- Struktura tabeli dla tabeli `news`
134--
135
136CREATE TABLE IF NOT EXISTS `news` (
137`id` int(11) NOT NULL,
138  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_polish_ci NOT NULL,
139  `content` text CHARACTER SET utf8 COLLATE utf8_polish_ci NOT NULL,
140  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
141  `author_nickname` varchar(255) NOT NULL,
142  `author_database_id` int(11) NOT NULL DEFAULT '0',
143  `is_blocked` tinyint(1) NOT NULL DEFAULT '0'
144) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;
145
146-- --------------------------------------------------------
147
148--
149-- Struktura tabeli dla tabeli `premium_channels`
150--
151
152CREATE TABLE IF NOT EXISTS `premium_channels` (
153`id` int(11) NOT NULL,
154  `section_id` int(11) NOT NULL,
155  `owner_dbid` int(11) NOT NULL,
156  `owner_uid` varchar(255) NOT NULL,
157  `channel_id` int(11) NOT NULL,
158  `created` int(11) NOT NULL,
159  `remove_time` int(11) NOT NULL,
160  `last_message` int(11) NOT NULL,
161  `group_id` int(11) NOT NULL
162) ENGINE=InnoDB DEFAULT CHARSET=latin1;
163
164-- --------------------------------------------------------
165
166--
167-- Struktura tabeli dla tabeli `premium_groups`
168--
169
170CREATE TABLE IF NOT EXISTS `premium_groups` (
171`id` int(11) NOT NULL,
172  `owner_dbid` int(255) NOT NULL,
173  `owner_uid` text NOT NULL,
174  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
175  `remove_time` text NOT NULL,
176  `group_id` int(255) NOT NULL
177) ENGINE=InnoDB DEFAULT CHARSET=utf8;
178
179-- --------------------------------------------------------
180
181--
182-- Struktura tabeli dla tabeli `profile_settings`
183--
184
185CREATE TABLE IF NOT EXISTS `profile_settings` (
186  `database_id` int(11) NOT NULL,
187  `firstname` text CHARACTER SET utf8 NOT NULL,
188  `city` text CHARACTER SET utf8 NOT NULL,
189  `birthday` date NOT NULL,
190  `community` text CHARACTER SET utf8 NOT NULL,
191  `subdomain_name` text CHARACTER SET utf8 NOT NULL,
192  `lastactions` int(255) NOT NULL
193) ENGINE=InnoDB DEFAULT CHARSET=utf32;
194
195-- --------------------------------------------------------
196
197--
198-- Struktura tabeli dla tabeli `serverusage`
199--
200
201CREATE TABLE IF NOT EXISTS `serverusage` (
202`id` int(11) NOT NULL,
203  `clients` int(255) NOT NULL,
204  `packetlost` text NOT NULL,
205  `ping` text NOT NULL,
206  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
207) ENGINE=InnoDB AUTO_INCREMENT=5433 DEFAULT CHARSET=utf8;
208
209-- --------------------------------------------------------
210
211--
212-- Struktura tabeli dla tabeli `sessions`
213--
214
215CREATE TABLE IF NOT EXISTS `sessions` (
216  `ip` varchar(35) NOT NULL,
217  `last_seen` datetime NOT NULL
218) ENGINE=InnoDB DEFAULT CHARSET=utf32;
219
220--
221-- Indeksy dla zrzutów tabel
222--
223
224--
225-- Indexes for table `actions`
226--
227ALTER TABLE `actions`
228 ADD PRIMARY KEY (`id`);
229
230--
231-- Indexes for table `applications`
232--
233ALTER TABLE `applications`
234 ADD PRIMARY KEY (`id`);
235
236--
237-- Indexes for table `clientinfo`
238--
239ALTER TABLE `clientinfo`
240 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `database_id` (`database_id`);
241
242--
243-- Indexes for table `events`
244--
245ALTER TABLE `events`
246 ADD PRIMARY KEY (`id`);
247
248--
249-- Indexes for table `lol`
250--
251ALTER TABLE `lol`
252 ADD PRIMARY KEY (`id`);
253
254--
255-- Indexes for table `news`
256--
257ALTER TABLE `news`
258 ADD PRIMARY KEY (`id`);
259
260--
261-- Indexes for table `premium_channels`
262--
263ALTER TABLE `premium_channels`
264 ADD PRIMARY KEY (`id`);
265
266--
267-- Indexes for table `premium_groups`
268--
269ALTER TABLE `premium_groups`
270 ADD PRIMARY KEY (`id`);
271
272--
273-- Indexes for table `profile_settings`
274--
275ALTER TABLE `profile_settings`
276 ADD PRIMARY KEY (`database_id`);
277
278--
279-- Indexes for table `serverusage`
280--
281ALTER TABLE `serverusage`
282 ADD PRIMARY KEY (`id`);
283
284--
285-- Indexes for table `sessions`
286--
287ALTER TABLE `sessions`
288 ADD PRIMARY KEY (`ip`);
289
290--
291-- AUTO_INCREMENT for dumped tables
292--
293
294--
295-- AUTO_INCREMENT dla tabeli `actions`
296--
297ALTER TABLE `actions`
298MODIFY `id` int(255) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=287;
299--
300-- AUTO_INCREMENT dla tabeli `applications`
301--
302ALTER TABLE `applications`
303MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
304--
305-- AUTO_INCREMENT dla tabeli `clientinfo`
306--
307ALTER TABLE `clientinfo`
308MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=34558538;
309--
310-- AUTO_INCREMENT dla tabeli `events`
311--
312ALTER TABLE `events`
313MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
314--
315-- AUTO_INCREMENT dla tabeli `lol`
316--
317ALTER TABLE `lol`
318MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
319--
320-- AUTO_INCREMENT dla tabeli `news`
321--
322ALTER TABLE `news`
323MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=12;
324--
325-- AUTO_INCREMENT dla tabeli `premium_channels`
326--
327ALTER TABLE `premium_channels`
328MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
329--
330-- AUTO_INCREMENT dla tabeli `premium_groups`
331--
332ALTER TABLE `premium_groups`
333MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
334--
335-- AUTO_INCREMENT dla tabeli `serverusage`
336--
337ALTER TABLE `serverusage`
338MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5433;
339/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
340/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
341/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;