XMQqiLjy

1-- phpMyAdmin SQL Dump
2-- version 4.1.14
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: 27-Set-2016 às 16:09
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: `esportbd`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Estrutura da tabela `events`
27--
28
29CREATE TABLE IF NOT EXISTS `events` (
30  `id` int(11) NOT NULL AUTO_INCREMENT,
31  `name` varchar(155) COLLATE utf8_bin NOT NULL,
32  `date` date NOT NULL,
33  `locationId` int(11) NOT NULL,
34  `adress` varchar(255) COLLATE utf8_bin NOT NULL,
35  `localeId` int(11) NOT NULL,
36  `typeCamp` int(3) NOT NULL,
37  `situation` int(3) NOT NULL,
38  PRIMARY KEY (`id`)
39) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;
40
41-- --------------------------------------------------------
42
43--
44-- Estrutura da tabela `games`
45--
46
47CREATE TABLE IF NOT EXISTS `games` (
48  `id` int(11) NOT NULL AUTO_INCREMENT,
49  `name` varchar(155) COLLATE utf8_bin NOT NULL,
50  `genreId` int(11) NOT NULL,
51  `maxPlayers` int(11) NOT NULL,
52  `minPlayers` int(11) NOT NULL,
53  PRIMARY KEY (`id`)
54) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;
55
56-- --------------------------------------------------------
57
58--
59-- Estrutura da tabela `genres`
60--
61
62CREATE TABLE IF NOT EXISTS `genres` (
63  `id` int(11) NOT NULL AUTO_INCREMENT,
64  `name` varchar(255) COLLATE utf8_bin NOT NULL,
65  PRIMARY KEY (`id`)
66) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;
67
68-- --------------------------------------------------------
69
70--
71-- Estrutura da tabela `location`
72--
73
74CREATE TABLE IF NOT EXISTS `location` (
75  `id` int(11) NOT NULL,
76  `name` varchar(35) COLLATE utf8_bin NOT NULL
77) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
78
79-- --------------------------------------------------------
80
81--
82-- Estrutura da tabela `news`
83--
84
85CREATE TABLE IF NOT EXISTS `news` (
86  `id` int(11) NOT NULL AUTO_INCREMENT,
87  `name` varchar(50) COLLATE utf8_bin NOT NULL,
88  `topic` varchar(75) COLLATE utf8_bin NOT NULL,
89  `text` text COLLATE utf8_bin NOT NULL,
90  `author` int(11) NOT NULL,
91  `date` date NOT NULL,
92  PRIMARY KEY (`id`)
93) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;
94
95-- --------------------------------------------------------
96
97--
98-- Estrutura da tabela `user`
99--
100
101CREATE TABLE IF NOT EXISTS `user` (
102  `id` int(11) NOT NULL AUTO_INCREMENT,
103  `nome` varchar(50) COLLATE utf8_bin NOT NULL,
104  `username` varchar(100) COLLATE utf8_bin NOT NULL,
105  `email` varchar(255) COLLATE utf8_bin NOT NULL,
106  `type` int(3) NOT NULL,
107  `password` varchar(255) COLLATE utf8_bin NOT NULL,
108  `situation` int(3) NOT NULL,
109  PRIMARY KEY (`id`)
110) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;
111
112-- --------------------------------------------------------
113
114--
115-- Estrutura da tabela `user_events`
116--
117
118CREATE TABLE IF NOT EXISTS `user_events` (
119  `eventId` int(11) NOT NULL,
120  `userId` int(11) NOT NULL,
121  `situation` int(11) NOT NULL
122) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
123
124/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
125/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
126/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;