JFIFxxC      C  " }!1AQa"q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w!1AQaq"2B #3RbrJFIFxxC      C  " }!1AQa"q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w!1AQaq"2B #3Rbr-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1:3306 -- Generation Time: Feb 27, 2025 at 05:49 PM -- Server version: 8.3.0 -- PHP Version: 8.2.18 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `mini` -- -- -------------------------------------------------------- -- -- Table structure for table `accounts` -- DROP TABLE IF EXISTS `accounts`; CREATE TABLE IF NOT EXISTS `accounts` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `account_no` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `initial_balance` double DEFAULT NULL, `total_balance` double NOT NULL, `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `is_default` tinyint(1) DEFAULT NULL, `is_active` tinyint(1) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `accounts` -- INSERT INTO `accounts` (`id`, `account_no`, `name`, `initial_balance`, `total_balance`, `note`, `is_default`, `is_active`, `created_at`, `updated_at`) VALUES (1, '11111', 'Sales Accounts', 1000, 1000, 'this is first account', 1, 1, '2018-12-18 02:58:02', '2024-03-12 07:57:50'), (3, '21211', 'Sa', NULL, 0, NULL, 0, 1, '2018-12-18 02:58:56', '2019-01-20 09:59:06'), (5, 'bank-1', 'zuhair', 100000, 100000, NULL, NULL, 1, '2022-11-28 05:58:18', '2022-11-28 05:58:18'); -- -------------------------------------------------------- -- -- Table structure for table `adjustments` -- DROP TABLE IF EXISTS `adjustments`; CREATE TABLE IF NOT EXISTS `adjustments` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `reference_no` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `warehouse_id` int NOT NULL, `document` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `total_qty` double NOT NULL, `item` int NOT NULL, `note` text CHARACTER SET utf8mb4 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; -- -------------------------------------------------------- -- -- Table structure for table `attendances` -- DROP TABLE IF EXISTS `attendances`; CREATE TABLE IF NOT EXISTS `attendances` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `date` date NOT NULL, `employee_id` int NOT NULL, `user_id` int NOT NULL, `checkin` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `checkout` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` int NOT NULL, `note` text CHARACTER SET utf8mb4 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; -- -------------------------------------------------------- -- -- Table structure for table `barcodes` -- DROP TABLE IF EXISTS `barcodes`; CREATE TABLE IF NOT EXISTS `barcodes` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `width` double(22,4) DEFAULT NULL, `height` double(22,4) DEFAULT NULL, `paper_width` double(22,4) DEFAULT NULL, `paper_height` double(22,4) DEFAULT NULL, `top_margin` double(22,4) DEFAULT NULL, `left_margin` double(22,4) DEFAULT NULL, `row_distance` double(22,4) DEFAULT NULL, `col_distance` double(22,4) DEFAULT NULL, `stickers_in_one_row` int DEFAULT NULL, `is_default` tinyint(1) NOT NULL DEFAULT '0', `is_continuous` tinyint(1) NOT NULL DEFAULT '0', `stickers_in_one_sheet` int DEFAULT NULL, `is_custom` int DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `billers` -- DROP TABLE IF EXISTS `billers`; CREATE TABLE IF NOT EXISTS `billers` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `company_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `vat_number` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `phone_number` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `address` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `city` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `state` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `postal_code` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `country` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_active` tinyint(1) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `billers` -- INSERT INTO `billers` (`id`, `name`, `image`, `company_name`, `vat_number`, `email`, `phone_number`, `address`, `city`, `state`, `postal_code`, `country`, `is_active`, `created_at`, `updated_at`) VALUES (1, 'محفوظ العزيب', NULL, 'بقالة الصباحي', '100', 'Alvaa@gmail.com', '0777349854', 'gert', 'sana\'a', NULL, NULL, 'اليمن', 1, '2025-02-11 19:29:53', '2025-02-11 19:29:53'); -- -------------------------------------------------------- -- -- Table structure for table `brands` -- DROP TABLE IF EXISTS `brands`; CREATE TABLE IF NOT EXISTS `brands` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_active` tinyint(1) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `cash_registers` -- DROP TABLE IF EXISTS `cash_registers`; CREATE TABLE IF NOT EXISTS `cash_registers` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `cash_in_hand` double NOT NULL, `user_id` int NOT NULL, `warehouse_id` int NOT NULL, `status` tinyint(1) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `cash_registers` -- INSERT INTO `cash_registers` (`id`, `cash_in_hand`, `user_id`, `warehouse_id`, `status`, `created_at`, `updated_at`) VALUES (1, 1000, 1, 1, 1, '2025-02-11 17:04:36', '2025-02-11 17:04:36'); -- -------------------------------------------------------- -- -- Table structure for table `categories` -- DROP TABLE IF EXISTS `categories`; CREATE TABLE IF NOT EXISTS `categories` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `parent_id` int DEFAULT NULL, `is_active` tinyint(1) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `categories` -- INSERT INTO `categories` (`id`, `name`, `image`, `parent_id`, `is_active`, `created_at`, `updated_at`) VALUES (1, 'حليب ', NULL, NULL, 1, '2025-02-10 18:50:03', '2025-02-10 18:50:03'), (2, 'ماء صنعاء', NULL, NULL, 1, '2025-02-10 18:50:03', '2025-02-10 18:50:03'), (3, 'بقوليات ', NULL, NULL, 1, '2025-02-10 18:56:29', '2025-02-10 18:56:29'), (4, 'عصائر', NULL, 3, 1, '2025-02-10 18:56:29', '2025-02-10 18:56:29'); -- -------------------------------------------------------- -- -- Table structure for table `challans` -- DROP TABLE IF EXISTS `challans`; CREATE TABLE IF NOT EXISTS `challans` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `reference_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `courier_id` int NOT NULL, `packing_slip_list` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `amount_list` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `cash_list` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `online_payment_list` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `cheque_list` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `delivery_charge_list` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `status_list` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `closing_date` date DEFAULT NULL, `created_by_id` int NOT NULL, `closed_by_id` int DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `coupons` -- DROP TABLE IF EXISTS `coupons`; CREATE TABLE IF NOT EXISTS `coupons` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `code` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `amount` double NOT NULL, `minimum_amount` double DEFAULT NULL, `quantity` int NOT NULL, `used` int NOT NULL, `expired_date` date NOT NULL, `user_id` int NOT NULL, `is_active` tinyint(1) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `couriers` -- DROP TABLE IF EXISTS `couriers`; CREATE TABLE IF NOT EXISTS `couriers` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `phone_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `is_active` tinyint(1) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `couriers` -- INSERT INTO `couriers` (`id`, `name`, `phone_number`, `address`, `is_active`, `created_at`, `updated_at`) VALUES (1, 'salesman', '0772526905', 'gert', 1, '2025-02-11 20:25:18', '2025-02-11 20:25:18'); -- -------------------------------------------------------- -- -- Table structure for table `currencies` -- DROP TABLE IF EXISTS `currencies`; CREATE TABLE IF NOT EXISTS `currencies` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `code` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `exchange_rate` double 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=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `currencies` -- INSERT INTO `currencies` (`id`, `name`, `code`, `exchange_rate`, `is_active`, `created_at`, `updated_at`) VALUES (1, 'US Dollar', 'USD', 1, 1, '2020-11-01 00:22:58', '2023-04-02 09:51:28'), (2, 'Euro', 'Euro', 0.95, 1, '2020-11-01 01:29:12', '2023-06-08 10:10:32'), (3, 'Bangladeshi Taka', 'BDT', 110, 0, '2023-09-06 07:05:29', '2023-09-06 07:05:46'), (4, 'YER', 'ريال يمني', 530, 1, '2025-02-11 16:53:01', '2025-02-11 16:53:01'); -- -------------------------------------------------------- -- -- Table structure for table `customers` -- DROP TABLE IF EXISTS `customers`; CREATE TABLE IF NOT EXISTS `customers` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `customer_group_id` int NOT NULL, `user_id` int DEFAULT NULL, `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `company_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `phone_number` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `tax_no` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `state` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `postal_code` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `country` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `points` double DEFAULT NULL, `deposit` double DEFAULT NULL, `expense` double DEFAULT NULL, `is_active` tinyint(1) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `ecom` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `dsf` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'df', `arabic_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `admin` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `franchise_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `customer_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Same as Customer', `customer_assigned_to` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Advocate', `assigned` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Advocate', `aaaaaaaa` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'aa', `district` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `customers` -- INSERT INTO `customers` (`id`, `customer_group_id`, `user_id`, `name`, `company_name`, `email`, `phone_number`, `tax_no`, `address`, `city`, `state`, `postal_code`, `country`, `points`, `deposit`, `expense`, `is_active`, `created_at`, `updated_at`, `ecom`, `dsf`, `arabic_name`, `admin`, `franchise_location`, `customer_type`, `customer_assigned_to`, `assigned`, `aaaaaaaa`, `district`) VALUES (1, 1, NULL, 'اديب مفرح', 'كايزن سوفت', 'adeeb@gmial.com', '+967770803155', NULL, 'صنعاء جوار بيت بوس', 'صنعاء', 'بيت بوس', NULL, 'اليمن', 2183, NULL, NULL, 1, '2025-02-10 22:15:14', '2025-02-11 20:15:06', NULL, 'df', NULL, NULL, NULL, 'Same as Customer', 'Advocate', 'Advocate', 'aa', NULL), (2, 2, NULL, 'رحمه الله', NULL, 'Alvaa@gmail.com', '0777234567', NULL, 'شارع صخر', 'صنعاء', NULL, NULL, 'Yemen', 11991, NULL, NULL, 1, '2025-02-11 19:32:48', '2025-02-13 20:58:01', NULL, 'df', NULL, NULL, NULL, 'Same as Customer', 'Advocate', 'Advocate', 'aa', NULL); -- -------------------------------------------------------- -- -- Table structure for table `customer_groups` -- DROP TABLE IF EXISTS `customer_groups`; CREATE TABLE IF NOT EXISTS `customer_groups` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `percentage` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `is_active` tinyint(1) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `customer_groups` -- INSERT INTO `customer_groups` (`id`, `name`, `percentage`, `is_active`, `created_at`, `updated_at`) VALUES (1, 'عميل فردي', '3', 1, '2025-02-10 21:46:37', '2025-02-10 21:46:37'), (2, 'عميل افتراضي', '0', 1, '2025-02-11 19:32:07', '2025-02-11 19:32:07'); -- -------------------------------------------------------- -- -- Table structure for table `custom_fields` -- DROP TABLE IF EXISTS `custom_fields`; CREATE TABLE IF NOT EXISTS `custom_fields` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `belongs_to` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `default_value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `option_value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `grid_value` int NOT NULL, `is_table` tinyint(1) NOT NULL, `is_invoice` tinyint(1) NOT NULL, `is_required` tinyint(1) NOT NULL, `is_admin` tinyint(1) NOT NULL, `is_disable` tinyint(1) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `deliveries` -- DROP TABLE IF EXISTS `deliveries`; CREATE TABLE IF NOT EXISTS `deliveries` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `reference_no` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `sale_id` int NOT NULL, `packing_slip_ids` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_id` int DEFAULT NULL, `courier_id` int DEFAULT NULL, `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `delivered_by` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `recieved_by` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `file` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `note` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `deliveries` -- INSERT INTO `deliveries` (`id`, `reference_no`, `sale_id`, `packing_slip_ids`, `user_id`, `courier_id`, `address`, `delivered_by`, `recieved_by`, `file`, `note`, `status`, `created_at`, `updated_at`) VALUES (1, 'dr-20250211-111553', 1, NULL, 1, 1, 'صنعاء جوار بيت بوس صنعاء اليمن', 'اديب', 'احمد', NULL, NULL, '3', '2025-02-11 20:16:16', '2025-02-11 20:25:32'); -- -------------------------------------------------------- -- -- Table structure for table `departments` -- DROP TABLE IF EXISTS `departments`; CREATE TABLE IF NOT EXISTS `departments` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `is_active` tinyint(1) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `deposits` -- DROP TABLE IF EXISTS `deposits`; CREATE TABLE IF NOT EXISTS `deposits` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `amount` double NOT NULL, `customer_id` int NOT NULL, `user_id` int NOT NULL, `note` text CHARACTER SET utf8mb4 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; -- -------------------------------------------------------- -- -- Table structure for table `discounts` -- DROP TABLE IF EXISTS `discounts`; CREATE TABLE IF NOT EXISTS `discounts` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `applicable_for` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `product_list` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `valid_from` date NOT NULL, `valid_till` date NOT NULL, `type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `value` double NOT NULL, `minimum_qty` double NOT NULL, `maximum_qty` double NOT NULL, `days` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `is_active` tinyint(1) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `discount_plans` -- DROP TABLE IF EXISTS `discount_plans`; CREATE TABLE IF NOT EXISTS `discount_plans` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `is_active` tinyint(1) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `discount_plan_customers` -- DROP TABLE IF EXISTS `discount_plan_customers`; CREATE TABLE IF NOT EXISTS `discount_plan_customers` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `discount_plan_id` int NOT NULL, `customer_id` int NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `discount_plan_discounts` -- DROP TABLE IF EXISTS `discount_plan_discounts`; CREATE TABLE IF NOT EXISTS `discount_plan_discounts` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `discount_id` int NOT NULL, `discount_plan_id` int NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `dso_alerts` -- DROP TABLE IF EXISTS `dso_alerts`; CREATE TABLE IF NOT EXISTS `dso_alerts` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `product_info` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `number_of_products` int NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `employees` -- DROP TABLE IF EXISTS `employees`; CREATE TABLE IF NOT EXISTS `employees` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `phone_number` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `department_id` int NOT NULL, `user_id` int DEFAULT NULL, `staff_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `city` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `country` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_active` tinyint(1) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `expenses` -- DROP TABLE IF EXISTS `expenses`; CREATE TABLE IF NOT EXISTS `expenses` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `reference_no` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `expense_category_id` int NOT NULL, `warehouse_id` int NOT NULL, `account_id` int NOT NULL, `user_id` int NOT NULL, `cash_register_id` int DEFAULT NULL, `amount` double NOT NULL, `note` text CHARACTER SET utf8mb4 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; -- -------------------------------------------------------- -- -- Table structure for table `expense_categories` -- DROP TABLE IF EXISTS `expense_categories`; CREATE TABLE IF NOT EXISTS `expense_categories` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `code` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `is_active` tinyint(1) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `external_services` -- DROP TABLE IF EXISTS `external_services`; CREATE TABLE IF NOT EXISTS `external_services` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `details` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `active` int DEFAULT '1', `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 `external_services` -- INSERT INTO `external_services` (`id`, `name`, `type`, `details`, `active`, `created_at`, `updated_at`) VALUES (1, 'PayPal', 'payment', 'Client ID,Client Secret;abcd1234,wxyz5678', 1, NULL, NULL), (2, 'Stripe', 'payment', 'Public Key,Private Key;efgh1234,stuv5678', 1, NULL, NULL), (3, 'twilio', 'sms', '{\"account_sid\":\"AC2ca1e3d9389673247787875c143dcaed\",\"auth_token\":\"961a38ecc705f62193a2480b2de44f01\",\"twilio_number\":\"+17753064283\"}', 1, '2025-02-11 16:57:12', '2025-02-11 16:57:25'); -- -------------------------------------------------------- -- -- Table structure for table `failed_jobs` -- DROP TABLE IF EXISTS `failed_jobs`; CREATE TABLE IF NOT EXISTS `failed_jobs` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `exception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `general_settings` -- DROP TABLE IF EXISTS `general_settings`; CREATE TABLE IF NOT EXISTS `general_settings` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `site_title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `site_logo` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_rtl` tinyint(1) DEFAULT NULL, `currency` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `package_id` int DEFAULT NULL, `subscription_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `staff_access` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `without_stock` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no', `date_format` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `developed_by` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `invoice_format` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `decimal` int DEFAULT '2', `state` int DEFAULT NULL, `theme` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `modules` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `currency_position` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `expiry_date` date DEFAULT NULL, `expiry_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'days', `expiry_value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', `is_zatca` tinyint(1) DEFAULT NULL, `company_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `company_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `company_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `company_phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `vat_registration_number` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_packing_slip` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `general_settings` -- INSERT INTO `general_settings` (`id`, `site_title`, `site_logo`, `is_rtl`, `currency`, `package_id`, `subscription_type`, `staff_access`, `without_stock`, `date_format`, `developed_by`, `invoice_format`, `decimal`, `state`, `theme`, `modules`, `created_at`, `updated_at`, `currency_position`, `expiry_date`, `expiry_type`, `expiry_value`, `is_zatca`, `company_name`, `company_address`, `company_email`, `company_phone`, `vat_registration_number`, `is_packing_slip`) VALUES (1, 'MiniShopping', '20250206080229.png', 0, '4', NULL, NULL, 'own', 'no', 'd-m-Y', 'KaizonSoft', 'standard', 2, 1, 'default.css', NULL, '2018-07-06 06:13:11', '2025-02-27 20:49:15', 'prefix', NULL, 'days', '1', 0, 'بقالة الصباحي', 'صنعاء شارع الستين جوار وزارة الداخلية', 'adeebmof6@gmail.com', '0772526905', '98098007', 1); -- -------------------------------------------------------- -- -- Table structure for table `gift_cards` -- DROP TABLE IF EXISTS `gift_cards`; CREATE TABLE IF NOT EXISTS `gift_cards` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `card_no` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `amount` double NOT NULL, `expense` double NOT NULL, `customer_id` int DEFAULT NULL, `user_id` int DEFAULT NULL, `expired_date` date DEFAULT NULL, `created_by` int NOT NULL, `is_active` tinyint(1) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `gift_card_recharges` -- DROP TABLE IF EXISTS `gift_card_recharges`; CREATE TABLE IF NOT EXISTS `gift_card_recharges` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `gift_card_id` int NOT NULL, `amount` double NOT NULL, `user_id` int NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `holidays` -- DROP TABLE IF EXISTS `holidays`; CREATE TABLE IF NOT EXISTS `holidays` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `user_id` int NOT NULL, `from_date` date NOT NULL, `to_date` date NOT NULL, `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `is_approved` tinyint(1) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `hrm_settings` -- DROP TABLE IF EXISTS `hrm_settings`; CREATE TABLE IF NOT EXISTS `hrm_settings` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `checkin` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `checkout` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `hrm_settings` -- INSERT INTO `hrm_settings` (`id`, `checkin`, `checkout`, `created_at`, `updated_at`) VALUES (1, '10:00am', '6:00pm', '2019-01-02 02:20:08', '2019-01-02 04:20:53'); -- -------------------------------------------------------- -- -- Table structure for table `incomes` -- DROP TABLE IF EXISTS `incomes`; CREATE TABLE IF NOT EXISTS `incomes` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `reference_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `income_category_id` int NOT NULL, `warehouse_id` int NOT NULL, `account_id` int NOT NULL, `user_id` int NOT NULL, `cash_register_id` int DEFAULT NULL, `amount` double NOT NULL, `note` text CHARACTER SET utf8mb4 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; -- -------------------------------------------------------- -- -- Table structure for table `income_categories` -- DROP TABLE IF EXISTS `income_categories`; CREATE TABLE IF NOT EXISTS `income_categories` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `is_active` tinyint(1) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `languages` -- DROP TABLE IF EXISTS `languages`; CREATE TABLE IF NOT EXISTS `languages` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `code` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `languages` -- INSERT INTO `languages` (`id`, `code`, `created_at`, `updated_at`) VALUES (1, 'en', '2018-07-07 22:59:17', '2019-12-24 17:34:20'); -- -------------------------------------------------------- -- -- Table structure for table `mail_settings` -- DROP TABLE IF EXISTS `mail_settings`; CREATE TABLE IF NOT EXISTS `mail_settings` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `driver` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `host` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `port` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `from_address` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `from_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `username` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `password` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `encryption` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `mail_settings` -- INSERT INTO `mail_settings` (`id`, `driver`, `host`, `port`, `from_address`, `from_name`, `username`, `password`, `encryption`, `created_at`, `updated_at`) VALUES (1, 'smtp', 'smtp.gmail.com', '587', 'ashfaqdev.php@gmail.com', 'Adeeb', 'admin', 'admin', 'tls', '2025-02-11 16:58:33', '2025-02-11 16:58:33'); -- -------------------------------------------------------- -- -- Table structure for table `migrations` -- DROP TABLE IF EXISTS `migrations`; CREATE TABLE IF NOT EXISTS `migrations` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `migration` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=251 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `migrations` -- INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (1, '2014_10_12_000000_create_users_table', 1), (2, '2014_10_12_100000_create_password_resets_table', 1), (3, '2018_02_17_060412_create_categories_table', 1), (4, '2018_02_20_035727_create_brands_table', 1), (5, '2018_02_25_100635_create_suppliers_table', 1), (6, '2018_02_27_101619_create_warehouse_table', 1), (7, '2018_03_03_040448_create_units_table', 1), (8, '2018_03_04_041317_create_taxes_table', 1), (9, '2018_03_10_061915_create_customer_groups_table', 1), (10, '2018_03_10_090534_create_customers_table', 1), (11, '2018_03_11_095547_create_billers_table', 1), (12, '2018_04_05_054401_create_products_table', 1), (13, '2018_04_06_133606_create_purchases_table', 1), (14, '2018_04_06_154600_create_product_purchases_table', 1), (15, '2018_04_06_154915_create_product_warhouse_table', 1), (16, '2018_04_10_085927_create_sales_table', 1), (17, '2018_04_10_090133_create_product_sales_table', 1), (18, '2018_04_10_090254_create_payments_table', 1), (19, '2018_04_10_090341_create_payment_with_cheque_table', 1), (20, '2018_04_10_090509_create_payment_with_credit_card_table', 1), (21, '2018_04_13_121436_create_quotation_table', 1), (22, '2018_04_13_122324_create_product_quotation_table', 1), (23, '2018_04_14_121802_create_transfers_table', 1), (24, '2018_04_14_121913_create_product_transfer_table', 1), (25, '2018_05_13_082847_add_payment_id_and_change_sale_id_to_payments_table', 2), (26, '2018_05_13_090906_change_customer_id_to_payment_with_credit_card_table', 3), (27, '2018_05_20_054532_create_adjustments_table', 4), (28, '2018_05_20_054859_create_product_adjustments_table', 4), (29, '2018_05_21_163419_create_returns_table', 5), (30, '2018_05_21_163443_create_product_returns_table', 5), (31, '2018_06_02_050905_create_roles_table', 6), (32, '2018_06_02_073430_add_columns_to_users_table', 7), (33, '2018_06_03_053738_create_permission_tables', 8), (36, '2018_06_21_063736_create_pos_setting_table', 9), (37, '2018_06_21_094155_add_user_id_to_sales_table', 10), (38, '2018_06_21_101529_add_user_id_to_purchases_table', 11), (39, '2018_06_21_103512_add_user_id_to_transfers_table', 12), (40, '2018_06_23_061058_add_user_id_to_quotations_table', 13), (41, '2018_06_23_082427_add_is_deleted_to_users_table', 14), (42, '2018_06_25_043308_change_email_to_users_table', 15), (43, '2018_07_06_115449_create_general_settings_table', 16), (44, '2018_07_08_043944_create_languages_table', 17), (45, '2018_07_11_102144_add_user_id_to_returns_table', 18), (46, '2018_07_11_102334_add_user_id_to_payments_table', 18), (47, '2018_07_22_130541_add_digital_to_products_table', 19), (49, '2018_07_24_154250_create_deliveries_table', 20), (50, '2018_08_16_053336_create_expense_categories_table', 21), (51, '2018_08_17_115415_create_expenses_table', 22), (55, '2018_08_18_050418_create_gift_cards_table', 23), (56, '2018_08_19_063119_create_payment_with_gift_card_table', 24), (57, '2018_08_25_042333_create_gift_card_recharges_table', 25), (58, '2018_08_25_101354_add_deposit_expense_to_customers_table', 26), (59, '2018_08_26_043801_create_deposits_table', 27), (60, '2018_09_02_044042_add_keybord_active_to_pos_setting_table', 28), (61, '2018_09_09_092713_create_payment_with_paypal_table', 29), (62, '2018_09_10_051254_add_currency_to_general_settings_table', 30), (63, '2018_10_22_084118_add_biller_and_store_id_to_users_table', 31), (65, '2018_10_26_034927_create_coupons_table', 32), (66, '2018_10_27_090857_add_coupon_to_sales_table', 33), (67, '2018_11_07_070155_add_currency_position_to_general_settings_table', 34), (68, '2018_11_19_094650_add_combo_to_products_table', 35), (69, '2018_12_09_043712_create_accounts_table', 36), (70, '2018_12_17_112253_add_is_default_to_accounts_table', 37), (71, '2018_12_19_103941_add_account_id_to_payments_table', 38), (72, '2018_12_20_065900_add_account_id_to_expenses_table', 39), (73, '2018_12_20_082753_add_account_id_to_returns_table', 40), (74, '2018_12_26_064330_create_return_purchases_table', 41), (75, '2018_12_26_144210_create_purchase_product_return_table', 42), (76, '2018_12_26_144708_create_purchase_product_return_table', 43), (77, '2018_12_27_110018_create_departments_table', 44), (78, '2018_12_30_054844_create_employees_table', 45), (79, '2018_12_31_125210_create_payrolls_table', 46), (80, '2018_12_31_150446_add_department_id_to_employees_table', 47), (81, '2019_01_01_062708_add_user_id_to_expenses_table', 48), (82, '2019_01_02_075644_create_hrm_settings_table', 49), (83, '2019_01_02_090334_create_attendances_table', 50), (84, '2019_01_27_160956_add_three_columns_to_general_settings_table', 51), (85, '2019_02_15_183303_create_stock_counts_table', 52), (86, '2019_02_17_101604_add_is_adjusted_to_stock_counts_table', 53), (87, '2019_04_13_101707_add_tax_no_to_customers_table', 54), (89, '2019_10_14_111455_create_holidays_table', 55), (90, '2019_11_13_145619_add_is_variant_to_products_table', 56), (91, '2019_11_13_150206_create_product_variants_table', 57), (92, '2019_11_13_153828_create_variants_table', 57), (93, '2019_11_25_134041_add_qty_to_product_variants_table', 58), (94, '2019_11_25_134922_add_variant_id_to_product_purchases_table', 58), (95, '2019_11_25_145341_add_variant_id_to_product_warehouse_table', 58), (96, '2019_11_29_182201_add_variant_id_to_product_sales_table', 59), (97, '2019_12_04_121311_add_variant_id_to_product_quotation_table', 60), (98, '2019_12_05_123802_add_variant_id_to_product_transfer_table', 61), (100, '2019_12_08_114954_add_variant_id_to_product_returns_table', 62), (101, '2019_12_08_203146_add_variant_id_to_purchase_product_return_table', 63), (102, '2020_02_28_103340_create_money_transfers_table', 64), (103, '2020_07_01_193151_add_image_to_categories_table', 65), (105, '2020_09_26_130426_add_user_id_to_deliveries_table', 66), (107, '2020_10_11_125457_create_cash_registers_table', 67), (108, '2020_10_13_155019_add_cash_register_id_to_sales_table', 68), (109, '2020_10_13_172624_add_cash_register_id_to_returns_table', 69), (110, '2020_10_17_212338_add_cash_register_id_to_payments_table', 70), (111, '2020_10_18_124200_add_cash_register_id_to_expenses_table', 71), (112, '2020_10_21_121632_add_developed_by_to_general_settings_table', 72), (113, '2019_08_19_000000_create_failed_jobs_table', 73), (114, '2020_10_30_135557_create_notifications_table', 73), (115, '2020_11_01_044954_create_currencies_table', 74), (116, '2020_11_01_140736_add_price_to_product_warehouse_table', 75), (117, '2020_11_02_050633_add_is_diff_price_to_products_table', 76), (118, '2020_11_09_055222_add_user_id_to_customers_table', 77), (119, '2020_11_17_054806_add_invoice_format_to_general_settings_table', 78), (120, '2021_02_10_074859_add_variant_id_to_product_adjustments_table', 79), (121, '2021_03_07_093606_create_product_batches_table', 80), (122, '2021_03_07_093759_add_product_batch_id_to_product_warehouse_table', 80), (123, '2021_03_07_093900_add_product_batch_id_to_product_purchases_table', 80), (124, '2021_03_11_132603_add_product_batch_id_to_product_sales_table', 81), (127, '2021_03_25_125421_add_is_batch_to_products_table', 82), (128, '2021_05_19_120127_add_product_batch_id_to_product_returns_table', 82), (130, '2021_05_22_105611_add_product_batch_id_to_purchase_product_return_table', 83), (131, '2021_05_23_124848_add_product_batch_id_to_product_transfer_table', 84), (132, '2021_05_26_153106_add_product_batch_id_to_product_quotation_table', 85), (133, '2021_06_08_213007_create_reward_point_settings_table', 86), (134, '2021_06_16_104155_add_points_to_customers_table', 87), (135, '2021_06_17_101057_add_used_points_to_payments_table', 88), (136, '2021_07_06_132716_add_variant_list_to_products_table', 89), (137, '2021_09_27_161141_add_is_imei_to_products_table', 90), (138, '2021_09_28_170052_add_imei_number_to_product_warehouse_table', 91), (139, '2021_09_28_170126_add_imei_number_to_product_purchases_table', 91), (140, '2021_10_03_170652_add_imei_number_to_product_sales_table', 92), (141, '2021_10_10_145214_add_imei_number_to_product_returns_table', 93), (142, '2021_10_11_104504_add_imei_number_to_product_transfer_table', 94), (143, '2021_10_12_160107_add_imei_number_to_purchase_product_return_table', 95), (144, '2021_10_12_205146_add_is_rtl_to_general_settings_table', 96), (145, '2021_10_23_142451_add_is_approve_to_payments_table', 97), (146, '2022_01_13_191242_create_discount_plans_table', 97), (147, '2022_01_14_174318_create_discount_plan_customers_table', 97), (148, '2022_01_14_202439_create_discounts_table', 98), (149, '2022_01_16_153506_create_discount_plan_discounts_table', 98), (150, '2022_02_05_174210_add_order_discount_type_and_value_to_sales_table', 99), (154, '2022_05_26_195506_add_daily_sale_objective_to_products_table', 100), (155, '2022_05_28_104209_create_dso_alerts_table', 101), (156, '2022_06_01_112100_add_is_embeded_to_products_table', 102), (157, '2022_06_14_130505_add_sale_id_to_returns_table', 103), (159, '2022_07_19_115504_add_variant_data_to_products_table', 104), (160, '2022_07_25_194300_add_additional_cost_to_product_variants_table', 104), (161, '2022_09_04_195610_add_purchase_id_to_return_purchases_table', 105), (162, '2023_01_18_123842_alter_table_pos_setting', 106), (164, '2023_01_18_125040_alter_table_general_settings', 107), (165, '2023_01_18_133701_alter_table_pos_setting', 108), (166, '2023_01_25_145309_add_expiry_date_to_general_settings_table', 109), (167, '2023_02_23_125656_alter_table_sales', 110), (168, '2023_02_26_124100_add_package_id_to_general_settings_table', 111), (169, '2023_03_04_120325_create_custom_fields_table', 111), (170, '2023_03_22_174352_add_currency_id_and_exchange_rate_to_returns_table', 112), (171, '2023_03_27_114320_add_currency_id_and_exchange_rate_to_purchases_table', 113), (172, '2023_03_27_132747_add_currency_id_and_exchange_rate_to_return_purchases_table', 114), (173, '2023_04_25_150236_create_mail_settings_table', 115), (174, '2023_05_13_125424_add_zatca_to_general_settings_table', 116), (175, '2023_05_28_155540_create_tables_table', 117), (176, '2023_05_29_115039_add_is_table_to_pos_setting_table', 117), (177, '2023_05_29_115301_add_table_id_to_sales_table', 117), (178, '2023_05_31_165049_add_queue_no_to_sales_table', 117), (190, '2023_08_12_124016_add_staff_id_to_employees_table', 121), (192, '2023_07_23_160254_create_couriers_table', 122), (193, '2023_07_23_174343_add_courier_id_to_deliveries_table', 122), (194, '2023_08_14_142608_add_is_active_to_currencies_table', 122), (195, '2023_08_24_130203_change_columns_to_attendances_table', 122), (196, '2023_09_10_134503_add_without_stock_to_general_settings_table', 123), (204, '2023_09_26_211542_add_modules_to_general_settings_table', 125), (217, '2023_10_15_124306_add_return_qty_to_product_sales_table', 129), (219, '2023_12_03_235606_crete_external_services_table', 131), (221, '2023_03_14_174658_add_subscription_type_to_general_setting_table', 130), (222, '2024_02_04_131826_add_unit_cost_to_product_adjustments_table', 132), (223, '2024_02_13_173126_change_modules_to_general_settings_table', 133), (224, '2024_05_02_114215_add_payment_receiver_to_payments', 134), (225, '2024_05_06_132553_create_sms_templates_table', 135), (226, '2024_05_07_102225_add_send_sms_to_pos_setting_table', 135), (227, '2024_05_07_132625_add_is_default_to_sms_templates_table', 135), (228, '2024_05_08_112211_change_address_and_city_field_to_nullable_in_customers_table', 135), (229, '2024_05_08_151050_add_is_default_ecommerce_columne_to_sms_templates_table', 135), (230, '2024_05_20_182757_add_wholesale_price_to_products_table', 136), (231, '2024_05_21_170500_add_is_sent_to_transfers_table', 137), (232, '2023_02_05_132001_add_change_to_payments_table', 138), (233, '2024_06_04_225113_create_income_categories_table', 138), (234, '2024_06_04_225128_create_incomes_table', 138), (235, '2024_06_29_131917_add_is_packing_slip_to_general_settings_table', 138), (236, '2024_07_05_192531_create_packing_slips_table', 138), (237, '2024_07_05_193002_create_packing_slip_products_table', 138), (238, '2024_07_05_194501_add_is_packing_and_delivered_to_product_sales_table', 138), (239, '2024_07_14_122245_add_delivery_id_to_packing_slips_table', 138), (240, '2024_07_14_122415_add_variant_id_to_packing_slip_products_table', 138), (241, '2024_07_14_122519_add_packing_slip_ids_to_deliveries_table', 138), (242, '2024_07_16_125908_create_challans_table', 138), (243, '2024_08_12_112830_add_thermal_invoice_size_to_pos_setting', 139), (244, '2024_08_14_133351_add_expiry_type_value_to_general_settings', 139), (245, '2024_09_11_151744_add_return_qty_to_product_purchases_table', 140), (246, '2024_09_12_162309_create_barcodes_table', 140), (247, '2024_10_10_121312_add_data_to_payment_with_credit_card_table', 141), (248, '2024_10_10_212501_alter_attendances_table', 141), (249, '2024_10_10_213757_alter_attendances_table', 141), (250, '2024_10_14_144917_change_column_to_nullable_to_payment_with_credit_card_table', 141); -- -------------------------------------------------------- -- -- Table structure for table `money_transfers` -- DROP TABLE IF EXISTS `money_transfers`; CREATE TABLE IF NOT EXISTS `money_transfers` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `reference_no` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `from_account_id` int NOT NULL, `to_account_id` int NOT NULL, `amount` double NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `notifications` -- DROP TABLE IF EXISTS `notifications`; CREATE TABLE IF NOT EXISTS `notifications` ( `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `notifiable_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `notifiable_id` bigint UNSIGNED NOT NULL, `data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `read_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `notifications_notifiable_type_notifiable_id_index` (`notifiable_type`,`notifiable_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `packing_slips` -- DROP TABLE IF EXISTS `packing_slips`; CREATE TABLE IF NOT EXISTS `packing_slips` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `reference_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `sale_id` int NOT NULL, `delivery_id` int DEFAULT NULL, `amount` double NOT NULL, `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `packing_slip_products` -- DROP TABLE IF EXISTS `packing_slip_products`; CREATE TABLE IF NOT EXISTS `packing_slip_products` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `packing_slip_id` int NOT NULL, `product_id` int NOT NULL, `variant_id` int DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `password_resets` -- DROP TABLE IF EXISTS `password_resets`; CREATE TABLE IF NOT EXISTS `password_resets` ( `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, KEY `password_resets_email_index` (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `password_resets` -- INSERT INTO `password_resets` (`email`, `token`, `created_at`) VALUES ('ashfaqdev.php@gmail.com', '$2y$10$plxHOMxChJlHd9t6FQkoN.4dXMdtZ9fE5tXBBItzjxB1R5JF9OpbO', '2023-07-15 11:31:30'); -- -------------------------------------------------------- -- -- Table structure for table `payments` -- DROP TABLE IF EXISTS `payments`; CREATE TABLE IF NOT EXISTS `payments` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `payment_reference` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` int NOT NULL, `purchase_id` int DEFAULT NULL, `sale_id` int DEFAULT NULL, `cash_register_id` int DEFAULT NULL, `account_id` int NOT NULL, `payment_receiver` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `amount` double NOT NULL, `used_points` double DEFAULT NULL, `change` double DEFAULT NULL, `paying_method` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `payment_note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `payments` -- INSERT INTO `payments` (`id`, `payment_reference`, `user_id`, `purchase_id`, `sale_id`, `cash_register_id`, `account_id`, `payment_receiver`, `amount`, `used_points`, `change`, `paying_method`, `payment_note`, `created_at`, `updated_at`) VALUES (1, 'spr-20250211-113657', 1, NULL, 1, 1, 1, 'bn', 655080, NULL, 0, 'Cash', NULL, '2025-02-11 20:36:57', '2025-02-11 20:36:57'), (2, 'spr-20250211-113659', 1, NULL, 1, 1, 1, 'bn', 655080, NULL, 0, 'Cash', NULL, '2025-02-11 20:36:59', '2025-02-11 20:36:59'), (3, 'spr-20250211-114516', 1, NULL, 2, 1, 1, NULL, 424000, NULL, 0, 'Cash', NULL, '2025-02-11 20:45:16', '2025-02-11 20:45:16'), (4, 'spr-20250211-114610', 1, NULL, 3, 1, 1, NULL, 636000, NULL, 0, 'Cash', NULL, '2025-02-11 20:46:10', '2025-02-11 20:46:10'), (5, 'spr-20250211-114705', 1, NULL, 4, 1, 1, NULL, 212000, NULL, 0, 'Cash', NULL, '2025-02-11 20:47:05', '2025-02-11 20:47:05'), (6, 'spr-20250211-114826', 1, NULL, 5, 1, 1, NULL, 212000, NULL, 0, 'Cash', NULL, '2025-02-11 20:48:26', '2025-02-11 20:48:26'), (7, 'spr-20250211-114911', 1, NULL, 6, 1, 1, NULL, 212000, NULL, 0, 'Cash', NULL, '2025-02-11 20:49:11', '2025-02-11 20:49:11'), (8, 'spr-20250211-115537', 1, NULL, 7, 1, 1, 'اديب', 207760, NULL, 0, 'Cash', NULL, '2025-02-11 20:55:37', '2025-02-11 20:55:37'), (9, 'spr-20250212-121149', 1, NULL, 8, 1, 1, NULL, 212000, NULL, 0, 'Cash', NULL, '2025-02-11 21:11:49', '2025-02-11 21:11:49'), (10, 'spr-20250212-121705', 1, NULL, 9, 1, 1, NULL, 212000, NULL, 0, 'Cash', NULL, '2025-02-11 21:17:05', '2025-02-11 21:17:05'), (11, 'spr-20250212-121815', 1, NULL, 10, 1, 1, NULL, 212000, NULL, 0, 'Cash', NULL, '2025-02-11 21:18:15', '2025-02-11 21:18:15'), (12, 'spr-20250212-121919', 1, NULL, 11, 1, 1, NULL, 212000, NULL, 0, 'Cash', NULL, '2025-02-11 21:19:19', '2025-02-11 21:19:19'), (13, 'spr-20250212-123121', 1, NULL, 12, 1, 1, NULL, 212000, NULL, 0, 'Cash', NULL, '2025-02-11 21:31:21', '2025-02-11 21:31:21'), (14, 'spr-20250212-123225', 1, NULL, 13, 1, 1, NULL, 212000, NULL, 0, 'Cash', NULL, '2025-02-11 21:32:25', '2025-02-11 21:32:25'), (15, 'spr-20250212-123316', 1, NULL, 14, 1, 1, NULL, 212000, NULL, 0, 'Cash', NULL, '2025-02-11 21:33:16', '2025-02-11 21:33:16'), (16, 'spr-20250213-115802', 1, NULL, 15, 1, 1, NULL, 212000, NULL, 0, 'Cash', NULL, '2025-02-13 20:58:02', '2025-02-13 20:58:02'); -- -------------------------------------------------------- -- -- Table structure for table `payment_with_cheque` -- DROP TABLE IF EXISTS `payment_with_cheque`; CREATE TABLE IF NOT EXISTS `payment_with_cheque` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `payment_id` int NOT NULL, `cheque_no` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `payment_with_credit_card` -- DROP TABLE IF EXISTS `payment_with_credit_card`; CREATE TABLE IF NOT EXISTS `payment_with_credit_card` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `payment_id` int NOT NULL, `customer_id` int DEFAULT NULL, `customer_stripe_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `charge_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `data` longtext CHARACTER SET utf8mb4 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; -- -------------------------------------------------------- -- -- Table structure for table `payment_with_gift_card` -- DROP TABLE IF EXISTS `payment_with_gift_card`; CREATE TABLE IF NOT EXISTS `payment_with_gift_card` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `payment_id` int NOT NULL, `gift_card_id` int NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `payment_with_paypal` -- DROP TABLE IF EXISTS `payment_with_paypal`; CREATE TABLE IF NOT EXISTS `payment_with_paypal` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `payment_id` int NOT NULL, `transaction_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `payrolls` -- DROP TABLE IF EXISTS `payrolls`; CREATE TABLE IF NOT EXISTS `payrolls` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `reference_no` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `employee_id` int NOT NULL, `account_id` int NOT NULL, `user_id` int NOT NULL, `amount` double NOT NULL, `paying_method` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `note` text CHARACTER SET utf8mb4 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; -- -------------------------------------------------------- -- -- Table structure for table `permissions` -- DROP TABLE IF EXISTS `permissions`; CREATE TABLE IF NOT EXISTS `permissions` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `guard_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=133 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `permissions` -- INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (4, 'products-edit', 'web', '2018-06-03 01:00:09', '2018-06-03 01:00:09'), (5, 'products-delete', 'web', '2018-06-03 22:54:22', '2018-06-03 22:54:22'), (6, 'products-add', 'web', '2018-06-04 00:34:14', '2018-06-04 00:34:14'), (7, 'products-index', 'web', '2018-06-04 03:34:27', '2018-06-04 03:34:27'), (8, 'purchases-index', 'web', '2018-06-04 08:03:19', '2018-06-04 08:03:19'), (9, 'purchases-add', 'web', '2018-06-04 08:12:25', '2018-06-04 08:12:25'), (10, 'purchases-edit', 'web', '2018-06-04 09:47:36', '2018-06-04 09:47:36'), (11, 'purchases-delete', 'web', '2018-06-04 09:47:36', '2018-06-04 09:47:36'), (12, 'sales-index', 'web', '2018-06-04 10:49:08', '2018-06-04 10:49:08'), (13, 'sales-add', 'web', '2018-06-04 10:49:52', '2018-06-04 10:49:52'), (14, 'sales-edit', 'web', '2018-06-04 10:49:52', '2018-06-04 10:49:52'), (15, 'sales-delete', 'web', '2018-06-04 10:49:53', '2018-06-04 10:49:53'), (16, 'quotes-index', 'web', '2018-06-04 22:05:10', '2018-06-04 22:05:10'), (17, 'quotes-add', 'web', '2018-06-04 22:05:10', '2018-06-04 22:05:10'), (18, 'quotes-edit', 'web', '2018-06-04 22:05:10', '2018-06-04 22:05:10'), (19, 'quotes-delete', 'web', '2018-06-04 22:05:10', '2018-06-04 22:05:10'), (20, 'transfers-index', 'web', '2018-06-04 22:30:03', '2018-06-04 22:30:03'), (21, 'transfers-add', 'web', '2018-06-04 22:30:03', '2018-06-04 22:30:03'), (22, 'transfers-edit', 'web', '2018-06-04 22:30:03', '2018-06-04 22:30:03'), (23, 'transfers-delete', 'web', '2018-06-04 22:30:03', '2018-06-04 22:30:03'), (24, 'returns-index', 'web', '2018-06-04 22:50:24', '2018-06-04 22:50:24'), (25, 'returns-add', 'web', '2018-06-04 22:50:24', '2018-06-04 22:50:24'), (26, 'returns-edit', 'web', '2018-06-04 22:50:25', '2018-06-04 22:50:25'), (27, 'returns-delete', 'web', '2018-06-04 22:50:25', '2018-06-04 22:50:25'), (28, 'customers-index', 'web', '2018-06-04 23:15:54', '2018-06-04 23:15:54'), (29, 'customers-add', 'web', '2018-06-04 23:15:55', '2018-06-04 23:15:55'), (30, 'customers-edit', 'web', '2018-06-04 23:15:55', '2018-06-04 23:15:55'), (31, 'customers-delete', 'web', '2018-06-04 23:15:55', '2018-06-04 23:15:55'), (32, 'suppliers-index', 'web', '2018-06-04 23:40:12', '2018-06-04 23:40:12'), (33, 'suppliers-add', 'web', '2018-06-04 23:40:12', '2018-06-04 23:40:12'), (34, 'suppliers-edit', 'web', '2018-06-04 23:40:12', '2018-06-04 23:40:12'), (35, 'suppliers-delete', 'web', '2018-06-04 23:40:12', '2018-06-04 23:40:12'), (36, 'product-report', 'web', '2018-06-24 23:05:33', '2018-06-24 23:05:33'), (37, 'purchase-report', 'web', '2018-06-24 23:24:56', '2018-06-24 23:24:56'), (38, 'sale-report', 'web', '2018-06-24 23:33:13', '2018-06-24 23:33:13'), (39, 'customer-report', 'web', '2018-06-24 23:36:51', '2018-06-24 23:36:51'), (40, 'due-report', 'web', '2018-06-24 23:39:52', '2018-06-24 23:39:52'), (41, 'users-index', 'web', '2018-06-25 00:00:10', '2018-06-25 00:00:10'), (42, 'users-add', 'web', '2018-06-25 00:00:10', '2018-06-25 00:00:10'), (43, 'users-edit', 'web', '2018-06-25 00:01:30', '2018-06-25 00:01:30'), (44, 'users-delete', 'web', '2018-06-25 00:01:30', '2018-06-25 00:01:30'), (45, 'profit-loss', 'web', '2018-07-14 21:50:05', '2018-07-14 21:50:05'), (46, 'best-seller', 'web', '2018-07-14 22:01:38', '2018-07-14 22:01:38'), (47, 'daily-sale', 'web', '2018-07-14 22:24:21', '2018-07-14 22:24:21'), (48, 'monthly-sale', 'web', '2018-07-14 22:30:41', '2018-07-14 22:30:41'), (49, 'daily-purchase', 'web', '2018-07-14 22:36:46', '2018-07-14 22:36:46'), (50, 'monthly-purchase', 'web', '2018-07-14 22:48:17', '2018-07-14 22:48:17'), (51, 'payment-report', 'web', '2018-07-14 23:10:41', '2018-07-14 23:10:41'), (52, 'warehouse-stock-report', 'web', '2018-07-14 23:16:55', '2018-07-14 23:16:55'), (53, 'product-qty-alert', 'web', '2018-07-14 23:33:21', '2018-07-14 23:33:21'), (54, 'supplier-report', 'web', '2018-07-30 03:00:01', '2018-07-30 03:00:01'), (55, 'expenses-index', 'web', '2018-09-05 01:07:10', '2018-09-05 01:07:10'), (56, 'expenses-add', 'web', '2018-09-05 01:07:10', '2018-09-05 01:07:10'), (57, 'expenses-edit', 'web', '2018-09-05 01:07:10', '2018-09-05 01:07:10'), (58, 'expenses-delete', 'web', '2018-09-05 01:07:11', '2018-09-05 01:07:11'), (59, 'general_setting', 'web', '2018-10-19 23:10:04', '2018-10-19 23:10:04'), (60, 'mail_setting', 'web', '2018-10-19 23:10:04', '2018-10-19 23:10:04'), (61, 'pos_setting', 'web', '2018-10-19 23:10:04', '2018-10-19 23:10:04'), (62, 'hrm_setting', 'web', '2019-01-02 10:30:23', '2019-01-02 10:30:23'), (63, 'purchase-return-index', 'web', '2019-01-02 21:45:14', '2019-01-02 21:45:14'), (64, 'purchase-return-add', 'web', '2019-01-02 21:45:14', '2019-01-02 21:45:14'), (65, 'purchase-return-edit', 'web', '2019-01-02 21:45:14', '2019-01-02 21:45:14'), (66, 'purchase-return-delete', 'web', '2019-01-02 21:45:14', '2019-01-02 21:45:14'), (67, 'account-index', 'web', '2019-01-02 22:06:13', '2019-01-02 22:06:13'), (68, 'balance-sheet', 'web', '2019-01-02 22:06:14', '2019-01-02 22:06:14'), (69, 'account-statement', 'web', '2019-01-02 22:06:14', '2019-01-02 22:06:14'), (70, 'department', 'web', '2019-01-02 22:30:01', '2019-01-02 22:30:01'), (71, 'attendance', 'web', '2019-01-02 22:30:01', '2019-01-02 22:30:01'), (72, 'payroll', 'web', '2019-01-02 22:30:01', '2019-01-02 22:30:01'), (73, 'employees-index', 'web', '2019-01-02 22:52:19', '2019-01-02 22:52:19'), (74, 'employees-add', 'web', '2019-01-02 22:52:19', '2019-01-02 22:52:19'), (75, 'employees-edit', 'web', '2019-01-02 22:52:19', '2019-01-02 22:52:19'), (76, 'employees-delete', 'web', '2019-01-02 22:52:19', '2019-01-02 22:52:19'), (77, 'user-report', 'web', '2019-01-16 06:48:18', '2019-01-16 06:48:18'), (78, 'stock_count', 'web', '2019-02-17 10:32:01', '2019-02-17 10:32:01'), (79, 'adjustment', 'web', '2019-02-17 10:32:02', '2019-02-17 10:32:02'), (80, 'sms_setting', 'web', '2019-02-22 05:18:03', '2019-02-22 05:18:03'), (81, 'create_sms', 'web', '2019-02-22 05:18:03', '2019-02-22 05:18:03'), (82, 'print_barcode', 'web', '2019-03-07 05:02:19', '2019-03-07 05:02:19'), (83, 'empty_database', 'web', '2019-03-07 05:02:19', '2019-03-07 05:02:19'), (84, 'customer_group', 'web', '2019-03-07 05:37:15', '2019-03-07 05:37:15'), (85, 'unit', 'web', '2019-03-07 05:37:15', '2019-03-07 05:37:15'), (86, 'tax', 'web', '2019-03-07 05:37:15', '2019-03-07 05:37:15'), (87, 'gift_card', 'web', '2019-03-07 06:29:38', '2019-03-07 06:29:38'), (88, 'coupon', 'web', '2019-03-07 06:29:38', '2019-03-07 06:29:38'), (89, 'holiday', 'web', '2019-10-19 08:57:15', '2019-10-19 08:57:15'), (90, 'warehouse-report', 'web', '2019-10-22 06:00:23', '2019-10-22 06:00:23'), (91, 'warehouse', 'web', '2020-02-26 06:47:32', '2020-02-26 06:47:32'), (92, 'brand', 'web', '2020-02-26 06:59:59', '2020-02-26 06:59:59'), (93, 'billers-index', 'web', '2020-02-26 07:11:15', '2020-02-26 07:11:15'), (94, 'billers-add', 'web', '2020-02-26 07:11:15', '2020-02-26 07:11:15'), (95, 'billers-edit', 'web', '2020-02-26 07:11:15', '2020-02-26 07:11:15'), (96, 'billers-delete', 'web', '2020-02-26 07:11:15', '2020-02-26 07:11:15'), (97, 'money-transfer', 'web', '2020-03-02 05:41:48', '2020-03-02 05:41:48'), (98, 'category', 'web', '2020-07-13 12:13:16', '2020-07-13 12:13:16'), (99, 'delivery', 'web', '2020-07-13 12:13:16', '2020-07-13 12:13:16'), (100, 'send_notification', 'web', '2020-10-31 06:21:31', '2020-10-31 06:21:31'), (101, 'today_sale', 'web', '2020-10-31 06:57:04', '2020-10-31 06:57:04'), (102, 'today_profit', 'web', '2020-10-31 06:57:04', '2020-10-31 06:57:04'), (103, 'currency', 'web', '2020-11-09 00:23:11', '2020-11-09 00:23:11'), (104, 'backup_database', 'web', '2020-11-15 00:16:55', '2020-11-15 00:16:55'), (105, 'reward_point_setting', 'web', '2021-06-27 04:34:42', '2021-06-27 04:34:42'), (106, 'revenue_profit_summary', 'web', '2022-02-08 13:57:21', '2022-02-08 13:57:21'), (107, 'cash_flow', 'web', '2022-02-08 13:57:22', '2022-02-08 13:57:22'), (108, 'monthly_summary', 'web', '2022-02-08 13:57:22', '2022-02-08 13:57:22'), (109, 'yearly_report', 'web', '2022-02-08 13:57:22', '2022-02-08 13:57:22'), (110, 'discount_plan', 'web', '2022-02-16 09:12:26', '2022-02-16 09:12:26'), (111, 'discount', 'web', '2022-02-16 09:12:38', '2022-02-16 09:12:38'), (112, 'product-expiry-report', 'web', '2022-03-30 05:39:20', '2022-03-30 05:39:20'), (113, 'purchase-payment-index', 'web', '2022-06-05 14:12:27', '2022-06-05 14:12:27'), (114, 'purchase-payment-add', 'web', '2022-06-05 14:12:28', '2022-06-05 14:12:28'), (115, 'purchase-payment-edit', 'web', '2022-06-05 14:12:28', '2022-06-05 14:12:28'), (116, 'purchase-payment-delete', 'web', '2022-06-05 14:12:28', '2022-06-05 14:12:28'), (117, 'sale-payment-index', 'web', '2022-06-05 14:12:28', '2022-06-05 14:12:28'), (118, 'sale-payment-add', 'web', '2022-06-05 14:12:28', '2022-06-05 14:12:28'), (119, 'sale-payment-edit', 'web', '2022-06-05 14:12:28', '2022-06-05 14:12:28'), (120, 'sale-payment-delete', 'web', '2022-06-05 14:12:28', '2022-06-05 14:12:28'), (121, 'all_notification', 'web', '2022-06-05 14:12:29', '2022-06-05 14:12:29'), (122, 'sale-report-chart', 'web', '2022-06-05 14:12:29', '2022-06-05 14:12:29'), (123, 'dso-report', 'web', '2022-06-05 14:12:29', '2022-06-05 14:12:29'), (124, 'product_history', 'web', '2022-08-25 14:04:05', '2022-08-25 14:04:05'), (125, 'supplier-due-report', 'web', '2022-08-31 09:46:33', '2022-08-31 09:46:33'), (126, 'custom_field', 'web', '2023-05-02 07:41:35', '2023-05-02 07:41:35'), (127, 'incomes-index', 'web', '2024-08-11 04:50:59', '2024-08-11 04:50:59'), (128, 'incomes-add', 'web', '2024-08-11 04:50:59', '2024-08-11 04:50:59'), (129, 'incomes-edit', 'web', '2024-08-11 04:50:59', '2024-08-11 04:50:59'), (130, 'incomes-delete', 'web', '2024-08-11 04:50:59', '2024-08-11 04:50:59'), (131, 'packing_slip_challan', 'web', '2024-08-11 04:51:00', '2024-08-11 04:51:00'), (132, 'biller-report', 'web', '2024-08-21 06:15:25', '2024-08-21 06:15:25'); -- -------------------------------------------------------- -- -- Table structure for table `pos_setting` -- DROP TABLE IF EXISTS `pos_setting`; CREATE TABLE IF NOT EXISTS `pos_setting` ( `id` int NOT NULL AUTO_INCREMENT, `customer_id` int NOT NULL, `warehouse_id` int NOT NULL, `biller_id` int NOT NULL, `product_number` int NOT NULL, `keybord_active` tinyint(1) NOT NULL, `is_table` tinyint(1) NOT NULL DEFAULT '0', `send_sms` tinyint(1) NOT NULL DEFAULT '0', `stripe_public_key` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `stripe_secret_key` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `paypal_live_api_username` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `paypal_live_api_password` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `paypal_live_api_secret` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `payment_options` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `invoice_option` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `thermal_invoice_size` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '80', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, UNIQUE KEY `pos_setting_id_unique` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `pos_setting` -- INSERT INTO `pos_setting` (`id`, `customer_id`, `warehouse_id`, `biller_id`, `product_number`, `keybord_active`, `is_table`, `send_sms`, `stripe_public_key`, `stripe_secret_key`, `paypal_live_api_username`, `paypal_live_api_password`, `paypal_live_api_secret`, `payment_options`, `invoice_option`, `thermal_invoice_size`, `created_at`, `updated_at`) VALUES (1, 2, 1, 1, 5, 0, 0, 0, NULL, NULL, 'admin', 'admin', NULL, 'cash,card,cheque,gift_card,deposit,paypal', 'A4', '58', '2018-09-02 03:17:04', '2025-02-13 20:59:56'); -- -------------------------------------------------------- -- -- Table structure for table `products` -- DROP TABLE IF EXISTS `products`; CREATE TABLE IF NOT EXISTS `products` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `code` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `barcode_symbology` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `brand_id` int DEFAULT NULL, `category_id` int NOT NULL, `unit_id` int NOT NULL, `purchase_unit_id` int NOT NULL, `sale_unit_id` int NOT NULL, `cost` double NOT NULL, `price` double NOT NULL, `wholesale_price` double DEFAULT NULL, `qty` double DEFAULT NULL, `alert_quantity` double DEFAULT NULL, `daily_sale_objective` double DEFAULT NULL, `promotion` tinyint DEFAULT NULL, `promotion_price` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `starting_date` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `last_date` date DEFAULT NULL, `tax_id` int DEFAULT NULL, `tax_method` int DEFAULT NULL, `image` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `file` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_embeded` tinyint(1) DEFAULT NULL, `is_variant` tinyint(1) DEFAULT NULL, `is_batch` tinyint(1) DEFAULT NULL, `is_diffPrice` tinyint(1) DEFAULT NULL, `is_imei` tinyint(1) DEFAULT NULL, `featured` tinyint DEFAULT NULL, `product_list` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `variant_list` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `qty_list` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `price_list` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `product_details` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `variant_option` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `variant_value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `is_active` tinyint(1) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `products` -- INSERT INTO `products` (`id`, `name`, `code`, `type`, `barcode_symbology`, `brand_id`, `category_id`, `unit_id`, `purchase_unit_id`, `sale_unit_id`, `cost`, `price`, `wholesale_price`, `qty`, `alert_quantity`, `daily_sale_objective`, `promotion`, `promotion_price`, `starting_date`, `last_date`, `tax_id`, `tax_method`, `image`, `file`, `is_embeded`, `is_variant`, `is_batch`, `is_diffPrice`, `is_imei`, `featured`, `product_list`, `variant_list`, `qty_list`, `price_list`, `product_details`, `variant_option`, `variant_value`, `is_active`, `created_at`, `updated_at`) VALUES (1, 'ماء صنعاء', '1233', 'standard', 'C128', NULL, 4, 1, 3, 1, 87, 400, NULL, 1980, 20, 100, NULL, NULL, NULL, NULL, NULL, 1, '131322.png', NULL, 0, 1, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, '

