CREATE TABLE painelmiguel (
  idpainelmiguel INTEGER UNSIGNED  NOT NULL   AUTO_INCREMENT,
  nome VARCHAR(50)  NULL  ,
  datainicio DATETIME  NULL  ,
  datafim DATETIME  NULL    ,
PRIMARY KEY(idpainelmiguel));



CREATE TABLE macmiguel (
  idmacmiguel VARCHAR(17)  NOT NULL  ,
  nome VARCHAR(35)  NULL  ,
  ativo BOOL  NULL    ,
PRIMARY KEY(idmacmiguel));



CREATE TABLE ledmiguel (
  idledmiguel INTEGER UNSIGNED  NOT NULL   AUTO_INCREMENT,
  nome VARCHAR(35)  NULL  ,
  pinor INTEGER UNSIGNED  NULL  ,
  pinog INTEGER UNSIGNED  NULL  ,
  pinob INTEGER UNSIGNED  NULL    ,
PRIMARY KEY(idledmiguel));



CREATE TABLE painelmiguel_has_macmiguel (
  painelmiguel_idpainelmiguel INTEGER UNSIGNED  NOT NULL  ,
  macmiguel_idmacmiguel VARCHAR(17)  NOT NULL  ,
  ledmiguel_idledmiguel INTEGER UNSIGNED  NOT NULL  ,
  ledr INTEGER UNSIGNED  NULL  ,
  ledg INTEGER UNSIGNED  NULL  ,
  ledb INTEGER UNSIGNED  NULL    ,
PRIMARY KEY(painelmiguel_idpainelmiguel, macmiguel_idmacmiguel)  ,
INDEX painelmiguel_has_macmiguel_FKIndex1(painelmiguel_idpainelmiguel)  ,
INDEX painelmiguel_has_macmiguel_FKIndex2(macmiguel_idmacmiguel)  ,
INDEX painelmiguel_has_macmiguel_FKIndex3(ledmiguel_idledmiguel),
  FOREIGN KEY(painelmiguel_idpainelmiguel)
    REFERENCES painelmiguel(idpainelmiguel)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  FOREIGN KEY(macmiguel_idmacmiguel)
    REFERENCES macmiguel(idmacmiguel)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  FOREIGN KEY(ledmiguel_idledmiguel)
    REFERENCES ledmiguel(idledmiguel)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION);