create table menclothes
( 
type varchar(10), price double, model_no varchar(10) primary key, qty int
);
insert into menclothes values('shirt',1200,'pte1',10);
insert into menclothes values('trouser',1400,'pte2',10);
insert into menclothes values('trouser',1400,'pte3',10);
insert into menclothes values('T-shirt',1500,'ucb1',20);
insert into menclothes values('T-shirt',1600,'ucb2',20);
insert into menclothes values('T-shirt',1300,'ucb3',20);
insert into menclothes values('polo-T',600,'usp1',15);
insert into menclothes values('polo-T',900,'usp2',15);
insert into menclothes values('polo-T',1700,'usp3',15);

__________________________________________________________
create table menfoot
( 
type varchar(10), price double, model_no varchar(10) primary key, qty int
);
insert into menfoot values('flipflops',1200,'nik1',10);
insert into menfoot values('flipflops',1400,'nik2',10);
insert into menfoot values('flipflops',1400,'nik3',10);
insert into menfoot values('flipflops',1500,'pum1',20);
insert into menfoot values('flotter',1600,'pum2',20);
insert into menfoot values('flotter',1300,'pum3',20);
insert into menfoot values('shoes',600,'adi1',15);
insert into menfoot values('shoes',900,'adi2',15);
insert into menfoot values('shoes',1700,'adi3',15);

_______________________________________________________________
create table womenclothing
( 
type varchar(10), price double, model_no varchar(10) primary key, qty int
);
insert into womenclothing values('kurta',1200,'bib1',10);
insert into womenclothing values('kurta',1400,'bib2',10);
insert into womenclothing values('kurta',1400,'bib3',10);
insert into womenclothing values('jeans',1500,'mad1',20);
insert into womenclothing values('onepiece',1600,'mad2',20);
insert into womenclothing values('onepiece',1300,'mad3',20);
insert into womenclothing values('onepiece',600,'akr',15);
insert into womenclothing values('skirt-top',900,'akr2',15);
insert into womenclothing values('skirt-top',1700,'akr3',15);

_________________________________________________________________
create table womenfoot
( 
type varchar(10), price double, model_no varchar(10) primary key, qty int
);
insert into womenfoot values('stelletos',1200,'cat1',10);
insert into womenfoot values('stelletos',1400,'cat2',10);
insert into womenfoot values('stelletos',1400,'cat3',10);
insert into womenfoot values('flats',1500,'spa1',20);
insert into womenfoot values('flats',1600,'spa2',20);
insert into womenfoot values('flats',1300,'spa3',20);
insert into womenfoot values('heels',600,'dre1',15);
insert into womenfoot values('heels',900,'dre2',15);
insert into womenfoot values('heels',1700,'dre3',15);

__________________________________________________________________
create table kidsapparel
( 
type varchar(10), price double, model_no varchar(10) primary key, qty int
);
insert into kidsapparel values('top',1200,'fun1',10);
insert into kidsapparel values('jeans',1400,'fun2',10);
insert into kidsapparel values('frock',1500,'lil1',20);
insert into kidsapparel values('frock',1600,'lil2',20);
insert into kidsapparel values('frock',1300,'lil3',20);
insert into kidsapparel values('sandals',600,'gnj1',15);
insert into kidsapparel values('sandals',900,'gnj2',15);
insert into kidsapparel values('sandals',1700,'gnj3',15);


_____________________________________________________________
create table kidstoys
( 
type varchar(10), price double, model_no varchar(10) primary key, qty int
);
insert into kidstoys values('toy',1200,'fun4',10);
insert into kidstoys values('toy',1400,'fun5',10);
insert into kidstoys values('toy',1400,'fun6',10);
insert into kidstoys values('toy',1500,'lil4',20);
insert into kidstoys values('toy',1600,'lil5',20);
insert into kidstoys values('toy',1300,'lil6',20);
insert into kidstoys values('toy',600,'gnj4',15);
insert into kidstoys values('toy',900,'gnj5',15);
insert into kidstoys values('toy',1700,'gnj6',15);

