-- phpMyAdmin SQL Dump
-- version 5.2.3
-- https://www.phpmyadmin.net/
--
-- Hôte : 127.0.0.1:3306
-- Généré le : lun. 16 mars 2026 à 08:16
-- 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,
  PRIMARY KEY (`id`),
  KEY `IDX_B140D80282EA2E54` (`commande_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- 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,
  `actu` varchar(1000) DEFAULT NULL,
  `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=48 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- 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=39 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\\Version20260219085042', '2026-02-19 09:50:52', 153),
('DoctrineMigrations\\Version20260219085350', '2026-02-19 09:53:58', 173),
('DoctrineMigrations\\Version20260309092842', '2026-03-09 10:28:52', 209),
('DoctrineMigrations\\Version20260309101650', '2026-03-09 11:17:01', 237),
('DoctrineMigrations\\Version20260310082216', '2026-03-10 09:22:25', 207),
('DoctrineMigrations\\Version20260311123848', '2026-03-11 13:38:56', 226);

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

--
-- 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 `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 `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 `order`
--

DROP TABLE IF EXISTS `order`;
CREATE TABLE IF NOT EXISTS `order` (
  `id` int NOT NULL AUTO_INCREMENT,
  `card_ids` json NOT NULL,
  `total_ht` decimal(10,2) NOT NULL,
  `total_ttc` decimal(10,2) NOT NULL,
  `status` varchar(50) NOT NULL,
  `stripe_session_id` varchar(255) DEFAULT NULL,
  `stripe_payment_intent_id` varchar(255) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `paid_at` datetime DEFAULT NULL,
  `customer_email` varchar(255) DEFAULT NULL,
  `customer_name` varchar(255) DEFAULT NULL,
  `notes` longtext,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Structure de la table `order_item`
--

DROP TABLE IF EXISTS `order_item`;
CREATE TABLE IF NOT EXISTS `order_item` (
  `id` int NOT NULL AUTO_INCREMENT,
  `quantity` int NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `card_name` varchar(255) NOT NULL,
  `session_token` varchar(255) DEFAULT NULL,
  `order_ref_id` int DEFAULT NULL,
  `card_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_52EA1F09E238517C` (`order_ref_id`),
  KEY `IDX_52EA1F094ACC9A20` (`card_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,
  `satifaction` 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,
  PRIMARY KEY (`id`),
  KEY `idx_push_card_slug` (`card_slug`(250)),
  KEY `idx_push_created` (`created_at`)
) ENGINE=MyISAM AUTO_INCREMENT=2 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`) 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');

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

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

DROP TABLE IF EXISTS `recommendation`;
CREATE TABLE IF NOT EXISTS `recommendation` (
  `id` int NOT NULL AUTO_INCREMENT,
  `prospect_company` varchar(255) DEFAULT NULL,
  `prospect_phone` varchar(50) DEFAULT NULL,
  `message` longtext,
  `created_at` datetime NOT NULL,
  `status` varchar(20) NOT NULL,
  `contacted_at` datetime DEFAULT NULL,
  `prospect_name` varchar(255) NOT NULL,
  `prospect_email` varchar(255) NOT NULL,
  `prospect_sector` varchar(100) DEFAULT NULL,
  `interested_package` varchar(100) DEFAULT NULL,
  `referrer_name` varchar(255) NOT NULL,
  `referrer_email` varchar(255) DEFAULT NULL,
  `referrer_phone` varchar(50) DEFAULT NULL,
  `source_card_slug` varchar(255) NOT NULL,
  `converted_at` datetime DEFAULT NULL,
  `admin_notes` longtext,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- 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,
  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`) VALUES
(1, 'tom@tom.fr', '[\"ROLE_ADMIN\"]', '$2y$13$bF/QdYgEDk0XYIm6VOf6SeXBtGWLXrGhhKRTTWuimv9MtTwoLafvy', 0, NULL, NULL, 'd024184ef05ac1559b597568100b7f92a81cfdd0c4b937a55fbade3bc707afa5', '2026-02-17 15:34:29', 'tom', 'Tom', NULL, NULL, NULL, '2026-02-16 15:34:28', NULL),
(2, 'phil31780@live.fr', '[]', '$2y$13$GTZMJ2WUZvgtLpQ8DoDdEejPEtF1UvA66FgotnN.VlcDt4oM0aJ6m', 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),
(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);
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 */;