CREATE TABLE users ( 
    idUser BIGINT PRIMARY KEY NOT NULL AUTO_INCREMENT , 
    nom VARCHAR (30) , 
    prenom VARCHAR (30) , 
    email VARCHAR (50) , 
    rue VARCHAR (100) , 
    cp VARCHAR (10) , 
    ville VARCHAR (50) , 
    tel VARCHAR (12) );

CREATE TABLE IF NOT EXISTS modeles ( 
    idModele BIGINT PRIMARY KEY NOT NULL AUTO_INCREMENT , 
    nomModele VARCHAR (20) );

CREATE TABLE IF NOT EXISTS articles ( 
    idArticle BIGINT PRIMARY KEY NOT NULL AUTO_INCREMENT , 
    nom VARCHAR (50) , 
    descriptif VARCHAR (255) , 
    idModele BIGINT , 
    prix DOUBLE , 
    FOREIGN KEY (idModele) REFERENCES modeles(idModele) );

CREATE TABLE IF NOT EXISTS panier ( 
    idPanier BIGINT PRIMARY KEY NOT NULL AUTO_INCREMENT , 
    idUser BIGINT, 
    idArticle BIGINT , 
	idModele BIGINT ,
    quantite INT , 
    total DOUBLE , 
    FOREIGN KEY (idUser) REFERENCES users(idUser) , 
	FOREIGN KEY (idModele) REFERENCES modeles(idModele) ,
    FOREIGN KEY (idArticle) REFERENCES articles(idArticle) )