ALTER TABLE `conductores` ADD `vehicleIdWFM` VARCHAR(25) NULL AFTER `vehicleId`; ALTER TABLE jobssaleforce ADD Name varchar(200) NULL AFTER ONE_ID_Task_Frotcom_Destino__c; ALTER TABLE jobssaleforce ADD ONE_Fecha_Limite__c varchar(50) NULL AFTER Name; ALTER TABLE jobssaleforce ADD ONE_Longitud_Y_Latitud__Latitude__s varchar(50) NULL AFTER ONE_Fecha_Limite__c; ALTER TABLE jobssaleforce ADD ONE_Longitud_Y_Latitud__Longitude__s varchar(50) NULL AFTER ONE_Longitud_Y_Latitud__Latitude__s; ALTER TABLE jobssaleforce ADD ONE_A_A_Invierno_26_27_O_Verano_19_21__c varchar(5) NULL AFTER ONE_Longitud_Y_Latitud__Longitude__s; ALTER TABLE jobssaleforce ADD ONE_Acompanar__c varchar(5) NULL AFTER ONE_A_A_Invierno_26_27_O_Verano_19_21__c; ALTER TABLE jobssaleforce ADD ONE_Acreditacion_Cenizas__c varchar(50) NULL AFTER ONE_Acompanar__c; ALTER TABLE jobssaleforce ADD ONE_Afeitar__c varchar(5) NULL AFTER ONE_Acreditacion_Cenizas__c; ALTER TABLE jobssaleforce ADD ONE_Aislamiento__c varchar(50) NULL AFTER ONE_Afeitar__c; ALTER TABLE jobssaleforce ADD ONE_Amatista__c varchar(5) NULL AFTER ONE_Aislamiento__c; ALTER TABLE jobssaleforce ADD ONE_Amortajar__c varchar(5) NULL AFTER ONE_Amatista__c; ALTER TABLE jobssaleforce ADD ONE_Aseo_Neceser_Preparado__c varchar(5) NULL AFTER ONE_Amortajar__c; ALTER TABLE jobssaleforce ADD ONE_Aseo_Precinto_Higienizacion_Inodoro__c varchar(5) NULL AFTER ONE_Aseo_Neceser_Preparado__c; ALTER TABLE jobssaleforce ADD ONE_Aseo_Precinto_WC__c varchar(5) NULL AFTER ONE_Aseo_Precinto_Higienizacion_Inodoro__c; ALTER TABLE jobssaleforce ADD ONE_Capilla__c varchar(5) NULL AFTER ONE_Aseo_Precinto_WC__c; ALTER TABLE jobssaleforce ADD ONE_Capilla_Funebre__c varchar(5) NULL AFTER ONE_Capilla__c; ALTER TABLE jobssaleforce ADD ONE_Capucha__c varchar(5) NULL AFTER ONE_Capilla_Funebre__c; ALTER TABLE jobssaleforce ADD ONE_Catering_En_Sala__c varchar(5) NULL AFTER ONE_Capucha__c; ALTER TABLE jobssaleforce ADD ONE_Cenizas_Entregadas__c varchar(5) NULL AFTER ONE_Catering_En_Sala__c; ALTER TABLE jobssaleforce ADD ONE_Cintas_De_Inscripcion_Sin_Errores__c varchar(5) NULL AFTER ONE_Cenizas_Entregadas__c; ALTER TABLE jobssaleforce ADD ONE_CMD__c varchar(5) NULL AFTER ONE_Cintas_De_Inscripcion_Sin_Errores__c; ALTER TABLE jobssaleforce ADD ONE_Codigo_Postal__c varchar(50) NULL AFTER ONE_CMD__c; ALTER TABLE jobssaleforce ADD ONE_Color_Labios__c varchar(50) NULL AFTER ONE_Codigo_Postal__c; ALTER TABLE jobssaleforce ADD ONE_Color_Unas__c varchar(50) NULL AFTER ONE_Color_Labios__c; ALTER TABLE jobssaleforce ADD ONE_Columbario__c varchar(5) NULL AFTER ONE_Color_Unas__c; ALTER TABLE jobssaleforce ADD ONE_Complementos_Segmentacion__c varchar(5) NULL AFTER ONE_Columbario__c; ALTER TABLE jobssaleforce ADD ONE_Con_Cruz__c varchar(5) NULL AFTER ONE_Complementos_Segmentacion__c; ALTER TABLE jobssaleforce ADD ONE_Con_Imagen__c varchar(5) NULL AFTER ONE_Con_Cruz__c; ALTER TABLE jobssaleforce ADD ONE_Conservacion__c varchar(5) NULL AFTER ONE_Con_Imagen__c; ALTER TABLE jobssaleforce ADD ONE_Coral__c varchar(5) NULL AFTER ONE_Conservacion__c; ALTER TABLE jobssaleforce ADD ONE_Cortina_Operativa__c varchar(5) NULL AFTER ONE_Coral__c; ALTER TABLE jobssaleforce ADD ONE_Cripta__c varchar(5) NULL AFTER ONE_Cortina_Operativa__c; ALTER TABLE jobssaleforce ADD ONE_Cuarzo__c varchar(5) NULL AFTER ONE_Cripta__c; ALTER TABLE jobssaleforce ADD ONE_Detalle_Afeitado__c varchar(50) NULL AFTER ONE_Cuarzo__c; ALTER TABLE jobssaleforce ADD ONE_Detalle_Peinado__c varchar(50) NULL AFTER ONE_Detalle_Afeitado__c; ALTER TABLE jobssaleforce ADD ONE_Difunto__c varchar(5) NULL AFTER ONE_Detalle_Peinado__c; ALTER TABLE jobssaleforce ADD ONE_Direccion__c varchar(50) NULL AFTER ONE_Difunto__c; ALTER TABLE jobssaleforce ADD ONE_Direccion_De_Entrega__c varchar(50) NULL AFTER ONE_Direccion__c; ALTER TABLE jobssaleforce ADD ONE_Disposicion_Correcta_Del_Difunto__c varchar(5) NULL AFTER ONE_Direccion_De_Entrega__c; ALTER TABLE jobssaleforce ADD ONE_Disposicion_Correcta_Y_Equilibrada__c varchar(5) NULL AFTER ONE_Disposicion_Correcta_Del_Difunto__c; ALTER TABLE jobssaleforce ADD ONE_Disposicion_Del_Feretro_En_La_Sala__c varchar(5) NULL AFTER ONE_Disposicion_Correcta_Y_Equilibrada__c; ALTER TABLE jobssaleforce ADD ONE_Documentos_Legales_Firmados__c varchar(5) NULL AFTER ONE_Disposicion_Del_Feretro_En_La_Sala__c; ALTER TABLE jobssaleforce ADD ONE_Embalsamar__c varchar(5) NULL AFTER ONE_Documentos_Legales_Firmados__c; ALTER TABLE jobssaleforce ADD ONE_Esquelas__c varchar(5) NULL AFTER ONE_Embalsamar__c; ALTER TABLE jobssaleforce ADD ONE_Estado_De_Las_Flores__c varchar(5) NULL AFTER ONE_Esquelas__c; ALTER TABLE jobssaleforce ADD ONE_Faldon_Colocado_Correctamente__c varchar(5) NULL AFTER ONE_Estado_De_Las_Flores__c; ALTER TABLE jobssaleforce ADD ONE_Familia_Presente__c varchar(5) NULL AFTER ONE_Faldon_Colocado_Correctamente__c; ALTER TABLE jobssaleforce ADD ONE_Fecha_Hora_Recogida_Cenizas__c varchar(50) NULL AFTER ONE_Familia_Presente__c; ALTER TABLE jobssaleforce ADD ONE_Fecha_Limite_Entrega_De_Cenizas__c varchar(50) NULL AFTER ONE_Fecha_Hora_Recogida_Cenizas__c; ALTER TABLE jobssaleforce ADD ONE_Feretro__c varchar(5) NULL AFTER ONE_Fecha_Limite_Entrega_De_Cenizas__c; ALTER TABLE jobssaleforce ADD ONE_Feretro_Ecologico__c varchar(5) NULL AFTER ONE_Feretro__c; ALTER TABLE jobssaleforce ADD ONE_Filtro__c varchar(5) NULL AFTER ONE_Feretro_Ecologico__c; ALTER TABLE jobssaleforce ADD ONE_Flores__c varchar(5) NULL AFTER ONE_Filtro__c; ALTER TABLE jobssaleforce ADD ONE_Flores_Familia__c varchar(5) NULL AFTER ONE_Flores__c; ALTER TABLE jobssaleforce ADD ONE_Flores_Y_Cintas__c varchar(5) NULL AFTER ONE_Flores_Familia__c; ALTER TABLE jobssaleforce ADD ONE_Foto_A_Difunto_Realizada__c varchar(5) NULL AFTER ONE_Flores_Y_Cintas__c; ALTER TABLE jobssaleforce ADD ONE_Func_Telf_Contacto_Recepcion__c varchar(5) NULL AFTER ONE_Foto_A_Difunto_Realizada__c; ALTER TABLE jobssaleforce ADD ONE_Habito__c varchar(5) NULL AFTER ONE_Func_Telf_Contacto_Recepcion__c; ALTER TABLE jobssaleforce ADD ONE_Identificacion_QR_Correcta__c varchar(5) NULL AFTER ONE_Habito__c; ALTER TABLE jobssaleforce ADD ONE_Identificacion_QR_Manual__c varchar(50) NULL AFTER ONE_Identificacion_QR_Correcta__c; ALTER TABLE jobssaleforce ADD ONE_Identificacion_QR_SKU_Correcta__c varchar(5) NULL AFTER ONE_Identificacion_QR_Manual__c; ALTER TABLE jobssaleforce ADD ONE_Idioma__c varchar(50) NULL AFTER ONE_Identificacion_QR_SKU_Correcta__c; ALTER TABLE jobssaleforce ADD ONE_Iluminacion_Correcta__c varchar(5) NULL AFTER ONE_Idioma__c; ALTER TABLE jobssaleforce ADD ONE_Incidencias_Durante_La_Revision__c varchar(50) NULL AFTER ONE_Iluminacion_Correcta__c; ALTER TABLE jobssaleforce ADD ONE_Incidencias_Revision_Con_La_Familia__c varchar(50) NULL AFTER ONE_Incidencias_Durante_La_Revision__c; ALTER TABLE jobssaleforce ADD ONE_Informar_Aspectos_Sala__c varchar(5) NULL AFTER ONE_Incidencias_Revision_Con_La_Familia__c; ALTER TABLE jobssaleforce ADD ONE_Informar_Forma_Contacto_Recepcion__c varchar(5) NULL AFTER ONE_Informar_Aspectos_Sala__c; ALTER TABLE jobssaleforce ADD ONE_Informar_Horarios_Y_Destinos__c varchar(5) NULL AFTER ONE_Informar_Forma_Contacto_Recepcion__c; ALTER TABLE jobssaleforce ADD ONE_Informar_Protocolo_De_Salida__c varchar(5) NULL AFTER ONE_Informar_Horarios_Y_Destinos__c; ALTER TABLE jobssaleforce ADD ONE_Jade__c varchar(5) NULL AFTER ONE_Informar_Protocolo_De_Salida__c; ALTER TABLE jobssaleforce ADD ONE_Libro_De_Firmas__c varchar(5) NULL AFTER ONE_Jade__c; ALTER TABLE jobssaleforce ADD ONE_Libro_De_Firmas_Familia__c varchar(5) NULL AFTER ONE_Libro_De_Firmas__c; ALTER TABLE jobssaleforce ADD ONE_Licencia__c varchar(5) NULL AFTER ONE_Libro_De_Firmas_Familia__c; ALTER TABLE jobssaleforce ADD ONE_Limpieza_Correcto_Estado_Sin_Golpes__c varchar(5) NULL AFTER ONE_Licencia__c; ALTER TABLE jobssaleforce ADD ONE_Limpieza_General__c varchar(5) NULL AFTER ONE_Limpieza_Correcto_Estado_Sin_Golpes__c; ALTER TABLE jobssaleforce ADD ONE_Limpieza_Suelos_Cortina_Paredes__c varchar(5) NULL AFTER ONE_Limpieza_General__c; ALTER TABLE jobssaleforce ADD ONE_Localizacion_Unidad_Enterramiento__c varchar(50) NULL AFTER ONE_Limpieza_Suelos_Cortina_Paredes__c; ALTER TABLE jobssaleforce ADD ONE_Lugar__c varchar(50) NULL AFTER ONE_Localizacion_Unidad_Enterramiento__c; ALTER TABLE jobssaleforce ADD ONE_Lugar__r_Name varchar(150) NULL AFTER ONE_Lugar__c; ALTER TABLE jobssaleforce ADD ONE_Maquillaje__c varchar(50) NULL AFTER ONE_Lugar__r_Name; ALTER TABLE jobssaleforce ADD ONE_Marcapasos__c varchar(5) NULL AFTER ONE_Maquillaje__c; ALTER TABLE jobssaleforce ADD ONE_Mausoleo__c varchar(5) NULL AFTER ONE_Marcapasos__c; ALTER TABLE jobssaleforce ADD ONE_Modelo_De_Feretro__c varchar(50) NULL AFTER ONE_Mausoleo__c; ALTER TABLE jobssaleforce ADD ONE_Municipio__c varchar(50) NULL AFTER ONE_Modelo_De_Feretro__c; ALTER TABLE jobssaleforce ADD ONE_N_Placa__c varchar(50) NULL AFTER ONE_Municipio__c; ALTER TABLE jobssaleforce ADD ONE_Nicho_Nuevo__c varchar(5) NULL AFTER ONE_N_Placa__c; ALTER TABLE jobssaleforce ADD ONE_Nicho_Ocupado__c varchar(5) NULL AFTER ONE_Nicho_Nuevo__c; ALTER TABLE jobssaleforce ADD ONE_Nombre_Del_Difunto_En_Tumulo__c varchar(5) NULL AFTER ONE_Nicho_Ocupado__c; ALTER TABLE jobssaleforce ADD ONE_Nombre_Persona_Recogida_Cenizas__c varchar(250) NULL AFTER ONE_Nombre_Del_Difunto_En_Tumulo__c; ALTER TABLE jobssaleforce ADD ONE_Numero_Identificador_Cremacion__c varchar(50) NULL AFTER ONE_Nombre_Persona_Recogida_Cenizas__c; ALTER TABLE jobssaleforce ADD ONE_Pais__c varchar(50) NULL AFTER ONE_Numero_Identificador_Cremacion__c; ALTER TABLE jobssaleforce ADD ONE_Peinado__c varchar(5) NULL AFTER ONE_Pais__c; ALTER TABLE jobssaleforce ADD ONE_Permiso_Cremacion__c varchar(5) NULL AFTER ONE_Peinado__c; ALTER TABLE jobssaleforce ADD ONE_Placa_Id_Feretro_Correcta__c varchar(5) NULL AFTER ONE_Permiso_Cremacion__c; ALTER TABLE jobssaleforce ADD ONE_Placa_Identificativa__c varchar(50) NULL AFTER ONE_Placa_Id_Feretro_Correcta__c; ALTER TABLE jobssaleforce ADD ONE_Presentacion__c varchar(50) NULL AFTER ONE_Placa_Identificativa__c; ALTER TABLE jobssaleforce ADD ONE_Presentacion_Del_Difunto__c varchar(5) NULL AFTER ONE_Presentacion__c; ALTER TABLE jobssaleforce ADD ONE_Presentacion_Difunto_Correcto__c varchar(5) NULL AFTER ONE_Presentacion_Del_Difunto__c; ALTER TABLE jobssaleforce ADD ONE_Provincia__c varchar(50) NULL AFTER ONE_Presentacion_Difunto_Correcto__c; ALTER TABLE jobssaleforce ADD ONE_Recoge_Cenizas__c varchar(50) NULL AFTER ONE_Provincia__c; ALTER TABLE jobssaleforce ADD ONE_Recordatorios__c varchar(5) NULL AFTER ONE_Recoge_Cenizas__c; ALTER TABLE jobssaleforce ADD ONE_Recordatorios_Familia__c varchar(5) NULL AFTER ONE_Recordatorios__c; ALTER TABLE jobssaleforce ADD ONE_Refrigerado_4_Maximo_5_Norma_15017__c varchar(5) NULL AFTER ONE_Recordatorios_Familia__c; ALTER TABLE jobssaleforce ADD ONE_Requiere_Foto_A_Difunto__c varchar(5) NULL AFTER ONE_Refrigerado_4_Maximo_5_Norma_15017__c; ALTER TABLE jobssaleforce ADD ONE_Requiere_Identificacion_QR__c varchar(5) NULL AFTER ONE_Requiere_Foto_A_Difunto__c; ALTER TABLE jobssaleforce ADD ONE_Requiere_Identificacion_QR_Del_SKU__c varchar(5) NULL AFTER ONE_Requiere_Identificacion_QR__c; ALTER TABLE jobssaleforce ADD ONE_Retirada_De_La_Lapida__c varchar(5) NULL AFTER ONE_Requiere_Identificacion_QR_Del_SKU__c; ALTER TABLE jobssaleforce ADD ONE_Revisar_Con_Familia__c varchar(5) NULL AFTER ONE_Retirada_De_La_Lapida__c; ALTER TABLE jobssaleforce ADD ONE_Sabana__c varchar(5) NULL AFTER ONE_Revisar_Con_Familia__c; ALTER TABLE jobssaleforce ADD ONE_Sala__c varchar(50) NULL AFTER ONE_Sabana__c; ALTER TABLE jobssaleforce ADD ONE_Sala__r_Name varchar(150) NULL AFTER ONE_Sala__c; ALTER TABLE jobssaleforce ADD ONE_Sala_Checklist__c varchar(5) NULL AFTER ONE_Sala__r_Name; ALTER TABLE jobssaleforce ADD ONE_Sepultura__c varchar(5) NULL AFTER ONE_Sala_Checklist__c; ALTER TABLE jobssaleforce ADD ONE_Servicio_Musical__c varchar(5) NULL AFTER ONE_Sepultura__c; ALTER TABLE jobssaleforce ADD ONE_Servicios_Acompanamiento_Al_Duelo__c varchar(5) NULL AFTER ONE_Servicio_Musical__c; ALTER TABLE jobssaleforce ADD ONE_Sudario__c varchar(5) NULL AFTER ONE_Servicios_Acompanamiento_Al_Duelo__c; ALTER TABLE jobssaleforce ADD ONE_Talla__c varchar(50) NULL AFTER ONE_Sudario__c; ALTER TABLE jobssaleforce ADD ONE_Tanatoestetica__c varchar(5) NULL AFTER ONE_Talla__c; ALTER TABLE jobssaleforce ADD ONE_Tanatopraxia__c varchar(5) NULL AFTER ONE_Tanatoestetica__c; ALTER TABLE jobssaleforce ADD ONE_Tapa_Feretro_Vertical_Dentro_Tumulo__c varchar(5) NULL AFTER ONE_Tanatopraxia__c; ALTER TABLE jobssaleforce ADD ONE_Tarjeta_De_Condolencia__c varchar(5) NULL AFTER ONE_Tapa_Feretro_Vertical_Dentro_Tumulo__c; ALTER TABLE jobssaleforce ADD ONE_Texto_Completo__c varchar(50) NULL AFTER ONE_Tarjeta_De_Condolencia__c; ALTER TABLE jobssaleforce ADD ONE_Texto_Corto__c varchar(50) NULL AFTER ONE_Texto_Completo__c; ALTER TABLE jobssaleforce ADD ONE_Tipo_De_Destino_De_Cenizas__c varchar(50) NULL AFTER ONE_Texto_Corto__c; ALTER TABLE jobssaleforce ADD ONE_Tipo_De_Ritual__c varchar(50) NULL AFTER ONE_Tipo_De_Destino_De_Cenizas__c; ALTER TABLE jobssaleforce ADD ONE_Traje__c varchar(5) NULL AFTER ONE_Tipo_De_Ritual__c; ALTER TABLE jobssaleforce ADD ONE_Traje_Vestido__c varchar(5) NULL AFTER ONE_Traje__c; ALTER TABLE jobssaleforce ADD ONE_Tumulo__c varchar(5) NULL AFTER ONE_Traje_Vestido__c; ALTER TABLE jobssaleforce ADD ONE_Vehiculo_Coronario__c varchar(5) NULL AFTER ONE_Tumulo__c; ALTER TABLE jobssaleforce ADD ONE_Vestido_Modelo__c varchar(50) NULL AFTER ONE_Vehiculo_Coronario__c; ALTER TABLE jobssaleforce ADD ONE_Vestir__c varchar(5) NULL AFTER ONE_Vestido_Modelo__c; ALTER TABLE jobssaleforce ADD vehicleId varchar(25) NULL AFTER ONE_Vestir__c; ALTER TABLE jobssaleforce ADD puestoName varchar(100) NULL AFTER vehicleId; ALTER TABLE jobssaleforce ADD startDate varchar(100) NULL AFTER puestoName; ALTER TABLE jobssaleforce ADD endDate varchar(100) NULL AFTER startDate; ALTER TABLE jobssaleforce ADD startForm varchar(25) NULL AFTER endDate; ALTER TABLE jobssaleforce ADD endForm varchar(25) NULL AFTER startForm; ALTER TABLE `jobssaleforce` DROP `Name`; ALTER TABLE `jobssaleforce` DROP `vehicleId`; ALTER TABLE `jobssaleforce` DROP `puestoName`; ALTER TABLE `jobssaleforce` DROP `startDate`; ALTER TABLE `jobssaleforce` DROP `endDate`; ALTER TABLE `jobssaleforce` DROP `startForm`; ALTER TABLE `jobssaleforce` DROP `endForm`; ALTER TABLE jobssaleforcecanceled ADD Name varchar(200) NULL AFTER ONE_ID_Task_Frotcom_Destino__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Fecha_Limite__c varchar(50) NULL AFTER Name; ALTER TABLE jobssaleforcecanceled ADD ONE_Longitud_Y_Latitud__Latitude__s varchar(50) NULL AFTER ONE_Fecha_Limite__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Longitud_Y_Latitud__Longitude__s varchar(50) NULL AFTER ONE_Longitud_Y_Latitud__Latitude__s; ALTER TABLE jobssaleforcecanceled ADD ONE_A_A_Invierno_26_27_O_Verano_19_21__c varchar(5) NULL AFTER ONE_Longitud_Y_Latitud__Longitude__s; ALTER TABLE jobssaleforcecanceled ADD ONE_Acompanar__c varchar(5) NULL AFTER ONE_A_A_Invierno_26_27_O_Verano_19_21__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Acreditacion_Cenizas__c varchar(50) NULL AFTER ONE_Acompanar__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Afeitar__c varchar(5) NULL AFTER ONE_Acreditacion_Cenizas__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Aislamiento__c varchar(50) NULL AFTER ONE_Afeitar__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Amatista__c varchar(5) NULL AFTER ONE_Aislamiento__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Amortajar__c varchar(5) NULL AFTER ONE_Amatista__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Aseo_Neceser_Preparado__c varchar(5) NULL AFTER ONE_Amortajar__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Aseo_Precinto_Higienizacion_Inodoro__c varchar(5) NULL AFTER ONE_Aseo_Neceser_Preparado__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Aseo_Precinto_WC__c varchar(5) NULL AFTER ONE_Aseo_Precinto_Higienizacion_Inodoro__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Capilla__c varchar(5) NULL AFTER ONE_Aseo_Precinto_WC__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Capilla_Funebre__c varchar(5) NULL AFTER ONE_Capilla__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Capucha__c varchar(5) NULL AFTER ONE_Capilla_Funebre__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Catering_En_Sala__c varchar(5) NULL AFTER ONE_Capucha__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Cenizas_Entregadas__c varchar(5) NULL AFTER ONE_Catering_En_Sala__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Cintas_De_Inscripcion_Sin_Errores__c varchar(5) NULL AFTER ONE_Cenizas_Entregadas__c; ALTER TABLE jobssaleforcecanceled ADD ONE_CMD__c varchar(5) NULL AFTER ONE_Cintas_De_Inscripcion_Sin_Errores__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Codigo_Postal__c varchar(50) NULL AFTER ONE_CMD__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Color_Labios__c varchar(50) NULL AFTER ONE_Codigo_Postal__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Color_Unas__c varchar(50) NULL AFTER ONE_Color_Labios__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Columbario__c varchar(5) NULL AFTER ONE_Color_Unas__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Complementos_Segmentacion__c varchar(5) NULL AFTER ONE_Columbario__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Con_Cruz__c varchar(5) NULL AFTER ONE_Complementos_Segmentacion__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Con_Imagen__c varchar(5) NULL AFTER ONE_Con_Cruz__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Conservacion__c varchar(5) NULL AFTER ONE_Con_Imagen__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Coral__c varchar(5) NULL AFTER ONE_Conservacion__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Cortina_Operativa__c varchar(5) NULL AFTER ONE_Coral__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Cripta__c varchar(5) NULL AFTER ONE_Cortina_Operativa__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Cuarzo__c varchar(5) NULL AFTER ONE_Cripta__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Detalle_Afeitado__c varchar(50) NULL AFTER ONE_Cuarzo__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Detalle_Peinado__c varchar(50) NULL AFTER ONE_Detalle_Afeitado__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Difunto__c varchar(5) NULL AFTER ONE_Detalle_Peinado__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Direccion__c varchar(50) NULL AFTER ONE_Difunto__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Direccion_De_Entrega__c varchar(50) NULL AFTER ONE_Direccion__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Disposicion_Correcta_Del_Difunto__c varchar(5) NULL AFTER ONE_Direccion_De_Entrega__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Disposicion_Correcta_Y_Equilibrada__c varchar(5) NULL AFTER ONE_Disposicion_Correcta_Del_Difunto__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Disposicion_Del_Feretro_En_La_Sala__c varchar(5) NULL AFTER ONE_Disposicion_Correcta_Y_Equilibrada__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Documentos_Legales_Firmados__c varchar(5) NULL AFTER ONE_Disposicion_Del_Feretro_En_La_Sala__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Embalsamar__c varchar(5) NULL AFTER ONE_Documentos_Legales_Firmados__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Esquelas__c varchar(5) NULL AFTER ONE_Embalsamar__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Estado_De_Las_Flores__c varchar(5) NULL AFTER ONE_Esquelas__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Faldon_Colocado_Correctamente__c varchar(5) NULL AFTER ONE_Estado_De_Las_Flores__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Familia_Presente__c varchar(5) NULL AFTER ONE_Faldon_Colocado_Correctamente__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Fecha_Hora_Recogida_Cenizas__c varchar(50) NULL AFTER ONE_Familia_Presente__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Fecha_Limite_Entrega_De_Cenizas__c varchar(50) NULL AFTER ONE_Fecha_Hora_Recogida_Cenizas__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Feretro__c varchar(5) NULL AFTER ONE_Fecha_Limite_Entrega_De_Cenizas__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Feretro_Ecologico__c varchar(5) NULL AFTER ONE_Feretro__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Filtro__c varchar(5) NULL AFTER ONE_Feretro_Ecologico__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Flores__c varchar(5) NULL AFTER ONE_Filtro__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Flores_Familia__c varchar(5) NULL AFTER ONE_Flores__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Flores_Y_Cintas__c varchar(5) NULL AFTER ONE_Flores_Familia__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Foto_A_Difunto_Realizada__c varchar(5) NULL AFTER ONE_Flores_Y_Cintas__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Func_Telf_Contacto_Recepcion__c varchar(5) NULL AFTER ONE_Foto_A_Difunto_Realizada__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Habito__c varchar(5) NULL AFTER ONE_Func_Telf_Contacto_Recepcion__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Identificacion_QR_Correcta__c varchar(5) NULL AFTER ONE_Habito__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Identificacion_QR_Manual__c varchar(50) NULL AFTER ONE_Identificacion_QR_Correcta__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Identificacion_QR_SKU_Correcta__c varchar(5) NULL AFTER ONE_Identificacion_QR_Manual__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Idioma__c varchar(50) NULL AFTER ONE_Identificacion_QR_SKU_Correcta__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Iluminacion_Correcta__c varchar(5) NULL AFTER ONE_Idioma__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Incidencias_Durante_La_Revision__c varchar(50) NULL AFTER ONE_Iluminacion_Correcta__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Incidencias_Revision_Con_La_Familia__c varchar(50) NULL AFTER ONE_Incidencias_Durante_La_Revision__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Informar_Aspectos_Sala__c varchar(5) NULL AFTER ONE_Incidencias_Revision_Con_La_Familia__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Informar_Forma_Contacto_Recepcion__c varchar(5) NULL AFTER ONE_Informar_Aspectos_Sala__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Informar_Horarios_Y_Destinos__c varchar(5) NULL AFTER ONE_Informar_Forma_Contacto_Recepcion__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Informar_Protocolo_De_Salida__c varchar(5) NULL AFTER ONE_Informar_Horarios_Y_Destinos__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Jade__c varchar(5) NULL AFTER ONE_Informar_Protocolo_De_Salida__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Libro_De_Firmas__c varchar(5) NULL AFTER ONE_Jade__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Libro_De_Firmas_Familia__c varchar(5) NULL AFTER ONE_Libro_De_Firmas__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Licencia__c varchar(5) NULL AFTER ONE_Libro_De_Firmas_Familia__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Limpieza_Correcto_Estado_Sin_Golpes__c varchar(5) NULL AFTER ONE_Licencia__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Limpieza_General__c varchar(5) NULL AFTER ONE_Limpieza_Correcto_Estado_Sin_Golpes__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Limpieza_Suelos_Cortina_Paredes__c varchar(5) NULL AFTER ONE_Limpieza_General__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Localizacion_Unidad_Enterramiento__c varchar(50) NULL AFTER ONE_Limpieza_Suelos_Cortina_Paredes__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Lugar__c varchar(50) NULL AFTER ONE_Localizacion_Unidad_Enterramiento__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Lugar__r_Name varchar(150) NULL AFTER ONE_Lugar__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Maquillaje__c varchar(50) NULL AFTER ONE_Lugar__r_Name; ALTER TABLE jobssaleforcecanceled ADD ONE_Marcapasos__c varchar(5) NULL AFTER ONE_Maquillaje__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Mausoleo__c varchar(5) NULL AFTER ONE_Marcapasos__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Modelo_De_Feretro__c varchar(50) NULL AFTER ONE_Mausoleo__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Municipio__c varchar(50) NULL AFTER ONE_Modelo_De_Feretro__c; ALTER TABLE jobssaleforcecanceled ADD ONE_N_Placa__c varchar(50) NULL AFTER ONE_Municipio__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Nicho_Nuevo__c varchar(5) NULL AFTER ONE_N_Placa__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Nicho_Ocupado__c varchar(5) NULL AFTER ONE_Nicho_Nuevo__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Nombre_Del_Difunto_En_Tumulo__c varchar(5) NULL AFTER ONE_Nicho_Ocupado__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Nombre_Persona_Recogida_Cenizas__c varchar(250) NULL AFTER ONE_Nombre_Del_Difunto_En_Tumulo__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Numero_Identificador_Cremacion__c varchar(50) NULL AFTER ONE_Nombre_Persona_Recogida_Cenizas__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Pais__c varchar(50) NULL AFTER ONE_Numero_Identificador_Cremacion__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Peinado__c varchar(5) NULL AFTER ONE_Pais__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Permiso_Cremacion__c varchar(5) NULL AFTER ONE_Peinado__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Placa_Id_Feretro_Correcta__c varchar(5) NULL AFTER ONE_Permiso_Cremacion__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Placa_Identificativa__c varchar(50) NULL AFTER ONE_Placa_Id_Feretro_Correcta__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Presentacion__c varchar(50) NULL AFTER ONE_Placa_Identificativa__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Presentacion_Del_Difunto__c varchar(5) NULL AFTER ONE_Presentacion__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Presentacion_Difunto_Correcto__c varchar(5) NULL AFTER ONE_Presentacion_Del_Difunto__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Provincia__c varchar(50) NULL AFTER ONE_Presentacion_Difunto_Correcto__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Recoge_Cenizas__c varchar(50) NULL AFTER ONE_Provincia__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Recordatorios__c varchar(5) NULL AFTER ONE_Recoge_Cenizas__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Recordatorios_Familia__c varchar(5) NULL AFTER ONE_Recordatorios__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Refrigerado_4_Maximo_5_Norma_15017__c varchar(5) NULL AFTER ONE_Recordatorios_Familia__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Requiere_Foto_A_Difunto__c varchar(5) NULL AFTER ONE_Refrigerado_4_Maximo_5_Norma_15017__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Requiere_Identificacion_QR__c varchar(5) NULL AFTER ONE_Requiere_Foto_A_Difunto__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Requiere_Identificacion_QR_Del_SKU__c varchar(5) NULL AFTER ONE_Requiere_Identificacion_QR__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Retirada_De_La_Lapida__c varchar(5) NULL AFTER ONE_Requiere_Identificacion_QR_Del_SKU__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Revisar_Con_Familia__c varchar(5) NULL AFTER ONE_Retirada_De_La_Lapida__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Sabana__c varchar(5) NULL AFTER ONE_Revisar_Con_Familia__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Sala__c varchar(50) NULL AFTER ONE_Sabana__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Sala__r_Name varchar(150) NULL AFTER ONE_Sala__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Sala_Checklist__c varchar(5) NULL AFTER ONE_Sala__r_Name; ALTER TABLE jobssaleforcecanceled ADD ONE_Sepultura__c varchar(5) NULL AFTER ONE_Sala_Checklist__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Servicio_Musical__c varchar(5) NULL AFTER ONE_Sepultura__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Servicios_Acompanamiento_Al_Duelo__c varchar(5) NULL AFTER ONE_Servicio_Musical__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Sudario__c varchar(5) NULL AFTER ONE_Servicios_Acompanamiento_Al_Duelo__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Talla__c varchar(50) NULL AFTER ONE_Sudario__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Tanatoestetica__c varchar(5) NULL AFTER ONE_Talla__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Tanatopraxia__c varchar(5) NULL AFTER ONE_Tanatoestetica__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Tapa_Feretro_Vertical_Dentro_Tumulo__c varchar(5) NULL AFTER ONE_Tanatopraxia__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Tarjeta_De_Condolencia__c varchar(5) NULL AFTER ONE_Tapa_Feretro_Vertical_Dentro_Tumulo__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Texto_Completo__c varchar(50) NULL AFTER ONE_Tarjeta_De_Condolencia__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Texto_Corto__c varchar(50) NULL AFTER ONE_Texto_Completo__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Tipo_De_Destino_De_Cenizas__c varchar(50) NULL AFTER ONE_Texto_Corto__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Tipo_De_Ritual__c varchar(50) NULL AFTER ONE_Tipo_De_Destino_De_Cenizas__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Traje__c varchar(5) NULL AFTER ONE_Tipo_De_Ritual__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Traje_Vestido__c varchar(5) NULL AFTER ONE_Traje__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Tumulo__c varchar(5) NULL AFTER ONE_Traje_Vestido__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Vehiculo_Coronario__c varchar(5) NULL AFTER ONE_Tumulo__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Vestido_Modelo__c varchar(50) NULL AFTER ONE_Vehiculo_Coronario__c; ALTER TABLE jobssaleforcecanceled ADD ONE_Vestir__c varchar(5) NULL AFTER ONE_Vestido_Modelo__c; ALTER TABLE jobssaleforcecanceled ADD vehicleId varchar(25) NULL AFTER ONE_Vestir__c; ALTER TABLE jobssaleforcecanceled ADD puestoName varchar(100) NULL AFTER vehicleId; ALTER TABLE jobssaleforcecanceled ADD startDate varchar(100) NULL AFTER puestoName; ALTER TABLE jobssaleforcecanceled ADD endDate varchar(100) NULL AFTER startDate; ALTER TABLE jobssaleforcecanceled ADD startForm varchar(25) NULL AFTER endDate; ALTER TABLE jobssaleforcecanceled ADD endForm varchar(25) NULL AFTER startForm; ALTER TABLE `jobssaleforcecanceled` DROP `Name`; ALTER TABLE `jobssaleforcecanceled` DROP `vehicleId`; ALTER TABLE `jobssaleforcecanceled` DROP `puestoName`; ALTER TABLE `jobssaleforcecanceled` DROP `startDate`; ALTER TABLE `jobssaleforcecanceled` DROP `endDate`; ALTER TABLE `jobssaleforcecanceled` DROP `startForm`; ALTER TABLE `jobssaleforcecanceled` DROP `endForm`; ALTER TABLE jobssaleforcecompleted ADD Name varchar(200) NULL AFTER ONE_ID_Task_Frotcom_Destino__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Fecha_Limite__c varchar(50) NULL AFTER Name; ALTER TABLE jobssaleforcecompleted ADD ONE_Longitud_Y_Latitud__Latitude__s varchar(50) NULL AFTER ONE_Fecha_Limite__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Longitud_Y_Latitud__Longitude__s varchar(50) NULL AFTER ONE_Longitud_Y_Latitud__Latitude__s; ALTER TABLE jobssaleforcecompleted ADD ONE_A_A_Invierno_26_27_O_Verano_19_21__c varchar(5) NULL AFTER ONE_Longitud_Y_Latitud__Longitude__s; ALTER TABLE jobssaleforcecompleted ADD ONE_Acompanar__c varchar(5) NULL AFTER ONE_A_A_Invierno_26_27_O_Verano_19_21__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Acreditacion_Cenizas__c varchar(50) NULL AFTER ONE_Acompanar__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Afeitar__c varchar(5) NULL AFTER ONE_Acreditacion_Cenizas__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Aislamiento__c varchar(50) NULL AFTER ONE_Afeitar__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Amatista__c varchar(5) NULL AFTER ONE_Aislamiento__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Amortajar__c varchar(5) NULL AFTER ONE_Amatista__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Aseo_Neceser_Preparado__c varchar(5) NULL AFTER ONE_Amortajar__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Aseo_Precinto_Higienizacion_Inodoro__c varchar(5) NULL AFTER ONE_Aseo_Neceser_Preparado__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Aseo_Precinto_WC__c varchar(5) NULL AFTER ONE_Aseo_Precinto_Higienizacion_Inodoro__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Capilla__c varchar(5) NULL AFTER ONE_Aseo_Precinto_WC__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Capilla_Funebre__c varchar(5) NULL AFTER ONE_Capilla__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Capucha__c varchar(5) NULL AFTER ONE_Capilla_Funebre__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Catering_En_Sala__c varchar(5) NULL AFTER ONE_Capucha__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Cenizas_Entregadas__c varchar(5) NULL AFTER ONE_Catering_En_Sala__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Cintas_De_Inscripcion_Sin_Errores__c varchar(5) NULL AFTER ONE_Cenizas_Entregadas__c; ALTER TABLE jobssaleforcecompleted ADD ONE_CMD__c varchar(5) NULL AFTER ONE_Cintas_De_Inscripcion_Sin_Errores__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Codigo_Postal__c varchar(50) NULL AFTER ONE_CMD__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Color_Labios__c varchar(50) NULL AFTER ONE_Codigo_Postal__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Color_Unas__c varchar(50) NULL AFTER ONE_Color_Labios__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Columbario__c varchar(5) NULL AFTER ONE_Color_Unas__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Complementos_Segmentacion__c varchar(5) NULL AFTER ONE_Columbario__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Con_Cruz__c varchar(5) NULL AFTER ONE_Complementos_Segmentacion__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Con_Imagen__c varchar(5) NULL AFTER ONE_Con_Cruz__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Conservacion__c varchar(5) NULL AFTER ONE_Con_Imagen__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Coral__c varchar(5) NULL AFTER ONE_Conservacion__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Cortina_Operativa__c varchar(5) NULL AFTER ONE_Coral__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Cripta__c varchar(5) NULL AFTER ONE_Cortina_Operativa__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Cuarzo__c varchar(5) NULL AFTER ONE_Cripta__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Detalle_Afeitado__c varchar(50) NULL AFTER ONE_Cuarzo__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Detalle_Peinado__c varchar(50) NULL AFTER ONE_Detalle_Afeitado__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Difunto__c varchar(5) NULL AFTER ONE_Detalle_Peinado__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Direccion__c varchar(50) NULL AFTER ONE_Difunto__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Direccion_De_Entrega__c varchar(50) NULL AFTER ONE_Direccion__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Disposicion_Correcta_Del_Difunto__c varchar(5) NULL AFTER ONE_Direccion_De_Entrega__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Disposicion_Correcta_Y_Equilibrada__c varchar(5) NULL AFTER ONE_Disposicion_Correcta_Del_Difunto__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Disposicion_Del_Feretro_En_La_Sala__c varchar(5) NULL AFTER ONE_Disposicion_Correcta_Y_Equilibrada__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Documentos_Legales_Firmados__c varchar(5) NULL AFTER ONE_Disposicion_Del_Feretro_En_La_Sala__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Embalsamar__c varchar(5) NULL AFTER ONE_Documentos_Legales_Firmados__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Esquelas__c varchar(5) NULL AFTER ONE_Embalsamar__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Estado_De_Las_Flores__c varchar(5) NULL AFTER ONE_Esquelas__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Faldon_Colocado_Correctamente__c varchar(5) NULL AFTER ONE_Estado_De_Las_Flores__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Familia_Presente__c varchar(5) NULL AFTER ONE_Faldon_Colocado_Correctamente__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Fecha_Hora_Recogida_Cenizas__c varchar(50) NULL AFTER ONE_Familia_Presente__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Fecha_Limite_Entrega_De_Cenizas__c varchar(50) NULL AFTER ONE_Fecha_Hora_Recogida_Cenizas__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Feretro__c varchar(5) NULL AFTER ONE_Fecha_Limite_Entrega_De_Cenizas__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Feretro_Ecologico__c varchar(5) NULL AFTER ONE_Feretro__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Filtro__c varchar(5) NULL AFTER ONE_Feretro_Ecologico__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Flores__c varchar(5) NULL AFTER ONE_Filtro__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Flores_Familia__c varchar(5) NULL AFTER ONE_Flores__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Flores_Y_Cintas__c varchar(5) NULL AFTER ONE_Flores_Familia__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Foto_A_Difunto_Realizada__c varchar(5) NULL AFTER ONE_Flores_Y_Cintas__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Func_Telf_Contacto_Recepcion__c varchar(5) NULL AFTER ONE_Foto_A_Difunto_Realizada__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Habito__c varchar(5) NULL AFTER ONE_Func_Telf_Contacto_Recepcion__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Identificacion_QR_Correcta__c varchar(5) NULL AFTER ONE_Habito__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Identificacion_QR_Manual__c varchar(50) NULL AFTER ONE_Identificacion_QR_Correcta__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Identificacion_QR_SKU_Correcta__c varchar(5) NULL AFTER ONE_Identificacion_QR_Manual__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Idioma__c varchar(50) NULL AFTER ONE_Identificacion_QR_SKU_Correcta__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Iluminacion_Correcta__c varchar(5) NULL AFTER ONE_Idioma__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Incidencias_Durante_La_Revision__c varchar(50) NULL AFTER ONE_Iluminacion_Correcta__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Incidencias_Revision_Con_La_Familia__c varchar(50) NULL AFTER ONE_Incidencias_Durante_La_Revision__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Informar_Aspectos_Sala__c varchar(5) NULL AFTER ONE_Incidencias_Revision_Con_La_Familia__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Informar_Forma_Contacto_Recepcion__c varchar(5) NULL AFTER ONE_Informar_Aspectos_Sala__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Informar_Horarios_Y_Destinos__c varchar(5) NULL AFTER ONE_Informar_Forma_Contacto_Recepcion__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Informar_Protocolo_De_Salida__c varchar(5) NULL AFTER ONE_Informar_Horarios_Y_Destinos__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Jade__c varchar(5) NULL AFTER ONE_Informar_Protocolo_De_Salida__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Libro_De_Firmas__c varchar(5) NULL AFTER ONE_Jade__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Libro_De_Firmas_Familia__c varchar(5) NULL AFTER ONE_Libro_De_Firmas__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Licencia__c varchar(5) NULL AFTER ONE_Libro_De_Firmas_Familia__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Limpieza_Correcto_Estado_Sin_Golpes__c varchar(5) NULL AFTER ONE_Licencia__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Limpieza_General__c varchar(5) NULL AFTER ONE_Limpieza_Correcto_Estado_Sin_Golpes__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Limpieza_Suelos_Cortina_Paredes__c varchar(5) NULL AFTER ONE_Limpieza_General__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Localizacion_Unidad_Enterramiento__c varchar(50) NULL AFTER ONE_Limpieza_Suelos_Cortina_Paredes__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Lugar__c varchar(50) NULL AFTER ONE_Localizacion_Unidad_Enterramiento__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Lugar__r_Name varchar(150) NULL AFTER ONE_Lugar__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Maquillaje__c varchar(50) NULL AFTER ONE_Lugar__r_Name; ALTER TABLE jobssaleforcecompleted ADD ONE_Marcapasos__c varchar(5) NULL AFTER ONE_Maquillaje__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Mausoleo__c varchar(5) NULL AFTER ONE_Marcapasos__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Modelo_De_Feretro__c varchar(50) NULL AFTER ONE_Mausoleo__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Municipio__c varchar(50) NULL AFTER ONE_Modelo_De_Feretro__c; ALTER TABLE jobssaleforcecompleted ADD ONE_N_Placa__c varchar(50) NULL AFTER ONE_Municipio__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Nicho_Nuevo__c varchar(5) NULL AFTER ONE_N_Placa__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Nicho_Ocupado__c varchar(5) NULL AFTER ONE_Nicho_Nuevo__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Nombre_Del_Difunto_En_Tumulo__c varchar(5) NULL AFTER ONE_Nicho_Ocupado__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Nombre_Persona_Recogida_Cenizas__c varchar(250) NULL AFTER ONE_Nombre_Del_Difunto_En_Tumulo__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Numero_Identificador_Cremacion__c varchar(50) NULL AFTER ONE_Nombre_Persona_Recogida_Cenizas__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Pais__c varchar(50) NULL AFTER ONE_Numero_Identificador_Cremacion__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Peinado__c varchar(5) NULL AFTER ONE_Pais__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Permiso_Cremacion__c varchar(5) NULL AFTER ONE_Peinado__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Placa_Id_Feretro_Correcta__c varchar(5) NULL AFTER ONE_Permiso_Cremacion__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Placa_Identificativa__c varchar(50) NULL AFTER ONE_Placa_Id_Feretro_Correcta__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Presentacion__c varchar(50) NULL AFTER ONE_Placa_Identificativa__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Presentacion_Del_Difunto__c varchar(5) NULL AFTER ONE_Presentacion__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Presentacion_Difunto_Correcto__c varchar(5) NULL AFTER ONE_Presentacion_Del_Difunto__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Provincia__c varchar(50) NULL AFTER ONE_Presentacion_Difunto_Correcto__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Recoge_Cenizas__c varchar(50) NULL AFTER ONE_Provincia__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Recordatorios__c varchar(5) NULL AFTER ONE_Recoge_Cenizas__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Recordatorios_Familia__c varchar(5) NULL AFTER ONE_Recordatorios__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Refrigerado_4_Maximo_5_Norma_15017__c varchar(5) NULL AFTER ONE_Recordatorios_Familia__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Requiere_Foto_A_Difunto__c varchar(5) NULL AFTER ONE_Refrigerado_4_Maximo_5_Norma_15017__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Requiere_Identificacion_QR__c varchar(5) NULL AFTER ONE_Requiere_Foto_A_Difunto__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Requiere_Identificacion_QR_Del_SKU__c varchar(5) NULL AFTER ONE_Requiere_Identificacion_QR__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Retirada_De_La_Lapida__c varchar(5) NULL AFTER ONE_Requiere_Identificacion_QR_Del_SKU__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Revisar_Con_Familia__c varchar(5) NULL AFTER ONE_Retirada_De_La_Lapida__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Sabana__c varchar(5) NULL AFTER ONE_Revisar_Con_Familia__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Sala__c varchar(50) NULL AFTER ONE_Sabana__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Sala__r_Name varchar(150) NULL AFTER ONE_Sala__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Sala_Checklist__c varchar(5) NULL AFTER ONE_Sala__r_Name; ALTER TABLE jobssaleforcecompleted ADD ONE_Sepultura__c varchar(5) NULL AFTER ONE_Sala_Checklist__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Servicio_Musical__c varchar(5) NULL AFTER ONE_Sepultura__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Servicios_Acompanamiento_Al_Duelo__c varchar(5) NULL AFTER ONE_Servicio_Musical__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Sudario__c varchar(5) NULL AFTER ONE_Servicios_Acompanamiento_Al_Duelo__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Talla__c varchar(50) NULL AFTER ONE_Sudario__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Tanatoestetica__c varchar(5) NULL AFTER ONE_Talla__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Tanatopraxia__c varchar(5) NULL AFTER ONE_Tanatoestetica__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Tapa_Feretro_Vertical_Dentro_Tumulo__c varchar(5) NULL AFTER ONE_Tanatopraxia__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Tarjeta_De_Condolencia__c varchar(5) NULL AFTER ONE_Tapa_Feretro_Vertical_Dentro_Tumulo__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Texto_Completo__c varchar(50) NULL AFTER ONE_Tarjeta_De_Condolencia__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Texto_Corto__c varchar(50) NULL AFTER ONE_Texto_Completo__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Tipo_De_Destino_De_Cenizas__c varchar(50) NULL AFTER ONE_Texto_Corto__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Tipo_De_Ritual__c varchar(50) NULL AFTER ONE_Tipo_De_Destino_De_Cenizas__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Traje__c varchar(5) NULL AFTER ONE_Tipo_De_Ritual__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Traje_Vestido__c varchar(5) NULL AFTER ONE_Traje__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Tumulo__c varchar(5) NULL AFTER ONE_Traje_Vestido__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Vehiculo_Coronario__c varchar(5) NULL AFTER ONE_Tumulo__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Vestido_Modelo__c varchar(50) NULL AFTER ONE_Vehiculo_Coronario__c; ALTER TABLE jobssaleforcecompleted ADD ONE_Vestir__c varchar(5) NULL AFTER ONE_Vestido_Modelo__c; ALTER TABLE jobssaleforcecompleted ADD vehicleId varchar(25) NULL AFTER ONE_Vestir__c; ALTER TABLE jobssaleforcecompleted ADD puestoName varchar(100) NULL AFTER vehicleId; ALTER TABLE jobssaleforcecompleted ADD startDate varchar(100) NULL AFTER puestoName; ALTER TABLE jobssaleforcecompleted ADD endDate varchar(100) NULL AFTER startDate; ALTER TABLE jobssaleforcecompleted ADD startForm varchar(25) NULL AFTER endDate; ALTER TABLE jobssaleforcecompleted ADD endForm varchar(25) NULL AFTER startForm; ALTER TABLE `jobssaleforcecompleted` DROP `Name`; ALTER TABLE `jobssaleforcecompleted` DROP `vehicleId`; ALTER TABLE `jobssaleforcecompleted` DROP `puestoName`; ALTER TABLE `jobssaleforcecompleted` DROP `startDate`; ALTER TABLE `jobssaleforcecompleted` DROP `endDate`; ALTER TABLE `jobssaleforcecompleted` DROP `startForm`; ALTER TABLE `jobssaleforcecompleted` DROP `endForm`; ALTER TABLE `jobssaleforce` ADD `isInterna` VARCHAR(5) CHARACTER SET utf8 COLLATE utf8_spanish2_ci NULL AFTER `provider`; ALTER TABLE `jobssaleforcecanceled` ADD `isInterna` VARCHAR(5) CHARACTER SET utf8 COLLATE utf8_spanish2_ci NULL AFTER `provider`; ALTER TABLE `jobssaleforcecompleted` ADD `isInterna` VARCHAR(5) CHARACTER SET utf8 COLLATE utf8_spanish2_ci NULL AFTER `provider`; ALTER TABLE `jobssaleforce` ADD `formResultReceived` BLOB NULL AFTER `formResultIdDestino`; ALTER TABLE `jobssaleforcecanceled` ADD `formResultReceived` BLOB NULL AFTER `formResultIdDestino`; ALTER TABLE `jobssaleforcecompleted` ADD `formResultReceived` BLOB NULL AFTER `formResultIdDestino`; ALTER TABLE `places` ADD `typeId` VARCHAR(5) NULL AFTER `typeName`; Name → ONE_Tarea__r_Name vehicleId → idVehicle puestoName → licensePlate startDate → dateStartInProgress endDate → dateFinishOrder1 startForm → dateStartOrder2 endForm → dateFinishOrder2 NUEVO CAMPO PARA IDENTIFICAR SI ES INTERNA(null=conduccion, TRUE=1) jobssaleforce jobssaleforcecompleted jobssaleforcecanceled assignmentsjobssaleforce(se puede borrar esta tabla)