#------------------------------------------------------------
#        Script MySQL.
#------------------------------------------------------------


#------------------------------------------------------------
# Table: photographie
#------------------------------------------------------------

CREATE TABLE photographie(
        codePhoto       Varchar (50) NOT NULL ,
        lieu            Varchar (50) NOT NULL ,
        datePrise       Datetime NOT NULL ,
        datePublication Datetime NOT NULL ,
        iduser          Varchar (50) NOT NULL ,
        tempsExposition Int ,
        ouvertureFocale Int ,
        flash           Int ,
        idAppareil      Int ,
        PRIMARY KEY (codePhoto )
)ENGINE=InnoDB;


#------------------------------------------------------------
# Table: Utilisateur
#------------------------------------------------------------

CREATE TABLE Utilisateur(
        iduser Varchar (50) NOT NULL ,
        PRIMARY KEY (iduser )
)ENGINE=InnoDB;


#------------------------------------------------------------
# Table: appreilPhoto
#------------------------------------------------------------

CREATE TABLE appreilPhoto(
        marque     Varchar (50) NOT NULL ,
        idAppareil Int NOT NULL ,
        PRIMARY KEY (idAppareil )
)ENGINE=InnoDB;


#------------------------------------------------------------
# Table: Licence
#------------------------------------------------------------

CREATE TABLE Licence(
        nomLicence Varchar (50) NOT NULL ,
        idLicence  Int NOT NULL ,
        PRIMARY KEY (idLicence )
)ENGINE=InnoDB;


#------------------------------------------------------------
# Table: encadrer
#------------------------------------------------------------

CREATE TABLE encadrer(
        idLicence Int NOT NULL ,
        codePhoto Varchar (50) NOT NULL ,
        PRIMARY KEY (idLicence ,codePhoto )
)ENGINE=InnoDB;

ALTER TABLE photographie ADD CONSTRAINT FK_photographie_iduser FOREIGN KEY (iduser) REFERENCES Utilisateur(iduser);
ALTER TABLE photographie ADD CONSTRAINT FK_photographie_idAppareil FOREIGN KEY (idAppareil) REFERENCES appreilPhoto(idAppareil);
ALTER TABLE encadrer ADD CONSTRAINT FK_encadrer_idLicence FOREIGN KEY (idLicence) REFERENCES Licence(idLicence);
ALTER TABLE encadrer ADD CONSTRAINT FK_encadrer_codePhoto FOREIGN KEY (codePhoto) REFERENCES photographie(codePhoto);