-- --------------------------------------------------------
-- Servidor:                     localhost
-- Versão do servidor:           8.0.21 - MySQL Community Server - GPL
-- OS do Servidor:               Win64
-- HeidiSQL Versão:              12.5.0.6677
-- --------------------------------------------------------


-- Copiando estrutura para tabela i360.abouts
CREATE TABLE IF NOT EXISTS `abouts` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `title_home` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `slug` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `description_home` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `mission` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `vision` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `values` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `picture` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Copiando dados para a tabela i360.abouts: ~5 rows (aproximadamente)
DELETE FROM `abouts`;
INSERT INTO `abouts` (`id`, `title`, `title_home`, `slug`, `description`, `description_home`, `mission`, `vision`, `values`, `picture`, `created_at`, `updated_at`) VALUES
	(1, 'Sobre', NULL, 'about', '<p>Nas rela&ccedil;&otilde;es pessoais poucas coisas s&atilde;o t&atilde;o importantes quanto uma boa comunica&ccedil;&atilde;o, n&atilde;o &eacute; mesmo? E no trabalho ent&atilde;o, onde uma falha de atendimento pode custar um desgaste desnecess&aacute;rio com o cliente e acarretar preju&iacute;zo para todos? Enfim, se comunicar bem, tamb&eacute;m &eacute; a base para o in&iacute;cio de um bom neg&oacute;cio.</p>\r\n\r\n<p>Desta forma, neste mundo onde tudo est&aacute; cada vez mais digital e automatizado &eacute; quando percebemos que o ser humano ainda &eacute; o protagonista, em sua forma mais impactante de se expressar: a voz. Pois pela voz reconhecemos o semelhante, falamos com as empresas e as marcas e somos tratados e atendidos da melhor maneira que poder&iacute;amos ser. Para dar voz aos bons neg&oacute;cios e consequentemente bons resultados, n&oacute;s da i360, por meio de estrutura pr&oacute;pria, desenvolvemos e oferecemos ferramentas que atendem &agrave;s necessidades de seus p&uacute;blicos atrav&eacute;s da facilidade na experi&ecirc;ncia do usu&aacute;rio, educa&ccedil;&atilde;o e atendimento especializados.</p>\r\n\r\n<p>Al&eacute;m de fomentar parcerias id&ocirc;neas e est&iacute;mulo &agrave; gest&atilde;o anal&iacute;tica para a obten&ccedil;&atilde;o de performance e produtividade.<br />\r\nSe voc&ecirc; e sua empresa acreditam que conectar pessoas e neg&oacute;cios atrav&eacute;s da voz geram os melhores resultados, juntem-se a n&oacute;s.<br />\r\ni360 - D&ecirc; voz aos seus resultados.</p>', NULL, NULL, NULL, NULL, NULL, NULL, '2021-09-27 11:54:02'),
	(2, 'iPABX Virtual', NULL, 'ipabx-virtual', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(3, 'Funcionalidades', NULL, 'funcionalidades', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(4, 'Parceiros', NULL, 'partners', '<p>Evolua de N&iacute;vel! Quanto mais clientes conquistar, maior ser&aacute; o seu ganho.Fa&ccedil;a seu cadastro que nossa equipe entrar&aacute; em contato com voc&ecirc;.</p>', NULL, NULL, NULL, NULL, NULL, NULL, '2022-02-08 14:52:38'),
	(5, 'Afiliados', NULL, 'affiliates', '<p>Afiliados i360 oferecem o iPABX i360 aos seus clientes e demais interessados. Nosso portal de indica&ccedil;&otilde;es torna mais f&aacute;cil adicionar seus clientes e adicionar suas comiss&otilde;es.</p>', NULL, NULL, NULL, NULL, NULL, NULL, '2022-03-28 14:28:32'),
	(6, 'iPABX', NULL, 'ipabx', '<p>R&aacute;pido de contratar e simples de configurar. O iPABX i360 &eacute; altamente personaliz&aacute;vel e incrivelmente f&aacute;cil de usar. &Eacute; poss&iacute;vel discar de qualquer lugar a qualquer momento e adicionar novos usu&aacute;rios com pouca configura&ccedil;&atilde;o adicional.</p>\r\n\r\n<p>Confiabilidade de chamada incompar&aacute;vel! Simplifique processos de televendas de onde estiver e sem perder o ritmo: o iPABX i360 entende as necessidades das equipes de vendas remotas. Da configura&ccedil;&atilde;o &agrave; supervis&atilde;o, o PABX baseado em NUVEM da i360 &eacute; projetado com ferramentas que aprimoram a experi&ecirc;ncia de seus usu&aacute;rios.</p>', NULL, NULL, NULL, NULL, NULL, NULL, '2022-01-28 11:56:44');

-- Copiando estrutura para tabela i360.applications
CREATE TABLE IF NOT EXISTS `applications` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `state` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `city` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `url_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `curriculum` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `interests` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Copiando dados para a tabela i360.applications: ~0 rows (aproximadamente)
DELETE FROM `applications`;

-- Copiando estrutura para tabela i360.awards
CREATE TABLE IF NOT EXISTS `awards` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `about_id` int unsigned DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `picture` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `order` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `awards_about_id_foreign` (`about_id`),
  CONSTRAINT `awards_about_id_foreign` FOREIGN KEY (`about_id`) REFERENCES `abouts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Copiando dados para a tabela i360.awards: ~6 rows (aproximadamente)
DELETE FROM `awards`;
INSERT INTO `awards` (`id`, `about_id`, `title`, `description`, `picture`, `order`, `created_at`, `updated_at`) VALUES
	(1, 1, 'Gravação \r\ndas ligações.', NULL, 'gravacao-das-ligacoes.png', 1, '2021-09-27 11:57:38', '2021-09-29 18:02:21'),
	(2, 3, 'Relatórios', '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Curabitur quis egestas metus. Vivamus odio ligula, faucibus blandit accumsan in, sagittis vitae lacus.</p>', 'fh5-biome-swamp-02-16x9-wm.jpg', 2, '2021-09-29 16:25:33', '2021-09-29 18:08:35'),
	(3, 1, '<h3>Possibilidade v&iacute;deo confer&ecirc;ncia<br />\r\nintegrada com a plataforma<br />\r\n<strong>em todos os planos</strong></h3>', NULL, 'page6.png', 3, '2021-09-29 18:04:44', '2021-09-29 18:04:47'),
	(4, 3, 'Gravações', '<p>Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).</p>', 'fh5-biome-canyon-01-16x9-wm.jpg', 4, '2021-09-29 18:09:07', '2021-09-29 18:09:09'),
	(5, 4, '<h3>Tecnologia&nbsp;<strong>PABX virtual</strong><br />\r\nque est&aacute; em expans&atilde;o<br />\r\nentre as empresas</h3>', NULL, 'eslwncew-400x400-1.jpg', 5, '2022-01-27 11:30:31', '2022-01-27 11:30:31'),
	(6, 5, '<h3><strong>Suporte 24h</strong><br />\r\npor nossa parte</h3>', NULL, 'dep-3.jpg', 6, '2022-01-27 11:30:47', '2022-01-27 11:30:47');

-- Copiando estrutura para tabela i360.banners
CREATE TABLE IF NOT EXISTS `banners` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `subtitle` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `button_text` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `link` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `banner` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `banner_mobile` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `banner_cover` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `order` int DEFAULT NULL,
  `expire_at` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Copiando dados para a tabela i360.banners: ~2 rows (aproximadamente)
DELETE FROM `banners`;
INSERT INTO `banners` (`id`, `type`, `title`, `subtitle`, `button_text`, `description`, `link`, `banner`, `banner_mobile`, `banner_cover`, `active`, `order`, `expire_at`, `created_at`, `updated_at`) VALUES
	(1, '', 'Dê Voz à sua Gestão', 'Conheça os planos e benefícios do PABX Virtual 100% Online que irá revolucionar o seu negócio.', 'Conheça o iPABX i360', 'Fácil de usar, rápido de configurar e gera resultados para sua empresa que vão dar o que falar.', NULL, '01.png', '01-1.png', NULL, 1, 1, NULL, '2021-09-29 11:59:48', '2021-09-29 12:01:15'),
	(2, '', 'Dê Voz ao seu Home Office', 'Conheça os planos e benefícios do PABX Virtual 100% Online que irá revolucionar o seu negócio.', 'Conheça o iPABX i360', 'Fácil de usar, rápido de configurar e gera resultados para sua empresa que vão dar o que falar.', NULL, 'PFiUdTretrXD6Hq.jpg', 'YHmPECC8gLcYoJO.jpg', NULL, 1, 2, NULL, '2021-09-29 12:00:38', '2021-09-29 12:01:23');

-- Copiando estrutura para tabela i360.benefits
CREATE TABLE IF NOT EXISTS `benefits` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `model_id` int unsigned NOT NULL,
  `model` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `subtitle` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `value` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `value_aditional` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `value_extra` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `max` int DEFAULT NULL,
  `picture` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `order` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Copiando dados para a tabela i360.benefits: ~9 rows (aproximadamente)
DELETE FROM `benefits`;
INSERT INTO `benefits` (`id`, `model_id`, `model`, `title`, `description`, `subtitle`, `value`, `value_aditional`, `value_extra`, `max`, `picture`, `active`, `order`, `created_at`, `updated_at`) VALUES
	(1, 1, NULL, 'PABX Virtual', NULL, 'lasld as das das das d', NULL, NULL, NULL, NULL, NULL, 1, 1, '2022-01-27 12:23:14', '2022-01-27 12:23:14'),
	(2, 6, 'App\\Models\\Category', '0800 SMARTVOICE', '<ul>\r\n	<li><strong>Cr&eacute;dito Consum&iacute;vel:</strong> 500 min</li>\r\n	<li><strong>Portabilidade:</strong> Sim</li>\r\n	<li><strong>Linha Telef&ocirc;nica:</strong> 5</li>\r\n	<li><strong>Fixo:</strong> R$0,25</li>\r\n	<li><strong>M&oacute;vel:</strong> R$0,25</li>\r\n</ul>', '500 minutos', '129.00', '0.25', NULL, 0, NULL, 1, 2, '2022-02-01 14:06:22', '2022-02-03 12:25:39'),
	(3, 6, NULL, '0800 MACRO', NULL, 'Minutos ilimitados', '299.00', '0.00', NULL, 2, NULL, 1, 3, '2022-02-01 14:13:40', '2022-02-03 12:25:43'),
	(4, 6, NULL, '0800 lalaa', NULL, NULL, '0.00', NULL, NULL, 0, NULL, 1, 4, '2022-02-08 14:57:05', '2022-02-08 14:57:05'),
	(5, 6, NULL, '0800 lasdasd', NULL, NULL, '0.00', NULL, NULL, 0, NULL, 1, 5, '2022-02-08 14:57:12', '2022-02-08 14:57:12'),
	(6, 6, NULL, 'Teste', NULL, 'Teste', NULL, NULL, NULL, NULL, NULL, 1, 6, '2022-02-18 12:34:57', '2022-02-18 12:34:57'),
	(7, 6, 'App\\Repositories\\Services\\BenefitRepository', 'Teste', NULL, 'asd as das das d', NULL, NULL, NULL, NULL, NULL, 1, 7, '2022-02-18 12:35:45', '2022-02-18 12:35:45'),
	(8, 6, 'App\\Models\\Service', 'asdas as', NULL, 'd as das d', NULL, NULL, NULL, NULL, NULL, 1, 8, '2022-02-18 12:36:23', '2022-02-18 12:36:23'),
	(9, 6, 'App\\Models\\Category', 'Teste', NULL, NULL, '1.99', NULL, NULL, 0, NULL, 1, 9, '2022-02-18 12:36:43', '2022-02-18 12:36:43');

-- Copiando estrutura para tabela i360.categories
CREATE TABLE IF NOT EXISTS `categories` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `type` bit(1) NOT NULL,
  `show` tinyint(1) NOT NULL DEFAULT '1',
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `subtitle` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `extra_description` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `value` decimal(15,2) DEFAULT NULL,
  `billing_period` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'mensal',
  `picture` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `banner` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `order` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Copiando dados para a tabela i360.categories: ~7 rows (aproximadamente)
DELETE FROM `categories`;
INSERT INTO `categories` (`id`, `type`, `show`, `title`, `subtitle`, `description`, `extra_description`, `value`, `billing_period`, `picture`, `banner`, `active`, `order`, `created_at`, `updated_at`) VALUES
	(1, b'1', 0, 'Número Virtual POPs', NULL, '<p>(CNs11, 31, 51 (Teut&ocirc;nia, Estrela, Lajeado, Santa Cruz do Sul e Van&acirc;ncio Aires)</p>', '<div class="block-title custom">&bull; Plano Basic: <span class="text"><strong>R$ 23,90</strong> (mensal)</span></div>\r\n\r\n<div class="block-title custom">&bull; Plano Advanced: <span class="text"><strong>R$ 74,90</strong> (mensal)</span></div>\r\n\r\n<div class="block-title custom">&bull; Plano Expert: <span class="text"><strong>R$ 189,90</strong> (mensal)</span></div>', 14.90, 'mensal', NULL, NULL, 1, 1, '2021-09-29 16:40:08', '2022-02-01 16:05:51'),
	(2, b'0', 0, 'Número Virtual ROC (Demais localidades)', NULL, NULL, NULL, 29.90, 'mensal', NULL, NULL, 1, 2, '2021-09-29 16:44:39', '2022-02-01 16:06:02'),
	(3, b'0', 1, 'Gravação URA', NULL, '<p>(Valor &uacute;nico por grava&ccedil;&atilde;o)</p>', NULL, 14.90, 'mensal', NULL, NULL, 1, 3, '2021-09-29 16:44:58', '2021-09-29 16:44:58'),
	(4, b'0', 1, 'Módulo Call Center mais Discador Automático', NULL, '<p>(Mensalidade por ramal e discador autom&aacute;tico para at&eacute; 25 ramais)</p>', NULL, 0.00, 'mensal', NULL, NULL, 1, 4, '2021-09-29 16:45:18', '2021-09-29 16:45:18'),
	(5, b'0', 1, 'Cloud 100GB', NULL, NULL, NULL, 9.90, 'mensal', NULL, NULL, 1, 5, '2021-09-29 16:45:33', '2021-09-29 16:45:33'),
	(6, b'0', 0, 'Número 0800', NULL, '<p>Minutagem para consumo compartilhado entre ramais.<br />\r\nQuantidade de canais proporcionais &agrave; quantidade de ramais contratados.</p>', '<div class="table-responsive content-table">\r\n<table class="table table-additional">\r\n	<thead>\r\n		<tr>\r\n			<th class="custom upper">Item</th>\r\n			<th class="upper">Receive</th>\r\n			<th class="upper">Voice</th>\r\n			<th class="upper">Sell</th>\r\n		</tr>\r\n	</thead>\r\n	<tbody>\r\n		<tr>\r\n			<td><strong>0800 - 100 Minutos</strong></td>\r\n			<td><strong>R$ 49,90</strong></td>\r\n			<td><strong>R$ 49,90</strong></td>\r\n			<td><strong>R$ 49,90</strong></td>\r\n		</tr>\r\n		<tr>\r\n			<td><strong>Canais 0800</strong></td>\r\n			<td>Qtd. Ramais contratados</td>\r\n			<td>Qtd. Ramais contratados</td>\r\n			<td>Qtd. Ramais contratados</td>\r\n		</tr>\r\n		<tr>\r\n			<td><strong>Tarafa Fixo e M&oacute;vel - Consumo Excedente</strong></td>\r\n			<td>R$ 0,25</td>\r\n			<td>R$ 0,25</td>\r\n			<td>R$ 0,25</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n</div>', 49.90, 'mensal', NULL, NULL, 1, 6, '2021-09-29 16:49:41', '2022-02-01 16:06:11'),
	(7, b'0', 1, 'Portabilidade (Portabilidade em até 5 dias)', NULL, '<p>Suporte especializado com dura&ccedil;&atilde;o de at&eacute; 2 horas para utiliza&ccedil;&atilde;o dentro do m&ecirc;s contratado.</p>', NULL, 200.00, 'mensal', NULL, NULL, 1, 7, '2021-09-29 16:53:57', '2021-09-29 16:53:57'),
	(8, b'1', 1, 'Ramal Adicional', NULL, NULL, NULL, 39.90, 'mensal', NULL, NULL, 1, 8, '2022-02-01 16:07:49', '2022-02-01 16:07:49');

-- Copiando estrutura para tabela i360.contacts
CREATE TABLE IF NOT EXISTS `contacts` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `document` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `clients` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ramais` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `contact` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `state` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `city` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `interest` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `msg` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Copiando dados para a tabela i360.contacts: ~9 rows (aproximadamente)
DELETE FROM `contacts`;
INSERT INTO `contacts` (`id`, `type`, `document`, `clients`, `ramais`, `contact`, `name`, `email`, `phone`, `state`, `city`, `interest`, `msg`, `created_at`, `updated_at`) VALUES
	(1, NULL, NULL, NULL, NULL, NULL, 'Eduardo Dornelles', 'eduardornelles@gmail.com', '(12) 32342.3434', 'RS', 'Sao Leopoldo', 'contact', 'Testasda sad sd', '2022-02-02 15:01:38', '2022-02-02 15:01:38'),
	(2, NULL, '234223423434', '3324', '234234', NULL, 'sdfsdfsdf', 'eduardornelles@gmail.com', '(23) 42342.34__', 'AP', 'sadfsfd', 'partner', NULL, '2022-02-02 15:08:59', '2022-02-02 15:08:59'),
	(3, NULL, '005.273.100-69', '234234', '234234', NULL, 'Usina RS', 'eduardornelles@gmail.com', '(23) 42342.34__', 'RS', 'Sao Leopoldo', 'partner', NULL, '2022-02-02 15:12:44', '2022-02-02 15:12:44'),
	(4, NULL, 'asdq2342342', '234234', '234234', NULL, 'asdasdasd', 'eduardornelles@gmail.com', '(23) 42342.3423', 'AC', '234234', 'affiliate', NULL, '2022-02-02 15:17:23', '2022-02-02 15:17:23'),
	(5, NULL, 'q234234', NULL, NULL, NULL, 'asdasdasdasd', 'eduardornelles@gmail.com', '(32) 42342.34__', NULL, NULL, 'change', 'asdasd asd as das da dasd asd', '2022-02-02 15:20:34', '2022-02-02 15:20:34'),
	(6, NULL, 'q234234', NULL, NULL, NULL, 'asdasdasdasd', 'eduardornelles@gmail.com', '(32) 42342.34__', NULL, NULL, 'change', 'asdasd asd as das da dasd asd', '2022-02-02 15:20:54', '2022-02-02 15:20:54'),
	(7, NULL, 'sd342534534', NULL, NULL, NULL, 'sedfsdf', 'eduardornelles@gmail.com', '(32) 42345.345_', NULL, NULL, 'cancel', 'asdasdas da as da dasd as dasd', '2022-02-02 15:23:28', '2022-02-02 15:23:28'),
	(8, NULL, NULL, NULL, NULL, NULL, 'Eduardo', 'eduardornelles@gmail.com', '(23) 42342.3423', 'RS', 'Sao Leopoldo', 'contact', 'Teste', '2022-02-18 14:28:58', '2022-02-18 14:28:58'),
	(9, NULL, NULL, NULL, NULL, NULL, 'Eduardo', 'eduardornelles@gmail.com', '(23) 42342.3423', 'RS', 'Sao Leopoldo', 'contact', 'Teste', '2022-02-18 14:32:46', '2022-02-18 14:32:46'),
	(10, NULL, NULL, NULL, NULL, NULL, 'Eduardo', 'eduardornelles@gmail.com', '(23) 42342.3423', 'RS', 'Sao Leopoldo', 'contact', 'Teste', '2022-02-18 14:33:22', '2022-02-18 14:33:22');

-- Copiando estrutura para tabela i360.dids
CREATE TABLE IF NOT EXISTS `dids` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `city` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `area_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `number` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `available` tinyint(1) NOT NULL DEFAULT '1',
  `reserved` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `reserved_until` timestamp NULL DEFAULT NULL,
  `user_id` int unsigned DEFAULT NULL,
  `order_id` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `dids_user_id_foreign` (`user_id`),
  KEY `dids_order_id_foreign` (`order_id`),
  CONSTRAINT `dids_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE,
  CONSTRAINT `dids_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Copiando dados para a tabela i360.dids: ~22 rows (aproximadamente)
DELETE FROM `dids`;
INSERT INTO `dids` (`id`, `type`, `city`, `area_code`, `number`, `available`, `reserved`, `reserved_until`, `user_id`, `order_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(3, '0800', NULL, NULL, '08004569955', 0, NULL, NULL, 95, NULL, '2021-09-29 13:03:41', '2022-03-10 13:39:22', NULL),
	(11, '800', NULL, NULL, '8007457457', 1, NULL, NULL, NULL, NULL, '2021-09-29 13:39:35', '2022-03-10 13:39:22', NULL),
	(15, 'roc', 'Salvador', '81', '98477384', 0, NULL, NULL, NULL, NULL, '2021-09-30 17:46:48', '2022-03-10 13:39:22', NULL),
	(34, '0800', NULL, NULL, '08007457456', 0, NULL, NULL, 97, NULL, '2021-09-30 17:46:48', '2022-03-10 13:39:22', NULL),
	(35, '0800', NULL, NULL, '08007457455', 0, NULL, NULL, 97, NULL, '2021-09-30 17:46:48', '2022-03-10 13:39:22', NULL),
	(36, '0800', NULL, NULL, '08007457454', 0, NULL, NULL, 118, NULL, '2021-09-30 17:46:48', '2022-03-10 13:39:22', NULL),
	(37, '0800', NULL, NULL, '08007457453', 0, NULL, NULL, 118, NULL, '2021-09-30 17:46:48', '2022-03-10 13:39:22', NULL),
	(38, '0800', NULL, NULL, '08007457452', 0, NULL, NULL, 122, NULL, '2021-09-30 17:46:48', '2022-03-10 13:39:22', NULL),
	(40, '0800', NULL, NULL, '08007457450', 0, NULL, NULL, 156, NULL, '2021-09-30 17:46:48', '2022-03-10 15:06:25', NULL),
	(41, '0800', NULL, NULL, '08007457449', 1, NULL, NULL, NULL, NULL, '2021-09-30 17:46:48', '2022-03-10 15:08:33', NULL),
	(42, '0800', NULL, NULL, '08007457448', 1, NULL, NULL, NULL, NULL, '2021-09-30 17:46:48', '2022-03-10 15:08:52', NULL),
	(43, '0800', NULL, NULL, '08007457447', 1, NULL, NULL, NULL, NULL, '2021-09-30 17:46:48', '2022-03-10 15:09:00', NULL),
	(44, '0800', NULL, NULL, '08007457446', 1, NULL, NULL, NULL, NULL, '2021-09-30 17:46:48', '2022-03-10 15:08:58', NULL),
	(49, 'roc', 'Salvador', '81', '25497855', 0, NULL, NULL, 147, NULL, NULL, '2022-03-10 13:39:22', NULL),
	(50, 'roc', 'Salvador', '81', '25497854', 0, NULL, NULL, 147, NULL, NULL, '2022-03-10 13:39:22', NULL),
	(53, 'roc', 'Curitiba', '33', '123123123', 0, NULL, NULL, 156, NULL, '2022-03-03 12:49:34', '2022-03-10 15:06:25', NULL),
	(55, 'roc', 'Salvador', '44', '33343433', 1, '2MgDWtqPTB5KYU77cxgENAUdcElIIgWAZqm', '2022-05-02 14:39:52', NULL, NULL, '2022-03-03 13:35:37', '2022-05-02 13:39:52', NULL),
	(56, 'roc', 'Salvador', '88', '23451323', 0, NULL, NULL, 156, NULL, '2022-03-03 13:35:48', '2022-03-10 15:06:25', NULL),
	(57, 'roc', 'Salvador', '87', '13470987', 1, 'WPGtCiFOwF48Cjm7CTZBj0zs1xw6KjZBMrY', '2022-03-28 15:07:20', NULL, NULL, '2022-03-03 13:36:03', '2022-03-28 14:07:20', NULL),
	(58, 'roc', 'Salvador', '44', '33343438', 0, NULL, NULL, 156, NULL, '2022-03-03 13:35:37', '2022-03-10 15:06:25', NULL),
	(59, 'roc', 'Salvador', '44', '33543438', 1, 'WPGtCiFOwF48Cjm7CTZBj0zs1xw6KjZBMrY', '2022-03-28 15:07:25', NULL, NULL, '2022-03-03 13:35:37', '2022-03-28 14:07:25', NULL),
	(60, 'roc', 'Salvador', '87', '13470944', 1, NULL, NULL, NULL, NULL, '2022-03-03 13:36:03', '2022-05-02 13:38:21', NULL);

-- Copiando estrutura para tabela i360.downloads
CREATE TABLE IF NOT EXISTS `downloads` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `category_id` int unsigned DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `file` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `downloads_category_id_foreign` (`category_id`),
  CONSTRAINT `downloads_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `download_categories` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Copiando dados para a tabela i360.downloads: ~0 rows (aproximadamente)
DELETE FROM `downloads`;

-- Copiando estrutura para tabela i360.download_categories
CREATE TABLE IF NOT EXISTS `download_categories` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Copiando dados para a tabela i360.download_categories: ~0 rows (aproximadamente)
DELETE FROM `download_categories`;

-- Copiando estrutura para tabela i360.faqs
CREATE TABLE IF NOT EXISTS `faqs` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `faq_model` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `model_id` int unsigned NOT NULL,
  `question` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `answer` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `order` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Copiando dados para a tabela i360.faqs: ~2 rows (aproximadamente)
DELETE FROM `faqs`;
INSERT INTO `faqs` (`id`, `faq_model`, `model_id`, `question`, `answer`, `active`, `order`, `created_at`, `updated_at`) VALUES
	(1, 'App\\Models\\Abouts', 2, 'Ipsum asdf sd sd f1222', '<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. 333</p>', 1, 1, '2021-09-29 16:23:01', '2022-01-27 11:55:17'),
	(2, 'App\\Models\\Abouts', 2, 'amet', '<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat.</p>', 1, 2, '2021-09-29 16:23:13', '2021-09-29 16:23:13');

-- Copiando estrutura para tabela i360.history
CREATE TABLE IF NOT EXISTS `history` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `model` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `model_id` int unsigned NOT NULL,
  `data` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Copiando dados para a tabela i360.history: ~17 rows (aproximadamente)
DELETE FROM `history`;
INSERT INTO `history` (`id`, `model`, `model_id`, `data`, `created_at`, `updated_at`) VALUES
	(5, 'App\\Domains\\Orders\\Models\\Order', 26, '{"origin":"Notifica\\u00e7\\u00e3o PagSeguro","user_id":29,"status_id":1,"status_title":"Aguardando Pagamento","total":149.9,"observation":null}', '2021-09-30 16:53:55', '2021-09-30 16:53:55'),
	(6, 'App\\Domains\\Orders\\Models\\Order', 31, '{"origin":"Notifica\\u00e7\\u00e3o PagSeguro","user_id":36,"status_id":1,"status_title":"Aguardando Pagamento","total":149.9,"observation":null}', '2021-09-30 17:09:18', '2021-09-30 17:09:18'),
	(8, 'App\\Domains\\Orders\\Models\\Order', 33, '{"origin":"Escape","user_id":38,"status_id":1,"status_title":"Aguardando Pagamento","total":149.9,"observation":null}', '2021-09-30 19:19:52', '2021-09-30 19:19:52'),
	(9, 'App\\Domains\\Orders\\Models\\Order', 34, '{"origin":"Escape","user_id":39,"status_id":1,"status_title":"Aguardando Pagamento","total":149.9,"observation":null}', '2021-09-30 19:41:21', '2021-09-30 19:41:21'),
	(10, 'App\\Domains\\Orders\\Models\\Order', 35, '{"origin":"Notifica\\u00e7\\u00e3o PagSeguro","user_id":40,"status_id":1,"status_title":"Aguardando Pagamento","total":149.9,"observation":null}', '2021-10-01 00:02:47', '2021-10-01 00:02:47'),
	(18, 'App\\Domains\\Orders\\Models\\Order', 79, '{"origin":"Notifica\\u00e7\\u00e3o PagSeguro","user_id":84,"status_id":1,"status_title":"Aguardando Pagamento","total":786.6999999999999,"observation":null}', '2022-02-02 13:47:50', '2022-02-02 13:47:50'),
	(20, 'App\\Domains\\Orders\\Models\\Order', 81, '{"origin":"Notifica\\u00e7\\u00e3o PagSeguro","user_id":86,"status_id":1,"status_title":"Aguardando Pagamento","total":149,"observation":null}', '2022-02-02 14:05:07', '2022-02-02 14:05:07'),
	(22, 'App\\Domains\\Orders\\Models\\Order', 83, '{"origin":"Notifica\\u00e7\\u00e3o PagSeguro","user_id":88,"status_id":1,"status_title":"Aguardando Pagamento","total":487.7,"observation":null}', '2022-02-02 14:16:15', '2022-02-02 14:16:15'),
	(23, 'App\\Domains\\Orders\\Models\\Order', 84, '{"origin":"Notifica\\u00e7\\u00e3o PagSeguro","user_id":89,"status_id":1,"status_title":"Aguardando Pagamento","total":453.6,"observation":null}', '2022-02-02 14:21:41', '2022-02-02 14:21:41'),
	(27, 'App\\Domains\\Orders\\Models\\Order', 90, '{"origin":"Escape","user_id":95,"status_id":1,"status_title":"Aguardando Pagamento","total":457.9,"observation":null}', '2022-02-02 15:55:56', '2022-02-02 15:55:56'),
	(28, 'App\\Domains\\Orders\\Models\\Order', 92, '{"origin":"Escape","user_id":97,"status_id":1,"status_title":"Aguardando Pagamento","total":1096.3000000000002,"observation":null}', '2022-02-03 12:38:23', '2022-02-03 12:38:23'),
	(32, 'App\\Domains\\Orders\\Models\\Order', 92, '{"origin":"Escape","user_id":97,"status_id":2,"status_title":"Confirmado","total":1096.3,"observation":null}', '2022-02-07 13:13:42', '2022-02-07 13:13:42'),
	(36, 'App\\Domains\\Orders\\Models\\Order', 113, '{"origin":"Notifica\\u00e7\\u00e3o PagSeguro","user_id":118,"status_id":1,"status_title":"Aguardando Pagamento","total":747,"observation":null}', '2022-02-14 14:09:56', '2022-02-14 14:09:56'),
	(39, 'App\\Domains\\Orders\\Models\\Order', 116, '{"origin":"Notifica\\u00e7\\u00e3o PagSeguro","user_id":121,"status_id":1,"status_title":"Aguardando Pagamento","total":299.8,"observation":null}', '2022-02-14 14:21:51', '2022-02-14 14:21:51'),
	(40, 'App\\Domains\\Orders\\Models\\Order', 116, '{"origin":"Escape","user_id":121,"status_id":2,"status_title":"Confirmado","total":299.8,"observation":null}', '2022-02-16 15:25:56', '2022-02-16 15:25:56'),
	(41, 'App\\Domains\\Orders\\Models\\Order', 116, '{"origin":"Escape","user_id":121,"status_id":5,"status_title":"Pedido Cancelado","total":299.8,"observation":null}', '2022-02-16 15:26:10', '2022-02-16 15:26:10'),
	(42, 'App\\Domains\\Orders\\Models\\Order', 117, '{"origin":"Escape","user_id":122,"status_id":1,"status_title":"Aguardando Pagamento","total":278.9,"observation":null}', '2022-02-16 15:34:59', '2022-02-16 15:34:59'),
	(43, 'App\\Domains\\Orders\\Models\\Order', 117, '{"origin":"Escape","user_id":122,"status_id":5,"status_title":"Pedido Cancelado","total":278.9,"observation":null}', '2022-02-16 15:38:15', '2022-02-16 15:38:15'),
	(44, 'App\\Domains\\Orders\\Models\\Order', 118, '{"origin":"Escape","user_id":123,"status_id":1,"status_title":"Aguardando Pagamento","total":448.9,"observation":null}', '2022-02-16 15:41:37', '2022-02-16 15:41:37'),
	(45, 'App\\Domains\\Orders\\Models\\Order', 118, '{"origin":"Escape","user_id":123,"status_id":5,"status_title":"Pedido Cancelado","total":448.9,"observation":null}', '2022-02-16 15:43:58', '2022-02-16 15:43:58'),
	(46, 'App\\Domains\\Orders\\Models\\Order', 142, '{"origin":"Notifica\\u00e7\\u00e3o PagSeguro","user_id":147,"status_id":1,"status_title":"Aguardando Pagamento","total":149.9,"observation":null}', '2022-02-21 14:28:56', '2022-02-21 14:28:56'),
	(47, 'App\\Domains\\Orders\\Models\\Order', 143, '{"origin":"Notifica\\u00e7\\u00e3o PagSeguro","user_id":148,"status_id":1,"status_title":"Aguardando Pagamento","total":189.8,"observation":null}', '2022-02-25 11:37:19', '2022-02-25 11:37:19'),
	(48, 'App\\Domains\\Orders\\Models\\Order', 143, '{"origin":"Escape","user_id":148,"status_id":2,"status_title":"Confirmado\\/Pago","total":189.8,"observation":null}', '2022-02-25 11:40:20', '2022-02-25 11:40:20'),
	(49, 'App\\Domains\\Orders\\Models\\Order', 143, '{"origin":"Escape","user_id":148,"status_id":5,"status_title":"Pedido Cancelado","total":189.8,"observation":null}', '2022-02-25 11:41:24', '2022-02-25 11:41:24'),
	(50, 'App\\Domains\\Orders\\Models\\Order', 151, '{"origin":"Notifica\\u00e7\\u00e3o PagSeguro","user_id":156,"status_id":1,"status_title":"Aguardando Pagamento","total":588.6,"observation":null}', '2022-03-10 14:51:38', '2022-03-10 14:51:38');

-- Copiando estrutura para tabela i360.laramedias
CREATE TABLE IF NOT EXISTS `laramedias` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `media_model` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `model_id` int unsigned NOT NULL,
  `file` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `caption` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `credits` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `crop_position` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT 'center',
  `order` int DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Copiando dados para a tabela i360.laramedias: ~4 rows (aproximadamente)
DELETE FROM `laramedias`;
INSERT INTO `laramedias` (`id`, `media_model`, `model_id`, `file`, `caption`, `credits`, `crop_position`, `order`, `active`, `created_at`, `updated_at`) VALUES
	(1, 'App\\Models\\Abouts', 1, 'fh5-biome-canyon-01-16x9-wm.jpg', NULL, NULL, 'center', 1, 1, '2021-09-29 11:52:03', '2021-09-29 11:52:03'),
	(2, 'App\\Models\\Abouts', 1, 'fh5-biome-living-desert-02-16x9-wm.jpg', NULL, NULL, 'center', 2, 1, '2021-09-29 11:52:03', '2021-09-29 11:52:03'),
	(3, 'App\\Models\\Abouts', 1, 'fh5-biome-swamp-02-16x9-wm.jpg', NULL, NULL, 'center', 3, 1, '2021-09-29 11:52:03', '2021-09-29 11:52:03'),
	(4, 'App\\Models\\Abouts', 1, 'fh5-biome-tropical-coast-02-16x9-wm.jpg', NULL, NULL, 'center', 4, 1, '2021-09-29 11:52:03', '2021-09-29 11:52:03');

-- Copiando estrutura para tabela i360.manager_roles
CREATE TABLE IF NOT EXISTS `manager_roles` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `all_permissions` tinyint(1) NOT NULL DEFAULT '0',
  `admin` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Copiando dados para a tabela i360.manager_roles: ~2 rows (aproximadamente)
DELETE FROM `manager_roles`;
INSERT INTO `manager_roles` (`id`, `title`, `all_permissions`, `admin`, `created_at`, `updated_at`) VALUES
	(1, 'NSA', 1, 1, '2021-09-21 11:49:52', '2021-09-21 11:49:52'),
	(2, 'Administrador', 1, 0, '2021-09-21 11:49:52', '2021-09-21 11:49:52');

-- Copiando estrutura para tabela i360.manager_role_actions
CREATE TABLE IF NOT EXISTS `manager_role_actions` (
  `role_id` int unsigned NOT NULL,
  `page` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `action` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  KEY `manager_role_actions_role_id_foreign` (`role_id`),
  CONSTRAINT `manager_role_actions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `manager_roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Copiando dados para a tabela i360.manager_role_actions: ~0 rows (aproximadamente)
DELETE FROM `manager_role_actions`;

-- Copiando estrutura para tabela i360.manager_role_pages
CREATE TABLE IF NOT EXISTS `manager_role_pages` (
  `role_id` int unsigned NOT NULL,
  `page` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  KEY `manager_role_pages_role_id_foreign` (`role_id`),
  CONSTRAINT `manager_role_pages_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `manager_roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Copiando dados para a tabela i360.manager_role_pages: ~0 rows (aproximadamente)
DELETE FROM `manager_role_pages`;

-- Copiando estrutura para tabela i360.migrations
CREATE TABLE IF NOT EXISTS `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=64 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Copiando dados para a tabela i360.migrations: ~50 rows (aproximadamente)
DELETE FROM `migrations`;
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(1, '2013_02_06_203421_create_manager_users_table', 1),
	(2, '2013_05_06_120258_create_manager_roles_table', 1),
	(3, '2013_06_16_200640_add_foreign_keys_to_users_table', 1),
	(4, '2014_10_12_100000_create_manager_password_resets_table', 1),
	(5, '2015_02_14_161455_create_manager_media_table', 1),
	(6, '2015_05_11_164229_manager_role_pages', 1),
	(7, '2015_11_05_094307_add_crop_position_to_manager_medias_table', 1),
	(8, '2016_01_06_132322_create_first_roles_records', 1),
	(9, '2017_05_25_091829_create_manager_role_actions_table', 1),
	(10, '2018_05_16_090950_create_subscribers_table', 1),
	(11, '2018_05_16_091316_create_regions_table', 1),
	(12, '2018_05_16_112552_create_table_sections', 1),
	(13, '2018_05_16_121013_create_downloads_table', 1),
	(14, '2018_11_26_140429_create_manager_configuration_table', 1),
	(15, '2020_02_26_131521_create_vacantjobs_table', 1),
	(16, '2020_02_26_131522_create_applications_table', 1),
	(17, '2020_03_03_084730_create_faq', 1),
	(18, '2020_03_16_084730_create_benefits', 1),
	(19, '2020_11_11_093645_create_contacts_table', 1),
	(20, '2020_12_16_100035_create_banners_table', 1),
	(21, '2020_12_16_100958_create_abouts_table', 1),
	(22, '2020_12_16_100958_create_awards_table', 1),
	(23, '2021_03_09_134614_create_news_categories_table', 1),
	(24, '2021_03_09_134614_create_news_table', 1),
	(25, '2021_04_19_095632_create_infos_table', 1),
	(26, '2021_04_19_102852_create_services_table', 1),
	(29, '2021_04_22_085425_alter_table_news_add_folder', 1),
	(31, '2021_04_22_085426_alter_table_services', 1),
	(32, '2021_04_26_135705_create_testimonials_table', 1),
	(33, '2017_02_16_171108_create_users_table', 2),
	(34, '2021_09_24_092531_create_dids_table', 2),
	(35, '2021_09_29_085312_create_partners_table', 3),
	(36, '2021_04_19_111150_create_categories_table', 4),
	(37, '2021_04_19_112003_create_table_service_categories', 4),
	(38, '2021_09_29_140405_add_value_to_services', 5),
	(39, '2017_02_16_171109_create_orders_table', 6),
	(40, '2017_03_02_163505_create_status_table', 6),
	(41, '2017_03_02_164007_add_status_id_field_to_orders_table', 6),
	(42, '2017_03_03_164738_create_history_table', 6),
	(43, '2017_03_06_104103_create_user_addresses_table', 6),
	(44, '2017_03_22_135942_add_delivery_fields_to_orders_table', 6),
	(45, '2017_06_08_084405_create_payments_tables', 6),
	(46, '2017_06_08_160944_add_new_fields_to_payments_table', 6),
	(47, '2017_06_16_132425_add_extra_fields_to_payments_table', 6),
	(48, '2017_12_08_132638_alter_orders_table', 6),
	(49, '2018_11_13_135509_create_order_delivery_table', 6),
	(50, '2018_11_13_153606_alter_table_orders_add_type', 6),
	(51, '2018_11_14_090055_create_new_status', 6),
	(52, '2019_03_17_210137_alter_table_orders_add_transaction_code', 6),
	(53, '2021_09_30_153647_create_data_table', 7),
	(54, '2021_09_29_140406_add_value_ramal_to_services', 8),
	(55, '2022_01_27_095632_create_new_infos', 9),
	(56, '2022_01_28_095632_create_new_infos_ipabx', 10),
	(57, '2022_01_28_100405_add_company_to_users', 11),
	(58, '2022_01_30_100405_add_city_to_dids', 12),
	(59, '2022_01_31_100405_add_value_to_categories', 13),
	(60, '2022_02_02_100405_add_data_contact', 14),
	(61, '2022_02_02_100406_add_more_info_to_categories', 15),
	(62, '2022_02_02_180406_add_model_to_benefits', 16),
	(63, '2022_03_10_091507_alter_table_dids_add_key', 17);

-- Copiando estrutura para tabela i360.news
CREATE TABLE IF NOT EXISTS `news` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `news_category_id` int unsigned DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `subtitle` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `slug` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `picture` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `folder` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `date` date NOT NULL,
  `content` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `news_slug_unique` (`slug`),
  KEY `news_news_category_id_foreign` (`news_category_id`),
  CONSTRAINT `news_news_category_id_foreign` FOREIGN KEY (`news_category_id`) REFERENCES `news_categories` (`id`) ON DELETE SET NULL ON UPDATE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Copiando dados para a tabela i360.news: ~2 rows (aproximadamente)
DELETE FROM `news`;
INSERT INTO `news` (`id`, `news_category_id`, `title`, `subtitle`, `slug`, `picture`, `folder`, `date`, `content`, `active`, `created_at`, `updated_at`) VALUES
	(1, 1, 'Startup brasileira inova com lançamento de solução de PABX Virtual.', NULL, 'startup-brasileira-inova-com-lancamento-de-solucao-de-pabx-virtual', '04.png', '6rgvg6rTMARFp6n.jpg', '2021-09-29', '<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut w&aacute;si enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi.</p>\r\n\r\n<p>Lorem ipsum dolor sit amet, cons ectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi.</p>\r\n\r\n<p>Lorem ipsum dolor sit amet, cons ectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat.</p>', 1, '2021-09-29 12:12:43', '2021-09-29 12:27:16'),
	(2, 1, 'Segunda noticia', NULL, 'segunda-noticia', '05.png', 'oslVcG03DidGkzf.jpg', '2021-09-21', '<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi.</p>\r\n\r\n<p>Lorem ipsum dolor sit amet, cons ectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi.</p>\r\n\r\n<p>Lorem ipsum dolor sit amet, cons ectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat.</p>', 1, '2021-09-29 12:14:03', '2021-09-29 12:14:05');

-- Copiando estrutura para tabela i360.news_categories
CREATE TABLE IF NOT EXISTS `news_categories` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `news_categories_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Copiando dados para a tabela i360.news_categories: ~2 rows (aproximadamente)
DELETE FROM `news_categories`;
INSERT INTO `news_categories` (`id`, `title`, `slug`, `description`, `active`, `created_at`, `updated_at`) VALUES
	(1, 'Notícias', 'noticias', NULL, 1, '2021-09-29 12:11:23', '2021-09-29 12:11:23'),
	(2, 'Artigos', 'artigos', NULL, 1, '2021-09-29 12:11:36', '2021-09-29 12:11:36');

-- Copiando estrutura para tabela i360.orders
CREATE TABLE IF NOT EXISTS `orders` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `user_id` int unsigned NOT NULL,
  `address_id` int unsigned DEFAULT NULL,
  `max_extension` int DEFAULT NULL,
  `total` double(8,2) DEFAULT NULL,
  `type` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT 'payment',
  `observation` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `status_id` int unsigned NOT NULL DEFAULT '1',
  `status_pagseguro` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `transaction_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `finalized_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `orders_user_id_foreign` (`user_id`),
  KEY `orders_status_id_foreign` (`status_id`),
  KEY `orders_address_id_foreign` (`address_id`),
  CONSTRAINT `orders_address_id_foreign` FOREIGN KEY (`address_id`) REFERENCES `user_addresses` (`id`),
  CONSTRAINT `orders_status_id_foreign` FOREIGN KEY (`status_id`) REFERENCES `status` (`id`),
  CONSTRAINT `orders_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=152 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Copiando dados para a tabela i360.orders: ~17 rows (aproximadamente)
DELETE FROM `orders`;
INSERT INTO `orders` (`id`, `code`, `user_id`, `address_id`, `max_extension`, `total`, `type`, `observation`, `status_id`, `status_pagseguro`, `transaction_code`, `finalized_at`, `created_at`, `updated_at`) VALUES
	(26, NULL, 29, 27, NULL, 149.90, NULL, NULL, 1, NULL, '17CE335A-7001-49ED-96DD-F0204DF7A314', NULL, '2021-09-30 16:53:52', '2021-09-30 16:53:55'),
	(31, 'iFroE4-HIOWkB-BTkZsw', 36, 34, NULL, 149.90, NULL, NULL, 1, NULL, '46E0D977-CDDA-4E14-B75D-9C3F4E49749C', NULL, '2021-09-30 17:09:14', '2021-09-30 17:09:18'),
	(33, '7coB6P-1G4QD4-IHMzym', 38, 36, NULL, 149.90, NULL, NULL, 1, NULL, 'F0D98970-913B-4819-8BF8-F5A82CBB3134', NULL, '2021-09-30 19:19:49', '2021-09-30 19:19:52'),
	(34, 'otgFl4-LBo6aL-jVbG3p', 39, 37, NULL, 149.90, NULL, NULL, 1, NULL, '91A35FB0-C19F-4ECC-A536-5D129CA6106C', NULL, '2021-09-30 19:41:18', '2021-09-30 19:41:21'),
	(35, 'awl8SJ-AVVdBp-tuQV2c', 40, 38, NULL, 149.90, NULL, NULL, 1, NULL, '06D5EDBC-C9BA-4543-9202-79D0CECA49A0', NULL, '2021-10-01 00:02:45', '2021-10-01 00:02:47'),
	(79, 'KFINdQ-8wcTvX-EoMg7r', 84, 82, NULL, 786.70, NULL, NULL, 1, NULL, 'A842BC73-30B8-4F52-9544-6550F6F47A53', NULL, '2022-02-02 13:47:47', '2022-02-02 13:47:50'),
	(81, 'BuR3FK-OZEaFl-hSPCTh', 86, 84, NULL, 149.00, NULL, NULL, 1, NULL, '107C78C4-9EC7-448D-9827-5317D66B451A', NULL, '2022-02-02 14:05:02', '2022-02-02 14:05:07'),
	(83, 'ByeOYu-PNpXZj-Wa3zBa', 88, 86, NULL, 487.70, NULL, NULL, 1, NULL, 'E59F594C-754C-4B8E-B47E-3F554CEB0A70', NULL, '2022-02-02 14:16:10', '2022-02-02 14:16:15'),
	(90, 'Z1XEWM-kaNLFK-pjJv7i', 95, 93, NULL, 457.90, NULL, NULL, 1, NULL, '7EB3FB2E-8C96-41AD-B09B-756AFA71C7C8', NULL, '2022-02-02 15:55:53', '2022-02-02 15:55:56'),
	(92, 'MlN1Pg-OOrskF-liZw3h', 97, 95, NULL, 1096.30, NULL, NULL, 2, NULL, '6B42A651-01CA-4C7B-92B9-97B5DAED9F0F', '2022-02-07 13:13:42', '2022-02-03 12:38:19', '2022-02-07 13:13:42'),
	(113, 'UALKsV-IXQWej-4gMOKp', 118, 116, NULL, 747.00, NULL, NULL, 1, NULL, 'E0857D92-F5F0-4D89-8108-48E24AC19C21', NULL, '2022-02-14 14:09:52', '2022-02-14 14:09:56'),
	(116, '7iFDFn-Dpj2xa-PjYq7b', 121, 119, NULL, 299.80, NULL, NULL, 5, NULL, 'E297D29F-246E-43C5-87A0-03BB8205EC74', '2022-02-16 15:25:56', '2022-02-14 14:21:46', '2022-02-16 15:26:10'),
	(117, 'u6QCFH-2YA8oT-omWuh5', 122, 120, NULL, 278.90, NULL, NULL, 5, NULL, '8DF31D28-C0C5-4B00-A8F0-5DDBC837BB28', NULL, '2022-02-16 15:34:55', '2022-02-16 15:38:15'),
	(118, '8VmD4S-zbLnnp-GOcV92', 123, 121, NULL, 448.90, NULL, NULL, 2, NULL, 'C4DF6E86-E514-49B3-9AA2-70AED5877FED', NULL, '2022-02-16 15:41:33', '2022-02-16 15:43:58'),
	(142, 'Xfq8JZ-kCRIow-hFrumy', 147, 145, NULL, 149.90, NULL, NULL, 1, NULL, 'F87BECFB-20B1-48AC-B2E9-21FC28BA9ED5', NULL, '2022-02-21 14:28:48', '2022-02-21 14:28:56'),
	(143, 'to1mz4-eV078r-Zr4Tqf', 148, 146, NULL, 189.80, NULL, NULL, 5, NULL, 'EEF91E74-3B57-4E15-80F1-E16E557A2CE4', '2022-02-25 11:40:20', '2022-02-25 11:37:10', '2022-02-25 11:41:24'),
	(151, 'FCPgRd-a0RPsH-gL84VS', 156, 154, NULL, 588.60, NULL, NULL, 1, NULL, '06386882-E4D0-48F6-8058-3478E2B58B09', NULL, '2022-03-10 14:51:24', '2022-03-10 14:51:38');

-- Copiando estrutura para tabela i360.order_delivery
CREATE TABLE IF NOT EXISTS `order_delivery` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `order_id` int unsigned NOT NULL,
  `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `price` double(8,2) DEFAULT NULL,
  `deadline` int unsigned NOT NULL,
  `free` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `order_delivery_order_id_foreign` (`order_id`),
  CONSTRAINT `order_delivery_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=91 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Copiando dados para a tabela i360.order_delivery: ~12 rows (aproximadamente)
DELETE FROM `order_delivery`;
INSERT INTO `order_delivery` (`id`, `order_id`, `type`, `price`, `deadline`, `free`, `created_at`, `updated_at`) VALUES
	(31, 79, 'withdraw', 0.00, 0, 1, '2022-02-02 13:47:47', '2022-02-02 13:47:47'),
	(33, 81, 'withdraw', 0.00, 0, 1, '2022-02-02 14:05:02', '2022-02-02 14:05:02'),
	(35, 83, 'withdraw', 0.00, 0, 1, '2022-02-02 14:16:10', '2022-02-02 14:16:10'),
	(42, 90, 'withdraw', 0.00, 0, 1, '2022-02-02 15:55:53', '2022-02-02 15:55:53'),
	(43, 92, 'withdraw', 0.00, 0, 1, '2022-02-03 12:38:19', '2022-02-03 12:38:19'),
	(52, 113, 'withdraw', 0.00, 0, 1, '2022-02-14 14:09:52', '2022-02-14 14:09:52'),
	(55, 116, 'withdraw', 0.00, 0, 1, '2022-02-14 14:21:46', '2022-02-14 14:21:46'),
	(56, 117, 'withdraw', 0.00, 0, 1, '2022-02-16 15:34:55', '2022-02-16 15:34:55'),
	(57, 118, 'withdraw', 0.00, 0, 1, '2022-02-16 15:41:33', '2022-02-16 15:41:33'),
	(81, 142, 'withdraw', 0.00, 0, 1, '2022-02-21 14:28:48', '2022-02-21 14:28:48'),
	(82, 143, 'withdraw', 0.00, 0, 1, '2022-02-25 11:37:10', '2022-02-25 11:37:10'),
	(90, 151, 'withdraw', 0.00, 0, 1, '2022-03-10 14:51:24', '2022-03-10 14:51:24');

-- Copiando estrutura para tabela i360.order_items
CREATE TABLE IF NOT EXISTS `order_items` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `order_id` int unsigned NOT NULL,
  `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT '',
  `quantity` int NOT NULL DEFAULT '1',
  `price` double(8,2) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `order_items_order_id_foreign` (`order_id`),
  CONSTRAINT `order_items_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=577 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Copiando dados para a tabela i360.order_items: ~51 rows (aproximadamente)
DELETE FROM `order_items`;
INSERT INTO `order_items` (`id`, `order_id`, `description`, `quantity`, `price`, `created_at`, `updated_at`) VALUES
	(23, 26, '1', 1, 149.90, '2021-09-30 16:53:52', '2021-09-30 16:53:52'),
	(28, 31, 'Plano Receive', 1, 149.90, '2021-09-30 17:09:14', '2021-09-30 17:09:14'),
	(30, 33, 'Plano Receive', 1, 149.90, '2021-09-30 19:19:49', '2021-09-30 19:19:49'),
	(31, 34, 'Plano Receive', 1, 149.90, '2021-09-30 19:41:18', '2021-09-30 19:41:18'),
	(32, 35, 'Plano Receive', 1, 149.90, '2021-10-01 00:02:45', '2021-10-01 00:02:45'),
	(317, 79, 'Plano Receive', 1, 149.00, '2022-02-02 13:47:47', '2022-02-02 13:47:47'),
	(318, 79, 'Número POP Incluso', 1, 0.00, '2022-02-02 13:47:47', '2022-02-02 13:47:47'),
	(319, 79, 'Número POP Adicional', 1, 14.90, '2022-02-02 13:47:47', '2022-02-02 13:47:47'),
	(320, 79, '0800 - 0800 MACRO', 2, 299.00, '2022-02-02 13:47:47', '2022-02-02 13:47:47'),
	(321, 79, 'Gravação URA', 1, 14.90, '2022-02-02 13:47:47', '2022-02-02 13:47:47'),
	(322, 79, 'Cloud 100GB', 1, 9.90, '2022-02-02 13:47:47', '2022-02-02 13:47:47'),
	(329, 81, 'Plano Receive', 1, 149.00, '2022-02-02 14:05:02', '2022-02-02 14:05:02'),
	(330, 81, 'Número POP Incluso', 1, 0.00, '2022-02-02 14:05:02', '2022-02-02 14:05:02'),
	(331, 81, 'Número POP Adicional', -1, 0.00, '2022-02-02 14:05:02', '2022-02-02 14:05:02'),
	(338, 83, 'Plano Receive', 1, 149.00, '2022-02-02 14:16:10', '2022-02-02 14:16:10'),
	(339, 83, 'Número POP Incluso', 1, 0.00, '2022-02-02 14:16:10', '2022-02-02 14:16:10'),
	(340, 83, 'Número POP Adicional', 1, 14.90, '2022-02-02 14:16:10', '2022-02-02 14:16:10'),
	(341, 83, '0800 - 0800 MACRO', 1, 299.00, '2022-02-02 14:16:10', '2022-02-02 14:16:10'),
	(342, 83, 'Gravação URA', 1, 14.90, '2022-02-02 14:16:10', '2022-02-02 14:16:10'),
	(343, 83, 'Cloud 100GB', 1, 9.90, '2022-02-02 14:16:10', '2022-02-02 14:16:10'),
	(375, 90, 'Plano Receive', 1, 149.00, '2022-02-02 15:55:53', '2022-02-02 15:55:53'),
	(376, 90, 'Número POP Incluso', 1, 0.00, '2022-02-02 15:55:53', '2022-02-02 15:55:53'),
	(377, 90, 'Número POP Adicional', -1, 0.00, '2022-02-02 15:55:53', '2022-02-02 15:55:53'),
	(378, 90, '0800 - 0800 MACRO', 1, 299.00, '2022-02-02 15:55:53', '2022-02-02 15:55:53'),
	(379, 90, 'Cloud 100GB', 1, 9.90, '2022-02-02 15:55:53', '2022-02-02 15:55:53'),
	(389, 92, 'Plano Receive', 1, 149.00, '2022-02-03 12:38:19', '2022-02-03 12:38:19'),
	(390, 92, 'Número POP Incluso', 1, 0.00, '2022-02-03 12:38:19', '2022-02-03 12:38:19'),
	(391, 92, 'Número POP Adicional', 2, 14.90, '2022-02-03 12:38:19', '2022-02-03 12:38:19'),
	(392, 92, 'Número ROC Rio de Janeiro', 1, 14.90, '2022-02-03 12:38:19', '2022-02-03 12:38:19'),
	(393, 92, '0800 - 0800 MACRO', 2, 299.00, '2022-02-03 12:38:19', '2022-02-03 12:38:19'),
	(394, 92, 'Gravação URA', 1, 14.90, '2022-02-03 12:38:19', '2022-02-03 12:38:19'),
	(395, 92, 'Cloud 100GB', 1, 9.90, '2022-02-03 12:38:19', '2022-02-03 12:38:19'),
	(396, 92, 'Suporte Técnico', 1, 200.00, '2022-02-03 12:38:19', '2022-02-03 12:38:19'),
	(397, 92, 'Ramal Adicional', 2, 39.90, '2022-02-03 12:38:19', '2022-02-03 12:38:19'),
	(468, 113, 'Plano Receive', 1, 149.00, '2022-02-14 14:09:52', '2022-02-14 14:09:52'),
	(469, 113, 'Números Virtuais Inclusos', 5, 0.00, '2022-02-14 14:09:52', '2022-02-14 14:09:52'),
	(470, 113, '0800 - 0800 MACRO', 2, 299.00, '2022-02-14 14:09:52', '2022-02-14 14:09:52'),
	(477, 116, 'Plano Voice', 1, 149.90, '2022-02-14 14:21:46', '2022-02-14 14:21:46'),
	(478, 116, 'Números Virtuais Inclusos', 1, 0.00, '2022-02-14 14:21:46', '2022-02-14 14:21:46'),
	(479, 116, 'Números Virtuais Adicionais', 1, 149.90, '2022-02-14 14:21:46', '2022-02-14 14:21:46'),
	(480, 117, 'Plano Voice', 1, 149.90, '2022-02-16 15:34:55', '2022-02-16 15:34:55'),
	(481, 117, 'Números Virtuais Inclusos', 1, 0.00, '2022-02-16 15:34:55', '2022-02-16 15:34:55'),
	(482, 117, '0800 - 0800 SMARTVOICE', 1, 129.00, '2022-02-16 15:34:55', '2022-02-16 15:34:55'),
	(483, 118, 'Plano Voice', 1, 149.90, '2022-02-16 15:41:33', '2022-02-16 15:41:33'),
	(484, 118, 'Números Virtuais Inclusos', 1, 0.00, '2022-02-16 15:41:33', '2022-02-16 15:41:33'),
	(485, 118, '0800 - 0800 MACRO', 1, 299.00, '2022-02-16 15:41:33', '2022-02-16 15:41:33'),
	(532, 142, 'Plano Voice', 1, 149.90, '2022-02-21 14:28:48', '2022-02-21 14:28:48'),
	(533, 142, 'Números Virtuais Inclusos', 1, 0.00, '2022-02-21 14:28:48', '2022-02-21 14:28:48'),
	(534, 143, 'Plano Voice', 1, 149.90, '2022-02-25 11:37:10', '2022-02-25 11:37:10'),
	(535, 143, 'Números Virtuais Inclusos', 1, 0.00, '2022-02-25 11:37:10', '2022-02-25 11:37:10'),
	(536, 143, 'Ramal Adicional', 1, 39.90, '2022-02-25 11:37:10', '2022-02-25 11:37:10'),
	(572, 151, 'Plano Voice', 1, 149.90, '2022-03-10 14:51:24', '2022-03-10 14:51:24'),
	(573, 151, 'Números Virtuais Inclusos', 1, 0.00, '2022-03-10 14:51:24', '2022-03-10 14:51:24'),
	(574, 151, 'Números Virtuais Adicionais', 2, 149.90, '2022-03-10 14:51:24', '2022-03-10 14:51:24'),
	(575, 151, '0800 - 0800 SMARTVOICE', 1, 129.00, '2022-03-10 14:51:24', '2022-03-10 14:51:24'),
	(576, 151, 'Cloud 100GB', 1, 9.90, '2022-03-10 14:51:24', '2022-03-10 14:51:24');

-- Copiando estrutura para tabela i360.partners
CREATE TABLE IF NOT EXISTS `partners` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `link` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `picture` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `order` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Copiando dados para a tabela i360.partners: ~0 rows (aproximadamente)
DELETE FROM `partners`;
INSERT INTO `partners` (`id`, `name`, `link`, `picture`, `order`, `created_at`, `updated_at`) VALUES
	(1, 'Teste', NULL, '61043fe150cf2-image001.jpg', 1, '2021-09-29 11:55:47', '2021-09-29 11:55:47');

-- Copiando estrutura para tabela i360.payments
CREATE TABLE IF NOT EXISTS `payments` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `model` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `model_id` int unsigned NOT NULL,
  `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `code` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `price` double(8,2) DEFAULT NULL,
  `installments` int DEFAULT NULL,
  `card_first6` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `card_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `extra` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Copiando dados para a tabela i360.payments: ~13 rows (aproximadamente)
DELETE FROM `payments`;
INSERT INTO `payments` (`id`, `model`, `model_id`, `type`, `code`, `price`, `installments`, `card_first6`, `card_type`, `status`, `extra`, `created_at`, `updated_at`) VALUES
	(5, 'App\\Domains\\Orders\\Models\\Order', 26, 'pagseguro', '17CE335A-7001-49ED-96DD-F0204DF7A314', 149.90, 1, '4111 1', 'visa', 'Aguardando Pagamento', '{"NumPedido":26,"plots":{"quantity":"1","installmentAmount":"149.90","grossAmount":"149.90","netAmount":"142.02","feeAmount":"7.88"}}', '2021-09-30 16:53:55', '2021-09-30 16:53:55'),
	(6, 'App\\Domains\\Orders\\Models\\Order', 31, 'pagseguro', '46E0D977-CDDA-4E14-B75D-9C3F4E49749C', 149.90, 1, '4111 1', 'visa', 'Aguardando Pagamento', '{"NumPedido":31,"plots":{"quantity":"1","installmentAmount":"149.90","grossAmount":"149.90","netAmount":"142.02","feeAmount":"7.88"}}', '2021-09-30 17:09:18', '2021-09-30 17:09:18'),
	(8, 'App\\Domains\\Orders\\Models\\Order', 33, 'pagseguro', 'F0D98970-913B-4819-8BF8-F5A82CBB3134', 149.90, 1, '4111 1', 'visa', 'Aguardando Pagamento', '{"NumPedido":33,"plots":{"quantity":"1","installmentAmount":"149.90","grossAmount":"149.90","netAmount":"142.02","feeAmount":"7.88"}}', '2021-09-30 19:19:52', '2021-09-30 19:19:52'),
	(9, 'App\\Domains\\Orders\\Models\\Order', 34, 'pagseguro', '91A35FB0-C19F-4ECC-A536-5D129CA6106C', 149.90, 1, '4111 1', 'visa', 'Aguardando Pagamento', '{"NumPedido":34,"plots":{"quantity":"1","installmentAmount":"149.90","grossAmount":"149.90","netAmount":"142.02","feeAmount":"7.88"}}', '2021-09-30 19:41:21', '2021-09-30 19:41:21'),
	(10, 'App\\Domains\\Orders\\Models\\Order', 35, 'pagseguro', '06D5EDBC-C9BA-4543-9202-79D0CECA49A0', 149.90, 1, '4111 1', 'visa', 'Aguardando Pagamento', '{"NumPedido":35,"plots":{"quantity":"1","installmentAmount":"149.90","grossAmount":"149.90","netAmount":"149.90","feeAmount":"0.00"}}', '2021-10-01 00:02:47', '2021-10-01 00:02:47'),
	(18, 'App\\Domains\\Orders\\Models\\Order', 79, 'pagseguro', 'A842BC73-30B8-4F52-9544-6550F6F47A53', 786.70, 1, '4111 1', 'visa', 'Aguardando Pagamento', '{"NumPedido":79,"plots":{"quantity":"1","installmentAmount":"786.70","grossAmount":"786.70","netAmount":"747.04","feeAmount":"39.66"}}', '2022-02-02 13:47:50', '2022-02-02 13:47:50'),
	(20, 'App\\Domains\\Orders\\Models\\Order', 81, 'pagseguro', '107C78C4-9EC7-448D-9827-5317D66B451A', 149.00, 1, '4111 1', 'visa', 'Aguardando Pagamento', '{"NumPedido":81,"plots":{"quantity":"1","installmentAmount":"149.00","grossAmount":"149.00","netAmount":"141.16","feeAmount":"7.84"}}', '2022-02-02 14:05:07', '2022-02-02 14:05:07'),
	(22, 'App\\Domains\\Orders\\Models\\Order', 83, 'pagseguro', 'E59F594C-754C-4B8E-B47E-3F554CEB0A70', 487.70, 1, '4111 1', 'visa', 'Aguardando Pagamento', '{"NumPedido":83,"plots":{"quantity":"1","installmentAmount":"487.70","grossAmount":"487.70","netAmount":"462.96","feeAmount":"24.74"}}', '2022-02-02 14:16:15', '2022-02-02 14:16:15'),
	(23, 'App\\Domains\\Orders\\Models\\Order', 84, 'pagseguro', '756200C4-30F2-4A3E-8317-76ECECF8FC38', 453.60, 1, '4111 1', 'visa', 'Aguardando Pagamento', '{"NumPedido":84,"plots":{"quantity":"1","installmentAmount":"453.60","grossAmount":"453.60","netAmount":"430.57","feeAmount":"23.03"}}', '2022-02-02 14:21:41', '2022-02-02 14:21:41'),
	(27, 'App\\Domains\\Orders\\Models\\Order', 90, 'pagseguro', '7EB3FB2E-8C96-41AD-B09B-756AFA71C7C8', 457.90, 1, '4111 1', 'visa', 'Aguardando Pagamento', '{"NumPedido":90,"plots":{"quantity":"1","installmentAmount":"457.90","grossAmount":"457.90","netAmount":"434.65","feeAmount":"23.25"}}', '2022-02-02 15:55:56', '2022-02-02 15:55:56'),
	(28, 'App\\Domains\\Orders\\Models\\Order', 92, 'pagseguro', '6B42A651-01CA-4C7B-92B9-97B5DAED9F0F', 1096.30, 1, '4111 1', 'visa', 'Aguardando Pagamento', '{"NumPedido":92,"plots":{"quantity":"1","installmentAmount":"1096.30","grossAmount":"1096.30","netAmount":"1041.19","feeAmount":"55.11"}}', '2022-02-03 12:38:23', '2022-02-03 12:38:23'),
	(35, 'App\\Domains\\Orders\\Models\\Order', 113, 'pagseguro', 'E0857D92-F5F0-4D89-8108-48E24AC19C21', 747.00, 1, '4111 1', 'visa', 'Aguardando Pagamento', '{"NumPedido":113,"plots":{"quantity":"1","installmentAmount":"747.00","grossAmount":"747.00","netAmount":"709.32","feeAmount":"37.68"}}', '2022-02-14 14:09:56', '2022-02-14 14:09:56'),
	(38, 'App\\Domains\\Orders\\Models\\Order', 116, 'pagseguro', 'E297D29F-246E-43C5-87A0-03BB8205EC74', 299.80, 1, '4111 1', 'visa', 'Aguardando Pagamento', '{"NumPedido":116,"plots":{"quantity":"1","installmentAmount":"299.80","grossAmount":"299.80","netAmount":"284.44","feeAmount":"15.36"}}', '2022-02-14 14:21:51', '2022-02-14 14:21:51'),
	(39, 'App\\Domains\\Orders\\Models\\Order', 117, 'pagseguro', '8DF31D28-C0C5-4B00-A8F0-5DDBC837BB28', 278.90, 1, '4111 1', 'visa', 'Aguardando Pagamento', '{"NumPedido":117,"plots":{"quantity":"1","installmentAmount":"278.90","grossAmount":"278.90","netAmount":"264.58","feeAmount":"14.32"}}', '2022-02-16 15:34:59', '2022-02-16 15:34:59'),
	(40, 'App\\Domains\\Orders\\Models\\Order', 118, 'pagseguro', 'C4DF6E86-E514-49B3-9AA2-70AED5877FED', 448.90, 1, '4111 1', 'visa', 'Aguardando Pagamento', '{"NumPedido":118,"plots":{"quantity":"1","installmentAmount":"448.90","grossAmount":"448.90","netAmount":"426.10","feeAmount":"22.80"}}', '2022-02-16 15:41:37', '2022-02-16 15:41:37'),
	(42, 'App\\Domains\\Orders\\Models\\Order', 142, 'pagseguro', 'F87BECFB-20B1-48AC-B2E9-21FC28BA9ED5', 149.90, 1, '4111 1', 'visa', 'Aguardando Pagamento', '{"NumPedido":142,"plots":{"quantity":"1","installmentAmount":"149.90","grossAmount":"149.90","netAmount":"142.02","feeAmount":"7.88"}}', '2022-02-21 14:28:56', '2022-02-21 14:28:56'),
	(43, 'App\\Domains\\Orders\\Models\\Order', 143, 'pagseguro', 'EEF91E74-3B57-4E15-80F1-E16E557A2CE4', 189.80, 1, '4111 1', 'visa', 'Aguardando Pagamento', '{"NumPedido":143,"plots":{"quantity":"1","installmentAmount":"189.80","grossAmount":"189.80","netAmount":"179.93","feeAmount":"9.87"}}', '2022-02-25 11:37:19', '2022-02-25 11:37:19'),
	(44, 'App\\Domains\\Orders\\Models\\Order', 151, 'pagseguro', '06386882-E4D0-48F6-8058-3478E2B58B09', 588.60, 1, '4111 1', 'visa', 'Aguardando Pagamento', '{"NumPedido":151,"plots":{"quantity":"1","installmentAmount":"588.60","grossAmount":"588.60","netAmount":"558.83","feeAmount":"29.77"}}', '2022-03-10 14:51:38', '2022-03-10 14:51:38');

-- Copiando estrutura para tabela i360.payment_transactions
CREATE TABLE IF NOT EXISTS `payment_transactions` (
  `payment_id` int unsigned NOT NULL,
  `code` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `obs` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  KEY `payment_transactions_payment_id_foreign` (`payment_id`),
  CONSTRAINT `payment_transactions_payment_id_foreign` FOREIGN KEY (`payment_id`) REFERENCES `payments` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Copiando dados para a tabela i360.payment_transactions: ~0 rows (aproximadamente)
DELETE FROM `payment_transactions`;

-- Copiando estrutura para tabela i360.regions
CREATE TABLE IF NOT EXISTS `regions` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `region_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `regions_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Copiando dados para a tabela i360.regions: ~0 rows (aproximadamente)
DELETE FROM `regions`;

-- Copiando estrutura para tabela i360.sections
CREATE TABLE IF NOT EXISTS `sections` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `sections_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Copiando dados para a tabela i360.sections: ~0 rows (aproximadamente)
DELETE FROM `sections`;

-- Copiando estrutura para tabela i360.services
CREATE TABLE IF NOT EXISTS `services` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `value` decimal(15,2) DEFAULT NULL,
  `value_ramal` decimal(15,2) DEFAULT NULL,
  `has_call_center` tinyint(1) DEFAULT NULL,
  `has_cloud` tinyint(1) DEFAULT NULL,
  `free_dids` int DEFAULT '1',
  `subtitle` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `slug` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `picture` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `banner` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `banner_mobile` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `icon` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `order` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `services_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Copiando dados para a tabela i360.services: ~5 rows (aproximadamente)
DELETE FROM `services`;
INSERT INTO `services` (`id`, `title`, `value`, `value_ramal`, `has_call_center`, `has_cloud`, `free_dids`, `subtitle`, `slug`, `picture`, `banner`, `banner_mobile`, `icon`, `description`, `active`, `order`, `created_at`, `updated_at`) VALUES
	(1, 'Receive', 149.00, 14.90, 0, 0, 5, 'Ideal para empresas e negócios que precisam receber mais ligações do que fazer. Tenha mais ramais organizados para gerar resultados no atendimento aos seus clientes.', 'receive', NULL, NULL, NULL, NULL, '<ul>\r\n	<li>PABX Virtual</li>\r\n	<li>7 ramais</li>\r\n	<li>1 n&uacute;mero virtual POPs (CNs11, 31, 51 (Teut&ocirc;nia, Estrela, Lajeado, Santa Cruz do Sul e Ven&acirc;ncio Aires e 54)</li>\r\n	<li>5 canais receptivos</li>\r\n	<li>Ura receptiva (Uma grava&ccedil;&atilde;o para atendimento autom&aacute;tico)</li>\r\n	<li>Tarifa reduzida para tr&aacute;fego Brasil</li>\r\n	<li>Fixo Brasil: 0,03</li>\r\n	<li>M&oacute;vel Brasil: 0,15</li>\r\n</ul>', 1, 2, '2021-09-29 14:23:46', '2022-02-03 12:49:28'),
	(2, 'Voice', 149.90, 149.90, 0, 1, 1, 'Desenvolvido para empresas e negócios que precisam fazer mais ligações do que receber. Tenha ramais programados para gerar resultados por meio de ligações ilimitadas para telefones fixos e móveis.', 'voice', NULL, NULL, NULL, NULL, '<ul>\r\n	<li>PABX Virtual</li>\r\n	<li>4 ramais</li>\r\n	<li>1 n&uacute;mero virtual POPs (CNs11, 31, 51 (Teut&ocirc;nia, Estrela, Lajeado, Santa Cruz do Sul e Ven&acirc;ncio Aires e 54)</li>\r\n	<li>5 canais receptivos</li>\r\n	<li>Ura receptiva (Uma grava&ccedil;&atilde;o para atendimento autom&aacute;tico)</li>\r\n	<li>Liga&ccedil;&otilde;es fixo e m&oacute;vel Ilimitado</li>\r\n	<li>Combo 10 ramais: R$ 699,90</li>\r\n	<li>Combo 20 ramais: R$ 1.689,90</li>\r\n</ul>', 1, 1, '2021-09-29 14:24:02', '2022-02-03 12:49:39'),
	(3, 'Sell', 189.90, 189.00, 1, 1, 7, 'Se o objetivo do seu negócio ou empresa é vender por telefone, este é o plano! Através do Módulo Call Center você gerencia sua equipe em busca dos melhores resultados com ligações ilimitadas para telefones fixos e móveis.', 'sell', NULL, NULL, NULL, NULL, '<ul>\r\n	<li>PABX Virtual</li>\r\n	<li>1 ramal</li>\r\n	<li>1 n&uacute;mero virtual POPs (CNs11, 31, 51 (Teut&ocirc;nia, Estrela, Lajeado, Santa Cruz do Sul e Ven&acirc;ncio Aires e 54)</li>\r\n	<li>5 canais receptivos</li>\r\n	<li>Ura receptiva (Uma grava&ccedil;&atilde;o para atendimento autom&aacute;tico)</li>\r\n	<li>Liga&ccedil;&otilde;es fixo e m&oacute;vel Ilimitado</li>\r\n	<li>M&oacute;dulo Call Center (Discador autom&aacute;tico para at&eacute; 25 ramais)</li>\r\n	<li>Plataforma para videoconfer&ecirc;ncia</li>\r\n	<li>iCloud 100GB (Armazenamento na nuvem)</li>\r\n</ul>', 1, 3, '2021-09-29 14:24:15', '2022-02-03 12:59:56'),
	(5, 'Sell', 189.90, 189.00, 1, 1, 7, 'Se o objetivo do seu negócio ou empresa é vender por telefone, este é o plano! Através do Módulo Call Center você gerencia sua equipe em busca dos melhores resultados com ligações ilimitadas para telefones fixos e móveis.', 'sell2', NULL, NULL, NULL, NULL, '<ul>\r\n	<li>PABX Virtual</li>\r\n	<li>1 ramal</li>\r\n	<li>1 n&uacute;mero virtual POPs (CNs11, 31, 51 (Teut&ocirc;nia, Estrela, Lajeado, Santa Cruz do Sul e Ven&acirc;ncio Aires e 54)</li>\r\n	<li>5 canais receptivos</li>\r\n	<li>Ura receptiva (Uma grava&ccedil;&atilde;o para atendimento autom&aacute;tico)</li>\r\n	<li>Liga&ccedil;&otilde;es fixo e m&oacute;vel Ilimitado</li>\r\n	<li>M&oacute;dulo Call Center (Discador autom&aacute;tico para at&eacute; 25 ramais)</li>\r\n	<li>Plataforma para videoconfer&ecirc;ncia</li>\r\n	<li>iCloud 100GB (Armazenamento na nuvem)</li>\r\n</ul>', 1, 3, '2021-09-29 14:24:15', '2022-02-03 12:59:56'),
	(6, 'Sell', 189.90, 189.00, 1, 1, 7, 'Se o objetivo do seu negócio ou empresa é vender por telefone, este é o plano! Através do Módulo Call Center você gerencia sua equipe em busca dos melhores resultados com ligações ilimitadas para telefones fixos e móveis.', 'sell23', NULL, NULL, NULL, NULL, '<ul>\r\n	<li>PABX Virtual</li>\r\n	<li>1 ramal</li>\r\n	<li>1 n&uacute;mero virtual POPs (CNs11, 31, 51 (Teut&ocirc;nia, Estrela, Lajeado, Santa Cruz do Sul e Ven&acirc;ncio Aires e 54)</li>\r\n	<li>5 canais receptivos</li>\r\n	<li>Ura receptiva (Uma grava&ccedil;&atilde;o para atendimento autom&aacute;tico)</li>\r\n	<li>Liga&ccedil;&otilde;es fixo e m&oacute;vel Ilimitado</li>\r\n	<li>M&oacute;dulo Call Center (Discador autom&aacute;tico para at&eacute; 25 ramais)</li>\r\n	<li>Plataforma para videoconfer&ecirc;ncia</li>\r\n	<li>iCloud 100GB (Armazenamento na nuvem)</li>\r\n</ul>', 1, 3, '2021-09-29 14:24:15', '2022-02-03 12:59:56');

-- Copiando estrutura para tabela i360.service_categories
CREATE TABLE IF NOT EXISTS `service_categories` (
  `service_id` int unsigned DEFAULT NULL,
  `category_id` int unsigned DEFAULT NULL,
  KEY `service_categories_service_id_foreign` (`service_id`),
  KEY `service_categories_category_id_foreign` (`category_id`),
  CONSTRAINT `service_categories_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `service_categories_service_id_foreign` FOREIGN KEY (`service_id`) REFERENCES `services` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Copiando dados para a tabela i360.service_categories: ~0 rows (aproximadamente)
DELETE FROM `service_categories`;

-- Copiando estrutura para tabela i360.status
CREATE TABLE IF NOT EXISTS `status` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Copiando dados para a tabela i360.status: ~6 rows (aproximadamente)
DELETE FROM `status`;
INSERT INTO `status` (`id`, `title`, `deleted_at`) VALUES
	(1, 'Aguardando Pagamento', NULL),
	(2, 'Confirmado/Pago', NULL),
	(3, 'Saiu para Entrega', NULL),
	(4, 'Entregue', NULL),
	(5, 'Pedido Cancelado', NULL),
	(6, 'Pedido Reembolsado', NULL);

-- Copiando estrutura para tabela i360.subscribers
CREATE TABLE IF NOT EXISTS `subscribers` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `city` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `state` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `subscribers_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=96 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Copiando dados para a tabela i360.subscribers: ~13 rows (aproximadamente)
DELETE FROM `subscribers`;
INSERT INTO `subscribers` (`id`, `name`, `email`, `city`, `state`, `created_at`, `updated_at`) VALUES
	(37, 'Usina RS', 'eduardo@escape.ppg.br', NULL, NULL, '2022-02-02 13:47:47', '2022-02-02 13:47:47'),
	(38, 'Usina RS', 'eduardornelles@outlook.com', NULL, NULL, '2022-02-02 14:05:02', '2022-02-02 14:05:02'),
	(40, 'Usina RS', 'eduardo3@escape.ppg.br', NULL, NULL, '2022-02-02 14:16:10', '2022-02-02 14:16:10'),
	(41, 'Usina RS', 'eduardornelles33@gmail.com', NULL, NULL, '2022-02-02 14:21:36', '2022-02-02 14:21:36'),
	(42, NULL, 'eduardornelles@gmail.com', NULL, NULL, '2022-02-02 15:08:59', '2022-02-02 15:08:59'),
	(48, NULL, 'eduardornelles333@gmail.com', NULL, NULL, '2022-02-02 15:55:53', '2022-02-02 15:55:53'),
	(50, 'Usina RS', 'eduardo55@escape.ppg.br', NULL, NULL, '2022-02-03 12:38:19', '2022-02-03 12:38:19'),
	(71, 'Rafael Souza', 'eduardo66@escape.ppg.br', NULL, NULL, '2022-02-14 14:09:52', '2022-02-14 14:09:52'),
	(74, 'Eduardo 77', 'eduardo77@escape.ppg.br', NULL, NULL, '2022-02-14 14:21:46', '2022-02-21 14:28:48'),
	(75, 'Rafael Santos', 'rafael99@escape.ppg.br', NULL, NULL, '2022-02-16 15:34:55', '2022-02-16 15:34:55'),
	(76, 'Eduardo Teste Final', 'eduardo667@escape.ppg.br', NULL, NULL, '2022-02-16 15:41:33', '2022-02-16 15:41:33'),
	(87, 'Eduardo Escape', 'eduardo7777@escape.ppg.br', NULL, NULL, '2022-02-25 11:37:10', '2022-02-25 11:37:10'),
	(95, 'Eduardo D', 'eduardo999@escape.ppg.br', NULL, NULL, '2022-03-10 14:51:24', '2022-03-10 14:51:24');

-- Copiando estrutura para tabela i360.subscribers_groups
CREATE TABLE IF NOT EXISTS `subscribers_groups` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Copiando dados para a tabela i360.subscribers_groups: ~0 rows (aproximadamente)
DELETE FROM `subscribers_groups`;

-- Copiando estrutura para tabela i360.subscriber_groups
CREATE TABLE IF NOT EXISTS `subscriber_groups` (
  `subscriber_id` int unsigned NOT NULL,
  `group_id` int unsigned NOT NULL,
  KEY `subscriber_groups_subscriber_id_foreign` (`subscriber_id`),
  KEY `subscriber_groups_group_id_foreign` (`group_id`),
  CONSTRAINT `subscriber_groups_group_id_foreign` FOREIGN KEY (`group_id`) REFERENCES `subscribers_groups` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `subscriber_groups_subscriber_id_foreign` FOREIGN KEY (`subscriber_id`) REFERENCES `subscribers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Copiando dados para a tabela i360.subscriber_groups: ~0 rows (aproximadamente)
DELETE FROM `subscriber_groups`;

-- Copiando estrutura para tabela i360.testimonials
CREATE TABLE IF NOT EXISTS `testimonials` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `company` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `logo` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `city` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `uf` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `body` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Copiando dados para a tabela i360.testimonials: ~0 rows (aproximadamente)
DELETE FROM `testimonials`;

-- Copiando estrutura para tabela i360.user_addresses
CREATE TABLE IF NOT EXISTS `user_addresses` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned NOT NULL,
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `postal_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `state` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `city` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `address_complement` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `number` varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `district` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_addresses_user_id_foreign` (`user_id`),
  CONSTRAINT `user_addresses_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=155 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Copiando dados para a tabela i360.user_addresses: ~17 rows (aproximadamente)
DELETE FROM `user_addresses`;
INSERT INTO `user_addresses` (`id`, `user_id`, `title`, `postal_code`, `state`, `city`, `address`, `address_complement`, `number`, `district`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(27, 29, 'Endereço', '93332-070', 'RS', 'Novo Hamburgo', 'Rua Jacarandá', NULL, '123', 'Ideal', '2021-09-30 16:53:52', '2021-09-30 16:53:52', NULL),
	(34, 36, 'Endereço', '93320-070', 'RS', 'Novo Hamburgo', 'Rua Salgado Filho', NULL, '123', 'Pátria Nova', '2021-09-30 17:09:14', '2021-09-30 17:09:14', NULL),
	(36, 38, 'Endereço', '93320-070', 'RS', 'Novo Hamburgo', 'Rua Salgado Filho', NULL, '122', 'Pátria Nova', '2021-09-30 19:19:49', '2021-09-30 19:19:49', NULL),
	(37, 39, 'Endereço', '93320-080', 'RS', 'Novo Hamburgo', 'Rua Tapes', NULL, '121', 'Ideal', '2021-09-30 19:41:18', '2021-09-30 19:41:18', NULL),
	(38, 40, 'Endereço', '93320-070', 'RS', 'Novo Hamburgo', 'Rua Salgado Filho', NULL, '1244', 'Pátria Nova', '2021-10-01 00:02:45', '2021-10-01 00:02:45', NULL),
	(82, 84, 'Endereço', '93320-070', 'RS', 'Novo Hamburgo', 'Rua Salgado Filho', NULL, '15', 'Pátria Nova', '2022-02-02 13:47:47', '2022-02-02 13:47:47', NULL),
	(84, 86, 'Endereço', '93320-070', 'RS', 'Novo Hamburgo', 'Rua Salgado Filho', NULL, '22', 'Pátria Nova', '2022-02-02 14:05:02', '2022-02-02 14:05:02', NULL),
	(86, 88, 'Endereço', '93320-070', 'RS', 'Novo Hamburgo', 'Rua Salgado Filho', NULL, '33', 'Pátria Nova', '2022-02-02 14:16:10', '2022-02-02 14:16:10', NULL),
	(93, 95, 'Endereço', '93320-070', 'RS', 'Novo Hamburgo', 'Rua Salgado Filho', NULL, '33', 'Pátria Nova', '2022-02-02 15:55:53', '2022-02-02 15:55:53', NULL),
	(95, 97, 'Endereço', '93320-070', 'RS', 'Novo Hamburgo', 'Rua Salgado Filho', NULL, '33', 'Pátria Nova', '2022-02-03 12:38:19', '2022-02-03 12:38:19', NULL),
	(116, 118, 'Endereço', '93320-070', 'RS', 'Novo Hamburgo', 'Rua Salgado Filho', NULL, '444', 'Pátria Nova', '2022-02-14 14:09:52', '2022-02-14 14:09:52', NULL),
	(119, 121, 'Endereço', '93120-612', 'RS', 'São Leopoldo', 'Avenida Parobé', NULL, '45', 'Scharlau', '2022-02-14 14:21:46', '2022-02-14 14:21:46', NULL),
	(120, 122, 'Endereço', '93320-070', 'RS', 'Novo Hamburgo', 'Rua Salgado Filho', NULL, '333', 'Pátria Nova', '2022-02-16 15:34:55', '2022-02-16 15:34:55', NULL),
	(121, 123, 'Endereço', '93320-070', 'RS', 'Novo Hamburgo', 'Rua Salgado Filho', NULL, '3', 'Pátria Nova', '2022-02-16 15:41:33', '2022-02-16 15:41:33', NULL),
	(145, 147, 'Endereço', '93320-070', 'RS', 'Novo Hamburgo', 'Rua Salgado Filho', NULL, '22', 'Pátria Nova', '2022-02-21 14:28:48', '2022-02-21 14:28:48', NULL),
	(146, 148, 'Endereço', '93320-070', 'RS', 'Novo Hamburgo', 'Rua Salgado Filho', NULL, '22', 'Pátria Nova', '2022-02-25 11:37:10', '2022-02-25 11:37:10', NULL),
	(154, 156, 'Endereço', '93320-070', 'RS', 'Novo Hamburgo', 'Rua Salgado Filho', NULL, '291', 'Pátria Nova', '2022-03-10 14:51:24', '2022-03-10 14:51:24', NULL);

-- Copiando estrutura para tabela i360.vacantjobs
CREATE TABLE IF NOT EXISTS `vacantjobs` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `active` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Copiando dados para a tabela i360.vacantjobs: ~0 rows (aproximadamente)
DELETE FROM `vacantjobs`;

