JH0QNpkb

1-- phpMyAdmin SQL Dump
2-- version 4.6.6deb4
3-- https://www.phpmyadmin.net/
4--
5-- Host: localhost:3306
6-- Generation Time: Apr 02, 2019 at 09:34 PM
7-- Server version: 10.1.37-MariaDB-0+deb9u1
8-- PHP Version: 7.0.33-0+deb9u3
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13--
14-- Database: `classicmodels`
15--
16
17-- --------------------------------------------------------
18
19--
20-- Table structure for table `Produit`
21--
22
23DROP TABLE IF EXISTS `Produit`;
24CREATE TABLE `Produit` (
25  `ID_Produit` int(10) UNSIGNED NOT NULL,
26  `Mobile` tinyint(1) NOT NULL,
27  `Telephone` tinyint(1) NOT NULL,
28  `TV` tinyint(1) NOT NULL,
29  `ADSL` tinyint(1) NOT NULL
30) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
31
32--
33-- Indexes for dumped tables
34--
35
36--
37-- Indexes for table `Produit`
38--
39ALTER TABLE `Produit`
40  ADD PRIMARY KEY (`ID_Produit`);
41
42--
43-- AUTO_INCREMENT for dumped tables
44--
45
46--
47-- AUTO_INCREMENT for table `Produit`
48--
49ALTER TABLE `Produit`
50  MODIFY `ID_Produit` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;