9ivjiiW4

1-- phpMyAdmin SQL Dump
2-- version 2.11.11.3
3-- http://www.phpmyadmin.net
4--
5-- Хост: localhost
6-- Время создания: Дек 10 2016 г., 11:38
7-- Версия сервера: 5.1.73
8-- Версия PHP: 5.4.45
9
10SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11
12--
13-- База данных: `thewortex`
14--
15
16-- --------------------------------------------------------
17
18--
19-- Структура таблицы `moder_log`
20--
21
22CREATE TABLE IF NOT EXISTS `moder_log` (
23  `id` int(9) NOT NULL AUTO_INCREMENT,
24  `username` varchar(16) NOT NULL,
25  `act_ind` int(3) NOT NULL,
26  `command` varchar(128) NOT NULL,
27  `time` int(11) NOT NULL,
28  `server` int(3) NOT NULL DEFAULT '0',
29  PRIMARY KEY (`id`)
30) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
31
32--
33-- Дамп данных таблицы `moder_log`
34--
35
36INSERT INTO `moder_log` (`id`, `username`, `act_ind`, `command`, `time`, `server`) VALUES
37(1, 'TaMBoV', 0, 'tempban Test 3 h Правило 3.1', 1481238772, 1),
38(2, 'TaMBoV', 0, 'tempban Test 3 h Правило 3.1', 1481239394, 1),
39(3, 'TaMBoV', 0, '/tempban Test 3 h Правило 3.1', 1481239495, 1),
40(4, 'TaMBoV', 4, '/ban Test Правило 2.1', 1481239591, 1),
41(5, 'TaMBoV', 0, 'tempban Test 3 h Правило 3.1', 1481321258, 1);
42
43-- --------------------------------------------------------
44
45--
46-- Дублирующая структура для представления `moder_log_date`
47--
48CREATE TABLE IF NOT EXISTS `moder_log_date` (
49`id` int(9)
50,`username` varchar(16)
51,`act_ind` int(3)
52,`command` varchar(128)
53,`server` int(3)
54,`date` datetime
55);
56-- --------------------------------------------------------
57
58--
59-- Структура для представления `moder_log_date`
60--
61DROP TABLE IF EXISTS `moder_log_date`;
62
63CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `thewortex`.`moder_log_date` AS (select `thewortex`.`moder_log`.`id` AS `id`,`thewortex`.`moder_log`.`username` AS `username`,`thewortex`.`moder_log`.`act_ind` AS `act_ind`,`thewortex`.`moder_log`.`command` AS `command`,`thewortex`.`moder_log`.`server` AS `server`,from_unixtime(`thewortex`.`moder_log`.`time`) AS `date` from `thewortex`.`moder_log`);