__________________________________________________________________

create table accesories
( 
type varchar(10), price double, model_no varchar(10) primary key, qty int
);
insert into accesories values('wallet',1200,'rad1',10);
insert into accesories values('wallet',1400,'rad2',10);
insert into accesories values('bagpack',1400,'rad3',10);
insert into accesories values('bagpack',1500,'rol1',20);
insert into accesories values('watches',1600,'rol2',20);
insert into accesories values('watches',1300,'rol3',20);
insert into accesories values('cap',600,'tag1',15);
insert into accesories values('cap',900,'tag2',15);
insert into accesories values('face care',1700,'tag3',15);
_______________________________________________________________

create table regusers
( username varchar(20) primary key, pass varchar(10));
insert into regusers values('Nitish','Raizada');
insert into regusers values('Sonal','Gupta');
insert into regusers values('Richa','Richa');
insert into regusers values('Anshika','Gupta');
insert into regusers values('Dipanshu','Awasthi');
insert into regusers values('Vishal','Mittal');
insert into regusers values('Prem','Prakash');
insert into regusers values('Harsh','Misra');
insert into regusers values('Mridul','Mundhra');
insert into regusers values('Aditya','Mehrotra');
_______________________________________________________________

create table userdetails
(
username varchar(50) primary key, address varchar(150), mobile_no varchar(10));
insert into userdetails values('Nitish','Kanpur','9415356975');
insert into userdetails values('Sonal','Allahabad','9335241022');
insert into userdetails values('Richa','Lucknow','7855210366');
insert into userdetails values('Anshika','Jaipur','8852014473');
insert into userdetails values('Dipanshu','Goa','8569320015');
insert into userdetails values('Vishal','Roorkee','7785226482');
insert into userdetails values('Prem','Allahabad','9965012257');
insert into userdetails values('Harsh','Kanpur','7741023658');
insert into userdetails values('Mridul','Jaipur','9987452103');
insert into userdetails values('Aditya','Kanpur','8574102365');

______________________________________________________________
create table  userpaybak(name varchar(20),paybkpt int);
insert into userpaybk values('richa',5);
insert into userpaybk values('sonal',10);
insert into userpaybk values('nitish',7);
insert into userpaybk values('hina',3);
insert into userpaybk values('priya',0);
__________________________________________________________

create table debit(cardno varchar(20),month int,year int,name varchar(20));
insert into debit values('11011011',4,2020,'richa'); 
insert into debit values('22022022',5,2030,'sonal'); 
insert into debit values('33033033',2,2040,'nitish'); 
_______________________________________________________________
create table brandlist
(brand_id varchar(20) primary key, brandname varchar(30));
insert into brandlist values ('UCB','United Colors Of Benetton');
insert into brandlist values ('PTE','Peter England');
insert into brandlist values ('USP','U.S. Polo ASSN.');
insert into brandlist values ('nik','Nike');
insert into brandlist values ('pum','Puma');
insert into brandlist values ('adi','Adidas');
insert into brandlist values ('bib','Biba');
insert into brandlist values ('akr','Akriti');
insert into brandlist values ('mad','Madame');
insert into brandlist values ('cat','CatWalk');
insert into brandlist values ('spa','Sparks');
insert into brandlist values ('dre','DressBerry');
insert into brandlist values ('fun','FunSkool');
insert into brandlist values ('lil','Liliput');
insert into brandlist values ('gnj','GinnieNjonny');
insert into brandlist values ('rad','Rado');
insert into brandlist values ('rol','Rolex');
insert into brandlist values ('tag','Tag Heuer');
________________________________________________________________
create table admin(admin_id varchar(20) primary key,admin_pass varchar(10));
create table usersecurity(username varchar(20) primary key,secur_ques varchar(100),secure_ans varchar(10));