--
-- Host: localhost    Database: gposarytech_pos
-- ------------------------------------------------------


--
-- Current Database: `gposarytech_pos`
--


--
-- Table structure for table `ns_failed_jobs`
--

CREATE TABLE `ns_failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_failed_jobs`
--


--
-- Table structure for table `ns_jobs`
--

CREATE TABLE `ns_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint unsigned NOT NULL,
  `reserved_at` int unsigned DEFAULT NULL,
  `available_at` int unsigned NOT NULL,
  `created_at` int unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ns_jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_jobs`
--


--
-- Table structure for table `ns_migrations`
--

CREATE TABLE `ns_migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_migrations`
--

INSERT INTO `ns_migrations` (`id`, `migration`, `batch`, `type`) VALUES (1,'2018_08_08_100000_create_telescope_entries_table',1,NULL),(2,'2019_12_14_000001_create_personal_access_tokens_table',1,NULL),(3,'2022_10_28_123458_setup_migration_table',1,NULL),(4,'2014_10_13_000000_create_users_table',0,'core'),(5,'2017_07_28_130434_create_roles_table',0,'core'),(6,'2017_07_28_130610_create_permissions_table',0,'core'),(7,'2018_08_08_100000_create_telescope_entries_table',0,'core'),(8,'2019_08_19_000000_create_failed_jobs_table',0,'core'),(9,'2020_06_20_000000_create_permissions',0,'core'),(10,'2020_06_20_000000_create_roles',0,'core'),(11,'2020_10_11_122857_create_jobs_table',0,'core'),(12,'2020_11_04_124040_add_new_customers_permission_nov4',0,'core'),(13,'2020_11_11_151614_nov11_create_nexopos_users_attributes_table',0,'core'),(14,'2020_11_12_205243_nov12_create_order_permission',0,'core'),(15,'2020_11_25_203531_nov25_fix_report_permissions_attribution',0,'core'),(16,'2020_12_08_210001_dec8add_new_permissions',0,'core'),(17,'2020_12_19_221434_create_nexopos_modules_migrations_table',0,'core'),(18,'2021_01_07_143635_add_new_customer_permission_janv7_21',0,'core'),(19,'2021_03_09_165538_create_new_permissions_march_9',0,'core'),(20,'2021_05_25_175424_update_add_payment_type_permissions',0,'core'),(21,'2021_05_28_114827_create_new_report_permissions_may28',0,'core'),(22,'2021_06_24_053134_update_permissions_jun24',0,'core'),(23,'2021_07_31_153029_update_dashboard_days_report_jul31',0,'core'),(24,'2014_10_12_000000_create_medias_table',0,'create'),(25,'2017_12_29_174613_create_options_table',0,'create'),(26,'2020_06_20_000000_create_customers_groups_table',0,'create'),(27,'2020_06_20_000000_create_customers_table',0,'create'),(28,'2020_06_20_000000_create_expenses_categories_table',0,'create'),(29,'2020_06_20_000000_create_expenses_table',0,'create'),(30,'2020_06_20_000000_create_orders_addresses_table',0,'create'),(31,'2020_06_20_000000_create_orders_coupons_table',0,'create'),(32,'2020_06_20_000000_create_orders_metas_table',0,'create'),(33,'2020_06_20_000000_create_orders_payment_table',0,'create'),(34,'2020_06_20_000000_create_orders_products_table',0,'create'),(35,'2020_06_20_000000_create_orders_table',0,'create'),(36,'2020_06_20_000000_create_procurements_products_table',0,'create'),(37,'2020_06_20_000000_create_procurements_table',0,'create'),(38,'2020_06_20_000000_create_products_categories_table',0,'create'),(39,'2020_06_20_000000_create_products_gallery_table',0,'create'),(40,'2020_06_20_000000_create_products_history_table',0,'create'),(41,'2020_06_20_000000_create_products_metas_table',0,'create'),(42,'2020_06_20_000000_create_products_table',0,'create'),(43,'2020_06_20_000000_create_products_taxes_table',0,'create'),(44,'2020_06_20_000000_create_products_unit_quantities',0,'create'),(45,'2020_06_20_000000_create_providers_table',0,'create'),(46,'2020_06_20_000000_create_registers_history_table',0,'create'),(47,'2020_06_20_000000_create_registers_table',0,'create'),(48,'2020_06_20_000000_create_rewards_system_rules_table',0,'create'),(49,'2020_06_20_000000_create_rewards_system_table',0,'create'),(50,'2020_06_20_000000_create_taxes_table',0,'create'),(51,'2020_06_20_000000_create_units_group_table',0,'create'),(52,'2020_06_20_000000_create_units_table',0,'create'),(53,'2020_08_01_143801_create_customers_coupons_table',0,'create'),(54,'2020_10_10_224639_create_dashboard_table',0,'create'),(55,'2020_10_11_074631_create_nexopos_notifications_table',0,'create'),(56,'2020_10_17_231628_create_nexopos_orders_storage',0,'create'),(57,'2020_10_29_150642_create_nexopos_expenses_history_table',0,'create'),(58,'2020_11_17_120204_nov17_add_fields_to_nexopos_orders_products_table',0,'create'),(59,'2020_12_11_210734_create_nexopos_dashboard_months_table',0,'create'),(60,'2021_01_23_225101_create_coupons_table',0,'create'),(61,'2021_01_23_225713_create_customers_rewards_table',0,'create'),(62,'2021_02_21_144532_create_orders_instalments_table',0,'create'),(63,'2021_02_23_004748_create_new_instalments_permissions',0,'create'),(64,'2021_05_25_131104_create_nexopos_payments_types_table',0,'create'),(65,'2022_01_20_202253_create_user_role_relations_table',0,'create'),(66,'2022_05_13_142039_create_products_group_items_table',0,'create'),(67,'2022_10_12_083552_update_register_history_oct12_22',0,'create'),(68,'2022_10_28_093041_update_expense_table28_oct22',0,'create'),(69,'2022_11_25_071626_create_users_widgets_table',0,'create'),(70,'2023_10_31_120602_stock_history_detailed',0,'create'),(71,'2024_04_29_214452_create_transaction_balance_days_table',0,'create'),(72,'2024_04_29_214459_create_transaction_balance_months_table',0,'create'),(73,'2025_02_18_071747_create_brands_table',0,'create'),(74,'2022_11_28_000259_v5x_general_database_update',0,'update'),(75,'2022_11_30_224820_update_orders_coupon_table',0,'update'),(76,'2023_02_14_123130_update_product_history_table14_fev23',0,'update'),(77,'2023_03_16_214039_update_expense_table',0,'update'),(78,'2023_07_30_235454_fix_wrong_purchase_price_32_jul_23',0,'update'),(79,'2024_01_26_075544_update_expenses_and_accounts',0,'update'),(80,'2024_01_26_165001_update_transaction_histories',0,'update'),(81,'2024_02_29_035014_update_add_new_pos_permissions',0,'update'),(82,'2024_03_12_235545_update_v5_2_0',0,'update'),(83,'2024_03_25_150121_update_user_widget',0,'update'),(84,'2024_04_04_234202_update_transactions_adds_missing_field',0,'update'),(85,'2024_04_18_084130_update_transactions_history_table',0,'update'),(86,'2024_04_29_110922_update_cash_registers_table',0,'update'),(87,'2024_08_12_183024_add_purchase_order_fields_in_procurements_table',0,'update'),(88,'2024_08_12_184016_add_purchase_order_fields_in_procurements_prodcuts_table',0,'update');

--
-- Table structure for table `ns_nexopos_brands`
--

CREATE TABLE `ns_nexopos_brands` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `report_name_placeholder` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `website` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text COLLATE utf8mb4_unicode_ci,
  `active` tinyint(1) NOT NULL DEFAULT '0',
  `author` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_brands`
--

INSERT INTO `ns_nexopos_brands` (`id`, `name`, `report_name_placeholder`, `logo`, `description`, `website`, `email`, `phone`, `address`, `active`, `author`, `created_at`, `updated_at`) VALUES (1,'Tapal',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,28,'2025-04-21 07:40:41','2025-04-21 07:40:41'),(2,'Habib Oil',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,28,'2025-05-15 03:20:53','2025-05-15 03:20:53');

--
-- Table structure for table `ns_nexopos_coupons`
--

CREATE TABLE `ns_nexopos_coupons` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'discount',
  `discount_value` float NOT NULL DEFAULT '0',
  `discount` decimal(8,2) NOT NULL DEFAULT '0.00',
  `valid_until` datetime DEFAULT NULL,
  `minimum_cart_value` float DEFAULT '0',
  `maximum_cart_value` float DEFAULT '0',
  `valid_hours_start` datetime DEFAULT NULL,
  `valid_hours_end` datetime DEFAULT NULL,
  `expiry_date` date DEFAULT NULL,
  `limit_usage` float NOT NULL DEFAULT '0',
  `groups_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customers_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `author` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ns_nexopos_coupons_code_unique` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_coupons`
--


--
-- Table structure for table `ns_nexopos_coupons_categories`
--

CREATE TABLE `ns_nexopos_coupons_categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `coupon_id` int NOT NULL,
  `category_id` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_coupons_categories`
--


--
-- Table structure for table `ns_nexopos_coupons_customers`
--

CREATE TABLE `ns_nexopos_coupons_customers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `coupon_id` int NOT NULL,
  `customer_id` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_coupons_customers`
--


--
-- Table structure for table `ns_nexopos_coupons_customers_groups`
--

CREATE TABLE `ns_nexopos_coupons_customers_groups` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `coupon_id` int NOT NULL,
  `group_id` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_coupons_customers_groups`
--


--
-- Table structure for table `ns_nexopos_coupons_products`
--

CREATE TABLE `ns_nexopos_coupons_products` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `coupon_id` int NOT NULL,
  `product_id` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_coupons_products`
--


--
-- Table structure for table `ns_nexopos_customers_account_history`
--

CREATE TABLE `ns_nexopos_customers_account_history` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `customer_id` int NOT NULL,
  `order_id` int DEFAULT NULL,
  `previous_amount` double NOT NULL DEFAULT '0',
  `amount` double NOT NULL DEFAULT '0',
  `next_amount` double NOT NULL DEFAULT '0',
  `operation` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `author` int NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_customers_account_history`
--


--
-- Table structure for table `ns_nexopos_customers_addresses`
--

CREATE TABLE `ns_nexopos_customers_addresses` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `customer_id` int NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `first_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_1` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pobox` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `author` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_customers_addresses`
--

INSERT INTO `ns_nexopos_customers_addresses` (`id`, `customer_id`, `type`, `email`, `first_name`, `last_name`, `phone`, `address_1`, `address_2`, `country`, `city`, `pobox`, `company`, `uuid`, `author`, `created_at`, `updated_at`) VALUES (1,29,'shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,28,'2025-05-15 02:50:50','2025-05-15 02:50:50'),(2,29,'billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,28,'2025-05-15 02:50:50','2025-05-15 02:50:50');

--
-- Table structure for table `ns_nexopos_customers_coupons`
--

CREATE TABLE `ns_nexopos_customers_coupons` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `usage` int NOT NULL DEFAULT '0',
  `limit_usage` int NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `coupon_id` int NOT NULL,
  `customer_id` int NOT NULL,
  `author` 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;

--
-- Dumping data for table `ns_nexopos_customers_coupons`
--


--
-- Table structure for table `ns_nexopos_customers_groups`
--

CREATE TABLE `ns_nexopos_customers_groups` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `reward_system_id` int DEFAULT '0',
  `minimal_credit_payment` int NOT NULL DEFAULT '0',
  `author` int NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_customers_groups`
--

INSERT INTO `ns_nexopos_customers_groups` (`id`, `name`, `description`, `reward_system_id`, `minimal_credit_payment`, `author`, `uuid`, `created_at`, `updated_at`) VALUES (1,'Default',NULL,NULL,0,28,NULL,'2025-05-15 02:50:21','2025-05-15 02:50:21');

--
-- Table structure for table `ns_nexopos_customers_rewards`
--

CREATE TABLE `ns_nexopos_customers_rewards` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `customer_id` int NOT NULL,
  `reward_id` int NOT NULL,
  `reward_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `points` float NOT NULL,
  `target` float 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;

--
-- Dumping data for table `ns_nexopos_customers_rewards`
--


--
-- Table structure for table `ns_nexopos_dashboard_days`
--

CREATE TABLE `ns_nexopos_dashboard_days` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `total_unpaid_orders` float NOT NULL DEFAULT '0',
  `day_unpaid_orders` float NOT NULL DEFAULT '0',
  `total_unpaid_orders_count` float NOT NULL DEFAULT '0',
  `day_unpaid_orders_count` float NOT NULL DEFAULT '0',
  `total_paid_orders` float NOT NULL DEFAULT '0',
  `day_paid_orders` float NOT NULL DEFAULT '0',
  `total_paid_orders_count` float NOT NULL DEFAULT '0',
  `day_paid_orders_count` float NOT NULL DEFAULT '0',
  `total_partially_paid_orders` float NOT NULL DEFAULT '0',
  `day_partially_paid_orders` float NOT NULL DEFAULT '0',
  `total_partially_paid_orders_count` float NOT NULL DEFAULT '0',
  `day_partially_paid_orders_count` float NOT NULL DEFAULT '0',
  `total_income` float NOT NULL DEFAULT '0',
  `day_income` float NOT NULL DEFAULT '0',
  `total_discounts` float NOT NULL DEFAULT '0',
  `day_discounts` float NOT NULL DEFAULT '0',
  `day_taxes` float NOT NULL DEFAULT '0',
  `total_taxes` float NOT NULL DEFAULT '0',
  `total_wasted_goods_count` float NOT NULL DEFAULT '0',
  `day_wasted_goods_count` float NOT NULL DEFAULT '0',
  `total_wasted_goods` float NOT NULL DEFAULT '0',
  `day_wasted_goods` float NOT NULL DEFAULT '0',
  `total_expenses` float NOT NULL DEFAULT '0',
  `day_expenses` float NOT NULL DEFAULT '0',
  `day_of_year` int NOT NULL DEFAULT '0',
  `range_starts` datetime DEFAULT NULL,
  `range_ends` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_dashboard_days`
--

INSERT INTO `ns_nexopos_dashboard_days` (`id`, `total_unpaid_orders`, `day_unpaid_orders`, `total_unpaid_orders_count`, `day_unpaid_orders_count`, `total_paid_orders`, `day_paid_orders`, `total_paid_orders_count`, `day_paid_orders_count`, `total_partially_paid_orders`, `day_partially_paid_orders`, `total_partially_paid_orders_count`, `day_partially_paid_orders_count`, `total_income`, `day_income`, `total_discounts`, `day_discounts`, `day_taxes`, `total_taxes`, `total_wasted_goods_count`, `day_wasted_goods_count`, `total_wasted_goods`, `day_wasted_goods`, `total_expenses`, `day_expenses`, `day_of_year`, `range_starts`, `range_ends`) VALUES (1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,135,'2025-05-15 00:00:00','2025-05-15 23:59:59'),(2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,134,'2025-05-14 00:00:00','2025-05-14 23:59:59'),(3,0,0,0,0,140,140,1,1,0,0,0,0,140,140,0,0,0,0,0,0,0,0,0,0,142,'2025-05-22 00:00:00','2025-05-22 23:59:59'),(4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,141,'2025-05-21 00:00:00','2025-05-21 23:59:59'),(5,0,0,2,2,7469.7,7469.7,14,14,0,0,0,0,7469.7,7469.7,75.4,75.4,0,0,0,0,0,0,0,0,154,'2025-06-03 00:00:00','2025-06-03 23:59:59'),(6,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,153,'2025-06-02 00:00:00','2025-06-02 23:59:59'),(7,0,0,0,0,660,660,1,1,0,0,0,0,660,660,0,0,0,0,0,0,0,0,0,0,164,'2025-06-13 00:00:00','2025-06-13 23:59:59'),(8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,163,'2025-06-12 00:00:00','2025-06-12 23:59:59'),(9,0,0,0,0,1980,1980,3,3,0,0,0,0,1980,1980,0,0,0,0,0,0,0,0,0,0,167,'2025-06-16 00:00:00','2025-06-16 23:59:59'),(10,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,166,'2025-06-15 00:00:00','2025-06-15 23:59:59'),(11,0,0,0,0,1980,0,3,0,0,0,0,0,1980,0,0,0,0,0,0,0,0,0,660,660,168,'2025-06-17 00:00:00','2025-06-17 23:59:59');

