-- --------------------------------------------------------
-- Host:                         127.0.0.1
-- Server version:               5.7.17-log - MySQL Community Server (GPL)
-- Server OS:                    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 */;


-- Dumping database structure for posai
DROP DATABASE IF EXISTS `posai`;
CREATE DATABASE IF NOT EXISTS `posai` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `posai`;

-- Dumping structure for table posai.branches
DROP TABLE IF EXISTS `branches`;
CREATE TABLE IF NOT EXISTS `branches` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `location` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text COLLATE utf8mb4_unicode_ci,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `is_default` tinyint(1) NOT NULL DEFAULT '0',
  `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;

-- Dumping data for table posai.branches: ~2 rows (approximately)
/*!40000 ALTER TABLE `branches` DISABLE KEYS */;
REPLACE INTO `branches` (`id`, `name`, `location`, `phone`, `email`, `address`, `is_active`, `is_default`, `created_at`, `updated_at`) VALUES
	(1, 'Main Branch', 'Nairobi CBD', '+254700000001', 'main@pos.com', 'Kenyatta Avenue, Nairobi', 1, 1, '2026-03-29 18:34:22', '2026-03-29 18:34:22'),
	(2, 'Westlands Branch', 'Westlands, Nairobi', '+254700000002', 'westlands@pos.com', 'Westlands Business Centre, Nairobi', 1, 0, '2026-03-29 18:34:22', '2026-03-29 18:34:22'),
	(3, 'Mombasa Branch', 'Mombasa CBD', '+254700000003', 'mombasa@pos.com', 'Mombasa Road, Mombasa', 1, 0, '2026-03-29 18:34:22', '2026-03-29 18:34:22');
/*!40000 ALTER TABLE `branches` ENABLE KEYS */;

-- Dumping structure for table posai.cache
DROP TABLE IF EXISTS `cache`;
CREATE TABLE IF NOT EXISTS `cache` (
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiration` int(11) NOT NULL,
  PRIMARY KEY (`key`),
  KEY `cache_expiration_index` (`expiration`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table posai.cache: ~0 rows (approximately)
/*!40000 ALTER TABLE `cache` DISABLE KEYS */;
/*!40000 ALTER TABLE `cache` ENABLE KEYS */;

-- Dumping structure for table posai.cache_locks
DROP TABLE IF EXISTS `cache_locks`;
CREATE TABLE IF NOT EXISTS `cache_locks` (
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `owner` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiration` int(11) NOT NULL,
  PRIMARY KEY (`key`),
  KEY `cache_locks_expiration_index` (`expiration`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table posai.cache_locks: ~0 rows (approximately)
/*!40000 ALTER TABLE `cache_locks` DISABLE KEYS */;
/*!40000 ALTER TABLE `cache_locks` ENABLE KEYS */;

-- Dumping structure for table posai.categories
DROP TABLE IF EXISTS `categories`;
CREATE TABLE IF NOT EXISTS `categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `categories_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table posai.categories: ~15 rows (approximately)
/*!40000 ALTER TABLE `categories` DISABLE KEYS */;
REPLACE INTO `categories` (`id`, `name`, `slug`, `description`, `is_active`, `created_at`, `updated_at`) VALUES
	(11, 'Wines', 'wines', NULL, 1, '2026-03-30 16:56:02', '2026-03-30 16:56:02'),
	(12, 'Beer', 'beer', NULL, 1, '2026-03-30 17:02:59', '2026-03-30 17:02:59'),
	(13, 'Whiskey', 'whiskey', NULL, 1, '2026-03-30 17:06:21', '2026-03-30 17:06:21'),
	(14, 'Gin', 'gin', NULL, 1, '2026-03-30 17:24:44', '2026-03-30 17:24:44'),
	(15, 'Liquer', 'liquer', NULL, 1, '2026-03-30 17:27:39', '2026-03-30 17:27:39'),
	(16, 'Vodka', 'vodka', NULL, 1, '2026-03-30 17:34:23', '2026-03-30 17:34:23'),
	(17, 'Cigarette', 'cigarette', NULL, 1, '2026-03-30 18:00:05', '2026-03-30 18:00:05'),
	(18, 'Tequila', 'tequila', NULL, 1, '2026-03-30 18:14:55', '2026-03-30 18:14:55'),
	(19, 'Rum', 'rum', NULL, 1, '2026-03-30 18:27:57', '2026-03-30 18:27:57'),
	(20, 'Spirit', 'spirit', NULL, 1, '2026-03-30 19:13:41', '2026-03-30 19:13:41'),
	(21, 'Juice', 'juice', NULL, 1, '2026-03-30 19:28:11', '2026-03-30 19:28:11'),
	(22, 'Cognac', 'cognac', NULL, 1, '2026-03-30 20:36:16', '2026-03-30 20:36:16'),
	(23, 'Soft drink', 'soft-drink', NULL, 1, '2026-03-31 11:29:47', '2026-03-31 11:30:10'),
	(24, 'Brandy', 'brandy', NULL, 1, '2026-03-31 11:46:30', '2026-03-31 11:46:30'),
	(25, 'Water', 'water', NULL, 1, '2026-03-31 12:08:38', '2026-03-31 12:08:38');
/*!40000 ALTER TABLE `categories` ENABLE KEYS */;

-- Dumping structure for table posai.credit_payments
DROP TABLE IF EXISTS `credit_payments`;
CREATE TABLE IF NOT EXISTS `credit_payments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` bigint(20) unsigned NOT NULL,
  `customer_id` bigint(20) unsigned NOT NULL,
  `amount` decimal(12,2) NOT NULL,
  `balance_before` decimal(12,2) DEFAULT '0.00',
  `balance_after` decimal(12,2) DEFAULT '0.00',
  `payment_method` varchar(255) DEFAULT 'cash',
  `reference_number` varchar(255) DEFAULT NULL,
  `notes` text,
  `user_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `order_id` (`order_id`),
  KEY `customer_id` (`customer_id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `credit_payments_ibfk_1` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE,
  CONSTRAINT `credit_payments_ibfk_2` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE,
  CONSTRAINT `credit_payments_ibfk_3` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Dumping data for table posai.credit_payments: ~0 rows (approximately)
/*!40000 ALTER TABLE `credit_payments` DISABLE KEYS */;
/*!40000 ALTER TABLE `credit_payments` ENABLE KEYS */;

-- Dumping structure for table posai.customers
DROP TABLE IF EXISTS `customers`;
CREATE TABLE IF NOT EXISTS `customers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text COLLATE utf8mb4_unicode_ci,
  `balance` decimal(10,2) NOT NULL DEFAULT '0.00',
  `loyalty_points` int(11) NOT NULL DEFAULT '0',
  `total_points_earned` int(11) NOT NULL DEFAULT '0',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table posai.customers: ~0 rows (approximately)
/*!40000 ALTER TABLE `customers` DISABLE KEYS */;
REPLACE INTO `customers` (`id`, `name`, `phone`, `email`, `address`, `balance`, `loyalty_points`, `total_points_earned`, `is_active`, `created_at`, `updated_at`) VALUES
	(11, 'kelvin', '701980200', '1moonger@gmail.com', NULL, 0.00, 0, 0, 1, '2026-03-28 09:34:20', '2026-03-29 11:06:52');
/*!40000 ALTER TABLE `customers` ENABLE KEYS */;

-- Dumping structure for table posai.disposed_products
DROP TABLE IF EXISTS `disposed_products`;
CREATE TABLE IF NOT EXISTS `disposed_products` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `product_id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `quantity` int(11) NOT NULL,
  `unit_cost` decimal(12,2) DEFAULT NULL,
  `total_value` decimal(12,2) DEFAULT NULL,
  `reason` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `disposed_products_product_id_foreign` (`product_id`),
  KEY `disposed_products_user_id_foreign` (`user_id`),
  CONSTRAINT `disposed_products_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  CONSTRAINT `disposed_products_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table posai.disposed_products: ~0 rows (approximately)
/*!40000 ALTER TABLE `disposed_products` DISABLE KEYS */;
/*!40000 ALTER TABLE `disposed_products` ENABLE KEYS */;

-- Dumping structure for table posai.etims_configs
DROP TABLE IF EXISTS `etims_configs`;
CREATE TABLE IF NOT EXISTS `etims_configs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `company_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `company_npwp` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_nik` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `branches_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `api_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `api_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `api_secret` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `client_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `client_secret` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `machine_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'POS-001',
  `register_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'REG-001',
  `serial_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_production` tinyint(1) NOT NULL DEFAULT '0',
  `is_active` tinyint(1) NOT NULL DEFAULT '0',
  `notes` 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;

-- Dumping data for table posai.etims_configs: ~0 rows (approximately)
/*!40000 ALTER TABLE `etims_configs` DISABLE KEYS */;
/*!40000 ALTER TABLE `etims_configs` ENABLE KEYS */;

-- Dumping structure for table posai.expenses
DROP TABLE IF EXISTS `expenses`;
CREATE TABLE IF NOT EXISTS `expenses` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `category` varchar(255) NOT NULL,
  `amount` decimal(12,2) NOT NULL,
  `description` text,
  `expense_date` date NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `branch_id` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `expenses_branch_id_foreign` (`branch_id`),
  CONSTRAINT `expenses_branch_id_foreign` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE SET NULL,
  CONSTRAINT `expenses_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Dumping data for table posai.expenses: ~0 rows (approximately)
/*!40000 ALTER TABLE `expenses` DISABLE KEYS */;
/*!40000 ALTER TABLE `expenses` ENABLE KEYS */;

-- Dumping structure for table posai.failed_jobs
DROP TABLE IF EXISTS `failed_jobs`;
CREATE TABLE IF NOT EXISTS `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `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`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table posai.failed_jobs: ~0 rows (approximately)
/*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */;

-- Dumping structure for table posai.inventory_logs
DROP TABLE IF EXISTS `inventory_logs`;
CREATE TABLE IF NOT EXISTS `inventory_logs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `product_id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `supplier_id` bigint(20) unsigned DEFAULT NULL,
  `type` enum('stock_in','stock_out','adjustment','reconciliation','opening_balance') DEFAULT NULL,
  `quantity` decimal(12,2) NOT NULL,
  `previous_stock` decimal(12,2) NOT NULL,
  `new_stock` decimal(12,2) NOT NULL,
  `unit_cost` decimal(10,2) DEFAULT NULL,
  `reference_number` text,
  `notes` text,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `branch_id` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `product_id` (`product_id`),
  KEY `user_id` (`user_id`),
  KEY `supplier_id` (`supplier_id`),
  KEY `inventory_logs_branch_id_foreign` (`branch_id`),
  CONSTRAINT `inventory_logs_branch_id_foreign` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE SET NULL,
  CONSTRAINT `inventory_logs_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  CONSTRAINT `inventory_logs_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `inventory_logs_ibfk_3` FOREIGN KEY (`supplier_id`) REFERENCES `suppliers` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Dumping data for table posai.inventory_logs: ~0 rows (approximately)
/*!40000 ALTER TABLE `inventory_logs` DISABLE KEYS */;
/*!40000 ALTER TABLE `inventory_logs` ENABLE KEYS */;

-- Dumping structure for table posai.jobs
DROP TABLE IF EXISTS `jobs`;
CREATE TABLE IF NOT EXISTS `jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint(3) unsigned NOT NULL,
  `reserved_at` int(10) unsigned DEFAULT NULL,
  `available_at` int(10) unsigned NOT NULL,
  `created_at` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table posai.jobs: ~0 rows (approximately)
/*!40000 ALTER TABLE `jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `jobs` ENABLE KEYS */;

-- Dumping structure for table posai.job_batches
DROP TABLE IF EXISTS `job_batches`;
CREATE TABLE IF NOT EXISTS `job_batches` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `options` mediumtext COLLATE utf8mb4_unicode_ci,
  `cancelled_at` int(11) DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `finished_at` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table posai.job_batches: ~0 rows (approximately)
/*!40000 ALTER TABLE `job_batches` DISABLE KEYS */;
/*!40000 ALTER TABLE `job_batches` ENABLE KEYS */;

-- Dumping structure for table posai.migrations
DROP TABLE IF EXISTS `migrations`;
CREATE TABLE IF NOT EXISTS `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table posai.migrations: ~49 rows (approximately)
/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
REPLACE INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(1, '0001_01_01_000001_create_cache_table', 1),
	(2, '0001_01_01_000002_create_jobs_table', 1),
	(3, '2024_01_01_000001_create_users_table', 1),
	(4, '2024_01_01_000002_create_categories_table', 1),
	(5, '2024_01_01_000003_create_products_table', 1),
	(6, '2024_01_01_000004_create_customers_table', 1),
	(7, '2024_01_01_000005_create_suppliers_table', 1),
	(8, '2024_01_01_000006_create_orders_table', 1),
	(9, '2024_01_01_000007_create_inventory_logs_table', 1),
	(10, '2024_01_01_000008_create_sessions_table', 1),
	(11, '2024_01_01_000009_create_permissions_table', 1),
	(12, '2026_03_24_164454_update_orders_table_for_multiple_payments', 1),
	(13, '2026_03_25_130701_add_total_paid_to_suppliers_table', 1),
	(14, '2026_03_25_131400_create_expenses_table', 1),
	(15, '2026_03_25_153423_create_opening_balances_table', 1),
	(16, '2026_03_25_160000_create_supplier_payments_table', 1),
	(17, '2026_03_25_164732_add_opening_balance_to_inventory_logs_type', 1),
	(18, '2026_03_25_170000_create_subscriptions_tables', 1),
	(19, '2026_03_25_181947_update_products_stock_quantity_to_decimal', 1),
	(20, '2026_03_25_182031_update_inventory_logs_quantity_to_decimal', 1),
	(21, '2026_03_25_190000_create_tax_configs_table', 1),
	(22, '2026_03_25_191000_add_tax_details_to_orders_table', 1),
	(23, '2026_03_25_200000_create_mpesa_configs_table', 1),
	(24, '2026_03_25_add_theme_to_users', 1),
	(25, '2026_03_26_000000_add_expiry_date_to_products_table', 1),
	(26, '2026_03_26_100000_add_loyalty_points_to_customers_table', 1),
	(27, '2026_03_26_110000_create_settings_table', 1),
	(28, '2026_03_26_120000_add_super_admin_role_to_users', 1),
	(29, '2026_03_26_130000_add_multiple_prices_to_products', 1),
	(30, '2026_03_27_000000_add_price_type_to_order_items_table', 1),
	(31, '2026_03_27_100000_create_price_adjustment_logs_table', 1),
	(44, '2026_03_27_110000_create_price_adjustment_details_table', 2),
	(45, '2026_03_27_120000_create_product_price_history_table', 2),
	(46, '2026_03_27_124603_add_credit_fields_to_orders_table', 2),
	(47, '2026_03_27_133309_add_sms_settings', 2),
	(48, '2026_03_27_135240_add_nenasasa_sms_settings', 2),
	(49, '2026_03_27_143945_add_nenasasa_oauth_settings', 2),
	(50, '2026_03_27_150000_create_user_activity_logs_table', 2),
	(51, '2026_03_27_181132_add_client_time_to_user_activity_logs_table', 2),
	(54, '2026_03_27_185832_add_client_time_to_orders_table', 3),
	(55, '2026_03_28_000001_add_manual_recording_to_mpesa_configs', 3),
	(56, '2026_03_28_083712_add_price2_price3_to_price_adjustment_details', 4),
	(57, '2026_03_28_091420_add_notes_to_opening_balances_table', 5),
	(58, '2026_03_28_120000_add_receipt_report_settings', 6),
	(59, '2026_03_29_000000_create_unit_of_measures_table', 7),
	(60, '2026_03_29_000001_add_unit_of_measure_id_to_products_table', 7),
	(61, '2026_03_29_000002_create_disposed_products_table', 8),
	(62, '2026_03_29_000003_create_branches_table', 9),
	(63, '2026_03_29_000004_add_branch_id_to_tables', 9),
	(64, '2026_03_29_000005_add_branch_id_to_products_table', 10),
	(65, '2026_03_30_000001_add_reconciliation_to_inventory_logs_type', 11);
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;

-- Dumping structure for table posai.mpesa_configs
DROP TABLE IF EXISTS `mpesa_configs`;
CREATE TABLE IF NOT EXISTS `mpesa_configs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `consumer_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `consumer_secret` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shortcode` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `passkey` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `callback_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `confirmation_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `validation_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '0',
  `is_production` tinyint(1) NOT NULL DEFAULT '0',
  `manual_recording` tinyint(1) NOT NULL DEFAULT '0',
  `notes` 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;

-- Dumping data for table posai.mpesa_configs: ~0 rows (approximately)
/*!40000 ALTER TABLE `mpesa_configs` DISABLE KEYS */;
REPLACE INTO `mpesa_configs` (`id`, `consumer_key`, `consumer_secret`, `shortcode`, `passkey`, `callback_url`, `confirmation_url`, `validation_url`, `is_active`, `is_production`, `manual_recording`, `notes`, `created_at`, `updated_at`) VALUES
	(1, 'admin@pos.com', 'password', '123', '123', 'http://127.0.0.1:8000/mpesa/callback', NULL, NULL, 1, 0, 1, NULL, '2026-03-28 06:36:28', '2026-03-29 05:48:18');
/*!40000 ALTER TABLE `mpesa_configs` ENABLE KEYS */;

-- Dumping structure for table posai.mpesa_transactions
DROP TABLE IF EXISTS `mpesa_transactions`;
CREATE TABLE IF NOT EXISTS `mpesa_transactions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` bigint(20) unsigned DEFAULT NULL,
  `transaction_type` varchar(255) DEFAULT NULL,
  `transaction_id` varchar(255) DEFAULT NULL,
  `transaction_time` varchar(255) DEFAULT NULL,
  `amount` decimal(12,2) DEFAULT '0.00',
  `msisdn` varchar(255) DEFAULT NULL,
  `sender` varchar(255) DEFAULT NULL,
  `receiver` varchar(255) DEFAULT NULL,
  `account_reference` varchar(255) DEFAULT NULL,
  `invoice_number` varchar(255) DEFAULT NULL,
  `external_reference` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT 'pending',
  `raw_request` text,
  `raw_response` text,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mpesa_transactions_transaction_id_unique` (`transaction_id`),
  KEY `order_id` (`order_id`),
  CONSTRAINT `mpesa_transactions_ibfk_1` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Dumping data for table posai.mpesa_transactions: ~0 rows (approximately)
/*!40000 ALTER TABLE `mpesa_transactions` DISABLE KEYS */;
/*!40000 ALTER TABLE `mpesa_transactions` ENABLE KEYS */;

-- Dumping structure for table posai.opening_balances
DROP TABLE IF EXISTS `opening_balances`;
CREATE TABLE IF NOT EXISTS `opening_balances` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `date` date NOT NULL,
  `amount` decimal(12,2) DEFAULT '0.00',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `notes` text,
  `branch_id` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `opening_balances_user_id_date_unique` (`user_id`,`date`),
  KEY `opening_balances_branch_id_foreign` (`branch_id`),
  CONSTRAINT `opening_balances_branch_id_foreign` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE SET NULL,
  CONSTRAINT `opening_balances_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Dumping data for table posai.opening_balances: ~0 rows (approximately)
/*!40000 ALTER TABLE `opening_balances` DISABLE KEYS */;
/*!40000 ALTER TABLE `opening_balances` ENABLE KEYS */;

-- Dumping structure for table posai.orders
DROP TABLE IF EXISTS `orders`;
CREATE TABLE IF NOT EXISTS `orders` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `invoice_number` varchar(255) NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `customer_id` bigint(20) unsigned DEFAULT NULL,
  `client_time` timestamp NULL DEFAULT NULL,
  `subtotal` decimal(10,2) NOT NULL,
  `discount` decimal(10,2) DEFAULT '0.00',
  `discount_type` varchar(255) DEFAULT 'percentage',
  `tax` decimal(10,2) DEFAULT '0.00',
  `tax_rate` decimal(5,2) DEFAULT '0.00',
  `tax_details` json DEFAULT NULL,
  `total` decimal(10,2) NOT NULL,
  `paid_amount` decimal(12,2) DEFAULT '0.00',
  `change_amount` decimal(10,2) DEFAULT '0.00',
  `payment_method` varchar(255) DEFAULT NULL,
  `payment_methods` json DEFAULT NULL,
  `payment_type` enum('cash','credit','partial') DEFAULT 'cash',
  `credit_amount` decimal(12,2) DEFAULT '0.00',
  `due_date` date DEFAULT NULL,
  `credit_status` enum('pending','partial','paid','overdue') DEFAULT NULL,
  `status` enum('completed','pending','cancelled') DEFAULT 'completed',
  `notes` text,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `branch_id` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `orders_invoice_number_unique` (`invoice_number`),
  KEY `user_id` (`user_id`),
  KEY `customer_id` (`customer_id`),
  KEY `orders_branch_id_foreign` (`branch_id`),
  CONSTRAINT `orders_branch_id_foreign` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE SET NULL,
  CONSTRAINT `orders_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `orders_ibfk_2` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Dumping data for table posai.orders: ~0 rows (approximately)
/*!40000 ALTER TABLE `orders` DISABLE KEYS */;
/*!40000 ALTER TABLE `orders` ENABLE KEYS */;

-- Dumping structure for table posai.order_items
DROP TABLE IF EXISTS `order_items`;
CREATE TABLE IF NOT EXISTS `order_items` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` bigint(20) unsigned NOT NULL,
  `product_id` bigint(20) unsigned NOT NULL,
  `product_name` varchar(255) NOT NULL,
  `product_sku` varchar(255) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `price_type` varchar(255) DEFAULT NULL,
  `unit_cost` decimal(12,2) DEFAULT NULL,
  `quantity` int(11) NOT NULL,
  `subtotal` decimal(10,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `order_id` (`order_id`),
  KEY `product_id` (`product_id`),
  CONSTRAINT `order_items_ibfk_1` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE,
  CONSTRAINT `order_items_ibfk_2` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Dumping data for table posai.order_items: ~0 rows (approximately)
/*!40000 ALTER TABLE `order_items` DISABLE KEYS */;
/*!40000 ALTER TABLE `order_items` ENABLE KEYS */;

-- Dumping structure for table posai.password_reset_tokens
DROP TABLE IF EXISTS `password_reset_tokens`;
CREATE TABLE IF NOT EXISTS `password_reset_tokens` (
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table posai.password_reset_tokens: ~0 rows (approximately)
/*!40000 ALTER TABLE `password_reset_tokens` DISABLE KEYS */;
/*!40000 ALTER TABLE `password_reset_tokens` ENABLE KEYS */;

-- Dumping structure for table posai.permissions
DROP TABLE IF EXISTS `permissions`;
CREATE TABLE IF NOT EXISTS `permissions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_name_unique` (`name`),
  UNIQUE KEY `permissions_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=64 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table posai.permissions: ~63 rows (approximately)
/*!40000 ALTER TABLE `permissions` DISABLE KEYS */;
REPLACE INTO `permissions` (`id`, `name`, `slug`, `description`, `created_at`, `updated_at`) VALUES
	(1, 'View Dashboard', 'dashboard.view', 'Can view dashboard', '2026-03-31 08:03:13', '2026-03-31 08:03:13'),
	(2, 'View Products', 'products.view', 'Can view products list', '2026-03-31 08:03:13', '2026-03-31 08:03:13'),
	(3, 'Create Products', 'products.create', 'Can create products', '2026-03-31 08:03:13', '2026-03-31 08:03:13'),
	(4, 'Edit Products', 'products.edit', 'Can edit products', '2026-03-31 08:03:13', '2026-03-31 08:03:13'),
	(5, 'Delete Products', 'products.delete', 'Can delete products', '2026-03-31 08:03:13', '2026-03-31 08:03:13'),
	(6, 'View Categories', 'categories.view', 'Can view categories', '2026-03-31 08:03:13', '2026-03-31 08:03:13'),
	(7, 'Create Categories', 'categories.create', 'Can create categories', '2026-03-31 08:03:13', '2026-03-31 08:03:13'),
	(8, 'Edit Categories', 'categories.edit', 'Can edit categories', '2026-03-31 08:03:13', '2026-03-31 08:03:13'),
	(9, 'Delete Categories', 'categories.delete', 'Can delete categories', '2026-03-31 08:03:13', '2026-03-31 08:03:13'),
	(10, 'View Unit of Measures', 'unit-of-measures.view', 'Can view unit of measures', '2026-03-31 08:03:13', '2026-03-31 08:03:13'),
	(11, 'Create Unit of Measures', 'unit-of-measures.create', 'Can create unit of measures', '2026-03-31 08:03:13', '2026-03-31 08:03:13'),
	(12, 'Edit Unit of Measures', 'unit-of-measures.edit', 'Can edit unit of measures', '2026-03-31 08:03:13', '2026-03-31 08:03:13'),
	(13, 'Delete Unit of Measures', 'unit-of-measures.delete', 'Can delete unit of measures', '2026-03-31 08:03:13', '2026-03-31 08:03:13'),
	(14, 'View Customers', 'customers.view', 'Can view customers', '2026-03-31 08:03:13', '2026-03-31 08:03:13'),
	(15, 'Create Customers', 'customers.create', 'Can create customers', '2026-03-31 08:03:13', '2026-03-31 08:03:13'),
	(16, 'Edit Customers', 'customers.edit', 'Can edit customers', '2026-03-31 08:03:13', '2026-03-31 08:03:13'),
	(17, 'Delete Customers', 'customers.delete', 'Can delete customers', '2026-03-31 08:03:13', '2026-03-31 08:03:13'),
	(18, 'View Suppliers', 'suppliers.view', 'Can view suppliers', '2026-03-31 08:03:13', '2026-03-31 08:03:13'),
	(19, 'Create Suppliers', 'suppliers.create', 'Can create suppliers', '2026-03-31 08:03:13', '2026-03-31 08:03:13'),
	(20, 'Edit Suppliers', 'suppliers.edit', 'Can edit suppliers', '2026-03-31 08:03:13', '2026-03-31 08:03:13'),
	(21, 'Delete Suppliers', 'suppliers.delete', 'Can delete suppliers', '2026-03-31 08:03:13', '2026-03-31 08:03:13'),
	(22, 'Supplier Finance', 'suppliers.finance', 'Can view supplier finance', '2026-03-31 08:03:13', '2026-03-31 08:03:13'),
	(23, 'POS Sales', 'pos.sales', 'Can make sales', '2026-03-31 08:03:13', '2026-03-31 08:03:13'),
	(24, 'Opening Balance', 'opening-balance.view', 'Can view opening balance', '2026-03-31 08:03:13', '2026-03-31 08:03:13'),
	(25, 'Expiry Management', 'expiry.manage', 'Can manage product expiry', '2026-03-31 08:03:13', '2026-03-31 08:03:13'),
	(26, 'View Orders', 'orders.view', 'Can view orders', '2026-03-31 08:03:13', '2026-03-31 08:03:13'),
	(27, 'Cancel Orders', 'orders.cancel', 'Can cancel orders', '2026-03-31 08:03:13', '2026-03-31 08:03:13'),
	(28, 'View Inventory', 'inventory.view', 'Can view inventory', '2026-03-31 08:03:13', '2026-03-31 08:03:13'),
	(29, 'Stock In', 'inventory.stock-in', 'Can add stock', '2026-03-31 08:03:13', '2026-03-31 08:03:13'),
	(30, 'Price Adjustment', 'inventory.adjustment', 'Can adjust inventory', '2026-03-31 08:03:13', '2026-03-31 08:03:13'),
	(31, 'Products Reconciliation', 'products.reconciliation', 'Can manage products reconciliation', '2026-03-31 08:03:13', '2026-03-31 08:03:13'),
	(32, 'Reconciliation Report', 'reports.reconciliation', 'Can view reconciliation report', '2026-03-31 08:03:13', '2026-03-31 08:03:13'),
	(33, 'View Reports', 'reports.view', 'Can view reports', '2026-03-31 08:03:13', '2026-03-31 08:03:13'),
	(34, 'Sales Report', 'reports.sales', 'Can view sales report', '2026-03-31 08:03:13', '2026-03-31 08:03:13'),
	(35, 'Profit Report', 'reports.profit', 'Can view profit report', '2026-03-31 08:03:13', '2026-03-31 08:03:13'),
	(36, 'Inventory Report', 'reports.inventory', 'Can view inventory report', '2026-03-31 08:03:14', '2026-03-31 08:03:14'),
	(37, 'Stock Value Report', 'reports.stock-value', 'Can view detailed stock value report', '2026-03-31 08:03:14', '2026-03-31 08:03:14'),
	(38, 'Supplier Payments Report', 'reports.supplier-payments', 'Can view supplier payments report', '2026-03-31 08:03:14', '2026-03-31 08:03:14'),
	(39, 'Opening Balance Report', 'reports.opening-balance', 'Can view opening balance report', '2026-03-31 08:03:14', '2026-03-31 08:03:14'),
	(40, 'Stock Movement Report', 'reports.stock-movement', 'Can view stock movement report', '2026-03-31 08:03:14', '2026-03-31 08:03:14'),
	(41, 'Cashier Report', 'reports.cashier', 'Can view cashier report', '2026-03-31 08:03:14', '2026-03-31 08:03:14'),
	(42, 'Cashier Sales Report', 'reports.cashier-sales', 'Can view cashier sales report', '2026-03-31 08:03:14', '2026-03-31 08:03:14'),
	(43, 'Disposed Products Report', 'reports.disposed', 'Can view disposed products report', '2026-03-31 08:03:14', '2026-03-31 08:03:14'),
	(44, 'Manage Users', 'users.manage', 'Can manage users', '2026-03-31 08:03:14', '2026-03-31 08:03:14'),
	(45, 'Manage Permissions', 'permissions.manage', 'Can manage user permissions', '2026-03-31 08:03:14', '2026-03-31 08:03:14'),
	(46, 'View Expenses', 'expenses.view', 'Can view expenses', '2026-03-31 08:03:14', '2026-03-31 08:03:14'),
	(47, 'Create Expenses', 'expenses.create', 'Can create expenses', '2026-03-31 08:03:14', '2026-03-31 08:03:14'),
	(48, 'Delete Expenses', 'expenses.delete', 'Can delete expenses', '2026-03-31 08:03:14', '2026-03-31 08:03:14'),
	(49, 'View Cash Flow', 'expenses.cashflow', 'Can view cash flow report', '2026-03-31 08:03:14', '2026-03-31 08:03:14'),
	(50, 'View Tax', 'tax.view', 'Can view tax configuration', '2026-03-31 08:03:14', '2026-03-31 08:03:14'),
	(51, 'Manage Tax', 'tax.manage', 'Can manage tax settings', '2026-03-31 08:03:14', '2026-03-31 08:03:14'),
	(52, 'View e-TIMS', 'tax.etims.view', 'Can view e-TIMS configuration', '2026-03-31 08:03:14', '2026-03-31 08:03:14'),
	(53, 'Manage e-TIMS', 'tax.etims.manage', 'Can manage e-TIMS settings', '2026-03-31 08:03:14', '2026-03-31 08:03:14'),
	(54, 'View M-Pesa', 'mpesa.view', 'Can view M-Pesa configuration', '2026-03-31 08:03:14', '2026-03-31 08:03:14'),
	(55, 'Manage M-Pesa', 'mpesa.manage', 'Can manage M-Pesa settings', '2026-03-31 08:03:14', '2026-03-31 08:03:14'),
	(56, 'View Credit', 'credit.view', 'Can view credit management', '2026-03-31 08:03:14', '2026-03-31 08:03:14'),
	(57, 'Manage Credit', 'credit.manage', 'Can manage credit and receive payments', '2026-03-31 08:03:14', '2026-03-31 08:03:14'),
	(58, 'Send Reminders', 'credit.reminders', 'Can send payment reminders', '2026-03-31 08:03:14', '2026-03-31 08:03:14'),
	(59, 'SMS Settings', 'settings.sms', 'Can manage SMS integration settings', '2026-03-31 08:03:14', '2026-03-31 08:03:14'),
	(60, 'Receipt Settings', 'settings.receipt', 'Can manage receipt and report settings', '2026-03-31 08:03:14', '2026-03-31 08:03:14'),
	(61, 'System Settings', 'settings.system', 'Can manage system settings', '2026-03-31 08:03:14', '2026-03-31 08:03:14'),
	(62, 'M-Pesa Access', 'mpesa.access', 'Can access M-Pesa menu', '2026-03-31 08:03:14', '2026-03-31 08:03:14'),
	(63, 'M-Pesa Transactions Report', 'reports.mpesa-transactions', 'Can view M-Pesa transactions report', '2026-03-31 08:03:14', '2026-03-31 08:03:14');
/*!40000 ALTER TABLE `permissions` ENABLE KEYS */;

-- Dumping structure for table posai.price_adjustment_details
DROP TABLE IF EXISTS `price_adjustment_details`;
CREATE TABLE IF NOT EXISTS `price_adjustment_details` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `price_adjustment_log_id` bigint(20) unsigned NOT NULL,
  `product_id` bigint(20) unsigned NOT NULL,
  `old_cost_price` decimal(10,2) NOT NULL,
  `new_cost_price` decimal(10,2) NOT NULL,
  `old_selling_price` decimal(10,2) NOT NULL,
  `new_selling_price` decimal(10,2) NOT NULL,
  `old_price_2` decimal(10,2) DEFAULT NULL,
  `new_price_2` decimal(10,2) DEFAULT NULL,
  `old_price_3` decimal(10,2) DEFAULT NULL,
  `new_price_3` decimal(10,2) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `price_adjustment_details_price_adjustment_log_id_foreign` (`price_adjustment_log_id`),
  KEY `price_adjustment_details_product_id_foreign` (`product_id`),
  CONSTRAINT `price_adjustment_details_price_adjustment_log_id_foreign` FOREIGN KEY (`price_adjustment_log_id`) REFERENCES `price_adjustment_logs` (`id`) ON DELETE CASCADE,
  CONSTRAINT `price_adjustment_details_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Dumping data for table posai.price_adjustment_details: ~0 rows (approximately)
/*!40000 ALTER TABLE `price_adjustment_details` DISABLE KEYS */;
/*!40000 ALTER TABLE `price_adjustment_details` ENABLE KEYS */;

-- Dumping structure for table posai.price_adjustment_logs
DROP TABLE IF EXISTS `price_adjustment_logs`;
CREATE TABLE IF NOT EXISTS `price_adjustment_logs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `adjustment_type` varchar(255) NOT NULL,
  `operation` varchar(255) NOT NULL,
  `price_type` varchar(255) NOT NULL,
  `adjustment_value` decimal(10,2) NOT NULL,
  `products_updated` int(11) NOT NULL,
  `notes` text,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `price_adjustment_logs_user_id_foreign` (`user_id`),
  CONSTRAINT `price_adjustment_logs_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Dumping data for table posai.price_adjustment_logs: ~0 rows (approximately)
/*!40000 ALTER TABLE `price_adjustment_logs` DISABLE KEYS */;
/*!40000 ALTER TABLE `price_adjustment_logs` ENABLE KEYS */;

-- Dumping structure for table posai.products
DROP TABLE IF EXISTS `products`;
CREATE TABLE IF NOT EXISTS `products` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` bigint(20) unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sku` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `barcode` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cost_price` decimal(10,2) NOT NULL,
  `selling_price` decimal(10,2) NOT NULL,
  `price_2` decimal(12,2) DEFAULT NULL,
  `price_3` decimal(12,2) DEFAULT NULL,
  `price_2_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'e.g., Wholesale, VIP',
  `price_3_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'e.g., Bulk, Special',
  `stock_quantity` decimal(12,2) NOT NULL,
  `low_stock_threshold` int(11) NOT NULL DEFAULT '10',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `description` text COLLATE utf8mb4_unicode_ci,
  `expiry_date` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `unit_of_measure_id` bigint(20) unsigned DEFAULT NULL,
  `branch_id` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `products_sku_unique` (`sku`),
  UNIQUE KEY `products_barcode_unique` (`barcode`),
  KEY `products_category_id_foreign` (`category_id`),
  KEY `products_unit_of_measure_id_foreign` (`unit_of_measure_id`),
  KEY `products_branch_id_foreign` (`branch_id`),
  CONSTRAINT `products_branch_id_foreign` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE SET NULL,
  CONSTRAINT `products_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE,
  CONSTRAINT `products_unit_of_measure_id_foreign` FOREIGN KEY (`unit_of_measure_id`) REFERENCES `unit_of_measures` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=245 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table posai.products: ~214 rows (approximately)
/*!40000 ALTER TABLE `products` DISABLE KEYS */;
REPLACE INTO `products` (`id`, `category_id`, `name`, `sku`, `barcode`, `image`, `cost_price`, `selling_price`, `price_2`, `price_3`, `price_2_name`, `price_3_name`, `stock_quantity`, `low_stock_threshold`, `is_active`, `description`, `expiry_date`, `created_at`, `updated_at`, `unit_of_measure_id`, `branch_id`) VALUES
	(31, 11, '4TH STREET S.R 750ML', '315691', '315691', '522b2fac-ce2a-4a27-964c-41688fdec852.jpg', 920.00, 1400.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 16:58:10', '2026-03-30 16:58:10', 1, NULL),
	(32, 11, '4TH STREET S.W 750ML', '799832', '799832', '8f6bc642-7327-4e07-a62c-6705cd650b08.png', 880.00, 1300.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 17:00:56', '2026-03-30 17:00:56', 1, NULL),
	(33, 12, '58 ORANGE GIN &TONIC CAN', '25845', '25845', '79d2bd41-4128-4c9b-999b-25f97a234a10.webp', 208.00, 260.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 17:03:08', '2026-03-30 17:03:08', 1, NULL),
	(34, 13, 'ALL SEASONS 1LTR', '126593', '126593', '29027e0a-97a4-44f5-8d1e-95cc1c91a25b.jpg', 1050.00, 1600.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 17:06:23', '2026-03-30 17:06:23', 1, NULL),
	(35, 13, 'ALL SEASONS 750ML', '361327', '361327', 'b151b6ec-eb6e-4c17-bcfc-e5dbf2e1af23.jpg', 900.00, 1400.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 17:10:29', '2026-03-30 17:10:29', 1, NULL),
	(36, 13, 'BALLANTINES 1LTR', '10601', '10601', '5042f0dc-4481-45b9-b5a5-f17b9370a76c.jpg', 2100.00, 3100.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 17:12:02', '2026-03-30 17:12:14', 1, NULL),
	(37, 13, 'BALLANTINES 750ML', '389508', '389508', '43b872a0-88e3-4065-9c73-28d7a1e51eba.jpg', 1750.00, 2700.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 17:14:50', '2026-03-30 17:14:50', 1, NULL),
	(38, 12, 'BALOZI GLASS', '803153', '803153', '546f7d99-4d42-4a57-ac11-09a273d52926.jpg', 169.00, 270.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 17:18:40', '2026-03-30 17:19:33', 1, NULL),
	(39, 12, 'BALOZI CAN', '436991', '436991', '61613eb4-4fce-4e31-a8da-840d76063ff8.jpg', 198.00, 250.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 17:20:55', '2026-03-30 17:20:55', 1, NULL),
	(40, 14, 'BEEFEATER PINK 750ML', '369360', '369360', '52b3a020-c55f-43d5-afd8-43c970bd661c.jpg', 2150.00, 3500.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 17:25:18', '2026-03-30 17:25:18', 1, NULL),
	(41, 15, 'BEST CREAM 750ML', '520602', '520602', '0a74c4fa-5b46-4a1e-bd78-20b1a6b6ea7f.jpg', 1047.00, 1400.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 17:28:14', '2026-03-30 17:28:14', 1, NULL),
	(42, 14, 'BEST GIN 250ML', '122104', '122104', '8ab8028e-d9f2-4416-a3f4-5aef37678640.jpg', 255.90, 350.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 17:29:40', '2026-03-30 17:29:40', 1, NULL),
	(43, 14, 'BEST GIN 750ML', '612044', '612044', '163fffd5-6372-41c8-a997-0a296533dbba.png', 751.00, 950.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 17:32:26', '2026-03-30 17:32:26', 1, NULL),
	(44, 16, 'BEST VODKA 250ML', '980656', '980656', '7175461f-9cbb-4e71-aea0-09a03804381a.jpg', 240.00, 320.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 17:35:15', '2026-03-30 17:35:15', 1, NULL),
	(45, 16, 'BEST VODKA 750ML', '201834', '201834', '2af1015e-e0b2-4506-8487-d53508667ab2.png', 685.00, 900.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 17:36:16', '2026-03-30 17:36:16', 1, NULL),
	(46, 13, 'BEST WHISKY 250ML', '625919', '625919', '51211a24-b6be-403a-9806-ec67a55e1f69.png', 303.40, 400.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 17:37:19', '2026-03-30 17:37:19', 1, NULL),
	(47, 13, 'BEST WHISKY 750ML', '710334', '710334', '2b187282-5683-4d5d-907d-e1bcffa4fe22.jpg', 1015.00, 1500.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 17:38:14', '2026-03-30 17:38:14', 1, NULL),
	(48, 13, 'BLACK & WHITE 1LTR', '205530', '205530', '76b77ae3-f098-418e-8b3d-81639f6352b4.jpg', 1400.00, 2100.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 17:49:31', '2026-03-30 17:49:31', 1, NULL),
	(49, 13, 'BLACK & WHITE 375ML', '255118', '255118', 'fdf08252-4ba4-46a2-8860-d71045bb7368.jpeg', 560.00, 800.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 17:50:49', '2026-03-30 17:50:49', 1, NULL),
	(50, 13, 'BLACK & WHITE 750ML', '738988', '738988', 'a87966dd-84c7-45b8-ac70-1fbe36dfedd7.webp', 1150.00, 1500.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 17:52:02', '2026-03-30 17:52:02', 1, NULL),
	(51, 12, 'BLACK ICE', '680966', '680966', 'c7186855-4306-4532-b069-b902db6b6a4b.jpg', 175.00, 250.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 17:53:25', '2026-03-30 17:53:25', 1, NULL),
	(52, 13, 'BLACK LABEL 1LTR', '298849', '298849', '6706df7d-3eb4-46a8-94cf-d10bfe601221.png', 3620.00, 4800.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 17:55:05', '2026-03-30 17:55:05', 1, NULL),
	(53, 13, 'BLACK LABEL 250ML', '699778', '699778', 'da791ce0-27ea-4366-8c45-5dc8a624fef3.jpg', 1100.00, 1500.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 17:56:04', '2026-03-30 17:56:04', 1, NULL),
	(54, 13, 'BLACK LABEL 375ML', '331812', '331812', '4b4b3bd4-5e36-4632-83de-d566a6f4fe69.jpeg', 1520.00, 2200.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 17:57:02', '2026-03-30 17:57:02', 1, NULL),
	(55, 13, 'BLACK LABEL 750ML', '785591', '785591', 'bc9b6c4f-7e16-4441-9a19-d09d60491cfc.jpg', 3150.00, 4200.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 17:57:59', '2026-03-30 17:57:59', 1, NULL),
	(56, 17, 'BLEND CIGARETTE', '488488', '488488', 'd9b3eefd-7c52-444e-9ed4-d97332624e1c.jpg', 5.75, 20.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 18:00:50', '2026-03-30 18:01:19', 1, NULL),
	(57, 16, 'BLUE ICE 250ML', '603917', '603917', '5eaa6a87-8b41-44fa-8c3b-831686ee8c87.jpg', 149.00, 200.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 18:11:33', '2026-03-30 18:11:33', 1, NULL),
	(58, 13, 'BOND 7 250ML', '167372', '167372', '0fe4fdb5-f1a2-4db5-84bb-fcb377a40d14.jpg', 405.00, 600.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 18:12:27', '2026-03-30 18:12:27', 1, NULL),
	(59, 13, 'BOND 7 350ML', '313002', '313002', '0ace6445-30a8-4fa3-86e5-6aa90578cd44.jpg', 560.00, 800.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 18:13:16', '2026-03-30 18:13:16', 1, NULL),
	(60, 13, 'BOND 7 750ML', '47713', '47713', 'b2f74239-8243-48ef-b998-133dacff54b7.jpg', 1225.00, 1600.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 18:14:12', '2026-03-30 18:14:12', 1, NULL),
	(61, 18, 'CAMINO GOLD 750ML', '555355', '555355', '8c9cf99b-ad5e-4ed0-b4e0-4659ad331d4d.jpeg', 1850.00, 2500.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 18:15:33', '2026-03-30 18:15:33', 1, NULL),
	(62, 18, 'CAMINO WHITE 750ML', '10074', '10074', '4d452b58-52eb-41c1-aa1e-857dad9aa6c6.jpg', 2100.00, 3200.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 18:17:17', '2026-03-30 18:17:17', 1, NULL),
	(63, 11, 'CAPRICE D.R 1LTR', '233413', '233413', 'f314ba04-2c17-4e51-9ea2-96524427223e.jpg', 882.99, 1100.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 18:19:21', '2026-03-30 18:19:21', 1, NULL),
	(64, 11, 'CAPRICE D.W 1LTR', '951561', '951561', '0ac712b5-bb04-4e36-8ab9-79341e6c441f.jpeg', 882.99, 1100.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 18:20:29', '2026-03-30 18:20:29', 1, NULL),
	(65, 11, 'CAPRICE S.R 1LTR', '180115', '180115', '3a751f03-74a7-4fe7-adc5-b63b3041a1b2.png', 882.00, 1100.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 18:23:08', '2026-03-30 18:23:08', 1, NULL),
	(66, 11, 'CAPRICE S.W 1LTR', '322847', '322847', 'ea8127e8-1257-48ce-a6b3-a73308ed2738.png', 882.00, 1100.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 18:26:20', '2026-03-30 18:26:20', 1, NULL),
	(67, 19, 'CAPTAIN MORGAN GOLD 250ML', '215771', '215771', 'e0e6eba1-2b02-4c2a-9db3-396b9277b4b9.jpg', 336.00, 420.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 18:28:37', '2026-03-30 18:28:37', 1, NULL),
	(68, 19, 'CAPTAIN MORGAN GOLD 750ML', '467987', '467987', '8fad213f-b805-4a90-a85b-0b2d33d82df3.jpg', 920.00, 1300.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 18:30:03', '2026-03-30 18:30:03', 1, NULL),
	(69, 15, 'CAPTAIN MORGAN MUCK PIT 250ML', '866080', '866080', 'bd78fed0-6259-4825-9bd8-faa20f702234.webp', 339.00, 450.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 18:57:12', '2026-03-30 18:57:12', 1, NULL),
	(70, 15, 'CAPTAIN MORGAN MUCK PIT 70ML', '628237', '628237', 'a721497d-0244-4fd4-a2f7-0cef1dc8f1d4.webp', 1060.00, 1450.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 18:59:54', '2026-03-30 18:59:54', 1, NULL),
	(71, 14, 'CARIBIA 250ML', '557289', '557289', '6832399a-5e29-4d45-973a-952f4af989c5.jpg', 242.00, 300.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 19:01:35', '2026-03-30 19:01:35', 1, NULL),
	(72, 14, 'CARIBIA 350ML', '650383', '650383', '0a2903e5-5b3e-4907-b46a-2f1c3a3b4130.jpg', 354.00, 450.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 19:02:42', '2026-03-30 19:02:42', 1, NULL),
	(73, 14, 'CARIBIA 750ML', '321956', '321956', 'e6128e74-4ef4-40d7-847d-d37d96158ba5.jpg', 710.00, 900.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 19:03:57', '2026-03-30 19:03:57', 1, NULL),
	(74, 11, 'CASABUENA RED 1LTR', '491586', '491586', 'ff0efe0c-349b-4ac0-ae65-5c9e0480fa34.jpg', 726.64, 1100.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 19:05:20', '2026-03-30 19:05:20', 1, NULL),
	(75, 13, 'CHIVAS 12YRS 750ML', '879826', '879826', '362c3524-d539-4abd-bd8f-13bf207d7123.webp', 3000.00, 4500.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 19:06:35', '2026-03-30 19:06:35', 1, NULL),
	(76, 14, 'CHROME GIN 250ML', '981662', '981662', '5ba61e6b-4525-4008-aba3-9ca2ee1a4dcf.webp', 208.00, 300.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 19:07:36', '2026-03-30 19:07:36', 1, NULL),
	(77, 14, 'CHROME GIN 750ML', '529485', '529485', 'b576de6d-785c-4284-a276-dea3f0d46cbb.jpg', 560.00, 800.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 19:08:24', '2026-03-30 19:08:24', 1, NULL),
	(78, 16, 'CHROME LEMON 250ML', '70140', '70140', 'a7437954-acef-4681-b8e1-e78615d2cc2c.webp', 208.00, 300.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 19:10:17', '2026-03-30 19:10:17', 1, NULL),
	(79, 16, 'CHROME VODKA 250ML', '651857', '651857', 'ada989ea-688f-4444-a80e-40b9a22422e2.webp', 208.00, 300.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 19:11:11', '2026-03-30 19:11:11', 1, NULL),
	(80, 16, 'CHROME VODKA 750ML', '810860', '810860', 'c7445757-9e18-4cf7-88d6-c8cb67ad7238.jpg', 560.00, 800.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 19:12:01', '2026-03-30 19:12:01', 1, NULL),
	(81, 16, 'CIROC 750ML', '831598', '831598', '1338f59c-32fd-48c2-b58f-49fe34758a60.jpg', 3750.00, 6200.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 19:13:15', '2026-03-30 19:13:15', 1, NULL),
	(82, 20, 'COUNTY 250ML', '20359', '20359', '9f56847c-2384-412c-881a-660c89e82764.jpg', 232.00, 300.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 19:14:21', '2026-03-30 19:21:18', 1, NULL),
	(83, 20, 'COUNTY 750ML', '982465', '982465', '0a410905-ade7-4559-869c-214f208fcbf8.webp', 650.00, 850.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 19:24:23', '2026-03-30 19:24:23', 1, NULL),
	(84, 13, 'CRAZY COCK 250ML', '497353', '497353', 'b4662978-19d4-4b45-84dd-60aa71087de1.png', 380.00, 500.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 19:25:35', '2026-03-30 19:25:35', 1, NULL),
	(85, 13, 'CRAZY COCK 750ML', '833139', '833139', '65a87d04-be39-4905-ab08-7d4409d0fe8a.png', 970.00, 1500.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 19:26:40', '2026-03-30 19:26:40', 1, NULL),
	(86, 21, 'DELMONTE APPLE 1LTR', '388939', '388939', '6d2bb3bc-7db2-403b-bc10-9e38b9fa5811.jpg', 245.00, 300.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 19:28:25', '2026-03-30 19:28:25', 1, NULL),
	(87, 21, 'DELMONTE MANGO 1LTR', '758478', '758478', 'f89b09c0-b860-4b02-b522-a80e4b550f93.webp', 250.00, 300.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 19:29:35', '2026-03-30 19:29:35', 1, NULL),
	(88, 21, 'DELMONTE MIXXED BERRIES', '938083', '938083', 'e086425a-f6d3-4bb4-b0bf-ae0ea1da1939.webp', 245.00, 300.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 19:30:43', '2026-03-30 19:30:43', 1, NULL),
	(89, 21, 'DELMONTE TROPICAL 1LTR', '280361', '280361', '811e81be-7d07-45d0-acdf-3c7d8bc9378c.webp', 250.00, 300.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 19:31:41', '2026-03-30 19:31:41', 1, NULL),
	(90, 21, 'DEMONTE APPLE', '260476', '260476', 'a567c306-cdce-42fa-9c44-a4804f08f7e9.jpg', 250.00, 300.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 19:32:50', '2026-03-30 19:32:50', 1, NULL),
	(91, 12, 'DESPARADO', '750186', '750186', '647e6cfa-8c31-4cc2-87dd-5e7049a8bdf0.jpg', 284.00, 350.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 19:46:59', '2026-03-30 19:46:59', 1, NULL),
	(92, 18, 'DONJULIO', '133688', '133688', '6d1439c5-f824-420f-af35-a22f4ea50072.jpg', 7350.00, 12000.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 19:48:37', '2026-03-30 19:48:37', 1, NULL),
	(93, 17, 'DOUBLE SWITCH', '148369', '148369', '113ee705-c6b9-4a7d-ab0e-d41293de7146.jpg', 26.00, 30.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 19:50:45', '2026-03-30 19:50:45', 1, NULL),
	(94, 17, 'EMBASSY', '552150', '552150', '31dc3ca3-03df-4ba9-8073-d2b363a1052b.jpg', 21.75, 30.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 19:51:56', '2026-03-30 19:51:56', 1, NULL),
	(95, 13, 'FAMOUS GROUSE 1LTR', '235540', '235540', 'e8590c6c-92f8-4ed2-9769-2be248dec6ef.png', 1900.00, 2900.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 19:53:24', '2026-03-30 19:53:24', 1, NULL),
	(96, 13, 'FAMOUS GROUSE 750ML', '255186', '255186', '1be64886-0f88-4462-84cc-7a91bf9b9927.jpg', 1600.00, 2600.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 19:54:25', '2026-03-30 19:54:25', 1, NULL),
	(97, 12, 'FAXE', '289260', '289260', '65f4fb7c-08cb-4ae5-9464-81c1a7b65534.jpg', 280.00, 350.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 19:56:30', '2026-03-30 19:56:30', 1, NULL),
	(98, 16, 'FLIRT GREEN APPLE 1LTR', '884547', '884547', '439bffef-2e73-4875-af52-37935f13225a.webp', 1000.00, 1700.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 19:57:32', '2026-03-30 19:57:32', 1, NULL),
	(99, 16, 'FLIRT VODKA GREEN 750ML', '552350', '552350', 'd1e876b6-a42e-4010-9108-9c5689c4f0fe.webp', 950.00, 1400.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 19:58:37', '2026-03-30 19:59:29', 1, NULL),
	(100, 11, 'FOUR COUSINS S.R 750ML', '835647', '835647', '703426e6-ead8-4100-a121-870b43d6f401.webp', 790.00, 1400.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 20:00:55', '2026-03-30 20:00:55', 1, NULL),
	(101, 11, 'FOUR COUSINS S.W 750ML', '27614', '27614', 'c81df972-9bb7-4ecc-84f5-9cda1bea69c2.webp', 0.00, 1400.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 20:01:47', '2026-03-30 20:01:47', 1, NULL),
	(102, 20, 'GENERAL MEAKINS 250ML', '383725', '383725', '2373ff87-74bb-483f-9350-6248193271ec.jpg', 209.00, 350.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 20:02:46', '2026-03-30 20:02:46', 1, NULL),
	(103, 20, 'GENERAL MEAKINS 750ML', '846217', '846217', 'f14d10a1-b928-4174-aac3-2b7b8c45a2e2.jpg', 635.00, 850.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 20:03:47', '2026-03-30 20:03:47', 1, NULL),
	(104, 14, 'GILBEYS 250ML', '469687', '469687', '3935ebde-1a1c-490a-ae74-d1f872d54d14.jpg', 576.00, 600.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 20:05:10', '2026-03-30 20:05:10', 1, NULL),
	(105, 14, 'GILBEYS 350ML', '291881', '291881', '99150d77-93b1-40d6-b15a-d86d3fe60d3f.jpg', 576.00, 800.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 20:06:43', '2026-03-30 20:06:43', 1, NULL),
	(106, 14, 'GILBEYS 750ML', '535027', '535027', 'd8dc6440-1bf8-4d48-9d79-9c60972f0978.jpg', 1225.00, 1600.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 20:09:37', '2026-03-30 20:09:37', 1, NULL),
	(107, 13, 'GLENFIDDICH 12YRS 750ML', '70887', '70887', '6ab6646e-093d-4c01-95f0-d9590fa409eb.jpg', 5700.00, 8500.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 20:11:02', '2026-03-30 20:11:02', 1, NULL),
	(108, 14, 'GORDONS  350ML', '759049', '759049', 'fd707a26-cdb1-4c39-badd-8de5d9e67a63.jpg', 960.00, 1150.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 20:11:53', '2026-03-30 20:11:53', 1, NULL),
	(109, 14, 'GORDONS  PREMIUM PINK GIN', '7509', '7509', '7a9c039d-0e4d-49c4-a671-dbfcd42c32fd.webp', 2200.00, 3000.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 20:13:18', '2026-03-30 20:13:18', 1, NULL),
	(110, 14, 'GORDONS 1LTR', '32492', '32492', 'ae0912ed-07eb-4ef2-b632-e14a630a60f5.jpg', 2280.00, 3200.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 20:14:31', '2026-03-30 20:14:31', 1, NULL),
	(111, 14, 'GORDONS 750ML', '807639', '807639', '1d36d048-3198-4fdb-8ac0-dd8b0b0b81cb.jpg', 1920.00, 2800.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 20:15:27', '2026-03-30 20:15:27', 1, NULL),
	(112, 12, 'GORDONS PINK', '47420', '47420', '268295a0-cc9b-4c3f-beee-68a0bbfe148f.jpg', 190.00, 250.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 20:16:36', '2026-03-30 20:16:36', 1, NULL),
	(113, 12, 'GORDONS PURPLE', '29106', '29106', '9ac67445-5e23-4c2e-95f7-51335e7a5981.jpg', 192.00, 250.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 20:17:30', '2026-03-30 20:17:30', 1, NULL),
	(114, 13, 'GRANTS 1LTR', '338778', '338778', '012ee52a-9bee-468c-bda8-929f4a7a888a.jpg', 2000.00, 2600.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 20:19:08', '2026-03-30 20:19:08', 1, NULL),
	(115, 13, 'GRANTS 750ML', '956511', '956511', '1ceedca0-f0fb-4ef9-b990-7e5ae8254e72.jpg', 1600.00, 2400.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 20:20:31', '2026-03-30 20:20:31', 1, NULL),
	(116, 13, 'GRENFIDDICH 700ML', '585086', '585086', 'e4a81fa3-a6cf-4c03-838e-7ab8670c3deb.webp', 5700.00, 8500.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 20:21:51', '2026-03-30 20:21:51', 1, NULL),
	(117, 13, 'GUARANA CAN', '717441', '717441', '01f5d325-eb27-443a-a214-3b75bf35eb23.webp', 176.00, 250.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 20:23:14', '2026-03-30 20:23:14', 1, NULL),
	(118, 12, 'GUINESS CAN', '436827', '436827', '18d49e0a-d140-4a5e-bcfc-27d8f46202ff.png', 213.00, 280.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 20:30:14', '2026-03-30 20:30:14', 1, NULL),
	(119, 12, 'GUINESS GLASS', '822465', '822465', '1eb72142-2abc-4c5f-948c-70d62e42d0ce.jpg', 204.00, 300.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 20:31:16', '2026-03-30 20:31:16', 1, NULL),
	(120, 12, 'GUINESS SMOOTH', '549742', '549742', 'ac75fcb8-20bc-43cc-9b4e-f25474b576bc.jpg', 198.00, 250.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 20:32:02', '2026-03-30 20:32:02', 1, NULL),
	(121, 13, 'HAMPTOM DRUM 750ML', '979852', '979852', 'a3a7a07c-8b5d-4417-81b2-d701bf9b89c2.jpg', 1420.00, 2000.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 20:32:49', '2026-03-30 20:32:49', 1, NULL),
	(122, 12, 'HEINEKEN 0.0', '607899', '607899', '47f30a03-afab-464f-9fb9-40ce5e805eab.jpg', 202.85, 250.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 20:33:37', '2026-03-30 20:33:37', 1, NULL),
	(123, 12, 'HEINEKEN CAN', '476220', '476220', 'ef39cdc1-229f-4a96-8105-7b1939d2f8ac.jpg', 275.00, 350.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 20:34:24', '2026-03-30 20:34:24', 1, NULL),
	(124, 12, 'HEINEKEN GLASS 330ML', '531520', '531520', '8f41ea9e-9619-4312-b35b-752555c92ce6.jpg', 235.00, 350.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 20:35:39', '2026-03-30 20:35:39', 1, NULL),
	(125, 22, 'HENESSY VS 1LTR', '221061', '221061', 'ebd84076-70ce-4e2f-8cfb-79f8dd7dea82.jpg', 6500.00, 9000.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 20:42:43', '2026-03-30 20:42:43', 1, NULL),
	(126, 22, 'HENESSY VS 750ML', '360507', '360507', '1640e83e-5bf3-4a28-9de6-16d20a86fe4a.webp', 4500.00, 6500.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 20:44:00', '2026-03-30 20:44:00', 1, NULL),
	(127, 13, 'HENNESSY VSOP 1LTR', '149866', '149866', '2af872f6-7987-4d1b-9107-31361d9189fd.jpg', 9500.00, 13000.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 20:44:54', '2026-03-30 20:44:54', 1, NULL),
	(128, 13, 'HERDMAN 250ML', '670273', '670273', 'c3b168ad-9c7f-4dce-aff2-291ca4a7878c.jpg', 359.00, 500.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 20:46:58', '2026-03-30 20:46:58', 1, NULL),
	(129, 13, 'HERDSMAN 500ML', '735791', '735791', 'e6f5195c-0b0b-4cd7-9923-3e6f16765722.webp', 750.00, 1000.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 20:48:31', '2026-03-30 20:48:31', 1, NULL),
	(130, 13, 'HUNTERS CHOICE 250ML', '864531', '864531', '7f40daeb-50be-42da-aab4-49b0b12e8ce2.jpg', 295.00, 400.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-30 20:50:02', '2026-03-30 20:50:02', 1, NULL),
	(131, 13, 'HUNTERS CHOICE 350ML', '532840', '532840', 'b19c6667-b105-4b4c-8556-efd5e21ecd9a.jpg', 422.00, 570.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 08:17:03', '2026-03-31 08:17:03', 1, NULL),
	(132, 13, 'HUNTERS CHOICE 750ML', '102951', '102951', 'c7d4bcb5-591d-4f42-b8c2-229f5cf93ebb.jpg', 899.00, 1200.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 08:27:18', '2026-03-31 08:27:18', 1, NULL),
	(133, 12, 'HUNTERS DRY', '329903', '329903', 'e4366086-0e3c-4765-a66a-eff0b711fc8f.webp', 198.00, 350.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 08:28:26', '2026-03-31 08:28:26', 1, NULL),
	(134, 12, 'HUNTERS GOLD', '916875', '916875', '79dd8b2c-5675-4dec-be14-1a2ed9d1bab4.webp', 198.00, 350.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 08:29:33', '2026-03-31 08:29:33', 1, NULL),
	(135, 13, 'JACK DANIELS 1LTR', '324541', '324541', 'e40584f4-2fc5-49a3-9cc2-89ede2eef298.jpg', 3050.00, 4500.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 08:30:29', '2026-03-31 08:30:29', 1, NULL),
	(136, 13, 'JACK DANIELS 750ML', '264670', '264670', 'd7ff6d4c-2923-40c4-b5dd-69a19dbe6a36.jpg', 2700.00, 4000.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 08:31:48', '2026-03-31 08:31:48', 1, NULL),
	(137, 15, 'JAGERMEIFTER 1LTR', '747772', '747772', '558f6703-6c9f-4464-8c81-1fa763e4d3ca.jpg', 2650.00, 3800.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 08:32:49', '2026-03-31 08:33:43', 1, NULL),
	(138, 15, 'JAGERMEIFTER 750ML', '421558', '421558', '0ff91344-ce3c-4b59-91e4-061bc23c3ac4.webp', 2000.00, 3200.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 08:35:26', '2026-03-31 08:35:26', 1, NULL),
	(139, 13, 'JAMESON 1LTR', '823856', '823856', '92a7b179-3fe5-4bce-b09e-fc496eb85bc7.jpg', 2850.00, 3500.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 08:36:35', '2026-03-31 08:36:35', 1, NULL),
	(140, 13, 'JAMESON 750ML', '369582', '369582', 'b576f9ff-111e-4c97-be0f-0babc1cce0a4.png', 2450.00, 2700.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 08:37:28', '2026-03-31 08:37:28', 1, NULL),
	(141, 13, 'JAMESON BLACK BARREL 750ML', '996815', '996815', 'ea40d35b-d8c7-478d-b2eb-09cb911c1f3d.jpeg', 4200.00, 5500.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 08:43:23', '2026-03-31 08:43:23', 1, NULL),
	(142, 12, 'JINRO SOJU 350ML', '53123', '53123', 'a5992f00-d454-40a4-b468-e3a69a482aa6.jpg', 350.00, 420.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 08:45:21', '2026-03-31 08:45:21', 1, NULL),
	(143, 13, 'JOHN BARR BLACK  1 LTR', '256339', '256339', '733c5cbd-4fe1-4feb-9271-81c312681ade.jpg', 1700.00, 2600.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 08:46:25', '2026-03-31 08:46:25', 1, NULL),
	(144, 13, 'JOHN BARR BLACK 750ML', '570130', '570130', '7167d704-504f-4aae-87cf-264cab895320.webp', 1550.00, 2200.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 08:47:07', '2026-03-31 08:47:07', 1, NULL),
	(145, 13, 'JOHN BARR RED 1LTR', '751733', '751733', '496b6bb7-d61f-461f-97a5-f5f365039376.jpg', 1300.00, 2400.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 08:48:03', '2026-03-31 08:48:03', 1, NULL),
	(146, 13, 'JOHN BARR RED 750ML', '129505', '129505', '946aee87-86ce-4179-a8c6-f18f58a8763e.webp', 1250.00, 2200.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 08:48:52', '2026-03-31 08:48:52', 1, NULL),
	(147, 13, 'JOHNNIE WALKER BLONDE 750ML', '757498', '757498', 'ceb52dd3-5496-48e8-a194-24ea8f3b8d58.webp', 1991.00, 2500.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 08:56:03', '2026-03-31 08:56:03', 1, NULL),
	(148, 20, 'KANE 250ML', '908311', '908311', '7ef74640-1229-46b8-8310-b5bfdc3d70bf.jpeg', 192.00, 270.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 09:00:27', '2026-03-31 09:00:27', 1, NULL),
	(149, 20, 'KANE 750ML', '35145', '35145', 'a436cb68-4ee2-4a1e-a10f-a54170ba4584.jpg', 584.00, 800.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 09:01:18', '2026-03-31 09:01:18', 1, NULL),
	(150, 20, 'KC LEMON AND GINGER 250ML', '650530', '650530', '04cf6434-8ca1-441d-a65c-9fa82cb0a526.webp', 250.00, 350.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 09:03:08', '2026-03-31 09:03:08', 1, NULL),
	(151, 20, 'KC LEMON AND GINGER 750ML', '344789', '344789', 'e11cff33-ab15-42c6-8eab-8427652d093d.webp', 655.00, 950.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 11:04:00', '2026-03-31 11:04:00', 1, NULL),
	(152, 20, 'KC PINEAPPLE 250ML', '106604', '106604', '3cd33056-d189-494b-ad71-580744b2cdce.jpeg', 250.00, 320.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 11:05:05', '2026-03-31 11:05:05', 1, NULL),
	(153, 20, 'KC PINEAPPLE 750ML', '592750', '592750', '4e816cfe-8fa9-4d2a-979e-6cc2e5583d39.jpg', 655.00, 900.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 11:12:01', '2026-03-31 11:12:01', 1, NULL),
	(154, 20, 'KENYA CANE SMOOTH 250 ML', '162710', '162710', NULL, 256.00, 320.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 11:13:02', '2026-03-31 11:13:02', 1, NULL),
	(155, 20, 'KENYA CANE 350ML', '493330', '493330', '8899016e-38e3-4dc6-ba94-317d3d1c63dc.jpg', 352.00, 530.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 11:14:03', '2026-03-31 11:14:03', 1, NULL),
	(156, 20, 'KENYA CANE SMOOTH 750ML', '794710', '794710', 'a570fb9f-b07b-42d1-ad15-7643c688d048.jpg', 672.00, 900.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 11:14:58', '2026-03-31 11:14:58', 1, NULL),
	(157, 16, 'KIBAO 250ML', '904709', '904709', '630f69f2-eea8-463b-9a4c-f30c0a0d998d.jpg', 226.00, 270.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 11:16:14', '2026-03-31 11:16:44', 1, NULL),
	(158, 16, 'KIBAO 350ML', '275032', '275032', 'abac9065-e30e-415f-9813-989398a88e48.jpg', 337.00, 450.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 11:17:40', '2026-03-31 11:17:40', 1, NULL),
	(159, 16, 'KIBAO 750ML', '584770', '584770', 'fa9fd4e4-7e6e-48b1-abef-46489a8bafea.webp', 635.00, 800.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 11:18:21', '2026-03-31 11:18:21', 1, NULL),
	(160, 12, 'KO DRY CIDER 500ML CAN', '769367', '769367', '5c888c56-1653-4b0d-a7bf-cd82364e71b4.jpg', 230.00, 300.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 11:19:35', '2026-03-31 11:19:35', 1, NULL),
	(161, 12, 'KO GLASS', '210694', '210694', NULL, 230.00, 300.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 11:20:44', '2026-03-31 11:20:44', 1, NULL),
	(162, 20, 'KONYAGI 250ML', '956822', '956822', 'f0255ec3-081b-44f9-974e-ec37b70ce605.jpg', 230.00, 360.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 11:22:01', '2026-03-31 11:22:01', 1, NULL),
	(163, 20, 'KONYAGI 500ML', '553528', '553528', '1c370895-0d8e-4f34-8948-1b35f8db617d.jpg', 445.00, 650.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 11:22:48', '2026-03-31 11:22:48', 1, NULL),
	(164, 20, 'KONYAGI 750ML', '259907', '259907', '1a86962b-e282-4c1f-ae30-4a4f7fb8ec85.jpg', 655.00, 1000.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 11:23:56', '2026-03-31 11:23:56', 1, NULL),
	(165, 14, 'LEADING WARAGI 250ML', '302478', '302478', '8f897b63-3f13-4514-9828-29d063293e77.jpg', 200.00, 270.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 11:28:38', '2026-03-31 11:28:38', 1, NULL),
	(166, 14, 'LEADING WARAGI 750ML', '113634', '113634', '94c2385c-8382-4219-aa4d-e2486d0c2bec.jpg', 600.00, 850.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 11:29:23', '2026-03-31 11:29:23', 1, NULL),
	(167, 23, 'LEMONADE', '36307', '36307', NULL, 40.00, 60.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 11:31:54', '2026-03-31 11:31:54', 1, NULL),
	(168, 19, 'MALIBU 700ML', '429487', '429487', '1b1b6888-da01-444c-a73d-b786eb56d607.jpg', 1700.00, 2500.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 11:32:49', '2026-03-31 11:32:49', 1, NULL),
	(169, 12, 'MANYATTA GLASS', '658584', '658584', '28947cb0-49dc-4d06-8fe2-e07a06fa6f26.png', 223.00, 300.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 11:34:49', '2026-03-31 11:34:49', 1, NULL),
	(170, 12, 'MANYATTA CAN', '695435', '695435', '32a2344e-154e-4662-a7ee-4e22d99310b5.jpg', 235.00, 300.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 11:35:43', '2026-03-31 11:35:43', 1, NULL),
	(171, 22, 'MARTELL VS 750ML', '740026', '740026', '28a3655b-5361-44da-b1cb-9eea50fbf603.webp', 4650.00, 7000.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 11:37:06', '2026-03-31 11:37:06', 1, NULL),
	(172, 23, 'MINUTE MAID 1LTR', '20455', '20455', NULL, 133.00, 160.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 11:37:37', '2026-03-31 11:37:37', 1, NULL),
	(173, 23, 'MINUTE MAID 400ML', '450883', '450883', NULL, 67.00, 80.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 11:38:07', '2026-03-31 11:38:07', 1, NULL),
	(174, 23, 'MONSTER', '818664', '818664', 'a2b8f385-b1b5-491a-bfc4-7db3dbb9529c.webp', 200.00, 250.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 11:39:46', '2026-03-31 11:39:46', 1, NULL),
	(175, 11, 'MUCHO MÁS RED 750ML', '163954', '163954', '8b2a0730-cd0d-4616-a29a-3d6075749e6c.png', 1865.00, 2500.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 11:41:03', '2026-03-31 11:41:03', 1, NULL),
	(176, 12, 'OJ BEER 500ML', '954722', '954722', '6cd2a8ef-ec13-465a-8b4a-2b8ecb3a8e4a.png', 300.00, 350.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 11:42:15', '2026-03-31 11:45:53', 1, NULL),
	(177, 24, 'ORIJIN 250ML', '906057', '906057', 'dac28803-bfa4-4312-8569-4a441eb970db.jpg', 232.00, 300.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 11:47:19', '2026-03-31 11:47:19', 1, NULL),
	(178, 24, 'ORIJIN 750ML', '359175', '359175', 'b379ab0e-bccd-4d3d-8cd1-4c6423cb60df.jpg', 605.00, 850.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 11:48:03', '2026-03-31 11:48:03', 1, NULL),
	(179, 17, 'PALLMALL CIGARETTE', '431497', '431497', 'af063c64-551d-4961-9d2b-c73cdddc3a09.jpg', 8.00, 10.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 11:49:05', '2026-03-31 11:49:05', 1, NULL),
	(180, 12, 'PILSNER CAN 500ML', '438321', '438321', 'cf0eec35-f240-487b-b30d-eb74e463aa63.png', 198.00, 250.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 11:50:17', '2026-03-31 11:50:17', 1, NULL),
	(181, 12, 'SMIRNOFF ICE PINEAPPLE PUNCH 33OML', '964709', '964709', 'ae0fd004-e216-4253-9531-8e1dff77a20d.jpg', 175.00, 250.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 11:51:31', '2026-03-31 11:51:31', 1, NULL),
	(182, 23, 'PREDATOR', '905337', '905337', NULL, 54.00, 70.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 11:52:08', '2026-03-31 11:52:08', 1, NULL),
	(183, 23, 'RED BULL', '955489', '955489', 'deecaae1-30a0-4cd1-8942-15edcb2e265f.webp', 185.00, 250.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 11:52:55', '2026-03-31 11:52:55', 1, NULL),
	(184, 13, 'RED LABEL 1LTR', '657906', '657906', 'a7abb1da-9d3b-40a9-b367-e213f5a6081b.webp', 2080.00, 2800.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 11:54:05', '2026-03-31 11:54:05', 1, NULL),
	(185, 13, 'RED LABEL 250ML', '948781', '948781', 'c93e6a36-c6d5-4a99-8b75-605ee39addf9.jpg', 600.00, 800.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 11:55:28', '2026-03-31 11:55:28', 1, NULL),
	(186, 13, 'RED LABEL 375ML', '97239', '97239', '3736b700-8150-40b1-b0e7-e27c8e7ecaab.png', 840.00, 1200.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 11:56:49', '2026-03-31 11:56:49', 1, NULL),
	(187, 13, 'RED LABEL 750ML', '710431', '710431', '7fc29def-89d5-42d7-a97a-3b864e35fa32.jpg', 1780.00, 2300.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 12:01:47', '2026-03-31 12:01:47', 1, NULL),
	(188, 24, 'RICHIOT 750ML', '656704', '656704', '35497342-2231-4995-a4f9-d0a072908c96.jpg', 1225.00, 1700.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 12:02:53', '2026-03-31 12:02:53', 1, NULL),
	(189, 24, 'RICHOT 250ML', '11937', '11937', 'd9e213c2-2a58-4f55-9556-5550a7fcbd90.jpg', 405.00, 450.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 12:03:53', '2026-03-31 12:03:53', 1, NULL),
	(190, 24, 'RICHOT 350ML', '813215', '813215', 'a4f82e04-8042-481b-b8f7-c906a8b8a950.jpg', 560.00, 800.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 12:04:48', '2026-03-31 12:04:48', 1, NULL),
	(191, 11, 'ROBERTSON SWEET RED 750 ML', '839917', '839917', 'aa7dde95-c261-4ea5-b7a4-97eb1c369858.png', 950.00, 1400.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 12:06:12', '2026-03-31 12:06:12', 1, NULL),
	(192, 11, 'ROSSO NOBILE CHERRY 750ML', '682283', '682283', '42354102-5b9b-4d39-a1f8-37f440b6ad17.jpg', 1250.00, 2000.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 12:07:13', '2026-03-31 12:07:13', 1, NULL),
	(193, 17, 'SAFARI CIGARETTE', '564372', '564372', NULL, 11.00, 15.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 12:07:42', '2026-03-31 12:07:42', 1, NULL),
	(194, 17, 'SAFARI MENTHOL CIGARETTE', '9002', '9002', NULL, 11.00, 15.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 12:08:20', '2026-03-31 12:08:20', 1, NULL),
	(195, 25, 'SAFARI WATER 1LTR', '974744', '974744', '6e4b1b00-ef47-440b-89b7-3502f4bfed22.jpg', 42.00, 100.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 12:09:12', '2026-03-31 12:09:12', 1, NULL),
	(196, 25, 'SAFARI WATER 500ML', '622569', '622569', '53d6aaf8-7585-445b-8b4b-8e67bd3e6283.jpg', 20.00, 50.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 12:09:38', '2026-03-31 12:09:38', 1, NULL),
	(197, 12, 'SAVANNA ANGRY  LEMON 330ML', '579604', '579604', 'ecf7e7ea-33c5-48ea-a9c5-1fba7265aea3.jpg', 258.00, 350.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 12:14:45', '2026-03-31 12:14:45', 1, NULL),
	(198, 12, 'SAVANNA DRY 330ML', '62241', '62241', '56b1fd19-4035-47b5-b45a-06927f2fd826.jpg', 241.85, 350.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 12:15:34', '2026-03-31 12:15:34', 1, NULL),
	(199, 17, 'SINGLE SWITCH CIGARETTE', '655404', '655404', NULL, 22.00, 30.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 12:16:38', '2026-03-31 12:16:38', 1, NULL),
	(200, 13, 'SINGLETON 1LTR 12YRS', '389206', '389206', '0ce39ba8-3668-4d81-9d1c-11e8456c0e9e.webp', 4933.00, 7500.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 12:18:32', '2026-03-31 12:18:32', 1, NULL),
	(201, 16, 'SMIRNOFF 250ML', '962438', '962438', '902552be-3418-4577-9bb2-e7f9e7028633.jpg', 405.00, 550.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 12:19:30', '2026-03-31 12:19:30', 1, NULL),
	(202, 16, 'SMIRNOFF 350ML', '669880', '669880', '3d8b5e16-be16-4433-b3d9-1152a9befb03.jpg', 560.00, 750.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 12:22:05', '2026-03-31 12:22:05', 1, NULL),
	(203, 16, 'SMIRNOFF 750ML', '657145', '657145', '206613b1-dc63-4ed7-b9ac-63f33080587c.jpg', 1205.00, 1700.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 12:22:40', '2026-03-31 12:22:40', 1, NULL),
	(204, 15, 'SMIRNOFF SPICY TAMARIND 750ML', '980111', '980111', 'c4eb2c49-061b-40a7-93fb-5784da1f2e65.jpg', 1758.00, 2300.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 12:23:35', '2026-03-31 12:23:35', 1, NULL),
	(205, 12, 'SNAPP CAN', '311922', '311922', '57e5ff99-5e99-4f26-a6c2-921ca397fa43.jpg', 175.00, 250.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 12:24:28', '2026-03-31 12:24:28', 1, NULL),
	(206, 23, 'SODA 1.25LTR', '950195', '950195', NULL, 125.00, 150.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 12:25:18', '2026-03-31 12:25:18', 1, NULL),
	(207, 23, 'SODA 1LTR', '433301', '433301', NULL, 87.00, 130.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 12:25:53', '2026-03-31 12:25:53', 1, NULL),
	(208, 23, 'SODA 2LTRS', '247443', '247443', NULL, 176.00, 200.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 12:26:20', '2026-03-31 12:26:20', 1, NULL),
	(209, 23, 'SODA 350ML', '470696', '470696', NULL, 42.00, 60.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 12:26:47', '2026-03-31 12:26:47', 1, NULL),
	(210, 23, 'SODA 500ML', '868080', '868080', NULL, 62.00, 80.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 12:27:13', '2026-03-31 12:27:13', 1, NULL),
	(211, 23, 'SODA GLASS 300ML', '703697', '703697', NULL, 33.00, 50.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 12:27:41', '2026-03-31 12:27:41', 1, NULL),
	(212, 23, 'SODA GLASS 500ML', '347238', '347238', NULL, 50.00, 80.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 12:28:46', '2026-03-31 12:28:46', 1, NULL),
	(213, 13, 'SOUTHERN COMFORT 1LTR', '815004', '815004', '45869e79-08c0-4713-b317-092055c51e88.jpeg', 2050.00, 3000.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 12:31:22', '2026-03-31 12:31:22', 1, NULL),
	(214, 13, 'SOUTHERN COMFORT 750ML', '214608', '214608', '1d292c3e-20c0-4103-98c9-027471fddf43.jpg', 1750.00, 2400.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 12:32:19', '2026-03-31 12:32:19', 1, NULL),
	(215, 17, 'SPORTMAN CIGARETTE', '132846', '132846', NULL, 18.00, 20.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 12:33:09', '2026-03-31 12:33:09', 1, NULL),
	(216, 25, 'TONIC WATER', '697995', '697995', NULL, 65.00, 100.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 12:33:42', '2026-03-31 12:33:42', 1, NULL),
	(217, 15, 'TORRERO 250ML', '956116', '956116', '9d28574b-a030-4b96-8099-fa87aa539513.png', 256.00, 300.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 12:34:37', '2026-03-31 12:34:37', 1, NULL),
	(218, 15, 'TORRERO 750ML', '196555', '196555', '275ac4f6-7f01-4b30-a376-83c082c5547f.jpg', 630.00, 1000.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 12:45:36', '2026-03-31 12:45:36', 1, NULL),
	(219, 16, 'TRIPLE ACE 250ML', '907153', '907153', '88e5d62b-0843-4b83-b96a-1cabed5b9485.jpg', 195.00, 280.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 12:46:50', '2026-03-31 12:46:50', 1, NULL),
	(220, 15, 'TORRERRO 250ML', '763040', '763040', 'cacc8a19-5655-4a4a-a7c5-cb2ae4a75681.png', 260.00, 350.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 12:47:51', '2026-03-31 12:47:51', 1, NULL),
	(221, 16, 'TRIPLE ACE 750ML', '171777', '171777', 'e0c361da-9a31-48ec-9e66-c0901715b92d.jpg', 544.00, 800.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 12:49:46', '2026-03-31 12:49:46', 1, NULL),
	(222, 12, 'TUSKER CIDER', '561196', '561196', '987a695c-108c-4fa2-87cf-a94c650025f5.jpg', 229.00, 280.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 12:54:03', '2026-03-31 12:54:03', 1, NULL),
	(223, 12, 'TUSKER LAGER', '381595', '381595', 'af9762b9-8319-4370-b40c-507e7005f897.webp', 196.00, 250.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 12:55:02', '2026-03-31 12:55:02', 1, NULL),
	(224, 12, 'TUSKER LAGER GLASS', '58292', '58292', 'ce2d22a2-b246-4d6a-ba23-9c18915ba884.webp', 169.00, 270.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 12:55:35', '2026-03-31 12:55:35', 1, NULL),
	(225, 12, 'TUSKER LITE', '388908', '388908', 'e1b45064-e979-432a-be6d-15a8bc902629.jpg', 238.00, 300.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 13:01:20', '2026-03-31 13:01:20', 1, NULL),
	(226, 12, 'TUSKER MALT', '711443', '711443', 'e8ce9934-6cd8-4c74-969e-a9c8ed061a3f.jpg', 232.00, 300.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 13:02:04', '2026-03-31 13:02:04', 1, NULL),
	(227, 12, 'TUSKER NDIMU', '991384', '991384', '78481d4e-5b0d-42ca-abba-43ec40e7fe0b.jpg', 151.00, 250.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 13:02:46', '2026-03-31 13:02:46', 1, NULL),
	(228, 15, 'V & A 250ML', '224415', '224415', 'a0bd0aa1-d052-44b4-9a60-42a9ca6bc548.jpg', 291.00, 450.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 13:08:56', '2026-03-31 13:08:56', 1, NULL),
	(229, 15, 'V & A 750ML', '888434', '888434', '0918ecf0-6142-4f11-90df-4ff9c8d23ef6.jpg', 750.00, 1200.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 13:10:07', '2026-03-31 13:10:07', 1, NULL),
	(230, 13, 'VAT 69 375ML', '864497', '864497', 'aab0879e-d223-4e8f-b02c-82b342ad441c.jpg', 730.00, 1100.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 13:12:08', '2026-03-31 13:12:08', 1, NULL),
	(231, 13, 'VAT 69 750ML', '510237', '510237', '1e11dc81-5cc5-458b-b677-20b076ead6bc.jpg', 1320.00, 1750.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 13:13:19', '2026-03-31 13:13:19', 1, NULL),
	(232, 13, 'VAT 69 750ML', '777367', '777367', '2f558721-782f-436b-85e4-cf0ec6340048.jpg', 427.00, 550.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 13:14:55', '2026-03-31 13:14:55', 1, NULL),
	(233, 13, 'VICEROY 375ML', '328364', '328364', 'afbac8c5-0283-45d6-bd06-3ba08c2174d0.jpg', 623.00, 800.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 13:15:53', '2026-03-31 13:15:53', 1, NULL),
	(234, 13, 'VICEROY 750ML', '412002', '412002', 'da853538-2319-434c-b3cf-263d0a61ae43.png', 1220.00, 1600.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 13:16:40', '2026-03-31 13:16:40', 1, NULL),
	(235, 14, 'WARAGI 250ML', '663572', '663572', '974b31bf-7b87-47af-b2b9-8687dea39a5f.jpg', 200.00, 270.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 13:17:40', '2026-03-31 13:17:40', 1, NULL),
	(236, 14, 'WARAGI 750ML', '922274', '922274', 'eb6a04ab-7167-4dae-a613-ec958360b7d0.jpg', 600.00, 850.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 13:18:26', '2026-03-31 13:18:26', 1, NULL),
	(237, 25, 'WATER 1LTR', '415645', '415645', NULL, 30.00, 50.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 13:19:21', '2026-03-31 13:19:21', 1, NULL),
	(238, 25, 'WATER 500ML', '450084', '450084', NULL, 15.00, 30.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 13:19:47', '2026-03-31 13:19:47', 1, NULL),
	(239, 12, 'WHITE CAP CAN', '623407', '623407', '5f170da6-afb8-409a-b7c5-958049dc88be.jpg', 213.00, 270.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 13:20:51', '2026-03-31 13:20:51', 1, NULL),
	(240, 12, 'WHITE CAP CRISP', '731143', '731143', 'e2d356e0-91af-4bbb-b3fa-0798704015e5.jpg', 231.00, 300.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 13:21:38', '2026-03-31 13:21:38', 1, NULL),
	(241, 12, 'WHITE CAP GLASS', '304275', '304275', '51277ed1-cf36-4603-8451-ec958e743893.jpg', 196.00, 280.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 13:22:18', '2026-03-31 13:22:18', 1, NULL),
	(242, 16, 'WHITE PAERL 750ML', '418391', '418391', '997e9b83-d0b0-47a9-8d92-fa323c4433d3.png', 635.00, 900.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 13:23:10', '2026-03-31 13:23:10', 1, NULL),
	(243, 16, 'WHITE PEARL 250ML', '483397', '483397', '497da022-3a8d-4f05-b9c5-d63dd24f1192.jpg', 214.00, 300.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 13:23:49', '2026-03-31 13:23:49', 1, NULL),
	(244, 12, 'WINDHOEK LAGER', '475711', '475711', '62044c0c-62b4-4e45-8a5a-686e0385aeb3.jpg', 189.00, 300.00, NULL, NULL, 'Price 2', 'Price 3', 0.00, 10, 1, NULL, NULL, '2026-03-31 13:25:12', '2026-03-31 13:25:12', 1, NULL);
/*!40000 ALTER TABLE `products` ENABLE KEYS */;

-- Dumping structure for table posai.product_price_history
DROP TABLE IF EXISTS `product_price_history`;
CREATE TABLE IF NOT EXISTS `product_price_history` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `product_id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `price_adjustment_log_id` bigint(20) unsigned DEFAULT NULL,
  `old_cost_price` decimal(12,2) NOT NULL,
  `new_cost_price` decimal(12,2) NOT NULL,
  `old_selling_price` decimal(12,2) NOT NULL,
  `new_selling_price` decimal(12,2) NOT NULL,
  `reason` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `product_id` (`product_id`),
  CONSTRAINT `product_price_history_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Dumping data for table posai.product_price_history: ~0 rows (approximately)
/*!40000 ALTER TABLE `product_price_history` DISABLE KEYS */;
/*!40000 ALTER TABLE `product_price_history` ENABLE KEYS */;

-- Dumping structure for table posai.sessions
DROP TABLE IF EXISTS `sessions`;
CREATE TABLE IF NOT EXISTS `sessions` (
  `id` varchar(255) 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,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table posai.sessions: ~0 rows (approximately)
/*!40000 ALTER TABLE `sessions` DISABLE KEYS */;
/*!40000 ALTER TABLE `sessions` ENABLE KEYS */;

-- Dumping structure for table posai.settings
DROP TABLE IF EXISTS `settings`;
CREATE TABLE IF NOT EXISTS `settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `settings_key_unique` (`key`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table posai.settings: ~26 rows (approximately)
/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
REPLACE INTO `settings` (`id`, `key`, `value`, `created_at`, `updated_at`) VALUES
	(1, 'loyalty_points_ratio', '1', '2026-03-28 06:16:13', '2026-03-28 06:16:13'),
	(2, 'loyalty_points_redemption', '1', '2026-03-28 06:16:13', '2026-03-28 06:16:13'),
	(16, 'sms_provider', 'africastalking', '2026-03-28 06:25:40', '2026-03-28 06:25:40'),
	(17, 'sms_api_key', '', '2026-03-28 06:25:40', '2026-03-28 06:25:40'),
	(18, 'sms_shortcode', '', '2026-03-28 06:25:40', '2026-03-28 06:25:40'),
	(19, 'sms_sender_id', '', '2026-03-28 06:25:40', '2026-03-28 06:25:40'),
	(20, 'sms_enabled', '0', '2026-03-28 06:25:40', '2026-03-28 06:25:40'),
	(21, 'sms_oauth_client_id', '', '2026-03-28 06:25:40', '2026-03-28 06:25:40'),
	(22, 'sms_oauth_client_secret', '', '2026-03-28 06:25:40', '2026-03-28 06:25:40'),
	(23, 'sms_oauth_access_token', '', '2026-03-28 06:25:40', '2026-03-28 06:25:40'),
	(24, 'sms_oauth_refresh_token', '', '2026-03-28 06:25:40', '2026-03-28 06:25:40'),
	(25, 'sms_oauth_token_expires', '', '2026-03-28 06:25:40', '2026-03-28 06:25:40'),
	(26, 'sms_oauth_username', '', '2026-03-28 06:25:40', '2026-03-28 06:25:40'),
	(27, 'sms_oauth_password', '', '2026-03-28 06:25:40', '2026-03-28 06:25:40'),
	(28, 'sms_channel_id', '', '2026-03-28 06:25:40', '2026-03-28 06:25:40'),
	(29, 'receipt_header', 'TOKIM PHARMACY', '2026-03-28 12:37:22', '2026-03-28 13:01:41'),
	(30, 'receipt_address', 'NAKURU-NDUNDORI', '2026-03-28 12:37:22', '2026-03-28 13:01:41'),
	(31, 'receipt_phone', 'Tel: 0701-980-200', '2026-03-28 12:37:22', '2026-03-28 13:01:41'),
	(32, 'receipt_footer', '*** THANK YOU FOR YOUR BUSINESS ***', '2026-03-28 12:37:22', '2026-03-28 13:01:41'),
	(33, 'report_header', 'POS System Report', '2026-03-28 12:37:22', '2026-03-28 13:01:41'),
	(34, 'report_company', 'POS SYSTEM', '2026-03-28 12:37:22', '2026-03-28 13:01:41'),
	(35, 'report_footer', 'Generated by POS System', '2026-03-28 12:37:22', '2026-03-28 13:01:41'),
	(36, 'receipt_dev_ad', 'Powered by Destech: 0701-980-200 / destechsoftwares.co.ke', '2026-03-28 12:37:22', '2026-03-28 13:01:41'),
	(37, 'report_dev_ad', NULL, '2026-03-28 12:37:22', '2026-03-28 13:01:41'),
	(38, 'receipt_tagline', 'Your Trusted Shopping Destination Always', '2026-03-28 12:37:22', '2026-03-28 13:01:41'),
	(39, 'system_name', 'BOOZE & BLISS', NULL, '2026-03-30 17:15:44'),
	(40, 'inactivity_timeout', '60', NULL, '2026-03-30 17:15:44');
/*!40000 ALTER TABLE `settings` ENABLE KEYS */;

-- Dumping structure for table posai.subscriptions
DROP TABLE IF EXISTS `subscriptions`;
CREATE TABLE IF NOT EXISTS `subscriptions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `plan_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` decimal(12,2) NOT NULL,
  `billing_cycle_days` int(11) NOT NULL DEFAULT '30',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `description` 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;

-- Dumping data for table posai.subscriptions: ~0 rows (approximately)
/*!40000 ALTER TABLE `subscriptions` DISABLE KEYS */;
/*!40000 ALTER TABLE `subscriptions` ENABLE KEYS */;

-- Dumping structure for table posai.suppliers
DROP TABLE IF EXISTS `suppliers`;
CREATE TABLE IF NOT EXISTS `suppliers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text COLLATE utf8mb4_unicode_ci,
  `contact_person` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `total_paid` decimal(12,2) NOT NULL DEFAULT '0.00',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table posai.suppliers: ~0 rows (approximately)
/*!40000 ALTER TABLE `suppliers` DISABLE KEYS */;
REPLACE INTO `suppliers` (`id`, `name`, `phone`, `email`, `address`, `contact_person`, `is_active`, `total_paid`, `created_at`, `updated_at`) VALUES
	(6, 'Self', '00000000', 'admin@pos.com', NULL, 'Self', 1, 0.00, '2026-03-29 16:12:00', '2026-03-29 17:36:46');
/*!40000 ALTER TABLE `suppliers` ENABLE KEYS */;

-- Dumping structure for table posai.supplier_payments
DROP TABLE IF EXISTS `supplier_payments`;
CREATE TABLE IF NOT EXISTS `supplier_payments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `supplier_id` bigint(20) unsigned NOT NULL,
  `amount` decimal(12,2) NOT NULL,
  `payment_method` varchar(255) DEFAULT 'cash',
  `reference_number` varchar(255) DEFAULT NULL,
  `notes` text,
  `payment_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `supplier_id` (`supplier_id`),
  CONSTRAINT `supplier_payments_ibfk_1` FOREIGN KEY (`supplier_id`) REFERENCES `suppliers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Dumping data for table posai.supplier_payments: ~0 rows (approximately)
/*!40000 ALTER TABLE `supplier_payments` DISABLE KEYS */;
/*!40000 ALTER TABLE `supplier_payments` ENABLE KEYS */;

-- Dumping structure for table posai.tax_configs
DROP TABLE IF EXISTS `tax_configs`;
CREATE TABLE IF NOT EXISTS `tax_configs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `rate` decimal(5,2) NOT NULL DEFAULT '0.00',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `is_default` tinyint(1) NOT NULL DEFAULT '0',
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'vat',
  `description` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `tax_configs_code_unique` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table posai.tax_configs: ~0 rows (approximately)
/*!40000 ALTER TABLE `tax_configs` DISABLE KEYS */;
REPLACE INTO `tax_configs` (`id`, `name`, `code`, `rate`, `is_active`, `is_default`, `type`, `description`, `created_at`, `updated_at`) VALUES
	(1, 'vat 16%', 'vat', 16.00, 0, 1, 'vat', NULL, '2026-03-28 11:07:14', '2026-03-29 05:54:59');
/*!40000 ALTER TABLE `tax_configs` ENABLE KEYS */;

-- Dumping structure for table posai.unit_of_measures
DROP TABLE IF EXISTS `unit_of_measures`;
CREATE TABLE IF NOT EXISTS `unit_of_measures` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `abbreviation` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table posai.unit_of_measures: ~15 rows (approximately)
/*!40000 ALTER TABLE `unit_of_measures` DISABLE KEYS */;
REPLACE INTO `unit_of_measures` (`id`, `name`, `abbreviation`, `is_active`, `created_at`, `updated_at`) VALUES
	(1, 'Piece', 'pc', 1, '2026-03-29 15:51:48', '2026-03-29 15:51:48'),
	(2, 'Kilogram', 'kg', 1, '2026-03-29 15:51:48', '2026-03-29 15:51:48'),
	(3, 'Gram', 'g', 1, '2026-03-29 15:51:48', '2026-03-29 15:51:48'),
	(4, 'Liter', 'L', 1, '2026-03-29 15:51:48', '2026-03-29 15:51:48'),
	(5, 'Milliliter', 'mL', 1, '2026-03-29 15:51:48', '2026-03-29 15:51:48'),
	(6, 'Meter', 'm', 1, '2026-03-29 15:51:48', '2026-03-29 15:51:48'),
	(7, 'Centimeter', 'cm', 1, '2026-03-29 15:51:48', '2026-03-29 15:51:48'),
	(8, 'Pack', 'pack', 1, '2026-03-29 15:51:48', '2026-03-29 15:51:48'),
	(9, 'Box', 'box', 1, '2026-03-29 15:51:48', '2026-03-29 15:51:48'),
	(10, 'Carton', 'ctn', 1, '2026-03-29 15:51:48', '2026-03-29 15:51:48'),
	(11, 'Dozen', 'doz', 1, '2026-03-29 15:51:48', '2026-03-29 15:51:48'),
	(12, 'Set', 'set', 1, '2026-03-29 15:51:48', '2026-03-29 15:51:48'),
	(13, 'Pair', 'pair', 1, '2026-03-29 15:51:48', '2026-03-29 15:51:48'),
	(14, 'Roll', 'roll', 1, '2026-03-29 15:51:48', '2026-03-29 15:51:48'),
	(15, 'Bundle', 'bdl', 1, '2026-03-29 15:51:48', '2026-03-29 15:51:48');
/*!40000 ALTER TABLE `unit_of_measures` ENABLE KEYS */;

-- Dumping structure for table posai.users
DROP TABLE IF EXISTS `users`;
CREATE TABLE IF NOT EXISTS `users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `role` enum('super_admin','admin','cashier') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'cashier',
  `permissions` json DEFAULT NULL,
  `theme` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'system',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `subscription_id` bigint(20) unsigned DEFAULT NULL,
  `subscription_expires_at` timestamp NULL DEFAULT NULL,
  `branch_id` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`),
  KEY `users_subscription_id_foreign` (`subscription_id`),
  KEY `users_branch_id_foreign` (`branch_id`),
  CONSTRAINT `users_branch_id_foreign` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE SET NULL,
  CONSTRAINT `users_subscription_id_foreign` FOREIGN KEY (`subscription_id`) REFERENCES `subscriptions` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table posai.users: ~3 rows (approximately)
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
REPLACE INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `role`, `permissions`, `theme`, `is_active`, `remember_token`, `created_at`, `updated_at`, `subscription_id`, `subscription_expires_at`, `branch_id`) VALUES
	(1, 'Super Admin', 'superadmin@pos.com', NULL, '$2y$12$ED2/FHxamjXKZguHmP81Bue7HeInga7vSQo9l9ikr11OVH5D4kdjC', 'super_admin', NULL, 'system', 1, NULL, '2026-03-28 06:17:23', '2026-03-29 18:34:22', NULL, NULL, 1),
	(5, 'Dest Test', 'dest@gmail.com', NULL, '$2y$12$384ln5eq1edmOlkVOM1aZ.M9v5Qs7gZe6zMx2qGYjiavvP0tYJtwq', 'admin', NULL, 'light', 1, NULL, '2026-03-29 15:22:36', '2026-03-31 08:49:31', NULL, NULL, 1),
	(6, 'Cashier', 'Cashier@gmail.com', NULL, '$2y$12$JvI5NYizJl1fRM2MlKNyJeawu9uSEOz0AioexoAKDKZh8i2cYDWvC', 'cashier', '["expenses.create", "products.create", "reports.mpesa-transactions", "pos.sales", "inventory.stock-in", "expenses.view", "products.view"]', 'system', 1, NULL, '2026-03-29 16:43:30', '2026-03-31 08:03:41', NULL, NULL, 2);
/*!40000 ALTER TABLE `users` ENABLE KEYS */;

-- Dumping structure for table posai.user_activity_logs
DROP TABLE IF EXISTS `user_activity_logs`;
CREATE TABLE IF NOT EXISTS `user_activity_logs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `activity_type` varchar(255) NOT NULL,
  `description` text,
  `ip_address` varchar(255) DEFAULT NULL,
  `user_agent` text,
  `metadata` json DEFAULT NULL,
  `client_time` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `user_activity_logs_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=388 DEFAULT CHARSET=utf8;

-- Dumping data for table posai.user_activity_logs: ~81 rows (approximately)
/*!40000 ALTER TABLE `user_activity_logs` DISABLE KEYS */;
REPLACE INTO `user_activity_logs` (`id`, `user_id`, `activity_type`, `description`, `ip_address`, `user_agent`, `metadata`, `client_time`, `created_at`, `updated_at`) VALUES
	(307, 5, 'logout', 'User logged out', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', '[]', '2026-03-30 10:03:58', '2026-03-30 10:03:59', '2026-03-30 10:03:59'),
	(308, 1, 'login', 'User logged in', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', NULL, '2026-03-30 10:04:03', '2026-03-30 10:04:05', '2026-03-30 10:04:05'),
	(309, 1, 'logout', 'User logged out', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', '[]', '2026-03-30 10:04:19', '2026-03-30 10:04:20', '2026-03-30 10:04:20'),
	(310, 5, 'login', 'User logged in', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', NULL, '2026-03-30 10:04:28', '2026-03-30 10:04:29', '2026-03-30 10:04:29'),
	(311, 5, 'logout', 'User logged out', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', '[]', '2026-03-30 10:32:34', '2026-03-30 10:32:35', '2026-03-30 10:32:35'),
	(312, 6, 'login', 'User logged in', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', NULL, '2026-03-30 10:32:38', '2026-03-30 10:32:40', '2026-03-30 10:32:40'),
	(313, 6, 'logout', 'User logged out', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', '[]', '2026-03-30 10:32:45', '2026-03-30 10:32:45', '2026-03-30 10:32:45'),
	(314, 5, 'login', 'User logged in', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', NULL, '2026-03-30 10:32:49', '2026-03-30 10:32:51', '2026-03-30 10:32:51'),
	(315, 5, 'logout', 'User logged out', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', '[]', '2026-03-30 10:33:20', '2026-03-30 10:33:21', '2026-03-30 10:33:21'),
	(316, 5, 'login', 'User logged in', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', NULL, '2026-03-30 10:33:25', '2026-03-30 10:33:27', '2026-03-30 10:33:27'),
	(317, 5, 'auto_logout', 'Session expired due to inactivity', '127.0.0.1', NULL, NULL, '2026-03-30 11:03:38', '2026-03-30 11:03:39', '2026-03-30 11:03:39'),
	(318, 5, 'login', 'User logged in', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', NULL, '2026-03-30 14:11:47', '2026-03-30 14:11:53', '2026-03-30 14:11:53'),
	(319, 5, 'login', 'User logged in', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', NULL, '2026-03-30 14:18:13', '2026-03-30 14:18:20', '2026-03-30 14:18:20'),
	(320, 5, 'auto_logout', 'Session expired due to inactivity', '127.0.0.1', NULL, NULL, '2026-03-30 15:25:26', '2026-03-30 15:25:27', '2026-03-30 15:25:27'),
	(321, 5, 'login', 'User logged in', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', NULL, '2026-03-30 16:05:12', '2026-03-30 16:05:13', '2026-03-30 16:05:13'),
	(322, 5, 'auto_logout', 'Session expired due to inactivity', '127.0.0.1', NULL, NULL, '2026-03-30 16:09:03', '2026-03-30 16:09:04', '2026-03-30 16:09:04'),
	(323, 5, 'login', 'User logged in', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', NULL, '2026-03-30 16:14:09', '2026-03-30 16:14:10', '2026-03-30 16:14:10'),
	(324, 5, 'auto_logout', 'Session expired due to inactivity', '127.0.0.1', NULL, NULL, '2026-03-30 16:24:47', '2026-03-30 16:24:47', '2026-03-30 16:24:47'),
	(325, 5, 'login', 'User logged in', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', NULL, '2026-03-30 16:32:20', '2026-03-30 16:32:21', '2026-03-30 16:32:21'),
	(326, 5, 'logout', 'User logged out', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', '[]', '2026-03-30 17:15:16', '2026-03-30 17:15:16', '2026-03-30 17:15:16'),
	(327, 1, 'login', 'User logged in', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', NULL, '2026-03-30 17:15:21', '2026-03-30 17:15:22', '2026-03-30 17:15:22'),
	(328, 1, 'logout', 'User logged out', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', '[]', '2026-03-30 17:15:51', '2026-03-30 17:15:51', '2026-03-30 17:15:51'),
	(329, 5, 'login', 'User logged in', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', NULL, '2026-03-30 17:15:59', '2026-03-30 17:16:00', '2026-03-30 17:16:00'),
	(330, 5, 'logout', 'User logged out', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', '[]', '2026-03-30 18:03:16', '2026-03-30 18:03:17', '2026-03-30 18:03:17'),
	(331, 6, 'login', 'User logged in', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', NULL, '2026-03-30 18:03:21', '2026-03-30 18:03:23', '2026-03-30 18:03:23'),
	(332, 6, 'logout', 'User logged out', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', '[]', '2026-03-30 18:05:49', '2026-03-30 18:05:50', '2026-03-30 18:05:50'),
	(333, 5, 'login', 'User logged in', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', NULL, '2026-03-30 18:05:56', '2026-03-30 18:05:58', '2026-03-30 18:05:58'),
	(334, 5, 'logout', 'User logged out', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', '[]', '2026-03-30 18:06:07', '2026-03-30 18:06:07', '2026-03-30 18:06:07'),
	(335, 6, 'login', 'User logged in', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', NULL, '2026-03-30 18:06:12', '2026-03-30 18:06:14', '2026-03-30 18:06:14'),
	(336, 6, 'logout', 'User logged out', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', '[]', '2026-03-30 18:10:09', '2026-03-30 18:10:10', '2026-03-30 18:10:10'),
	(337, 5, 'login', 'User logged in', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', NULL, '2026-03-30 18:10:14', '2026-03-30 18:10:16', '2026-03-30 18:10:16'),
	(338, 5, 'login', 'User logged in', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', NULL, '2026-03-30 18:31:07', '2026-03-30 18:31:09', '2026-03-30 18:31:09'),
	(339, 5, 'auto_logout', 'Session expired due to inactivity', '127.0.0.1', NULL, NULL, '2026-03-30 18:34:39', '2026-03-30 18:34:40', '2026-03-30 18:34:40'),
	(340, 5, 'login', 'User logged in', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', NULL, '2026-03-30 18:36:08', '2026-03-30 18:36:10', '2026-03-30 18:36:10'),
	(341, 5, 'auto_logout', 'Session expired due to inactivity', '127.0.0.1', NULL, NULL, '2026-03-30 18:42:33', '2026-03-30 18:42:34', '2026-03-30 18:42:34'),
	(342, 5, 'login', 'User logged in', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', NULL, '2026-03-30 18:55:05', '2026-03-30 18:55:06', '2026-03-30 18:55:06'),
	(343, 5, 'login', 'User logged in', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', NULL, '2026-03-30 19:00:10', '2026-03-30 19:00:12', '2026-03-30 19:00:12'),
	(344, 5, 'logout', 'User logged out', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', '[]', '2026-03-30 19:18:15', '2026-03-30 19:18:16', '2026-03-30 19:18:16'),
	(345, 6, 'login', 'User logged in', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', NULL, '2026-03-30 19:18:21', '2026-03-30 19:18:23', '2026-03-30 19:18:23'),
	(346, 6, 'logout', 'User logged out', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', '[]', '2026-03-30 19:19:23', '2026-03-30 19:19:23', '2026-03-30 19:19:23'),
	(347, 5, 'login', 'User logged in', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', NULL, '2026-03-30 19:19:28', '2026-03-30 19:19:29', '2026-03-30 19:19:29'),
	(348, 5, 'auto_logout', 'Session expired due to inactivity', '127.0.0.1', NULL, NULL, '2026-03-30 19:36:35', '2026-03-30 19:36:36', '2026-03-30 19:36:36'),
	(349, 5, 'login', 'User logged in', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', NULL, '2026-03-30 19:45:01', '2026-03-30 19:45:03', '2026-03-30 19:45:03'),
	(350, 5, 'auto_logout', 'Session expired due to inactivity', '127.0.0.1', NULL, NULL, '2026-03-30 21:00:27', '2026-03-30 21:00:27', '2026-03-30 21:00:27'),
	(351, 5, 'login', 'User logged in', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', NULL, '2026-03-30 21:00:32', '2026-03-30 21:00:32', '2026-03-30 21:00:32'),
	(352, 5, 'auto_logout', 'Session expired due to inactivity', '127.0.0.1', NULL, NULL, '2026-03-30 21:57:50', '2026-03-30 21:57:50', '2026-03-30 21:57:50'),
	(353, 5, 'login', 'User logged in', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', NULL, '2026-03-30 21:58:54', '2026-03-30 21:58:55', '2026-03-30 21:58:55'),
	(354, 5, 'auto_logout', 'Session expired due to inactivity', '127.0.0.1', NULL, NULL, '2026-03-30 22:06:14', '2026-03-30 22:06:14', '2026-03-30 22:06:14'),
	(355, 5, 'login', 'User logged in', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', NULL, '2026-03-31 08:01:02', '2026-03-31 08:01:02', '2026-03-31 08:01:02'),
	(356, 5, 'logout', 'User logged out', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', '[]', '2026-03-31 08:02:12', '2026-03-31 08:02:13', '2026-03-31 08:02:13'),
	(357, 6, 'login', 'User logged in', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', NULL, '2026-03-31 08:02:16', '2026-03-31 08:02:17', '2026-03-31 08:02:17'),
	(358, 6, 'logout', 'User logged out', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', '[]', '2026-03-31 08:03:21', '2026-03-31 08:03:21', '2026-03-31 08:03:21'),
	(359, 5, 'login', 'User logged in', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', NULL, '2026-03-31 08:03:25', '2026-03-31 08:03:25', '2026-03-31 08:03:25'),
	(360, 5, 'logout', 'User logged out', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', '[]', '2026-03-31 08:03:45', '2026-03-31 08:03:45', '2026-03-31 08:03:45'),
	(361, 6, 'login', 'User logged in', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', NULL, '2026-03-31 08:03:49', '2026-03-31 08:03:50', '2026-03-31 08:03:50'),
	(362, 6, 'login', 'User logged in', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', NULL, '2026-03-31 08:12:34', '2026-03-31 08:12:35', '2026-03-31 08:12:35'),
	(363, 6, 'logout', 'User logged out', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', '[]', '2026-03-31 08:13:02', '2026-03-31 08:13:02', '2026-03-31 08:13:02'),
	(364, 5, 'login', 'User logged in', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', NULL, '2026-03-31 08:13:06', '2026-03-31 08:13:06', '2026-03-31 08:13:06'),
	(365, 5, 'logout', 'User logged out', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', '[]', '2026-03-31 08:13:51', '2026-03-31 08:13:51', '2026-03-31 08:13:51'),
	(366, 6, 'login', 'User logged in', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', NULL, '2026-03-31 08:13:54', '2026-03-31 08:13:55', '2026-03-31 08:13:55'),
	(367, 6, 'logout', 'User logged out', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', '[]', '2026-03-31 08:14:35', '2026-03-31 08:14:35', '2026-03-31 08:14:35'),
	(368, 5, 'login', 'User logged in', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', NULL, '2026-03-31 08:14:39', '2026-03-31 08:14:40', '2026-03-31 08:14:40'),
	(369, 5, 'logout', 'User logged out', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', '[]', '2026-03-31 08:39:25', '2026-03-31 08:39:26', '2026-03-31 08:39:26'),
	(370, 6, 'login', 'User logged in', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', NULL, '2026-03-31 08:39:29', '2026-03-31 08:39:30', '2026-03-31 08:39:30'),
	(371, 6, 'logout', 'User logged out', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', '[]', '2026-03-31 08:39:45', '2026-03-31 08:39:45', '2026-03-31 08:39:45'),
	(372, 5, 'login', 'User logged in', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', NULL, '2026-03-31 08:39:49', '2026-03-31 08:39:49', '2026-03-31 08:39:49'),
	(373, 5, 'auto_logout', 'Session expired due to inactivity', '127.0.0.1', NULL, NULL, '2026-03-31 09:06:40', '2026-03-31 09:06:41', '2026-03-31 09:06:41'),
	(374, 5, 'login', 'User logged in', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', NULL, '2026-03-31 09:27:22', '2026-03-31 09:27:24', '2026-03-31 09:27:24'),
	(375, 5, 'login', 'User logged in', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', NULL, '2026-03-31 09:33:03', '2026-03-31 09:33:05', '2026-03-31 09:33:05'),
	(376, 5, 'auto_logout', 'Session expired due to inactivity', '127.0.0.1', NULL, NULL, '2026-03-31 09:40:32', '2026-03-31 09:40:33', '2026-03-31 09:40:33'),
	(377, 5, 'login', 'User logged in', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', NULL, '2026-03-31 09:42:52', '2026-03-31 09:42:53', '2026-03-31 09:42:53'),
	(378, 5, 'login', 'User logged in', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', NULL, '2026-03-31 09:43:02', '2026-03-31 09:43:04', '2026-03-31 09:43:04'),
	(379, 5, 'auto_logout', 'Session expired due to inactivity', '127.0.0.1', NULL, NULL, '2026-03-31 10:11:20', '2026-03-31 10:11:21', '2026-03-31 10:11:21'),
	(380, 5, 'login', 'User logged in', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', NULL, '2026-03-31 10:22:14', '2026-03-31 10:22:16', '2026-03-31 10:22:16'),
	(381, 5, 'auto_logout', 'Session expired due to inactivity', '127.0.0.1', NULL, NULL, '2026-03-31 10:25:00', '2026-03-31 10:25:01', '2026-03-31 10:25:01'),
	(382, 5, 'login', 'User logged in', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', NULL, '2026-03-31 11:02:13', '2026-03-31 11:02:15', '2026-03-31 11:02:15'),
	(383, 5, 'login', 'User logged in', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', NULL, '2026-03-31 11:59:38', '2026-03-31 11:59:39', '2026-03-31 11:59:39'),
	(384, 5, 'auto_logout', 'Session expired due to inactivity', '127.0.0.1', NULL, NULL, '2026-03-31 12:12:35', '2026-03-31 12:12:35', '2026-03-31 12:12:35'),
	(385, 5, 'login', 'User logged in', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', NULL, '2026-03-31 12:13:51', '2026-03-31 12:13:51', '2026-03-31 12:13:51'),
	(386, 5, 'auto_logout', 'Session expired due to inactivity', '127.0.0.1', NULL, NULL, '2026-03-31 12:51:47', '2026-03-31 12:51:47', '2026-03-31 12:51:47'),
	(387, 5, 'login', 'User logged in', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', NULL, '2026-03-31 12:52:46', '2026-03-31 12:52:48', '2026-03-31 12:52:48');
/*!40000 ALTER TABLE `user_activity_logs` 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) */;