YtBb4SQC

1-- phpMyAdmin SQL Dump
2-- version 4.0.10deb1
3-- http://www.phpmyadmin.net
4--
5-- Máquina: localhost
6-- Data de Criação: 28-Jul-2016 às 02:36
7-- Versão do servidor: 5.5.50-0ubuntu0.14.04.1
8-- versão do PHP: 5.5.9-1ubuntu4.17
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-- Base de Dados: `dbMatheus`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Estrutura da tabela `Accounts`
27--
28
29CREATE TABLE IF NOT EXISTS `Accounts` (
30  `userId` int(11) NOT NULL AUTO_INCREMENT,
31  `Name` varchar(30) NOT NULL,
32  `NameLower` varchar(60) NOT NULL,
33  `Password` varchar(255) NOT NULL,
34  `Level` int(255) NOT NULL,
35  `UltimoIP` varchar(255) NOT NULL,
36  `UniqueID` varchar(225) DEFAULT NULL,
37  `UniqueID2` varchar(255) DEFAULT NULL,
38  `RegDate` varchar(255) DEFAULT NULL,
39  `LastVisit` int(255) NOT NULL,
40  `TotalTime` int(255) NOT NULL,
41  PRIMARY KEY (`userId`)
42) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=49 ;
43
44--
45-- Extraindo dados da tabela `Accounts`
46--
47
48-- --------------------------------------------------------
49
50--
51-- Estrutura da tabela `Perfil`
52--
53
54CREATE TABLE IF NOT EXISTS `Perfil` (
55  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
56  `Name` varchar(100) NOT NULL,
57  `NameLower` varchar(50) NOT NULL,
58  `Dinheiro` int(255) NOT NULL,
59  `Banco` int(255) NOT NULL,
60  `Emprego` int(11) NOT NULL,
61  `Sexo` int(11) NOT NULL,
62  PRIMARY KEY (`id`)
63) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=39 ;
64
65--
66-- Extraindo dados da tabela `Perfil`
67--
68
69/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
70/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
71/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;