-- phpMyAdmin SQL Dump
-- version 4.5.4.1deb2ubuntu2.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: 08-Jul-2025 às 12:48
-- Versão do servidor: 5.7.31-0ubuntu0.16.04.1
-- PHP Version: 7.0.33-0ubuntu0.16.04.16

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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: `encipe`
--

-- --------------------------------------------------------

--
-- Estrutura da tabela `estado`
--

CREATE TABLE `estado` (
  `id` int(11) NOT NULL,
  `id_pais` int(11) NOT NULL,
  `nome` varchar(100) NOT NULL,
  `uf` varchar(2) NOT NULL,
  `data_atualizacao` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Extraindo dados da tabela `estado`
--

INSERT INTO `estado` (`id`, `id_pais`, `nome`, `uf`, `data_atualizacao`) VALUES
(1, 1, 'Rondônia', 'RO', '2016-08-22 13:08:17'),
(2, 1, 'Acre', 'AC', '2016-08-22 13:08:17'),
(3, 1, 'Amazonas', 'AM', '2016-08-22 13:08:17'),
(4, 1, 'Roraima', 'RR', '2016-08-22 13:08:17'),
(5, 1, 'Pará', 'PA', '2016-08-22 13:08:17'),
(6, 1, 'Amapá', 'AP', '2016-08-22 13:08:17'),
(7, 1, 'Tocantis', 'TO', '2016-08-22 13:08:17'),
(8, 1, 'Maranhão', 'MA', '2016-08-22 13:08:17'),
(9, 1, 'Piauí', 'PI', '2016-08-22 13:08:17'),
(10, 1, 'Ceará', 'CE', '2016-08-22 13:08:17'),
(11, 1, 'Rio Grande do Norte', 'RN', '2016-08-22 13:08:17'),
(12, 1, 'Paraíba', 'PB', '2016-08-22 13:08:17'),
(13, 1, 'Pernambuco', 'PE', '2016-08-22 13:08:17'),
(14, 1, 'Alagoas', 'AL', '2016-08-22 13:08:17'),
(15, 1, 'Sergipe', 'SE', '2016-08-22 13:08:17'),
(16, 1, 'Bahia', 'BA', '2016-08-22 13:08:17'),
(17, 1, 'Minas Gerais', 'MG', '2016-08-22 13:08:17'),
(18, 1, 'Espirito Santo', 'ES', '2016-08-22 13:08:17'),
(19, 1, 'Rio de Janeiro', 'RJ', '2016-08-22 13:08:17'),
(20, 1, 'São Paulo', 'SP', '2016-08-22 13:08:17'),
(21, 1, 'Paraná', 'PR', '2016-08-22 13:08:17'),
(22, 1, 'Santa Catarina', 'SC', '2016-08-22 13:08:17'),
(23, 1, 'Rio Grande do Sul', 'RS', '2016-08-22 13:08:17'),
(24, 1, 'Mato Grosso do Sul', 'MS', '2016-08-22 13:08:17'),
(25, 1, 'Mato Grosso', 'MT', '2016-08-22 13:08:17'),
(26, 1, 'Goiás', 'GO', '2016-08-22 13:08:17'),
(27, 1, 'Distrito Federal', 'DF', '2016-08-22 13:08:17');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `estado`
--
ALTER TABLE `estado`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_estado_pais` (`id_pais`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `estado`
--
ALTER TABLE `estado`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;
/*!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 */;