--
-- Table structure for table `ns_nexopos_dashboard_months`
--

CREATE TABLE `ns_nexopos_dashboard_months` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `month_taxes` float NOT NULL DEFAULT '0',
  `month_unpaid_orders` float NOT NULL DEFAULT '0',
  `month_unpaid_orders_count` float NOT NULL DEFAULT '0',
  `month_paid_orders` float NOT NULL DEFAULT '0',
  `month_paid_orders_count` float NOT NULL DEFAULT '0',
  `month_partially_paid_orders` float NOT NULL DEFAULT '0',
  `month_partially_paid_orders_count` float NOT NULL DEFAULT '0',
  `month_income` float NOT NULL DEFAULT '0',
  `month_discounts` float NOT NULL DEFAULT '0',
  `month_wasted_goods_count` float NOT NULL DEFAULT '0',
  `month_wasted_goods` float NOT NULL DEFAULT '0',
  `month_expenses` float NOT NULL DEFAULT '0',
  `total_wasted_goods` float NOT NULL DEFAULT '0',
  `total_unpaid_orders` float NOT NULL DEFAULT '0',
  `total_unpaid_orders_count` float NOT NULL DEFAULT '0',
  `total_paid_orders` float NOT NULL DEFAULT '0',
  `total_paid_orders_count` float NOT NULL DEFAULT '0',
  `total_partially_paid_orders` float NOT NULL DEFAULT '0',
  `total_partially_paid_orders_count` float NOT NULL DEFAULT '0',
  `total_income` float NOT NULL DEFAULT '0',
  `total_discounts` float NOT NULL DEFAULT '0',
  `total_taxes` float NOT NULL DEFAULT '0',
  `total_wasted_goods_count` float NOT NULL DEFAULT '0',
  `total_expenses` float NOT NULL DEFAULT '0',
  `month_of_year` int NOT NULL DEFAULT '0',
  `range_starts` datetime NOT NULL,
  `range_ends` datetime NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_dashboard_months`
--

INSERT INTO `ns_nexopos_dashboard_months` (`id`, `month_taxes`, `month_unpaid_orders`, `month_unpaid_orders_count`, `month_paid_orders`, `month_paid_orders_count`, `month_partially_paid_orders`, `month_partially_paid_orders_count`, `month_income`, `month_discounts`, `month_wasted_goods_count`, `month_wasted_goods`, `month_expenses`, `total_wasted_goods`, `total_unpaid_orders`, `total_unpaid_orders_count`, `total_paid_orders`, `total_paid_orders_count`, `total_partially_paid_orders`, `total_partially_paid_orders_count`, `total_income`, `total_discounts`, `total_taxes`, `total_wasted_goods_count`, `total_expenses`, `month_of_year`, `range_starts`, `range_ends`, `created_at`, `updated_at`) VALUES (1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,'2025-01-01 00:00:00','2025-01-31 23:59:59',NULL,NULL),(2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,'2025-02-01 00:00:00','2025-02-28 23:59:59',NULL,NULL),(3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,'2025-03-01 00:00:00','2025-03-31 23:59:59',NULL,NULL),(4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4,'2025-04-01 00:00:00','2025-04-30 23:59:59',NULL,NULL),(5,0,0,0,140,1,0,0,140,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5,'2025-05-01 00:00:00','2025-05-31 23:59:59',NULL,NULL),(6,0,0,2,7469.7,14,0,0,7469.7,75.4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,6,'2025-06-01 00:00:00','2025-06-30 23:59:59',NULL,NULL),(7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,7,'2025-07-01 00:00:00','2025-07-31 23:59:59',NULL,NULL),(8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,8,'2025-08-01 00:00:00','2025-08-31 23:59:59',NULL,NULL),(9,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,9,'2025-09-01 00:00:00','2025-09-30 23:59:59',NULL,NULL),(10,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,10,'2025-10-01 00:00:00','2025-10-31 23:59:59',NULL,NULL),(11,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,11,'2025-11-01 00:00:00','2025-11-30 23:59:59',NULL,NULL),(12,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,12,'2025-12-01 00:00:00','2025-12-31 23:59:59',NULL,NULL);

--
-- Table structure for table `ns_nexopos_dashboard_weeks`
--

CREATE TABLE `ns_nexopos_dashboard_weeks` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `total_gross_income` float NOT NULL DEFAULT '0',
  `total_taxes` float NOT NULL DEFAULT '0',
  `total_expenses` float NOT NULL DEFAULT '0',
  `total_net_income` float NOT NULL DEFAULT '0',
  `week_number` int NOT NULL DEFAULT '0',
  `range_starts` datetime DEFAULT NULL,
  `range_ends` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_dashboard_weeks`
--


--
-- Table structure for table `ns_nexopos_medias`
--

CREATE TABLE `ns_nexopos_medias` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `extension` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ns_nexopos_medias_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_medias`
--

INSERT INTO `ns_nexopos_medias` (`id`, `name`, `extension`, `slug`, `user_id`, `created_at`, `updated_at`) VALUES (1,'ary-pos-logo-wht','png','2025/04/ary-pos-logo-wht',28,'2025-04-21 07:59:23','2025-04-21 07:59:23'),(2,'ary-tech-pos-blue-logo-xs','png','2025/06/ary-tech-pos-blue-logo-xs',28,'2025-06-16 02:13:40','2025-06-16 02:13:40'),(3,'ary-chase','png','2025/06/ary-chase',28,'2025-06-17 03:34:39','2025-06-17 03:34:39'),(4,'ary-chase-thumb','png','2025/06/ary-chase-thumb',28,'2025-06-17 03:37:00','2025-06-17 03:37:00'),(5,'chasedepartmentstore-logo','jpg','2025/06/chasedepartmentstore-logo',28,'2025-06-17 03:55:36','2025-06-17 03:55:36'),(6,'logo-png','png','2025/06/logo-png',28,'2025-06-17 08:25:54','2025-06-17 08:25:54'),(7,'logo-png-black','png','2025/06/logo-png-black',28,'2025-06-17 08:27:16','2025-06-17 08:27:16');

--
-- Table structure for table `ns_nexopos_modules_migrations`
--

CREATE TABLE `ns_nexopos_modules_migrations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `namespace` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `file` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_modules_migrations`
--


--
-- Table structure for table `ns_nexopos_notifications`
--

CREATE TABLE `ns_nexopos_notifications` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `identifier` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '#',
  `source` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'system',
  `dismissable` 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=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_notifications`
--

INSERT INTO `ns_nexopos_notifications` (`id`, `user_id`, `identifier`, `title`, `description`, `url`, `source`, `dismissable`, `created_at`, `updated_at`) VALUES (1,28,'ns.notifications.workers-disabled','Task Scheduling Disabled','AryPOS is unable to schedule background tasks. This might restrict necessary features. Click here to learn how to fix it.','https://my.nexopos.com/en/documentation/troubleshooting/workers-or-async-requests-disabled?utm_source=nexopos&utm_campaign=warning&utm_medium=app','system',1,'2025-04-21 07:59:07','2025-06-23 08:14:00'),(2,28,'ns.notifications.cron-disabled','Cron Disabled','Cron jobs aren\'t configured correctly on AryPOS. This might restrict necessary features. Click here to learn how to fix it.','https://my.nexopos.com/en/documentation/troubleshooting/workers-or-async-requests-disabled?utm_source=nexopos&utm_campaign=warning&utm_medium=app','system',1,'2025-04-21 07:59:07','2025-06-23 08:14:00');

--
-- Table structure for table `ns_nexopos_orders`
--

