-- https://www.phpmyadmin.net/
--

START TRANSACTION;



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

--
-- Table structure for table `banner`
--

CREATE TABLE `banner` (
  `id` int NOT NULL,
  `img` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `banner`
--



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

--
-- Table structure for table `payout_setting`
--

CREATE TABLE `payout_setting` (
  `id` int NOT NULL,
  `owner_id` int NOT NULL,
  `amt` int NOT NULL,
  `status` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `proof` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `r_date` datetime NOT NULL,
  `r_type` enum('UPI','BANK Transfer','Paypal') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `acc_number` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `bank_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `acc_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `ifsc_code` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `upi_id` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `paypal_id` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `service_details`
--


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

--
-- Table structure for table `tbl_address`
--

CREATE TABLE `tbl_address` (
  `id` int NOT NULL,
  `uid` int NOT NULL,
  `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `landmark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `r_instruction` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `a_type` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `a_lat` text NOT NULL,
  `a_long` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_address`
--


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

--
-- Table structure for table `tbl_cash`
--

CREATE TABLE `tbl_cash` (
  `id` int NOT NULL,
  `rid` int NOT NULL,
  `amt` float NOT NULL,
  `message` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `pdate` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_category`
--

CREATE TABLE `tbl_category` (
  `id` int NOT NULL,
  `title` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `img` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `status` int NOT NULL,
  `cover` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_category`
--


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

--
-- Table structure for table `tbl_coupon`
--

CREATE TABLE `tbl_coupon` (
  `id` int NOT NULL,
  `store_id` int NOT NULL,
  `coupon_img` text NOT NULL,
  `title` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `coupon_code` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `subtitle` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `expire_date` date NOT NULL,
  `min_amt` float NOT NULL,
  `coupon_val` float NOT NULL,
  `description` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `status` int NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_coupon`
--


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

--
-- Table structure for table `tbl_data_required`
--

CREATE TABLE `tbl_data_required` (
  `id` int NOT NULL,
  `data` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tbl_data_required`
--


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

--
-- Table structure for table `tbl_faq`
--

CREATE TABLE `tbl_faq` (
  `id` int NOT NULL,
  `store_id` int NOT NULL,
  `question` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `answer` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `status` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_faq`
--

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

--
-- Table structure for table `tbl_fav`
--

CREATE TABLE `tbl_fav` (
  `id` int NOT NULL,
  `uid` int NOT NULL,
  `store_id` int NOT NULL,
  `zone_id` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_fav`
--


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

--
-- Table structure for table `tbl_mcat`
--

CREATE TABLE `tbl_mcat` (
  `id` int NOT NULL,
  `store_id` int NOT NULL,
  `title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `status` int NOT NULL,
  `img` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_mcat`
--

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

--
-- Table structure for table `tbl_normal_order`
--

CREATE TABLE `tbl_normal_order` (
  `id` int NOT NULL,
  `store_id` int NOT NULL,
  `uid` int NOT NULL,
  `odate` date NOT NULL,
  `p_method_id` int NOT NULL,
  `address` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `landmark` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci,
  `d_charge` float NOT NULL,
  `cou_id` float NOT NULL,
  `cou_amt` float NOT NULL,
  `o_total` float NOT NULL,
  `subtotal` float NOT NULL,
  `trans_id` text,
  `a_note` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci,
  `a_status` int NOT NULL DEFAULT '0',
  `rid` int NOT NULL DEFAULT '0',
  `wall_amt` float NOT NULL,
  `name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `mobile` double NOT NULL,
  `status` enum('Pending','Processing','Completed','Cancelled','On Route') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `comment_reject` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci,
  `tslot` text NOT NULL,
  `is_rate` int NOT NULL DEFAULT '0',
  `review_date` date DEFAULT NULL,
  `total_rate` int NOT NULL DEFAULT '0',
  `rate_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `commission` int NOT NULL DEFAULT '0',
  `store_charge` float NOT NULL,
  `order_status` int NOT NULL DEFAULT '0',
  `sign` text,
  `dslot` text NOT NULL,
  `pick_date` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_normal_order`
--


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

--
-- Table structure for table `tbl_normal_order_product`
--

CREATE TABLE `tbl_normal_order_product` (
  `id` int NOT NULL,
  `oid` int NOT NULL,
  `pquantity` int NOT NULL,
  `ptitle` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `pdiscount` int NOT NULL,
  `pimg` text NOT NULL,
  `pprice` int NOT NULL,
  `ptype` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_normal_order_product`
--



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

--
-- Table structure for table `tbl_notification`
--

CREATE TABLE `tbl_notification` (
  `id` int NOT NULL,
  `uid` int NOT NULL,
  `datetime` datetime NOT NULL,
  `title` text NOT NULL,
  `description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_notification`
--



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

--
-- Table structure for table `tbl_page`
--

CREATE TABLE `tbl_page` (
  `id` int NOT NULL,
  `title` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `status` int NOT NULL,
  `description` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_page`
--


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

--
-- Table structure for table `tbl_payment_list`
--

CREATE TABLE `tbl_payment_list` (
  `id` int NOT NULL,
  `title` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `img` text NOT NULL,
  `attributes` text NOT NULL,
  `status` int NOT NULL DEFAULT '1',
  `subtitle` text NOT NULL,
  `p_show` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_payment_list`
--

INSERT INTO `tbl_payment_list` (`id`, `title`, `img`, `attributes`, `status`, `subtitle`, `p_show`) VALUES
(1, 'Paypal', 'images/payment/1663146734.png', 'Client_id,Secret_Key,0', 1, 'Credit/Debit card with Easier way to pay – online and on your mobile.', 1),
(2, 'Stripe', 'images/payment/1663146748.png', 'pk_key,sk_key', 1, 'Accept all major debit and credit cards from customers in every country', 1),
(3, 'Wallet', 'assets/category/catimg/1604897167.png', '-', 0, 'For Wallet Use Only', 0),
(4, 'Razorpay', 'images/payment/1665207685.png', 'rzp_key', 1, 'Card, UPI, Net banking, Wallet(Phone Pe, Amazon Pay, Freecharge)', 1),
(5, 'Cash On Delivery', 'images/payment/1669368349.png', '-', 1, 'Cash on Delivery', 0),
(6, 'Paytm', 'images/payment/1670319015.png', 'MID,MKEY,TEST', 1, 'Credit/Debit card,net banking,Paytm wallet', 1),
(7, 'Flutterwave', 'images/payment/1670319098.png', 'FLWSECK_KEY', 1, 'Card, pay with USSD, pay with bank, pay with barter', 1),
(9, 'Paystack', '', 'pk_key,sk_key', 1, 'Credit/Debit card with an Easier way to pay – online and on your mobile.', 1);

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

--
-- Table structure for table `tbl_photo`
--

CREATE TABLE `tbl_photo` (
  `id` int NOT NULL,
  `store_id` int NOT NULL,
  `img` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `status` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_photo`
--



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

--
-- Table structure for table `tbl_product`
--

CREATE TABLE `tbl_product` (
  `id` int NOT NULL,
  `store_id` int NOT NULL,
  `cat_id` int NOT NULL,
  `title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `img` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `status` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_product`
--



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

--
-- Table structure for table `tbl_product_attribute`
--

CREATE TABLE `tbl_product_attribute` (
  `id` int NOT NULL,
  `store_id` int NOT NULL,
  `product_id` int NOT NULL,
  `normal_price` float NOT NULL,
  `title` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `discount` float NOT NULL,
  `out_of_stock` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_rider`
--



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

--
-- Table structure for table `tbl_rnoti`
--

CREATE TABLE `tbl_rnoti` (
  `id` int NOT NULL,
  `rid` int NOT NULL,
  `msg` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_snoti`
--

CREATE TABLE `tbl_snoti` (
  `id` int NOT NULL,
  `sid` int NOT NULL,
  `datetime` datetime NOT NULL,
  `title` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `description` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_snoti`
--



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

--
-- Table structure for table `tbl_time`
--

CREATE TABLE `tbl_time` (
  `id` int NOT NULL,
  `store_id` int NOT NULL,
  `mintime` time NOT NULL,
  `maxtime` time NOT NULL,
  `status` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_user`
--


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

--
-- Table structure for table `wallet_report`
--

CREATE TABLE `wallet_report` (
  `id` int NOT NULL,
  `uid` int NOT NULL,
  `message` text NOT NULL,
  `status` text NOT NULL,
  `amt` int NOT NULL,
  `tdate` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `wallet_report`
--



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

--
-- Table structure for table `zones`
--

CREATE TABLE `zones` (
  `id` int NOT NULL,
  `title` text NOT NULL,
  `status` int NOT NULL,
  `coordinates` polygon NOT NULL,
  `alias` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `banner`
--
ALTER TABLE `banner`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `payout_setting`
--
ALTER TABLE `payout_setting`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_address`
--
ALTER TABLE `tbl_address`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_cash`
--
ALTER TABLE `tbl_cash`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_category`
--
ALTER TABLE `tbl_category`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_coupon`
--
ALTER TABLE `tbl_coupon`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_data_required`
--
ALTER TABLE `tbl_data_required`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tbl_faq`
--
ALTER TABLE `tbl_faq`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_fav`
--
ALTER TABLE `tbl_fav`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_mcat`
--
ALTER TABLE `tbl_mcat`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_normal_order`
--
ALTER TABLE `tbl_normal_order`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_normal_order_product`
--
ALTER TABLE `tbl_normal_order_product`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_notification`
--
ALTER TABLE `tbl_notification`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_page`
--
ALTER TABLE `tbl_page`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_payment_list`
--
ALTER TABLE `tbl_payment_list`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `tbl_photo`
--
ALTER TABLE `tbl_photo`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_product`
--
ALTER TABLE `tbl_product`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_product_attribute`
--
ALTER TABLE `tbl_product_attribute`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_rnoti`
--
ALTER TABLE `tbl_rnoti`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_snoti`
--
ALTER TABLE `tbl_snoti`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_time`
--
ALTER TABLE `tbl_time`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `wallet_report`
--
ALTER TABLE `wallet_report`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `zones`
--
ALTER TABLE `zones`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;
COMMIT;

