CREATE TABLE `assignmentsjobsinternassaleforce` ( `idSaleforce` varchar(50) COLLATE utf8mb4_spanish2_ci DEFAULT NULL, `vehicleId` int(11) DEFAULT NULL, `licensePlate` varchar(25) COLLATE utf8mb4_spanish2_ci DEFAULT NULL, `driverId` int(11) DEFAULT NULL, `driverName` varchar(50) COLLATE utf8mb4_spanish2_ci DEFAULT NULL, `action` varchar(25) COLLATE utf8mb4_spanish2_ci DEFAULT NULL, `updateDate` varchar(100) COLLATE utf8mb4_spanish2_ci DEFAULT NULL, `scheduledDate` varchar(100) COLLATE utf8mb4_spanish2_ci DEFAULT NULL, `smsBody` varchar(1000) COLLATE utf8mb4_spanish2_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_spanish2_ci; CREATE TABLE `jobssalesforceinternas` ( `Id` varchar(50) COLLATE utf8_spanish2_ci NOT NULL, `Name` varchar(200) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Nombre_Y_Apellidos_Del_Difunto__c` varchar(200) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Estado__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Expediente__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Expediente__r_Name` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Codigo_De_Centro__c` varchar(15) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Fecha_Y_Hora__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Fecha_Deseada__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Fecha_Limite__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_ID_Tarea_Frotcom__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_ID_Task_Frotcom_Origen__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Longitud_Y_Latitud__Latitude__s` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Longitud_Y_Latitud__Longitude__s` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_A_A_Invierno_26_27_O_Verano_19_21__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Acompanar__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Acreditacion_Cenizas__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Afeitar__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Aislamiento__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Amatista__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Amortajar__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Aseo_Neceser_Preparado__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Aseo_Precinto_Higienizacion_Inodoro__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Aseo_Precinto_WC__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Capilla__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Capilla_Funebre__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Capucha__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Catering_En_Sala__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Cenizas_Entregadas__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Cintas_De_Inscripcion_Sin_Errores__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_CMD__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_CMD_Disponible__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Codigo_Postal__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Color_Labios__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Color_Unas__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Columbario__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Comentarios__c` tinyblob DEFAULT NULL, `ONE_Comentarios_Sobre_Estado_De_Difunto__c` tinyblob DEFAULT NULL, `ONE_Complementos_Segmentacion__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Con_Cruz__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Con_Imagen__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Conservacion__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Coral__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Cortina_Operativa__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Cripta__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Cuarzo__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Descripcion_Del_Riesgo__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Detalle_Afeitado__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Detalle_Peinado__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Difunto__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Direccion__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Direccion_De_Entrega__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Disposicion_Correcta_Del_Difunto__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Disposicion_Correcta_Y_Equilibrada__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Disposicion_Del_Feretro_En_La_Sala__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Documentos_Legales_Firmados__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Embalsamar__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Esquelas__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Estado_De_Las_Flores__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Estado_Difunto_Correcto__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Faldon_Colocado_Correctamente__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Familia_Presente__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Fecha_Hora_Recogida_Cenizas__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Fecha_Limite_Entrega_De_Cenizas__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Feretro__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Feretro_Ecologico__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Filtro__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Flores__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Flores_Familia__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Flores_Y_Cintas__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Foto_A_Difunto_Realizada__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Func_Telf_Contacto_Recepcion__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Habito__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Identificacion_QR_Correcta__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Identificacion_QR_Manual__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Identificacion_QR_SKU_Correcta__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Idioma__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Iluminacion_Correcta__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Incidencias_Durante_La_Revision__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Incidencias_Revision_Con_La_Familia__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Informar_Aspectos_Sala__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Informar_Forma_Contacto_Recepcion__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Informar_Horarios_Y_Destinos__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Informar_Protocolo_De_Salida__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Jade__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Libro_De_Firmas__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Libro_De_Firmas_Familia__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Licencia__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Limpieza_Correcto_Estado_Sin_Golpes__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Limpieza_General__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Limpieza_Suelos_Cortina_Paredes__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Localizacion_Unidad_Enterramiento__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Lugar__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Lugar__r_Name` varchar(150) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Maquillaje__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Marcapasos__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Mausoleo__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Modelo_De_Feretro__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Municipio__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_N_Placa__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Nicho_Nuevo__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Nicho_Ocupado__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Nombre_Del_Difunto_En_Tumulo__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Nombre_Persona_Recogida_Cenizas__c` varchar(250) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Numero_Identificador_Cremacion__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Pais__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Peinado__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Permiso_Cremacion__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Placa_Id_Feretro_Correcta__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Placa_Identificativa__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Posicion_De_La_Tapa__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Presentacion__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Presentacion_Del_Difunto__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Presentacion_Difunto_Correcto__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Provincia__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Recoge_Cenizas__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Recordatorios__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Recordatorios_Familia__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Refrigerado_4_Maximo_5_Norma_15017__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Requiere_Foto_A_Difunto__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Requiere_Identificacion_QR__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Requiere_Identificacion_QR_Del_SKU__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Retirada_De_La_Lapida__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Revisar_Con_Familia__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Riesgo__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Sabana__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Sala__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Sala__r_Name` varchar(150) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Sala_Checklist__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Sepultura__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Servicio_Musical__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Servicios_Acompanamiento_Al_Duelo__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Sudario__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Talla__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Tanatoestetica__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Tanatopraxia__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Tapa_Feretro_Vertical_Dentro_Tumulo__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Tarjeta_De_Condolencia__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Texto_Completo__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Texto_Corto__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Tipo_De_Destino_De_Cenizas__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Tipo_De_Ritual__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Traje__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Traje_Vestido__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Tumulo__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Vehiculo_Coronario__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Vehiculos_Acompanamiento__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Vestido_Modelo__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Vestir__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `provider` varchar(25) COLLATE utf8_spanish2_ci DEFAULT NULL, `scheduledDate` varchar(100) COLLATE utf8_spanish2_ci DEFAULT NULL, `vehicleId` varchar(25) COLLATE utf8_spanish2_ci DEFAULT NULL, `puestoName` varchar(25) COLLATE utf8_spanish2_ci DEFAULT NULL, `driverId` varchar(25) COLLATE utf8_spanish2_ci DEFAULT NULL, `driverName` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `startDate` varchar(100) COLLATE utf8_spanish2_ci DEFAULT NULL, `endDate` varchar(100) COLLATE utf8_spanish2_ci DEFAULT NULL, `startForm` varchar(25) COLLATE utf8_spanish2_ci DEFAULT NULL, `endForm` varchar(25) COLLATE utf8_spanish2_ci DEFAULT NULL, `manualCompleted` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish2_ci; CREATE TABLE `jobssalesforceinternascanceled` ( `Id` varchar(50) COLLATE utf8_spanish2_ci NOT NULL, `Name` varchar(200) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Nombre_Y_Apellidos_Del_Difunto__c` varchar(200) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Estado__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Expediente__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Expediente__r_Name` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Codigo_De_Centro__c` varchar(15) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Fecha_Y_Hora__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Fecha_Deseada__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Fecha_Limite__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_ID_Tarea_Frotcom__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_ID_Task_Frotcom_Origen__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Longitud_Y_Latitud__Latitude__s` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Longitud_Y_Latitud__Longitude__s` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_A_A_Invierno_26_27_O_Verano_19_21__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Acompanar__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Acreditacion_Cenizas__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Afeitar__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Aislamiento__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Amatista__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Amortajar__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Aseo_Neceser_Preparado__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Aseo_Precinto_Higienizacion_Inodoro__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Aseo_Precinto_WC__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Capilla__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Capilla_Funebre__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Capucha__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Catering_En_Sala__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Cenizas_Entregadas__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Cintas_De_Inscripcion_Sin_Errores__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_CMD__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_CMD_Disponible__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Codigo_Postal__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Color_Labios__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Color_Unas__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Columbario__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Comentarios__c` tinyblob DEFAULT NULL, `ONE_Comentarios_Sobre_Estado_De_Difunto__c` tinyblob DEFAULT NULL, `ONE_Complementos_Segmentacion__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Con_Cruz__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Con_Imagen__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Conservacion__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Coral__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Cortina_Operativa__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Cripta__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Cuarzo__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Descripcion_Del_Riesgo__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Detalle_Afeitado__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Detalle_Peinado__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Difunto__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Direccion__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Direccion_De_Entrega__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Disposicion_Correcta_Del_Difunto__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Disposicion_Correcta_Y_Equilibrada__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Disposicion_Del_Feretro_En_La_Sala__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Documentos_Legales_Firmados__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Embalsamar__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Esquelas__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Estado_De_Las_Flores__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Estado_Difunto_Correcto__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Faldon_Colocado_Correctamente__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Familia_Presente__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Fecha_Hora_Recogida_Cenizas__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Fecha_Limite_Entrega_De_Cenizas__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Feretro__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Feretro_Ecologico__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Filtro__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Flores__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Flores_Familia__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Flores_Y_Cintas__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Foto_A_Difunto_Realizada__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Func_Telf_Contacto_Recepcion__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Habito__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Identificacion_QR_Correcta__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Identificacion_QR_Manual__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Identificacion_QR_SKU_Correcta__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Idioma__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Iluminacion_Correcta__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Incidencias_Durante_La_Revision__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Incidencias_Revision_Con_La_Familia__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Informar_Aspectos_Sala__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Informar_Forma_Contacto_Recepcion__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Informar_Horarios_Y_Destinos__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Informar_Protocolo_De_Salida__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Jade__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Libro_De_Firmas__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Libro_De_Firmas_Familia__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Licencia__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Limpieza_Correcto_Estado_Sin_Golpes__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Limpieza_General__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Limpieza_Suelos_Cortina_Paredes__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Localizacion_Unidad_Enterramiento__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Lugar__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Lugar__r_Name` varchar(150) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Maquillaje__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Marcapasos__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Mausoleo__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Modelo_De_Feretro__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Municipio__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_N_Placa__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Nicho_Nuevo__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Nicho_Ocupado__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Nombre_Del_Difunto_En_Tumulo__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Nombre_Persona_Recogida_Cenizas__c` varchar(250) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Numero_Identificador_Cremacion__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Pais__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Peinado__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Permiso_Cremacion__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Placa_Id_Feretro_Correcta__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Placa_Identificativa__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Posicion_De_La_Tapa__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Presentacion__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Presentacion_Del_Difunto__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Presentacion_Difunto_Correcto__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Provincia__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Recoge_Cenizas__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Recordatorios__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Recordatorios_Familia__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Refrigerado_4_Maximo_5_Norma_15017__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Requiere_Foto_A_Difunto__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Requiere_Identificacion_QR__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Requiere_Identificacion_QR_Del_SKU__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Retirada_De_La_Lapida__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Revisar_Con_Familia__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Riesgo__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Sabana__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Sala__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Sala__r_Name` varchar(150) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Sala_Checklist__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Sepultura__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Servicio_Musical__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Servicios_Acompanamiento_Al_Duelo__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Sudario__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Talla__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Tanatoestetica__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Tanatopraxia__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Tapa_Feretro_Vertical_Dentro_Tumulo__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Tarjeta_De_Condolencia__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Texto_Completo__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Texto_Corto__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Tipo_De_Destino_De_Cenizas__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Tipo_De_Ritual__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Traje__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Traje_Vestido__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Tumulo__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Vehiculo_Coronario__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Vehiculos_Acompanamiento__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Vestido_Modelo__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Vestir__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `provider` varchar(25) COLLATE utf8_spanish2_ci DEFAULT NULL, `scheduledDate` varchar(100) COLLATE utf8_spanish2_ci DEFAULT NULL, `vehicleId` varchar(25) COLLATE utf8_spanish2_ci DEFAULT NULL, `puestoName` varchar(25) COLLATE utf8_spanish2_ci DEFAULT NULL, `driverId` varchar(25) COLLATE utf8_spanish2_ci DEFAULT NULL, `driverName` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `startDate` varchar(100) COLLATE utf8_spanish2_ci DEFAULT NULL, `endDate` varchar(100) COLLATE utf8_spanish2_ci DEFAULT NULL, `startForm` varchar(25) COLLATE utf8_spanish2_ci DEFAULT NULL, `endForm` varchar(25) COLLATE utf8_spanish2_ci DEFAULT NULL, `manualCompleted` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish2_ci; CREATE TABLE `jobssalesforceinternascompleted` ( `Id` varchar(50) COLLATE utf8_spanish2_ci NOT NULL, `Name` varchar(200) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Nombre_Y_Apellidos_Del_Difunto__c` varchar(200) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Estado__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Expediente__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Expediente__r_Name` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Codigo_De_Centro__c` varchar(15) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Fecha_Y_Hora__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Fecha_Deseada__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Fecha_Limite__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_ID_Tarea_Frotcom__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_ID_Task_Frotcom_Origen__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Longitud_Y_Latitud__Latitude__s` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Longitud_Y_Latitud__Longitude__s` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_A_A_Invierno_26_27_O_Verano_19_21__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Acompanar__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Acreditacion_Cenizas__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Afeitar__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Aislamiento__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Amatista__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Amortajar__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Aseo_Neceser_Preparado__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Aseo_Precinto_Higienizacion_Inodoro__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Aseo_Precinto_WC__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Capilla__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Capilla_Funebre__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Capucha__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Catering_En_Sala__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Cenizas_Entregadas__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Cintas_De_Inscripcion_Sin_Errores__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_CMD__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_CMD_Disponible__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Codigo_Postal__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Color_Labios__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Color_Unas__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Columbario__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Comentarios__c` tinyblob DEFAULT NULL, `ONE_Comentarios_Sobre_Estado_De_Difunto__c` tinyblob DEFAULT NULL, `ONE_Complementos_Segmentacion__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Con_Cruz__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Con_Imagen__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Conservacion__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Coral__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Cortina_Operativa__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Cripta__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Cuarzo__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Descripcion_Del_Riesgo__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Detalle_Afeitado__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Detalle_Peinado__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Difunto__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Direccion__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Direccion_De_Entrega__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Disposicion_Correcta_Del_Difunto__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Disposicion_Correcta_Y_Equilibrada__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Disposicion_Del_Feretro_En_La_Sala__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Documentos_Legales_Firmados__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Embalsamar__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Esquelas__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Estado_De_Las_Flores__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Estado_Difunto_Correcto__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Faldon_Colocado_Correctamente__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Familia_Presente__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Fecha_Hora_Recogida_Cenizas__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Fecha_Limite_Entrega_De_Cenizas__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Feretro__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Feretro_Ecologico__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Filtro__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Flores__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Flores_Familia__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Flores_Y_Cintas__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Foto_A_Difunto_Realizada__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Func_Telf_Contacto_Recepcion__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Habito__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Identificacion_QR_Correcta__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Identificacion_QR_Manual__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Identificacion_QR_SKU_Correcta__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Idioma__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Iluminacion_Correcta__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Incidencias_Durante_La_Revision__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Incidencias_Revision_Con_La_Familia__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Informar_Aspectos_Sala__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Informar_Forma_Contacto_Recepcion__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Informar_Horarios_Y_Destinos__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Informar_Protocolo_De_Salida__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Jade__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Libro_De_Firmas__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Libro_De_Firmas_Familia__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Licencia__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Limpieza_Correcto_Estado_Sin_Golpes__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Limpieza_General__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Limpieza_Suelos_Cortina_Paredes__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Localizacion_Unidad_Enterramiento__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Lugar__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Lugar__r_Name` varchar(150) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Maquillaje__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Marcapasos__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Mausoleo__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Modelo_De_Feretro__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Municipio__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_N_Placa__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Nicho_Nuevo__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Nicho_Ocupado__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Nombre_Del_Difunto_En_Tumulo__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Nombre_Persona_Recogida_Cenizas__c` varchar(250) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Numero_Identificador_Cremacion__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Pais__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Peinado__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Permiso_Cremacion__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Placa_Id_Feretro_Correcta__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Placa_Identificativa__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Posicion_De_La_Tapa__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Presentacion__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Presentacion_Del_Difunto__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Presentacion_Difunto_Correcto__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Provincia__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Recoge_Cenizas__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Recordatorios__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Recordatorios_Familia__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Refrigerado_4_Maximo_5_Norma_15017__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Requiere_Foto_A_Difunto__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Requiere_Identificacion_QR__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Requiere_Identificacion_QR_Del_SKU__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Retirada_De_La_Lapida__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Revisar_Con_Familia__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Riesgo__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Sabana__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Sala__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Sala__r_Name` varchar(150) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Sala_Checklist__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Sepultura__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Servicio_Musical__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Servicios_Acompanamiento_Al_Duelo__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Sudario__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Talla__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Tanatoestetica__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Tanatopraxia__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Tapa_Feretro_Vertical_Dentro_Tumulo__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Tarjeta_De_Condolencia__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Texto_Completo__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Texto_Corto__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Tipo_De_Destino_De_Cenizas__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Tipo_De_Ritual__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Traje__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Traje_Vestido__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Tumulo__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Vehiculo_Coronario__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Vehiculos_Acompanamiento__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Vestido_Modelo__c` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `ONE_Vestir__c` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, `provider` varchar(25) COLLATE utf8_spanish2_ci DEFAULT NULL, `scheduledDate` varchar(100) COLLATE utf8_spanish2_ci DEFAULT NULL, `vehicleId` varchar(25) COLLATE utf8_spanish2_ci DEFAULT NULL, `puestoName` varchar(25) COLLATE utf8_spanish2_ci DEFAULT NULL, `driverId` varchar(25) COLLATE utf8_spanish2_ci DEFAULT NULL, `driverName` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `startDate` varchar(100) COLLATE utf8_spanish2_ci DEFAULT NULL, `endDate` varchar(100) COLLATE utf8_spanish2_ci DEFAULT NULL, `startForm` varchar(25) COLLATE utf8_spanish2_ci DEFAULT NULL, `endForm` varchar(25) COLLATE utf8_spanish2_ci DEFAULT NULL, `manualCompleted` varchar(5) COLLATE utf8_spanish2_ci DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish2_ci; CREATE TABLE `puestostrabajo` ( `vehicleId` varchar(25) COLLATE utf8_spanish2_ci NOT NULL, `puestoName` varchar(100) COLLATE utf8_spanish2_ci DEFAULT NULL, `placeName` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `placeId` varchar(25) COLLATE utf8_spanish2_ci DEFAULT NULL, `tipoTarea` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL, `centro` varchar(25) COLLATE utf8_spanish2_ci DEFAULT NULL, PRIMARY KEY (`vehicleId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish2_ci; ALTER TABLE `jobssaleforce` ADD `ONE_Expediente__r_ONE_Numero_Servicio_Ruta__c` VARCHAR(20) NULL AFTER `ONE_Expediente__r_ONE_Sala_De_Velacion__r_ONE_Agrupador__c`; ALTER TABLE `jobssaleforcecanceled` ADD `ONE_Expediente__r_ONE_Numero_Servicio_Ruta__c` VARCHAR(20) NULL AFTER `ONE_Expediente__r_ONE_Sala_De_Velacion__r_ONE_Agrupador__c`; ALTER TABLE `jobssaleforcecompleted` ADD `ONE_Expediente__r_ONE_Numero_Servicio_Ruta__c` VARCHAR(20) NULL AFTER `ONE_Expediente__r_ONE_Sala_De_Velacion__r_ONE_Agrupador__c`; ALTER TABLE `jobssaleforce` ADD `logRegisteredDate` VARCHAR(50) NULL AFTER `manualCompleted`, ADD `logUpdatedDate` VARCHAR(50) NULL AFTER `logRegisteredDate`, ADD `logAssignedDate` VARCHAR(50) NULL AFTER `logUpdatedDate`, ADD `logAssignedUsername` VARCHAR(50) NULL AFTER `logAssignedDate`, ADD `logDeassignedDate` VARCHAR(50) NULL AFTER `logAssignedUsername`, ADD `logDeassignedUsername` VARCHAR(50) NULL AFTER `logDeassignedDate`, ADD `logCompletedDate` VARCHAR(50) NULL AFTER `logDeassignedUsername`, ADD `logCompletedUsername` VARCHAR(50) NULL AFTER `logCompletedDate`, ADD `logScheduledDate` VARCHAR(50) NULL AFTER `logCompletedUsername`; ALTER TABLE `jobssaleforcecanceled` ADD `logRegisteredDate` VARCHAR(50) NULL AFTER `manualCompleted`, ADD `logUpdatedDate` VARCHAR(50) NULL AFTER `logRegisteredDate`, ADD `logAssignedDate` VARCHAR(50) NULL AFTER `logUpdatedDate`, ADD `logAssignedUsername` VARCHAR(50) NULL AFTER `logAssignedDate`, ADD `logDeassignedDate` VARCHAR(50) NULL AFTER `logAssignedUsername`, ADD `logDeassignedUsername` VARCHAR(50) NULL AFTER `logDeassignedDate`, ADD `logCompletedDate` VARCHAR(50) NULL AFTER `logDeassignedUsername`, ADD `logCompletedUsername` VARCHAR(50) NULL AFTER `logCompletedDate`, ADD `logScheduledDate` VARCHAR(50) NULL AFTER `logCompletedUsername`; ALTER TABLE `jobssaleforcecompleted` ADD `logRegisteredDate` VARCHAR(50) NULL AFTER `manualCompleted`, ADD `logUpdatedDate` VARCHAR(50) NULL AFTER `logRegisteredDate`, ADD `logAssignedDate` VARCHAR(50) NULL AFTER `logUpdatedDate`, ADD `logAssignedUsername` VARCHAR(50) NULL AFTER `logAssignedDate`, ADD `logDeassignedDate` VARCHAR(50) NULL AFTER `logAssignedUsername`, ADD `logDeassignedUsername` VARCHAR(50) NULL AFTER `logDeassignedDate`, ADD `logCompletedDate` VARCHAR(50) NULL AFTER `logDeassignedUsername`, ADD `logCompletedUsername` VARCHAR(50) NULL AFTER `logCompletedDate`, ADD `logScheduledDate` VARCHAR(50) NULL AFTER `logCompletedUsername`;