CREATE TABLE `ns_nexopos_orders` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `description` text COLLATE utf8mb4_unicode_ci,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payment_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `process_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `delivery_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `discount` float NOT NULL DEFAULT '0',
  `discount_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `support_instalments` tinyint(1) NOT NULL DEFAULT '1',
  `discount_percentage` float DEFAULT NULL,
  `shipping` float NOT NULL DEFAULT '0',
  `shipping_rate` float NOT NULL DEFAULT '0',
  `shipping_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `total_without_tax` float NOT NULL DEFAULT '0',
  `subtotal` float NOT NULL DEFAULT '0',
  `total_with_tax` float NOT NULL DEFAULT '0',
  `total_coupons` float NOT NULL DEFAULT '0',
  `total` float NOT NULL DEFAULT '0',
  `tax_value` float NOT NULL DEFAULT '0',
  `products_tax_value` double NOT NULL DEFAULT '0',
  `total_tax_value` double NOT NULL DEFAULT '0',
  `tax_group_id` int DEFAULT NULL,
  `tax_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tendered` float NOT NULL DEFAULT '0',
  `change` float NOT NULL DEFAULT '0',
  `final_payment_date` datetime DEFAULT NULL,
  `total_instalments` int NOT NULL DEFAULT '0',
  `customer_id` int NOT NULL,
  `note` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `note_visibility` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `author` int NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `register_id` int DEFAULT NULL,
  `voidance_reason` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_orders`
--

INSERT INTO `ns_nexopos_orders` (`id`, `description`, `code`, `title`, `type`, `payment_status`, `process_status`, `delivery_status`, `discount`, `discount_type`, `support_instalments`, `discount_percentage`, `shipping`, `shipping_rate`, `shipping_type`, `total_without_tax`, `subtotal`, `total_with_tax`, `total_coupons`, `total`, `tax_value`, `products_tax_value`, `total_tax_value`, `tax_group_id`, `tax_type`, `tendered`, `change`, `final_payment_date`, `total_instalments`, `customer_id`, `note`, `note_visibility`, `author`, `uuid`, `register_id`, `voidance_reason`, `created_at`, `updated_at`) VALUES (1,NULL,'250522-001',NULL,'takeaway','paid','not-available','not-available',0,NULL,1,0,0,0,NULL,140,140,140,0,140,0,0,0,NULL,'0',140,0,NULL,0,29,NULL,'hidden',28,NULL,NULL,NULL,'2025-05-22 04:05:35','2025-05-22 04:05:35'),(2,NULL,'250603-001',NULL,'takeaway','paid','not-available','not-available',49.2,'percentage',1,2,0,0,NULL,2410.8,2460,2410.8,0,2410.8,0,0,0,NULL,'0',2411,0.2,NULL,0,29,NULL,'hidden',28,NULL,NULL,NULL,'2025-06-03 03:07:26','2025-06-03 03:07:26'),(3,NULL,'250603-002',NULL,'takeaway','paid','not-available','not-available',0,NULL,1,0,0,0,NULL,66.5,66.5,66.5,0,66.5,0,0,0,NULL,'0',67,0.5,NULL,0,29,NULL,'hidden',28,NULL,NULL,NULL,'2025-06-03 03:09:01','2025-06-03 03:09:01'),(4,NULL,'250603-003',NULL,'takeaway','paid','not-available','not-available',4,'flat',1,0,0,0,NULL,64.6,68.6,64.6,0,64.6,0,0,0,NULL,'0',65,0.4,NULL,0,29,NULL,'hidden',28,NULL,NULL,NULL,'2025-06-03 03:12:02','2025-06-03 03:12:02'),(5,NULL,'250603-004',NULL,'takeaway','paid','not-available','not-available',19.2,'percentage',1,3,0,0,NULL,620.8,640,620.8,0,620.8,0,0,0,NULL,'0',621,0.2,NULL,0,29,'Term & condition applied','hidden',28,NULL,NULL,NULL,'2025-06-03 03:14:42','2025-06-03 03:14:42'),(6,NULL,'250603-005',NULL,'takeaway','paid','not-available','not-available',0,NULL,1,0,0,0,NULL,70,70,70,0,70,0,0,0,NULL,'0',70,0,NULL,0,29,'Term & condition applied','visible',28,NULL,NULL,NULL,'2025-06-03 03:15:26','2025-06-03 03:15:26'),(7,NULL,'250603-006',NULL,'takeaway','paid','not-available','not-available',0,NULL,1,0,0,0,NULL,660,660,660,0,660,0,0,0,NULL,'0',660,0,NULL,0,29,NULL,'hidden',28,NULL,NULL,NULL,'2025-06-03 03:20:14','2025-06-03 03:20:14'),(8,NULL,'250603-007',NULL,'takeaway','paid','not-available','not-available',3,'flat',1,0,0,0,NULL,67,70,67,0,67,0,0,0,NULL,'0',100,33,NULL,0,29,NULL,'hidden',28,NULL,NULL,NULL,'2025-06-03 03:29:17','2025-06-03 03:29:17'),(9,NULL,'250603-008',NULL,'takeaway','unpaid','not-available','not-available',0,'flat',1,2,0,0,NULL,0,0,0,0,0,0,0,0,NULL,'0',0,0,NULL,0,29,NULL,'hidden',28,NULL,NULL,NULL,'2025-06-03 08:18:34','2025-06-03 08:18:34'),(10,NULL,'250603-009',NULL,'takeaway','unpaid','not-available','not-available',0,NULL,1,0,0,0,NULL,0,0,0,0,0,0,0,0,NULL,'0',0,0,NULL,0,29,NULL,'hidden',28,NULL,NULL,NULL,'2025-06-03 08:22:36','2025-06-03 08:22:36'),(11,NULL,'250603-010',NULL,'takeaway','paid','not-available','not-available',0,NULL,1,0,0,0,NULL,70,70,70,0,70,0,0,0,NULL,'0',70,0,NULL,0,29,NULL,'hidden',28,NULL,NULL,NULL,'2025-06-03 08:23:36','2025-06-03 08:23:36'),(12,NULL,'250603-011',NULL,'takeaway','paid','not-available','not-available',0,NULL,1,0,0,0,NULL,70,70,70,0,70,0,0,0,NULL,'0',70,0,NULL,0,29,NULL,'hidden',28,NULL,NULL,NULL,'2025-06-03 08:41:18','2025-06-03 08:41:18'),(13,NULL,'250603-012',NULL,'takeaway','paid','not-available','not-available',0,NULL,1,0,0,0,NULL,70,70,70,0,70,0,0,0,NULL,'0',70,0,NULL,0,29,NULL,'hidden',28,NULL,NULL,NULL,'2025-06-03 08:41:58','2025-06-03 08:41:58'),(14,NULL,'250603-013',NULL,'takeaway','paid','not-available','not-available',0,NULL,1,0,0,0,NULL,1320,1320,1320,0,1320,0,0,0,NULL,'0',1320,0,NULL,0,29,NULL,'hidden',28,NULL,NULL,NULL,'2025-06-03 08:44:46','2025-06-03 08:44:46'),(15,NULL,'250603-014',NULL,'takeaway','paid','not-available','not-available',0,NULL,1,0,0,0,NULL,660,660,660,0,660,0,0,0,NULL,'0',730,70,NULL,0,29,NULL,'hidden',28,NULL,NULL,NULL,'2025-06-03 08:48:28','2025-06-03 08:48:28'),(16,NULL,'250603-015',NULL,'takeaway','paid','not-available','not-available',0,NULL,1,0,0,0,NULL,660,660,660,0,660,0,0,0,NULL,'0',660,0,NULL,0,29,NULL,'hidden',28,NULL,NULL,NULL,'2025-06-03 08:54:14','2025-06-03 08:54:14'),(17,NULL,'250603-016',NULL,'takeaway','paid','not-available','not-available',0,NULL,1,0,0,0,NULL,660,660,660,0,660,0,0,0,NULL,'0',660,0,NULL,0,29,NULL,'hidden',28,NULL,NULL,NULL,'2025-06-03 08:56:40','2025-06-03 08:56:40'),(18,NULL,'250613-001',NULL,'takeaway','paid','not-available','not-available',0,NULL,1,0,0,0,NULL,660,660,660,0,660,0,0,0,NULL,'0',1482,822,NULL,0,29,NULL,'hidden',28,NULL,NULL,NULL,'2025-06-13 01:52:13','2025-06-13 01:52:13'),(19,NULL,'250616-001',NULL,'takeaway','paid','not-available','not-available',0,NULL,1,0,0,0,NULL,660,660,660,0,660,0,0,0,NULL,'0',660,0,NULL,0,29,NULL,'hidden',28,NULL,NULL,NULL,'2025-06-16 01:50:36','2025-06-16 01:50:36'),(20,NULL,'250616-002',NULL,'takeaway','paid','not-available','not-available',0,NULL,1,0,0,0,NULL,660,660,660,0,660,0,0,0,NULL,'0',660,0,NULL,0,29,NULL,'hidden',28,NULL,NULL,NULL,'2025-06-16 02:01:28','2025-06-16 02:01:28'),(21,NULL,'250616-003',NULL,'takeaway','refunded','not-available','not-available',0,NULL,1,0,0,0,NULL,0,0,0,0,0,0,0,0,NULL,'0',660,660,NULL,0,29,NULL,'hidden',28,NULL,NULL,NULL,'2025-06-16 02:02:05','2025-06-16 02:02:05');

--
-- Table structure for table `ns_nexopos_orders_addresses`
--

CREATE TABLE `ns_nexopos_orders_addresses` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `order_id` int NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `first_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_1` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pobox` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `author` int NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_orders_addresses`
--

INSERT INTO `ns_nexopos_orders_addresses` (`id`, `order_id`, `type`, `first_name`, `last_name`, `phone`, `address_1`, `email`, `address_2`, `country`, `city`, `pobox`, `company`, `author`, `uuid`, `created_at`, `updated_at`) VALUES (1,1,'shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,28,NULL,'2025-05-22 04:05:35','2025-05-22 04:05:35'),(2,1,'billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,28,NULL,'2025-05-22 04:05:35','2025-05-22 04:05:35'),(3,2,'shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,28,NULL,'2025-06-03 03:07:28','2025-06-03 03:07:28'),(4,2,'billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,28,NULL,'2025-06-03 03:07:28','2025-06-03 03:07:28'),(5,3,'shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,28,NULL,'2025-06-03 03:09:04','2025-06-03 03:09:04'),(6,3,'billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,28,NULL,'2025-06-03 03:09:05','2025-06-03 03:09:05'),(7,4,'shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,28,NULL,'2025-06-03 03:12:02','2025-06-03 03:12:02'),(8,4,'billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,28,NULL,'2025-06-03 03:12:02','2025-06-03 03:12:02'),(9,5,'shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,28,NULL,'2025-06-03 03:14:43','2025-06-03 03:14:43'),(10,5,'billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,28,NULL,'2025-06-03 03:14:43','2025-06-03 03:14:43'),(11,6,'shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,28,NULL,'2025-06-03 03:15:27','2025-06-03 03:15:27'),(12,6,'billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,28,NULL,'2025-06-03 03:15:27','2025-06-03 03:15:27'),(13,7,'shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,28,NULL,'2025-06-03 03:20:15','2025-06-03 03:20:15'),(14,7,'billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,28,NULL,'2025-06-03 03:20:15','2025-06-03 03:20:15'),(15,8,'shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,28,NULL,'2025-06-03 03:29:17','2025-06-03 03:29:17'),(16,8,'billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,28,NULL,'2025-06-03 03:29:17','2025-06-03 03:29:17'),(17,9,'shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,28,NULL,'2025-06-03 08:18:35','2025-06-03 08:18:35'),(18,9,'billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,28,NULL,'2025-06-03 08:18:35','2025-06-03 08:18:35'),(19,10,'shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,28,NULL,'2025-06-03 08:22:37','2025-06-03 08:22:37'),(20,10,'billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,28,NULL,'2025-06-03 08:22:37','2025-06-03 08:22:37'),(21,11,'shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,28,NULL,'2025-06-03 08:23:36','2025-06-03 08:23:36'),(22,11,'billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,28,NULL,'2025-06-03 08:23:37','2025-06-03 08:23:37'),(23,12,'shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,28,NULL,'2025-06-03 08:41:18','2025-06-03 08:41:18'),(24,12,'billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,28,NULL,'2025-06-03 08:41:18','2025-06-03 08:41:18'),(25,13,'shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,28,NULL,'2025-06-03 08:41:58','2025-06-03 08:41:58'),(26,13,'billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,28,NULL,'2025-06-03 08:41:58','2025-06-03 08:41:58'),(27,14,'shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,28,NULL,'2025-06-03 08:44:47','2025-06-03 08:44:47'),(28,14,'billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,28,NULL,'2025-06-03 08:44:47','2025-06-03 08:44:47'),(29,15,'shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,28,NULL,'2025-06-03 08:48:28','2025-06-03 08:48:28'),(30,15,'billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,28,NULL,'2025-06-03 08:48:28','2025-06-03 08:48:28'),(31,16,'shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,28,NULL,'2025-06-03 08:54:15','2025-06-03 08:54:15'),(32,16,'billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,28,NULL,'2025-06-03 08:54:15','2025-06-03 08:54:15'),(33,17,'shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,28,NULL,'2025-06-03 08:56:40','2025-06-03 08:56:40'),(34,17,'billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,28,NULL,'2025-06-03 08:56:40','2025-06-03 08:56:40'),(35,18,'shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,28,NULL,'2025-06-13 01:52:13','2025-06-13 01:52:13'),(36,18,'billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,28,NULL,'2025-06-13 01:52:13','2025-06-13 01:52:13'),(37,19,'shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,28,NULL,'2025-06-16 01:50:37','2025-06-16 01:50:37'),(38,19,'billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,28,NULL,'2025-06-16 01:50:37','2025-06-16 01:50:37'),(39,20,'shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,28,NULL,'2025-06-16 02:01:28','2025-06-16 02:01:28'),(40,20,'billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,28,NULL,'2025-06-16 02:01:28','2025-06-16 02:01:28'),(41,21,'shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,28,NULL,'2025-06-16 02:02:05','2025-06-16 02:02:05'),(42,21,'billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,28,NULL,'2025-06-16 02:02:05','2025-06-16 02:02:05');

--
-- Table structure for table `ns_nexopos_orders_count`
--

CREATE TABLE `ns_nexopos_orders_count` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `count` int NOT NULL,
  `date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_orders_count`
--

INSERT INTO `ns_nexopos_orders_count` (`id`, `count`, `date`) VALUES (1,2,'2025-05-22 00:00:00'),(2,17,'2025-06-03 00:00:00'),(3,2,'2025-06-13 00:00:00'),(4,4,'2025-06-16 00:00:00');

--
-- Table structure for table `ns_nexopos_orders_coupons`
--

CREATE TABLE `ns_nexopos_orders_coupons` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `customer_coupon_id` int NOT NULL,
  `coupon_id` int NOT NULL,
  `order_id` int NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `discount_value` float NOT NULL,
  `minimum_cart_value` float NOT NULL DEFAULT '0',
  `maximum_cart_value` float NOT NULL DEFAULT '0',
  `limit_usage` int NOT NULL DEFAULT '0',
  `value` float NOT NULL DEFAULT '0',
  `author` int NOT NULL,
  `counted` tinyint(1) NOT NULL DEFAULT '0',
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci 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;

--
-- Dumping data for table `ns_nexopos_orders_coupons`
--


--
-- Table structure for table `ns_nexopos_orders_instalments`
--

CREATE TABLE `ns_nexopos_orders_instalments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `amount` float NOT NULL DEFAULT '0',
  `order_id` int DEFAULT NULL,
  `paid` tinyint(1) NOT NULL DEFAULT '0',
  `payment_id` int DEFAULT NULL,
  `date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_orders_instalments`
--


--
-- Table structure for table `ns_nexopos_orders_payments`
--

CREATE TABLE `ns_nexopos_orders_payments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `order_id` int NOT NULL,
  `value` float NOT NULL DEFAULT '0',
  `author` int NOT NULL,
  `identifier` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_orders_payments`
--

INSERT INTO `ns_nexopos_orders_payments` (`id`, `order_id`, `value`, `author`, `identifier`, `uuid`, `created_at`, `updated_at`) VALUES (1,1,140,28,'cash-payment',NULL,'2025-05-22 04:05:35','2025-05-22 04:05:35'),(2,2,2411,28,'cash-payment',NULL,'2025-06-03 03:07:29','2025-06-03 03:07:29'),(3,3,67,28,'cash-payment',NULL,'2025-06-03 03:09:06','2025-06-03 03:09:06'),(4,4,65,28,'cash-payment',NULL,'2025-06-03 03:12:02','2025-06-03 03:12:02'),(5,5,621,28,'cash-payment',NULL,'2025-06-03 03:14:43','2025-06-03 03:14:43'),(6,6,70,28,'cash-payment',NULL,'2025-06-03 03:15:27','2025-06-03 03:15:27'),(7,7,660,28,'cash-payment',NULL,'2025-06-03 03:20:16','2025-06-03 03:20:16'),(8,8,100,28,'cash-payment',NULL,'2025-06-03 03:29:17','2025-06-03 03:29:17'),(9,11,70,28,'cash-payment',NULL,'2025-06-03 08:23:37','2025-06-03 08:23:37'),(10,12,70,28,'cash-payment',NULL,'2025-06-03 08:41:19','2025-06-03 08:41:19'),(11,13,70,28,'cash-payment',NULL,'2025-06-03 08:41:58','2025-06-03 08:41:58'),(12,14,1320,28,'cash-payment',NULL,'2025-06-03 08:44:47','2025-06-03 08:44:47'),(13,15,70,28,'cash-payment',NULL,'2025-06-03 08:48:28','2025-06-03 08:48:28'),(14,15,660,28,'cash-payment',NULL,'2025-06-03 08:48:28','2025-06-03 08:48:28'),(15,16,660,28,'cash-payment',NULL,'2025-06-03 08:54:15','2025-06-03 08:54:15'),(16,17,660,28,'cash-payment',NULL,'2025-06-03 08:56:41','2025-06-03 08:56:41'),(17,18,1482,28,'cash-payment',NULL,'2025-06-13 01:52:13','2025-06-13 01:52:13'),(18,19,660,28,'cash-payment',NULL,'2025-06-16 01:50:37','2025-06-16 01:50:37'),(19,20,660,28,'cash-payment',NULL,'2025-06-16 02:01:28','2025-06-16 02:01:28'),(20,21,660,28,'cash-payment',NULL,'2025-06-16 02:02:05','2025-06-16 02:02:05');

--
-- Table structure for table `ns_nexopos_orders_products`
--

CREATE TABLE `ns_nexopos_orders_products` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `unit_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mode` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'normal',
  `product_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'product',
  `product_id` int NOT NULL,
  `order_id` int NOT NULL,
  `unit_id` int NOT NULL,
  `unit_quantity_id` int NOT NULL,
  `product_category_id` int NOT NULL,
  `procurement_product_id` int DEFAULT NULL,
  `tax_group_id` int NOT NULL DEFAULT '0',
  `tax_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'sold',
  `return_observations` text COLLATE utf8mb4_unicode_ci,
  `return_condition` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `discount_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'none',
  `discount` float NOT NULL DEFAULT '0',
  `quantity` float NOT NULL,
  `discount_percentage` float NOT NULL DEFAULT '0',
  `unit_price` float NOT NULL DEFAULT '0',
  `price_with_tax` float NOT NULL DEFAULT '0',
  `price_without_tax` float NOT NULL DEFAULT '0',
  `wholesale_tax_value` float NOT NULL DEFAULT '0',
  `sale_tax_value` float NOT NULL DEFAULT '0',
  `tax_value` float NOT NULL DEFAULT '0',
  `rate` double NOT NULL DEFAULT '0',
  `total_price` float NOT NULL DEFAULT '0',
  `total_price_with_tax` float NOT NULL DEFAULT '0',
  `total_price_without_tax` float NOT NULL DEFAULT '0',
  `total_purchase_price` float NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_orders_products`
--

