CREATE TABLE Client
(
id_cl INT  primary key,
nom VARCHAR(100) not null,
prenom VARCHAR(100) not null,
adfresse VARCHAR(255)not null,
ville VARCHAR(100) not null
) on FileGroup1;

CREATE TABLE Produit
(
id_pr INT primary key,
libelle VARCHAR(100) not null,
pu INT not null
) on FileGroup1;


CREATE TABLE Commande
(
id_cmd INT,
id_cl INT,
date Date not null,
PRIMARY KEY (id_cmd, id_cl)
) on FileGroup2;


CREATE TABLE LigneCommande
(
id_cmd INT,
id_prd INT,
qte INT not null,
PRIMARY KEY (id_cmd, id_prd)
) on FileGroup3;


SELECT * FROM sys.filegroups;



CREATE INDEX index_Client
ON Client (id_cl,nom ,prenom,adfresse,ville ) ;

CREATE INDEX index_Produit
ON Produit(id_pr ,libelle, pu);

CREATE INDEX index_Commande
ON Commande (id_cmd, id_cl, date) ;

CREATE INDEX index_LigneCommande
ON LigneCommande(id_cmd ,id_prd, qte)  ;






GRANT SELECT, INSERT, UPDATE
ON  Commande
TO user1;


GRANT ALL
ON  Commande
TO user2;


GRANT SELECT
ON  Commande
TO user3;





BACKUP DATABASE VENTES
TO DISK = 'C:\Sauv_Gestion\VENTES.bak';



BACKUP DATABASE VENTES
TO DISK = 'C:\Sauv_Gestion\VENTES.bak' WITH DIFFERENTIAL;