   ADD PRIMARY KEY (`user`);
 
 --
+-- Indexes for table `avaliacao`
+--
+ALTER TABLE `avaliacao`
+  ADD PRIMARY KEY (`id`),
+  ADD KEY `avaliacao_id_rep` (`id_rep`),
+  ADD KEY `avaliacao_usuario_id` (`user_id`);
+
+--
 -- Indexes for table `gastos`
 --
 ALTER TABLE `gastos`
-  ADD PRIMARY KEY (`id`);
+  ADD PRIMARY KEY (`id`),
+  ADD KEY `gastos_id_rep` (`id_rep`);
 
 --
 -- Indexes for table `republica`

--

CREATE TABLE `usuario` (
  `user` varchar(10) NOT NULL,
  `name` varchar(20) NOT NULL,
  `lastname` varchar(30) NOT NULL,
  `email` varchar(35) NOT NULL,
  `password` varchar(16) NOT NULL,
  `confirmpassword` varchar(16) NOT NULL,
  `birthday` date NOT NULL,
  `type` varchar(15) NOT NULL,
  `cod_image` int(15) NOT NULL,
  `name_image` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Extraindo dados da tabela `usuario`
--

INSERT INTO `usuario` (`user`, `name`, `lastname`, `email`, `password`, `confirmpassword`, `birthday`, `type`, `cod_image`, `name_image`) VALUES
('2442', 'adler', 'diniz', 'adlerunifei@gmail.com', '123', '123', '1980-01-03', '', 0, '');

--
-- Indexes for dumped tables

CREATE TABLE `republica` (
  `id` int(5) NOT NULL,
  `name` varchar(25) 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) 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`, `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');

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

