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 `user` (
  `user_id` varchar(200) NOT NULL,
  `fname` varchar(200) NOT NULL,
  `lname` varchar(200) NOT NULL,
  `email` varchar(200) NOT NULL UNIQUE,
  `mobile` bigint(200) NOT NULL,
  `password` varchar(200) NOT NULL,
  `gender` varchar(200) NOT NULL,
  `city` varchar(200) NOT NULL,
  `status` varchar(200) NOT NULL,
  `createdon` datetime NOT NULL,
  `loginon` datetime NOT NULL,
  PRIMARY KEY (`user_id`)	
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='User 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';




CREATE TABLE `cart` (
  `cart_id` varchar(10) NOT NULL,
  `user_id` varchar(10) NOT NULL,
  `product_id` varchar(10) NOT NULL,
  `quantity` int(100) NOT NULL,
  `createdon` datetime NOT NULL,
  `updatedon` datetime NOT NULL,
  `status` varchar(200) NOT NULL,
  PRIMARY KEY (`cart_id`,`user_id`,`product_id`)	
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Cart Table';



CREATE TABLE `wishlist` (
  `user_id` varchar(10) NOT NULL,
  `product_id` varchar(10) NOT NULL,
  `createdon` datetime NOT NULL,
  `updatedon` datetime NOT NULL,
  `status` varchar(200) NOT NULL,
  PRIMARY KEY (`user_id`,`product_id`)	
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Wishlist Table';



CREATE TABLE `orders` (
  `order_id` varchar(20) NOT NULL,
  `cart_id` varchar(20) NOT NULL,
  `payment_id` varchar(200) NOT NULL,
  `user_id` varchar(200) NOT NULL,
  `payment` decimal(20,2) NOT NULL,
  `coupon` varchar(200) NOT NULL,
  `discount` decimal(10,2) NOT NULL,
  `createdon` datetime NOT NULL,
  `updatedon` datetime NOT NULL,
  `shippingdate` datetime NOT NULL,
  `deliverydate` datetime NOT NULL,
  `status` varchar(200) NOT NULL,
  PRIMARY KEY (`order_id`)	
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Order Table';



CREATE TABLE `payments` (
  `payment_id` varchar(200) NOT NULL,
  `user_id` varchar(200) NOT NULL,
  `payment_type` varchar(200) NOT NULL,
  `payment_status` varchar(200) NOT NULL,
  `payment` decimal(10,2) NOT NULL,
  `status` varchar(200) NOT NULL,
  `createdon` datetime NOT NULL,
  PRIMARY KEY (`payment_id`)	
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Payment Table';


CREATE TABLE `coupon` (
  `coupon_id` varchar(10) NOT NULL,
  `code` varchar(10) NOT NULL,
  `max_limit` int(200) NOT NULL,
  `discount` int(200) NOT NULL,
  `createdon` datetime NOT NULL,
  `updatedon` datetime NOT NULL,
  `expireon` datetime NOT NULL,
  `status` varchar(200) NOT NULL,
  PRIMARY KEY (`coupon_id`)	
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Coupon Table';


----------------------------------------------------------------


CREATE TABLE `category_carasoul` (
  `id` varchar(200) NOT NULL,
  `category_id` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)	
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Category Carasoul';

INSERT INTO `category_carasoul` (`id`, `category_id`) VALUES
('1', '6475210'),
('2', '5840164'),
('3', '2621570'),
('4', '7249783'),
('5', '5');


CREATE TABLE `today_offers` (
  `tid` varchar(200) NOT NULL,
  `product_id` varchar(200) NOT NULL,
  PRIMARY KEY (`tid`)	
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Today Offers';

INSERT INTO `today_offers` (`tid`, `product_id`) VALUES
('1', 'V1790023'),
('2', 'V7681500'),
('3', 'V2902172'),
('4', 'V2063126'),
('5', 'V5403929'),
('6', 'V8676189'),
('7', 'V4941385'),
('8', 'V3400628'),
('9', 'V5252288'),
('10', 'V8960807'),
('11', 'V7036897'),
('12', 'V7264466');



CREATE TABLE `category_banners` (
  `bid` varchar(200) NOT NULL,
  `category_id` varchar(200) NOT NULL,
  `cat_banner` varchar(200) NOT NULL,
  PRIMARY KEY (`bid`)	
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Category Banner';

INSERT INTO `category_banners` (`bid`, `category_id`, `cat_banner`) VALUES
('1', '7051872', '1611324798108705711600add7ecc078snacks.jpg'),
('2', '1417804', '16113297151928920645600af0b3900b4beverages.jpg'),
('3', '3299142', '16113307691732630076600af4d1040aapersonal care.jpg'),
('4', '9065732', '16113320721804450480600af9e8b8b75body care.jpg'),
('5', '6852479', '16113330781578647631600afdd69c8c8househod.jpg'),
('6', '4336578', '16113330991366698957600afdeb6574adeteregents.jpg'),
('7', '8907793', '1611334215153965941600b024728a04kitchen.jpg'),
('8', '7225730', '16113342351548820266600b025bedd14stationary.jpg'),
('9', '8006125', '1611334251204567585600b026b43e10safety.jpg');


CREATE TABLE `landing_banners` (
  `id` varchar(200) NOT NULL,
  `banner` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)	
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Landing Banners';

INSERT INTO `landing_banners` (`id`, `banner`) VALUES
('1', '16113359171890621051600b08ed62cb11.jpg'),
('2', '16113411901769576092600b1d86c5c1d2.jpg'),
('3', '1611341629345931555600b1f3d679103.jpg'),
('4', '16112606867067570396009e30e7453c160900407711424334105fe7742d58607NUTRITION DRINKS.jpg'),
('5', '161126072817354681746009e3389a6aa16090042732120012265fe774f18b431TIOLET SOAPS.jpg'),
('6', '161126073619088811726009e340be707160900507810024212325fe7781695a9fBETEL NUT POWDER.jpg'),
('7', '16112607582745825106009e3564e1aa160900347712686102085fe771d562573CLOTH REFRESHERS.jpg');

CREATE TABLE `slider_banners` (
  `id` varchar(200) NOT NULL,
  `top_text` varchar(200) NOT NULL,
  `header` varchar(200) NOT NULL,
  `text` LONGTEXT NOT NULL,
  `slider` varchar(200) NOT NULL,
  `status` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)	
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Landing Slider Banners';

INSERT INTO `slider_banners` (`id`, `top_text`, `header`, `text`, `slider`, `status`) VALUES
('1', '2020', 'Men Fashion', 'dummy 2', '161126341518683628956009edb70cd9d02.jpg', 'Enabled'),
('2', '2019', 'Women Trends', 'dummy text dummy text ', '161126342014298065986009edbc6f06801.jpg', 'Enabled'),
('3', '2021', 'kids Special', 'dummy 3', '161126344219550196866009edd254fd202.jpg', 'Enabled');


