SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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 */;


--
-- Banco de dados: `painelfelipe`
--
CREATE DATABASE IF NOT EXISTS `painelfelipe` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
USE `painelfelipe`;


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


--
-- Estrutura para tabela `ledfelipe`
--


CREATE TABLE `ledfelipe` (
  `idledfelipe` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `nome` varchar(35) DEFAULT NULL,
  `pinor` int(10) UNSIGNED DEFAULT NULL,
  `pinog` int(10) UNSIGNED DEFAULT NULL,
  `pinob` int(10) UNSIGNED DEFAULT NULL,
  PRIMARY KEY (`idledfelipe`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;


--
-- Despejando dados para a tabela `ledfelipe`
--


INSERT INTO `ledfelipe` (`idledfelipe`, `nome`, `pinor`, `pinog`, `pinob`) VALUES
(1, 'Led do felipe', 5, 6, 7),
(3, 'Teste um', 12, 14, 15);


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


--
-- Estrutura para tabela `macfelipe`
--


CREATE TABLE `macfelipe` (
  `idmacfelipe` varchar(17) NOT NULL,
  `nome` varchar(35) DEFAULT NULL,
  `ativo` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`idmacfelipe`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;


--
-- Despejando dados para a tabela `macfelipe`
--


INSERT INTO `macfelipe` (`idmacfelipe`, `nome`, `ativo`) VALUES
('38:2B:78:03:A6:32', 'Placa do felipe', 1);


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


--
-- Estrutura para tabela `painelfelipe`
--


CREATE TABLE `painelfelipe` (
  `idpainelfelipe` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `nome` varchar(50) DEFAULT NULL,
  `datainicio` datetime DEFAULT NULL,
  `datafim` datetime DEFAULT NULL,
  PRIMARY KEY (`idpainelfelipe`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;


--
-- Despejando dados para a tabela `painelfelipe`
--


INSERT INTO `painelfelipe` (`idpainelfelipe`, `nome`, `datainicio`, `datafim`) VALUES
(1, 'Painel da aula do dia 18/09', '2026-09-18 14:00:00', '2026-09-18 23:59:59'),
(2, 'Painel da aula do dia 24/09', '2026-09-24 00:00:04', '2026-09-24 23:59:59'),
(3, 'Teste Painel Um', '2026-09-29 15:10:07', '2026-09-29 15:10:07');


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


--
-- Estrutura para tabela `combinafelipe`
--


CREATE TABLE `combinafelipe` (
  `idcombinafelipe` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `ledfelipe_idledfelipe` int(10) UNSIGNED NOT NULL,
  `painelfelipe_idpainelfelipe` int(10) UNSIGNED NOT NULL,
  `macfelipe_idmacfelipe` varchar(17) NOT NULL,
  `ledr` int(10) UNSIGNED DEFAULT NULL,
  `ledg` int(10) UNSIGNED DEFAULT NULL,
  `ledb` int(10) UNSIGNED DEFAULT NULL,
  PRIMARY KEY (`idcombinafelipe`),
  KEY `combinafelipe_FKIndex1` (`macfelipe_idmacfelipe`),
  KEY `combinafelipe_FKIndex2` (`painelfelipe_idpainelfelipe`),
  KEY `combinafelipe_FKIndex3` (`ledfelipe_idledfelipe`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;


--
-- Despejando dados para a tabela `combinafelipe`
--


INSERT INTO `combinafelipe` (`idcombinafelipe`, `ledfelipe_idledfelipe`, `painelfelipe_idpainelfelipe`, `macfelipe_idmacfelipe`, `ledr`, `ledg`, `ledb`) VALUES
(1, 1, 1, '38:2B:78:03:A6:32', 255, 0, 0),
(5, 1, 3, '38:2B:78:03:A6:32', 0, 0, 255);


--
-- Restrições para tabelas despejadas
--


--
-- Restrições para tabelas `combinafelipe`
--
ALTER TABLE `combinafelipe`
  ADD CONSTRAINT `combinafelipe_ibfk_1` FOREIGN KEY (`macfelipe_idmacfelipe`) REFERENCES `macfelipe` (`idmacfelipe`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `combinafelipe_ibfk_2` FOREIGN KEY (`painelfelipe_idpainelfelipe`) REFERENCES `painelfelipe` (`idpainelfelipe`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `combinafelipe_ibfk_3` FOREIGN KEY (`ledfelipe_idledfelipe`) REFERENCES `ledfelipe` (`idledfelipe`) 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 */;