text: -- --------------------------------------------------------
  -- Host:                         127.0.0.1
  -- Server version:               10.4.13-MariaDB - mariadb.org binary distribution
  -- Server OS:                    Win64
  -- HeidiSQL Version:             11.0.0.5919
  -- --------------------------------------------------------
  
  /*!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' */;
  
  
  -- Dumping database structure for b2b_sudahonline
  CREATE DATABASE IF NOT EXISTS `b2b_sudahonline` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
  USE `b2b_sudahonline`;
  
  -- Dumping structure for table b2b_sudahonline.b2b_client
  CREATE TABLE IF NOT EXISTS `b2b_client` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `client_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `client_image` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `client_slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `company_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `phone_whatsapp` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `phone` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `client_address` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `fb_url` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `inst_url` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `ytb_url` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `twt_url` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `status` enum('ACTIVE','INACTIVE') COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `type` enum('CLIENT','OWNER') COLLATE utf8mb4_unicode_ci NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `b2b_client_client_name_unique` (`client_name`),
    UNIQUE KEY `b2b_client_client_slug_unique` (`client_slug`),
    UNIQUE KEY `b2b_client_email_unique` (`email`),
    UNIQUE KEY `b2b_client_phone_whatsapp_unique` (`phone_whatsapp`),
    UNIQUE KEY `b2b_client_phone_unique` (`phone`)
  ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table b2b_sudahonline.banners
  CREATE TABLE IF NOT EXISTS `banners` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `image` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Berisi nama file image tanpa path',
    `client_id` int(10) unsigned DEFAULT NULL,
    `position` int(10) unsigned NOT NULL DEFAULT 0,
    `create_by` int(11) NOT NULL,
    `update_by` int(11) DEFAULT NULL,
    `delete_by` int(11) DEFAULT NULL,
    `deleted_at` timestamp NULL DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `banners_client_id_foreign` (`client_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table b2b_sudahonline.categories
  CREATE TABLE IF NOT EXISTS `categories` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `image_category` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Berisi nama file image tanpa path',
    `client_id` int(10) unsigned DEFAULT NULL,
    `create_by` int(11) NOT NULL,
    `update_by` int(11) DEFAULT NULL,
    `delete_by` int(11) DEFAULT NULL,
    `deleted_at` timestamp NULL DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `categories_slug_unique` (`slug`),
    KEY `categories_client_id_foreign` (`client_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table b2b_sudahonline.category_product
  CREATE TABLE IF NOT EXISTS `category_product` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `product_id` int(10) unsigned DEFAULT NULL,
    `category_id` int(10) unsigned DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `category_product_product_id_foreign` (`product_id`),
    KEY `category_product_category_id_foreign` (`category_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=60 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table b2b_sudahonline.cities
  CREATE TABLE IF NOT EXISTS `cities` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `province_id` int(11) NOT NULL,
    `city_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `postal_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `display_order` int(10) unsigned DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=502 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table b2b_sudahonline.customers
  CREATE TABLE IF NOT EXISTS `customers` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `store_code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `store_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `city_id` int(10) unsigned DEFAULT NULL,
    `address` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `phone_owner` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `phone_store` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `status` enum('ACTIVE','NONACTIVE','NEW') COLLATE utf8mb4_unicode_ci NOT NULL,
    `payment_term` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `user_id` bigint(20) unsigned DEFAULT NULL,
    `client_id` int(10) unsigned DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `customers_store_code_unique` (`store_code`),
    KEY `customers_client_id_foreign` (`client_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=518 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table b2b_sudahonline.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=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table b2b_sudahonline.groups
  CREATE TABLE IF NOT EXISTS `groups` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `group_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `group_image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Berisi nama file image tanpa path',
    `display_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `client_id` int(10) unsigned DEFAULT NULL,
    `version` int(10) unsigned DEFAULT NULL,
    `status` enum('ACTIVE','INACTIVE') COLLATE utf8mb4_unicode_ci NOT NULL,
    `group_cat` varchar(191) COLLATE utf8mb4_unicode_ci 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;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table b2b_sudahonline.groups_paket
  CREATE TABLE IF NOT EXISTS `groups_paket` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `group_id` int(10) unsigned DEFAULT NULL,
    `paket_id` int(10) unsigned DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `groups_paket_group_id_foreign` (`group_id`),
    KEY `groups_paket_paket_id_foreign` (`paket_id`),
    CONSTRAINT `groups_paket_group_id_foreign` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`),
    CONSTRAINT `groups_paket_paket_id_foreign` FOREIGN KEY (`paket_id`) REFERENCES `pakets` (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table b2b_sudahonline.group_product
  CREATE TABLE IF NOT EXISTS `group_product` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `group_id` int(10) unsigned DEFAULT NULL,
    `product_id` int(10) unsigned DEFAULT NULL,
    `status` enum('ACTIVE','INACTIVE') 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=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table b2b_sudahonline.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=MyISAM AUTO_INCREMENT=70 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table b2b_sudahonline.orders
  CREATE TABLE IF NOT EXISTS `orders` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `client_id` int(10) unsigned DEFAULT NULL,
    `user_id` bigint(20) unsigned NOT NULL,
    `user_loc` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `customer_id` bigint(20) unsigned DEFAULT NULL,
    `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `id_voucher` bigint(20) unsigned DEFAULT NULL,
    `total_price` decimal(11,2) unsigned NOT NULL DEFAULT 0.00,
    `invoice_number` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `payment_method` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `notes` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `status` enum('SUBMIT','PROCESS','FINISH','CANCEL') COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `process_time` timestamp NULL DEFAULT NULL,
    `finish_time` timestamp NULL DEFAULT NULL,
    `cancel_time` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `orders_customer_id_foreign` (`customer_id`),
    KEY `orders_user_id_foreign` (`user_id`),
    KEY `orders_client_id_foreign` (`client_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=133 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table b2b_sudahonline.order_paket_tmp
  CREATE TABLE IF NOT EXISTS `order_paket_tmp` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `order_id` int(10) unsigned NOT NULL,
    `product_id` int(10) unsigned NOT NULL,
    `price_item` double(8,2) DEFAULT NULL,
    `price_item_promo` double(8,2) DEFAULT NULL,
    `discount_item` double(8,2) DEFAULT NULL,
    `quantity` int(10) unsigned NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `group_id` int(10) unsigned DEFAULT NULL,
    `paket_id` int(10) unsigned DEFAULT NULL,
    `bonus_cat` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `order_product_order_id_foreign` (`order_id`),
    KEY `order_product_product_id_foreign` (`product_id`),
    KEY `order_product_group_id_foreign` (`group_id`),
    KEY `order_product_paket_id_foreign` (`paket_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=406 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table b2b_sudahonline.order_product
  CREATE TABLE IF NOT EXISTS `order_product` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `order_id` int(10) unsigned NOT NULL,
    `product_id` int(10) unsigned NOT NULL,
    `price_item` double(8,2) DEFAULT NULL,
    `price_item_promo` double(8,2) DEFAULT NULL,
    `discount_item` double(8,2) DEFAULT NULL,
    `quantity` int(10) unsigned NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `group_id` int(10) unsigned DEFAULT NULL,
    `paket_id` int(10) unsigned DEFAULT NULL,
    `bonus_cat` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `order_product_order_id_foreign` (`order_id`),
    KEY `order_product_product_id_foreign` (`product_id`),
    KEY `order_product_group_id_foreign` (`group_id`),
    KEY `order_product_paket_id_foreign` (`paket_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=449 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table b2b_sudahonline.pakets
  CREATE TABLE IF NOT EXISTS `pakets` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `paket_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `display_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `bonus_quantity` int(11) NOT NULL,
    `purchase_quantity` int(11) NOT NULL,
    `display_order` int(10) unsigned NOT NULL DEFAULT 0,
    `client_id` int(10) unsigned DEFAULT NULL,
    `status` enum('ACTIVE','INACTIVE') 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;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table b2b_sudahonline.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=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table b2b_sudahonline.products
  CREATE TABLE IF NOT EXISTS `products` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `client_id` int(10) unsigned DEFAULT NULL,
    `product_code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `Product_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `price` double(11,2) NOT NULL,
    `price_promo` double(11,2) NOT NULL,
    `discount` double(8,2) NOT NULL,
    `stock` int(10) unsigned NOT NULL DEFAULT 0,
    `low_stock_treshold` int(10) unsigned NOT NULL DEFAULT 0,
    `top_product` int(10) unsigned NOT NULL DEFAULT 0,
    `created_by` int(11) NOT NULL,
    `updated_by` int(11) DEFAULT NULL,
    `deleted_by` int(11) DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `deleted_at` timestamp NULL DEFAULT NULL,
    `status` enum('PUBLISH','DRAFT') COLLATE utf8mb4_unicode_ci NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `products_product_code_unique` (`product_code`),
    KEY `products_client_id_foreign` (`client_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=42 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table b2b_sudahonline.product_stock_status
  CREATE TABLE IF NOT EXISTS `product_stock_status` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `status_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `stock_status` enum('ON','OFF') COLLATE utf8mb4_unicode_ci NOT NULL,
    `client_id` int(10) unsigned DEFAULT 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;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table b2b_sudahonline.provinces
  CREATE TABLE IF NOT EXISTS `provinces` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `province` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table b2b_sudahonline.sessions
  CREATE TABLE IF NOT EXISTS `sessions` (
    `id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `user_id` bigint(20) unsigned DEFAULT NULL,
    `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `user_agent` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `payload` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `last_activity` int(11) NOT NULL,
    UNIQUE KEY `sessions_id_unique` (`id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table b2b_sudahonline.spv_sales
  CREATE TABLE IF NOT EXISTS `spv_sales` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `spv_id` int(10) unsigned DEFAULT NULL,
    `sls_id` int(10) unsigned DEFAULT NULL,
    `status` enum('ACTIVE','INACTIVE') 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=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table b2b_sudahonline.users
  CREATE TABLE IF NOT EXISTS `users` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `client_id` int(10) unsigned DEFAULT NULL,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `email_verified_at` timestamp NULL DEFAULT NULL,
    `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `username` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `roles` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `address` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `city_id` int(11) DEFAULT NULL,
    `profile_desc` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `avatar` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `status` enum('ACTIVE','INACTIVE') COLLATE utf8mb4_unicode_ci NOT NULL,
    `sales_area` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `users_email_unique` (`email`),
    UNIQUE KEY `users_username_unique` (`username`),
    KEY `users_client_id_foreign` (`client_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=38 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table b2b_sudahonline.vouchers
  CREATE TABLE IF NOT EXISTS `vouchers` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `uses` int(10) unsigned DEFAULT NULL,
    `max_uses` int(10) unsigned DEFAULT NULL,
    `type` tinyint(3) unsigned NOT NULL,
    `discount_amount` double(8,2) NOT NULL,
    `starts_at` timestamp NULL DEFAULT NULL,
    `expires_at` timestamp NULL DEFAULT NULL,
    `status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `deleted_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Data exporting was unselected.
  
  /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
  /*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  