43 lines
1.2 KiB
SQL
43 lines
1.2 KiB
SQL
|
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;
|