芝麻web文件管理V1.00

编辑当前文件:/home/mgatv524/giga.mgaplay.com.br/mgatv524_cms330.sql

-- phpMyAdmin SQL Dump
-- version 4.9.7
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Tempo de geração: 05-Dez-2022 às 13:41
-- Versão do servidor: 5.7.40
-- versão do PHP: 7.4.33

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
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 */;

--
-- Banco de dados: `mgatv524_cms330`
--

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

--
-- Estrutura da tabela `action`
--

CREATE TABLE `action` (
  `actionId` int(11) NOT NULL,
  `ownerId` int(11) NOT NULL,
  `triggerType` varchar(50) DEFAULT NULL,
  `triggerCode` varchar(50) DEFAULT NULL,
  `actionType` varchar(50) DEFAULT NULL,
  `source` varchar(50) DEFAULT NULL,
  `sourceId` int(11) DEFAULT NULL,
  `target` varchar(50) DEFAULT NULL,
  `targetId` int(11) DEFAULT NULL,
  `widgetId` int(11) DEFAULT NULL,
  `layoutCode` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Estrutura da tabela `auditlog`
--

CREATE TABLE `auditlog` (
  `logId` int(11) NOT NULL,
  `logDate` int(11) NOT NULL,
  `userId` int(11) NOT NULL,
  `message` varchar(255) NOT NULL,
  `entity` varchar(50) NOT NULL,
  `entityId` int(11) NOT NULL,
  `objectAfter` text,
  `ipAddress` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `auditlog`
--

INSERT INTO `auditlog` (`logId`, `logDate`, `userId`, `message`, `entity`, `entityId`, `objectAfter`, `ipAddress`) VALUES
(1, 1670256750, 0, 'User updated password', 'User', 1, 'false', NULL),
(2, 1670256750, 1, 'Login Granted', 'User', 1, '{\"UserAgent\":[\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/108.0.0.0 Safari\\/537.36\"]}', '187.183.233.174'),
(3, 1670256751, 1, 'Added', 'Media', 1, '{\"mediaId\":1,\"name\":\"Logo\",\"mediaType\":\"image\",\"fileName\":\"xibo_logo_square.png\",\"folderId\":1}', '187.183.233.174'),
(4, 1670256751, 1, 'Added', 'Media', 2, '{\"mediaId\":2,\"name\":\"Default Layout Background\",\"mediaType\":\"image\",\"fileName\":\"default layout3 background.jpg\",\"folderId\":1}', '187.183.233.174'),
(5, 1670256751, 1, 'Added', 'Widget', 1, '{\"widgetId\":1,\"type\":\"image\",\"layoutId\":\"1\",\"campaignId\":\"1\"}', '187.183.233.174'),
(6, 1670256751, 1, 'Saved', 'Playlist', 1, '{\"campaignId\":[\"1\"],\"layoutId\":[\"1\"]}', '187.183.233.174'),
(7, 1670256751, 1, 'Added', 'Widget', 2, '{\"widgetId\":2,\"type\":\"text\",\"layoutId\":\"1\",\"campaignId\":\"1\"}', '187.183.233.174'),
(8, 1670256751, 1, 'Saved', 'Playlist', 2, '{\"campaignId\":[\"1\"],\"layoutId\":[\"1\"]}', '187.183.233.174'),
(9, 1670256751, 1, 'Added', 'Widget', 3, '{\"widgetId\":3,\"type\":\"spacer\",\"layoutId\":\"1\",\"campaignId\":\"1\"}', '187.183.233.174'),
(10, 1670256751, 1, 'Added', 'Widget', 4, '{\"widgetId\":4,\"type\":\"text\",\"layoutId\":\"1\",\"campaignId\":\"1\"}', '187.183.233.174'),
(11, 1670256751, 1, 'Saved', 'Playlist', 3, '{\"campaignId\":[\"1\"],\"layoutId\":[\"1\"]}', '187.183.233.174'),
(12, 1670256751, 1, 'Added', 'Widget', 5, '{\"widgetId\":5,\"type\":\"clock\",\"layoutId\":\"1\",\"campaignId\":\"1\"}', '187.183.233.174'),
(13, 1670256751, 1, 'Saved', 'Playlist', 4, '{\"campaignId\":[\"1\"],\"layoutId\":[\"1\"]}', '187.183.233.174'),
(14, 1670256751, 1, 'Added', 'Media', 3, '{\"mediaId\":3,\"name\":\"jquery.min.js\",\"mediaType\":\"module\",\"fileName\":\"\\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/vendor\\/jquery.min.js\",\"folderId\":null}', '187.183.233.174'),
(15, 1670256751, 1, 'Added', 'Media', 4, '{\"mediaId\":4,\"name\":\"xibo-layout-scaler.js\",\"mediaType\":\"module\",\"fileName\":\"\\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-layout-scaler.js\",\"folderId\":null}', '187.183.233.174'),
(16, 1670256751, 1, 'Added', 'Media', 5, '{\"mediaId\":5,\"name\":\"xibo-interactive-control.min.js\",\"mediaType\":\"module\",\"fileName\":\"\\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-interactive-control.min.js\",\"folderId\":null}', '187.183.233.174'),
(17, 1670256751, 1, 'Updated', 'Media', 3, '{\"fileName\":\"jquery.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/vendor\\/jquery.min.js\"}', '187.183.233.174'),
(18, 1670256751, 1, 'Updated', 'Media', 4, '{\"fileName\":\"xibo-layout-scaler.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-layout-scaler.js\"}', '187.183.233.174'),
(19, 1670256751, 1, 'Updated', 'Media', 5, '{\"fileName\":\"xibo-interactive-control.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-interactive-control.min.js\"}', '187.183.233.174'),
(20, 1670256751, 1, 'Added', 'Media', 6, '{\"mediaId\":6,\"name\":\"moment.js\",\"mediaType\":\"module\",\"fileName\":\"\\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/vendor\\/moment.js\",\"folderId\":null}', '187.183.233.174'),
(21, 1670256751, 1, 'Added', 'Media', 7, '{\"mediaId\":7,\"name\":\"xibo-text-render.js\",\"mediaType\":\"module\",\"fileName\":\"\\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-text-render.js\",\"folderId\":null}', '187.183.233.174'),
(22, 1670256751, 1, 'Updated', 'Media', 3, '{\"fileName\":\"jquery.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/vendor\\/jquery.min.js\"}', '187.183.233.174'),
(23, 1670256751, 1, 'Updated', 'Media', 4, '{\"fileName\":\"xibo-layout-scaler.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-layout-scaler.js\"}', '187.183.233.174'),
(24, 1670256751, 1, 'Updated', 'Media', 5, '{\"fileName\":\"xibo-interactive-control.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-interactive-control.min.js\"}', '187.183.233.174'),
(25, 1670256751, 1, 'Added', 'Media', 8, '{\"mediaId\":8,\"name\":\"xibo-calendar-render.js\",\"mediaType\":\"module\",\"fileName\":\"\\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-calendar-render.js\",\"folderId\":null}', '187.183.233.174'),
(26, 1670256751, 1, 'Updated', 'Media', 6, '{\"fileName\":\"moment.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/vendor\\/moment.js\"}', '187.183.233.174'),
(27, 1670256751, 1, 'Updated', 'Media', 7, '{\"fileName\":\"xibo-text-render.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-text-render.js\"}', '187.183.233.174'),
(28, 1670256751, 1, 'Updated', 'Media', 3, '{\"fileName\":\"jquery.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/vendor\\/jquery.min.js\"}', '187.183.233.174'),
(29, 1670256751, 1, 'Updated', 'Media', 4, '{\"fileName\":\"xibo-layout-scaler.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-layout-scaler.js\"}', '187.183.233.174'),
(30, 1670256751, 1, 'Updated', 'Media', 5, '{\"fileName\":\"xibo-interactive-control.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-interactive-control.min.js\"}', '187.183.233.174'),
(31, 1670256751, 1, 'Updated', 'Media', 6, '{\"fileName\":\"moment.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/vendor\\/moment.js\"}', '187.183.233.174'),
(32, 1670256751, 1, 'Added', 'Media', 9, '{\"mediaId\":9,\"name\":\"Chart.min.js\",\"mediaType\":\"module\",\"fileName\":\"\\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/vendor\\/Chart.min.js\",\"folderId\":null}', '187.183.233.174'),
(33, 1670256751, 1, 'Updated', 'Media', 3, '{\"fileName\":\"jquery.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/vendor\\/jquery.min.js\"}', '187.183.233.174'),
(34, 1670256751, 1, 'Updated', 'Media', 4, '{\"fileName\":\"xibo-layout-scaler.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-layout-scaler.js\"}', '187.183.233.174'),
(35, 1670256751, 1, 'Updated', 'Media', 5, '{\"fileName\":\"xibo-interactive-control.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-interactive-control.min.js\"}', '187.183.233.174'),
(36, 1670256751, 1, 'Added', 'Media', 10, '{\"mediaId\":10,\"name\":\"jquery-cycle-2.1.6.min.js\",\"mediaType\":\"module\",\"fileName\":\"\\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/vendor\\/jquery-cycle-2.1.6.min.js\",\"folderId\":null}', '187.183.233.174'),
(37, 1670256751, 1, 'Updated', 'Media', 6, '{\"fileName\":\"moment.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/vendor\\/moment.js\"}', '187.183.233.174'),
(38, 1670256751, 1, 'Added', 'Media', 11, '{\"mediaId\":11,\"name\":\"flipclock.min.js\",\"mediaType\":\"module\",\"fileName\":\"\\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/vendor\\/flipclock.min.js\",\"folderId\":null}', '187.183.233.174'),
(39, 1670256751, 1, 'Updated', 'Media', 3, '{\"fileName\":\"jquery.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/vendor\\/jquery.min.js\"}', '187.183.233.174'),
(40, 1670256751, 1, 'Updated', 'Media', 4, '{\"fileName\":\"xibo-layout-scaler.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-layout-scaler.js\"}', '187.183.233.174'),
(41, 1670256751, 1, 'Updated', 'Media', 5, '{\"fileName\":\"xibo-interactive-control.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-interactive-control.min.js\"}', '187.183.233.174'),
(42, 1670256751, 1, 'Added', 'Media', 12, '{\"mediaId\":12,\"name\":\"xibo-countdown-render.js\",\"mediaType\":\"module\",\"fileName\":\"\\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-countdown-render.js\",\"folderId\":null}', '187.183.233.174'),
(43, 1670256751, 1, 'Updated', 'Media', 6, '{\"fileName\":\"moment.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/vendor\\/moment.js\"}', '187.183.233.174'),
(44, 1670256751, 1, 'Updated', 'Media', 3, '{\"fileName\":\"jquery.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/vendor\\/jquery.min.js\"}', '187.183.233.174'),
(45, 1670256751, 1, 'Updated', 'Media', 4, '{\"fileName\":\"xibo-layout-scaler.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-layout-scaler.js\"}', '187.183.233.174'),
(46, 1670256751, 1, 'Updated', 'Media', 5, '{\"fileName\":\"xibo-interactive-control.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-interactive-control.min.js\"}', '187.183.233.174'),
(47, 1670256751, 1, 'Updated', 'Media', 6, '{\"fileName\":\"moment.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/vendor\\/moment.js\"}', '187.183.233.174'),
(48, 1670256751, 1, 'Added', 'Media', 13, '{\"mediaId\":13,\"name\":\"jquery.marquee.min.js\",\"mediaType\":\"module\",\"fileName\":\"\\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/vendor\\/jquery.marquee.min.js\",\"folderId\":null}', '187.183.233.174'),
(49, 1670256751, 1, 'Updated', 'Media', 10, '{\"fileName\":\"jquery-cycle-2.1.6.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/vendor\\/jquery-cycle-2.1.6.min.js\"}', '187.183.233.174'),
(50, 1670256751, 1, 'Updated', 'Media', 7, '{\"fileName\":\"xibo-text-render.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-text-render.js\"}', '187.183.233.174'),
(51, 1670256751, 1, 'Added', 'Media', 14, '{\"mediaId\":14,\"name\":\"xibo-image-render.js\",\"mediaType\":\"module\",\"fileName\":\"\\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-image-render.js\",\"folderId\":null}', '187.183.233.174'),
(52, 1670256751, 1, 'Updated', 'Media', 3, '{\"fileName\":\"jquery.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/vendor\\/jquery.min.js\"}', '187.183.233.174'),
(53, 1670256751, 1, 'Updated', 'Media', 4, '{\"fileName\":\"xibo-layout-scaler.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-layout-scaler.js\"}', '187.183.233.174'),
(54, 1670256751, 1, 'Updated', 'Media', 5, '{\"fileName\":\"xibo-interactive-control.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-interactive-control.min.js\"}', '187.183.233.174'),
(55, 1670256751, 1, 'Updated', 'Media', 10, '{\"fileName\":\"jquery-cycle-2.1.6.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/vendor\\/jquery-cycle-2.1.6.min.js\"}', '187.183.233.174'),
(56, 1670256751, 1, 'Updated', 'Media', 6, '{\"fileName\":\"moment.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/vendor\\/moment.js\"}', '187.183.233.174'),
(57, 1670256751, 1, 'Added', 'Media', 15, '{\"mediaId\":15,\"name\":\"xibo-dataset-render.js\",\"mediaType\":\"module\",\"fileName\":\"\\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-dataset-render.js\",\"folderId\":null}', '187.183.233.174'),
(58, 1670256751, 1, 'Updated', 'Media', 14, '{\"fileName\":\"xibo-image-render.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-image-render.js\"}', '187.183.233.174'),
(59, 1670256751, 1, 'Updated', 'Media', 3, '{\"fileName\":\"jquery.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/vendor\\/jquery.min.js\"}', '187.183.233.174'),
(60, 1670256751, 1, 'Updated', 'Media', 4, '{\"fileName\":\"xibo-layout-scaler.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-layout-scaler.js\"}', '187.183.233.174'),
(61, 1670256751, 1, 'Updated', 'Media', 5, '{\"fileName\":\"xibo-interactive-control.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-interactive-control.min.js\"}', '187.183.233.174'),
(62, 1670256751, 1, 'Updated', 'Media', 14, '{\"fileName\":\"xibo-image-render.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-image-render.js\"}', '187.183.233.174'),
(63, 1670256751, 1, 'Added', 'Media', 16, '{\"mediaId\":16,\"name\":\"Aileron Heavy Regular\",\"mediaType\":\"font\",\"fileName\":\"\\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/fonts\\/Aileron-Heavy.otf\",\"folderId\":null}', '187.183.233.174'),
(64, 1670256751, 1, 'Added', 'Media', 17, '{\"mediaId\":17,\"name\":\"Aileron Regular\",\"mediaType\":\"font\",\"fileName\":\"\\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/fonts\\/Aileron-Regular.otf\",\"folderId\":null}', '187.183.233.174'),
(65, 1670256751, 1, 'Added', 'Media', 18, '{\"mediaId\":18,\"name\":\"Dancing Script Regular\",\"mediaType\":\"font\",\"fileName\":\"\\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/fonts\\/DancingScript-Regular.ttf\",\"folderId\":null}', '187.183.233.174'),
(66, 1670256751, 1, 'Added', 'Media', 19, '{\"mediaId\":19,\"name\":\"Railway Regular\",\"mediaType\":\"font\",\"fileName\":\"\\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/fonts\\/Railway.ttf\",\"folderId\":null}', '187.183.233.174'),
(67, 1670256751, 1, 'Added', 'Media', 20, '{\"mediaId\":20,\"name\":\"Linear Regular\",\"mediaType\":\"font\",\"fileName\":\"\\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/fonts\\/linear-by-braydon-fuller.otf\",\"folderId\":null}', '187.183.233.174'),
(68, 1670256751, 1, 'Updated', 'Media', 3, '{\"fileName\":\"jquery.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/vendor\\/jquery.min.js\"}', '187.183.233.174'),
(69, 1670256751, 1, 'Updated', 'Media', 4, '{\"fileName\":\"xibo-layout-scaler.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-layout-scaler.js\"}', '187.183.233.174'),
(70, 1670256751, 1, 'Updated', 'Media', 5, '{\"fileName\":\"xibo-interactive-control.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-interactive-control.min.js\"}', '187.183.233.174'),
(71, 1670256751, 1, 'Updated', 'Media', 3, '{\"fileName\":\"jquery.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/vendor\\/jquery.min.js\"}', '187.183.233.174'),
(72, 1670256751, 1, 'Updated', 'Media', 4, '{\"fileName\":\"xibo-layout-scaler.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-layout-scaler.js\"}', '187.183.233.174'),
(73, 1670256751, 1, 'Updated', 'Media', 5, '{\"fileName\":\"xibo-interactive-control.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-interactive-control.min.js\"}', '187.183.233.174'),
(74, 1670256751, 1, 'Updated', 'Media', 3, '{\"fileName\":\"jquery.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/vendor\\/jquery.min.js\"}', '187.183.233.174'),
(75, 1670256751, 1, 'Updated', 'Media', 4, '{\"fileName\":\"xibo-layout-scaler.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-layout-scaler.js\"}', '187.183.233.174'),
(76, 1670256751, 1, 'Updated', 'Media', 5, '{\"fileName\":\"xibo-interactive-control.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-interactive-control.min.js\"}', '187.183.233.174'),
(77, 1670256751, 1, 'Updated', 'Media', 3, '{\"fileName\":\"jquery.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/vendor\\/jquery.min.js\"}', '187.183.233.174'),
(78, 1670256751, 1, 'Updated', 'Media', 4, '{\"fileName\":\"xibo-layout-scaler.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-layout-scaler.js\"}', '187.183.233.174'),
(79, 1670256751, 1, 'Updated', 'Media', 5, '{\"fileName\":\"xibo-interactive-control.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-interactive-control.min.js\"}', '187.183.233.174'),
(80, 1670256751, 1, 'Updated', 'Media', 3, '{\"fileName\":\"jquery.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/vendor\\/jquery.min.js\"}', '187.183.233.174'),
(81, 1670256751, 1, 'Updated', 'Media', 4, '{\"fileName\":\"xibo-layout-scaler.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-layout-scaler.js\"}', '187.183.233.174'),
(82, 1670256751, 1, 'Updated', 'Media', 5, '{\"fileName\":\"xibo-interactive-control.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-interactive-control.min.js\"}', '187.183.233.174'),
(83, 1670256751, 1, 'Updated', 'Media', 3, '{\"fileName\":\"jquery.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/vendor\\/jquery.min.js\"}', '187.183.233.174'),
(84, 1670256751, 1, 'Updated', 'Media', 4, '{\"fileName\":\"xibo-layout-scaler.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-layout-scaler.js\"}', '187.183.233.174'),
(85, 1670256751, 1, 'Updated', 'Media', 5, '{\"fileName\":\"xibo-interactive-control.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-interactive-control.min.js\"}', '187.183.233.174'),
(86, 1670256751, 1, 'Updated', 'Media', 7, '{\"fileName\":\"xibo-text-render.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-text-render.js\"}', '187.183.233.174'),
(87, 1670256751, 1, 'Updated', 'Media', 13, '{\"fileName\":\"jquery.marquee.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/vendor\\/jquery.marquee.min.js\"}', '187.183.233.174'),
(88, 1670256751, 1, 'Updated', 'Media', 10, '{\"fileName\":\"jquery-cycle-2.1.6.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/vendor\\/jquery-cycle-2.1.6.min.js\"}', '187.183.233.174'),
(89, 1670256751, 1, 'Updated', 'Media', 3, '{\"fileName\":\"jquery.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/vendor\\/jquery.min.js\"}', '187.183.233.174'),
(90, 1670256751, 1, 'Updated', 'Media', 4, '{\"fileName\":\"xibo-layout-scaler.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-layout-scaler.js\"}', '187.183.233.174'),
(91, 1670256751, 1, 'Updated', 'Media', 5, '{\"fileName\":\"xibo-interactive-control.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-interactive-control.min.js\"}', '187.183.233.174'),
(92, 1670256751, 1, 'Added', 'Media', 21, '{\"mediaId\":21,\"name\":\"pdf.js\",\"mediaType\":\"module\",\"fileName\":\"\\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/vendor\\/pdfjs\\/pdf.js\",\"folderId\":null}', '187.183.233.174'),
(93, 1670256751, 1, 'Added', 'Media', 22, '{\"mediaId\":22,\"name\":\"pdf.worker.js\",\"mediaType\":\"module\",\"fileName\":\"\\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/vendor\\/pdfjs\\/pdf.worker.js\",\"folderId\":null}', '187.183.233.174'),
(94, 1670256751, 1, 'Updated', 'Media', 3, '{\"fileName\":\"jquery.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/vendor\\/jquery.min.js\"}', '187.183.233.174'),
(95, 1670256751, 1, 'Updated', 'Media', 4, '{\"fileName\":\"xibo-layout-scaler.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-layout-scaler.js\"}', '187.183.233.174'),
(96, 1670256751, 1, 'Updated', 'Media', 5, '{\"fileName\":\"xibo-interactive-control.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-interactive-control.min.js\"}', '187.183.233.174'),
(97, 1670256751, 1, 'Updated', 'Media', 3, '{\"fileName\":\"jquery.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/vendor\\/jquery.min.js\"}', '187.183.233.174'),
(98, 1670256751, 1, 'Updated', 'Media', 4, '{\"fileName\":\"xibo-layout-scaler.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-layout-scaler.js\"}', '187.183.233.174'),
(99, 1670256751, 1, 'Updated', 'Media', 5, '{\"fileName\":\"xibo-interactive-control.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-interactive-control.min.js\"}', '187.183.233.174'),
(100, 1670256751, 1, 'Updated', 'Media', 3, '{\"fileName\":\"jquery.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/vendor\\/jquery.min.js\"}', '187.183.233.174'),
(101, 1670256751, 1, 'Updated', 'Media', 4, '{\"fileName\":\"xibo-layout-scaler.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-layout-scaler.js\"}', '187.183.233.174'),
(102, 1670256751, 1, 'Updated', 'Media', 5, '{\"fileName\":\"xibo-interactive-control.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-interactive-control.min.js\"}', '187.183.233.174'),
(103, 1670256751, 1, 'Updated', 'Media', 3, '{\"fileName\":\"jquery.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/vendor\\/jquery.min.js\"}', '187.183.233.174'),
(104, 1670256751, 1, 'Updated', 'Media', 4, '{\"fileName\":\"xibo-layout-scaler.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-layout-scaler.js\"}', '187.183.233.174'),
(105, 1670256751, 1, 'Updated', 'Media', 5, '{\"fileName\":\"xibo-interactive-control.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-interactive-control.min.js\"}', '187.183.233.174'),
(106, 1670256751, 1, 'Updated', 'Media', 3, '{\"fileName\":\"jquery.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/vendor\\/jquery.min.js\"}', '187.183.233.174'),
(107, 1670256751, 1, 'Updated', 'Media', 4, '{\"fileName\":\"xibo-layout-scaler.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-layout-scaler.js\"}', '187.183.233.174'),
(108, 1670256751, 1, 'Updated', 'Media', 5, '{\"fileName\":\"xibo-interactive-control.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-interactive-control.min.js\"}', '187.183.233.174'),
(109, 1670256751, 1, 'Updated', 'Media', 3, '{\"fileName\":\"jquery.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/vendor\\/jquery.min.js\"}', '187.183.233.174'),
(110, 1670256751, 1, 'Updated', 'Media', 4, '{\"fileName\":\"xibo-layout-scaler.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-layout-scaler.js\"}', '187.183.233.174'),
(111, 1670256751, 1, 'Updated', 'Media', 5, '{\"fileName\":\"xibo-interactive-control.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-interactive-control.min.js\"}', '187.183.233.174'),
(112, 1670256751, 1, 'Updated', 'Media', 3, '{\"fileName\":\"jquery.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/vendor\\/jquery.min.js\"}', '187.183.233.174'),
(113, 1670256751, 1, 'Updated', 'Media', 4, '{\"fileName\":\"xibo-layout-scaler.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-layout-scaler.js\"}', '187.183.233.174'),
(114, 1670256751, 1, 'Updated', 'Media', 5, '{\"fileName\":\"xibo-interactive-control.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-interactive-control.min.js\"}', '187.183.233.174'),
(115, 1670256751, 1, 'Updated', 'Media', 6, '{\"fileName\":\"moment.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/vendor\\/moment.js\"}', '187.183.233.174'),
(116, 1670256751, 1, 'Updated', 'Media', 13, '{\"fileName\":\"jquery.marquee.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/vendor\\/jquery.marquee.min.js\"}', '187.183.233.174'),
(117, 1670256751, 1, 'Updated', 'Media', 10, '{\"fileName\":\"jquery-cycle-2.1.6.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/vendor\\/jquery-cycle-2.1.6.min.js\"}', '187.183.233.174'),
(118, 1670256751, 1, 'Updated', 'Media', 7, '{\"fileName\":\"xibo-text-render.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-text-render.js\"}', '187.183.233.174'),
(119, 1670256751, 1, 'Updated', 'Media', 14, '{\"fileName\":\"xibo-image-render.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-image-render.js\"}', '187.183.233.174'),
(120, 1670256751, 1, 'Updated', 'Media', 3, '{\"fileName\":\"jquery.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/vendor\\/jquery.min.js\"}', '187.183.233.174'),
(121, 1670256751, 1, 'Updated', 'Media', 4, '{\"fileName\":\"xibo-layout-scaler.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-layout-scaler.js\"}', '187.183.233.174'),
(122, 1670256751, 1, 'Updated', 'Media', 5, '{\"fileName\":\"xibo-interactive-control.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-interactive-control.min.js\"}', '187.183.233.174'),
(123, 1670256751, 1, 'Updated', 'Media', 6, '{\"fileName\":\"moment.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/vendor\\/moment.js\"}', '187.183.233.174'),
(124, 1670256751, 1, 'Updated', 'Media', 13, '{\"fileName\":\"jquery.marquee.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/vendor\\/jquery.marquee.min.js\"}', '187.183.233.174'),
(125, 1670256751, 1, 'Updated', 'Media', 10, '{\"fileName\":\"jquery-cycle-2.1.6.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/vendor\\/jquery-cycle-2.1.6.min.js\"}', '187.183.233.174'),
(126, 1670256751, 1, 'Updated', 'Media', 7, '{\"fileName\":\"xibo-text-render.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-text-render.js\"}', '187.183.233.174'),
(127, 1670256751, 1, 'Updated', 'Media', 14, '{\"fileName\":\"xibo-image-render.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-image-render.js\"}', '187.183.233.174'),
(128, 1670256751, 1, 'Updated', 'Media', 3, '{\"fileName\":\"jquery.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/vendor\\/jquery.min.js\"}', '187.183.233.174'),
(129, 1670256751, 1, 'Updated', 'Media', 4, '{\"fileName\":\"xibo-layout-scaler.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-layout-scaler.js\"}', '187.183.233.174'),
(130, 1670256751, 1, 'Updated', 'Media', 5, '{\"fileName\":\"xibo-interactive-control.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-interactive-control.min.js\"}', '187.183.233.174'),
(131, 1670256751, 1, 'Updated', 'Media', 3, '{\"fileName\":\"jquery.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/vendor\\/jquery.min.js\"}', '187.183.233.174'),
(132, 1670256751, 1, 'Updated', 'Media', 4, '{\"fileName\":\"xibo-layout-scaler.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-layout-scaler.js\"}', '187.183.233.174'),
(133, 1670256751, 1, 'Updated', 'Media', 5, '{\"fileName\":\"xibo-interactive-control.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-interactive-control.min.js\"}', '187.183.233.174'),
(134, 1670256751, 1, 'Updated', 'Media', 3, '{\"fileName\":\"jquery.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/vendor\\/jquery.min.js\"}', '187.183.233.174'),
(135, 1670256751, 1, 'Updated', 'Media', 4, '{\"fileName\":\"xibo-layout-scaler.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-layout-scaler.js\"}', '187.183.233.174'),
(136, 1670256751, 1, 'Updated', 'Media', 5, '{\"fileName\":\"xibo-interactive-control.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-interactive-control.min.js\"}', '187.183.233.174'),
(137, 1670256751, 1, 'Added', 'Media', 23, '{\"mediaId\":23,\"name\":\"xibo-webpage-render.js\",\"mediaType\":\"module\",\"fileName\":\"\\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-webpage-render.js\",\"folderId\":null}', '187.183.233.174'),
(138, 1670256751, 1, 'Updated', 'Media', 3, '{\"fileName\":\"jquery.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/vendor\\/jquery.min.js\"}', '187.183.233.174'),
(139, 1670256751, 1, 'Updated', 'Media', 4, '{\"fileName\":\"xibo-layout-scaler.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-layout-scaler.js\"}', '187.183.233.174'),
(140, 1670256751, 1, 'Updated', 'Media', 5, '{\"fileName\":\"xibo-interactive-control.min.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-interactive-control.min.js\"}', '187.183.233.174'),
(141, 1670256751, 1, 'Added', 'Media', 24, '{\"mediaId\":24,\"name\":\"xibo-worldclock-render.js\",\"mediaType\":\"module\",\"fileName\":\"\\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/xibo-worldclock-render.js\",\"folderId\":null}', '187.183.233.174'),
(142, 1670256751, 1, 'Updated', 'Media', 6, '{\"fileName\":\"moment.js > \\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/vendor\\/moment.js\"}', '187.183.233.174'),
(143, 1670256751, 1, 'Added', 'Media', 25, '{\"mediaId\":25,\"name\":\"moment-timezone.js\",\"mediaType\":\"module\",\"fileName\":\"\\/home\\/mgatv524\\/cms330.mgaplay.com.br\\/modules\\/vendor\\/moment-timezone.js\",\"folderId\":null}', '187.183.233.174'),
(144, 1670256751, 1, 'User Group edited', 'UserGroup', 3, '[]', '187.183.233.174'),
(145, 1670256751, 1, 'User updated', 'User', 1, '{\"newUserWizard\":\"0 > 1\"}', '187.183.233.174'),
(146, 1670256835, 1, 'Saved', 'Playlist', 3, '{\"campaignId\":[\"1\"],\"layoutId\":[\"1\"]}', '187.183.233.174'),
(147, 1670256835, 1, 'Saved', 'Playlist', 2, '{\"campaignId\":[\"1\"],\"layoutId\":[\"1\"]}', '187.183.233.174'),
(148, 1670256835, 1, 'Saved', 'Playlist', 1, '{\"campaignId\":[\"1\"],\"layoutId\":[\"1\"]}', '187.183.233.174'),
(149, 1670256835, 1, 'Saved', 'Playlist', 4, '{\"campaignId\":[\"1\"],\"layoutId\":[\"1\"]}', '187.183.233.174'),
(150, 1670256837, 1, 'Checked out', 'Layout', 2, '{\"layoutId\":1,\"layout\":\"Default Layout\",\"campaignId\":1}', '187.183.233.174'),
(151, 1670256837, 1, 'Added', 'Widget', 6, '{\"widgetId\":6,\"type\":\"spacer\",\"layoutId\":\"2\",\"campaignId\":\"1\"}', '187.183.233.174'),
(152, 1670256837, 1, 'Added', 'Widget', 7, '{\"widgetId\":7,\"type\":\"text\",\"layoutId\":\"2\",\"campaignId\":\"1\"}', '187.183.233.174'),
(153, 1670256837, 1, 'Saved', 'Playlist', 6, '{\"playlistId\":\"3 > 6\",\"regionId\":\"3 > 5\",\"campaignId\":[\"1\"],\"layoutId\":[\"2\"]}', '187.183.233.174'),
(154, 1670256837, 1, 'Added', 'Region', 5, '{\"regionId\":5,\"campaignId\":\"1\",\"details\":\"Region Explainer - 1626 x 145 (618, 147). RegionId = 5, LayoutId = 2. OwnerId = 1. Duration = 25\"}', '187.183.233.174'),
(155, 1670256837, 1, 'Added', 'Widget', 8, '{\"widgetId\":8,\"type\":\"text\",\"layoutId\":\"2\",\"campaignId\":\"1\"}', '187.183.233.174'),
(156, 1670256837, 1, 'Saved', 'Playlist', 7, '{\"playlistId\":\"2 > 7\",\"regionId\":\"2 > 6\",\"campaignId\":[\"1\"],\"layoutId\":[\"2\"]}', '187.183.233.174'),
(157, 1670256837, 1, 'Added', 'Region', 6, '{\"regionId\":6,\"campaignId\":\"1\",\"details\":\"Region Header - 1109 x 216 (290, 413). RegionId = 6, LayoutId = 2. OwnerId = 1. Duration = 10\"}', '187.183.233.174'),
(158, 1670256837, 1, 'Added', 'Widget', 9, '{\"widgetId\":9,\"type\":\"image\",\"layoutId\":\"2\",\"campaignId\":\"1\"}', '187.183.233.174'),
(159, 1670256837, 1, 'Saved', 'Playlist', 8, '{\"playlistId\":\"1 > 8\",\"regionId\":\"1 > 7\",\"campaignId\":[\"1\"],\"layoutId\":[\"2\"]}', '187.183.233.174'),
(160, 1670256837, 1, 'Added', 'Region', 7, '{\"regionId\":7,\"campaignId\":\"1\",\"details\":\"Region Logo - 267 x 157 (16, 24). RegionId = 7, LayoutId = 2. OwnerId = 1. Duration = 60\"}', '187.183.233.174'),
(161, 1670256837, 1, 'Added', 'Widget', 10, '{\"widgetId\":10,\"type\":\"clock\",\"layoutId\":\"2\",\"campaignId\":\"1\"}', '187.183.233.174'),
(162, 1670256837, 1, 'Saved', 'Playlist', 9, '{\"playlistId\":\"4 > 9\",\"regionId\":\"4 > 8\",\"campaignId\":[\"1\"],\"layoutId\":[\"2\"]}', '187.183.233.174'),
(163, 1670256837, 1, 'Added', 'Region', 8, '{\"regionId\":8,\"campaignId\":\"1\",\"details\":\"Region Time - 126 x 58 (971, 1741). RegionId = 8, LayoutId = 2. OwnerId = 1. Duration = 1\"}', '187.183.233.174'),
(164, 1670256837, 1, 'Updated', 'Layout', 1, '{\"publishedStatusId\":\"1 > 2\",\"publishedStatus\":\"Published > Rascunho\",\"campaignId\":[1]}', '187.183.233.174'),
(165, 1670256838, 1, 'Saved', 'Playlist', 6, '{\"campaignId\":[\"1\"],\"layoutId\":[\"2\"]}', '187.183.233.174'),
(166, 1670256838, 1, 'Saved', 'Playlist', 7, '{\"campaignId\":[\"1\"],\"layoutId\":[\"2\"]}', '187.183.233.174'),
(167, 1670256838, 1, 'Saved', 'Playlist', 8, '{\"campaignId\":[\"1\"],\"layoutId\":[\"2\"]}', '187.183.233.174'),
(168, 1670256838, 1, 'Saved', 'Playlist', 9, '{\"campaignId\":[\"1\"],\"layoutId\":[\"2\"]}', '187.183.233.174'),
(169, 1670256871, 1, 'Saved', 'Widget', 8, '{\"widgetOptions\":\"[\\n {\\n \\\"ta_text_advanced\\\": \\\"0 > 1\\\"\\n },\\n {\\n \\\"text\\\": \\\"powered by...<\\\\\\/span><\\\\\\/span><\\\\\\/p>\\\\r\\\\n\\\\r\\\\nXibo Digital Signage<\\\\\\/span><\\\\\\/span><\\\\\\/strong><\\\\\\/p>\\\\r\\\\n > powered by...<\\\\\\/span><\\\\\\/span><\\\\\\/p>\\\\r\\\\n\\\\r\\\\nMGA Digital Signage<\\\\\\/span><\\\\\\/span><\\\\\\/strong><\\\\\\/p>\\\\r\\\\n\\\"\\n }\\n]\",\"campaignId\":[\"1\"],\"layoutId\":[\"2\"]}', '187.183.233.174'),
(170, 1670256968, 1, 'Updated', 'Media', 1, '{\"isEdited\":\"0 > 1\"}', '187.183.233.174'),
(171, 1670256968, 1, 'Added', 'Media', 26, '{\"mediaId\":26,\"name\":\"Logo\",\"mediaType\":\"image\",\"fileName\":\"splash.png\",\"folderId\":1}', '187.183.233.174'),
(172, 1670256968, 1, 'Saved', 'Widget', 9, '{\"campaignId\":[\"1\"],\"layoutId\":[\"2\"]}', '187.183.233.174'),
(173, 1670256968, 1, 'Saved', 'Widget', 1, '{\"campaignId\":[\"1\"],\"layoutId\":[\"1\"]}', '187.183.233.174'),
(174, 1670256968, 1, 'Updated', 'Media', 1, '{\"parentId\":\"0 > 26\",\"isEdited\":\"0 > 1\"}', '187.183.233.174'),
(175, 1670256993, 1, 'Updated', 'Media', 26, '{\"isEdited\":\"0 > 1\"}', '187.183.233.174'),
(176, 1670256993, 1, 'Added', 'Media', 27, '{\"mediaId\":27,\"name\":\"Logo\",\"mediaType\":\"image\",\"fileName\":\"splash.png\",\"folderId\":1}', '187.183.233.174'),
(177, 1670256993, 1, 'Saved', 'Widget', 9, '{\"campaignId\":[\"1\"],\"layoutId\":[\"2\"]}', '187.183.233.174'),
(178, 1670256993, 1, 'Saved', 'Widget', 1, '{\"campaignId\":[\"1\"],\"layoutId\":[\"1\"]}', '187.183.233.174'),
(179, 1670256993, 1, 'Updated', 'Media', 26, '{\"parentId\":\"1 > 27\",\"isEdited\":\"0 > 1\"}', '187.183.233.174'),
(180, 1670257025, 1, 'Updated', 'Media', 27, '{\"isEdited\":\"0 > 1\"}', '187.183.233.174'),
(181, 1670257025, 1, 'Added', 'Media', 28, '{\"mediaId\":28,\"name\":\"Logo\",\"mediaType\":\"image\",\"fileName\":\"splash.png\",\"folderId\":1}', '187.183.233.174'),
(182, 1670257025, 1, 'Saved', 'Widget', 9, '{\"campaignId\":[\"1\"],\"layoutId\":[\"2\"]}', '187.183.233.174'),
(183, 1670257025, 1, 'Saved', 'Widget', 1, '{\"campaignId\":[\"1\"],\"layoutId\":[\"1\"]}', '187.183.233.174'),
(184, 1670257025, 1, 'Updated', 'Media', 27, '{\"parentId\":\"26 > 28\",\"isEdited\":\"0 > 1\"}', '187.183.233.174'),
(185, 1670257033, 1, 'Saved', 'Widget', 9, '{\"campaignId\":[\"1\"],\"layoutId\":[\"2\"]}', '187.183.233.174'),
(186, 1670257086, 1, 'Deleted', 'Widget', 3, '{\"widgetId\":3,\"playlistId\":3}', '187.183.233.174'),
(187, 1670257086, 1, 'Deleted', 'Widget', 4, '{\"widgetId\":4,\"playlistId\":3}', '187.183.233.174'),
(188, 1670257086, 1, 'Deleted', 'Playlist', 3, '{\"playlistId\":3,\"regionId\":3}', '187.183.233.174'),
(189, 1670257086, 1, 'Region Deleted', 'Region', 3, '{\"regionId\":3,\"layoutId\":1}', '187.183.233.174'),
(190, 1670257086, 1, 'Deleted', 'Widget', 2, '{\"widgetId\":2,\"playlistId\":2}', '187.183.233.174'),
(191, 1670257086, 1, 'Deleted', 'Playlist', 2, '{\"playlistId\":2,\"regionId\":2}', '187.183.233.174'),
(192, 1670257086, 1, 'Region Deleted', 'Region', 2, '{\"regionId\":2,\"layoutId\":1}', '187.183.233.174'),
(193, 1670257086, 1, 'Deleted', 'Widget', 1, '{\"widgetId\":1,\"playlistId\":1}', '187.183.233.174'),
(194, 1670257086, 1, 'Deleted', 'Playlist', 1, '{\"playlistId\":1,\"regionId\":1}', '187.183.233.174'),
(195, 1670257086, 1, 'Region Deleted', 'Region', 1, '{\"regionId\":1,\"layoutId\":1}', '187.183.233.174'),
(196, 1670257086, 1, 'Deleted', 'Widget', 5, '{\"widgetId\":5,\"playlistId\":4}', '187.183.233.174'),
(197, 1670257086, 1, 'Deleted', 'Playlist', 4, '{\"playlistId\":4,\"regionId\":4}', '187.183.233.174'),
(198, 1670257086, 1, 'Region Deleted', 'Region', 4, '{\"regionId\":4,\"layoutId\":1}', '187.183.233.174'),
(199, 1670257086, 1, 'Layout Deleted', 'Layout', 1, '{\"layoutId\":1}', '187.183.233.174'),
(200, 1670257086, 1, 'Deleted draft for 2', 'Layout', 1, '{\"parentId\":\" > 2\"}', '187.183.233.174'),
(201, 1670257086, 1, 'Updated Draft', 'Layout', 2, '{\"publishedStatusId\":\"2 > 1\",\"campaignId\":[1]}', '187.183.233.174'),
(202, 1670257139, 1, 'Added', 'Layout', 3, '{\"layoutId\":3,\"layout\":\"Uol-Celebridades\",\"campaignId\":3}', '187.183.233.174'),
(203, 1670257139, 1, 'Added', 'Layout', 5, '{\"layoutId\":5,\"layout\":\"Uol-Entretenimento\",\"campaignId\":4}', '187.183.233.174'),
(204, 1670257139, 1, 'Added', 'Layout', 4, '{\"layoutId\":4,\"layout\":\"Uol-Dicas\",\"campaignId\":2}', '187.183.233.174'),
(205, 1670257139, 1, 'Added', 'Widget', 12, '{\"widgetId\":12,\"type\":\"ticker\",\"layoutId\":\"3\",\"campaignId\":\"3\"}', '187.183.233.174'),
(206, 1670257139, 1, 'Saved', 'Playlist', 12, '{\"campaignId\":[\"3\"],\"layoutId\":[\"3\"]}', '187.183.233.174'),
(207, 1670257139, 1, 'Added', 'Region', 9, '{\"regionId\":9,\"campaignId\":\"3\",\"details\":\"Region 1 - 1920 x 1080 (0, 0). RegionId = 9, LayoutId = 3. OwnerId = 1. Duration = 0\"}', '187.183.233.174'),
(208, 1670257139, 1, 'Added', 'Layout', 6, '{\"layoutId\":6,\"layout\":\"Uol-Cotidiano\",\"campaignId\":5}', '187.183.233.174'),
(209, 1670257139, 1, 'Added', 'Widget', 11, '{\"widgetId\":11,\"type\":\"ticker\",\"layoutId\":\"4\",\"campaignId\":\"2\"}', '187.183.233.174'),
(210, 1670257139, 1, 'Saved', 'Playlist', 11, '{\"campaignId\":[\"2\"],\"layoutId\":[\"4\"]}', '187.183.233.174'),
(211, 1670257139, 1, 'Added', 'Region', 11, '{\"regionId\":11,\"campaignId\":\"2\",\"details\":\"Region 1 - 1920 x 1080 (0, 0). RegionId = 11, LayoutId = 4. OwnerId = 1. Duration = 0\"}', '187.183.233.174'),
(212, 1670257139, 1, 'Added', 'Widget', 13, '{\"widgetId\":13,\"type\":\"ticker\",\"layoutId\":\"5\",\"campaignId\":\"4\"}', '187.183.233.174'),
(213, 1670257139, 1, 'Saved', 'Playlist', 10, '{\"campaignId\":[\"4\"],\"layoutId\":[\"5\"]}', '187.183.233.174'),
(214, 1670257139, 1, 'Added', 'Region', 10, '{\"regionId\":10,\"campaignId\":\"4\",\"details\":\"Region 1 - 1920 x 1080 (0, 0). RegionId = 10, LayoutId = 5. OwnerId = 1. Duration = 0\"}', '187.183.233.174'),
(215, 1670257139, 1, 'Added', 'Widget', 14, '{\"widgetId\":14,\"type\":\"ticker\",\"layoutId\":\"6\",\"campaignId\":\"5\"}', '187.183.233.174'),
(216, 1670257139, 1, 'Saved', 'Playlist', 13, '{\"campaignId\":[\"5\"],\"layoutId\":[\"6\"]}', '187.183.233.174'),
(217, 1670257139, 1, 'Added', 'Region', 12, '{\"regionId\":12,\"campaignId\":\"5\",\"details\":\"Region 1 - 1920 x 1080 (0, 0). RegionId = 12, LayoutId = 6. OwnerId = 1. Duration = 0\"}', '187.183.233.174'),
(218, 1670257139, 1, 'Added', 'Layout', 7, '{\"layoutId\":7,\"layout\":\"Uol-Economia\",\"campaignId\":6}', '187.183.233.174'),
(219, 1670257139, 1, 'Added', 'Layout', 8, '{\"layoutId\":8,\"layout\":\"Uol-Destaques\",\"campaignId\":7}', '187.183.233.174'),
(220, 1670257139, 1, 'Added', 'Widget', 15, '{\"widgetId\":15,\"type\":\"ticker\",\"layoutId\":\"7\",\"campaignId\":\"6\"}', '187.183.233.174'),
(221, 1670257139, 1, 'Saved', 'Playlist', 14, '{\"campaignId\":[\"6\"],\"layoutId\":[\"7\"]}', '187.183.233.174'),
(222, 1670257139, 1, 'Added', 'Region', 13, '{\"regionId\":13,\"campaignId\":\"6\",\"details\":\"Region 1 - 1920 x 1080 (0, 0). RegionId = 13, LayoutId = 7. OwnerId = 1. Duration = 0\"}', '187.183.233.174'),
(223, 1670257139, 1, 'Added', 'Widget', 16, '{\"widgetId\":16,\"type\":\"ticker\",\"layoutId\":\"8\",\"campaignId\":\"7\"}', '187.183.233.174'),
(224, 1670257139, 1, 'Saved', 'Playlist', 15, '{\"campaignId\":[\"7\"],\"layoutId\":[\"8\"]}', '187.183.233.174'),
(225, 1670257139, 1, 'Added', 'Region', 14, '{\"regionId\":14,\"campaignId\":\"7\",\"details\":\"Region 1 - 1920 x 1080 (0, 0). RegionId = 14, LayoutId = 8. OwnerId = 1. Duration = 0\"}', '187.183.233.174'),
(226, 1670257140, 1, 'Added', 'Layout', 9, '{\"layoutId\":9,\"layout\":\"Uol-Televis\\u00e3o\",\"campaignId\":8}', '187.183.233.174'),
(227, 1670257140, 1, 'Added', 'Widget', 17, '{\"widgetId\":17,\"type\":\"ticker\",\"layoutId\":\"9\",\"campaignId\":\"8\"}', '187.183.233.174'),
(228, 1670257140, 1, 'Saved', 'Playlist', 16, '{\"campaignId\":[\"8\"],\"layoutId\":[\"9\"]}', '187.183.233.174'),
(229, 1670257140, 1, 'Added', 'Region', 15, '{\"regionId\":15,\"campaignId\":\"8\",\"details\":\"Region 1 - 1920 x 1080 (0, 0). RegionId = 15, LayoutId = 9. OwnerId = 1. Duration = 0\"}', '187.183.233.174'),
(230, 1670257140, 1, 'Added', 'Layout', 10, '{\"layoutId\":10,\"layout\":\"Uol-Pol\\u00edtica\",\"campaignId\":9}', '187.183.233.174'),
(231, 1670257140, 1, 'Added', 'Widget', 18, '{\"widgetId\":18,\"type\":\"ticker\",\"layoutId\":\"10\",\"campaignId\":\"9\"}', '187.183.233.174'),
(232, 1670257140, 1, 'Saved', 'Playlist', 17, '{\"campaignId\":[\"9\"],\"layoutId\":[\"10\"]}', '187.183.233.174'),
(233, 1670257140, 1, 'Added', 'Region', 16, '{\"regionId\":16,\"campaignId\":\"9\",\"details\":\"Region 1 - 1920 x 1080 (0, 0). RegionId = 16, LayoutId = 10. OwnerId = 1. Duration = 0\"}', '187.183.233.174'),
(234, 1670257140, 1, 'Added', 'Layout', 11, '{\"layoutId\":11,\"layout\":\"Uol-Internacional\",\"campaignId\":10}', '187.183.233.174'),
(235, 1670257140, 1, 'Added', 'Widget', 19, '{\"widgetId\":19,\"type\":\"ticker\",\"layoutId\":\"11\",\"campaignId\":\"10\"}', '187.183.233.174'),
(236, 1670257140, 1, 'Saved', 'Playlist', 18, '{\"campaignId\":[\"10\"],\"layoutId\":[\"11\"]}', '187.183.233.174'),
(237, 1670257140, 1, 'Added', 'Region', 17, '{\"regionId\":17,\"campaignId\":\"10\",\"details\":\"Region 1 - 1920 x 1080 (0, 0). RegionId = 17, LayoutId = 11. OwnerId = 1. Duration = 0\"}', '187.183.233.174'),
(238, 1670257140, 1, 'Added', 'Layout', 12, '{\"layoutId\":12,\"layout\":\"Uol-Esportes\",\"campaignId\":11}', '187.183.233.174'),
(239, 1670257140, 1, 'Added', 'Widget', 20, '{\"widgetId\":20,\"type\":\"ticker\",\"layoutId\":\"12\",\"campaignId\":\"11\"}', '187.183.233.174'),
(240, 1670257140, 1, 'Saved', 'Playlist', 19, '{\"campaignId\":[\"11\"],\"layoutId\":[\"12\"]}', '187.183.233.174'),
(241, 1670257140, 1, 'Added', 'Region', 18, '{\"regionId\":18,\"campaignId\":\"11\",\"details\":\"Region 1 - 1920 x 1080 (0, 0). RegionId = 18, LayoutId = 12. OwnerId = 1. Duration = 0\"}', '187.183.233.174'),
(242, 1670257150, 1, 'Saved', 'Playlist', 12, '{\"campaignId\":[\"3\"],\"layoutId\":[\"3\"]}', '187.183.233.174'),
(243, 1670257151, 1, 'Checked out', 'Layout', 13, '{\"layoutId\":3,\"layout\":\"Uol-Celebridades\",\"campaignId\":3}', '187.183.233.174'),
(244, 1670257151, 1, 'Added', 'Widget', 21, '{\"widgetId\":21,\"type\":\"ticker\",\"layoutId\":\"13\",\"campaignId\":\"3\"}', '187.183.233.174'),
(245, 1670257151, 1, 'Saved', 'Playlist', 20, '{\"playlistId\":\"12 > 20\",\"regionId\":\"9 > 19\",\"campaignId\":[\"3\"],\"layoutId\":[\"13\"]}', '187.183.233.174'),
(246, 1670257151, 1, 'Added', 'Region', 19, '{\"regionId\":19,\"campaignId\":\"3\",\"details\":\"Region 1 - 1920 x 1080 (0, 0). RegionId = 19, LayoutId = 13. OwnerId = 1. Duration = 5\"}', '187.183.233.174'),
(247, 1670257151, 1, 'Updated', 'Layout', 3, '{\"publishedStatusId\":\"1 > 2\",\"publishedStatus\":\"Published > Rascunho\",\"campaignId\":[3]}', '187.183.233.174'),
(248, 1670257151, 1, 'Added', 'Media', 29, '{\"mediaId\":29,\"name\":\"ticker_7a50d8e36d2cde50b039fbc298c14503\",\"mediaType\":\"module\",\"fileName\":\"http:\\/\\/conteudo.imguol.com.br\\/c\\/entretenimento\\/6d\\/2022\\/07\\/24\\/bianca-andrade-na-gravacao-do-numanice-2-de-ludmilla-1658663345178_v2_1920x1080.jpg\",\"folderId\":null}', '187.183.233.174'),
(249, 1670257151, 1, 'Added', 'Media', 30, '{\"mediaId\":30,\"name\":\"ticker_6cf6f9055a9d5347448b9689bf69d916\",\"mediaType\":\"module\",\"fileName\":\"http:\\/\\/conteudo.imguol.com.br\\/c\\/esporte\\/e1\\/2022\\/11\\/30\\/pele-o-rei-do-futebol-idolo-do-santos-e-tricampeao-mundial-com-a-selecao-brasileira-em-outubro-de-2018-1669832303881_v2_1920x1080.jpg\",\"folderId\":null}', '187.183.233.174'),
(250, 1670257151, 1, 'Added', 'Media', 31, '{\"mediaId\":31,\"name\":\"ticker_16da5eec921b54354ec4560ec2f911a0\",\"mediaType\":\"module\",\"fileName\":\"http:\\/\\/conteudo.imguol.com.br\\/c\\/entretenimento\\/d9\\/2018\\/01\\/07\\/gwendoline-christie-chega-ao-globo-de-ouro-2018-1515374794390_v2_1920x1080.jpg\",\"folderId\":null}', '187.183.233.174'),
(251, 1670257151, 1, 'Added', 'Media', 32, '{\"mediaId\":32,\"name\":\"ticker_31620e48683fb8c6fcae14c27ac20025\",\"mediaType\":\"module\",\"fileName\":\"http:\\/\\/conteudo.imguol.com.br\\/c\\/parceiros\\/30\\/2022\\/10\\/23\\/pele-comemora-86-anos-foto-reproducao-1666538102213_v2_1920x1080.jpg\",\"folderId\":null}', '187.183.233.174'),
(252, 1670257151, 1, 'Added', 'Media', 33, '{\"mediaId\":33,\"name\":\"ticker_771f2a3f696799f19e48994eab6de1eb\",\"mediaType\":\"module\",\"fileName\":\"http:\\/\\/conteudo.imguol.com.br\\/c\\/parceiros\\/b7\\/2022\\/10\\/27\\/kanye-west-1666905889351_v2_1920x1080.jpg\",\"folderId\":null}', '187.183.233.174'),
(253, 1670257151, 1, 'Added', 'Media', 34, '{\"mediaId\":34,\"name\":\"ticker_7b75cc911576c0e61d9c77a683a2f45e\",\"mediaType\":\"module\",\"fileName\":\"http:\\/\\/conteudo.imguol.com.br\\/c\\/parceiros\\/be\\/2022\\/08\\/09\\/caetano-veloso-1660039825454_v2_1920x1080.jpg\",\"folderId\":null}', '187.183.233.174'),
(254, 1670257151, 1, 'Added', 'Media', 35, '{\"mediaId\":35,\"name\":\"ticker_b188482bfa87e56bfc6a71140451ca28\",\"mediaType\":\"module\",\"fileName\":\"http:\\/\\/conteudo.imguol.com.br\\/c\\/entretenimento\\/ca\\/2018\\/05\\/30\\/igor-jansen-estrei-na-tv-em-as-aventuras-de-poliana-1527713846044_v2_1920x1080.jpg\",\"folderId\":null}', '187.183.233.174'),
(255, 1670257151, 1, 'Added', 'Media', 36, '{\"mediaId\":36,\"name\":\"ticker_66888c9d3b2592f508d9c1e1b792092b\",\"mediaType\":\"module\",\"fileName\":\"http:\\/\\/conteudo.imguol.com.br\\/c\\/entretenimento\\/12\\/2022\\/01\\/24\\/fatima-bernardes-voltou-hoje-de-ferias-1643033051496_v2_1920x1080.png\",\"folderId\":null}', '187.183.233.174'),
(256, 1670257151, 1, 'Added', 'Media', 37, '{\"mediaId\":37,\"name\":\"ticker_577a68c44b721baaa4272f911b16b65d\",\"mediaType\":\"module\",\"fileName\":\"http:\\/\\/conteudo.imguol.com.br\\/88\\/2016\\/05\\/25\\/kat-torres-1464195554940_1920x1080.jpg\",\"folderId\":null}', '187.183.233.174'),
(257, 1670257151, 1, 'Added', 'Media', 38, '{\"mediaId\":38,\"name\":\"ticker_109ed991fc8e0d50e05cf2b3ee122934\",\"mediaType\":\"module\",\"fileName\":\"http:\\/\\/conteudo.imguol.com.br\\/c\\/entretenimento\\/b6\\/2020\\/10\\/06\\/sem-filtro---angelica-retrato-remoto-1602007427901_v2_1920x1080.jpg\",\"folderId\":null}', '187.183.233.174'),
(258, 1670257151, 1, 'Added', 'Media', 39, '{\"mediaId\":39,\"name\":\"ticker_b179fdec3c63550d26edae18363f79f6\",\"mediaType\":\"module\",\"fileName\":\"http:\\/\\/conteudo.imguol.com.br\\/70\\/2022\\/04\\/20\\/adriano-imperador-se-surpreendeu-com-a-homenagem-feita-pelos-torcedores-da-inter-de-milao-1650448405569_v2_1920x1080.jpg\",\"folderId\":null}', '187.183.233.174'),
(259, 1670257151, 1, 'Added', 'Media', 40, '{\"mediaId\":40,\"name\":\"ticker_2dfb13aeaa27b6652366750e71db46ba\",\"mediaType\":\"module\",\"fileName\":\"http:\\/\\/conteudo.imguol.com.br\\/c\\/entretenimento\\/35\\/2022\\/09\\/20\\/viih-tube-anuncia-que-esta-gravida-de-eliezer-1663683587073_v2_1920x1080.png\",\"folderId\":null}', '187.183.233.174'),
(260, 1670257151, 1, 'Added', 'Media', 41, '{\"mediaId\":41,\"name\":\"ticker_70804ed4fd23baebfd8a15270b81bd88\",\"mediaType\":\"module\",\"fileName\":\"http:\\/\\/conteudo.imguol.com.br\\/c\\/galeria\\/f5\\/2022\\/11\\/20\\/anitta-1668994741365_v2_1920x1080.jpg\",\"folderId\":null}', '187.183.233.174'),
(261, 1670257151, 1, 'Added', 'Media', 42, '{\"mediaId\":42,\"name\":\"ticker_f6e6fec4ae6b593b3c93694e2a77e1c4\",\"mediaType\":\"module\",\"fileName\":\"http:\\/\\/conteudo.imguol.com.br\\/c\\/esporte\\/67\\/2021\\/09\\/17\\/hospital-israelita-albert-einstein-em-sao-paulo-onde-pele-esta-internado-1631921346913_v2_1920x1080.jpg\",\"folderId\":null}', '187.183.233.174'),
(262, 1670257151, 1, 'Added', 'Media', 43, '{\"mediaId\":43,\"name\":\"ticker_2735a6d23c09ed4b487f97f1c27e11e9\",\"mediaType\":\"module\",\"fileName\":\"http:\\/\\/conteudo.imguol.com.br\\/c\\/esporte\\/5e\\/2016\\/04\\/24\\/torcida-do-santos-apoia-a-equipe-contra-o-palmeiras-no-paulistao-1461526369574_1920x1080.jpg\",\"folderId\":null}', '187.183.233.174'),
(263, 1670257151, 1, 'Added', 'Media', 44, '{\"mediaId\":44,\"name\":\"ticker_3c7a2795011cd2000c188ceb3753f1d3\",\"mediaType\":\"module\",\"fileName\":\"http:\\/\\/conteudo.imguol.com.br\\/c\\/noticias\\/37\\/2022\\/12\\/04\\/doneda-foi-membro-do-conselho-responsavel-por-orientar-a-agencia-nacional-de-protecao-de-dados-1670196018388_v2_1920x1080.jpg\",\"folderId\":null}', '187.183.233.174'),
(264, 1670257151, 1, 'Added', 'Media', 45, '{\"mediaId\":45,\"name\":\"ticker_089a7330a13a9653f4133a7960ce6b40\",\"mediaType\":\"module\",\"fileName\":\"http:\\/\\/conteudo.imguol.com.br\\/c\\/entretenimento\\/2f\\/2020\\/02\\/05\\/rafael-cardoso-e-mariana-bridi-1580926315017_v2_1920x1080.jpg\",\"folderId\":null}', '187.183.233.174'),
(265, 1670257151, 1, 'Added', 'Media', 46, '{\"mediaId\":46,\"name\":\"ticker_0c3a2771ba2f4002a03cf75e67748c31\",\"mediaType\":\"module\",\"fileName\":\"http:\\/\\/conteudo.imguol.com.br\\/c\\/entretenimento\\/2014\\/04\\/30\\/jessica-ellen-e-alice-em-geracao-brasil-1398881721586_v2_1920x1080.jpg\",\"folderId\":null}', '187.183.233.174'),
(266, 1670257151, 1, 'Added', 'Media', 47, '{\"mediaId\":47,\"name\":\"ticker_5a3bfc623f799d4f8d4ee050ee36f620\",\"mediaType\":\"module\",\"fileName\":\"http:\\/\\/conteudo.imguol.com.br\\/c\\/entretenimento\\/e6\\/2022\\/10\\/31\\/nicolas-prattes-buscara-justica-em-todas-as-flores-1667257083709_v2_1920x1080.jpg\",\"folderId\":null}', '187.183.233.174'),
(267, 1670257151, 1, 'Added', 'Media', 48, '{\"mediaId\":48,\"name\":\"ticker_14c15a96c9cbf1659a678b5226630627\",\"mediaType\":\"module\",\"fileName\":\"http:\\/\\/conteudo.imguol.com.br\\/c\\/entretenimento\\/bc\\/2022\\/09\\/16\\/tiago-leifert-daiana-garbin-e-a-filha-lua-1663358671404_v2_1920x1080.jpg\",\"folderId\":null}', '187.183.233.174'),
(268, 1670257152, 1, 'Saved', 'Playlist', 20, '{\"campaignId\":[\"3\"],\"layoutId\":[\"13\"]}', '187.183.233.174');
INSERT INTO `auditlog` (`logId`, `logDate`, `userId`, `message`, `entity`, `entityId`, `objectAfter`, `ipAddress`) VALUES
(269, 1670257152, 1, 'Updated', 'Media', 29, '{\"fileName\":\"bianca-andrade-na-gravacao-do-numanice-2-de-ludmilla-1658663345178_v2_1920x1080.jpg > http:\\/\\/conteudo.imguol.com.br\\/c\\/entretenimento\\/6d\\/2022\\/07\\/24\\/bianca-andrade-na-gravacao-do-numanice-2-de-ludmilla-1658663345178_v2_1920x1080.jpg\",\"expires\":\"2022-12-06 16:19:11 > 2022-12-06 16:19:12\"}', '187.183.233.174'),
(270, 1670257152, 1, 'Updated', 'Media', 30, '{\"fileName\":\"pele-o-rei-do-futebol-idolo-do-santos-e-tricampeao-mundial-com-a-selecao-brasileira-em-outubro-de-2018-1669832303881_v2_1920x1080.jpg > http:\\/\\/conteudo.imguol.com.br\\/c\\/esporte\\/e1\\/2022\\/11\\/30\\/pele-o-rei-do-futebol-idolo-do-santos-e-tricampeao-mundial-com-a-selecao-brasileira-em-outubro-de-2018-1669832303881_v2_1920x1080.jpg\",\"expires\":\"2022-12-06 16:19:11 > 2022-12-06 16:19:12\"}', '187.183.233.174'),
(271, 1670257152, 1, 'Updated', 'Media', 31, '{\"fileName\":\"gwendoline-christie-chega-ao-globo-de-ouro-2018-1515374794390_v2_1920x1080.jpg > http:\\/\\/conteudo.imguol.com.br\\/c\\/entretenimento\\/d9\\/2018\\/01\\/07\\/gwendoline-christie-chega-ao-globo-de-ouro-2018-1515374794390_v2_1920x1080.jpg\",\"expires\":\"2022-12-06 16:19:11 > 2022-12-06 16:19:12\"}', '187.183.233.174'),
(272, 1670257152, 1, 'Updated', 'Media', 32, '{\"fileName\":\"pele-comemora-86-anos-foto-reproducao-1666538102213_v2_1920x1080.jpg > http:\\/\\/conteudo.imguol.com.br\\/c\\/parceiros\\/30\\/2022\\/10\\/23\\/pele-comemora-86-anos-foto-reproducao-1666538102213_v2_1920x1080.jpg\",\"expires\":\"2022-12-06 16:19:11 > 2022-12-06 16:19:12\"}', '187.183.233.174'),
(273, 1670257152, 1, 'Updated', 'Media', 33, '{\"fileName\":\"kanye-west-1666905889351_v2_1920x1080.jpg > http:\\/\\/conteudo.imguol.com.br\\/c\\/parceiros\\/b7\\/2022\\/10\\/27\\/kanye-west-1666905889351_v2_1920x1080.jpg\",\"expires\":\"2022-12-06 16:19:11 > 2022-12-06 16:19:12\"}', '187.183.233.174'),
(274, 1670257152, 1, 'Updated', 'Media', 34, '{\"fileName\":\"caetano-veloso-1660039825454_v2_1920x1080.jpg > http:\\/\\/conteudo.imguol.com.br\\/c\\/parceiros\\/be\\/2022\\/08\\/09\\/caetano-veloso-1660039825454_v2_1920x1080.jpg\",\"expires\":\"2022-12-06 16:19:11 > 2022-12-06 16:19:12\"}', '187.183.233.174'),
(275, 1670257152, 1, 'Updated', 'Media', 35, '{\"fileName\":\"igor-jansen-estrei-na-tv-em-as-aventuras-de-poliana-1527713846044_v2_1920x1080.jpg > http:\\/\\/conteudo.imguol.com.br\\/c\\/entretenimento\\/ca\\/2018\\/05\\/30\\/igor-jansen-estrei-na-tv-em-as-aventuras-de-poliana-1527713846044_v2_1920x1080.jpg\",\"expires\":\"2022-12-06 16:19:11 > 2022-12-06 16:19:12\"}', '187.183.233.174'),
(276, 1670257152, 1, 'Updated', 'Media', 36, '{\"fileName\":\"fatima-bernardes-voltou-hoje-de-ferias-1643033051496_v2_1920x1080.png > http:\\/\\/conteudo.imguol.com.br\\/c\\/entretenimento\\/12\\/2022\\/01\\/24\\/fatima-bernardes-voltou-hoje-de-ferias-1643033051496_v2_1920x1080.png\",\"expires\":\"2022-12-06 16:19:11 > 2022-12-06 16:19:12\"}', '187.183.233.174'),
(277, 1670257152, 1, 'Updated', 'Media', 37, '{\"fileName\":\"kat-torres-1464195554940_1920x1080.jpg > http:\\/\\/conteudo.imguol.com.br\\/88\\/2016\\/05\\/25\\/kat-torres-1464195554940_1920x1080.jpg\",\"expires\":\"2022-12-06 16:19:11 > 2022-12-06 16:19:12\"}', '187.183.233.174'),
(278, 1670257152, 1, 'Updated', 'Media', 38, '{\"fileName\":\"sem-filtro---angelica-retrato-remoto-1602007427901_v2_1920x1080.jpg > http:\\/\\/conteudo.imguol.com.br\\/c\\/entretenimento\\/b6\\/2020\\/10\\/06\\/sem-filtro---angelica-retrato-remoto-1602007427901_v2_1920x1080.jpg\",\"expires\":\"2022-12-06 16:19:11 > 2022-12-06 16:19:12\"}', '187.183.233.174'),
(279, 1670257152, 1, 'Updated', 'Media', 39, '{\"fileName\":\"adriano-imperador-se-surpreendeu-com-a-homenagem-feita-pelos-torcedores-da-inter-de-milao-1650448405569_v2_1920x1080.jpg > http:\\/\\/conteudo.imguol.com.br\\/70\\/2022\\/04\\/20\\/adriano-imperador-se-surpreendeu-com-a-homenagem-feita-pelos-torcedores-da-inter-de-milao-1650448405569_v2_1920x1080.jpg\",\"expires\":\"2022-12-06 16:19:11 > 2022-12-06 16:19:12\"}', '187.183.233.174'),
(280, 1670257152, 1, 'Updated', 'Media', 40, '{\"fileName\":\"viih-tube-anuncia-que-esta-gravida-de-eliezer-1663683587073_v2_1920x1080.png > http:\\/\\/conteudo.imguol.com.br\\/c\\/entretenimento\\/35\\/2022\\/09\\/20\\/viih-tube-anuncia-que-esta-gravida-de-eliezer-1663683587073_v2_1920x1080.png\",\"expires\":\"2022-12-06 16:19:11 > 2022-12-06 16:19:12\"}', '187.183.233.174'),
(281, 1670257152, 1, 'Updated', 'Media', 41, '{\"fileName\":\"anitta-1668994741365_v2_1920x1080.jpg > http:\\/\\/conteudo.imguol.com.br\\/c\\/galeria\\/f5\\/2022\\/11\\/20\\/anitta-1668994741365_v2_1920x1080.jpg\",\"expires\":\"2022-12-06 16:19:11 > 2022-12-06 16:19:12\"}', '187.183.233.174'),
(282, 1670257152, 1, 'Updated', 'Media', 42, '{\"fileName\":\"hospital-israelita-albert-einstein-em-sao-paulo-onde-pele-esta-internado-1631921346913_v2_1920x1080.jpg > http:\\/\\/conteudo.imguol.com.br\\/c\\/esporte\\/67\\/2021\\/09\\/17\\/hospital-israelita-albert-einstein-em-sao-paulo-onde-pele-esta-internado-1631921346913_v2_1920x1080.jpg\",\"expires\":\"2022-12-06 16:19:11 > 2022-12-06 16:19:12\"}', '187.183.233.174'),
(283, 1670257152, 1, 'Updated', 'Media', 43, '{\"fileName\":\"torcida-do-santos-apoia-a-equipe-contra-o-palmeiras-no-paulistao-1461526369574_1920x1080.jpg > http:\\/\\/conteudo.imguol.com.br\\/c\\/esporte\\/5e\\/2016\\/04\\/24\\/torcida-do-santos-apoia-a-equipe-contra-o-palmeiras-no-paulistao-1461526369574_1920x1080.jpg\",\"expires\":\"2022-12-06 16:19:11 > 2022-12-06 16:19:12\"}', '187.183.233.174'),
(284, 1670257152, 1, 'Updated', 'Media', 44, '{\"fileName\":\"doneda-foi-membro-do-conselho-responsavel-por-orientar-a-agencia-nacional-de-protecao-de-dados-1670196018388_v2_1920x1080.jpg > http:\\/\\/conteudo.imguol.com.br\\/c\\/noticias\\/37\\/2022\\/12\\/04\\/doneda-foi-membro-do-conselho-responsavel-por-orientar-a-agencia-nacional-de-protecao-de-dados-1670196018388_v2_1920x1080.jpg\",\"expires\":\"2022-12-06 16:19:11 > 2022-12-06 16:19:12\"}', '187.183.233.174'),
(285, 1670257152, 1, 'Updated', 'Media', 45, '{\"fileName\":\"rafael-cardoso-e-mariana-bridi-1580926315017_v2_1920x1080.jpg > http:\\/\\/conteudo.imguol.com.br\\/c\\/entretenimento\\/2f\\/2020\\/02\\/05\\/rafael-cardoso-e-mariana-bridi-1580926315017_v2_1920x1080.jpg\",\"expires\":\"2022-12-06 16:19:11 > 2022-12-06 16:19:12\"}', '187.183.233.174'),
(286, 1670257152, 1, 'Updated', 'Media', 46, '{\"fileName\":\"jessica-ellen-e-alice-em-geracao-brasil-1398881721586_v2_1920x1080.jpg > http:\\/\\/conteudo.imguol.com.br\\/c\\/entretenimento\\/2014\\/04\\/30\\/jessica-ellen-e-alice-em-geracao-brasil-1398881721586_v2_1920x1080.jpg\",\"expires\":\"2022-12-06 16:19:11 > 2022-12-06 16:19:12\"}', '187.183.233.174'),
(287, 1670257152, 1, 'Updated', 'Media', 47, '{\"fileName\":\"nicolas-prattes-buscara-justica-em-todas-as-flores-1667257083709_v2_1920x1080.jpg > http:\\/\\/conteudo.imguol.com.br\\/c\\/entretenimento\\/e6\\/2022\\/10\\/31\\/nicolas-prattes-buscara-justica-em-todas-as-flores-1667257083709_v2_1920x1080.jpg\",\"expires\":\"2022-12-06 16:19:11 > 2022-12-06 16:19:12\"}', '187.183.233.174'),
(288, 1670257152, 1, 'Updated', 'Media', 48, '{\"fileName\":\"tiago-leifert-daiana-garbin-e-a-filha-lua-1663358671404_v2_1920x1080.jpg > http:\\/\\/conteudo.imguol.com.br\\/c\\/entretenimento\\/bc\\/2022\\/09\\/16\\/tiago-leifert-daiana-garbin-e-a-filha-lua-1663358671404_v2_1920x1080.jpg\",\"expires\":\"2022-12-06 16:19:11 > 2022-12-06 16:19:12\"}', '187.183.233.174'),
(289, 1670257209, 1, 'Saved', 'Widget', 21, '{\"widgetOptions\":\"[\\n {\\n \\\"css\\\": \\\".linkfoto > img { width:1920px;height:1080px;}\\\\n.logo1{display: block; margin: 15px auto 30px auto}\\\\n.cycle-overlay {color: white;background-color: rgba(0,0,0,0.6);position: absolute;bottom: 0;width: 20%;height:100%;padding: 15px;}\\\\n > .linkfoto > img { width:1920px;height:1080px;}\\\\r\\\\n.logo1{display: block; margin: 15px auto 30px auto}\\\\r\\\\n.cycle-overlay {color: white;background-color: rgba(0,0,0,0.6);position: absolute;bottom: 0;width: 20%;height:100%;padding: 15px;}\\\\r\\\\n\\\"\\n },\\n {\\n \\\"noDataMessage\\\": \\\"No Data returned from the source<\\\\\\/span><\\\\\\/span><\\\\\\/p>\\\\n > No Data returned from the source<\\\\\\/span><\\\\\\/span><\\\\\\/p>\\\\r\\\\n\\\"\\n },\\n {\\n \\\"template\\\": \\\"<div class=\\\\\\\"linkfoto\\\\\\\">[linkfoto|image]\\\\n<div class=\\\\\\\"cycle-overlay\\\\\\\">\\\\n<div class=\\\\\\\"logo1\\\\\\\"><img src=\\\\\\\"https:\\\\\\/\\\\\\/www.mgatv.com.br\\\\\\/uol\\\\\\/logo1.png\\\\\\\" \\\\\\/><\\\\\\/div>\\\\n\\\\n[Title]<\\\\\\/p>\\\\n\\\\n[Description]<\\\\\\/p>\\\\n<\\\\\\/div>\\\\n<\\\\\\/div>\\\\n > <div class=\\\\\\\"linkfoto\\\\\\\">[linkfoto|image]\\\\r\\\\n<div class=\\\\\\\"cycle-overlay\\\\\\\">\\\\r\\\\n<div class=\\\\\\\"logo1\\\\\\\"><img src=\\\\\\\"https:\\\\\\/\\\\\\/www.mgaplay.com.br\\\\\\/uol\\\\\\/logo1.png\\\\\\\" \\\\\\/><\\\\\\/div>\\\\r\\\\n\\\\r\\\\n[Title]<\\\\\\/p>\\\\r\\\\n\\\\r\\\\n[Description]<\\\\\\/p>\\\\r\\\\n<\\\\\\/div>\\\\r\\\\n<\\\\\\/div>\\\\r\\\\n\\\"\\n }\\n]\",\"campaignId\":[\"3\"],\"layoutId\":[\"13\"]}', '187.183.233.174'),
(290, 1670257210, 1, 'Updated', 'Media', 29, '{\"fileName\":\"bianca-andrade-na-gravacao-do-numanice-2-de-ludmilla-1658663345178_v2_1920x1080.jpg > http:\\/\\/conteudo.imguol.com.br\\/c\\/entretenimento\\/6d\\/2022\\/07\\/24\\/bianca-andrade-na-gravacao-do-numanice-2-de-ludmilla-1658663345178_v2_1920x1080.jpg\",\"expires\":\"2022-12-06 16:19:12 > 2022-12-05 20:20:10\"}', '187.183.233.174'),
(291, 1670257210, 1, 'Updated', 'Media', 30, '{\"fileName\":\"pele-o-rei-do-futebol-idolo-do-santos-e-tricampeao-mundial-com-a-selecao-brasileira-em-outubro-de-2018-1669832303881_v2_1920x1080.jpg > http:\\/\\/conteudo.imguol.com.br\\/c\\/esporte\\/e1\\/2022\\/11\\/30\\/pele-o-rei-do-futebol-idolo-do-santos-e-tricampeao-mundial-com-a-selecao-brasileira-em-outubro-de-2018-1669832303881_v2_1920x1080.jpg\",\"expires\":\"2022-12-06 16:19:12 > 2022-12-05 20:20:10\"}', '187.183.233.174'),
(292, 1670257210, 1, 'Updated', 'Media', 31, '{\"fileName\":\"gwendoline-christie-chega-ao-globo-de-ouro-2018-1515374794390_v2_1920x1080.jpg > http:\\/\\/conteudo.imguol.com.br\\/c\\/entretenimento\\/d9\\/2018\\/01\\/07\\/gwendoline-christie-chega-ao-globo-de-ouro-2018-1515374794390_v2_1920x1080.jpg\",\"expires\":\"2022-12-06 16:19:12 > 2022-12-05 20:20:10\"}', '187.183.233.174'),
(293, 1670257210, 1, 'Updated', 'Media', 32, '{\"fileName\":\"pele-comemora-86-anos-foto-reproducao-1666538102213_v2_1920x1080.jpg > http:\\/\\/conteudo.imguol.com.br\\/c\\/parceiros\\/30\\/2022\\/10\\/23\\/pele-comemora-86-anos-foto-reproducao-1666538102213_v2_1920x1080.jpg\",\"expires\":\"2022-12-06 16:19:12 > 2022-12-05 20:20:10\"}', '187.183.233.174'),
(294, 1670257210, 1, 'Updated', 'Media', 33, '{\"fileName\":\"kanye-west-1666905889351_v2_1920x1080.jpg > http:\\/\\/conteudo.imguol.com.br\\/c\\/parceiros\\/b7\\/2022\\/10\\/27\\/kanye-west-1666905889351_v2_1920x1080.jpg\",\"expires\":\"2022-12-06 16:19:12 > 2022-12-05 20:20:10\"}', '187.183.233.174'),
(295, 1670257210, 1, 'Updated', 'Media', 34, '{\"fileName\":\"caetano-veloso-1660039825454_v2_1920x1080.jpg > http:\\/\\/conteudo.imguol.com.br\\/c\\/parceiros\\/be\\/2022\\/08\\/09\\/caetano-veloso-1660039825454_v2_1920x1080.jpg\",\"expires\":\"2022-12-06 16:19:12 > 2022-12-05 20:20:10\"}', '187.183.233.174'),
(296, 1670257210, 1, 'Updated', 'Media', 35, '{\"fileName\":\"igor-jansen-estrei-na-tv-em-as-aventuras-de-poliana-1527713846044_v2_1920x1080.jpg > http:\\/\\/conteudo.imguol.com.br\\/c\\/entretenimento\\/ca\\/2018\\/05\\/30\\/igor-jansen-estrei-na-tv-em-as-aventuras-de-poliana-1527713846044_v2_1920x1080.jpg\",\"expires\":\"2022-12-06 16:19:12 > 2022-12-05 20:20:10\"}', '187.183.233.174'),
(297, 1670257210, 1, 'Updated', 'Media', 36, '{\"fileName\":\"fatima-bernardes-voltou-hoje-de-ferias-1643033051496_v2_1920x1080.png > http:\\/\\/conteudo.imguol.com.br\\/c\\/entretenimento\\/12\\/2022\\/01\\/24\\/fatima-bernardes-voltou-hoje-de-ferias-1643033051496_v2_1920x1080.png\",\"expires\":\"2022-12-06 16:19:12 > 2022-12-05 20:20:10\"}', '187.183.233.174'),
(298, 1670257210, 1, 'Updated', 'Media', 37, '{\"fileName\":\"kat-torres-1464195554940_1920x1080.jpg > http:\\/\\/conteudo.imguol.com.br\\/88\\/2016\\/05\\/25\\/kat-torres-1464195554940_1920x1080.jpg\",\"expires\":\"2022-12-06 16:19:12 > 2022-12-05 20:20:10\"}', '187.183.233.174'),
(299, 1670257210, 1, 'Updated', 'Media', 38, '{\"fileName\":\"sem-filtro---angelica-retrato-remoto-1602007427901_v2_1920x1080.jpg > http:\\/\\/conteudo.imguol.com.br\\/c\\/entretenimento\\/b6\\/2020\\/10\\/06\\/sem-filtro---angelica-retrato-remoto-1602007427901_v2_1920x1080.jpg\",\"expires\":\"2022-12-06 16:19:12 > 2022-12-05 20:20:10\"}', '187.183.233.174'),
(300, 1670257210, 1, 'Updated', 'Media', 39, '{\"fileName\":\"adriano-imperador-se-surpreendeu-com-a-homenagem-feita-pelos-torcedores-da-inter-de-milao-1650448405569_v2_1920x1080.jpg > http:\\/\\/conteudo.imguol.com.br\\/70\\/2022\\/04\\/20\\/adriano-imperador-se-surpreendeu-com-a-homenagem-feita-pelos-torcedores-da-inter-de-milao-1650448405569_v2_1920x1080.jpg\",\"expires\":\"2022-12-06 16:19:12 > 2022-12-05 20:20:10\"}', '187.183.233.174'),
(301, 1670257210, 1, 'Updated', 'Media', 40, '{\"fileName\":\"viih-tube-anuncia-que-esta-gravida-de-eliezer-1663683587073_v2_1920x1080.png > http:\\/\\/conteudo.imguol.com.br\\/c\\/entretenimento\\/35\\/2022\\/09\\/20\\/viih-tube-anuncia-que-esta-gravida-de-eliezer-1663683587073_v2_1920x1080.png\",\"expires\":\"2022-12-06 16:19:12 > 2022-12-05 20:20:10\"}', '187.183.233.174'),
(302, 1670257210, 1, 'Updated', 'Media', 41, '{\"fileName\":\"anitta-1668994741365_v2_1920x1080.jpg > http:\\/\\/conteudo.imguol.com.br\\/c\\/galeria\\/f5\\/2022\\/11\\/20\\/anitta-1668994741365_v2_1920x1080.jpg\",\"expires\":\"2022-12-06 16:19:12 > 2022-12-05 20:20:10\"}', '187.183.233.174'),
(303, 1670257210, 1, 'Updated', 'Media', 42, '{\"fileName\":\"hospital-israelita-albert-einstein-em-sao-paulo-onde-pele-esta-internado-1631921346913_v2_1920x1080.jpg > http:\\/\\/conteudo.imguol.com.br\\/c\\/esporte\\/67\\/2021\\/09\\/17\\/hospital-israelita-albert-einstein-em-sao-paulo-onde-pele-esta-internado-1631921346913_v2_1920x1080.jpg\",\"expires\":\"2022-12-06 16:19:12 > 2022-12-05 20:20:10\"}', '187.183.233.174'),
(304, 1670257210, 1, 'Updated', 'Media', 43, '{\"fileName\":\"torcida-do-santos-apoia-a-equipe-contra-o-palmeiras-no-paulistao-1461526369574_1920x1080.jpg > http:\\/\\/conteudo.imguol.com.br\\/c\\/esporte\\/5e\\/2016\\/04\\/24\\/torcida-do-santos-apoia-a-equipe-contra-o-palmeiras-no-paulistao-1461526369574_1920x1080.jpg\",\"expires\":\"2022-12-06 16:19:12 > 2022-12-05 20:20:10\"}', '187.183.233.174'),
(305, 1670257210, 1, 'Updated', 'Media', 44, '{\"fileName\":\"doneda-foi-membro-do-conselho-responsavel-por-orientar-a-agencia-nacional-de-protecao-de-dados-1670196018388_v2_1920x1080.jpg > http:\\/\\/conteudo.imguol.com.br\\/c\\/noticias\\/37\\/2022\\/12\\/04\\/doneda-foi-membro-do-conselho-responsavel-por-orientar-a-agencia-nacional-de-protecao-de-dados-1670196018388_v2_1920x1080.jpg\",\"expires\":\"2022-12-06 16:19:12 > 2022-12-05 20:20:10\"}', '187.183.233.174'),
(306, 1670257210, 1, 'Updated', 'Media', 45, '{\"fileName\":\"rafael-cardoso-e-mariana-bridi-1580926315017_v2_1920x1080.jpg > http:\\/\\/conteudo.imguol.com.br\\/c\\/entretenimento\\/2f\\/2020\\/02\\/05\\/rafael-cardoso-e-mariana-bridi-1580926315017_v2_1920x1080.jpg\",\"expires\":\"2022-12-06 16:19:12 > 2022-12-05 20:20:10\"}', '187.183.233.174'),
(307, 1670257210, 1, 'Updated', 'Media', 46, '{\"fileName\":\"jessica-ellen-e-alice-em-geracao-brasil-1398881721586_v2_1920x1080.jpg > http:\\/\\/conteudo.imguol.com.br\\/c\\/entretenimento\\/2014\\/04\\/30\\/jessica-ellen-e-alice-em-geracao-brasil-1398881721586_v2_1920x1080.jpg\",\"expires\":\"2022-12-06 16:19:12 > 2022-12-05 20:20:10\"}', '187.183.233.174'),
(308, 1670257210, 1, 'Updated', 'Media', 47, '{\"fileName\":\"nicolas-prattes-buscara-justica-em-todas-as-flores-1667257083709_v2_1920x1080.jpg > http:\\/\\/conteudo.imguol.com.br\\/c\\/entretenimento\\/e6\\/2022\\/10\\/31\\/nicolas-prattes-buscara-justica-em-todas-as-flores-1667257083709_v2_1920x1080.jpg\",\"expires\":\"2022-12-06 16:19:12 > 2022-12-05 20:20:10\"}', '187.183.233.174'),
(309, 1670257210, 1, 'Updated', 'Media', 48, '{\"fileName\":\"tiago-leifert-daiana-garbin-e-a-filha-lua-1663358671404_v2_1920x1080.jpg > http:\\/\\/conteudo.imguol.com.br\\/c\\/entretenimento\\/bc\\/2022\\/09\\/16\\/tiago-leifert-daiana-garbin-e-a-filha-lua-1663358671404_v2_1920x1080.jpg\",\"expires\":\"2022-12-06 16:19:12 > 2022-12-05 20:20:10\"}', '187.183.233.174'),
(310, 1670257471, 1, 'Deleted', 'Widget', 21, '{\"widgetId\":21,\"playlistId\":20}', '187.183.233.174'),
(311, 1670257471, 1, 'Deleted', 'Playlist', 20, '{\"playlistId\":20,\"regionId\":19}', '187.183.233.174'),
(312, 1670257471, 1, 'Region Deleted', 'Region', 19, '{\"regionId\":19,\"layoutId\":13}', '187.183.233.174'),
(313, 1670257471, 1, 'Layout Deleted', 'Layout', 13, '{\"layoutId\":13}', '187.183.233.174'),
(314, 1670257471, 1, 'Deleted draft for 3', 'Layout', 13, '[]', '187.183.233.174'),
(315, 1670257471, 1, 'Deleted', 'Widget', 12, '{\"widgetId\":12,\"playlistId\":12}', '187.183.233.174'),
(316, 1670257471, 1, 'Deleted', 'Playlist', 12, '{\"playlistId\":12,\"regionId\":9}', '187.183.233.174'),
(317, 1670257471, 1, 'Region Deleted', 'Region', 9, '{\"regionId\":9,\"layoutId\":3}', '187.183.233.174'),
(318, 1670257471, 1, 'Layout Deleted', 'Layout', 3, '{\"layoutId\":3}', '187.183.233.174'),
(319, 1670257471, 1, 'Deleted', 'Layout', 3, '[]', '187.183.233.174'),
(320, 1670257488, 1, 'Deleted', 'Widget', 14, '{\"widgetId\":14,\"playlistId\":13}', '187.183.233.174'),
(321, 1670257488, 1, 'Deleted', 'Playlist', 13, '{\"playlistId\":13,\"regionId\":12}', '187.183.233.174'),
(322, 1670257488, 1, 'Region Deleted', 'Region', 12, '{\"regionId\":12,\"layoutId\":6}', '187.183.233.174'),
(323, 1670257488, 1, 'Layout Deleted', 'Layout', 6, '{\"layoutId\":6}', '187.183.233.174'),
(324, 1670257488, 1, 'Deleted', 'Layout', 6, '[]', '187.183.233.174'),
(325, 1670257495, 1, 'Deleted', 'Widget', 16, '{\"widgetId\":16,\"playlistId\":15}', '187.183.233.174'),
(326, 1670257495, 1, 'Deleted', 'Playlist', 15, '{\"playlistId\":15,\"regionId\":14}', '187.183.233.174'),
(327, 1670257495, 1, 'Region Deleted', 'Region', 14, '{\"regionId\":14,\"layoutId\":8}', '187.183.233.174'),
(328, 1670257495, 1, 'Layout Deleted', 'Layout', 8, '{\"layoutId\":8}', '187.183.233.174'),
(329, 1670257495, 1, 'Deleted', 'Layout', 8, '[]', '187.183.233.174'),
(330, 1670257502, 1, 'Deleted', 'Widget', 11, '{\"widgetId\":11,\"playlistId\":11}', '187.183.233.174'),
(331, 1670257502, 1, 'Deleted', 'Playlist', 11, '{\"playlistId\":11,\"regionId\":11}', '187.183.233.174'),
(332, 1670257502, 1, 'Region Deleted', 'Region', 11, '{\"regionId\":11,\"layoutId\":4}', '187.183.233.174'),
(333, 1670257502, 1, 'Layout Deleted', 'Layout', 4, '{\"layoutId\":4}', '187.183.233.174'),
(334, 1670257502, 1, 'Deleted', 'Layout', 4, '[]', '187.183.233.174'),
(335, 1670257508, 1, 'Saved', 'Playlist', 14, '{\"campaignId\":[\"6\"],\"layoutId\":[\"7\"]}', '187.183.233.174'),
(336, 1670257515, 1, 'Deleted', 'Widget', 15, '{\"widgetId\":15,\"playlistId\":14}', '187.183.233.174'),
(337, 1670257515, 1, 'Deleted', 'Playlist', 14, '{\"playlistId\":14,\"regionId\":13}', '187.183.233.174'),
(338, 1670257515, 1, 'Region Deleted', 'Region', 13, '{\"regionId\":13,\"layoutId\":7}', '187.183.233.174'),
(339, 1670257515, 1, 'Layout Deleted', 'Layout', 7, '{\"layoutId\":7}', '187.183.233.174'),
(340, 1670257515, 1, 'Deleted', 'Layout', 7, '[]', '187.183.233.174'),
(341, 1670257522, 1, 'Deleted', 'Widget', 13, '{\"widgetId\":13,\"playlistId\":10}', '187.183.233.174'),
(342, 1670257522, 1, 'Deleted', 'Playlist', 10, '{\"playlistId\":10,\"regionId\":10}', '187.183.233.174'),
(343, 1670257522, 1, 'Region Deleted', 'Region', 10, '{\"regionId\":10,\"layoutId\":5}', '187.183.233.174'),
(344, 1670257522, 1, 'Layout Deleted', 'Layout', 5, '{\"layoutId\":5}', '187.183.233.174'),
(345, 1670257522, 1, 'Deleted', 'Layout', 5, '[]', '187.183.233.174'),
(346, 1670257527, 1, 'Deleted', 'Widget', 20, '{\"widgetId\":20,\"playlistId\":19}', '187.183.233.174'),
(347, 1670257527, 1, 'Deleted', 'Playlist', 19, '{\"playlistId\":19,\"regionId\":18}', '187.183.233.174'),
(348, 1670257527, 1, 'Region Deleted', 'Region', 18, '{\"regionId\":18,\"layoutId\":12}', '187.183.233.174'),
(349, 1670257527, 1, 'Layout Deleted', 'Layout', 12, '{\"layoutId\":12}', '187.183.233.174'),
(350, 1670257527, 1, 'Deleted', 'Layout', 12, '[]', '187.183.233.174'),
(351, 1670257533, 1, 'Deleted', 'Widget', 18, '{\"widgetId\":18,\"playlistId\":17}', '187.183.233.174'),
(352, 1670257533, 1, 'Deleted', 'Playlist', 17, '{\"playlistId\":17,\"regionId\":16}', '187.183.233.174'),
(353, 1670257533, 1, 'Region Deleted', 'Region', 16, '{\"regionId\":16,\"layoutId\":10}', '187.183.233.174'),
(354, 1670257533, 1, 'Layout Deleted', 'Layout', 10, '{\"layoutId\":10}', '187.183.233.174'),
(355, 1670257533, 1, 'Deleted', 'Layout', 10, '[]', '187.183.233.174'),
(356, 1670257539, 1, 'Deleted', 'Widget', 19, '{\"widgetId\":19,\"playlistId\":18}', '187.183.233.174'),
(357, 1670257539, 1, 'Deleted', 'Playlist', 18, '{\"playlistId\":18,\"regionId\":17}', '187.183.233.174'),
(358, 1670257539, 1, 'Region Deleted', 'Region', 17, '{\"regionId\":17,\"layoutId\":11}', '187.183.233.174'),
(359, 1670257539, 1, 'Layout Deleted', 'Layout', 11, '{\"layoutId\":11}', '187.183.233.174'),
(360, 1670257539, 1, 'Deleted', 'Layout', 11, '[]', '187.183.233.174'),
(361, 1670257545, 1, 'Deleted', 'Widget', 17, '{\"widgetId\":17,\"playlistId\":16}', '187.183.233.174'),
(362, 1670257545, 1, 'Deleted', 'Playlist', 16, '{\"playlistId\":16,\"regionId\":15}', '187.183.233.174'),
(363, 1670257545, 1, 'Region Deleted', 'Region', 15, '{\"regionId\":15,\"layoutId\":9}', '187.183.233.174'),
(364, 1670257545, 1, 'Layout Deleted', 'Layout', 9, '{\"layoutId\":9}', '187.183.233.174'),
(365, 1670257545, 1, 'Deleted', 'Layout', 9, '[]', '187.183.233.174'),
(366, 1670258003, 1, 'Updated', 'Settings', 0, '{\"GLOBAL_THEME_NAME\":\"default > mga\",\"RESTING_LOG_LEVEL\":\"Error > emergency\",\"audit\":\"Error > emergency\"}', '187.183.233.174'),
(367, 1670258011, 1, 'User logout', 'User', 1, '{\"UserAgent\":[\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/108.0.0.0 Safari\\/537.36\"]}', '187.183.233.174'),
(368, 1670258033, 1, 'Login Granted', 'User', 1, '{\"UserAgent\":[\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/108.0.0.0 Safari\\/537.36\"]}', '187.183.233.174'),
(369, 1670258137, 1, 'Updated', 'Settings', 0, '{\"DASHBOARD_LATEST_NEWS_ENABLED\":\"1 > 0\"}', '187.183.233.174'),
(370, 1670258165, 1, 'Updated', 'Settings', 0, '{\"DEFAULT_LANGUAGE\":\"en_GB > pt_BR\",\"defaultTimezone\":\"UTC > America\\/Sao_Paulo\",\"DATE_FORMAT\":\"Y-m-d H:i > d-m-Y H:i\",\"DETECT_LANGUAGE\":\"1 > 0\"}', '187.183.233.174'),
(371, 1670258204, 1, 'Tidy library started from Settings', 'Media', 0, '{\"tidyOldRevisions\":1,\"cleanUnusedFiles\":1,\"tidyGenericFiles\":1,\"initiator\":1}', '187.183.233.174'),
(372, 1670258204, 1, 'Deleted', 'Media', 1, '{\"mediaId\":1,\"name\":\"Logo\",\"mediaType\":\"image\",\"fileName\":\"xibo_logo_square.png\"}', '187.183.233.174'),
(373, 1670258204, 1, 'Deleted', 'Media', 26, '{\"mediaId\":26,\"name\":\"Logo\",\"mediaType\":\"image\",\"fileName\":\"splash.png\"}', '187.183.233.174'),
(374, 1670258204, 1, 'Deleted', 'Media', 27, '{\"mediaId\":27,\"name\":\"Logo\",\"mediaType\":\"image\",\"fileName\":\"splash.png\"}', '187.183.233.174'),
(375, 1670258204, 1, 'Tidy library from settings complete', 'Media', 0, '{\"countDeleted\":3,\"initiator\":1}', '187.183.233.174');

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

--
-- Estrutura da tabela `bandwidth`
--

CREATE TABLE `bandwidth` (
  `displayId` int(11) NOT NULL,
  `type` int(11) NOT NULL,
  `month` int(11) NOT NULL,
  `size` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Estrutura da tabela `bandwidthtype`
--

CREATE TABLE `bandwidthtype` (
  `bandwidthTypeId` int(11) NOT NULL,
  `name` varchar(25) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `bandwidthtype`
--

INSERT INTO `bandwidthtype` (`bandwidthTypeId`, `name`) VALUES
(1, 'Register'),
(2, 'Required Files'),
(3, 'Schedule'),
(4, 'Get File'),
(5, 'Get Resource'),
(6, 'Media Inventory'),
(7, 'Notify Status'),
(8, 'Submit Stats'),
(9, 'Submit Log'),
(10, 'Report Fault'),
(11, 'Screen Shot');

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

--
-- Estrutura da tabela `campaign`
--

CREATE TABLE `campaign` (
  `campaignId` int(11) NOT NULL,
  `campaign` varchar(254) NOT NULL,
  `isLayoutSpecific` tinyint(4) NOT NULL,
  `userId` int(11) NOT NULL,
  `folderId` int(11) NOT NULL DEFAULT '1',
  `permissionsFolderId` int(11) NOT NULL DEFAULT '1',
  `cyclePlaybackEnabled` tinyint(4) NOT NULL DEFAULT '0',
  `playCount` int(11) DEFAULT NULL,
  `type` varchar(10) NOT NULL DEFAULT 'list',
  `startDt` int(11) DEFAULT NULL,
  `endDt` int(11) DEFAULT NULL,
  `targetType` varchar(6) DEFAULT NULL,
  `target` int(11) DEFAULT NULL,
  `plays` int(11) NOT NULL DEFAULT '0',
  `spend` int(11) NOT NULL DEFAULT '0',
  `impressions` int(11) NOT NULL DEFAULT '0',
  `lastPopId` varchar(50) DEFAULT NULL,
  `listPlayOrder` varchar(6) NOT NULL DEFAULT 'round',
  `ref1` varchar(254) DEFAULT NULL,
  `ref2` varchar(254) DEFAULT NULL,
  `ref3` varchar(254) DEFAULT NULL,
  `ref4` varchar(254) DEFAULT NULL,
  `ref5` varchar(254) DEFAULT NULL,
  `createdAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modifiedAt` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `modifiedBy` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `campaign`
--

INSERT INTO `campaign` (`campaignId`, `campaign`, `isLayoutSpecific`, `userId`, `folderId`, `permissionsFolderId`, `cyclePlaybackEnabled`, `playCount`, `type`, `startDt`, `endDt`, `targetType`, `target`, `plays`, `spend`, `impressions`, `lastPopId`, `listPlayOrder`, `ref1`, `ref2`, `ref3`, `ref4`, `ref5`, `createdAt`, `modifiedAt`, `modifiedBy`) VALUES
(1, 'Default Layout', 1, 1, 1, 1, 0, 0, 'list', NULL, NULL, NULL, NULL, 0, 0, 0, NULL, 'round', NULL, NULL, NULL, NULL, NULL, '2022-12-05 16:12:31', '2022-12-05 16:13:55', 0);

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

--
-- Estrutura da tabela `command`
--

CREATE TABLE `command` (
  `commandId` int(11) NOT NULL,
  `command` varchar(254) NOT NULL,
  `code` varchar(50) NOT NULL,
  `description` varchar(1000) DEFAULT NULL,
  `userId` int(11) NOT NULL,
  `availableOn` varchar(50) DEFAULT NULL,
  `commandString` varchar(1000) DEFAULT NULL,
  `validationString` varchar(1000) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Estrutura da tabela `connectors`
--

CREATE TABLE `connectors` (
  `connectorId` int(11) NOT NULL,
  `className` varchar(254) NOT NULL,
  `settings` text,
  `isEnabled` tinyint(4) NOT NULL DEFAULT '0',
  `isVisible` tinyint(4) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `connectors`
--

INSERT INTO `connectors` (`connectorId`, `className`, `settings`, `isEnabled`, `isVisible`) VALUES
(1, '\\Xibo\\Connector\\PixabayConnector', NULL, 0, 1),
(2, '\\Xibo\\Connector\\XiboExchangeConnector', NULL, 0, 1),
(3, '\\Xibo\\Connector\\XiboDashboardConnector', NULL, 0, 1),
(4, '\\Xibo\\Connector\\XiboSspConnector', NULL, 0, 1),
(5, '\\Xibo\\Connector\\XiboAudienceReportingConnector', NULL, 0, 1);

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

--
-- Estrutura da tabela `dataset`
--

CREATE TABLE `dataset` (
  `dataSetId` int(11) NOT NULL,
  `dataSet` varchar(50) NOT NULL,
  `description` varchar(254) DEFAULT NULL,
  `userId` int(11) NOT NULL,
  `lastDataEdit` int(11) NOT NULL DEFAULT '0',
  `code` varchar(50) DEFAULT NULL,
  `isLookup` tinyint(4) NOT NULL,
  `isRemote` tinyint(4) NOT NULL DEFAULT '0',
  `method` enum('GET','POST') DEFAULT NULL,
  `uri` varchar(250) DEFAULT NULL,
  `postData` text,
  `authentication` varchar(10) DEFAULT NULL,
  `username` varchar(250) DEFAULT NULL,
  `password` varchar(250) DEFAULT NULL,
  `customHeaders` text,
  `userAgent` text,
  `refreshRate` int(11) NOT NULL DEFAULT '86400',
  `clearRate` int(11) NOT NULL DEFAULT '0',
  `truncateOnEmpty` tinyint(4) NOT NULL DEFAULT '0',
  `runsAfter` int(11) DEFAULT NULL,
  `dataRoot` varchar(250) DEFAULT NULL,
  `lastSync` int(11) NOT NULL DEFAULT '0',
  `summarize` varchar(10) DEFAULT NULL,
  `summarizeField` varchar(250) DEFAULT NULL,
  `lastClear` int(11) NOT NULL DEFAULT '0',
  `ignoreFirstRow` tinyint(4) DEFAULT NULL,
  `sourceId` tinyint(4) DEFAULT NULL,
  `rowLimit` int(11) DEFAULT NULL,
  `limitPolicy` varchar(50) DEFAULT NULL,
  `csvSeparator` varchar(5) DEFAULT NULL,
  `folderId` int(11) NOT NULL DEFAULT '1',
  `permissionsFolderId` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Estrutura da tabela `datasetcolumn`
--

CREATE TABLE `datasetcolumn` (
  `dataSetColumnId` int(11) NOT NULL,
  `dataSetId` int(11) NOT NULL,
  `heading` varchar(50) NOT NULL,
  `dataTypeId` int(11) NOT NULL,
  `dataSetColumnTypeId` int(11) NOT NULL,
  `listContent` varchar(1000) DEFAULT NULL,
  `columnOrder` smallint(6) NOT NULL,
  `formula` varchar(1000) DEFAULT NULL,
  `remoteField` varchar(250) DEFAULT NULL,
  `showFilter` tinyint(4) NOT NULL DEFAULT '1',
  `showSort` tinyint(4) NOT NULL DEFAULT '1',
  `tooltip` varchar(100) DEFAULT NULL,
  `isRequired` tinyint(4) NOT NULL DEFAULT '0',
  `dateFormat` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Estrutura da tabela `datasetcolumntype`
--

CREATE TABLE `datasetcolumntype` (
  `dataSetColumnTypeId` int(11) NOT NULL,
  `dataSetColumnType` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `datasetcolumntype`
--

INSERT INTO `datasetcolumntype` (`dataSetColumnTypeId`, `dataSetColumnType`) VALUES
(1, 'Value'),
(2, 'Formula'),
(3, 'Remote');

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

--
-- Estrutura da tabela `datasetrss`
--

CREATE TABLE `datasetrss` (
  `id` int(11) NOT NULL,
  `dataSetId` int(11) NOT NULL,
  `psk` varchar(254) NOT NULL,
  `title` varchar(254) NOT NULL,
  `author` varchar(254) NOT NULL,
  `titleColumnId` int(11) DEFAULT NULL,
  `summaryColumnId` int(11) DEFAULT NULL,
  `contentColumnId` int(11) DEFAULT NULL,
  `publishedDateColumnId` int(11) DEFAULT NULL,
  `sort` text,
  `filter` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Estrutura da tabela `datatype`
--

CREATE TABLE `datatype` (
  `dataTypeId` int(11) NOT NULL,
  `dataType` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `datatype`
--

INSERT INTO `datatype` (`dataTypeId`, `dataType`) VALUES
(1, 'String'),
(2, 'Number'),
(3, 'Date'),
(4, 'External Image'),
(5, 'Library Image'),
(6, 'HTML');

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

--
-- Estrutura da tabela `daypart`
--

CREATE TABLE `daypart` (
  `dayPartId` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `description` varchar(50) DEFAULT NULL,
  `isRetired` tinyint(4) NOT NULL DEFAULT '0',
  `userId` int(11) NOT NULL,
  `startTime` varchar(8) NOT NULL DEFAULT '00:00:00',
  `endTime` varchar(8) NOT NULL DEFAULT '00:00:00',
  `exceptions` text,
  `isAlways` tinyint(4) NOT NULL DEFAULT '0',
  `isCustom` tinyint(4) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `daypart`
--

INSERT INTO `daypart` (`dayPartId`, `name`, `description`, `isRetired`, `userId`, `startTime`, `endTime`, `exceptions`, `isAlways`, `isCustom`) VALUES
(1, 'Custom', 'User specifies the from/to date', 0, 1, '', '', '', 0, 1),
(2, 'Always', 'Event runs always', 0, 1, '', '', '', 1, 0);

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

--
-- Estrutura da tabela `display`
--

CREATE TABLE `display` (
  `displayId` int(11) NOT NULL,
  `display` varchar(50) NOT NULL,
  `displayTypeId` int(11) DEFAULT NULL,
  `screenSize` int(11) DEFAULT NULL,
  `languages` text,
  `address` text,
  `isMobile` tinyint(4) NOT NULL DEFAULT '0',
  `venueId` int(11) DEFAULT NULL,
  `auditingUntil` int(11) NOT NULL DEFAULT '0',
  `defaultLayoutId` int(11) NOT NULL,
  `license` varchar(40) DEFAULT NULL,
  `licensed` tinyint(4) NOT NULL DEFAULT '0',
  `loggedIn` tinyint(4) NOT NULL DEFAULT '0',
  `lastaccessed` int(11) DEFAULT NULL,
  `inc_schedule` tinyint(4) NOT NULL DEFAULT '0',
  `email_alert` int(11) DEFAULT '0',
  `alert_timeout` int(11) DEFAULT '0',
  `clientAddress` varchar(50) DEFAULT NULL,
  `mediaInventoryStatus` tinyint(4) NOT NULL DEFAULT '0',
  `macAddress` varchar(254) DEFAULT NULL,
  `lastChanged` int(11) DEFAULT NULL,
  `numberOfMacAddressChanges` int(11) DEFAULT '0',
  `lastWakeOnLanCommandSent` int(11) DEFAULT NULL,
  `wakeOnLan` tinyint(4) NOT NULL DEFAULT '0',
  `wakeOnLanTime` varchar(5) DEFAULT NULL,
  `broadCastAddress` varchar(100) DEFAULT NULL,
  `secureOn` varchar(17) DEFAULT NULL,
  `cidr` varchar(6) DEFAULT NULL,
  `geoLocation` point DEFAULT NULL,
  `client_type` varchar(20) DEFAULT NULL,
  `client_version` varchar(15) DEFAULT NULL,
  `client_code` smallint(6) DEFAULT NULL,
  `displayProfileId` int(11) DEFAULT NULL,
  `screenShotRequested` tinyint(4) NOT NULL DEFAULT '0',
  `storageAvailableSpace` bigint(20) DEFAULT NULL,
  `storageTotalSpace` bigint(20) DEFAULT NULL,
  `xmrChannel` varchar(254) DEFAULT NULL,
  `xmrPubKey` text,
  `lastCommandSuccess` tinyint(4) NOT NULL DEFAULT '2',
  `deviceName` varchar(254) DEFAULT NULL,
  `timeZone` varchar(254) DEFAULT NULL,
  `overrideConfig` text,
  `newCmsAddress` varchar(1000) DEFAULT NULL,
  `newCmsKey` varchar(40) DEFAULT NULL,
  `orientation` varchar(10) DEFAULT NULL,
  `resolution` varchar(10) DEFAULT NULL,
  `commercialLicence` tinyint(4) DEFAULT NULL,
  `teamViewerSerial` varchar(255) DEFAULT NULL,
  `webkeySerial` varchar(255) DEFAULT NULL,
  `lanIpAddress` varchar(50) DEFAULT NULL,
  `customId` varchar(254) DEFAULT NULL,
  `isOutdoor` tinyint(4) NOT NULL DEFAULT '0',
  `costPerPlay` int(11) DEFAULT NULL,
  `impressionsPerPlay` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Estrutura da tabela `displayevent`
--

CREATE TABLE `displayevent` (
  `displayEventId` int(11) NOT NULL,
  `eventDate` int(11) NOT NULL,
  `displayId` int(11) NOT NULL,
  `start` int(11) NOT NULL,
  `end` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Estrutura da tabela `displaygroup`
--

CREATE TABLE `displaygroup` (
  `displayGroupId` int(11) NOT NULL,
  `displayGroup` varchar(50) NOT NULL,
  `description` varchar(254) DEFAULT NULL,
  `isDisplaySpecific` tinyint(4) NOT NULL DEFAULT '0',
  `isDynamic` tinyint(4) NOT NULL DEFAULT '0',
  `dynamicCriteria` text,
  `dynamicCriteriaLogicalOperator` varchar(3) NOT NULL DEFAULT 'OR',
  `userId` int(11) NOT NULL,
  `dynamicCriteriaTags` varchar(254) DEFAULT NULL,
  `dynamicCriteriaExactTags` tinyint(4) NOT NULL DEFAULT '0',
  `dynamicCriteriaTagsLogicalOperator` varchar(3) NOT NULL DEFAULT 'OR',
  `bandwidthLimit` int(11) NOT NULL DEFAULT '0',
  `ref1` text,
  `ref2` text,
  `ref3` text,
  `ref4` text,
  `ref5` text,
  `createdDt` datetime DEFAULT NULL,
  `modifiedDt` datetime DEFAULT NULL,
  `folderId` int(11) NOT NULL DEFAULT '1',
  `permissionsFolderId` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Estrutura da tabela `displayprofile`
--

CREATE TABLE `displayprofile` (
  `displayProfileId` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `type` varchar(15) NOT NULL,
  `config` text,
  `isDefault` tinyint(4) NOT NULL DEFAULT '0',
  `userId` int(11) NOT NULL,
  `isCustom` tinyint(4) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `displayprofile`
--

INSERT INTO `displayprofile` (`displayProfileId`, `name`, `type`, `config`, `isDefault`, `userId`, `isCustom`) VALUES
(1, 'Windows', 'windows', '[]', 1, 1, 0),
(2, 'Android', 'android', '[]', 1, 1, 0),
(3, 'webOS', 'lg', '[]', 1, 1, 0),
(4, 'Tizen', 'sssp', '[]', 1, 1, 0),
(5, 'Linux', 'linux', '[]', 1, 1, 0);

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

--
-- Estrutura da tabela `display_types`
--

CREATE TABLE `display_types` (
  `displayTypeId` int(11) NOT NULL,
  `displayType` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `display_types`
--

INSERT INTO `display_types` (`displayTypeId`, `displayType`) VALUES
(1, 'Billboard'),
(2, 'Kiosk'),
(3, 'LED Matrix / LED Video Wall'),
(4, 'Monitor / Other'),
(5, 'Projector'),
(6, 'Shelf-edge Display'),
(7, 'Smart Mirror'),
(8, 'TV / Panel'),
(9, 'Tablet'),
(10, 'Totem');

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

--
-- Estrutura da tabela `folder`
--

CREATE TABLE `folder` (
  `folderId` int(11) NOT NULL,
  `folderName` varchar(255) NOT NULL,
  `parentId` int(11) DEFAULT NULL,
  `isRoot` int(11) NOT NULL DEFAULT '0',
  `children` text,
  `permissionsFolderId` int(11) DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `folder`
--

INSERT INTO `folder` (`folderId`, `folderName`, `parentId`, `isRoot`, `children`, `permissionsFolderId`) VALUES
(1, '/', NULL, 1, NULL, NULL);

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

--
-- Estrutura da tabela `group`
--

CREATE TABLE `group` (
  `groupId` int(11) NOT NULL,
  `group` varchar(50) NOT NULL,
  `isUserSpecific` tinyint(4) NOT NULL DEFAULT '0',
  `isEveryone` tinyint(4) NOT NULL DEFAULT '0',
  `libraryQuota` int(11) DEFAULT NULL,
  `isSystemNotification` tinyint(4) NOT NULL DEFAULT '0',
  `isDisplayNotification` tinyint(4) NOT NULL DEFAULT '0',
  `features` longtext,
  `description` varchar(500) DEFAULT NULL,
  `isShownForAddUser` tinyint(4) NOT NULL DEFAULT '0',
  `defaultHomepageId` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `group`
--

INSERT INTO `group` (`groupId`, `group`, `isUserSpecific`, `isEveryone`, `libraryQuota`, `isSystemNotification`, `isDisplayNotification`, `features`, `description`, `isShownForAddUser`, `defaultHomepageId`) VALUES
(1, 'Users', 0, 0, NULL, 0, 0, '[\"library.view\",\"library.add\",\"library.modify\",\"schedule.now\",\"icondashboard.view\",\"icondashboard.add\",\"icondashboard.modify\",\"schedule.view\",\"schedule.add\",\"schedule.modify\",\"playlist.view\",\"playlist.add\",\"playlist.modify\",\"layout.view\",\"layout.add\",\"layout.modify\",\"users.view\",\"users.add\",\"users.modify\",\"region.view\",\"region.add\",\"region.modify\",\"mediamanager.view\",\"mediamanager.add\",\"mediamanager.modify\",\"statusdashboard.view\",\"statusdashboard.add\",\"statusdashboard.modify\",\"preview.view\",\"preview.add\",\"preview.modify\",\"user.sharing\"]', NULL, 0, NULL),
(2, 'Everyone', 0, 1, NULL, 0, 0, NULL, NULL, 0, NULL),
(3, 'admin', 1, 0, 0, 1, 0, '[\"schedule.now\"]', NULL, 0, ''),
(4, 'System Notifications', 0, 0, NULL, 1, 0, '[\"schedule.now\"]', NULL, 0, NULL),
(5, 'Content Manager', 0, 0, NULL, 0, 0, '[\"folder.view\",\"folder.add\",\"folder.modify\",\"library.view\",\"library.add\",\"library.modify\",\"dataset.view\",\"dataset.add\",\"dataset.modify\",\"dataset.data\",\"playlist.view\",\"playlist.add\",\"playlist.modify\",\"layout.view\",\"layout.add\",\"layout.modify\",\"layout.export\",\"template.view\",\"template.add\",\"template.modify\",\"resolution.view\",\"resolution.add\",\"resolution.modify\",\"campaign.view\",\"campaign.add\",\"campaign.modify\",\"tag.view\",\"tag.tagging\",\"user.profile\"]', 'Management of all features related to Content Creation only.', 1, 'icondashboard.view'),
(6, 'Playlist Manager', 0, 0, NULL, 0, 0, '[\"user.profile\",\"dashboard.playlist\"]', 'Management of specific Playlists to edit / replace Media only.', 1, 'playlistdashboard.view'),
(7, 'Schedule Manager', 0, 0, NULL, 0, 0, '[\"folder.view\",\"schedule.view\",\"schedule.agenda\",\"schedule.add\",\"schedule.modify\",\"schedule.now\",\"daypart.view\",\"daypart.add\",\"daypart.modify\",\"user.profile\"]', 'Management of all features for the purpose of Event Scheduling only.', 1, 'icondashboard.view'),
(8, 'Display Manager', 0, 0, NULL, 0, 1, '[\"report.view\",\"displays.reporting\",\"proof-of-play\",\"folder.view\",\"folder.add\",\"folder.modify\",\"tag.tagging\",\"schedule.view\",\"schedule.agenda\",\"displays.view\",\"displays.add\",\"displays.modify\",\"displaygroup.view\",\"displaygroup.add\",\"displaygroup.modify\",\"displayprofile.view\",\"displayprofile.add\",\"displayprofile.modify\",\"playersoftware.view\",\"command.view\",\"user.profile\",\"notification.centre\",\"notification.add\",\"notification.modify\",\"dashboard.status\",\"log.view\"]', 'Management of all features for the purpose of Display Administration only.', 1, 'statusdashboard.view');

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

--
-- Estrutura da tabela `help`
--

CREATE TABLE `help` (
  `helpId` int(11) NOT NULL,
  `topic` varchar(254) NOT NULL,
  `category` varchar(254) NOT NULL DEFAULT 'General',
  `link` varchar(254) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `help`
--

INSERT INTO `help` (`helpId`, `topic`, `category`, `link`) VALUES
(1, 'Layout', 'General', 'layouts.html'),
(2, 'Content', 'General', 'media.html'),
(4, 'Schedule', 'General', 'scheduling.html'),
(5, 'Group', 'General', 'users_groups.html'),
(6, 'Admin', 'General', 'cms_settings.html'),
(7, 'Report', 'General', 'troubleshooting.html'),
(8, 'Dashboard', 'General', 'tour.html'),
(9, 'User', 'General', 'users.html'),
(10, 'Display', 'General', 'displays.html'),
(11, 'DisplayGroup', 'General', 'displays_groups.html'),
(12, 'Layout', 'Add', 'layouts.html#Add_Layout'),
(13, 'Layout', 'Background', 'layouts_designer.html#Background'),
(14, 'Content', 'Assign', 'layouts_playlists.html#Assigning_Content'),
(15, 'Layout', 'RegionOptions', 'layouts_regions.html'),
(16, 'Content', 'AddtoLibrary', 'media_library.html'),
(17, 'Display', 'Edit', 'displays.html#Display_Edit'),
(18, 'Display', 'Delete', 'displays.html#Display_Delete'),
(19, 'Displays', 'Groups', 'displays_groups.html#Group_Members'),
(20, 'UserGroup', 'Add', 'users_groups.html#Adding_Group'),
(21, 'User', 'Add', 'users_administration.html#Add_User'),
(22, 'User', 'Delete', 'users_administration.html#Delete_User'),
(23, 'Content', 'Config', 'cms_settings.html#Content'),
(24, 'LayoutMedia', 'Permissions', 'users_permissions.html'),
(25, 'Region', 'Permissions', 'users_permissions.html'),
(26, 'Library', 'Assign', 'layouts_playlists.html#Add_From_Library'),
(27, 'Media', 'Delete', 'media_library.html#Delete'),
(28, 'DisplayGroup', 'Add', 'displays_groups.html#Add_Group'),
(29, 'DisplayGroup', 'Edit', 'displays_groups.html#Edit_Group'),
(30, 'DisplayGroup', 'Delete', 'displays_groups.html#Delete_Group'),
(31, 'DisplayGroup', 'Members', 'displays_groups.html#Group_Members'),
(32, 'DisplayGroup', 'Permissions', 'users_permissions.html'),
(34, 'Schedule', 'ScheduleNow', 'scheduling_now.html'),
(35, 'Layout', 'Delete', 'layouts.html#Delete_Layout'),
(36, 'Layout', 'Copy', 'layouts.html#Copy_Layout'),
(37, 'Schedule', 'Edit', 'scheduling_events.html#Edit'),
(38, 'Schedule', 'Add', 'scheduling_events.html#Add'),
(39, 'Layout', 'Permissions', 'users_permissions.html'),
(40, 'Display', 'MediaInventory', 'displays.html#Media_Inventory'),
(41, 'User', 'ChangePassword', 'users.html#Change_Password'),
(42, 'Schedule', 'Delete', 'scheduling_events.html'),
(43, 'Layout', 'Edit', 'layouts_designer.html#Edit_Layout'),
(44, 'Media', 'Permissions', 'users_permissions.html'),
(45, 'Display', 'DefaultLayout', 'displays.html#DefaultLayout'),
(46, 'UserGroup', 'Edit', 'users_groups.html#Edit_Group'),
(47, 'UserGroup', 'Members', 'users_groups.html#Group_Member'),
(48, 'User', 'PageSecurity', 'users_permissions.html#Page_Security'),
(49, 'User', 'MenuSecurity', 'users_permissions.html#Menu_Security'),
(50, 'UserGroup', 'Delete', 'users_groups.html#Delete_Group'),
(51, 'User', 'Edit', 'users_administration.html#Edit_User'),
(52, 'User', 'Applications', 'users_administration.html#Users_MyApplications'),
(53, 'User', 'SetHomepage', 'users_administration.html#Media_Dashboard'),
(54, 'DataSet', 'General', 'media_datasets.html'),
(55, 'DataSet', 'Add', 'media_datasets.html#Create_Dataset'),
(56, 'DataSet', 'Edit', 'media_datasets.html#Edit_Dataset'),
(57, 'DataSet', 'Delete', 'media_datasets.html#Delete_Dataset'),
(58, 'DataSet', 'AddColumn', 'media_datasets.html#Dataset_Column'),
(59, 'DataSet', 'EditColumn', 'media_datasets.html#Dataset_Column'),
(60, 'DataSet', 'DeleteColumn', 'media_datasets.html#Dataset_Column'),
(61, 'DataSet', 'Data', 'media_datasets.html#Dataset_Row'),
(62, 'DataSet', 'Permissions', 'users_permissions.html'),
(63, 'Fault', 'General', 'troubleshooting.html#Report_Fault'),
(65, 'Stats', 'General', 'displays_metrics.html'),
(66, 'Resolution', 'General', 'layouts_resolutions.html'),
(67, 'Template', 'General', 'layouts_templates.html'),
(68, 'Services', 'Register', '#Registered_Applications'),
(69, 'OAuth', 'General', 'api_oauth.html'),
(70, 'Services', 'Log', 'api_oauth.html#oAuthLog'),
(71, 'Module', 'Edit', 'media_modules.html'),
(72, 'Module', 'General', 'media_modules.html'),
(73, 'Campaign', 'General', 'layouts_campaigns.html'),
(74, 'License', 'General', 'licence_information.html'),
(75, 'DataSet', 'ViewColumns', 'media_datasets.html#Dataset_Column'),
(76, 'Campaign', 'Permissions', 'users_permissions.html'),
(77, 'Transition', 'Edit', 'layouts_transitions.html'),
(78, 'User', 'SetPassword', 'users_administration.html#Set_Password'),
(79, 'DataSet', 'ImportCSV', 'media_datasets.htmlmedia_datasets.html#Import_CSV'),
(80, 'DisplayGroup', 'FileAssociations', 'displays_fileassociations.html'),
(81, 'Statusdashboard', 'General', 'tour_status_dashboard.html'),
(82, 'Displayprofile', 'General', 'displays_settings.html'),
(83, 'DisplayProfile', 'Edit', 'displays_settings.html#edit'),
(84, 'DisplayProfile', 'Delete', 'displays_settings.html#delete');

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

--
-- Estrutura da tabela `layout`
--

CREATE TABLE `layout` (
  `layoutId` int(11) NOT NULL,
  `layout` varchar(254) NOT NULL,
  `userId` int(11) NOT NULL,
  `createdDt` datetime DEFAULT NULL,
  `modifiedDt` datetime DEFAULT NULL,
  `description` varchar(254) DEFAULT NULL,
  `retired` tinyint(4) NOT NULL DEFAULT '0',
  `duration` int(11) NOT NULL,
  `backgroundImageId` int(11) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '0',
  `width` decimal(10,0) NOT NULL,
  `height` decimal(10,0) NOT NULL,
  `backgroundColor` varchar(25) DEFAULT NULL,
  `backgroundzIndex` int(11) NOT NULL DEFAULT '1',
  `schemaVersion` tinyint(4) NOT NULL DEFAULT '2',
  `statusMessage` text,
  `parentId` int(11) DEFAULT NULL,
  `publishedStatusId` int(11) NOT NULL DEFAULT '1',
  `enableStat` int(11) DEFAULT NULL,
  `publishedDate` datetime DEFAULT NULL,
  `autoApplyTransitions` tinyint(4) NOT NULL DEFAULT '0',
  `code` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `layout`
--

INSERT INTO `layout` (`layoutId`, `layout`, `userId`, `createdDt`, `modifiedDt`, `description`, `retired`, `duration`, `backgroundImageId`, `status`, `width`, `height`, `backgroundColor`, `backgroundzIndex`, `schemaVersion`, `statusMessage`, `parentId`, `publishedStatusId`, `enableStat`, `publishedDate`, `autoApplyTransitions`, `code`) VALUES
(2, 'Default Layout', 1, '2022-12-05 16:13:57', '2022-12-05 16:18:06', 'Default Layout assigned to Players to show in the event scheduled content cannot be shown.', 0, 60, 2, 1, '1920', '1080', '#03031a', 0, 3, NULL, NULL, 1, 0, NULL, 0, NULL);

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

--
-- Estrutura da tabela `layouthistory`
--

CREATE TABLE `layouthistory` (
  `layoutHistoryId` int(11) NOT NULL,
  `campaignId` int(11) NOT NULL,
  `layoutId` int(11) NOT NULL,
  `publishedDate` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `layouthistory`
--

INSERT INTO `layouthistory` (`layoutHistoryId`, `campaignId`, `layoutId`, `publishedDate`) VALUES
(1, 1, 1, '2022-12-05 16:12:31'),
(2, 1, 2, '2022-12-05 16:18:06');

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

--
-- Estrutura da tabela `lkcampaigndisplaygroup`
--

CREATE TABLE `lkcampaigndisplaygroup` (
  `campaignId` int(11) NOT NULL,
  `displayGroupId` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Estrutura da tabela `lkcampaignlayout`
--

CREATE TABLE `lkcampaignlayout` (
  `lkCampaignLayoutId` int(11) NOT NULL,
  `campaignId` int(11) NOT NULL,
  `layoutId` int(11) NOT NULL,
  `displayOrder` int(11) NOT NULL,
  `dayPartId` int(11) DEFAULT NULL,
  `daysOfWeek` varchar(50) DEFAULT NULL,
  `geoFence` mediumtext
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `lkcampaignlayout`
--

INSERT INTO `lkcampaignlayout` (`lkCampaignLayoutId`, `campaignId`, `layoutId`, `displayOrder`, `dayPartId`, `daysOfWeek`, `geoFence`) VALUES
(3, 1, 2, 2, NULL, NULL, NULL);

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

--
-- Estrutura da tabela `lkcommanddisplayprofile`
--

CREATE TABLE `lkcommanddisplayprofile` (
  `commandId` int(11) NOT NULL,
  `displayProfileId` int(11) NOT NULL,
  `commandString` varchar(1000) NOT NULL,
  `validationString` varchar(1000) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Estrutura da tabela `lkdgdg`
--

CREATE TABLE `lkdgdg` (
  `parentId` int(11) NOT NULL,
  `childId` int(11) NOT NULL,
  `depth` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Estrutura da tabela `lkdisplaydg`
--

CREATE TABLE `lkdisplaydg` (
  `LkDisplayDGID` int(11) NOT NULL,
  `displayGroupId` int(11) NOT NULL,
  `displayId` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Estrutura da tabela `lklayoutdisplaygroup`
--

CREATE TABLE `lklayoutdisplaygroup` (
  `id` int(11) NOT NULL,
  `displayGroupId` int(11) NOT NULL,
  `layoutId` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Estrutura da tabela `lkmediadisplaygroup`
--

CREATE TABLE `lkmediadisplaygroup` (
  `id` int(11) NOT NULL,
  `displayGroupId` int(11) NOT NULL,
  `mediaId` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Estrutura da tabela `lknotificationdg`
--

CREATE TABLE `lknotificationdg` (
  `lkNotificationDgId` int(11) NOT NULL,
  `notificationId` int(11) NOT NULL,
  `displayGroupId` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Estrutura da tabela `lknotificationgroup`
--

CREATE TABLE `lknotificationgroup` (
  `lkNotificationGroupId` int(11) NOT NULL,
  `notificationId` int(11) NOT NULL,
  `groupId` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Estrutura da tabela `lknotificationuser`
--

CREATE TABLE `lknotificationuser` (
  `lkNotificationUserId` int(11) NOT NULL,
  `notificationId` int(11) NOT NULL,
  `userId` int(11) NOT NULL,
  `read` tinyint(4) NOT NULL,
  `readDt` int(11) NOT NULL,
  `emailDt` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Estrutura da tabela `lkplaylistplaylist`
--

CREATE TABLE `lkplaylistplaylist` (
  `parentId` int(11) NOT NULL,
  `childId` int(11) NOT NULL,
  `depth` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `lkplaylistplaylist`
--

INSERT INTO `lkplaylistplaylist` (`parentId`, `childId`, `depth`) VALUES
(5, 5, 0),
(6, 6, 0),
(7, 7, 0),
(8, 8, 0),
(9, 9, 0);

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

--
-- Estrutura da tabela `lkscheduledisplaygroup`
--

CREATE TABLE `lkscheduledisplaygroup` (
  `eventId` int(11) NOT NULL,
  `displayGroupId` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Estrutura da tabela `lktagcampaign`
--

CREATE TABLE `lktagcampaign` (
  `lkTagCampaignId` int(11) NOT NULL,
  `tagId` int(11) NOT NULL,
  `campaignId` int(11) NOT NULL,
  `value` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Estrutura da tabela `lktagdisplaygroup`
--

CREATE TABLE `lktagdisplaygroup` (
  `lkTagDisplayGroupId` int(11) NOT NULL,
  `tagId` int(11) NOT NULL,
  `displayGroupId` int(11) NOT NULL,
  `value` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Estrutura da tabela `lktaglayout`
--

CREATE TABLE `lktaglayout` (
  `lkTagLayoutId` int(11) NOT NULL,
  `tagId` int(11) NOT NULL,
  `layoutId` int(11) NOT NULL,
  `value` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `lktaglayout`
--

INSERT INTO `lktaglayout` (`lkTagLayoutId`, `tagId`, `layoutId`, `value`) VALUES
(1, 4, 2, NULL);

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

--
-- Estrutura da tabela `lktagmedia`
--

CREATE TABLE `lktagmedia` (
  `lkTagMediaId` int(11) NOT NULL,
  `tagId` int(11) NOT NULL,
  `mediaId` int(11) NOT NULL,
  `value` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `lktagmedia`
--

INSERT INTO `lktagmedia` (`lkTagMediaId`, `tagId`, `mediaId`, `value`) VALUES
(2, 4, 2, NULL);

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

--
-- Estrutura da tabela `lktagplaylist`
--

CREATE TABLE `lktagplaylist` (
  `lkTagPlaylistId` int(11) NOT NULL,
  `tagId` int(11) NOT NULL,
  `playlistId` int(11) NOT NULL,
  `value` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Estrutura da tabela `lkusergroup`
--

CREATE TABLE `lkusergroup` (
  `lkUserGroupID` int(11) NOT NULL,
  `groupId` int(11) NOT NULL,
  `userId` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `lkusergroup`
--

INSERT INTO `lkusergroup` (`lkUserGroupID`, `groupId`, `userId`) VALUES
(1, 3, 1);

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

--
-- Estrutura da tabela `lkwidgetaudio`
--

CREATE TABLE `lkwidgetaudio` (
  `widgetId` int(11) NOT NULL,
  `mediaId` int(11) NOT NULL,
  `volume` tinyint(4) NOT NULL,
  `loop` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Estrutura da tabela `lkwidgetmedia`
--

CREATE TABLE `lkwidgetmedia` (
  `widgetId` int(11) NOT NULL,
  `mediaId` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `lkwidgetmedia`
--

INSERT INTO `lkwidgetmedia` (`widgetId`, `mediaId`) VALUES
(9, 28);

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

--
-- Estrutura da tabela `log`
--

CREATE TABLE `log` (
  `logId` int(11) NOT NULL,
  `runNo` varchar(10) NOT NULL,
  `logDate` datetime DEFAULT NULL,
  `channel` varchar(20) NOT NULL,
  `type` varchar(254) NOT NULL,
  `page` varchar(50) NOT NULL,
  `function` varchar(50) DEFAULT NULL,
  `message` longtext NOT NULL,
  `userId` int(11) NOT NULL DEFAULT '0',
  `displayId` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `log`
--

INSERT INTO `log` (`logId`, `runNo`, `logDate`, `channel`, `type`, `page`, `function`, `message`, `userId`, `displayId`) VALUES
(1, '934f654', '2022-12-05 16:12:06', 'WEB', 'ERROR', '/login', 'GET', 'Library not writable', 0, 0),
(2, '46b2a94', '2022-12-05 16:13:08', 'WEB', 'ERROR', '/user/pref', 'GET', 'Opção de usuário não encontrada', 0, 0),
(3, 'c45a509', '2022-12-05 16:13:22', 'WEB', 'ERROR', '/user/pref', 'GET', 'Opção de usuário não encontrada', 0, 0),
(4, 'd8bb7b4', '2022-12-05 16:13:22', 'WEB', 'ERROR', '/user/pref', 'GET', 'Opção de usuário não encontrada', 0, 0),
(5, '3fa2640', '2022-12-05 16:13:40', 'WEB', 'ERROR', '/user/pref', 'GET', 'Opção de usuário não encontrada', 0, 0),
(6, '3fd9a92', '2022-12-05 16:13:55', 'WEB', 'ERROR', '/user/pref', 'GET', 'Opção de usuário não encontrada', 0, 0),
(7, 'fe2319b', '2022-12-05 16:13:56', 'WEB', 'ERROR', '/user/pref', 'GET', 'Opção de usuário não encontrada', 0, 0),
(8, 'a39083d', '2022-12-05 16:18:09', 'WEB', 'ERROR', '/user/pref', 'GET', 'Opção de usuário não encontrada', 0, 0),
(9, 'fdec399', '2022-12-05 16:18:10', 'WEB', 'ERROR', '/user/pref', 'GET', 'Opção de usuário não encontrada', 0, 0),
(10, '1f2985d', '2022-12-05 16:19:09', 'WEB', 'ERROR', '/user/pref', 'GET', 'Opção de usuário não encontrada', 0, 0),
(11, 'c5c5b40', '2022-12-05 16:19:09', 'WEB', 'ERROR', '/user/pref', 'GET', 'Opção de usuário não encontrada', 0, 0),
(12, '69fb303', '2022-12-05 16:26:01', 'WEB', 'ERROR', '/user/pref', 'GET', 'Opção de usuário não encontrada', 0, 0),
(13, 'f81e8f4', '2022-12-05 16:26:32', 'WEB', 'ERROR', '/user/pref', 'GET', 'Opção de usuário não encontrada', 0, 0),
(14, 'e5c7582', '2022-12-05 16:27:20', 'WEB', 'ERROR', '/user/pref', 'GET', 'Opção de usuário não encontrada', 0, 0);

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

--
-- Estrutura da tabela `media`
--

CREATE TABLE `media` (
  `mediaId` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `type` varchar(15) NOT NULL,
  `duration` int(11) NOT NULL,
  `originalFileName` varchar(254) DEFAULT NULL,
  `storedAs` varchar(254) DEFAULT NULL,
  `md5` varchar(32) DEFAULT NULL,
  `fileSize` bigint(20) DEFAULT NULL,
  `userId` int(11) NOT NULL,
  `retired` tinyint(4) NOT NULL DEFAULT '0',
  `isEdited` tinyint(4) NOT NULL DEFAULT '0',
  `editedMediaId` int(11) DEFAULT NULL,
  `moduleSystemFile` tinyint(4) NOT NULL DEFAULT '0',
  `valid` tinyint(4) NOT NULL DEFAULT '1',
  `expires` int(11) DEFAULT NULL,
  `released` tinyint(4) NOT NULL DEFAULT '1',
  `apiRef` varchar(254) DEFAULT NULL,
  `createdDt` datetime DEFAULT NULL,
  `modifiedDt` datetime DEFAULT NULL,
  `enableStat` varchar(255) DEFAULT NULL,
  `folderId` int(11) NOT NULL DEFAULT '1',
  `permissionsFolderId` int(11) NOT NULL DEFAULT '1',
  `orientation` varchar(10) DEFAULT NULL,
  `width` mediumint(9) DEFAULT NULL,
  `height` mediumint(9) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `media`
--

INSERT INTO `media` (`mediaId`, `name`, `type`, `duration`, `originalFileName`, `storedAs`, `md5`, `fileSize`, `userId`, `retired`, `isEdited`, `editedMediaId`, `moduleSystemFile`, `valid`, `expires`, `released`, `apiRef`, `createdDt`, `modifiedDt`, `enableStat`, `folderId`, `permissionsFolderId`, `orientation`, `width`, `height`) VALUES
(2, 'Default Layout Background', 'image', 10, 'default layout3 background.jpg', '2.jpg', '1723376616232e8d354f4362c9670fa0', 119781, 1, 0, 0, NULL, 0, 1, 0, 1, NULL, '2022-12-05 16:12:31', '2022-12-05 16:12:31', 'Inherit', 1, 1, 'landscape', 1920, 1080),
(3, 'jquery.min.js', 'module', 0, 'jquery.min.js', 'jquery.min.js', '12b69d0ae6c6f0c42942ae6da2896e84', 89475, 1, 0, 0, 0, 1, 1, 0, 1, NULL, '2022-12-05 16:12:31', '2022-12-05 16:12:31', NULL, 1, 1, NULL, 0, 0),
(4, 'xibo-layout-scaler.js', 'module', 0, 'xibo-layout-scaler.js', 'xibo-layout-scaler.js', '89c01844f224241b0f5ad7b7b2d1a856', 6245, 1, 0, 0, 0, 1, 1, 0, 1, NULL, '2022-12-05 16:12:31', '2022-12-05 16:12:31', NULL, 1, 1, NULL, 0, 0),
(5, 'xibo-interactive-control.min.js', 'module', 0, 'xibo-interactive-control.min.js', 'xibo-interactive-control.min.js', 'd2e448d751d8180c0ed4f70d583227f8', 5270, 1, 0, 0, 0, 1, 1, 0, 1, NULL, '2022-12-05 16:12:31', '2022-12-05 16:12:31', NULL, 1, 1, NULL, 0, 0),
(6, 'moment.js', 'module', 0, 'moment.js', 'moment.js', '373de90432311a7e68d41b264fcb8d8e', 369309, 1, 0, 0, 0, 1, 1, 0, 1, NULL, '2022-12-05 16:12:31', '2022-12-05 16:12:31', NULL, 1, 1, NULL, 0, 0),
(7, 'xibo-text-render.js', 'module', 0, 'xibo-text-render.js', 'xibo-text-render.js', '45bc3100d39425badc06a49aad1261b6', 14559, 1, 0, 0, 0, 1, 1, 0, 1, NULL, '2022-12-05 16:12:31', '2022-12-05 16:12:31', NULL, 1, 1, NULL, 0, 0),
(8, 'xibo-calendar-render.js', 'module', 0, 'xibo-calendar-render.js', 'xibo-calendar-render.js', '566d2ee06c532cee1da036bd7ac8bb0e', 41208, 1, 0, 0, NULL, 1, 1, 0, 1, NULL, '2022-12-05 16:12:31', '2022-12-05 16:12:31', NULL, 1, 1, NULL, NULL, NULL),
(9, 'Chart.min.js', 'module', 0, 'Chart.min.js', 'Chart.min.js', 'f6c8efa65711e0cbbc99ba72997ecd0e', 159638, 1, 0, 0, NULL, 1, 1, 0, 1, NULL, '2022-12-05 16:12:31', '2022-12-05 16:12:31', NULL, 1, 1, NULL, NULL, NULL),
(10, 'jquery-cycle-2.1.6.min.js', 'module', 0, 'jquery-cycle-2.1.6.min.js', 'jquery-cycle-2.1.6.min.js', '212480cf1292db459557814e2d7a571d', 28876, 1, 0, 0, 0, 1, 1, 0, 1, NULL, '2022-12-05 16:12:31', '2022-12-05 16:12:31', NULL, 1, 1, NULL, 0, 0),
(11, 'flipclock.min.js', 'module', 0, 'flipclock.min.js', 'flipclock.min.js', 'b9d7742384bdf912c51b6a1b5d674f7a', 21107, 1, 0, 0, NULL, 1, 1, 0, 1, NULL, '2022-12-05 16:12:31', '2022-12-05 16:12:31', NULL, 1, 1, NULL, NULL, NULL),
(12, 'xibo-countdown-render.js', 'module', 0, 'xibo-countdown-render.js', 'xibo-countdown-render.js', '9b001984b29274f0c347330311345e3d', 5846, 1, 0, 0, NULL, 1, 1, 0, 1, NULL, '2022-12-05 16:12:31', '2022-12-05 16:12:31', NULL, 1, 1, NULL, NULL, NULL),
(13, 'jquery.marquee.min.js', 'module', 0, 'jquery.marquee.min.js', 'jquery.marquee.min.js', '15f24e1fda583562dbfeabf2ee6a3d26', 11795, 1, 0, 0, 0, 1, 1, 0, 1, NULL, '2022-12-05 16:12:31', '2022-12-05 16:12:31', NULL, 1, 1, NULL, 0, 0),
(14, 'xibo-image-render.js', 'module', 0, 'xibo-image-render.js', 'xibo-image-render.js', '6152d3e99b2c61bb3db365d108337483', 2988, 1, 0, 0, 0, 1, 1, 0, 1, NULL, '2022-12-05 16:12:31', '2022-12-05 16:12:31', NULL, 1, 1, NULL, 0, 0),
(15, 'xibo-dataset-render.js', 'module', 0, 'xibo-dataset-render.js', 'xibo-dataset-render.js', 'e04ad2bff2a293cc7c7e162a9ef1a4c8', 1687, 1, 0, 0, NULL, 1, 1, 0, 1, NULL, '2022-12-05 16:12:31', '2022-12-05 16:12:31', NULL, 1, 1, NULL, NULL, NULL),
(16, 'Aileron Heavy Regular', 'font', 0, 'Aileron-Heavy.otf', '16.otf', '621ba5aaf66e52f3def0cf69807104b9', 30060, 1, 0, 0, NULL, 0, 1, 0, 1, NULL, '2022-12-05 16:12:31', '2022-12-05 16:12:31', NULL, 1, 1, NULL, NULL, NULL),
(17, 'Aileron Regular', 'font', 0, 'Aileron-Regular.otf', '17.otf', 'd321fa78bb7190a8ca7e14213ef63203', 27644, 1, 0, 0, NULL, 0, 1, 0, 1, NULL, '2022-12-05 16:12:31', '2022-12-05 16:12:31', NULL, 1, 1, NULL, NULL, NULL),
(18, 'Dancing Script Regular', 'font', 0, 'DancingScript-Regular.ttf', '18.ttf', '86aadd0451f9e7dafa957e1e61dd2ed7', 116580, 1, 0, 0, NULL, 0, 1, 0, 1, NULL, '2022-12-05 16:12:31', '2022-12-05 16:12:31', NULL, 1, 1, NULL, NULL, NULL),
(19, 'Railway Regular', 'font', 0, 'Railway.ttf', '19.ttf', '58963d3a57da7a70ac36d331416746c5', 45884, 1, 0, 0, NULL, 0, 1, 0, 1, NULL, '2022-12-05 16:12:31', '2022-12-05 16:12:31', NULL, 1, 1, NULL, NULL, NULL),
(20, 'Linear Regular', 'font', 0, 'linear-by-braydon-fuller.otf', '20.otf', 'afb33470c582079834acd8b9f979ce1a', 19684, 1, 0, 0, NULL, 0, 1, 0, 1, NULL, '2022-12-05 16:12:31', '2022-12-05 16:12:31', NULL, 1, 1, NULL, NULL, NULL),
(21, 'pdf.js', 'module', 0, 'pdf.js', 'pdf.js', 'bef617263de936f84ac22131cf2144af', 767405, 1, 0, 0, NULL, 1, 1, 0, 1, NULL, '2022-12-05 16:12:31', '2022-12-05 16:12:31', NULL, 1, 1, NULL, NULL, NULL),
(22, 'pdf.worker.js', 'module', 0, 'pdf.worker.js', 'pdf.worker.js', '5c3e932eaab386051de8d60d9a9ae45c', 1692977, 1, 0, 0, NULL, 1, 1, 0, 1, NULL, '2022-12-05 16:12:31', '2022-12-05 16:12:31', NULL, 1, 1, NULL, NULL, NULL),
(23, 'xibo-webpage-render.js', 'module', 0, 'xibo-webpage-render.js', 'xibo-webpage-render.js', 'd59f5fc84ef7747f27baddc07fe81487', 4832, 1, 0, 0, NULL, 1, 1, 0, 1, NULL, '2022-12-05 16:12:31', '2022-12-05 16:12:31', NULL, 1, 1, NULL, NULL, NULL),
(24, 'xibo-worldclock-render.js', 'module', 0, 'xibo-worldclock-render.js', 'xibo-worldclock-render.js', '83b3026fbc8ebd81d281bbd64b903e19', 4019, 1, 0, 0, NULL, 1, 1, 0, 1, NULL, '2022-12-05 16:12:31', '2022-12-05 16:12:31', NULL, 1, 1, NULL, NULL, NULL),
(25, 'moment-timezone.js', 'module', 0, 'moment-timezone.js', 'moment-timezone.js', 'fdc029099ff760ace501b4b92799ac74', 185127, 1, 0, 0, NULL, 1, 1, 0, 1, NULL, '2022-12-05 16:12:31', '2022-12-05 16:12:31', NULL, 1, 1, NULL, NULL, NULL),
(28, 'Logo', 'image', 10, 'splash.png', '28.png', '53713a589b811e00b1b0e3418c641e5c', 75093, 1, 0, 0, NULL, 0, 1, NULL, 1, NULL, '2022-12-05 16:17:05', '2022-12-05 16:17:05', 'Inherit', 1, 1, 'landscape', 1920, 1080),
(29, 'ticker_7a50d8e36d2cde50b039fbc298c14503', 'module', 0, 'bianca-andrade-na-gravacao-do-numanice-2-de-ludmilla-1658663345178_v2_1920x1080.jpg', 'ticker_7a50d8e36d2cde50b039fbc298c14503', '427cc7cdae37023e3c3cf3f0de3c5ca8', 128352, 1, 0, 0, 0, 0, 1, 1670271610, 1, NULL, '2022-12-05 16:19:11', '2022-12-05 16:20:10', NULL, 1, 1, 'landscape', 1920, 1080),
(30, 'ticker_6cf6f9055a9d5347448b9689bf69d916', 'module', 0, 'pele-o-rei-do-futebol-idolo-do-santos-e-tricampeao-mundial-com-a-selecao-brasileira-em-outubro-de-2018-1669832303881_v2_1920x1080.jpg', 'ticker_6cf6f9055a9d5347448b9689bf69d916', 'e5279ba70c3cb47eb8e6c983671e8e8e', 208011, 1, 0, 0, 0, 0, 1, 1670271610, 1, NULL, '2022-12-05 16:19:11', '2022-12-05 16:20:10', NULL, 1, 1, 'landscape', 1920, 1080),
(31, 'ticker_16da5eec921b54354ec4560ec2f911a0', 'module', 0, 'gwendoline-christie-chega-ao-globo-de-ouro-2018-1515374794390_v2_1920x1080.jpg', 'ticker_16da5eec921b54354ec4560ec2f911a0', 'd23ee809f95337b68a9ef2fde7104faf', 200960, 1, 0, 0, 0, 0, 1, 1670271610, 1, NULL, '2022-12-05 16:19:11', '2022-12-05 16:20:10', NULL, 1, 1, 'landscape', 1920, 1080),
(32, 'ticker_31620e48683fb8c6fcae14c27ac20025', 'module', 0, 'pele-comemora-86-anos-foto-reproducao-1666538102213_v2_1920x1080.jpg', 'ticker_31620e48683fb8c6fcae14c27ac20025', '72b4609f7307efadcc8159c756dba72e', 104736, 1, 0, 0, 0, 0, 1, 1670271610, 1, NULL, '2022-12-05 16:19:11', '2022-12-05 16:20:10', NULL, 1, 1, 'landscape', 1920, 1080),
(33, 'ticker_771f2a3f696799f19e48994eab6de1eb', 'module', 0, 'kanye-west-1666905889351_v2_1920x1080.jpg', 'ticker_771f2a3f696799f19e48994eab6de1eb', '76680da4765d1acc7831e18516d6d45e', 92557, 1, 0, 0, 0, 0, 1, 1670271610, 1, NULL, '2022-12-05 16:19:11', '2022-12-05 16:20:10', NULL, 1, 1, 'landscape', 1920, 1080),
(34, 'ticker_7b75cc911576c0e61d9c77a683a2f45e', 'module', 0, 'caetano-veloso-1660039825454_v2_1920x1080.jpg', 'ticker_7b75cc911576c0e61d9c77a683a2f45e', '24a1ec2d0a96af9f57a64f7be548772a', 111236, 1, 0, 0, 0, 0, 1, 1670271610, 1, NULL, '2022-12-05 16:19:11', '2022-12-05 16:20:10', NULL, 1, 1, 'landscape', 1920, 1080),
(35, 'ticker_b188482bfa87e56bfc6a71140451ca28', 'module', 0, 'igor-jansen-estrei-na-tv-em-as-aventuras-de-poliana-1527713846044_v2_1920x1080.jpg', 'ticker_b188482bfa87e56bfc6a71140451ca28', '02e3bd5471296709916cffb3cd4a5bad', 202748, 1, 0, 0, 0, 0, 1, 1670271610, 1, NULL, '2022-12-05 16:19:11', '2022-12-05 16:20:10', NULL, 1, 1, 'landscape', 1920, 1080),
(36, 'ticker_66888c9d3b2592f508d9c1e1b792092b', 'module', 0, 'fatima-bernardes-voltou-hoje-de-ferias-1643033051496_v2_1920x1080.png', 'ticker_66888c9d3b2592f508d9c1e1b792092b', '1d23f303abb1fe5564ac9e7933a1fd98', 887051, 1, 0, 0, 0, 0, 1, 1670271610, 1, NULL, '2022-12-05 16:19:11', '2022-12-05 16:20:10', NULL, 1, 1, 'landscape', 1920, 1080),
(37, 'ticker_577a68c44b721baaa4272f911b16b65d', 'module', 0, 'kat-torres-1464195554940_1920x1080.jpg', 'ticker_577a68c44b721baaa4272f911b16b65d', '2ab956ea5ac5a82c03028727ee4cdfe4', 289185, 1, 0, 0, 0, 0, 1, 1670271610, 1, NULL, '2022-12-05 16:19:11', '2022-12-05 16:20:10', NULL, 1, 1, 'landscape', 1920, 1080),
(38, 'ticker_109ed991fc8e0d50e05cf2b3ee122934', 'module', 0, 'sem-filtro---angelica-retrato-remoto-1602007427901_v2_1920x1080.jpg', 'ticker_109ed991fc8e0d50e05cf2b3ee122934', '990c3ac4a12ee64359fb96bb44bd16e8', 174688, 1, 0, 0, 0, 0, 1, 1670271610, 1, NULL, '2022-12-05 16:19:11', '2022-12-05 16:20:10', NULL, 1, 1, 'landscape', 1920, 1080),
(39, 'ticker_b179fdec3c63550d26edae18363f79f6', 'module', 0, 'adriano-imperador-se-surpreendeu-com-a-homenagem-feita-pelos-torcedores-da-inter-de-milao-1650448405569_v2_1920x1080.jpg', 'ticker_b179fdec3c63550d26edae18363f79f6', 'fc0f31fd081a565b54769b3e580a32c5', 147558, 1, 0, 0, 0, 0, 1, 1670271610, 1, NULL, '2022-12-05 16:19:11', '2022-12-05 16:20:10', NULL, 1, 1, 'landscape', 1920, 1080),
(40, 'ticker_2dfb13aeaa27b6652366750e71db46ba', 'module', 0, 'viih-tube-anuncia-que-esta-gravida-de-eliezer-1663683587073_v2_1920x1080.png', 'ticker_2dfb13aeaa27b6652366750e71db46ba', '3de8ba54747492f7329a3c19e2057db1', 830838, 1, 0, 0, 0, 0, 1, 1670271610, 1, NULL, '2022-12-05 16:19:11', '2022-12-05 16:20:10', NULL, 1, 1, 'landscape', 1920, 1080),
(41, 'ticker_70804ed4fd23baebfd8a15270b81bd88', 'module', 0, 'anitta-1668994741365_v2_1920x1080.jpg', 'ticker_70804ed4fd23baebfd8a15270b81bd88', '4eb4bddcf46d4b005dcf56c760000600', 147829, 1, 0, 0, 0, 0, 1, 1670271610, 1, NULL, '2022-12-05 16:19:11', '2022-12-05 16:20:10', NULL, 1, 1, 'landscape', 1920, 1080),
(42, 'ticker_f6e6fec4ae6b593b3c93694e2a77e1c4', 'module', 0, 'hospital-israelita-albert-einstein-em-sao-paulo-onde-pele-esta-internado-1631921346913_v2_1920x1080.jpg', 'ticker_f6e6fec4ae6b593b3c93694e2a77e1c4', '468f8b9bb718e31aaeda0e48396bec99', 318234, 1, 0, 0, 0, 0, 1, 1670271610, 1, NULL, '2022-12-05 16:19:11', '2022-12-05 16:20:10', NULL, 1, 1, 'landscape', 1920, 1080),
(43, 'ticker_2735a6d23c09ed4b487f97f1c27e11e9', 'module', 0, 'torcida-do-santos-apoia-a-equipe-contra-o-palmeiras-no-paulistao-1461526369574_1920x1080.jpg', 'ticker_2735a6d23c09ed4b487f97f1c27e11e9', '6c67193c47c4dda5475457e109ca47fb', 536609, 1, 0, 0, 0, 0, 1, 1670271610, 1, NULL, '2022-12-05 16:19:11', '2022-12-05 16:20:10', NULL, 1, 1, 'landscape', 1920, 1080),
(44, 'ticker_3c7a2795011cd2000c188ceb3753f1d3', 'module', 0, 'doneda-foi-membro-do-conselho-responsavel-por-orientar-a-agencia-nacional-de-protecao-de-dados-1670196018388_v2_1920x1080.jpg', 'ticker_3c7a2795011cd2000c188ceb3753f1d3', '0fd6f6288cd9e2bc3482e929c7819332', 322396, 1, 0, 0, 0, 0, 1, 1670271610, 1, NULL, '2022-12-05 16:19:11', '2022-12-05 16:20:10', NULL, 1, 1, 'landscape', 1920, 1080),
(45, 'ticker_089a7330a13a9653f4133a7960ce6b40', 'module', 0, 'rafael-cardoso-e-mariana-bridi-1580926315017_v2_1920x1080.jpg', 'ticker_089a7330a13a9653f4133a7960ce6b40', '594d576446d1b09b3d911caa4ae096f4', 134810, 1, 0, 0, 0, 0, 1, 1670271610, 1, NULL, '2022-12-05 16:19:11', '2022-12-05 16:20:10', NULL, 1, 1, 'landscape', 1920, 1080),
(46, 'ticker_0c3a2771ba2f4002a03cf75e67748c31', 'module', 0, 'jessica-ellen-e-alice-em-geracao-brasil-1398881721586_v2_1920x1080.jpg', 'ticker_0c3a2771ba2f4002a03cf75e67748c31', 'eca1c0ada6892452d80e86b6dd3917dc', 189958, 1, 0, 0, 0, 0, 1, 1670271610, 1, NULL, '2022-12-05 16:19:11', '2022-12-05 16:20:10', NULL, 1, 1, 'landscape', 1920, 1080),
(47, 'ticker_5a3bfc623f799d4f8d4ee050ee36f620', 'module', 0, 'nicolas-prattes-buscara-justica-em-todas-as-flores-1667257083709_v2_1920x1080.jpg', 'ticker_5a3bfc623f799d4f8d4ee050ee36f620', '0244478518137da36da0846388fd852d', 202059, 1, 0, 0, 0, 0, 1, 1670271610, 1, NULL, '2022-12-05 16:19:11', '2022-12-05 16:20:10', NULL, 1, 1, 'landscape', 1920, 1080),
(48, 'ticker_14c15a96c9cbf1659a678b5226630627', 'module', 0, 'tiago-leifert-daiana-garbin-e-a-filha-lua-1663358671404_v2_1920x1080.jpg', 'ticker_14c15a96c9cbf1659a678b5226630627', 'afa71f6882f524a19560ca9c2202743c', 196435, 1, 0, 0, 0, 0, 1, 1670271610, 1, NULL, '2022-12-05 16:19:11', '2022-12-05 16:20:10', NULL, 1, 1, 'landscape', 1920, 1080);

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

--
-- Estrutura da tabela `menu_board`
--

CREATE TABLE `menu_board` (
  `menuId` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `description` varchar(254) DEFAULT NULL,
  `code` varchar(50) DEFAULT NULL,
  `userId` int(11) NOT NULL,
  `modifiedDt` int(11) NOT NULL DEFAULT '0',
  `folderId` int(11) NOT NULL DEFAULT '1',
  `permissionsFolderId` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Estrutura da tabela `menu_category`
--

CREATE TABLE `menu_category` (
  `menuCategoryId` int(11) NOT NULL,
  `menuId` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `mediaId` int(11) DEFAULT NULL,
  `code` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Estrutura da tabela `menu_product`
--

CREATE TABLE `menu_product` (
  `menuProductId` int(11) NOT NULL,
  `menuCategoryId` int(11) NOT NULL,
  `menuId` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `price` varchar(255) NOT NULL,
  `description` varchar(254) DEFAULT NULL,
  `mediaId` int(11) DEFAULT NULL,
  `availability` tinyint(4) NOT NULL,
  `allergyInfo` varchar(254) DEFAULT NULL,
  `code` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Estrutura da tabela `menu_product_options`
--

CREATE TABLE `menu_product_options` (
  `menuProductId` int(11) NOT NULL,
  `option` varchar(254) NOT NULL,
  `value` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Estrutura da tabela `module`
--

CREATE TABLE `module` (
  `moduleId` int(11) NOT NULL,
  `module` varchar(50) NOT NULL,
  `name` varchar(50) NOT NULL,
  `enabled` tinyint(4) NOT NULL DEFAULT '0',
  `regionSpecific` tinyint(4) NOT NULL DEFAULT '1',
  `description` varchar(254) DEFAULT NULL,
  `schemaVersion` int(11) NOT NULL DEFAULT '1',
  `validExtensions` varchar(254) DEFAULT NULL,
  `previewEnabled` tinyint(4) NOT NULL DEFAULT '1',
  `assignable` tinyint(4) NOT NULL DEFAULT '1',
  `render_as` varchar(10) DEFAULT NULL,
  `settings` text,
  `viewPath` varchar(254) NOT NULL DEFAULT '../modules',
  `class` varchar(254) NOT NULL,
  `defaultDuration` int(11) NOT NULL,
  `installName` varchar(254) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `module`
--

INSERT INTO `module` (`moduleId`, `module`, `name`, `enabled`, `regionSpecific`, `description`, `schemaVersion`, `validExtensions`, `previewEnabled`, `assignable`, `render_as`, `settings`, `viewPath`, `class`, `defaultDuration`, `installName`) VALUES
(1, 'Image', 'Image', 1, 0, 'Upload Image files to assign to Layouts', 1, 'jpg,jpeg,png,bmp,gif', 1, 1, NULL, NULL, '../modules', 'Xibo\\Widget\\Image', 10, NULL),
(2, 'Video', 'Video', 1, 0, 'Upload Video files to assign to Layouts', 1, 'wmv,avi,mpg,mpeg,webm,mp4,m4v', 1, 1, NULL, NULL, '../modules', 'Xibo\\Widget\\Video', 0, NULL),
(4, 'PowerPoint', 'PowerPoint', 1, 0, 'Upload a PowerPoint file to assign to Layouts', 1, 'ppt,pps,pptx', 1, 1, NULL, NULL, '../modules', 'Xibo\\Widget\\PowerPoint', 10, NULL),
(5, 'Webpage', 'Webpage', 1, 1, 'Embed a Webpage', 1, NULL, 1, 1, NULL, NULL, '../modules', 'Xibo\\Widget\\WebPage', 60, NULL),
(6, 'Ticker', 'Ticker', 1, 1, 'Display dynamic feed content', 1, NULL, 1, 1, NULL, '[]', '../modules', 'Xibo\\Widget\\Ticker', 5, NULL),
(7, 'Text', 'Text', 1, 1, 'Add Text directly to a Layout', 1, NULL, 1, 1, NULL, NULL, '../modules', 'Xibo\\Widget\\Text', 5, NULL),
(8, 'Embedded', 'Embedded', 1, 1, 'Embed HTML and JavaScript', 1, NULL, 1, 1, NULL, NULL, '../modules', 'Xibo\\Widget\\Embedded', 60, NULL),
(11, 'datasetview', 'DataSet View', 1, 1, 'Organise and display DataSet data in a tabular format', 1, NULL, 1, 1, NULL, NULL, '../modules', 'Xibo\\Widget\\DataSetView', 60, NULL),
(12, 'shellcommand', 'Shell Command', 1, 1, 'Instruct a Display to execute a command using the operating system shell', 1, NULL, 1, 1, NULL, NULL, '../modules', 'Xibo\\Widget\\ShellCommand', 3, NULL),
(13, 'localvideo', 'Local Video', 1, 1, 'Display Video that only exists on the Display by providing a local file path or URL', 1, NULL, 0, 1, NULL, NULL, '../modules', 'Xibo\\Widget\\LocalVideo', 60, NULL),
(14, 'genericfile', 'Generic File', 1, 0, 'A generic file to be stored in the library', 1, ',js,html,htm', 0, 0, NULL, NULL, '../modules', 'Xibo\\Widget\\GenericFile', 10, NULL),
(15, 'clock', 'Clock', 1, 1, 'Assign a type of Clock or a Countdown', 1, NULL, 1, 1, 'html', '[]', '../modules', 'Xibo\\Widget\\Clock', 5, NULL),
(16, 'font', 'Font', 1, 0, 'A font to use in other Modules', 1, 'ttf,otf,eot,svg,woff', 0, 0, NULL, NULL, '../modules', 'Xibo\\Widget\\Font', 10, NULL),
(17, 'audio', 'Audio', 1, 0, 'Upload Audio files to assign to Layouts', 1, 'mp3,wav', 0, 1, NULL, NULL, '../modules', 'Xibo\\Widget\\Audio', 0, NULL),
(18, 'pdf', 'PDF', 1, 0, 'Upload PDF files to assign to Layouts', 1, 'pdf', 1, 1, 'html', NULL, '../modules', 'Xibo\\Widget\\Pdf', 60, NULL),
(19, 'notificationview', 'Notification', 1, 1, 'Display messages created in the Notification Drawer of the CMS', 1, NULL, 1, 1, 'html', NULL, '../modules', 'Xibo\\Widget\\NotificationView', 10, NULL),
(20, 'subplaylist', 'Sub-Playlist', 1, 1, 'Embed a Sub-Playlist', 1, NULL, 1, 1, 'native', NULL, '../modules', 'Xibo\\Widget\\SubPlaylist', 10, NULL),
(21, 'datasetticker', 'DataSet Ticker', 1, 1, 'Ticker with a DataSet providing the items', 1, NULL, 1, 1, 'html', NULL, '../modules', 'Xibo\\Widget\\DataSetTicker', 10, NULL),
(22, 'playersoftware', 'Player Software', 1, 0, 'A module for managing Player Versions', 1, 'apk,ipk,wgt', 0, 0, NULL, NULL, '../modules', 'Xibo\\Widget\\PlayerSoftware', 10, NULL),
(23, 'htmlpackage', 'HTML Package', 1, 0, 'Upload a complete package to distribute to Players', 1, 'htz', 0, 1, 'native', NULL, '../modules', 'Xibo\\Widget\\HtmlPackage', 60, NULL),
(24, 'videoin', 'Video In', 1, 1, 'Display input from an external source', 1, NULL, 0, 1, 'native', NULL, '../modules', 'Xibo\\Widget\\VideoIn', 60, NULL),
(25, 'hls', 'HLS', 1, 1, 'Display live streamed content', 1, NULL, 1, 1, 'html', NULL, '../modules', 'Xibo\\Widget\\Hls', 60, NULL),
(26, 'calendaradvanced', 'Calendar', 1, 1, 'Display events from an iCAL feed', 1, NULL, 1, 1, 'html', NULL, '../modules', 'Xibo\\Widget\\Calendar', 60, 'calendaradvanced'),
(27, 'chart', 'Chart', 1, 1, 'Display information held in a DataSet as a type of Chart', 1, NULL, 1, 1, 'html', NULL, '../modules', 'Xibo\\Widget\\Chart', 240, NULL),
(28, 'savedreport', 'Saved Reports', 1, 0, 'A saved report to be stored in the library', 1, 'json', 0, 0, NULL, NULL, '../modules', 'Xibo\\Widget\\SavedReport', 10, 'savedreport'),
(29, 'spacer', 'Spacer', 1, 1, 'Make a Region empty for a specified duration', 1, NULL, 0, 1, 'html', NULL, '../modules', 'Xibo\\Widget\\Spacer', 60, 'spacer'),
(30, 'countdown', 'Countdown', 1, 1, 'Countdown Module', 1, NULL, 1, 1, 'html', NULL, '../modules', 'Xibo\\Widget\\Countdown', 60, 'countdown'),
(31, 'menuboard', 'Menu Board', 0, 1, 'Module for displaying Menu Boards', 1, '', 1, 1, 'html', NULL, '../modules', 'Xibo\\Widget\\MenuBoard', 60, 'menuboard'),
(32, 'calendar', 'Agenda', 1, 1, 'A module for displaying an agenda based on an iCal feed', 1, '', 1, 1, 'html', NULL, '../modules', 'Xibo\\Widget\\Agenda', 60, 'calendar'),
(33, 'worldclock', 'World Clock', 1, 1, 'WorldClock Module', 1, NULL, 1, 1, 'html', NULL, '../modules', 'Xibo\\Widget\\WorldClock', 60, 'worldclock');

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

--
-- Estrutura da tabela `notification`
--

CREATE TABLE `notification` (
  `notificationId` int(11) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `body` longtext NOT NULL,
  `createDt` int(11) NOT NULL,
  `releaseDt` int(11) NOT NULL,
  `isEmail` tinyint(4) NOT NULL,
  `isInterrupt` tinyint(4) NOT NULL,
  `isSystem` tinyint(4) NOT NULL,
  `userId` int(11) NOT NULL,
  `filename` varchar(1000) DEFAULT NULL,
  `nonusers` varchar(1000) DEFAULT NULL,
  `originalFileName` varchar(254) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Estrutura da tabela `oauth_clients`
--

CREATE TABLE `oauth_clients` (
  `id` varchar(254) NOT NULL,
  `secret` varchar(254) NOT NULL,
  `name` varchar(254) NOT NULL,
  `userId` int(11) NOT NULL,
  `authCode` tinyint(4) NOT NULL,
  `clientCredentials` tinyint(4) NOT NULL,
  `isConfidential` tinyint(4) NOT NULL DEFAULT '1',
  `description` varchar(254) DEFAULT NULL,
  `logo` varchar(254) DEFAULT NULL,
  `coverImage` varchar(254) DEFAULT NULL,
  `companyName` varchar(254) DEFAULT NULL,
  `termsUrl` varchar(254) DEFAULT NULL,
  `privacyUrl` varchar(254) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Estrutura da tabela `oauth_client_redirect_uris`
--

CREATE TABLE `oauth_client_redirect_uris` (
  `id` int(11) NOT NULL,
  `client_id` varchar(254) NOT NULL,
  `redirect_uri` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Estrutura da tabela `oauth_client_scopes`
--

CREATE TABLE `oauth_client_scopes` (
  `id` int(11) NOT NULL,
  `clientId` varchar(254) NOT NULL,
  `scopeId` varchar(254) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Estrutura da tabela `oauth_lkclientuser`
--

CREATE TABLE `oauth_lkclientuser` (
  `lkClientUserId` int(11) NOT NULL,
  `clientId` varchar(255) NOT NULL,
  `userId` int(11) NOT NULL,
  `approvedDate` datetime DEFAULT NULL,
  `approvedIp` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Estrutura da tabela `oauth_scopes`
--

CREATE TABLE `oauth_scopes` (
  `id` varchar(254) NOT NULL,
  `description` varchar(1000) NOT NULL,
  `useRegex` tinyint(4) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `oauth_scopes`
--

INSERT INTO `oauth_scopes` (`id`, `description`, `useRegex`) VALUES
('all', 'Full account access', 0),
('datasets', 'Access to DataSets', 1),
('datasetsDelete', 'Access to deleting DataSets', 1),
('design', 'Access to Library, Layouts, Playlists, Widgets and Resolutions', 1),
('designDelete', 'Access to deleting content from Library, Layouts, Playlists, Widgets and Resolutions', 1),
('displays', 'Access to Displays and Display Groups', 1),
('displaysDelete', 'Access to deleting Displays and Display Groups', 0),
('mcaas', 'Media Conversion as a Service', 0),
('schedule', 'Access to Scheduling', 1),
('scheduleDelete', 'Access to deleting Scheduled Events', 1);

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

--
-- Estrutura da tabela `oauth_scope_routes`
--

CREATE TABLE `oauth_scope_routes` (
  `id` int(11) NOT NULL,
  `scopeId` varchar(254) NOT NULL,
  `route` varchar(1000) NOT NULL,
  `method` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `oauth_scope_routes`
--

INSERT INTO `oauth_scope_routes` (`id`, `scopeId`, `route`, `method`) VALUES
(1, 'mcaas', '/', 'GET'),
(2, 'mcaas', '/library/download/{id}[/{type}]', 'GET'),
(3, 'mcaas', '/library/mcaas/{id}', 'POST'),
(4, 'design', '/library', 'GET,POST,PUT'),
(5, 'design', '/layout', 'GET,POST,PUT'),
(6, 'design', '/playlist', 'GET,POST,PUT'),
(7, 'designDelete', '/library', 'DELETE'),
(8, 'designDelete', '/layout', 'DELETE'),
(9, 'designDelete', '/playlist', 'DELETE'),
(10, 'displays', '/display', 'GET,POST,PUT'),
(11, 'displays', '/displaygroup', 'GET,POST,PUT'),
(12, 'displaysDelete', '/display/{id}', 'DELETE'),
(13, 'displaysDelete', '/displaygroup/{id}', 'DELETE'),
(14, 'schedule', '/schedule', 'GET,POST,PUT'),
(15, 'scheduleDelete', '/schedule', 'DELETE'),
(16, 'datasets', '/dataset', 'GET,POST,PUT'),
(17, 'datasetsDelete', '/dataset', 'DELETE'),
(18, 'design', '/resolution', 'GET,POST,PUT'),
(19, 'designDelete', '/resolution', 'DELETE');

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

--
-- Estrutura da tabela `permission`
--

CREATE TABLE `permission` (
  `permissionId` int(11) NOT NULL,
  `entityId` int(11) NOT NULL,
  `groupId` int(11) NOT NULL,
  `objectId` int(11) NOT NULL,
  `view` tinyint(4) NOT NULL,
  `edit` tinyint(4) NOT NULL,
  `delete` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `permission`
--

INSERT INTO `permission` (`permissionId`, `entityId`, `groupId`, `objectId`, `view`, `edit`, `delete`) VALUES
(12, 11, 2, 1, 1, 0, 0),
(13, 11, 2, 2, 1, 0, 0),
(18, 3, 2, 16, 1, 0, 0),
(19, 3, 2, 17, 1, 0, 0),
(20, 3, 2, 18, 1, 0, 0),
(21, 3, 2, 19, 1, 0, 0),
(22, 3, 2, 20, 1, 0, 0);

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

--
-- Estrutura da tabela `permissionentity`
--

CREATE TABLE `permissionentity` (
  `entityId` int(11) NOT NULL,
  `entity` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `permissionentity`
--

INSERT INTO `permissionentity` (`entityId`, `entity`) VALUES
(4, 'Xibo\\Entity\\Campaign'),
(12, 'Xibo\\Entity\\Command'),
(9, 'Xibo\\Entity\\DataSet'),
(11, 'Xibo\\Entity\\DayPart'),
(2, 'Xibo\\Entity\\DisplayGroup'),
(13, 'Xibo\\Entity\\Folder'),
(3, 'Xibo\\Entity\\Media'),
(14, 'Xibo\\Entity\\MenuBoard'),
(10, 'Xibo\\Entity\\Notification'),
(8, 'Xibo\\Entity\\Playlist'),
(7, 'Xibo\\Entity\\Region'),
(5, 'Xibo\\Entity\\Widget');

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

--
-- Estrutura da tabela `phinxlog`
--

CREATE TABLE `phinxlog` (
  `version` bigint(20) NOT NULL,
  `migration_name` varchar(100) DEFAULT NULL,
  `start_time` timestamp NULL DEFAULT NULL,
  `end_time` timestamp NULL DEFAULT NULL,
  `breakpoint` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `phinxlog`
--

INSERT INTO `phinxlog` (`version`, `migration_name`, `start_time`, `end_time`, `breakpoint`) VALUES
(20180130073838, 'InstallMigration', '2022-12-05 19:11:48', '2022-12-05 19:11:49', 0),
(20180131113100, 'OldUpgradeStep85Migration', '2022-12-05 19:11:49', '2022-12-05 19:11:49', 0),
(20180131113853, 'OldUpgradeStep86Migration', '2022-12-05 19:11:49', '2022-12-05 19:11:49', 0),
(20180131113941, 'OldUpgradeStep87Migration', '2022-12-05 19:11:49', '2022-12-05 19:11:49', 0),
(20180131113948, 'OldUpgradeStep88Migration', '2022-12-05 19:11:49', '2022-12-05 19:11:49', 0),
(20180131113952, 'OldUpgradeStep92Migration', '2022-12-05 19:11:49', '2022-12-05 19:11:49', 0),
(20180131113957, 'OldUpgradeStep120Migration', '2022-12-05 19:11:49', '2022-12-05 19:11:49', 0),
(20180131114002, 'OldUpgradeStep121Migration', '2022-12-05 19:11:49', '2022-12-05 19:11:49', 0),
(20180131114007, 'OldUpgradeStep122Migration', '2022-12-05 19:11:49', '2022-12-05 19:11:49', 0),
(20180131114013, 'OldUpgradeStep123Migration', '2022-12-05 19:11:49', '2022-12-05 19:11:49', 0),
(20180131114017, 'OldUpgradeStep124Migration', '2022-12-05 19:11:49', '2022-12-05 19:11:49', 0),
(20180131114021, 'OldUpgradeStep125Migration', '2022-12-05 19:11:49', '2022-12-05 19:11:49', 0),
(20180131114025, 'OldUpgradeStep126Migration', '2022-12-05 19:11:49', '2022-12-05 19:11:49', 0),
(20180131114030, 'OldUpgradeStep127Migration', '2022-12-05 19:11:49', '2022-12-05 19:11:49', 0),
(20180131114050, 'OldUpgradeStep128Migration', '2022-12-05 19:11:49', '2022-12-05 19:11:49', 0),
(20180131114058, 'OldUpgradeStep129Migration', '2022-12-05 19:11:49', '2022-12-05 19:11:49', 0),
(20180131114103, 'OldUpgradeStep130Migration', '2022-12-05 19:11:49', '2022-12-05 19:11:49', 0),
(20180131114107, 'OldUpgradeStep131Migration', '2022-12-05 19:11:49', '2022-12-05 19:11:49', 0),
(20180131114110, 'OldUpgradeStep132Migration', '2022-12-05 19:11:49', '2022-12-05 19:11:49', 0),
(20180131114114, 'OldUpgradeStep133Migration', '2022-12-05 19:11:49', '2022-12-05 19:11:49', 0),
(20180131114118, 'OldUpgradeStep134Migration', '2022-12-05 19:11:49', '2022-12-05 19:11:49', 0),
(20180131114123, 'OldUpgradeStep135Migration', '2022-12-05 19:11:49', '2022-12-05 19:11:49', 0),
(20180131122645, 'OneRegionPerPlaylistMigration', '2022-12-05 19:11:49', '2022-12-05 19:11:49', 0),
(20180131123038, 'PlaylistTagsMigration', '2022-12-05 19:11:49', '2022-12-05 19:11:49', 0),
(20180131123248, 'WidgetFromToDtMigration', '2022-12-05 19:11:49', '2022-12-05 19:11:49', 0),
(20180212143336, 'DaypartSystemEntriesAsRecords', '2022-12-05 19:11:49', '2022-12-05 19:11:50', 0),
(20180213173846, 'MailFromNameSettingMigration', '2022-12-05 19:11:50', '2022-12-05 19:11:50', 0),
(20180219141257, 'DisplayGroupClosureIndexToNonUnique', '2022-12-05 19:11:50', '2022-12-05 19:11:50', 0),
(20180223180534, 'DataSetColumnFilterAndSortOptionsMigration', '2022-12-05 19:11:50', '2022-12-05 19:11:50', 0),
(20180302182421, 'WidgetCreatedAndModifiedDtMigration', '2022-12-05 19:11:50', '2022-12-05 19:11:50', 0),
(20180313085749, 'MediaTableEditedIdIndexMigration', '2022-12-05 19:11:50', '2022-12-05 19:11:50', 0),
(20180320154652, 'PlaylistAddDynamicFilterMigration', '2022-12-05 19:11:50', '2022-12-05 19:11:50', 0),
(20180327153325, 'RemoveUserLoggedInMigration', '2022-12-05 19:11:50', '2022-12-05 19:11:50', 0),
(20180514114415, 'FixCaseOnHelpTextFieldMigration', '2022-12-05 19:11:50', '2022-12-05 19:11:50', 0),
(20180515123835, 'LayoutPublishDraftMigration', '2022-12-05 19:11:50', '2022-12-05 19:11:50', 0),
(20180529065816, 'DataSetTruncateFixMigration', '2022-12-05 19:11:50', '2022-12-05 19:11:50', 0),
(20180529073531, 'DisplayAsVncLinkMigration', '2022-12-05 19:11:50', '2022-12-05 19:11:50', 0),
(20180621134013, 'AddWidgetSyncTaskMigration', '2022-12-05 19:11:50', '2022-12-05 19:11:50', 0),
(20180621134250, 'EventLayoutPermissionSettingMigration', '2022-12-05 19:11:50', '2022-12-05 19:11:50', 0),
(20180906115552, 'AddForeignKeysToTagsMigration', '2022-12-05 19:11:50', '2022-12-05 19:11:50', 0),
(20180906115606, 'AddForeignKeysToPermissionsMigration', '2022-12-05 19:11:50', '2022-12-05 19:11:50', 0),
(20180906115712, 'AddForeignKeysToWidgetMediaMigration', '2022-12-05 19:11:50', '2022-12-05 19:11:50', 0),
(20180906131643, 'ForgottenPasswordReminderMigration', '2022-12-05 19:11:50', '2022-12-05 19:11:50', 0),
(20180906131716, 'DataSetRssMigration', '2022-12-05 19:11:50', '2022-12-05 19:11:50', 0),
(20181011160130, 'SimpleSettingsMigration', '2022-12-05 19:11:50', '2022-12-05 19:11:51', 0),
(20181113173310, 'RemoveFinanceModuleMigration', '2022-12-05 19:11:51', '2022-12-05 19:11:51', 0),
(20181113180337, 'SplitTickerModuleMigration', '2022-12-05 19:11:51', '2022-12-05 19:11:51', 0),
(20181126113231, 'Release1812Migration', '2022-12-05 19:11:51', '2022-12-05 19:11:51', 0),
(20181210092443, 'RemoveImageUriModuleMigration', '2022-12-05 19:11:51', '2022-12-05 19:11:51', 0),
(20181212114400, 'CreatePlayerVersionsTableMigration', '2022-12-05 19:11:51', '2022-12-05 19:11:51', 0),
(20181217135044, 'EventSyncMigration', '2022-12-05 19:11:51', '2022-12-05 19:11:51', 0),
(20190121092556, 'PlayerUpgradeAndOverrideConfigMigration', '2022-12-05 19:11:51', '2022-12-05 19:11:51', 0),
(20190125170130, 'PlayerSoftwareVersionFieldMigration', '2022-12-05 19:11:51', '2022-12-05 19:11:51', 0),
(20190129103831, 'AddLinuxDisplayProfileMigration', '2022-12-05 19:11:51', '2022-12-05 19:11:51', 0),
(20190212112534, 'AddProofOfPlayStatsDurationAndCountMigration', '2022-12-05 19:11:51', '2022-12-05 19:11:51', 0),
(20190212115432, 'AddDefaultTransitionDurationSettingMigration', '2022-12-05 19:11:51', '2022-12-05 19:11:51', 0),
(20190213160914, 'AddGlobalStatSettingMigration', '2022-12-05 19:11:51', '2022-12-05 19:11:51', 0),
(20190213162212, 'AddHorizontalMenuSettingMigration', '2022-12-05 19:11:51', '2022-12-05 19:11:51', 0),
(20190214102508, 'AddLayoutEnableStat', '2022-12-05 19:11:51', '2022-12-05 19:11:51', 0),
(20190214102516, 'AddMediaEnableStat', '2022-12-05 19:11:51', '2022-12-05 19:11:51', 0),
(20190220165703, 'AddScheduleRecurrenceMonthlyRepeatsOnMigration', '2022-12-05 19:11:51', '2022-12-05 19:11:51', 0),
(20190227101705, 'MakeDisplayLicenseColumnUniqueMigration', '2022-12-05 19:11:51', '2022-12-05 19:11:51', 0),
(20190228120603, 'AddDynamicCriteriaTagsMigration', '2022-12-05 19:11:51', '2022-12-05 19:11:51', 0),
(20190301115046, 'AdjustGenericfileValidExtensionsMigration', '2022-12-05 19:11:51', '2022-12-05 19:11:51', 0),
(20190315134628, 'AddBandwidthLimitColumnToDisplaygroupMigration', '2022-12-05 19:11:51', '2022-12-05 19:11:51', 0),
(20190322162052, 'AddPublishedDateColumnMigration', '2022-12-05 19:11:51', '2022-12-05 19:11:51', 0),
(20190326163016, 'CreateLayoutHistoryTableMigration', '2022-12-05 19:11:51', '2022-12-05 19:11:51', 0),
(20190328111718, 'AddCampaignStatMigration', '2022-12-05 19:11:51', '2022-12-05 19:11:51', 0),
(20190401150256, 'AddScheduleNowPageMigration', '2022-12-05 19:11:51', '2022-12-05 19:11:51', 0),
(20190509101525, 'CreateReportScheduleTableMigration', '2022-12-05 19:11:51', '2022-12-05 19:11:51', 0),
(20190509102648, 'CreateSavedReportTableMigration', '2022-12-05 19:11:51', '2022-12-05 19:11:51', 0),
(20190509113001, 'AddReportPageMigration', '2022-12-05 19:11:51', '2022-12-05 19:11:51', 0),
(20190510140126, 'TwoFactorAuthMigration', '2022-12-05 19:11:51', '2022-12-05 19:11:51', 0),
(20190514134430, 'NullableTextFieldsMigration', '2022-12-05 19:11:51', '2022-12-05 19:11:52', 0),
(20190515094133, 'AddHtmlDatatypeMigration', '2022-12-05 19:11:52', '2022-12-05 19:11:52', 0),
(20190515105624, 'InstallAdditionalStandardModulesMigration', '2022-12-05 19:11:52', '2022-12-05 19:11:52', 0),
(20190517080033, 'AddForeignKeysToLktagTablesMigration', '2022-12-05 19:11:52', '2022-12-05 19:11:52', 0),
(20190521092700, 'AddReportScheduleTaskMigration', '2022-12-05 19:11:52', '2022-12-05 19:11:52', 0),
(20190521092930, 'AddPreviousRunDateReportScheduleMigration', '2022-12-05 19:11:52', '2022-12-05 19:11:52', 0),
(20190521102635, 'PlaylistDurationUpdateAtTimestamp', '2022-12-05 19:11:52', '2022-12-05 19:11:52', 0),
(20190603083836, 'ChangeStatTableStartEndColumnMigration', '2022-12-05 19:11:52', '2022-12-05 19:11:52', 0),
(20190610150331, 'TagsWithValuesMigration', '2022-12-05 19:11:52', '2022-12-05 19:11:52', 0),
(20190611145607, 'RemoveOldVersionTableMigration', '2022-12-05 19:11:52', '2022-12-05 19:11:52', 0),
(20190612140955, 'DisplayTableDatabaseSchemaAdjustmentsMigration', '2022-12-05 19:11:52', '2022-12-05 19:11:52', 0),
(20190620112611, 'MoveTidyStatsToStatsArchiveTaskMigration', '2022-12-05 19:11:52', '2022-12-05 19:11:52', 0),
(20190620142655, 'AddPlaylistEnableStatMigration', '2022-12-05 19:11:52', '2022-12-05 19:11:52', 0),
(20190626091331, 'WidgetHistoryMigration', '2022-12-05 19:11:52', '2022-12-05 19:11:52', 0),
(20190626110359, 'CreateStatTableMigration', '2022-12-05 19:11:52', '2022-12-05 19:11:52', 0),
(20190628083649, 'AddStatsMigrationTaskMigration', '2022-12-05 19:11:52', '2022-12-05 19:11:52', 0),
(20190710213414, 'AddIsActiveReportScheduleMigration', '2022-12-05 19:11:52', '2022-12-05 19:11:52', 0),
(20190717101342, 'NullableCommandValidationStringMigration', '2022-12-05 19:11:52', '2022-12-05 19:11:52', 0),
(20190719074601, 'MissingDefaultValueMigration', '2022-12-05 19:11:52', '2022-12-05 19:11:52', 0),
(20190725115532, 'AddScheduleReminderTaskMigration', '2022-12-05 19:11:52', '2022-12-05 19:11:52', 0),
(20190801102042, 'DisplayProfileCommandLinkFixMigration', '2022-12-05 19:11:52', '2022-12-05 19:11:52', 0),
(20190801141737, 'DatasetAddCustomHeadersColumnMigration', '2022-12-05 19:11:52', '2022-12-05 19:11:52', 0),
(20190801142302, 'AddDoohUserTypeMigration', '2022-12-05 19:11:52', '2022-12-05 19:11:52', 0),
(20190802145636, 'CreateScheduleReminderTableMigration', '2022-12-05 19:11:52', '2022-12-05 19:11:52', 0),
(20190806144729, 'AddShowContentFromMigration', '2022-12-05 19:11:52', '2022-12-05 19:11:52', 0),
(20190823081448, 'AddImageProcessingTaskMigration', '2022-12-05 19:11:52', '2022-12-05 19:11:52', 0),
(20190828123735, 'AddDefaultSettingResizeLimitResizeThresholdMigration', '2022-12-05 19:11:52', '2022-12-05 19:11:52', 0),
(20190903083314, 'AddGlobalSettingForCascadePermissionsMigration', '2022-12-05 19:11:52', '2022-12-05 19:11:52', 0),
(20190905084201, 'AddSettingForDefaultTransitionTypeMigration', '2022-12-05 19:11:52', '2022-12-05 19:11:52', 0),
(20190905084642, 'AddSettingForAutoLayoutPublishMigration', '2022-12-05 19:11:52', '2022-12-05 19:11:52', 0),
(20190910132520, 'DisplayMoveCmsMigration', '2022-12-05 19:11:52', '2022-12-05 19:11:52', 0),
(20190917093141, 'InterruptLayoutMigration', '2022-12-05 19:11:52', '2022-12-05 19:11:52', 0),
(20190918090608, 'AddDefaultSettingQuickChartMigration', '2022-12-05 19:11:52', '2022-12-05 19:11:52', 0),
(20190919154513, 'AddNotificationAttachmentFilenameNonUsersMigration', '2022-12-05 19:11:52', '2022-12-05 19:11:52', 0),
(20190926135518, 'AddSettingForTransitionAutoApplyToLayoutMigration', '2022-12-05 19:11:52', '2022-12-05 19:11:52', 0),
(20190926140809, 'InstallSavedReportsAndSpacerModulesMigration', '2022-12-05 19:11:52', '2022-12-05 19:11:52', 0),
(20191001092651, 'AddNotificationOriginalFilenameMigration', '2022-12-05 19:11:52', '2022-12-05 19:11:52', 0),
(20191022101141, 'AddCommandEntityToPermissionEntityMigration', '2022-12-05 19:11:52', '2022-12-05 19:11:53', 0),
(20191024152519, 'AddScheduleExclusionsTableMigration', '2022-12-05 19:11:53', '2022-12-05 19:11:53', 0),
(20191122114104, 'FixDuplicateModuleFilesMigration', '2022-12-05 19:11:53', '2022-12-05 19:11:53', 0),
(20191126103120, 'GeoScheduleMigration', '2022-12-05 19:11:53', '2022-12-05 19:11:53', 0),
(20191126141140, 'RemoteDataSetCsvSourceMigration', '2022-12-05 19:11:53', '2022-12-05 19:11:53', 0),
(20191205180116, 'AddPlaylistDashboardPageUserMigration', '2022-12-05 19:11:53', '2022-12-05 19:11:53', 0),
(20200107082625, 'DisplayAddResolutionMigration', '2022-12-05 19:11:53', '2022-12-05 19:11:53', 0),
(20200115115935, 'AddReportScheduleMessageMigration', '2022-12-05 19:11:53', '2022-12-05 19:11:53', 0),
(20200122143630, 'AddReleasedRequiredFileMigration', '2022-12-05 19:11:53', '2022-12-05 19:11:53', 0),
(20200122191232, 'AddCommercialLicenceColumnMigration', '2022-12-05 19:11:53', '2022-12-05 19:11:53', 0),
(20200129104944, 'AddEngagementsStatsMigration', '2022-12-05 19:11:53', '2022-12-05 19:11:53', 0),
(20200130165443, 'CountdownModuleAddMigration', '2022-12-05 19:11:53', '2022-12-05 19:11:53', 0),
(20200311110512, 'AddIsDrawerColumnMigration', '2022-12-05 19:11:53', '2022-12-05 19:11:53', 0),
(20200311110535, 'CreateActionTableMigration', '2022-12-05 19:11:53', '2022-12-05 19:11:53', 0),
(20200319093235, 'ChangeInterruptLayoutMigration', '2022-12-05 19:11:53', '2022-12-05 19:11:53', 0),
(20200401121544, 'AddSystemUserSettingMigration', '2022-12-05 19:11:53', '2022-12-05 19:11:53', 0),
(20200407143200, 'AddCodeColumnToLayoutMigration', '2022-12-05 19:11:53', '2022-12-05 19:11:53', 0),
(20200422101006, 'AddDataSetRowLimitMigration', '2022-12-05 19:11:53', '2022-12-05 19:11:53', 0),
(20200427085958, 'AddReportScheduleStartEndMigration', '2022-12-05 19:11:53', '2022-12-05 19:11:53', 0),
(20200530103029, 'DisplayRemoteLinksMigration', '2022-12-05 19:11:53', '2022-12-05 19:11:53', 0),
(20200604103141, 'CommandImprovementsMigration', '2022-12-05 19:11:53', '2022-12-05 19:11:53', 0),
(20200612141755, 'OauthUpgradeMigration', '2022-12-05 19:11:53', '2022-12-05 19:11:53', 0),
(20200720092246, 'AddSavedReportSchemaVersionMigration', '2022-12-05 19:11:53', '2022-12-05 19:11:53', 0),
(20200916134817, 'RemoveOldScreenshotsMigration', '2022-12-05 19:11:53', '2022-12-05 19:11:53', 0),
(20200917140227, 'DisplayGroupCreatedModifiedDates', '2022-12-05 19:11:53', '2022-12-05 19:11:53', 0),
(20201007080829, 'AddFoldersMigration', '2022-12-05 19:11:53', '2022-12-05 19:11:54', 0),
(20201007093511, 'FeaturesMigration', '2022-12-05 19:11:54', '2022-12-05 19:11:54', 0),
(20201025153753, 'RemoveOldPermissionSettingsMigration', '2022-12-05 19:11:54', '2022-12-05 19:11:54', 0),
(20210105105646, 'AddMcaasScopeAndRouteMigration', '2022-12-05 19:11:54', '2022-12-05 19:11:54', 0),
(20210113134628, 'EnableUserSharingFeatureOnUsersGroupMigration', '2022-12-05 19:11:54', '2022-12-05 19:11:54', 0),
(20210128143602, 'MenuBoardsMigration', '2022-12-05 19:11:54', '2022-12-05 19:11:54', 0),
(20210201150259, 'UserOnboardingMigration', '2022-12-05 19:11:54', '2022-12-05 19:11:54', 0),
(20210305131937, 'FixDuplicateTagsMigration', '2022-12-05 19:11:54', '2022-12-05 19:11:54', 0),
(20210407111756, 'RemoveReportNameColumnFromSavedReportMigration', '2022-12-05 19:11:54', '2022-12-05 19:11:54', 0),
(20210421142731, 'RemoveMaintenanceKeyMigration', '2022-12-05 19:11:54', '2022-12-05 19:11:54', 0),
(20210601104441, 'AddUserAgentToDataSetMigration', '2022-12-05 19:11:54', '2022-12-05 19:11:54', 0),
(20210603114231, 'NewCalendarTypeMigration', '2022-12-05 19:11:54', '2022-12-05 19:11:54', 0),
(20210608142925, 'AddOrientationToResolutionAndMediaMigration', '2022-12-05 19:11:54', '2022-12-05 19:11:54', 0),
(20210611122809, 'AddPurgeListTableMigration', '2022-12-05 19:11:54', '2022-12-05 19:11:54', 0),
(20210806122814, 'AddNumberOfItemsToPlaylistMigration', '2022-12-05 19:11:54', '2022-12-05 19:11:54', 0),
(20210813094723, 'AddCycleBasedPlaybackOptionToCampaignMigration', '2022-12-05 19:11:54', '2022-12-05 19:11:54', 0),
(20210817105702, 'AddCustomSeparatorToDatasetMigration', '2022-12-05 19:11:54', '2022-12-05 19:11:54', 0),
(20210820100520, 'AddActionEventTypeMigration', '2022-12-05 19:11:54', '2022-12-05 19:11:54', 0),
(20210901134913, 'AddIpAddressColumnToAuditLogMigration', '2022-12-05 19:11:54', '2022-12-05 19:11:54', 0),
(20210901150615, 'AddTooltipAndIsRequiredColumnsMigration', '2022-12-05 19:11:54', '2022-12-05 19:11:54', 0),
(20211109130951, 'FixOrphanedDisplayGroupsMigration', '2022-12-05 19:11:54', '2022-12-05 19:11:54', 0),
(20211109134929, 'FixPlaylistManagerUserGroupMigration', '2022-12-05 19:11:54', '2022-12-05 19:11:54', 0),
(20211109141925, 'DatasetAddOptionToTruncateOnNoNewDataMigration', '2022-12-05 19:11:54', '2022-12-05 19:11:55', 0),
(20211116153103, 'ConnectorsMigration', '2022-12-05 19:11:55', '2022-12-05 19:11:55', 0),
(20211231141457, 'AddMoreTagFilteringOptionsMigration', '2022-12-05 19:11:55', '2022-12-05 19:11:55', 0),
(20211231153355, 'AddIsCustomToDisplayProfileMigration', '2022-12-05 19:11:55', '2022-12-05 19:11:55', 0),
(20220117150212, 'AddLayoutExchangeConnectorMigration', '2022-12-05 19:11:55', '2022-12-05 19:11:55', 0),
(20220119124436, 'AddCodeColumnToMenuBoardsMigration', '2022-12-05 19:11:55', '2022-12-05 19:11:55', 0),
(20220131151346, 'AddDateFormatToDataSetColumnMigration', '2022-12-05 19:11:55', '2022-12-05 19:11:55', 0),
(20220201163832, 'ReportLogoMigration', '2022-12-05 19:11:55', '2022-12-05 19:11:55', 0),
(20220203145712, 'ApplicationsTweaksMigration', '2022-12-05 19:11:55', '2022-12-05 19:11:55', 0),
(20220207160047, 'TidyCalendarModuleTypes', '2022-12-05 19:11:55', '2022-12-05 19:11:55', 0),
(20220224130122, 'AddResolutionRoutesToDesignScopeMigration', '2022-12-05 19:11:55', '2022-12-05 19:11:55', 0),
(20220225105237, 'MergeWeatherWidgets', '2022-12-05 19:11:55', '2022-12-05 19:11:55', 0),
(20220302152503, 'LayoutRemoveOrientationMigration', '2022-12-05 19:11:55', '2022-12-05 19:11:55', 0),
(20220307134554, 'AddWorldClockMigration', '2022-12-05 19:11:55', '2022-12-05 19:11:55', 0),
(20220906085300, 'ThreeTwoZeroMigration', '2022-12-05 19:11:55', '2022-12-05 19:11:55', 0),
(20220907135653, 'AddLogicalOperatorNameMigration', '2022-12-05 19:11:55', '2022-12-05 19:11:55', 0),
(20220907143500, 'UserHomeFolderMigration', '2022-12-05 19:11:55', '2022-12-05 19:11:55', 0),
(20221013103000, 'AdvertisingConnectorsMigration', '2022-12-05 19:11:55', '2022-12-05 19:11:55', 0),
(20221024082400, 'AdCampaignMigration', '2022-12-05 19:11:55', '2022-12-05 19:11:56', 0),
(20221101090337, 'CreateDisplayTypeTableMigration', '2022-12-05 19:11:56', '2022-12-05 19:11:56', 0),
(20221101130018, 'AddDisplayMetaDataMigration', '2022-12-05 19:11:56', '2022-12-05 19:11:56', 0),
(20221104095722, 'CreateDisplayLocationTypeTableMigration', '2022-12-05 19:11:56', '2022-12-05 19:11:57', 0);

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

--
-- Estrutura da tabela `player_faults`
--

CREATE TABLE `player_faults` (
  `playerFaultId` int(11) NOT NULL,
  `displayId` int(11) NOT NULL,
  `incidentDt` datetime DEFAULT NULL,
  `expires` datetime DEFAULT NULL,
  `code` varchar(255) DEFAULT NULL,
  `reason` varchar(255) DEFAULT NULL,
  `scheduleId` int(11) DEFAULT NULL,
  `layoutId` int(11) DEFAULT NULL,
  `regionId` int(11) DEFAULT NULL,
  `mediaId` int(11) DEFAULT NULL,
  `widgetId` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Estrutura da tabela `player_software`
--

CREATE TABLE `player_software` (
  `versionId` int(11) NOT NULL,
  `player_type` varchar(20) DEFAULT NULL,
  `player_version` varchar(15) DEFAULT NULL,
  `player_code` smallint(6) DEFAULT NULL,
  `mediaId` int(11) NOT NULL,
  `playerShowVersion` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Estrutura da tabela `playlist`
--

CREATE TABLE `playlist` (
  `playlistId` int(11) NOT NULL,
  `name` varchar(254) NOT NULL,
  `ownerId` int(11) NOT NULL,
  `regionId` int(11) DEFAULT NULL,
  `createdDt` datetime DEFAULT NULL,
  `modifiedDt` datetime DEFAULT NULL,
  `duration` int(11) NOT NULL DEFAULT '0',
  `requiresDurationUpdate` int(11) NOT NULL DEFAULT '0',
  `isDynamic` tinyint(4) NOT NULL DEFAULT '0',
  `filterMediaName` text,
  `filterMediaNameLogicalOperator` varchar(3) NOT NULL DEFAULT 'OR',
  `filterMediaTags` text,
  `filterExactTags` tinyint(4) NOT NULL DEFAULT '0',
  `filterMediaTagsLogicalOperator` varchar(3) NOT NULL DEFAULT 'OR',
  `maxNumberOfItems` int(11) DEFAULT NULL,
  `enableStat` varchar(255) DEFAULT NULL,
  `folderId` int(11) NOT NULL DEFAULT '1',
  `permissionsFolderId` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `playlist`
--

INSERT INTO `playlist` (`playlistId`, `name`, `ownerId`, `regionId`, `createdDt`, `modifiedDt`, `duration`, `requiresDurationUpdate`, `isDynamic`, `filterMediaName`, `filterMediaNameLogicalOperator`, `filterMediaTags`, `filterExactTags`, `filterMediaTagsLogicalOperator`, `maxNumberOfItems`, `enableStat`, `folderId`, `permissionsFolderId`) VALUES
(5, 'PLAYLIST PORTUGUES', 1, NULL, '2022-12-05 16:13:21', '2022-12-05 16:13:21', 0, 1, 0, NULL, 'OR', NULL, 0, 'OR', NULL, 'Inherit', 1, 1),
(6, 'Explainer', 1, 5, '2022-12-05 16:13:57', '2022-12-05 16:13:58', 0, 1, 0, NULL, 'OR', NULL, 0, 'OR', 0, NULL, 1, 1),
(7, 'Header', 1, 6, '2022-12-05 16:13:57', '2022-12-05 16:13:58', 0, 1, 0, NULL, 'OR', NULL, 0, 'OR', 0, NULL, 1, 1),
(8, 'Logo', 1, 7, '2022-12-05 16:13:57', '2022-12-05 16:13:58', 0, 1, 0, NULL, 'OR', NULL, 0, 'OR', 0, NULL, 1, 1),
(9, 'Time', 1, 8, '2022-12-05 16:13:57', '2022-12-05 16:13:58', 0, 1, 0, NULL, 'OR', NULL, 0, 'OR', 0, NULL, 1, 1);

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

--
-- Estrutura da tabela `purge_list`
--

CREATE TABLE `purge_list` (
  `purgeListId` int(11) NOT NULL,
  `mediaId` int(11) NOT NULL,
  `storedAs` varchar(255) NOT NULL,
  `expiryDate` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Estrutura da tabela `region`
--

CREATE TABLE `region` (
  `regionId` int(11) NOT NULL,
  `layoutId` int(11) NOT NULL,
  `ownerId` int(11) NOT NULL,
  `name` varchar(254) DEFAULT NULL,
  `width` decimal(10,0) NOT NULL,
  `height` decimal(10,0) NOT NULL,
  `top` decimal(10,0) NOT NULL,
  `left` decimal(10,0) NOT NULL,
  `zIndex` smallint(6) NOT NULL,
  `duration` int(11) NOT NULL DEFAULT '0',
  `isDrawer` tinyint(4) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `region`
--

INSERT INTO `region` (`regionId`, `layoutId`, `ownerId`, `name`, `width`, `height`, `top`, `left`, `zIndex`, `duration`, `isDrawer`) VALUES
(5, 2, 1, 'Explainer', '1626', '145', '618', '147', 0, 25, 0),
(6, 2, 1, 'Header', '1109', '216', '290', '413', 0, 10, 0),
(7, 2, 1, 'Logo', '267', '157', '16', '24', 0, 60, 0),
(8, 2, 1, 'Time', '126', '58', '971', '1741', 0, 1, 0);

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

--
-- Estrutura da tabela `regionoption`
--

CREATE TABLE `regionoption` (
  `regionId` int(11) NOT NULL,
  `option` varchar(50) NOT NULL,
  `value` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Estrutura da tabela `reportschedule`
--

CREATE TABLE `reportschedule` (
  `reportScheduleId` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `reportName` varchar(255) NOT NULL,
  `filterCriteria` text,
  `schedule` varchar(255) NOT NULL,
  `lastSavedReportId` int(11) NOT NULL DEFAULT '0',
  `lastRunDt` int(11) NOT NULL DEFAULT '0',
  `previousRunDt` int(11) NOT NULL DEFAULT '0',
  `userId` int(11) NOT NULL,
  `isActive` int(11) NOT NULL DEFAULT '1',
  `fromDt` int(11) NOT NULL DEFAULT '0',
  `toDt` int(11) NOT NULL DEFAULT '0',
  `createdDt` int(11) NOT NULL,
  `message` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Estrutura da tabela `requiredfile`
--

CREATE TABLE `requiredfile` (
  `rfId` int(11) NOT NULL,
  `displayId` int(11) NOT NULL,
  `type` varchar(1) NOT NULL,
  `itemId` int(11) DEFAULT NULL,
  `bytesRequested` bigint(20) NOT NULL,
  `complete` tinyint(4) NOT NULL DEFAULT '0',
  `path` varchar(255) DEFAULT NULL,
  `size` bigint(20) NOT NULL DEFAULT '0',
  `released` tinyint(4) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Estrutura da tabela `resolution`
--

CREATE TABLE `resolution` (
  `resolutionId` int(11) NOT NULL,
  `resolution` varchar(254) NOT NULL,
  `width` smallint(6) NOT NULL,
  `height` smallint(6) NOT NULL,
  `intended_width` smallint(6) NOT NULL,
  `intended_height` smallint(6) NOT NULL,
  `version` tinyint(4) NOT NULL DEFAULT '1',
  `enabled` tinyint(4) NOT NULL DEFAULT '1',
  `userId` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `resolution`
--

INSERT INTO `resolution` (`resolutionId`, `resolution`, `width`, `height`, `intended_width`, `intended_height`, `version`, `enabled`, `userId`) VALUES
(1, '1080p HD Landscape', 800, 450, 1920, 1080, 2, 1, 1),
(2, '720p HD Landscape', 800, 450, 1280, 720, 2, 1, 1),
(3, '1080p HD Portrait', 450, 800, 1080, 1920, 2, 1, 1),
(4, '720p HD Portrait', 450, 800, 720, 1280, 2, 1, 1),
(5, '4k cinema', 800, 450, 4096, 2304, 2, 1, 1),
(6, 'Common PC Monitor 4:3', 800, 600, 1024, 768, 2, 1, 1),
(7, '4k UHD Landscape', 450, 800, 3840, 2160, 2, 1, 1),
(8, '4k UHD Portrait', 800, 450, 2160, 3840, 2, 1, 1);

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

--
-- Estrutura da tabela `saved_report`
--

CREATE TABLE `saved_report` (
  `savedReportId` int(11) NOT NULL,
  `saveAs` varchar(255) NOT NULL,
  `mediaId` int(11) NOT NULL,
  `reportScheduleId` int(11) NOT NULL,
  `generatedOn` int(11) NOT NULL,
  `userId` int(11) NOT NULL,
  `schemaVersion` tinyint(4) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Estrutura da tabela `schedule`
--

CREATE TABLE `schedule` (
  `eventId` int(11) NOT NULL,
  `eventTypeId` int(11) NOT NULL,
  `campaignId` int(11) DEFAULT NULL,
  `commandId` int(11) DEFAULT NULL,
  `dayPartId` int(11) NOT NULL DEFAULT '0',
  `userId` int(11) NOT NULL,
  `fromDt` bigint(20) DEFAULT NULL,
  `toDt` bigint(20) DEFAULT NULL,
  `is_priority` tinyint(4) NOT NULL,
  `displayOrder` int(11) NOT NULL DEFAULT '0',
  `lastRecurrenceWatermark` bigint(20) DEFAULT NULL,
  `syncTimezone` tinyint(4) NOT NULL DEFAULT '0',
  `recurrence_type` enum('Minute','Hour','Day','Week','Month','Year') DEFAULT NULL,
  `recurrence_detail` int(11) DEFAULT NULL,
  `recurrence_range` bigint(20) DEFAULT NULL,
  `recurrenceRepeatsOn` varchar(14) DEFAULT NULL,
  `syncEvent` int(11) NOT NULL DEFAULT '0',
  `recurrenceMonthlyRepeatsOn` tinyint(4) NOT NULL DEFAULT '0',
  `shareOfVoice` smallint(6) DEFAULT NULL,
  `isGeoAware` tinyint(4) NOT NULL DEFAULT '0',
  `geoLocation` text,
  `actionTriggerCode` varchar(50) DEFAULT NULL,
  `actionType` varchar(50) DEFAULT NULL,
  `actionLayoutCode` varchar(50) DEFAULT NULL,
  `maxPlaysPerHour` smallint(6) NOT NULL DEFAULT '0',
  `parentCampaignId` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Estrutura da tabela `scheduleexclusions`
--

CREATE TABLE `scheduleexclusions` (
  `scheduleExclusionId` int(11) NOT NULL,
  `eventId` int(11) NOT NULL,
  `fromDt` int(11) NOT NULL,
  `toDt` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Estrutura da tabela `schedulereminder`
--

CREATE TABLE `schedulereminder` (
  `scheduleReminderId` int(11) NOT NULL,
  `eventId` int(11) NOT NULL,
  `value` int(11) NOT NULL,
  `type` int(11) NOT NULL,
  `option` int(11) NOT NULL,
  `reminderDt` int(11) NOT NULL,
  `lastReminderDt` int(11) NOT NULL,
  `isEmail` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Estrutura da tabela `session`
--

CREATE TABLE `session` (
  `session_id` varchar(160) NOT NULL,
  `session_data` longtext NOT NULL,
  `session_expiration` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `lastAccessed` datetime DEFAULT NULL,
  `userId` int(11) DEFAULT NULL,
  `isExpired` tinyint(4) NOT NULL DEFAULT '1',
  `userAgent` varchar(255) DEFAULT NULL,
  `remoteAddr` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `session`
--

INSERT INTO `session` (`session_id`, `session_data`, `session_expiration`, `lastAccessed`, `userId`, `isExpired`, `userAgent`, `remoteAddr`) VALUES
('440ee6905f3dfbb3aa6d6634a616f12a', 'init|s:1:\"1\";slimFlash|a:0:{}csrfToken|s:40:\"c1d7b70f12cb4cdba007ce0230993ca61cccbcb4\";displayGroupIds|a:0:{}userid|i:1;', 1670259836, '2022-12-05 13:41:56', 1, 0, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', '187.183.233.174'),
('4ad7780bd6d7b4596657815a3b6850d0', 'init|s:1:\"1\";slimFlash|a:1:{s:10:\"priorRoute\";a:1:{i:0;s:1:\"/\";}}', 1670258166, '2022-12-05 16:12:06', 0, 0, 'Mozilla/5.0 (Windows NT 10.0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/106.0.0.0 Safari/537.36', '205.169.39.63'),
('8098e27eb9b515c1a87fce05cf20d2f3', 'init|s:1:\"1\";slimFlash|a:1:{s:10:\"priorRoute\";a:1:{i:0;s:1:\"/\";}}', 1670259667, '2022-12-05 13:37:07', 0, 0, 'Go-http-client/2.0', '51.75.169.50'),
('a3f1a9d0ba36d154e52d3df57a216f3b', 'init|s:1:\"1\";slimFlash|a:0:{}csrfToken|s:40:\"175ecd8c40771a1f6b5164d06c62cda3ab01b8c7\";', 1670258306, '2022-12-05 16:14:26', 0, 0, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/37.0.2062.124 Safari/537.36', '148.113.143.236'),
('af8bbc2e5d1c3d839a6ecd04de34e9af', 'init|s:1:\"1\";slimFlash|a:0:{}csrfToken|s:40:\"777480ae7811d69d61d03f3a30d71cc41df3533b\";', 1670259670, '2022-12-05 13:37:10', 0, 0, 'Go-http-client/2.0', '51.75.169.50'),
('ba2ec25adb90a045e7e62fe98ad7f12b', 'init|s:1:\"1\";slimFlash|a:1:{s:10:\"priorRoute\";a:1:{i:0;s:1:\"/\";}}', 1670259668, '2022-12-05 13:37:08', 0, 0, 'Go-http-client/2.0', '51.75.169.50'),
('c16b64a74ec64b9d8c46099635ffbf40', 'init|s:1:\"1\";slimFlash|a:0:{}csrfToken|s:40:\"f0bd6abcbbf77f07675933943c0c62defa6ac280\";', 1670259671, '2022-12-05 13:37:11', 0, 0, 'Go-http-client/2.0', '51.75.169.50'),
('f910fdcb8d67087d00d085556a564765', 'init|s:1:\"1\";slimFlash|a:0:{}csrfToken|s:40:\"a098302354e9bfb45c59da52b24d7f4a15dc5cc2\";', 1670258243, '2022-12-05 16:13:23', 0, 0, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/32.0.1664.3 Safari/537.36', '148.113.142.71');

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

--
-- Estrutura da tabela `setting`
--

CREATE TABLE `setting` (
  `settingId` int(11) NOT NULL,
  `setting` varchar(50) NOT NULL,
  `value` varchar(1000) NOT NULL,
  `userSee` tinyint(4) NOT NULL DEFAULT '1',
  `userChange` tinyint(4) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `setting`
--

INSERT INTO `setting` (`settingId`, `setting`, `value`, `userSee`, `userChange`) VALUES
(3, 'defaultUsertype', 'User', 1, 1),
(7, 'userModule', 'module_user_general.php', 0, 0),
(11, 'defaultTimezone', 'America/Sao_Paulo', 1, 1),
(18, 'mail_to', 'mail@yoursite.com', 1, 1),
(19, 'mail_from', 'mail@yoursite.com', 1, 1),
(30, 'audit', 'emergency', 1, 1),
(33, 'LIBRARY_LOCATION', 'media/', 1, 1),
(34, 'SERVER_KEY', 'abcd1234', 1, 1),
(35, 'HELP_BASE', 'http://www.xibo.org.uk/manual/en/', 1, 1),
(36, 'PHONE_HOME', '1', 1, 1),
(37, 'PHONE_HOME_KEY', '', 0, 0),
(38, 'PHONE_HOME_URL', 'https://xibo.org.uk/api/stats/track', 0, 0),
(39, 'PHONE_HOME_DATE', '0', 0, 0),
(40, 'SERVER_MODE', 'Production', 1, 1),
(41, 'MAINTENANCE_ENABLED', 'Off', 1, 1),
(42, 'MAINTENANCE_EMAIL_ALERTS', '1', 1, 1),
(44, 'MAINTENANCE_LOG_MAXAGE', '30', 1, 1),
(45, 'MAINTENANCE_STAT_MAXAGE', '30', 1, 1),
(46, 'MAINTENANCE_ALERT_TOUT', '12', 1, 1),
(47, 'SHOW_DISPLAY_AS_VNCLINK', '', 1, 1),
(48, 'SHOW_DISPLAY_AS_VNC_TGT', '_top', 1, 1),
(49, 'MAINTENANCE_ALWAYS_ALERT', '0', 1, 1),
(50, 'SCHEDULE_LOOKAHEAD', '1', 1, 0),
(51, 'REQUIRED_FILES_LOOKAHEAD', '172800', 1, 1),
(52, 'REGION_OPTIONS_COLOURING', 'Media Colouring', 1, 1),
(53, 'LAYOUT_COPY_MEDIA_CHECKB', '0', 1, 1),
(54, 'MAX_LICENSED_DISPLAYS', '0', 0, 0),
(55, 'LIBRARY_MEDIA_UPDATEINALL_CHECKB', '1', 1, 1),
(56, 'USER_PASSWORD_POLICY', '', 1, 1),
(57, 'USER_PASSWORD_ERROR', '', 1, 1),
(58, 'MODULE_CONFIG_LOCKED_CHECKB', '0', 0, 0),
(59, 'LIBRARY_SIZE_LIMIT_KB', '0', 1, 0),
(60, 'MONTHLY_XMDS_TRANSFER_LIMIT_KB', '0', 1, 0),
(61, 'DEFAULT_LANGUAGE', 'pt_BR', 1, 1),
(62, 'TRANSITION_CONFIG_LOCKED_CHECKB', '0', 1, 0),
(63, 'GLOBAL_THEME_NAME', 'mga', 1, 1),
(64, 'DEFAULT_LAT', '51.504', 1, 1),
(65, 'DEFAULT_LONG', '-0.104', 1, 1),
(66, 'SCHEDULE_WITH_VIEW_PERMISSION', '0', 1, 1),
(67, 'SETTING_IMPORT_ENABLED', '1', 1, 1),
(68, 'SETTING_LIBRARY_TIDY_ENABLED', '1', 1, 1),
(69, 'SENDFILE_MODE', 'Off', 1, 1),
(70, 'EMBEDDED_STATUS_WIDGET', '', 1, 0),
(71, 'PROXY_HOST', '', 1, 1),
(72, 'PROXY_PORT', '0', 1, 1),
(73, 'PROXY_AUTH', '', 1, 1),
(74, 'DATE_FORMAT', 'd-m-Y H:i', 1, 1),
(75, 'DETECT_LANGUAGE', '0', 1, 1),
(76, 'DEFAULTS_IMPORTED', '1', 0, 0),
(77, 'FORCE_HTTPS', '0', 1, 1),
(78, 'ISSUE_STS', '0', 1, 1),
(79, 'STS_TTL', '600', 1, 1),
(81, 'CALENDAR_TYPE', 'Gregorian', 1, 1),
(82, 'DASHBOARD_LATEST_NEWS_ENABLED', '0', 1, 1),
(83, 'LIBRARY_MEDIA_DELETEOLDVER_CHECKB', '1', 1, 1),
(84, 'PROXY_EXCEPTIONS', '', 1, 1),
(85, 'INSTANCE_SUSPENDED', '0', 0, 0),
(87, 'XMR_ADDRESS', 'tcp://localhost:5555', 1, 1),
(88, 'XMR_PUB_ADDRESS', '', 1, 1),
(89, 'CDN_URL', '', 0, 0),
(90, 'ELEVATE_LOG_UNTIL', '1670261603', 1, 1),
(91, 'RESTING_LOG_LEVEL', 'emergency', 1, 1),
(92, 'TASK_CONFIG_LOCKED_CHECKB', '0', 0, 0),
(93, 'WHITELIST_LOAD_BALANCERS', '', 1, 1),
(94, 'DEFAULT_LAYOUT', '2', 1, 1),
(95, 'DISPLAY_PROFILE_STATS_DEFAULT', '0', 1, 1),
(96, 'DISPLAY_PROFILE_CURRENT_LAYOUT_STATUS_ENABLED', '1', 1, 1),
(97, 'DISPLAY_PROFILE_SCREENSHOT_INTERVAL_ENABLED', '1', 1, 1),
(98, 'DISPLAY_PROFILE_SCREENSHOT_SIZE_DEFAULT', '200', 1, 1),
(99, 'LATEST_NEWS_URL', 'http://xibo.org.uk/feed', 0, 0),
(100, 'DISPLAY_LOCK_NAME_TO_DEVICENAME', '0', 1, 1),
(101, 'mail_from_name', '', 1, 1),
(102, 'SCHEDULE_SHOW_LAYOUT_NAME', '0', 1, 1),
(103, 'DEFAULT_USERGROUP', '1', 1, 1),
(104, 'PASSWORD_REMINDER_ENABLED', 'Off', 1, 1),
(105, 'DISPLAY_AUTO_AUTH', '0', 0, 0),
(106, 'EVENT_SYNC', '0', 0, 0),
(107, 'DEFAULT_TRANSITION_DURATION', '1000', 1, 1),
(108, 'LAYOUT_STATS_ENABLED_DEFAULT', '0', 1, 1),
(109, 'DISPLAY_PROFILE_AGGREGATION_LEVEL_DEFAULT', 'Individual', 1, 1),
(110, 'MEDIA_STATS_ENABLED_DEFAULT', 'Inherit', 1, 1),
(111, 'WIDGET_STATS_ENABLED_DEFAULT', 'Inherit', 1, 1),
(112, 'NAVIGATION_MENU_POSITION', 'vertical', 1, 1),
(113, 'TWOFACTOR_ISSUER', '', 1, 1),
(114, 'PLAYLIST_STATS_ENABLED_DEFAULT', 'Inherit', 1, 1),
(115, 'DEFAULT_RESIZE_LIMIT', '6000', 1, 1),
(116, 'DEFAULT_RESIZE_THRESHOLD', '1920', 1, 1),
(118, 'DEFAULT_TRANSITION_IN', 'fadeIn', 1, 1),
(119, 'DEFAULT_TRANSITION_OUT', 'fadeOut', 1, 1),
(120, 'DEFAULT_LAYOUT_AUTO_PUBLISH_CHECKB', '0', 1, 1),
(121, 'QUICK_CHART_URL', 'https://quickchart.io', 1, 1),
(122, 'DEFAULT_TRANSITION_AUTO_APPLY', '0', 1, 1),
(123, 'SYSTEM_USER', '1', 1, 1),
(124, 'DATASET_HARD_ROW_LIMIT', '10000', 1, 1),
(125, 'DISPLAY_SCREENSHOT_TTL', '0', 1, 1),
(126, 'DEFAULT_PURGE_LIST_TTL', '7', 1, 1),
(127, 'DEFAULT_DYNAMIC_PLAYLIST_MAXNUMBER', '30', 1, 1),
(128, 'DEFAULT_DYNAMIC_PLAYLIST_MAXNUMBER_LIMIT', '100', 1, 1),
(129, 'REPORTS_EXPORT_SHOW_LOGO', '1', 1, 1),
(130, 'FOLDERS_ALLOW_SAVE_IN_ROOT', '1', 1, 1);

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

--
-- Estrutura da tabela `stat`
--

CREATE TABLE `stat` (
  `statId` int(11) NOT NULL,
  `type` varchar(20) NOT NULL,
  `statDate` int(11) NOT NULL,
  `scheduleId` int(11) NOT NULL,
  `displayId` int(11) NOT NULL,
  `campaignId` int(11) DEFAULT NULL,
  `layoutId` int(11) DEFAULT NULL,
  `mediaId` int(11) DEFAULT NULL,
  `widgetId` int(11) DEFAULT NULL,
  `start` int(11) NOT NULL,
  `end` int(11) NOT NULL,
  `tag` varchar(254) DEFAULT NULL,
  `duration` int(11) NOT NULL,
  `count` int(11) NOT NULL,
  `engagements` text,
  `parentCampaignId` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Estrutura da tabela `status`
--

CREATE TABLE `status` (
  `id` int(11) NOT NULL,
  `status` varchar(254) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `status`
--

INSERT INTO `status` (`id`, `status`) VALUES
(1, 'Published'),
(2, 'Draft'),
(3, 'Pending Approval');

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

--
-- Estrutura da tabela `stat_archive`
--

CREATE TABLE `stat_archive` (
  `statId` int(11) NOT NULL,
  `type` varchar(20) NOT NULL,
  `statDate` datetime DEFAULT NULL,
  `scheduleId` int(11) NOT NULL,
  `displayId` int(11) NOT NULL,
  `layoutId` int(11) DEFAULT NULL,
  `mediaId` int(11) DEFAULT NULL,
  `widgetId` int(11) DEFAULT NULL,
  `start` datetime DEFAULT NULL,
  `end` datetime DEFAULT NULL,
  `tag` varchar(254) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Estrutura da tabela `tag`
--

CREATE TABLE `tag` (
  `tagId` int(11) NOT NULL,
  `tag` varchar(50) NOT NULL,
  `isSystem` int(11) NOT NULL DEFAULT '0',
  `options` text,
  `isRequired` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `tag`
--

INSERT INTO `tag` (`tagId`, `tag`, `isSystem`, `options`, `isRequired`) VALUES
(1, 'template', 1, NULL, 0),
(2, 'background', 1, NULL, 0),
(3, 'thumbnail', 1, NULL, 0),
(4, 'imported', 1, NULL, 0);

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

--
-- Estrutura da tabela `task`
--

CREATE TABLE `task` (
  `taskId` int(11) NOT NULL,
  `name` varchar(254) NOT NULL,
  `class` varchar(254) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '2',
  `pid` int(11) DEFAULT NULL,
  `options` text,
  `schedule` varchar(254) NOT NULL,
  `lastRunDt` int(11) NOT NULL DEFAULT '0',
  `lastRunStartDt` int(11) DEFAULT NULL,
  `lastRunMessage` varchar(255) DEFAULT NULL,
  `lastRunStatus` tinyint(4) NOT NULL DEFAULT '0',
  `lastRunDuration` smallint(6) NOT NULL DEFAULT '0',
  `lastRunExitCode` smallint(6) NOT NULL DEFAULT '0',
  `isActive` tinyint(4) NOT NULL,
  `runNow` tinyint(4) NOT NULL DEFAULT '0',
  `configFile` varchar(254) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `task`
--

INSERT INTO `task` (`taskId`, `name`, `class`, `status`, `pid`, `options`, `schedule`, `lastRunDt`, `lastRunStartDt`, `lastRunMessage`, `lastRunStatus`, `lastRunDuration`, `lastRunExitCode`, `isActive`, `runNow`, `configFile`) VALUES
(1, 'Daily Maintenance', '\\Xibo\\XTR\\MaintenanceDailyTask', 2, NULL, '[]', '0 0 * * * *', 0, NULL, NULL, 0, 0, 0, 1, 0, '/tasks/maintenance-daily.task'),
(2, 'Regular Maintenance', '\\Xibo\\XTR\\MaintenanceRegularTask', 2, NULL, '[]', '*/5 * * * * *', 0, NULL, NULL, 0, 0, 0, 1, 0, '/tasks/maintenance-regular.task'),
(3, 'Email Notifications', '\\Xibo\\XTR\\EmailNotificationsTask', 2, NULL, '[]', '*/5 * * * * *', 0, NULL, NULL, 0, 0, 0, 1, 0, '/tasks/email-notifications.task'),
(4, 'Stats Archive', '\\Xibo\\XTR\\StatsArchiveTask', 2, NULL, '{\"periodSizeInDays\":\"7\",\"maxPeriods\":\"4\",\"archiveStats\":\"On\"}', '0 0 * * Mon', 0, NULL, NULL, 0, 0, 0, 1, 0, '/tasks/stats-archiver.task'),
(5, 'Remove old Notifications', '\\Xibo\\XTR\\NotificationTidyTask', 2, NULL, '{\"maxAgeDays\":\"7\",\"systemOnly\":\"1\",\"readOnly\":\"0\"}', '15 0 * * *', 0, NULL, NULL, 0, 0, 0, 1, 0, '/tasks/notification-tidy.task'),
(6, 'Fetch Remote DataSets', '\\Xibo\\XTR\\RemoteDataSetFetchTask', 2, NULL, '[]', '30 * * * * *', 0, NULL, NULL, 0, 0, 0, 1, 0, '/tasks/remote-dataset.task'),
(7, 'Drop Player Cache', '\\Xibo\\XTR\\DropPlayerCacheTask', 2, NULL, '[]', '0 0 1 1 *', 0, NULL, NULL, 0, 0, 0, 0, 0, '/tasks/drop-player-cache.task'),
(8, 'Sync Dynamic Playlists', '\\Xibo\\XTR\\DynamicPlaylistSyncTask', 2, NULL, '[]', '* * * * * *', 0, NULL, NULL, 0, 0, 0, 1, 0, '/tasks/dynamic-playlist-sync.task'),
(9, 'Widget Sync', '\\Xibo\\XTR\\WidgetSyncTask', 2, NULL, '{}', '*/3 * * * *', 0, NULL, NULL, 0, 0, 0, 1, 0, '/tasks/widget-sync.task'),
(10, 'Report Schedule', '\\Xibo\\XTR\\ReportScheduleTask', 2, NULL, '[]', '*/5 * * * * *', 0, NULL, NULL, 0, 0, 0, 1, 0, '/tasks/report-schedule.task'),
(11, 'Statistics Migration', '\\Xibo\\XTR\\StatsMigrationTask', 2, NULL, '{\"killSwitch\":\"0\",\"numberOfRecords\":\"5000\",\"numberOfLoops\":\"10\",\"pauseBetweenLoops\":\"1\",\"optimiseOnComplete\":\"1\"}', '*/10 * * * * *', 0, NULL, NULL, 0, 0, 0, 1, 0, '/tasks/stats-migration.task'),
(12, 'Schedule Reminder', '\\Xibo\\XTR\\ScheduleReminderTask', 2, NULL, '[]', '*/5 * * * * *', 0, NULL, NULL, 0, 0, 0, 1, 0, '/tasks/schedule-reminder.task'),
(13, 'Image Processing', '\\Xibo\\XTR\\ImageProcessingTask', 2, NULL, '[]', '*/5 * * * * *', 0, NULL, NULL, 0, 0, 0, 1, 0, '/tasks/image-processing.task'),
(14, 'Remove Old Screenshots', '\\Xibo\\XTR\\RemoveOldScreenshotsTask', 2, NULL, '[]', '0 0 * * * *', 0, NULL, NULL, 0, 0, 0, 1, 0, '/tasks/remove-old-screenshots.task'),
(15, 'Media Orientation', '\\Xibo\\XTR\\MediaOrientationTask', 2, NULL, '[]', '*/5 * * * * *', 0, NULL, NULL, 0, 0, 0, 1, 0, '/tasks/media-orientation.task'),
(16, 'Purge List Cleanup', '\\Xibo\\XTR\\PurgeListCleanupTask', 2, 0, '[]', '0 0 * * *', 0, NULL, NULL, 0, 0, 0, 1, 0, '/tasks/purge-list-cleanup.task'),
(17, 'Campaign Scheduler', '\\Xibo\\XTR\\CampaignSchedulerTask', 2, NULL, '[]', '45 * * * *', 0, NULL, NULL, 0, 0, 0, 1, 0, '/tasks/campaign-scheduler.task');

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

--
-- Estrutura da tabela `transition`
--

CREATE TABLE `transition` (
  `transitionId` int(11) NOT NULL,
  `transition` varchar(254) NOT NULL,
  `code` varchar(254) NOT NULL,
  `hasDuration` tinyint(4) NOT NULL,
  `hasDirection` tinyint(4) NOT NULL,
  `availableAsIn` tinyint(4) NOT NULL,
  `availableAsOut` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `transition`
--

INSERT INTO `transition` (`transitionId`, `transition`, `code`, `hasDuration`, `hasDirection`, `availableAsIn`, `availableAsOut`) VALUES
(1, 'Fade In', 'fadeIn', 1, 0, 1, 0),
(2, 'Fade Out', 'fadeOut', 1, 0, 0, 1),
(3, 'Fly', 'fly', 1, 1, 1, 1);

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

--
-- Estrutura da tabela `user`
--

CREATE TABLE `user` (
  `userId` int(11) NOT NULL,
  `userTypeId` int(11) NOT NULL,
  `userName` varchar(50) NOT NULL,
  `userPassword` varchar(255) NOT NULL,
  `lastAccessed` datetime DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `homePageId` varchar(255) DEFAULT 'null',
  `retired` tinyint(4) NOT NULL DEFAULT '0',
  `csprng` tinyint(4) NOT NULL DEFAULT '0',
  `newUserWizard` tinyint(4) NOT NULL DEFAULT '0',
  `firstName` varchar(254) DEFAULT NULL,
  `lastName` varchar(254) DEFAULT NULL,
  `phone` varchar(254) DEFAULT NULL,
  `ref1` varchar(254) DEFAULT NULL,
  `ref2` varchar(254) DEFAULT NULL,
  `ref3` varchar(254) DEFAULT NULL,
  `ref4` varchar(254) DEFAULT NULL,
  `ref5` varchar(254) DEFAULT NULL,
  `isPasswordChangeRequired` tinyint(4) NOT NULL DEFAULT '0',
  `twoFactorTypeId` int(11) NOT NULL DEFAULT '0',
  `twoFactorSecret` text,
  `twoFactorRecoveryCodes` text,
  `showContentFrom` tinyint(4) NOT NULL DEFAULT '1',
  `homeFolderId` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `user`
--

INSERT INTO `user` (`userId`, `userTypeId`, `userName`, `userPassword`, `lastAccessed`, `email`, `homePageId`, `retired`, `csprng`, `newUserWizard`, `firstName`, `lastName`, `phone`, `ref1`, `ref2`, `ref3`, `ref4`, `ref5`, `isPasswordChangeRequired`, `twoFactorTypeId`, `twoFactorSecret`, `twoFactorRecoveryCodes`, `showContentFrom`, `homeFolderId`) VALUES
(1, 1, 'admin', '$2y$10$qHEqlgBnxGa22W.ceSU4qOAWDzgLhQ0WcgWwdS2RVYb0uH9tJ.45S', '2022-12-05 16:33:53', NULL, 'statusdashboard.view', 0, 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, 1, 1);

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

--
-- Estrutura da tabela `useroption`
--

CREATE TABLE `useroption` (
  `userId` int(11) NOT NULL,
  `option` varchar(50) NOT NULL,
  `value` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `useroption`
--

INSERT INTO `useroption` (`userId`, `option`, `value`) VALUES
(1, 'daypartGrid', '{\"time\":1670257640843,\"start\":0,\"length\":10,\"order\":[[1,\"asc\"]],\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true},\"columns\":[{\"visible\":true,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}},{\"visible\":true,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}},{\"visible\":true,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}},{\"visible\":true,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}},{\"visible\":true,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}}]}'),
(1, 'displayProfileGrid', '{\"time\":1670257592899,\"start\":0,\"length\":10,\"order\":[[1,\"asc\"]],\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true},\"columns\":[{\"visible\":true,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}},{\"visible\":true,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}},{\"visible\":true,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}},{\"visible\":true,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}}]}'),
(1, 'displaysGrid', '{\"time\":1670258395729,\"start\":0,\"length\":10,\"order\":[[0,\"asc\"]],\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true},\"columns\":[{\"visible\":true,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}},{\"visible\":true,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}},{\"visible\":true,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}}]}'),
(1, 'layoutGrid', '{\"time\":1670257648148,\"start\":0,\"length\":10,\"order\":[[1,\"asc\"]],\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true},\"columns\":[{\"visible\":true,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}},{\"visible\":true,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}},{\"visible\":true,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}},{\"visible\":true,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}},{\"visible\":true,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}},{\"visible\":false,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}},{\"visible\":false,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}},{\"visible\":true,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}},{\"visible\":true,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}},{\"visible\":true,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}},{\"visible\":true,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}},{\"visible\":true,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}},{\"visible\":false,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}},{\"visible\":true,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}},{\"visible\":false,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}},{\"visible\":false,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}},{\"visible\":true,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}}],\"childRows\":[\"#undefined\"]}'),
(1, 'libraryGrid', '{\"time\":1670257653983,\"start\":0,\"length\":10,\"order\":[[1,\"asc\"]],\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true},\"columns\":[{\"visible\":true,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}},{\"visible\":true,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}},{\"visible\":true,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}},{\"visible\":false,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}},{\"visible\":true,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}},{\"visible\":true,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}},{\"visible\":false,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}},{\"visible\":true,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}},{\"visible\":false,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}},{\"visible\":false,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}},{\"visible\":true,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}},{\"visible\":true,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}},{\"visible\":false,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}},{\"visible\":false,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}},{\"visible\":true,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}},{\"visible\":true,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}},{\"visible\":false,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}},{\"visible\":false,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}},{\"visible\":true,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}},{\"visible\":true,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}}]}'),
(1, 'playlistGrid', '{\"time\":1670256801919,\"start\":0,\"length\":10,\"order\":[[1,\"asc\"]],\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true},\"columns\":[{\"visible\":true,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}},{\"visible\":true,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}},{\"visible\":true,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}},{\"visible\":false,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}},{\"visible\":true,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}},{\"visible\":true,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}},{\"visible\":true,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}},{\"visible\":false,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}},{\"visible\":false,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}},{\"visible\":true,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}},{\"visible\":true,\"search\":{\"search\":\"\",\"smart\":true,\"regex\":false,\"caseInsensitive\":true}}],\"childRows\":[\"#undefined\"]}'),
(1, 'toolbar', '{\"filters\":[{},{},{},{},{}],\"openedMenu\":-1,\"displayTooltips\":1,\"favouriteModules\":[]}');

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

--
-- Estrutura da tabela `usertype`
--

CREATE TABLE `usertype` (
  `userTypeId` int(11) NOT NULL,
  `userType` varchar(16) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `usertype`
--

INSERT INTO `usertype` (`userTypeId`, `userType`) VALUES
(1, 'Super Admin'),
(2, 'Group Admin'),
(3, 'User'),
(4, 'DOOH');

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

--
-- Estrutura da tabela `widget`
--

CREATE TABLE `widget` (
  `widgetId` int(11) NOT NULL,
  `playlistId` int(11) NOT NULL,
  `ownerId` int(11) NOT NULL,
  `type` varchar(50) NOT NULL,
  `duration` int(11) NOT NULL,
  `displayOrder` int(11) NOT NULL,
  `calculatedDuration` int(11) NOT NULL,
  `useDuration` tinyint(4) NOT NULL DEFAULT '1',
  `fromDt` int(11) NOT NULL,
  `toDt` int(11) NOT NULL,
  `createdDt` int(11) NOT NULL DEFAULT '0',
  `modifiedDt` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `widget`
--

INSERT INTO `widget` (`widgetId`, `playlistId`, `ownerId`, `type`, `duration`, `displayOrder`, `calculatedDuration`, `useDuration`, `fromDt`, `toDt`, `createdDt`, `modifiedDt`) VALUES
(6, 6, 1, 'spacer', 5, 1, 5, 1, 0, 2147483647, 1670256751, 1670256837),
(7, 6, 1, 'text', 20, 2, 20, 1, 0, 2147483647, 1670256751, 1670256837),
(8, 7, 1, 'text', 10, 1, 10, 1, 0, 2147483647, 1670256751, 1670256871),
(9, 8, 1, 'image', 60, 1, 60, 1, 0, 2147483647, 1670256751, 1670257025),
(10, 9, 1, 'clock', 1, 1, 1, 0, 0, 2147483647, 1670256751, 1670256837);

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

--
-- Estrutura da tabela `widgethistory`
--

CREATE TABLE `widgethistory` (
  `id` int(11) NOT NULL,
  `layoutHistoryId` int(11) NOT NULL,
  `widgetId` int(11) NOT NULL,
  `mediaId` int(11) DEFAULT NULL,
  `type` varchar(50) NOT NULL,
  `name` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `widgethistory`
--

INSERT INTO `widgethistory` (`id`, `layoutHistoryId`, `widgetId`, `mediaId`, `type`, `name`) VALUES
(1, 1, 5, NULL, 'clock', NULL),
(2, 1, 1, 28, 'image', 'Company Logo'),
(3, 1, 2, NULL, 'text', 'Header Text'),
(4, 1, 3, NULL, 'spacer', NULL),
(5, 1, 4, NULL, 'text', 'Explainer Text');

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

--
-- Estrutura da tabela `widgetoption`
--

CREATE TABLE `widgetoption` (
  `widgetId` int(11) NOT NULL,
  `type` varchar(50) NOT NULL,
  `option` varchar(254) NOT NULL,
  `value` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `widgetoption`
--

INSERT INTO `widgetoption` (`widgetId`, `type`, `option`, `value`) VALUES
(6, 'attrib', 'enableStat', 'Inherit'),
(6, 'attrib', 'lowerLimit', '0'),
(6, 'attrib', 'upperLimit', '0'),
(7, 'attrib', 'backgroundColor', NULL),
(7, 'attrib', 'effect', 'fade'),
(7, 'attrib', 'enableStat', 'Inherit'),
(7, 'attrib', 'lowerLimit', '0'),
(7, 'attrib', 'marqueeInlineSelector', NULL),
(7, 'attrib', 'name', 'Explainer Text'),
(7, 'attrib', 'speed', '6000'),
(7, 'attrib', 'ta_text_advanced', '0'),
(7, 'attrib', 'upperLimit', '0'),
(7, 'attrib', 'xmds', '1'),
(7, 'cdata', 'javaScript', ''),
(7, 'cdata', 'text', 'This is the Default Layout to assign to displays\r\n\r\nIt will be shown when nothing else is scheduled\r\n\r\nEdit this Default Layout to personalise or create your own to assign to your displays!\r\n\r\n \r\n'),
(8, 'attrib', 'alignV', 'top'),
(8, 'attrib', 'backgroundColor', ''),
(8, 'attrib', 'effect', 'none'),
(8, 'attrib', 'enableStat', 'Inherit'),
(8, 'attrib', 'lowerLimit', '0'),
(8, 'attrib', 'marqueeInlineSelector', ''),
(8, 'attrib', 'name', 'Header Text'),
(8, 'attrib', 'speed', NULL),
(8, 'attrib', 'ta_text_advanced', '1'),
(8, 'attrib', 'upperLimit', '0'),
(8, 'attrib', 'xmds', '1'),
(8, 'cdata', 'javaScript', ''),
(8, 'cdata', 'text', 'powered by...\r\n\r\nMGA Digital Signage\r\n'),
(9, 'attrib', 'align', 'center'),
(9, 'attrib', 'enableStat', 'Inherit'),
(9, 'attrib', 'name', 'Company Logo'),
(9, 'attrib', 'scaleType', 'center'),
(9, 'attrib', 'uri', '1.png'),
(9, 'attrib', 'valign', 'middle'),
(10, 'attrib', 'clockFace', 'TwentyFourHourClock'),
(10, 'attrib', 'clockTypeId', '2'),
(10, 'attrib', 'enableStat', 'Inherit'),
(10, 'attrib', 'lowerLimit', '0'),
(10, 'attrib', 'name', NULL),
(10, 'attrib', 'offset', '0'),
(10, 'attrib', 'showSeconds', '1'),
(10, 'attrib', 'ta_text_advanced', '0'),
(10, 'attrib', 'theme', '1'),
(10, 'attrib', 'upperLimit', '0'),
(10, 'cdata', 'format', '[HH:mm]\r\n');

--
-- Índices para tabelas despejadas
--

--
-- Índices para tabela `action`
--
ALTER TABLE `action`
  ADD PRIMARY KEY (`actionId`),
  ADD KEY `ownerId` (`ownerId`);

--
-- Índices para tabela `auditlog`
--
ALTER TABLE `auditlog`
  ADD PRIMARY KEY (`logId`);

--
-- Índices para tabela `bandwidth`
--
ALTER TABLE `bandwidth`
  ADD PRIMARY KEY (`displayId`,`type`,`month`),
  ADD KEY `type` (`type`);

--
-- Índices para tabela `bandwidthtype`
--
ALTER TABLE `bandwidthtype`
  ADD PRIMARY KEY (`bandwidthTypeId`);

--
-- Índices para tabela `campaign`
--
ALTER TABLE `campaign`
  ADD PRIMARY KEY (`campaignId`),
  ADD KEY `userId` (`userId`),
  ADD KEY `folderId` (`folderId`);

--
-- Índices para tabela `command`
--
ALTER TABLE `command`
  ADD PRIMARY KEY (`commandId`),
  ADD KEY `userId` (`userId`);

--
-- Índices para tabela `connectors`
--
ALTER TABLE `connectors`
  ADD PRIMARY KEY (`connectorId`);

--
-- Índices para tabela `dataset`
--
ALTER TABLE `dataset`
  ADD PRIMARY KEY (`dataSetId`),
  ADD KEY `userId` (`userId`),
  ADD KEY `folderId` (`folderId`);

--
-- Índices para tabela `datasetcolumn`
--
ALTER TABLE `datasetcolumn`
  ADD PRIMARY KEY (`dataSetColumnId`),
  ADD KEY `dataSetId` (`dataSetId`),
  ADD KEY `dataTypeId` (`dataTypeId`),
  ADD KEY `dataSetColumnTypeId` (`dataSetColumnTypeId`);

--
-- Índices para tabela `datasetcolumntype`
--
ALTER TABLE `datasetcolumntype`
  ADD PRIMARY KEY (`dataSetColumnTypeId`);

--
-- Índices para tabela `datasetrss`
--
ALTER TABLE `datasetrss`
  ADD PRIMARY KEY (`id`),
  ADD KEY `dataSetId` (`dataSetId`);

--
-- Índices para tabela `datatype`
--
ALTER TABLE `datatype`
  ADD PRIMARY KEY (`dataTypeId`);

--
-- Índices para tabela `daypart`
--
ALTER TABLE `daypart`
  ADD PRIMARY KEY (`dayPartId`),
  ADD KEY `userId` (`userId`);

--
-- Índices para tabela `display`
--
ALTER TABLE `display`
  ADD PRIMARY KEY (`displayId`),
  ADD UNIQUE KEY `license` (`license`),
  ADD KEY `defaultLayoutId` (`defaultLayoutId`),
  ADD KEY `displayProfileId` (`displayProfileId`),
  ADD KEY `displayTypeId` (`displayTypeId`);

--
-- Índices para tabela `displayevent`
--
ALTER TABLE `displayevent`
  ADD PRIMARY KEY (`displayEventId`),
  ADD KEY `eventDate` (`eventDate`),
  ADD KEY `displayId` (`displayId`,`end`);

--
-- Índices para tabela `displaygroup`
--
ALTER TABLE `displaygroup`
  ADD PRIMARY KEY (`displayGroupId`),
  ADD KEY `userId` (`userId`),
  ADD KEY `folderId` (`folderId`);

--
-- Índices para tabela `displayprofile`
--
ALTER TABLE `displayprofile`
  ADD PRIMARY KEY (`displayProfileId`),
  ADD KEY `userId` (`userId`);

--
-- Índices para tabela `display_types`
--
ALTER TABLE `display_types`
  ADD PRIMARY KEY (`displayTypeId`);

--
-- Índices para tabela `folder`
--
ALTER TABLE `folder`
  ADD PRIMARY KEY (`folderId`);

--
-- Índices para tabela `group`
--
ALTER TABLE `group`
  ADD PRIMARY KEY (`groupId`);

--
-- Índices para tabela `help`
--
ALTER TABLE `help`
  ADD PRIMARY KEY (`helpId`);

--
-- Índices para tabela `layout`
--
ALTER TABLE `layout`
  ADD PRIMARY KEY (`layoutId`),
  ADD KEY `userId` (`userId`),
  ADD KEY `backgroundImageId` (`backgroundImageId`),
  ADD KEY `publishedStatusId` (`publishedStatusId`);

--
-- Índices para tabela `layouthistory`
--
ALTER TABLE `layouthistory`
  ADD PRIMARY KEY (`layoutHistoryId`),
  ADD KEY `campaignId` (`campaignId`);

--
-- Índices para tabela `lkcampaigndisplaygroup`
--
ALTER TABLE `lkcampaigndisplaygroup`
  ADD PRIMARY KEY (`campaignId`,`displayGroupId`),
  ADD KEY `displayGroupId` (`displayGroupId`);

--
-- Índices para tabela `lkcampaignlayout`
--
ALTER TABLE `lkcampaignlayout`
  ADD PRIMARY KEY (`lkCampaignLayoutId`),
  ADD UNIQUE KEY `campaignId` (`campaignId`,`layoutId`,`displayOrder`),
  ADD KEY `layoutId` (`layoutId`);

--
-- Índices para tabela `lkcommanddisplayprofile`
--
ALTER TABLE `lkcommanddisplayprofile`
  ADD PRIMARY KEY (`commandId`,`displayProfileId`),
  ADD KEY `displayProfileId` (`displayProfileId`);

--
-- Índices para tabela `lkdgdg`
--
ALTER TABLE `lkdgdg`
  ADD KEY `parentId` (`parentId`,`childId`,`depth`),
  ADD KEY `childId` (`childId`,`parentId`,`depth`);

--
-- Índices para tabela `lkdisplaydg`
--
ALTER TABLE `lkdisplaydg`
  ADD PRIMARY KEY (`LkDisplayDGID`),
  ADD UNIQUE KEY `displayGroupId` (`displayGroupId`,`displayId`),
  ADD KEY `displayId` (`displayId`);

--
-- Índices para tabela `lklayoutdisplaygroup`
--
ALTER TABLE `lklayoutdisplaygroup`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `displayGroupId` (`displayGroupId`,`layoutId`),
  ADD KEY `layoutId` (`layoutId`);

--
-- Índices para tabela `lkmediadisplaygroup`
--
ALTER TABLE `lkmediadisplaygroup`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `displayGroupId` (`displayGroupId`,`mediaId`),
  ADD KEY `mediaId` (`mediaId`);

--
-- Índices para tabela `lknotificationdg`
--
ALTER TABLE `lknotificationdg`
  ADD PRIMARY KEY (`lkNotificationDgId`),
  ADD UNIQUE KEY `notificationId` (`notificationId`,`displayGroupId`);

--
-- Índices para tabela `lknotificationgroup`
--
ALTER TABLE `lknotificationgroup`
  ADD PRIMARY KEY (`lkNotificationGroupId`),
  ADD UNIQUE KEY `notificationId` (`notificationId`,`groupId`),
  ADD KEY `groupId` (`groupId`);

--
-- Índices para tabela `lknotificationuser`
--
ALTER TABLE `lknotificationuser`
  ADD PRIMARY KEY (`lkNotificationUserId`),
  ADD UNIQUE KEY `notificationId` (`notificationId`,`userId`),
  ADD KEY `userId` (`userId`);

--
-- Índices para tabela `lkplaylistplaylist`
--
ALTER TABLE `lkplaylistplaylist`
  ADD PRIMARY KEY (`parentId`,`childId`,`depth`),
  ADD UNIQUE KEY `childId` (`childId`,`parentId`,`depth`);

--
-- Índices para tabela `lkscheduledisplaygroup`
--
ALTER TABLE `lkscheduledisplaygroup`
  ADD PRIMARY KEY (`eventId`,`displayGroupId`),
  ADD KEY `displayGroupId` (`displayGroupId`);

--
-- Índices para tabela `lktagcampaign`
--
ALTER TABLE `lktagcampaign`
  ADD PRIMARY KEY (`lkTagCampaignId`),
  ADD UNIQUE KEY `tagId` (`tagId`,`campaignId`),
  ADD KEY `campaignId` (`campaignId`);

--
-- Índices para tabela `lktagdisplaygroup`
--
ALTER TABLE `lktagdisplaygroup`
  ADD PRIMARY KEY (`lkTagDisplayGroupId`),
  ADD UNIQUE KEY `tagId` (`tagId`,`displayGroupId`),
  ADD KEY `displayGroupId` (`displayGroupId`);

--
-- Índices para tabela `lktaglayout`
--
ALTER TABLE `lktaglayout`
  ADD PRIMARY KEY (`lkTagLayoutId`),
  ADD UNIQUE KEY `tagId` (`tagId`,`layoutId`),
  ADD KEY `layoutId` (`layoutId`);

--
-- Índices para tabela `lktagmedia`
--
ALTER TABLE `lktagmedia`
  ADD PRIMARY KEY (`lkTagMediaId`),
  ADD UNIQUE KEY `tagId` (`tagId`,`mediaId`),
  ADD KEY `mediaId` (`mediaId`);

--
-- Índices para tabela `lktagplaylist`
--
ALTER TABLE `lktagplaylist`
  ADD PRIMARY KEY (`lkTagPlaylistId`),
  ADD UNIQUE KEY `tagId` (`tagId`,`playlistId`),
  ADD KEY `lktagplaylist_ibfk_2` (`playlistId`);

--
-- Índices para tabela `lkusergroup`
--
ALTER TABLE `lkusergroup`
  ADD PRIMARY KEY (`lkUserGroupID`),
  ADD UNIQUE KEY `groupId` (`groupId`,`userId`),
  ADD KEY `userId` (`userId`);

--
-- Índices para tabela `lkwidgetaudio`
--
ALTER TABLE `lkwidgetaudio`
  ADD PRIMARY KEY (`widgetId`,`mediaId`),
  ADD KEY `mediaId` (`mediaId`);

--
-- Índices para tabela `lkwidgetmedia`
--
ALTER TABLE `lkwidgetmedia`
  ADD PRIMARY KEY (`widgetId`,`mediaId`),
  ADD KEY `mediaId` (`mediaId`);

--
-- Índices para tabela `log`
--
ALTER TABLE `log`
  ADD PRIMARY KEY (`logId`),
  ADD KEY `logDate` (`logDate`);

--
-- Índices para tabela `media`
--
ALTER TABLE `media`
  ADD PRIMARY KEY (`mediaId`),
  ADD KEY `userId` (`userId`),
  ADD KEY `editedMediaId` (`editedMediaId`),
  ADD KEY `folderId` (`folderId`);

--
-- Índices para tabela `menu_board`
--
ALTER TABLE `menu_board`
  ADD PRIMARY KEY (`menuId`),
  ADD KEY `folderId` (`folderId`),
  ADD KEY `userId` (`userId`);

--
-- Índices para tabela `menu_category`
--
ALTER TABLE `menu_category`
  ADD PRIMARY KEY (`menuCategoryId`),
  ADD KEY `menuId` (`menuId`),
  ADD KEY `mediaId` (`mediaId`);

--
-- Índices para tabela `menu_product`
--
ALTER TABLE `menu_product`
  ADD PRIMARY KEY (`menuProductId`),
  ADD KEY `menuId` (`menuId`),
  ADD KEY `menuCategoryId` (`menuCategoryId`),
  ADD KEY `mediaId` (`mediaId`);

--
-- Índices para tabela `menu_product_options`
--
ALTER TABLE `menu_product_options`
  ADD PRIMARY KEY (`menuProductId`,`option`);

--
-- Índices para tabela `module`
--
ALTER TABLE `module`
  ADD PRIMARY KEY (`moduleId`);

--
-- Índices para tabela `notification`
--
ALTER TABLE `notification`
  ADD PRIMARY KEY (`notificationId`),
  ADD KEY `userId` (`userId`);

--
-- Índices para tabela `oauth_clients`
--
ALTER TABLE `oauth_clients`
  ADD PRIMARY KEY (`id`),
  ADD KEY `userId` (`userId`);

--
-- Índices para tabela `oauth_client_redirect_uris`
--
ALTER TABLE `oauth_client_redirect_uris`
  ADD PRIMARY KEY (`id`);

--
-- Índices para tabela `oauth_client_scopes`
--
ALTER TABLE `oauth_client_scopes`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `clientId` (`clientId`,`scopeId`);

--
-- Índices para tabela `oauth_lkclientuser`
--
ALTER TABLE `oauth_lkclientuser`
  ADD PRIMARY KEY (`lkClientUserId`),
  ADD UNIQUE KEY `clientId` (`clientId`,`userId`),
  ADD KEY `userId` (`userId`);

--
-- Índices para tabela `oauth_scopes`
--
ALTER TABLE `oauth_scopes`
  ADD PRIMARY KEY (`id`);

--
-- Índices para tabela `oauth_scope_routes`
--
ALTER TABLE `oauth_scope_routes`
  ADD PRIMARY KEY (`id`);

--
-- Índices para tabela `permission`
--
ALTER TABLE `permission`
  ADD PRIMARY KEY (`permissionId`),
  ADD KEY `permission_ibfk_1` (`groupId`),
  ADD KEY `permission_ibfk_2` (`entityId`),
  ADD KEY `permission_objectId_index` (`objectId`);

--
-- Índices para tabela `permissionentity`
--
ALTER TABLE `permissionentity`
  ADD PRIMARY KEY (`entityId`),
  ADD UNIQUE KEY `entity` (`entity`);

--
-- Índices para tabela `phinxlog`
--
ALTER TABLE `phinxlog`
  ADD PRIMARY KEY (`version`);

--
-- Índices para tabela `player_faults`
--
ALTER TABLE `player_faults`
  ADD PRIMARY KEY (`playerFaultId`),
  ADD KEY `displayId` (`displayId`);

--
-- Índices para tabela `player_software`
--
ALTER TABLE `player_software`
  ADD PRIMARY KEY (`versionId`),
  ADD KEY `mediaId` (`mediaId`);

--
-- Índices para tabela `playlist`
--
ALTER TABLE `playlist`
  ADD PRIMARY KEY (`playlistId`),
  ADD KEY `ownerId` (`ownerId`),
  ADD KEY `folderId` (`folderId`);

--
-- Índices para tabela `purge_list`
--
ALTER TABLE `purge_list`
  ADD PRIMARY KEY (`purgeListId`);

--
-- Índices para tabela `region`
--
ALTER TABLE `region`
  ADD PRIMARY KEY (`regionId`),
  ADD KEY `ownerId` (`ownerId`);

--
-- Índices para tabela `regionoption`
--
ALTER TABLE `regionoption`
  ADD PRIMARY KEY (`regionId`,`option`);

--
-- Índices para tabela `reportschedule`
--
ALTER TABLE `reportschedule`
  ADD PRIMARY KEY (`reportScheduleId`),
  ADD KEY `userId` (`userId`);

--
-- Índices para tabela `requiredfile`
--
ALTER TABLE `requiredfile`
  ADD PRIMARY KEY (`rfId`),
  ADD KEY `displayId` (`displayId`,`type`);

--
-- Índices para tabela `resolution`
--
ALTER TABLE `resolution`
  ADD PRIMARY KEY (`resolutionId`),
  ADD KEY `userId` (`userId`);

--
-- Índices para tabela `saved_report`
--
ALTER TABLE `saved_report`
  ADD PRIMARY KEY (`savedReportId`),
  ADD KEY `userId` (`userId`),
  ADD KEY `mediaId` (`mediaId`),
  ADD KEY `reportScheduleId` (`reportScheduleId`);

--
-- Índices para tabela `schedule`
--
ALTER TABLE `schedule`
  ADD PRIMARY KEY (`eventId`),
  ADD KEY `campaignId` (`campaignId`),
  ADD KEY `userId` (`userId`);

--
-- Índices para tabela `scheduleexclusions`
--
ALTER TABLE `scheduleexclusions`
  ADD PRIMARY KEY (`scheduleExclusionId`),
  ADD KEY `eventId` (`eventId`);

--
-- Índices para tabela `schedulereminder`
--
ALTER TABLE `schedulereminder`
  ADD PRIMARY KEY (`scheduleReminderId`),
  ADD KEY `eventId` (`eventId`);

--
-- Índices para tabela `session`
--
ALTER TABLE `session`
  ADD PRIMARY KEY (`session_id`),
  ADD KEY `userId` (`userId`);

--
-- Índices para tabela `setting`
--
ALTER TABLE `setting`
  ADD PRIMARY KEY (`settingId`);

--
-- Índices para tabela `stat`
--
ALTER TABLE `stat`
  ADD PRIMARY KEY (`statId`),
  ADD KEY `statDate` (`statDate`),
  ADD KEY `displayId` (`displayId`,`end`,`type`);

--
-- Índices para tabela `status`
--
ALTER TABLE `status`
  ADD PRIMARY KEY (`id`);

--
-- Índices para tabela `stat_archive`
--
ALTER TABLE `stat_archive`
  ADD PRIMARY KEY (`statId`),
  ADD KEY `statDate` (`statDate`),
  ADD KEY `displayId` (`displayId`,`end`,`type`);

--
-- Índices para tabela `tag`
--
ALTER TABLE `tag`
  ADD PRIMARY KEY (`tagId`);

--
-- Índices para tabela `task`
--
ALTER TABLE `task`
  ADD PRIMARY KEY (`taskId`);

--
-- Índices para tabela `transition`
--
ALTER TABLE `transition`
  ADD PRIMARY KEY (`transitionId`);

--
-- Índices para tabela `user`
--
ALTER TABLE `user`
  ADD PRIMARY KEY (`userId`),
  ADD KEY `userTypeId` (`userTypeId`),
  ADD KEY `homeFolderId` (`homeFolderId`);

--
-- Índices para tabela `useroption`
--
ALTER TABLE `useroption`
  ADD PRIMARY KEY (`userId`,`option`);

--
-- Índices para tabela `usertype`
--
ALTER TABLE `usertype`
  ADD PRIMARY KEY (`userTypeId`);

--
-- Índices para tabela `widget`
--
ALTER TABLE `widget`
  ADD PRIMARY KEY (`widgetId`),
  ADD KEY `playlistId` (`playlistId`),
  ADD KEY `ownerId` (`ownerId`);

--
-- Índices para tabela `widgethistory`
--
ALTER TABLE `widgethistory`
  ADD PRIMARY KEY (`id`),
  ADD KEY `layoutHistoryId` (`layoutHistoryId`);

--
-- Índices para tabela `widgetoption`
--
ALTER TABLE `widgetoption`
  ADD PRIMARY KEY (`widgetId`,`type`,`option`);

--
-- AUTO_INCREMENT de tabelas despejadas
--

--
-- AUTO_INCREMENT de tabela `action`
--
ALTER TABLE `action`
  MODIFY `actionId` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `auditlog`
--
ALTER TABLE `auditlog`
  MODIFY `logId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=376;

--
-- AUTO_INCREMENT de tabela `bandwidthtype`
--
ALTER TABLE `bandwidthtype`
  MODIFY `bandwidthTypeId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT de tabela `campaign`
--
ALTER TABLE `campaign`
  MODIFY `campaignId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT de tabela `command`
--
ALTER TABLE `command`
  MODIFY `commandId` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `connectors`
--
ALTER TABLE `connectors`
  MODIFY `connectorId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT de tabela `dataset`
--
ALTER TABLE `dataset`
  MODIFY `dataSetId` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `datasetcolumn`
--
ALTER TABLE `datasetcolumn`
  MODIFY `dataSetColumnId` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `datasetcolumntype`
--
ALTER TABLE `datasetcolumntype`
  MODIFY `dataSetColumnTypeId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT de tabela `datasetrss`
--
ALTER TABLE `datasetrss`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `datatype`
--
ALTER TABLE `datatype`
  MODIFY `dataTypeId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT de tabela `daypart`
--
ALTER TABLE `daypart`
  MODIFY `dayPartId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT de tabela `display`
--
ALTER TABLE `display`
  MODIFY `displayId` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `displayevent`
--
ALTER TABLE `displayevent`
  MODIFY `displayEventId` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `displaygroup`
--
ALTER TABLE `displaygroup`
  MODIFY `displayGroupId` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `displayprofile`
--
ALTER TABLE `displayprofile`
  MODIFY `displayProfileId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT de tabela `display_types`
--
ALTER TABLE `display_types`
  MODIFY `displayTypeId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT de tabela `folder`
--
ALTER TABLE `folder`
  MODIFY `folderId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de tabela `group`
--
ALTER TABLE `group`
  MODIFY `groupId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT de tabela `help`
--
ALTER TABLE `help`
  MODIFY `helpId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=85;

--
-- AUTO_INCREMENT de tabela `layout`
--
ALTER TABLE `layout`
  MODIFY `layoutId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT de tabela `layouthistory`
--
ALTER TABLE `layouthistory`
  MODIFY `layoutHistoryId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT de tabela `lkcampaignlayout`
--
ALTER TABLE `lkcampaignlayout`
  MODIFY `lkCampaignLayoutId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT de tabela `lkdisplaydg`
--
ALTER TABLE `lkdisplaydg`
  MODIFY `LkDisplayDGID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `lklayoutdisplaygroup`
--
ALTER TABLE `lklayoutdisplaygroup`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `lkmediadisplaygroup`
--
ALTER TABLE `lkmediadisplaygroup`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `lknotificationdg`
--
ALTER TABLE `lknotificationdg`
  MODIFY `lkNotificationDgId` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `lknotificationgroup`
--
ALTER TABLE `lknotificationgroup`
  MODIFY `lkNotificationGroupId` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `lknotificationuser`
--
ALTER TABLE `lknotificationuser`
  MODIFY `lkNotificationUserId` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `lktagcampaign`
--
ALTER TABLE `lktagcampaign`
  MODIFY `lkTagCampaignId` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `lktagdisplaygroup`
--
ALTER TABLE `lktagdisplaygroup`
  MODIFY `lkTagDisplayGroupId` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `lktaglayout`
--
ALTER TABLE `lktaglayout`
  MODIFY `lkTagLayoutId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT de tabela `lktagmedia`
--
ALTER TABLE `lktagmedia`
  MODIFY `lkTagMediaId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT de tabela `lktagplaylist`
--
ALTER TABLE `lktagplaylist`
  MODIFY `lkTagPlaylistId` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `lkusergroup`
--
ALTER TABLE `lkusergroup`
  MODIFY `lkUserGroupID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de tabela `log`
--
ALTER TABLE `log`
  MODIFY `logId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT de tabela `media`
--
ALTER TABLE `media`
  MODIFY `mediaId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=49;

--
-- AUTO_INCREMENT de tabela `menu_board`
--
ALTER TABLE `menu_board`
  MODIFY `menuId` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `menu_category`
--
ALTER TABLE `menu_category`
  MODIFY `menuCategoryId` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `menu_product`
--
ALTER TABLE `menu_product`
  MODIFY `menuProductId` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `module`
--
ALTER TABLE `module`
  MODIFY `moduleId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34;

--
-- AUTO_INCREMENT de tabela `notification`
--
ALTER TABLE `notification`
  MODIFY `notificationId` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `oauth_client_redirect_uris`
--
ALTER TABLE `oauth_client_redirect_uris`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `oauth_client_scopes`
--
ALTER TABLE `oauth_client_scopes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `oauth_lkclientuser`
--
ALTER TABLE `oauth_lkclientuser`
  MODIFY `lkClientUserId` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `oauth_scope_routes`
--
ALTER TABLE `oauth_scope_routes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT de tabela `permission`
--
ALTER TABLE `permission`
  MODIFY `permissionId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT de tabela `permissionentity`
--
ALTER TABLE `permissionentity`
  MODIFY `entityId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT de tabela `player_faults`
--
ALTER TABLE `player_faults`
  MODIFY `playerFaultId` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `player_software`
--
ALTER TABLE `player_software`
  MODIFY `versionId` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `playlist`
--
ALTER TABLE `playlist`
  MODIFY `playlistId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT de tabela `purge_list`
--
ALTER TABLE `purge_list`
  MODIFY `purgeListId` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `region`
--
ALTER TABLE `region`
  MODIFY `regionId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT de tabela `reportschedule`
--
ALTER TABLE `reportschedule`
  MODIFY `reportScheduleId` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `requiredfile`
--
ALTER TABLE `requiredfile`
  MODIFY `rfId` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `resolution`
--
ALTER TABLE `resolution`
  MODIFY `resolutionId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT de tabela `saved_report`
--
ALTER TABLE `saved_report`
  MODIFY `savedReportId` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `schedule`
--
ALTER TABLE `schedule`
  MODIFY `eventId` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `scheduleexclusions`
--
ALTER TABLE `scheduleexclusions`
  MODIFY `scheduleExclusionId` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `schedulereminder`
--
ALTER TABLE `schedulereminder`
  MODIFY `scheduleReminderId` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `setting`
--
ALTER TABLE `setting`
  MODIFY `settingId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=131;

--
-- AUTO_INCREMENT de tabela `stat`
--
ALTER TABLE `stat`
  MODIFY `statId` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `status`
--
ALTER TABLE `status`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT de tabela `stat_archive`
--
ALTER TABLE `stat_archive`
  MODIFY `statId` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `tag`
--
ALTER TABLE `tag`
  MODIFY `tagId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT de tabela `task`
--
ALTER TABLE `task`
  MODIFY `taskId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT de tabela `transition`
--
ALTER TABLE `transition`
  MODIFY `transitionId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT de tabela `user`
--
ALTER TABLE `user`
  MODIFY `userId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de tabela `usertype`
--
ALTER TABLE `usertype`
  MODIFY `userTypeId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT de tabela `widget`
--
ALTER TABLE `widget`
  MODIFY `widgetId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT de tabela `widgethistory`
--
ALTER TABLE `widgethistory`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- Restrições para despejos de tabelas
--

--
-- Limitadores para a tabela `action`
--
ALTER TABLE `action`
  ADD CONSTRAINT `action_ibfk_1` FOREIGN KEY (`ownerId`) REFERENCES `user` (`userId`);

--
-- Limitadores para a tabela `bandwidth`
--
ALTER TABLE `bandwidth`
  ADD CONSTRAINT `bandwidth_ibfk_1` FOREIGN KEY (`type`) REFERENCES `bandwidthtype` (`bandwidthTypeId`);

--
-- Limitadores para a tabela `campaign`
--
ALTER TABLE `campaign`
  ADD CONSTRAINT `campaign_ibfk_1` FOREIGN KEY (`userId`) REFERENCES `user` (`userId`),
  ADD CONSTRAINT `campaign_ibfk_2` FOREIGN KEY (`folderId`) REFERENCES `folder` (`folderId`);

--
-- Limitadores para a tabela `command`
--
ALTER TABLE `command`
  ADD CONSTRAINT `command_ibfk_1` FOREIGN KEY (`userId`) REFERENCES `user` (`userId`);

--
-- Limitadores para a tabela `dataset`
--
ALTER TABLE `dataset`
  ADD CONSTRAINT `dataset_ibfk_1` FOREIGN KEY (`userId`) REFERENCES `user` (`userId`),
  ADD CONSTRAINT `dataset_ibfk_2` FOREIGN KEY (`folderId`) REFERENCES `folder` (`folderId`);

--
-- Limitadores para a tabela `datasetcolumn`
--
ALTER TABLE `datasetcolumn`
  ADD CONSTRAINT `datasetcolumn_ibfk_1` FOREIGN KEY (`dataSetId`) REFERENCES `dataset` (`dataSetId`),
  ADD CONSTRAINT `datasetcolumn_ibfk_2` FOREIGN KEY (`dataTypeId`) REFERENCES `datatype` (`dataTypeId`),
  ADD CONSTRAINT `datasetcolumn_ibfk_3` FOREIGN KEY (`dataSetColumnTypeId`) REFERENCES `datasetcolumntype` (`dataSetColumnTypeId`);

--
-- Limitadores para a tabela `datasetrss`
--
ALTER TABLE `datasetrss`
  ADD CONSTRAINT `datasetrss_ibfk_1` FOREIGN KEY (`dataSetId`) REFERENCES `dataset` (`dataSetId`);

--
-- Limitadores para a tabela `daypart`
--
ALTER TABLE `daypart`
  ADD CONSTRAINT `daypart_ibfk_1` FOREIGN KEY (`userId`) REFERENCES `user` (`userId`);

--
-- Limitadores para a tabela `display`
--
ALTER TABLE `display`
  ADD CONSTRAINT `display_ibfk_1` FOREIGN KEY (`displayProfileId`) REFERENCES `displayprofile` (`displayProfileId`),
  ADD CONSTRAINT `display_ibfk_2` FOREIGN KEY (`displayTypeId`) REFERENCES `display_types` (`displayTypeId`);

--
-- Limitadores para a tabela `displaygroup`
--
ALTER TABLE `displaygroup`
  ADD CONSTRAINT `displaygroup_ibfk_1` FOREIGN KEY (`userId`) REFERENCES `user` (`userId`),
  ADD CONSTRAINT `displaygroup_ibfk_2` FOREIGN KEY (`folderId`) REFERENCES `folder` (`folderId`);

--
-- Limitadores para a tabela `displayprofile`
--
ALTER TABLE `displayprofile`
  ADD CONSTRAINT `displayprofile_ibfk_1` FOREIGN KEY (`userId`) REFERENCES `user` (`userId`);

--
-- Limitadores para a tabela `layout`
--
ALTER TABLE `layout`
  ADD CONSTRAINT `layout_ibfk_1` FOREIGN KEY (`userId`) REFERENCES `user` (`userId`),
  ADD CONSTRAINT `layout_ibfk_2` FOREIGN KEY (`backgroundImageId`) REFERENCES `media` (`mediaId`),
  ADD CONSTRAINT `layout_ibfk_3` FOREIGN KEY (`publishedStatusId`) REFERENCES `status` (`id`);

--
-- Limitadores para a tabela `layouthistory`
--
ALTER TABLE `layouthistory`
  ADD CONSTRAINT `layouthistory_ibfk_1` FOREIGN KEY (`campaignId`) REFERENCES `campaign` (`campaignId`);

--
-- Limitadores para a tabela `lkcampaigndisplaygroup`
--
ALTER TABLE `lkcampaigndisplaygroup`
  ADD CONSTRAINT `lkcampaigndisplaygroup_ibfk_1` FOREIGN KEY (`campaignId`) REFERENCES `campaign` (`campaignId`),
  ADD CONSTRAINT `lkcampaigndisplaygroup_ibfk_2` FOREIGN KEY (`displayGroupId`) REFERENCES `displaygroup` (`displayGroupId`);

--
-- Limitadores para a tabela `lkcampaignlayout`
--
ALTER TABLE `lkcampaignlayout`
  ADD CONSTRAINT `lkcampaignlayout_ibfk_1` FOREIGN KEY (`campaignId`) REFERENCES `campaign` (`campaignId`),
  ADD CONSTRAINT `lkcampaignlayout_ibfk_2` FOREIGN KEY (`layoutId`) REFERENCES `layout` (`layoutId`);

--
-- Limitadores para a tabela `lkcommanddisplayprofile`
--
ALTER TABLE `lkcommanddisplayprofile`
  ADD CONSTRAINT `lkcommanddisplayprofile_ibfk_1` FOREIGN KEY (`commandId`) REFERENCES `command` (`commandId`),
  ADD CONSTRAINT `lkcommanddisplayprofile_ibfk_2` FOREIGN KEY (`displayProfileId`) REFERENCES `displayprofile` (`displayProfileId`);

--
-- Limitadores para a tabela `lkdisplaydg`
--
ALTER TABLE `lkdisplaydg`
  ADD CONSTRAINT `lkdisplaydg_ibfk_1` FOREIGN KEY (`displayGroupId`) REFERENCES `displaygroup` (`displayGroupId`),
  ADD CONSTRAINT `lkdisplaydg_ibfk_2` FOREIGN KEY (`displayId`) REFERENCES `display` (`displayId`);

--
-- Limitadores para a tabela `lklayoutdisplaygroup`
--
ALTER TABLE `lklayoutdisplaygroup`
  ADD CONSTRAINT `lklayoutdisplaygroup_ibfk_1` FOREIGN KEY (`displayGroupId`) REFERENCES `displaygroup` (`displayGroupId`),
  ADD CONSTRAINT `lklayoutdisplaygroup_ibfk_2` FOREIGN KEY (`layoutId`) REFERENCES `layout` (`layoutId`);

--
-- Limitadores para a tabela `lkmediadisplaygroup`
--
ALTER TABLE `lkmediadisplaygroup`
  ADD CONSTRAINT `lkmediadisplaygroup_ibfk_1` FOREIGN KEY (`displayGroupId`) REFERENCES `displaygroup` (`displayGroupId`),
  ADD CONSTRAINT `lkmediadisplaygroup_ibfk_2` FOREIGN KEY (`mediaId`) REFERENCES `media` (`mediaId`);

--
-- Limitadores para a tabela `lknotificationdg`
--
ALTER TABLE `lknotificationdg`
  ADD CONSTRAINT `lknotificationdg_ibfk_1` FOREIGN KEY (`notificationId`) REFERENCES `notification` (`notificationId`);

--
-- Limitadores para a tabela `lknotificationgroup`
--
ALTER TABLE `lknotificationgroup`
  ADD CONSTRAINT `lknotificationgroup_ibfk_1` FOREIGN KEY (`notificationId`) REFERENCES `notification` (`notificationId`),
  ADD CONSTRAINT `lknotificationgroup_ibfk_2` FOREIGN KEY (`groupId`) REFERENCES `group` (`groupId`);

--
-- Limitadores para a tabela `lknotificationuser`
--
ALTER TABLE `lknotificationuser`
  ADD CONSTRAINT `lknotificationuser_ibfk_1` FOREIGN KEY (`notificationId`) REFERENCES `notification` (`notificationId`),
  ADD CONSTRAINT `lknotificationuser_ibfk_2` FOREIGN KEY (`userId`) REFERENCES `user` (`userId`);

--
-- Limitadores para a tabela `lkscheduledisplaygroup`
--
ALTER TABLE `lkscheduledisplaygroup`
  ADD CONSTRAINT `lkscheduledisplaygroup_ibfk_1` FOREIGN KEY (`eventId`) REFERENCES `schedule` (`eventId`),
  ADD CONSTRAINT `lkscheduledisplaygroup_ibfk_2` FOREIGN KEY (`displayGroupId`) REFERENCES `displaygroup` (`displayGroupId`);

--
-- Limitadores para a tabela `lktagcampaign`
--
ALTER TABLE `lktagcampaign`
  ADD CONSTRAINT `lktagcampaign_ibfk_1` FOREIGN KEY (`tagId`) REFERENCES `tag` (`tagId`),
  ADD CONSTRAINT `lktagcampaign_ibfk_2` FOREIGN KEY (`campaignId`) REFERENCES `campaign` (`campaignId`);

--
-- Limitadores para a tabela `lktagdisplaygroup`
--
ALTER TABLE `lktagdisplaygroup`
  ADD CONSTRAINT `lktagdisplaygroup_ibfk_1` FOREIGN KEY (`tagId`) REFERENCES `tag` (`tagId`),
  ADD CONSTRAINT `lktagdisplaygroup_ibfk_2` FOREIGN KEY (`displayGroupId`) REFERENCES `displaygroup` (`displayGroupId`);

--
-- Limitadores para a tabela `lktaglayout`
--
ALTER TABLE `lktaglayout`
  ADD CONSTRAINT `lktaglayout_ibfk_1` FOREIGN KEY (`tagId`) REFERENCES `tag` (`tagId`),
  ADD CONSTRAINT `lktaglayout_ibfk_2` FOREIGN KEY (`layoutId`) REFERENCES `layout` (`layoutId`);

--
-- Limitadores para a tabela `lktagmedia`
--
ALTER TABLE `lktagmedia`
  ADD CONSTRAINT `lktagmedia_ibfk_1` FOREIGN KEY (`tagId`) REFERENCES `tag` (`tagId`),
  ADD CONSTRAINT `lktagmedia_ibfk_2` FOREIGN KEY (`mediaId`) REFERENCES `media` (`mediaId`);

--
-- Limitadores para a tabela `lktagplaylist`
--
ALTER TABLE `lktagplaylist`
  ADD CONSTRAINT `lktagplaylist_ibfk_1` FOREIGN KEY (`tagId`) REFERENCES `tag` (`tagId`),
  ADD CONSTRAINT `lktagplaylist_ibfk_2` FOREIGN KEY (`playlistId`) REFERENCES `playlist` (`playlistId`);

--
-- Limitadores para a tabela `lkusergroup`
--
ALTER TABLE `lkusergroup`
  ADD CONSTRAINT `lkusergroup_ibfk_1` FOREIGN KEY (`groupId`) REFERENCES `group` (`groupId`),
  ADD CONSTRAINT `lkusergroup_ibfk_2` FOREIGN KEY (`userId`) REFERENCES `user` (`userId`);

--
-- Limitadores para a tabela `lkwidgetaudio`
--
ALTER TABLE `lkwidgetaudio`
  ADD CONSTRAINT `lkwidgetaudio_ibfk_1` FOREIGN KEY (`widgetId`) REFERENCES `widget` (`widgetId`),
  ADD CONSTRAINT `lkwidgetaudio_ibfk_2` FOREIGN KEY (`mediaId`) REFERENCES `media` (`mediaId`);

--
-- Limitadores para a tabela `lkwidgetmedia`
--
ALTER TABLE `lkwidgetmedia`
  ADD CONSTRAINT `lkwidgetmedia_ibfk_1` FOREIGN KEY (`widgetId`) REFERENCES `widget` (`widgetId`),
  ADD CONSTRAINT `lkwidgetmedia_ibfk_2` FOREIGN KEY (`mediaId`) REFERENCES `media` (`mediaId`);

--
-- Limitadores para a tabela `media`
--
ALTER TABLE `media`
  ADD CONSTRAINT `media_ibfk_1` FOREIGN KEY (`userId`) REFERENCES `user` (`userId`),
  ADD CONSTRAINT `media_ibfk_2` FOREIGN KEY (`folderId`) REFERENCES `folder` (`folderId`);

--
-- Limitadores para a tabela `menu_board`
--
ALTER TABLE `menu_board`
  ADD CONSTRAINT `menu_board_ibfk_1` FOREIGN KEY (`folderId`) REFERENCES `folder` (`folderId`),
  ADD CONSTRAINT `menu_board_ibfk_2` FOREIGN KEY (`userId`) REFERENCES `user` (`userId`);

--
-- Limitadores para a tabela `menu_category`
--
ALTER TABLE `menu_category`
  ADD CONSTRAINT `menu_category_ibfk_1` FOREIGN KEY (`menuId`) REFERENCES `menu_board` (`menuId`),
  ADD CONSTRAINT `menu_category_ibfk_2` FOREIGN KEY (`mediaId`) REFERENCES `media` (`mediaId`);

--
-- Limitadores para a tabela `menu_product`
--
ALTER TABLE `menu_product`
  ADD CONSTRAINT `menu_product_ibfk_1` FOREIGN KEY (`menuId`) REFERENCES `menu_board` (`menuId`),
  ADD CONSTRAINT `menu_product_ibfk_2` FOREIGN KEY (`menuCategoryId`) REFERENCES `menu_category` (`menuCategoryId`),
  ADD CONSTRAINT `menu_product_ibfk_3` FOREIGN KEY (`mediaId`) REFERENCES `media` (`mediaId`);

--
-- Limitadores para a tabela `menu_product_options`
--
ALTER TABLE `menu_product_options`
  ADD CONSTRAINT `menu_product_options_ibfk_1` FOREIGN KEY (`menuProductId`) REFERENCES `menu_product` (`menuProductId`);

--
-- Limitadores para a tabela `notification`
--
ALTER TABLE `notification`
  ADD CONSTRAINT `notification_ibfk_1` FOREIGN KEY (`userId`) REFERENCES `user` (`userId`);

--
-- Limitadores para a tabela `oauth_clients`
--
ALTER TABLE `oauth_clients`
  ADD CONSTRAINT `oauth_clients_ibfk_1` FOREIGN KEY (`userId`) REFERENCES `user` (`userId`);

--
-- Limitadores para a tabela `oauth_lkclientuser`
--
ALTER TABLE `oauth_lkclientuser`
  ADD CONSTRAINT `oauth_lkclientuser_ibfk_1` FOREIGN KEY (`clientId`) REFERENCES `oauth_clients` (`id`),
  ADD CONSTRAINT `oauth_lkclientuser_ibfk_2` FOREIGN KEY (`userId`) REFERENCES `user` (`userId`);

--
-- Limitadores para a tabela `permission`
--
ALTER TABLE `permission`
  ADD CONSTRAINT `permission_ibfk_1` FOREIGN KEY (`groupId`) REFERENCES `group` (`groupId`),
  ADD CONSTRAINT `permission_ibfk_2` FOREIGN KEY (`entityId`) REFERENCES `permissionentity` (`entityId`);

--
-- Limitadores para a tabela `player_faults`
--
ALTER TABLE `player_faults`
  ADD CONSTRAINT `player_faults_ibfk_1` FOREIGN KEY (`displayId`) REFERENCES `display` (`displayId`);

--
-- Limitadores para a tabela `player_software`
--
ALTER TABLE `player_software`
  ADD CONSTRAINT `player_software_ibfk_1` FOREIGN KEY (`mediaId`) REFERENCES `media` (`mediaId`);

--
-- Limitadores para a tabela `playlist`
--
ALTER TABLE `playlist`
  ADD CONSTRAINT `playlist_ibfk_1` FOREIGN KEY (`ownerId`) REFERENCES `user` (`userId`),
  ADD CONSTRAINT `playlist_ibfk_2` FOREIGN KEY (`folderId`) REFERENCES `folder` (`folderId`);

--
-- Limitadores para a tabela `region`
--
ALTER TABLE `region`
  ADD CONSTRAINT `region_ibfk_1` FOREIGN KEY (`ownerId`) REFERENCES `user` (`userId`);

--
-- Limitadores para a tabela `reportschedule`
--
ALTER TABLE `reportschedule`
  ADD CONSTRAINT `reportschedule_ibfk_1` FOREIGN KEY (`userId`) REFERENCES `user` (`userId`);

--
-- Limitadores para a tabela `requiredfile`
--
ALTER TABLE `requiredfile`
  ADD CONSTRAINT `requiredfile_ibfk_1` FOREIGN KEY (`displayId`) REFERENCES `display` (`displayId`);

--
-- Limitadores para a tabela `resolution`
--
ALTER TABLE `resolution`
  ADD CONSTRAINT `resolution_ibfk_1` FOREIGN KEY (`userId`) REFERENCES `user` (`userId`);

--
-- Limitadores para a tabela `saved_report`
--
ALTER TABLE `saved_report`
  ADD CONSTRAINT `saved_report_ibfk_1` FOREIGN KEY (`userId`) REFERENCES `user` (`userId`),
  ADD CONSTRAINT `saved_report_ibfk_2` FOREIGN KEY (`mediaId`) REFERENCES `media` (`mediaId`),
  ADD CONSTRAINT `saved_report_ibfk_3` FOREIGN KEY (`reportScheduleId`) REFERENCES `reportschedule` (`reportScheduleId`);

--
-- Limitadores para a tabela `schedule`
--
ALTER TABLE `schedule`
  ADD CONSTRAINT `schedule_ibfk_1` FOREIGN KEY (`userId`) REFERENCES `user` (`userId`);

--
-- Limitadores para a tabela `scheduleexclusions`
--
ALTER TABLE `scheduleexclusions`
  ADD CONSTRAINT `scheduleexclusions_ibfk_1` FOREIGN KEY (`eventId`) REFERENCES `schedule` (`eventId`);

--
-- Limitadores para a tabela `schedulereminder`
--
ALTER TABLE `schedulereminder`
  ADD CONSTRAINT `schedulereminder_ibfk_1` FOREIGN KEY (`eventId`) REFERENCES `schedule` (`eventId`);

--
-- Limitadores para a tabela `user`
--
ALTER TABLE `user`
  ADD CONSTRAINT `user_ibfk_1` FOREIGN KEY (`userTypeId`) REFERENCES `usertype` (`userTypeId`),
  ADD CONSTRAINT `user_ibfk_2` FOREIGN KEY (`homeFolderId`) REFERENCES `folder` (`folderId`);

--
-- Limitadores para a tabela `widget`
--
ALTER TABLE `widget`
  ADD CONSTRAINT `widget_ibfk_1` FOREIGN KEY (`playlistId`) REFERENCES `playlist` (`playlistId`),
  ADD CONSTRAINT `widget_ibfk_2` FOREIGN KEY (`ownerId`) REFERENCES `user` (`userId`);

--
-- Limitadores para a tabela `widgethistory`
--
ALTER TABLE `widgethistory`
  ADD CONSTRAINT `widgethistory_ibfk_1` FOREIGN KEY (`layoutHistoryId`) REFERENCES `layouthistory` (`layoutHistoryId`);

--
-- Limitadores para a tabela `widgetoption`
--
ALTER TABLE `widgetoption`
  ADD CONSTRAINT `widgetoption_ibfk_1` FOREIGN KEY (`widgetId`) REFERENCES `widget` (`widgetId`);
COMMIT;

/*!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 */;