CREATE TABLE macsamuel (
  idmacsamuel VARCHAR(17) NOT NULL,
  nome VARCHAR(35) NULL,
  ativo BOOL NULL,
  PRIMARY KEY (idmacsamuel)
) ENGINE=InnoDB;

CREATE TABLE painelsamuel (
  idpainelsamuel INTEGER NOT NULL,
  nome VARCHAR(50) NULL,
  datainicio DATETIME NULL,
  datafim DATETIME NULL,
  PRIMARY KEY (idpainelsamuel)
) ENGINE=InnoDB;

CREATE TABLE ledsamuel (
  idledsamuel INTEGER NOT NULL,
  nome VARCHAR(35) NULL,
  pinor INTEGER NULL,
  pinog INTEGER NULL,
  pinob INTEGER NULL,
  PRIMARY KEY (idledsamuel)
) ENGINE=InnoDB;

CREATE TABLE combinasamuel (
  idcombinasamuel INTEGER NOT NULL,
  painelsamuel_idpainelsamuel INTEGER NOT NULL,
  ledsamuel_idledsamuel INTEGER NOT NULL,
  macsamuel_idmacsamuel VARCHAR(17) NOT NULL,
  ledr INTEGER NULL,
  ledg INTEGER NULL,
  ledb INTEGER NULL,
  PRIMARY KEY (idcombinasamuel),
  INDEX combinasamuel_FKIndex1 (macsamuel_idmacsamuel),
  INDEX combinasamuel_FKIndex2 (ledsamuel_idledsamuel),
  INDEX combinasamuel_FKIndex3 (painelsamuel_idpainelsamuel),
  FOREIGN KEY (macsamuel_idmacsamuel)
    REFERENCES macsamuel (idmacsamuel)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  FOREIGN KEY (ledsamuel_idledsamuel)
    REFERENCES ledsamuel (idledsamuel)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  FOREIGN KEY (painelsamuel_idpainelsamuel)
    REFERENCES painelsamuel (idpainelsamuel)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION
) ENGINE=InnoDB;