CREATE TABLE `admin` (
  `admin_id` int(10) NOT NULL,
  `fname` varchar(200) NOT NULL,
  `lname` varchar(200) NOT NULL,
  `uname` varchar(200) NOT NULL,
  `email` varchar(200) NOT NULL,
  `mobile` bigint(200) NOT NULL,
  `password` varchar(200) NOT NULL,
  `profession` varchar(200) NOT NULL,
  `gender` varchar(200) NOT NULL,
  `city` varchar(200) NOT NULL,
  `state` varchar(200) NOT NULL,
  `country` varchar(200) NOT NULL,
  `ipath` varchar(200) NOT NULL,
  `status` varchar(200) NOT NULL,
  `statusFlag` varchar(200) NOT NULL,
  `redFlag` varchar(200) NOT NULL,
  PRIMARY KEY (`admin_id`)	
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Admin Table';

CREATE TABLE `categories` (
  `category_id` int(10) NOT NULL,
  `category_name` varchar(200) UNIQUE NOT NULL,
  `category_image` varchar(200) NOT NULL,
  `status` varchar(200) NOT NULL,
  PRIMARY KEY (`category_id`)	
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Category Table';


CREATE TABLE `brands` (
  `brand_id` int(10) NOT NULL,
  `brand_name` varchar(200) UNIQUE NOT NULL,
  `brand_image` varchar(200) NOT NULL,
  `status` varchar(200) NOT NULL,
  PRIMARY KEY (`brand_id`)	
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Brand Table';

CREATE TABLE `products` (
  `product_id` varchar(10) NOT NULL,
  `product_name` varchar(200) NOT NULL,
  `category_id` varchar(200) NOT NULL ,
  `brand_id` varchar(200) NOT NULL,
  `quantity` int(100) NOT NULL,
  `weight` varchar(100) NOT NULL,
  `weightfig` varchar(100) NOT NULL,
  `mrp` decimal(10,2) NOT NULL,
  `sp` decimal(10,2) NOT NULL,
  `product_image` varchar(200) NOT NULL,
  `status` varchar(200) NOT NULL,
  PRIMARY KEY (`product_id`)	
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Product Table';

CREATE TABLE `freebies` (
  `freebie_id` varchar(10) NOT NULL,
  `freebie_name` varchar(200) NOT NULL,
  `category_id` varchar(200) NOT NULL ,
  `brand_id` varchar(200) NOT NULL,
  `quantity` int(100) NOT NULL,
  `weight` varchar(100) NOT NULL,
  `weightfig` varchar(100) NOT NULL,
  `mrp` decimal(10,2) NOT NULL,
  `sp` decimal(10,2) NOT NULL,
  `freebie_image` varchar(200) NOT NULL,
  `status` varchar(200) NOT NULL,
  PRIMARY KEY (`freebie_id`)	
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Freebies';

CREATE TABLE `offers` (
  `offer_id` varchar(10) NOT NULL,
  `offer_name` varchar(200) NOT NULL,
  `quantity` int(200) NOT NULL,
  `product_id` varchar(200) NOT NULL references products(product_id),
  `freebie_id` varchar(200) NOT NULL references freebies(freebie_id),
  `offer_image` varchar(200) NOT NULL,
  `img_location` varchar(200) NOT NULL,
  `status` varchar(200) NOT NULL,
  PRIMARY KEY (`offer_id`)	
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Offer';



CREATE TABLE `settings` (
  `name` varchar(200) NOT NULL,
  `value` varchar(200) NOT NULL,
  PRIMARY KEY (`name`)	
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Settings';