-- phpMyAdmin SQL Dump
-- version 4.9.7
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Feb 01, 2023 at 06:15 PM
-- Server version: 8.0.32
-- PHP Version: 7.4.33

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: `akihvfyj_lundry`
--

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

--
-- Table structure for table `tbl_account`
--

CREATE TABLE `tbl_account` (
  `id` int NOT NULL,
  `ac_name` varchar(255) NOT NULL,
  `ac_number` varchar(255) NOT NULL,
  `ac_decrip` varchar(255) NOT NULL,
  `store_ID` varchar(255) NOT NULL,
  `balance` float NOT NULL DEFAULT '0',
  `store_name` varchar(255) NOT NULL,
  `delet_flage` varchar(255) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_account`
--



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

--
-- Table structure for table `tbl_addons`
--

CREATE TABLE `tbl_addons` (
  `id` int NOT NULL,
  `addon` varchar(45) NOT NULL,
  `price` float NOT NULL,
  `status` varchar(45) NOT NULL DEFAULT '0',
  `store_ID` varchar(45) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_addons`
--



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

--
-- Table structure for table `tbl_admin`
--

CREATE TABLE `tbl_admin` (
  `id` int NOT NULL,
  `name` varchar(45) NOT NULL,
  `number` varchar(45) NOT NULL,
  `email` varchar(45) NOT NULL,
  `username` varchar(45) NOT NULL,
  `password` varchar(45) NOT NULL,
  `store_ID` varchar(45) NOT NULL DEFAULT '0',
  `roll_id` varchar(45) NOT NULL DEFAULT '0',
  `approved` varchar(45) NOT NULL DEFAULT '0',
  `delet_flage` varchar(45) NOT NULL DEFAULT '0',
  `img` varchar(255) DEFAULT NULL,
  `is_staff` varchar(45) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_admin`
--

INSERT INTO `tbl_admin` (`id`, `name`, `number`, `email`, `username`, `password`, `store_ID`, `roll_id`, `approved`, `delet_flage`, `img`, `is_staff`) VALUES
(1, 'admin', '985675698', 'trinity1@gmail.com', 'admin', '1234', '1', '1', '1', '0', '1674642755446-avatar-1.jpg', '1');

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

--
-- Table structure for table `tbl_cart`
--

CREATE TABLE `tbl_cart` (
  `id` int NOT NULL,
  `created_by` varchar(45) NOT NULL DEFAULT '0',
  `store_id` varchar(45) NOT NULL DEFAULT '0',
  `customer_id` varchar(45) NOT NULL DEFAULT '0',
  `order_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `service_list_id` varchar(255) NOT NULL DEFAULT '0',
  `order_id` varchar(255) NOT NULL DEFAULT '0',
  `addon_id` varchar(255) NOT NULL DEFAULT '0',
  `addon_price` float NOT NULL DEFAULT '0',
  `delivery_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `extra_discount` float NOT NULL DEFAULT '0',
  `coupon_id` varchar(255) NOT NULL DEFAULT '0',
  `coupon_discount` float NOT NULL DEFAULT '0',
  `tax` float DEFAULT NULL,
  `sub_total` float NOT NULL DEFAULT '0',
  `gross_total` float NOT NULL DEFAULT '0',
  `paid_amount` float NOT NULL DEFAULT '0',
  `payment_type` varchar(255) NOT NULL DEFAULT '0',
  `balance` float NOT NULL DEFAULT '0',
  `notes` varchar(255) NOT NULL DEFAULT ' ',
  `tax_amount` float NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_cart`
--



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

--
-- Table structure for table `tbl_cart_servicelist`
--

CREATE TABLE `tbl_cart_servicelist` (
  `id` int NOT NULL,
  `service_id` varchar(255) NOT NULL,
  `service_type_id` varchar(255) NOT NULL,
  `service_type_price` float NOT NULL,
  `service_quntity` int NOT NULL,
  `service_color` varchar(255) NOT NULL,
  `service_name` varchar(255) NOT NULL,
  `service_type_name` varchar(255) NOT NULL,
  `service_img` varchar(255) NOT NULL DEFAULT ' '
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_cart_servicelist`
--



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

--
-- Table structure for table `tbl_commision`
--

CREATE TABLE `tbl_commision` (
  `id` int NOT NULL,
  `date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `amount` float DEFAULT NULL,
  `from_account` varchar(255) DEFAULT NULL,
  `to_account` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `store_id` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_commision`
--



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

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

CREATE TABLE `tbl_coupon` (
  `id` int NOT NULL,
  `titel` varchar(255) NOT NULL,
  `code` varchar(255) NOT NULL,
  `min_purchase` float NOT NULL,
  `discount` float NOT NULL,
  `start_date` datetime NOT NULL,
  `end_date` datetime NOT NULL,
  `store_list_id` varchar(255) NOT NULL DEFAULT '1',
  `coupon_type` varchar(255) NOT NULL,
  `limit_forsame_user` int NOT NULL,
  `status` varchar(45) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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



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

--
-- Table structure for table `tbl_customer`
--

CREATE TABLE `tbl_customer` (
  `id` int NOT NULL,
  `name` varchar(45) NOT NULL,
  `number` varchar(45) NOT NULL,
  `email` varchar(45) NOT NULL,
  `address` varchar(255) NOT NULL,
  `taxnumber` varchar(45) NOT NULL,
  `username` varchar(45) NOT NULL,
  `password` varchar(45) NOT NULL,
  `store_ID` varchar(45) NOT NULL DEFAULT '1',
  `reffstore` varchar(45) DEFAULT '1',
  `approved` int NOT NULL DEFAULT '0',
  `delet_flage` varchar(45) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_customer`
--


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

--
-- Table structure for table `tbl_email`
--

CREATE TABLE `tbl_email` (
  `id` int NOT NULL,
  `store_id` varchar(255) DEFAULT NULL,
  `host` varchar(255) DEFAULT NULL,
  `port` varchar(255) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `frommail` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_email`
--

INSERT INTO `tbl_email` (`id`, `store_id`, `host`, `port`, `username`, `password`, `frommail`, `status`) VALUES
(1, '5', 'hostname', 'port', 'username', 'password', 'fromemail', '1');

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

--
-- Table structure for table `tbl_expense`
--

CREATE TABLE `tbl_expense` (
  `id` int NOT NULL,
  `date` timestamp NOT NULL,
  `amount` float NOT NULL,
  `towards` varchar(255) NOT NULL,
  `category` varchar(255) DEFAULT NULL,
  `taxInclud` varchar(255) NOT NULL,
  `payment_mode` varchar(255) NOT NULL,
  `created_by` varchar(255) NOT NULL,
  `delet_flage` varchar(255) NOT NULL DEFAULT '0',
  `store_ID` varchar(255) DEFAULT '1',
  `taxpercent` int DEFAULT '0',
  `transection_id` int DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_expense`
--


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

--
-- Table structure for table `tbl_exp_cat`
--

CREATE TABLE `tbl_exp_cat` (
  `id` int NOT NULL,
  `exp_cat_type_id` varchar(45) NOT NULL,
  `cat_name` varchar(255) NOT NULL,
  `delet_flage` varchar(45) NOT NULL DEFAULT '0',
  `store_ID` varchar(45) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_exp_cat`
--



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

--
-- Table structure for table `tbl_exp_cat_type`
--

CREATE TABLE `tbl_exp_cat_type` (
  `id` int NOT NULL,
  `type_name` varchar(255) NOT NULL,
  `delet_flage` varchar(45) NOT NULL DEFAULT '0',
  `store_ID` varchar(45) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_exp_cat_type`
--


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

--
-- Table structure for table `tbl_master_shop`
--

CREATE TABLE `tbl_master_shop` (
  `id` int NOT NULL,
  `type` varchar(45) NOT NULL,
  `currency_symbol` varchar(255) DEFAULT NULL,
  `currency_placement` int DEFAULT '0',
  `customer_autoapprove` int DEFAULT '0',
  `store_autoapprove` int DEFAULT '0',
  `timezone` varchar(255) DEFAULT NULL,
  `printer` int DEFAULT '0',
  `storeroll` int DEFAULT '0',
  `app_logo` varchar(255) DEFAULT NULL,
  `app_favicon` varchar(255) DEFAULT NULL,
  `app_name` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_master_shop`
--

INSERT INTO `tbl_master_shop` (`id`, `type`, `currency_symbol`, `currency_placement`, `customer_autoapprove`, `store_autoapprove`, `timezone`, `printer`, `storeroll`, `app_logo`, `app_favicon`, `app_name`) VALUES
(1, '1', '$', 1, 0, 1, 'Asia/Calcutta', 0, 2, '1674713607268-llll11.png', '1674714113150-llll11.png', 'iLaundry');

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

--
-- Table structure for table `tbl_order`
--

CREATE TABLE `tbl_order` (
  `id` int NOT NULL,
  `order_id` varchar(255) DEFAULT NULL,
  `order_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `delivery_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `order_status` int DEFAULT NULL,
  `service_list` varchar(255) DEFAULT NULL,
  `customer_id` varchar(255) DEFAULT NULL,
  `store_id` varchar(255) DEFAULT NULL,
  `created_by` varchar(255) DEFAULT NULL,
  `addon_data` varchar(255) DEFAULT NULL,
  `addon_price` float DEFAULT NULL,
  `sub_total` float DEFAULT NULL,
  `tax` float DEFAULT NULL,
  `coupon_id` varchar(255) DEFAULT NULL,
  `coupon_discount` float DEFAULT NULL,
  `extra_discount` float DEFAULT NULL,
  `gross_total` float DEFAULT NULL,
  `paid_amount` float DEFAULT NULL,
  `balance_amount` float DEFAULT NULL,
  `payment_data` varchar(255) DEFAULT NULL,
  `tax_amount` float DEFAULT '0',
  `note` varchar(255) DEFAULT NULL,
  `stutus_change_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `master_comission` float DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_order`
--



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

--
-- Table structure for table `tbl_orderstatus`
--

CREATE TABLE `tbl_orderstatus` (
  `id` int NOT NULL,
  `status` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_orderstatus`
--

INSERT INTO `tbl_orderstatus` (`id`, `status`) VALUES
(1, 'Pending'),
(2, 'Processing'),
(3, 'Ready To deliver'),
(4, 'Deliver'),
(5, 'Returned');

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

--
-- Table structure for table `tbl_order_payment`
--

CREATE TABLE `tbl_order_payment` (
  `id` int NOT NULL,
  `payment_amount` float NOT NULL,
  `payment_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `payment_account` varchar(255) NOT NULL,
  `order_id` varchar(45) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_order_payment`
--



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

--
-- Table structure for table `tbl_roll`
--

CREATE TABLE `tbl_roll` (
  `id` int NOT NULL,
  `roll` varchar(255) NOT NULL,
  `orders` varchar(45) NOT NULL DEFAULT ' ',
  `expense` varchar(45) NOT NULL DEFAULT ' ',
  `service` varchar(45) NOT NULL DEFAULT ' ',
  `reports` varchar(45) NOT NULL DEFAULT ' ',
  `tools` varchar(45) NOT NULL DEFAULT ' ',
  `mail` varchar(45) NOT NULL DEFAULT ' ',
  `master` varchar(45) NOT NULL DEFAULT ' ',
  `sms` varchar(45) NOT NULL DEFAULT ' ',
  `staff` varchar(45) NOT NULL DEFAULT ' ',
  `pos` varchar(45) NOT NULL DEFAULT ' ',
  `account` varchar(45) DEFAULT ' ',
  `coupon` varchar(45) DEFAULT ' ',
  `rollaccess` varchar(45) NOT NULL DEFAULT ' ',
  `delet_flage` varchar(45) NOT NULL DEFAULT '0',
  `store_ID` varchar(45) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_roll`
--

INSERT INTO `tbl_roll` (`id`, `roll`, `orders`, `expense`, `service`, `reports`, `tools`, `mail`, `master`, `sms`, `staff`, `pos`, `account`, `coupon`, `rollaccess`, `delet_flage`, `store_ID`) VALUES
(1, 'master_Admin', 'read,write,edit,delete', 'read,write,edit,delete', 'read,write,edit,delete', 'read,write,edit,delete', 'read,write,edit,delete', 'read,write,edit,delete', 'read,write,edit,delete', 'read,write,edit,delete', 'read,write,edit,delete', 'read,write,edit,delete', 'read,write,edit,delete', 'read,write,edit,delete', 'read,write,edit,delete', '0', '1'),
(2, 'Store', 'read,write,edit,delete', 'read,write,edit,delete', 'read,write,edit,delete', 'read,write,edit,delete', 'read,write,edit', 'read,write,edit', 'read,edit', 'read', 'read,write,edit,delete', 'read,write,edit,delete', 'read,write,edit,delete', '', 'read,write,edit', '0', '1'),
(4, 'Cashier', 'read,write,edit,delete', 'read,write,edit', 'read,write,edit', 'read', 'read', 'read', 'read', 'read', 'read,write', 'read,write,edit,delete', 'read', 'read', 'read', '0', '1'),
(5, 'coustomer', 'read,edit', 'read', 'read', '', '', 'edit', 'write', '', '', '', '', '', '', '0', '5'),
(6, 'Cashier', '', 'read,write,edit,delete', 'read,write,edit,delete', '', '', '', 'write', '', '', '', '', '', '', '0', '6'),
(7, 'customer', 'read', 'read,write,edit', '', '', '', '', '', '', '', '', NULL, NULL, '', '0', '6'),
(9, 'manager', 'read,write,edit,delete', 'read,write,edit', '', '', '', '', '', '', '', 'read,write,edit,delete', '', '', '', '0', '5'),
(10, 'Office boys', 'read,write,edit,delete', 'read,write,edit,delete', 'read,write,edit,delete', '', '', '', '', '', '', 'read', '', '', '', '0', '10');

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

--
-- Table structure for table `tbl_services`
--

CREATE TABLE `tbl_services` (
  `id` int NOT NULL,
  `name` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `services_type_id` varchar(45) NOT NULL,
  `services_type_price` varchar(45) NOT NULL,
  `store_ID` varchar(45) NOT NULL DEFAULT '1',
  `status` varchar(45) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_services`
--



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

--
-- Table structure for table `tbl_services_type`
--

CREATE TABLE `tbl_services_type` (
  `id` int NOT NULL,
  `services_type` varchar(45) NOT NULL,
  `status` varchar(45) NOT NULL,
  `store_ID` varchar(45) DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_services_type`
--


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

--
-- Table structure for table `tbl_store`
--

CREATE TABLE `tbl_store` (
  `id` int NOT NULL,
  `name` varchar(255) NOT NULL,
  `logo` varchar(255) NOT NULL,
  `mobile_number` varchar(255) NOT NULL,
  `username` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `shop_commission` float NOT NULL,
  `tax_percent` float NOT NULL,
  `country` varchar(45) NOT NULL,
  `state` varchar(45) NOT NULL,
  `city` varchar(45) NOT NULL,
  `district` varchar(45) NOT NULL,
  `zipcode` varchar(45) NOT NULL,
  `store_email` varchar(255) NOT NULL,
  `store_tax_number` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `status` varchar(45) NOT NULL DEFAULT '0',
  `delete_flage` varchar(45) NOT NULL DEFAULT '0',
  `createdat` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `roll_ID` varchar(45) DEFAULT '0',
  `admin_id` varchar(45) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_store`
--

INSERT INTO `tbl_store` (`id`, `name`, `logo`, `mobile_number`, `username`, `password`, `shop_commission`, `tax_percent`, `country`, `state`, `city`, `district`, `zipcode`, `store_email`, `store_tax_number`, `address`, `status`, `delete_flage`, `createdat`, `roll_ID`, `admin_id`) VALUES
(1, 'UrbanDhobi', '1675163625145-Item9.png', '9856748521', 'urbandhobi', '1234', 40, 25, 'AR', 'gujarat', 'surat', 'surat', '390008', 'trinity@gmail.com', 'PBN458261P52', 'L. P. Savani road', '1', '0', '2023-01-05 12:23:29', '2', '2');

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

--
-- Table structure for table `tbl_transections`
--

CREATE TABLE `tbl_transections` (
  `id` int NOT NULL,
  `account_id` varchar(45) NOT NULL,
  `store_ID` varchar(45) NOT NULL,
  `transec_detail` varchar(255) NOT NULL,
  `transec_type` varchar(255) NOT NULL,
  `debit_amount` float NOT NULL DEFAULT '0',
  `credit_amount` float NOT NULL DEFAULT '0',
  `balance_amount` float DEFAULT '0',
  `date` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_transections`
--



--
-- Indexes for dumped tables
--

--
-- Indexes for table `tbl_account`
--
ALTER TABLE `tbl_account`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id_UNIQUE` (`id`);

--
-- Indexes for table `tbl_addons`
--
ALTER TABLE `tbl_addons`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id_UNIQUE` (`id`);

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

--
-- Indexes for table `tbl_cart`
--
ALTER TABLE `tbl_cart`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id_UNIQUE` (`id`);

--
-- Indexes for table `tbl_cart_servicelist`
--
ALTER TABLE `tbl_cart_servicelist`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id_UNIQUE` (`id`);

--
-- Indexes for table `tbl_commision`
--
ALTER TABLE `tbl_commision`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id_UNIQUE` (`id`);

--
-- Indexes for table `tbl_coupon`
--
ALTER TABLE `tbl_coupon`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id_UNIQUE` (`id`),
  ADD UNIQUE KEY `code_UNIQUE` (`code`);

--
-- Indexes for table `tbl_customer`
--
ALTER TABLE `tbl_customer`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id_UNIQUE` (`id`);

--
-- Indexes for table `tbl_email`
--
ALTER TABLE `tbl_email`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id_UNIQUE` (`id`);

--
-- Indexes for table `tbl_expense`
--
ALTER TABLE `tbl_expense`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id_UNIQUE` (`id`);

--
-- Indexes for table `tbl_exp_cat`
--
ALTER TABLE `tbl_exp_cat`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id_UNIQUE` (`id`);

--
-- Indexes for table `tbl_exp_cat_type`
--
ALTER TABLE `tbl_exp_cat_type`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id_UNIQUE` (`id`);

--
-- Indexes for table `tbl_master_shop`
--
ALTER TABLE `tbl_master_shop`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id_UNIQUE` (`id`);

--
-- Indexes for table `tbl_order`
--
ALTER TABLE `tbl_order`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id_UNIQUE` (`id`);

--
-- Indexes for table `tbl_orderstatus`
--
ALTER TABLE `tbl_orderstatus`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id_UNIQUE` (`id`);

--
-- Indexes for table `tbl_order_payment`
--
ALTER TABLE `tbl_order_payment`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id_UNIQUE` (`id`);

--
-- Indexes for table `tbl_roll`
--
ALTER TABLE `tbl_roll`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id_UNIQUE` (`id`);

--
-- Indexes for table `tbl_services`
--
ALTER TABLE `tbl_services`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id_UNIQUE` (`id`);

--
-- Indexes for table `tbl_services_type`
--
ALTER TABLE `tbl_services_type`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id_UNIQUE` (`id`);

--
-- Indexes for table `tbl_store`
--
ALTER TABLE `tbl_store`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id_UNIQUE` (`id`);

--
-- Indexes for table `tbl_transections`
--
ALTER TABLE `tbl_transections`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id_UNIQUE` (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `tbl_account`
--
ALTER TABLE `tbl_account`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `tbl_addons`
--
ALTER TABLE `tbl_addons`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `tbl_admin`
--
ALTER TABLE `tbl_admin`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `tbl_cart`
--
ALTER TABLE `tbl_cart`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `tbl_cart_servicelist`
--
ALTER TABLE `tbl_cart_servicelist`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=48;

--
-- AUTO_INCREMENT for table `tbl_commision`
--
ALTER TABLE `tbl_commision`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

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

--
-- AUTO_INCREMENT for table `tbl_customer`
--
ALTER TABLE `tbl_customer`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=54;

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

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

--
-- AUTO_INCREMENT for table `tbl_exp_cat`
--
ALTER TABLE `tbl_exp_cat`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `tbl_exp_cat_type`
--
ALTER TABLE `tbl_exp_cat_type`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

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

--
-- AUTO_INCREMENT for table `tbl_order`
--
ALTER TABLE `tbl_order`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `tbl_orderstatus`
--
ALTER TABLE `tbl_orderstatus`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `tbl_order_payment`
--
ALTER TABLE `tbl_order_payment`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

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

--
-- AUTO_INCREMENT for table `tbl_services`
--
ALTER TABLE `tbl_services`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=49;

--
-- AUTO_INCREMENT for table `tbl_services_type`
--
ALTER TABLE `tbl_services_type`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `tbl_store`
--
ALTER TABLE `tbl_store`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `tbl_transections`
--
ALTER TABLE `tbl_transections`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;
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 */;
