text: -- phpMyAdmin SQL Dump
  -- version 4.7.3
  -- https://www.phpmyadmin.net/
  --
  -- Host: localhost:3306
  -- Generation Time: Feb 19, 2018 at 11:24 AM
  -- Server version: 5.6.37
  -- PHP Version: 5.6.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: `caworksi_pos_demos`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `categories`
  --
  
  CREATE TABLE `categories` (
    `id` int(11) NOT NULL,
    `name` varchar(50) NOT NULL,
    `created_at` varchar(200) DEFAULT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `categories`
  --
  
  INSERT INTO `categories` (`id`, `name`, `created_at`) VALUES
  (16, 'Beer ', '2017-12-14 15:47:48');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `categorie_expences`
  --
  
  CREATE TABLE `categorie_expences` (
    `id` int(11) NOT NULL,
    `name` varchar(100) NOT NULL,
    `created_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `categorie_expences`
  --
  
  INSERT INTO `categorie_expences` (`id`, `name`, `created_date`) VALUES
  (4, 'Traveller', '2017-12-14 10:26:05');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `combo_items`
  --
  
  CREATE TABLE `combo_items` (
    `id` int(11) NOT NULL,
    `product_id` int(11) NOT NULL,
    `item_id` int(11) NOT NULL,
    `quantity` int(11) NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `customers`
  --
  
  CREATE TABLE `customers` (
    `id` int(11) NOT NULL,
    `name` varchar(50) NOT NULL,
    `phone` varchar(30) DEFAULT NULL,
    `email` varchar(50) DEFAULT NULL,
    `discount` varchar(5) DEFAULT NULL,
    `created_at` varchar(150) DEFAULT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `customers`
  --
  
  INSERT INTO `customers` (`id`, `name`, `phone`, `email`, `discount`, `created_at`) VALUES
  (11, 'Joshua', '888888888', 'Fbook@fufu.com', '10', '2017-12-14 15:51:47');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `expences`
  --
  
  CREATE TABLE `expences` (
    `id` int(11) NOT NULL,
    `date` date NOT NULL,
    `reference` varchar(150) NOT NULL,
    `note` text,
    `amount` float NOT NULL,
    `attachment` varchar(200) DEFAULT NULL,
    `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `category_id` int(11) DEFAULT NULL,
    `store_id` int(11) DEFAULT NULL,
    `created_by` int(11) NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `expences`
  --
  
  INSERT INTO `expences` (`id`, `date`, `reference`, `note`, `amount`, `attachment`, `created_date`, `category_id`, `store_id`, `created_by`) VALUES
  (16, '2017-12-14', '123', '<p>Expense</p>', 110, '', '2017-12-14 10:26:49', 4, 1, 1);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `holds`
  --
  
  CREATE TABLE `holds` (
    `id` int(11) NOT NULL,
    `number` int(11) NOT NULL,
    `time` varchar(10) NOT NULL,
    `register_id` int(11) DEFAULT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `holds`
  --
  
  INSERT INTO `holds` (`id`, `number`, `time`, `register_id`) VALUES
  (190, 1, '11:21', 34);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `payements`
  --
  
  CREATE TABLE `payements` (
    `id` int(11) NOT NULL,
    `date` date NOT NULL,
    `paid` float NOT NULL,
    `paidmethod` varchar(300) CHARACTER SET latin1 NOT NULL,
    `created_by` varchar(60) CHARACTER SET latin1 NOT NULL,
    `register_id` int(11) NOT NULL,
    `sale_id` int(11) NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `posales`
  --
  
  CREATE TABLE `posales` (
    `id` int(11) NOT NULL,
    `product_id` int(11) NOT NULL,
    `name` varchar(200) NOT NULL,
    `price` float NOT NULL,
    `qt` int(6) NOT NULL,
    `status` tinyint(4) DEFAULT NULL,
    `register_id` int(11) DEFAULT NULL,
    `number` int(11) DEFAULT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `products`
  --
  
  CREATE TABLE `products` (
    `id` int(11) NOT NULL,
    `code` varchar(20) CHARACTER SET latin1 NOT NULL,
    `name` varchar(25) CHARACTER SET latin1 NOT NULL,
    `category` varchar(20) CHARACTER SET latin1 NOT NULL,
    `cost` float NOT NULL,
    `tax` varchar(11) CHARACTER SET latin1 DEFAULT NULL,
    `description` text CHARACTER SET latin1,
    `price` float NOT NULL,
    `photo` varchar(200) CHARACTER SET latin1 NOT NULL,
    `photothumb` varchar(500) CHARACTER SET latin1 DEFAULT NULL,
    `color` varchar(10) CHARACTER SET latin1 NOT NULL,
    `created_at` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
    `modified_at` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
    `type` tinyint(4) DEFAULT NULL,
    `alertqt` int(10) DEFAULT NULL,
    `supplier` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
    `unit` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
    `taxmethod` tinyint(4) DEFAULT NULL,
    `h_stores` varchar(300) CHARACTER SET latin1 DEFAULT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `products`
  --
  
  INSERT INTO `products` (`id`, `code`, `name`, `category`, `cost`, `tax`, `description`, `price`, `photo`, `photothumb`, `color`, `created_at`, `modified_at`, `type`, `alertqt`, `supplier`, `unit`, `taxmethod`, `h_stores`) VALUES
  (140, '001', 'Laptop', 'Elcectronic', 1000, '10', '<p>Dell Laptop.</p>', 1100, '', '', 'color01', '2017-12-14 15:49:09', '2017-12-14 15:49:08', 0, 1, 'Supplier', '123', 0, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `purchases`
  --
  
  CREATE TABLE `purchases` (
    `id` int(11) NOT NULL,
    `ref` varchar(11) CHARACTER SET latin1 NOT NULL,
    `date` date NOT NULL,
    `total` float DEFAULT NULL,
    `attachement` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
    `supplier_id` int(11) DEFAULT NULL,
    `status` tinyint(4) NOT NULL,
    `created_by` int(11) NOT NULL,
    `type` tinyint(4) NOT NULL,
    `store_id` int(11) DEFAULT NULL,
    `warehouse_id` int(11) DEFAULT NULL,
    `note` text CHARACTER SET latin1,
    `modified_at` varchar(50) CHARACTER SET latin1 DEFAULT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `purchase_items`
  --
  
  CREATE TABLE `purchase_items` (
    `id` int(11) NOT NULL,
    `purchase_id` int(11) NOT NULL,
    `product_id` int(11) NOT NULL,
    `qt` int(10) NOT NULL,
    `cost` float NOT NULL,
    `subtot` float NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `registers`
  --
  
  CREATE TABLE `registers` (
    `id` int(11) NOT NULL,
    `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `status` tinyint(4) NOT NULL,
    `user_id` int(11) NOT NULL,
    `cash_total` float DEFAULT NULL,
    `cash_sub` float DEFAULT NULL,
    `cc_total` float DEFAULT NULL,
    `cc_sub` float DEFAULT NULL,
    `cheque_total` float DEFAULT NULL,
    `cheque_sub` float DEFAULT NULL,
    `cash_inhand` float DEFAULT NULL,
    `note` text,
    `closed_at` varchar(150) DEFAULT NULL,
    `closed_by` int(11) DEFAULT NULL,
    `store_id` int(11) NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `registers`
  --
  
  INSERT INTO `registers` (`id`, `date`, `status`, `user_id`, `cash_total`, `cash_sub`, `cc_total`, `cc_sub`, `cheque_total`, `cheque_sub`, `cash_inhand`, `note`, `closed_at`, `closed_by`, `store_id`) VALUES
  (34, '2017-10-20 11:56:37', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, 200, NULL, NULL, NULL, 1);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `sales`
  --
  
  CREATE TABLE `sales` (
    `id` int(11) NOT NULL,
    `client_id` int(11) NOT NULL,
    `clientname` varchar(50) NOT NULL,
    `tax` varchar(5) DEFAULT NULL,
    `discount` varchar(5) DEFAULT NULL,
    `subtotal` varchar(15) NOT NULL,
    `total` float NOT NULL,
    `created_at` date NOT NULL,
    `modified_at` varchar(150) DEFAULT NULL,
    `status` tinyint(1) NOT NULL,
    `created_by` varchar(50) NOT NULL,
    `totalitems` int(20) NOT NULL,
    `paid` varchar(15) DEFAULT NULL,
    `paidmethod` varchar(700) DEFAULT NULL,
    `taxamount` float DEFAULT NULL,
    `discountamount` float DEFAULT NULL,
    `register_id` int(11) DEFAULT NULL,
    `firstpayement` float DEFAULT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `sale_items`
  --
  
  CREATE TABLE `sale_items` (
    `id` int(11) NOT NULL,
    `sale_id` int(11) NOT NULL,
    `product_id` int(11) NOT NULL,
    `name` varchar(200) NOT NULL,
    `price` float NOT NULL,
    `qt` int(6) NOT NULL,
    `subtotal` varchar(20) NOT NULL,
    `date` date DEFAULT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `settings`
  --
  
  CREATE TABLE `settings` (
    `id` int(11) NOT NULL,
    `companyname` varchar(100) NOT NULL,
    `logo` varchar(200) DEFAULT NULL,
    `phone` varchar(15) DEFAULT NULL,
    `currency` varchar(10) DEFAULT NULL,
    `keyboard` tinyint(1) NOT NULL,
    `receiptheader` text,
    `receiptfooter` text NOT NULL,
    `theme` varchar(20) NOT NULL,
    `discount` varchar(5) DEFAULT NULL,
    `tax` varchar(5) DEFAULT NULL,
    `timezone` varchar(400) DEFAULT NULL,
    `language` varchar(30) DEFAULT NULL,
    `stripe` tinyint(4) DEFAULT NULL,
    `stripe_secret_key` varchar(150) DEFAULT NULL,
    `stripe_publishable_key` varchar(150) DEFAULT NULL,
    `decimals` int(2) DEFAULT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `settings`
  --
  
  INSERT INTO `settings` (`id`, `companyname`, `logo`, `phone`, `currency`, `keyboard`, `receiptheader`, `receiptfooter`, `theme`, `discount`, `tax`, `timezone`, `language`, `stripe`, `stripe_secret_key`, `stripe_publishable_key`, `decimals`) VALUES
  (1, 'Demo', '5a0d57910a5951ef9e7d88acb7f79cd3.png', '13246598', 'USD', 1, '', 'Thank you for your business', 'Light', '', '12%', 'Asia/Kolkata', 'english', 0, '', '', 1);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `stocks`
  --
  
  CREATE TABLE `stocks` (
    `id` int(11) NOT NULL,
    `product_id` int(11) NOT NULL,
    `type` tinyint(4) DEFAULT NULL,
    `store_id` int(11) DEFAULT NULL,
    `warehouse_id` int(11) DEFAULT NULL,
    `quantity` int(10) DEFAULT NULL,
    `price` float DEFAULT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `stores`
  --
  
  CREATE TABLE `stores` (
    `id` int(11) NOT NULL,
    `name` varchar(40) NOT NULL,
    `email` varchar(40) DEFAULT NULL,
    `phone` varchar(40) DEFAULT NULL,
    `adresse` varchar(400) DEFAULT NULL,
    `footer_text` varchar(400) DEFAULT NULL,
    `city` varchar(20) DEFAULT NULL,
    `country` varchar(20) DEFAULT NULL,
    `created_at` varchar(200) NOT NULL,
    `status` tinyint(4) DEFAULT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `stores`
  --
  
  INSERT INTO `stores` (`id`, `name`, `email`, `phone`, `adresse`, `footer_text`, `city`, `country`, `created_at`, `status`) VALUES
  (1, 'Dar el web', 'default@store.com', '+12345678', 'adresse', 'Custome Footer for dal web store', 'zarzis', 'tunisia', '2016-05-10 12:44:33', 1);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `suppliers`
  --
  
  CREATE TABLE `suppliers` (
    `id` int(11) NOT NULL,
    `name` varchar(200) CHARACTER SET latin1 NOT NULL,
    `phone` varchar(15) CHARACTER SET latin1 DEFAULT NULL,
    `email` varchar(150) CHARACTER SET latin1 DEFAULT NULL,
    `note` text CHARACTER SET latin1,
    `created_at` varchar(150) CHARACTER SET latin1 NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `users`
  --
  
  CREATE TABLE `users` (
    `id` int(11) NOT NULL,
    `username` varchar(45) NOT NULL,
    `firstname` varchar(100) NOT NULL,
    `lastname` varchar(100) DEFAULT NULL,
    `hashed_password` varchar(128) NOT NULL,
    `email` varchar(60) DEFAULT NULL,
    `role` varchar(20) NOT NULL,
    `last_active` varchar(50) DEFAULT NULL,
    `avatar` varchar(200) DEFAULT NULL,
    `created_at` varchar(300) DEFAULT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `users`
  --
  
  INSERT INTO `users` (`id`, `username`, `firstname`, `lastname`, `hashed_password`, `email`, `role`, `last_active`, `avatar`, `created_at`) VALUES
  (1, 'admin', 'admin', 'Doe', '3a28999d3b2ff721964e04b9c3707219cce2bda3c882d74350d9961e053e4dd08148c314c7cb691ce918195c6f4e0c828ec139b336a8c4ea08c540221264b602', 'admin@admin.com', 'admin', '2017-12-24 12:27:29', '9fff9cc26e539214e9a5fd3b6a10cde9.jpg', '2017-10-20 15:27:00');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `variations`
  --
  
  CREATE TABLE `variations` (
    `id` int(11) NOT NULL,
    `item_id` int(11) NOT NULL,
    `price` float DEFAULT NULL,
    `quantity` int(11) DEFAULT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `warehouses`
  --
  
  CREATE TABLE `warehouses` (
    `id` int(11) NOT NULL,
    `name` varchar(100) CHARACTER SET latin1 NOT NULL,
    `phone` varchar(20) CHARACTER SET latin1 DEFAULT NULL,
    `email` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
    `adresse` varchar(400) CHARACTER SET latin1 DEFAULT NULL,
    `created_at` varchar(200) CHARACTER SET latin1 NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indexes for table `categories`
  --
  ALTER TABLE `categories`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `categorie_expences`
  --
  ALTER TABLE `categorie_expences`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `combo_items`
  --
  ALTER TABLE `combo_items`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `customers`
  --
  ALTER TABLE `customers`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `expences`
  --
  ALTER TABLE `expences`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `holds`
  --
  ALTER TABLE `holds`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `payements`
  --
  ALTER TABLE `payements`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `posales`
  --
  ALTER TABLE `posales`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `products`
  --
  ALTER TABLE `products`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `purchases`
  --
  ALTER TABLE `purchases`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `purchase_items`
  --
  ALTER TABLE `purchase_items`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `registers`
  --
  ALTER TABLE `registers`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `sales`
  --
  ALTER TABLE `sales`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `sale_items`
  --
  ALTER TABLE `sale_items`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `settings`
  --
  ALTER TABLE `settings`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `stocks`
  --
  ALTER TABLE `stocks`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `stores`
  --
  ALTER TABLE `stores`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `suppliers`
  --
  ALTER TABLE `suppliers`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `users`
  --
  ALTER TABLE `users`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `warehouses`
  --
  ALTER TABLE `warehouses`
    ADD PRIMARY KEY (`id`);
  
  --
  -- AUTO_INCREMENT for dumped tables
  --
  
  --
  -- AUTO_INCREMENT for table `categories`
  --
  ALTER TABLE `categories`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
  --
  -- AUTO_INCREMENT for table `categorie_expences`
  --
  ALTER TABLE `categorie_expences`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  --
  -- AUTO_INCREMENT for table `combo_items`
  --
  ALTER TABLE `combo_items`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;
  --
  -- AUTO_INCREMENT for table `customers`
  --
  ALTER TABLE `customers`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
  --
  -- AUTO_INCREMENT for table `expences`
  --
  ALTER TABLE `expences`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
  --
  -- AUTO_INCREMENT for table `holds`
  --
  ALTER TABLE `holds`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=191;
  --
  -- AUTO_INCREMENT for table `payements`
  --
  ALTER TABLE `payements`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;
  --
  -- AUTO_INCREMENT for table `posales`
  --
  ALTER TABLE `posales`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1428;
  --
  -- AUTO_INCREMENT for table `products`
  --
  ALTER TABLE `products`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=141;
  --
  -- AUTO_INCREMENT for table `purchases`
  --
  ALTER TABLE `purchases`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `purchase_items`
  --
  ALTER TABLE `purchase_items`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `registers`
  --
  ALTER TABLE `registers`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;
  --
  -- AUTO_INCREMENT for table `sales`
  --
  ALTER TABLE `sales`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;
  --
  -- AUTO_INCREMENT for table `sale_items`
  --
  ALTER TABLE `sale_items`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=977;
  --
  -- AUTO_INCREMENT for table `settings`
  --
  ALTER TABLE `settings`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  --
  -- AUTO_INCREMENT for table `stocks`
  --
  ALTER TABLE `stocks`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=60;
  --
  -- AUTO_INCREMENT for table `stores`
  --
  ALTER TABLE `stores`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  --
  -- AUTO_INCREMENT for table `suppliers`
  --
  ALTER TABLE `suppliers`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  --
  -- AUTO_INCREMENT for table `users`
  --
  ALTER TABLE `users`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
  --
  -- AUTO_INCREMENT for table `warehouses`
  --
  ALTER TABLE `warehouses`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;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 */;
  