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



--
-- Base de données : `tv_menu`
--

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

--
-- Structure de la table `configuration`
--

CREATE TABLE IF NOT EXISTS `configuration` (
  `id` int NOT NULL DEFAULT '1',
  `refresh_time` int NOT NULL DEFAULT '5000' COMMENT 'in ms',
  `money_unity` varchar(5) NOT NULL DEFAULT 'fr.',
  `password` varchar(20) NOT NULL DEFAULT 'Emf12345',
  `menu_font` varchar(50) DEFAULT NULL,
  `menu_size` decimal(3,1) DEFAULT NULL,
  `menu_color` varchar(10) DEFAULT NULL,
  `title_font` varchar(50) DEFAULT NULL,
  `title_size` decimal(3,1) DEFAULT NULL,
  `title_color` varchar(10) DEFAULT NULL,
  `image_dir_path` varchar(100) DEFAULT NULL,
  `logo` mediumblob,
  `logo_path` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

INSERT INTO `configuration` (`id`, `refresh_time`, `money_unity`, `password`, `menu_font`, `menu_size`, `menu_color`, `title_font`, `title_size`, `title_color`, `image_dir_path`, `logo`, `logo_path`) VALUES
(1, 5000, 'fr.', 'Emf12345', NULL, NULL, NULL, NULL, NULL, NULL, '/TVMenu/tip-2026-tvmenu/FrontEnd/assets/images/', NULL, NULL);

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

--
-- 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[encoded data, 53760 characters], 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[encoded data, 256352 characters], 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[encoded data, 210308 characters]