-- phpMyAdmin SQL Dump
-- version 4.8.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: May 09, 2024 at 10:06 AM
-- Server version: 5.7.22
-- PHP Version: 7.0.30

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: `7094869231retail_store1_device1_mydbsalesdata`
--

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

--
-- Table structure for table `all_sales`
--

CREATE TABLE `all_sales` (
  `_id` int(11) NOT NULL,
  `itemname` text COLLATE utf8mb4_unicode_ci,
  `quantity` text COLLATE utf8mb4_unicode_ci,
  `price` text COLLATE utf8mb4_unicode_ci,
  `total` text COLLATE utf8mb4_unicode_ci,
  `type` text COLLATE utf8mb4_unicode_ci,
  `parent` text COLLATE utf8mb4_unicode_ci,
  `parentid` text COLLATE utf8mb4_unicode_ci,
  `mod_assigned` text COLLATE utf8mb4_unicode_ci,
  `tax` text COLLATE utf8mb4_unicode_ci,
  `taxname` text COLLATE utf8mb4_unicode_ci,
  `bill_no` text COLLATE utf8mb4_unicode_ci,
  `time` text COLLATE utf8mb4_unicode_ci,
  `date` text COLLATE utf8mb4_unicode_ci,
  `user` text COLLATE utf8mb4_unicode_ci,
  `table_id` text COLLATE utf8mb4_unicode_ci,
  `billtype` text COLLATE utf8mb4_unicode_ci,
  `paymentmethod` text COLLATE utf8mb4_unicode_ci,
  `billamount_disapply` text COLLATE utf8mb4_unicode_ci,
  `billamount_disnotapply` text COLLATE utf8mb4_unicode_ci,
  `_idd` text COLLATE utf8mb4_unicode_ci,
  `deleted_not` text COLLATE utf8mb4_unicode_ci,
  `modifiedquantity` text COLLATE utf8mb4_unicode_ci,
  `quantitycopy` text COLLATE utf8mb4_unicode_ci,
  `modifiedtotal` text COLLATE utf8mb4_unicode_ci,
  `date1` text COLLATE utf8mb4_unicode_ci,
  `datetimee` text COLLATE utf8mb4_unicode_ci,
  `disc_type` text COLLATE utf8mb4_unicode_ci,
  `disc_value` text COLLATE utf8mb4_unicode_ci,
  `newtotal` text COLLATE utf8mb4_unicode_ci,
  `disc_thereornot` text COLLATE utf8mb4_unicode_ci,
  `disc_indiv_total` text COLLATE utf8mb4_unicode_ci,
  `new_modified_total` text COLLATE utf8mb4_unicode_ci,
  `datetimee_new` text COLLATE utf8mb4_unicode_ci,
  `hsn_code` text COLLATE utf8mb4_unicode_ci,
  `taxname2` text COLLATE utf8mb4_unicode_ci,
  `tax2` text COLLATE utf8mb4_unicode_ci,
  `taxname3` text COLLATE utf8mb4_unicode_ci,
  `tax3` text COLLATE utf8mb4_unicode_ci,
  `taxname4` text COLLATE utf8mb4_unicode_ci,
  `tax4` text COLLATE utf8mb4_unicode_ci,
  `taxname5` text COLLATE utf8mb4_unicode_ci,
  `tax5` text COLLATE utf8mb4_unicode_ci,
  `category` text COLLATE utf8mb4_unicode_ci,
  `counterperson_username` text COLLATE utf8mb4_unicode_ci,
  `counterperson_name` text COLLATE utf8mb4_unicode_ci,
  `credit` text COLLATE utf8mb4_unicode_ci,
  `Phone_num` text COLLATE utf8mb4_unicode_ci,
  `barcode_get` text COLLATE utf8mb4_unicode_ci,
  `order_id` text COLLATE utf8mb4_unicode_ci,
  `old_total` text COLLATE utf8mb4_unicode_ci,
  `hsn_code2` text COLLATE utf8mb4_unicode_ci,
  `hsn_code3` text COLLATE utf8mb4_unicode_ci,
  `hsn_code4` text COLLATE utf8mb4_unicode_ci,
  `hsn_code5` text COLLATE utf8mb4_unicode_ci,
  `item_online` text COLLATE utf8mb4_unicode_ci,
  `old_total_indiv` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `all_sales_cancelled`
--

CREATE TABLE `all_sales_cancelled` (
  `_id` int(11) NOT NULL,
  `itemname` text COLLATE utf8mb4_unicode_ci,
  `quantity` text COLLATE utf8mb4_unicode_ci,
  `price` text COLLATE utf8mb4_unicode_ci,
  `total` text COLLATE utf8mb4_unicode_ci,
  `type` text COLLATE utf8mb4_unicode_ci,
  `parent` text COLLATE utf8mb4_unicode_ci,
  `parentid` text COLLATE utf8mb4_unicode_ci,
  `mod_assigned` text COLLATE utf8mb4_unicode_ci,
  `tax` text COLLATE utf8mb4_unicode_ci,
  `taxname` text COLLATE utf8mb4_unicode_ci,
  `bill_no` text COLLATE utf8mb4_unicode_ci,
  `time` text COLLATE utf8mb4_unicode_ci,
  `date` text COLLATE utf8mb4_unicode_ci,
  `user` text COLLATE utf8mb4_unicode_ci,
  `billtype` text COLLATE utf8mb4_unicode_ci,
  `paymentmethod` text COLLATE utf8mb4_unicode_ci,
  `billamount_disapply` text COLLATE utf8mb4_unicode_ci,
  `billamount_disnotapply` text COLLATE utf8mb4_unicode_ci,
  `_idd` text COLLATE utf8mb4_unicode_ci,
  `reason` text COLLATE utf8mb4_unicode_ci,
  `billamount_cancelled` text COLLATE utf8mb4_unicode_ci,
  `date1` text COLLATE utf8mb4_unicode_ci,
  `billamount_cancelled_user` text COLLATE utf8mb4_unicode_ci,
  `disc_type` text COLLATE utf8mb4_unicode_ci,
  `disc_value` text COLLATE utf8mb4_unicode_ci,
  `newtotal` text COLLATE utf8mb4_unicode_ci,
  `disc_thereornot` text COLLATE utf8mb4_unicode_ci,
  `disc_indiv_total` text COLLATE utf8mb4_unicode_ci,
  `datetimee_new` text COLLATE utf8mb4_unicode_ci,
  `taxname2` text COLLATE utf8mb4_unicode_ci,
  `tax2` text COLLATE utf8mb4_unicode_ci,
  `taxname3` text COLLATE utf8mb4_unicode_ci,
  `tax3` text COLLATE utf8mb4_unicode_ci,
  `taxname4` text COLLATE utf8mb4_unicode_ci,
  `tax4` text COLLATE utf8mb4_unicode_ci,
  `taxname5` text COLLATE utf8mb4_unicode_ci,
  `tax5` text COLLATE utf8mb4_unicode_ci,
  `hsn_code` text COLLATE utf8mb4_unicode_ci,
  `old_total` text COLLATE utf8mb4_unicode_ci,
  `old_total_indiv` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `billcount`
--

CREATE TABLE `billcount` (
  `_id` int(11) NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `billcount`
--

INSERT INTO `billcount` (`_id`, `value`) VALUES
(1, '0');

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

--
-- Table structure for table `billnumber`
--

CREATE TABLE `billnumber` (
  `_id` int(11) NOT NULL,
  `billnumber` text COLLATE utf8mb4_unicode_ci,
  `total` text COLLATE utf8mb4_unicode_ci,
  `user` text COLLATE utf8mb4_unicode_ci,
  `date` text COLLATE utf8mb4_unicode_ci,
  `paymentmethod` text COLLATE utf8mb4_unicode_ci,
  `billtype` text COLLATE utf8mb4_unicode_ci,
  `subtotal` text COLLATE utf8mb4_unicode_ci,
  `taxtotal` text COLLATE utf8mb4_unicode_ci,
  `roundoff` text COLLATE utf8mb4_unicode_ci,
  `globaltaxtotal` text COLLATE utf8mb4_unicode_ci,
  `billcount` text COLLATE utf8mb4_unicode_ci,
  `datetimee_new` text COLLATE utf8mb4_unicode_ci,
  `comments_sales` text COLLATE utf8mb4_unicode_ci,
  `delivery_fee` text COLLATE utf8mb4_unicode_ci,
  `packing_charges` text COLLATE utf8mb4_unicode_ci,
  `loyalty_points` text COLLATE utf8mb4_unicode_ci,
  `loyalty_amount` text COLLATE utf8mb4_unicode_ci,
  `order_id` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `cancelwiseorderlistitems`
--

CREATE TABLE `cancelwiseorderlistitems` (
  `_id` int(11) NOT NULL,
  `date` text COLLATE utf8mb4_unicode_ci,
  `time` text COLLATE utf8mb4_unicode_ci,
  `user` text COLLATE utf8mb4_unicode_ci,
  `billno` text COLLATE utf8mb4_unicode_ci,
  `sale` text COLLATE utf8mb4_unicode_ci,
  `refund` text COLLATE utf8mb4_unicode_ci,
  `reason` text COLLATE utf8mb4_unicode_ci,
  `billcount` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `cardnumber`
--

CREATE TABLE `cardnumber` (
  `_id` int(11) NOT NULL,
  `cardnumber` text COLLATE utf8mb4_unicode_ci,
  `billnumber` text COLLATE utf8mb4_unicode_ci,
  `datetimee_new` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `clicked_cust_name`
--

CREATE TABLE `clicked_cust_name` (
  `_id` int(11) NOT NULL,
  `name` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `clicked_cust_name`
--

INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES
(1, '');

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

--
-- Table structure for table `cusotmer_activity_temp`
--

CREATE TABLE `cusotmer_activity_temp` (
  `_id` int(11) NOT NULL,
  `name` text COLLATE utf8mb4_unicode_ci,
  `phone_no` text COLLATE utf8mb4_unicode_ci,
  `email` text COLLATE utf8mb4_unicode_ci,
  `addr` text COLLATE utf8mb4_unicode_ci,
  `total_amount` text COLLATE utf8mb4_unicode_ci,
  `balance` text COLLATE utf8mb4_unicode_ci,
  `discount_value` text COLLATE utf8mb4_unicode_ci,
  `discount_type` text COLLATE utf8mb4_unicode_ci,
  `approval_rate` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `cusotmer_activity_temp_top3`
--

CREATE TABLE `cusotmer_activity_temp_top3` (
  `_id` int(11) NOT NULL,
  `name` text COLLATE utf8mb4_unicode_ci,
  `phone_no` text COLLATE utf8mb4_unicode_ci,
  `email` text COLLATE utf8mb4_unicode_ci,
  `addr` text COLLATE utf8mb4_unicode_ci,
  `total_amount` int(11) DEFAULT NULL,
  `balance` text COLLATE utf8mb4_unicode_ci,
  `discount_value` text COLLATE utf8mb4_unicode_ci,
  `discount_type` text COLLATE utf8mb4_unicode_ci,
  `approval_rate` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `customerdetails`
--

CREATE TABLE `customerdetails` (
  `_id` int(11) NOT NULL,
  `name` text COLLATE utf8mb4_unicode_ci,
  `phoneno` text COLLATE utf8mb4_unicode_ci,
  `emailid` text COLLATE utf8mb4_unicode_ci,
  `address` text COLLATE utf8mb4_unicode_ci,
  `rupees` text COLLATE utf8mb4_unicode_ci,
  `billnumber` text COLLATE utf8mb4_unicode_ci,
  `date1` text COLLATE utf8mb4_unicode_ci,
  `time1` text COLLATE utf8mb4_unicode_ci,
  `date` text COLLATE utf8mb4_unicode_ci,
  `total` text COLLATE utf8mb4_unicode_ci,
  `deposit` text COLLATE utf8mb4_unicode_ci,
  `cashout` text COLLATE utf8mb4_unicode_ci,
  `credit` text COLLATE utf8mb4_unicode_ci,
  `charges` text COLLATE utf8mb4_unicode_ci,
  `authentication_pin` text COLLATE utf8mb4_unicode_ci,
  `otp` text COLLATE utf8mb4_unicode_ci,
  `dob` text COLLATE utf8mb4_unicode_ci,
  `refunds` text COLLATE utf8mb4_unicode_ci,
  `total_amount` text COLLATE utf8mb4_unicode_ci,
  `cashout_type` text COLLATE utf8mb4_unicode_ci,
  `credit_default` text COLLATE utf8mb4_unicode_ci,
  `commission_charges` text COLLATE utf8mb4_unicode_ci,
  `commission_charges_type` text COLLATE utf8mb4_unicode_ci,
  `commission_charges_status` text COLLATE utf8mb4_unicode_ci,
  `authentication_pin_status` text COLLATE utf8mb4_unicode_ci,
  `dob_alaram` text COLLATE utf8mb4_unicode_ci,
  `default_discount_status` text COLLATE utf8mb4_unicode_ci,
  `default_discount_amount` text COLLATE utf8mb4_unicode_ci,
  `default_discount_value` text COLLATE utf8mb4_unicode_ci,
  `default_discount_type` text COLLATE utf8mb4_unicode_ci,
  `notes` text COLLATE utf8mb4_unicode_ci,
  `cust_account_no` text COLLATE utf8mb4_unicode_ci,
  `cust_ifsc_code` text COLLATE utf8mb4_unicode_ci,
  `cust_account_holder_name` text COLLATE utf8mb4_unicode_ci,
  `cust_bank_name` text COLLATE utf8mb4_unicode_ci,
  `datetimee_new` text COLLATE utf8mb4_unicode_ci,
  `user_id` text COLLATE utf8mb4_unicode_ci,
  `tax1` text COLLATE utf8mb4_unicode_ci,
  `tax2` text COLLATE utf8mb4_unicode_ci,
  `tax3` text COLLATE utf8mb4_unicode_ci,
  `tax4` text COLLATE utf8mb4_unicode_ci,
  `tax5` text COLLATE utf8mb4_unicode_ci,
  `tax6` text COLLATE utf8mb4_unicode_ci,
  `tax7` text COLLATE utf8mb4_unicode_ci,
  `tax8` text COLLATE utf8mb4_unicode_ci,
  `tax9` text COLLATE utf8mb4_unicode_ci,
  `tax10` text COLLATE utf8mb4_unicode_ci,
  `tax11` text COLLATE utf8mb4_unicode_ci,
  `tax12` text COLLATE utf8mb4_unicode_ci,
  `tax13` text COLLATE utf8mb4_unicode_ci,
  `tax14` text COLLATE utf8mb4_unicode_ci,
  `tax15` text COLLATE utf8mb4_unicode_ci,
  `tax_selection` text COLLATE utf8mb4_unicode_ci,
  `tax1_value` text COLLATE utf8mb4_unicode_ci,
  `tax2_value` text COLLATE utf8mb4_unicode_ci,
  `tax3_value` text COLLATE utf8mb4_unicode_ci,
  `tax4_value` text COLLATE utf8mb4_unicode_ci,
  `tax5_value` text COLLATE utf8mb4_unicode_ci,
  `tax6_value` text COLLATE utf8mb4_unicode_ci,
  `tax7_value` text COLLATE utf8mb4_unicode_ci,
  `tax8_value` text COLLATE utf8mb4_unicode_ci,
  `tax9_value` text COLLATE utf8mb4_unicode_ci,
  `tax10_value` text COLLATE utf8mb4_unicode_ci,
  `tax11_value` text COLLATE utf8mb4_unicode_ci,
  `tax12_value` text COLLATE utf8mb4_unicode_ci,
  `tax13_value` text COLLATE utf8mb4_unicode_ci,
  `tax14_value` text COLLATE utf8mb4_unicode_ci,
  `tax15_value` text COLLATE utf8mb4_unicode_ci,
  `proceedings` text COLLATE utf8mb4_unicode_ci,
  `SaleType` text COLLATE utf8mb4_unicode_ci,
  `Cheque_num` text COLLATE utf8mb4_unicode_ci,
  `CreditAmount` text COLLATE utf8mb4_unicode_ci,
  `SaleTime` text COLLATE utf8mb4_unicode_ci,
  `SaleDate` text COLLATE utf8mb4_unicode_ci,
  `Transaction_ID` text COLLATE utf8mb4_unicode_ci,
  `Card_Type` text COLLATE utf8mb4_unicode_ci,
  `Card_Num` text COLLATE utf8mb4_unicode_ci,
  `RRN` text COLLATE utf8mb4_unicode_ci,
  `pincode` text COLLATE utf8mb4_unicode_ci,
  `limit_status` text COLLATE utf8mb4_unicode_ci,
  `limit_value` text COLLATE utf8mb4_unicode_ci,
  `limit_present_value` text COLLATE utf8mb4_unicode_ci,
  `write_off` text COLLATE utf8mb4_unicode_ci,
  `loyal_points` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `customerdetails_temporary`
--

CREATE TABLE `customerdetails_temporary` (
  `_id` int(11) NOT NULL,
  `commission_charges` text COLLATE utf8mb4_unicode_ci,
  `commission_charges_status` text COLLATE utf8mb4_unicode_ci,
  `commission_charges_type` text COLLATE utf8mb4_unicode_ci,
  `phoneno` text COLLATE utf8mb4_unicode_ci,
  `name` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `customer_loyalty_points`
--

CREATE TABLE `customer_loyalty_points` (
  `_id` int(11) NOT NULL,
  `phoneno` text COLLATE utf8mb4_unicode_ci,
  `points` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `cust_feedback`
--

CREATE TABLE `cust_feedback` (
  `_id` int(11) NOT NULL,
  `cust_name` text COLLATE utf8mb4_unicode_ci,
  `date` text COLLATE utf8mb4_unicode_ci,
  `time` text COLLATE utf8mb4_unicode_ci,
  `ambience_rating` text COLLATE utf8mb4_unicode_ci,
  `pro_qual_rating` text COLLATE utf8mb4_unicode_ci,
  `service_rating` text COLLATE utf8mb4_unicode_ci,
  `overall_exp_rating` text COLLATE utf8mb4_unicode_ci,
  `comments` text COLLATE utf8mb4_unicode_ci,
  `percentage` text COLLATE utf8mb4_unicode_ci,
  `cust_phoneno` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `discountdetails`
--

CREATE TABLE `discountdetails` (
  `_id` int(11) NOT NULL,
  `date` text COLLATE utf8mb4_unicode_ci,
  `time` text COLLATE utf8mb4_unicode_ci,
  `billno` text COLLATE utf8mb4_unicode_ci,
  `Discountcodeno` text COLLATE utf8mb4_unicode_ci,
  `Discount_percent` text COLLATE utf8mb4_unicode_ci,
  `Billamount_rupess` text COLLATE utf8mb4_unicode_ci,
  `Discount_rupees` text COLLATE utf8mb4_unicode_ci,
  `date1` text COLLATE utf8mb4_unicode_ci,
  `original_amount` text COLLATE utf8mb4_unicode_ci,
  `billcount` text COLLATE utf8mb4_unicode_ci,
  `datetimee_new` text COLLATE utf8mb4_unicode_ci,
  `paymentmethod` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `expenses_sales`
--

CREATE TABLE `expenses_sales` (
  `_id` int(11) NOT NULL,
  `expensename` text COLLATE utf8mb4_unicode_ci,
  `price` text COLLATE utf8mb4_unicode_ci,
  `category` text COLLATE utf8mb4_unicode_ci,
  `counterperson_username` text COLLATE utf8mb4_unicode_ci,
  `counterperson_name` text COLLATE utf8mb4_unicode_ci,
  `date` text COLLATE utf8mb4_unicode_ci,
  `time` text COLLATE utf8mb4_unicode_ci,
  `datetimee_new` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `generalorderlistascdesc`
--

CREATE TABLE `generalorderlistascdesc` (
  `_id` int(11) NOT NULL,
  `date` text COLLATE utf8mb4_unicode_ci,
  `time` text COLLATE utf8mb4_unicode_ci,
  `user` text COLLATE utf8mb4_unicode_ci,
  `billno` text COLLATE utf8mb4_unicode_ci,
  `billdetails` text COLLATE utf8mb4_unicode_ci,
  `sales` int(11) DEFAULT NULL,
  `discountamount` text COLLATE utf8mb4_unicode_ci,
  `paymentmethod` text COLLATE utf8mb4_unicode_ci,
  `billtype` text COLLATE utf8mb4_unicode_ci,
  `itemname` text COLLATE utf8mb4_unicode_ci,
  `quan` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `generalorderlistascdesc1`
--

CREATE TABLE `generalorderlistascdesc1` (
  `_id` int(11) NOT NULL,
  `date` text COLLATE utf8mb4_unicode_ci,
  `time` text COLLATE utf8mb4_unicode_ci,
  `user` text COLLATE utf8mb4_unicode_ci,
  `billno` text COLLATE utf8mb4_unicode_ci,
  `billdetails` text COLLATE utf8mb4_unicode_ci,
  `sales` int(11) DEFAULT NULL,
  `discountamount` text COLLATE utf8mb4_unicode_ci,
  `paymentmethod` text COLLATE utf8mb4_unicode_ci,
  `billtype` text COLLATE utf8mb4_unicode_ci,
  `itemname` text COLLATE utf8mb4_unicode_ci,
  `quan` text COLLATE utf8mb4_unicode_ci,
  `tableid` text COLLATE utf8mb4_unicode_ci,
  `individualprice` text COLLATE utf8mb4_unicode_ci,
  `date1` text COLLATE utf8mb4_unicode_ci,
  `datetimee` text COLLATE utf8mb4_unicode_ci,
  `cardnumber` text COLLATE utf8mb4_unicode_ci,
  `individualtotal` text COLLATE utf8mb4_unicode_ci,
  `billcount` text COLLATE utf8mb4_unicode_ci,
  `hsn_code` text COLLATE utf8mb4_unicode_ci,
  `itemtax_name` text COLLATE utf8mb4_unicode_ci,
  `itemtax_per` text COLLATE utf8mb4_unicode_ci,
  `itemtax_rs` text COLLATE utf8mb4_unicode_ci,
  `globaltax_rs` text COLLATE utf8mb4_unicode_ci,
  `itemtax_name2` text COLLATE utf8mb4_unicode_ci,
  `itemtax_rs2` text COLLATE utf8mb4_unicode_ci,
  `itemtax_name3` text COLLATE utf8mb4_unicode_ci,
  `itemtax_rs3` text COLLATE utf8mb4_unicode_ci,
  `itemtax_name4` text COLLATE utf8mb4_unicode_ci,
  `itemtax_rs4` text COLLATE utf8mb4_unicode_ci,
  `itemtax_name5` text COLLATE utf8mb4_unicode_ci,
  `itemtax_rs5` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `itemdata`
--

CREATE TABLE `itemdata` (
  `_id` int(11) NOT NULL,
  `itemname` text COLLATE utf8mb4_unicode_ci,
  `total` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `itemwiseorderlistcategory`
--

CREATE TABLE `itemwiseorderlistcategory` (
  `_id` int(11) NOT NULL,
  `itemno` text COLLATE utf8mb4_unicode_ci,
  `categoryname` text COLLATE utf8mb4_unicode_ci,
  `sales` int(11) DEFAULT NULL,
  `salespercentage` int(11) DEFAULT NULL,
  `itemtotalquan` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `itemwiseorderlistitems`
--

CREATE TABLE `itemwiseorderlistitems` (
  `_id` int(11) NOT NULL,
  `itemno` text COLLATE utf8mb4_unicode_ci,
  `itemname` text COLLATE utf8mb4_unicode_ci,
  `sales` int(11) DEFAULT NULL,
  `salespercentage` int(11) DEFAULT NULL,
  `itemtotalquan` text COLLATE utf8mb4_unicode_ci,
  `category` text COLLATE utf8mb4_unicode_ci,
  `i_buying_price` text COLLATE utf8mb4_unicode_ci,
  `mi_buying_price` text COLLATE utf8mb4_unicode_ci,
  `i_cost_value` text COLLATE utf8mb4_unicode_ci,
  `i_cost_percent` text COLLATE utf8mb4_unicode_ci,
  `mi_cost_value` text COLLATE utf8mb4_unicode_ci,
  `mi_cost_percent` text COLLATE utf8mb4_unicode_ci,
  `barcode_value` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `itemwiseorderlistmodifiers`
--

CREATE TABLE `itemwiseorderlistmodifiers` (
  `_id` int(11) NOT NULL,
  `modno` text COLLATE utf8mb4_unicode_ci,
  `modname` text COLLATE utf8mb4_unicode_ci,
  `sales` int(11) DEFAULT NULL,
  `salespercentage` int(11) DEFAULT NULL,
  `modtotalquan` text COLLATE utf8mb4_unicode_ci,
  `category` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `kotcancelled`
--

CREATE TABLE `kotcancelled` (
  `_id` int(11) NOT NULL,
  `itemname` text COLLATE utf8mb4_unicode_ci,
  `qty` text COLLATE utf8mb4_unicode_ci,
  `tableid` text COLLATE utf8mb4_unicode_ci,
  `reason` text COLLATE utf8mb4_unicode_ci,
  `date` text COLLATE utf8mb4_unicode_ci,
  `date1` text COLLATE utf8mb4_unicode_ci,
  `time` text COLLATE utf8mb4_unicode_ci,
  `datetimee_new` text COLLATE utf8mb4_unicode_ci,
  `category` text COLLATE utf8mb4_unicode_ci,
  `user` text COLLATE utf8mb4_unicode_ci,
  `kot_no` text COLLATE utf8mb4_unicode_ci,
  `itemtype` text COLLATE utf8mb4_unicode_ci,
  `price` text COLLATE utf8mb4_unicode_ci,
  `total` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `online_order_wera`
--

CREATE TABLE `online_order_wera` (
  `_id` int(11) NOT NULL,
  `order_type` text COLLATE utf8mb4_unicode_ci,
  `order_date_time` text COLLATE utf8mb4_unicode_ci,
  `payment_mode` text COLLATE utf8mb4_unicode_ci,
  `restaurant_id` text COLLATE utf8mb4_unicode_ci,
  `restaurant_name` text COLLATE utf8mb4_unicode_ci,
  `external_order_id` text COLLATE utf8mb4_unicode_ci,
  `restaurant_address` text COLLATE utf8mb4_unicode_ci,
  `restaurant_number` text COLLATE utf8mb4_unicode_ci,
  `order_from` text COLLATE utf8mb4_unicode_ci,
  `enable_delivery` text COLLATE utf8mb4_unicode_ci,
  `net_amount` text COLLATE utf8mb4_unicode_ci,
  `gross_amount` text COLLATE utf8mb4_unicode_ci,
  `order_instructions` text COLLATE utf8mb4_unicode_ci,
  `gst` text COLLATE utf8mb4_unicode_ci,
  `cgst` text COLLATE utf8mb4_unicode_ci,
  `sgst` text COLLATE utf8mb4_unicode_ci,
  `packaging` text COLLATE utf8mb4_unicode_ci,
  `order_packaging` text COLLATE utf8mb4_unicode_ci,
  `packaging_cgst_percent` text COLLATE utf8mb4_unicode_ci,
  `packaging_sgst_percent` text COLLATE utf8mb4_unicode_ci,
  `packaging_cgst` text COLLATE utf8mb4_unicode_ci,
  `packaging_sgst` text COLLATE utf8mb4_unicode_ci,
  `order_packaging_cgst` text COLLATE utf8mb4_unicode_ci,
  `order_packaging_sgst` text COLLATE utf8mb4_unicode_ci,
  `order_packaging_cgst_percent` text COLLATE utf8mb4_unicode_ci,
  `order_packaging_sgst_percent` text COLLATE utf8mb4_unicode_ci,
  `delivery_charge` text COLLATE utf8mb4_unicode_ci,
  `discount_reason` text COLLATE utf8mb4_unicode_ci,
  `discount` text COLLATE utf8mb4_unicode_ci,
  `cus_name` text COLLATE utf8mb4_unicode_ci,
  `cus_phone_number` text COLLATE utf8mb4_unicode_ci,
  `cus_email` text COLLATE utf8mb4_unicode_ci,
  `cus_address` text COLLATE utf8mb4_unicode_ci,
  `cus_delivery_area` text COLLATE utf8mb4_unicode_ci,
  `cus_address_instructions` text COLLATE utf8mb4_unicode_ci,
  `num_item` text COLLATE utf8mb4_unicode_ci,
  `order_status` text COLLATE utf8mb4_unicode_ci,
  `order_reason` text COLLATE utf8mb4_unicode_ci,
  `rider_name` text COLLATE utf8mb4_unicode_ci,
  `rider_number` text COLLATE utf8mb4_unicode_ci,
  `rider_status` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `online_wera_store`
--

CREATE TABLE `online_wera_store` (
  `_id` int(11) NOT NULL,
  `open_status` text COLLATE utf8mb4_unicode_ci,
  `menu_upload_ref` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `razorpay_trans_details`
--

CREATE TABLE `razorpay_trans_details` (
  `_id` int(11) NOT NULL,
  `billnumber` text COLLATE utf8mb4_unicode_ci,
  `account_id` text COLLATE utf8mb4_unicode_ci,
  `event` text COLLATE utf8mb4_unicode_ci,
  `id` text COLLATE utf8mb4_unicode_ci,
  `order_id` text COLLATE utf8mb4_unicode_ci,
  `description` text COLLATE utf8mb4_unicode_ci,
  `rrn` text COLLATE utf8mb4_unicode_ci,
  `upi_transaction_id` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `splitdata`
--

CREATE TABLE `splitdata` (
  `_id` int(11) NOT NULL,
  `billnum` text COLLATE utf8mb4_unicode_ci,
  `total` text COLLATE utf8mb4_unicode_ci,
  `splittype` text COLLATE utf8mb4_unicode_ci,
  `split1` text COLLATE utf8mb4_unicode_ci,
  `split2` text COLLATE utf8mb4_unicode_ci,
  `split3` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tablepayment`
--

CREATE TABLE `tablepayment` (
  `_id` int(11) NOT NULL,
  `tablename` text COLLATE utf8mb4_unicode_ci,
  `tableid` text COLLATE utf8mb4_unicode_ci,
  `price` text COLLATE utf8mb4_unicode_ci,
  `print` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `top_category`
--

CREATE TABLE `top_category` (
  `_id` int(11) NOT NULL,
  `category` text COLLATE utf8mb4_unicode_ci,
  `value` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `top_reason`
--

CREATE TABLE `top_reason` (
  `_id` int(11) NOT NULL,
  `reason` text COLLATE utf8mb4_unicode_ci,
  `value` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `usercancelleddata`
--

CREATE TABLE `usercancelleddata` (
  `_id` int(11) NOT NULL,
  `username` text COLLATE utf8mb4_unicode_ci,
  `total` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `userdata`
--

CREATE TABLE `userdata` (
  `_id` int(11) NOT NULL,
  `username` text COLLATE utf8mb4_unicode_ci,
  `total` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `userwiseorderlistitems`
--

CREATE TABLE `userwiseorderlistitems` (
  `_id` int(11) NOT NULL,
  `username` text COLLATE utf8mb4_unicode_ci,
  `sales` int(11) DEFAULT NULL,
  `salespercentage` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `write_off`
--

CREATE TABLE `write_off` (
  `_id` int(11) NOT NULL,
  `date` text COLLATE utf8mb4_unicode_ci,
  `time` text COLLATE utf8mb4_unicode_ci,
  `name` text COLLATE utf8mb4_unicode_ci,
  `phoneno` text COLLATE utf8mb4_unicode_ci,
  `write_off` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `all_sales`
--
ALTER TABLE `all_sales`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `all_sales_cancelled`
--
ALTER TABLE `all_sales_cancelled`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `billcount`
--
ALTER TABLE `billcount`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `billnumber`
--
ALTER TABLE `billnumber`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `cancelwiseorderlistitems`
--
ALTER TABLE `cancelwiseorderlistitems`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `cardnumber`
--
ALTER TABLE `cardnumber`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `clicked_cust_name`
--
ALTER TABLE `clicked_cust_name`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `cusotmer_activity_temp`
--
ALTER TABLE `cusotmer_activity_temp`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `cusotmer_activity_temp_top3`
--
ALTER TABLE `cusotmer_activity_temp_top3`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `customerdetails`
--
ALTER TABLE `customerdetails`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `customerdetails_temporary`
--
ALTER TABLE `customerdetails_temporary`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `customer_loyalty_points`
--
ALTER TABLE `customer_loyalty_points`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `cust_feedback`
--
ALTER TABLE `cust_feedback`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `discountdetails`
--
ALTER TABLE `discountdetails`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `expenses_sales`
--
ALTER TABLE `expenses_sales`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `generalorderlistascdesc`
--
ALTER TABLE `generalorderlistascdesc`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `generalorderlistascdesc1`
--
ALTER TABLE `generalorderlistascdesc1`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `itemdata`
--
ALTER TABLE `itemdata`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `itemwiseorderlistcategory`
--
ALTER TABLE `itemwiseorderlistcategory`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `itemwiseorderlistitems`
--
ALTER TABLE `itemwiseorderlistitems`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `itemwiseorderlistmodifiers`
--
ALTER TABLE `itemwiseorderlistmodifiers`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `kotcancelled`
--
ALTER TABLE `kotcancelled`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `online_order_wera`
--
ALTER TABLE `online_order_wera`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `online_wera_store`
--
ALTER TABLE `online_wera_store`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `razorpay_trans_details`
--
ALTER TABLE `razorpay_trans_details`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `splitdata`
--
ALTER TABLE `splitdata`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `tablepayment`
--
ALTER TABLE `tablepayment`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `top_category`
--
ALTER TABLE `top_category`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `top_reason`
--
ALTER TABLE `top_reason`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `usercancelleddata`
--
ALTER TABLE `usercancelleddata`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `userdata`
--
ALTER TABLE `userdata`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `userwiseorderlistitems`
--
ALTER TABLE `userwiseorderlistitems`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `write_off`
--
ALTER TABLE `write_off`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `all_sales`
--
ALTER TABLE `all_sales`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `all_sales_cancelled`
--
ALTER TABLE `all_sales_cancelled`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `billnumber`
--
ALTER TABLE `billnumber`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cardnumber`
--
ALTER TABLE `cardnumber`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `customerdetails`
--
ALTER TABLE `customerdetails`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `customerdetails_temporary`
--
ALTER TABLE `customerdetails_temporary`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `customer_loyalty_points`
--
ALTER TABLE `customer_loyalty_points`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `discountdetails`
--
ALTER TABLE `discountdetails`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `expenses_sales`
--
ALTER TABLE `expenses_sales`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `kotcancelled`
--
ALTER TABLE `kotcancelled`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `razorpay_trans_details`
--
ALTER TABLE `razorpay_trans_details`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tablepayment`
--
ALTER TABLE `tablepayment`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `top_category`
--
ALTER TABLE `top_category`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `top_reason`
--
ALTER TABLE `top_reason`
  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 */;
