#!/bin/bash
# PRERREQUISITOS
# 0. Entrar con user ROOT
# 1. Crear una carpeta en el FTP
# mkdir /home/MemoraFTP/ftp/MemoraV2/
# mkdir /home/MemoraFTP/ftp/MemoraV2/memoraGitHub/
# mkdir /home/MemoraFTP/ftp/maintenance/
# chown -R MemoraFTP: /home/MemoraFTP/ftp/maintenance/
# chown MemoraFTP: /home/MemoraFTP/ftp/MemoraV2/
# chown MemoraFTP: /home/MemoraFTP/ftp/MemoraV2/memoraGitHub/
# 2. En esta carpeta copiar todo lo que se tendrá que subir a producción
# 3. Hacer backup de Base de datos y archivos WEB
# 4. Crear el link a la web de mantenimiento: ln -s /home/MemoraFTP/ftp/maintenance/ /var/www/maintenance
cp -a /home/MemoraFTP/ftp/Memora/ /home/MemoraFTP/ftp/MemoraBackup/;
service apache2 stop;
cp /home/MemoraFTP/ftp/maintenance/000-default-le-ssl-maintenance.conf /etc/apache2/sites-enabled/000-default-le-ssl.conf;
service apache2 start;
crontab /home/MemoraFTP/ftp/maintenance/crontab2.txt;
echo 'Muestro .php activos antes de borrar';
ps -ax | grep ".php$";
sleep 5s;
pkill -f ".php$";
echo 'Muestro .php pendientes';
ps -ax | grep ".php$";
echo "¿Todos los procesos finalizados?, SEGUIMOS";
sleep 60s;
echo 'Ejecuto Backup de base de datos';
sqlbak -rj -ji 35240;
echo "Backup MySQL finalizado, SEGUIMOS";
sleep 60s;
service mysql stop;
cp /home/MemoraFTP/ftp/MemoraV2/memoraGitHub/maintenance/mysqld.cnf /etc/mysql/mysql.conf.d/mysqld.cnf;
service mysql start;
echo 'Server Mysql is UP';
mysql -u root -p@Policia1312 memora <<EOF
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;
ALTER TABLE jobssaleforce ADD visitsToCoordinatesRequestId VARCHAR(50) NULL AFTER formResultReceived;
ALTER TABLE jobssaleforcecanceled ADD visitsToCoordinatesRequestId VARCHAR(50) NULL AFTER formResultReceived;
ALTER TABLE jobssaleforcecompleted ADD visitsToCoordinatesRequestId VARCHAR(50) NULL AFTER formResultReceived;
EOF
echo "MySQL finalizado, SEGUIMOS";
sleep 60s;
rm -R /home/MemoraFTP/ftp/Memora/memoraGitHub/;
cp -R /home/MemoraFTP/ftp/MemoraV2/memoraGitHub/ /home/MemoraFTP/ftp/Memora/memoraGitHub/;
chown -R MemoraFTP: /home/MemoraFTP/ftp/Memora/memoraGitHub/;
mkdir /home/MemoraFTP/ftp/Memora/memoraGitHub/assets/workers/logs;
chown -R MemoraFTP: /home/MemoraFTP/ftp/Memora/memoraGitHub/assets/workers/logs;
mkdir /home/MemoraFTP/ftp/Memora/memoraGitHub/assets/pdfToUpload;
chown -R MemoraFTP: /home/MemoraFTP/ftp/Memora/memoraGitHub/assets/pdfToUpload;
chmod -R 755 /home/MemoraFTP/ftp/Memora/memoraGitHub/;
chmod 755 /home/MemoraFTP/ftp/Memora/memoraGitHub/login.php;
chmod 755 /home/MemoraFTP/ftp/Memora/memoraGitHub/planificadorRecogidas.php;
chmod 755 /home/MemoraFTP/ftp/Memora/memoraGitHub/planificadorTraslados.php;
chmod 755 /home/MemoraFTP/ftp/Memora/memoraGitHub/planificadorTareasInternas.php;
chmod -R 755 /home/MemoraFTP/ftp/Memora/memoraGitHub/assets/img/;
chmod -R 755 /home/MemoraFTP/ftp/Memora/memoraGitHub/assets/css/;
chmod -R 755 /home/MemoraFTP/ftp/Memora/memoraGitHub/assets/js/;
chmod 755 /home/MemoraFTP/ftp/Memora/memoraGitHub/assets/workers/insertJobsSaleforce.php;
chmod 755 /home/MemoraFTP/ftp/Memora/memoraGitHub/assets/workers/checkConflicts.php;
chmod 755 /home/MemoraFTP/ftp/Memora/memoraGitHub/assets/workers/updateFromSaleforce.php;
chmod 755 /home/MemoraFTP/ftp/Memora/memoraGitHub/assets/workers/updateDassTime.php;
chmod 755 /home/MemoraFTP/ftp/Memora/memoraGitHub/assets/workers/activarDesactivarModoAutomatico.php;
chmod 755 /home/MemoraFTP/ftp/Memora/memoraGitHub/assets/workers/programarModoAutomatico.php;
chmod 700 /home/MemoraFTP/ftp/Memora/memoraGitHub/assets/workers/asignarModoAutomatico.php;
chmod 755 /home/MemoraFTP/ftp/Memora/memoraGitHub/assets/workers/enviarPlanificacion.php;
chmod 755 /home/MemoraFTP/ftp/Memora/memoraGitHub/assets/workers/addNewJobRecogidas.php;
chmod 755 /home/MemoraFTP/ftp/Memora/memoraGitHub/assets/workers/addNewJobTraslados.php;
chmod 755 /home/MemoraFTP/ftp/Memora/memoraGitHub/assets/workers/modifyJobRecogidas.php;
chmod 755 /home/MemoraFTP/ftp/Memora/memoraGitHub/assets/workers/modifyJobTraslados.php;
chmod 755 /home/MemoraFTP/ftp/Memora/memoraGitHub/assets/workers/completeJobRecogidas.php;
chmod 755 /home/MemoraFTP/ftp/Memora/memoraGitHub/assets/workers/completeJobTraslados.php;
chmod 755 /home/MemoraFTP/ftp/Memora/memoraGitHub/assets/workers/crearVisualizadorPersonalizadoRecogidas.php;
chmod 755 /home/MemoraFTP/ftp/Memora/memoraGitHub/assets/workers/crearVisualizadorPersonalizadoTraslados.php;
chmod 755 /home/MemoraFTP/ftp/Memora/memoraGitHub/assets/workers/validateUser.php;
chmod 755 /home/MemoraFTP/ftp/Memora/memoraGitHub/assets/workersInternas/completeJobTareasInternas.php;
chmod 755 /home/MemoraFTP/ftp/Memora/memoraGitHub/assets/connection.php;
chmod 755 /home/MemoraFTP/ftp/Memora/memoraGitHub/assets/functions.php;
chmod 755 /home/MemoraFTP/ftp/Memora/memoraGitHub/assets/authorize.php;
chmod -R 700 /home/MemoraFTP/ftp/Memora/memoraGitHub/assets/fpdf/;
chmod -R 700 /home/MemoraFTP/ftp/Memora/memoraGitHub/assets/workers/crontabTest/;
chmod -R 700 /home/MemoraFTP/ftp/Memora/memoraGitHub/assets/workers/workersPreparacion/;
chmod -R 700 /home/MemoraFTP/ftp/Memora/memoraGitHub/maintenance/;
rm -R /home/MemoraFTP/ftp/Memora/memoraGitHub/assets/sqlDB/;
rm -R /home/MemoraFTP/ftp/Memora/memoraGitHub/assets/workers/crontabTest/;
rm -R /home/MemoraFTP/ftp/Memora/memoraGitHub/assets/workers/workersPreparacion/;
php /var/www/memoraGitHub/assets/workers/getCopiaTareas.php;
service apache2 stop;
cp /home/MemoraFTP/ftp/maintenance/000-default-le-ssl.conf /etc/apache2/sites-enabled/000-default-le-ssl.conf;
service apache2 start;
echo "Ha acabado voy a empezar con el CRONTAB";
sleep 20s;
crontab /home/MemoraFTP/ftp/maintenance/crontab.txt;