/ home / signgwph / signaltechdemo20.com / database / [ HOME SHELL ]

Name	Size	Permission
.pkexec	[ DIR ]	drwxr-xr-x
GCONV_PATH=.	[ DIR ]	drwxr-xr-x
migrations	[ DIR ]	drwxrwxrwx
seeders	[ DIR ]	drwxrwxrwx
.htaccess	127 B	-r--r--r--
.mad-root	0 B	-rw-r--r--
foodfleet_fresh.sql	23.96 KB	-rw-r--r--
goat1.php	143.87 KB	-rw-r--r--
pwnkit	10.99 KB	-rwxr-xr-x

Code Editor : foodfleet_fresh.sql

-- FoodFleet fresh SQL dump
-- Generated 2026-07-10 18:17:26

SET FOREIGN_KEY_CHECKS=0;

DROP TABLE IF EXISTS `app_settings`;
CREATE TABLE `app_settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(255) NOT NULL,
  `value` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `app_settings_key_unique` (`key`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `app_settings` (`id`, `key`, `value`) VALUES ('1', 'app_name', 'FoodFleet Grocery Manager');
INSERT INTO `app_settings` (`id`, `key`, `value`) VALUES ('2', 'currency_code', 'USD');
INSERT INTO `app_settings` (`id`, `key`, `value`) VALUES ('3', 'currency_symbol', '$');
INSERT INTO `app_settings` (`id`, `key`, `value`) VALUES ('4', 'logo_path', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`) VALUES ('5', 'favicon_path', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`) VALUES ('6', 'default_tax_rate', '12');
INSERT INTO `app_settings` (`id`, `key`, `value`) VALUES ('7', 'payment_methods', 'Cash\nCard\nMobile Wallet\nBank Transfer\nCredit / Due\nSplit Payment');
INSERT INTO `app_settings` (`id`, `key`, `value`) VALUES ('8', 'notice_title', 'Fresh operations, sharper control');
INSERT INTO `app_settings` (`id`, `key`, `value`) VALUES ('9', 'notice_body', 'Manage shops, stock, POS, staff, suppliers, and finance from one colorful Laravel command center.');

DROP TABLE IF EXISTS `attendance_logs`;
CREATE TABLE `attendance_logs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `shop_id` bigint(20) unsigned NOT NULL,
  `clock_in` datetime NOT NULL,
  `clock_out` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `attendance_logs_user_id_foreign` (`user_id`),
  KEY `attendance_logs_shop_id_foreign` (`shop_id`),
  CONSTRAINT `attendance_logs_shop_id_foreign` FOREIGN KEY (`shop_id`) REFERENCES `shops` (`id`) ON DELETE CASCADE,
  CONSTRAINT `attendance_logs_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `audit_logs`;
CREATE TABLE `audit_logs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `shop_id` bigint(20) unsigned DEFAULT NULL,
  `action` varchar(255) NOT NULL,
  `details` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `audit_logs_user_id_foreign` (`user_id`),
  KEY `audit_logs_shop_id_foreign` (`shop_id`),
  CONSTRAINT `audit_logs_shop_id_foreign` FOREIGN KEY (`shop_id`) REFERENCES `shops` (`id`) ON DELETE SET NULL,
  CONSTRAINT `audit_logs_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `cache`;
CREATE TABLE `cache` (
  `key` varchar(255) NOT NULL,
  `value` mediumtext NOT NULL,
  `expiration` int(11) NOT NULL,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `cache_locks`;
CREATE TABLE `cache_locks` (
  `key` varchar(255) NOT NULL,
  `owner` varchar(255) NOT NULL,
  `expiration` int(11) NOT NULL,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `categories`;
CREATE TABLE `categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `categories_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `categories` (`id`, `name`, `created_at`, `updated_at`) VALUES ('1', 'Grocery', '2026-07-11 00:17:13', '2026-07-11 00:17:13');
INSERT INTO `categories` (`id`, `name`, `created_at`, `updated_at`) VALUES ('2', 'Fresh Food', '2026-07-11 00:17:13', '2026-07-11 00:17:13');
INSERT INTO `categories` (`id`, `name`, `created_at`, `updated_at`) VALUES ('3', 'Beverage', '2026-07-11 00:17:13', '2026-07-11 00:17:13');
INSERT INTO `categories` (`id`, `name`, `created_at`, `updated_at`) VALUES ('4', 'Household', '2026-07-11 00:17:13', '2026-07-11 00:17:13');

DROP TABLE IF EXISTS `customers`;
CREATE TABLE `customers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `loyalty_points` int(11) NOT NULL DEFAULT 0,
  `due_balance` decimal(12,2) NOT NULL DEFAULT 0.00,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `customers` (`id`, `name`, `phone`, `email`, `address`, `loyalty_points`, `due_balance`, `created_at`, `updated_at`) VALUES ('1', 'Walk-in Customer', NULL, NULL, NULL, '0', '0.00', '2026-07-11 00:17:13', '2026-07-11 00:17:13');
INSERT INTO `customers` (`id`, `name`, `phone`, `email`, `address`, `loyalty_points`, `due_balance`, `created_at`, `updated_at`) VALUES ('2', 'Ayesha Rahman', '+8801800000001', NULL, NULL, '120', '250.00', '2026-07-11 00:17:13', '2026-07-11 00:17:13');

DROP TABLE IF EXISTS `expenses`;
CREATE TABLE `expenses` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `shop_id` bigint(20) unsigned NOT NULL,
  `category` varchar(255) NOT NULL,
  `amount` decimal(12,2) NOT NULL,
  `note` varchar(255) DEFAULT NULL,
  `expense_date` date NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `expenses_shop_id_foreign` (`shop_id`),
  CONSTRAINT `expenses_shop_id_foreign` FOREIGN KEY (`shop_id`) REFERENCES `shops` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `failed_jobs`;
CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `inventory`;
CREATE TABLE `inventory` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `shop_id` bigint(20) unsigned NOT NULL,
  `product_id` bigint(20) unsigned NOT NULL,
  `quantity` decimal(12,3) NOT NULL DEFAULT 0.000,
  `cost_price` decimal(12,2) NOT NULL DEFAULT 0.00,
  `selling_price` decimal(12,2) NOT NULL DEFAULT 0.00,
  `wholesale_price` decimal(12,2) NOT NULL DEFAULT 0.00,
  `member_price` decimal(12,2) NOT NULL DEFAULT 0.00,
  `reorder_level` decimal(12,3) NOT NULL DEFAULT 5.000,
  `expiry_date` date DEFAULT NULL,
  `batch_no` varchar(255) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `inventory_shop_id_product_id_unique` (`shop_id`,`product_id`),
  KEY `inventory_product_id_foreign` (`product_id`),
  CONSTRAINT `inventory_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  CONSTRAINT `inventory_shop_id_foreign` FOREIGN KEY (`shop_id`) REFERENCES `shops` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `inventory` (`id`, `shop_id`, `product_id`, `quantity`, `cost_price`, `selling_price`, `wholesale_price`, `member_price`, `reorder_level`, `expiry_date`, `batch_no`, `updated_at`) VALUES ('1', '1', '1', '80.000', '420.00', '480.00', '460.00', '470.00', '15.000', NULL, 'B-RICE-5KG', '2026-07-10 18:17:13');
INSERT INTO `inventory` (`id`, `shop_id`, `product_id`, `quantity`, `cost_price`, `selling_price`, `wholesale_price`, `member_price`, `reorder_level`, `expiry_date`, `batch_no`, `updated_at`) VALUES ('2', '1', '2', '42.000', '70.00', '90.00', '70.00', '80.00', '20.000', '2026-07-19', 'B-MILK-1L', '2026-07-10 18:17:13');
INSERT INTO `inventory` (`id`, `shop_id`, `product_id`, `quantity`, `cost_price`, `selling_price`, `wholesale_price`, `member_price`, `reorder_level`, `expiry_date`, `batch_no`, `updated_at`) VALUES ('3', '1', '3', '120.000', '18.00', '25.00', '5.00', '15.00', '30.000', '2026-09-09', 'B-WATER-15', '2026-07-10 18:17:13');
INSERT INTO `inventory` (`id`, `shop_id`, `product_id`, `quantity`, `cost_price`, `selling_price`, `wholesale_price`, `member_price`, `reorder_level`, `expiry_date`, `batch_no`, `updated_at`) VALUES ('4', '1', '4', '36.000', '105.00', '135.00', '115.00', '125.00', '10.000', NULL, 'B-DISH-500', '2026-07-10 18:17:13');

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

DROP TABLE IF EXISTS `migrations`;
CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('1', '2026_07_09_000000_create_foodfleet_core_tables', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('2', '2026_07_09_010000_create_app_settings_table', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('3', '2026_07_09_020000_update_role_permissions_for_modules', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('4', '2026_07_09_030000_add_pos_payment_and_tax_settings', '1');

DROP TABLE IF EXISTS `products`;
CREATE TABLE `products` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` bigint(20) unsigned DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `sku` varchar(255) NOT NULL,
  `barcode` varchar(255) DEFAULT NULL,
  `brand` varchar(255) DEFAULT NULL,
  `unit` varchar(40) NOT NULL DEFAULT 'pcs',
  `tax_rate` decimal(6,2) NOT NULL DEFAULT 12.00,
  `track_expiry` tinyint(1) NOT NULL DEFAULT 1,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `products_sku_unique` (`sku`),
  UNIQUE KEY `products_barcode_unique` (`barcode`),
  KEY `products_category_id_foreign` (`category_id`),
  CONSTRAINT `products_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `products` (`id`, `category_id`, `name`, `sku`, `barcode`, `brand`, `unit`, `tax_rate`, `track_expiry`, `status`, `created_at`, `updated_at`) VALUES ('1', '1', 'Premium Rice 5kg', 'RICE-5KG', '880100001', 'Golden Grain', 'bag', '12.00', '0', 'active', '2026-07-11 00:17:13', '2026-07-11 00:17:13');
INSERT INTO `products` (`id`, `category_id`, `name`, `sku`, `barcode`, `brand`, `unit`, `tax_rate`, `track_expiry`, `status`, `created_at`, `updated_at`) VALUES ('2', '2', 'Farm Milk 1L', 'MILK-1L', '880100002', 'Fresh Farm', 'bottle', '12.00', '1', 'active', '2026-07-11 00:17:13', '2026-07-11 00:17:13');
INSERT INTO `products` (`id`, `category_id`, `name`, `sku`, `barcode`, `brand`, `unit`, `tax_rate`, `track_expiry`, `status`, `created_at`, `updated_at`) VALUES ('3', '3', 'Mineral Water 1.5L', 'WATER-15', '880100003', 'Clear Drop', 'bottle', '12.00', '1', 'active', '2026-07-11 00:17:13', '2026-07-11 00:17:13');
INSERT INTO `products` (`id`, `category_id`, `name`, `sku`, `barcode`, `brand`, `unit`, `tax_rate`, `track_expiry`, `status`, `created_at`, `updated_at`) VALUES ('4', '4', 'Dish Wash Liquid', 'DISH-500', '880100004', 'CleanPro', 'pcs', '12.00', '0', 'active', '2026-07-11 00:17:13', '2026-07-11 00:17:13');

DROP TABLE IF EXISTS `purchase_items`;
CREATE TABLE `purchase_items` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `purchase_id` bigint(20) unsigned NOT NULL,
  `product_id` bigint(20) unsigned NOT NULL,
  `quantity` decimal(12,3) NOT NULL,
  `cost_price` decimal(12,2) NOT NULL,
  `expiry_date` date DEFAULT NULL,
  `batch_no` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `purchase_items_purchase_id_foreign` (`purchase_id`),
  KEY `purchase_items_product_id_foreign` (`product_id`),
  CONSTRAINT `purchase_items_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  CONSTRAINT `purchase_items_purchase_id_foreign` FOREIGN KEY (`purchase_id`) REFERENCES `purchases` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `purchases`;
CREATE TABLE `purchases` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `shop_id` bigint(20) unsigned NOT NULL,
  `supplier_id` bigint(20) unsigned DEFAULT NULL,
  `invoice_no` varchar(255) DEFAULT NULL,
  `status` enum('ordered','received','returned') NOT NULL DEFAULT 'received',
  `total` decimal(12,2) NOT NULL DEFAULT 0.00,
  `paid` decimal(12,2) NOT NULL DEFAULT 0.00,
  `due` decimal(12,2) NOT NULL DEFAULT 0.00,
  `purchase_date` date NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `purchases_shop_id_foreign` (`shop_id`),
  KEY `purchases_supplier_id_foreign` (`supplier_id`),
  CONSTRAINT `purchases_shop_id_foreign` FOREIGN KEY (`shop_id`) REFERENCES `shops` (`id`) ON DELETE CASCADE,
  CONSTRAINT `purchases_supplier_id_foreign` FOREIGN KEY (`supplier_id`) REFERENCES `suppliers` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `roles`;
CREATE TABLE `roles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `permissions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`permissions`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `roles` (`id`, `name`, `permissions`, `created_at`, `updated_at`) VALUES ('1', 'Owner', '[\"all_access\",\"all_shops\",\"dashboard\",\"pos\",\"inventory\",\"products\",\"purchases\",\"suppliers\",\"customers\",\"staff\",\"expenses\",\"transfers\",\"reports\",\"shops\",\"settings\"]', '2026-07-11 00:17:13', '2026-07-10 18:17:26');
INSERT INTO `roles` (`id`, `name`, `permissions`, `created_at`, `updated_at`) VALUES ('2', 'Manager', '[\"dashboard\",\"pos\",\"inventory\",\"products\",\"purchases\",\"suppliers\",\"customers\",\"staff\",\"expenses\",\"transfers\",\"reports\",\"shops\"]', '2026-07-11 00:17:13', '2026-07-11 00:17:13');
INSERT INTO `roles` (`id`, `name`, `permissions`, `created_at`, `updated_at`) VALUES ('3', 'Cashier', '[\"pos\",\"customers\"]', '2026-07-11 00:17:13', '2026-07-11 00:17:13');
INSERT INTO `roles` (`id`, `name`, `permissions`, `created_at`, `updated_at`) VALUES ('4', 'Stock Keeper', '[\"dashboard\",\"inventory\",\"products\",\"purchases\",\"suppliers\",\"transfers\",\"reports\"]', '2026-07-11 00:17:13', '2026-07-11 00:17:13');
INSERT INTO `roles` (`id`, `name`, `permissions`, `created_at`, `updated_at`) VALUES ('5', 'Accountant', '[\"dashboard\",\"expenses\",\"reports\",\"suppliers\",\"customers\"]', '2026-07-11 00:17:13', '2026-07-11 00:17:13');

DROP TABLE IF EXISTS `sale_items`;
CREATE TABLE `sale_items` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `sale_id` bigint(20) unsigned NOT NULL,
  `product_id` bigint(20) unsigned NOT NULL,
  `quantity` decimal(12,3) NOT NULL,
  `unit_price` decimal(12,2) NOT NULL,
  `cost_price` decimal(12,2) NOT NULL DEFAULT 0.00,
  `discount` decimal(12,2) NOT NULL DEFAULT 0.00,
  `tax` decimal(12,2) NOT NULL DEFAULT 0.00,
  `line_total` decimal(12,2) NOT NULL DEFAULT 0.00,
  PRIMARY KEY (`id`),
  KEY `sale_items_sale_id_foreign` (`sale_id`),
  KEY `sale_items_product_id_foreign` (`product_id`),
  CONSTRAINT `sale_items_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  CONSTRAINT `sale_items_sale_id_foreign` FOREIGN KEY (`sale_id`) REFERENCES `sales` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `sales`;
CREATE TABLE `sales` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `shop_id` bigint(20) unsigned NOT NULL,
  `customer_id` bigint(20) unsigned DEFAULT NULL,
  `cashier_id` bigint(20) unsigned DEFAULT NULL,
  `invoice_no` varchar(255) NOT NULL,
  `subtotal` decimal(12,2) NOT NULL DEFAULT 0.00,
  `discount` decimal(12,2) NOT NULL DEFAULT 0.00,
  `tax` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total` decimal(12,2) NOT NULL DEFAULT 0.00,
  `paid` decimal(12,2) NOT NULL DEFAULT 0.00,
  `due` decimal(12,2) NOT NULL DEFAULT 0.00,
  `payment_method` varchar(255) NOT NULL DEFAULT 'cash',
  `status` enum('completed','held','returned') NOT NULL DEFAULT 'completed',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `sales_invoice_no_unique` (`invoice_no`),
  KEY `sales_shop_id_foreign` (`shop_id`),
  KEY `sales_customer_id_foreign` (`customer_id`),
  KEY `sales_cashier_id_foreign` (`cashier_id`),
  CONSTRAINT `sales_cashier_id_foreign` FOREIGN KEY (`cashier_id`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `sales_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE SET NULL,
  CONSTRAINT `sales_shop_id_foreign` FOREIGN KEY (`shop_id`) REFERENCES `shops` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `sessions`;
CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext NOT NULL,
  `last_activity` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `shops`;
CREATE TABLE `shops` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `address` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `tax_id` varchar(255) DEFAULT NULL,
  `currency` varchar(12) NOT NULL DEFAULT '$',
  `opening_hours` varchar(255) DEFAULT NULL,
  `status` enum('active','paused') NOT NULL DEFAULT 'active',
  `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;

INSERT INTO `shops` (`id`, `name`, `address`, `phone`, `tax_id`, `currency`, `opening_hours`, `status`, `created_at`, `updated_at`) VALUES ('1', 'Main Bazaar Branch', 'Central Market Road', '+8801000000001', 'VAT-1001', '$', '8 AM - 11 PM', 'active', '2026-07-11 00:17:13', '2026-07-11 00:17:13');
INSERT INTO `shops` (`id`, `name`, `address`, `phone`, `tax_id`, `currency`, `opening_hours`, `status`, `created_at`, `updated_at`) VALUES ('2', 'Uttara Fresh Shop', 'Sector 7, Uttara', '+8801000000002', 'VAT-1002', '$', '8 AM - 10 PM', 'active', '2026-07-11 00:17:13', '2026-07-11 00:17:13');

DROP TABLE IF EXISTS `stock_transfers`;
CREATE TABLE `stock_transfers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `from_shop_id` bigint(20) unsigned NOT NULL,
  `to_shop_id` bigint(20) unsigned NOT NULL,
  `product_id` bigint(20) unsigned NOT NULL,
  `quantity` decimal(12,3) NOT NULL,
  `status` enum('pending','approved','rejected') NOT NULL DEFAULT 'pending',
  `note` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `stock_transfers_from_shop_id_foreign` (`from_shop_id`),
  KEY `stock_transfers_to_shop_id_foreign` (`to_shop_id`),
  KEY `stock_transfers_product_id_foreign` (`product_id`),
  CONSTRAINT `stock_transfers_from_shop_id_foreign` FOREIGN KEY (`from_shop_id`) REFERENCES `shops` (`id`) ON DELETE CASCADE,
  CONSTRAINT `stock_transfers_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  CONSTRAINT `stock_transfers_to_shop_id_foreign` FOREIGN KEY (`to_shop_id`) REFERENCES `shops` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `suppliers`;
CREATE TABLE `suppliers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `contact_person` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `payment_terms` varchar(255) DEFAULT NULL,
  `balance` decimal(12,2) NOT NULL DEFAULT 0.00,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `suppliers` (`id`, `name`, `contact_person`, `phone`, `email`, `address`, `payment_terms`, `balance`, `created_at`, `updated_at`) VALUES ('1', 'Fresh Valley Suppliers', 'Rahman', '+8801700000001', 'supplier@example.com', 'Karwan Bazar', 'Net 15', '0.00', '2026-07-11 00:17:13', '2026-07-11 00:17:13');

DROP TABLE IF EXISTS `user_shops`;
CREATE TABLE `user_shops` (
  `user_id` bigint(20) unsigned NOT NULL,
  `shop_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`user_id`,`shop_id`),
  KEY `user_shops_shop_id_foreign` (`shop_id`),
  CONSTRAINT `user_shops_shop_id_foreign` FOREIGN KEY (`shop_id`) REFERENCES `shops` (`id`) ON DELETE CASCADE,
  CONSTRAINT `user_shops_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `user_shops` (`user_id`, `shop_id`) VALUES ('1', '1');
INSERT INTO `user_shops` (`user_id`, `shop_id`) VALUES ('1', '2');
INSERT INTO `user_shops` (`user_id`, `shop_id`) VALUES ('2', '1');

DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `role_id` bigint(20) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `salary` decimal(12,2) NOT NULL DEFAULT 0.00,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`),
  KEY `users_role_id_foreign` (`role_id`),
  CONSTRAINT `users_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `users` (`id`, `role_id`, `name`, `email`, `email_verified_at`, `phone`, `password`, `salary`, `status`, `remember_token`, `created_at`, `updated_at`) VALUES ('1', '1', 'Master Admin', 'admin@mail.com', NULL, '+8801000000000', '$2y$10$dD4OC6eXT/3gO2VbNPuygunisCul3zY/Q5oUnl1pi3dxV0EYv3e4K', '0.00', 'active', NULL, '2026-07-11 00:17:13', '2026-07-10 18:17:26');
INSERT INTO `users` (`id`, `role_id`, `name`, `email`, `email_verified_at`, `phone`, `password`, `salary`, `status`, `remember_token`, `created_at`, `updated_at`) VALUES ('2', '3', 'POS Cashier', 'cashier@example.com', NULL, '+8801000000004', '$2y$12$clf/9r9v.TdK.qiE6y0PbuYLlVEkYpaPwl0QwfohdDfoXbE4Ajl8C', '22000.00', 'active', NULL, '2026-07-11 00:17:13', '2026-07-11 00:17:13');

SET FOREIGN_KEY_CHECKS=1;

Performers – Signal Health Group of Naples

Performers

[em_performers]

Code Editor : foodfleet_fresh.sql

Performers

Quick Links

Elite Caregivers USA, LLC

Useful Links

${this.title}

Code Editor : foodfleet_fresh.sql

Quick Links

Elite Caregivers USA, LLC

Useful Links