-- https://www.phpmyadmin.net/
--
-- Hôte : 127.0.0.1:3306
-- Généré le : mar. 28 avr. 2026 à 08:57
-- Version du serveur : 8.4.7
-- Version de PHP : 8.3.28

START TRANSACTION;



--
-- Base de données : `numecard`
--

-- --------------------------------------------------------

--
-- Structure de la table `actu`
--

CREATE TABLE IF NOT EXISTS `actu` (
  `id` int NOT NULL AUTO_INCREMENT,
  `titre` varchar(255) NOT NULL,
  `contenu` longtext NOT NULL,
  `categorie` varchar(30) NOT NULL,
  `image_filename` varchar(255) DEFAULT NULL,
  `cta_url` varchar(500) DEFAULT NULL,
  `cta_texte` varchar(100) DEFAULT NULL,
  `epingle` tinyint NOT NULL,
  `statut` varchar(20) NOT NULL,
  `vues` int NOT NULL,
  `clics` int NOT NULL,
  `created_at` datetime NOT NULL,
  `published_at` datetime DEFAULT NULL,
  `published_by_admin` tinyint NOT NULL,
  `beneficiaire_id` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_837303425AF81F68` (`beneficiaire_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Déchargement des données de la table `actu`
--

INSERT INTO `actu` (`id`, `titre`, `contenu`, `categorie`, `image_filename`, `cta_url`, `cta_texte`, `epingle`, `statut`, `vues`, `clics`, `created_at`, `published_at`, `published_by_admin`, `beneficiaire_id`) VALUES
(1, 'Hello ', 'Je testes une actu 16h32', 'realisation', '69aea74106f19.png', NULL, NULL, 1, 'publie', 27, 0, '2026-03-09 11:56:01', '2026-03-09 16:32:58', 1, 40),
(3, 'Test 1', 'Hello ', 'realisation', NULL, NULL, NULL, 0, 'publie', 1, 0, '2026-03-10 10:02:36', '2026-03-10 10:02:36', 0, 41);

-- --------------------------------------------------------

--
-- Structure de la table `admin_access_log`
--

CREATE TABLE IF NOT EXISTS `admin_access_log` (
  `id` int NOT NULL AUTO_INCREMENT,
  `admin_id` int NOT NULL,
  `admin_email` varchar(180) NOT NULL,
  `ip_tronquee` varchar(50) NOT NULL,
  `path` varchar(500) NOT NULL,
  `method` varchar(10) NOT NULL,
  `created_at` datetime NOT NULL,
  `action` varchar(100) NOT NULL,
  `resource` varchar(255) DEFAULT NULL,
  `context` json DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_admin_log_created_at` (`created_at`),
  KEY `idx_admin_log_admin_id` (`admin_id`),
  KEY `idx_admin_log_action` (`action`)
) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Déchargement des données de la table `admin_access_log`
--

INSERT INTO `admin_access_log` (`id`, `admin_id`, `admin_email`, `ip_tronquee`, `path`, `method`, `created_at`, `action`, `resource`, `context`) VALUES
(1, 1, 'contact@num-ecard.com', '127.0.0.xxx', '/admin/rgpd', 'GET', '2026-04-27 12:10:46', 'view_rgpd_demandes', 'Filtrage: pending', NULL),
(2, 1, 'contact@num-ecard.com', '127.0.0.xxx', '/admin/rgpd', 'GET', '2026-04-27 12:12:23', 'view_rgpd_demandes', 'Filtrage: pending', NULL),
(3, 1, 'contact@num-ecard.com', '127.0.0.xxx', '/admin/rgpd', 'GET', '2026-04-27 12:18:09', 'view_rgpd_demandes', 'Filtrage: pending', NULL),
(4, 1, 'contact@num-ecard.com', '127.0.0.xxx', '/admin/rgpd', 'GET', '2026-04-27 12:18:40', 'view_rgpd_demandes', 'Filtrage: pending', NULL),
(5, 1, 'contact@num-ecard.com', '127.0.0.xxx', '/admin/rgpd', 'GET', '2026-04-27 12:19:12', 'view_rgpd_demandes', 'Filtrage: pending', NULL),
(6, 1, 'contact@num-ecard.com', '127.0.0.xxx', '/admin/utilisateurs/3', 'GET', '2026-04-27 12:20:04', 'view_user', 'User#3 — cecilephilippe31@gmail.com', NULL),
(7, 1, 'contact@num-ecard.com', '127.0.0.xxx', '/admin/rgpd', 'GET', '2026-04-27 12:24:30', 'view_rgpd_demandes', 'Filtrage: pending', NULL),
(8, 1, 'contact@num-ecard.com', '127.0.0.xxx', '/admin/rgpd', 'GET', '2026-04-27 12:25:07', 'view_rgpd_demandes', 'Filtrage: pending', NULL),
(9, 1, 'contact@num-ecard.com', '127.0.0.xxx', '/admin/rgpd', 'GET', '2026-04-27 12:25:20', 'view_rgpd_demandes', 'Filtrage: pending', NULL),
(10, 1, 'contact@num-ecard.com', '127.0.0.xxx', '/admin/rgpd', 'GET', '2026-04-27 12:25:55', 'view_rgpd_demandes', 'Filtrage: pending', NULL),
(11, 1, 'contact@num-ecard.com', '127.0.0.xxx', '/admin/rgpd', 'GET', '2026-04-27 12:26:06', 'view_rgpd_demandes', 'Filtrage: pending', NULL),
(12, 1, 'contact@num-ecard.com', '127.0.0.xxx', '/admin/rgpd', 'GET', '2026-04-27 12:27:12', 'view_rgpd_demandes', 'Filtrage: pending', NULL),
(13, 1, 'contact@num-ecard.com', '127.0.0.xxx', '/admin/rgpd', 'GET', '2026-04-27 12:31:08', 'view_rgpd_demandes', 'Filtrage: pending', NULL),
(14, 1, 'contact@num-ecard.com', '127.0.0.xxx', '/admin/rgpd', 'GET', '2026-04-27 12:34:10', 'view_rgpd_demandes', 'Filtrage: pending', NULL),
(15, 1, 'contact@num-ecard.com', '127.0.0.xxx', '/admin/rgpd', 'GET', '2026-04-27 12:34:46', 'view_rgpd_demandes', 'Filtrage: pending', NULL),
(16, 1, 'contact@num-ecard.com', '127.0.0.xxx', '/admin/rgpd/1/rejeter', 'POST', '2026-04-27 12:34:50', 'rgpd_reject_demande', 'RgpdRequest#1', '{\"motif\": \"\"}'),
(17, 1, 'contact@num-ecard.com', '127.0.0.xxx', '/admin/rgpd', 'GET', '2026-04-27 12:34:51', 'view_rgpd_demandes', 'Filtrage: pending', NULL),
(18, 1, 'contact@num-ecard.com', '127.0.0.xxx', '/admin/rgpd', 'GET', '2026-04-27 12:36:37', 'view_rgpd_demandes', 'Filtrage: pending', NULL),
(19, 1, 'contact@num-ecard.com', '127.0.0.xxx', '/admin/rgpd', 'GET', '2026-04-27 13:06:14', 'view_rgpd_demandes', 'Filtrage: pending', NULL),
(20, 1, 'contact@num-ecard.com', '127.0.0.xxx', '/admin/rgpd', 'GET', '2026-04-27 13:09:10', 'view_rgpd_demandes', 'Filtrage: pending', NULL),
(21, 1, 'contact@num-ecard.com', '127.0.0.xxx', '/admin/rgpd', 'GET', '2026-04-27 13:09:43', 'view_rgpd_demandes', 'Filtrage: pending', NULL),
(22, 1, 'contact@num-ecard.com', '127.0.0.xxx', '/admin/rgpd', 'GET', '2026-04-27 13:09:50', 'view_rgpd_demandes', 'Filtrage: pending', NULL),
(23, 1, 'contact@num-ecard.com', '127.0.0.xxx', '/admin/rgpd', 'GET', '2026-04-27 13:11:39', 'view_rgpd_demandes', 'Filtrage: pending', NULL),
(24, 1, 'contact@num-ecard.com', '127.0.0.xxx', '/admin/rgpd', 'GET', '2026-04-27 13:12:06', 'view_rgpd_demandes', 'Filtrage: pending', NULL),
(25, 1, 'contact@num-ecard.com', '127.0.0.xxx', '/admin/rgpd', 'GET', '2026-04-27 13:13:46', 'view_rgpd_demandes', 'Filtrage: pending', NULL),
(26, 1, 'contact@num-ecard.com', '127.0.0.xxx', '/admin/rgpd', 'GET', '2026-04-27 13:13:59', 'view_rgpd_demandes', 'Filtrage: pending', NULL),
(27, 1, 'contact@num-ecard.com', '127.0.0.xxx', '/admin/rgpd', 'GET', '2026-04-27 13:14:09', 'view_rgpd_demandes', 'Filtrage: pending', NULL),
(28, 1, 'contact@num-ecard.com', '127.0.0.xxx', '/admin/rgpd', 'GET', '2026-04-27 13:21:25', 'view_rgpd_demandes', 'Filtrage: pending', NULL),
(29, 1, 'contact@num-ecard.com', '127.0.0.xxx', '/admin/utilisateurs/4', 'GET', '2026-04-28 09:45:22', 'view_user', 'User#4 — cecilephilippe31@gmail.com', NULL),
(30, 1, 'contact@num-ecard.com', '127.0.0.xxx', '/admin/utilisateurs/4', 'GET', '2026-04-28 09:47:42', 'view_user', 'User#4 — cecilephilippe31@gmail.com', NULL),
(31, 1, 'contact@num-ecard.com', '127.0.0.xxx', '/admin/utilisateurs/4', 'GET', '2026-04-28 10:21:00', 'view_user', 'User#4 — cecilephilippe31@gmail.com', NULL),
(32, 1, 'contact@num-ecard.com', '127.0.0.xxx', '/admin/utilisateurs/4', 'GET', '2026-04-28 10:21:30', 'view_user', 'User#4 — cecilephilippe31@gmail.com', NULL);

-- --------------------------------------------------------

--
-- Structure de la table `admin_email_log`
--

CREATE TABLE IF NOT EXISTS `admin_email_log` (
  `id` int NOT NULL AUTO_INCREMENT,
  `recipient_email` varchar(255) NOT NULL,
  `sender_name` varchar(255) NOT NULL,
  `sujet` varchar(255) NOT NULL,
  `corps` longtext,
  `status` varchar(20) NOT NULL,
  `error_message` longtext,
  `admin_ip` varchar(45) DEFAULT NULL,
  `sent_at` datetime NOT NULL,
  `body_purged_at` datetime DEFAULT NULL,
  `sent_by_id` int DEFAULT NULL,
  `sent_to_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_EF0C4DB1A45BB98C` (`sent_by_id`),
  KEY `IDX_EF0C4DB13E89D3ED` (`sent_to_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- --------------------------------------------------------

--
-- Structure de la table `beneficiaire`
--

CREATE TABLE IF NOT EXISTS `beneficiaire` (
  `avatar_type` varchar(20) NOT NULL,
  `initiales` varchar(5) DEFAULT NULL,
  `photo_filename` varchar(255) DEFAULT NULL,
  `charte_type` varchar(255) NOT NULL,
  `charte_template` int DEFAULT NULL,
  `couleur_principale` varchar(7) DEFAULT NULL,
  `couleur_secondaire` varchar(7) DEFAULT NULL,
  `police_personnalisee` varchar(100) DEFAULT NULL,
  `charte_pdf_filename` varchar(255) DEFAULT NULL,
  `service1` varchar(150) DEFAULT NULL,
  `service2` varchar(150) DEFAULT NULL,
  `service3` varchar(150) DEFAULT NULL,
  `service4` varchar(150) DEFAULT NULL,
  `threads` varchar(255) DEFAULT NULL,
  `zoom` varchar(255) DEFAULT NULL,
  `google_meet` varchar(255) DEFAULT NULL,
  `microsoft_teams` varchar(255) DEFAULT NULL,
  `feature_agenda` tinyint NOT NULL,
  `agenda_link` varchar(255) DEFAULT NULL,
  `feature_galerie` tinyint NOT NULL,
  `galerie_link` varchar(255) DEFAULT NULL,
  `feature_satisfaction` tinyint NOT NULL,
  `satisfaction_link` varchar(255) DEFAULT NULL,
  `feature_catalogue` tinyint NOT NULL,
  `catalogue_link` varchar(255) DEFAULT NULL,
  `feature_video` tinyint NOT NULL,
  `video_link` varchar(255) DEFAULT NULL,
  `lien_personnalise` varchar(255) DEFAULT NULL,
  `expertise` varchar(100) DEFAULT NULL,
  `seances` varchar(100) DEFAULT NULL,
  `satisfaction` varchar(100) DEFAULT NULL,
  `position` int NOT NULL,
  `modification_count` int NOT NULL,
  `last_modified_at` datetime DEFAULT NULL,
  `needs_regeneration` tinyint NOT NULL,
  `commande_id` int NOT NULL,
  `id` int NOT NULL,
  `card_url` varchar(500) DEFAULT NULL,
  `card_sent_at` datetime DEFAULT NULL,
  `is_active` tinyint NOT NULL,
  `deactivated_at` datetime DEFAULT NULL,
  `reactivated_at` datetime DEFAULT NULL,
  `scheduled_activation_at` datetime DEFAULT NULL,
  `timezone` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_B140D80282EA2E54` (`commande_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Déchargement des données de la table `beneficiaire`
--

INSERT INTO `beneficiaire` (`avatar_type`, `initiales`, `photo_filename`, `charte_type`, `charte_template`, `couleur_principale`, `couleur_secondaire`, `police_personnalisee`, `charte_pdf_filename`, `service1`, `service2`, `service3`, `service4`, `threads`, `zoom`, `google_meet`, `microsoft_teams`, `feature_agenda`, `agenda_link`, `feature_galerie`, `galerie_link`, `feature_satisfaction`, `satisfaction_link`, `feature_catalogue`, `catalogue_link`, `feature_video`, `video_link`, `lien_personnalise`, `expertise`, `seances`, `satisfaction`, `position`, `modification_count`, `last_modified_at`, `needs_regeneration`, `commande_id`, `id`, `card_url`, `card_sent_at`, `is_active`, `deactivated_at`, `reactivated_at`, `scheduled_activation_at`, `timezone`) VALUES
('initiales', 'TM', NULL, 'template', 6, '#667eea', '#764ba2', NULL, NULL, 'Événementiel', 'Marketing digital', 'Gestion immobilière', 'SEO/SEA', '', '', '', '', 0, '', 0, '', 0, '', 0, '', 0, '', '', '', '', '', 1, 1, '2026-03-18 18:53:46', 1, 39, 48, NULL, NULL, 1, NULL, NULL, NULL, NULL),
('initiales', 'MN', NULL, 'personnalisee', 55, '#cc3bce', '#4f31c9', NULL, NULL, 'Développement web', 'Communication digitale', 'Photo/Vidéo', 'SEO/SEA', '', '', '', '', 0, '', 0, '', 0, '', 0, '', 0, '', '', '', '', '', 1, 26, '2026-03-31 08:53:44', 1, 40, 49, NULL, NULL, 1, NULL, NULL, NULL, NULL),
('initiales', 'PL', NULL, 'template', 48, '#667eea', '#764ba2', NULL, NULL, 'Communication digitale', 'Design graphique', 'Conseil stratégique', 'Marketing digital', '', '', '', '', 0, '', 0, '', 0, '', 0, '', 0, '', '', '', '', '', 1, 3, '2026-03-24 11:33:46', 1, 41, 50, NULL, NULL, 1, NULL, NULL, NULL, NULL),
('initiales', 'TB', NULL, 'template', 11, '#667eea', '#764ba2', NULL, NULL, 'Conseil stratégique', 'Développement web', 'Communication digitale', 'Marketing digital', '', '', '', '', 0, '', 0, '', 0, '', 0, '', 0, 'https://www.youtube.com/watch?v=PlrSdoeKjZ8', '', '', '', '', 1, 3, '2026-03-24 12:37:34', 1, 42, 51, NULL, NULL, 1, NULL, NULL, NULL, NULL),
('initiales', 'ED', NULL, 'template', 1, NULL, NULL, NULL, NULL, 'Développement web', 'Formation', 'Conseil stratégique', 'Photo/Vidéo', NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, 1, 43, 52, NULL, NULL, 1, NULL, NULL, NULL, NULL),
('initiales', 'HL', NULL, 'template', 20, NULL, NULL, NULL, NULL, 'Communication digitale', 'Conseil stratégique', 'Marketing digital', 'Gestion immobilière', NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, 1, 44, 53, NULL, NULL, 1, NULL, NULL, NULL, NULL),
('initiales', 'LM', NULL, 'template', 53, NULL, NULL, NULL, NULL, 'Formation', 'SEO/SEA', 'Communication digitale', 'Événementiel', NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, 1, 45, 54, NULL, NULL, 0, '2026-03-27 16:32:29', NULL, '2026-04-10 00:00:00', 'Europe/Paris'),
('initiales', 'LD', NULL, 'personnalisee', 47, NULL, NULL, NULL, NULL, 'Développement web', 'Conseil stratégique', 'Communication digitale', 'SEO/SEA', NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, 1, 46, 55, NULL, NULL, 1, NULL, NULL, NULL, NULL),
('initiales', 'HD', NULL, 'personnalisee', 18, NULL, NULL, NULL, NULL, 'Conseil stratégique', 'Gestion immobilière', 'Photo/Vidéo', 'Formation', NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, 1, 47, 56, NULL, NULL, 1, NULL, NULL, NULL, 'Europe/Paris'),
('initiales', NULL, NULL, 'personnalisee', 53, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, 1, 48, 57, NULL, NULL, 1, NULL, NULL, NULL, NULL),
('initiales', 'AL', NULL, 'personnalisee', 53, '#c81eba', '#0fa4c2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, 1, 49, 58, NULL, NULL, 1, '2026-04-07 09:52:37', '2026-04-07 09:52:40', NULL, NULL),
('initiales', 'AA', NULL, 'template', 53, '#667eea', '#764ba2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, 1, 50, 59, NULL, NULL, 0, '2026-04-07 09:45:14', '2026-04-07 09:41:13', NULL, NULL);

-- --------------------------------------------------------

--
-- Structure de la table `card`
--

CREATE TABLE IF NOT EXISTS `card` (
  `id` int NOT NULL AUTO_INCREMENT,
  `nom` varchar(100) NOT NULL,
  `prenom` varchar(100) NOT NULL,
  `entreprise` varchar(150) DEFAULT NULL,
  `logo` varchar(255) DEFAULT NULL,
  `titre` varchar(200) DEFAULT NULL,
  `slogan` varchar(200) DEFAULT NULL,
  `fonction` varchar(150) DEFAULT NULL,
  `fixe` varchar(50) DEFAULT NULL,
  `mobile` varchar(255) DEFAULT NULL,
  `email` varchar(150) DEFAULT NULL,
  `site_web` varchar(255) DEFAULT NULL,
  `adresse` longtext,
  `price` decimal(10,2) DEFAULT NULL,
  `linkedin` varchar(1000) DEFAULT NULL,
  `facebook` varchar(1000) DEFAULT NULL,
  `youtube` varchar(1000) DEFAULT NULL,
  `tiktok` varchar(1000) DEFAULT NULL,
  `insta` varchar(1000) DEFAULT NULL,
  `x` varchar(1000) DEFAULT NULL,
  `type` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=60 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Déchargement des données de la table `card`
--

INSERT INTO `card` (`id`, `nom`, `prenom`, `entreprise`, `logo`, `titre`, `slogan`, `fonction`, `fixe`, `mobile`, `email`, `site_web`, `adresse`, `price`, `linkedin`, `facebook`, `youtube`, `tiktok`, `insta`, `x`, `type`) VALUES
(58, 'Louis', 'Anna', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 349.00, NULL, NULL, NULL, NULL, NULL, NULL, 'beneficiaire'),
(59, 'Alain', 'Alin', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 549.00, NULL, NULL, NULL, NULL, NULL, NULL, 'beneficiaire'),
(57, 'Louis', 'Paola', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 349.00, NULL, NULL, NULL, NULL, NULL, NULL, 'beneficiaire'),
(56, 'DUPONT', 'Hugo', 'Digital Cube', NULL, NULL, 'Créons ensemble votre succès', 'Chargé de Communication', '0519360591', '0639951818', 'hugo.dupont@digitalcube.fr', 'https://www.digitalcube.fr', '83 rue des Coquelicots, 31110 Colomiers', 549.00, 'https://linkedin.com/in/hugo-dupont', 'https://facebook.com/hugodupont', NULL, NULL, 'https://instagram.com/hugo_dupont', NULL, 'beneficiaire'),
(55, 'DUPONT', 'Luc', 'Focus Digital', NULL, NULL, 'La musique est ma passion', 'Designer', '0579176838', '0678624871', 'luc.dupont@focusdigital.fr', 'https://www.focusdigital.fr', '65 rue du Commerce, 31673 Toulouse', 199.00, 'https://linkedin.com/in/luc-dupont', 'https://facebook.com/lucdupont', NULL, NULL, 'https://instagram.com/luc_dupont', NULL, 'beneficiaire'),
(49, 'MARTIN', 'Nathalie', 'Sud Développement', NULL, '', 'L\'innovation au service de l\'immobilier', 'Designer', '0561753343', '0645286047', 'nathalie.martin@suddveloppement.fr', 'https://www.suddveloppement.fr', '12 rue des Coquelicots, 31477 Albi', 549.00, 'https://linkedin.com/in/nathalie-martin', 'https://facebook.com/nathaliemartin', 'https://www.youtube.com/watch?v=IC62ia_bZeY', '', 'https://instagram.com/nathalie_martin', '', 'beneficiaire'),
(48, 'MOREAU', 'Thomas', 'SANAGENCY', NULL, '', 'L\'innovation au service de l\'immobilier', 'Designer', '0561358513', '0626214018', 'thomas.moreau@sanagency.fr', 'https://www.sanagency.fr', '8 rue Jean Jaurès, 31167 Toulouse', 349.00, 'https://linkedin.com/in/thomas-moreau', 'https://facebook.com/thomasmoreau', '', '', 'https://instagram.com/thomas_moreau', '', 'beneficiaire');

-- --------------------------------------------------------

--
-- Structure de la table `commande_multi`
--

CREATE TABLE IF NOT EXISTS `commande_multi` (
  `id` int NOT NULL AUTO_INCREMENT,
  `reference` varchar(20) NOT NULL,
  `pack_type` varchar(20) NOT NULL,
  `quantity` int NOT NULL,
  `client_nom` varchar(200) DEFAULT NULL,
  `client_entreprise` varchar(200) DEFAULT NULL,
  `client_email` varchar(180) DEFAULT NULL,
  `client_telephone` varchar(20) DEFAULT NULL,
  `client_adresse` longtext,
  `paiement_mode` varchar(20) NOT NULL,
  `total_ht` decimal(10,2) NOT NULL,
  `total_ttc` decimal(10,2) NOT NULL,
  `taux_tva` decimal(5,2) NOT NULL,
  `stripe_session_id` varchar(255) DEFAULT NULL,
  `stripe_payment_intent_id` varchar(255) DEFAULT NULL,
  `status` varchar(20) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  `paid_at` datetime DEFAULT NULL,
  `completed_at` datetime DEFAULT NULL,
  `notes` longtext,
  `user_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_FCF99CC6AEA34913` (`reference`),
  KEY `IDX_FCF99CC6A76ED395` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=51 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Déchargement des données de la table `commande_multi`
--

INSERT INTO `commande_multi` (`id`, `reference`, `pack_type`, `quantity`, `client_nom`, `client_entreprise`, `client_email`, `client_telephone`, `client_adresse`, `paiement_mode`, `total_ht`, `total_ttc`, `taux_tva`, `stripe_session_id`, `stripe_payment_intent_id`, `status`, `created_at`, `updated_at`, `paid_at`, `completed_at`, `notes`, `user_id`) VALUES
(39, 'CMD-2026-80376', 'premium', 1, 'Tom tom', NULL, 'tom@tom.fr', NULL, NULL, 'comptant', 349.00, 418.80, 20.00, 'ADMIN_69b7be44a7172', NULL, 'paid', '2026-03-16 09:24:36', '2026-03-16 09:24:36', '2026-03-16 09:24:36', NULL, NULL, 1),
(40, 'CMD-2026-13628', 'forcevente', 1, 'Tom tom', NULL, 'tom@tom.fr', NULL, NULL, 'comptant', 549.00, 658.80, 20.00, 'ADMIN_69ba911ab5bc2', NULL, 'paid', '2026-03-18 12:48:42', '2026-03-18 12:48:42', '2026-03-18 12:48:42', NULL, NULL, 1),
(41, 'CMD-2026-01275', 'forcevente', 1, 'Philippe CECILE', NULL, 'cecilephilippe31@gmail.com', NULL, NULL, 'comptant', 549.00, 658.80, 20.00, 'cs_test_a1hIhUJhdsXEAW7UtvMoxKFftJzWlx5HYRwNqcw210v1Iiqqj4Zj4j2Ype', 'pi_3TEQbqLKvnU8BpCB143FOYdR', 'paid', '2026-03-24 09:46:20', '2026-03-24 09:46:48', '2026-03-24 09:46:48', NULL, NULL, 3),
(42, 'CMD-2026-36084', 'forcevente', 1, 'Philippe CECILE', NULL, 'cecilephilippe31@gmail.com', NULL, NULL, 'comptant', 549.00, 658.80, 20.00, 'cs_test_a1IXHek5dp3NQ7j2waEk0fGmVKeVE6dRHaiEpoFLEeDMIf9juuUHhgDukz', 'pi_3TESb1LKvnU8BpCB0Moq2w0V', 'paid', '2026-03-24 11:53:25', '2026-03-24 11:54:05', '2026-03-24 11:54:05', NULL, NULL, 3),
(43, 'CMD-2026-58908', 'forcevente', 1, 'Philippe CECILE', NULL, 'cecilephilippe31@gmail.com', NULL, NULL, 'comptant', 549.00, 658.80, 20.00, 'cs_test_a1A6BDpfvoKzvoZW4xh8Vktd0TlUQ0gpvNZh5ThVPydAqpMKf5ktKkNIu5', 'pi_3TFDOTLKvnU8BpCB1TnfoSkx', 'paid', '2026-03-26 13:51:49', '2026-03-26 13:52:16', '2026-03-26 13:52:16', NULL, NULL, 3),
(44, 'CMD-2026-70147', 'forcevente', 1, 'Philippe CECILE', NULL, 'cecilephilippe31@gmail.com', NULL, NULL, 'comptant', 549.00, 658.80, 20.00, 'cs_test_a1k0qZQxVYGsSsWpb3MRYxrYFjoDcSzOyjf2T0hijNNvWsRYC3e566JrW8', 'pi_3TFEE6LKvnU8BpCB1YfhYkWK', 'paid', '2026-03-26 14:45:08', '2026-03-26 14:45:37', '2026-03-26 14:45:37', NULL, NULL, 3),
(45, 'CMD-2026-94513', 'forcevente', 1, 'Philippe CECILE', NULL, 'phil31780@live.fr', '07 89 54 86 28', NULL, 'comptant', 549.00, 658.80, 20.00, 'cs_test_a1V92fuebdB11dTeRhvq2MTBrpeX48nGRyeZQBFsbcpqtSm6O3EKB35XGr', 'pi_3TFcNSLKvnU8BpCB0wKMLDNV', 'paid', '2026-03-27 16:32:29', '2026-03-27 16:32:52', '2026-03-27 16:32:52', NULL, NULL, NULL),
(46, 'CMD-2026-85142', 'essentiel', 1, 'Patrice Sanachy', NULL, 'contact@num-ecard.com', NULL, NULL, 'comptant', 199.00, 238.80, 20.00, 'ADMIN_69cb7ae3f25fb', NULL, 'paid', '2026-03-31 09:42:27', '2026-03-31 09:42:27', '2026-03-31 09:42:27', NULL, NULL, 1),
(47, 'CMD-2026-91144', 'forcevente', 1, 'Patrice Sanachy', NULL, 'contact@num-ecard.com', NULL, NULL, 'comptant', 549.00, 658.80, 20.00, 'ADMIN_69cb7b0d84d0f', NULL, 'paid', '2026-03-31 09:43:09', '2026-03-31 09:43:09', '2026-03-31 09:43:09', NULL, NULL, 1),
(48, 'CMD-2026-86947', 'premium', 1, 'Patrice Sanachy', NULL, 'contact@num-ecard.com', NULL, NULL, 'comptant', 349.00, 418.80, 20.00, 'ADMIN_69cbb1f40895d', NULL, 'paid', '2026-03-31 13:37:24', '2026-03-31 13:37:24', '2026-03-31 13:37:24', NULL, NULL, 1),
(49, 'CMD-2026-82440', 'premium', 1, 'Patrice Sanachy', NULL, 'contact@num-ecard.com', NULL, NULL, 'comptant', 349.00, 418.80, 20.00, 'ADMIN_69cbbaf5a3a3a', NULL, 'paid', '2026-03-31 14:15:49', '2026-03-31 14:15:49', '2026-03-31 14:15:49', NULL, NULL, 1),
(50, 'CMD-2026-45669', 'forcevente', 1, 'Patrice Sanachy', NULL, 'contact@num-ecard.com', NULL, NULL, 'comptant', 549.00, 658.80, 20.00, 'ADMIN_69cbbc5c1f452', NULL, 'paid', '2026-03-31 14:21:48', '2026-03-31 14:21:48', '2026-03-31 14:21:48', NULL, NULL, 1);

-- --------------------------------------------------------

--
-- Structure de la table `consent_log`
--

CREATE TABLE IF NOT EXISTS `consent_log` (
  `id` int NOT NULL AUTO_INCREMENT,
  `source` varchar(64) NOT NULL,
  `analytics` tinyint NOT NULL,
  `consent_version` smallint NOT NULL,
  `user_agent` varchar(512) DEFAULT NULL,
  `consent_given_at` datetime NOT NULL,
  `user_id` int DEFAULT NULL,
  `marketing` tinyint NOT NULL,
  `essential` tinyint NOT NULL,
  `ip_anonymized` varchar(64) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_30113729A76ED395` (`user_id`),
  KEY `idx_consent_source` (`source`),
  KEY `idx_consent_date` (`consent_given_at`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- --------------------------------------------------------

--
-- Structure de la table `consent_record`
--

CREATE TABLE IF NOT EXISTS `consent_record` (
  `id` int NOT NULL AUTO_INCREMENT,
  `purpose` varchar(50) NOT NULL,
  `action` varchar(10) NOT NULL,
  `ip_anonymized` varchar(50) DEFAULT NULL,
  `legal_basis` varchar(10) NOT NULL,
  `notice_version` varchar(100) DEFAULT NULL,
  `source` varchar(100) DEFAULT NULL,
  `user_agent` varchar(512) DEFAULT NULL,
  `consented_at` datetime NOT NULL,
  `user_id` int DEFAULT NULL,
  `analytics_consent` tinyint DEFAULT NULL,
  `marketing_consent` tinyint DEFAULT NULL,
  `visitor_token` varchar(64) DEFAULT NULL,
  `page_url` varchar(512) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_consent_user` (`user_id`),
  KEY `idx_consent_purpose` (`purpose`),
  KEY `idx_consent_date` (`consented_at`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- --------------------------------------------------------

--
-- Structure de la table `deletion_log`
--

CREATE TABLE IF NOT EXISTS `deletion_log` (
  `id` int NOT NULL AUTO_INCREMENT,
  `email_hashed` varchar(64) NOT NULL,
  `original_user_id` int DEFAULT NULL,
  `channel` varchar(30) NOT NULL,
  `commandes_count` int NOT NULL,
  `beneficiaires_count` int NOT NULL,
  `files_deleted_count` int NOT NULL,
  `brevio_purged` tinyint NOT NULL,
  `ip_anonymized` varchar(50) DEFAULT NULL,
  `deleted_at` datetime NOT NULL,
  `request_reference` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_deletion_date` (`deleted_at`),
  KEY `idx_deletion_email` (`email_hashed`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Déchargement des données de la table `deletion_log`
--

INSERT INTO `deletion_log` (`id`, `email_hashed`, `original_user_id`, `channel`, `commandes_count`, `beneficiaires_count`, `files_deleted_count`, `brevio_purged`, `ip_anonymized`, `deleted_at`, `request_reference`) VALUES
(1, '8fab9f51bdc503fb3f116f1f979b472b92cfba0c32e4d7506f193572c9d44cca', 2, 'self_service', 1, 1, 0, 0, '127.0.0.0', '2026-04-23 11:15:34', NULL),
(2, '05d47ecfa6581712db1b9dfdc86af68267fb0fb781cef4165b3262c693c28f22', 3, 'rgpd_request', 4, 4, 4, 0, NULL, '2026-04-27 13:14:07', 'RGPD-2');

-- --------------------------------------------------------

--
-- Structure de la table `doctrine_migration_versions`
--

CREATE TABLE IF NOT EXISTS `doctrine_migration_versions` (
  `version` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `executed_at` datetime DEFAULT NULL,
  `execution_time` int DEFAULT NULL,
  PRIMARY KEY (`version`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `doctrine_migration_versions`
--

INSERT INTO `doctrine_migration_versions` (`version`, `executed_at`, `execution_time`) VALUES
('DoctrineMigrations\\Version20260428085643', '2026-04-28 10:56:51', 363);

-- --------------------------------------------------------

--
-- Structure de la table `essentiel`
--

CREATE TABLE IF NOT EXISTS `essentiel` (
  `id` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- --------------------------------------------------------

--
-- Structure de la table `force_carte`
--

CREATE TABLE IF NOT EXISTS `force_carte` (
  `specialite` longtext,
  `services` longtext,
  `zone_intervention` varchar(200) DEFAULT NULL,
  `horaires` varchar(100) DEFAULT NULL,
  `id` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- --------------------------------------------------------

--
-- Structure de la table `hebergement_subscription`
--

CREATE TABLE IF NOT EXISTS `hebergement_subscription` (
  `id` int NOT NULL AUTO_INCREMENT,
  `status` varchar(20) NOT NULL,
  `starts_at` datetime NOT NULL,
  `expires_at` datetime NOT NULL,
  `stripe_subscription_id` varchar(255) DEFAULT NULL,
  `stripe_session_id` varchar(255) DEFAULT NULL,
  `last_renewal_at` datetime DEFAULT NULL,
  `reminders_sent_at` json DEFAULT NULL,
  `renewed_by_admin` tinyint NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  `beneficiaire_id` int NOT NULL,
  `is_free_forever` tinyint NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_18E62BFF5AF81F68` (`beneficiaire_id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Déchargement des données de la table `hebergement_subscription`
--

INSERT INTO `hebergement_subscription` (`id`, `status`, `starts_at`, `expires_at`, `stripe_subscription_id`, `stripe_session_id`, `last_renewal_at`, `reminders_sent_at`, `renewed_by_admin`, `created_at`, `updated_at`, `beneficiaire_id`, `is_free_forever`) VALUES
(3, 'trial', '2026-03-25 12:19:47', '2027-03-25 12:19:47', NULL, NULL, NULL, NULL, 0, '2026-03-25 12:19:47', NULL, 48, 0),
(4, 'trial', '2026-03-25 12:19:47', '2027-03-25 12:19:47', NULL, NULL, NULL, NULL, 0, '2026-03-25 12:19:47', NULL, 49, 0),
(7, 'trial', '2026-04-02 11:36:54', '2027-04-02 11:36:54', NULL, NULL, NULL, NULL, 0, '2026-04-02 11:36:54', NULL, 55, 0),
(8, 'trial', '2026-04-02 11:36:54', '2027-04-02 11:36:54', NULL, NULL, NULL, NULL, 0, '2026-04-02 11:36:54', NULL, 56, 0),
(9, 'trial', '2026-04-02 11:36:54', '2027-04-02 11:36:54', NULL, NULL, NULL, NULL, 0, '2026-04-02 11:36:54', NULL, 57, 0),
(10, 'trial', '2026-04-02 11:36:54', '2027-04-02 11:36:54', NULL, NULL, NULL, NULL, 0, '2026-04-02 11:36:54', NULL, 58, 0),
(11, 'trial', '2026-04-02 11:36:54', '2027-04-02 11:36:54', NULL, NULL, NULL, NULL, 0, '2026-04-02 11:36:54', NULL, 59, 0);

-- --------------------------------------------------------

--
-- Structure de la table `messenger_messages`
--

CREATE TABLE IF NOT EXISTS `messenger_messages` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `body` longtext NOT NULL,
  `headers` longtext NOT NULL,
  `queue_name` varchar(190) NOT NULL,
  `created_at` datetime NOT NULL,
  `available_at` datetime NOT NULL,
  `delivered_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_75EA56E0FB7336F0` (`queue_name`),
  KEY `IDX_75EA56E0E3BD61CE` (`available_at`),
  KEY `IDX_75EA56E016BA31DB` (`delivered_at`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- --------------------------------------------------------

--
-- Structure de la table `modification_invoice`
--

CREATE TABLE IF NOT EXISTS `modification_invoice` (
  `id` int NOT NULL AUTO_INCREMENT,
  `reference` varchar(100) NOT NULL,
  `modification_number` int NOT NULL,
  `price_ht` decimal(8,2) NOT NULL,
  `tva` decimal(8,2) NOT NULL,
  `price_ttc` decimal(8,2) NOT NULL,
  `stripe_session_id` varchar(255) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `beneficiaire_id` int NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_4718C21AEA34913` (`reference`),
  KEY `IDX_4718C215AF81F68` (`beneficiaire_id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Déchargement des données de la table `modification_invoice`
--

INSERT INTO `modification_invoice` (`id`, `reference`, `modification_number`, `price_ht`, `tva`, `price_ttc`, `stripe_session_id`, `created_at`, `beneficiaire_id`) VALUES
(1, 'MOD-51-20260324-GCRSUZ', 2, 20.00, 4.00, 24.00, 'cs_test_a1tV0ukpPEshfy4HUZLMpWNYIcapOH6EG2enKfh6sSNr7QP2mbrggCRsuz', '2026-03-24 12:16:43', 51),
(2, 'MOD-51-20260324-UCYRVC', 3, 20.00, 4.00, 24.00, 'cs_test_a16swchnUYkggr1N2OuwAoRdYuNsByftQStC0jQmwbOTjZjGg9iQucYrvC', '2026-03-24 12:37:34', 51),
(3, 'MOD-49-20260324-ADMIN', 18, 0.00, 0.00, 0.00, NULL, '2026-03-24 13:27:24', 49),
(4, 'MOD-49-20260324-ADMIN-2692', 21, 0.00, 0.00, 0.00, NULL, '2026-03-24 13:30:16', 49),
(5, 'MOD-49-20260324-ADMIN-C6D4', 22, 0.00, 0.00, 0.00, NULL, '2026-03-24 13:31:51', 49),
(6, 'MOD-49-20260331-ADMIN-F137', 23, 0.00, 0.00, 0.00, NULL, '2026-03-31 08:42:50', 49),
(7, 'MOD-49-20260331-ADMIN-2E47', 24, 0.00, 0.00, 0.00, NULL, '2026-03-31 08:51:55', 49),
(8, 'MOD-49-20260331-ADMIN-1057', 25, 0.00, 0.00, 0.00, NULL, '2026-03-31 08:52:42', 49),
(9, 'MOD-49-20260331-ADMIN-97E9', 26, 0.00, 0.00, 0.00, NULL, '2026-03-31 08:53:44', 49);

-- --------------------------------------------------------

--
-- Structure de la table `multi`
--

CREATE TABLE IF NOT EXISTS `multi` (
  `id` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- --------------------------------------------------------

--
-- Structure de la table `newsletter_consent_log`
--

CREATE TABLE IF NOT EXISTS `newsletter_consent_log` (
  `id` int NOT NULL AUTO_INCREMENT,
  `email` varchar(254) DEFAULT NULL,
  `email_hashed` varchar(64) NOT NULL,
  `source` varchar(64) NOT NULL,
  `consent_version` varchar(32) NOT NULL,
  `consent_text_hash` varchar(64) DEFAULT NULL,
  `form_url` varchar(512) DEFAULT NULL,
  `ip_anonymized` varchar(64) NOT NULL,
  `user_agent` varchar(512) DEFAULT NULL,
  `granted_at` datetime NOT NULL,
  `withdrawn_at` datetime DEFAULT NULL,
  `brevo_contact_id` int DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_6FF68E6A76ED395` (`user_id`),
  KEY `idx_ncl_email` (`email_hashed`),
  KEY `idx_ncl_granted_at` (`granted_at`),
  KEY `idx_ncl_withdrawn_at` (`withdrawn_at`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- --------------------------------------------------------

--
-- Structure de la table `premium`
--

CREATE TABLE IF NOT EXISTS `premium` (
  `expertise` varchar(100) DEFAULT NULL,
  `seances` varchar(100) DEFAULT NULL,
  `spe1` varchar(255) DEFAULT NULL,
  `spe2` varchar(255) DEFAULT NULL,
  `spe3` varchar(255) DEFAULT NULL,
  `spe4` varchar(255) DEFAULT NULL,
  `satisfaction` varchar(255) DEFAULT NULL,
  `id` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- --------------------------------------------------------

--
-- Structure de la table `push_subscription`
--

CREATE TABLE IF NOT EXISTS `push_subscription` (
  `id` int NOT NULL AUTO_INCREMENT,
  `card_slug` varchar(255) NOT NULL,
  `endpoint` longtext NOT NULL,
  `public_key` longtext NOT NULL,
  `auth_token` longtext NOT NULL,
  `user_agent` varchar(500) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `last_used_at` datetime DEFAULT NULL,
  `visitor_hash` varchar(64) DEFAULT NULL,
  `subscriber_ip` varchar(45) DEFAULT NULL,
  `consent_version` varchar(20) DEFAULT NULL,
  `status` varchar(20) NOT NULL,
  `unsubscribed_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_push_card_slug` (`card_slug`(250)),
  KEY `idx_push_created` (`created_at`),
  KEY `idx_push_status` (`status`),
  KEY `idx_push_visitor_hash` (`visitor_hash`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Déchargement des données de la table `push_subscription`
--

INSERT INTO `push_subscription` (`id`, `card_slug`, `endpoint`, `public_key`, `auth_token`, `user_agent`, `created_at`, `last_used_at`, `visitor_hash`, `subscriber_ip`, `consent_version`, `status`, `unsubscribed_at`) VALUES
(1, 'unknown', 'https://fcm.googleapis.com/fcm/send/elPzUC7DL4g:APA91bESNQTy8KAKlttvVKDsLhJklIupA2M44G5H0fqjpzKrlB_pLUlhqAAuOK8kH3pJFVGhJ2ggeeTrjjhgtLarVcItsPyAezh13iI9fEx3yaXowNr3yK_4xPfFGxmUZ0hB-k12gHYo', 'BM1xY-S0MywqC7uQo1Bymd_30i51zrKSffCxdTl97Z-HdCkaQZuawGzz-lpWaosqL0y99dTEajNBqOAsyIyq7cI', 'oqW-XxuYUYAIXNJEePjhzg', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-03-10 10:01:01', '2026-03-10 10:28:24', NULL, NULL, NULL, '', NULL),
(2, 'thomas-bernard', 'https://fcm.googleapis.com/fcm/send/eNF52HV0CB4:APA91bFO9qYlt2PXDjpgjD0wT4X-yAA-WtvBfEIUSwqHrJFJRmyGP3di-jVckvPKAIjNIH8MmgUZ7ilEHAiqGPcXBr5Ni04lrSMqOHBbASpB_HuE1JMLUPp5nl9Lc7a5PJ99di1y5yS5', 'BPUdwReHUPNjqIquq3MJB4vFe_UIOyWRrVIg0S3PwTs5oQRayZNn1ajmNCNJz30wxiq1q5sN7-0bhEtWobBYNvg', 'j3gxY6H3z7y9nVGXzPkUdA', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', '2026-03-18 12:48:18', '2026-03-24 11:54:27', NULL, NULL, NULL, '', NULL),
(3, 'thomas-bernard', 'https://fcm.googleapis.com/fcm/send/e7Co-BWYECo:APA91bFY7c-_bZLIMvH-OC2ar71595LsIV1OYBehjU9-w60B4_yMUeHmO8Ytga4eVTRxa-SqIy_J4pZ67EGbAOVrFpBQIOQr6DFG-GlgPfSSlffdYiW5DdgMn5UNEuOzFN1lAeE567Ed', 'BBSiMDQ4zeHM9OGEtbRz7K7VimGHIumFH-V8NRJTN0IBE_Ew4R7oj8vfyQAYS3VmAm9--vnu7iQhn5XhCffDrWU', 'JqOKAo3Q0HQ1E-jxWaN1aw', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', '2026-03-25 13:23:46', '2026-03-25 13:50:17', NULL, NULL, NULL, '', NULL),
(4, 'thomas-bernard', 'https://fcm.googleapis.com/fcm/send/d6AXHSgQ67Q:APA91bE8eJ6L96Y3QanrqJP8bC0WPIZnT1FUNxdUKLNwmpOPTCHRfOL_1PXZ7RyPs6gXkxHlSk8A8irbegebwvVa-KIYdqH7WHl0oKXCEE99fuSyfx18677Cj7BoGfGjv1J1hvprIrzJ', 'BFZ7PmvV7mKB5AntciB-7VDdJW-PrVGycfUncn2Pm96_GGjkpXkmcUUAJi28KJxAYb5cSNLGriwwmqRhjafXoo0', '1RtYmJ8tLt06IE4cK5DJmw', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', '2026-03-26 07:57:47', NULL, NULL, NULL, NULL, '', NULL);

-- --------------------------------------------------------

--
-- Structure de la table `recommendation`
--

CREATE TABLE IF NOT EXISTS `recommendation` (
  `id` int NOT NULL AUTO_INCREMENT,
  `message` longtext,
  `created_at` datetime NOT NULL,
  `status` varchar(20) NOT NULL,
  `recommender_name` varchar(255) NOT NULL,
  `recommender_entreprise` varchar(255) DEFAULT NULL,
  `recommender_email` varchar(255) DEFAULT NULL,
  `recommender_phone` varchar(50) DEFAULT NULL,
  `contact_name` varchar(255) NOT NULL,
  `contact_email` varchar(255) NOT NULL,
  `contact_phone` varchar(50) DEFAULT NULL,
  `contact_entreprise` varchar(255) DEFAULT NULL,
  `offre_suggeree` varchar(50) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `beneficiaire_id` int NOT NULL,
  `submitter_ip` varchar(45) DEFAULT NULL,
  `submitter_hash` varchar(64) DEFAULT NULL,
  `consent_mention_version` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_433224D25AF81F68` (`beneficiaire_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Déchargement des données de la table `recommendation`
--

INSERT INTO `recommendation` (`id`, `message`, `created_at`, `status`, `recommender_name`, `recommender_entreprise`, `recommender_email`, `recommender_phone`, `contact_name`, `contact_email`, `contact_phone`, `contact_entreprise`, `offre_suggeree`, `updated_at`, `beneficiaire_id`, `submitter_ip`, `submitter_hash`, `consent_mention_version`) VALUES
(1, 'A contacter d\'urgence', '2026-03-19 10:25:31', 'new', 'Nathalie MARTIN', 'Sud Développement', NULL, NULL, 'Jean louis parfait', 'jlp@live.fr', '08 85 65 25 56', NULL, NULL, '2026-03-19 10:25:31', 49, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Structure de la table `rgpd_rights_requests`
--

CREATE TABLE IF NOT EXISTS `rgpd_rights_requests` (
  `id` int NOT NULL AUTO_INCREMENT,
  `type` varchar(50) NOT NULL,
  `status` varchar(20) NOT NULL,
  `requested_at` datetime NOT NULL,
  `processed_at` datetime DEFAULT NULL,
  `download_token` varchar(64) DEFAULT NULL,
  `download_token_expires_at` datetime DEFAULT NULL,
  `export_file_path` varchar(255) DEFAULT NULL,
  `error_message` longtext,
  `request_ip` varchar(45) DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `nom_demandeur` varchar(200) DEFAULT NULL,
  `email_demandeur` varchar(180) DEFAULT NULL,
  `deadline_at` datetime DEFAULT NULL,
  `notes_admin` longtext,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_951BA948704D2D87` (`download_token`),
  KEY `IDX_951BA948A76ED395` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Déchargement des données de la table `rgpd_rights_requests`
--

INSERT INTO `rgpd_rights_requests` (`id`, `type`, `status`, `requested_at`, `processed_at`, `download_token`, `download_token_expires_at`, `export_file_path`, `error_message`, `request_ip`, `user_id`, `nom_demandeur`, `email_demandeur`, `deadline_at`, `notes_admin`) VALUES
(1, 'suppression', 'refused', '2026-04-24 09:45:30', '2026-04-27 12:34:50', NULL, NULL, NULL, NULL, '127.0.0.1', 3, 'Philippe CECILE', 'cecilephilippe31@gmail.com', '2026-05-24 09:45:30', '[27/04/2026 12:34] Rejet — Aucun motif renseigné — Admin : contact@num-ecard.com'),
(2, 'suppression', 'processed', '2026-04-27 12:36:18', '2026-04-27 13:14:07', NULL, NULL, NULL, NULL, '127.0.0.1', 3, 'Philippe CECILE', 'cecilephilippe31@gmail.com', '2026-05-27 12:36:18', '[27/04/2026 13:14] Anonymisation exécutée par contact@num-ecard.com');

-- --------------------------------------------------------

--
-- Structure de la table `tracking_events`
--

CREATE TABLE IF NOT EXISTS `tracking_events` (
  `id` int NOT NULL AUTO_INCREMENT,
  `type` varchar(20) NOT NULL,
  `action` varchar(50) DEFAULT NULL,
  `pays` varchar(2) DEFAULT NULL,
  `device` varchar(50) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `beneficiaire_id` int NOT NULL,
  `source` varchar(20) DEFAULT NULL,
  `duration` smallint DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_FB0BD4065AF81F68` (`beneficiaire_id`),
  KEY `idx_tracking_benef_date` (`beneficiaire_id`,`created_at`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Déchargement des données de la table `tracking_events`
--

INSERT INTO `tracking_events` (`id`, `type`, `action`, `pays`, `device`, `created_at`, `beneficiaire_id`, `source`, `duration`) VALUES
(1, 'vue', NULL, NULL, 'mobile', '2026-03-30 14:14:15', 48, 'qr', NULL),
(2, 'clic', 'telephone', NULL, NULL, '2026-03-30 14:16:37', 48, NULL, NULL);

-- --------------------------------------------------------

--
-- Structure de la table `user`
--

CREATE TABLE IF NOT EXISTS `user` (
  `id` int NOT NULL AUTO_INCREMENT,
  `email` varchar(180) NOT NULL,
  `roles` json NOT NULL,
  `password` varchar(255) NOT NULL,
  `is_verified` tinyint NOT NULL,
  `reset_token` varchar(100) DEFAULT NULL,
  `reset_token_expires_at` datetime DEFAULT NULL,
  `verification_token` varchar(100) DEFAULT NULL,
  `verification_token_expires_at` datetime DEFAULT NULL,
  `nom` varchar(100) DEFAULT NULL,
  `prenom` varchar(100) DEFAULT NULL,
  `telephone` varchar(20) DEFAULT NULL,
  `entreprise` varchar(200) DEFAULT NULL,
  `adresse` longtext,
  `created_at` datetime NOT NULL,
  `last_login_at` datetime DEFAULT NULL,
  `marketing_opt_in` tinyint DEFAULT NULL,
  `marketing_opt_in_at` datetime DEFAULT NULL,
  `marketing_opt_in_ip` varchar(45) DEFAULT NULL,
  `marketing_opt_in_version` varchar(20) DEFAULT NULL,
  `marketing_opt_in_channel` varchar(30) DEFAULT NULL,
  `password_changed_at` datetime DEFAULT NULL,
  `password_history` json DEFAULT NULL,
  `totp_secret` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_IDENTIFIER_EMAIL` (`email`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Déchargement des données de la table `user`
--

INSERT INTO `user` (`id`, `email`, `roles`, `password`, `is_verified`, `reset_token`, `reset_token_expires_at`, `verification_token`, `verification_token_expires_at`, `nom`, `prenom`, `telephone`, `entreprise`, `adresse`, `created_at`, `last_login_at`, `marketing_opt_in`, `marketing_opt_in_at`, `marketing_opt_in_ip`, `marketing_opt_in_version`, `marketing_opt_in_channel`, `password_changed_at`, `password_history`, `totp_secret`) VALUES
(1, 'contact@num-ecard.com', '[\"ROLE_ADMIN\"]', '$2y$13$bF/QdYgEDk0XYIm6VOf6SeXBtGWLXrGhhKRTTWuimv9MtTwoLafvy', 1, NULL, NULL, 'd024184ef05ac1559b597568100b7f92a81cfdd0c4b937a55fbade3bc707afa5', '2026-02-17 15:34:29', 'Sanachy', 'Patrice', NULL, NULL, NULL, '2026-02-16 15:34:28', NULL, NULL, NULL, NULL, NULL, NULL, '2026-04-09 15:27:55', NULL, 'HMGI5SUBMT75FLKCB7U4JH26ZCPDZXPOT7M46H4WQVXVOGFXWUSA'),
(3, 'deleted-3@void.local', '[]', '4ed857545d4e804012b831a85b11bd8f88ca6fc82c95ac6ee0e9c648bf8b62c8', 0, NULL, NULL, '02f99b1a4ec9ca6cd7cdd7b7be9aa0555ce8296b2169702c8e4af50744095275', '2026-02-20 11:33:21', 'Compte', 'Supprimé', NULL, NULL, NULL, '2026-02-19 11:33:20', NULL, 0, NULL, NULL, NULL, NULL, '2026-04-09 15:27:55', NULL, NULL),
(4, 'cecilephilippe31@gmail.com', '[]', '$2y$13$LJW1xTMQ1/36xNCXkbGOAOaBN1cTQ/rJtr24aQ78SSUtJ8qCus.nW', 1, NULL, NULL, NULL, NULL, 'CECILE', 'Philippe', NULL, NULL, NULL, '2026-04-28 07:01:56', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
COMMIT;

