CREATE TABLE `memora`.`equiposconduccion` ( `nombreEquipo` VARCHAR(150) NULL , `licensePlate` VARCHAR(15) NULL , `vehicleId` VARCHAR(20) NULL , `driverName` VARCHAR(50) NULL , `driverId` VARCHAR(20) NULL , `acompañanteName` VARCHAR(50) NULL , `acompañanteId` VARCHAR(20) NULL , `centroTest` VARCHAR(300) NOT NULL ) ENGINE = InnoDB;


ALTER TABLE `conductores` ADD `driverIdWFM` VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_spanish2_ci NULL AFTER `vehicleIdWFM`;

ALTER TABLE `vehiculos` ADD `driverIdWFM` VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_spanish2_ci NULL AFTER `numCentro`;


ALTER TABLE `vehiculos` ADD `driverNameWFM` VARCHAR(150) NULL AFTER `driverIdWFM`;



ALTER TABLE `conductores` ADD `lastDriverStatus` VARCHAR(1) NULL AFTER `department`;




PERMISOS:
chmod 755 /home/MemoraFTP/ftp/Memora/memoraGitHub/assets/workers/anadirEquiposConduccion.php
chmod 755 /home/MemoraFTP/ftp/Memora/memoraGitHub/assets/workers/asignarRutas.php

CRONTAB:
# 2 veces al día actualizamos los conductores de WFM para vincularlos
0 4 * * * php /var/www/memoraGitHub/assets/workers/getDriversWFM.php > /var/www/memoraGitHub/assets/workers/logs/getDriversWFM.log
0 16 * * * php /var/www/memoraGitHub/assets/workers/getDriversWFM.php > /var/www/memoraGitHub/assets/workers/logs/getDriversWFM.log