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



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



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



CREATE TABLE macdeidiani_has_leddeidiani (
  macdeidiani_idmacdeidiani VARCHAR(17)  NOT NULL  ,
  leddeidiani_idleddeidiani INTEGER UNSIGNED  NOT NULL  ,
  paineldeidiani_idpaineldeidiani INTEGER UNSIGNED  NOT NULL    ,
PRIMARY KEY(macdeidiani_idmacdeidiani, leddeidiani_idleddeidiani)  ,
INDEX macdeidiani_has_leddeidiani_FKIndex1(macdeidiani_idmacdeidiani)  ,
INDEX macdeidiani_has_leddeidiani_FKIndex2(leddeidiani_idleddeidiani)  ,
INDEX macdeidiani_has_leddeidiani_FKIndex3(paineldeidiani_idpaineldeidiani),
  FOREIGN KEY(macdeidiani_idmacdeidiani)
    REFERENCES macdeidiani(idmacdeidiani)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  FOREIGN KEY(leddeidiani_idleddeidiani)
    REFERENCES leddeidiani(idleddeidiani)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  FOREIGN KEY(paineldeidiani_idpaineldeidiani)
    REFERENCES paineldeidiani(idpaineldeidiani)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION);