drop table categorii;
drop table subcategorii;
drop table producatori;
drop table servicii;
drop table articole;
drop table utilizatori;


create table categorii(id_categ int unsigned not null auto_increment,index(id_categ),denumire varchar(30));

create table subcategorii(id_subcateg int unsigned not null auto_increment,index(id_subcateg), id_categ int unsigned, denumire varchar(30));

create table producatori(id_prod int unsigned not null auto_increment,index(id_prod),nume varchar(30),link varchar(255));

create table servicii(id_servicii int unsigned not null auto_increment,index(id_servicii),descriere varchar(30), pret double);

create table articole(id_art int unsigned not null auto_increment,index(id_art),idsubcateg int unsigned, id_prod int unsigned, denumire varchar(30), pret double, imagine blob, reducere smallint unsigned, garantie smallint unsigned, promotional tinyint,descriere text);

create table utilizatori(id_user int unsigned not null auto_increment,index(id_user),nume char(30),prenume char(30),email char(50),utilizator char(20),parola char(40),drepturi char(1));


insert into utilizatori values(0,'Maxim','Iacob','iacob_m@stud.usv.ro','maxmaia','6d4d10df4ce00307ea10988d1a91db05',1);