PcnCXQjH

1-- phpMyAdmin SQL Dump
2-- version 4.0.10deb1
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Czas wygenerowania: 14 Mar 2017, 15:31
7-- Wersja serwera: 5.6.33-0ubuntu0.14.04.1
8-- Wersja PHP: 5.5.9-1ubuntu4.21
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  PRIMARY KEY (`db_id`)
33) ENGINE=InnoDB DEFAULT CHARSET=latin1;
34
35-- --------------------------------------------------------
36
37--
38-- Struktura tabeli dla tabeli `newUsersToday`
39--
40
41CREATE TABLE IF NOT EXISTS `newUsersToday` (
42  `client_database_id` int(255) NOT NULL,
43  `client_servergroups` text NOT NULL,
44  `client_nickname` text NOT NULL,
45  `client_unique_identifier` text NOT NULL,
46  `day` text NOT NULL,
47  PRIMARY KEY (`client_database_id`)
48) ENGINE=InnoDB DEFAULT CHARSET=latin1;
49
50-- --------------------------------------------------------
51
52--
53-- Struktura tabeli dla tabeli `randomGroup`
54--
55
56CREATE TABLE IF NOT EXISTS `randomGroup` (
57  `client_database_id` int(255) NOT NULL,
58  `group_time` int(255) NOT NULL,
59  `add_group` int(255) NOT NULL,
60  PRIMARY KEY (`client_database_id`)
61) ENGINE=InnoDB DEFAULT CHARSET=latin1;
62
63-- --------------------------------------------------------
64
65--
66-- Struktura tabeli dla tabeli `songTitle`
67--
68
69CREATE TABLE IF NOT EXISTS `songTitle` (
70  `id` int(11) NOT NULL AUTO_INCREMENT,
71  `song` text COLLATE utf8_polish_ci NOT NULL,
72  `num` int(11) NOT NULL,
73  `time` int(255) NOT NULL,
74  PRIMARY KEY (`id`)
75) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci AUTO_INCREMENT=31530 ;
76
77-- --------------------------------------------------------
78
79--
80-- Struktura tabeli dla tabeli `timeSpent`
81--
82
83CREATE TABLE IF NOT EXISTS `timeSpent` (
84  `client_database_id` int(255) NOT NULL,
85  `time` int(255) NOT NULL,
86  PRIMARY KEY (`client_database_id`)
87) ENGINE=InnoDB DEFAULT CHARSET=latin1;
88
89-- --------------------------------------------------------
90
91--
92-- Struktura tabeli dla tabeli `top50connections`
93--
94
95CREATE TABLE IF NOT EXISTS `top50connections` (
96  `client_nickname` text CHARACTER SET utf8 COLLATE utf8_polish_ci NOT NULL,
97  `client_on_channel` text CHARACTER SET utf8 COLLATE utf8_polish_ci NOT NULL,
98  `client_unique_identifier` text CHARACTER SET utf8 COLLATE utf8_polish_ci NOT NULL,
99  `client_database_id` int(255) NOT NULL,
100  `client_totalconnections` int(255) NOT NULL,
101  PRIMARY KEY (`client_database_id`),
102  UNIQUE KEY `client_database_id` (`client_database_id`)
103) ENGINE=InnoDB DEFAULT CHARSET=latin1;
104
105-- --------------------------------------------------------
106
107--
108-- Struktura tabeli dla tabeli `top50onlinetime`
109--
110
111CREATE TABLE IF NOT EXISTS `top50onlinetime` (
112  `client_nickname` text CHARACTER SET utf8 COLLATE utf8_polish_ci NOT NULL,
113  `client_on_channel` text CHARACTER SET utf8 COLLATE utf8_polish_ci NOT NULL,
114  `client_unique_identifier` text CHARACTER SET utf8 COLLATE utf8_polish_ci NOT NULL,
115  `client_database_id` int(255) NOT NULL,
116  `connection_connected_time` int(255) NOT NULL,
117  PRIMARY KEY (`client_database_id`),
118  UNIQUE KEY `client_database_id` (`client_database_id`),
119  UNIQUE KEY `client_database_id_2` (`client_database_id`),
120  UNIQUE KEY `client_database_id_3` (`client_database_id`)
121) ENGINE=InnoDB DEFAULT CHARSET=latin1;
122
123-- --------------------------------------------------------
124
125--
126-- Struktura tabeli dla tabeli `topweekonline`
127--
128
129CREATE TABLE IF NOT EXISTS `topweekonline` (
130  `db` int(255) NOT NULL,
131  `time` int(255) NOT NULL,
132  PRIMARY KEY (`db`)
133) ENGINE=InnoDB DEFAULT CHARSET=latin1;
134
135/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
136/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
137/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;