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`;