set @MANAGER_ID_ACCOUNT='ICI PLACER LE ID_LOG TECH DE LUTILISATEUR A SUPPRIMER';
 
delete from t_email where id_account=@MANAGER_ID_ACCOUNT;
delete from t_dataaccess_rule_user where id_account=@MANAGER_ID_ACCOUNT;
delete from t_phone where id_account=@MANAGER_ID_ACCOUNT;
delete from t_hist_state where id_tech_hist in  (select id_tech_event from t_event where id_alph_subject=@MANAGER_ID_ACCOUNT);
delete from t_password where id_tech_pwd  in (select id_tech_event from t_event where id_alph_subject=@MANAGER_ID_ACCOUNT);
delete from t_event where id_alph_subject=@MANAGER_ID_ACCOUNT; -- ne pas lancer cette ligne en journée 
delete from t_manager_service where id_manager in (select id_tech_manager from t_manager where id_account = @MANAGER_ID_ACCOUNT);
delete from t_manager where id_account = @MANAGER_ID_ACCOUNT;
delete from t_account where id_log_tech=@MANAGER_ID_ACCOUNT;
delete from t_address where id_address IN (select id_address from t_account where id_log_tech = @MANAGER_ID_ACCOUNT);


-- CI-DESSOUS VERSION TRES BOURINE UNIQUEMENT TESTE EN DEV !!!!
set @MANAGER_ID_ACCOUNT='ICI PLACER LE ID_LOG TECH DE LUTILISATEUR A SUPPRIMER';

delete from t_email where id_account=@MANAGER_ID_ACCOUNT;
delete from t_dataaccess_rule_user where id_account=@MANAGER_ID_ACCOUNT;
delete from t_phone where id_account=@MANAGER_ID_ACCOUNT;
delete from t_hist_state where id_tech_hist in  (select id_tech_event from t_event where id_alph_subject=@MANAGER_ID_ACCOUNT);
delete from t_password where id_tech_pwd  in (select id_tech_event from t_event where id_alph_subject=@MANAGER_ID_ACCOUNT);
delete from t_message_participants where id_message in (select id_message from t_message where id_event in (select id_tech_event from t_event where id_alph_subject=@MANAGER_ID_ACCOUNT));
delete from t_message where id_event in (select id_tech_event from t_event where id_alph_subject=@MANAGER_ID_ACCOUNT);
delete from t_event_case where id_event in (select id_tech_event from t_event where id_alph_subject=@MANAGER_ID_ACCOUNT);
delete from t_task where id_event in  (select id_tech_event from t_event where id_alph_subject=@MANAGER_ID_ACCOUNT);
delete from t_event where id_alph_subject=@MANAGER_ID_ACCOUNT;
delete from t_manager_service where id_manager in (select id_tech_manager from t_manager where id_account = @MANAGER_ID_ACCOUNT);
delete from t_manager where id_account = @MANAGER_ID_ACCOUNT;
delete from t_devis_diff where id_log_tech=@MANAGER_ID_ACCOUNT;
delete from t_request_histo where LAST_UPDATE_USER = @MANAGER_ID_ACCOUNT;
delete from t_req_msg_part_status where ID_REQ_MSG in (select id_req_msg from t_req_msg where sender = @MANAGER_ID_ACCOUNT);
delete from t_req_msg where sender = @MANAGER_ID_ACCOUNT;
delete from t_req_participant where REQ_PART_ACCT_ID = @MANAGER_ID_ACCOUNT;
delete from t_account where id_log_tech=@MANAGER_ID_ACCOUNT;
delete from t_address where id_address IN (select id_address from t_account where id_log_tech = @MANAGER_ID_ACCOUNT);