INSERT INTO `ns_nexopos_orders_products` (`id`, `name`, `unit_name`, `mode`, `product_type`, `product_id`, `order_id`, `unit_id`, `unit_quantity_id`, `product_category_id`, `procurement_product_id`, `tax_group_id`, `tax_type`, `uuid`, `status`, `return_observations`, `return_condition`, `discount_type`, `discount`, `quantity`, `discount_percentage`, `unit_price`, `price_with_tax`, `price_without_tax`, `wholesale_tax_value`, `sale_tax_value`, `tax_value`, `rate`, `total_price`, `total_price_with_tax`, `total_price_without_tax`, `total_purchase_price`, `created_at`, `updated_at`) VALUES (1,'Tapal Danedar','DefaultUnit','normal','product',1,1,1,1,1,NULL,0,'disabled',NULL,'sold',NULL,NULL,'percentage',0,2,0,70,70,70,0,0,0,0,140,140,140,280,'2025-05-22 04:05:35','2025-05-22 04:05:35'),(2,'Tapal Danedaar 1 kg','DefaultUnit','wholesale','product',5,2,1,5,1,NULL,0,'disabled',NULL,'sold',NULL,NULL,'percentage',0,2,0,570,570,570,0,0,0,0,1140,1140,1140,0,'2025-06-03 03:07:30','2025-06-03 03:07:30'),(3,'Tapal Danedaar 1 kg','DefaultUnit','normal','product',5,2,1,5,1,NULL,0,'disabled',NULL,'sold',NULL,NULL,'percentage',0,1,0,660,660,660,0,0,0,0,660,660,660,0,'2025-06-03 03:07:33','2025-06-03 03:07:33'),(4,'Tapal Danedaar 1 kg','DefaultUnit','normal','product',5,2,1,5,1,NULL,0,'disabled',NULL,'sold',NULL,NULL,'percentage',0,1,0,660,660,660,0,0,0,0,660,660,660,0,'2025-06-03 03:07:35','2025-06-03 03:07:35'),(5,'Tapal Danedar','DefaultUnit','normal','product',1,3,1,1,1,NULL,0,'disabled',NULL,'sold',NULL,NULL,'percentage',3.5,1,5,70,70,70,0,0,0,0,66.5,70,70,0,'2025-06-03 03:09:07','2025-06-03 03:09:07'),(6,'Tapal Danedar','DefaultUnit','normal','product',1,4,1,1,1,NULL,0,'disabled',NULL,'sold',NULL,NULL,'percentage',1.4,1,2,70,70,70,0,0,0,0,68.6,70,70,0,'2025-06-03 03:12:02','2025-06-03 03:12:02'),(7,'Tapal Danedaar 1 kg','DefaultUnit','wholesale','product',5,5,1,5,1,NULL,0,'disabled',NULL,'sold',NULL,NULL,'percentage',0,1,0,570,570,570,0,0,0,0,570,570,570,0,'2025-06-03 03:14:43','2025-06-03 03:14:43'),(8,'Tapal Danedar','DefaultUnit','normal','product',1,5,1,1,1,NULL,0,'disabled',NULL,'sold',NULL,NULL,'percentage',0,1,0,70,70,70,0,0,0,0,70,70,70,0,'2025-06-03 03:14:44','2025-06-03 03:14:44'),(9,'Tapal Danedar','DefaultUnit','normal','product',1,6,1,1,1,NULL,0,'disabled',NULL,'sold',NULL,NULL,'percentage',0,1,0,70,70,70,0,0,0,0,70,70,70,0,'2025-06-03 03:15:27','2025-06-03 03:15:27'),(10,'Tapal Danedaar 1 kg','DefaultUnit','normal','product',5,7,1,5,1,NULL,0,'disabled',NULL,'sold',NULL,NULL,'percentage',0,1,0,660,660,660,0,0,0,0,660,660,660,0,'2025-06-03 03:20:16','2025-06-03 03:20:16'),(11,'Tapal Danedar','DefaultUnit','normal','product',1,8,1,1,1,NULL,0,'disabled',NULL,'sold',NULL,NULL,'percentage',0,1,0,70,70,70,0,0,0,0,70,70,70,0,'2025-06-03 03:29:18','2025-06-03 03:29:18'),(12,'Tapal Danedar','DefaultUnit','normal','product',1,9,1,1,1,NULL,0,'disabled',NULL,'sold',NULL,NULL,'percentage',0,0,0,70,70,70,0,0,0,0,0,0,0,0,'2025-06-03 08:18:35','2025-06-03 08:18:35'),(13,'Tapal Danedar','DefaultUnit','normal','product',1,10,1,1,1,NULL,0,'disabled',NULL,'sold',NULL,NULL,'percentage',0,0,0,70,70,70,0,0,0,0,0,0,0,0,'2025-06-03 08:22:37','2025-06-03 08:22:37'),(14,'Tapal Danedar','DefaultUnit','normal','product',1,11,1,1,1,NULL,0,'disabled',NULL,'sold',NULL,NULL,'percentage',0,1,0,70,70,70,0,0,0,0,70,70,70,0,'2025-06-03 08:23:37','2025-06-03 08:23:37'),(15,'Tapal Danedar','DefaultUnit','normal','product',1,12,1,1,1,NULL,0,'disabled',NULL,'sold',NULL,NULL,'percentage',0,1,0,70,70,70,0,0,0,0,70,70,70,0,'2025-06-03 08:41:19','2025-06-03 08:41:19'),(16,'Tapal Danedar','DefaultUnit','normal','product',1,13,1,1,1,NULL,0,'disabled',NULL,'sold',NULL,NULL,'percentage',0,1,0,70,70,70,0,0,0,0,70,70,70,0,'2025-06-03 08:41:58','2025-06-03 08:41:58'),(17,'Tapal Danedaar 1 kg','DefaultUnit','normal','product',5,14,1,5,1,NULL,0,'disabled',NULL,'sold',NULL,NULL,'percentage',0,2,0,660,660,660,0,0,0,0,1320,1320,1320,0,'2025-06-03 08:44:47','2025-06-03 08:44:47'),(18,'Tapal Danedaar 1 kg','DefaultUnit','normal','product',5,15,1,5,1,NULL,0,'disabled',NULL,'sold',NULL,NULL,'percentage',0,1,0,660,660,660,0,0,0,0,660,660,660,0,'2025-06-03 08:48:29','2025-06-03 08:48:29'),(19,'Tapal Danedaar 1 kg','DefaultUnit','normal','product',5,16,1,5,1,NULL,0,'disabled',NULL,'sold',NULL,NULL,'percentage',0,1,0,660,660,660,0,0,0,0,660,660,660,0,'2025-06-03 08:54:15','2025-06-03 08:54:15'),(20,'Tapal Danedaar 1 kg','DefaultUnit','normal','product',5,17,1,5,1,NULL,0,'disabled',NULL,'sold',NULL,NULL,'percentage',0,1,0,660,660,660,0,0,0,0,660,660,660,0,'2025-06-03 08:56:41','2025-06-03 08:56:41'),(21,'Tapal Danedaar 1 kg','DefaultUnit','normal','product',5,18,1,5,1,NULL,0,'disabled',NULL,'sold',NULL,NULL,'percentage',0,1,0,660,660,660,0,0,0,0,660,660,660,0,'2025-06-13 01:52:13','2025-06-13 01:52:13'),(22,'Tapal Danedaar 1 kg','DefaultUnit','normal','product',5,19,1,5,1,NULL,0,'disabled',NULL,'sold',NULL,NULL,'percentage',0,1,0,660,660,660,0,0,0,0,660,660,660,0,'2025-06-16 01:50:37','2025-06-16 01:50:37'),(23,'Tapal Danedaar 1 kg','DefaultUnit','normal','product',5,20,1,5,1,NULL,0,'disabled',NULL,'sold',NULL,NULL,'percentage',0,1,0,660,660,660,0,0,0,0,660,660,660,0,'2025-06-16 02:01:28','2025-06-16 02:01:28'),(24,'Tapal Danedaar 1 kg','DefaultUnit','normal','product',5,21,1,5,1,NULL,0,'disabled',NULL,'returned',NULL,NULL,'percentage',0,0,0,660,660,660,0,0,0,0,0,0,0,0,'2025-06-16 02:02:06','2025-06-17 02:11:24');

--
-- Table structure for table `ns_nexopos_orders_products_refunds`
--

CREATE TABLE `ns_nexopos_orders_products_refunds` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `order_id` int NOT NULL,
  `order_refund_id` int NOT NULL,
  `order_product_id` int NOT NULL,
  `unit_id` int NOT NULL,
  `product_id` int NOT NULL,
  `unit_price` float NOT NULL,
  `tax_value` float NOT NULL DEFAULT '0',
  `quantity` float NOT NULL,
  `total_price` float NOT NULL,
  `condition` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `author` int 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 `ns_nexopos_orders_products_refunds`
--

INSERT INTO `ns_nexopos_orders_products_refunds` (`id`, `order_id`, `order_refund_id`, `order_product_id`, `unit_id`, `product_id`, `unit_price`, `tax_value`, `quantity`, `total_price`, `condition`, `description`, `author`, `created_at`, `updated_at`) VALUES (1,21,1,24,1,5,660,0,1,660,'unspoiled','damaged',28,'2025-06-17 02:11:24','2025-06-17 02:11:24');

--
-- Table structure for table `ns_nexopos_orders_refunds`
--

CREATE TABLE `ns_nexopos_orders_refunds` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `order_id` int NOT NULL,
  `author` int NOT NULL,
  `total` float NOT NULL,
  `tax_value` float NOT NULL DEFAULT '0',
  `shipping` float NOT NULL,
  `payment_method` varchar(255) 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 `ns_nexopos_orders_refunds`
--

INSERT INTO `ns_nexopos_orders_refunds` (`id`, `order_id`, `author`, `total`, `tax_value`, `shipping`, `payment_method`, `created_at`, `updated_at`) VALUES (1,21,28,660,0,0,'cash-payment','2025-06-17 02:11:24','2025-06-17 02:11:25');

--
-- Table structure for table `ns_nexopos_orders_storage`
--

CREATE TABLE `ns_nexopos_orders_storage` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `product_id` int DEFAULT NULL,
  `unit_quantity_id` int DEFAULT NULL,
  `unit_id` int DEFAULT NULL,
  `quantity` int DEFAULT NULL,
  `session_identifier` varchar(255) 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=27 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_orders_storage`
--

INSERT INTO `ns_nexopos_orders_storage` (`id`, `product_id`, `unit_quantity_id`, `unit_id`, `quantity`, `session_identifier`, `created_at`, `updated_at`) VALUES (1,1,1,1,2,'83S1IJpi4p','2025-05-22 04:05:34','2025-05-22 04:05:34'),(2,5,5,1,2,'yE3TIb2ya7','2025-06-03 03:07:26','2025-06-03 03:07:26'),(3,5,5,1,1,'yE3TIb2ya7','2025-06-03 03:07:26','2025-06-03 03:07:26'),(4,5,5,1,1,'yE3TIb2ya7','2025-06-03 03:07:26','2025-06-03 03:07:26'),(5,1,1,1,1,'hTHhWto3xV','2025-06-03 03:08:55','2025-06-03 03:08:55'),(6,1,1,1,1,'Oe0Dse2mUw','2025-06-03 03:12:02','2025-06-03 03:12:02'),(7,5,5,1,1,'c5zRX3coiN','2025-06-03 03:14:42','2025-06-03 03:14:42'),(8,1,1,1,1,'c5zRX3coiN','2025-06-03 03:14:42','2025-06-03 03:14:42'),(9,1,1,1,1,'yI5xlta4T4','2025-06-03 03:15:26','2025-06-03 03:15:26'),(10,5,5,1,1,'vR21jQHuyL','2025-06-03 03:20:14','2025-06-03 03:20:14'),(11,1,1,1,1,'SWBj6i2MZE','2025-06-03 03:29:17','2025-06-03 03:29:17'),(12,1,1,1,0,'hl2qwwQE9s','2025-06-03 08:18:34','2025-06-03 08:18:34'),(13,1,1,1,0,'VLk3lIX2So','2025-06-03 08:22:36','2025-06-03 08:22:36'),(14,1,1,1,1,'ld52bR1Atg','2025-06-03 08:23:36','2025-06-03 08:23:36'),(15,1,1,1,1,'HlRheRukyw','2025-06-03 08:41:18','2025-06-03 08:41:18'),(16,1,1,1,1,'axGBUGVgLS','2025-06-03 08:41:57','2025-06-03 08:41:57'),(17,5,5,1,2,'UW5BMCpNYf','2025-06-03 08:44:46','2025-06-03 08:44:46'),(18,5,5,1,1,'nb355enzSS','2025-06-03 08:48:09','2025-06-03 08:48:09'),(19,5,5,1,1,'auYAuQ3fA8','2025-06-03 08:48:15','2025-06-03 08:48:15'),(20,5,5,1,1,'x1YxroBNkR','2025-06-03 08:48:27','2025-06-03 08:48:27'),(21,5,5,1,1,'TF9bZtAGBr','2025-06-03 08:54:14','2025-06-03 08:54:14'),(22,5,5,1,1,'vaOnPmP2de','2025-06-03 08:56:40','2025-06-03 08:56:40'),(23,5,5,1,1,'jDuAtR3LP8','2025-06-13 01:52:13','2025-06-13 01:52:13'),(24,5,5,1,1,'PkgjHTGwq3','2025-06-16 01:50:36','2025-06-16 01:50:36'),(25,5,5,1,1,'5zypw2TQ86','2025-06-16 02:01:28','2025-06-16 02:01:28'),(26,5,5,1,1,'OBI2KtxD03','2025-06-16 02:02:05','2025-06-16 02:02:05');

--
-- Table structure for table `ns_nexopos_orders_taxes`
--

CREATE TABLE `ns_nexopos_orders_taxes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `tax_id` int DEFAULT NULL,
  `order_id` int DEFAULT NULL,
  `rate` double NOT NULL,
  `tax_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tax_value` double NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_orders_taxes`
--


--
-- Table structure for table `ns_nexopos_payments_types`
--

CREATE TABLE `ns_nexopos_payments_types` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `label` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `identifier` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `priority` int NOT NULL DEFAULT '0',
  `description` text COLLATE utf8mb4_unicode_ci,
  `author` int NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `readonly` 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=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_payments_types`
--

INSERT INTO `ns_nexopos_payments_types` (`id`, `label`, `identifier`, `priority`, `description`, `author`, `active`, `readonly`, `created_at`, `updated_at`) VALUES (1,'Cash','cash-payment',0,NULL,28,1,1,'2025-04-21 07:40:41','2025-04-21 07:40:41');

--
-- Table structure for table `ns_nexopos_permissions`
--

CREATE TABLE `ns_nexopos_permissions` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `namespace` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ns_nexopos_permissions_name_unique` (`name`),
  UNIQUE KEY `ns_nexopos_permissions_namespace_unique` (`namespace`)
) ENGINE=InnoDB AUTO_INCREMENT=124 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_permissions`
--

