FXDXhXF4

1-- Adminer 4.2.5 MySQL dump
2
3SET NAMES utf8;
4SET time_zone = '+00:00';
5SET foreign_key_checks = 0;
6SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
7
8SET NAMES utf8mb4;
9
10DROP DATABASE IF EXISTS `voiture`;
11CREATE DATABASE `voiture` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
12USE `voiture`;
13
14DROP TABLE IF EXISTS `modele`;
15CREATE TABLE `modele` (
16  `id_modele` int(5) NOT NULL,
17  `modele` varchar(20) NOT NULL,
18  PRIMARY KEY (`id_modele`)
19) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
20
21INSERT INTO `modele` (`id_modele`, `modele`) VALUES
22(2,	'bmw')
23ON DUPLICATE KEY UPDATE `id_modele` = VALUES(`id_modele`), `modele` = VALUES(`modele`);
24
25DROP TABLE IF EXISTS `voiture`;
26CREATE TABLE `voiture` (
27  `Immat` int(5) NOT NULL,
28  `id_modele` int(5) NOT NULL,
29  `couleur` varchar(20) NOT NULL,
30  PRIMARY KEY (`Immat`)
31) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
32
33INSERT INTO `voiture` (`Immat`, `id_modele`, `couleur`) VALUES
34(1,	2,	'rouge')
35ON DUPLICATE KEY UPDATE `Immat` = VALUES(`Immat`), `id_modele` = VALUES(`id_modele`), `couleur` = VALUES(`couleur`);
36
37-- 2018-04-20 20:45:27