-- phpMyAdmin SQL Dump
-- version 4.9.2
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Tempo de geração: 12-Fev-2020 às 03:47
-- Versão do servidor: 10.4.11-MariaDB
-- versão do PHP: 7.2.26

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Banco de dados: `login`
--

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

--
-- Estrutura da tabela `loginattempts`
--

CREATE TABLE `loginattempts` (
  `IP` varchar(20) NOT NULL,
  `Attempts` int(11) NOT NULL,
  `LastLogin` datetime NOT NULL,
  `Username` varchar(65) DEFAULT NULL,
  `ID` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `loginattempts`
--

INSERT INTO `loginattempts` (`IP`, `Attempts`, `LastLogin`, `Username`, `ID`) VALUES
('::1', 1, '2020-02-11 20:58:08', '12709472651', 1),
('::1', 2, '2020-02-11 20:09:16', '12345678912', 2),
('::1', 1, '2020-02-11 20:47:07', '96824654604', 3);

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

--
-- Estrutura da tabela `members`
--

CREATE TABLE `members` (
  `id` char(23) NOT NULL,
  `username` varchar(65) NOT NULL DEFAULT '',
  `password` varchar(65) NOT NULL DEFAULT '',
  `email` varchar(65) NOT NULL,
  `verified` tinyint(1) NOT NULL DEFAULT 0,
  `mod_timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `members`
--

INSERT INTO `members` (`id`, `username`, `password`, `email`, `verified`, `mod_timestamp`) VALUES
('13691065365e4301182aeef', '12345678912', '$2y$10$iu8/mdf55NJ.lHR1Px23VOocRk57a8PxxoqY.3kI1P6t1fm0oxP/m', 'higorsrdesign@gmail.com', 1, '2020-02-11 19:34:55'),
('6323249935e4303b69b0e2', '96824654604', '$2y$10$Xa.27lqpaBK8.Nj8m6uDE.z7d7zqztF18XHzXt5giVZcQI2cHu7L6', 'contato@poisson.com.br', 1, '2020-02-11 19:46:26'),
('9147592135e3b3b2080e9b', '12709472651', '$2y$10$QiAuDMGTdYTbGnvvuSAZY./TzbrlfwDSVlQbXwTSXbI0dy1suNOai', 'hsrdrumx@gmail.com', 1, '2020-02-11 18:45:51');

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

--
-- Estrutura da tabela `myblob`
--

CREATE TABLE `myblob` (
  `id` int(11) NOT NULL,
  `name` varchar(255) CHARACTER SET latin1 NOT NULL,
  `mime` varchar(255) CHARACTER SET latin1 NOT NULL,
  `filepath` varchar(255) NOT NULL,
  `user` varchar(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Extraindo dados da tabela `myblob`
--

INSERT INTO `myblob` (`id`, `name`, `mime`, `filepath`, `user`) VALUES
(1, 'Certificado - Gestao Ambiental Volume 1.docx', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document', 'uploads/Certificado - Gestao Ambiental Volume 1.docx', '12709472651'),
(2, '82852.docx', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document', 'uploads/82852.docx', '96824654604'),
(3, '80620.docx', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document', 'uploads/80620.docx', '96824654604'),
(4, '80620 - gráficos-do-.docx', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document', 'uploads/80620 - gráficos-do-.docx', '96824654604'),
(5, '82852.docx', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document', 'uploads/82852.docx', '96824654604'),
(6, 'Certificado - Gestao Ambiental Volume 1.docx', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document', 'uploads/Certificado - Gestao Ambiental Volume 1.docx', '12709472651');

--
-- Índices para tabelas despejadas
--

--
-- Índices para tabela `loginattempts`
--
ALTER TABLE `loginattempts`
  ADD PRIMARY KEY (`ID`);

--
-- Índices para tabela `members`
--
ALTER TABLE `members`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `username_UNIQUE` (`username`),
  ADD UNIQUE KEY `id_UNIQUE` (`id`),
  ADD UNIQUE KEY `email_UNIQUE` (`email`);

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

--
-- AUTO_INCREMENT de tabelas despejadas
--

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

--
-- AUTO_INCREMENT de tabela `myblob`
--
ALTER TABLE `myblob`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
