2500QNvQ

1-- phpMyAdmin SQL Dump
2-- version 4.1.14
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: 10-Fev-2016 às 20:24
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: `db_yugiohgame`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Estrutura da tabela `users`
27--
28
29CREATE TABLE IF NOT EXISTS `users` (
30  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
31  `name` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
32  `password` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
33  `email` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
34  `gender` enum('m','f') COLLATE utf8_unicode_ci NOT NULL,
35  `birthdate` date NOT NULL,
36  `nickname` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
37  PRIMARY KEY (`id`)
38) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=15 ;
39
40--
41-- Extraindo dados da tabela `users`
42--
43
44INSERT INTO `users` (`id`, `name`, `password`, `email`, `gender`, `birthdate`, `nickname`) VALUES
45(12, 'João Pedro Carpanezi dos Santos', '123456', 'jpcarpanezi@gmail.com', 'm', '2000-11-20', 'jpcarpanezi'),
46(13, 'Usuário 1', '2d29b962490320f821db80cddf6ed4b6e4ac7498', 'jpcarpanezi@gmail.com', 'm', '0000-00-00', ''),
47(14, 'João Pedro Carpanezi dos Santos', '2d29b962490320f821db80cddf6ed4b6e4ac7498', 'pinto@gmail.com', 'm', '2000-11-20', 'jpcarpanezi');
48
49/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
50/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
51/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;