CREATE TABLE llx_rete_comprobante (
  rowid int(11) NOT NULL AUTO_INCREMENT,
  ref varchar(64) NOT NULL,
  entity int(11) NOT NULL DEFAULT 1,
  label varchar(255) DEFAULT NULL,
  qty double(24, 8) DEFAULT NULL,
  fk_facture int(11) DEFAULT NULL,
  concepto varchar(60) DEFAULT NULL,
  comentario varchar(256) DEFAULT NULL,
  status int(11) DEFAULT NULL,
  date_creation datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  tms timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  import_key varchar(14) DEFAULT NULL,
  societe_type smallint(6) DEFAULT NULL,
  anio smallint(6) DEFAULT NULL,
  mes smallint(6) DEFAULT NULL,
  tiporete varchar(60) DEFAULT NULL,
  PRIMARY KEY (rowid)
)
ENGINE = INNODB;