-- phpMyAdmin SQL Dump
-- version 5.2.3
-- https://www.phpmyadmin.net/
--
-- Hôte : 127.0.0.1:3306
-- Généré le : jeu. 09 avr. 2026 à 13:35
-- Version du serveur : 8.4.7
-- Version de PHP : 8.3.28

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

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

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

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

DROP TABLE IF EXISTS `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 `beneficiaire`
--

DROP TABLE IF EXISTS `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`
--

DROP TABLE IF EXISTS `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'),
(54, 'MOREAU', 'Léa', 'TechVision', NULL, NULL, 'Solutions digitales sur mesure', 'Chef de Projet', '0582813129', '0687530413', 'léa.moreau@techvision.fr', 'https://www.techvision.fr', '24 rue des Coquelicots, 31354 Montauban', 549.00, 'https://linkedin.com/in/léa-moreau', 'https://facebook.com/léamoreau', NULL, NULL, 'https://instagram.com/léa_moreau', NULL, 'beneficiaire'),
(53, 'LEROY', 'Hugo', 'RENFORT IMMO', NULL, NULL, 'Solutions digitales sur mesure', 'Développeur Web', '0592773565', '0620829541', 'hugo.leroy@renfortimmo.fr', 'https://www.renfortimmo.fr', '139 rue Jean Jaurès, 31473 Montauban', 549.00, 'https://linkedin.com/in/hugo-leroy', 'https://facebook.com/hugoleroy', NULL, NULL, 'https://instagram.com/hugo_leroy', NULL, 'beneficiaire'),
(52, 'DALAYRAC', 'Emma', 'SANAGENCY', NULL, NULL, 'Solutions digitales sur mesure', 'Directeur Général', '0532802918', '0615474114', 'emma.dalayrac@sanagency.fr', 'https://www.sanagency.fr', '18 rue du Commerce, 31474 Montauban', 549.00, 'https://linkedin.com/in/emma-dalayrac', 'https://facebook.com/emmadalayrac', NULL, NULL, 'https://instagram.com/emma_dalayrac', NULL, 'beneficiaire'),
(51, 'BERNARD', 'Thomas', 'Sud Développement', NULL, NULL, 'Solutions digitales sur mesure', 'Designer', '0573168440', '0623075146', 'thomas.bernard@suddveloppement.fr', 'https://www.suddveloppement.fr', '55 rue des Lilas, 31456 Toulouse', 549.00, 'https://linkedin.com/in/thomas-bernard', 'https://facebook.com/thomasbernard', 'https://www.youtube.com/@Philou_fwi', 'https://www.tiktok.com/@philfwi', 'https://instagram.com/thomas_bernard', '', 'beneficiaire'),
(50, 'LEROY', 'Paul', 'Innov\'Toulouse', NULL, '', 'Créons ensemble votre succès', 'Consultant', '0564015972', '0647266081', 'paul.leroy@innovtoulouse.fr', 'https://www.innovtoulouse.fr', '113 rue Jean Jaurès, 31796 Montauban', 549.00, 'https://linkedin.com/in/paul-leroy', 'https://facebook.com/paulleroy', '', '', 'https://instagram.com/paul_leroy', '', '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`
--

DROP TABLE IF EXISTS `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, 2),
(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`
--

DROP TABLE IF EXISTS `consent_log`;
CREATE TABLE IF NOT EXISTS `consent_log` (
  `id` int NOT NULL AUTO_INCREMENT,
  `email` varchar(180) NOT NULL,
  `type` varchar(50) NOT NULL,
  `source` varchar(50) NOT NULL,
  `consent_value` tinyint NOT NULL,
  `consent_version` varchar(20) NOT NULL,
  `ip` varchar(45) DEFAULT NULL,
  `user_agent` varchar(500) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `revoked_at` datetime DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_30113729A76ED395` (`user_id`),
  KEY `idx_consent_email` (`email`),
  KEY `idx_consent_source` (`source`),
  KEY `idx_consent_created` (`created_at`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

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

DROP TABLE IF EXISTS `doctrine_migration_versions`;
CREATE TABLE IF NOT EXISTS `doctrine_migration_versions` (
  `version` varchar(191) 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\\Version20260409132035', '2026-04-09 15:20:44', 252),
('DoctrineMigrations\\Version20260409122118', '2026-04-09 14:21:27', 252);

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

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

DROP TABLE IF EXISTS `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`
--

DROP TABLE IF EXISTS `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`
--

DROP TABLE IF EXISTS `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=12 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
(1, 'trial', '2026-03-24 09:47:50', '2027-03-24 09:47:50', NULL, 'cs_test_a1Fx7jp66sRAwLkd8RQQ2l3065vaC8eF87DKq0mWudUvvJCPpXXrX5C9YL', NULL, NULL, 0, '2026-03-24 09:47:50', NULL, 50, 0),
(2, 'trial', '2026-03-25 12:00:54', '2027-03-25 12:00:54', NULL, NULL, NULL, NULL, 0, '2026-03-25 12:00:54', NULL, 51, 0),
(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),
(5, 'trial', '2026-03-26 14:02:01', '2027-03-26 14:02:01', NULL, NULL, NULL, NULL, 0, '2026-03-26 14:02:01', NULL, 52, 0),
(6, 'trial', '2026-03-27 16:33:01', '2027-03-27 16:33:01', NULL, NULL, NULL, NULL, 0, '2026-03-27 16:33:01', NULL, 54, 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`
--

DROP TABLE IF EXISTS `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`
--

DROP TABLE IF EXISTS `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`
--

DROP TABLE IF EXISTS `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 `premium`
--

DROP TABLE IF EXISTS `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`
--

DROP TABLE IF EXISTS `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`
--

DROP TABLE IF EXISTS `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 `tracking_events`
--

DROP TABLE IF EXISTS `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`
--

DROP TABLE IF EXISTS `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=4 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', 0, 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, NULL),
(2, 'phil31780@live.fr', '[]', '$2y$13$mhnDrLzpZ7KQ7Vh5sn7ZLuUphDuHAz6dEUsmh4zhucT2osQASv7am', 0, NULL, NULL, '7fd9a85655fd2527382de34b5f221a8c7b01688319e724a2a217387d229798f9', '2026-02-20 08:56:35', 'CECILE', 'Philippe', '07 89 54 86 28', NULL, NULL, '2026-02-19 08:56:34', NULL, NULL, NULL, NULL, NULL, NULL, '2026-04-09 15:27:55', NULL, NULL),
(3, 'cecilephilippe31@gmail.com', '[\"ROLE_USER\"]', '$2y$13$i8N.x.xKqJ/gTWab5ovp9ur9f8FYJPGeKu4pS7ZDGqRQajgBUD03G', 0, NULL, NULL, '02f99b1a4ec9ca6cd7cdd7b7be9aa0555ce8296b2169702c8e4af50744095275', '2026-02-20 11:33:21', 'CECILE', 'Philippe', NULL, NULL, NULL, '2026-02-19 11:33:20', NULL, NULL, NULL, NULL, NULL, NULL, '2026-04-09 15:27:55', NULL, NULL);
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;