php artisan infyom:api_scaffold History --fromTable --tableName=historial_estado --connection=product

ALTER TABLE `estado_caso` ADD `created_at` TIMESTAMP NULL AFTER `fecha_modificacion`, ADD `updated_at` TIMESTAMP NULL AFTER `created_at`, ADD `deleted_at` TIMESTAMP NULL AFTER `updated_at`;
ALTER TABLE `historial_estado` ADD `created_at` TIMESTAMP NULL AFTER `fecha_modificacion`, ADD `updated_at` TIMESTAMP NULL AFTER `created_at`, ADD `deleted_at` TIMESTAMP NULL AFTER `updated_at`;
ALTER TABLE `comentarios` ADD `deleted_at` TIMESTAMP NULL AFTER `fecha_modificacion`;

#-----
ALTER TABLE `estado_caso` ADD `mensaje_api` TEXT NOT NULL AFTER `mensaje_hogar`;
table: sucursal_mapper

#------
ALTER TABLE casos ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8; SHOW WARNINGS;
ALTER TABLE `casos` ADD `gesticla` VARCHAR(50) NULL AFTER `franquicia`;
ALTER TABLE `casos` ADD `gestisec` VARCHAR(50) NULL AFTER `gesticla`, ADD `providerCode` VARCHAR(50) NULL AFTER `gestisec`;
INSERT INTO `ctipos` (`id`, `nombre`, `desactivado`, `created_at`, `updated_at`, `estatus`, `id_usuario_registro`, `fecha_registro`, `id_usuario_modifica`, `fecha_modificacion`) VALUES (NULL, 'Asignación directa', '0', '2020-06-01 16:46:44', '2020-06-01 16:46:44', '1', '4', '2020-06-01 16:46:44', '4', '2020-06-01 16:52:11');
INSERT INTO `articulos` (`id`, `nombre`, `descripcion`, `codia`, `grupo`, `marca`, `marca_vehiculo`, `modelo_vehiculo`, `id_fabricante`, `imagen_id`, `rubro`, `categoria`, `padre_type`, `padre_id`, `estado`, `created_at`, `updated_at`, `estatus`, `id_complejidad`, `id_usuario_registro`, `fecha_registro`, `id_usuario_modifica`, `fecha_modificacion`, `deleted_at`) VALUES (NULL, 'Asignación directa', 'Asignación directa', NULL, '3', 'Asignación directa', NULL, '-', '-', 'default.png', NULL, '18', NULL, NULL, '1', '2022-04-26 11:24:47', '2022-04-26 11:24:47', '1', NULL, '273', '2022-04-26 11:24:47', NULL, NULL, NULL);
ALTER TABLE `adjudicacions_categoria` ADD `created_at` TIMESTAMP NULL AFTER `fecha_modificacion`, ADD `updated_at` TIMESTAMP NULL AFTER `created_at`, ADD `deleted_at` TIMESTAMP NULL AFTER `updated_at`;

------
errores:

CS0: Error en el proceso de registro
CS004: Año inexistente
CS005: Sucursal inexistente

----------
ALTER TABLE casos ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8; SHOW WARNINGS;
ALTER TABLE `casos` ADD `provinces` VARCHAR(250) NULL AFTER `franquicia`, ADD `zipCode` VARCHAR(250) NULL AFTER `provinces`, ADD `codeInfoauto` VARCHAR(250) NULL AFTER `zipCode`, ADD `carDescription` VARCHAR(250) NULL AFTER `codeInfoauto`;
ALTER TABLE `casos` ADD `company` VARCHAR(50) NULL AFTER `carDescription`, ADD `product` VARCHAR(50) NULL AFTER `company`, ADD `office` VARCHAR(50) NULL AFTER `product`;

- nsiniestro: String
ALTER TABLE `casos` CHANGE `npoliza` `npoliza` VARCHAR(250) NULL DEFAULT NULL;

-----
ALTER TABLE `sucursal_mapper` ADD `provider_type` VARCHAR(50) NULL AFTER `code`;
ALTER TABLE `sucursal_mapper` ADD `code_alt` VARCHAR(50) NULL AFTER `code`;
ALTER TABLE `casos` ADD `analyst_id` INT NULL AFTER `office`, ADD `analyst_description` VARCHAR(250) NULL AFTER `analyst_id`, ADD `cover_Id` INT NULL AFTER `analyst_description`, ADD `cover_desc` VARCHAR(250) NULL AFTER `cover_Id`, ADD `subcober_id` INT NULL AFTER `cover_desc`, ADD `subcober_desc` VARCHAR(250) NULL AFTER `subcober_id`;
ALTER TABLE `casos` CHANGE `nsiniestro` `nsiniestro` VARCHAR(250) NULL DEFAULT NULL, CHANGE `npoliza` `npoliza` VARCHAR(250) NULL DEFAULT NULL;
ALTER TABLE `casos` ADD `analyst_email` VARCHAR(250) NULL AFTER `subcober_desc`;

---
ALTER TABLE `caso_categoria` ADD `cobertura_id` INT NULL AFTER `id_categoria`, ADD `subcobertura_id` INT NULL AFTER `cobertura_id`, ADD `gestisec` VARCHAR(150) NULL AFTER `subcobertura_id`, ADD `gesticla` VARCHAR(150) NULL AFTER `gestisec`;
ALTER TABLE `caso_categoria` ADD `cover_desc` VARCHAR(150) NULL AFTER `subcobertura_id`, ADD `subcober_desc` VARCHAR(150) NULL AFTER `cover_desc`;
ALTER TABLE `casos`
  DROP `cover_Id`,
  DROP `cover_desc`,
  DROP `subcober_id`,
  DROP `subcober_desc`;

ALTER TABLE casos ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8; SHOW WARNINGS;
ALTER TABLE `sucursal` ADD `id_categoria` INT NULL AFTER `tipo_proveedor`;