-- phpMyAdmin SQL Dump
-- version 4.9.5
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Aug 01, 2020 at 01:18 PM
-- Server version: 5.7.31
-- PHP Version: 7.3.6

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `kamleshy_home_delivery_app`
--

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

--
-- Table structure for table `app_suggetions`
--

CREATE TABLE `app_suggetions` (
  `sugId` int(11) NOT NULL,
  `userId` int(11) NOT NULL,
  `suggetions` varchar(2000) NOT NULL,
  `creatDate` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `app_suggetions`
--

INSERT INTO `app_suggetions` (`sugId`, `userId`, `suggetions`, `creatDate`) VALUES
(2, 10, '[\"App Product catalog\",\" Multiple Payment\",\" Options Homepage with multiple banners\",\" Pickup/Delivery\",\" Options Social sharing buttons\",\" Integrated Shopping cart\"]', '2020-04-21 15:46:51');

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

--
-- Table structure for table `app_version`
--

CREATE TABLE `app_version` (
  `id` int(11) NOT NULL,
  `version` varchar(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `app_version`
--

INSERT INTO `app_version` (`id`, `version`) VALUES
(1, '1');

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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `catId` int(11) NOT NULL,
  `catName` varchar(50) NOT NULL,
  `catImage` varchar(500) NOT NULL,
  `catStatus` int(10) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`catId`, `catName`, `catImage`, `catStatus`) VALUES
(1, 'Personalcare', '985fddeed5.jpg', 1),
(29, 'Skin Care', 'ec777224ea.jpg', 1),
(3, 'Biscuits Cookies', '0607051808.jpg', 1),
(4, 'Packed Food', '247dd7c6b3.jpg', 1),
(5, 'Home & Kitchen', 'c6015df9e5.jpg', 1),
(35, 'school supplies', '790f30e827.jpg', 1),
(34, 'Monsoon essentials1', '1a709352b9.jpg', 1),
(33, 'Healty and safe', '5326a3fbf0.jpg', 1),
(32, 'Monthly essentials', '65e718367a.jpg', 1),
(31, 'Hair care', '5b7723da65.jpg', 1),
(42, 'festival delight', '7b86d4ba8c.jpg', 1);

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

--
-- Table structure for table `item_unit`
--

CREATE TABLE `item_unit` (
  `unitId` int(11) NOT NULL,
  `unitName` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `item_unit`
--

INSERT INTO `item_unit` (`unitId`, `unitName`) VALUES
(1, 'Kg'),
(2, 'Ltr'),
(3, 'ml'),
(4, 'grams');

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

--
-- Table structure for table `language`
--

CREATE TABLE `language` (
  `language_id` int(11) NOT NULL,
  `language_key` text NOT NULL,
  `language_title` text NOT NULL,
  `language_type` text NOT NULL,
  `language_english` text,
  `language_hindi` text,
  `language_french` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `language`
--

INSERT INTO `language` (`language_id`, `language_key`, `language_title`, `language_type`, `language_english`, `language_hindi`, `language_french`) VALUES
(1, 'login_success', 'login success', 'message', 'login successful', 'jhjhjhjhyuyuyuyu', '  this thing is not working and  if it is working the it is not good to sell out and if it is good to sell out then it is not in the '),
(2, 'login_failure', 'login failed', 'message', 'Incorrect Login details.', 'dfdfdf', NULL),
(3, 'account_disabled', 'account has been disabled', 'message', 'Your account has been disabled please contact to admin-9632587410', 'rytyth trerr 4eteryrytryt', NULL),
(4, 'register_emailexists', 'email already exists ', 'message', 'This email address already registered.', NULL, NULL),
(5, 'register_mobileexists', 'mobile already exists ', 'message', 'This mobile number already registered.', NULL, NULL),
(6, 'register_mobilefiled', 'mobile filed is required', 'message', 'Please enter mobile number.', NULL, NULL),
(7, 'ragiter_success', 'registration success', 'message', 'Your request has been processing and OTP send to your enter mobile number', NULL, NULL),
(8, 'ragister_failed', 'registration failed', 'message', 'something went wrong please try again', NULL, NULL),
(9, 'verify_fequired', 'verify code is required', 'message', 'verify code filed is required', NULL, NULL),
(10, 'verify_failed', 'verify failed', 'message', 'This otp code is wrong.', NULL, NULL),
(11, 'verify_success', 'verify success', 'message', 'Your mobile number verified successfully you can login', NULL, NULL),
(12, 'category_failed', 'categories null', 'message', 'not found', NULL, NULL),
(13, 'userid_required', 'user id filed is required ', 'message', 'Please enter user id.', NULL, NULL),
(14, 'update_success', 'update success', 'message', 'User update Successfully.', NULL, NULL),
(15, 'update_failed', 'update failed', 'message', 'something went wrong please try again', NULL, NULL),
(16, 'item_unit', 'itme unit', 'message', 'not found', NULL, NULL),
(17, 'item_failed', 'items', 'message', 'not found', NULL, NULL),
(18, 'order_success', 'order receive', 'message', 'Thank you ! We have received your order', NULL, NULL),
(19, 'order_failed', 'order failed', 'message', 'Something went wrong please try again', NULL, NULL),
(20, 'wholesalerid_required', 'wholesaler id filed required', 'message', 'Select wholesaler id empty', NULL, NULL),
(21, 'outof_stock', 'out of stock', 'message', 'your items stock empty.', NULL, NULL),
(22, 'order_update', 'order_update', 'message', 'Successfully updated', NULL, NULL),
(23, 'version_error', 'version error', 'message', 'App version not', NULL, NULL),
(24, 'order_list', 'order list', 'message', 'not found', NULL, NULL),
(25, 'forgote_password', 'forgot password', 'message', 'OTP has been sent to your mobile number.', NULL, NULL),
(26, 'order_delivered', 'order delivered', 'message', 'Oder delivery successful..', NULL, NULL),
(27, 'order_cancelled', 'Order cancelled ', 'message', 'Order cancelled.', NULL, NULL),
(28, 'category_exists', 'Category name', 'message', 'Category name already exists.', NULL, NULL),
(29, 'item_update', 'item update', 'message', 'Item update successful.', NULL, NULL),
(30, 'add_item', 'add item', 'message', 'Item add successful.', NULL, NULL),
(31, 'notice_orderucancel', 'Order cancelled by customer', 'message', 'Order cancelled by customer.', NULL, NULL),
(32, 'notice_neworder', 'new order', 'message', 'New order by customer.', NULL, NULL),
(33, 'notice_ordercancel', 'order cancelled by wholesaler', 'message', 'Your order has been cancelled by store manager.', NULL, NULL),
(34, 'notice_orderdelivered', 'order delivered', 'message', 'your order delivered', NULL, NULL),
(35, 'notice_error', 'notice error', 'message', 'not found', NULL, NULL),
(36, 'refund_amountall', 'refund amount already', 'message', 'Your request for refund amount already received.', NULL, NULL),
(37, 'refund_dateexpired', 'refund order date expired', 'message', 'Order date expired !! Amount can\'t be refunded', NULL, NULL),
(38, 'refund_delivered', 'refund delivered order', 'messase', 'Your order has been delivered but payment is non-refundable', NULL, NULL),
(39, 'refund_ordernumber', 'refund order number', 'message', 'your order number is not valid', NULL, NULL),
(40, 'refund_success', 'refund success', 'message', 'Payment refund add successful', NULL, NULL),
(41, 'login_title', 'login title', 'login page', 'login to continuecc', NULL, NULL),
(42, 'mobile_placeholder', 'mobile placeholder ', 'login page', 'your mobile number', NULL, NULL),
(43, 'password_placeholder', 'password placeholder', 'login page', 'your password ', NULL, NULL),
(44, 'forgot_password', 'forgot password', 'login page', 'forgot password', NULL, NULL),
(45, 'login_button', 'login button', 'login page', 'login', NULL, NULL),
(46, 'create_account', 'create new account', 'login page', 'want to create an account? click here', NULL, NULL),
(47, 'forgot_title', 'forgot title', 'forgot page', 'enter mobile number below to change your password', NULL, NULL),
(48, 'forgot_button', 'forgot button', 'forgot page', 'continue', NULL, NULL),
(49, 'forgotnew_password', 'new password placeholder', 'forgot page', 'new password', NULL, NULL),
(50, 'otp_title', 'otp title', 'forgot page', 'enter otp here that has been sent to your mobile number', NULL, NULL),
(51, 'confirm_button', 'confirm button', 'forgot page', 'confirm', NULL, NULL),
(52, 'email_placeholder', 'email placeholder', 'signup page', 'your email', NULL, NULL),
(53, 'name_placeholder', 'name placeholder', 'signup page', 'your full name', NULL, NULL),
(54, 'house_placeholder', 'house number placeholder', 'signup page', 'house number', NULL, NULL),
(55, 'ward_placeholder', 'ward number placeholder', 'signup page', 'ward number', NULL, NULL),
(56, 'town_placeholder', 'town placeholder', 'signup page', 'town/area', NULL, NULL),
(57, 'signup_button', 'signup button', 'signup page', 'register', NULL, NULL),
(58, 'back_login', 'already account', 'sigup page', 'aleady have an account? lon in', NULL, NULL),
(59, 'notificationMenu', 'notification', 'menu', 'notifications', NULL, NULL),
(60, 'itemMenu', 'items', 'menu', 'all items', NULL, NULL),
(61, 'addItemMenu', 'add item', 'menu', 'add item', NULL, NULL),
(62, 'profileMenu', 'profile', 'menu', 'profile', NULL, NULL),
(63, 'newOrdersMenu', 'new orders', 'menu', 'new orders', NULL, NULL),
(64, 'deliveredOrdersMenu', 'delivered orders', 'menu', 'delivered orders', NULL, NULL),
(65, 'cancelledOrdersMenu', 'cancelled orders', 'mene', 'cancelled orders', NULL, NULL),
(66, 'logoutMenu', 'logout', 'menu', 'logout', NULL, NULL),
(67, 'homeMenu', 'home', 'menu', 'home', NULL, NULL),
(68, 'orderHistoryMenu', 'order history', 'menu', 'order history', NULL, NULL),
(69, 'settingMenu', 'settings', 'menu', 'settings', NULL, NULL),
(70, 'itemNameItem', 'name', 'item page', 'item name', NULL, NULL),
(71, 'itemCatItem', 'category', 'item page', 'item category', NULL, NULL),
(72, 'itemWeight', 'weight', 'item page', 'item page', NULL, NULL),
(73, 'weightPlaceholder', 'weight placeholder', 'item page', 'enter weight(5,500,1000 etc.)', NULL, NULL),
(74, 'stockItem', 'stock quantity', 'item page', 'item stock quantity', NULL, NULL),
(75, 'offerRateItem', 'offer rate', 'item page', 'MRP rate', NULL, NULL),
(76, 'itemRate', 'item rate', 'item page', 'item rate', NULL, NULL),
(77, 'itemImage', 'image', 'item page', 'item image', NULL, NULL),
(78, 'selectImage', 'select image', 'item page', 'select image', NULL, NULL),
(79, 'addItemButton', 'add button', 'item page', 'add item', NULL, NULL),
(80, 'updateButtonItem', 'update button', 'item page', 'update item', NULL, NULL),
(81, 'updateItem', 'update', 'item page', 'update', NULL, NULL),
(82, 'wholesalerNameProfile', 'wholesaler name', 'profile page', 'store or vendor name', NULL, NULL),
(83, 'nameProfile', 'name', 'profile page', 'name', NULL, NULL),
(84, 'emailProfile', 'email', 'profile page', 'email address', NULL, NULL),
(85, 'mobileProfile', 'mobile', 'profile page', 'mobile number', NULL, NULL),
(86, 'passwordProfile', 'password', 'profile page', 'password', NULL, NULL),
(87, 'passwordPlaceholder', 'password placeholder', 'profile page', 'reset password', NULL, NULL),
(88, 'addressProfile', 'address', 'profile page', 'address', NULL, NULL),
(89, 'wardNumberProfile', 'ward number', 'profile page', 'ward number', NULL, NULL),
(90, 'wardPlaceholder', 'ward placeholder', 'profile page', 'ward number', NULL, NULL),
(91, 'houseNumber', 'house number', 'profile page', 'house number', NULL, NULL),
(92, 'housePlaceholder', 'house no. placeholder', 'profile page', 'house number', NULL, NULL),
(93, 'townprofile', 'town', 'profile page', 'town/area', NULL, NULL),
(94, 'townPlaceholder', 'town placeholder', 'profile page', 'town', NULL, NULL),
(95, 'districtProfile', 'district', 'profile page', 'district', NULL, NULL),
(96, 'districtPlaceholder', 'district Placeholder', 'profile page', 'district', NULL, NULL),
(97, 'updateButton', 'update button', 'profile page', 'update', NULL, NULL),
(98, 'searchStorePlaceholder', 'search store Placeholder', 'other', 'search store', 'yu7yuyuy', NULL),
(99, 'selectStore', 'select store', 'other', 'select store', NULL, NULL),
(100, 'searchCatItems', 'search item', 'other', 'aapko kya chahiye? sugar, oil, daal etc..', NULL, NULL),
(101, 'happyShopping', 'happy shopping', 'other', 'happy shopping', NULL, 'ssdf'),
(102, 'totalButton', 'total item', 'other', 'total item', NULL, NULL),
(103, 'orderNowButton', 'order now', 'other', 'order now', NULL, NULL),
(104, 'orderConfirmButton', 'confirm order', 'other', 'confirm', NULL, NULL),
(105, 'cancelOrder', 'cancel order', 'other', 'cancel order', NULL, NULL),
(106, 'grandTotal', 'grand total', 'other', 'grand total amount -', NULL, NULL),
(107, 'change address', 'change address', 'other', 'change address', NULL, NULL),
(108, 'addButton', 'add button', 'message', 'Add successful', NULL, NULL),
(109, 'mobileNotRegistered', 'mobile number not registered', 'message', 'your mobile number not registered', NULL, NULL),
(110, 'fieldRequired', 'field required', 'message', 'Parameter field required.', NULL, NULL);

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

--
-- Table structure for table `logo_settings`
--

CREATE TABLE `logo_settings` (
  `logoId` int(11) NOT NULL,
  `logoTitle` varchar(100) NOT NULL,
  `logoImage` varchar(100) NOT NULL,
  `themeColor` varchar(200) NOT NULL,
  `loginBoxImg` varchar(200) NOT NULL,
  `loginBoxColor` varchar(200) NOT NULL,
  `loginImg` varchar(200) NOT NULL,
  `headerLogo` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `logo_settings`
--

INSERT INTO `logo_settings` (`logoId`, `logoTitle`, `logoImage`, `themeColor`, `loginBoxImg`, `loginBoxColor`, `loginImg`, `headerLogo`) VALUES
(1, 'Home Delivery', '6a1b1f045f.jpg', '#FD4313', 'welcom_img.png', '#FD4313', '641554f49f.jpg', 'bec0187ebb.svg');

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

--
-- Table structure for table `refund_notification`
--

CREATE TABLE `refund_notification` (
  `refundId` int(11) NOT NULL,
  `userId` int(11) NOT NULL,
  `vendorId` int(11) NOT NULL,
  `orderId` int(11) NOT NULL,
  `refundPaymentId` varchar(100) NOT NULL,
  `holderName` varchar(100) NOT NULL,
  `accountNumber` varchar(20) NOT NULL,
  `ifscCode` varchar(20) NOT NULL,
  `notificationDate` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `refundStatus` int(11) NOT NULL,
  `withdrawalStatus` int(11) NOT NULL,
  `userMobile` varchar(20) NOT NULL,
  `comments` varchar(500) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `rt_settings`
--

CREATE TABLE `rt_settings` (
  `uniq_id` int(11) NOT NULL,
  `title` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `key_text` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `value_text` text CHARACTER SET utf8 NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `rt_settings`
--

INSERT INTO `rt_settings` (`uniq_id`, `title`, `key_text`, `value_text`) VALUES
(1, 'Portal Currency (OPT : USD OR INR)', 'portal_curreny', 'INR'),
(2, 'Currency Symbol (OPT : $ or ₹ )', 'portalcurreny_symbol', '₹'),
(3, 'PayuMoney Status (OPT : 1 = Active, 0 = Inactive )', 'payu_status', '1'),
(4, 'Payumoney Merchant Key', 'payu_merchantKey', 'sCFyuxhl'),
(5, 'Payumoney Merchant Salt', 'payu_merchantSalt', 'l1hMFGsCMl'),
(6, 'Wallet Status (OPT : 1 = Active or 0 = Inactive  )', 'wallet_status', '1'),
(18, 'Booking Mail Subject', 'bookingemail_subject', 'Booking Detail'),
(19, 'Booking Order Text ( [username] : Name of User , [order_date] : Date of Order , [order_number : Order Number , [break] : Use For Break lines ] )', 'bookorder_text', '<strong>Thanks for your order</strong>\r\n<h4>Hello [username],</h4><p>We\'re processing your order . Thanks for shopping with us.</p><div class=\"login_info\"><p><strong>Date :</strong> [order_date] </p><p><strong>Order Number :</strong> [order_number]</p></div>'),
(20, 'In Transit Order Text ( [username] : Name of User , [order_date] : Date of Order , [order_number : Order Number , [break] : Use For Break lines ] )', 'intransits_text', 'Hi,[username],[break]\r\nYour order [order_number] is succefully prepared and  in transits and will be available to you shortly. [break]'),
(21, 'Booking Cancel Text ( [username] : Name of User , [order_date] : Date of Order , [order_number : Order Number , [break] : Use For Break lines ] )', 'canceled_text', '<h4>Hello [username],</h4><p>Your order [order_number] is canceled. Sorry for inconvenience.</p>'),
(22, 'Booking Delivered Text ( [username] : Name of User , [order_date] : Date of Order , [order_number : Order Number , [break] : Use For Break lines ] )', 'delivered_text', '<h4>Hello [username],</h4><p>Your order [order_number] is Delivered.</p>'),
(10, 'Name in Email Send', 'email_fromname', 'Home Delivery'),
(11, 'Email in Email Send ', 'email_fromemail', 'ravi.mali@himanshusofttech.com'),
(12, 'Email for Contact', 'email_contactemail', ''),
(13, 'Message Status : (1 = Active , 0 = Inactive )', 'msg91_status', '1'),
(14, 'MSG91 Key', 'msg91_key', '330935AZoL0Tgff15ed4edd6P1'),
(15, 'Message Send Name', 'msg91_sender', 'MSGIND'),
(16, 'Admin Mobile Number', 'admin_mobile', ''),
(17, 'Add User Email Text ', 'addnewuseremail_text', '<h4>Hello [username],</h4><p>Congratulations!! We have created your account on our portal.</p><p>Here is your login details</p><div class=\"login_info\"><p><strong>Email :</strong> [useremail] </p><p><strong>Password :</strong> [password]</p></div>\r\n<p><span>[loginword]</span><span>[loginlink]</span></p>'),
(7, 'COD Status ( OPT : 1 = Active , 2  : Inactive )', 'cod_status', '1'),
(8, 'Paypal Status (OPT :  1 = Active , 0 : Inactve ) ', 'paypal_status', '1'),
(9, 'Paypal Business Email', 'paypal_business_mail', 'syinfotech333-facilitator1@gmail.com'),
(25, 'Booking Order Text For Admin ( [username] : Name of User , [order_date] : Date of Order , [order_number : Order Number , [break] : Use For Break lines ] )', 'abookorder_text', '<h4>Hello Admin,</h4><p>[username] has booked a order.</p><div class=\"login_info\"><p><strong>Date :</strong> [order_date] </p><p><strong>Order Number :</strong> [order_number] </p></div>'),
(26, 'Cancel Order Text For Admin ( [username] : Name of User , [order_date] : Date of Order , [order_number : Order Number , [break] : Use For Break lines ] )', 'acanceled_text', '<h4>Hello Admin,</h4><p>Order [order_number] is canceled. Sorry for inconvenience.</p>'),
(27, 'In Transit Order Text For Admin( [username] : Name of User , [order_date] : Date of Order , [order_number : Order Number , [break] : Use For Break lines ] )', 'aintransits_text', '<h4>Hello,</h4><p>order [order_number] is succefully prepared and in transits and will be available to customer shortly.</p>'),
(28, 'Booking Delivered Text for Admin ( [username] => For user name , [order_date] => For order date , [order_number => for Order Number , [break] => For break the text] )', 'adelivered_text', '<h4>Hello Admin ,</h4><p>Order [order_number] is Delivered.</p>'),
(29, 'Rating Text ( [username] => For user name ,  [order_number => for Order Number , [break] => For break the text] )', 'prating_text', '<h4>Hello [username] ,</h4><p>Your order [order_number] is Delivered.</p><p>[s1]</p><p>[s2]</p><p>[s3]</p><p>[s4]</p><p>[s5]</p>'),
(33, 'Fire-base Notification Key', 'fire_base', 'AIzaSyC-agL_zcESpkwWrqSP1huKveB813vJBbc'),
(30, 'email verification', 'emailveri_text', '[linktext],[break]Thanks,[break]'),
(31, 'Forgot Password', 'forgotps_text', '<b>Hi,</b>[break]\r\nYour OTP is <b>[linktext]</b> ,[break]\r\nPlease use this Otp to reset your password ,[break]'),
(32, 'Copyright', 'copyright_text', 'Copyright © 2020 Home Delivery . All Right Reserved.'),
(34, 'Forgot Password', 'forgotps_subject', 'forgot password'),
(35, 'email validation', 'emailveri_subject', 'E-Mail Verification'),
(36, 'order message', 'order_subject', 'Home Delivery Order'),
(37, 'Order canceled', 'canceled_subject', 'Order canceled'),
(38, 'order booked', 'bookorder_subject', 'Order Booked'),
(39, 'intransits subject', 'intransits_subject', 'inTransist'),
(40, 'Order Delivered', 'delivered_subject', 'Order delivered'),
(41, 'Currency Convert Api Key', 'currency_api', '692f11c4d93d89416722'),
(42, 'Add New User Subject', 'addnewuseremail_subject', 'New Account Created'),
(43, 'customer order cancel', 'acanceled_subject', 'Customer order cancel'),
(44, 'Admin payment refund', 'arefundpay_text', '<h4>Hello [username],</h4><p>Your order [order_number] payment has been refunded.</p>'),
(45, 'Payment Refunded', 'arefundpay_subject', 'Payment Refunded'),
(46, 'Payment Refund Request', 'crefundreq_subject', 'Payment Refund Request'),
(47, 'customer payment refund request', 'crefundreq_text', '<h4>Hello Admin ,</h4><p>Order [order_number] is payment refund request.</p>'),
(48, 'web logo title', 'logo_title', 'Home Delivery'),
(49, 'web & App logo icon', 'logo_image', '8230ad2860.png'),
(50, 'theme color setting', 'theme_color', '#00d4bb'),
(51, 'web login box images', 'login_box_img', '4e14dd3b99.png'),
(52, 'login box bg color setting', 'login_box_color', '#dbeef1'),
(53, 'login bg images setting', 'login_img', '641554f49f.jpg'),
(54, 'theme header logo setting', 'header_logo', 'bec0187ebb.svg'),
(55, 'web and api msg change select option language', 'weblanguage_text', 'english'),
(56, 'languageoption name', 'languageoption_text', 'english,hindi,french'),
(57, 'languagesection title data tabel', 'languagesection_text', 'message,login page,forgot page,signup page,menu,item page,profile page,other');

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

--
-- Table structure for table `sub_categories`
--

CREATE TABLE `sub_categories` (
  `subCatId` int(11) NOT NULL,
  `partyId` int(11) NOT NULL,
  `subCatName` varchar(50) NOT NULL,
  `mainCatId` int(11) NOT NULL,
  `rate` varchar(20) NOT NULL,
  `itemMrp` varchar(11) NOT NULL,
  `stockQnt` int(20) NOT NULL,
  `itemStockWeight` int(11) NOT NULL,
  `qntUnit` varchar(20) NOT NULL,
  `image` varchar(50) NOT NULL,
  `itemStatus` int(4) NOT NULL DEFAULT '1',
  `itemDate` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `userId` int(11) NOT NULL,
  `userName` varchar(50) NOT NULL,
  `userEmail` varchar(50) NOT NULL,
  `userMobile` varchar(20) NOT NULL,
  `userPassword` varchar(250) NOT NULL,
  `address` varchar(500) NOT NULL,
  `userImage` varchar(100) NOT NULL,
  `aadharNumber` varchar(20) NOT NULL,
  `panNumber` varchar(20) NOT NULL,
  `GSTNumber` varchar(20) NOT NULL,
  `aadharImage` varchar(100) NOT NULL,
  `panImage` varchar(100) NOT NULL,
  `shopImage` varchar(100) NOT NULL,
  `latitude` varchar(50) NOT NULL,
  `longitude` varchar(50) NOT NULL,
  `userType` tinyint(4) NOT NULL DEFAULT '0' COMMENT '1(admin) , 2(Customer), 3(Wholesaler)',
  `status` tinyint(4) NOT NULL DEFAULT '0',
  `verifyCode` varchar(50) NOT NULL,
  `tokenId` varchar(500) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`userId`, `userName`, `userEmail`, `userMobile`, `userPassword`, `address`, `userImage`, `aadharNumber`, `panNumber`, `GSTNumber`, `aadharImage`, `panImage`, `shopImage`, `latitude`, `longitude`, `userType`, `status`, `verifyCode`, `tokenId`) VALUES
(1, 'admin', 'admin@gmail.com', '8319133069', 'e10adc3949ba59abbe56e057f20f883e', '', '', '', '', '', '', '', '', '', '', 1, 1, '', '');

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

--
-- Table structure for table `wholesales_item`
--

CREATE TABLE `wholesales_item` (
  `id` int(11) NOT NULL,
  `salesInvoiceId` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `itemId` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `quantity` int(10) NOT NULL,
  `rate` varchar(250) COLLATE utf8_unicode_ci NOT NULL COMMENT 'edited rate',
  `amount` varchar(250) COLLATE utf8_unicode_ci NOT NULL COMMENT 'actul amount'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `wholesale_item_invoice`
--

CREATE TABLE `wholesale_item_invoice` (
  `id` int(11) NOT NULL,
  `billNo` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `vendorId` int(11) NOT NULL,
  `userId` int(11) NOT NULL,
  `partyName` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `saleDate` date NOT NULL,
  `subtotal` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `totalAmount` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `userNoticeView` int(4) NOT NULL,
  `vendorNoticeView` int(4) NOT NULL,
  `paymentType` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `transactionId` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `deliveryStatus` int(11) NOT NULL COMMENT '1 delivered 0 waiting 2 vendor cancel 3 user cancel 4 payment refund',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'invoice delete status 0= deleted ',
  `paymentStatus` tinyint(4) NOT NULL DEFAULT '0',
  `deliveryDate` date NOT NULL,
  `createdAt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updateAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `app_suggetions`
--
ALTER TABLE `app_suggetions`
  ADD PRIMARY KEY (`sugId`);

--
-- Indexes for table `app_version`
--
ALTER TABLE `app_version`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`catId`);

--
-- Indexes for table `item_unit`
--
ALTER TABLE `item_unit`
  ADD PRIMARY KEY (`unitId`);

--
-- Indexes for table `language`
--
ALTER TABLE `language`
  ADD PRIMARY KEY (`language_id`);

--
-- Indexes for table `logo_settings`
--
ALTER TABLE `logo_settings`
  ADD PRIMARY KEY (`logoId`);

--
-- Indexes for table `refund_notification`
--
ALTER TABLE `refund_notification`
  ADD PRIMARY KEY (`refundId`);

--
-- Indexes for table `rt_settings`
--
ALTER TABLE `rt_settings`
  ADD PRIMARY KEY (`uniq_id`);

--
-- Indexes for table `sub_categories`
--
ALTER TABLE `sub_categories`
  ADD PRIMARY KEY (`subCatId`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`userId`);

--
-- Indexes for table `wholesales_item`
--
ALTER TABLE `wholesales_item`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `wholesale_item_invoice`
--
ALTER TABLE `wholesale_item_invoice`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `app_suggetions`
--
ALTER TABLE `app_suggetions`
  MODIFY `sugId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `app_version`
--
ALTER TABLE `app_version`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `catId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=43;

--
-- AUTO_INCREMENT for table `item_unit`
--
ALTER TABLE `item_unit`
  MODIFY `unitId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `language`
--
ALTER TABLE `language`
  MODIFY `language_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=111;

--
-- AUTO_INCREMENT for table `logo_settings`
--
ALTER TABLE `logo_settings`
  MODIFY `logoId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `refund_notification`
--
ALTER TABLE `refund_notification`
  MODIFY `refundId` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `rt_settings`
--
ALTER TABLE `rt_settings`
  MODIFY `uniq_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=58;

--
-- AUTO_INCREMENT for table `sub_categories`
--
ALTER TABLE `sub_categories`
  MODIFY `subCatId` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `userId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `wholesales_item`
--
ALTER TABLE `wholesales_item`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `wholesale_item_invoice`
--
ALTER TABLE `wholesale_item_invoice`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
