--
-- Índices de tabela `leituramiguel`
--
ALTER TABLE `leituramiguel`
  ADD PRIMARY KEY (`idleituramiguel`),
  ADD KEY `leituramiguel_FKIndex1` (`aluno_idaluno`),
  ADD KEY `leituramiguel_FKIndex2` (`mac_idmac`),
  ADD KEY `leituramiguel_FKIndex3` (`sensor_idsensor`);


--
-- Restrições para tabelas `leituramiguel`
--
ALTER TABLE `leituramiguel`
  ADD CONSTRAINT `leituramiguel_ibfk_1` FOREIGN KEY (`aluno_idaluno`) REFERENCES `aluno` (`idaluno`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `leituramiguel_ibfk_2` FOREIGN KEY (`mac_idmac`) REFERENCES `mac` (`idmac`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `leituramiguel_ibfk_3` FOREIGN KEY (`sensor_idsensor`) REFERENCES `sensor` (`idsensor`) ON DELETE NO ACTION ON UPDATE NO ACTION;
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 */;