create table categories(
cid int(4) NOT NULL AUTO_INCREMENT,
cname varchar(250) DEFAULT NULL,
cimg varchar(250) DEFAULT NULL,
cshow   varchar(250) DEFAULT NULL,
corder  int(4) NOT NULL,
PRIMARY KEY (cid)
);

create table yesno(
ynid int(4) NOT NULL AUTO_INCREMENT,
ynname varchar(250) DEFAULT NULL,  
PRIMARY KEY (ynid)
); insert into yesno value (null , 'Yes'),(null,'No');


create table numbers(
nid int(4) NOT NULL AUTO_INCREMENT,
cid int(4) NOT NULL,
jid  int(4) NOT NULL,
nname varchar(250) DEFAULT NULL,
nnumber  int(12) NOT NULL,
nmail varchar(250) DEFAULT NULL,
nshow   varchar(250) DEFAULT NULL,
PRIMARY KEY (nid)
);

create table jobs(
jid int(4) NOT NULL AUTO_INCREMENT,
jname varchar(250) DEFAULT NULL,  
PRIMARY KEY (jid)
); 

