spV161q5

1-- phpMyAdmin SQL Dump
2-- version 3.5.1
3-- http://www.phpmyadmin.net
4--
5-- Хост: 127.0.0.1
6-- Время создания: Янв 25 2018 г., 12:47
7-- Версия сервера: 5.5.25
8-- Версия PHP: 5.3.13
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-- База данных: `tzbot`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Структура таблицы `admin_default`
27--
28
29CREATE TABLE IF NOT EXISTS `admin_default` (
30  `id` int(11) NOT NULL,
31  `login` varchar(255) NOT NULL
32) ENGINE=InnoDB DEFAULT CHARSET=utf8;
33
34-- --------------------------------------------------------
35
36--
37-- Структура таблицы `black_list`
38--
39
40CREATE TABLE IF NOT EXISTS `black_list` (
41  `login` varchar(255) NOT NULL,
42  `prichina` varchar(255) NOT NULL,
43  `battle` int(11) NOT NULL,
44  `otstrochka` varchar(255) NOT NULL,
45  `chs` varchar(255) NOT NULL,
46  `check_status` int(11) NOT NULL,
47  `exit_state` int(11) NOT NULL,
48  `id` int(11) NOT NULL,
49  PRIMARY KEY (`id`)
50) ENGINE=InnoDB DEFAULT CHARSET=utf8;
51
52--
53-- Дамп данных таблицы `black_list`
54--
55
56INSERT INTO `black_list` (`login`, `prichina`, `battle`, `otstrochka`, `chs`, `check_status`, `exit_state`, `id`) VALUES
57('Eliks', 'Жирный пидор', 1, '0', '0', 1, 1, 0);
58
59-- --------------------------------------------------------
60
61--
62-- Структура таблицы `radio`
63--
64
65CREATE TABLE IF NOT EXISTS `radio` (
66  `id` int(11) NOT NULL,
67  `nik` varchar(255) NOT NULL,
68  `login` varchar(255) NOT NULL
69) ENGINE=InnoDB DEFAULT CHARSET=utf8;
70
71-- --------------------------------------------------------
72
73--
74-- Структура таблицы `radiovol`
75--
76
77CREATE TABLE IF NOT EXISTS `radiovol` (
78  `id` int(11) NOT NULL,
79  `v` int(11) NOT NULL,
80  `date` date NOT NULL
81) ENGINE=InnoDB DEFAULT CHARSET=utf8;
82
83--
84-- Дамп данных таблицы `radiovol`
85--
86
87INSERT INTO `radiovol` (`id`, `v`, `date`) VALUES
88(1, 222333444, '2018-01-25');
89
90/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
91/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
92/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;