use location;
DROP TABLE IF EXISTS lignesfic;
DROP TABLE IF EXISTS fiche;
DROP TABLE IF EXISTS article;
DROP TABLE IF EXISTS client;
DROP TABLE IF EXISTS categorie;
CREATE TABLE client
(
   codeclient   int PRIMARY KEY,
   nom          varchar(30),
   prenom       varchar(20),
   codpost      char(5),
   ville        varchar(30)
);

CREATE TABLE categorie
(
   codecat   char(5) PRIMARY KEY,
   prix      float
);

CREATE TABLE fiche
(
   codefiche      int PRIMARY KEY ,
   datecreation   datetime,
   datefin        datetime,
   modereg        char(3),
   codeclient     int,
   CONSTRAINT fk_fiche_codeclient FOREIGN KEY(codeclient)
   REFERENCES client(codeclient)
);

CREATE TABLE article
(
   codeart   int PRIMARY KEY,
   libelle   varchar(25),
   etat      char(3),
   codecat   char(5),
   CONSTRAINT fk_article_codecat FOREIGN KEY(codecat)
   REFERENCES categorie(codecat)
);

CREATE TABLE lignesfic
(
   codefiche   int,
   codeart     int,
   nbjour      int,
   PRIMARY KEY(codefiche, codeart),
   CONSTRAINT fk_lignesfic_codefiche FOREIGN KEY(codefiche)
   REFERENCES fiche(codefiche),
   CONSTRAINT fk_lignesfic_codeart FOREIGN KEY(codeart)
   REFERENCES article(codeart)
);