-- https://www.phpmyadmin.net/
--
-- Hôte : 127.0.0.1:3306
-- Généré le : dim. 12 mars 2023 à 19:45
-- Version du serveur : 8.0.31
-- Version de PHP : 8.0.26

START TRANSACTION;



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

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

--
-- Structure de la table `t_article`
--

CREATE TABLE IF NOT EXISTS `t_article` (
  `PK_Article` int NOT NULL AUTO_INCREMENT,
  `Nom` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
  `Marque` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
  `Prix` double NOT NULL,
  `ImageArticle` blob NOT NULL,
  `FK_CLIENT` int NOT NULL,
  PRIMARY KEY (`PK_Article`),
  KEY `FK_CLIENT` (`FK_CLIENT`)
) ENGINE=MyISAM AUTO_INCREMENT=131 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;

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

INSERT INTO `t_article` (`PK_Article`, `Nom`, `Marque`, `Prix`, `ImageArticle`, `FK_CLIENT`) VALUES
(128, 'Air Force 1', 'Nike', 21, 0x[encoded data, 53624 characters], 137);

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

--
-- Structure de la table `t_clients`
--

CREATE TABLE IF NOT EXISTS `t_clients` (
  `PK_Client` int NOT NULL AUTO_INCREMENT,
  `Pseudo` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
  `Mdp` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
  `Portefeuille` double NOT NULL,
  PRIMARY KEY (`PK_Client`)
) ENGINE=MyISAM AUTO_INCREMENT=140 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;

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

INSERT INTO `t_clients` (`PK_Client`, `Pseudo`, `Mdp`, `Portefeuille`) VALUES
(136, 'Kabashie', '$2y$10$NumWIWcZ.sYwzWkjej2yRejA8GuHT952DOh0xphij7AVZB1D/NmZi', 350),
(137, 'Fejzaje', '$2y$10$ByOz7L5YpggkTbA1bCHWtOqjBDbuxBwzP8mQZ9wiEYitB7GMky6Rq', 2),
(139, 'Leon', '$2y$10$3xicXjQkcs9Ajfzw9uDhvepi6yP0lX/CBzAuAHfiz9Ll1jQjPqlSm', 350);
COMMIT;

