DBDEsigner problem with TYPE = InnoDB;

0

I use DB_Designer 4.0.5.6 Beta. I discovered a problem when I was generating an sql code to build my database. The last line that appears in the sql code is the "TYPE = InnoDB;"

CREATE TABLE cliente (
  idCliente INT NOT NULL AUTO_INCREMENT,
  clicpf VARCHAR(11) NOT NULL,
  painel_idpainel INT NOT NULL,
  localMonitorado_idClilocalMon INT NOT NULL,
  redesociais_idCliRedesociais INT NOT NULL,
  telefones_idCliTelefone INT NOT NULL,
  Emails_idEmail INT NOT NULL,
  cliCodigo SMALLINT NOT NULL,
  clirg VARCHAR(10) NOT NULL,
  clinome VARCHAR(45) NOT NULL,
  cliendereco VARCHAR(45) NOT NULL,
  clibairro VARCHAR(45) NOT NULL,
  clicidade VARCHAR(45) NOT NULL,
  cliestado VARCHAR(45) NOT NULL,
  clipais VARCHAR(45) NOT NULL,
  clicep VARCHAR(8) NOT NULL,
  PRIMARY KEY(idCliente, clicpf),
  INDEX cliente_index_idCliente(idCliente),
  INDEX cliente_index_clicpf(clicpf),
  INDEX cliente_FKIndex_idEmail(Emails_idEmail),
  INDEX cliente_FKIndex_idCliTelefone(telefones_idCliTelefone),
  INDEX cliente_FKIndex_idCliRedesociais(redesociais_idCliRedesociais),
  INDEX cliente_FKIndex_idClilocalMon(localMonitorado_idClilocalMon),
  INDEX cliente_FKIndex_idpainel(painel_idpainel),
  INDEX cliente_index_UNIQUE(cliCodigo),
  INDEX cliente_index_cliNome_UNIQUE(clinome)
)
TYPE=InnoDB;        <<===  this part end up in error at MySql.

17:51:17    TYPE    Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE' at line 1  0.000 sec

I realize that the right thing to set is "ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_unicode_ci;" to replace and work. But I need to do this every time, in every table.

How do I configure DB_Designer to avoid this error?

    
asked by anonymous 25.02.2018 / 22:18

0 answers