ALTER TABLE t_agence ADD COLUMN LATITUDE FLOAT DEFAULT 0;
ALTER TABLE t_agence ADD COLUMN LONGITUDE FLOAT DEFAULT 0;

ALTER TABLE GNSS_PLACE ADD COLUMN VEHICLE_ID INTEGER DEFAULT 0;
ALTER TABLE GNSS_PLACE ADD COLUMN LATITUDE FLOAT DEFAULT 0;
ALTER TABLE GNSS_PLACE ADD COLUMN LONGITUDE FLOAT DEFAULT 0;
ALTER TABLE GNSS_PLACE ADD COLUMN HEADING INTEGER DEFAULT 0;
ALTER TABLE GNSS_PLACE MODIFY COORDINATE VARCHAR(12) DEFAULT NULL;
ALTER TABLE GNSS_PLACE MODIFY DRIVER_ID INT(11) DEFAULT 0;
ALTER TABLE GNSS_PLACE DROP FOREIGN KEY gnss_place_ibfk_1;

ALTER TABLE t_frais ADD COLUMN EMPLOYEE_TYPE_ID TINYINT default 0;
ALTER TABLE t_frais ADD COLUMN EXPORT TINYINT default 0;

INSERT INTO TAUX_BASE (T115M, T118M, T120M, T128M, T138M, T150M, DATE_INSERTION, DATE_DEBUT) values (10.10, 10.10, 10.10, 10.13, 10.15, 10.39, '2019-06-01 00:00:00', '2019-06-01 00:00:00');