 CREATE TABLE `republica` (
   `id` int(5) NOT NULL,
   `name` varchar(25) NOT NULL,
-  `creation` date NOT NULL,
-  `type` varchar(10) NOT NULL,
-  `state` varchar(20) NOT NULL,
-  `city` varchar(30) NOT NULL,
-  `street` varchar(25) NOT NULL,
-  `neighboor` varchar(20) NOT NULL,
-  `complement` varchar(10) NOT NULL,
-  `email` varchar(25) NOT NULL,
-  `phone` varchar(20) NOT NULL,
-  `cellphone` varchar(20) NOT NULL,
+  `type` varchar(10) CHARACTER SET latin1 NOT NULL,
+  `state` varchar(20) CHARACTER SET latin1 NOT NULL,
+  `city` varchar(30) CHARACTER SET latin1 NOT NULL,
+  `street` varchar(45) CHARACTER SET latin1 NOT NULL,
+  `neighboor` varchar(20) CHARACTER SET latin1 NOT NULL,
+  `complement` varchar(15) CHARACTER SET latin1 NOT NULL,
+  `email` varchar(45) CHARACTER SET latin1 NOT NULL,
+  `phone` varchar(20) CHARACTER SET latin1 NOT NULL,
+  `cellphone` varchar(20) CHARACTER SET latin1 NOT NULL,
   `qtd` int(2) NOT NULL,
-  `services` varchar(80) NOT NULL,
-  `agency` varchar(20) NOT NULL,
-  `able` varchar(20) NOT NULL,
-  `img_id` int(6) NOT NULL,
-  `img_name` varchar(40) NOT NULL,
-  `img_date` date NOT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+  `services` varchar(80) CHARACTER SET latin1 NOT NULL,
+  `agency` varchar(20) CHARACTER SET latin1 NOT NULL,
+  `able` varchar(20) CHARACTER SET latin1 NOT NULL,
+  `img_name` varchar(40) CHARACTER SET latin1 NOT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
 --
 -- Extraindo dados da tabela `republica`
 --
 
-INSERT INTO `republica` (`id`, `name`, `creation`, `type`, `state`, `city`, `street`, `neighboor`, `complement`, `email`, `phone`, `cellphone`, `qtd`, `services`, `agency`, `able`, `img_id`, `img_name`, `img_date`) VALUES
-(8661, 'Rep do Amor', '2017-05-30', 'Masculina', 'Minas Gerais', 'Cidades MG', 'Rua Miguel Albano, 2071', 'Abc', '', 'adlerunifei@gmail.com', '35991226598', '358896654', 5, 'nada', 'locadora', '', 96508, 'fccf40b5e80dfaf6605b9d7055b27fd2.jpg', '2017-05-29');
+INSERT INTO `republica` (`id`, `name`, `type`, `state`, `city`, `street`, `neighboor`, `complement`, `email`, `phone`, `cellphone`, `qtd`, `services`, `agency`, `able`, `img_name`) VALUES
+(1645, 'RepÃºblica DebÃ´nio', 'Mista', 'Minas Gerais', 'Cidades SP', 'Rua AntÃ´nio Alves de Almeida, 200', 'Alves CÃ¢ntara', 'Casa', 'vitaumsky@gmail.com', '', '', 8, 'Piscina, TV a Cabo', 'Free Wings', '', 'd21efa095a8bb4fdd690a3b05d0b8c16.jpg');
 
 -- --------------------------------------------------------
 

-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: 31-Maio-2017 às 01:32
-- Versão do servidor: 10.1.22-MariaDB
-- PHP Version: 7.1.4


  `birthday` date NOT NULL,
  `password` varchar(16) NOT NULL,
  `confirmpassword` varchar(16) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Estrutura da tabela `avaliacao`
--

CREATE TABLE `avaliacao` (
  `id` int(8) NOT NULL,
  `id_rep` int(8) NOT NULL,
  `date` date NOT NULL,
  `description` varchar(180) NOT NULL,
  `value` int(5) NOT NULL,
  `user_id` int(8) NOT NULL,
  `image_name` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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