CREATE TABLE IF NOT EXISTS llx_notetoquote_corrections (
  rowid            INT AUTO_INCREMENT PRIMARY KEY,
  entity           INT NOT NULL DEFAULT 1,
  fk_user          INT NOT NULL,
  type_bien        VARCHAR(20) NOT NULL DEFAULT 'residentiel',
  product_ref      VARCHAR(255) NULL,
  designation_ai   TEXT NULL,
  designation_user TEXT NULL,
  detail_ai        TEXT NULL,
  detail_user      TEXT NULL,
  prix_ht_ai       DOUBLE NULL,
  prix_ht_user     DOUBLE NULL,
  created_at       DATETIME NOT NULL DEFAULT NOW(),
  KEY idx_ntq_corr_entity    (entity),
  KEY idx_ntq_corr_type_bien (type_bien),
  KEY idx_ntq_corr_created   (created_at)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