ماء معدني

', '[\"\\\"Size\",\"Color\"]', '[\"S,M,L\",\"Red,Green\"]', 1, '2025-02-10 21:26:21', '2025-02-27 20:30:43'); -- -------------------------------------------------------- -- -- Table structure for table `product_adjustments` -- DROP TABLE IF EXISTS `product_adjustments`; CREATE TABLE IF NOT EXISTS `product_adjustments` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `adjustment_id` int NOT NULL, `product_id` int NOT NULL, `variant_id` int DEFAULT NULL, `unit_cost` double DEFAULT NULL, `qty` double NOT NULL, `action` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `product_batches` -- DROP TABLE IF EXISTS `product_batches`; CREATE TABLE IF NOT EXISTS `product_batches` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `product_id` int NOT NULL, `batch_no` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `expired_date` date NOT NULL, `qty` double NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `product_purchases` -- DROP TABLE IF EXISTS `product_purchases`; CREATE TABLE IF NOT EXISTS `product_purchases` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `purchase_id` int NOT NULL, `product_id` int NOT NULL, `product_batch_id` int DEFAULT NULL, `variant_id` int DEFAULT NULL, `imei_number` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `qty` double NOT NULL, `recieved` double NOT NULL, `return_qty` double NOT NULL DEFAULT '0', `purchase_unit_id` int NOT NULL, `net_unit_cost` double NOT NULL, `discount` double NOT NULL, `tax_rate` double NOT NULL, `tax` double NOT NULL, `total` double NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `product_purchases` -- INSERT INTO `product_purchases` (`id`, `purchase_id`, `product_id`, `product_batch_id`, `variant_id`, `imei_number`, `qty`, `recieved`, `return_qty`, `purchase_unit_id`, `net_unit_cost`, `discount`, `tax_rate`, `tax`, `total`, `created_at`, `updated_at`) VALUES (1, 1, 1, NULL, 7, NULL, 2000, 2000, 0, 1, 300, 0, 0, 0, 600000, '2025-02-11 17:03:28', '2025-02-11 17:03:28'); -- -------------------------------------------------------- -- -- Table structure for table `product_quotation` -- DROP TABLE IF EXISTS `product_quotation`; CREATE TABLE IF NOT EXISTS `product_quotation` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `quotation_id` int NOT NULL, `product_id` int NOT NULL, `product_batch_id` int DEFAULT NULL, `variant_id` int DEFAULT NULL, `qty` double NOT NULL, `sale_unit_id` int NOT NULL, `net_unit_price` double NOT NULL, `discount` double NOT NULL, `tax_rate` double NOT NULL, `tax` double NOT NULL, `total` double NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `product_returns` -- DROP TABLE IF EXISTS `product_returns`; CREATE TABLE IF NOT EXISTS `product_returns` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `return_id` int NOT NULL, `product_id` int NOT NULL, `product_batch_id` int DEFAULT NULL, `variant_id` int DEFAULT NULL, `imei_number` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `qty` double NOT NULL, `sale_unit_id` int NOT NULL, `net_unit_price` double NOT NULL, `discount` double NOT NULL, `tax_rate` double NOT NULL, `tax` double NOT NULL, `total` double NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `product_sales` -- DROP TABLE IF EXISTS `product_sales`; CREATE TABLE IF NOT EXISTS `product_sales` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `sale_id` int NOT NULL, `product_id` int NOT NULL, `product_batch_id` int DEFAULT NULL, `variant_id` int DEFAULT NULL, `imei_number` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `qty` double NOT NULL, `return_qty` double NOT NULL DEFAULT '0', `sale_unit_id` int NOT NULL, `net_unit_price` double NOT NULL, `discount` double NOT NULL, `tax_rate` double NOT NULL, `tax` double NOT NULL, `total` double NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `is_delivered` tinyint(1) DEFAULT NULL, `is_packing` tinyint(1) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `product_sales` -- INSERT INTO `product_sales` (`id`, `sale_id`, `product_id`, `product_batch_id`, `variant_id`, `imei_number`, `qty`, `return_qty`, `sale_unit_id`, `net_unit_price`, `discount`, `tax_rate`, `tax`, `total`, `created_at`, `updated_at`, `is_delivered`, `is_packing`) VALUES (1, 1, 1, NULL, 7, 'null', 3, 0, 1, 218360, 0, 0, 0, 655080, '2025-02-11 17:06:39', '2025-02-11 20:37:38', NULL, NULL), (2, 2, 1, NULL, 7, 'null', 2, 0, 1, 212000, 0, 0, 0, 424000, '2025-02-11 20:45:04', '2025-02-11 20:45:04', NULL, NULL), (3, 3, 1, NULL, 7, 'null', 3, 0, 1, 212000, 0, 0, 0, 636000, '2025-02-11 20:46:10', '2025-02-11 20:46:10', NULL, NULL), (4, 4, 1, NULL, 7, 'null', 1, 0, 1, 212000, 0, 0, 0, 212000, '2025-02-11 20:46:53', '2025-02-11 20:46:53', NULL, NULL), (5, 5, 1, NULL, 7, 'null', 1, 0, 1, 212000, 0, 0, 0, 212000, '2025-02-11 20:48:20', '2025-02-11 20:48:20', NULL, NULL), (6, 6, 1, NULL, 7, 'null', 1, 0, 1, 212000, 0, 0, 0, 212000, '2025-02-11 20:49:08', '2025-02-11 20:49:08', NULL, NULL), (7, 7, 1, NULL, 7, 'null', 1, 0, 1, 212000, 0, 0, 0, 212000, '2025-02-11 20:55:34', '2025-02-11 20:55:34', NULL, NULL), (8, 8, 1, NULL, 7, 'null', 1, 0, 1, 212000, 0, 0, 0, 212000, '2025-02-11 21:11:37', '2025-02-11 21:11:37', NULL, NULL), (9, 9, 1, NULL, 7, 'null', 1, 0, 1, 212000, 0, 0, 0, 212000, '2025-02-11 21:16:09', '2025-02-11 21:16:09', NULL, NULL), (10, 10, 1, NULL, 7, 'null', 1, 0, 1, 212000, 0, 0, 0, 212000, '2025-02-11 21:17:54', '2025-02-11 21:17:54', NULL, NULL), (11, 11, 1, NULL, 7, 'null', 1, 0, 1, 212000, 0, 0, 0, 212000, '2025-02-11 21:18:59', '2025-02-11 21:18:59', NULL, NULL), (12, 12, 1, NULL, 7, 'null', 1, 0, 1, 212000, 0, 0, 0, 212000, '2025-02-11 21:31:21', '2025-02-11 21:31:21', NULL, NULL), (13, 13, 1, NULL, 7, 'null', 1, 0, 1, 212000, 0, 0, 0, 212000, '2025-02-11 21:32:25', '2025-02-11 21:32:25', NULL, NULL), (14, 14, 1, NULL, 7, 'null', 1, 0, 1, 212000, 0, 0, 0, 212000, '2025-02-11 21:33:09', '2025-02-11 21:33:09', NULL, NULL), (15, 15, 1, NULL, 7, 'null', 1, 0, 1, 212000, 0, 0, 0, 212000, '2025-02-13 20:58:01', '2025-02-13 20:58:01', NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `product_transfer` -- DROP TABLE IF EXISTS `product_transfer`; CREATE TABLE IF NOT EXISTS `product_transfer` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `transfer_id` int NOT NULL, `product_id` int NOT NULL, `product_batch_id` int DEFAULT NULL, `variant_id` int DEFAULT NULL, `imei_number` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `qty` double NOT NULL, `purchase_unit_id` int NOT NULL, `net_unit_cost` double NOT NULL, `tax_rate` double NOT NULL, `tax` double NOT NULL, `total` double NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `product_variants` -- DROP TABLE IF EXISTS `product_variants`; CREATE TABLE IF NOT EXISTS `product_variants` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `product_id` int NOT NULL, `variant_id` int NOT NULL, `position` int NOT NULL, `item_code` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `additional_cost` double DEFAULT NULL, `additional_price` double DEFAULT NULL, `qty` double NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `product_variants` -- INSERT INTO `product_variants` (`id`, `product_id`, `variant_id`, `position`, `item_code`, `additional_cost`, `additional_price`, `qty`, `created_at`, `updated_at`) VALUES (2, 1, 2, 2, 'S/Green-1233', 0, 0, 0, '2025-02-10 21:30:02', '2025-02-11 17:02:13'), (3, 1, 3, 3, 'M/Red-1233', 0, 0, 0, '2025-02-10 21:30:02', '2025-02-11 17:02:13'), (4, 1, 4, 4, 'M/Green-1233', 0, 0, 0, '2025-02-10 21:30:02', '2025-02-11 17:02:13'), (5, 1, 5, 5, 'L/Red-1233', 0, 10, 0, '2025-02-10 21:30:02', '2025-02-11 17:02:13'), (7, 1, 7, 1, 'S/Red-1233', NULL, NULL, 1980, '2025-02-11 17:02:13', '2025-02-13 20:58:01'), (8, 1, 8, 6, 'L/Green-1233', NULL, NULL, 0, '2025-02-11 17:02:13', '2025-02-11 17:02:13'); -- -------------------------------------------------------- -- -- Table structure for table `product_warehouse` -- DROP TABLE IF EXISTS `product_warehouse`; CREATE TABLE IF NOT EXISTS `product_warehouse` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `product_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `product_batch_id` int DEFAULT NULL, `variant_id` int DEFAULT NULL, `imei_number` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `warehouse_id` int NOT NULL, `qty` double NOT NULL, `price` double DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `product_warehouse` -- INSERT INTO `product_warehouse` (`id`, `product_id`, `product_batch_id`, `variant_id`, `imei_number`, `warehouse_id`, `qty`, `price`, `created_at`, `updated_at`) VALUES (1, '1', NULL, 7, '', 1, 1980, NULL, '2025-02-11 17:03:28', '2025-02-27 19:28:24'); -- -------------------------------------------------------- -- -- Table structure for table `purchases` -- DROP TABLE IF EXISTS `purchases`; CREATE TABLE IF NOT EXISTS `purchases` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `reference_no` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` int NOT NULL, `warehouse_id` int NOT NULL, `supplier_id` int DEFAULT NULL, `currency_id` int DEFAULT NULL, `exchange_rate` double DEFAULT NULL, `item` int NOT NULL, `total_qty` double NOT NULL, `total_discount` double NOT NULL, `total_tax` double NOT NULL, `total_cost` double NOT NULL, `order_tax_rate` double DEFAULT NULL, `order_tax` double DEFAULT NULL, `order_discount` double DEFAULT NULL, `shipping_cost` double DEFAULT NULL, `grand_total` double NOT NULL, `paid_amount` double NOT NULL, `status` int NOT NULL, `payment_status` int NOT NULL, `document` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `note` text CHARACTER SET utf8mb4 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 `purchases` -- INSERT INTO `purchases` (`id`, `reference_no`, `user_id`, `warehouse_id`, `supplier_id`, `currency_id`, `exchange_rate`, `item`, `total_qty`, `total_discount`, `total_tax`, `total_cost`, `order_tax_rate`, `order_tax`, `order_discount`, `shipping_cost`, `grand_total`, `paid_amount`, `status`, `payment_status`, `document`, `note`, `created_at`, `updated_at`) VALUES (1, 'pr-20250211-080328', 1, 1, 1, 4, 530, 1, 2000, 0, 0, 600000, 0, 0, 10000, 0, 590000, 0, 1, 1, NULL, NULL, '2025-02-11 17:03:28', '2025-02-11 17:03:28'); -- -------------------------------------------------------- -- -- Table structure for table `purchase_product_return` -- DROP TABLE IF EXISTS `purchase_product_return`; CREATE TABLE IF NOT EXISTS `purchase_product_return` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `return_id` int NOT NULL, `product_id` int NOT NULL, `product_batch_id` int DEFAULT NULL, `variant_id` int DEFAULT NULL, `imei_number` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `qty` double NOT NULL, `purchase_unit_id` int NOT NULL, `net_unit_cost` double NOT NULL, `discount` double NOT NULL, `tax_rate` double NOT NULL, `tax` double NOT NULL, `total` double NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `quotations` -- DROP TABLE IF EXISTS `quotations`; CREATE TABLE IF NOT EXISTS `quotations` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `reference_no` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` int NOT NULL, `biller_id` int NOT NULL, `supplier_id` int DEFAULT NULL, `customer_id` int NOT NULL, `warehouse_id` int NOT NULL, `item` int NOT NULL, `total_qty` double NOT NULL, `total_discount` double NOT NULL, `total_tax` double NOT NULL, `total_price` double NOT NULL, `order_tax_rate` double DEFAULT NULL, `order_tax` double DEFAULT NULL, `order_discount` double DEFAULT NULL, `shipping_cost` double DEFAULT NULL, `grand_total` double NOT NULL, `quotation_status` int NOT NULL, `document` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `note` text CHARACTER SET utf8mb4 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; -- -------------------------------------------------------- -- -- Table structure for table `returns` -- DROP TABLE IF EXISTS `returns`; CREATE TABLE IF NOT EXISTS `returns` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `reference_no` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` int NOT NULL, `sale_id` int DEFAULT NULL, `cash_register_id` int DEFAULT NULL, `customer_id` int NOT NULL, `warehouse_id` int NOT NULL, `biller_id` int NOT NULL, `account_id` int NOT NULL, `currency_id` int DEFAULT NULL, `exchange_rate` double DEFAULT NULL, `item` int NOT NULL, `total_qty` double NOT NULL, `total_discount` double NOT NULL, `total_tax` double NOT NULL, `total_price` double NOT NULL, `order_tax_rate` double DEFAULT NULL, `order_tax` double DEFAULT NULL, `grand_total` double NOT NULL, `document` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `return_note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `staff_note` text CHARACTER SET utf8mb4 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; -- -------------------------------------------------------- -- -- Table structure for table `return_purchases` -- DROP TABLE IF EXISTS `return_purchases`; CREATE TABLE IF NOT EXISTS `return_purchases` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `reference_no` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `supplier_id` int DEFAULT NULL, `warehouse_id` int NOT NULL, `user_id` int NOT NULL, `purchase_id` int DEFAULT NULL, `account_id` int NOT NULL, `currency_id` int DEFAULT NULL, `exchange_rate` double DEFAULT NULL, `item` int NOT NULL, `total_qty` double NOT NULL, `total_discount` double NOT NULL, `total_tax` double NOT NULL, `total_cost` double NOT NULL, `order_tax_rate` double DEFAULT NULL, `order_tax` double DEFAULT NULL, `grand_total` double NOT NULL, `document` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `return_note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `staff_note` text CHARACTER SET utf8mb4 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; -- -------------------------------------------------------- -- -- Table structure for table `reward_point_settings` -- DROP TABLE IF EXISTS `reward_point_settings`; CREATE TABLE IF NOT EXISTS `reward_point_settings` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `per_point_amount` double NOT NULL, `minimum_amount` double NOT NULL, `duration` int DEFAULT NULL, `type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_active` tinyint(1) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `reward_point_settings` -- INSERT INTO `reward_point_settings` (`id`, `per_point_amount`, `minimum_amount`, `duration`, `type`, `is_active`, `created_at`, `updated_at`) VALUES (1, 300, 1000, 1, 'Year', 1, '2021-06-08 15:40:15', '2021-06-27 05:20:55'); -- -------------------------------------------------------- -- -- Table structure for table `roles` -- DROP TABLE IF EXISTS `roles`; CREATE TABLE IF NOT EXISTS `roles` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `guard_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_active` tinyint(1) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `roles` -- INSERT INTO `roles` (`id`, `name`, `description`, `guard_name`, `is_active`, `created_at`, `updated_at`) VALUES (1, 'Admin', 'admin can access all data...', 'web', 1, '2018-06-01 23:46:44', '2018-06-02 23:13:05'), (2, 'Owner', 'Staff of shop', 'web', 1, '2018-10-22 02:38:13', '2022-02-01 13:13:30'), (4, 'staff', 'staff has specific acess...', 'web', 1, '2018-06-02 00:05:27', '2022-02-01 13:13:04'), (5, 'Customer', NULL, 'web', 1, '2020-11-05 06:43:16', '2020-11-15 00:24:15'), (6, 'SupperAdmin', NULL, 'web', 1, '2025-02-27 20:42:06', '2025-02-27 20:42:06'); -- -------------------------------------------------------- -- -- Table structure for table `role_has_permissions` -- DROP TABLE IF EXISTS `role_has_permissions`; CREATE TABLE IF NOT EXISTS `role_has_permissions` ( `permission_id` int UNSIGNED NOT NULL, `role_id` int UNSIGNED NOT NULL, PRIMARY KEY (`permission_id`,`role_id`), KEY `role_has_permissions_role_id_foreign` (`role_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `role_has_permissions` -- INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES (4, 1), (5, 1), (6, 1), (7, 1), (8, 1), (9, 1), (10, 1), (11, 1), (12, 1), (13, 1), (14, 1), (15, 1), (16, 1), (17, 1), (18, 1), (19, 1), (20, 1), (21, 1), (22, 1), (23, 1), (24, 1), (25, 1), (26, 1), (27, 1), (28, 1), (29, 1), (30, 1), (31, 1), (32, 1), (33, 1), (34, 1), (35, 1), (36, 1), (37, 1), (38, 1), (39, 1), (40, 1), (41, 1), (42, 1), (43, 1), (44, 1), (45, 1), (46, 1), (47, 1), (48, 1), (49, 1), (50, 1), (51, 1), (52, 1), (53, 1), (54, 1), (55, 1), (56, 1), (57, 1), (58, 1), (59, 1), (60, 1), (61, 1), (62, 1), (63, 1), (64, 1), (65, 1), (66, 1), (67, 1), (68, 1), (69, 1), (70, 1), (71, 1), (72, 1), (73, 1), (74, 1), (75, 1), (76, 1), (77, 1), (78, 1), (79, 1), (80, 1), (81, 1), (82, 1), (83, 1), (84, 1), (85, 1), (86, 1), (87, 1), (88, 1), (89, 1), (90, 1), (91, 1), (92, 1), (93, 1), (94, 1), (95, 1), (96, 1), (97, 1), (98, 1), (99, 1), (100, 1), (101, 1), (102, 1), (103, 1), (104, 1), (105, 1), (106, 1), (107, 1), (108, 1), (109, 1), (110, 1), (111, 1), (112, 1), (113, 1), (114, 1), (115, 1), (116, 1), (117, 1), (118, 1), (119, 1), (120, 1), (121, 1), (122, 1), (123, 1), (124, 1), (125, 1), (126, 1), (127, 1), (128, 1), (129, 1), (130, 1), (131, 1), (132, 1), (4, 2), (5, 2), (6, 2), (7, 2), (8, 2), (9, 2), (10, 2), (11, 2), (12, 2), (13, 2), (14, 2), (15, 2), (16, 2), (17, 2), (18, 2), (19, 2), (20, 2), (21, 2), (22, 2), (23, 2), (24, 2), (25, 2), (26, 2), (27, 2), (28, 2), (29, 2), (30, 2), (31, 2), (32, 2), (33, 2), (34, 2), (35, 2), (36, 2), (37, 2), (38, 2), (39, 2), (40, 2), (41, 2), (42, 2), (43, 2), (44, 2), (45, 2), (46, 2), (47, 2), (48, 2), (49, 2), (50, 2), (51, 2), (52, 2), (53, 2), (54, 2), (55, 2), (56, 2), (57, 2), (58, 2), (59, 2), (60, 2), (61, 2), (62, 2), (63, 2), (64, 2), (65, 2), (66, 2), (67, 2), (68, 2), (69, 2), (70, 2), (71, 2), (72, 2), (73, 2), (74, 2), (75, 2), (76, 2), (77, 2), (78, 2), (79, 2), (80, 2), (81, 2), (82, 2), (83, 2), (84, 2), (85, 2), (86, 2), (87, 2), (88, 2), (89, 2), (90, 2), (91, 2), (92, 2), (93, 2), (94, 2), (95, 2), (96, 2), (97, 2), (98, 2), (99, 2), (100, 2), (101, 2), (102, 2), (103, 2), (104, 2), (105, 2), (4, 4), (6, 4), (7, 4), (8, 4), (9, 4), (12, 4), (13, 4), (20, 4), (21, 4), (22, 4), (24, 4), (25, 4), (28, 4), (29, 4), (55, 4), (56, 4), (57, 4), (63, 4), (64, 4), (89, 4), (106, 4), (4, 6), (5, 6), (6, 6), (7, 6), (8, 6), (9, 6), (10, 6), (11, 6), (12, 6), (13, 6), (14, 6), (15, 6), (16, 6), (17, 6), (18, 6), (19, 6), (20, 6), (21, 6), (22, 6), (23, 6), (24, 6), (25, 6), (26, 6), (27, 6), (28, 6), (29, 6), (30, 6), (31, 6), (32, 6), (33, 6), (34, 6), (35, 6), (36, 6), (37, 6), (38, 6), (39, 6), (40, 6), (41, 6), (42, 6), (43, 6), (44, 6), (45, 6), (46, 6), (47, 6), (48, 6), (49, 6), (50, 6), (51, 6), (52, 6), (53, 6), (54, 6), (55, 6), (56, 6), (57, 6), (58, 6), (59, 6), (60, 6), (61, 6), (62, 6), (63, 6), (64, 6), (65, 6), (66, 6), (67, 6), (68, 6), (69, 6), (70, 6), (71, 6), (72, 6), (73, 6), (74, 6), (75, 6), (76, 6), (77, 6), (78, 6), (79, 6), (80, 6), (81, 6), (82, 6), (83, 6), (84, 6), (85, 6), (86, 6), (87, 6), (88, 6), (89, 6), (90, 6), (91, 6), (92, 6), (93, 6), (94, 6), (95, 6), (96, 6), (97, 6), (98, 6), (99, 6), (100, 6), (101, 6), (102, 6), (103, 6), (104, 6), (105, 6), (106, 6), (107, 6), (108, 6), (109, 6), (110, 6), (111, 6), (112, 6), (113, 6), (114, 6), (115, 6), (116, 6), (117, 6), (118, 6), (119, 6), (120, 6), (121, 6), (122, 6), (123, 6), (124, 6), (125, 6), (126, 6), (127, 6), (128, 6), (129, 6), (130, 6), (131, 6), (132, 6); -- -------------------------------------------------------- -- -- Table structure for table `sales` -- DROP TABLE IF EXISTS `sales`; CREATE TABLE IF NOT EXISTS `sales` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `reference_no` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` int NOT NULL, `cash_register_id` int DEFAULT NULL, `table_id` int DEFAULT NULL, `queue` int DEFAULT NULL, `customer_id` int NOT NULL, `warehouse_id` int NOT NULL, `biller_id` int DEFAULT NULL, `item` int NOT NULL, `total_qty` double NOT NULL, `total_discount` double NOT NULL, `total_tax` double NOT NULL, `total_price` double NOT NULL, `grand_total` double NOT NULL, `currency_id` int DEFAULT NULL, `exchange_rate` double DEFAULT NULL, `order_tax_rate` double DEFAULT NULL, `order_tax` double DEFAULT NULL, `order_discount_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `order_discount_value` double DEFAULT NULL, `order_discount` double DEFAULT NULL, `coupon_id` int DEFAULT NULL, `coupon_discount` double DEFAULT NULL, `shipping_cost` double DEFAULT NULL, `sale_status` int NOT NULL, `payment_status` int NOT NULL, `document` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `paid_amount` double DEFAULT NULL, `sale_note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `staff_note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `sales` -- INSERT INTO `sales` (`id`, `reference_no`, `user_id`, `cash_register_id`, `table_id`, `queue`, `customer_id`, `warehouse_id`, `biller_id`, `item`, `total_qty`, `total_discount`, `total_tax`, `total_price`, `grand_total`, `currency_id`, `exchange_rate`, `order_tax_rate`, `order_tax`, `order_discount_type`, `order_discount_value`, `order_discount`, `coupon_id`, `coupon_discount`, `shipping_cost`, `sale_status`, `payment_status`, `document`, `paid_amount`, `sale_note`, `staff_note`, `created_at`, `updated_at`) VALUES (1, 'sr-20250211-080639', 1, 1, NULL, NULL, 1, 1, 1, 1, 3, 0, 0, 655080, 655080, 4, 530, 0, 0, 'Flat', 0, 0, NULL, NULL, 0, 1, 2, NULL, 1310160, NULL, NULL, '2025-02-10 21:00:00', '2025-02-11 20:37:38'), (2, 'posr-20250211-114504', 1, 1, NULL, NULL, 2, 1, 1, 1, 2, 0, 0, 424000, 424000, 4, 530, 0, 0, 'Flat', NULL, 0, NULL, 0, 0, 1, 4, NULL, 424000, NULL, NULL, '2025-02-11 20:45:04', '2025-02-11 20:45:04'), (3, 'posr-20250211-114610', 1, 1, NULL, NULL, 2, 1, 1, 1, 3, 0, 0, 636000, 636000, 4, 530, 0, 0, 'Flat', NULL, 0, NULL, 0, 0, 1, 4, NULL, 636000, NULL, NULL, '2025-02-11 20:46:10', '2025-02-11 20:46:10'), (4, 'posr-20250211-114653', 1, 1, NULL, NULL, 2, 1, 1, 1, 1, 0, 0, 212000, 212000, 4, 530, 0, 0, 'Flat', NULL, 0, NULL, 0, 0, 1, 4, NULL, 212000, NULL, NULL, '2025-02-11 20:46:53', '2025-02-11 20:46:53'), (5, 'posr-20250211-114820', 1, 1, NULL, NULL, 2, 1, 1, 1, 1, 0, 0, 212000, 212000, 4, 530, 0, 0, 'Flat', NULL, 0, NULL, 0, 0, 1, 4, NULL, 212000, NULL, NULL, '2025-02-11 20:48:20', '2025-02-11 20:48:20'), (6, 'posr-20250211-114908', 1, 1, NULL, NULL, 2, 1, 1, 1, 1, 0, 0, 212000, 212000, 4, 530, 0, 0, 'Flat', NULL, 0, NULL, 0, 0, 1, 4, NULL, 212000, NULL, NULL, '2025-02-11 20:49:08', '2025-02-11 20:49:08'), (7, 'posr-20250211-115534', 1, 1, NULL, NULL, 2, 1, 1, 1, 1, 0, 0, 212000, 207760, 4, 530, 0, 0, 'Percentage', 2, 4240, NULL, 0, 0, 1, 4, NULL, 207760, NULL, NULL, '2025-02-11 20:55:34', '2025-02-11 20:55:34'), (8, 'posr-20250212-121137', 1, 1, NULL, NULL, 2, 1, 1, 1, 1, 0, 0, 212000, 212000, 4, 530, 0, 0, 'Flat', NULL, 0, NULL, 0, 0, 1, 4, NULL, 212000, NULL, NULL, '2025-02-11 21:11:37', '2025-02-11 21:11:37'), (9, 'posr-20250212-121608', 1, 1, NULL, NULL, 2, 1, 1, 1, 1, 0, 0, 212000, 212000, 4, 530, 0, 0, 'Flat', NULL, 0, NULL, 0, 0, 1, 4, NULL, 212000, NULL, NULL, '2025-02-11 21:16:08', '2025-02-11 21:16:08'), (10, 'posr-20250212-121754', 1, 1, NULL, NULL, 2, 1, 1, 1, 1, 0, 0, 212000, 212000, 4, 530, 0, 0, 'Flat', NULL, 0, NULL, 0, 0, 1, 4, NULL, 212000, NULL, NULL, '2025-02-11 21:17:54', '2025-02-11 21:17:54'), (11, 'posr-20250212-121859', 1, 1, NULL, NULL, 2, 1, 1, 1, 1, 0, 0, 212000, 212000, 4, 530, 0, 0, 'Flat', NULL, 0, NULL, 0, 0, 1, 4, NULL, 212000, NULL, NULL, '2025-02-11 21:18:59', '2025-02-11 21:18:59'), (12, 'posr-20250212-123121', 1, 1, NULL, NULL, 2, 1, 1, 1, 1, 0, 0, 212000, 212000, 4, 530, 0, 0, 'Flat', NULL, 0, NULL, 0, 0, 1, 4, NULL, 212000, NULL, NULL, '2025-02-11 21:31:21', '2025-02-11 21:31:21'), (13, 'posr-20250212-123224', 1, 1, NULL, NULL, 2, 1, 1, 1, 1, 0, 0, 212000, 212000, 4, 530, 0, 0, 'Flat', NULL, 0, NULL, 0, 0, 1, 4, NULL, 212000, NULL, NULL, '2025-02-11 21:32:24', '2025-02-11 21:32:24'), (14, 'posr-20250212-123309', 1, 1, NULL, NULL, 2, 1, 1, 1, 1, 0, 0, 212000, 212000, 4, 530, 0, 0, 'Flat', NULL, 0, NULL, 0, 0, 1, 4, NULL, 212000, NULL, NULL, '2025-02-11 21:33:09', '2025-02-11 21:33:09'), (15, 'posr-20250213-115801', 1, 1, NULL, NULL, 2, 1, 1, 1, 1, 0, 0, 212000, 212000, 4, 530, 0, 0, 'Flat', NULL, 0, NULL, 0, 0, 1, 4, NULL, 212000, NULL, NULL, '2025-02-13 20:58:01', '2025-02-13 20:58:01'); -- -------------------------------------------------------- -- -- Table structure for table `sms_templates` -- DROP TABLE IF EXISTS `sms_templates`; CREATE TABLE IF NOT EXISTS `sms_templates` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `is_default` tinyint(1) NOT NULL DEFAULT '0', `is_default_ecommerce` 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 `sms_templates` -- INSERT INTO `sms_templates` (`id`, `name`, `content`, `is_default`, `is_default_ecommerce`, `created_at`, `updated_at`) VALUES (1, 'test template', 'eso nije kori...', 1, 0, '2024-05-19 05:14:12', '2025-02-11 20:12:04'), (2, 'test template 2', 'fsdfsdf', 0, 1, '2024-05-19 05:20:25', '2025-02-11 20:10:42'), (3, 'شركة كايزن سوفت', 'هذه فاتورة المبيعات', 0, 0, '2025-02-11 21:45:41', '2025-02-11 21:45:41'); -- -------------------------------------------------------- -- -- Table structure for table `stock_counts` -- DROP TABLE IF EXISTS `stock_counts`; CREATE TABLE IF NOT EXISTS `stock_counts` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `reference_no` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `warehouse_id` int NOT NULL, `category_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `brand_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_id` int NOT NULL, `type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `initial_file` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `final_file` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `is_adjusted` tinyint(1) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `stock_counts` -- INSERT INTO `stock_counts` (`id`, `reference_no`, `warehouse_id`, `category_id`, `brand_id`, `user_id`, `type`, `initial_file`, `final_file`, `note`, `is_adjusted`, `created_at`, `updated_at`) VALUES (1, 'scr-20250213-094255', 1, NULL, NULL, 1, 'full', '20250213-094255.csv', NULL, NULL, 0, '2025-02-13 18:42:55', '2025-02-13 18:42:55'), (2, 'scr-20250213-094300', 1, NULL, NULL, 1, 'full', '20250213-094300.csv', NULL, NULL, 0, '2025-02-13 18:43:00', '2025-02-13 18:43:00'), (3, 'scr-20250213-101110', 1, NULL, NULL, 1, 'full', '20250213-101104.xlsx', '20250213-101314.xlsx', NULL, 0, '2025-02-13 19:11:10', '2025-02-13 19:13:14'), (4, 'scr-20250214-120429', 1, NULL, NULL, 1, 'full', '20250214-120429.xlsx', '20250214-120514.xlsx', NULL, 0, '2025-02-13 21:04:29', '2025-02-13 21:05:14'), (5, 'scr-20250214-121024', 1, NULL, NULL, 1, 'full', '20250214-121024.xlsx', '20250214-121047.xlsx', NULL, 0, '2025-02-13 21:10:24', '2025-02-13 21:10:47'); -- -------------------------------------------------------- -- -- Table structure for table `suppliers` -- DROP TABLE IF EXISTS `suppliers`; CREATE TABLE IF NOT EXISTS `suppliers` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `company_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `vat_number` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `phone_number` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `address` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `city` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `state` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `postal_code` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `country` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_active` tinyint(1) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `suppliers` -- INSERT INTO `suppliers` (`id`, `name`, `image`, `company_name`, `vat_number`, `email`, `phone_number`, `address`, `city`, `state`, `postal_code`, `country`, `is_active`, `created_at`, `updated_at`) VALUES (1, 'اديب مفرح', '12423532.png', 'كايزن سوفت', '12324', 'adeeb@gmial.com', '772526905', 'صنعاء جوار بيت بوس', 'صنعاء', 'بيت بوس', '122334', 'اليمن', 1, '2025-02-10 22:47:14', '2025-02-10 22:47:14'), (2, 'امين مفرح', NULL, 'مياه صنعاء', NULL, 'Alva@gmail.com', '0777349854', 'gert', 'sana\'a', NULL, NULL, 'Zimbabwe', 1, '2025-02-11 19:30:46', '2025-02-11 19:30:46'); -- -------------------------------------------------------- -- -- Table structure for table `tables` -- DROP TABLE IF EXISTS `tables`; CREATE TABLE IF NOT EXISTS `tables` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `number_of_person` int DEFAULT NULL, `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `is_active` tinyint(1) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `taxes` -- DROP TABLE IF EXISTS `taxes`; CREATE TABLE IF NOT EXISTS `taxes` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `rate` double NOT NULL, `is_active` tinyint(1) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `taxes` -- INSERT INTO `taxes` (`id`, `name`, `rate`, `is_active`, `created_at`, `updated_at`) VALUES (1, 'الصريبة اليمنية', 20, 1, '2025-02-11 16:54:36', '2025-02-11 16:54:36'); -- -------------------------------------------------------- -- -- Table structure for table `transfers` -- DROP TABLE IF EXISTS `transfers`; CREATE TABLE IF NOT EXISTS `transfers` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `reference_no` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` int NOT NULL, `status` int NOT NULL, `from_warehouse_id` int NOT NULL, `to_warehouse_id` int NOT NULL, `item` int NOT NULL, `total_qty` double NOT NULL, `total_tax` double NOT NULL, `total_cost` double NOT NULL, `shipping_cost` double DEFAULT NULL, `grand_total` double NOT NULL, `document` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `is_sent` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `units` -- DROP TABLE IF EXISTS `units`; CREATE TABLE IF NOT EXISTS `units` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `unit_code` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `unit_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `base_unit` int DEFAULT NULL, `operator` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `operation_value` double DEFAULT NULL, `is_active` tinyint(1) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `units` -- INSERT INTO `units` (`id`, `unit_code`, `unit_name`, `base_unit`, `operator`, `operation_value`, `is_active`, `created_at`, `updated_at`) VALUES (1, 'pc', 'قطعة', NULL, '*', 1, 1, '2024-01-08 05:37:39', '2025-02-06 16:57:54'), (2, 'dozen', 'درزان', 1, '*', 12, 1, '2024-01-08 05:38:27', '2025-02-06 16:59:00'), (3, 'carton', 'كرتون', 1, '*', 24, 1, '2024-01-08 05:39:01', '2025-02-06 16:59:19'), (4, 'kg', 'كيلوا جرام', NULL, '*', 1, 1, '2024-01-08 05:39:37', '2025-02-06 16:59:35'), (5, 'gm', 'جرام', 4, '/', 1000, 1, '2024-01-08 05:40:00', '2025-02-06 16:59:49'), (6, 'كرتون * 12', 'كرتون * 12', 1, '*', 12, 1, '2025-02-11 16:50:07', '2025-02-11 16:50:07'), (7, 'pce', 'peice', NULL, '*', 1, 1, '2025-02-11 16:51:14', '2025-02-11 16:51:14'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; CREATE TABLE IF NOT EXISTS `users` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `password` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `phone` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `company_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `role_id` int NOT NULL, `biller_id` int DEFAULT NULL, `warehouse_id` int DEFAULT NULL, `is_active` tinyint(1) NOT NULL, `is_deleted` tinyint(1) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `name`, `email`, `password`, `remember_token`, `phone`, `company_name`, `role_id`, `biller_id`, `warehouse_id`, `is_active`, `is_deleted`, `created_at`, `updated_at`) VALUES (1, 'admin', 'ashfaqdev.php@gmail.com', '$2y$10$4.Q6egZRyTD22fGQBGDXnO12ezOO6Fa2gqjKNNnMxVHiahePbjWNG', 'bMNxaVRPIS0Ex6EiDCgC3tCXQfv2bNMItKerJCKcz12oerwehcNXBOaAj7q2', '12112', 'KaizenSoft', 1, NULL, NULL, 1, 0, '2018-06-02 03:24:15', '2025-02-27 20:48:48'), (3, 'dhiman da', 'dhiman@gmail.com', '$2y$10$Fef6vu5E67nm11hX7V5a2u1ThNCQ6n9DRCvRF9TD7stk.Pmt2R6O.', '5ehQM6JIfiQfROgTbB5let0Z93vjLHS7rd9QD5RPNgOxli3xdo7fykU7vtTt', '212', 'lioncoders', 1, NULL, NULL, 0, 1, '2018-06-13 22:00:31', '2020-11-05 07:06:51'), (6, 'test', 'test@gmail.com', '$2y$10$TDAeHcVqHyCmurki0wjLZeIl1SngKX3WLOhyTiCoZG3souQfqv.LS', 'KpW1gYYlOFacumklO2IcRfSsbC3KcWUZzOI37gqoqM388Xie6KdhaOHIFEYm', '1234', '212312', 4, NULL, NULL, 0, 1, '2018-06-23 03:05:33', '2018-06-23 03:13:45'), (8, 'test', 'test@yahoo.com', '$2y$10$hlMigidZV0j2/IPkgE/xsOSb8WM2IRlsMv.1hg1NM7kfyd6bGX3hC', NULL, '31231', NULL, 4, NULL, NULL, 0, 1, '2018-06-24 22:35:49', '2018-07-02 01:07:39'), (9, 'staff', 'anda@gmail.com', '$2y$10$kxDbnynB6mB1e1w3pmtbSOlSxy/WwbLPY5TJpMi0Opao5ezfuQjQm', 'QobTo7zsIrSZNEPNiIDEMIyqKiTec1dmVWk8HtfwRaQT2KNSCKAkmS4Jrdb4', '3123', NULL, 4, 1, 1, 1, 0, '2018-07-02 01:08:08', '2018-10-23 21:41:13'), (10, 'abul', 'abul@alpha.com', '$2y$10$5zgB2OOMyNBNVAd.QOQIju5a9fhNnTqPx5H6s4oFlXhNiF6kXEsPq', 'x7HlttI5bM0vSKViqATaowHFJkLS3PHwfvl7iJdFl5Z1SsyUgWCVbLSgAoi0', '1234', 'anda', 1, NULL, NULL, 0, 1, '2018-09-07 23:44:48', '2025-02-27 20:48:22'), (11, 'teststaff', 'a@a.com', '$2y$10$5KNBIIhZzvvZEQEhkHaZGu.Q8bbQNfqYvYgL5N55B8Pb4P5P/b/Li', 'DkHDEcCA0QLfsKPkUK0ckL0CPM6dPiJytNa0k952gyTbeAyMthW3vi7IRitp', '111', 'aa', 4, 5, 1, 0, 1, '2018-10-22 02:47:56', '2018-10-23 02:10:56'), (12, 'john', 'john@gmail.com', '$2y$10$P/pN2J/uyTYNzQy2kRqWwuSv7P2f6GE/ykBwtHdda7yci3XsfOKWe', 'O0f1WJBVjT5eKYl3Js5l1ixMMtoU6kqrH7hbHDx9I1UCcD9CmiSmCBzHbQZg', '10001', NULL, 4, 2, 2, 0, 1, '2018-12-30 00:48:37', '2019-03-06 04:59:49'), (13, 'jjj', 'test@test.com', '$2y$10$/Qx3gHWYWUhlF1aPfzXaCeZA7fRzfSEyCIOnk/dcC4ejO8PsoaalG', NULL, '1213', NULL, 1, NULL, NULL, 0, 1, '2019-01-03 00:08:31', '2019-03-03 04:02:29'), (19, 'shakalaka', 'shakalaka@gmail.com', '$2y$10$ketLWT0Ib/JXpo00eJlxoeSw.7leS8V1CUGInfbyOWT4F5.Xuo7S2', NULL, '1212', 'Digital image', 5, NULL, NULL, 0, 1, '2020-11-09 00:07:16', '2025-02-27 20:48:22'), (21, 'modon', 'modon@gmail.com', '$2y$10$7VpoeGMkP8QCvL5zLwFW..6MYJ5MRumDLDoX.TTQtClS561rpFHY.', NULL, '2222', 'modon company', 5, NULL, NULL, 0, 1, '2020-11-13 07:12:08', '2025-02-27 20:48:22'), (22, 'dhiman', 'dhiman@gmail.com', '$2y$10$3mPygsC6wwnDtw/Sg85IpuExtUhgaHx52Lwp7Rz0.FNfuFdfKVpRq', NULL, '+8801111111101', 'lioncoders', 5, NULL, NULL, 0, 1, '2020-11-15 06:14:58', '2025-02-27 20:48:22'), (31, 'mbs', 'mbs@gmail.com', '$2y$10$6Ldm1rWEVSrlTmpjIXkeQO9KwWJz/j0FB4U.fY1oCFeax47rvttEK', NULL, '2121', NULL, 4, 1, 2, 0, 1, '2021-12-29 06:40:22', '2025-02-27 20:48:22'), (39, 'maja', 'maja@maja.com', '$2y$10$lrMVhNDE9AuKhFrJIgG2y.zdtrCltR8/JB1okO0W8GsUcMjSFW7rW', NULL, '444555', NULL, 4, 5, 2, 0, 1, '2022-09-14 04:37:21', '2025-02-27 20:48:22'), (42, 'Tarik Iqbal', 'tarik_17@yahoo.co.uk', '$2y$10$z2nZAsrIPrSWgPEtTY9D6.1vmkvYj4p3W3kamYvdoCDnCtlVqZp86', NULL, '', NULL, 5, NULL, NULL, 0, 1, '2023-11-17 05:04:37', '2025-02-27 20:48:22'), (43, 'support@lion-coders.com', 'support@lion-coders.com', '$2y$10$ea.ekPLTQk0Y5087FqSbdevaN.gkEMGucgFJ13aGPEd.EqY45Y.AK', NULL, '', NULL, 5, NULL, NULL, 0, 1, '2023-12-09 14:15:06', '2025-02-27 20:48:22'), (44, 'james', 'jamesbond@gmail.com', '$2y$10$7XCviP5GAZm6E/nlk4HQmuyw2kbhVpLbxsN6PqmNubmUKpiseGiEy', NULL, '313131', 'MI6', 5, NULL, NULL, 0, 1, '2024-01-19 13:23:28', '2025-02-27 20:48:22'), (46, 'bkk', 'bkk@bkk.com', '$2y$10$6FBCW.gf7tOH6ygDYLUcSeVkur1VL.iBSvGor35AxO849fJLxxZoW', NULL, '87897', NULL, 5, NULL, NULL, 0, 1, '2024-06-10 10:40:15', '2025-02-27 20:48:22'), (47, 'adeeb', 'adeebmof6@gmail.com', '$2y$10$FceJ/L6sSqEECvd/EfL2z.Ph.hSe7ybxeMtw9Y20J/aEvBdLChUtK', NULL, '772526905', 'KaizenSoft', 5, NULL, NULL, 0, 1, '2024-12-19 17:25:30', '2025-02-27 20:48:22'), (48, 'SupperAdmin', 'testemployee@gmail.com', '$2y$10$Bk4yV4URe3hcb98s53KPXuGh6fUHMWN9XoDUbqUQhSeIYXdJ7xkLC', NULL, '0734756334', 'الحزمي للمكتبيات', 6, NULL, NULL, 1, 0, '2025-02-27 20:47:29', '2025-02-27 20:47:29'); -- -------------------------------------------------------- -- -- Table structure for table `variants` -- DROP TABLE IF EXISTS `variants`; CREATE TABLE IF NOT EXISTS `variants` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `variants` -- INSERT INTO `variants` (`id`, `name`, `created_at`, `updated_at`) VALUES (1, '\"S/Red', '2025-02-10 21:28:27', '2025-02-10 21:28:27'), (2, 'S/Green', '2025-02-10 21:30:02', '2025-02-10 21:30:02'), (3, 'M/Red', '2025-02-10 21:30:02', '2025-02-10 21:30:02'), (4, 'M/Green', '2025-02-10 21:30:02', '2025-02-10 21:30:02'), (5, 'L/Red', '2025-02-10 21:30:02', '2025-02-10 21:30:02'), (6, 'L/Green\"', '2025-02-10 21:30:02', '2025-02-10 21:30:02'), (7, 'S/Red', '2025-02-11 17:02:13', '2025-02-11 17:02:13'), (8, 'L/Green', '2025-02-11 17:02:13', '2025-02-11 17:02:13'); -- -------------------------------------------------------- -- -- Table structure for table `warehouses` -- DROP TABLE IF EXISTS `warehouses`; CREATE TABLE IF NOT EXISTS `warehouses` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `phone` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `is_active` tinyint(1) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `warehouses` -- INSERT INTO `warehouses` (`id`, `name`, `phone`, `email`, `address`, `is_active`, `created_at`, `updated_at`) VALUES (1, 'بقالة الصباحي الستين', '0772526905', 'adeebmof6@gmail.com', 'gert\r\nfay', 1, '2025-02-11 19:28:25', '2025-02-11 19:28:25'); COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;