SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"
SET AUTOCOMMIT = 0
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 */
DROP TABLE IF EXISTS `jeux`
CREATE TABLE IF NOT EXISTS `jeux` (`ID` int(11) NOT NULL AUTO_INCREMENT,`TITRE` varchar(50) NOT NULL,`GENRE` varchar(30) NOT NULL,`TYPE_CONSOLE` varchar(30) NOT NULL,PRIMARY KEY (`ID`)) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8
INSERT INTO `jeux` (`ID`, `TITRE`, `GENRE`, `TYPE_CONSOLE`) VALUES(1, 'The Legend of Zelda : Link Awakening', 'Aventure', 'Switch'),(2, 'FIFA 20', 'Sport', 'Switch'),(3, 'New Super Mario Bros. U Deluxe', 'Plateforme', 'Switch'),(4, 'Gears 5', 'Action', 'XBOX'),(5, 'Super Mario Party', 'Ambiance', 'Switch'),(6, 'Burger Time', 'Plateforme', 'Intellivision'),(7, 'Super Mario Odyssey', 'Plateforme', 'Switch'),(8, 'The Witcher 2 : Assassins of Kings', 'Action', 'PS3'),(9, 'Minecraft', 'Construction', 'PS4'),(10, 'Turbo', 'Racing', 'Colecovision'),(11, 'Mario Kart', 'Jeu de course', 'Switch'),(12, 'Just dance 2020', 'Rythme musical', 'Wii'),(13, 'Minecraft', 'Construction', 'Switch'),(14, 'Space Wars', 'Shoot them up', 'Vectrex'),(15, 'Wolfenstein: Youngblood', 'Action', 'Switch'),(16, 'Mario Kart', 'Jeu de course', 'Nintendo 64'),(17, 'Mario Kart', 'Jeu de course', 'Game Cube'),(18, 'Freespace 2', 'Action', 'PC'),(19, 'Easy Piano', 'Ludo-Educatif', 'Nintendo DS')
DROP TABLE IF EXISTS `stock`
CREATE TABLE IF NOT EXISTS `stock` (`ID_STOCK` int(11) NOT NULL AUTO_INCREMENT,`ID_JEU` int(11) NOT NULL,`PRIX_ACHAT` float NOT NULL,`PRIX_VENTE` float NOT NULL,`ETAT_NEUF` tinyint(1) NOT NULL,`DATE_VENTE` timestamp NULL DEFAULT NULL,PRIMARY KEY (`ID_STOCK`)) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8
INSERT INTO `stock` (`ID_STOCK`, `ID_JEU`, `PRIX_ACHAT`, `PRIX_VENTE`, `ETAT_NEUF`, `DATE_VENTE`) VALUES(2, 3, 50, 60, 0, NULL),(3, 3, 28.4, 50, 0, NULL),(4, 3, 50, 60, 0, NULL),(5, 3, 50, 60, 0, NULL),(6, 3, 50, 60, 0, NULL),(7, 3, 50, 60, 0, NULL),(8, 9, 25, 45, 0, NULL),(9, 9, 70, 90, 1, NULL),(10, 4, 35, 50, 0, NULL),(11, 1, 65, 75, 1, NULL),(12, 1, 55, 60, 0, NULL),(13, 2, 34, 45, 0, NULL),(14, 2, 20, 35, 1, NULL),(15, 5, 45, 80, 0, NULL),(16, 6, 55, 70, 1, NULL),(17, 7, 65, 80, 1, NULL),(18, 8, 47, 55, 0, NULL),(19, 8, 45, 57, 1, NULL),(20, 11, 56, 72, 0, NULL),(21, 11, 45, 65, 0, NULL),(22, 12, 35, 65, 0, NULL),(23, 13, 78, 92, 1, NULL),(24, 13, 67, 80, 0, NULL),(25, 10, 80, 95, 1, NULL),(26, 9, 67, 89, 1, NULL),(27, 14, 56, 70, 1, NULL),(28, 14, 45, 55, 0, NULL),(29, 15, 70, 88, 1, NULL),(30, 16, 89, 99, 1, NULL),(31, 16, 91, 105, 1, NULL),(32, 16, 67, 78, 0, NULL),(33, 17, 92, 110, 1, NULL),(34, 17, 78, 89, 0, NULL),(35, 18, 90, 135, 1, NULL),(36, 19, 34, 56, 0, NULL);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 */;