INSERT INTO `stores` (`id`, `name_en`, `name`, `company_photo`, `department`, `owner_fname_en`, `owner_lname_en`, `owner_fname`, `owner_lname`, `owner_mobile`, `commercial_no`, `id_no`, `crphoto`, `idphoto`, `bank_name`, `customer_name`, `bank_account`, `iban`, `bank_photo`, `user_name`, `password`, `c_password`, `lang`, `status`, `active`, `block`, `country`, `city`, `place`, `branch_id`, `c_date`, `commission`, `branches`) VALUES
(6, 'Sport Style', 'اسلوب الرياضه ', '', '3', 'Mohammed Abdullah', 'Bahtab', '  محمد عبد الله ', 'باحطاب', '9660556416561', 1010476086, 1119466603, 'data:image/jpeg;base64,[encoded data, 310052 characters]', 'data:image/jpeg;base64,[encoded data, 48360 characters]', '', '', '', '', '', 'sstyle1', '123456', '123456', 'EN', 0, 0, 0, 2, 18, 0, 0, '2018-11-22', 10, 0);

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

--
-- Table structure for table `stores_branches`
--

CREATE TABLE `stores_branches` (
  `id` int(11) NOT NULL,
  `name` text COLLATE utf8_bin NOT NULL,
  `name_en` text COLLATE utf8_bin NOT NULL,
  `store_id` int(11) NOT NULL,
  `country` int(11) NOT NULL,
  `city` int(11) NOT NULL,
  `place` int(11) NOT NULL,
  `c_date` date NOT NULL,
  `manager_fname_en` varchar(255) COLLATE utf8_bin NOT NULL,
  `manager_lname_en` varchar(255) COLLATE utf8_bin NOT NULL,
  `manager_fname` varchar(255) COLLATE utf8_bin NOT NULL,
  `manager_lname` varchar(255) COLLATE utf8_bin NOT NULL,
  `manager_mobile` varchar(255) COLLATE utf8_bin NOT NULL,
  `manager_email` varchar(255) COLLATE utf8_bin NOT NULL,
  `manager_nat` varchar(255) COLLATE utf8_bin NOT NULL,
  `lat` text COLLATE utf8_bin NOT NULL,
  `lon` text COLLATE utf8_bin NOT NULL,
  `phone` text COLLATE utf8_bin NOT NULL,
  `email` text COLLATE utf8_bin NOT NULL,
  `block` int(11) NOT NULL,
  `address` text COLLATE utf8_bin NOT NULL,
  `day_1_from` time NOT NULL,
  `day_2_from` time NOT NULL,
  `day_3_from` time NOT NULL,
  `day_4_from` time NOT NULL,
  `day_5_from` time NOT NULL,
  `day_6_from` time NOT NULL,
  `day_7_from` time NOT NULL,
  `day_1_to` time NOT NULL,
  `day_2_to` time NOT NULL,
  `day_3_to` time NOT NULL,
  `day_4_to` time NOT NULL,
  `day_5_to` time NOT NULL,
  `day_6_to` time NOT NULL,
  `day_7_to` time NOT NULL,
  `operation` int(11) NOT NULL,
  `user_name` varchar(255) COLLATE utf8_bin NOT NULL,
  `branch_password` text COLLATE utf8_bin NOT NULL,
  `c_password` text COLLATE utf8_bin NOT NULL,
  `lang` text COLLATE utf8_bin NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `stores_branches`
--

INSERT INTO `stores_branches` (`id`, `name`, `name_en`, `store_id`, `country`, `city`, `place`, `c_date`, `manager_fname_en`, `manager_lname_en`, `manager_fname`, `manager_lname`, `manager_mobile`, `manager_email`, `manager_nat`, `lat`, `lon`, `phone`, `email`, `block`, `address`, `day_1_from`, `day_2_from`, `day_3_from`, `day_4_from`, `day_5_from`, `day_6_from`, `day_7_from`, `day_1_to`, `day_2_to`, `day_3_to`, `day_4_to`, `day_5_to`, `day_6_to`, `day_7_to`, `operation`, `user_name`, `branch_password`, `c_password`, `lang`) VALUES
(1, 'Smbbranch', 'smbranch', 3, 2, 4, 4, '0000-00-00', 'smb', 's', 'GVXBVC', 'jdnc', 'mvnmv', 'smb@gmail.com', 'can', '', '', '12345', 'smb@gmail.com', 0, 'jfjfjhfjf', '00:00:00', '00:00:00', '00:00:00', '00:00:00', '00:00:00', '00:00:00', '00:00:00', '00:00:00', '00:00:00', '00:00:00', '00:00:00', '00:00:00', '00:00:00', '00:00:00', 0, 'smb', 'smb', 'smb', ''),
(2, 'wellnesskitchen2', 'wellnesskitchen2', 0, 2, 18, 22, '0000-00-00', 'ssfsfsfi', 'ug', 'ug', 'iug', 'iug', 'iug@gmail.com', 'iug', '', '', 'poj', 'poj', 0, 'sdssfsfsfsf', '15:09:00', '15:09:00', '15:09:00', '15:09:00', '15:09:00', '15:09:00', '15:09:00', '15:09:00', '15:09:00', '15:09:00', '15:09:00', '15:09:00', '15:09:00', '15:09:00', 0, 'wellnessk2', '123', '123', 'EN'),
(3, '0507333163', 'Danish', 13, 2, 18, 37, '0000-00-00', 'Danish', 'Agha', 'Danish', 'Agha', '02323232', 'danishagha@outlook.com', 'Pakistani ', '', '', '1212323', 'danishagha@outlook.com', 0, 'Malaz', '19:54:00', '19:54:00', '19:54:00', '19:54:00', '19:54:00', '19:54:00', '19:54:00', '07:30:00', '07:30:00', '07:30:00', '07:30:00', '07:30:00', '07:30:00', '07:30:00', 0, 'danishagha', '123456', '123456', 'EN');

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

--
-- Table structure for table `store_departments`
--

CREATE TABLE `store_departments` (
  `id` int(11) NOT NULL,
  `name` varchar(200) COLLATE utf8_bin NOT NULL,
  `name_en` varchar(200) COLLATE utf8_bin NOT NULL,
  `store` int(11) NOT NULL,
  `main` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `store_departments`
--

INSERT INTO `store_departments` (`id`, `name`, `name_en`, `store`, `main`) VALUES
(1, 'juicy', 'juicey', 3, 1),
(2, 'بروتين', 'Protein', 6, 3),
(3, 'Chicken Meals', 'Chicken Meals', 13, 1);

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

--
-- Table structure for table `subscribe`
--

CREATE TABLE `subscribe` (
  `id` int(11) NOT NULL,
  `name` text COLLATE utf8_bin NOT NULL,
  `email` text COLLATE utf8_bin NOT NULL,
  `mobile` text COLLATE utf8_bin NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

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

--
-- Table structure for table `suppliers_trans`
--

CREATE TABLE `suppliers_trans` (
  `id` int(11) NOT NULL,
  `date` date NOT NULL,
  `type` varchar(10) COLLATE utf8_bin NOT NULL,
  `amount` int(11) NOT NULL,
  `store` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `suppliers_trans`
--

INSERT INTO `suppliers_trans` (`id`, `date`, `type`, `amount`, `store`) VALUES
(1, '2018-08-17', '1', 30, 3),
(2, '2018-08-17', '2', 20, 4);

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

--
-- Table structure for table `supplier_invoice`
--

CREATE TABLE `supplier_invoice` (
  `id` int(11) NOT NULL,
  `invoice_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `commision` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `trans_date` date DEFAULT NULL,
  `total_sale` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `name_en` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `status` int(11) NOT NULL,
  `t_status` int(11) NOT NULL,
  `confirm` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `supplier_invoice`
--

INSERT INTO `supplier_invoice` (`id`, `invoice_no`, `commision`, `trans_date`, `total_sale`, `name`, `name_en`, `status`, `t_status`, `confirm`) VALUES
(1, '1', '2', '2018-09-15', '21', 'كنتاكي ', 'Nutrifiks2', 0, 1, 1),
(2, '2', '222', '2018-09-09', '22', 'ماكدونالدز 2', 'eurus dimashq2', 1, 1, 0),
(3, '3', '', '2018-09-08', '23', 'كنتاكي 5', 'Pizza Hut3', 1, 1, 1),
(4, '7', '0', '0000-00-00', '24', 'كنتاكي 4', 'Pizza Hut2', 0, 0, 0),
(5, '4', '0', '0000-00-00', '25', 'كنتاكي 3', 'Nutrifiks', 0, 0, 0),
(17, '5', '0', '2018-09-08', '26', 'كنتاكي 2', 'eurus dimashq', 0, 0, 0),
(18, '8', '13.68', '2018-09-09', '27', '22كنتاكي ', 'eurus dimashq', 0, 0, 0),
(19, '6', '0', '2018-09-09', '28', '3333333????? ?? ', 'Pizza Hut', 0, 0, 0),
(20, '10', '0', '2018-09-09', '29', '3333333بيتزا هت ', 'Pizza Hut33', 0, 0, 0),
(21, '3', '0', '2018-09-08', '30', 'ماكدونالدز ', 'McDonalds', 0, 0, 0),
(37, '1', '11.34', '2018-09-15', '31', 'كنتاكي ', 'Nutrifiks2', 1, 1, 1),
(38, '9', '0', '0000-00-00', '32', 'مشروبات', 'Drinks2', 0, 0, 0),
(39, '3', '0', '2018-09-08', '33', 'ماكدونالدز ', 'McDonalds77777', 1, 0, 0),
(40, '1', '11.34', '2018-07-10', '34', 'كنتاكي ', 'Nutrifiks2', 1, 0, 0),
(41, '1', '11.34', '2018-07-10', '35', 'كنتاكي ', 'Nutrifiks2', 1, 1, 0),
(42, '1', '3.78', '2018-08-00', '36', 'كنتاكي ', 'Nutrifiks2', 1, 0, 0),
(43, '1', '3.78', '2018-08-21', '37', 'كنتاكي ', 'Nutrifiks2', 1, 0, 0),
(44, '1', '7.56', '2018-09-16', '42', 'كنتاكي ', 'Nutrifiks2', 1, 0, 0),
(45, '2', '90.72', '2018-07-24', '504', '3333333بيتزا هت ', 'Pizza Hut', 1, 0, 0),
(46, '1', '7.98', '2018-09-17', '42', 'كنتاكي ', 'Nutrifiks2', 1, 0, 0),
(47, '2', '85.31', '2018-05-07', '449', '2بيتزا هت ', 'Pizza Hut44', 1, 0, 0);

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

--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
  `id` int(11) NOT NULL,
  `driver` int(11) NOT NULL,
  `amount` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `payment_method` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `date` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `transactions`
--

INSERT INTO `transactions` (`id`, `driver`, `amount`, `payment_method`, `date`) VALUES
(1, 1, '33', 'cash', '2018-08-09'),
(3, 1, '33', 'cash', '2018-08-09');

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

--
-- Table structure for table `update_stores`
--

CREATE TABLE `update_stores` (
  `id` int(11) NOT NULL,
  `name_en` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_bin NOT NULL,
  `company_photo` longtext COLLATE utf8_bin NOT NULL,
  `department` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `owner_fname_en` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `owner_lname_en` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `owner_fname` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `owner_lname` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `owner_mobile` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `commercial_no` int(11) DEFAULT NULL,
  `id_no` int(11) DEFAULT NULL,
  `crphoto` longtext COLLATE utf8_bin,
  `idphoto` longtext COLLATE utf8_bin,
  `bank_name` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `customer_name` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `bank_account` text COLLATE utf8_bin,
  `iban` text COLLATE utf8_bin,
  `bank_photo` longtext COLLATE utf8_bin,
  `user_name` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `password` text COLLATE utf8_bin,
  `c_password` text COLLATE utf8_bin,
  `lang` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `status` int(11) NOT NULL,
  `country` int(11) NOT NULL,
  `city` int(11) NOT NULL,
  `place` int(11) NOT NULL,
  `branch_id` int(11) NOT NULL,
  `active` int(11) NOT NULL,
  `block` int(11) NOT NULL,
  `c_date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

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

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

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `username` text COLLATE utf8_bin NOT NULL,
  `role` int(11) NOT NULL COMMENT 'role=''1''admin,role=''2''supplier',
  `email` text COLLATE utf8_bin NOT NULL,
  `password` text COLLATE utf8_bin NOT NULL,
  `department` int(100) NOT NULL,
  `name` text COLLATE utf8_bin NOT NULL,
  `mobile` text COLLATE utf8_bin NOT NULL,
  `photo` text COLLATE utf8_bin NOT NULL,
  `block` int(11) NOT NULL,
  `c_date` text COLLATE utf8_bin NOT NULL,
  `last_login` text COLLATE utf8_bin NOT NULL,
  `ip_address` text COLLATE utf8_bin NOT NULL,
  `zipcode` varchar(20) COLLATE utf8_bin NOT NULL,
  `location` int(11) NOT NULL,
  `address` varchar(150) COLLATE utf8_bin NOT NULL,
  `level` int(11) NOT NULL,
  `orders_v` int(11) NOT NULL,
  `info_screens_v` int(11) NOT NULL,
  `rating_v` int(11) NOT NULL,
  `customers_v` int(11) NOT NULL,
  `suppliers_v` int(11) NOT NULL,
  `drivers_v` int(11) NOT NULL,
  `promo_codes_v` int(11) NOT NULL,
  `ads_v` int(11) NOT NULL,
  `accounting_v` int(11) NOT NULL,
  `settings_v` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

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

INSERT INTO `users` (`id`, `username`, `role`, `email`, `password`, `department`, `name`, `mobile`, `photo`, `block`, `c_date`, `last_login`, `ip_address`, `zipcode`, `location`, `address`, `level`, `orders_v`, `info_screens_v`, `rating_v`, `customers_v`, `suppliers_v`, `drivers_v`, `promo_codes_v`, `ads_v`, `accounting_v`, `settings_v`) VALUES
(1, 'admin', 1, 'admin@admin', '123', 0, '', '', '', 0, '1475111786', '', '', '705', 0, '', 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1),
(2, 'admin', 2, 'admin@admin', '1234', 0, 'admin2', '12345678890', '', 0, '1475111786', '', '', '705', 0, '', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1);

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`);
ALTER TABLE `users` ADD FULLTEXT KEY `mobile` (`mobile`);
ALTER TABLE `users` ADD FULLTEXT KEY `mobile_2` (`mobile`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `client_details`
--
ALTER TABLE `client_details`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;
COMMIT;

