-- https://www.phpmyadmin.net/
--
-- Hôte : 127.0.0.1:3306
-- Généré le : jeu. 21 mai 2026 à 14:38
-- Version du serveur : 8.4.7
-- Version de PHP : 8.3.28

START TRANSACTION;



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

--
-- Structure de la table `page`
--

CREATE TABLE IF NOT EXISTS `page` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `order` int NOT NULL,
  `color` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

INSERT INTO `page` (`id`, `name`, `order`, `color`) VALUES
(1, 'Les entrées', 10, NULL),
(2, 'Lers viandes', 20, NULL),
(3, 'Les pâtes', 30, NULL),
(4, 'Les desserts', 40, NULL);

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

--
-- Structure de la table `plat`
--

CREATE TABLE IF NOT EXISTS `plat` (
  `id` int NOT NULL AUTO_INCREMENT,
  `description` varchar(100) NOT NULL,
  `quantity` varchar(25) DEFAULT NULL,
  `soldout` tinyint NOT NULL DEFAULT '0',
  `price` decimal(5,2) NOT NULL,
  `page_id` int NOT NULL,
  `image` mediumblob,
  `image_path` varchar(100) DEFAULT NULL,
  `order` int NOT NULL DEFAULT '10',
  PRIMARY KEY (`id`),
  KEY `page_containt_idx` (`page_id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

INSERT INTO `plat` (`id`, `description`, `quantity`, `soldout`, `price`, `page_id`, `image`, `image_path`, `order`) VALUES
(1, 'Salade verte', NULL, 0, 7.50, 1, 0x[BLOB], NULL, 10);
INSERT INTO `plat` (`id`, `description`, `quantity`, `soldout`, `price`, `page_id`, `image`, `image_path`, `order`) VALUES
(2, 'Salade du marché', NULL, 0, 12.80, 1, NULL, 'salade_marche.jpg', 20);
INSERT INTO `plat` (`id`, `description`, `quantity`, `soldout`, `price`, `page_id`, `image`, `image_path`, `order`) VALUES
(3, 'Salade printanière au chèvre chaud', NULL, 0, 17.50, 1, 0x[BLOB], NULL, 30);
INSERT INTO `plat` (`id`, `description`, `quantity`, `soldout`, `price`, `page_id`, `image`, `image_path`, `order`) VALUES
(4, 'Feuilleté d\'asperges avec jambon cru', NULL, 0, 22.00, 1, 0x[BLOB]