-- https://www.phpmyadmin.net/
--
-- Versão do servidor: 5.7.32-35-log

START TRANSACTION;



--
-- Database: `usuariosdsm`
--

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

--
-- Estrutura da tabela `usuarios`
--

CREATE TABLE `usuarios` (
  `id` int(11) NOT NULL,
  `nome` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `email` varchar(50) COLLATE latin1_general_ci DEFAULT NULL,
  `acesso0` int(1) NOT NULL,
  `acesso1` int(1) NOT NULL,
  `acesso2` int(1) NOT NULL,
  `acesso3` int(1) NOT NULL,
  `acesso4` int(1) NOT NULL,
  `acesso5` int(1) NOT NULL,
  `acesso6` int(1) NOT NULL,
  `acesso7` int(1) NOT NULL,
  `acesso8` int(1) NOT NULL,
  `custo1` int(1) NOT NULL,
  `custo2` int(1) NOT NULL,
  `custo3` int(1) NOT NULL,
  `login` varchar(15) COLLATE latin1_general_ci NOT NULL,
  `senha` varchar(15) COLLATE latin1_general_ci NOT NULL,
  `criado` datetime(2) NOT NULL,
  `IPcriado` varchar(15) COLLATE latin1_general_ci NOT NULL,
  `alterado` datetime(2) NOT NULL,
  `IPalterado` varchar(15) COLLATE latin1_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Extraindo dados da tabela `usuarios`
--

INSERT INTO `usuarios` (`id`, `nome`, `email`, `acesso0`, `acesso1`, `acesso2`, `acesso3`, `acesso4`, `acesso5`, `acesso6`, `acesso7`, `acesso8`, `custo1`, `custo2`, `custo3`, `login`, `senha`, `criado`, `IPcriado`, `alterado`, `IPalterado`) VALUES
(6, 'Danilo Faria', 'ti@transwar.com.br', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 'danilo.faria', 'danil0', '2020-03-26 16:24:00.00', '201.68.79.143', '2020-04-17 18:21:00.00', '189.111.61.146'),
(23, 'Daniel Lopes', 'daniel.lopes@transwar.com.br', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 'daniel.lopes', 'war.1234', '2020-04-13 15:52:00.00', '192.168.0.61', '2020-07-24 10:21:00.00', '192.168.0.61'),
(25, 'Ana Souza', 'ana.souza@transwar.com.br', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 'ana.souza', 'war.123', '2020-05-12 14:39:00.00', '192.168.0.120', '2020-05-14 13:58:00.00', '192.168.0.155'),
(26, 'sac _Trans War', 'comercial@transwar.com.br', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 'sac.transwar', 'war.123', '2020-05-12 14:43:00.00', '192.168.0.120', '2020-05-15 14:39:00.00', '192.168.0.155'),
(27, 'David Santos', 'david.Santos@dsm.com', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 'david.santos', 'dsm1234', '2020-05-14 14:00:00.00', '192.168.0.155', '2020-08-20 17:08:00.00', '187.103.168.11'),
(28, 'Mauricio Siqueira', 'Mauricio.Siqueira@DSM.COM', 0, 0, 1, 1, 1, 1, 1, 0, 1, 1, 1, 1, 'Mauricio.Siquei', 'dsm123', '2020-05-14 14:13:00.00', '187.103.164.87', '2022-11-16 09:00:00.00', '179.125.133.81'),
(29, 'Ana Bressan', 'Ana.Bressan@dsm.com', 0, 0, 1, 1, 1, 0, 0, 0, 1, 1, 1, 1, 'ana.bressan', 'dsm1234', '2020-05-14 14:16:00.00', '187.103.164.87', '2020-05-19 12:08:00.00', '187.103.164.87'),
(30, 'Henrique', 'henrique.santos-datrino@dsm.com', 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 1, 'Henrique.datrin', 'dsm1234', '2020-05-15 15:46:00.00', '187.103.164.87', '2020-05-15 15:46:00.00', '187.103.164.87'),
(31, 'Bruno Navarro', 'bruno.navarro@dsm.com', 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 1, 'bruno.navarro', 'dsm1234', '2020-05-15 17:24:00.00', '187.103.164.87', '2020-05-15 17:24:00.00', '187.103.164.87'),
(32, 'Rosane Carvalho', 'Rosane.Carvalho@dsm.com', 0, 0, 1, 1, 1, 0, 0, 0, 1, 1, 1, 1, 'rosane.carvalho', 'dsm1234', '2020-05-19 10:24:00.00', '187.103.164.87', '2020-05-19 12:08:00.00', '187.103.164.87'),
(33, 'Tania Montezano', 'tania.montezano@dsm.com', 0, 0, 1, 1, 1, 0, 0, 0, 1, 1, 1, 1, 'tania.montezano', 'dsm1234', '2020-05-19 10:25:00.00', '187.103.164.87', '2020-05-19 12:08:00.00', '187.103.164.87'),
(34, 'Angelica Garcia', 'Angelica.Garcia@dsm.com', 0, 0, 1, 1, 1, 0, 0, 0, 1, 1, 1, 1, 'angelica.garcia', 'dsm1234', '2020-05-19 10:26:00.00', '187.103.164.87', '2020-05-19 12:08:00.00', '187.103.164.87'),
(35, 'Camila Lopes', 'Camila.Lopes@dsm.com', 0, 0, 1, 1, 1, 0, 0, 0, 1, 1, 1, 1, 'camila.lopes', 'dsm1234', '2020-05-19 10:26:00.00', '187.103.164.87', '2020-05-19 12:07:00.00', '187.103.164.87'),
(36, 'Renato Martins', 'Renato.Martins@dsm.com', 0, 0, 1, 1, 1, 0, 0, 0, 1, 1, 1, 1, 'renato.martins', 'dsm1234', '2020-05-19 11:07:00.00', '187.103.164.87', '2020-05-19 12:07:00.00', '187.103.164.87'),
(37, 'Juliane Brianezi', 'Juliane.Brianezi@dsm.com', 0, 0, 1, 1, 1, 0, 0, 0, 1, 1, 1, 1, 'juliane.brianez', 'dsm1234', '2020-05-22 16:52:00.00', '187.103.164.87', '2020-05-22 16:52:00.00', '187.103.164.87'),
(38, 'Jerry Sun', 'jerry.sun@transwar.com.br', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 'Jerry Sun', 'war.1234', '2020-06-03 13:17:00.00', '192.168.0.96', '2020-07-24 10:25:00.00', '192.168.0.170'),
(39, 'Tauany Leal', 'Tauany.Leal@dsm.com', 0, 0, 1, 1, 1, 0, 0, 0, 1, 1, 1, 1, 'tauany.leal', 'dsm1234', '2020-06-04 15:12:00.00', '177.25.192.233', '2020-06-04 15:12:00.00', '177.25.192.233'),
(40, 'Paulo Faria', 'paulo.faria@transwar.com.br', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 'paulo.faria', 'adm2278', '2020-11-10 09:24:00.00', '189.46.184.243', '2020-11-12 14:15:00.00', '189.46.184.243'),
(41, 'Danilo Loures', 'danilo.loures@dsm.com', 0, 0, 1, 1, 1, 0, 0, 0, 0, 1, 1, 1, 'danilo.loures', 'dsm123', '2021-10-25 16:37:00.00', '187.103.165.33', '2021-10-25 16:37:00.00', '187.103.165.33'),
(42, 'Leticia Laitano ', 'leticia.laitano@dsm.com', 0, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 1, 'Leticia.Laitano', 'DSM123', '2022-02-09 13:27:00.00', '45.236.136.50', '2022-02-09 13:27:00.00', '45.236.136.50');

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

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