INSERT INTO `ns_nexopos_permissions` (`id`, `name`, `namespace`, `description`, `created_at`, `updated_at`) VALUES (1,'Create Users','create.users','Can create users','2025-04-21 07:40:11','2025-04-21 07:40:11'),(2,'Read Users','read.users','Can read users','2025-04-21 07:40:11','2025-04-21 07:40:11'),(3,'Update Users','update.users','Can update users','2025-04-21 07:40:11','2025-04-21 07:40:11'),(4,'Delete Users','delete.users','Can delete users','2025-04-21 07:40:11','2025-04-21 07:40:11'),(5,'Create Roles','create.roles','Can create roles','2025-04-21 07:40:11','2025-04-21 07:40:11'),(6,'Read Roles','read.roles','Can read roles','2025-04-21 07:40:11','2025-04-21 07:40:11'),(7,'Update Roles','update.roles','Can update roles','2025-04-21 07:40:11','2025-04-21 07:40:11'),(8,'Delete Roles','delete.roles','Can delete roles','2025-04-21 07:40:11','2025-04-21 07:40:11'),(9,'Update Core','update.core','Can update core','2025-04-21 07:40:11','2025-04-21 07:40:11'),(10,'Manage Profile','manage.profile','Can manage profile','2025-04-21 07:40:11','2025-04-21 07:40:11'),(11,'Manage Modules','manage.modules','Can manage module : install, delete, update, migrate, enable, disable','2025-04-21 07:40:11','2025-04-21 07:40:11'),(12,'Manage Options','manage.options','Can manage options : read, update','2025-04-21 07:40:11','2025-04-21 07:40:11'),(13,'View Dashboard','read.dashboard','Can access the dashboard and see metrics','2025-04-21 07:40:11','2025-04-21 07:40:11'),(14,'Upload Medias','nexopos.upload.medias','Let the user upload medias.','2025-04-21 07:40:11','2025-04-21 07:40:11'),(15,'See Medias','nexopos.see.medias','Let the user see medias.','2025-04-21 07:40:11','2025-04-21 07:40:11'),(16,'Delete Medias','nexopos.delete.medias','Let the user delete medias.','2025-04-21 07:40:11','2025-04-21 07:40:11'),(17,'Update Medias','nexopos.update.medias','Let the user update uploaded medias.','2025-04-21 07:40:11','2025-04-21 07:40:11'),(18,'Create Categories','nexopos.create.categories','Let the user create products categories.','2025-04-21 07:40:11','2025-04-21 07:40:11'),(19,'Delete Categories','nexopos.delete.categories','Let the user delete products categories.','2025-04-21 07:40:11','2025-04-21 07:40:11'),(20,'Update Categories','nexopos.update.categories','Let the user update products categories.','2025-04-21 07:40:11','2025-04-21 07:40:11'),(21,'Read Categories','nexopos.read.categories','Let the user read products categories.','2025-04-21 07:40:11','2025-04-21 07:40:11'),(22,'Create Customers','nexopos.create.customers','Let the user create customers.','2025-04-21 07:40:11','2025-04-21 07:40:11'),(23,'Delete Customers','nexopos.delete.customers','Let the user delete customers.','2025-04-21 07:40:11','2025-04-21 07:40:11'),(24,'Update Customers','nexopos.update.customers','Let the user update customers.','2025-04-21 07:40:11','2025-04-21 07:40:11'),(25,'Read Customers','nexopos.read.customers','Let the user read customers.','2025-04-21 07:40:11','2025-04-21 07:40:11'),(26,'Import Customers','nexopos.import.customers','Let the user import customers.','2025-04-21 07:40:11','2025-04-21 07:40:11'),(27,'Manage Customer Account History','nexopos.customers.manage-account-history','Can add, deduct amount from each customers account.','2025-04-21 07:40:11','2025-04-21 07:40:11'),(28,'Create Customers Groups','nexopos.create.customers-groups','Let the user create Customers Groups','2025-04-21 07:40:11','2025-04-21 07:40:11'),(29,'Delete Customers Groups','nexopos.delete.customers-groups','Let the user delete Customers Groups','2025-04-21 07:40:11','2025-04-21 07:40:11'),(30,'Update Customers Groups','nexopos.update.customers-groups','Let the user update Customers Groups','2025-04-21 07:40:11','2025-04-21 07:40:11'),(31,'Read Customers Groups','nexopos.read.customers-groups','Let the user read Customers Groups','2025-04-21 07:40:11','2025-04-21 07:40:11'),(32,'Create Coupons','nexopos.create.coupons','Let the user create coupons','2025-04-21 07:40:11','2025-04-21 07:40:11'),(33,'Delete Coupons','nexopos.delete.coupons','Let the user delete coupons','2025-04-21 07:40:11','2025-04-21 07:40:11'),(34,'Update Coupons','nexopos.update.coupons','Let the user update coupons','2025-04-21 07:40:11','2025-04-21 07:40:11'),(35,'Read Coupons','nexopos.read.coupons','Let the user read coupons','2025-04-21 07:40:11','2025-04-21 07:40:11'),(36,'Create Transaction Account','nexopos.create.transactions-account','Let the user create transactions account','2025-04-21 07:40:11','2025-04-21 07:40:11'),(37,'Delete Transactions Account','nexopos.delete.transactions-account','Let the user delete Transaction Account','2025-04-21 07:40:11','2025-04-21 07:40:11'),(38,'Update Transactions Account','nexopos.update.transactions-account','Let the user update Transaction Account','2025-04-21 07:40:11','2025-04-21 07:40:11'),(39,'Read Transactions Account','nexopos.read.transactions-account','Let the user read Transaction Account','2025-04-21 07:40:11','2025-04-21 07:40:11'),(40,'Create Transaction','nexopos.create.transactions','Let the user create transactions','2025-04-21 07:40:11','2025-04-21 07:40:11'),(41,'Delete Transaction','nexopos.delete.transactions','Let the user delete transactions','2025-04-21 07:40:11','2025-04-21 07:40:11'),(42,'Update Transaction','nexopos.update.transactions','Let the user update transactions','2025-04-21 07:40:11','2025-04-21 07:40:11'),(43,'Read Transaction','nexopos.read.transactions','Let the user read transactions','2025-04-21 07:40:11','2025-04-21 07:40:11'),(44,'Read Transactions History','nexopos.read.transactions-history','Give access to the transactions history.','2025-04-21 07:40:11','2025-04-21 07:40:11'),(45,'Delete Transactions History','nexopos.delete.transactions-history','Allow to delete an Transactions History.','2025-04-21 07:40:11','2025-04-21 07:40:11'),(46,'Update Transactions History','nexopos.update.transactions-history','Allow to the Transactions History.','2025-04-21 07:40:11','2025-04-21 07:40:11'),(47,'Create Transactions History','nexopos.create.transactions-history','Allow to create a Transactions History.','2025-04-21 07:40:11','2025-04-21 07:40:11'),(48,'Create Orders','nexopos.create.orders','Let the user create orders','2025-04-21 07:40:11','2025-04-21 07:40:11'),(49,'Delete Orders','nexopos.delete.orders','Let the user delete orders','2025-04-21 07:40:12','2025-04-21 07:40:12'),(50,'Update Orders','nexopos.update.orders','Let the user update orders','2025-04-21 07:40:12','2025-04-21 07:40:12'),(51,'Read Orders','nexopos.read.orders','Let the user read orders','2025-04-21 07:40:12','2025-04-21 07:40:12'),(52,'Void Order','nexopos.void.orders','Let the user void orders','2025-04-21 07:40:12','2025-04-21 07:40:12'),(53,'Refund Order','nexopos.refund.orders','Let the user refund orders','2025-04-21 07:40:12','2025-04-21 07:40:12'),(54,'Make Payment To orders','nexopos.make-payment.orders','Allow the user to make payments to orders.','2025-04-21 07:40:12','2025-04-21 07:40:12'),(55,'Create Procurements','nexopos.create.procurements','Let the user create procurements','2025-04-21 07:40:12','2025-04-21 07:40:12'),(56,'Delete Procurements','nexopos.delete.procurements','Let the user delete procurements','2025-04-21 07:40:12','2025-04-21 07:40:12'),(57,'Update Procurements','nexopos.update.procurements','Let the user update procurements','2025-04-21 07:40:12','2025-04-21 07:40:12'),(58,'Read Procurements','nexopos.read.procurements','Let the user read procurements','2025-04-21 07:40:12','2025-04-21 07:40:12'),(59,'Create Providers','nexopos.create.providers','Let the user create providers','2025-04-21 07:40:12','2025-04-21 07:40:12'),(60,'Delete Providers','nexopos.delete.providers','Let the user delete providers','2025-04-21 07:40:12','2025-04-21 07:40:12'),(61,'Update Providers','nexopos.update.providers','Let the user update providers','2025-04-21 07:40:12','2025-04-21 07:40:12'),(62,'Read Providers','nexopos.read.providers','Let the user read providers','2025-04-21 07:40:12','2025-04-21 07:40:12'),(63,'Create Products','nexopos.create.products','Let the user create products','2025-04-21 07:40:12','2025-04-21 07:40:12'),(64,'Delete Products','nexopos.delete.products','Let the user delete products','2025-04-21 07:40:12','2025-04-21 07:40:12'),(65,'Update Products','nexopos.update.products','Let the user update products','2025-04-21 07:40:12','2025-04-21 07:40:12'),(66,'Read Products','nexopos.read.products','Let the user read products','2025-04-21 07:40:12','2025-04-21 07:40:12'),(67,'Read Product History','nexopos.read.products-history','Let the user read products history','2025-04-21 07:40:12','2025-04-21 07:40:12'),(68,'Adjust Product Stock','nexopos.make.products-adjustments','Let the user adjust product stock.','2025-04-21 07:40:12','2025-04-21 07:40:12'),(69,'Create Product Units/Unit Group','nexopos.create.products-units','Let the user create products units.','2025-04-21 07:40:12','2025-04-21 07:40:12'),(70,'Read Product Units/Unit Group','nexopos.read.products-units','Let the user read products units.','2025-04-21 07:40:12','2025-04-21 07:40:12'),(71,'Update Product Units/Unit Group','nexopos.update.products-units','Let the user update products units.','2025-04-21 07:40:12','2025-04-21 07:40:12'),(72,'Delete Product Units/Unit Group','nexopos.delete.products-units','Let the user delete products units.','2025-04-21 07:40:12','2025-04-21 07:40:12'),(73,'Create Registers','nexopos.create.registers','Let the user create registers','2025-04-21 07:40:12','2025-04-21 07:40:12'),(74,'Delete Registers','nexopos.delete.registers','Let the user delete registers','2025-04-21 07:40:12','2025-04-21 07:40:12'),(75,'Update Registers','nexopos.update.registers','Let the user update registers','2025-04-21 07:40:12','2025-04-21 07:40:12'),(76,'Read Registers','nexopos.read.registers','Let the user read registers','2025-04-21 07:40:12','2025-04-21 07:40:12'),(77,'Read Registers History','nexopos.read.registers-history','Let the user read registers history','2025-04-21 07:40:12','2025-04-21 07:40:12'),(78,'Read Use Registers','nexopos.use.registers','Let the user use registers','2025-04-21 07:40:12','2025-04-21 07:40:12'),(79,'Create Rewards','nexopos.create.rewards','Let the user create Rewards','2025-04-21 07:40:12','2025-04-21 07:40:12'),(80,'Delete Rewards','nexopos.delete.rewards','Let the user delete Rewards','2025-04-21 07:40:12','2025-04-21 07:40:12'),(81,'Update Rewards','nexopos.update.rewards','Let the user update Rewards','2025-04-21 07:40:12','2025-04-21 07:40:12'),(82,'Read Rewards','nexopos.read.rewards','Let the user read Rewards','2025-04-21 07:40:12','2025-04-21 07:40:12'),(83,'Create Taxes','nexopos.create.taxes','Let the user create taxes','2025-04-21 07:40:12','2025-04-21 07:40:12'),(84,'Delete Taxes','nexopos.delete.taxes','Let the user delete taxes','2025-04-21 07:40:12','2025-04-21 07:40:12'),(85,'Update Taxes','nexopos.update.taxes','Let the user update taxes','2025-04-21 07:40:12','2025-04-21 07:40:12'),(86,'Read Taxes','nexopos.read.taxes','Let the user read taxes','2025-04-21 07:40:12','2025-04-21 07:40:12'),(87,'See Sale Report','nexopos.reports.sales','Let you see the sales report','2025-04-21 07:40:12','2025-04-21 07:40:12'),(88,'See Products Report','nexopos.reports.products-report','Let you see the Products report','2025-04-21 07:40:12','2025-04-21 07:40:12'),(89,'See Best Report','nexopos.reports.best_sales','Let you see the best_sales report','2025-04-21 07:40:12','2025-04-21 07:40:12'),(90,'See Transaction Report','nexopos.reports.transactions','Let you see the transactions report','2025-04-21 07:40:12','2025-04-21 07:40:12'),(91,'See Yearly Sales','nexopos.reports.yearly','Allow to see the yearly sales.','2025-04-21 07:40:12','2025-04-21 07:40:12'),(92,'See Customers','nexopos.reports.customers','Allow to see the customers','2025-04-21 07:40:12','2025-04-21 07:40:12'),(93,'See Inventory Tracking','nexopos.reports.inventory','Allow to see the inventory','2025-04-21 07:40:12','2025-04-21 07:40:12'),(94,'See Customers Statement','nexopos.reports.customers-statement','Allow to see the customers statement.','2025-04-21 07:40:12','2025-04-21 07:40:12'),(95,'Read Sales by Payment Types','nexopos.reports.payment-types','Let the user read the report that shows sales by payment types.','2025-04-21 07:40:12','2025-04-21 07:40:12'),(96,'Read Low Stock Report','nexopos.reports.low-stock','Let the user read the report that shows low stock.','2025-04-21 07:40:13','2025-04-21 07:40:13'),(97,'Read Stock History','nexopos.reports.stock-history','Let the user read the stock history report.','2025-04-21 07:40:13','2025-04-21 07:40:13'),(98,'Manage Order Payments','nexopos.manage-payments-types','Allow to create, update and delete payments type.','2025-04-21 07:40:13','2025-04-21 07:40:13'),(99,'Edit Purchase Price','nexopos.pos.edit-purchase-price','Let the user edit the purchase price of products.','2025-04-21 07:40:13','2025-04-21 07:40:13'),(100,'Edit Order Settings','nexopos.pos.edit-settings','Let the user edit the order settings.','2025-04-21 07:40:13','2025-04-21 07:40:13'),(101,'Edit Product Discounts','nexopos.pos.products-discount','Let the user add discount on products.','2025-04-21 07:40:13','2025-04-21 07:40:13'),(102,'Edit Cart Discounts','nexopos.pos.cart-discount','Let the user add discount on cart.','2025-04-21 07:40:13','2025-04-21 07:40:13'),(103,'POS: Delete Order Products','nexopos.pos.delete-order-product','Let the user delete order products on POS.','2025-04-21 07:40:13','2025-04-21 07:40:13'),(104,'Widget: Incomplete Sale Card Widget','nexopos.see.incomplete-sale-card-widget','Will display a card of current and overall incomplete sales.','2025-04-21 07:40:13','2025-04-21 07:40:13'),(105,'Widget: Expense Card Widget','nexopos.see.expense-card-widget','Will display a card of current and overwall expenses.','2025-04-21 07:40:13','2025-04-21 07:40:13'),(106,'Widget: Sale Card Widget','nexopos.see.sale-card-widget','Will display current and overall sales.','2025-04-21 07:40:13','2025-04-21 07:40:13'),(107,'Widget: Best Customers','nexopos.see.best-customers-widget','Will display all customers with the highest purchases.','2025-04-21 07:40:13','2025-04-21 07:40:13'),(108,'Widget: Profile','nexopos.see.profile-widget','Will display a profile widget with user stats.','2025-04-21 07:40:13','2025-04-21 07:40:13'),(109,'Widget: Orders Chart','nexopos.see.orders-chart-widget','Will display a chart of weekly sales.','2025-04-21 07:40:13','2025-04-21 07:40:13'),(110,'Widget: Orders Summary','nexopos.see.orders-summary-widget','Will display a summary of recent sales.','2025-04-21 07:40:13','2025-04-21 07:40:13'),(111,'Widget: Best Cashiers','nexopos.see.best-cashier-widget','Will display all cashiers who performs well.','2025-04-21 07:40:13','2025-04-21 07:40:13'),(112,'Create Brands','nexopos.create.brands','Let the user create brands','2025-04-21 07:40:13','2025-04-21 07:40:13'),(113,'Delete Brands','nexopos.delete.brands','Let the user delete brands','2025-04-21 07:40:13','2025-04-21 07:40:13'),(114,'Update Brands','nexopos.update.brands','Let the user update brands','2025-04-21 07:40:13','2025-04-21 07:40:13'),(115,'Read Brands','nexopos.read.brands','Let the user read brands','2025-04-21 07:40:13','2025-04-21 07:40:13'),(116,'Read Cash Flow History','nexopos.read.cash-flow-history','Allow to the Cash Flow History.','2025-04-21 07:40:20','2025-04-21 07:40:20'),(117,'Delete Expense History','nexopos.delete.cash-flow-history','Allow to delete an expense history.','2025-04-21 07:40:20','2025-04-21 07:40:20'),(118,'Manage Customers Account','nexopos.customers.manage-account','Allow to manage customer virtual deposit account.','2025-04-21 07:40:20','2025-04-21 07:40:20'),(119,'Create Products Labels','nexopos.create.products-labels','Allow the user to create products labels','2025-04-21 07:40:20','2025-04-21 07:40:20'),(120,'Create Instalment','nexopos.create.orders-instalments','Allow the user to create instalments.','2025-04-21 07:40:35','2025-04-21 07:40:35'),(121,'Update Instalment','nexopos.update.orders-instalments','Allow the user to update instalments.','2025-04-21 07:40:35','2025-04-21 07:40:35'),(122,'Read Instalment','nexopos.read.orders-instalments','Allow the user to read instalments.','2025-04-21 07:40:35','2025-04-21 07:40:35'),(123,'Delete Instalment','nexopos.delete.orders-instalments','Allow the user to delete instalments.','2025-04-21 07:40:35','2025-04-21 07:40:35');

--
-- Table structure for table `ns_nexopos_procurements`
--

