-- https://www.phpmyadmin.net/
--
-- Hôte : 127.0.0.1:3306
-- Généré le : lun. 09 mars 2026 à 12:44
-- 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=2 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 2', 'realisation', '69aea74106f19.png', NULL, NULL, 1, 'publie', 0, 0, '2026-03-09 11:56:01', '2026-03-09 13:08:28', 1, 40);

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

--
-- 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,
  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`) VALUES
('initiales', 'LD', NULL, 'template', 11, NULL, NULL, NULL, NULL, 'Événementiel', 'Conseil stratégique', 'Développement web', 'SEO/SEA', NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 3, 0, NULL, 0, 11, 16, NULL, NULL),
('initiales', 'ND', NULL, 'template', 3, NULL, NULL, NULL, NULL, 'Conseil stratégique', 'SEO/SEA', 'Photo/Vidéo', 'Événementiel', NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 2, 0, NULL, 0, 11, 15, NULL, NULL),
('initiales', 'AM', NULL, 'template', 5, NULL, NULL, NULL, NULL, 'SEO/SEA', 'Gestion immobilière', 'Conseil stratégique', 'Marketing digital', NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, 0, 11, 14, NULL, NULL),
('initiales', 'SL', NULL, 'template', 2, NULL, NULL, NULL, NULL, 'SEO/SEA', 'Communication digitale', 'Formation', 'Événementiel', NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 4, 0, NULL, 0, 10, 13, NULL, NULL),
('initiales', 'TG', NULL, 'template', 44, NULL, NULL, NULL, NULL, 'Formation', 'Gestion immobilière', 'Communication digitale', 'SEO/SEA', NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 3, 0, NULL, 0, 10, 12, NULL, NULL),
('initiales', 'MR', NULL, 'template', 45, NULL, NULL, NULL, NULL, 'Design graphique', 'Gestion immobilière', 'Événementiel', 'SEO/SEA', NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 2, 0, NULL, 0, 10, 11, NULL, NULL),
('initiales', 'HB', NULL, 'template', 8, NULL, NULL, NULL, NULL, 'SEO/SEA', 'Communication digitale', 'Formation', 'Photo/Vidéo', NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, 0, 10, 10, NULL, NULL),
('initiales', 'CC', NULL, 'template', 3, '#667eea', '#764ba2', NULL, NULL, 'Communication digitale', 'Conseil stratégique', 'Événementiel', 'Formation', '', '', '', '', 0, '', 0, '', 0, '', 0, '', 0, '', '', '', '', '', 1, 1, '2026-02-18 09:11:47', 0, 9, 9, NULL, NULL),
('initiales', 'PG', NULL, 'template', 13, NULL, NULL, NULL, NULL, 'SEO/SEA', 'Conseil stratégique', 'Développement web', 'Événementiel', NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 4, 0, NULL, 0, 11, 17, NULL, NULL),
('initiales', 'CR', NULL, 'template', 2, NULL, NULL, NULL, NULL, 'Photo/Vidéo', 'Événementiel', 'Design graphique', 'Marketing digital', NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, 0, 12, 18, NULL, NULL),
('initiales', 'JL', NULL, 'template', 2, NULL, NULL, NULL, NULL, 'Gestion immobilière', 'Design graphique', 'Marketing digital', 'Développement web', NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, 0, 13, 19, NULL, NULL),
('initiales', 'MD', NULL, 'template', 7, NULL, NULL, NULL, NULL, 'Marketing digital', 'Événementiel', 'Conseil stratégique', 'Formation', NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, 0, 14, 20, NULL, NULL),
('initiales', 'LR', NULL, 'template', 1, NULL, NULL, NULL, NULL, 'Formation', 'Gestion immobilière', 'Photo/Vidéo', 'Événementiel', NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, 0, 15, 21, NULL, NULL),
('initiales', 'CP', NULL, 'template', 40, 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, 0, 16, 22, NULL, NULL),
('initiales', 'JD', NULL, 'template', 2, NULL, NULL, NULL, NULL, 'Photo/Vidéo', 'Communication digitale', 'Développement web', 'Formation', NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, 0, 17, 23, NULL, NULL),
('initiales', 'NC', NULL, 'template', 4, NULL, NULL, NULL, NULL, 'Développement web', 'Formation', 'Design graphique', 'Photo/Vidéo', NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, 0, 18, 24, NULL, NULL),
('initiales', 'LC', NULL, 'template', 40, NULL, NULL, NULL, NULL, 'Gestion immobilière', 'Événementiel', 'Communication digitale', 'Développement web', NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, 0, 19, 25, NULL, NULL),
('initiales', 'SG', NULL, 'template', 2, NULL, NULL, NULL, NULL, 'Développement web', 'Événementiel', '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, 0, 20, 26, NULL, NULL),
('initiales', 'PR', NULL, 'template', 2, NULL, NULL, NULL, NULL, 'SEO/SEA', 'Formation', 'Gestion immobilière', 'Événementiel', NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, 0, 21, 27, NULL, NULL),
('initiales', 'PD', NULL, 'template', 44, NULL, NULL, NULL, NULL, 'Photo/Vidéo', 'Développement web', 'Formation', 'Communication digitale', NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, 1, 22, 28, NULL, NULL),
('initiales', 'TL', NULL, 'template', 4, NULL, NULL, NULL, NULL, 'Communication digitale', 'Conseil stratégique', 'Photo/Vidéo', 'Marketing digital', NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, 1, 23, 29, NULL, NULL),
('initiales', 'PB', NULL, 'template', 54, NULL, NULL, NULL, NULL, 'SEO/SEA', 'Développement web', 'Conseil stratégique', 'Marketing digital', NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, 1, 24, 30, NULL, NULL),
('initiales', 'HM', NULL, 'template', 27, NULL, NULL, NULL, NULL, 'Design graphique', 'Gestion immobilière', 'SEO/SEA', '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, 25, 31, NULL, NULL),
('initiales', 'EM', NULL, 'template', 46, NULL, NULL, NULL, NULL, 'Design graphique', 'Conseil stratégique', 'Gestion immobilière', 'SEO/SEA', NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, 0, 26, 32, NULL, NULL),
('initiales', 'AD', NULL, 'template', 53, NULL, NULL, NULL, NULL, 'Formation', 'Marketing digital', 'Événementiel', 'Design graphique', NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, 1, 27, 33, NULL, NULL),
('initiales', 'PR', NULL, 'template', 53, NULL, NULL, NULL, NULL, 'Formation', 'Développement web', 'Design graphique', 'Communication digitale', NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, 1, 28, 34, NULL, NULL),
('initiales', 'LD', NULL, 'template', 4, NULL, NULL, NULL, NULL, 'Gestion immobilière', 'SEO/SEA', 'Marketing digital', 'Communication digitale', NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, 1, 29, 35, NULL, NULL),
('initiales', 'AD', NULL, 'template', 22, NULL, NULL, NULL, NULL, 'Marketing digital', 'Communication digitale', 'Conseil stratégique', 'Formation', NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, 1, 30, 36, NULL, NULL),
('initiales', 'JD', NULL, 'template', 52, NULL, NULL, NULL, NULL, 'Marketing digital', 'Design graphique', 'Conseil stratégique', '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, 31, 37, NULL, NULL),
('initiales', 'MG', NULL, 'template', 29, NULL, NULL, NULL, NULL, 'Communication digitale', 'Gestion immobilière', 'Développement web', 'Événementiel', NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, 1, 32, 38, NULL, NULL),
('initiales', 'PL', NULL, 'template', 17, NULL, NULL, NULL, NULL, 'Communication digitale', 'Marketing digital', 'Photo/Vidéo', 'Conseil stratégique', NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, 0, 33, 39, NULL, NULL),
('initiales', 'JC', NULL, 'template', 11, NULL, NULL, NULL, NULL, 'Gestion immobilière', 'SEO/SEA', 'Photo/Vidéo', 'Marketing digital', NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, 0, 34, 40, 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,
  `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=41 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`, `actu`, `price`, `linkedin`, `facebook`, `youtube`, `tiktok`, `insta`, `x`, `type`) VALUES
(16, 'DUPONT', 'Léa', 'Digital Cube', NULL, NULL, 'Créons ensemble votre succès', 'Directeur Général', '0589710856', '0691847195', 'léa.dupont@digitalcube.fr', 'https://www.digitalcube.fr', '105 rue Jean Jaurès, 31686 Albi', NULL, 249.75, 'https://linkedin.com/in/léa-dupont', 'https://facebook.com/léadupont', NULL, NULL, 'https://instagram.com/léa_dupont', NULL, 'beneficiaire'),
(17, 'GARCIA', 'Paul', 'Focus Digital', NULL, NULL, 'L\'innovation au service de l\'immobilier', 'Responsable Marketing', '0539738627', '0654006506', 'paul.garcia@focusdigital.fr', 'https://www.focusdigital.fr', '65 rue des Lilas, 31183 Toulouse', NULL, 249.75, 'https://linkedin.com/in/paul-garcia', 'https://facebook.com/paulgarcia', NULL, NULL, 'https://instagram.com/paul_garcia', NULL, 'beneficiaire'),
(15, 'DUPONT', 'Nathalie', 'Focus Digital', NULL, NULL, 'Créons ensemble votre succès', 'Chargé de Communication', '0519680168', '0661788216', 'nathalie.dupont@focusdigital.fr', 'https://www.focusdigital.fr', '150 rue des Coquelicots, 31764 Larra', NULL, 249.75, 'https://linkedin.com/in/nathalie-dupont', 'https://facebook.com/nathaliedupont', NULL, NULL, 'https://instagram.com/nathalie_dupont', NULL, 'beneficiaire'),
(14, 'MARTIN', 'Antoine', 'Focus Digital', NULL, NULL, 'Votre partenaire digital', 'Commercial', '0557546567', '0687553672', 'antoine.martin@focusdigital.fr', 'https://www.focusdigital.fr', '112 rue de la République, 31524 Colomiers', NULL, 249.75, 'https://linkedin.com/in/antoine-martin', 'https://facebook.com/antoinemartin', NULL, NULL, 'https://instagram.com/antoine_martin', NULL, 'beneficiaire'),
(13, 'LEROY', 'Sophie', 'TechVision', NULL, NULL, 'Votre partenaire digital', 'Développeur Web', '0592116928', '0633135928', 'sophie.leroy@techvision.fr', 'https://www.techvision.fr', '38 rue Jean Jaurès, 31324 Blagnac', NULL, 249.75, 'https://linkedin.com/in/sophie-leroy', 'https://facebook.com/sophieleroy', NULL, NULL, 'https://instagram.com/sophie_leroy', NULL, 'beneficiaire'),
(12, 'GARCIA', 'Thomas', 'Sud Développement', NULL, NULL, 'Créons ensemble votre succès', 'Chargé de Communication', '0562899457', '0617678853', 'thomas.garcia@suddveloppement.fr', 'https://www.suddveloppement.fr', '24 rue Victor Hugo, 31177 Colomiers', NULL, 249.75, 'https://linkedin.com/in/thomas-garcia', 'https://facebook.com/thomasgarcia', NULL, NULL, 'https://instagram.com/thomas_garcia', NULL, 'beneficiaire'),
(11, 'ROUX', 'Marie', 'SANAGENCY', NULL, NULL, 'L\'innovation au service de l\'immobilier', 'Designer', '0538873455', '0686195146', 'marie.roux@sanagency.fr', 'https://www.sanagency.fr', '111 rue de la République, 31421 Larra', NULL, 249.75, 'https://linkedin.com/in/marie-roux', 'https://facebook.com/marieroux', NULL, NULL, 'https://instagram.com/marie_roux', NULL, 'beneficiaire'),
(10, 'BERNARD', 'Hugo', 'Focus Digital', NULL, NULL, 'L\'innovation au service de l\'immobilier', 'Directeur Général', '0569113010', '0682869327', 'hugo.bernard@focusdigital.fr', 'https://www.focusdigital.fr', '80 rue de la République, 31547 Larra', NULL, 249.75, 'https://linkedin.com/in/hugo-bernard', 'https://facebook.com/hugobernard', NULL, NULL, 'https://instagram.com/hugo_bernard', NULL, 'beneficiaire'),
(9, 'CECILE', 'Clara', 'Digital Cube', NULL, '', 'Votre partenaire digital', 'Responsable Marketing', '0577260563', '0789548628', 'phil31780@live.fr', 'https://www.digitalcube.fr', '11 rue des Coquelicots, 31373 Toulouse', NULL, 349.00, 'https://linkedin.com/in/clara-cecile', 'https://facebook.com/claracecile', '', '', 'https://instagram.com/clara_cecile', '', 'beneficiaire'),
(18, 'ROUX', 'Clara', 'Sud Développement', NULL, NULL, 'Créons ensemble votre succès', 'Consultant', '0549426574', '0698581018', 'clara.roux@suddveloppement.fr', 'https://www.suddveloppement.fr', '88 rue du Commerce, 31573 Toulouse', NULL, 199.00, 'https://linkedin.com/in/clara-roux', 'https://facebook.com/clararoux', NULL, NULL, 'https://instagram.com/clara_roux', NULL, 'beneficiaire'),
(19, 'LAURENT', 'Jean', 'Sud Développement', NULL, NULL, 'Solutions digitales sur mesure', 'Directeur Général', '0515778677', '0673293660', 'jean.laurent@suddveloppement.fr', 'https://www.suddveloppement.fr', '130 rue du Commerce, 31834 Montauban', NULL, 199.00, 'https://linkedin.com/in/jean-laurent', 'https://facebook.com/jeanlaurent', NULL, NULL, 'https://instagram.com/jean_laurent', NULL, 'beneficiaire'),
(20, 'DALAYRAC', 'Marie', 'Digital Cube', NULL, NULL, 'Créons ensemble votre succès', 'DJ', '0558679075', '0628415014', 'marie.dalayrac@digitalcube.fr', 'https://www.digitalcube.fr', '43 rue des Coquelicots, 31977 Toulouse', NULL, 199.00, 'https://linkedin.com/in/marie-dalayrac', 'https://facebook.com/mariedalayrac', NULL, NULL, 'https://instagram.com/marie_dalayrac', NULL, 'beneficiaire'),
(21, 'ROUX', 'Léa', 'Digital Cube', NULL, NULL, 'Créons ensemble votre succès', 'Commercial', '0532742857', '0671434448', 'léa.roux@digitalcube.fr', 'https://www.digitalcube.fr', '50 rue du Commerce, 31464 Montauban', NULL, 199.00, 'https://linkedin.com/in/léa-roux', 'https://facebook.com/léaroux', NULL, NULL, 'https://instagram.com/léa_roux', NULL, 'beneficiaire'),
(22, 'PETIT', 'Clara', 'TechVision', NULL, NULL, 'Votre partenaire digital', 'Développeur Web', '0526014773', '0646157112', 'clara.petit@techvision.fr', 'https://www.techvision.fr', '64 rue Victor Hugo, 31941 Toulouse', NULL, 199.00, 'https://linkedin.com/in/clara-petit', 'https://facebook.com/clarapetit', NULL, NULL, 'https://instagram.com/clara_petit', NULL, 'beneficiaire'),
(23, 'DALAYRAC', 'Julie', 'Digital Cube', NULL, NULL, 'Créons ensemble votre succès', 'Consultant', '0597563965', '0633418564', 'julie.dalayrac@digitalcube.fr', 'https://www.digitalcube.fr', '79 rue du Commerce, 31253 Muret', NULL, 199.00, 'https://linkedin.com/in/julie-dalayrac', 'https://facebook.com/juliedalayrac', NULL, NULL, 'https://instagram.com/julie_dalayrac', NULL, 'beneficiaire'),
(24, 'CECILE', 'Nathalie', 'RENFORT IMMO', NULL, NULL, 'L\'innovation au service de l\'immobilier', 'Chargé de Communication', '0579843635', '0673440254', 'nathalie.cecile@renfortimmo.fr', 'https://www.renfortimmo.fr', '87 rue Jean Jaurès, 31789 Toulouse', NULL, 199.00, 'https://linkedin.com/in/nathalie-cecile', 'https://facebook.com/nathaliececile', NULL, NULL, 'https://instagram.com/nathalie_cecile', NULL, 'beneficiaire'),
(25, 'CECILE', 'Luc', 'Innov\'Toulouse', NULL, NULL, 'La musique est ma passion', 'Chargé de Communication', '0549730294', '0695537110', 'luc.cecile@innovtoulouse.fr', 'https://www.innovtoulouse.fr', '35 rue du Commerce, 31278 Montauban', NULL, 199.00, 'https://linkedin.com/in/luc-cecile', 'https://facebook.com/luccecile', NULL, NULL, 'https://instagram.com/luc_cecile', NULL, 'beneficiaire'),
(26, 'GARCIA', 'Sophie', 'TechVision', NULL, NULL, 'Créons ensemble votre succès', 'Consultant', '0546645862', '0693992495', 'sophie.garcia@techvision.fr', 'https://www.techvision.fr', '25 rue Jean Jaurès, 31912 Colomiers', NULL, 199.00, 'https://linkedin.com/in/sophie-garcia', 'https://facebook.com/sophiegarcia', NULL, NULL, 'https://instagram.com/sophie_garcia', NULL, 'beneficiaire'),
(27, 'ROUX', 'Philippe', 'Innov\'Toulouse', NULL, NULL, 'La musique est ma passion', 'DJ', '0573404977', '0673107542', 'philippe.roux@innovtoulouse.fr', 'https://www.innovtoulouse.fr', '64 rue des Lilas, 31387 Montauban', NULL, 199.00, 'https://linkedin.com/in/philippe-roux', 'https://facebook.com/philipperoux', NULL, NULL, 'https://instagram.com/philippe_roux', NULL, 'beneficiaire'),
(28, 'DUPONT', 'Paul', 'Focus Digital', NULL, NULL, 'Créons ensemble votre succès', 'Consultant', '0530959459', '0615149033', 'paul.dupont@focusdigital.fr', 'https://www.focusdigital.fr', '131 rue des Lilas, 31624 Toulouse', NULL, 199.00, 'https://linkedin.com/in/paul-dupont', 'https://facebook.com/pauldupont', NULL, NULL, 'https://instagram.com/paul_dupont', NULL, 'beneficiaire'),
(29, 'LAURENT', 'Thomas', 'TechVision', NULL, NULL, 'L\'innovation au service de l\'immobilier', 'Directeur Général', '0553828577', '0625179857', 'thomas.laurent@techvision.fr', 'https://www.techvision.fr', '11 rue de la République, 31471 Montauban', NULL, 199.00, 'https://linkedin.com/in/thomas-laurent', 'https://facebook.com/thomaslaurent', NULL, NULL, 'https://instagram.com/thomas_laurent', NULL, 'beneficiaire'),
(30, 'BERNARD', 'Paul', 'Digital Cube', NULL, NULL, 'Votre partenaire digital', 'Responsable Marketing', '0536844084', '0664050973', 'paul.bernard@digitalcube.fr', 'https://www.digitalcube.fr', '145 rue du Commerce, 31258 Toulouse', NULL, 199.00, 'https://linkedin.com/in/paul-bernard', 'https://facebook.com/paulbernard', NULL, NULL, 'https://instagram.com/paul_bernard', NULL, 'beneficiaire'),
(31, 'MARTIN', 'Hugo', 'Focus Digital', NULL, NULL, 'La musique est ma passion', 'Consultant', '0542701551', '0656916776', 'hugo.martin@focusdigital.fr', 'https://www.focusdigital.fr', '45 rue de la République, 31264 Blagnac', NULL, 549.00, 'https://linkedin.com/in/hugo-martin', 'https://facebook.com/hugomartin', NULL, NULL, 'https://instagram.com/hugo_martin', NULL, 'beneficiaire'),
(32, 'MARTIN', 'Emma', 'TechVision', NULL, NULL, 'La musique est ma passion', 'Développeur Web', '0521283367', '0683191414', 'emma.martin@techvision.fr', 'https://www.techvision.fr', '90 rue des Coquelicots, 31546 Muret', NULL, 549.00, 'https://linkedin.com/in/emma-martin', 'https://facebook.com/emmamartin', NULL, NULL, 'https://instagram.com/emma_martin', NULL, 'beneficiaire'),
(33, 'DALAYRAC', 'Antoine', 'Sud Développement', NULL, NULL, 'L\'innovation au service de l\'immobilier', 'Chargé de Communication', '0541133500', '0679075421', 'antoine.dalayrac@suddveloppement.fr', 'https://www.suddveloppement.fr', '52 rue des Lilas, 31535 Larra', NULL, 349.00, 'https://linkedin.com/in/antoine-dalayrac', 'https://facebook.com/antoinedalayrac', NULL, NULL, 'https://instagram.com/antoine_dalayrac', NULL, 'beneficiaire'),
(34, 'ROUX', 'Pierre', 'Sud Développement', NULL, NULL, 'Solutions digitales sur mesure', 'Chef de Projet', '0581835426', '0675530987', 'pierre.roux@suddveloppement.fr', 'https://www.suddveloppement.fr', '50 rue Jean Jaurès, 31004 Montauban', NULL, 349.00, 'https://linkedin.com/in/pierre-roux', 'https://facebook.com/pierreroux', NULL, NULL, 'https://instagram.com/pierre_roux', NULL, 'beneficiaire'),
(35, 'DURAND', 'Luc', 'Focus Digital', NULL, NULL, 'L\'innovation au service de l\'immobilier', 'Designer', '0513813705', '0676476709', 'luc.durand@focusdigital.fr', 'https://www.focusdigital.fr', '50 rue Victor Hugo, 31446 Blagnac', NULL, 199.00, 'https://linkedin.com/in/luc-durand', 'https://facebook.com/lucdurand', NULL, NULL, 'https://instagram.com/luc_durand', NULL, 'beneficiaire'),
(36, 'DALAYRAC', 'Antoine', 'Sud Développement', NULL, NULL, 'L\'innovation au service de l\'immobilier', 'Commercial', '0593387324', '0673047571', 'antoine.dalayrac@suddveloppement.fr', 'https://www.suddveloppement.fr', '147 rue des Lilas, 31265 Larra', NULL, 349.00, 'https://linkedin.com/in/antoine-dalayrac', 'https://facebook.com/antoinedalayrac', NULL, NULL, 'https://instagram.com/antoine_dalayrac', NULL, 'beneficiaire'),
(37, 'DUPONT', 'Jean', 'Digital Cube', NULL, NULL, 'La musique est ma passion', 'Développeur Web', '0520497790', '0688542602', 'jean.dupont@digitalcube.fr', 'https://www.digitalcube.fr', '66 rue Victor Hugo, 31167 Colomiers', NULL, 199.00, 'https://linkedin.com/in/jean-dupont', 'https://facebook.com/jeandupont', NULL, NULL, 'https://instagram.com/jean_dupont', NULL, 'beneficiaire'),
(38, 'GARCIA', 'Marie', 'Digital Cube', NULL, NULL, 'Votre partenaire digital', 'Consultant', '0556641873', '0654907463', 'marie.garcia@digitalcube.fr', 'https://www.digitalcube.fr', '32 rue Jean Jaurès, 31348 Colomiers', NULL, 199.00, 'https://linkedin.com/in/marie-garcia', 'https://facebook.com/mariegarcia', NULL, NULL, 'https://instagram.com/marie_garcia', NULL, 'beneficiaire'),
(39, 'LEROY', 'Paul', 'Digital Cube', NULL, NULL, 'La musique est ma passion', 'Consultant', '0524455973', '0634630610', 'paul.leroy@digitalcube.fr', 'https://www.digitalcube.fr', '140 rue de la République, 31966 Montauban', NULL, 199.00, 'https://linkedin.com/in/paul-leroy', 'https://facebook.com/paulleroy', NULL, NULL, 'https://instagram.com/paul_leroy', NULL, 'beneficiaire'),
(40, 'CECILE', 'Julie', 'TechVision', NULL, NULL, 'Solutions digitales sur mesure', 'Directeur Général', '0591480302', '0619207859', 'julie.cecile@techvision.fr', 'https://www.techvision.fr', '121 rue du Commerce, 31720 Toulouse', NULL, 549.00, 'https://linkedin.com/in/julie-cecile', 'https://facebook.com/juliececile', NULL, NULL, 'https://instagram.com/julie_cecile', NULL, 'beneficiaire');

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

--
-- Structure de la table `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);

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

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

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

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 `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;
COMMIT;

