-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `nnetwork_office_test`
--

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

--
-- Table structure for table `acoes_log`
--

CREATE TABLE `acoes_log` (
  `id` int(11) NOT NULL,
  `dono` varchar(255) NOT NULL,
  `alvo` varchar(255) NOT NULL,
  `razao` varchar(255) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `catalogo_vods`
--

CREATE TABLE `catalogo_vods` (
  `id` int(11) NOT NULL,
  `titulo` varchar(255) DEFAULT NULL,
  `titulo_original` varchar(255) DEFAULT NULL,
  `poster_path` varchar(255) DEFAULT NULL,
  `original_language` varchar(5) DEFAULT NULL,
  `genre_ids` varchar(100) DEFAULT NULL,
  `sinopse` text DEFAULT NULL,
  `vote_average` varchar(20) DEFAULT NULL,
  `vote_count` int(11) DEFAULT NULL,
  `id_api` int(11) DEFAULT NULL,
  `data_lancamento` date DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `confianca`
--

CREATE TABLE `confianca` (
  `idconfianca` int(11) NOT NULL,
  `id_cliente` varchar(45) DEFAULT NULL,
  `exp_confianca` varchar(45) DEFAULT NULL,
  `exp_cliente` varchar(45) DEFAULT NULL,
  `tipo` varchar(45) DEFAULT NULL,
  `status` varchar(45) DEFAULT NULL,
  `created_at` varchar(45) DEFAULT NULL,
  `updated_at` varchar(45) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `config_gerals`
--

CREATE TABLE `config_gerals` (
  `id` int(11) NOT NULL,
  `url_api_linha` varchar(255) DEFAULT NULL,
  `url_api_lista` varchar(255) DEFAULT NULL,
  `url_api_canais` varchar(255) DEFAULT NULL,
  `status_painel` tinyint(1) DEFAULT NULL,
  `status_vods` tinyint(1) DEFAULT NULL,
  `status_revendas` tinyint(1) DEFAULT NULL,
  `status_testes_p2p` tinyint(1) DEFAULT NULL,
  `status_testes_iptv` tinyint(1) DEFAULT NULL,
  `status_user_p2p` tinyint(1) DEFAULT NULL,
  `status_user_iptv` tinyint(1) DEFAULT NULL,
  `cont_vods` int(11) DEFAULT NULL,
  `cont_canais` int(11) DEFAULT NULL,
  `bonus` int(11) DEFAULT NULL,
  `remocao_creditos` int(11) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `config_gerals`
--

INSERT INTO `config_gerals` (`id`, `url_api_linha`, `url_api_lista`, `url_api_canais`, `status_painel`, `status_vods`, `status_revendas`, `status_testes_p2p`, `status_testes_iptv`, `status_user_p2p`, `status_user_iptv`, `cont_vods`, `cont_canais`, `bonus`, `remocao_creditos`, `created`, `modified`) VALUES
(1, '1', '1', '1', 1, 1, 1, 1, 1, 1, 1, 40000, 2000, 0, 1, '2018-11-17 11:51:49', '2021-04-08 19:10:58'),
(2, '1', '1', '1', 1, 1, 1, 1, 1, 1, 1, 40000, 2000, 0, 0, '2018-11-17 11:51:49', '2021-04-08 19:10:58'),
(3, '1', '1', '1', 1, 1, 1, 1, 1, 1, 1, 40000, 2000, 0, 0, '2018-11-17 11:51:49', '2021-04-08 19:10:58'),
(4, '1', '1', '1', 1, 1, 1, 1, 1, 1, 1, 40000, 2000, 0, 0, NULL, NULL),
(5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL);

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

--
-- Table structure for table `config_mercadopagos`
--

CREATE TABLE `config_mercadopagos` (
  `id` int(11) NOT NULL,
  `id_cliente` varchar(255) DEFAULT NULL,
  `cliente_secret` varchar(255) DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `valor_usuario` decimal(10,2) DEFAULT NULL,
  `valor_revenda` decimal(10,2) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `config_mercadopago_qrcodes`
--

CREATE TABLE `config_mercadopago_qrcodes` (
  `id` int(11) NOT NULL,
  `qrcode` varchar(150) DEFAULT NULL,
  `valor_usuario` decimal(10,2) DEFAULT NULL,
  `valor_revenda` decimal(10,2) DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `config_paypal`
--

CREATE TABLE `config_paypal` (
  `id` int(11) NOT NULL,
  `usuario` varchar(100) DEFAULT NULL,
  `senha` varchar(100) DEFAULT NULL,
  `assinatura` varchar(100) DEFAULT NULL,
  `valor_usuario` decimal(10,2) DEFAULT NULL,
  `valor_revenda` decimal(10,2) DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `config_url_testes`
--

CREATE TABLE `config_url_testes` (
  `id` int(11) NOT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `tempo` int(11) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `reduz_tempo` tinyint(1) DEFAULT NULL,
  `painel_tipo` int(11) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `creditos_log`
--

CREATE TABLE `creditos_log` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `dono` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `alvo` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `razao` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `quantidade` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `valor_antes` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `valor_pos` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `creditos_log`
--

INSERT INTO `creditos_log` (`id`, `dono`, `alvo`, `razao`, `quantidade`, `valor_antes`, `valor_pos`, `created_at`, `updated_at`) VALUES
(271460, 'painel', 'revenda', 'Credito Revenda', '1000', '999999997', '999998997', '2022-04-13 15:14:25', '2022-04-13 15:14:25');

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

--
-- Table structure for table `email_permitidos`
--

CREATE TABLE `email_permitidos` (
  `id` int(11) NOT NULL,
  `servidor` varchar(255) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `email_permitidos`
--

INSERT INTO `email_permitidos` (`id`, `servidor`, `created`, `modified`) VALUES
(1, 'i7sites.com.br', '2019-10-22 17:01:59', '2019-10-22 17:01:59'),
(2, 'gmail.com', '2019-10-22 17:02:09', '2019-10-22 17:02:09'),
(3, 'hotmail.com', '2019-11-04 11:40:34', '2019-11-04 11:40:34'),
(4, 'yahoo.com', '2019-11-04 11:40:53', '2019-11-04 11:40:53'),
(5, 'outlook.com', '2020-01-06 16:37:14', '2020-01-06 16:37:14'),
(6, 'outlook.com.br', '2020-01-06 16:37:34', '2020-01-06 16:37:34'),
(7, 'live.com', '2020-01-06 16:37:55', '2020-01-06 16:37:55'),
(8, 'uou.com', '2020-01-06 16:38:11', '2020-01-06 16:38:11'),
(9, 'uou.com', '2020-01-06 16:38:17', '2020-01-06 16:38:17'),
(10, 'uou.com.br', '2020-01-06 16:38:31', '2020-01-06 16:38:31');

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

--
-- Table structure for table `fatura_creditos`
--

CREATE TABLE `fatura_creditos` (
  `id` int(11) NOT NULL,
  `id_vendedor` int(11) DEFAULT NULL,
  `identificador` varchar(255) DEFAULT NULL,
  `produto` varchar(255) DEFAULT NULL,
  `quantidade` int(11) DEFAULT NULL,
  `valor` decimal(10,2) DEFAULT NULL,
  `status` varchar(20) DEFAULT NULL,
  `tipo_pagamento` varchar(20) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `groups`
--

CREATE TABLE `groups` (
  `id` int(11) NOT NULL,
  `titulo` varchar(50) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `groups`
--

INSERT INTO `groups` (`id`, `titulo`, `created`, `modified`) VALUES
(1, 'Administrador', '2018-08-14 23:36:13', '2018-08-14 23:36:13'),
(2, 'Revendas', '2018-08-14 23:36:18', '2018-08-14 23:36:18'),
(3, 'Usuários', '2018-08-14 23:36:25', '2018-08-14 23:36:25'),
(4, 'Testes', '2018-08-14 23:36:30', '2018-08-14 23:36:30');

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

--
-- Table structure for table `lista_personalizadas`
--

CREATE TABLE `lista_personalizadas` (
  `id` int(11) NOT NULL,
  `nome` varchar(255) DEFAULT NULL,
  `link` varchar(255) DEFAULT NULL,
  `canais` mediumtext DEFAULT NULL,
  `series` mediumtext DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  `created` varchar(45) DEFAULT NULL,
  `modified` varchar(45) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `logs`
--

CREATE TABLE `logs` (
  `id` int(11) NOT NULL,
  `ip` varchar(100) DEFAULT NULL,
  `mensagem` varchar(200) DEFAULT NULL,
  `id_acionado` int(11) DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  `created` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `log_mercadopago`
--

CREATE TABLE `log_mercadopago` (
  `id` int(11) NOT NULL,
  `id_user` varchar(255) NOT NULL,
  `user` varchar(255) NOT NULL,
  `parent_id` varchar(255) NOT NULL,
  `quantidade` varchar(255) NOT NULL,
  `valor_cobrado` varchar(255) NOT NULL,
  `valor_total` varchar(255) NOT NULL,
  `payment_id` varchar(255) DEFAULT NULL,
  `collection_id` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `log_creditos_id` varchar(255) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `mercadopago_users`
--

CREATE TABLE `mercadopago_users` (
  `id` int(11) NOT NULL,
  `user_id` varchar(255) NOT NULL,
  `user_key` varchar(255) NOT NULL,
  `client_id` varchar(255) NOT NULL,
  `valor_revenda` decimal(10,0) NOT NULL,
  `valor_cliente` decimal(10,0) NOT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `modelo_emails`
--

CREATE TABLE `modelo_emails` (
  `id` int(11) NOT NULL,
  `titulo` varchar(50) DEFAULT NULL,
  `modelo` longtext DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `modelo_emails`
--

INSERT INTO `modelo_emails` (`id`, `titulo`, `modelo`, `created`, `modified`) VALUES
(1, 'Template principal', '<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\"><html xmlns=\"http://www.w3.org/1999/xhtml\"> <head> <meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\"/> <meta name=\"viewport\" content=\"width=device-width; initial-scale=1.0; maximum-scale=1.0;\"> <style type=\"text/css\"> /* Custom Font */ @font-face{font-family:\"ProximaNW01-AltThinReg\"; src:url(\"http://www.stampready.net/css/Fonts/9de06c9b-e01e-48d4-b864-599e6bf15774.eot?#iefix\"); src:url(\"http://www.stampready.net/css/Fonts/9de06c9b-e01e-48d4-b864-599e6bf15774.eot?#iefix\") format(\"eot\"),url(\"http://www.stampready.net/css/Fonts/2c1b14e1-f9f3-46d2-97d5-69d45cffb5d7.woff\") format(\"woff\"),url(\"http://www.stampready.net/css/Fonts/ee527a2c-7f40-43c1-98fa-095263631aea.ttf\") format(\"truetype\"),url(\"http://www.stampready.net/css/Fonts/51834262-4210-4d01-942f-6ad0dead091f.svg#51834262-4210-4d01-942f-6ad0dead091f\") format(\"svg\");}@font-face{font-family:\"ProximaNW01-AltLightReg\"; src:url(\"http://www.stampready.net/css/Fonts/dae3ab6e-9824-4d09-be4d-0dd63919caf1.eot?#iefix\"); src:url(\"http://www.stampready.net/css/Fonts/dae3ab6e-9824-4d09-be4d-0dd63919caf1.eot?#iefix\") format(\"eot\"),url(\"http://www.stampready.net/css/Fonts/57e50225-0ba6-4485-99eb-da20ed870c76.woff\") format(\"woff\"),url(\"http://www.stampready.net/css/Fonts/2ed17183-9ebd-4294-a07e-7bd7b1ce07af.ttf\") format(\"truetype\"),url(\"http://www.stampready.net/css/Fonts/b45f178e-8b38-492a-a31e-d8172c0b29e2.svg#b45f178e-8b38-492a-a31e-d8172c0b29e2\") format(\"svg\");}@font-face{font-family:\"Proxima N W01 At Reg\"; src:url(\"http://www.stampready.net/css/Fonts/96676c88-bae1-468a-acf5-fa74fdb2b736.eot?#iefix\"); src:url(\"http://www.stampready.net/css/Fonts/96676c88-bae1-468a-acf5-fa74fdb2b736.eot?#iefix\") format(\"eot\"),url(\"http://www.stampready.net/css/Fonts/dba0fe51-98c1-4045-b289-c0e6afb10f73.woff\") format(\"woff\"),url(\"http://www.stampready.net/css/Fonts/14c284c3-7a50-4ef0-becf-c01232631f59.ttf\") format(\"truetype\"),url(\"http://www.stampready.net/css/Fonts/c7536b52-8fbc-472d-8d8a-335dae2980df.svg#c7536b52-8fbc-472d-8d8a-335dae2980df\") format(\"svg\");}@font-face{font-family:\"Proxima N W01 At Smbd\"; src:url(\"http://www.stampready.net/css/Fonts/a9f16204-0ff0-4a9e-8a02-59d15bc5f66b.eot?#iefix\"); src:url(\"http://www.stampready.net/css/Fonts/a9f16204-0ff0-4a9e-8a02-59d15bc5f66b.eot?#iefix\") format(\"eot\"),url(\"http://www.stampready.net/css/Fonts/6e328769-56a5-4de1-957e-575f839df36d.woff\") format(\"woff\"),url(\"http://www.stampready.net/css/Fonts/b5b3aa5a-a6be-4897-a646-09224334b90b.ttf\") format(\"truetype\"),url(\"http://www.stampready.net/css/Fonts/bcade2c9-7691-43e7-9c1b e6b2ac50ee97.svg#bcade2c9-7691-43e7-9c1b-e6b2ac50ee97\") format(\"svg\");}}/* Reset */ *{margin-top: 0px; margin-bottom: 0px; padding: 0px; border: none; line-height: normal; outline: none; list-style: none; -webkit-text-size-adjust: none; -ms-text-size-adjust: none;}table{border-collapse: collapse !important; padding: 0px !important; border: none !important; border-bottom-width: 0px !important; mso-table-lspace: 0pt; mso-table-rspace: 0pt;}table td{border-collapse: collapse;}body{margin: 0px; padding: 0px; background-color: #FFFFFF;}.ExternalClass *{line-height: 100%;}/* Responsive */ @media only screen and (max-width:600px){/* Tables parameters: width, alignment, padding */ table[class=scale]{width: 100%!important;}table[class=scale-bottom]{width: 100%!important;}table[class=borderwidth]{width: 150px!important;}table[class=center]{text-align: center!important;}table[class=scale-round]{width: 100%!important; border-top-right-radius: 0px!important; border-top-left-radius: 0px!important}/* Td */ td[class=scale-left]{width: 100%!important; text-align: left!important;}td[class=scale-left-bottom]{width: 100%!important; text-align: left!important; padding-bottom: 25px!important;}td[class=scale-left-top]{width: 100%!important; text-align: left!important; padding-top: 25px!important;}td[class=scale-left-all]{width: 100%!important; text-align: left!important; padding-top: 25px!important; padding-bottom: 25px!important;}td[class=scale-center]{width: 100%!important; text-align: center!important;}td[class=scale-center-bottom]{width: 100%!important; text-align: center!important; padding-bottom: 25px!important;}td[class=scale-center-top]{width: 100%!important; text-align: center!important; padding-top: 25px!important;}td[class=scale-center-all]{width: 100%!important; text-align: center!important; padding-top: 25px!important; padding-bottom: 25px!important;}td[class=scale-right]{width: 100%!important; text-align: right!important;}td[class=scale-right-bottom]{width: 100%!important; text-align: right!important; padding-bottom: 25px!important;}td[class=scale-right-top]{width: 100%!important; text-align: right!important; padding-top: 25px!important;}td[class=scale-right-all]{width: 100%!important; text-align: right!important; padding-top: 25px!important; padding-bottom: 25px!important;}td[class=scale-center-both]{width: 100%!important; text-align: center!important; padding-left: 20px!important; padding-right: 20px!important;}td[class=scale-center-both-top]{width: 100%!important; text-align: center!important; padding-left: 20px!important; padding-right: 20px!important; padding-top: 24px!important;}td[class=scale-width]{width: 200px!important;}td[class=noshow]{display: none!important;}td[class=borderwidth]{width: 150px!important;}span[class=nein]{display: none!important;}img[class=reset]{display: inline!important;}img[class=blockset]{display: block!important; text-align: center!important; padding-bottom: 20px!important;}p[class=lhreset]{line-height: 30px!important;}}</style> </head> <body> <table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\"> <tbody> <tr> <td align=\"center\" valign=\"top\" bgcolor=\"#ebebeb\"> <table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" data-module=\"Header\"> <tbody> <tr> <td bgcolor=\"#ebebeb\"> <table class=\"scale-round\" style=\"border-top-right-radius: 4px; border-top-left-radius: 4px;\" border=\"0\" width=\"600\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\" bgcolor=\"#474d57\" data-bgcolor=\"Header\"> <tbody> <tr> <td class=\"noshow\" height=\"42\">&nbsp;</td></tr><tr> <td> <table class=\"scale\" border=\"0\" width=\"95%\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\"> <tbody> <tr> <td> <table class=\"scale\" style=\"font-family: \'ProximaNW01-AltThinReg\', Helvetica, Arial, sans-serif; color: #ffffff;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\"> <tbody> <tr> <td height=\"24\">&nbsp;</td></tr><tr> <td class=\"scale-center-both-top\" align=\"center\"><span style=\"font-family: \'Proxima N W01 At Reg\', Helvetica, Arial, sans-serif; font-size: 32px;\" data-color=\"Headline Big\" data-size=\"Headline Big\" data-min=\"16\" data-max=\"48\">Seja Bem-Vindo!</span></td></tr><tr> <td class=\"scale-center-both\" align=\"center\">&nbsp;</td></tr><tr> <td class=\"scale-center-bottom\" style=\"padding: 42px 0px 36px 0px;\">&nbsp;</td></tr></tbody> </table> </td></tr></tbody> </table> </td></tr></tbody> </table> </td></tr></tbody> </table> <table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" data-module=\"2Col txt_left\"> <tbody> <tr> <td bgcolor=\"#ebebeb\"> <table class=\"scale\" border=\"0\" width=\"600\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\" bgcolor=\"#FFFFFF\"> <tbody> <tr> <td> <table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\"> <tbody> <tr> <td height=\"24\">&nbsp;</td></tr><tr> <td align=\"center\"><span style=\"font-family: \'Proxima N W01 At Reg\', Helvetica, Arial, sans-serif; font-size: 22px; color: #474d57;\" data-color=\"Headline Big\" data-size=\"Headline Big\" data-min=\"16\" data-max=\"48\">Dados de acesso</span></td></tr><tr> <td> <table class=\"scale\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\"> <tbody> <tr> <td> <br/> <table class=\"scale\" border=\"1\" width=\"90%\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\"> <thead></thead> <tbody> <tr> <td class=\"scale-center-bottom\" align=\"center\">&nbsp;{{LOGIN}}</td><td class=\"scale-center-bottom\" align=\"center\">&nbsp;{{SENHA}}</td></tr><tr> <td colspan=\"3\" align=\"center\">Acesse o Painel: <a href=\"http://domain.com\" target=\"_blank\">Clique aqui!</a></td></tr></tbody> </table> </td></tr></tbody> </table> </td></tr><tr> <td height=\"24\">&nbsp;</td></tr></tbody> </table> </td></tr></tbody> </table> </td></tr></tbody> </table> <table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" data-module=\"Footer\"> <tbody> <tr> <td bgcolor=\"#ebebeb\"> <table class=\"scale\" border=\"0\" width=\"600\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\" bgcolor=\"#FFFFFF\"> <tbody> <tr> <td style=\"border-bottom: 3px solid #464d57;\"> <table class=\"scale\" border=\"0\" width=\"520\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\"> <tbody> <tr> <td height=\"36\">&nbsp;</td></tr><tr> <td class=\"scale-center-both\"> <table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" align=\"left\"> <tbody> <tr> <td>&nbsp;</td></tr></tbody> </table> <table style=\"font-family: \'Proxima N W01 At Reg\', Helvetica, Arial, sans-serif; font-size: 14px;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" align=\"right\"> <tbody> <tr> <td align=\"right\" data-link-style=\"text-decoration: none; color: #8a8d95;\" data-link-color=\"Navigation Link\" data-link-size=\"Navigation Link\" data-max=\"16\">&nbsp;</td></tr></tbody> </table> </td></tr><tr> <td height=\"36\">&nbsp;</td></tr></tbody> </table> </td></tr></tbody> </table> </td></tr></tbody> </table> </td></tr></tbody> </table> </body></html>', '2018-11-21 00:00:00', '2018-11-21 00:00:00');

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

--
-- Table structure for table `msg_rapida`
--

CREATE TABLE `msg_rapida` (
  `id` int(11) NOT NULL,
  `msg` longtext NOT NULL,
  `empresa` varchar(45) DEFAULT NULL,
  `tipo` varchar(45) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `msg_rapida`
--

INSERT INTO `msg_rapida` (`id`, `msg`, `empresa`, `tipo`, `created`, `modified`) VALUES
(1, '<h5><br></h5><h5>Links Encurtado:</h5>                             <li><span class=\"font-weight-bold text-primary\"><i class=\"fas fa-atom\"></i> Lista M3U:</span> <br><span class=\"ml-2\"><encurtado_m3u></encurtado_m3u></span></li>                             <li><span class=\"font-weight-bold text-primary\"> <i class=\"fas fa-atom\"></i> Lista HLS:</span> <br><span class=\"ml-2\"><encurtado_hls></encurtado_hls></span></li>                             <li><span class=\"font-weight-bold text-primary\"><i class=\"fas fa-atom\"></i> Lista SSIPTV:</span> <br><span class=\"ml-2\"><encurtado_ssiptv></encurtado_ssiptv></span></li>                             <br><h5><b>Acessos SmartTV:</b></h5>                             <li><span class=\"font-weight-bold text-primary\"><i class=\"fas fa-atom\"></i> DNS para IPTV Smarters/ XCIPTV / ROKU TV:</span> <br>&nbsp; &nbsp; <font color=\"#ffffff\">&nbsp;<font color=\"#ffffff\"><a href=\"http://p2xsmart.xyz:2082\" target=\"_blank\"><font color=\"#ffffff\">http://p2xsmart.xyz:2082&nbsp;</font></a> </font></font></li><li>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; OU</li><li><a href=\"http://p2xsmart.xyz:2082\" target=\"_blank\"><font color=\"#ffffff\">http://p2xsmart.xyz:8</font></a><font color=\"#ffffff\">080</font><a href=\"http://p2xsmart.xyz:2082\" target=\"_blank\" style=\"\"><font color=\"#ffffff\"></font></a></li><li><a href=\"http://p2xsmart.xyz:2082\" target=\"_blank\" style=\"\"><font color=\"#ffffff\"><br></font></a></li><li><span class=\"font-weight-bold text-primary\"><span class=\"fas fa-atom\" style=\"letter-spacing: 0.14px;\"></span><span style=\"letter-spacing: 0.14px;\"></span>&nbsp;DNS para STB:</span> <br><span class=\"ml-2\">83.136.219.4</span></li><a href=\"http://p2xsmart.xyz:2082\" target=\"_blank\">                             </a><li><span class=\"font-weight-bold text-primary\"><i class=\"fas fa-atom\"></i> DNS PARA (SMART UP,SS IPTV,IPTV PORTAL:</span> <br><span class=\"ml-2\">31.42.186.33</span></li><li><h5 style=\"font-family: Montserrat, Helvetica, Arial, serif; letter-spacing: 0.14px;\"><span style=\"font-weight: 600;\">&nbsp; &nbsp; </span></h5><h5 style=\"font-family: Montserrat, Helvetica, Arial, serif; letter-spacing: 0.14px;\"><span style=\"font-weight: 600;\">Aplicativos para IPTV&nbsp;</span></h5></li><li><br></li><li>&nbsp;<span class=\"fas fa-atom\" style=\"letter-spacing: 0.14px; font-size: 1.07rem; color: rgb(115, 103, 240);\"></span><span style=\"font-family: inherit; letter-spacing: 0.14px; font-size: 1.07rem; color: rgb(115, 103, 240);\"></span><b><font color=\"#ffffff\">&nbsp;XCIPTV - link playstore </font></b></li><li><a href=\"https://bit.ly/xcp2new\" target=\"_blank\">https://bit.ly/xcp2new</a></li><li><br></li><li>&nbsp;<span class=\"fas fa-atom\" style=\"letter-spacing: 0.14px; font-size: 1.07rem; color: rgb(115, 103, 240);\"></span><span style=\"font-family: inherit; letter-spacing: 0.14px; font-size: 1.07rem; color: rgb(115, 103, 240);\"></span><b><font color=\"#ffffff\">&nbsp;Xtream Player -link playstore :</font></b></li><li><a href=\"https://bit.ly/xtreamp2\" target=\"_blank\">https://bit.ly/xtreamp2</a><a href=\"https://bit.ly/xtreamp2\" target=\"_blank\"></a></li><li><br></li><li><span style=\"font-family: inherit; letter-spacing: 0.14px; font-size: 1.07rem; color: rgb(115, 103, 240);\"></span><span style=\"font-family: inherit; letter-spacing: 0.14px; font-size: 1.07rem; color: rgb(115, 103, 240);\"></span>&nbsp;<span class=\"fas fa-atom\" style=\"letter-spacing: 0.14px; font-size: 1.07rem; color: rgb(115, 103, 240);\"></span><span style=\"font-family: inherit; letter-spacing: 0.14px; font-size: 1.07rem; color: rgb(115, 103, 240);\"></span><b><font color=\"#ffffff\">&nbsp;Smart Iptv Xtream Player&nbsp;</font></b></li><li><font color=\"#ffffff\" style=\"\"><a href=\"https://bit.ly/iptvxtreamplayer2\" target=\"_blank\">https://bit.ly/iptvxtreamplayer2</a><br></font></li><li><br></li><li><br></li><li><span style=\"font-weight: 600; color: rgb(208, 210, 214); font-size: 1.07rem; letter-spacing: 0.14px;\">&nbsp; &nbsp; Aplicativos para IOS&nbsp;</span><br></li><li><br></li><li><span class=\"fas fa-atom\" style=\"letter-spacing: 0.14px; font-size: 1.07rem; color: rgb(115, 103, 240);\"></span><span style=\"font-family: inherit; letter-spacing: 0.14px; font-size: 1.07rem; color: rgb(115, 103, 240);\"></span><span style=\"font-weight: 600; letter-spacing: 0.14px;\"><font color=\"#ffffff\">&nbsp;</font></span><b><font color=\"#ffffff\">LEEZTV GO - link apple store</font></b></li><li><a href=\"https://bit.ly/leezp2\" target=\"_blank\">https://bit.ly/leezp2</a></li><li><br></li><li><span class=\"fas fa-atom\" style=\"letter-spacing: 0.14px; font-size: 1.07rem; color: rgb(115, 103, 240);\"></span><span style=\"font-family: inherit; letter-spacing: 0.14px; font-size: 1.07rem; color: rgb(115, 103, 240);\"></span><font color=\"#ffffff\" style=\"font-size: 1rem; letter-spacing: 0.01rem;\">&nbsp;</font><font color=\"#ffffff\">&nbsp;</font><b style=\"font-size: 1rem; letter-spacing: 0.01rem;\"><font color=\"#ffffff\">247 IPTV PLAYER - link apple store</font></b></li><li><span style=\"color: rgb(115, 103, 240); letter-spacing: 0.14px;\"><a href=\"https://bit.ly/247iptvp2L\" target=\"_blank\">https://bit.ly/247iptvp2L</a></span><br></li><li><span class=\"font-weight-bold text-primary\"></span></li><li><span style=\"letter-spacing: 0.14px; font-weight: 600;\">&nbsp;</span><span style=\"letter-spacing: 0.14px; font-weight: 600;\">&nbsp;</span><span class=\"fas fa-atom\" style=\"letter-spacing: 0.14px; font-size: 1.07rem; color: rgb(115, 103, 240);\"></span><span style=\"letter-spacing: 0.14px; font-weight: 600;\">&nbsp;</span><span style=\"letter-spacing: 0.14px; font-weight: 600;\">&nbsp;</span><span style=\"font-family: inherit; letter-spacing: 0.14px; font-size: 1.07rem; color: rgb(115, 103, 240);\"></span><span style=\"letter-spacing: 0.14px; font-weight: 600;\"></span><span style=\"letter-spacing: 0.14px; font-weight: 600;\"><font color=\"#ffffff\">GSE SMART IPTV</font></span><span style=\"letter-spacing: 0.14px;\">&nbsp;</span></li><li><a href=\"https://bit.ly/GSEIPTVNEW\" target=\"_blank\">https://bit.ly/GSEIPTVNEW</a><br><h5 style=\"font-family: Montserrat, Helvetica, Arial, serif; letter-spacing: 0.14px;\"><span style=\"font-weight: 600;\">&nbsp; &nbsp; </span></h5><h5 style=\"font-family: Montserrat, Helvetica, Arial, serif; letter-spacing: 0.14px;\"><span style=\"font-weight: 600;\">Programas para COMPUTADOR</span></h5></li><li><br></li><li><span class=\"fas fa-atom\" style=\"letter-spacing: 0.14px; font-size: 1.07rem; color: rgb(115, 103, 240);\"></span><b style=\"font-size: 1rem; letter-spacing: 0.01rem;\"><font color=\"#ffffff\">DUPLEX PLAYER ( LISTA M3U)</font></b></li><li><a href=\"https://www.microsoft.com/store/apps/9NXBKN795PKQ\" target=\"_blank\">https://www.microsoft.com/store/apps/9NXBKN795PKQ</a><a href=\"https://www.microsoft.com/store/apps/9NXBKN795PKQ\" target=\"_blank\"></a></li><li><br></li><li><span class=\"fas fa-atom\" style=\"letter-spacing: 0.14px; font-size: 1.07rem; color: rgb(115, 103, 240);\"><br></span><b><span style=\"letter-spacing: 0.14px; color: rgb(255, 255, 255);\">IPTV SMARTERS PLAYER&nbsp;</span><br></b></li><li><font color=\"#ffffff\"><a href=\"https://bit.ly/SMARTERSPCNEW\" target=\"_blank\">https://bit.ly/SMARTERSPCNEW</a></font><br></li><li><br></li><li><span style=\"letter-spacing: 0.14px;\"></span><span class=\"fas fa-atom\" style=\"letter-spacing: 0.14px; font-size: 1.07rem; color: rgb(115, 103, 240);\"></span><b>&nbsp;<font color=\"#ffffff\">WebPlayer Opcão 1</font></b></li><li><span style=\"color: rgb(115, 103, 240); letter-spacing: 0.14px;\">https://xc.p2xsmart.xyz/index.php</span><br></li><li><br></li><li><b><font color=\"#ffffff\">&nbsp;</font><span class=\"fas fa-atom\" style=\"letter-spacing: 0.14px; font-size: 1.07rem; color: rgb(115, 103, 240);\"></span><span style=\"font-family: inherit; letter-spacing: 0.14px; font-size: 1.07rem; color: rgb(115, 103, 240);\"></span><span style=\"letter-spacing: 0.14px;\"><font color=\"#ffffff\">&nbsp;</font></span><font color=\"#ffffff\">WebPlayer Opcão 2</font></b></li><li><span style=\"color: rgb(115, 103, 240); letter-spacing: 0.14px;\">https://play.p2xsmart.xyz/</span><br></li><li><br></li><li><br></li><a href=\"http://p2xsmart.xyz:2082\" target=\"_blank\">                             </a><br><center><h5>Site de Suporte</h5></center><a href=\"http://p2xsmart.xyz:2082\" target=\"_blank\">                             </a><center><h6 style=\"text-align: left; \"><font color=\"#7367f0\">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; www.storep2.com</font><br></h6></center>', '1', 'iptv', NULL, '2021-11-14 17:17:48'),
(2, '<p></p><p><b>Seja bem vindo ao melhor servidor P2P</b>&nbsp;</p><p><span style=\"color: rgb(115, 103, 240); font-family: &quot;Arial Black&quot;; font-size: 1rem; letter-spacing: 0.14px;\">BAIXE O APLICATIVO M2 PRO (TV BOX) OU STDOWNLOADER (ANDROID TV)</span></p><p><b style=\"font-size: 1rem; letter-spacing: 0.01rem;\">Após baixar acesse o painel de instalação do aplicativo no link abaixo :&nbsp;</b></p><p><a href=\"http://m.x2br.co/\" target=\"_blank\">http://m.x2br.co/</a><b></b></p><p><b>usuario: helpdeskp2p@gmail.com</b><br>senha: 102030</p><p><b style=\"font-size: 1rem; letter-spacing: 0.01rem;\">clique na guia Agendador - clique em novo - Digite o ID mostrado no aplicativo&nbsp;</b></p><p><b style=\"font-size: 1rem; letter-spacing: 0.01rem;\">Duvidas ? Veja nosso </b><b>vídeo</b><b style=\"font-size: 1rem; letter-spacing: 0.01rem;\">&nbsp;tutorial clicando ao lado do seu painel guia Tutorial !</b></p><p><br></p><p><b style=\"font-size: 1rem; letter-spacing: 0.01rem;\">LOJA DE APLICATIVOS VIA WEB</b><br></p><h5 style=\"font-family: Montserrat, Helvetica, Arial, serif; letter-spacing: 0.14px;\"><font color=\"#7367f0\">&nbsp;www.bit.ly/lojaxp2</font></h5><h5 style=\"font-family: Montserrat, Helvetica, Arial, serif; letter-spacing: 0.14px;\"><font color=\"#7367f0\"><br></font><br></h5><p style=\"text-align: left;\"><br></p><p style=\"\"><br></p><p style=\"font-family: Montserrat, Helvetica, Arial, serif; letter-spacing: 0.14px;\"><br></p><h5><br></h5><p><br></p><p></p><p></p>', '1', 'p2p', NULL, '2022-02-22 12:09:56'),
(3, '<li><br></li>', '2', 'iptv', NULL, '2021-08-07 11:03:49'),
(4, '<h5><br></h5><h5><span style=\"color: rgb(115, 103, 240); letter-spacing: 0.14px; font-size: 1rem;\">&nbsp;</span></h5><span class=\"fas fa-atom\" style=\"color: rgb(115, 103, 240); letter-spacing: 0.14px;\"><span style=\"font-size: 1rem; letter-spacing: 0.14px; font-family: &quot;Arial Black&quot;;\">&nbsp;</span><span style=\"font-size: 1rem; letter-spacing: 0.14px; font-family: &quot;Arial Black&quot;; font-weight: 500;\">XPURPLE :</span></span><h5>https://bit.ly/XPURPLE</h5><p><br></p><p><span style=\"color: rgb(115, 103, 240); font-size: 1rem; letter-spacing: 0.01rem;\"> </span></p><span class=\"fas fa-atom\" style=\"color: rgb(115, 103, 240); letter-spacing: 0.14px;\"><span style=\"font-size: 1rem; letter-spacing: 0.01rem; font-family: &quot;Arial Black&quot;;\">&nbsp;</span><span style=\"font-size: 1rem; letter-spacing: 0.01rem; font-family: &quot;Arial Black&quot;; font-weight: 400;\">P2CLASSICO 3.0 :</span></span><p><b>https://bit.ly/p2classicnew</b></p>', '2', 'p2p', NULL, '2021-08-07 11:04:33'),
(5, '<li><br></li>', '4', 'iptv', NULL, '2021-08-07 11:03:49'),
(6, '<p>APLICATIVOS</p><p><br></p><p>LINK DIRETO&nbsp;</p><p><a href=\"http://abre.xyz/Va7j\" target=\"_blank\">http://abre.xyz/Va7j</a></p><p><br></p><p>LOJA PLAYSTORE</p><p><a href=\"http://abre.xyz/n4XQ\" target=\"_blank\">http://abre.xyz/n4XQ</a></p><p>&gt;&gt;Codigo do app na Loja&lt;&lt;</p><p>&gt;&gt;1004&lt;&lt;</p>', '4', 'p2p', NULL, '2021-11-14 12:11:52');

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

--
-- Table structure for table `mural_internos`
--

CREATE TABLE `mural_internos` (
  `id` int(11) NOT NULL,
  `conteudo` longtext DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `mural_internos`
--

INSERT INTO `mural_internos` (`id`, `conteudo`, `created`, `modified`) VALUES
(1, '<a href=\"https://painel.net\" target=\"_blank\">painel.net</a>', NULL, NULL);

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

--
-- Table structure for table `notificacoes`
--

CREATE TABLE `notificacoes` (
  `id` int(11) NOT NULL,
  `mensagem` text DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `identificador` int(11) DEFAULT NULL,
  `grupo` int(11) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `planos`
--

CREATE TABLE `planos` (
  `id` int(11) NOT NULL,
  `nome_plano` varchar(50) DEFAULT NULL,
  `id_externo` varchar(255) DEFAULT NULL,
  `painel_tipo` tinyint(4) DEFAULT NULL,
  `created` datetime DEFAULT NULL COMMENT '	',
  `modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `planos`
--

INSERT INTO `planos` (`id`, `nome_plano`, `id_externo`, `painel_tipo`, `created`, `modified`) VALUES
(31, 'Completo Sem Adultos	\r\n', '1', 1, '2020-07-02 20:12:30', '2020-12-28 01:03:58'),
(32, 'COMPLETO SEM VOD', '61fdb0662eb36220dc838a69', 0, '2020-12-19 12:59:30', '2020-12-19 13:09:47'),
(33, 'COMPLETO', '61dee02f2a7dad697ed1f714', 0, '2020-12-19 13:10:09', '2020-12-19 13:10:09'),
(34, 'Completo Com Adultos	\r\n', '3', 1, '2020-12-19 13:11:50', '2021-04-08 19:14:41');

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

--
-- Table structure for table `planos_users`
--

CREATE TABLE `planos_users` (
  `user_id` int(11) NOT NULL,
  `plano_id` int(11) NOT NULL,
  `valor` decimal(10,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `planos_users`
--

INSERT INTO `planos_users` (`user_id`, `plano_id`, `valor`) VALUES
(619203, 31, NULL),
(619204, 31, NULL),
(619205, 31, NULL),
(619206, 31, NULL),
(619207, 31, NULL),
(619208, 31, NULL),
(619209, 31, NULL),
(619210, 31, NULL),
(619211, 31, NULL),
(619212, 31, NULL),
(619213, 31, NULL),
(619214, 31, NULL),
(619222, 31, NULL),
(619223, 31, NULL),
(619224, 34, NULL);

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

--
-- Table structure for table `redirect`
--

CREATE TABLE `redirect` (
  `id` int(11) NOT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `date` varchar(45) DEFAULT NULL,
  `hits` varchar(45) DEFAULT NULL,
  `user_id` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `redirect`
--

INSERT INTO `redirect` (`id`, `slug`, `url`, `date`, `hits`, `user_id`) VALUES
(270106, '9473104702', 'http://p2xsmart.xyz:2082/get.php?username=4675722326&password=4461378202&type=m3u_plus&output=ts', NULL, '0', '619203'),
(270107, '2090816326', 'http://p2xsmart.xyz:2082/get.php?username=4675722326&password=4461378202&type=m3u_plus&output=m3u8', NULL, '0', '619203'),
(270108, '7499204153', 'http://p2cms.mydev.wtf/get/ssiptv/paineis?username=4675722326&password=4461378202', NULL, '0', '619203'),
(270109, '6388362479', 'http://p2xsmart.xyz:2082/get.php?username=0540596409&password=2695798862&type=m3u_plus&output=ts', NULL, '0', '619204'),
(270110, '1842073498', 'http://p2xsmart.xyz:2082/get.php?username=0540596409&password=2695798862&type=m3u_plus&output=m3u8', NULL, '0', '619204'),
(270111, '1294225863', 'http://p2cms.mydev.wtf/get/ssiptv/paineis?username=0540596409&password=2695798862', NULL, '0', '619204'),
(270112, '8325530808', 'http://p2xsmart.xyz:2082/get.php?username=fghj&password=dfg&type=m3u_plus&output=ts', NULL, '0', '619205'),
(270113, '5173455983', 'http://p2xsmart.xyz:2082/get.php?username=fghj&password=dfg&type=m3u_plus&output=m3u8', NULL, '0', '619205'),
(270114, '2896085210', 'http://p2cms.mydev.wtf/get/ssiptv/paineis?username=fghj&password=dfg', NULL, '0', '619205'),
(270115, '2297806010', 'http://p2xsmart.xyz:2082/get.php?username=khjkhlk&password=kjjkhkh&type=m3u_plus&output=ts', NULL, '0', '619206'),
(270116, '0121475634', 'http://p2xsmart.xyz:2082/get.php?username=khjkhlk&password=kjjkhkh&type=m3u_plus&output=m3u8', NULL, '0', '619206'),
(270117, '2963026047', 'http://p2cms.mydev.wtf/get/ssiptv/paineis?username=khjkhlk&password=kjjkhkh', NULL, '0', '619206'),
(270118, '2615772756', 'http://p2xsmart.xyz:2082/get.php?username=2613247869&password=4258540868&type=m3u_plus&output=ts', NULL, '0', '619207'),
(270119, '6021957259', 'http://p2xsmart.xyz:2082/get.php?username=2613247869&password=4258540868&type=m3u_plus&output=m3u8', NULL, '0', '619207'),
(270120, '2233454125', 'http://p2cms.mydev.wtf/get/ssiptv/paineis?username=2613247869&password=4258540868', NULL, '0', '619207'),
(270121, '8649967014', 'http://p2xsmart.xyz:2082/get.php?username=4960354743&password=4008140686&type=m3u_plus&output=ts', NULL, '0', '619208'),
(270122, '9256728524', 'http://p2xsmart.xyz:2082/get.php?username=4960354743&password=4008140686&type=m3u_plus&output=m3u8', NULL, '0', '619208'),
(270123, '4851661606', 'http://p2cms.mydev.wtf/get/ssiptv/paineis?username=4960354743&password=4008140686', NULL, '0', '619208'),
(270124, '2976903206', 'http://p2xsmart.xyz:2082/get.php?username=9578619298&password=4852775620&type=m3u_plus&output=ts', NULL, '0', '619209'),
(270125, '6581861051', 'http://p2xsmart.xyz:2082/get.php?username=9578619298&password=4852775620&type=m3u_plus&output=m3u8', NULL, '0', '619209'),
(270126, '1710216952', 'http://p2cms.mydev.wtf/get/ssiptv/paineis?username=9578619298&password=4852775620', NULL, '0', '619209'),
(270127, '7220322102', 'http://p2xsmart.xyz:2082/get.php?username=4144732996&password=7081992134&type=m3u_plus&output=ts', NULL, '0', '619210'),
(270128, '8844603456', 'http://p2xsmart.xyz:2082/get.php?username=4144732996&password=7081992134&type=m3u_plus&output=m3u8', NULL, '0', '619210'),
(270129, '1342463787', 'http://p2cms.mydev.wtf/get/ssiptv/paineis?username=4144732996&password=7081992134', NULL, '0', '619210'),
(270130, '2975836211', 'http://p2xsmart.xyz:2082/get.php?username=5269275102&password=9129106457&type=m3u_plus&output=ts', NULL, '0', '619211'),
(270131, '0853769803', 'http://p2xsmart.xyz:2082/get.php?username=5269275102&password=9129106457&type=m3u_plus&output=m3u8', NULL, '0', '619211'),
(270132, '4273194719', 'http://p2cms.mydev.wtf/get/ssiptv/paineis?username=5269275102&password=9129106457', NULL, '0', '619211'),
(270133, '7413262860', 'http://p2xsmart.xyz:2082/get.php?username=3636462683&password=7226517260&type=m3u_plus&output=ts', NULL, '0', '619212'),
(270134, '1148955501', 'http://p2xsmart.xyz:2082/get.php?username=3636462683&password=7226517260&type=m3u_plus&output=m3u8', NULL, '0', '619212'),
(270135, '6512140203', 'http://p2cms.mydev.wtf/get/ssiptv/paineis?username=3636462683&password=7226517260', NULL, '0', '619212'),
(270136, '5846093721', 'http://p2xsmart.xyz:2082/get.php?username=8104123536&password=6862372773&type=m3u_plus&output=ts', NULL, '0', '619213'),
(270137, '2868832850', 'http://p2xsmart.xyz:2082/get.php?username=8104123536&password=6862372773&type=m3u_plus&output=m3u8', NULL, '0', '619213'),
(270138, '3777433097', 'http://p2cms.mydev.wtf/get/ssiptv/paineis?username=8104123536&password=6862372773', NULL, '0', '619213'),
(270139, '6157197321', 'http://p2xsmart.xyz:2082/get.php?username=1859208815&password=3816213689&type=m3u_plus&output=ts', NULL, '0', '619214'),
(270140, '9049684299', 'http://p2xsmart.xyz:2082/get.php?username=1859208815&password=3816213689&type=m3u_plus&output=m3u8', NULL, '0', '619214'),
(270141, '1327864772', 'http://p2cms.mydev.wtf/get/ssiptv/paineis?username=1859208815&password=3816213689', NULL, '0', '619214'),
(270142, '0315586729', 'http://p2xsmart.xyz:2082/get.php?username=5936474092&password=7614018452&type=m3u_plus&output=ts', NULL, '0', '619222'),
(270143, '1656266348', 'http://p2xsmart.xyz:2082/get.php?username=5936474092&password=7614018452&type=m3u_plus&output=m3u8', NULL, '0', '619222'),
(270144, '2597544069', 'http://p2cms.mydev.wtf/get/ssiptv/paineis?username=5936474092&password=7614018452', NULL, '0', '619222'),
(270145, '6711344579', 'http://p2xsmart.xyz:2082/get.php?username=8083383157&password=7170923339&type=m3u_plus&output=ts', NULL, '0', '619223'),
(270146, '3453689262', 'http://p2xsmart.xyz:2082/get.php?username=8083383157&password=7170923339&type=m3u_plus&output=m3u8', NULL, '0', '619223'),
(270147, '9244786791', 'http://p2cms.mydev.wtf/get/ssiptv/paineis?username=8083383157&password=7170923339', NULL, '0', '619223'),
(270148, '0799486582', 'http://p2xsmart.xyz:2082/get.php?username=sdfgh&password=sdfgh&type=m3u_plus&output=ts', NULL, '0', '619224'),
(270149, '1571432313', 'http://p2xsmart.xyz:2082/get.php?username=sdfgh&password=sdfgh&type=m3u_plus&output=m3u8', NULL, '0', '619224'),
(270150, '8752477832', 'http://p2cms.mydev.wtf/get/ssiptv/paineis?username=sdfgh&password=sdfgh', NULL, '0', '619224');

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

--
-- Table structure for table `servidor_emails`
--

CREATE TABLE `servidor_emails` (
  `id` int(11) NOT NULL,
  `email` varchar(255) DEFAULT NULL,
  `usuario` varchar(255) DEFAULT NULL,
  `senha` varchar(255) DEFAULT NULL,
  `seguranca` varchar(25) DEFAULT NULL,
  `servidor` varchar(255) DEFAULT NULL,
  `porta` int(11) DEFAULT NULL,
  `tipo` varchar(35) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `servidor_streams`
--

CREATE TABLE `servidor_streams` (
  `id` int(11) NOT NULL,
  `nome` varchar(50) DEFAULT NULL,
  `id_externo` int(11) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `suportes`
--

CREATE TABLE `suportes` (
  `id` int(11) NOT NULL,
  `assunto` varchar(255) DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `caixa_remetente` int(11) DEFAULT NULL,
  `caixa_destinatario` int(11) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  `id_destinatario` int(11) DEFAULT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `suporte_mensagens`
--

CREATE TABLE `suporte_mensagens` (
  `id` int(11) NOT NULL,
  `mensagem` longtext DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  `suporte_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `template_emails`
--

CREATE TABLE `template_emails` (
  `id` int(11) NOT NULL,
  `tipo` int(11) DEFAULT NULL,
  `assunto` varchar(255) DEFAULT NULL,
  `mensagem` longtext DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `tutorial`
--

CREATE TABLE `tutorial` (
  `id` int(10) UNSIGNED NOT NULL,
  `subject` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `detail` longtext NOT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tutorial`
--

INSERT INTO `tutorial` (`id`, `subject`, `title`, `detail`, `created`, `modified`) VALUES
(1, '1', 'Aplictivo M2 PRO (TV BOX)  OU STDOWNLOADER (ANDROID TV)', '<p>Exemplo<iframe frameborder=\"0\" src=\"//www.youtube.com/embed/Qgf3FGBrYJo\" width=\"640\" height=\"360\" class=\"note-video-clip\"></iframe></p>', NULL, NULL);

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

--
-- Table structure for table `tuto_subject`
--

CREATE TABLE `tuto_subject` (
  `id` int(11) NOT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `subject_detail` varchar(255) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tuto_subject`
--

INSERT INTO `tuto_subject` (`id`, `subject`, `subject_detail`, `created`, `modified`) VALUES
(1, 'COMO BAIXAR APLICATIVO P2P NO TV BOX E ADROID TV', 'NOVO APLICATIVO NA PLAYSTORE', '2021-11-18 12:18:27', '2021-11-18 12:18:27');

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `nome` varchar(100) DEFAULT NULL,
  `telefone` varchar(20) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `expiracao` datetime DEFAULT NULL,
  `creditos` int(11) DEFAULT NULL,
  `limite_teste` int(11) DEFAULT NULL,
  `limite_usuarios` int(11) DEFAULT NULL,
  `valor_cobrado` decimal(10,2) DEFAULT NULL,
  `conexoes` int(11) DEFAULT 1,
  `username` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `externo_login` varchar(255) DEFAULT NULL,
  `externo_senha` varchar(255) DEFAULT NULL,
  `imagem` varchar(100) DEFAULT NULL,
  `observacao` text DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `token_api` varchar(32) DEFAULT NULL,
  `group_id` int(11) NOT NULL,
  `mac` varchar(255) DEFAULT NULL,
  `extensao` int(11) DEFAULT NULL,
  `data_extensao` datetime DEFAULT NULL,
  `id_externo` int(11) DEFAULT NULL,
  `painel_tipo` tinyint(1) DEFAULT NULL,
  `tipo` varchar(45) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  `ip` varchar(45) DEFAULT NULL,
  `updated_at` varchar(45) DEFAULT NULL,
  `created_at` varchar(45) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `parent_id`, `nome`, `telefone`, `email`, `expiracao`, `creditos`, `limite_teste`, `limite_usuarios`, `valor_cobrado`, `conexoes`, `username`, `password`, `externo_login`, `externo_senha`, `imagem`, `observacao`, `status`, `token_api`, `group_id`, `mac`, `extensao`, `data_extensao`, `id_externo`, `painel_tipo`, `tipo`, `created`, `modified`, `ip`, `updated_at`, `created_at`) VALUES
(1, NULL, 'admin', '83991165618', 'admincs@painel.net', NULL, 999998996, 10000, 1000000, '0.00', NULL, 'painel', '$2a$12$ZAGov1BfcOSyIXv9CgG0mujZfdePDE2Y65f63TOsPSnG7JxNtMu8G', 'adminadm', '', '', NULL, 1, NULL, 1, NULL, NULL, NULL, NULL, NULL, 'Ultra', '2020-12-19 13:25:51', '2021-09-22 11:09:09', '2804:29b8:507a:2058:2c2b:2daa:bfba:a107', '2022-04-13 11:42:19', NULL),
(619203, 1, '4675722326', NULL, NULL, '2022-04-13 14:51:22', 0, NULL, NULL, '0.00', 1, '4675722326', '$2y$10$J3YSoVUqd5zbx5ZdRwUBo.ju101N4yD0vhB7I88sen92ICN0v38fu', '4675722326', '4461378202', NULL, 'OPA', 1, NULL, 4, NULL, NULL, NULL, 2774347, 1, '1', '2022-04-13 10:51:23', '2022-04-13 10:51:23', NULL, '2022-04-13 10:58:16', '2022-04-13 10:51:23'),
(619204, 1, '0540596409', NULL, NULL, '2022-04-13 14:53:21', 0, NULL, NULL, '0.00', 1, '0540596409', '$2y$10$w7nwxkv.EGCV1WERfsz5i.gfpVOe5jJSfb08v8FwgSrKMZIidKo5i', '0540596409', '2695798862', NULL, NULL, 1, NULL, 4, NULL, NULL, NULL, 2774348, 1, '1', '2022-04-13 10:53:21', '2022-04-13 10:53:21', NULL, '2022-04-13 10:53:21', '2022-04-13 10:53:21'),
(619205, 1, 'ghjk', NULL, NULL, '2022-05-13 11:02:27', 1, NULL, NULL, '23.00', 1, 'fghj', '$2y$10$DdXadrHvp/nvYC15/noZ9uY5AdI7MozaAXJ8l5ANSD4xUue1jcrHi', 'fghj', 'dfg', NULL, 'dfgsdgsdfg', 1, NULL, 3, NULL, NULL, NULL, 2774349, 1, '1', '2022-04-13 11:02:28', '2022-04-13 11:02:28', NULL, '2022-04-13 11:04:11', '2022-04-13 11:02:28'),
(619206, 1, 'dfkdshf', NULL, NULL, '2022-05-13 11:04:49', 1, NULL, NULL, '0.00', 1, 'khjkhlk', '$2y$10$wt6a6.wqTYKlsYQdrXlFI.YGkW/r2lWS5Wv1adIHHSuERXWbgG2da', 'khjkhlk', 'kjjkhkh', NULL, NULL, 1, NULL, 3, NULL, NULL, NULL, 2774350, 1, '1', '2022-04-13 11:04:50', '2022-04-13 11:04:50', NULL, '2022-04-13 11:04:50', '2022-04-13 11:04:50'),
(619207, 1, '2613247869', NULL, NULL, '2022-04-13 15:05:47', 0, NULL, NULL, '0.00', 1, '2613247869', '$2y$10$gOo9DJOCuPQN/TFBHYaowu6r3wdBlMypT867Up4.hyd95WZ0tNjom', '2613247869', '4258540868', NULL, NULL, 1, NULL, 4, NULL, NULL, NULL, 2774351, 1, '1', '2022-04-13 11:05:48', '2022-04-13 11:05:48', NULL, '2022-04-13 11:05:48', '2022-04-13 11:05:48'),
(619208, 1, '4960354743', NULL, NULL, '2022-04-13 15:06:00', 0, NULL, NULL, '0.00', 1, '4960354743', '$2y$10$ch5vVbbi5A0cbZnOmemnweUXCfZWqxC5DlN34AB59xc8r9UkevOeO', '4960354743', '4008140686', NULL, NULL, 1, NULL, 4, NULL, NULL, NULL, 2774352, 1, '1', '2022-04-13 11:06:00', '2022-04-13 11:06:00', NULL, '2022-04-13 11:06:00', '2022-04-13 11:06:00'),
(619209, 1, '9578619298', NULL, NULL, '2022-04-13 15:07:17', 0, NULL, NULL, '0.00', 1, '9578619298', '$2y$10$OKl5FwgyZGmt5KQOGAKxQe96zHYQL7UymIBOybHeRv8fuGVDSWKu6', '9578619298', '4852775620', NULL, NULL, 1, NULL, 4, NULL, NULL, NULL, 2774354, 1, '1', '2022-04-13 11:07:18', '2022-04-13 11:07:18', NULL, '2022-04-13 11:07:18', '2022-04-13 11:07:18'),
(619210, 1, '4144732996', NULL, NULL, '2022-04-13 15:07:40', 0, NULL, NULL, '0.00', 1, '4144732996', '$2y$10$gpbHULzldvqgPseG2vcew.KrbxUjBSO8X41jMOlAoggBMfOlJiQz6', '4144732996', '7081992134', NULL, NULL, 1, NULL, 4, NULL, NULL, NULL, 2774355, 1, '1', '2022-04-13 11:07:41', '2022-04-13 11:07:41', NULL, '2022-04-13 11:07:41', '2022-04-13 11:07:41'),
(619211, 1, '5269275102', NULL, NULL, '2022-04-13 15:07:58', 0, NULL, NULL, '0.00', 1, '5269275102', '$2y$10$aN5Lv6NtRDS1KDVx4d/VQeY3mj31FQ/HTtNg5/2s23/h5oPZI26yi', '5269275102', '9129106457', NULL, NULL, 1, NULL, 4, NULL, NULL, NULL, 2774356, 1, '1', '2022-04-13 11:07:59', '2022-04-13 11:07:59', NULL, '2022-04-13 11:07:59', '2022-04-13 11:07:59'),
(619212, 1, '3636462683', NULL, NULL, '2022-04-13 15:08:28', 0, NULL, NULL, '0.00', 1, '3636462683', '$2y$10$SZUqwbMUud8ONLf7h63s9u.nDPJz2WpvAa1rKsZHQczh74xL4kJim', '3636462683', '7226517260', NULL, NULL, 1, NULL, 4, NULL, NULL, NULL, 2774357, 1, '1', '2022-04-13 11:08:29', '2022-04-13 11:08:29', NULL, '2022-04-13 11:08:29', '2022-04-13 11:08:29'),
(619213, 1, '8104123536', NULL, NULL, '2022-04-13 15:09:09', 0, NULL, NULL, '0.00', 1, '8104123536', '$2y$10$ZC9NkgaGlh03741edg7sNOH1mX2QKNjw6ziEx5mM23X6jM4dIMHKi', '8104123536', '6862372773', NULL, NULL, 1, NULL, 4, NULL, NULL, NULL, 2774358, 1, '1', '2022-04-13 11:09:10', '2022-04-13 11:09:10', NULL, '2022-04-13 11:09:10', '2022-04-13 11:09:10'),
(619214, 1, '1859208815', NULL, NULL, '2022-04-13 15:12:48', 0, NULL, NULL, '0.00', 1, '1859208815', '$2y$10$wBODG3D1alPb8KFSPNQVKuPYkcIOnbhiChhxbNvcuicrx/.ge91gC', '1859208815', '3816213689', NULL, NULL, 1, NULL, 4, NULL, NULL, NULL, 2774359, 1, '1', '2022-04-13 11:12:48', '2022-04-13 11:12:48', NULL, '2022-04-13 11:12:48', '2022-04-13 11:12:48'),
(619215, 1, 'Teste Revenda', NULL, 'revenda@painel.net', '2022-04-13 11:14:01', 1000, NULL, NULL, '0.00', 1, 'revenda', '$2y$10$Iq97pgDR/VTc.gy48syUaO0SL3KAN5xgmbxMs6ot3yVvfNG1mIZp2', 'revenda', '123456', NULL, NULL, 1, NULL, 2, NULL, NULL, NULL, NULL, 1, NULL, '2022-04-13 11:14:01', '2022-04-13 11:14:01', NULL, '2022-04-13 11:14:25', '2022-04-13 11:14:01'),
(619216, 1, '4223097224', NULL, NULL, '2022-04-13 15:31:55', 0, NULL, NULL, '0.00', 1, '4223097224', '$2y$10$3/re71WscgTCb4bL7oWFWuPNF/B5PwH4AIaPzjbHafYxk3PVruhTG', '4223097224', '4420821421', NULL, NULL, 1, NULL, 4, NULL, NULL, NULL, 2774360, 1, '1', '2022-04-13 11:31:56', '2022-04-13 11:31:56', NULL, '2022-04-13 11:31:56', '2022-04-13 11:31:56'),
(619217, 1, '1271638969', NULL, NULL, '2022-04-13 15:32:20', 0, NULL, NULL, '0.00', 1, '1271638969', '$2y$10$tdUUYuDidkhrB5YCJC9HpOL92fps4K4jnm42iOYCDiVF9ujEEEGcq', '1271638969', '5073866562', NULL, NULL, 1, NULL, 4, NULL, NULL, NULL, 2774361, 1, '1', '2022-04-13 11:32:20', '2022-04-13 11:32:20', NULL, '2022-04-13 11:32:20', '2022-04-13 11:32:20'),
(619218, 1, '7178160670', NULL, NULL, '2022-04-13 15:32:20', 0, NULL, NULL, '0.00', 1, '7178160670', '$2y$10$3TaN7wcNVNlkZqWFd6LEeeGSMIwyJtCgR4xz./u.1A8oc1HrXaLY2', '7178160670', '7333733458', NULL, NULL, 1, NULL, 4, NULL, NULL, NULL, 2774362, 1, '1', '2022-04-13 11:32:21', '2022-04-13 11:32:21', NULL, '2022-04-13 11:32:21', '2022-04-13 11:32:21'),
(619219, 1, '2120734423', NULL, NULL, '2022-04-13 15:37:55', 0, NULL, NULL, '0.00', 1, '2120734423', '$2y$10$sGiovgPjeoCpt6ErVFtv1ucLPnHdfeJB6YH5PwQ8QmwBcIAjRFMNm', '2120734423', '1321049847', NULL, NULL, 1, NULL, 4, NULL, NULL, NULL, 2774363, 1, '1', '2022-04-13 11:37:55', '2022-04-13 11:37:55', NULL, '2022-04-13 11:37:55', '2022-04-13 11:37:55'),
(619220, 1, '0109768771', NULL, NULL, '2022-04-13 15:38:05', 0, NULL, NULL, '0.00', 1, '0109768771', '$2y$10$0ExSNyiaxkhQvizgMP31Ke5x7idHHdj9fbizw27I4RqHVsYSVVB/K', '0109768771', '2101250053', NULL, NULL, 1, NULL, 4, NULL, NULL, NULL, 2774364, 1, '1', '2022-04-13 11:38:05', '2022-04-13 11:38:05', NULL, '2022-04-13 11:38:05', '2022-04-13 11:38:05'),
(619221, 1, '7283645214', NULL, NULL, '2022-04-13 15:39:59', 0, NULL, NULL, '0.00', 1, '7283645214', '$2y$10$aJE9s8cQOJxJ0eVCIp9PE.gRnuTXXfIZ/E98wMGCSy.81icHpqTZC', '7283645214', '2530693151', NULL, NULL, 1, NULL, 4, NULL, NULL, NULL, 2774365, 1, '1', '2022-04-13 11:40:00', '2022-04-13 11:40:00', NULL, '2022-04-13 11:40:00', '2022-04-13 11:40:00'),
(619222, 1, '5936474092', NULL, NULL, '2022-04-13 15:41:09', 0, NULL, NULL, '0.00', 1, '5936474092', '$2y$10$QNjUTP9Gc/qxNIY3fH761Oyb5ybAyjGG.zQTyYasqA.0LiFufx7.W', '5936474092', '7614018452', NULL, NULL, 1, NULL, 4, NULL, NULL, NULL, 2774366, 1, '1', '2022-04-13 11:41:10', '2022-04-13 11:41:10', NULL, '2022-04-13 11:41:10', '2022-04-13 11:41:10'),
(619223, 1, '8083383157', NULL, NULL, '2022-04-13 15:41:50', 0, NULL, NULL, '0.00', 1, '8083383157', '$2y$10$SCjD4iEnazFn8OjWCLJEEeyDw8LGhWwYcJgyk/DnsYb6RhYs.5BWu', '8083383157', '7170923339', NULL, NULL, 1, NULL, 4, NULL, NULL, NULL, 2774367, 1, '1', '2022-04-13 11:41:51', '2022-04-13 11:41:51', NULL, '2022-04-13 11:41:51', '2022-04-13 11:41:51'),
(619224, 1, 'dfghj', NULL, NULL, '2022-05-13 11:42:16', 1, NULL, NULL, '0.00', 1, 'sdfgh', '$2y$10$7u6TJcoDRUs8xUKFmzVoEexyT3szFQkju.MgN.Pr3pD8w/1hR7vjO', 'sdfgh', 'sdfgh', NULL, NULL, 1, NULL, 3, NULL, NULL, NULL, 2774368, 1, '3', '2022-04-13 11:42:19', '2022-04-13 11:42:19', NULL, '2022-04-13 11:42:19', '2022-04-13 11:42:19');

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

--
-- Table structure for table `vods`
--

CREATE TABLE `vods` (
  `id` int(11) NOT NULL,
  `vod` text DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `acoes_log`
--
ALTER TABLE `acoes_log`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `catalogo_vods`
--
ALTER TABLE `catalogo_vods`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `confianca`
--
ALTER TABLE `confianca`
  ADD PRIMARY KEY (`idconfianca`);

--
-- Indexes for table `config_gerals`
--
ALTER TABLE `config_gerals`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `config_mercadopagos`
--
ALTER TABLE `config_mercadopagos`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `config_mercadopago_qrcodes`
--
ALTER TABLE `config_mercadopago_qrcodes`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `config_paypal`
--
ALTER TABLE `config_paypal`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `config_url_testes`
--
ALTER TABLE `config_url_testes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_config_url_testes_users1_idx` (`user_id`);

--
-- Indexes for table `creditos_log`
--
ALTER TABLE `creditos_log`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `email_permitidos`
--
ALTER TABLE `email_permitidos`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `fatura_creditos`
--
ALTER TABLE `fatura_creditos`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `groups`
--
ALTER TABLE `groups`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `lista_personalizadas`
--
ALTER TABLE `lista_personalizadas`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_lista_personalizadas_users1_idx` (`user_id`);

--
-- Indexes for table `logs`
--
ALTER TABLE `logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_logs_users1_idx` (`user_id`);

--
-- Indexes for table `log_mercadopago`
--
ALTER TABLE `log_mercadopago`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mercadopago_users`
--
ALTER TABLE `mercadopago_users`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `modelo_emails`
--
ALTER TABLE `modelo_emails`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `msg_rapida`
--
ALTER TABLE `msg_rapida`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mural_internos`
--
ALTER TABLE `mural_internos`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `notificacoes`
--
ALTER TABLE `notificacoes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_notificacoes_users1_idx` (`user_id`);

--
-- Indexes for table `planos`
--
ALTER TABLE `planos`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `planos_users`
--
ALTER TABLE `planos_users`
  ADD PRIMARY KEY (`user_id`,`plano_id`),
  ADD KEY `fk_users_has_planos_planos1_idx` (`plano_id`),
  ADD KEY `fk_users_has_planos_users1_idx` (`user_id`);

--
-- Indexes for table `redirect`
--
ALTER TABLE `redirect`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `servidor_emails`
--
ALTER TABLE `servidor_emails`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_servidor_emails_users1_idx` (`user_id`);

--
-- Indexes for table `servidor_streams`
--
ALTER TABLE `servidor_streams`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `suportes`
--
ALTER TABLE `suportes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_suportes_users1_idx` (`user_id`);

--
-- Indexes for table `suporte_mensagens`
--
ALTER TABLE `suporte_mensagens`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_suporte_mensagens_suportes_idx` (`suporte_id`);

--
-- Indexes for table `template_emails`
--
ALTER TABLE `template_emails`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_template_emails_users2_idx` (`user_id`);

--
-- Indexes for table `tutorial`
--
ALTER TABLE `tutorial`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tuto_subject`
--
ALTER TABLE `tuto_subject`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_users_groups1_idx` (`group_id`),
  ADD KEY `fk_users_users` (`parent_id`);

--
-- Indexes for table `vods`
--
ALTER TABLE `vods`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_vods_users1_idx` (`user_id`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

--
-- AUTO_INCREMENT for table `confianca`
--
ALTER TABLE `confianca`
  MODIFY `idconfianca` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15078;

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

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

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

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

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

--
-- AUTO_INCREMENT for table `creditos_log`
--
ALTER TABLE `creditos_log`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=271461;

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `notificacoes`
--
ALTER TABLE `notificacoes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

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

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

--
-- AUTO_INCREMENT for table `servidor_streams`
--
ALTER TABLE `servidor_streams`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `suporte_mensagens`
--
ALTER TABLE `suporte_mensagens`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `tutorial`
--
ALTER TABLE `tutorial`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

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

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

--
-- AUTO_INCREMENT for table `vods`
--
ALTER TABLE `vods`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `config_url_testes`
--
ALTER TABLE `config_url_testes`
  ADD CONSTRAINT `fk_config_url_testes_users1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `lista_personalizadas`
--
ALTER TABLE `lista_personalizadas`
  ADD CONSTRAINT `fk_lista_personalizadas_users1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `logs`
--
ALTER TABLE `logs`
  ADD CONSTRAINT `fk_logs_users1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `notificacoes`
--
ALTER TABLE `notificacoes`
  ADD CONSTRAINT `fk_notificacoes_users1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `planos_users`
--
ALTER TABLE `planos_users`
  ADD CONSTRAINT `fk_users_has_planos_planos1` FOREIGN KEY (`plano_id`) REFERENCES `planos` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_users_has_planos_users1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `servidor_emails`
--
ALTER TABLE `servidor_emails`
  ADD CONSTRAINT `fk_servidor_emails_users1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `suporte_mensagens`
--
ALTER TABLE `suporte_mensagens`
  ADD CONSTRAINT `fk_suporte_mensagens_suportes` FOREIGN KEY (`suporte_id`) REFERENCES `suportes` (`id`);

--
-- Constraints for table `template_emails`
--
ALTER TABLE `template_emails`
  ADD CONSTRAINT `fk_template_emails_users2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `users`
--
ALTER TABLE `users`
  ADD CONSTRAINT `fk_users_groups1` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`);

--
-- Constraints for table `vods`
--
ALTER TABLE `vods`
  ADD CONSTRAINT `fk_vods_users1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);
COMMIT;

