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) )