text: CREATE DATABASE  IF NOT EXISTS `bd_unicorn` /*!40100 DEFAULT CHARACTER SET utf8 */;
  USE `bd_unicorn`;
  -- MySQL dump 10.13  Distrib 5.7.17, for Win64 (x86_64)
  --
  -- Host: 127.0.0.1    Database: bd_unicorn
  -- ------------------------------------------------------
  -- Server version	5.5.5-10.1.32-MariaDB
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  /*!40101 SET NAMES utf8 */;
  /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  /*!40103 SET TIME_ZONE='+00:00' */;
  /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  
  --
  -- Table structure for table `aeroporto`
  --
  
  DROP TABLE IF EXISTS `aeroporto`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `aeroporto` (
    `registro` int(11) NOT NULL AUTO_INCREMENT,
    `nome` varchar(50) NOT NULL,
    `cidade` varchar(50) NOT NULL,
    `estado` varchar(50) NOT NULL,
    PRIMARY KEY (`registro`)
  ) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `aeroporto`
  --
  
  LOCK TABLES `aeroporto` WRITE;
  /*!40000 ALTER TABLE `aeroporto` DISABLE KEYS */;
  INSERT INTO `aeroporto` VALUES (21,'Aeroporto Sant\'ana','Ponta Grossa','PR'),(22,'Aeroporto Internacional Afonso Pena','Curitiba','PR');
  /*!40000 ALTER TABLE `aeroporto` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `aviao`
  --
  
  DROP TABLE IF EXISTS `aviao`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `aviao` (
    `registro` varchar(10) NOT NULL,
    `modelo` varchar(50) NOT NULL,
    `qtd_assentos` int(11) NOT NULL,
    `qtd_assentos_esp` int(11) NOT NULL,
    PRIMARY KEY (`registro`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `aviao`
  --
  
  LOCK TABLES `aviao` WRITE;
  /*!40000 ALTER TABLE `aviao` DISABLE KEYS */;
  INSERT INTO `aviao` VALUES ('AAA-CB','AAA-CB',140,40),('AAA-PG','AAA-PG',140,40);
  /*!40000 ALTER TABLE `aviao` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `passagem`
  --
  
  DROP TABLE IF EXISTS `passagem`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `passagem` (
    `id_passagem` int(11) NOT NULL AUTO_INCREMENT,
    `tipo` varchar(45) NOT NULL,
    `origem` varchar(45) NOT NULL,
    `destino` varchar(45) NOT NULL,
    `data` date NOT NULL,
    `plataforma` varchar(45) NOT NULL,
    `valor` float NOT NULL,
    `rg` varchar(45) NOT NULL,
    `cpf` varchar(45) NOT NULL,
    `nome` varchar(100) NOT NULL,
    `hora` varchar(45) NOT NULL,
    PRIMARY KEY (`id_passagem`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `passagem`
  --
  
  LOCK TABLES `passagem` WRITE;
  /*!40000 ALTER TABLE `passagem` DISABLE KEYS */;
  INSERT INTO `passagem` VALUES (2,'Comum','Ponta Grossa','Curitiba','2018-06-25','PAAA-CB',100,'13.705.383-7','108.488.689-86','Lucas Vanjura','08:08:00');
  /*!40000 ALTER TABLE `passagem` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `rota`
  --
  
  DROP TABLE IF EXISTS `rota`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `rota` (
    `id_rota` int(11) NOT NULL AUTO_INCREMENT,
    `origem` varchar(100) NOT NULL,
    `destino` varchar(100) NOT NULL,
    `preco_c` float NOT NULL,
    `preco_e` float NOT NULL,
    PRIMARY KEY (`id_rota`)
  ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `rota`
  --
  
  LOCK TABLES `rota` WRITE;
  /*!40000 ALTER TABLE `rota` DISABLE KEYS */;
  INSERT INTO `rota` VALUES (6,'Aeroporto Sant\'ana','Aeroporto Internacional Afonso Pena',100,90),(7,'Aeroporto Internacional Afonso Pena','Aeroporto Sant\'ana',100,90);
  /*!40000 ALTER TABLE `rota` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `usuario`
  --
  
  DROP TABLE IF EXISTS `usuario`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `usuario` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `nome` varchar(50) NOT NULL,
    `senha` varchar(100) NOT NULL,
    `nivel` int(11) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `usuario`
  --
  
  LOCK TABLES `usuario` WRITE;
  /*!40000 ALTER TABLE `usuario` DISABLE KEYS */;
  INSERT INTO `usuario` VALUES (12,'admin','admin',99),(13,'Vanjura','1234',5),(14,'At','1',1);
  /*!40000 ALTER TABLE `usuario` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `voo`
  --
  
  DROP TABLE IF EXISTS `voo`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `voo` (
    `id_voo` int(11) NOT NULL AUTO_INCREMENT,
    `rota` int(11) NOT NULL,
    `aviao` varchar(7) NOT NULL,
    `data` varchar(11) NOT NULL,
    `hora` varchar(45) NOT NULL,
    `ass_c` int(11) NOT NULL,
    `ass_esp` int(11) NOT NULL,
    `preco_c` float NOT NULL,
    `preco_e` float NOT NULL,
    `origem` varchar(100) NOT NULL,
    `destino` varchar(100) NOT NULL,
    PRIMARY KEY (`id_voo`)
  ) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `voo`
  --
  
  LOCK TABLES `voo` WRITE;
  /*!40000 ALTER TABLE `voo` DISABLE KEYS */;
  INSERT INTO `voo` VALUES (34,6,'AAA-PG','2018-06-25','08:08',140,40,100,90,'Ponta Grossa','Curitiba'),(35,7,'AAA-CB','2018-06-25','08:08',140,40,100,90,'Curitiba','Ponta Grossa');
  /*!40000 ALTER TABLE `voo` ENABLE KEYS */;
  UNLOCK TABLES;
  /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
  
  /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  
  -- Dump completed on 2018-06-24 13:57:11
  