CREATE TABLE `ns_nexopos_procurements` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `procurement_parent_id` int DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `procurement_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `provider_id` int NOT NULL,
  `location` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_term` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_mode` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value` float NOT NULL DEFAULT '0',
  `cost` float NOT NULL DEFAULT '0',
  `tax_value` float NOT NULL DEFAULT '0',
  `invoice_reference` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `automatic_approval` tinyint(1) DEFAULT '0',
  `delivery_time` datetime DEFAULT NULL,
  `invoice_date` datetime DEFAULT NULL,
  `payment_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'unpaid',
  `delivery_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `total_items` int NOT NULL DEFAULT '0',
  `description` text COLLATE utf8mb4_unicode_ci,
  `author` int NOT NULL,
  `updated_by` int DEFAULT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_procurements`
--

INSERT INTO `ns_nexopos_procurements` (`id`, `procurement_parent_id`, `name`, `procurement_type`, `provider_id`, `location`, `payment_term`, `payment_mode`, `value`, `cost`, `tax_value`, `invoice_reference`, `automatic_approval`, `delivery_time`, `invoice_date`, `payment_status`, `delivery_status`, `total_items`, `description`, `author`, `updated_by`, `uuid`, `created_at`, `updated_at`) VALUES (4,NULL,'P.O 00001','purchase_order',1,'store','1','cash',4000,4000,0,NULL,0,NULL,'2025-05-15 00:00:00','unpaid','pending',2,NULL,28,28,NULL,'2025-05-15 02:34:49','2025-05-15 02:34:49'),(5,4,'Procurement 00005 - G.R.N 00001','good_receive_note',1,'store','1','cash',0,0,0,NULL,0,NULL,'2025-05-15 00:00:00','unpaid','stocked',0,NULL,28,NULL,NULL,'2025-05-15 03:58:08','2025-05-15 03:58:08'),(6,4,'Procurement 00005 - G.R.N 00001','good_receive_note',1,'store','1','cash',0,0,0,NULL,0,NULL,'2025-05-15 00:00:00','unpaid','stocked',0,NULL,28,NULL,NULL,'2025-05-15 03:58:48','2025-05-15 03:58:48');

--
-- Table structure for table `ns_nexopos_procurements_products`
--

CREATE TABLE `ns_nexopos_procurements_products` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `master_product_id` int DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `gross_purchase_price` float NOT NULL DEFAULT '0',
  `net_purchase_price` float NOT NULL DEFAULT '0',
  `procurement_id` int NOT NULL,
  `product_id` int NOT NULL,
  `purchase_price` float NOT NULL DEFAULT '0',
  `quantity` float NOT NULL,
  `new_quantity_received` float NOT NULL DEFAULT '0',
  `foc_quantity` float NOT NULL,
  `available_quantity` float NOT NULL,
  `tax_group_id` int DEFAULT NULL,
  `barcode` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `expiration_date` datetime DEFAULT NULL,
  `tax_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tax_value` float NOT NULL DEFAULT '0',
  `total_purchase_price` float NOT NULL DEFAULT '0',
  `unit_id` int NOT NULL,
  `convert_unit_id` int DEFAULT NULL,
  `discount` float NOT NULL DEFAULT '0',
  `discount_extra` float NOT NULL DEFAULT '0',
  `author` int NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_procurements_products`
--

INSERT INTO `ns_nexopos_procurements_products` (`id`, `master_product_id`, `name`, `gross_purchase_price`, `net_purchase_price`, `procurement_id`, `product_id`, `purchase_price`, `quantity`, `new_quantity_received`, `foc_quantity`, `available_quantity`, `tax_group_id`, `barcode`, `expiration_date`, `tax_type`, `tax_value`, `total_purchase_price`, `unit_id`, `convert_unit_id`, `discount`, `discount_extra`, `author`, `uuid`, `created_at`, `updated_at`) VALUES (1,NULL,'Tapal Danedar',70,70,4,1,70,10,0,0,10,0,NULL,NULL,'inclusive',0,700,1,NULL,0,0,28,NULL,'2025-05-15 02:34:49','2025-05-15 03:52:00'),(2,NULL,'Tapal Danedaar 1 kg',660,660,4,5,660,5,0,5,5,0,NULL,NULL,'inclusive',0,3300,1,NULL,0,0,28,NULL,'2025-05-15 02:34:49','2025-05-15 03:52:00'),(3,1,'Tapal Danedar',70,70,5,1,70,10,10,0,10,0,NULL,NULL,'inclusive',0,700,1,NULL,0,0,28,NULL,'2025-05-15 03:58:08','2025-05-15 03:58:08'),(4,2,'Tapal Danedaar 1 kg',660,660,5,5,660,5,5,0,5,0,NULL,NULL,'inclusive',0,3300,1,NULL,0,0,28,NULL,'2025-05-15 03:58:08','2025-05-15 03:58:08'),(5,1,'Tapal Danedar',70,70,6,1,70,0,0,0,0,0,NULL,NULL,'inclusive',0,700,1,NULL,0,0,28,NULL,'2025-05-15 03:58:48','2025-05-15 03:58:48'),(6,2,'Tapal Danedaar 1 kg',660,660,6,5,660,10,10,0,10,0,NULL,NULL,'inclusive',0,3300,1,NULL,0,0,28,NULL,'2025-05-15 03:58:48','2025-05-15 03:58:48');

--
-- Table structure for table `ns_nexopos_products`
--

CREATE TABLE `ns_nexopos_products` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `alias_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tax_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tax_group_id` int DEFAULT NULL,
  `tax_value` float NOT NULL DEFAULT '0',
  `product_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'product',
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'tangible',
  `brand_id` int DEFAULT NULL,
  `accurate_tracking` tinyint(1) NOT NULL DEFAULT '0',
  `auto_cogs` tinyint(1) NOT NULL DEFAULT '1',
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'available',
  `stock_management` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'enabled',
  `barcode` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `barcode_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sku` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `thumbnail_id` int DEFAULT NULL,
  `category_id` int DEFAULT NULL,
  `parent_id` int NOT NULL DEFAULT '0',
  `unit_group` int NOT NULL,
  `on_expiration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'prevent_sales',
  `expires` tinyint(1) NOT NULL DEFAULT '0',
  `searchable` tinyint(1) NOT NULL DEFAULT '1',
  `author` int NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_products`
--

INSERT INTO `ns_nexopos_products` (`id`, `name`, `alias_name`, `tax_type`, `tax_group_id`, `tax_value`, `product_type`, `type`, `brand_id`, `accurate_tracking`, `auto_cogs`, `status`, `stock_management`, `barcode`, `barcode_type`, `sku`, `description`, `thumbnail_id`, `category_id`, `parent_id`, `unit_group`, `on_expiration`, `expires`, `searchable`, `author`, `uuid`, `created_at`, `updated_at`) VALUES (1,'Tapal Danedar','Danedar','inclusive',NULL,0,'product','materialized',1,0,0,'available','enabled','WoxxDwXpbn','code128','tapal-danedar-tfsWo',NULL,NULL,1,0,1,'prevent_sales',0,1,28,NULL,'2025-04-21 07:40:41','2025-06-03 01:56:17'),(2,'Tapal Family Mixture','Family Mixture','inclusive',NULL,0,'product','materialized',1,0,0,'available','enabled','cMGEczfs2a','code128','tapal-danedar-mixture',NULL,NULL,1,0,1,'prevent_sales',0,1,28,NULL,'2025-04-21 07:40:41','2025-06-03 01:56:39'),(3,'Tapal Green Tea','Green Tea','inclusive',NULL,0,'product','materialized',1,0,0,'available','enabled','5Uu9z2llSW','code128','tapal-green-tea',NULL,NULL,1,0,1,'prevent_sales',0,1,28,NULL,'2025-04-21 07:40:41','2025-06-03 01:57:23'),(4,'Tapal Cardamom tea','Cardamom Tea','inclusive',NULL,0,'product','materialized',1,0,0,'available','enabled','TOhKM1Pd3D','code128','tapal-cardamom-tea',NULL,NULL,1,0,1,'prevent_sales',0,1,28,NULL,'2025-04-21 07:40:41','2025-06-03 01:57:38'),(5,'Tapal Danedaar 1 kg',NULL,'inclusive',NULL,0,'product','materialized',1,0,0,'available','enabled','NHLRsj7rwP','code128','tapal-danedaar-1-kg-dy8YM',NULL,NULL,1,0,1,'prevent-sales',0,1,28,NULL,'2025-05-15 02:11:02','2025-06-03 01:55:57');

--
-- Table structure for table `ns_nexopos_products_categories`
--

CREATE TABLE `ns_nexopos_products_categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `parent_id` int DEFAULT '0',
  `media_id` int NOT NULL DEFAULT '0',
  `preview_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `displays_on_pos` tinyint(1) NOT NULL DEFAULT '1',
  `total_items` int NOT NULL DEFAULT '0',
  `description` text COLLATE utf8mb4_unicode_ci,
  `author` int NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_products_categories`
--

INSERT INTO `ns_nexopos_products_categories` (`id`, `name`, `parent_id`, `media_id`, `preview_url`, `displays_on_pos`, `total_items`, `description`, `author`, `uuid`, `created_at`, `updated_at`) VALUES (1,'Beverages',0,0,NULL,1,0,NULL,28,NULL,'2025-04-21 07:40:41','2025-04-21 07:40:41'),(2,'edible oil',0,0,NULL,1,0,NULL,28,NULL,'2025-05-15 03:20:30','2025-05-15 03:20:30');

--
-- Table structure for table `ns_nexopos_products_galleries`
--

CREATE TABLE `ns_nexopos_products_galleries` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `product_id` int NOT NULL,
  `media_id` int DEFAULT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order` int NOT NULL DEFAULT '0',
  `featured` tinyint(1) NOT NULL DEFAULT '0',
  `author` int NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci 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;

--
-- Dumping data for table `ns_nexopos_products_galleries`
--


--
-- Table structure for table `ns_nexopos_products_histories`
--

CREATE TABLE `ns_nexopos_products_histories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `product_id` int NOT NULL,
  `procurement_id` int DEFAULT NULL,
  `procurement_product_id` int DEFAULT NULL,
  `order_id` int DEFAULT NULL,
  `order_product_id` int DEFAULT NULL,
  `operation_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `unit_id` int NOT NULL,
  `before_quantity` float DEFAULT NULL,
  `quantity` float NOT NULL,
  `after_quantity` float DEFAULT NULL,
  `unit_price` float NOT NULL,
  `total_price` float NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `author` int NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_products_histories`
--

INSERT INTO `ns_nexopos_products_histories` (`id`, `product_id`, `procurement_id`, `procurement_product_id`, `order_id`, `order_product_id`, `operation_type`, `unit_id`, `before_quantity`, `quantity`, `after_quantity`, `unit_price`, `total_price`, `description`, `author`, `uuid`, `created_at`, `updated_at`) VALUES (1,1,5,3,NULL,NULL,'procured',1,0,10,10,70,700,NULL,28,NULL,'2025-05-15 03:58:08','2025-05-15 03:58:08'),(2,5,5,4,NULL,NULL,'procured',1,0,5,5,660,3300,NULL,28,NULL,'2025-05-15 03:58:08','2025-05-15 03:58:08'),(3,1,6,5,NULL,NULL,'procured',1,10,0,10,70,700,NULL,28,NULL,'2025-05-15 03:58:48','2025-05-15 03:58:48'),(4,5,6,6,NULL,NULL,'procured',1,5,10,15,660,3300,NULL,28,NULL,'2025-05-15 03:58:48','2025-05-15 03:58:48'),(5,1,NULL,NULL,1,1,'sold',1,10,2,8,70,140,'',28,NULL,'2025-05-22 04:05:35','2025-05-22 04:05:35'),(6,5,NULL,NULL,2,2,'sold',1,15,2,13,570,1140,'',28,NULL,'2025-06-03 03:07:31','2025-06-03 03:07:31'),(7,5,NULL,NULL,2,3,'sold',1,13,1,12,660,660,'',28,NULL,'2025-06-03 03:07:34','2025-06-03 03:07:34'),(8,5,NULL,NULL,2,4,'sold',1,12,1,11,660,660,'',28,NULL,'2025-06-03 03:07:35','2025-06-03 03:07:35'),(9,1,NULL,NULL,3,5,'sold',1,8,1,7,70,66.5,'',28,NULL,'2025-06-03 03:09:10','2025-06-03 03:09:10'),(10,1,NULL,NULL,4,6,'sold',1,7,1,6,70,68.6,'',28,NULL,'2025-06-03 03:12:02','2025-06-03 03:12:02'),(11,5,NULL,NULL,5,7,'sold',1,11,1,10,570,570,'',28,NULL,'2025-06-03 03:14:44','2025-06-03 03:14:44'),(12,1,NULL,NULL,5,8,'sold',1,6,1,5,70,70,'',28,NULL,'2025-06-03 03:14:44','2025-06-03 03:14:44'),(13,1,NULL,NULL,6,9,'sold',1,5,1,4,70,70,'',28,NULL,'2025-06-03 03:15:28','2025-06-03 03:15:28'),(14,5,NULL,NULL,7,10,'sold',1,10,1,9,660,660,'',28,NULL,'2025-06-03 03:20:16','2025-06-03 03:20:16'),(15,1,NULL,NULL,8,11,'sold',1,4,1,3,70,70,'',28,NULL,'2025-06-03 03:29:18','2025-06-03 03:29:18'),(16,1,NULL,NULL,9,12,'sold',1,3,0,3,70,0,'',28,NULL,'2025-06-03 08:18:35','2025-06-03 08:18:35'),(17,1,NULL,NULL,10,13,'sold',1,3,0,3,70,0,'',28,NULL,'2025-06-03 08:22:37','2025-06-03 08:22:37'),(18,1,NULL,NULL,11,14,'sold',1,3,1,2,70,70,'',28,NULL,'2025-06-03 08:23:37','2025-06-03 08:23:37'),(19,1,NULL,NULL,12,15,'sold',1,2,1,1,70,70,'',28,NULL,'2025-06-03 08:41:19','2025-06-03 08:41:19'),(20,1,NULL,NULL,13,16,'sold',1,1,1,0,70,70,'',28,NULL,'2025-06-03 08:41:58','2025-06-03 08:41:58'),(21,5,NULL,NULL,14,17,'sold',1,9,2,7,660,1320,'',28,NULL,'2025-06-03 08:44:48','2025-06-03 08:44:48'),(22,5,NULL,NULL,15,18,'sold',1,7,1,6,660,660,'',28,NULL,'2025-06-03 08:48:29','2025-06-03 08:48:29'),(23,5,NULL,NULL,16,19,'sold',1,6,1,5,660,660,'',28,NULL,'2025-06-03 08:54:16','2025-06-03 08:54:16'),(24,5,NULL,NULL,17,20,'sold',1,5,1,4,660,660,'',28,NULL,'2025-06-03 08:56:41','2025-06-03 08:56:41'),(25,5,NULL,NULL,18,21,'sold',1,4,1,3,660,660,'',28,NULL,'2025-06-13 01:52:13','2025-06-13 01:52:13'),(26,5,NULL,NULL,19,22,'sold',1,3,1,2,660,660,'',28,NULL,'2025-06-16 01:50:37','2025-06-16 01:50:37'),(27,5,NULL,NULL,20,23,'sold',1,2,1,1,660,660,'',28,NULL,'2025-06-16 02:01:28','2025-06-16 02:01:28'),(28,5,NULL,NULL,21,24,'sold',1,1,1,0,660,660,'',28,NULL,'2025-06-16 02:02:06','2025-06-16 02:02:06'),(29,5,NULL,NULL,21,24,'returned',1,0,1,1,660,660,'',28,NULL,'2025-06-17 02:11:25','2025-06-17 02:11:25');

--
-- Table structure for table `ns_nexopos_products_histories_combined`
--

CREATE TABLE `ns_nexopos_products_histories_combined` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` date NOT NULL,
  `product_id` int NOT NULL,
  `unit_id` int NOT NULL,
  `initial_quantity` double NOT NULL DEFAULT '0',
  `sold_quantity` double NOT NULL DEFAULT '0',
  `procured_quantity` double NOT NULL DEFAULT '0',
  `defective_quantity` double NOT NULL DEFAULT '0',
  `final_quantity` double NOT NULL DEFAULT '0',
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_products_histories_combined`
--

