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



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



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



CREATE TABLE combinaenzo (
  idcombinaenzo INTEGER UNSIGNED  NOT NULL   AUTO_INCREMENT,
  painelenzo_idpainelenzo INTEGER UNSIGNED  NOT NULL  ,
  macenzo_idmacenzo VARCHAR(17)  NOT NULL  ,
  ledenzo_idledenzo INTEGER UNSIGNED  NOT NULL  ,
  ledr INTEGER UNSIGNED  NULL  ,
  ledg INTEGER UNSIGNED  NULL  ,
  ledb INTEGER UNSIGNED  NULL    ,
PRIMARY KEY(idcombinaenzo)  ,
INDEX combinaenzo_FKIndex1(ledenzo_idledenzo)  ,
INDEX combinaenzo_FKIndex2(macenzo_idmacenzo)  ,
INDEX combinaenzo_FKIndex3(painelenzo_idpainelenzo),
  FOREIGN KEY(ledenzo_idledenzo)
    REFERENCES ledenzo(idledenzo)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  FOREIGN KEY(macenzo_idmacenzo)
    REFERENCES macenzo(idmacenzo)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  FOREIGN KEY(painelenzo_idpainelenzo)
    REFERENCES painelenzo(idpainelenzo)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION);