{"status":"success","detalle":[{"ok":true,"sql":"\r\nCREATE TABLE IF NOT EXISTS idbaja_print_profiles (\r\n  id int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n  name varchar(255) NOT NULL,\r\n  is_default tinyint(1) NOT NULL DEFAULT 0,\r\n  height_paper double NOT NULL,\r\n  width_paper double NOT NULL,\r\n  height double NOT NULL,\r\n  width double NOT NULL,\r\n  ch int(11) NOT NULL,\r\n  cv int(11) NOT NULL,\r\n  v1 double NOT NULL DEFAULT 0,\n  v2 double NOT NULL DEFAULT 0,\n  v3 double NOT NULL DEFAULT 0,\n  v4 double NOT NULL DEFAULT 0,\n  v5 double NOT NULL DEFAULT 0,\n  v6 double NOT NULL DEFAULT 0,\n  v7 double NOT NULL DEFAULT 0,\n  v8 double NOT NULL DEFAULT 0,\n  v9 double NOT NULL DEFAULT 0,\n  v10 double NOT NULL DEFAULT 0,\n  v11 double NOT NULL DEFAULT 0,\n  v12 double NOT NULL DEFAULT 0,\n  v13 double NOT NULL DEFAULT 0,\n  v14 double NOT NULL DEFAULT 0,\n  v15 double NOT NULL DEFAULT 0,\n  v16 double NOT NULL DEFAULT 0,\n  v17 double NOT NULL DEFAULT 0,\n  v18 double NOT NULL DEFAULT 0,\n  v19 double NOT NULL DEFAULT 0,\n  v20 double NOT NULL DEFAULT 0,\r\n  h1 double NOT NULL DEFAULT 0,\n  h2 double NOT NULL DEFAULT 0,\n  h3 double NOT NULL DEFAULT 0,\n  h4 double NOT NULL DEFAULT 0,\n  h5 double NOT NULL DEFAULT 0,\n  h6 double NOT NULL DEFAULT 0,\n  h7 double NOT NULL DEFAULT 0,\n  h8 double NOT NULL DEFAULT 0,\n  h9 double NOT NULL DEFAULT 0,\n  h10 double NOT NULL DEFAULT 0,\n  h11 double NOT NULL DEFAULT 0,\n  h12 double NOT NULL DEFAULT 0,\n  h13 double NOT NULL DEFAULT 0,\n  h14 double NOT NULL DEFAULT 0,\n  h15 double NOT NULL DEFAULT 0,\r\n  p1x double DEFAULT NULL,\n  p1y double DEFAULT NULL,\n  p2x double DEFAULT NULL,\n  p2y double DEFAULT NULL,\n  p3x double DEFAULT NULL,\n  p3y double DEFAULT NULL,\n  p4x double DEFAULT NULL,\n  p4y double DEFAULT NULL,\n  p5x double DEFAULT NULL,\n  p5y double DEFAULT NULL,\n  p6x double DEFAULT NULL,\n  p6y double DEFAULT NULL,\n  p7x double DEFAULT NULL,\n  p7y double DEFAULT NULL,\n  p8x double DEFAULT NULL,\n  p8y double DEFAULT NULL,\n  p9x double DEFAULT NULL,\n  p9y double DEFAULT NULL,\n  p10x double DEFAULT NULL,\n  p10y double DEFAULT NULL,\n  p11x double DEFAULT NULL,\n  p11y double DEFAULT NULL,\n  p12x double DEFAULT NULL,\n  p12y double DEFAULT NULL,\n  p13x double DEFAULT NULL,\n  p13y double DEFAULT NULL,\n  p14x double DEFAULT NULL,\n  p14y double DEFAULT NULL,\n  p15x double DEFAULT NULL,\n  p15y double DEFAULT NULL,\n  p16x double DEFAULT NULL,\n  p16y double DEFAULT NULL,\n  p17x double DEFAULT NULL,\n  p17y double DEFAULT NULL,\n  p18x double DEFAULT NULL,\n  p18y double DEFAULT NULL,\n  p19x double DEFAULT NULL,\n  p19y double DEFAULT NULL,\n  p20x double DEFAULT NULL,\n  p20y double DEFAULT NULL,\n  p21x double DEFAULT NULL,\n  p21y double DEFAULT NULL,\n  p22x double DEFAULT NULL,\n  p22y double DEFAULT NULL,\r\n  l1x double DEFAULT NULL,\r\n  l1y double DEFAULT NULL,\r\n  l2x double DEFAULT NULL,\r\n  l2y double DEFAULT NULL,\r\n  activo tinyint(1) NOT NULL DEFAULT 1,\r\n  created_at timestamp NULL DEFAULT CURRENT_TIMESTAMP,\r\n  updated_at timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\r\n  PRIMARY KEY (id),\r\n  KEY idx_default (is_default),\r\n  KEY idx_name_activo (name, activo)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;\r\n"},{"ok":false,"sql":"ALTER TABLE idbaja_print_profiles ADD KEY idx_format_activo (format_id, activo)","error":"SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'idx_format_activo'"},{"ok":false,"sql":"ALTER TABLE idbaja_print_profiles ADD KEY idx_format_default (format_id, is_default)","error":"SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'idx_format_default'"},{"ok":true,"sql":"UPDATE idbaja_print_profiles SET is_default = 0 WHERE activo = 0"},{"ok":true,"sql":"UPDATE idbaja_print_profiles SET is_default = 0 WHERE format_id IS NULL"},{"ok":true,"sql":"\r\nCREATE TABLE IF NOT EXISTS idbaja_settings (\r\n  id int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n  path varchar(255) NOT NULL DEFAULT '',\r\n  pcolor int(11) NOT NULL DEFAULT 0,\r\n  PRIMARY KEY (id)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;\r\n"},{"ok":true,"sql":"INSERT IGNORE INTO idbaja_settings (id, path, pcolor) VALUES (1, '', 0);"},{"ok":true,"sql":"\r\nCREATE TABLE IF NOT EXISTS idbaja_qa_referencias (\r\n  id int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n  format_id varchar(10) NOT NULL,\r\n  label varchar(120) NOT NULL,\r\n  profile_id int(10) unsigned DEFAULT NULL,\r\n  file_path varchar(255) NOT NULL,\r\n  sha1 char(40) NOT NULL,\r\n  pages int(11) NOT NULL DEFAULT 1,\r\n  page_width_mm double NOT NULL,\r\n  page_height_mm double NOT NULL,\r\n  activo tinyint(1) NOT NULL DEFAULT 1,\r\n  created_at timestamp NULL DEFAULT CURRENT_TIMESTAMP,\r\n  updated_at timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\r\n  PRIMARY KEY (id),\r\n  KEY idx_format_activo (format_id, activo),\r\n  KEY idx_profile (profile_id),\r\n  KEY idx_sha1 (sha1)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;\r\n"},{"ok":true,"sql":"\r\nCREATE TABLE IF NOT EXISTS idbaja_qa_reportes (\r\n  id int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n  reference_id int(10) unsigned NOT NULL,\r\n  profile_id int(10) unsigned NOT NULL,\r\n  tolerance_mm double NOT NULL DEFAULT 0.50,\r\n  metrics_json longtext NOT NULL,\r\n  applied_delta_x_mm double DEFAULT NULL,\r\n  applied_delta_y_mm double DEFAULT NULL,\r\n  profile_snapshot_json longtext NOT NULL,\r\n  created_at timestamp NULL DEFAULT CURRENT_TIMESTAMP,\r\n  PRIMARY KEY (id),\r\n  KEY idx_ref (reference_id),\r\n  KEY idx_profile (profile_id),\r\n  KEY idx_created (created_at)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;\r\n"}]}