7xsZ9Hm9

1-- phpMyAdmin SQL Dump
2-- version 4.2.12deb2+deb8u1
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Czas generowania: 27 Cze 2016, 13:03
7-- Wersja serwera: 10.0.25-MariaDB-0+deb8u1
8-- Wersja PHP: 5.6.22-1
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: `mbot`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Struktura tabeli dla tabeli `levels`
27--
28
29CREATE TABLE IF NOT EXISTS `levels` (
30  `db_id` int(255) NOT NULL,
31  `levels` int(255) NOT NULL
32) ENGINE=InnoDB DEFAULT CHARSET=latin1;
33
34-- --------------------------------------------------------
35
36--
37-- Struktura tabeli dla tabeli `newUsersToday`
38--
39
40CREATE TABLE IF NOT EXISTS `newUsersToday` (
41  `client_database_id` int(255) NOT NULL,
42  `client_servergroups` text NOT NULL,
43  `client_nickname` text NOT NULL,
44  `client_unique_identifier` text NOT NULL,
45  `day` text NOT NULL
46) ENGINE=InnoDB DEFAULT CHARSET=latin1;
47
48-- --------------------------------------------------------
49
50--
51-- Struktura tabeli dla tabeli `randomGroup`
52--
53
54CREATE TABLE IF NOT EXISTS `randomGroup` (
55  `client_database_id` int(255) NOT NULL,
56  `group_time` int(255) NOT NULL,
57  `add_group` int(255) NOT NULL
58) ENGINE=InnoDB DEFAULT CHARSET=latin1;
59
60-- --------------------------------------------------------
61
62--
63-- Struktura tabeli dla tabeli `songTitle`
64--
65
66CREATE TABLE IF NOT EXISTS `songTitle` (
67`id` int(11) NOT NULL,
68  `song` text COLLATE utf8_polish_ci NOT NULL,
69  `time` int(255) NOT NULL
70) ENGINE=InnoDB AUTO_INCREMENT=8304 DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
71
72-- --------------------------------------------------------
73
74--
75-- Struktura tabeli dla tabeli `timeSpent`
76--
77
78CREATE TABLE IF NOT EXISTS `timeSpent` (
79  `client_database_id` int(255) NOT NULL,
80  `time` int(255) NOT NULL
81) ENGINE=InnoDB DEFAULT CHARSET=latin1;
82
83-- --------------------------------------------------------
84
85--
86-- Struktura tabeli dla tabeli `top50connections`
87--
88
89CREATE TABLE IF NOT EXISTS `top50connections` (
90  `client_nickname` text CHARACTER SET utf8 COLLATE utf8_polish_ci NOT NULL,
91  `client_on_channel` text CHARACTER SET utf8 COLLATE utf8_polish_ci NOT NULL,
92  `client_unique_identifier` text CHARACTER SET utf8 COLLATE utf8_polish_ci NOT NULL,
93  `client_database_id` int(255) NOT NULL,
94  `client_totalconnections` int(255) NOT NULL
95) ENGINE=InnoDB DEFAULT CHARSET=latin1;
96
97-- --------------------------------------------------------
98
99--
100-- Struktura tabeli dla tabeli `top50onlinetime`
101--
102
103CREATE TABLE IF NOT EXISTS `top50onlinetime` (
104  `client_nickname` text CHARACTER SET utf8 COLLATE utf8_polish_ci NOT NULL,
105  `client_on_channel` text CHARACTER SET utf8 COLLATE utf8_polish_ci NOT NULL,
106  `client_unique_identifier` text CHARACTER SET utf8 COLLATE utf8_polish_ci NOT NULL,
107  `client_database_id` int(255) NOT NULL,
108  `connection_connected_time` int(255) NOT NULL
109) ENGINE=InnoDB DEFAULT CHARSET=latin1;
110
111-- --------------------------------------------------------
112
113--
114-- Struktura tabeli dla tabeli `topweekonline`
115--
116
117CREATE TABLE IF NOT EXISTS `topweekonline` (
118  `db` int(255) NOT NULL,
119  `time` int(255) NOT NULL
120) ENGINE=InnoDB DEFAULT CHARSET=latin1;
121
122--
123-- Indeksy dla zrzutów tabel
124--
125
126--
127-- Indexes for table `levels`
128--
129ALTER TABLE `levels`
130 ADD PRIMARY KEY (`db_id`);
131
132--
133-- Indexes for table `newUsersToday`
134--
135ALTER TABLE `newUsersToday`
136 ADD PRIMARY KEY (`client_database_id`);
137
138--
139-- Indexes for table `randomGroup`
140--
141ALTER TABLE `randomGroup`
142 ADD PRIMARY KEY (`client_database_id`);
143
144--
145-- Indexes for table `songTitle`
146--
147ALTER TABLE `songTitle`
148 ADD PRIMARY KEY (`id`);
149
150--
151-- Indexes for table `timeSpent`
152--
153ALTER TABLE `timeSpent`
154 ADD PRIMARY KEY (`client_database_id`);
155
156--
157-- Indexes for table `top50connections`
158--
159ALTER TABLE `top50connections`
160 ADD PRIMARY KEY (`client_database_id`), ADD UNIQUE KEY `client_database_id` (`client_database_id`);
161
162--
163-- Indexes for table `top50onlinetime`
164--
165ALTER TABLE `top50onlinetime`
166 ADD PRIMARY KEY (`client_database_id`), ADD UNIQUE KEY `client_database_id` (`client_database_id`), ADD UNIQUE KEY `client_database_id_2` (`client_database_id`), ADD UNIQUE KEY `client_database_id_3` (`client_database_id`);
167
168--
169-- Indexes for table `topweekonline`
170--
171ALTER TABLE `topweekonline`
172 ADD PRIMARY KEY (`db`);
173
174--
175-- AUTO_INCREMENT for dumped tables
176--
177
178--
179-- AUTO_INCREMENT dla tabeli `songTitle`
180--
181ALTER TABLE `songTitle`
182MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8304;
183/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
184/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
185/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;