START TRANSACTION;
    INSERT INTO `financial_utilisateur` (`id_local_direction`, `nom`, `prenom`, `tel1`, `tel2`, `fax`, `mail`, `login`, `pass`, `date_chg_password`, `date_creation`, `actif`, `commentaire`, `intitule`, `type_utilisateur`, `id_local`, `matricule`, `is_rc_prescription`, `id_utilisateur_odal`, `matricule_conges`, `date_sortie_effectif`, `deactivate_command_done`)
VALUES
	(00038, 'ESPACE', 'Client', '0000000000', '', '', 'logiciel@pointfinances.fr', 'espace.client', '0cc175b9c0f1b6a831c399e269772661', '2025-04-03', '2023-05-15', 1, '', 'Monsieur', 'commercial_4', 00038, '', 0, NULL, '', NULL, 0);

    SET @id_utilisateur = LAST_INSERT_ID();

	INSERT INTO `financial_rule_utilisateur` (`id_rule`, `id_utilisateur`, `more_less`)
	SELECT id_rule, @id_utilisateur, 'Y' FROM financial_rule WHERE rule = 'UTILISATEUR_FICTIF' AND id_local = 38;

    INSERT INTO `financial_parametre` (`id_local`, `variable`, `valeur`, `type`)
    VALUES
	(00038, 'ESPACE_CLIENT_AUTH_ISSUER', 'https://ami-credit-recette.eu.auth0.com/', 'String'),
	(00038, 'ESPACE_CLIENT', 'true', 'Boolean'),
	(00038, 'ONGLET_ESPACE_CLIENT', 'true', 'Boolean'),
	(00038, 'ESPACE_CLIENT_AUTH_CLIENT_ID', 'Uawvd2bofwq5ANnaNRCsHLu85UTlhZGl', 'String'),
	(00038, 'ESPACE_CLIENT_AUTH_CLIENT_SECRET', 'NDZnwoT9osYpv_F_8ZXw55Mk9zaQYx8I0lWu_DBavqIGeumbLcEOi8O5KrieYhG0', 'String'),
	(00038, 'ENDPOINT_ESPACE_CLIENT', 'https://recette.moncompte.pointfinances.ami-credit.fr/', 'String'),
	(00038, 'ESPACE_CLIENT_AUTH_CLIENT_URL', 'https://ami-credit-recette.eu.auth0.com/oauth/token', 'String'),
	(00038, 'MAIL_ESPACE_CLIENT_SENDINBLUE_TEMPLATE_ID_CREATION_COMPTE', '4', 'Int'),
	(00038, 'MAIL_ESPACE_CLIENT_SENDINBLUE_TEMPLATE_ID_RENVOIE_MDP', '5', 'Int'),
	(00038, 'MAIL_ESPACE_CLIENT_SENDINBLUE_TEMPLATE_ID_DEMANDE_BFC', '6', 'Int'),
	(00038, 'MAIL_ESPACE_CLIENT_SENDINBLUE_TEMPLATE_ID_RELANCE1_BFC', '7', 'Int'),
	(00038, 'MAIL_ESPACE_CLIENT_SENDINBLUE_TEMPLATE_ID_RELANCE2_BFC', '8', 'Int'),
	(00038, 'MAIL_ESPACE_CLIENT_SENDINBLUE_TEMPLATE_ID_DEMANDE_DOCUMENTS_COMPLEMENTAIRES', '9', 'Int'),
	(00038, 'MAIL_ESPACE_CLIENT_SENDINBLUE_TEMPLATE_ID_RELANCE1_DOCUMENTS_COMPLEMENTAIRES', '13', 'Int'),
	(00038, 'MAIL_ESPACE_CLIENT_SENDINBLUE_TEMPLATE_ID_RELANCE2_DOCUMENTS_COMPLEMENTAIRES', '14', 'Int'),
	(00038, 'MAIL_ESPACE_CLIENT_SENDINBLUE_TEMPLATE_ID_DEMANDE_DOCUMENTS_BANQUE', '10', 'Int'),
	(00038, 'MAIL_ESPACE_CLIENT_SENDINBLUE_TEMPLATE_ID_RELANCE1_DOCUMENTS_BANQUE', '11', 'Int'),
	(00038, 'MAIL_ESPACE_CLIENT_SENDINBLUE_TEMPLATE_ID_RELANCE2_DOCUMENTS_BANQUE', '12', 'Int'),
	(00038, 'ID_UTILISATEUR_ESPACE_CLIENT', @id_utilisateur, 'Int'),
    (00038, 'API_TEMPLATE_COMPANY_ID', '19', 'Int'),
	(00038, 'PARAM_DOMAIN_MAIL', 'pointfinances', 'String'),
	(00038, 'ESPACE_CLIENT_ACTIVATE_PRI', 'true', 'Boolean');

COMMIT;
COMMIT;
