-- https://www.phpmyadmin.net/
--
-- Tempo de geração: 30-Out-2020 às 19:19
-- Versão do servidor: 10.4.10-MariaDB
-- versão do PHP: 7.3.12

START TRANSACTION;



--
-- Banco de dados: `ponto`
--

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

--
-- Estrutura da tabela `aviso`
--

CREATE TABLE `aviso` (
  `id` int(11) NOT NULL,
  `assunto` varchar(1000) NOT NULL,
  `mensagem` varchar(10000) NOT NULL,
  `id_user` int(11) DEFAULT NULL,
  `status` enum('Ativo','Inativo') NOT NULL,
  `data_inicio` timestamp NULL DEFAULT NULL,
  `data_fim` timestamp NULL DEFAULT NULL,
  `tipo` enum('Geral','Normal') NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Extraindo dados da tabela `aviso`
--

INSERT INTO `aviso` (`id`, `assunto`, `mensagem`, `id_user`, `status`, `data_inicio`, `data_fim`, `tipo`, `created_at`, `updated_at`) VALUES
(7, 'Retorno justificativa referente ao dia 09-10-2020', 'AGr aprovado ok aprove aquiii', 19, 'Inativo', '2020-10-22 14:22:51', '2020-10-24 14:22:51', 'Normal', '2020-10-22 14:22:51', '2020-10-22 15:03:19'),
(9, 'Retorno justificativa referente ao dia 15-10-2020', 'aprovei, tá?', 2, 'Ativo', '2020-10-22 14:24:37', '2020-10-24 14:24:37', 'Normal', '2020-10-22 14:24:37', '2020-10-22 16:06:12'),
(10, 'Editei Brenaaa Retorno justificativa referente ao dia 27-10-2020', 'ok negada edit teste 02', 19, 'Ativo', '2020-10-28 15:27:00', '2020-10-28 18:30:00', 'Geral', '2020-10-27 15:27:22', '2020-10-28 17:30:45'),
(12, 'Teste 2 sghs gdsfigspdorigjsrd gordgsrh gordshgor gousdhr ghrsduogh orgosgh ', '2º teste akgf wuegf aufua faegifgueaso fuag fugaseof aseo fage fouagsefoa eofygaoef aeg fo eaf efasd fadsfa gadg', 2, 'Ativo', '2020-10-27 14:21:00', '2020-10-30 19:21:00', 'Normal', '2020-10-27 17:21:38', NULL),
(13, 'Só um testee Ultimo', 'Tatata', 2, 'Ativo', '2020-10-28 13:31:00', '2020-10-28 16:00:00', 'Geral', '2020-10-28 14:31:39', NULL),
(15, 'Novo para teste', 'Alô alô', 19, 'Ativo', '2020-10-29 07:46:00', '2020-10-29 14:50:00', 'Normal', '2020-10-29 11:46:38', NULL),
(17, 'Teste 02 enviar por ponto', 'enviar por ponto hehehe', 19, 'Ativo', '2020-10-29 11:38:00', '2020-10-29 16:38:00', 'Normal', '2020-10-29 13:39:03', NULL),
(18, 'Finalizei seu ponto', 'Finalização do ponto pelo adm', 2, 'Ativo', '2020-10-29 17:07:00', '2020-10-30 17:08:00', 'Geral', '2020-10-29 17:08:09', NULL),
(19, 'Hehehe', 'teste dia', 14, 'Ativo', '2020-10-30 16:53:00', '2020-11-01 16:53:00', 'Normal', '2020-10-30 16:53:31', NULL);

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

--
-- Estrutura da tabela `cms_privilegio`
--

CREATE TABLE `cms_privilegio` (
  `id` int(11) NOT NULL,
  `nome` varchar(255) NOT NULL,
  `is_superadmin` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Extraindo dados da tabela `cms_privilegio`
--

INSERT INTO `cms_privilegio` (`id`, `nome`, `is_superadmin`, `created_at`, `updated_at`) VALUES
(1, 'Administrador', 1, '2020-10-13 03:00:00', NULL),
(2, 'Colaborador', 0, '2020-10-13 03:00:00', NULL);

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

--
-- Estrutura da tabela `controle_horario`
--

CREATE TABLE `controle_horario` (
  `id` int(11) NOT NULL,
  `id_users` int(11) NOT NULL,
  `hora_inicio` timestamp NULL DEFAULT NULL,
  `hora_fim` timestamp NULL DEFAULT NULL,
  `inicio_almoco` timestamp NULL DEFAULT NULL,
  `fim_almoco` timestamp NULL DEFAULT NULL,
  `horas_almoco` double DEFAULT NULL,
  `total_horas` double DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Extraindo dados da tabela `controle_horario`
--

INSERT INTO `controle_horario` (`id`, `id_users`, `hora_inicio`, `hora_fim`, `inicio_almoco`, `fim_almoco`, `horas_almoco`, `total_horas`, `created_at`, `updated_at`) VALUES
(15, 1, '2020-10-08 17:29:47', '2020-10-09 12:12:31', NULL, NULL, NULL, 6.5, '2020-10-08 17:29:47', '2020-10-09 12:12:31'),
(36, 1, '2020-10-09 13:52:55', '2020-10-09 14:18:45', NULL, NULL, NULL, 2500, '2020-10-09 13:52:55', '2020-10-09 14:18:45'),
(46, 2, '2020-10-12 14:56:02', '2020-10-12 16:41:17', NULL, NULL, NULL, 1.75, '2020-10-12 14:56:02', '2020-10-12 16:41:17'),
(47, 2, '2020-10-13 18:56:10', '2020-10-13 20:21:05', NULL, NULL, NULL, 1.4, '2020-10-13 18:56:10', '2020-10-13 20:21:05'),
(48, 2, '2020-10-14 11:35:16', '2020-10-14 17:59:49', NULL, NULL, NULL, 6.4, '2020-10-14 11:35:16', '2020-10-14 17:59:49'),
(50, 2, '2020-10-15 11:57:00', '2020-10-22 17:52:00', NULL, NULL, NULL, 5.9166666666667, '2020-10-15 11:57:43', '2020-10-22 12:30:16'),
(51, 2, '2020-10-16 11:36:57', '2020-10-16 18:18:53', NULL, NULL, NULL, 6.6833333333333, '2020-10-16 11:36:57', '2020-10-16 18:18:53'),
(52, 1, '2020-10-16 12:30:38', '2020-10-16 17:26:41', NULL, NULL, NULL, 4.9333333333333, '2020-10-16 12:30:38', '2020-10-16 17:26:41'),
(53, 2, '2020-10-19 11:41:17', '2020-10-19 18:36:11', NULL, NULL, NULL, 6.9, '2020-10-19 11:41:17', '2020-10-19 18:36:11'),
(54, 19, '2020-10-19 18:01:30', '2020-10-19 18:01:36', NULL, NULL, NULL, 0, '2020-10-19 18:01:30', '2020-10-19 18:01:36'),
(55, 2, '2020-10-20 11:37:36', NULL, NULL, NULL, NULL, NULL, '2020-10-20 11:37:36', NULL),
(56, 19, '2020-10-20 11:41:54', '2020-10-20 11:46:30', NULL, NULL, NULL, 0.066666666666667, '2020-10-20 11:41:54', '2020-10-20 11:46:30'),
(57, 2, '2020-10-21 11:38:26', '2020-10-21 19:03:31', NULL, NULL, NULL, 7.4166666666667, '2020-10-21 11:38:26', '2020-10-21 19:03:31'),
(58, 19, '2020-10-09 11:30:00', '2020-10-09 17:31:00', NULL, NULL, NULL, 6.0166666666667, '2020-10-21 18:48:47', NULL),
(59, 2, '2020-10-22 11:39:03', '2020-10-22 16:52:51', NULL, NULL, NULL, 5.2166666666667, '2020-10-22 11:39:03', '2020-10-22 16:52:51'),
(60, 2, '2020-10-09 11:30:00', '2020-10-22 16:52:51', '2020-10-23 15:00:00', '2020-10-23 16:20:00', NULL, 5.2166666666667, '2020-10-22 12:27:38', '2020-10-22 16:52:51'),
(80, 2, '2020-10-23 16:07:05', '2020-10-23 17:36:27', '2020-10-23 16:10:19', '2020-10-23 16:50:45', NULL, 0.8, '2020-10-23 16:07:05', '2020-10-23 17:36:27'),
(81, 2, '2020-10-26 11:40:51', '2020-10-26 17:32:15', NULL, NULL, NULL, 5.85, '2020-10-26 11:40:51', '2020-10-26 17:32:15'),
(93, 19, '2020-10-26 17:10:21', '2020-10-26 17:13:48', NULL, NULL, NULL, 0.05, '2020-10-26 17:10:21', '2020-10-26 17:13:48'),
(100, 2, '2020-10-27 13:14:24', '2020-10-27 15:26:27', '2020-10-27 15:26:27', NULL, NULL, 2.2, '2020-10-27 13:14:24', '2020-10-27 17:11:27'),
(103, 19, '2020-10-27 15:35:00', '2020-10-27 15:43:00', '2020-10-27 15:37:47', '2020-10-27 15:41:10', 0.016, 0.034, '2020-10-27 15:35:20', '2020-10-29 14:55:19'),
(104, 19, '2020-10-28 17:38:12', '2020-10-28 17:39:53', '2020-10-28 17:39:41', '2020-10-28 17:39:45', 0, 0.016666666666667, '2020-10-28 17:38:12', '2020-10-28 17:39:53'),
(105, 2, '2020-10-29 11:30:00', '2020-10-29 17:08:00', NULL, NULL, NULL, 5.6333333333333, '2020-10-29 12:34:03', '2020-10-29 17:08:28'),
(106, 19, '2020-10-29 12:34:00', NULL, '2020-10-29 12:55:47', NULL, 0, 3.3166666666667, '2020-10-29 12:34:18', '2020-10-29 18:04:07'),
(107, 19, '2020-10-30 11:39:00', '2020-10-30 13:39:00', NULL, NULL, NULL, 2, '2020-10-30 11:39:53', '2020-10-30 12:38:23'),
(108, 2, '2020-10-30 11:40:00', '2020-10-30 12:47:00', '2020-10-30 12:40:21', '2020-10-30 12:44:43', 0.032666666666667, 1.0006666666667, '2020-10-30 11:40:11', '2020-10-30 12:46:21'),
(109, 14, '2020-10-30 16:40:02', NULL, '2020-10-30 17:18:12', '2020-10-30 17:35:09', 0.26666666666667, 0.63333333333333, '2020-10-30 16:40:02', '2020-10-30 17:35:09');

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

--
-- Estrutura da tabela `justificar_falta`
--

CREATE TABLE `justificar_falta` (
  `id` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `assunto` varchar(255) NOT NULL,
  `mensagem` varchar(1000) NOT NULL,
  `arquivo` varchar(255) DEFAULT NULL,
  `data` timestamp NULL DEFAULT NULL,
  `situacao` enum('Pendente','Aprovada','Negada') NOT NULL DEFAULT 'Pendente',
  `retorno` varchar(1000) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Extraindo dados da tabela `justificar_falta`
--

INSERT INTO `justificar_falta` (`id`, `id_user`, `assunto`, `mensagem`, `arquivo`, `data`, `situacao`, `retorno`, `created_at`, `updated_at`) VALUES
(1, 2, 'Teste affesfj af efh akea f efksfh afk fksefeaf fsefTeste affesfj af efh akea f efksfh afk fksefeaf fsefTeste affesfj af efh akea f efksfh afk fksefeaf fsefTeste affesfj af efh akea f efksfh afk fksefeaf fsefTeste affesfj af efh akea f efksfh afk fksefeaf', 'tatata sfdasd faf afatatata sfdasd faf afatatata sfdasd faf afatatata sfdasd faf afatatata sfdasd faf afatatata sfdasd faf afatatata sfdasd faf afatatata sfdasd faf afadfseftatata sfdasd faf afatatata sfdasd faf afatatata sfdasd faf afatatata sfdasd faf afatatata sfdasd faf afatatata sfdasd faf afatatata sfdasd faf afatatata sfdasd faf afatatata sfdasd faf afadfseftatata sfdasd faf afatatata sfdasd faf afatatata sfdasd faf afatatata sfdasd faf afatatata sfdasd faf afatatata sfdasd faf afatatata sfdasd faf afatatata sfdasd faf afatatata sfdasd faf afadfseftatata sfdasd faf afatatata sfdasd faf afatatata sfdasd faf afatatata sfdasd faf afatatata sfdasd faf afatatata sfdasd faf afatatata sfdasd faf afatatata sfdasd faf afatatata sfdasd faf afadfseftatata sfdasd faf afatatata sfdasd faf afatatata sfdasd faf afatatata sfdasd faf afatatata sfdasd faf afatatata sfdasd faf afatatata sfdasd faf afatatata sfdasd faf afatatata sfdasd faf afadfseftatata sfdasd faf afatatata sfdasd faf afatatata s', '/storage/justificar_falta/133843202010135f85d813c13ef.jpeg', '2020-10-13 03:00:00', 'Pendente', NULL, '2020-10-23 16:38:44', NULL),
(3, 2, 'testeeee', 'fdfsrararar', NULL, '2020-10-15 03:00:00', 'Aprovada', 'teste teste teste teste teste', '2020-10-14 16:16:18', NULL),
(5, 2, 'teste 03', '5', NULL, '2020-10-14 03:00:00', 'Negada', 'teste 03', '2020-10-15 15:41:13', '2020-10-21 14:57:34'),
(6, 2, 'teste 04', '6', '/storage/justificar_falta/124217202010155f886dd90b621.png', '2020-10-15 03:00:00', 'Negada', 'rdgsrdgsdrg', '2020-10-15 15:42:17', NULL),
(7, 2, 'Teste 05', '8', '/storage/justificar_falta/124257202010155f886e013f2ca.png', '2020-10-15 03:00:00', 'Aprovada', 'aprovei, tá?', '2020-10-15 15:42:57', '2020-10-22 14:24:37'),
(8, 2, 'testezin', 'test', '/storage/justificar_falta/094332202010165f899574e81c0.png', '2020-10-17 03:00:00', 'Aprovada', 'Aprovada pra testre tá Brenaa', '2020-10-16 12:43:33', '2020-10-21 17:00:12'),
(11, 19, 'sdfasd', 'fasdfads', '/storage/justificar_falta/152514202010195f8dda0ade0d8.png', '2020-10-09 03:00:00', 'Negada', 'AGr aprovado ok aprove aquiii Neguei', '2020-10-19 18:25:15', '2020-10-22 14:23:14'),
(16, 19, 'jtfjyfj', 'ygtjgyjyyyyyy BKNS', '/storage/justificar_falta/122517202010275f983bdd104bb.png', '2020-10-27 03:00:00', 'Negada', 'ok negada', '2020-10-27 15:25:17', '2020-10-27 15:27:22');

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

--
-- Estrutura da tabela `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Índices para tabelas despejadas
--

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

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

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

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

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

--
-- AUTO_INCREMENT de tabelas despejadas
--

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

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

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

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

--
-- AUTO_INCREMENT de tabela `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
COMMIT;

