INSERT INTO client(code, name, agence) VALUES ('CL00090','RAMBOLL France SAS', 'Lyon');
INSERT INTO client(code, name, agence) VALUES ('CL00091','RAMBOLL France SAS', 'Paris');
INSERT INTO client(code, name, agence) VALUES ('CL01329','RAMBOLL France SAS', 'Bordeaux');
INSERT INTO client(code, name, agence) VALUES ('CL00089','RAMBOLL France SAS', 'Aix-En-Provence');
UPDATE fos_user SET client_id = 1 WHERE email = 'mblondain@ramboll.com';

INSERT INTO client(code, name, agence) VALUES ('CL00002','AECOM France', 'Paris');
UPDATE fos_user SET client_id = 5 WHERE email = 'Farid.Fouakhri@consultant.aecom.com';







