text: -- phpMyAdmin SQL Dump
  -- version 4.8.5
  -- https://www.phpmyadmin.net/
  --
  -- Host: localhost
  -- Generation Time: Mar 18, 2019 at 01:07 AM
  -- Server version: 10.3.13-MariaDB
  -- PHP Version: 7.3.3
  
  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  SET AUTOCOMMIT = 0;
  START TRANSACTION;
  SET time_zone = "+00:00";
  
  
  /*!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 utf8mb4 */;
  
  --
  -- Database: `academico`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `aluno`
  --
  
  CREATE TABLE `aluno` (
    `id_aluno` int(11) NOT NULL,
    `nome` varchar(100) NOT NULL,
    `data_nascimento` date NOT NULL,
    `logradouro` varchar(200) NOT NULL,
    `numero` varchar(20) NOT NULL,
    `bairro` varchar(50) NOT NULL,
    `cidade` varchar(50) NOT NULL,
    `estado` varchar(20) NOT NULL,
    `data_criacao` date NOT NULL,
    `cep` varchar(10) NOT NULL,
    `id_curso` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `aluno`
  --
  
  INSERT INTO `aluno` (`id_aluno`, `nome`, `data_nascimento`, `logradouro`, `numero`, `bairro`, `cidade`, `estado`, `data_criacao`, `cep`, `id_curso`) VALUES
  (1, 'Dandara Lobo', '1995-04-25', 'Avenida F', '878', 'Flores', 'Manaus', 'AM', '2019-03-17', '', 1);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `curso`
  --
  
  CREATE TABLE `curso` (
    `id_curso` int(11) NOT NULL,
    `nome` varchar(100) NOT NULL,
    `data_criacao` date NOT NULL,
    `id_professor` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `curso`
  --
  
  INSERT INTO `curso` (`id_curso`, `nome`, `data_criacao`, `id_professor`) VALUES
  (1, 'Informática', '2019-03-17', 1);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `professor`
  --
  
  CREATE TABLE `professor` (
    `id_professor` int(11) NOT NULL,
    `nome` varchar(100) NOT NULL,
    `data_nascimento` date NOT NULL,
    `data_criacao` date NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `professor`
  --
  
  INSERT INTO `professor` (`id_professor`, `nome`, `data_nascimento`, `data_criacao`) VALUES
  (1, 'Rafael Alves', '1992-09-19', '2019-03-17');
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indexes for table `aluno`
  --
  ALTER TABLE `aluno`
    ADD PRIMARY KEY (`id_aluno`),
    ADD KEY `id_curso` (`id_curso`);
  
  --
  -- Indexes for table `curso`
  --
  ALTER TABLE `curso`
    ADD PRIMARY KEY (`id_curso`),
    ADD KEY `id_professor` (`id_professor`);
  
  --
  -- Indexes for table `professor`
  --
  ALTER TABLE `professor`
    ADD PRIMARY KEY (`id_professor`);
  
  --
  -- AUTO_INCREMENT for dumped tables
  --
  
  --
  -- AUTO_INCREMENT for table `aluno`
  --
  ALTER TABLE `aluno`
    MODIFY `id_aluno` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  
  --
  -- AUTO_INCREMENT for table `curso`
  --
  ALTER TABLE `curso`
    MODIFY `id_curso` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  
  --
  -- AUTO_INCREMENT for table `professor`
  --
  ALTER TABLE `professor`
    MODIFY `id_professor` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  
  --
  -- Constraints for dumped tables
  --
  
  --
  -- Constraints for table `aluno`
  --
  ALTER TABLE `aluno`
    ADD CONSTRAINT `aluno_ibfk_1` FOREIGN KEY (`id_curso`) REFERENCES `curso` (`id_curso`);
  
  --
  -- Constraints for table `curso`
  --
  ALTER TABLE `curso`
    ADD CONSTRAINT `curso_ibfk_1` FOREIGN KEY (`id_professor`) REFERENCES `professor` (`id_professor`);
  COMMIT;
  
  /*!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 */;
  