qAExYw1t

1-- phpMyAdmin SQL Dump
2-- version 3.4.9
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Dec 12, 2017 at 10:11 AM
7-- Server version: 5.5.20
8-- PHP Version: 5.3.9
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: `costalandia`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `diversoes`
27--
28
29CREATE TABLE IF NOT EXISTS `diversoes` (
30  `IdDiversao` int(10) unsigned NOT NULL AUTO_INCREMENT,
31  `NomeDiversao` varchar(45) NOT NULL,
32  `IdadeMinima` int(10) unsigned NOT NULL,
33  `Altura` decimal(10,0) NOT NULL,
34  `Velocidade` varchar(45) NOT NULL,
35  `Lotacao` int(10) unsigned NOT NULL,
36  `LocalDiversao` varchar(45) NOT NULL,
37  PRIMARY KEY (`IdDiversao`)
38) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
39
40--
41-- Dumping data for table `diversoes`
42--
43
44INSERT INTO `diversoes` (`IdDiversao`, `NomeDiversao`, `IdadeMinima`, `Altura`, `Velocidade`, `Lotacao`, `LocalDiversao`) VALUES
45(1, 'Roda Gigante', 2, 1, '10', 50, 'Zona 1'),
46(2, 'Montanha Russa', 12, 2, '80', 24, 'Zona 2'),
47(3, 'Super Man', 12, 2, '100', 40, 'Zona 3');
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 */;