text: -- --------------------------------------------------------
  -- Hôte:                         127.0.0.1
  -- Version du serveur:           5.7.33 - MySQL Community Server (GPL)
  -- SE du serveur:                Win64
  -- HeidiSQL Version:             11.2.0.6213
  -- --------------------------------------------------------
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET NAMES utf8 */;
  /*!50503 SET NAMES utf8mb4 */;
  /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  
  -- Listage de la structure de la table yovente. accounts
  CREATE TABLE IF NOT EXISTS `accounts` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `account_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `initial_balance` double DEFAULT NULL,
    `total_balance` double NOT NULL,
    `note` text COLLATE utf8mb4_unicode_ci,
    `is_default` tinyint(1) DEFAULT NULL,
    `is_active` tinyint(1) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.accounts : ~2 rows (environ)
  /*!40000 ALTER TABLE `accounts` DISABLE KEYS */;
  INSERT INTO `accounts` (`id`, `account_no`, `name`, `initial_balance`, `total_balance`, `note`, `is_default`, `is_active`, `created_at`, `updated_at`) VALUES
  	(1, 'Account-1', 'Comptabilité 1', NULL, 0, 'Fond de caisse initial', 1, 1, '2018-12-18 03:58:02', '2022-01-06 16:27:31'),
  	(3, '21211', 'Sa', NULL, 0, NULL, 0, 0, '2018-12-18 03:58:56', '2022-01-03 17:36:31');
  /*!40000 ALTER TABLE `accounts` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. adjustments
  CREATE TABLE IF NOT EXISTS `adjustments` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `reference_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `warehouse_id` int(11) NOT NULL,
    `document` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `total_qty` double NOT NULL,
    `item` int(11) NOT NULL,
    `note` text COLLATE utf8mb4_unicode_ci,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.adjustments : ~0 rows (environ)
  /*!40000 ALTER TABLE `adjustments` DISABLE KEYS */;
  /*!40000 ALTER TABLE `adjustments` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. attendances
  CREATE TABLE IF NOT EXISTS `attendances` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `date` date NOT NULL,
    `employee_id` int(11) NOT NULL,
    `user_id` int(11) NOT NULL,
    `checkin` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `checkout` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `status` int(11) NOT NULL,
    `note` text COLLATE utf8mb4_unicode_ci,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.attendances : ~0 rows (environ)
  /*!40000 ALTER TABLE `attendances` DISABLE KEYS */;
  /*!40000 ALTER TABLE `attendances` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. billers
  CREATE TABLE IF NOT EXISTS `billers` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `company_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `vat_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `phone_number` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `address` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `city` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `state` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `postal_code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `country` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `is_active` tinyint(1) DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.billers : ~0 rows (environ)
  /*!40000 ALTER TABLE `billers` DISABLE KEYS */;
  INSERT INTO `billers` (`id`, `name`, `image`, `company_name`, `vat_number`, `email`, `phone_number`, `address`, `city`, `state`, `postal_code`, `country`, `is_active`, `created_at`, `updated_at`) VALUES
  	(1, 'Yovente', 'YoventeSARL.png', 'Yovente S.A.R.L', NULL, 'yovente@yovente.com', '0622222222', 'Adresse Yovente', 'Benslimane', NULL, NULL, NULL, 1, '2022-01-07 22:33:14', '2022-01-07 22:33:14');
  /*!40000 ALTER TABLE `billers` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. brands
  CREATE TABLE IF NOT EXISTS `brands` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `is_active` tinyint(1) DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.brands : ~4 rows (environ)
  /*!40000 ALTER TABLE `brands` DISABLE KEYS */;
  INSERT INTO `brands` (`id`, `title`, `image`, `is_active`, `created_at`, `updated_at`) VALUES
  	(1, 'Çıkrıkçı', '20220107095635.jpg', 1, '2022-01-07 21:56:35', '2022-01-07 21:56:35'),
  	(2, 'Dilber', '20220107095651.jpg', 1, '2022-01-07 21:56:51', '2022-01-07 21:56:51'),
  	(3, 'Le Mirega', '20220107095703.jpg', 1, '2022-01-07 21:57:03', '2022-01-07 21:57:03'),
  	(4, 'Tubanur Özdemir', '20220107095716.jpg', 1, '2022-01-07 21:57:16', '2022-01-07 21:57:16');
  /*!40000 ALTER TABLE `brands` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. cash_registers
  CREATE TABLE IF NOT EXISTS `cash_registers` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `cash_in_hand` double NOT NULL,
    `user_id` int(11) NOT NULL,
    `warehouse_id` int(11) NOT NULL,
    `status` tinyint(1) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.cash_registers : ~3 rows (environ)
  /*!40000 ALTER TABLE `cash_registers` DISABLE KEYS */;
  INSERT INTO `cash_registers` (`id`, `cash_in_hand`, `user_id`, `warehouse_id`, `status`, `created_at`, `updated_at`) VALUES
  	(1, 0, 1, 1, 1, '2022-01-08 13:42:44', '2022-01-08 13:42:44'),
  	(2, 0, 23, 1, 1, '2022-01-16 00:40:24', '2022-01-16 00:40:24'),
  	(3, 0, 1, 2, 1, '2022-01-30 23:15:03', '2022-01-30 23:15:03');
  /*!40000 ALTER TABLE `cash_registers` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. categories
  CREATE TABLE IF NOT EXISTS `categories` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `parent_id` int(11) DEFAULT NULL,
    `is_active` tinyint(1) DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.categories : ~3 rows (environ)
  /*!40000 ALTER TABLE `categories` DISABLE KEYS */;
  INSERT INTO `categories` (`id`, `name`, `image`, `parent_id`, `is_active`, `created_at`, `updated_at`) VALUES
  	(1, 'Ensemble', '20220107104119.jpg', NULL, 1, '2022-01-07 22:41:19', '2022-01-07 22:41:19'),
  	(2, 'Robe Hijab', '20220107104130.jpg', NULL, 1, '2022-01-07 22:41:30', '2022-01-07 22:41:30'),
  	(3, 'Tunique', '20220107104142.jpg', NULL, 1, '2022-01-07 22:41:42', '2022-01-07 22:41:42');
  /*!40000 ALTER TABLE `categories` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. coupons
  CREATE TABLE IF NOT EXISTS `coupons` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `amount` double NOT NULL,
    `minimum_amount` double DEFAULT NULL,
    `quantity` int(11) NOT NULL,
    `used` int(11) NOT NULL,
    `expired_date` date NOT NULL,
    `user_id` int(11) NOT NULL,
    `is_active` tinyint(1) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.coupons : ~0 rows (environ)
  /*!40000 ALTER TABLE `coupons` DISABLE KEYS */;
  /*!40000 ALTER TABLE `coupons` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. currencies
  CREATE TABLE IF NOT EXISTS `currencies` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `exchange_rate` double NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.currencies : ~0 rows (environ)
  /*!40000 ALTER TABLE `currencies` DISABLE KEYS */;
  INSERT INTO `currencies` (`id`, `name`, `code`, `exchange_rate`, `created_at`, `updated_at`) VALUES
  	(2, 'Dirham', 'DHS', 1, '2020-11-01 02:29:12', '2022-01-02 16:06:53');
  /*!40000 ALTER TABLE `currencies` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. customers
  CREATE TABLE IF NOT EXISTS `customers` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `customer_group_id` int(11) NOT NULL,
    `user_id` int(11) DEFAULT NULL,
    `created_by` int(11) NOT NULL,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `company_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `phone_number` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `tax_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `address` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `city` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `state` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `postal_code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `country` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `deposit` double DEFAULT NULL,
    `expense` double DEFAULT NULL,
    `is_active` tinyint(1) DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.customers : ~4 rows (environ)
  /*!40000 ALTER TABLE `customers` DISABLE KEYS */;
  INSERT INTO `customers` (`id`, `customer_group_id`, `user_id`, `created_by`, `name`, `company_name`, `email`, `phone_number`, `tax_no`, `address`, `city`, `state`, `postal_code`, `country`, `deposit`, `expense`, `is_active`, `created_at`, `updated_at`) VALUES
  	(1, 1, 24, 1, 'Salma BOUKJIJ', 'Salma Company', 'salma@yovente.com', '0611111111', NULL, 'Adresse Salma BOUKJIJ', 'Benslimane', NULL, NULL, NULL, NULL, NULL, 1, '2022-01-07 22:01:16', '2022-01-15 21:13:17'),
  	(2, 1, 25, 1, 'Rim BOUKJIJ', 'Rim Company', 'rim@yovente.com', '0622222222', NULL, 'Adresse Salma BOUKJIJ', 'Benslimane', NULL, NULL, NULL, NULL, NULL, 1, '2022-01-30 19:58:16', '2022-01-30 19:58:16'),
  	(3, 1, NULL, 23, 'Faty BOUKJIJ', 'Faty Company', 'faty@yovente.com', '0699999999', NULL, 'Adresse Faty BOUKJIJ', 'Benslimane', NULL, NULL, NULL, NULL, NULL, 1, '2022-01-31 11:20:09', '2022-01-31 11:21:56'),
  	(4, 1, NULL, 23, 'Tarik BOUKJIJ', 'Tarik Company', 'tarik@yovente.com', '0700000000', NULL, 'Adresse Tarik BOUKJIJ', 'Meknès', NULL, NULL, NULL, NULL, NULL, 1, '2022-02-02 11:20:05', '2022-02-02 11:23:58');
  /*!40000 ALTER TABLE `customers` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. customer_groups
  CREATE TABLE IF NOT EXISTS `customer_groups` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `percentage` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `is_active` tinyint(1) DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.customer_groups : ~0 rows (environ)
  /*!40000 ALTER TABLE `customer_groups` DISABLE KEYS */;
  INSERT INTO `customer_groups` (`id`, `name`, `percentage`, `is_active`, `created_at`, `updated_at`) VALUES
  	(1, 'Global', '0', 1, '2022-01-07 21:55:51', '2022-01-07 21:55:51');
  /*!40000 ALTER TABLE `customer_groups` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. deliveries
  CREATE TABLE IF NOT EXISTS `deliveries` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `reference_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `sale_id` int(11) NOT NULL,
    `user_id` int(11) DEFAULT NULL,
    `sold_by` int(11) DEFAULT NULL,
    `address` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `packing` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `pickup` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `delivering` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `delivered` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `delivered_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `recieved_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `file` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `note` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.deliveries : ~0 rows (environ)
  /*!40000 ALTER TABLE `deliveries` DISABLE KEYS */;
  /*!40000 ALTER TABLE `deliveries` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. departments
  CREATE TABLE IF NOT EXISTS `departments` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `is_active` tinyint(1) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.departments : ~0 rows (environ)
  /*!40000 ALTER TABLE `departments` DISABLE KEYS */;
  /*!40000 ALTER TABLE `departments` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. deposits
  CREATE TABLE IF NOT EXISTS `deposits` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `amount` double NOT NULL,
    `customer_id` int(11) NOT NULL,
    `user_id` int(11) NOT NULL,
    `note` text COLLATE utf8mb4_unicode_ci,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.deposits : ~0 rows (environ)
  /*!40000 ALTER TABLE `deposits` DISABLE KEYS */;
  /*!40000 ALTER TABLE `deposits` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. employees
  CREATE TABLE IF NOT EXISTS `employees` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `phone_number` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `department_id` int(11) NOT NULL,
    `user_id` int(11) DEFAULT NULL,
    `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `city` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `country` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `is_active` tinyint(1) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.employees : ~0 rows (environ)
  /*!40000 ALTER TABLE `employees` DISABLE KEYS */;
  /*!40000 ALTER TABLE `employees` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. expenses
  CREATE TABLE IF NOT EXISTS `expenses` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `reference_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `expense_category_id` int(11) NOT NULL,
    `warehouse_id` int(11) NOT NULL,
    `account_id` int(11) NOT NULL,
    `user_id` int(11) NOT NULL,
    `cash_register_id` int(11) DEFAULT NULL,
    `amount` double NOT NULL,
    `note` text COLLATE utf8mb4_unicode_ci,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.expenses : ~0 rows (environ)
  /*!40000 ALTER TABLE `expenses` DISABLE KEYS */;
  INSERT INTO `expenses` (`id`, `reference_no`, `expense_category_id`, `warehouse_id`, `account_id`, `user_id`, `cash_register_id`, `amount`, `note`, `created_at`, `updated_at`) VALUES
  	(1, 'er-20220203-103830', 1, 2, 1, 1, 3, 200, NULL, '2022-02-03 10:38:30', '2022-02-03 10:38:30');
  /*!40000 ALTER TABLE `expenses` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. expense_categories
  CREATE TABLE IF NOT EXISTS `expense_categories` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `is_active` tinyint(1) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.expense_categories : ~0 rows (environ)
  /*!40000 ALTER TABLE `expense_categories` DISABLE KEYS */;
  INSERT INTO `expense_categories` (`id`, `code`, `name`, `is_active`, `created_at`, `updated_at`) VALUES
  	(1, '69089410', 'Carburant', 1, '2022-02-03 10:38:05', '2022-02-03 10:38:05');
  /*!40000 ALTER TABLE `expense_categories` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. failed_jobs
  CREATE TABLE IF NOT EXISTS `failed_jobs` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
    `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
    `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.failed_jobs : ~0 rows (environ)
  /*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */;
  /*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. general_settings
  CREATE TABLE IF NOT EXISTS `general_settings` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `site_title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `site_logo` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `currency` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `livraison` int(11) NOT NULL,
    `min_withdraw` int(11) NOT NULL,
    `staff_access` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `date_format` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `developed_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `invoice_format` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `state` int(11) DEFAULT NULL,
    `theme` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `currency_position` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.general_settings : ~0 rows (environ)
  /*!40000 ALTER TABLE `general_settings` DISABLE KEYS */;
  INSERT INTO `general_settings` (`id`, `site_title`, `site_logo`, `currency`, `livraison`, `min_withdraw`, `staff_access`, `date_format`, `developed_by`, `invoice_format`, `state`, `theme`, `created_at`, `updated_at`, `currency_position`) VALUES
  	(1, 'YoVente', '20220102040718.png', '2', 50, 500, 'own', 'd-m-Y', 'T@R!K', 'standard', 1, 'default.css', '2018-07-06 07:13:11', '2022-02-03 09:55:59', 'suffix');
  /*!40000 ALTER TABLE `general_settings` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. gift_cards
  CREATE TABLE IF NOT EXISTS `gift_cards` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `card_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `amount` double NOT NULL,
    `expense` double NOT NULL,
    `customer_id` int(11) DEFAULT NULL,
    `user_id` int(11) DEFAULT NULL,
    `expired_date` date DEFAULT NULL,
    `created_by` int(11) NOT NULL,
    `is_active` tinyint(1) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.gift_cards : ~0 rows (environ)
  /*!40000 ALTER TABLE `gift_cards` DISABLE KEYS */;
  /*!40000 ALTER TABLE `gift_cards` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. gift_card_recharges
  CREATE TABLE IF NOT EXISTS `gift_card_recharges` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `gift_card_id` int(11) NOT NULL,
    `amount` double NOT NULL,
    `user_id` int(11) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.gift_card_recharges : ~0 rows (environ)
  /*!40000 ALTER TABLE `gift_card_recharges` DISABLE KEYS */;
  /*!40000 ALTER TABLE `gift_card_recharges` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. holidays
  CREATE TABLE IF NOT EXISTS `holidays` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `user_id` int(11) NOT NULL,
    `from_date` date NOT NULL,
    `to_date` date NOT NULL,
    `note` text COLLATE utf8mb4_unicode_ci,
    `is_approved` tinyint(1) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.holidays : ~0 rows (environ)
  /*!40000 ALTER TABLE `holidays` DISABLE KEYS */;
  /*!40000 ALTER TABLE `holidays` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. hrm_settings
  CREATE TABLE IF NOT EXISTS `hrm_settings` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `checkin` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `checkout` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.hrm_settings : ~0 rows (environ)
  /*!40000 ALTER TABLE `hrm_settings` DISABLE KEYS */;
  /*!40000 ALTER TABLE `hrm_settings` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. languages
  CREATE TABLE IF NOT EXISTS `languages` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.languages : ~0 rows (environ)
  /*!40000 ALTER TABLE `languages` DISABLE KEYS */;
  INSERT INTO `languages` (`id`, `code`, `created_at`, `updated_at`) VALUES
  	(1, 'en', '2018-07-07 23:59:17', '2019-12-24 18:34:20');
  /*!40000 ALTER TABLE `languages` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. migrations
  CREATE TABLE IF NOT EXISTS `migrations` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `batch` int(11) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=154 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.migrations : ~130 rows (environ)
  /*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
  INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
  	(1, '2014_10_12_000000_create_users_table', 1),
  	(2, '2014_10_12_100000_create_password_resets_table', 1),
  	(3, '2018_02_17_060412_create_categories_table', 1),
  	(4, '2018_02_20_035727_create_brands_table', 1),
  	(5, '2018_02_25_100635_create_suppliers_table', 1),
  	(6, '2018_02_27_101619_create_warehouse_table', 1),
  	(7, '2018_03_03_040448_create_units_table', 1),
  	(8, '2018_03_04_041317_create_taxes_table', 1),
  	(9, '2018_03_10_061915_create_customer_groups_table', 1),
  	(10, '2018_03_10_090534_create_customers_table', 1),
  	(11, '2018_03_11_095547_create_billers_table', 1),
  	(12, '2018_04_05_054401_create_products_table', 1),
  	(13, '2018_04_06_133606_create_purchases_table', 1),
  	(14, '2018_04_06_154600_create_product_purchases_table', 1),
  	(15, '2018_04_06_154915_create_product_warhouse_table', 1),
  	(16, '2018_04_10_085927_create_sales_table', 1),
  	(17, '2018_04_10_090133_create_product_sales_table', 1),
  	(18, '2018_04_10_090254_create_payments_table', 1),
  	(19, '2018_04_10_090341_create_payment_with_cheque_table', 1),
  	(20, '2018_04_10_090509_create_payment_with_credit_card_table', 1),
  	(21, '2018_04_13_121436_create_quotation_table', 1),
  	(22, '2018_04_13_122324_create_product_quotation_table', 1),
  	(23, '2018_04_14_121802_create_transfers_table', 1),
  	(24, '2018_04_14_121913_create_product_transfer_table', 1),
  	(25, '2018_05_13_082847_add_payment_id_and_change_sale_id_to_payments_table', 2),
  	(26, '2018_05_13_090906_change_customer_id_to_payment_with_credit_card_table', 3),
  	(27, '2018_05_20_054532_create_adjustments_table', 4),
  	(28, '2018_05_20_054859_create_product_adjustments_table', 4),
  	(29, '2018_05_21_163419_create_returns_table', 5),
  	(30, '2018_05_21_163443_create_product_returns_table', 5),
  	(31, '2018_06_02_050905_create_roles_table', 6),
  	(32, '2018_06_02_073430_add_columns_to_users_table', 7),
  	(33, '2018_06_03_053738_create_permission_tables', 8),
  	(36, '2018_06_21_063736_create_pos_setting_table', 9),
  	(37, '2018_06_21_094155_add_user_id_to_sales_table', 10),
  	(38, '2018_06_21_101529_add_user_id_to_purchases_table', 11),
  	(39, '2018_06_21_103512_add_user_id_to_transfers_table', 12),
  	(40, '2018_06_23_061058_add_user_id_to_quotations_table', 13),
  	(41, '2018_06_23_082427_add_is_deleted_to_users_table', 14),
  	(42, '2018_06_25_043308_change_email_to_users_table', 15),
  	(43, '2018_07_06_115449_create_general_settings_table', 16),
  	(44, '2018_07_08_043944_create_languages_table', 17),
  	(45, '2018_07_11_102144_add_user_id_to_returns_table', 18),
  	(46, '2018_07_11_102334_add_user_id_to_payments_table', 18),
  	(47, '2018_07_22_130541_add_digital_to_products_table', 19),
  	(49, '2018_07_24_154250_create_deliveries_table', 20),
  	(50, '2018_08_16_053336_create_expense_categories_table', 21),
  	(51, '2018_08_17_115415_create_expenses_table', 22),
  	(55, '2018_08_18_050418_create_gift_cards_table', 23),
  	(56, '2018_08_19_063119_create_payment_with_gift_card_table', 24),
  	(57, '2018_08_25_042333_create_gift_card_recharges_table', 25),
  	(58, '2018_08_25_101354_add_deposit_expense_to_customers_table', 26),
  	(59, '2018_08_26_043801_create_deposits_table', 27),
  	(60, '2018_09_02_044042_add_keybord_active_to_pos_setting_table', 28),
  	(61, '2018_09_09_092713_create_payment_with_paypal_table', 29),
  	(62, '2018_09_10_051254_add_currency_to_general_settings_table', 30),
  	(63, '2018_10_22_084118_add_biller_and_store_id_to_users_table', 31),
  	(65, '2018_10_26_034927_create_coupons_table', 32),
  	(66, '2018_10_27_090857_add_coupon_to_sales_table', 33),
  	(67, '2018_11_07_070155_add_currency_position_to_general_settings_table', 34),
  	(68, '2018_11_19_094650_add_combo_to_products_table', 35),
  	(69, '2018_12_09_043712_create_accounts_table', 36),
  	(70, '2018_12_17_112253_add_is_default_to_accounts_table', 37),
  	(71, '2018_12_19_103941_add_account_id_to_payments_table', 38),
  	(72, '2018_12_20_065900_add_account_id_to_expenses_table', 39),
  	(73, '2018_12_20_082753_add_account_id_to_returns_table', 40),
  	(74, '2018_12_26_064330_create_return_purchases_table', 41),
  	(75, '2018_12_26_144210_create_purchase_product_return_table', 42),
  	(76, '2018_12_26_144708_create_purchase_product_return_table', 43),
  	(77, '2018_12_27_110018_create_departments_table', 44),
  	(78, '2018_12_30_054844_create_employees_table', 45),
  	(79, '2018_12_31_125210_create_payrolls_table', 46),
  	(80, '2018_12_31_150446_add_department_id_to_employees_table', 47),
  	(81, '2019_01_01_062708_add_user_id_to_expenses_table', 48),
  	(82, '2019_01_02_075644_create_hrm_settings_table', 49),
  	(83, '2019_01_02_090334_create_attendances_table', 50),
  	(84, '2019_01_27_160956_add_three_columns_to_general_settings_table', 51),
  	(85, '2019_02_15_183303_create_stock_counts_table', 52),
  	(86, '2019_02_17_101604_add_is_adjusted_to_stock_counts_table', 53),
  	(87, '2019_04_13_101707_add_tax_no_to_customers_table', 54),
  	(89, '2019_10_14_111455_create_holidays_table', 55),
  	(90, '2019_11_13_145619_add_is_variant_to_products_table', 56),
  	(91, '2019_11_13_150206_create_product_variants_table', 57),
  	(92, '2019_11_13_153828_create_variants_table', 57),
  	(93, '2019_11_25_134041_add_qty_to_product_variants_table', 58),
  	(94, '2019_11_25_134922_add_variant_id_to_product_purchases_table', 58),
  	(95, '2019_11_25_145341_add_variant_id_to_product_warehouse_table', 58),
  	(96, '2019_11_29_182201_add_variant_id_to_product_sales_table', 59),
  	(97, '2019_12_04_121311_add_variant_id_to_product_quotation_table', 60),
  	(98, '2019_12_05_123802_add_variant_id_to_product_transfer_table', 61),
  	(100, '2019_12_08_114954_add_variant_id_to_product_returns_table', 62),
  	(101, '2019_12_08_203146_add_variant_id_to_purchase_product_return_table', 63),
  	(102, '2020_02_28_103340_create_money_transfers_table', 64),
  	(103, '2020_07_01_193151_add_image_to_categories_table', 65),
  	(105, '2020_09_26_130426_add_user_id_to_deliveries_table', 66),
  	(107, '2020_10_11_125457_create_cash_registers_table', 67),
  	(108, '2020_10_13_155019_add_cash_register_id_to_sales_table', 68),
  	(109, '2020_10_13_172624_add_cash_register_id_to_returns_table', 69),
  	(110, '2020_10_17_212338_add_cash_register_id_to_payments_table', 70),
  	(111, '2020_10_18_124200_add_cash_register_id_to_expenses_table', 71),
  	(112, '2020_10_21_121632_add_developed_by_to_general_settings_table', 72),
  	(113, '2019_08_19_000000_create_failed_jobs_table', 73),
  	(114, '2020_10_30_135557_create_notifications_table', 73),
  	(115, '2020_11_01_044954_create_currencies_table', 74),
  	(116, '2020_11_01_140736_add_price_to_product_warehouse_table', 75),
  	(117, '2020_11_02_050633_add_is_diff_price_to_products_table', 76),
  	(118, '2020_11_09_055222_add_user_id_to_customers_table', 77),
  	(119, '2020_11_17_054806_add_invoice_format_to_general_settings_table', 78),
  	(120, '2021_02_10_074859_add_variant_id_to_product_adjustments_table', 79),
  	(121, '2021_03_07_093606_create_product_batches_table', 80),
  	(122, '2021_03_07_093759_add_product_batch_id_to_product_warehouse_table', 80),
  	(123, '2021_03_07_093900_add_product_batch_id_to_product_purchases_table', 80),
  	(124, '2021_03_11_132603_add_product_batch_id_to_product_sales_table', 81),
  	(127, '2021_03_25_125421_add_is_batch_to_products_table', 82),
  	(128, '2021_05_19_120127_add_product_batch_id_to_product_returns_table', 82),
  	(130, '2021_05_22_105611_add_product_batch_id_to_purchase_product_return_table', 83),
  	(131, '2021_05_23_124848_add_product_batch_id_to_product_transfer_table', 84),
  	(132, '2021_05_26_153106_add_product_batch_id_to_product_quotation_table', 85),
  	(134, '2022_01_03_205841_add_livraison_to_general_settings_table', 86),
  	(135, '2022_01_06_181753_add_livraison_to_sales_table', 87),
  	(136, '2022_01_06_182916_add_original_price_to_product_sales_table', 88),
  	(142, '2022_01_16_181335_add_packing_delivering_delivered_to_deliveries_table', 89),
  	(143, '2022_01_31_113821_add_fullname_to_users_table', 90),
  	(144, '2022_02_02_095123_add_bank_settings_to_users_table', 91),
  	(146, '2022_02_02_105659_add_created_by_to_customers_table', 92),
  	(148, '2022_02_03_093218_add_min_withdraw_to_general_settings_table', 93),
  	(149, '2022_02_03_101436_create_withdraws_table', 94),
  	(150, '2022_02_04_174247_rename_withdraws_table', 95),
  	(152, '2022_02_04_212528_add_is_paid_to_withdrawals_table', 96),
  	(153, '2022_02_09_202841_add_is_valide_to_sales_table', 97);
  /*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. money_transfers
  CREATE TABLE IF NOT EXISTS `money_transfers` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `reference_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `from_account_id` int(11) NOT NULL,
    `to_account_id` int(11) NOT NULL,
    `amount` double NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.money_transfers : ~0 rows (environ)
  /*!40000 ALTER TABLE `money_transfers` DISABLE KEYS */;
  /*!40000 ALTER TABLE `money_transfers` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. notifications
  CREATE TABLE IF NOT EXISTS `notifications` (
    `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
    `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `notifiable_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `notifiable_id` bigint(20) unsigned NOT NULL,
    `data` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `read_at` timestamp NULL DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `notifications_notifiable_type_notifiable_id_index` (`notifiable_type`,`notifiable_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.notifications : ~0 rows (environ)
  /*!40000 ALTER TABLE `notifications` DISABLE KEYS */;
  /*!40000 ALTER TABLE `notifications` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. password_resets
  CREATE TABLE IF NOT EXISTS `password_resets` (
    `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    KEY `password_resets_email_index` (`email`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.password_resets : ~0 rows (environ)
  /*!40000 ALTER TABLE `password_resets` DISABLE KEYS */;
  /*!40000 ALTER TABLE `password_resets` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. payments
  CREATE TABLE IF NOT EXISTS `payments` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `payment_reference` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `user_id` int(11) NOT NULL,
    `purchase_id` int(11) DEFAULT NULL,
    `sale_id` int(11) DEFAULT NULL,
    `cash_register_id` int(11) DEFAULT NULL,
    `account_id` int(11) DEFAULT NULL,
    `amount` double NOT NULL,
    `change` double NOT NULL,
    `paying_method` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `payment_note` text COLLATE utf8mb4_unicode_ci,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.payments : ~2 rows (environ)
  /*!40000 ALTER TABLE `payments` DISABLE KEYS */;
  INSERT INTO `payments` (`id`, `payment_reference`, `user_id`, `purchase_id`, `sale_id`, `cash_register_id`, `account_id`, `amount`, `change`, `paying_method`, `payment_note`, `created_at`, `updated_at`) VALUES
  	(1, 'ppr-20220107-113448', 1, 1, NULL, NULL, 1, 1750, 0, 'Cash', NULL, '2022-01-07 23:34:48', '2022-01-07 23:34:48'),
  	(2, 'ppr-20220108-013940', 1, 2, NULL, NULL, 1, 3600, 0, 'Cash', NULL, '2022-01-08 13:39:40', '2022-01-08 13:39:40');
  /*!40000 ALTER TABLE `payments` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. payment_with_cheque
  CREATE TABLE IF NOT EXISTS `payment_with_cheque` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `payment_id` int(11) NOT NULL,
    `cheque_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.payment_with_cheque : ~0 rows (environ)
  /*!40000 ALTER TABLE `payment_with_cheque` DISABLE KEYS */;
  /*!40000 ALTER TABLE `payment_with_cheque` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. payment_with_credit_card
  CREATE TABLE IF NOT EXISTS `payment_with_credit_card` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `payment_id` int(11) NOT NULL,
    `customer_id` int(11) DEFAULT NULL,
    `customer_stripe_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `charge_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.payment_with_credit_card : ~0 rows (environ)
  /*!40000 ALTER TABLE `payment_with_credit_card` DISABLE KEYS */;
  /*!40000 ALTER TABLE `payment_with_credit_card` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. payment_with_gift_card
  CREATE TABLE IF NOT EXISTS `payment_with_gift_card` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `payment_id` int(11) NOT NULL,
    `gift_card_id` int(11) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.payment_with_gift_card : ~0 rows (environ)
  /*!40000 ALTER TABLE `payment_with_gift_card` DISABLE KEYS */;
  /*!40000 ALTER TABLE `payment_with_gift_card` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. payment_with_paypal
  CREATE TABLE IF NOT EXISTS `payment_with_paypal` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `payment_id` int(11) NOT NULL,
    `transaction_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.payment_with_paypal : ~0 rows (environ)
  /*!40000 ALTER TABLE `payment_with_paypal` DISABLE KEYS */;
  /*!40000 ALTER TABLE `payment_with_paypal` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. payrolls
  CREATE TABLE IF NOT EXISTS `payrolls` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `reference_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `employee_id` int(11) NOT NULL,
    `account_id` int(11) NOT NULL,
    `user_id` int(11) NOT NULL,
    `amount` double NOT NULL,
    `paying_method` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `note` text COLLATE utf8mb4_unicode_ci,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.payrolls : ~0 rows (environ)
  /*!40000 ALTER TABLE `payrolls` DISABLE KEYS */;
  /*!40000 ALTER TABLE `payrolls` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. permissions
  CREATE TABLE IF NOT EXISTS `permissions` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `guard_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=109 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.permissions : ~105 rows (environ)
  /*!40000 ALTER TABLE `permissions` DISABLE KEYS */;
  INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
  	(4, 'products-edit', 'web', '2018-06-03 02:00:09', '2018-06-03 02:00:09'),
  	(5, 'products-delete', 'web', '2018-06-03 23:54:22', '2018-06-03 23:54:22'),
  	(6, 'products-add', 'web', '2018-06-04 01:34:14', '2018-06-04 01:34:14'),
  	(7, 'products-index', 'web', '2018-06-04 04:34:27', '2018-06-04 04:34:27'),
  	(8, 'purchases-index', 'web', '2018-06-04 09:03:19', '2018-06-04 09:03:19'),
  	(9, 'purchases-add', 'web', '2018-06-04 09:12:25', '2018-06-04 09:12:25'),
  	(10, 'purchases-edit', 'web', '2018-06-04 10:47:36', '2018-06-04 10:47:36'),
  	(11, 'purchases-delete', 'web', '2018-06-04 10:47:36', '2018-06-04 10:47:36'),
  	(12, 'sales-index', 'web', '2018-06-04 11:49:08', '2018-06-04 11:49:08'),
  	(13, 'sales-add', 'web', '2018-06-04 11:49:52', '2018-06-04 11:49:52'),
  	(14, 'sales-edit', 'web', '2018-06-04 11:49:52', '2018-06-04 11:49:52'),
  	(15, 'sales-delete', 'web', '2018-06-04 11:49:53', '2018-06-04 11:49:53'),
  	(16, 'quotes-index', 'web', '2018-06-04 23:05:10', '2018-06-04 23:05:10'),
  	(17, 'quotes-add', 'web', '2018-06-04 23:05:10', '2018-06-04 23:05:10'),
  	(18, 'quotes-edit', 'web', '2018-06-04 23:05:10', '2018-06-04 23:05:10'),
  	(19, 'quotes-delete', 'web', '2018-06-04 23:05:10', '2018-06-04 23:05:10'),
  	(20, 'transfers-index', 'web', '2018-06-04 23:30:03', '2018-06-04 23:30:03'),
  	(21, 'transfers-add', 'web', '2018-06-04 23:30:03', '2018-06-04 23:30:03'),
  	(22, 'transfers-edit', 'web', '2018-06-04 23:30:03', '2018-06-04 23:30:03'),
  	(23, 'transfers-delete', 'web', '2018-06-04 23:30:03', '2018-06-04 23:30:03'),
  	(24, 'returns-index', 'web', '2018-06-04 23:50:24', '2018-06-04 23:50:24'),
  	(25, 'returns-add', 'web', '2018-06-04 23:50:24', '2018-06-04 23:50:24'),
  	(26, 'returns-edit', 'web', '2018-06-04 23:50:25', '2018-06-04 23:50:25'),
  	(27, 'returns-delete', 'web', '2018-06-04 23:50:25', '2018-06-04 23:50:25'),
  	(28, 'customers-index', 'web', '2018-06-05 00:15:54', '2018-06-05 00:15:54'),
  	(29, 'customers-add', 'web', '2018-06-05 00:15:55', '2018-06-05 00:15:55'),
  	(30, 'customers-edit', 'web', '2018-06-05 00:15:55', '2018-06-05 00:15:55'),
  	(31, 'customers-delete', 'web', '2018-06-05 00:15:55', '2018-06-05 00:15:55'),
  	(32, 'suppliers-index', 'web', '2018-06-05 00:40:12', '2018-06-05 00:40:12'),
  	(33, 'suppliers-add', 'web', '2018-06-05 00:40:12', '2018-06-05 00:40:12'),
  	(34, 'suppliers-edit', 'web', '2018-06-05 00:40:12', '2018-06-05 00:40:12'),
  	(35, 'suppliers-delete', 'web', '2018-06-05 00:40:12', '2018-06-05 00:40:12'),
  	(36, 'product-report', 'web', '2018-06-25 00:05:33', '2018-06-25 00:05:33'),
  	(37, 'purchase-report', 'web', '2018-06-25 00:24:56', '2018-06-25 00:24:56'),
  	(38, 'sale-report', 'web', '2018-06-25 00:33:13', '2018-06-25 00:33:13'),
  	(39, 'customer-report', 'web', '2018-06-25 00:36:51', '2018-06-25 00:36:51'),
  	(40, 'due-report', 'web', '2018-06-25 00:39:52', '2018-06-25 00:39:52'),
  	(41, 'users-index', 'web', '2018-06-25 01:00:10', '2018-06-25 01:00:10'),
  	(42, 'users-add', 'web', '2018-06-25 01:00:10', '2018-06-25 01:00:10'),
  	(43, 'users-edit', 'web', '2018-06-25 01:01:30', '2018-06-25 01:01:30'),
  	(44, 'users-delete', 'web', '2018-06-25 01:01:30', '2018-06-25 01:01:30'),
  	(45, 'profit-loss', 'web', '2018-07-14 22:50:05', '2018-07-14 22:50:05'),
  	(46, 'best-seller', 'web', '2018-07-14 23:01:38', '2018-07-14 23:01:38'),
  	(47, 'daily-sale', 'web', '2018-07-14 23:24:21', '2018-07-14 23:24:21'),
  	(48, 'monthly-sale', 'web', '2018-07-14 23:30:41', '2018-07-14 23:30:41'),
  	(49, 'daily-purchase', 'web', '2018-07-14 23:36:46', '2018-07-14 23:36:46'),
  	(50, 'monthly-purchase', 'web', '2018-07-14 23:48:17', '2018-07-14 23:48:17'),
  	(51, 'payment-report', 'web', '2018-07-15 00:10:41', '2018-07-15 00:10:41'),
  	(52, 'warehouse-stock-report', 'web', '2018-07-15 00:16:55', '2018-07-15 00:16:55'),
  	(53, 'product-qty-alert', 'web', '2018-07-15 00:33:21', '2018-07-15 00:33:21'),
  	(54, 'supplier-report', 'web', '2018-07-30 04:00:01', '2018-07-30 04:00:01'),
  	(55, 'expenses-index', 'web', '2018-09-05 02:07:10', '2018-09-05 02:07:10'),
  	(56, 'expenses-add', 'web', '2018-09-05 02:07:10', '2018-09-05 02:07:10'),
  	(57, 'expenses-edit', 'web', '2018-09-05 02:07:10', '2018-09-05 02:07:10'),
  	(58, 'expenses-delete', 'web', '2018-09-05 02:07:11', '2018-09-05 02:07:11'),
  	(59, 'general_setting', 'web', '2018-10-20 00:10:04', '2018-10-20 00:10:04'),
  	(60, 'mail_setting', 'web', '2018-10-20 00:10:04', '2018-10-20 00:10:04'),
  	(61, 'pos_setting', 'web', '2018-10-20 00:10:04', '2018-10-20 00:10:04'),
  	(62, 'hrm_setting', 'web', '2019-01-02 11:30:23', '2019-01-02 11:30:23'),
  	(63, 'purchase-return-index', 'web', '2019-01-02 22:45:14', '2019-01-02 22:45:14'),
  	(64, 'purchase-return-add', 'web', '2019-01-02 22:45:14', '2019-01-02 22:45:14'),
  	(65, 'purchase-return-edit', 'web', '2019-01-02 22:45:14', '2019-01-02 22:45:14'),
  	(66, 'purchase-return-delete', 'web', '2019-01-02 22:45:14', '2019-01-02 22:45:14'),
  	(67, 'account-index', 'web', '2019-01-02 23:06:13', '2019-01-02 23:06:13'),
  	(68, 'balance-sheet', 'web', '2019-01-02 23:06:14', '2019-01-02 23:06:14'),
  	(69, 'account-statement', 'web', '2019-01-02 23:06:14', '2019-01-02 23:06:14'),
  	(70, 'department', 'web', '2019-01-02 23:30:01', '2019-01-02 23:30:01'),
  	(71, 'attendance', 'web', '2019-01-02 23:30:01', '2019-01-02 23:30:01'),
  	(72, 'payroll', 'web', '2019-01-02 23:30:01', '2019-01-02 23:30:01'),
  	(73, 'employees-index', 'web', '2019-01-02 23:52:19', '2019-01-02 23:52:19'),
  	(74, 'employees-add', 'web', '2019-01-02 23:52:19', '2019-01-02 23:52:19'),
  	(75, 'employees-edit', 'web', '2019-01-02 23:52:19', '2019-01-02 23:52:19'),
  	(76, 'employees-delete', 'web', '2019-01-02 23:52:19', '2019-01-02 23:52:19'),
  	(77, 'user-report', 'web', '2019-01-16 07:48:18', '2019-01-16 07:48:18'),
  	(78, 'stock_count', 'web', '2019-02-17 11:32:01', '2019-02-17 11:32:01'),
  	(79, 'adjustment', 'web', '2019-02-17 11:32:02', '2019-02-17 11:32:02'),
  	(80, 'sms_setting', 'web', '2019-02-22 06:18:03', '2019-02-22 06:18:03'),
  	(81, 'create_sms', 'web', '2019-02-22 06:18:03', '2019-02-22 06:18:03'),
  	(82, 'print_barcode', 'web', '2019-03-07 06:02:19', '2019-03-07 06:02:19'),
  	(83, 'empty_database', 'web', '2019-03-07 06:02:19', '2019-03-07 06:02:19'),
  	(84, 'customer_group', 'web', '2019-03-07 06:37:15', '2019-03-07 06:37:15'),
  	(85, 'unit', 'web', '2019-03-07 06:37:15', '2019-03-07 06:37:15'),
  	(86, 'tax', 'web', '2019-03-07 06:37:15', '2019-03-07 06:37:15'),
  	(87, 'gift_card', 'web', '2019-03-07 07:29:38', '2019-03-07 07:29:38'),
  	(88, 'coupon', 'web', '2019-03-07 07:29:38', '2019-03-07 07:29:38'),
  	(89, 'holiday', 'web', '2019-10-19 09:57:15', '2019-10-19 09:57:15'),
  	(90, 'warehouse-report', 'web', '2019-10-22 07:00:23', '2019-10-22 07:00:23'),
  	(91, 'warehouse', 'web', '2020-02-26 07:47:32', '2020-02-26 07:47:32'),
  	(92, 'brand', 'web', '2020-02-26 07:59:59', '2020-02-26 07:59:59'),
  	(93, 'billers-index', 'web', '2020-02-26 08:11:15', '2020-02-26 08:11:15'),
  	(94, 'billers-add', 'web', '2020-02-26 08:11:15', '2020-02-26 08:11:15'),
  	(95, 'billers-edit', 'web', '2020-02-26 08:11:15', '2020-02-26 08:11:15'),
  	(96, 'billers-delete', 'web', '2020-02-26 08:11:15', '2020-02-26 08:11:15'),
  	(97, 'money-transfer', 'web', '2020-03-02 06:41:48', '2020-03-02 06:41:48'),
  	(98, 'category', 'web', '2020-07-13 13:13:16', '2020-07-13 13:13:16'),
  	(99, 'delivery', 'web', '2020-07-13 13:13:16', '2020-07-13 13:13:16'),
  	(100, 'send_notification', 'web', '2020-10-31 07:21:31', '2020-10-31 07:21:31'),
  	(101, 'today_sale', 'web', '2020-10-31 07:57:04', '2020-10-31 07:57:04'),
  	(102, 'today_profit', 'web', '2020-10-31 07:57:04', '2020-10-31 07:57:04'),
  	(103, 'currency', 'web', '2020-11-09 01:23:11', '2020-11-09 01:23:11'),
  	(104, 'backup_database', 'web', '2020-11-15 01:16:55', '2020-11-15 01:16:55'),
  	(105, 'withdraw-add', 'web', '2022-02-03 10:10:47', '2022-02-03 10:10:49'),
  	(106, 'withdraw-edit', 'web', '2022-02-03 10:10:51', '2022-02-03 10:10:52'),
  	(107, 'withdraw-index', 'web', '2022-02-03 10:11:09', '2022-02-03 10:11:11'),
  	(108, 'withdraw-delete', 'web', '2022-02-03 10:11:26', '2022-02-03 10:11:27');
  /*!40000 ALTER TABLE `permissions` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. pos_setting
  CREATE TABLE IF NOT EXISTS `pos_setting` (
    `id` int(11) NOT NULL,
    `customer_id` int(11) NOT NULL,
    `warehouse_id` int(11) NOT NULL,
    `biller_id` int(11) NOT NULL,
    `product_number` int(11) NOT NULL,
    `keybord_active` tinyint(1) NOT NULL,
    `stripe_public_key` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `stripe_secret_key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    UNIQUE KEY `pos_setting_id_unique` (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.pos_setting : ~0 rows (environ)
  /*!40000 ALTER TABLE `pos_setting` DISABLE KEYS */;
  INSERT INTO `pos_setting` (`id`, `customer_id`, `warehouse_id`, `biller_id`, `product_number`, `keybord_active`, `stripe_public_key`, `stripe_secret_key`, `created_at`, `updated_at`) VALUES
  	(1, 1, 1, 1, 3, 1, 'Stripe_Publishable_key', 'Stripe_Secret_key', '2022-01-07 23:32:23', '2022-01-07 23:32:23');
  /*!40000 ALTER TABLE `pos_setting` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. products
  CREATE TABLE IF NOT EXISTS `products` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `barcode_symbology` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `brand_id` int(11) DEFAULT NULL,
    `category_id` int(11) NOT NULL,
    `unit_id` int(11) NOT NULL,
    `purchase_unit_id` int(11) NOT NULL,
    `sale_unit_id` int(11) NOT NULL,
    `cost` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `price` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `qty` double DEFAULT NULL,
    `alert_quantity` double DEFAULT NULL,
    `promotion` tinyint(4) DEFAULT NULL,
    `promotion_price` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `starting_date` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `last_date` date DEFAULT NULL,
    `tax_id` int(11) DEFAULT NULL,
    `tax_method` int(11) DEFAULT NULL,
    `image` longtext COLLATE utf8mb4_unicode_ci,
    `file` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `is_variant` tinyint(1) DEFAULT NULL,
    `is_batch` tinyint(1) DEFAULT NULL,
    `is_diffPrice` tinyint(1) DEFAULT NULL,
    `featured` tinyint(4) DEFAULT NULL,
    `product_list` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `qty_list` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `price_list` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `product_details` text COLLATE utf8mb4_unicode_ci,
    `is_active` tinyint(1) DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.products : ~2 rows (environ)
  /*!40000 ALTER TABLE `products` DISABLE KEYS */;
  INSERT INTO `products` (`id`, `name`, `code`, `type`, `barcode_symbology`, `brand_id`, `category_id`, `unit_id`, `purchase_unit_id`, `sale_unit_id`, `cost`, `price`, `qty`, `alert_quantity`, `promotion`, `promotion_price`, `starting_date`, `last_date`, `tax_id`, `tax_method`, `image`, `file`, `is_variant`, `is_batch`, `is_diffPrice`, `featured`, `product_list`, `qty_list`, `price_list`, `product_details`, `is_active`, `created_at`, `updated_at`) VALUES
  	(1, 'Product 1 Tunique', 'P-22-546', 'standard', 'C39', 4, 3, 1, 1, 1, '70', '150', 19, 10, NULL, NULL, NULL, NULL, NULL, NULL, '1641591753620robe-hijab-1.jpg,1641591753623robe-hijab-1-1.jpg', NULL, 1, NULL, 0, 0, NULL, NULL, NULL, '<p>Product Details Goes here !</p>', 1, '2022-01-07 22:42:53', '2022-02-08 21:34:00'),
  	(2, 'Product 2 Tunique', 'P-22-582', 'standard', 'C39', 2, 3, 1, 1, 1, '90', '190', 28, 10, NULL, NULL, NULL, NULL, NULL, NULL, '1641648820537z-desenliwebp.jpg', NULL, 1, NULL, 0, 0, NULL, NULL, NULL, '<p>Product Details Goes here !</p>', 1, '2022-01-08 13:34:13', '2022-02-09 22:28:11');
  /*!40000 ALTER TABLE `products` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. product_adjustments
  CREATE TABLE IF NOT EXISTS `product_adjustments` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `adjustment_id` int(11) NOT NULL,
    `product_id` int(11) NOT NULL,
    `variant_id` int(11) DEFAULT NULL,
    `qty` double NOT NULL,
    `action` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.product_adjustments : ~0 rows (environ)
  /*!40000 ALTER TABLE `product_adjustments` DISABLE KEYS */;
  /*!40000 ALTER TABLE `product_adjustments` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. product_batches
  CREATE TABLE IF NOT EXISTS `product_batches` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `product_id` int(11) NOT NULL,
    `batch_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `expired_date` date NOT NULL,
    `qty` double NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.product_batches : ~0 rows (environ)
  /*!40000 ALTER TABLE `product_batches` DISABLE KEYS */;
  /*!40000 ALTER TABLE `product_batches` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. product_purchases
  CREATE TABLE IF NOT EXISTS `product_purchases` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `purchase_id` int(11) NOT NULL,
    `product_id` int(11) NOT NULL,
    `product_batch_id` int(11) DEFAULT NULL,
    `variant_id` int(11) DEFAULT NULL,
    `qty` double NOT NULL,
    `recieved` double NOT NULL,
    `purchase_unit_id` int(11) NOT NULL,
    `net_unit_cost` double NOT NULL,
    `discount` double NOT NULL,
    `tax_rate` double NOT NULL,
    `tax` double NOT NULL,
    `total` double NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.product_purchases : ~6 rows (environ)
  /*!40000 ALTER TABLE `product_purchases` DISABLE KEYS */;
  INSERT INTO `product_purchases` (`id`, `purchase_id`, `product_id`, `product_batch_id`, `variant_id`, `qty`, `recieved`, `purchase_unit_id`, `net_unit_cost`, `discount`, `tax_rate`, `tax`, `total`, `created_at`, `updated_at`) VALUES
  	(1, 1, 1, NULL, 3, 5, 5, 1, 70, 0, 0, 0, 350, '2022-01-07 23:33:32', '2022-01-07 23:33:32'),
  	(2, 1, 1, NULL, 1, 10, 10, 1, 70, 0, 0, 0, 700, '2022-01-07 23:33:32', '2022-01-07 23:33:32'),
  	(3, 1, 1, NULL, 5, 10, 10, 1, 70, 0, 0, 0, 700, '2022-01-07 23:33:32', '2022-01-07 23:33:32'),
  	(19, 2, 2, NULL, 2, 10, 10, 1, 90, 0, 0, 0, 900, '2022-01-31 00:20:59', '2022-01-31 00:20:59'),
  	(20, 2, 2, NULL, 1, 15, 15, 1, 90, 0, 0, 0, 1350, '2022-01-31 00:20:59', '2022-01-31 00:20:59'),
  	(21, 2, 2, NULL, 5, 15, 15, 1, 90, 0, 0, 0, 1350, '2022-01-31 00:20:59', '2022-01-31 00:20:59');
  /*!40000 ALTER TABLE `product_purchases` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. product_quotation
  CREATE TABLE IF NOT EXISTS `product_quotation` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `quotation_id` int(11) NOT NULL,
    `product_id` int(11) NOT NULL,
    `product_batch_id` int(11) DEFAULT NULL,
    `variant_id` int(11) DEFAULT NULL,
    `qty` double NOT NULL,
    `sale_unit_id` int(11) NOT NULL,
    `net_unit_price` double NOT NULL,
    `discount` double NOT NULL,
    `tax_rate` double NOT NULL,
    `tax` double NOT NULL,
    `total` double NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.product_quotation : ~0 rows (environ)
  /*!40000 ALTER TABLE `product_quotation` DISABLE KEYS */;
  /*!40000 ALTER TABLE `product_quotation` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. product_returns
  CREATE TABLE IF NOT EXISTS `product_returns` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `return_id` int(11) NOT NULL,
    `product_id` int(11) NOT NULL,
    `product_batch_id` int(11) DEFAULT NULL,
    `variant_id` int(11) DEFAULT NULL,
    `qty` double NOT NULL,
    `sale_unit_id` int(11) NOT NULL,
    `net_unit_price` double NOT NULL,
    `discount` double NOT NULL,
    `tax_rate` double NOT NULL,
    `tax` double NOT NULL,
    `total` double NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.product_returns : ~0 rows (environ)
  /*!40000 ALTER TABLE `product_returns` DISABLE KEYS */;
  /*!40000 ALTER TABLE `product_returns` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. product_sales
  CREATE TABLE IF NOT EXISTS `product_sales` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `sale_id` int(11) NOT NULL,
    `product_id` int(11) NOT NULL,
    `product_batch_id` int(11) DEFAULT NULL,
    `variant_id` int(11) DEFAULT NULL,
    `qty` double NOT NULL,
    `sale_unit_id` int(11) NOT NULL,
    `net_unit_price` double NOT NULL,
    `original_price` double NOT NULL,
    `discount` double NOT NULL,
    `tax_rate` double NOT NULL,
    `tax` double NOT NULL,
    `total` double NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.product_sales : ~14 rows (environ)
  /*!40000 ALTER TABLE `product_sales` DISABLE KEYS */;
  INSERT INTO `product_sales` (`id`, `sale_id`, `product_id`, `product_batch_id`, `variant_id`, `qty`, `sale_unit_id`, `net_unit_price`, `original_price`, `discount`, `tax_rate`, `tax`, `total`, `created_at`, `updated_at`) VALUES
  	(1, 1, 2, NULL, 1, 1, 1, 330, 190, 0, 0, 0, 330, '2022-02-08 20:51:43', '2022-02-08 21:02:52'),
  	(2, 2, 2, NULL, 2, 1, 1, 300, 190, 0, 0, 0, 300, '2022-02-08 21:02:16', '2022-02-08 21:02:16'),
  	(3, 2, 2, NULL, 5, 2, 1, 350, 190, 0, 0, 0, 700, '2022-02-08 21:02:16', '2022-02-08 21:02:16'),
  	(4, 1, 2, NULL, 5, 1, 1, 370, 190, 0, 0, 0, 370, '2022-02-08 21:02:52', '2022-02-08 21:02:52'),
  	(5, 3, 2, NULL, 1, 1, 1, 350, 190, 0, 0, 0, 350, '2022-02-08 21:21:55', '2022-02-08 21:21:55'),
  	(7, 5, 1, NULL, 1, 2, 1, 300, 150, 0, 0, 0, 600, '2022-02-08 21:29:20', '2022-02-08 21:29:20'),
  	(8, 5, 2, NULL, 1, 1, 1, 350, 190, 0, 0, 0, 350, '2022-02-08 21:29:20', '2022-02-08 21:29:20'),
  	(9, 6, 1, NULL, 1, 1, 1, 300, 150, 0, 0, 0, 300, '2022-02-08 21:34:00', '2022-02-08 21:34:00'),
  	(10, 6, 1, NULL, 5, 1, 1, 300, 150, 0, 0, 0, 300, '2022-02-08 21:34:00', '2022-02-08 21:34:00'),
  	(11, 6, 2, NULL, 5, 1, 1, 350, 190, 0, 0, 0, 350, '2022-02-08 21:34:00', '2022-02-08 21:34:00'),
  	(12, 7, 2, NULL, 1, 1, 1, 290, 190, 0, 0, 0, 290, '2022-02-09 20:56:18', '2022-02-09 20:56:18'),
  	(13, 8, 2, NULL, 2, 1, 1, 480, 190, 0, 0, 0, 480, '2022-02-09 21:02:20', '2022-02-09 22:24:37'),
  	(14, 9, 2, NULL, 2, 1, 1, 400, 190, 0, 0, 0, 400, '2022-02-09 21:11:21', '2022-02-09 21:11:21'),
  	(15, 10, 2, NULL, 5, 1, 1, 500, 190, 0, 0, 0, 500, '2022-02-09 22:28:11', '2022-02-09 22:28:11');
  /*!40000 ALTER TABLE `product_sales` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. product_transfer
  CREATE TABLE IF NOT EXISTS `product_transfer` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `transfer_id` int(11) NOT NULL,
    `product_id` int(11) NOT NULL,
    `product_batch_id` int(11) DEFAULT NULL,
    `variant_id` int(11) DEFAULT NULL,
    `qty` double NOT NULL,
    `purchase_unit_id` int(11) NOT NULL,
    `net_unit_cost` double NOT NULL,
    `tax_rate` double NOT NULL,
    `tax` double NOT NULL,
    `total` double NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.product_transfer : ~0 rows (environ)
  /*!40000 ALTER TABLE `product_transfer` DISABLE KEYS */;
  /*!40000 ALTER TABLE `product_transfer` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. product_variants
  CREATE TABLE IF NOT EXISTS `product_variants` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `product_id` int(11) NOT NULL,
    `variant_id` int(11) NOT NULL,
    `position` int(11) NOT NULL,
    `item_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `additional_price` double DEFAULT NULL,
    `qty` double NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.product_variants : ~6 rows (environ)
  /*!40000 ALTER TABLE `product_variants` DISABLE KEYS */;
  INSERT INTO `product_variants` (`id`, `product_id`, `variant_id`, `position`, `item_code`, `additional_price`, `qty`, `created_at`, `updated_at`) VALUES
  	(9, 1, 1, 2, 'XL-P-22-546', NULL, 5, '2022-01-07 23:26:22', '2022-02-08 21:34:00'),
  	(10, 1, 5, 1, 'XXL-P-22-546', NULL, 9, '2022-01-07 23:26:22', '2022-02-08 21:34:00'),
  	(11, 1, 3, 3, 'M-P-22-546', NULL, 5, '2022-01-07 23:26:22', '2022-02-06 17:34:28'),
  	(12, 2, 5, 1, 'XXL-P-22-582', NULL, 10, '2022-01-08 13:34:13', '2022-02-09 22:28:11'),
  	(13, 2, 1, 2, 'XL-P-22-582', NULL, 11, '2022-01-08 13:34:13', '2022-02-09 20:56:18'),
  	(14, 2, 2, 3, 'L-P-22-582', NULL, 7, '2022-01-08 13:34:13', '2022-02-09 22:24:37');
  /*!40000 ALTER TABLE `product_variants` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. product_warehouse
  CREATE TABLE IF NOT EXISTS `product_warehouse` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `product_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `product_batch_id` int(11) DEFAULT NULL,
    `variant_id` int(11) DEFAULT NULL,
    `warehouse_id` int(11) NOT NULL,
    `qty` double NOT NULL,
    `price` double DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.product_warehouse : ~9 rows (environ)
  /*!40000 ALTER TABLE `product_warehouse` DISABLE KEYS */;
  INSERT INTO `product_warehouse` (`id`, `product_id`, `product_batch_id`, `variant_id`, `warehouse_id`, `qty`, `price`, `created_at`, `updated_at`) VALUES
  	(1, '1', NULL, 3, 1, 5, NULL, '2022-01-07 23:33:32', '2022-02-06 17:34:28'),
  	(2, '1', NULL, 1, 1, 7, NULL, '2022-01-07 23:33:32', '2022-02-08 21:34:00'),
  	(3, '1', NULL, 5, 1, 9, NULL, '2022-01-07 23:33:32', '2022-02-08 21:34:00'),
  	(7, '2', NULL, 2, 2, 7, NULL, '2022-01-31 00:07:19', '2022-02-09 22:24:37'),
  	(8, '2', NULL, 1, 2, 12, NULL, '2022-01-31 00:07:20', '2022-02-09 20:56:18'),
  	(9, '2', NULL, 5, 2, 11, NULL, '2022-01-31 00:07:20', '2022-02-09 22:28:11'),
  	(10, '2', NULL, 2, 1, 0, NULL, '2022-01-31 00:20:37', '2022-01-31 01:28:54'),
  	(11, '2', NULL, 1, 1, -1, NULL, '2022-01-31 00:20:37', '2022-02-08 21:29:20'),
  	(12, '2', NULL, 5, 1, -1, NULL, '2022-01-31 00:20:38', '2022-02-08 21:34:00');
  /*!40000 ALTER TABLE `product_warehouse` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. purchases
  CREATE TABLE IF NOT EXISTS `purchases` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `reference_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `user_id` int(11) NOT NULL,
    `warehouse_id` int(11) NOT NULL,
    `supplier_id` int(11) DEFAULT NULL,
    `item` int(11) NOT NULL,
    `total_qty` double NOT NULL,
    `total_discount` double NOT NULL,
    `total_tax` double NOT NULL,
    `total_cost` double NOT NULL,
    `order_tax_rate` double DEFAULT NULL,
    `order_tax` double DEFAULT NULL,
    `order_discount` double DEFAULT NULL,
    `shipping_cost` double DEFAULT NULL,
    `grand_total` double NOT NULL,
    `paid_amount` double NOT NULL,
    `status` int(11) NOT NULL,
    `payment_status` int(11) NOT NULL,
    `document` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `note` text COLLATE utf8mb4_unicode_ci,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.purchases : ~2 rows (environ)
  /*!40000 ALTER TABLE `purchases` DISABLE KEYS */;
  INSERT INTO `purchases` (`id`, `reference_no`, `user_id`, `warehouse_id`, `supplier_id`, `item`, `total_qty`, `total_discount`, `total_tax`, `total_cost`, `order_tax_rate`, `order_tax`, `order_discount`, `shipping_cost`, `grand_total`, `paid_amount`, `status`, `payment_status`, `document`, `note`, `created_at`, `updated_at`) VALUES
  	(1, 'pr-20220107-113331', 1, 1, 1, 3, 25, 0, 0, 1750, 0, 0, NULL, NULL, 1750, 1750, 1, 2, NULL, NULL, '2022-01-07 23:33:31', '2022-01-07 23:34:48'),
  	(2, 'pr-20220108-013922', 1, 2, 1, 3, 40, 0, 0, 3600, 0, 0, 0, 0, 3600, 3600, 1, 2, NULL, NULL, '2022-01-08 13:39:22', '2022-01-31 00:20:59');
  /*!40000 ALTER TABLE `purchases` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. purchase_product_return
  CREATE TABLE IF NOT EXISTS `purchase_product_return` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `return_id` int(11) NOT NULL,
    `product_id` int(11) NOT NULL,
    `product_batch_id` int(11) DEFAULT NULL,
    `variant_id` int(11) DEFAULT NULL,
    `qty` double NOT NULL,
    `purchase_unit_id` int(11) NOT NULL,
    `net_unit_cost` double NOT NULL,
    `discount` double NOT NULL,
    `tax_rate` double NOT NULL,
    `tax` double NOT NULL,
    `total` double NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.purchase_product_return : ~0 rows (environ)
  /*!40000 ALTER TABLE `purchase_product_return` DISABLE KEYS */;
  /*!40000 ALTER TABLE `purchase_product_return` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. quotations
  CREATE TABLE IF NOT EXISTS `quotations` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `reference_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `user_id` int(11) NOT NULL,
    `biller_id` int(11) NOT NULL,
    `supplier_id` int(11) DEFAULT NULL,
    `customer_id` int(11) NOT NULL,
    `warehouse_id` int(11) NOT NULL,
    `item` int(11) NOT NULL,
    `total_qty` double NOT NULL,
    `total_discount` double NOT NULL,
    `total_tax` double NOT NULL,
    `total_price` double NOT NULL,
    `order_tax_rate` double DEFAULT NULL,
    `order_tax` double DEFAULT NULL,
    `order_discount` double DEFAULT NULL,
    `shipping_cost` double DEFAULT NULL,
    `grand_total` double NOT NULL,
    `quotation_status` int(11) NOT NULL,
    `document` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `note` text COLLATE utf8mb4_unicode_ci,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.quotations : ~0 rows (environ)
  /*!40000 ALTER TABLE `quotations` DISABLE KEYS */;
  /*!40000 ALTER TABLE `quotations` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. returns
  CREATE TABLE IF NOT EXISTS `returns` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `reference_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `user_id` int(11) NOT NULL,
    `cash_register_id` int(11) DEFAULT NULL,
    `customer_id` int(11) NOT NULL,
    `warehouse_id` int(11) NOT NULL,
    `biller_id` int(11) NOT NULL,
    `account_id` int(11) NOT NULL,
    `item` int(11) NOT NULL,
    `total_qty` double NOT NULL,
    `total_discount` double NOT NULL,
    `total_tax` double NOT NULL,
    `total_price` double NOT NULL,
    `order_tax_rate` double DEFAULT NULL,
    `order_tax` double DEFAULT NULL,
    `grand_total` double NOT NULL,
    `document` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `return_note` text COLLATE utf8mb4_unicode_ci,
    `staff_note` text COLLATE utf8mb4_unicode_ci,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.returns : ~0 rows (environ)
  /*!40000 ALTER TABLE `returns` DISABLE KEYS */;
  /*!40000 ALTER TABLE `returns` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. return_purchases
  CREATE TABLE IF NOT EXISTS `return_purchases` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `reference_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `supplier_id` int(11) DEFAULT NULL,
    `warehouse_id` int(11) NOT NULL,
    `user_id` int(11) NOT NULL,
    `account_id` int(11) NOT NULL,
    `item` int(11) NOT NULL,
    `total_qty` double NOT NULL,
    `total_discount` double NOT NULL,
    `total_tax` double NOT NULL,
    `total_cost` double NOT NULL,
    `order_tax_rate` double DEFAULT NULL,
    `order_tax` double DEFAULT NULL,
    `grand_total` double NOT NULL,
    `document` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `return_note` text COLLATE utf8mb4_unicode_ci,
    `staff_note` text COLLATE utf8mb4_unicode_ci,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.return_purchases : ~0 rows (environ)
  /*!40000 ALTER TABLE `return_purchases` DISABLE KEYS */;
  /*!40000 ALTER TABLE `return_purchases` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. roles
  CREATE TABLE IF NOT EXISTS `roles` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `description` text COLLATE utf8mb4_unicode_ci,
    `guard_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `is_active` tinyint(1) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.roles : ~3 rows (environ)
  /*!40000 ALTER TABLE `roles` DISABLE KEYS */;
  INSERT INTO `roles` (`id`, `name`, `description`, `guard_name`, `is_active`, `created_at`, `updated_at`) VALUES
  	(1, 'Admin', 'Administrateur du système', 'web', 1, '2018-06-02 00:46:44', '2022-01-07 21:39:04'),
  	(4, 'Vendeur', 'Rôle Vendeur', 'web', 1, '2018-06-02 01:05:27', '2022-01-07 21:38:33'),
  	(5, 'Client', 'Rôle Client', 'web', 1, '2020-11-05 07:43:16', '2022-01-07 21:38:48');
  /*!40000 ALTER TABLE `roles` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. role_has_permissions
  CREATE TABLE IF NOT EXISTS `role_has_permissions` (
    `permission_id` int(10) unsigned NOT NULL,
    `role_id` int(10) unsigned NOT NULL,
    PRIMARY KEY (`permission_id`,`role_id`),
    KEY `role_has_permissions_role_id_foreign` (`role_id`),
    CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
    CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.role_has_permissions : ~99 rows (environ)
  /*!40000 ALTER TABLE `role_has_permissions` DISABLE KEYS */;
  INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
  	(4, 1),
  	(5, 1),
  	(6, 1),
  	(7, 1),
  	(8, 1),
  	(9, 1),
  	(10, 1),
  	(11, 1),
  	(12, 1),
  	(13, 1),
  	(14, 1),
  	(15, 1),
  	(24, 1),
  	(25, 1),
  	(26, 1),
  	(27, 1),
  	(28, 1),
  	(29, 1),
  	(30, 1),
  	(31, 1),
  	(32, 1),
  	(33, 1),
  	(34, 1),
  	(35, 1),
  	(36, 1),
  	(37, 1),
  	(38, 1),
  	(39, 1),
  	(40, 1),
  	(41, 1),
  	(42, 1),
  	(43, 1),
  	(44, 1),
  	(45, 1),
  	(46, 1),
  	(47, 1),
  	(48, 1),
  	(49, 1),
  	(50, 1),
  	(51, 1),
  	(52, 1),
  	(53, 1),
  	(54, 1),
  	(55, 1),
  	(56, 1),
  	(57, 1),
  	(58, 1),
  	(59, 1),
  	(60, 1),
  	(61, 1),
  	(62, 1),
  	(63, 1),
  	(64, 1),
  	(65, 1),
  	(66, 1),
  	(67, 1),
  	(69, 1),
  	(77, 1),
  	(78, 1),
  	(79, 1),
  	(80, 1),
  	(81, 1),
  	(82, 1),
  	(83, 1),
  	(84, 1),
  	(85, 1),
  	(86, 1),
  	(87, 1),
  	(88, 1),
  	(90, 1),
  	(91, 1),
  	(92, 1),
  	(93, 1),
  	(94, 1),
  	(95, 1),
  	(96, 1),
  	(98, 1),
  	(99, 1),
  	(100, 1),
  	(101, 1),
  	(102, 1),
  	(103, 1),
  	(104, 1),
  	(105, 1),
  	(106, 1),
  	(107, 1),
  	(108, 1),
  	(7, 4),
  	(12, 4),
  	(13, 4),
  	(14, 4),
  	(24, 4),
  	(28, 4),
  	(29, 4),
  	(30, 4),
  	(99, 4),
  	(105, 4),
  	(106, 4),
  	(107, 4);
  /*!40000 ALTER TABLE `role_has_permissions` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. sales
  CREATE TABLE IF NOT EXISTS `sales` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `reference_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `user_id` int(11) NOT NULL,
    `cash_register_id` int(11) DEFAULT NULL,
    `customer_id` int(11) NOT NULL,
    `warehouse_id` int(11) NOT NULL,
    `biller_id` int(11) DEFAULT NULL,
    `item` int(11) NOT NULL,
    `total_qty` double NOT NULL,
    `total_discount` double NOT NULL,
    `total_tax` double NOT NULL,
    `total_price` double NOT NULL,
    `livraison` int(11) NOT NULL,
    `grand_total` double NOT NULL,
    `order_tax_rate` double DEFAULT NULL,
    `order_tax` double DEFAULT NULL,
    `order_discount` double DEFAULT NULL,
    `coupon_id` int(11) DEFAULT NULL,
    `coupon_discount` double DEFAULT NULL,
    `shipping_cost` double DEFAULT NULL,
    `sale_status` int(11) NOT NULL,
    `payment_status` int(11) NOT NULL,
    `is_valide` tinyint(1) DEFAULT NULL,
    `document` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `paid_amount` double DEFAULT NULL,
    `sale_note` text COLLATE utf8mb4_unicode_ci,
    `staff_note` text COLLATE utf8mb4_unicode_ci,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.sales : ~9 rows (environ)
  /*!40000 ALTER TABLE `sales` DISABLE KEYS */;
  INSERT INTO `sales` (`id`, `reference_no`, `user_id`, `cash_register_id`, `customer_id`, `warehouse_id`, `biller_id`, `item`, `total_qty`, `total_discount`, `total_tax`, `total_price`, `livraison`, `grand_total`, `order_tax_rate`, `order_tax`, `order_discount`, `coupon_id`, `coupon_discount`, `shipping_cost`, `sale_status`, `payment_status`, `is_valide`, `document`, `paid_amount`, `sale_note`, `staff_note`, `created_at`, `updated_at`) VALUES
  	(1, 'vendeur-220208-205126', 23, NULL, 4, 2, 1, 2, 2, 0, 0, 700, 50, 700, 0, 0, 0, NULL, NULL, 0, 1, 2, 0, NULL, NULL, NULL, NULL, '2022-02-08 20:51:43', '2022-02-08 21:02:52'),
  	(2, 'tarik-220208-204935', 1, 3, 1, 2, 1, 2, 3, 0, 0, 1000, 0, 1000, 0, 0, NULL, NULL, NULL, NULL, 1, 2, 0, NULL, NULL, NULL, NULL, '2022-02-08 21:02:16', '2022-02-08 21:02:16'),
  	(3, 'vendeur-220208-212109', 23, NULL, 4, 2, 1, 2, 2, 0, 0, 650, 50, 650, 0, 0, NULL, NULL, NULL, NULL, 1, 2, 0, NULL, NULL, NULL, NULL, '2022-02-08 21:21:55', '2022-02-08 21:21:55'),
  	(5, 'vendeur-220208-212834', 23, 2, 3, 1, 1, 2, 3, 0, 0, 950, 50, 950, 0, 0, NULL, NULL, NULL, NULL, 1, 2, 1, NULL, NULL, NULL, NULL, '2022-02-08 21:29:20', '2022-02-08 21:29:20'),
  	(6, 'tarik-220208-213320', 1, 1, 1, 1, 1, 3, 3, 0, 0, 950, 0, 950, 0, 0, NULL, NULL, NULL, NULL, 1, 2, 0, NULL, NULL, NULL, NULL, '2022-02-08 21:34:00', '2022-02-08 21:34:00'),
  	(7, 'vendeur-220209-205553', 23, NULL, 3, 2, 1, 1, 1, 0, 0, 290, 50, 290, 0, 0, NULL, NULL, NULL, NULL, 1, 2, 0, NULL, NULL, NULL, NULL, '2022-02-09 20:56:18', '2022-02-09 20:56:18'),
  	(8, 'vendeur-220209-210104', 23, NULL, 3, 2, 1, 1, 1, 0, 0, 480, 50, 480, 0, 0, 0, NULL, NULL, 0, 1, 2, 1, NULL, NULL, NULL, NULL, '2022-02-09 21:02:20', '2022-02-09 22:24:37'),
  	(9, 'vendeur-220209-211020', 23, NULL, 3, 2, 1, 1, 1, 0, 0, 400, 50, 400, 0, 0, NULL, NULL, NULL, NULL, 1, 2, 1, NULL, NULL, NULL, NULL, '2022-02-09 21:11:20', '2022-02-09 21:11:20'),
  	(10, 'vendeur-220209-222721', 23, NULL, 3, 2, 1, 1, 1, 0, 0, 500, 50, 500, 0, 0, NULL, NULL, NULL, NULL, 1, 2, 1, NULL, NULL, NULL, NULL, '2022-02-09 22:28:11', '2022-02-09 22:28:11');
  /*!40000 ALTER TABLE `sales` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. stock_counts
  CREATE TABLE IF NOT EXISTS `stock_counts` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `reference_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `warehouse_id` int(11) NOT NULL,
    `category_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `brand_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `user_id` int(11) NOT NULL,
    `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `initial_file` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `final_file` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `note` text COLLATE utf8mb4_unicode_ci,
    `is_adjusted` tinyint(1) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.stock_counts : ~0 rows (environ)
  /*!40000 ALTER TABLE `stock_counts` DISABLE KEYS */;
  /*!40000 ALTER TABLE `stock_counts` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. suppliers
  CREATE TABLE IF NOT EXISTS `suppliers` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `company_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `vat_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `phone_number` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `address` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `city` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `state` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `postal_code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `country` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `is_active` tinyint(1) DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.suppliers : ~0 rows (environ)
  /*!40000 ALTER TABLE `suppliers` DISABLE KEYS */;
  INSERT INTO `suppliers` (`id`, `name`, `image`, `company_name`, `vat_number`, `email`, `phone_number`, `address`, `city`, `state`, `postal_code`, `country`, `is_active`, `created_at`, `updated_at`) VALUES
  	(1, 'Supplier 1', NULL, 'Supplier 1 Company', NULL, 'supplier1@yovente.com', '0655555555', 'Adresse Supplier 1', 'Casablanca', NULL, NULL, NULL, 1, '2022-01-07 23:28:29', '2022-01-07 23:28:29');
  /*!40000 ALTER TABLE `suppliers` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. taxes
  CREATE TABLE IF NOT EXISTS `taxes` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `rate` double NOT NULL,
    `is_active` tinyint(1) DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.taxes : ~0 rows (environ)
  /*!40000 ALTER TABLE `taxes` DISABLE KEYS */;
  /*!40000 ALTER TABLE `taxes` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. transfers
  CREATE TABLE IF NOT EXISTS `transfers` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `reference_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `user_id` int(11) NOT NULL,
    `status` int(11) NOT NULL,
    `from_warehouse_id` int(11) NOT NULL,
    `to_warehouse_id` int(11) NOT NULL,
    `item` int(11) NOT NULL,
    `total_qty` double NOT NULL,
    `total_tax` double NOT NULL,
    `total_cost` double NOT NULL,
    `shipping_cost` double DEFAULT NULL,
    `grand_total` double NOT NULL,
    `document` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `note` text COLLATE utf8mb4_unicode_ci,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.transfers : ~0 rows (environ)
  /*!40000 ALTER TABLE `transfers` DISABLE KEYS */;
  /*!40000 ALTER TABLE `transfers` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. units
  CREATE TABLE IF NOT EXISTS `units` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `unit_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `unit_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `base_unit` int(11) DEFAULT NULL,
    `operator` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `operation_value` double DEFAULT NULL,
    `is_active` tinyint(1) DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.units : ~3 rows (environ)
  /*!40000 ALTER TABLE `units` DISABLE KEYS */;
  INSERT INTO `units` (`id`, `unit_code`, `unit_name`, `base_unit`, `operator`, `operation_value`, `is_active`, `created_at`, `updated_at`) VALUES
  	(1, 'pce', 'Pièce', NULL, '*', 1, 1, '2022-01-07 21:57:28', '2022-01-07 21:57:28'),
  	(2, 'douzaine', 'Douzaine', 1, '*', 12, 1, '2022-01-09 17:19:14', '2022-01-09 17:19:14'),
  	(3, 'carton', 'Carton', 1, '*', 20, 1, '2022-01-09 17:19:28', '2022-01-09 17:19:28');
  /*!40000 ALTER TABLE `units` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. users
  CREATE TABLE IF NOT EXISTS `users` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `first_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `last_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `rib` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `bank_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `phone` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `company_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `role_id` int(11) NOT NULL,
    `biller_id` int(11) DEFAULT NULL,
    `warehouse_id` int(11) DEFAULT NULL,
    `is_active` tinyint(1) NOT NULL,
    `is_deleted` tinyint(1) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.users : ~8 rows (environ)
  /*!40000 ALTER TABLE `users` DISABLE KEYS */;
  INSERT INTO `users` (`id`, `name`, `first_name`, `last_name`, `email`, `rib`, `bank_name`, `password`, `remember_token`, `phone`, `company_name`, `role_id`, `biller_id`, `warehouse_id`, `is_active`, `is_deleted`, `created_at`, `updated_at`) VALUES
  	(1, 'Tarik', 'tarik', 'boukjij', 'tarik.engineering@gmail.com', '3200009233890588399028340', 'AL BARID BANK', '$2y$10$HPt3Go.HX8PKm/9Tuh2h5uaW3yIVnf5qu9y.aWIv85AVZJbUU0slG', 'U1YfEqzBWlE2Wye9cAJhdu5iQI2SpdnHUlRjjlJHM9CdZTQr4DERZqoZeMZd', '0689385061', 'T@R!K', 1, NULL, NULL, 1, 0, '2018-06-02 04:24:15', '2022-02-02 10:39:11'),
  	(23, 'Vendeur', 'vendeur', 'vendeur', 'vendeur@yovente.com', '42084724572057208572457', 'ATTIJARI WAFA BANK', '$2y$10$ZpJbd7m8PzYsUguYOjJJzu9oE7YO/Z.9bB2HyVBR5PBew8XCoPBRW', NULL, '0633333333', NULL, 4, NULL, NULL, 1, 0, '2022-01-07 22:35:45', '2022-02-02 10:39:37'),
  	(24, 'Salma', 'salma', 'boukjijma', 'salma@yovente.com', '', '', '$2y$10$0e2hSyrAl2X1W2XqAdnvUOVGLPK8f8xZmLhT8ItTYdqedqe2VcJbq', NULL, '0611111111', 'Salma Company', 5, NULL, NULL, 0, 1, '2022-01-15 21:13:17', '2022-01-30 20:00:17'),
  	(25, 'rim', 'rim', 'boukjijm', 'rim@yovente.com', '', '', '$2y$10$u6iuPGz6DHP5EVI0BGWsjOcVYKAQ4jbHTYhrwd/x23RLlrru5qPTK', NULL, '0622222222', 'Rim Company', 5, NULL, NULL, 0, 1, '2022-01-30 19:57:46', '2022-01-30 20:00:03'),
  	(26, 'Vendeur1', 'vendeur1', 'vendeur1', 'vendeur1@yovente.com', '', '', '$2y$10$Gk1VagRoo0AFv8xsZlOeT.4KEIu6um10ClY89DLokWCA1moANi3D2', NULL, '0688888888', NULL, 4, NULL, NULL, 1, 0, '2022-01-30 22:55:39', '2022-01-30 22:55:39'),
  	(27, 'faty1', 'faty', 'boukjijf', 'faty1@yovente.com', '', '', '$2y$10$7vuIzRDHIpcCdYGEXwc/beOVE6R9/jdlI79Cj/1Hbf.x.Wy8cnJAO', NULL, '0612121212', NULL, 4, NULL, NULL, 1, 0, '2022-01-31 12:19:52', '2022-02-01 09:53:48'),
  	(28, 'nejjar', 'fatima ezzahra', 'nejjar', 'nejjar@yovente.com', NULL, NULL, '$2y$10$1vFI/whJVJENEzQFeS/7DekOnRkUK/UuZzGUq0rEHGdIYnBsmm3fy', NULL, '0615914789', NULL, 4, NULL, NULL, 0, 1, '2022-02-09 21:06:27', '2022-02-09 21:06:45'),
  	(29, 'nejjar', 'fatima ezzahra', 'nejjar', 'nejjar@yovente.com', NULL, NULL, '$2y$10$gN9XZ6W9/fF9I94FQcwVK.sG0tgtoX2F5kp8CA7JMyfFw.uRJUp0K', NULL, '0612345678', NULL, 1, NULL, NULL, 0, 0, '2022-02-09 21:07:20', '2022-02-09 21:07:20');
  /*!40000 ALTER TABLE `users` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. variants
  CREATE TABLE IF NOT EXISTS `variants` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.variants : ~5 rows (environ)
  /*!40000 ALTER TABLE `variants` DISABLE KEYS */;
  INSERT INTO `variants` (`id`, `name`, `created_at`, `updated_at`) VALUES
  	(1, 'XL', '2022-01-07 22:42:53', '2022-01-07 22:42:53'),
  	(2, 'L', '2022-01-07 22:42:53', '2022-01-07 22:42:53'),
  	(3, 'M', '2022-01-07 22:42:53', '2022-01-07 22:42:53'),
  	(4, 'S', '2022-01-07 22:42:53', '2022-01-07 22:42:53'),
  	(5, 'XXL', '2022-01-07 23:26:22', '2022-01-07 23:26:22');
  /*!40000 ALTER TABLE `variants` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. warehouses
  CREATE TABLE IF NOT EXISTS `warehouses` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `address` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `is_active` tinyint(1) DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.warehouses : ~2 rows (environ)
  /*!40000 ALTER TABLE `warehouses` DISABLE KEYS */;
  INSERT INTO `warehouses` (`id`, `name`, `phone`, `email`, `address`, `is_active`, `created_at`, `updated_at`) VALUES
  	(1, 'Entrepôt Benslimane', '0600000000', 'entrepotbenslimane@yovente.com', 'Adresse de l\'entrepôt de Benslimane', 1, '2022-01-07 21:55:19', '2022-01-07 21:55:19'),
  	(2, 'Entrepot Fes', '0611111111', 'entrepotfes@yovente.com', 'Adresse de l\'entrepôt de Fes', 1, '2022-01-30 22:45:51', '2022-01-30 23:03:28');
  /*!40000 ALTER TABLE `warehouses` ENABLE KEYS */;
  
  -- Listage de la structure de la table yovente. withdrawals
  CREATE TABLE IF NOT EXISTS `withdrawals` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `reference_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `user_id` int(11) NOT NULL,
    `withdraw_amount` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `withdraw_note` text COLLATE utf8mb4_unicode_ci,
    `is_valide` tinyint(1) DEFAULT NULL,
    `is_paid` tinyint(1) DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Listage des données de la table yovente.withdrawals : ~2 rows (environ)
  /*!40000 ALTER TABLE `withdrawals` DISABLE KEYS */;
  INSERT INTO `withdrawals` (`id`, `reference_no`, `user_id`, `withdraw_amount`, `withdraw_note`, `is_valide`, `is_paid`, `created_at`, `updated_at`) VALUES
  	(1, 'retrait-vendeur-220208-213419', 23, '500', 'This is a note to the administrator, please send it on Dollar...', 0, NULL, '2022-02-08 21:37:16', '2022-02-08 22:45:02'),
  	(2, 'retrait-vendeur-220208-214856', 23, '580', 'هذه ملاحظة للمسؤول ، يرجى إرسالها على الدولار ...', 0, NULL, '2022-02-08 21:49:39', '2022-02-08 22:45:43');
  /*!40000 ALTER TABLE `withdrawals` ENABLE KEYS */;
  
  /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
  /*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  /*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;
  