· 4 years ago · Feb 18, 2021, 02:04 PM
1-- phpMyAdmin SQL Dump
2-- version 4.1.14
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: 08-Out-2018 às 21:20
7-- Versão do servidor: 5.6.17
8-- PHP Version: 5.5.12
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `projeto_mmn`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Estrutura da tabela `patentes`
27--
28
29CREATE TABLE IF NOT EXISTS `patentes` (
30 `id` int(11) NOT NULL AUTO_INCREMENT,
31 `nome` varchar(50) NOT NULL,
32 `min` int(11) NOT NULL,
33 PRIMARY KEY (`id`)
34) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
35
36--
37-- Extraindo dados da tabela `patentes`
38--
39
40INSERT INTO `patentes` (`id`, `nome`, `min`) VALUES
41(1, 'Iniciante', 0),
42(2, 'Junior', 1),
43(3, 'Diretor', 3),
44(4, 'Diretor Senior', 5),
45(5, 'Executivo', 10);
46
47-- --------------------------------------------------------
48
49--
50-- Estrutura da tabela `usuarios`
51--
52
53CREATE TABLE IF NOT EXISTS `usuarios` (
54 `id` int(11) NOT NULL AUTO_INCREMENT,
55 `id_pai` int(11) DEFAULT NULL,
56 `patente` int(11) NOT NULL COMMENT '1',
57 `nome` varchar(100) NOT NULL,
58 `email` varchar(100) NOT NULL,
59 `senha` varchar(32) NOT NULL,
60 PRIMARY KEY (`id`)
61) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=29 ;
62
63--
64-- Extraindo dados da tabela `usuarios`
65--
66
67INSERT INTO `usuarios` (`id`, `id_pai`, `patente`, `nome`, `email`, `senha`) VALUES
68(1, 0, 5, 'sistema', 'sistema@hotmail.com', '698dc19d489c4e4db73e28a713eab07b'),
69(2, 0, 3, 'teste', 'teste@teste.com', '698dc19d489c4e4db73e28a713eab07b'),
70(3, 1, 4, 'silas', 'silastj@hotmail.com', '74c781f169d016e7deea09ca7f3db242'),
71(4, 1, 3, 'amos', 'silastj@gmail.com', '6970ce29488b99d6a3ec1be259371134'),
72(5, 3, 2, 'samara', 'samara@samara.com', 'ebb9cfe31b06bebe3c3ccef5f56e5e89'),
73(6, 3, 2, 'bonito', 'bonito@bonito.com', 'c3abd1fd9b4b5a9abd16a4d536f51b85'),
74(7, 6, 1, 'feio', 'feio@feio.com', 'ae4a115e9c59b2ab0e02460c0b25d356'),
75(8, 2, 1, 'hoje', 'hoje@hoje.com', '8f59f169c4c4edeab7c4e0941fd5db00'),
76(9, 2, 1, 'amanha', 'amanha@amanha.com', 'b197854cbdde13c6e1692cb73762f239'),
77(10, 2, 1, 'depois', 'depois@depois.com', '38925d0f41673f245f7692b29e53a712'),
78(11, 5, 1, 'mae', 'mae@mae.com', 'f6fbc587c39247853a2eb219723a2226'),
79(12, 5, 1, 'pai', 'pai@pai.com', 'da503503729f9b12b00191a1d555cab0'),
80(13, 2, 1, 'novo', 'novo@novo.com', 'e29c5f59032c0a75d3059b95f26b9703'),
81(14, 1, 2, 'oi', 'oi@oi.com.br', 'ea083601c213734241f02c22db82441e'),
82(15, 14, 1, 'vivo', 'vivo@vivo.com.br', '764b50435d176fcb25e110542559dfc6'),
83(16, 4, 2, 'morto', 'morto@morto.com', 'f32307f7e74d5b9a2be324a67926cfb0'),
84(17, 4, 1, 'lindo', 'lindo@bonito.com', '9e1c2754001a041b3f35b16b5db50c55'),
85(18, 16, 1, 'paz', 'paz@paz.com', '1725dd676a95026c24f95556299841d6'),
86(21, 1, 0, 'jair', 'jair@jair.com', '1dcb7811160c72c3da404d32214e9cd8'),
87(22, 21, 0, 'bolsonaro', 'bolsonaro@bolsonaro.com', '7bdec56470a45de633aa2074f5263352'),
88(24, 1, 0, 'Messias', 'messias@messias.com', 'd6c347644993ac5f7e13db3559c3d267'),
89(25, 1, 0, 'santos', 'santos@santos.com', 'ed34b0515aef8f777bb4951f9965d86e'),
90(26, 25, 0, 'palmeiras', 'palmeiras@palmeiras.com', '5b486d7ce8ce4ce5e99d3ecce2d3d010'),
91(27, NULL, 0, 'Pipa', 'pipa@pipa.com', 'c263ded68afbcf928ea873f39db2601a'),
92(28, 2, 0, 'Mundial', 'mundial@mundial.com', '0c939cb0455c73941c0891a7fa8a5963');
93
94/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
95/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
96/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;