INSERT INTO `ns_nexopos_products_histories_combined` (`id`, `name`, `date`, `product_id`, `unit_id`, `initial_quantity`, `sold_quantity`, `procured_quantity`, `defective_quantity`, `final_quantity`, `uuid`, `created_at`, `updated_at`) VALUES (1,'Tapal Danedar','2025-05-15',1,1,0,0,10,0,10,NULL,'2025-05-15 03:58:08','2025-05-15 03:58:08'),(2,'Tapal Danedaar 1 kg','2025-05-15',5,1,0,0,15,0,15,NULL,'2025-05-15 03:58:08','2025-05-15 03:58:48'),(3,'Tapal Danedar','2025-05-22',1,1,10,2,0,0,8,NULL,'2025-05-22 04:05:35','2025-05-22 04:05:35'),(4,'Tapal Danedaar 1 kg','2025-06-03',5,1,15,11,0,0,4,NULL,'2025-06-03 03:07:32','2025-06-03 08:56:41'),(5,'Tapal Danedar','2025-06-03',1,1,8,8,0,0,0,NULL,'2025-06-03 03:09:11','2025-06-03 08:41:59'),(6,'Tapal Danedaar 1 kg','2025-06-13',5,1,4,1,0,0,3,NULL,'2025-06-13 01:52:13','2025-06-13 01:52:13'),(7,'Tapal Danedaar 1 kg','2025-06-16',5,1,3,3,0,0,0,NULL,'2025-06-16 01:50:37','2025-06-16 02:02:06'),(8,'Tapal Danedaar 1 kg','2025-06-17',5,1,0,0,1,0,1,NULL,'2025-06-17 02:11:25','2025-06-17 02:11:25');

--
-- Table structure for table `ns_nexopos_products_subitems`
--

CREATE TABLE `ns_nexopos_products_subitems` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` int NOT NULL,
  `product_id` int NOT NULL,
  `unit_id` int NOT NULL,
  `unit_quantity_id` int NOT NULL,
  `sale_price` double NOT NULL DEFAULT '0',
  `quantity` double NOT NULL DEFAULT '0',
  `total_price` double NOT NULL DEFAULT '0',
  `author` 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;

--
-- Dumping data for table `ns_nexopos_products_subitems`
--


--
-- Table structure for table `ns_nexopos_products_taxes`
--

CREATE TABLE `ns_nexopos_products_taxes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `product_id` int NOT NULL,
  `unit_quantity_id` int NOT NULL,
  `tax_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `rate` float NOT NULL,
  `value` float NOT NULL,
  `author` int NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci 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;

--
-- Dumping data for table `ns_nexopos_products_taxes`
--


--
-- Table structure for table `ns_nexopos_products_unit_quantities`
--

CREATE TABLE `ns_nexopos_products_unit_quantities` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `product_id` int NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'product',
  `preview_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `expiration_date` datetime DEFAULT NULL,
  `unit_id` int NOT NULL,
  `barcode` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quantity` float NOT NULL,
  `low_quantity` float NOT NULL DEFAULT '0',
  `stock_alert_enabled` tinyint(1) NOT NULL DEFAULT '0',
  `sale_price` float NOT NULL DEFAULT '0',
  `sale_price_edit` float NOT NULL DEFAULT '0',
  `sale_price_without_tax` float NOT NULL DEFAULT '0',
  `sale_price_with_tax` float NOT NULL DEFAULT '0',
  `sale_price_tax` float NOT NULL DEFAULT '0',
  `wholesale_price` float NOT NULL DEFAULT '0',
  `wholesale_price_edit` float NOT NULL DEFAULT '0',
  `wholesale_price_with_tax` float NOT NULL DEFAULT '0',
  `wholesale_price_without_tax` float NOT NULL DEFAULT '0',
  `wholesale_price_tax` float NOT NULL DEFAULT '0',
  `custom_price` float NOT NULL DEFAULT '0',
  `custom_price_edit` float NOT NULL DEFAULT '0',
  `custom_price_with_tax` float NOT NULL DEFAULT '0',
  `custom_price_without_tax` float NOT NULL DEFAULT '0',
  `custom_price_tax` float NOT NULL DEFAULT '0',
  `visible` tinyint(1) NOT NULL DEFAULT '1',
  `convert_unit_id` int DEFAULT NULL,
  `cogs` double NOT NULL DEFAULT '0',
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_products_unit_quantities`
--

INSERT INTO `ns_nexopos_products_unit_quantities` (`id`, `product_id`, `type`, `preview_url`, `expiration_date`, `unit_id`, `barcode`, `quantity`, `low_quantity`, `stock_alert_enabled`, `sale_price`, `sale_price_edit`, `sale_price_without_tax`, `sale_price_with_tax`, `sale_price_tax`, `wholesale_price`, `wholesale_price_edit`, `wholesale_price_with_tax`, `wholesale_price_without_tax`, `wholesale_price_tax`, `custom_price`, `custom_price_edit`, `custom_price_with_tax`, `custom_price_without_tax`, `custom_price_tax`, `visible`, `convert_unit_id`, `cogs`, `uuid`, `created_at`, `updated_at`) VALUES (1,1,'product','',NULL,1,'WoxxDwXpbn-1',0,3,1,70,70,70,70,0,60,60,60,60,0,0,0,0,0,0,1,NULL,0,NULL,'2025-04-21 07:40:41','2025-06-03 08:41:58'),(2,2,'product','',NULL,1,'cMGEczfs2a-2',0,3,1,75,75,75,75,0,65,65,65,65,0,0,0,0,0,0,1,NULL,0,NULL,'2025-04-21 07:40:41','2025-06-03 01:56:40'),(3,3,'product','',NULL,1,'5Uu9z2llSW-3',0,3,1,58,58,58,58,0,56,56,56,56,0,0,0,0,0,0,1,NULL,0,NULL,'2025-04-21 07:40:41','2025-06-03 01:57:23'),(4,4,'product','',NULL,1,'TOhKM1Pd3D-4',0,3,1,82,82,82,82,0,76,76,76,76,0,0,0,0,0,0,1,NULL,0,NULL,'2025-04-21 07:40:41','2025-06-03 01:57:38'),(5,5,'product','',NULL,1,'NHLRsj7rwP-5',1,3,1,660,660,660,660,0,570,570,570,570,0,0,0,0,0,0,1,NULL,0,NULL,'2025-05-15 02:11:02','2025-06-17 02:11:25');

--
-- Table structure for table `ns_nexopos_providers`
--

CREATE TABLE `ns_nexopos_providers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `active` tinyint(1) NOT NULL DEFAULT '0',
  `first_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_1` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `postal_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ntn_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gst_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `provider_category` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `provider_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bank_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `account_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_mode` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_term` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `balance_limit` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `wht_rate` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `excise_duty_rate` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `special_discount_rate` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `regular_discount_rate` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `primary_contact_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `primary_contact_phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `primary_contact_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `primary_contact_nic` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `secondary_contact_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `secondary_contact_phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `secondary_contact_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `secondary_contact_nic` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `author` int NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `amount_due` float NOT NULL DEFAULT '0',
  `amount_paid` float NOT NULL DEFAULT '0',
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ns_nexopos_providers_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_providers`
--

INSERT INTO `ns_nexopos_providers` (`id`, `active`, `first_name`, `last_name`, `email`, `city`, `phone`, `address_1`, `address_2`, `postal_code`, `ntn_no`, `gst_no`, `provider_category`, `provider_type`, `bank_name`, `account_number`, `payment_mode`, `payment_term`, `balance_limit`, `wht_rate`, `excise_duty_rate`, `special_discount_rate`, `regular_discount_rate`, `primary_contact_name`, `primary_contact_phone`, `primary_contact_email`, `primary_contact_nic`, `secondary_contact_name`, `secondary_contact_phone`, `secondary_contact_email`, `secondary_contact_nic`, `author`, `description`, `amount_due`, `amount_paid`, `uuid`, `created_at`, `updated_at`) VALUES (1,1,'Tapal Vendor',NULL,'tapal@gmail.com',NULL,'03121234567','Tapal vendor, Karachi Region',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,28,NULL,4000,0,NULL,'2025-04-21 07:40:41','2025-05-15 03:58:08'),(2,1,'OPTIMUS PHARMA (PVT) LTD',NULL,'OPTIMUSPHARMA@GMAIL.COM','Lahore','04235186994','259-F/1 Block, Wapda Town, Lahore',NULL,NULL,NULL,NULL,'Produce_Suppliers','Wholesale_Distributor','Habib Bank Limited','12487992356103','credit','30_days','250000',NULL,NULL,NULL,NULL,'Muhammad Amir Fazal','03085341840',NULL,NULL,NULL,NULL,NULL,NULL,28,NULL,0,0,NULL,'2025-05-20 04:22:58','2025-05-20 04:22:58'),(3,1,'VEGA PHARMA (PVT) LTD',NULL,'VEGAPHARMA@GMAIL.COM','Lahore','04235793074','30Km- Multan Road, Lahore',NULL,NULL,NULL,NULL,NULL,NULL,'MEEZAN BANK','02901077237939','credit','30_days','250000',NULL,NULL,NULL,NULL,'Muhammad Nabeel','03004914540',NULL,NULL,NULL,NULL,NULL,NULL,28,NULL,0,0,NULL,'2025-05-20 04:29:25','2025-05-20 04:29:25');

--
-- Table structure for table `ns_nexopos_registers`
--

CREATE TABLE `ns_nexopos_registers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'closed',
  `description` text COLLATE utf8mb4_unicode_ci,
  `used_by` int DEFAULT NULL,
  `author` int NOT NULL,
  `balance` float NOT NULL DEFAULT '0',
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci 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;

--
-- Dumping data for table `ns_nexopos_registers`
--


--
-- Table structure for table `ns_nexopos_registers_history`
--

CREATE TABLE `ns_nexopos_registers_history` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `register_id` int NOT NULL,
  `payment_id` int DEFAULT NULL,
  `payment_type_id` int NOT NULL DEFAULT '0',
  `order_id` int DEFAULT NULL,
  `action` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `author` int NOT NULL,
  `value` float NOT NULL DEFAULT '0',
  `description` text COLLATE utf8mb4_unicode_ci,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `balance_before` float NOT NULL DEFAULT '0',
  `transaction_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `balance_after` float 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;

--
-- Dumping data for table `ns_nexopos_registers_history`
--


--
-- Table structure for table `ns_nexopos_rewards_system`
--

CREATE TABLE `ns_nexopos_rewards_system` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `author` int NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `target` float NOT NULL DEFAULT '0',
  `description` text COLLATE utf8mb4_unicode_ci,
  `coupon_id` int DEFAULT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci 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;

--
-- Dumping data for table `ns_nexopos_rewards_system`
--


--
-- Table structure for table `ns_nexopos_rewards_system_rules`
--

CREATE TABLE `ns_nexopos_rewards_system_rules` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `from` float NOT NULL,
  `to` float NOT NULL,
  `reward` float NOT NULL,
  `reward_id` int NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `author` 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;

--
-- Dumping data for table `ns_nexopos_rewards_system_rules`
--


--
-- Table structure for table `ns_nexopos_role_permission`
--

CREATE TABLE `ns_nexopos_role_permission` (
  `permission_id` int NOT NULL,
  `role_id` int NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_role_permission`
--

INSERT INTO `ns_nexopos_role_permission` (`permission_id`, `role_id`) VALUES (1,2),(2,2),(3,2),(4,2),(5,2),(6,2),(7,2),(8,2),(9,2),(10,1),(10,2),(10,3),(10,4),(10,5),(11,2),(12,2),(13,2),(13,3),(13,4),(13,5),(14,2),(15,2),(16,2),(17,2),(18,2),(18,3),(19,2),(19,3),(20,2),(20,3),(21,2),(21,3),(22,2),(22,3),(23,2),(23,3),(24,2),(24,3),(25,2),(25,3),(26,2),(26,3),(27,2),(27,3),(27,4),(28,2),(28,3),(29,2),(29,3),(30,2),(30,3),(31,2),(31,3),(32,2),(32,3),(33,2),(33,3),(34,2),(34,3),(35,2),(35,3),(36,2),(36,3),(37,2),(37,3),(38,2),(38,3),(39,2),(39,3),(40,2),(40,3),(41,2),(41,3),(42,2),(42,3),(43,2),(43,3),(44,2),(44,3),(45,2),(45,3),(46,2),(46,3),(47,2),(47,3),(48,2),(48,3),(48,4),(49,2),(49,3),(50,2),(50,3),(50,4),(51,2),(51,3),(51,4),(52,2),(52,3),(52,4),(53,2),(53,3),(53,4),(54,2),(54,3),(54,4),(55,2),(55,3),(56,2),(56,3),(57,2),(57,3),(58,2),(58,3),(59,2),(59,3),(60,2),(60,3),(61,2),(61,3),(62,2),(62,3),(63,2),(63,3),(64,2),(64,3),(65,2),(65,3),(66,2),(66,3),(67,2),(67,3),(68,2),(68,3),(69,2),(69,3),(70,2),(70,3),(71,2),(71,3),(72,2),(72,3),(73,2),(73,3),(74,2),(74,3),(75,2),(75,3),(76,2),(76,3),(77,2),(77,3),(78,2),(78,3),(79,2),(79,3),(80,2),(80,3),(81,2),(81,3),(82,2),(82,3),(83,2),(83,3),(84,2),(84,3),(85,2),(85,3),(86,2),(86,3),(87,2),(87,3),(88,2),(88,3),(89,2),(89,3),(90,2),(90,3),(91,2),(91,3),(92,2),(92,3),(93,2),(93,3),(94,2),(94,3),(95,2),(95,3),(96,2),(96,3),(97,2),(97,3),(98,2),(98,3),(99,2),(99,3),(99,4),(100,2),(100,3),(100,4),(101,2),(101,3),(101,4),(102,2),(102,3),(102,4),(103,2),(103,3),(103,4),(104,2),(104,3),(105,2),(105,3),(106,2),(106,3),(107,2),(107,3),(108,1),(108,2),(108,3),(108,4),(108,5),(109,2),(109,3),(110,2),(110,3),(111,2),(111,3),(112,2),(113,2),(114,2),(115,2),(116,2),(116,3),(117,2),(117,3),(118,2),(118,3),(119,2),(119,3),(120,2),(120,3),(121,2),(121,3),(122,2),(122,3),(123,2),(123,3);

--
-- Table structure for table `ns_nexopos_roles`
--

CREATE TABLE `ns_nexopos_roles` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `namespace` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `reward_system_id` int DEFAULT NULL,
  `minimal_credit_payment` double NOT NULL DEFAULT '0',
  `author` int DEFAULT NULL,
  `locked` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ns_nexopos_roles_name_unique` (`name`),
  UNIQUE KEY `ns_nexopos_roles_namespace_unique` (`namespace`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_roles`
--

INSERT INTO `ns_nexopos_roles` (`id`, `name`, `namespace`, `description`, `reward_system_id`, `minimal_credit_payment`, `author`, `locked`, `created_at`, `updated_at`) VALUES (1,'User','user','Basic user role.',NULL,0,NULL,1,'2025-04-21 07:40:13','2025-04-21 07:40:13'),(2,'Administrator','admin','Master role which can perform all actions like create users, install/update/delete modules and much more.',NULL,0,NULL,1,'2025-04-21 07:40:13','2025-04-21 07:40:13'),(3,'Store Administrator','nexopos.store.administrator','Has a control over an entire store of NexoPOS.',NULL,0,NULL,1,'2025-04-21 07:40:16','2025-04-21 07:40:16'),(4,'Store Cashier','nexopos.store.cashier','Has a control over the sale process.',NULL,0,NULL,1,'2025-04-21 07:40:18','2025-04-21 07:40:18'),(5,'Store Customer','nexopos.store.customer','Can purchase orders and manage his profile.',NULL,0,NULL,1,'2025-04-21 07:40:19','2025-04-21 07:40:19');

