-- https://www.phpmyadmin.net/
--
-- Hôte : 127.0.0.1:3306
-- Généré le : mar. 24 mars 2026 à 12:06
-- 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 `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;

--
-- 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`) 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),
('initiales', 'NM', NULL, 'template', 55, '#667eea', '#764ba2', NULL, NULL, 'Développement web', 'Communication digitale', 'Photo/Vidéo', 'SEO/SEA', '', '', '', '', 0, '', 0, '', 0, '', 0, '', 0, '', '', '', '', '', 1, 17, '2026-03-20 12:19:33', 1, 40, 49, NULL, NULL, 1, 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),
('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);

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

--
-- 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=52 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
(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', NULL, 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', NULL, 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', NULL, 549.00, 'https://linkedin.com/in/nathalie-martin', 'https://facebook.com/nathaliemartin', '', '', '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', NULL, 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=43 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);

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

--
-- 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),
('DoctrineMigrations\\Version20260310082216', '2026-03-10 09:22:25', 207),
('DoctrineMigrations\\Version20260311123848', '2026-03-11 13:38:56', 226),
('DoctrineMigrations\\Version20260318083521', '2026-03-18 09:35:30', 233),
('DoctrineMigrations\\Version20260323130841', '2026-03-23 14:08:49', 204),
('DoctrineMigrations\\Version20260323131635', '2026-03-23 14:16:45', 208),
('DoctrineMigrations\\Version20260323134032', '2026-03-23 14:40:43', 266),
('DoctrineMigrations\\Version20260323143229', '2026-03-23 15:32:37', 340),
('DoctrineMigrations\\Version20260324111335', '2026-03-24 12:13:54', 257);

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

--
-- 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=2 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);

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

--
-- 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=3 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);

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

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

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

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

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=3 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'),
(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');

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

--
-- 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,
  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`) 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);

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

--
-- 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,
  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, '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),
(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),
(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;

