-- phpMyAdmin SQL Dump
-- version 4.7.7
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: 20-Jun-2018 às 10:25
-- Versão do servidor: 5.6.38
-- PHP Version: 7.2.1

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

--
-- Database: `traccar`
--

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

--
-- Estrutura da tabela `events`
--

CREATE TABLE `events` (
  `id` int(11) NOT NULL,
  `type` varchar(128) NOT NULL,
  `servertime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `deviceid` int(11) DEFAULT NULL,
  `positionid` int(11) DEFAULT NULL,
  `geofenceid` int(11) DEFAULT NULL,
  `attributes` varchar(4000) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Extraindo dados da tabela `events`
--

INSERT INTO `events` (`id`, `type`, `servertime`, `deviceid`, `positionid`, `geofenceid`, `attributes`) VALUES
(23, 'deviceOnline', '2018-06-07 02:02:38', 7, NULL, NULL, '{}'),
(24, 'deviceOffline', '2018-06-07 02:02:38', 7, NULL, NULL, '{}'),
(25, 'deviceOnline', '2018-06-07 02:02:48', 7, NULL, NULL, '{}'),
(26, 'deviceOffline', '2018-06-07 02:02:48', 7, NULL, NULL, '{}'),
(27, 'deviceOnline', '2018-06-07 02:04:33', 7, NULL, NULL, '{}'),
(28, 'deviceOffline', '2018-06-07 02:04:33', 7, NULL, NULL, '{}'),
(29, 'deviceOnline', '2018-06-07 10:32:32', 7, NULL, NULL, '{}'),
(30, 'deviceUnknown', '2018-06-07 14:17:55', 7, NULL, NULL, '{}'),
(31, 'deviceOnline', '2018-06-11 21:45:46', 7, NULL, NULL, '{}'),
(32, 'deviceOnline', '2018-06-11 22:29:09', 11, NULL, NULL, '{}'),
(33, 'deviceOffline', '2018-06-11 22:30:13', 11, NULL, NULL, '{}'),
(34, 'deviceOnline', '2018-06-11 22:53:40', 11, NULL, NULL, '{}'),
(35, 'deviceOnline', '2018-06-11 22:55:17', 7, NULL, NULL, '{}'),
(36, 'deviceOffline', '2018-06-11 23:04:42', 11, NULL, NULL, '{}'),
(37, 'deviceUnknown', '2018-06-11 23:41:27', 7, NULL, NULL, '{}'),
(38, 'deviceOnline', '2018-06-12 01:14:03', 7, NULL, NULL, '{}'),
(39, 'deviceUnknown', '2018-06-12 01:24:03', 7, NULL, NULL, '{}'),
(40, 'deviceOnline', '2018-06-12 11:28:00', 11, NULL, NULL, '{}'),
(41, 'deviceOffline', '2018-06-12 11:43:37', 11, NULL, NULL, '{}'),
(42, 'deviceOnline', '2018-06-15 09:22:35', 7, NULL, NULL, '{}'),
(43, 'deviceUnknown', '2018-06-15 09:32:35', 7, NULL, NULL, '{}'),
(44, 'deviceOnline', '2018-06-15 17:08:16', 7, NULL, NULL, '{}'),
(45, 'deviceUnknown', '2018-06-15 17:19:47', 7, NULL, NULL, '{}'),
(46, 'deviceOnline', '2018-06-15 17:53:51', 7, NULL, NULL, '{}'),
(47, 'deviceUnknown', '2018-06-15 20:50:10', 7, NULL, NULL, '{}'),
(48, 'deviceOnline', '2018-06-16 12:54:32', 7, NULL, NULL, '{}'),
(49, 'deviceUnknown', '2018-06-16 13:10:46', 7, NULL, NULL, '{}'),
(50, 'deviceOnline', '2018-06-18 11:11:31', 7, NULL, NULL, '{}'),
(51, 'deviceUnknown', '2018-06-18 11:22:58', 7, NULL, NULL, '{}'),
(52, 'deviceOnline', '2018-06-18 11:29:11', 12, NULL, NULL, '{}'),
(53, 'alarm', '2018-06-18 11:30:22', 12, 467, NULL, '{\"alarm\":\"sos\"}'),
(54, 'alarm', '2018-06-18 11:30:25', 12, 469, NULL, '{\"alarm\":\"powerCut\"}'),
(55, 'alarm', '2018-06-18 11:30:25', 12, 471, NULL, '{\"alarm\":\"powerCut\"}'),
(56, 'alarm', '2018-06-18 11:35:02', 12, 503, NULL, '{\"alarm\":\"lowBattery\"}'),
(57, 'deviceOffline', '2018-06-18 11:37:15', 12, NULL, NULL, '{}');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `events`
--
ALTER TABLE `events`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_event_deviceid` (`deviceid`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `events`
--
ALTER TABLE `events`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=58;

--
-- Constraints for dumped tables
--

--
-- Limitadores para a tabela `events`
--
ALTER TABLE `events`
  ADD CONSTRAINT `fk_event_deviceid` FOREIGN KEY (`deviceid`) REFERENCES `devices` (`id`) ON DELETE CASCADE;