--
-- Table structure for table `ns_nexopos_taxes`
--

CREATE TABLE `ns_nexopos_taxes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `rate` float NOT NULL,
  `tax_group_id` int NOT NULL,
  `author` int NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_taxes`
--

INSERT INTO `ns_nexopos_taxes` (`id`, `name`, `description`, `rate`, `tax_group_id`, `author`, `uuid`, `created_at`, `updated_at`) VALUES (1,'Sales Tax','Sales Tax Description',17,1,28,NULL,'2025-04-21 07:40:41','2025-04-21 07:40:41');

--
-- Table structure for table `ns_nexopos_taxes_groups`
--

CREATE TABLE `ns_nexopos_taxes_groups` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `author` int NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_taxes_groups`
--

INSERT INTO `ns_nexopos_taxes_groups` (`id`, `name`, `description`, `author`, `uuid`, `created_at`, `updated_at`) VALUES (1,'Government Taxes',NULL,28,NULL,'2025-04-21 07:40:41','2025-04-21 07:40:41');

--
-- Table structure for table `ns_nexopos_transactions`
--

CREATE TABLE `ns_nexopos_transactions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `account_id` int NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `media_id` int NOT NULL DEFAULT '0',
  `value` float NOT NULL DEFAULT '0',
  `recurring` tinyint(1) NOT NULL DEFAULT '0',
  `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '0',
  `group_id` int DEFAULT NULL,
  `occurrence` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `occurrence_value` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `scheduled_date` datetime DEFAULT NULL,
  `author` int NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci 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;

--
-- Dumping data for table `ns_nexopos_transactions`
--


--
-- Table structure for table `ns_nexopos_transactions_accounts`
--

CREATE TABLE `ns_nexopos_transactions_accounts` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `operation` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'debit',
  `account` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `description` text COLLATE utf8mb4_unicode_ci,
  `author` int NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_transactions_accounts`
--

INSERT INTO `ns_nexopos_transactions_accounts` (`id`, `name`, `operation`, `account`, `description`, `author`, `uuid`, `created_at`, `updated_at`) VALUES (1,'Liabilities Account','debit','009',NULL,28,NULL,'2025-05-15 03:58:08','2025-05-15 03:58:08'),(2,'Sales Account','credit','001',NULL,28,NULL,'2025-05-22 04:05:35','2025-05-22 04:05:35'),(3,'Sales Refunds Account','debit','003',NULL,28,NULL,'2025-06-17 02:11:24','2025-06-17 02:11:24');

--
-- Table structure for table `ns_nexopos_transactions_balance_days`
--

CREATE TABLE `ns_nexopos_transactions_balance_days` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `opening_balance` double NOT NULL DEFAULT '0',
  `income` double NOT NULL DEFAULT '0',
  `expense` double NOT NULL DEFAULT '0',
  `closing_balance` double NOT NULL DEFAULT '0',
  `date` date 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;

--
-- Dumping data for table `ns_nexopos_transactions_balance_days`
--


--
-- Table structure for table `ns_nexopos_transactions_balance_months`
--

CREATE TABLE `ns_nexopos_transactions_balance_months` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `opening_balance` double NOT NULL DEFAULT '0',
  `income` double NOT NULL DEFAULT '0',
  `expense` double NOT NULL DEFAULT '0',
  `closing_balance` double NOT NULL DEFAULT '0',
  `date` date 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;

--
-- Dumping data for table `ns_nexopos_transactions_balance_months`
--


--
-- Table structure for table `ns_nexopos_transactions_histories`
--

CREATE TABLE `ns_nexopos_transactions_histories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `transaction_id` int DEFAULT NULL,
  `operation` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `transaction_account_id` int DEFAULT NULL,
  `procurement_id` int DEFAULT NULL,
  `order_refund_id` int DEFAULT NULL,
  `order_payment_id` int DEFAULT NULL,
  `order_refund_product_id` int DEFAULT NULL,
  `order_id` int DEFAULT NULL,
  `order_product_id` int DEFAULT NULL,
  `register_history_id` int DEFAULT NULL,
  `customer_account_history_id` int DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `value` float NOT NULL DEFAULT '0',
  `trigger_date` datetime DEFAULT NULL,
  `author` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_transactions_histories`
--

INSERT INTO `ns_nexopos_transactions_histories` (`id`, `transaction_id`, `operation`, `transaction_account_id`, `procurement_id`, `order_refund_id`, `order_payment_id`, `order_refund_product_id`, `order_id`, `order_product_id`, `register_history_id`, `customer_account_history_id`, `name`, `type`, `status`, `value`, `trigger_date`, `author`, `created_at`, `updated_at`) VALUES (1,NULL,'debit',1,5,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Procurement Liability : Procurement 00005 - G.R.N 00001',NULL,'pending',0,NULL,28,'2025-05-15 03:58:08','2025-05-15 03:58:08'),(2,NULL,'debit',1,6,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Procurement Liability : Procurement 00005 - G.R.N 00001',NULL,'pending',0,NULL,28,'2025-05-15 03:58:48','2025-05-15 03:58:48'),(3,0,'credit',2,0,0,NULL,0,1,0,0,0,'Sale : 250522-001',NULL,'active',140,'2025-05-22 09:05:34',28,'2025-05-22 04:05:35','2025-05-22 04:05:35'),(4,0,'credit',2,0,0,NULL,0,2,0,0,0,'Sale : 250603-001',NULL,'active',2410.8,'2025-06-03 08:07:26',28,'2025-06-03 03:07:37','2025-06-03 03:07:37'),(5,0,'credit',2,0,0,NULL,0,3,0,0,0,'Sale : 250603-002',NULL,'active',66.5,'2025-06-03 08:08:55',28,'2025-06-03 03:09:19','2025-06-03 03:09:19'),(6,0,'credit',2,0,0,NULL,0,4,0,0,0,'Sale : 250603-003',NULL,'active',64.6,'2025-06-03 08:12:02',28,'2025-06-03 03:12:02','2025-06-03 03:12:02'),(7,0,'credit',2,0,0,NULL,0,5,0,0,0,'Sale : 250603-004',NULL,'active',620.8,'2025-06-03 08:14:42',28,'2025-06-03 03:14:45','2025-06-03 03:14:45'),(8,0,'credit',2,0,0,NULL,0,6,0,0,0,'Sale : 250603-005',NULL,'active',70,'2025-06-03 08:15:26',28,'2025-06-03 03:15:28','2025-06-03 03:15:28'),(9,0,'credit',2,0,0,NULL,0,7,0,0,0,'Sale : 250603-006',NULL,'active',660,'2025-06-03 08:20:13',28,'2025-06-03 03:20:17','2025-06-03 03:20:17'),(10,0,'credit',2,0,0,NULL,0,8,0,0,0,'Sale : 250603-007',NULL,'active',67,'2025-06-03 08:29:17',28,'2025-06-03 03:29:18','2025-06-03 03:29:18'),(11,0,'credit',2,0,0,NULL,0,11,0,0,0,'Sale : 250603-010',NULL,'active',70,'2025-06-03 13:23:36',28,'2025-06-03 08:23:38','2025-06-03 08:23:38'),(12,0,'credit',2,0,0,NULL,0,12,0,0,0,'Sale : 250603-011',NULL,'active',70,'2025-06-03 13:41:18',28,'2025-06-03 08:41:19','2025-06-03 08:41:19'),(13,0,'credit',2,0,0,NULL,0,13,0,0,0,'Sale : 250603-012',NULL,'active',70,'2025-06-03 13:41:57',28,'2025-06-03 08:41:59','2025-06-03 08:41:59'),(14,0,'credit',2,0,0,NULL,0,14,0,0,0,'Sale : 250603-013',NULL,'active',1320,'2025-06-03 13:44:46',28,'2025-06-03 08:44:48','2025-06-03 08:44:48'),(15,0,'credit',2,0,0,NULL,0,15,0,0,0,'Sale : 250603-014',NULL,'active',660,'2025-06-03 13:48:27',28,'2025-06-03 08:48:29','2025-06-03 08:48:29'),(16,0,'credit',2,0,0,NULL,0,16,0,0,0,'Sale : 250603-015',NULL,'active',660,'2025-06-03 13:54:14',28,'2025-06-03 08:54:16','2025-06-03 08:54:16'),(17,0,'credit',2,0,0,NULL,0,17,0,0,0,'Sale : 250603-016',NULL,'active',660,'2025-06-03 13:56:40',28,'2025-06-03 08:56:41','2025-06-03 08:56:41'),(18,0,'credit',2,0,0,NULL,0,18,0,0,0,'Sale : 250613-001',NULL,'active',660,'2025-06-13 06:52:13',28,'2025-06-13 01:52:13','2025-06-13 01:52:13'),(19,0,'credit',2,0,0,NULL,0,19,0,0,0,'Sale : 250616-001',NULL,'active',660,'2025-06-16 06:50:36',28,'2025-06-16 01:50:38','2025-06-16 01:50:38'),(20,0,'credit',2,0,0,NULL,0,20,0,0,0,'Sale : 250616-002',NULL,'active',660,'2025-06-16 07:01:28',28,'2025-06-16 02:01:28','2025-06-16 02:01:28'),(21,0,'credit',2,0,0,NULL,0,21,0,0,0,'Sale : 250616-003',NULL,'active',660,'2025-06-16 07:02:05',28,'2025-06-16 02:02:06','2025-06-16 02:02:06'),(22,0,'debit',3,0,1,NULL,1,21,24,0,0,'Refunding : Tapal Danedaar 1 kg',NULL,'active',660,'2025-06-17 07:11:24',28,'2025-06-17 02:11:24','2025-06-17 02:11:24');

--
-- Table structure for table `ns_nexopos_units`
--

CREATE TABLE `ns_nexopos_units` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `identifier` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `author` int NOT NULL,
  `group_id` int NOT NULL,
  `value` float NOT NULL,
  `preview_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `base_unit` tinyint(1) NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ns_nexopos_units_identifier_unique` (`identifier`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_units`
--

INSERT INTO `ns_nexopos_units` (`id`, `name`, `identifier`, `description`, `author`, `group_id`, `value`, `preview_url`, `base_unit`, `uuid`, `created_at`, `updated_at`) VALUES (1,'DefaultUnit','pc','DefaultUnit, created on installation',28,1,1,NULL,1,NULL,'2025-04-21 07:40:41','2025-04-21 07:40:41');

--
-- Table structure for table `ns_nexopos_units_groups`
--

CREATE TABLE `ns_nexopos_units_groups` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `author` int NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_units_groups`
--

INSERT INTO `ns_nexopos_units_groups` (`id`, `name`, `description`, `author`, `uuid`, `created_at`, `updated_at`) VALUES (1,'DefaultUnitGroup','DefaultUnitGroup, created on installation',28,NULL,'2025-04-21 07:40:41','2025-04-21 07:40:41');

--
-- Table structure for table `ns_nexopos_users_attributes`
--

CREATE TABLE `ns_nexopos_users_attributes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `avatar_link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `theme` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `language` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_users_attributes`
--

INSERT INTO `ns_nexopos_users_attributes` (`id`, `user_id`, `avatar_link`, `theme`, `language`) VALUES (1,28,NULL,NULL,'en');

--
-- Table structure for table `ns_nexopos_users_roles_relations`
--

CREATE TABLE `ns_nexopos_users_roles_relations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `role_id` int NOT NULL,
  `user_id` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_users_roles_relations`
--

INSERT INTO `ns_nexopos_users_roles_relations` (`id`, `role_id`, `user_id`, `created_at`, `updated_at`) VALUES (1,2,28,'2025-04-21 07:40:40','2025-04-21 07:40:40'),(2,5,29,'2025-05-15 02:50:50','2025-05-15 02:50:50');

--
-- Table structure for table `ns_nexopos_users_widgets`
--

CREATE TABLE `ns_nexopos_users_widgets` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `identifier` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `column` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `class_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `position` int 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;

--
-- Dumping data for table `ns_nexopos_users_widgets`
--

INSERT INTO `ns_nexopos_users_widgets` (`id`, `identifier`, `column`, `class_name`, `position`, `user_id`, `created_at`, `updated_at`) VALUES ('9eba6f0b-2399-49d4-8a50-7acd74026030','nsIncompleteSaleCardWidget','first-column','App\\Widgets\\IncompleteSaleCardWidget',0,28,'2025-04-21 07:40:41','2025-04-21 07:40:41'),('9eba6f0b-2c24-455f-b137-fb11981fd6b4','nsBestCustomers','first-column','App\\Widgets\\BestCustomersWidget',1,28,'2025-04-21 07:40:41','2025-04-21 07:40:41'),('9eba6f0b-3927-48f8-912a-a6cc70f8730f','nsOrdersSummary','first-column','App\\Widgets\\OrdersSummaryWidget',2,28,'2025-04-21 07:40:41','2025-04-21 07:40:41'),('9eba6f0b-49fd-42ba-b5e9-b0392ae74ab2','nsExpenseCardWidget','second-column','App\\Widgets\\ExpenseCardWidget',0,28,'2025-04-21 07:40:41','2025-04-21 07:40:41'),('9eba6f0b-5675-40c2-9524-bfdab11fce9c','nsProfileWidget','second-column','App\\Widgets\\ProfileWidget',1,28,'2025-04-21 07:40:41','2025-04-21 07:40:41'),('9eba6f0b-5d10-42f5-829d-d74902d9e874','nsBestCashiers','second-column','App\\Widgets\\BestCashiersWidget',2,28,'2025-04-21 07:40:41','2025-04-21 07:40:41'),('9eba6f0b-63b1-4dce-881a-78b7e46fc1a4','nsSaleCardWidget','third-column','App\\Widgets\\SaleCardWidget',0,28,'2025-04-21 07:40:41','2025-04-21 07:40:41'),('9eba6f0b-6a0b-46b2-8ad3-128c4095f4d4','nsOrdersChart','third-column','App\\Widgets\\OrdersChartWidget',1,28,'2025-04-21 07:40:41','2025-04-21 07:40:41');

--
-- Table structure for table `ns_telescope_entries`
--

CREATE TABLE `ns_telescope_entries` (
  `sequence` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `family_hash` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `should_display_on_index` tinyint(1) NOT NULL DEFAULT '1',
  `type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`sequence`),
  UNIQUE KEY `ns_telescope_entries_uuid_unique` (`uuid`),
  KEY `ns_telescope_entries_batch_id_index` (`batch_id`),
  KEY `ns_telescope_entries_family_hash_index` (`family_hash`),
  KEY `ns_telescope_entries_created_at_index` (`created_at`),
  KEY `ns_telescope_entries_type_should_display_on_index_index` (`type`,`should_display_on_index`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_telescope_entries`
--


--
-- Table structure for table `ns_telescope_entries_tags`
--

CREATE TABLE `ns_telescope_entries_tags` (
  `entry_uuid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tag` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  KEY `ns_telescope_entries_tags_entry_uuid_tag_index` (`entry_uuid`,`tag`),
  KEY `ns_telescope_entries_tags_tag_index` (`tag`),
  CONSTRAINT `ns_telescope_entries_tags_entry_uuid_foreign` FOREIGN KEY (`entry_uuid`) REFERENCES `ns_telescope_entries` (`uuid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_telescope_entries_tags`
--


--
-- Table structure for table `ns_telescope_monitoring`
--

CREATE TABLE `ns_telescope_monitoring` (
  `tag` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_telescope_monitoring`
--


--
-- Dumping events for database 'gposarytech_pos'
--

--
-- Dumping routines for database 'gposarytech_pos'
--


