ALTER USER dacosta
IDENTIFIED BY Vejumi27;

CREATE TABLE Buveur(
    NumBuveur Number PRIMARY KEY,
    Nom Varchar2(25) NOT NULL,
    Prenom Varchar2(25) NOT NULL,
    Ville Varchar2(30));

CREATE TABLE Viticulteur(
    NumVitic Number PRIMARY KEY,
    Nom Varchar2(25) NOT NULL,
    Prenom Varchar2(25),
    Ville Varchar2(30) NOT NULL);
    
CREATE TABLE Vin(
    NumVin Number PRIMARY KEY,
    Cru Varchar2(15) NOT NULL,
    Millesime Number NOT NULL,
    Region Varchar2(15) NOT NULL,
    NumVitiv Number NOT NULL REFERENCES Viticulteur);
    
CREATE TABLE Commande(
    NumCom Number PRIMARY KEY,
    NumBuveur Number NOT NULL REFERENCES Buveur,
    NumVin Number NOT NULL REFERENCES Vin,
    Qtte Number NOT NULL,
    DateCom Date NOT NULL);
    
CREATE TABLE Livraison(
    NumCom Number NOT NULL REFERENCES Commande,
    Qtte Number NOT NULL,
    DateLiv Date NOT NULL,
    PRIMARY KEY(NumCom, DateLiv));

INSERT INTO Buveur (SELECT * FROM laleau.buveur);
INSERT INTO Viticulteur (SELECT * FROM laleau.viticulteur);
INSERT INTO Vin (SELECT * FROM laleau.vin);
INSERT INTO Commande (SELECT * FROM laleau.commande);
INSERT INTO Livraison (SELECT * FROM laleau.livraison);

COMMIT;