create table pharmacie(id_pha int (11) primary key auto_increment,nom_pha varchar(200),forme_jur_pha varchar(200),coline_pha varchar(200),zone_pha varchar(200),province_pha varchar(200),localisation_pha varchar(200),adress_electr_pha varchar(200),num_RC_pha varchar(200),NIF_pha varchar(200),centre_fiscal_pha varchar(200),nom_prenom_infirm varchar(200), num_tel_pha varchar(200),login_pha varchar(200),psw1_pha varchar(200), psw2_pha varchar(200) );

create table stock(id_stock int(250) primary key auto_increment,date_stock varchar(200),type_stock varchar(200),pharma varchar(200),infirm varchar(200),entite varchar(200),quant_avant varchar (200), quant_achete varchar(200),quant_act varchar(200),quant_vendu varchar(200),quant_restant varchar(200),prix_vent_unit_ varchar(200),prix_vent_total varchar(200),prix_estim varchar(200),prix_tot_general_vendu varchar(200),prix_tota_gener_rest varchar(200) );

 create table historique(id_historique int(250) primary key auto_increment,date_historique varchar(200),type_hist varchar(200),pharma varchar(200),infirm varchar(200),etiquete varchar(200),quant_avant varchar (200), quant_achete varchar(200),quant_act varchar(200),quant_vendu varchar(200),quant_restant varchar(200),prix_vent_unit_ varchar(200),prix_vent_total varchar(200),prix_vent_rest varchar(200),prix_estim varchar(200),prix_tot_general_vendu varchar(200),prix_tota_gener_rest varchar(200),prix_total_gene_est varchar(200),id_session varchar(200),alert varchar(200),date_exp varchar(200),etiquette_commende varchar(200),prix_unit_commend varchar(200),prix_tot_commend varchar(200),prix_tot_general_commend varchar(200) );
 


insert into pharmacie(nom_pha,forme_jur_pha,coline_pha,zone_pha,province_pha,localisation_pha,adress_electr_pha,num_RC_pha,NIF_pha,centre_fiscal_pha,nom_prenom_infirm,num_tel_pha,login_pha,psw1_pha)values(' MUKIZA'," makele"," muzenga"," buhayira","cibitoke","TR7 au Nord","gahungu@gmail.com","rc 733","nif 736382",'cent fisc wawa', "gahungu claude","79009321","gahungu","gahungu123");
insert into pharmacie(nom_pha,forme_jur_pha,coline_pha,zone_pha,province_pha,localisation_pha,adress_electr_pha,num_RC_pha,NIF_pha,centre_fiscal_pha,nom_prenom_infirm,num_tel_pha,login_pha,psw1_pha)values(' pona'," toka"," kagunuzi"," ndava","cibitoke","nyamagana au sud","gakobwa@gmail.com","rc 111","nif 00032",'cent fisc gakobwa', "gakobwa aline","62345678","gakobwa","gakobwa123");






















