-- phpMyAdmin SQL Dump
-- version 5.2.3
-- https://www.phpmyadmin.net/
--
-- Hôte : 127.0.0.1:3306
-- Généré le : mer. 03 déc. 2025 à 14:07
-- 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 `card`
--

DROP TABLE IF EXISTS `card`;
CREATE TABLE IF NOT EXISTS `card` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` longtext NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `available` tinyint NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

INSERT INTO `card` (`id`, `name`, `description`, `price`, `image`, `available`) VALUES
(1, 'Modèle Essentiel', 'Modèle\nEssentiel', 199.00, NULL, 1),
(2, 'Model Premium', 'Model Premium', 349.00, NULL, 1),
(3, 'Modèle Platinium', 'Modèle\nPlatinium', 499.00, NULL, 1);

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

--
-- 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\\Version20251203115922', '2025-12-03 11:59:29', 26),
('DoctrineMigrations\\Version20251203131451', '2025-12-03 13:14:56', 58);

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

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

DROP TABLE IF EXISTS `order`;
CREATE TABLE IF NOT EXISTS `order` (
  `id` int NOT NULL AUTO_INCREMENT,
  `reference` varchar(20) NOT NULL,
  `total` decimal(10,2) NOT NULL,
  `status` varchar(50) NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_F5299398AEA34913` (`reference`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

INSERT INTO `order` (`id`, `reference`, `total`, `status`, `created_at`) VALUES
(1, 'ORDER_69303a249d1a6', 1497.00, 'PENDING', '2025-12-03 13:24:52'),
(2, 'ORDER_69303a28babe1', 1497.00, 'PENDING', '2025-12-03 13:24:56'),
(3, 'ORDER_69303a2b669db', 1497.00, 'PENDING', '2025-12-03 13:24:59'),
(4, 'ORDER_69303a3007904', 499.00, 'PENDING', '2025-12-03 13:25:04'),
(5, 'ORDER_69303a404f024', 499.00, 'PENDING', '2025-12-03 13:25:20'),
(6, 'ORDER_69303a4c422aa', 499.00, 'PENDING', '2025-12-03 13:25:32'),
(7, 'ORDER_69303b9e6da89', 499.00, 'PENDING', '2025-12-03 13:31:10'),
(8, 'ORDER_69303ba01c058', 499.00, 'PENDING', '2025-12-03 13:31:12'),
(9, 'ORDER_69303bbac3f6a', 499.00, 'PENDING', '2025-12-03 13:31:38'),
(10, 'ORDER_69303c7b141e9', 499.00, 'PENDING', '2025-12-03 13:34:51'),
(11, 'ORDER_69303c7fd148d', 499.00, 'PENDING', '2025-12-03 13:34:55'),
(12, 'ORDER_69303c9869d71', 2743.00, 'PENDING', '2025-12-03 13:35:20'),
(13, 'ORDER_69303c9bb1935', 2743.00, 'PENDING', '2025-12-03 13:35:23'),
(14, 'ORDER_69303cb160cc9', 2743.00, 'PENDING', '2025-12-03 13:35:45'),
(15, 'ORDER_69303d928fffc', 3043.00, 'PENDING', '2025-12-03 13:39:30'),
(16, 'ORDER_69303d9abb2e5', 199.00, 'PENDING', '2025-12-03 13:39:38'),
(17, 'ORDER_69303da255711', 1047.00, 'PENDING', '2025-12-03 13:39:46');

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

--
-- 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,
  `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 AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

INSERT INTO `order_item` (`id`, `quantity`, `price`, `card_name`, `order_ref_id`, `card_id`) VALUES
(1, 3, 499.00, 'Modèle Platinium', 1, 3),
(2, 3, 499.00, 'Modèle Platinium', 2, 3),
(3, 3, 499.00, 'Modèle Platinium', 3, 3),
(4, 1, 499.00, 'Modèle Platinium', 4, 3),
(5, 1, 499.00, 'Modèle Platinium', 5, 3),
(6, 1, 499.00, 'Modèle Platinium', 6, 3),
(7, 1, 499.00, 'Modèle Platinium', 7, 3),
(8, 1, 499.00, 'Modèle Platinium', 8, 3),
(9, 1, 499.00, 'Modèle Platinium', 9, 3),
(10, 1, 499.00, 'Modèle Platinium', 10, 3),
(11, 1, 499.00, 'Modèle Platinium', 11, 3),
(12, 4, 499.00, 'Modèle Platinium', 12, 3),
(13, 2, 199.00, 'Modèle Essentiel', 12, 1),
(14, 1, 349.00, 'Model Premium', 12, 2),
(15, 4, 499.00, 'Modèle Platinium', 13, 3),
(16, 2, 199.00, 'Modèle Essentiel', 13, 1),
(17, 1, 349.00, 'Model Premium', 13, 2),
(18, 4, 499.00, 'Modèle Platinium', 14, 3),
(19, 2, 199.00, 'Modèle Essentiel', 14, 1),
(20, 1, 349.00, 'Model Premium', 14, 2),
(21, 5, 499.00, 'Modèle Platinium', 15, 3),
(22, 1, 199.00, 'Modèle Essentiel', 15, 1),
(23, 1, 349.00, 'Model Premium', 15, 2),
(24, 1, 199.00, 'Modèle Essentiel', 16, 1),
(25, 1, 199.00, 'Modèle Essentiel', 17, 1),
(26, 1, 499.00, 'Modèle Platinium', 17, 3),
(27, 1, 349.00, 'Model Premium', 17, 2);
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 */;
