-- Se desactivan 11 localidades estableciendo el id_tiempo=0.
USE plocales;
UPDATE puntos SET id_tiempo=0 WHERE cod_pgeo >= 491629 AND cod_pgeo <= 491639;
DELETE FROM astro                 WHERE cod_pgeo >= 491629 AND cod_pgeo <= 491639;
DELETE FROM predicciones          WHERE cod_pgeo >= 491629 AND cod_pgeo <= 491639;
DELETE FROM predicciones_1        WHERE cod_pgeo >= 491629 AND cod_pgeo <= 491639;
DELETE FROM predicciones_2        WHERE cod_pgeo >= 491629 AND cod_pgeo <= 491639;
DELETE FROM predicciones_hist     WHERE cod_pgeo >= 491629 AND cod_pgeo <= 491639;
DELETE FROM predicciones_hor      WHERE cod_pgeo >= 491629 AND cod_pgeo <= 491639;
DELETE FROM predicciones_hor_1    WHERE cod_pgeo >= 491629 AND cod_pgeo <= 491639;
DELETE FROM predicciones_hor_2    WHERE cod_pgeo >= 491629 AND cod_pgeo <= 491639;
DELETE FROM predicciones_hor_hist WHERE cod_pgeo >= 491629 AND cod_pgeo <= 491639;
DELETE FROM predicciones_pruebas  WHERE cod_pgeo >= 491629 AND cod_pgeo <= 491639;



--scp *20171218* gbv@antartida.ogimet.com:~/updates_tablas
--ssh europa
--cd updates_tablas

--mysql -uroot -p plocales < update_puntos_20171218.sql
--mysql -uroot -p plocales < insert_puntos_20171218_A_Chile.sql
--mysql -uroot -p plocales < insert_puntos_20171218_B_Canada.sql

--su -c "nohup /usr/local/bin/astroloc_masivo 491671 499993 &" gfs
