-- phpMyAdmin SQL Dump
-- version 4.6.5.2
-- https://www.phpmyadmin.net/
--
-- Host: db.doc360.com.br
-- Generation Time: 11-Ago-2020 às 11:20
-- Versão do servidor: 5.6.42-google-log
-- PHP Version: 5.6.30

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `tecprinters`
--

-- --------------------------------------------------------

--
-- Estrutura da tabela `eventos`
--

CREATE TABLE `eventos` (
  `id_evento` int(11) NOT NULL,
  `id_cliente` int(11) NOT NULL,
  `id_equipamento` int(11) NOT NULL,
  `severity` int(11) NOT NULL,
  `code` int(11) NOT NULL,
  `group_evt` int(11) NOT NULL,
  `time_evt` time NOT NULL,
  `descr` varchar(300) NOT NULL,
  `data_evento` datetime NOT NULL,
  `data_proc` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `eventos`
--

INSERT INTO `eventos` (`id_evento`, `id_cliente`, `id_equipamento`, `severity`, `code`, `group_evt`, `time_evt`, `descr`, `data_evento`, `data_proc`) VALUES
(323, 35, 3482, 1, 1, 5, '01:34:04', 'Modo de economia de energia {10033}', '2020-08-11 10:53:37', '2020-08-11 10:56:15'),
(326, 35, 3295, 1, 1, 5, '01:34:05', 'Modo de economia de energia {10033}', '2020-08-11 10:58:38', '2020-08-11 11:01:08'),
(328, 35, 3288, 1, 1, 5, '03:12:42', 'Modo de economia de energia {10033}', '2020-08-11 11:12:38', '2020-08-11 11:15:18'),
(329, 35, 3294, 1, 1, 5, '03:12:38', 'Modo de economia de energia {10033}', '2020-08-11 11:13:38', '2020-08-11 11:16:18'),
(330, 35, 3308, 1, 1, 5, '00:36:19', 'Modo de economia de energia {10033}', '2020-08-11 11:13:38', '2020-08-11 11:16:18'),
(331, 35, 3287, 1, 1, 5, '01:06:29', 'Modo de economia de energia {10033}', '2020-08-11 11:13:38', '2020-08-11 11:16:18'),
(332, 35, 3293, 4, 1104, 11, '17:40:42', 'Baixo: Toner {10006}', '2020-08-11 11:15:38', '2020-08-11 11:18:10'),
(333, 35, 3305, 4, 1, 10, '17:40:34', 'Próximo de substituição: Unidade de tambor {30426}', '2020-08-11 11:15:38', '2020-08-11 11:18:10'),
(334, 35, 3306, 1, 1, 5, '17:40:09', 'Modo de economia de energia {10033}', '2020-08-11 11:15:38', '2020-08-11 11:18:10'),
(335, 35, 3307, 4, 1104, 11, '17:40:19', 'Baixo: Toner {10006}', '2020-08-11 11:15:38', '2020-08-11 11:18:10'),
(336, 35, 3289, 4, 1104, 11, '17:40:24', 'Baixo: Toner {10006}', '2020-08-11 11:15:38', '2020-08-11 11:18:10');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `eventos`
--
ALTER TABLE `eventos`
  ADD PRIMARY KEY (`id_evento`),
  ADD KEY `id_cliente` (`id_cliente`,`id_equipamento`,`severity`,`code`,`data_evento`,`data_proc`),
  ADD KEY `time_evt` (`time_evt`),
  ADD KEY `group_evt` (`group_evt`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `eventos`
--
ALTER TABLE `eventos`
  MODIFY `id_evento` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=337;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
