-- Table structure for table `types_of_services`
--

CREATE TABLE `types_of_services` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `business_id` int NOT NULL,
  `location_price_group` text COLLATE utf8mb4_unicode_ci,
  `packing_charge` decimal(22,4) DEFAULT NULL,
  `packing_charge_type` enum('fixed','percent') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `enable_custom_fields` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `units`
--

CREATE TABLE `units` (
  `id` int UNSIGNED NOT NULL,
  `business_id` int UNSIGNED NOT NULL,
  `actual_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `short_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `allow_decimal` tinyint(1) NOT NULL,
  `base_unit_id` int DEFAULT NULL,
  `base_unit_multiplier` decimal(20,4) DEFAULT NULL,
  `created_by` int UNSIGNED NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `units`
--

INSERT INTO `units` (`id`, `business_id`, `actual_name`, `short_name`, `allow_decimal`, `base_unit_id`, `base_unit_multiplier`, `created_by`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 1, 'Pieces', 'Pc(s)', 0, NULL, NULL, 1, NULL, '2025-02-20 23:12:15', '2025-02-20 23:12:15'),
(5, 4, 'Pieces', 'Pc(s)', 0, NULL, NULL, 5, NULL, '2025-05-10 13:14:50', '2025-05-10 13:14:50'),
(6, 5, 'Pieces', 'Pc(s)', 0, NULL, NULL, 10, NULL, '2026-01-25 17:42:20', '2026-01-25 17:42:20'),
(7, 6, 'Pieces', 'Pc(s)', 0, NULL, NULL, 12, NULL, '2026-01-25 19:15:33', '2026-01-25 19:15:33');

-- --------------------------------------------------------

--
-- Table structure for table `user_contact_access`
--

CREATE TABLE `user_contact_access` (
  `id` int UNSIGNED NOT NULL,
  `user_id` int NOT NULL,
  `contact_id` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `variations`
--

CREATE TABLE `variations` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_id` int UNSIGNED NOT NULL,
  `sub_sku` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `product_variation_id` int UNSIGNED NOT NULL,
  `woocommerce_variation_id` int DEFAULT NULL,
  `variation_value_id` int DEFAULT NULL,
  `default_purchase_price` decimal(22,4) DEFAULT NULL,
  `dpp_inc_tax` decimal(22,4) NOT NULL DEFAULT '0.0000',
  `profit_percent` decimal(22,4) NOT NULL DEFAULT '0.0000',
  `default_sell_price` decimal(22,4) DEFAULT NULL,
  `sell_price_inc_tax` decimal(22,4) DEFAULT NULL COMMENT 'Sell price including tax',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `combo_variations` text COLLATE utf8mb4_unicode_ci COMMENT 'Contains the combo variation details'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `variations`
--

INSERT INTO `variations` (`id`, `name`, `product_id`, `sub_sku`, `product_variation_id`, `woocommerce_variation_id`, `variation_value_id`, `default_purchase_price`, `dpp_inc_tax`, `profit_percent`, `default_sell_price`, `sell_price_inc_tax`, `created_at`, `updated_at`, `deleted_at`, `combo_variations`) VALUES
(524, 'DUMMY', 524, '0523', 524, NULL, NULL, '0.0000', '0.0000', '25.0000', '0.0000', '0.0000', '2025-03-11 10:12:06', '2025-03-11 10:12:06', NULL, '[]'),
(641, 'DUMMY', 641, '0641', 641, NULL, NULL, '210.0000', '210.0000', '100.0000', '420.0000', '420.0000', '2025-05-15 16:49:28', '2025-06-24 09:32:49', NULL, '[]'),
(642, 'DUMMY', 642, '0642', 642, NULL, NULL, '600.0000', '600.0000', '66.6700', '1000.0000', '1000.0000', '2025-05-19 11:41:35', '2025-06-24 09:10:28', NULL, '[]'),
(643, 'DUMMY', 643, '0643', 643, NULL, NULL, '450.0000', '450.0000', '100.0000', '900.0000', '900.0000', '2025-05-19 11:44:50', '2025-07-08 10:39:12', NULL, '[]'),
(644, 'DUMMY', 644, '0644', 644, NULL, NULL, '350.0000', '350.0000', '42.8600', '500.0000', '500.0000', '2025-05-19 11:47:13', '2025-06-23 15:36:09', NULL, '[]'),
(645, 'DUMMY', 645, '0645', 645, NULL, NULL, '25.0000', '25.0000', '100.0000', '50.0000', '50.0000', '2025-05-19 13:37:31', '2025-12-29 12:59:46', NULL, '[]'),
(647, 'DUMMY', 647, '0647', 647, NULL, NULL, '35.0000', '35.0000', '42.8600', '50.0000', '50.0000', '2025-05-19 14:04:47', '2025-07-21 10:10:22', NULL, '[]'),
(649, 'DUMMY', 649, '0649', 649, NULL, NULL, '90.0000', '90.0000', '100.0000', '180.0000', '180.0000', '2025-05-22 14:29:04', '2025-09-18 11:12:58', NULL, '[]'),
(650, 'DUMMY', 650, '0650', 650, NULL, NULL, '200.0000', '200.0000', '150.0000', '500.0000', '500.0000', '2025-05-22 14:29:54', '2025-12-29 13:02:42', NULL, '[]'),
(651, 'DUMMY', 651, '0651', 651, NULL, NULL, '225.0000', '225.0000', '100.0000', '450.0000', '450.0000', '2025-05-22 14:30:29', '2025-08-03 16:21:51', NULL, '[]'),
(652, 'DUMMY', 652, '0652', 652, NULL, NULL, '250.0000', '250.0000', '100.0000', '500.0000', '500.0000', '2025-05-22 14:31:54', '2025-06-23 15:38:08', NULL, '[]'),
(653, 'DUMMY', 653, '0653', 653, NULL, NULL, '75.0000', '75.0000', '100.0000', '150.0000', '150.0000', '2025-05-22 14:32:59', '2025-09-18 10:53:00', NULL, '[]'),
(654, 'DUMMY', 654, '0654', 654, NULL, NULL, '46.0000', '46.0000', '334.7800', '200.0000', '200.0000', '2025-05-22 14:34:41', '2025-09-18 10:52:25', NULL, '[]'),
(655, 'DUMMY', 655, '0655', 655, NULL, NULL, '100.0000', '100.0000', '100.0000', '200.0000', '200.0000', '2025-05-22 14:35:17', '2025-09-18 11:49:46', NULL, '[]'),
(656, 'DUMMY', 656, '0656', 656, NULL, NULL, '300.0000', '300.0000', '100.0000', '600.0000', '600.0000', '2025-05-22 14:35:32', '2025-06-24 14:01:21', NULL, '[]'),
(657, 'DUMMY', 657, '0657', 657, NULL, NULL, '200.0000', '200.0000', '100.0000', '400.0000', '400.0000', '2025-05-22 14:36:12', '2025-05-22 14:36:12', NULL, '[]'),
(658, 'DUMMY', 658, '0658', 658, NULL, NULL, '300.0000', '300.0000', '100.0000', '600.0000', '600.0000', '2025-05-22 14:37:48', '2025-07-26 14:34:42', NULL, '[]'),
(659, 'DUMMY', 659, '0659', 659, NULL, NULL, '350.0000', '350.0000', '71.4300', '600.0000', '600.0000', '2025-05-22 14:38:11', '2025-06-14 22:01:44', NULL, '[]'),
(660, 'DUMMY', 660, '0660', 660, NULL, NULL, '250.0000', '250.0000', '100.0000', '500.0000', '500.0000', '2025-05-22 14:38:57', '2025-06-14 22:06:57', NULL, '[]'),
(661, 'DUMMY', 661, '0661', 661, NULL, NULL, '220.0000', '220.0000', '104.5500', '450.0000', '450.0000', '2025-05-22 14:39:31', '2025-06-24 09:34:23', NULL, '[]'),
(662, 'DUMMY', 662, '0662', 662, NULL, NULL, '280.0000', '280.0000', '150.0000', '700.0000', '700.0000', '2025-05-22 14:41:24', '2025-06-14 21:36:08', NULL, '[]'),
(663, 'DUMMY', 663, '0663', 663, NULL, NULL, '250.0000', '250.0000', '100.0000', '500.0000', '500.0000', '2025-05-22 14:42:07', '2025-06-14 21:50:02', NULL, '[]'),
(664, 'DUMMY', 664, '0664', 664, NULL, NULL, '1400.0000', '1400.0000', '100.0000', '2800.0000', '2800.0000', '2025-05-22 14:43:16', '2025-05-22 14:43:16', NULL, '[]'),
(665, 'DUMMY', 665, '0665', 665, NULL, NULL, '1100.0000', '1100.0000', '100.0000', '2200.0000', '2200.0000', '2025-05-22 14:43:57', '2025-05-22 14:43:57', NULL, '[]'),
(666, 'DUMMY', 666, '0666', 666, NULL, NULL, '1250.0000', '1250.0000', '100.0000', '2500.0000', '2500.0000', '2025-05-22 14:44:36', '2025-12-29 13:00:35', NULL, '[]'),
(667, 'DUMMY', 667, '0667', 667, NULL, NULL, '1150.0000', '1150.0000', '100.0000', '2300.0000', '2300.0000', '2025-05-22 14:48:01', '2025-07-28 15:05:00', NULL, '[]'),
(668, 'DUMMY', 668, '0668', 668, NULL, NULL, '75.0000', '75.0000', '100.0000', '150.0000', '150.0000', '2025-05-22 14:48:40', '2025-07-26 14:37:36', NULL, '[]'),
(669, 'DUMMY', 669, '0669', 669, NULL, NULL, '1800.0000', '1800.0000', '100.0000', '3600.0000', '3600.0000', '2025-05-22 14:55:06', '2025-06-14 21:59:24', NULL, '[]'),
(671, 'DUMMY', 671, '0671', 671, NULL, NULL, '2100.0000', '2100.0000', '66.6700', '3500.0000', '3500.0000', '2025-05-22 14:59:02', '2025-07-27 11:15:38', NULL, '[]'),
(672, 'DUMMY', 672, '0672', 672, NULL, NULL, '25.0000', '25.0000', '100.0000', '50.0000', '50.0000', '2025-05-22 14:59:39', '2025-06-14 16:59:09', NULL, '[]'),
(673, 'DUMMY', 673, '0673', 673, NULL, NULL, '1150.0000', '1150.0000', '100.0000', '2300.0000', '2300.0000', '2025-05-22 15:01:43', '2025-06-14 23:08:13', NULL, '[]'),
(674, 'DUMMY', 674, '0674', 674, NULL, NULL, '1650.0000', '1650.0000', '100.0000', '3300.0000', '3300.0000', '2025-05-22 15:02:19', '2025-05-22 15:02:19', NULL, '[]'),
(675, 'DUMMY', 675, '0675', 675, NULL, NULL, '135.0000', '135.0000', '122.2200', '300.0000', '300.0000', '2025-05-22 15:03:40', '2025-06-14 22:11:30', NULL, '[]'),
(676, 'DUMMY', 676, '0676', 676, NULL, NULL, '350.0000', '350.0000', '100.0000', '700.0000', '700.0000', '2025-05-22 17:07:44', '2025-06-14 21:43:04', NULL, '[]'),
(677, 'DUMMY', 677, '0677', 677, NULL, NULL, '130.0000', '130.0000', '100.0000', '260.0000', '260.0000', '2025-05-22 17:12:38', '2025-06-14 22:12:25', NULL, '[]'),
(680, 'DUMMY', 680, '0680', 680, NULL, NULL, '150.0000', '150.0000', '100.0000', '300.0000', '300.0000', '2025-05-28 11:00:48', '2025-06-23 15:40:38', NULL, '[]'),
(681, 'DUMMY', 681, '0681', 681, NULL, NULL, '200.0000', '200.0000', '100.0000', '400.0000', '400.0000', '2025-05-28 16:04:49', '2025-08-20 09:06:16', NULL, '[]'),
(682, 'DUMMY', 682, '0682', 682, NULL, NULL, '200.0000', '200.0000', '100.0000', '400.0000', '400.0000', '2025-05-28 16:07:16', '2025-07-08 11:01:13', NULL, '[]'),
(685, 'DUMMY', 685, '0685', 685, NULL, NULL, '50.0000', '50.0000', '100.0000', '100.0000', '100.0000', '2025-05-28 16:09:48', '2025-06-24 09:23:12', NULL, '[]'),
(686, 'DUMMY', 686, '0686', 686, NULL, NULL, '150.0000', '150.0000', '100.0000', '300.0000', '300.0000', '2025-05-28 16:10:05', '2025-05-28 16:10:05', NULL, '[]'),
(688, 'DUMMY', 688, '0688', 688, NULL, NULL, '450.0000', '450.0000', '100.0000', '900.0000', '900.0000', '2025-05-28 16:12:43', '2025-06-14 21:23:58', NULL, '[]'),
(689, 'DUMMY', 689, '0689', 689, NULL, NULL, '120.0000', '120.0000', '100.0000', '240.0000', '240.0000', '2025-05-28 16:13:33', '2025-07-08 11:25:39', NULL, '[]'),
(690, 'DUMMY', 690, '0690', 690, NULL, NULL, '300.0000', '300.0000', '100.0000', '600.0000', '600.0000', '2025-05-28 16:14:19', '2025-06-14 17:04:13', NULL, '[]'),
(691, 'DUMMY', 691, '0691', 691, NULL, NULL, '350.0000', '350.0000', '100.0000', '700.0000', '700.0000', '2025-05-28 16:15:08', '2025-06-14 17:02:53', NULL, '[]'),
(692, 'DUMMY', 692, '0692', 692, NULL, NULL, '550.0000', '550.0000', '100.0000', '1100.0000', '1100.0000', '2025-05-29 11:18:32', '2025-07-08 11:12:19', NULL, '[]'),
(693, 'DUMMY', 693, '0693', 693, NULL, NULL, '50.0000', '50.0000', '100.0000', '100.0000', '100.0000', '2025-05-29 11:20:34', '2025-09-18 11:00:36', NULL, '[]'),
(696, 'DUMMY', 696, '0696', 696, NULL, NULL, '130.0000', '130.0000', '100.0000', '260.0000', '260.0000', '2025-05-29 11:35:24', '2025-06-14 22:13:14', NULL, '[]'),
(697, 'DUMMY', 697, '0697', 697, NULL, NULL, '600.0000', '600.0000', '100.0000', '1200.0000', '1200.0000', '2025-05-29 12:11:47', '2025-06-14 21:30:52', NULL, '[]'),
(698, 'DUMMY', 698, '0698', 698, NULL, NULL, '550.0000', '550.0000', '100.0000', '1100.0000', '1100.0000', '2025-05-29 12:12:57', '2025-05-29 12:12:57', NULL, '[]'),
(699, 'DUMMY', 699, '0699', 699, NULL, NULL, '3.5000', '3.5000', '328.5700', '15.0000', '15.0000', '2025-05-29 12:13:16', '2025-07-09 12:42:21', NULL, '[]'),
(700, 'DUMMY', 700, '0700', 700, NULL, NULL, '7.0000', '7.0000', '114.2900', '15.0000', '15.0000', '2025-05-29 12:13:35', '2025-07-09 12:51:01', NULL, '[]'),
(701, 'DUMMY', 701, '0701', 701, NULL, NULL, '800.0000', '800.0000', '37.5000', '1100.0000', '1100.0000', '2025-05-29 12:16:39', '2025-06-14 21:49:02', NULL, '[]'),
(702, 'DUMMY', 702, '0702', 702, NULL, NULL, '350.0000', '350.0000', '14.2900', '400.0000', '400.0000', '2025-05-29 12:19:41', '2025-06-14 21:26:18', NULL, '[]'),
(705, 'DUMMY', 705, '0705', 705, NULL, NULL, '900.0000', '900.0000', '27.7800', '1150.0000', '1150.0000', '2025-05-29 12:21:13', '2025-06-14 17:11:13', NULL, '[]'),
(707, 'DUMMY', 707, '0707', 707, NULL, NULL, '1000.0000', '1000.0000', '50.0000', '1500.0000', '1500.0000', '2025-05-29 12:22:54', '2025-06-14 23:04:25', NULL, '[]'),
(708, 'DUMMY', 708, '0708', 708, NULL, NULL, '200.0000', '200.0000', '100.0000', '400.0000', '400.0000', '2025-05-29 12:26:24', '2025-07-26 14:36:59', NULL, '[]'),
(709, 'DUMMY', 709, '0709', 709, NULL, NULL, '550.0000', '550.0000', '100.0000', '1100.0000', '1100.0000', '2025-06-23 15:51:09', '2025-06-23 15:51:09', NULL, '[]'),
(710, 'DUMMY', 710, '0710', 710, NULL, NULL, '200.0000', '200.0000', '100.0000', '400.0000', '400.0000', '2025-06-23 15:52:28', '2025-06-23 15:52:28', NULL, '[]'),
(711, 'DUMMY', 711, '0711', 711, NULL, NULL, '1422.0000', '1422.0000', '100.0000', '2844.0000', '2844.0000', '2025-06-24 10:35:13', '2025-06-24 10:35:13', NULL, '[]'),
(712, 'DUMMY', 712, '0712', 712, NULL, NULL, '3000.0000', '3000.0000', '100.0000', '6000.0000', '6000.0000', '2025-06-24 10:36:28', '2025-07-08 10:37:55', NULL, '[]'),
(713, 'DUMMY', 713, '0713', 713, NULL, NULL, '600.0000', '600.0000', '100.0000', '1200.0000', '1200.0000', '2025-06-24 10:38:30', '2025-06-24 10:38:30', NULL, '[]'),
(714, 'DUMMY', 714, '0714', 714, NULL, NULL, '900.0000', '900.0000', '83.3300', '1650.0000', '1650.0000', '2025-06-24 13:02:44', '2025-07-25 17:25:20', NULL, '[]'),
(715, 'DUMMY', 715, '0715', 715, NULL, NULL, '1600.0000', '1600.0000', '100.0000', '3200.0000', '3200.0000', '2025-06-24 13:03:49', '2025-07-10 08:56:04', NULL, '[]'),
(716, 'DUMMY', 716, '0716', 716, NULL, NULL, '1400.0000', '1400.0000', '100.0000', '2800.0000', '2800.0000', '2025-06-24 13:04:58', '2025-07-10 08:56:43', NULL, '[]'),
(717, 'DUMMY', 717, '0717', 717, NULL, NULL, '1000.0000', '1000.0000', '100.0000', '2000.0000', '2000.0000', '2025-06-24 13:39:12', '2025-07-08 10:42:38', NULL, '[]'),
(718, 'DUMMY', 718, '0718', 718, NULL, NULL, '250.0000', '250.0000', '100.0000', '500.0000', '500.0000', '2025-06-24 13:53:00', '2025-06-24 13:53:00', NULL, '[]'),
(719, 'DUMMY', 719, '0719', 719, NULL, NULL, '1250.0000', '1250.0000', '100.0000', '2500.0000', '2500.0000', '2025-06-26 15:46:07', '2025-08-03 16:19:33', NULL, '[]'),
(720, 'DUMMY', 720, '0720', 720, NULL, NULL, '25000.0000', '25000.0000', '100.0000', '50000.0000', '50000.0000', '2025-06-26 15:46:53', '2025-06-26 15:58:01', NULL, '[]'),
(721, 'DUMMY', 721, '0721', 721, NULL, NULL, '1775.0000', '1775.0000', '100.0000', '3550.0000', '3550.0000', '2025-06-26 15:47:42', '2025-07-10 08:53:27', NULL, '[]'),
(722, 'DUMMY', 722, '0722', 722, NULL, NULL, '75.0000', '75.0000', '100.0000', '150.0000', '150.0000', '2025-07-04 16:09:05', '2025-07-08 11:03:19', NULL, '[]'),
(723, 'DUMMY', 723, '0723', 723, NULL, NULL, '25.0000', '25.0000', '100.0000', '50.0000', '50.0000', '2025-07-04 16:11:08', '2025-07-04 16:11:08', NULL, '[]'),
(724, 'DUMMY', 724, '0724', 724, NULL, NULL, '25.0000', '25.0000', '100.0000', '50.0000', '50.0000', '2025-07-04 16:11:44', '2025-09-18 11:10:14', NULL, '[]'),
(725, 'DUMMY', 725, '0725', 725, NULL, NULL, '25.0000', '25.0000', '100.0000', '50.0000', '50.0000', '2025-07-04 16:12:30', '2025-07-04 16:12:30', NULL, '[]'),
(726, 'DUMMY', 726, '0726', 726, NULL, NULL, '50.0000', '50.0000', '100.0000', '100.0000', '100.0000', '2025-07-08 10:57:09', '2025-09-18 11:02:29', NULL, '[]'),
(727, 'DUMMY', 727, '0727', 727, NULL, NULL, '6.0000', '6.0000', '100.0000', '12.0000', '12.0000', '2025-07-08 11:42:13', '2025-08-16 12:37:05', NULL, '[]'),
(728, 'DUMMY', 728, '0728', 728, NULL, NULL, '5.0000', '5.0000', '100.0000', '10.0000', '10.0000', '2025-07-08 11:45:43', '2025-12-28 12:53:17', NULL, '[]'),
(729, 'DUMMY', 729, '0729', 729, NULL, NULL, '5.0000', '5.0000', '100.0000', '10.0000', '10.0000', '2025-07-08 12:21:13', '2025-12-28 12:51:38', NULL, '[]'),
(730, 'DUMMY', 730, '0730', 730, NULL, NULL, '6.0000', '6.0000', '100.0000', '12.0000', '12.0000', '2025-07-08 12:25:43', '2025-07-08 12:25:43', NULL, '[]'),
(731, 'DUMMY', 731, '0731', 731, NULL, NULL, '4.0000', '4.0000', '100.0000', '8.0000', '8.0000', '2025-07-08 12:27:47', '2025-07-08 12:27:47', NULL, '[]'),
(732, 'DUMMY', 732, '0732', 732, NULL, NULL, '4.0000', '4.0000', '100.0000', '8.0000', '8.0000', '2025-07-08 12:31:09', '2025-07-27 10:27:01', NULL, '[]'),
(733, 'DUMMY', 733, '0733', 733, NULL, NULL, '4.0000', '4.0000', '100.0000', '8.0000', '8.0000', '2025-07-08 12:33:30', '2025-07-08 12:33:30', NULL, '[]'),
(734, 'DUMMY', 734, '0734', 734, NULL, NULL, '60.0000', '60.0000', '100.0000', '120.0000', '120.0000', '2025-07-09 12:08:55', '2025-07-09 12:08:55', NULL, '[]'),
(735, 'DUMMY', 735, '0735', 735, NULL, NULL, '150.0000', '150.0000', '100.0000', '300.0000', '300.0000', '2025-07-09 12:36:39', '2025-09-18 10:49:24', NULL, '[]'),
(736, 'DUMMY', 736, '0736', 736, NULL, NULL, '10.0000', '10.0000', '100.0000', '20.0000', '20.0000', '2025-07-09 13:40:11', '2025-07-27 12:00:51', NULL, '[]'),
(738, 'DUMMY', 738, '0738', 738, NULL, NULL, '8.0000', '8.0000', '100.0000', '16.0000', '16.0000', '2025-07-20 08:33:00', '2025-07-24 15:07:32', NULL, '[]'),
(739, 'DUMMY', 739, '0739', 739, NULL, NULL, '0.0000', '0.0000', '0.0000', '25.0000', '25.0000', '2025-07-24 14:46:49', '2025-07-24 14:46:49', NULL, '[]'),
(740, 'DUMMY', 740, '0740', 740, NULL, NULL, '0.0000', '0.0000', '0.0000', '25.0000', '25.0000', '2025-07-24 14:48:33', '2025-07-24 14:49:19', NULL, '[]'),
(741, 'DUMMY', 741, '0741', 741, NULL, NULL, '4.0000', '4.0000', '100.0000', '8.0000', '8.0000', '2025-07-25 17:58:10', '2025-07-25 17:58:10', NULL, '[]'),
(742, 'DUMMY', 742, '0742', 742, NULL, NULL, '4.0000', '4.0000', '100.0000', '8.0000', '8.0000', '2025-07-25 18:00:47', '2025-10-24 13:20:46', NULL, '[]'),
(743, 'DUMMY', 743, '0743', 743, NULL, NULL, '150.0000', '150.0000', '100.0000', '300.0000', '300.0000', '2025-08-09 12:16:54', '2025-08-09 12:16:54', NULL, '[]'),
(744, 'DUMMY', 744, '0744', 744, NULL, NULL, '295.0000', '295.0000', '67.7966', '495.0000', '495.0000', '2025-08-10 14:01:40', '2025-08-10 14:36:29', NULL, '[]'),
(745, 'DUMMY', 745, '0745', 745, NULL, NULL, '295.0000', '295.0000', '61.0169', '475.0000', '475.0000', '2025-08-10 14:03:15', '2025-08-10 14:36:29', NULL, '[]'),
(746, 'DUMMY', 746, '0746', 746, NULL, NULL, '335.0000', '335.0000', '71.6400', '575.0000', '575.0000', '2025-08-10 14:11:16', '2025-08-10 14:11:16', NULL, '[]'),
(747, 'DUMMY', 747, '0747', 747, NULL, NULL, '355.0000', '355.0000', '69.0100', '600.0000', '600.0000', '2025-08-10 14:14:00', '2025-08-10 14:14:00', NULL, '[]'),
(748, 'DUMMY', 748, '0748', 748, NULL, NULL, '1290.0000', '1290.0000', '70.5426', '2200.0000', '2200.0000', '2025-08-10 14:16:06', '2025-08-10 14:36:29', NULL, '[]'),
(749, 'DUMMY', 749, '0749', 749, NULL, NULL, '975.0000', '975.0000', '58.9700', '1550.0000', '1550.0000', '2025-08-10 14:17:29', '2025-08-10 14:17:29', NULL, '[]'),
(750, 'DUMMY', 750, '0750', 750, NULL, NULL, '1335.0000', '1335.0000', '64.7900', '2200.0000', '2200.0000', '2025-08-10 14:27:31', '2025-08-10 14:27:31', NULL, '[]'),
(751, 'DUMMY', 751, '0751', 751, NULL, NULL, '1075.0000', '1075.0000', '44.1900', '1550.0000', '1550.0000', '2025-08-10 14:30:31', '2025-08-10 14:30:31', NULL, '[]'),
(752, 'DUMMY', 752, '0752', 752, NULL, NULL, '15.0000', '15.0000', '100.0000', '30.0000', '30.0000', '2025-08-16 12:33:08', '2025-09-18 10:57:34', NULL, '[]'),
(753, 'DUMMY', 753, '0753', 753, NULL, NULL, '20.0000', '20.0000', '50.0000', '30.0000', '30.0000', '2025-08-18 15:27:37', '2025-09-18 10:58:29', NULL, '[]'),
(754, 'DUMMY', 754, '0754', 754, NULL, NULL, '100.0000', '100.0000', '100.0000', '200.0000', '200.0000', '2025-10-01 16:20:06', '2025-10-01 16:20:06', NULL, '[]'),
(755, 'DUMMY', 755, '0755', 755, NULL, NULL, '100.0000', '100.0000', '100.0000', '200.0000', '200.0000', '2025-10-01 16:21:47', '2025-10-01 16:21:47', NULL, '[]'),
(756, 'DUMMY', 756, '0756', 756, NULL, NULL, '70.0000', '70.0000', '100.0000', '140.0000', '140.0000', '2025-10-01 16:25:09', '2025-10-01 16:25:09', NULL, '[]'),
(757, 'DUMMY', 757, '0757', 757, NULL, NULL, '400.0000', '400.0000', '100.0000', '800.0000', '800.0000', '2025-10-01 16:35:36', '2025-10-01 16:35:36', NULL, '[]'),
(758, 'DUMMY', 758, '0758', 758, NULL, NULL, '400.0000', '400.0000', '100.0000', '800.0000', '800.0000', '2025-10-01 16:37:05', '2025-10-01 16:37:05', NULL, '[]'),
(759, 'DUMMY', 759, '0759', 759, NULL, NULL, '150.0000', '150.0000', '100.0000', '300.0000', '300.0000', '2025-10-01 16:43:18', '2025-10-01 16:43:18', NULL, '[]'),
(760, 'DUMMY', 760, '0760', 760, NULL, NULL, '1000.0000', '1000.0000', '100.0000', '2000.0000', '2000.0000', '2025-10-01 16:45:12', '2025-10-01 16:45:12', NULL, '[]'),
(761, 'DUMMY', 761, '0761', 761, NULL, NULL, '500.0000', '500.0000', '100.0000', '1000.0000', '1000.0000', '2025-10-01 16:46:11', '2025-10-01 16:46:11', NULL, '[]'),
(762, 'DUMMY', 762, '0762', 762, NULL, NULL, '600.0000', '600.0000', '100.0000', '1200.0000', '1200.0000', '2025-10-01 16:47:36', '2025-10-01 16:47:36', NULL, '[]'),
(763, 'DUMMY', 763, '0763', 763, NULL, NULL, '200.0000', '200.0000', '100.0000', '400.0000', '400.0000', '2025-10-01 16:49:33', '2025-10-01 16:49:33', NULL, '[]'),
(764, 'DUMMY', 764, '0764', 764, NULL, NULL, '500.0000', '500.0000', '100.0000', '1000.0000', '1000.0000', '2025-10-01 16:50:16', '2025-10-01 16:50:16', NULL, '[]'),
(765, 'DUMMY', 765, '0765', 765, NULL, NULL, '500.0000', '500.0000', '100.0000', '1000.0000', '1000.0000', '2025-10-01 16:56:14', '2025-10-01 16:56:14', NULL, '[]'),
(766, 'DUMMY', 766, '0766', 766, NULL, NULL, '700.0000', '700.0000', '100.0000', '1400.0000', '1400.0000', '2025-10-01 17:08:23', '2025-10-01 17:08:23', NULL, '[]'),
(767, 'DUMMY', 767, '0767', 767, NULL, NULL, '150.0000', '150.0000', '100.0000', '300.0000', '300.0000', '2025-10-01 17:10:55', '2025-10-01 17:10:55', NULL, '[]'),
(768, 'DUMMY', 768, '0768', 768, NULL, NULL, '75.0000', '75.0000', '100.0000', '150.0000', '150.0000', '2025-10-01 17:11:50', '2025-10-01 17:11:50', NULL, '[]'),
(769, 'DUMMY', 769, '0769', 769, NULL, NULL, '400.0000', '400.0000', '100.0000', '800.0000', '800.0000', '2025-10-01 17:12:31', '2025-12-29 13:04:44', NULL, '[]'),
(770, 'DUMMY', 770, '0770', 770, NULL, NULL, '500.0000', '500.0000', '100.0000', '1000.0000', '1000.0000', '2025-10-01 17:13:34', '2025-10-01 17:13:34', NULL, '[]'),
(771, 'DUMMY', 771, '0771', 771, NULL, NULL, '300.0000', '300.0000', '100.0000', '600.0000', '600.0000', '2025-10-01 17:15:14', '2025-10-01 17:15:14', NULL, '[]'),
(772, 'DUMMY', 772, '0772', 772, NULL, NULL, '300.0000', '300.0000', '100.0000', '600.0000', '600.0000', '2025-10-01 17:16:14', '2025-10-01 17:16:14', NULL, '[]'),
(773, 'DUMMY', 773, '0773', 773, NULL, NULL, '16.0000', '16.0000', '0.0000', '16.0000', '16.0000', '2025-10-01 17:19:10', '2026-02-13 14:10:58', NULL, '[]'),
(774, 'DUMMY', 774, '0774', 774, NULL, NULL, '1300.0000', '1300.0000', '100.0000', '2600.0000', '2600.0000', '2025-10-01 17:22:47', '2025-10-01 17:22:47', NULL, '[]'),
(775, 'DUMMY', 775, '0775', 775, NULL, NULL, '650.0000', '650.0000', '100.0000', '1300.0000', '1300.0000', '2025-10-01 17:24:00', '2025-10-01 17:24:00', NULL, '[]'),
(776, 'DUMMY', 776, '0776', 776, NULL, NULL, '800.0000', '800.0000', '100.0000', '1600.0000', '1600.0000', '2025-10-01 17:26:03', '2025-10-01 17:26:03', NULL, '[]'),
(777, 'DUMMY', 777, '0777', 777, NULL, NULL, '900.0000', '900.0000', '100.0000', '1800.0000', '1800.0000', '2025-10-01 17:27:54', '2025-10-01 17:27:54', NULL, '[]'),
(778, 'DUMMY', 778, '0778', 778, NULL, NULL, '600.0000', '600.0000', '100.0000', '1250.0000', '0.0000', '2025-10-09 11:56:47', '2025-10-09 12:07:16', NULL, '[]'),
(779, 'DUMMY', 779, '0779', 779, NULL, NULL, '750.0000', '750.0000', '100.0000', '1500.0000', '1500.0000', '2025-10-09 12:06:00', '2025-10-09 12:06:00', NULL, '[]'),
(780, 'DUMMY', 780, '0780', 780, NULL, NULL, '0.0000', '0.0000', '100.0000', '0.0000', '0.0000', '2025-11-30 14:30:30', '2025-11-30 14:30:30', NULL, '[]'),
(781, 'DUMMY', 781, '0781', 781, NULL, NULL, '0.0000', '0.0000', '100.0000', '0.0000', '0.0000', '2025-11-30 14:45:00', '2025-11-30 14:45:00', NULL, '[]'),
(782, 'DUMMY', 782, '0782', 782, NULL, NULL, '0.0000', '0.0000', '100.0000', '0.0000', '0.0000', '2025-11-30 16:43:15', '2025-11-30 16:43:15', NULL, '[]'),
(783, 'DUMMY', 783, '0783', 783, NULL, NULL, '100.0000', '100.0000', '100.0000', '200.0000', '200.0000', '2025-12-01 19:54:07', '2025-12-28 19:08:13', NULL, '[]'),
(784, 'DUMMY', 784, '0784', 784, NULL, NULL, '1.0000', '1.0000', '0.0000', '1.0000', '1.0000', '2025-12-23 21:05:45', '2025-12-23 21:05:45', NULL, '[]'),
(785, 'DUMMY', 785, '0785', 785, NULL, NULL, '1.0000', '1.0000', '0.0000', '1.0000', '1.0000', '2025-12-31 01:28:57', '2025-12-31 01:30:54', NULL, '[]'),
(787, 'DUMMY', 787, '0787', 787, NULL, NULL, '1.0000', '1.0000', '0.0000', '1.0000', '1.0000', '2025-12-31 01:32:10', '2025-12-31 01:32:55', NULL, '[]'),
(788, 'DUMMY', 788, '0788', 788, NULL, NULL, '1.0000', '1.0000', '0.0000', '1.0000', '1.0000', '2026-01-01 00:44:19', '2026-01-01 00:44:19', NULL, '[]'),
(789, 'DUMMY', 789, '0789', 789, NULL, NULL, '1.0000', '1.0000', '-100.0000', '0.0000', '0.0000', '2026-01-03 02:37:53', '2026-01-03 02:37:53', NULL, '[]'),
(790, 'DUMMY', 790, '0790', 790, NULL, NULL, '0.0000', '0.0000', '100.0000', '0.0000', '0.0000', '2026-01-03 02:40:13', '2026-01-03 02:41:38', NULL, '[]'),
(791, 'DUMMY', 791, '0791', 791, NULL, NULL, '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '2026-01-25 15:07:14', '2026-01-25 15:07:14', NULL, '[]'),
(792, 'DUMMY', 792, '0792', 792, NULL, NULL, '250.0000', '250.0000', '0.0000', '250.0000', '250.0000', '2026-01-25 15:10:35', '2026-01-31 19:22:28', NULL, '[]'),
(793, 'DUMMY', 793, '0793', 793, NULL, NULL, '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '2026-01-25 15:15:05', '2026-01-25 15:15:05', NULL, '[]'),
(794, 'DUMMY', 794, '0794', 794, NULL, NULL, '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '2026-01-25 15:15:57', '2026-01-25 15:15:57', NULL, '[]'),
(795, 'DUMMY', 795, '0795', 795, NULL, NULL, '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '2026-01-25 15:16:13', '2026-01-25 15:16:13', NULL, '[]'),
(796, 'DUMMY', 796, '0796', 796, NULL, NULL, '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '2026-01-25 15:16:39', '2026-01-25 15:16:39', NULL, '[]'),
(797, 'DUMMY', 797, '0797', 797, NULL, NULL, '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '2026-01-26 11:36:28', '2026-01-26 11:36:28', NULL, '[]'),
(798, 'DUMMY', 798, '0798', 798, NULL, NULL, '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '2026-01-26 11:36:48', '2026-01-26 11:36:48', NULL, '[]'),
(799, 'DUMMY', 799, '0799', 799, NULL, NULL, '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '2026-01-26 11:37:14', '2026-01-26 11:37:14', NULL, '[]'),
(800, 'DUMMY', 800, '0800', 800, NULL, NULL, '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '2026-01-26 11:46:48', '2026-01-26 11:46:48', NULL, '[]'),
(801, 'DUMMY', 801, '0801', 801, NULL, NULL, '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '2026-01-26 11:49:32', '2026-01-26 11:49:32', NULL, '[]'),
(802, 'DUMMY', 802, '0802', 802, NULL, NULL, '75.0000', '75.0000', '100.0000', '150.0000', '150.0000', '2026-02-13 13:34:57', '2026-02-13 13:34:57', NULL, '[]'),
(803, 'DUMMY', 803, '0803', 803, NULL, NULL, '1750.0000', '1750.0000', '71.4300', '3000.0000', '3000.0000', '2026-02-13 13:38:44', '2026-02-13 13:38:44', NULL, '[]'),
(804, 'DUMMY', 804, '0804', 804, NULL, NULL, '6.0000', '6.0000', '12.0000', '6.7200', '6.7200', '2026-02-27 21:24:54', '2026-02-27 21:34:51', NULL, '[]');

-- --------------------------------------------------------

--
-- Table structure for table `variation_group_prices`
--

CREATE TABLE `variation_group_prices` (
  `id` int UNSIGNED NOT NULL,
  `variation_id` int UNSIGNED NOT NULL,
  `price_group_id` int UNSIGNED NOT NULL,
  `price_inc_tax` decimal(22,4) NOT NULL,
  `price_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'fixed',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `variation_location_details`
--

CREATE TABLE `variation_location_details` (
  `id` int UNSIGNED NOT NULL,
  `product_id` int UNSIGNED NOT NULL,
  `product_variation_id` int UNSIGNED NOT NULL COMMENT 'id from product_variations table',
  `variation_id` int UNSIGNED NOT NULL,
  `location_id` int UNSIGNED NOT NULL,
  `qty_available` decimal(22,4) NOT NULL DEFAULT '0.0000',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `variation_location_details`
--

INSERT INTO `variation_location_details` (`id`, `product_id`, `product_variation_id`, `variation_id`, `location_id`, `qty_available`, `created_at`, `updated_at`) VALUES
(111, 650, 650, 650, 6, '18.0000', '2025-06-14 16:56:42', '2025-12-29 13:03:05'),
(112, 691, 691, 691, 4, '1.0000', '2025-06-14 17:03:19', '2025-06-14 17:03:19'),
(113, 690, 690, 690, 4, '1.0000', '2025-06-14 17:04:21', '2025-06-14 17:04:21'),
(114, 700, 700, 700, 4, '17.0000', '2025-06-14 17:06:35', '2025-09-17 14:29:44'),
(115, 662, 662, 662, 6, '42.0000', '2025-06-14 21:37:55', '2025-06-14 21:37:55'),
(116, 699, 699, 699, 4, '1.0000', '2025-06-14 21:40:00', '2025-09-17 13:47:31'),
(117, 708, 708, 708, 6, '31.0000', '2025-06-14 21:42:21', '2025-08-03 16:25:21'),
(118, 676, 676, 676, 6, '8.0000', '2025-06-14 21:43:16', '2025-06-14 21:43:16'),
(119, 667, 667, 667, 6, '6.0000', '2025-06-14 21:47:46', '2025-07-28 15:15:35'),
(120, 701, 701, 701, 6, '22.0000', '2025-06-14 21:49:14', '2025-06-14 21:49:14'),
(121, 663, 663, 663, 6, '13.0000', '2025-06-14 21:50:21', '2025-06-14 21:50:21'),
(122, 659, 659, 659, 6, '11.0000', '2025-06-14 22:01:58', '2025-08-07 16:08:40'),
(123, 660, 660, 660, 6, '96.0000', '2025-06-14 22:07:20', '2026-02-13 18:47:55'),
(124, 652, 652, 652, 4, '0.0000', '2025-06-14 22:08:40', '2025-07-08 10:26:20'),
(125, 652, 652, 652, 6, '10.0000', '2025-06-14 22:08:40', '2025-06-14 22:08:40'),
(126, 661, 661, 661, 4, '0.0000', '2025-06-14 22:09:38', '2025-09-17 13:20:07'),
(127, 661, 661, 661, 6, '2.0000', '2025-06-14 22:09:38', '2025-06-14 22:09:38'),
(128, 675, 675, 675, 5, '1.0000', '2025-06-14 22:11:41', '2025-06-14 22:11:41'),
(129, 696, 696, 696, 6, '8.0000', '2025-06-14 22:13:29', '2025-06-14 22:13:29'),
(130, 644, 644, 644, 4, '2.0000', '2025-06-14 23:02:43', '2025-06-14 23:02:43'),
(131, 644, 644, 644, 6, '8.0000', '2025-06-14 23:02:43', '2025-06-14 23:02:43'),
(132, 707, 707, 707, 6, '4.0000', '2025-06-14 23:04:45', '2025-08-24 10:45:43'),
(133, 642, 642, 642, 4, '3.0000', '2025-06-14 23:05:25', '2025-06-24 09:15:47'),
(134, 673, 673, 673, 6, '36.0000', '2025-06-14 23:08:28', '2025-06-14 23:08:28'),
(135, 668, 668, 668, 6, '42.0000', '2025-06-14 23:11:31', '2026-02-13 18:48:44'),
(136, 647, 647, 647, 4, '2.0000', '2025-06-14 23:15:25', '2025-07-25 18:14:45'),
(137, 647, 647, 647, 6, '170.0000', '2025-06-14 23:15:25', '2025-06-14 23:15:25'),
(138, 655, 655, 655, 4, '0.0000', '2025-06-14 23:23:21', '2025-09-18 11:50:12'),
(139, 655, 655, 655, 6, '153.0000', '2025-06-14 23:23:21', '2026-02-13 18:48:44'),
(140, 692, 692, 692, 5, '2.0000', '2025-06-23 09:22:49', '2025-06-23 09:22:49'),
(141, 643, 643, 643, 5, '4.0000', '2025-06-23 09:24:00', '2025-06-23 09:24:00'),
(142, 644, 644, 644, 5, '2.0000', '2025-06-23 15:36:52', '2025-06-23 15:36:52'),
(143, 680, 680, 680, 4, '2.0000', '2025-06-23 15:41:18', '2025-06-23 15:41:18'),
(144, 653, 653, 653, 4, '13.0000', '2025-06-24 09:18:01', '2026-03-10 21:46:53'),
(145, 653, 653, 653, 6, '198.0000', '2025-06-24 09:18:01', '2026-02-13 18:47:55'),
(146, 681, 681, 681, 4, '1.0000', '2025-06-24 09:19:39', '2025-08-16 12:06:20'),
(147, 651, 651, 651, 4, '3.0000', '2025-06-24 09:22:01', '2025-08-03 16:23:04'),
(148, 651, 651, 651, 6, '33.0000', '2025-06-24 09:22:01', '2025-06-24 09:22:01'),
(149, 685, 685, 685, 4, '2.0000', '2025-06-24 09:23:28', '2025-06-24 09:23:28'),
(150, 656, 656, 656, 4, '3.0000', '2025-06-24 09:25:27', '2025-06-24 09:25:27'),
(151, 656, 656, 656, 6, '43.0000', '2025-06-24 09:25:27', '2025-06-24 14:02:35'),
(152, 654, 654, 654, 4, '76.0000', '2025-06-24 09:40:32', '2026-01-30 14:52:28'),
(153, 654, 654, 654, 6, '300.0000', '2025-06-24 09:40:32', '2026-02-13 14:31:00'),
(154, 682, 682, 682, 4, '9.0000', '2025-06-24 09:42:21', '2025-06-24 09:42:21'),
(155, 711, 711, 711, 6, '2.0000', '2025-06-24 10:35:26', '2025-06-24 10:35:26'),
(156, 712, 712, 712, 6, '1.0000', '2025-06-24 10:36:40', '2025-06-24 10:36:40'),
(157, 713, 713, 713, 6, '26.0000', '2025-06-24 10:44:52', '2025-06-24 10:44:52'),
(158, 714, 714, 714, 6, '0.0000', '2025-06-24 13:02:54', '2025-07-25 17:26:28'),
(159, 715, 715, 715, 6, '4.0000', '2025-06-24 13:04:07', '2025-06-24 13:04:07'),
(160, 716, 716, 716, 6, '1.0000', '2025-06-24 13:05:04', '2025-06-24 13:05:04'),
(161, 717, 717, 717, 6, '8.0000', '2025-06-24 13:39:17', '2025-06-24 13:39:17'),
(162, 718, 718, 718, 6, '93.0000', '2025-06-24 13:53:12', '2025-06-24 13:53:12'),
(163, 719, 719, 719, 4, '0.0000', '2025-06-26 15:46:15', '2025-08-03 16:20:34'),
(164, 720, 720, 720, 4, '1.0000', '2025-06-26 15:47:00', '2025-06-26 15:47:00'),
(165, 721, 721, 721, 4, '0.0000', '2025-06-26 15:47:50', '2025-07-10 08:54:19'),
(166, 722, 722, 722, 4, '10.0000', '2025-07-04 16:09:54', '2025-07-04 16:09:54'),
(167, 723, 723, 723, 4, '1.0000', '2025-07-04 16:11:15', '2025-07-04 16:11:15'),
(168, 724, 724, 724, 4, '5.0000', '2025-07-04 16:11:51', '2025-09-18 11:10:25'),
(169, 725, 725, 725, 4, '1.0000', '2025-07-04 16:12:51', '2025-07-04 16:12:51'),
(171, 693, 693, 693, 4, '9.0000', '2025-07-08 10:49:25', '2025-07-08 10:55:45'),
(172, 693, 693, 693, 6, '260.0000', '2025-07-08 10:49:25', '2025-07-08 10:49:25'),
(173, 726, 726, 726, 4, '5.0000', '2025-07-08 10:57:33', '2025-07-25 18:09:18'),
(174, 714, 714, 714, 4, '1.0000', '2025-07-08 11:09:44', '2025-07-08 11:09:44'),
(175, 689, 689, 689, 4, '0.0000', '2025-07-08 11:25:52', '2025-07-09 12:11:29'),
(176, 727, 727, 727, 5, '274.0000', '2025-07-08 11:43:22', '2025-12-25 09:20:28'),
(177, 728, 728, 728, 6, '305.0000', '2025-07-08 11:45:52', '2025-07-08 11:45:52'),
(178, 729, 729, 729, 5, '19.0000', '2025-07-08 12:21:19', '2025-07-28 15:26:10'),
(179, 730, 730, 730, 5, '305.0000', '2025-07-08 12:25:49', '2025-07-08 12:25:49'),
(180, 731, 731, 731, 5, '41.0000', '2025-07-08 12:27:53', '2025-08-16 12:12:54'),
(181, 732, 732, 732, 5, '99.0000', '2025-07-08 12:31:16', '2025-09-17 12:07:52'),
(182, 734, 734, 734, 4, '0.0000', '2025-07-09 12:09:02', '2025-09-18 11:04:06'),
(183, 735, 735, 735, 4, '3.0000', '2025-07-09 12:37:41', '2025-12-23 13:55:04'),
(184, 735, 735, 735, 6, '48.0000', '2025-07-09 12:37:41', '2025-07-09 12:37:41'),
(185, 736, 736, 736, 5, '241.0000', '2025-07-09 13:40:19', '2025-07-09 13:40:19'),
(186, 728, 728, 728, 5, '305.0000', '2025-07-19 09:31:44', '2025-10-24 13:20:18'),
(187, 738, 738, 738, 5, '11.0000', '2025-07-20 08:33:25', '2025-07-24 15:20:05'),
(188, 739, 739, 739, 4, '9913.0000', '2025-07-24 14:47:06', '2026-03-06 21:31:59'),
(189, 739, 739, 739, 5, '9999.0000', '2025-07-24 14:47:06', '2025-07-24 14:47:06'),
(190, 739, 739, 739, 6, '9989.0000', '2025-07-24 14:47:06', '2025-07-26 12:20:51'),
(191, 740, 740, 740, 4, '9936.0000', '2025-07-24 14:48:45', '2026-03-24 14:37:44'),
(192, 740, 740, 740, 5, '9999.0000', '2025-07-24 14:48:45', '2025-07-24 14:48:45'),
(193, 740, 740, 740, 6, '9989.0000', '2025-07-24 14:48:45', '2026-02-07 20:07:44'),
(194, 742, 742, 742, 5, '305.0000', '2025-07-25 18:03:17', '2025-10-24 13:20:58'),
(195, 658, 658, 658, 6, '6.0000', '2025-07-26 14:35:26', '2026-03-24 14:38:23'),
(196, 666, 666, 666, 6, '11.0000', '2025-07-28 15:08:33', '2025-12-29 13:00:56'),
(197, 743, 743, 743, 4, '11.0000', '2025-08-09 12:17:04', '2025-08-09 12:18:36'),
(198, 744, 744, 744, 4, '50.0000', '2025-08-10 14:36:29', '2025-08-10 14:36:29'),
(199, 745, 745, 745, 4, '27.0000', '2025-08-10 14:36:29', '2025-09-02 13:02:56'),
(200, 746, 746, 746, 4, '59.0000', '2025-08-10 14:36:29', '2025-10-01 17:05:32'),
(201, 747, 747, 747, 4, '31.0000', '2025-08-10 14:36:29', '2025-10-01 17:05:32'),
(202, 748, 748, 748, 4, '4.0000', '2025-08-10 14:36:29', '2025-08-24 12:53:37'),
(203, 749, 749, 749, 4, '23.0000', '2025-08-10 14:36:29', '2025-08-24 12:53:37'),
(204, 750, 750, 750, 4, '5.0000', '2025-08-10 14:36:29', '2025-08-10 14:36:29'),
(205, 751, 751, 751, 4, '5.0000', '2025-08-10 14:36:29', '2025-08-10 14:36:29'),
(206, 753, 753, 753, 4, '321.0000', '2025-08-18 15:27:58', '2025-09-18 10:58:52'),
(207, 753, 753, 753, 6, '250.0000', '2025-09-18 10:58:52', '2025-09-18 10:58:52'),
(208, 754, 754, 754, 4, '50.0000', '2025-10-01 17:05:32', '2025-10-01 17:05:32'),
(209, 755, 755, 755, 4, '20.0000', '2025-10-01 17:05:32', '2025-10-01 17:05:32'),
(210, 756, 756, 756, 4, '25.0000', '2025-10-01 17:05:32', '2025-10-01 17:05:32'),
(211, 757, 757, 757, 4, '15.0000', '2025-10-01 17:05:32', '2025-10-01 17:05:32'),
(212, 758, 758, 758, 4, '10.0000', '2025-10-01 17:05:32', '2025-10-01 17:05:32'),
(213, 759, 759, 759, 4, '15.0000', '2025-10-01 17:05:32', '2025-10-01 17:05:32'),
(214, 760, 760, 760, 4, '10.0000', '2025-10-01 17:05:32', '2025-10-01 17:05:32'),
(215, 761, 761, 761, 4, '10.0000', '2025-10-01 17:05:32', '2025-10-01 17:05:32'),
(216, 762, 762, 762, 4, '7.0000', '2025-10-01 17:05:32', '2025-10-01 17:05:32'),
(217, 763, 763, 763, 4, '2.0000', '2025-10-01 17:05:32', '2025-10-01 17:05:32'),
(218, 764, 764, 764, 4, '2.0000', '2025-10-01 17:05:32', '2025-10-01 17:05:32'),
(219, 765, 765, 765, 4, '6.0000', '2025-10-01 17:05:32', '2025-10-01 17:05:32'),
(220, 778, 778, 778, 6, '2.0000', '2025-10-09 12:03:19', '2025-10-09 12:03:19'),
(221, 779, 779, 779, 6, '1.0000', '2025-10-09 12:06:05', '2025-10-09 12:06:05'),
(222, 780, 780, 780, 7, '9175.0000', '2025-11-30 14:30:44', '2026-01-25 18:48:37'),
(223, 781, 781, 781, 7, '9315.0000', '2025-11-30 14:45:09', '2026-01-25 16:56:31'),
(224, 782, 782, 782, 8, '9398.0000', '2025-11-30 16:43:26', '2026-01-25 16:43:41'),
(225, 783, 783, 783, 4, '2.0000', '2025-12-01 19:54:58', '2026-01-25 11:47:34'),
(226, 784, 784, 784, 9, '9994.0000', '2025-12-23 21:05:45', '2026-01-03 14:51:01'),
(227, 729, 729, 729, 4, '610.0000', '2025-12-28 12:52:15', '2025-12-28 12:52:15'),
(228, 728, 728, 728, 4, '303.0000', '2025-12-28 12:53:37', '2025-12-28 13:03:26'),
(229, 645, 645, 645, 5, '12.0000', '2025-12-29 12:59:56', '2025-12-29 12:59:56'),
(230, 769, 769, 769, 5, '13.0000', '2025-12-29 13:05:17', '2026-03-12 21:57:04'),
(231, 788, 788, 788, 10, '9999.0000', '2026-01-01 00:44:30', '2026-01-01 00:44:30'),
(232, 771, 771, 771, 5, '10.0000', '2026-01-01 17:57:10', '2026-03-24 14:43:46'),
(233, 771, 771, 771, 6, '34.0000', '2026-01-01 17:57:10', '2026-02-13 14:31:00'),
(234, 789, 789, 789, 11, '9999.0000', '2026-01-03 02:38:01', '2026-01-03 02:38:01'),
(235, 790, 790, 790, 11, '9.0000', '2026-01-21 20:01:07', '2026-01-21 20:01:07'),
(236, 701, 701, 701, 5, '21.0000', '2026-01-23 16:48:00', '2026-01-23 16:50:05'),
(237, 791, 791, 791, 12, '48.0000', '2026-01-25 15:09:21', '2026-03-24 17:59:20'),
(238, 792, 792, 792, 12, '0.0000', '2026-01-25 15:11:16', '2026-01-28 19:30:45'),
(239, 793, 793, 793, 12, '9335.0000', '2026-01-25 15:15:05', '2026-03-23 10:55:05'),
(240, 796, 796, 796, 12, '9999.0000', '2026-01-25 15:16:39', '2026-01-25 15:16:39'),
(241, 797, 797, 797, 13, '9474.0000', '2026-01-26 11:36:28', '2026-03-26 20:51:09'),
(242, 798, 798, 798, 13, '999.0000', '2026-01-26 11:36:48', '2026-01-26 11:36:48'),
(243, 799, 799, 799, 13, '9736.0000', '2026-01-26 11:37:14', '2026-03-28 18:23:10'),
(244, 800, 800, 800, 13, '9460.0000', '2026-01-26 11:46:48', '2026-03-26 20:50:27'),
(245, 801, 801, 801, 13, '9938.0000', '2026-01-26 11:49:32', '2026-03-27 17:04:19'),
(246, 802, 802, 802, 5, '15.0000', '2026-02-13 13:35:14', '2026-03-24 14:42:12'),
(247, 803, 803, 803, 5, '610.0000', '2026-02-13 14:07:33', '2026-02-13 14:08:30'),
(248, 803, 803, 803, 6, '8.0000', '2026-02-13 14:07:33', '2026-02-13 14:07:33'),
(249, 773, 773, 773, 5, '505.0000', '2026-02-13 14:11:10', '2026-02-13 14:22:39'),
(250, 804, 804, 804, 5, '304.0000', '2026-02-27 21:26:10', '2026-02-27 21:40:21');

-- --------------------------------------------------------

--
-- Table structure for table `variation_templates`
--

CREATE TABLE `variation_templates` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `business_id` int UNSIGNED NOT NULL,
  `woocommerce_attr_id` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `variation_value_templates`
--

CREATE TABLE `variation_value_templates` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `variation_template_id` int UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `warranties`
--

CREATE TABLE `warranties` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `business_id` int NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `duration` int NOT NULL,
  `duration_type` enum('days','months','years') COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `warranties`
--

INSERT INTO `warranties` (`id`, `name`, `business_id`, `description`, `duration`, `duration_type`, `created_at`, `updated_at`) VALUES
(1, 'ضمان 11 شهر', 2, 'ضمان سنه', 1, 'years', '2025-02-21 16:51:54', '2025-02-21 16:52:39'),
(2, 'ضمان سنة', 3, NULL, 1, 'years', '2025-04-18 13:02:42', '2025-04-18 13:02:42'),
(3, 'ضمان سنتين', 3, NULL, 2, 'years', '2025-04-18 13:02:55', '2025-04-18 13:02:55'),
(4, 'ضمان 3 سنين', 3, NULL, 3, 'years', '2025-04-18 13:03:24', '2025-04-18 13:03:24'),
(5, 'ضمان 4 سنين', 3, NULL, 4, 'years', '2025-04-18 13:03:59', '2025-04-18 13:03:59'),
(6, 'ضمان 5 سنوات', 3, NULL, 5, 'years', '2025-04-18 13:04:11', '2025-04-18 13:04:11'),
(7, 'ضمان شهر', 3, NULL, 1, 'months', '2025-04-18 13:04:21', '2025-04-18 13:04:21'),
(8, 'ضمان 3 شهور', 3, NULL, 3, 'months', '2025-04-18 13:04:40', '2025-04-18 13:04:40'),
(9, 'ضمان 6 شهور', 3, NULL, 6, 'months', '2025-04-18 13:04:58', '2025-04-18 13:04:58'),
(10, 'بدون ضمان', 3, NULL, 0, 'days', '2025-04-18 13:05:27', '2025-04-18 13:05:27');

-- --------------------------------------------------------

--
-- Table structure for table `woocommerce_sync_logs`
--

CREATE TABLE `woocommerce_sync_logs` (
  `id` int UNSIGNED NOT NULL,
  `business_id` int NOT NULL,
  `sync_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `operation_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `data` longtext COLLATE utf8mb4_unicode_ci,
  `details` longtext COLLATE utf8mb4_unicode_ci,
  `created_by` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `woocommerce_sync_logs`
--

INSERT INTO `woocommerce_sync_logs` (`id`, `business_id`, `sync_type`, `operation_type`, `data`, `details`, `created_by`, `created_at`, `updated_at`) VALUES
(1, 3, 'orders', NULL, NULL, NULL, 4, '2025-04-17 15:43:02', '2025-04-17 15:43:02'),
(2, 3, 'orders', NULL, NULL, NULL, 4, '2025-04-17 15:44:12', '2025-04-17 15:44:12'),
(3, 3, 'orders', NULL, NULL, NULL, 4, '2025-04-17 15:45:28', '2025-04-17 15:45:28'),
(4, 3, 'orders', NULL, NULL, NULL, 4, '2025-04-17 15:51:30', '2025-04-17 15:51:30'),
(5, 3, 'orders', NULL, NULL, NULL, 4, '2025-04-17 16:09:36', '2025-04-17 16:09:36'),
(6, 3, 'orders', NULL, NULL, NULL, 4, '2025-04-17 16:12:53', '2025-04-17 16:12:53'),
(7, 3, 'orders', NULL, NULL, NULL, 4, '2025-04-17 22:19:55', '2025-04-17 22:19:55'),
(8, 3, 'all_products', 'reset', NULL, NULL, 4, '2025-04-17 22:20:08', '2025-04-17 22:20:08'),
(9, 3, 'orders', NULL, NULL, NULL, 4, '2025-04-17 22:30:28', '2025-04-17 22:30:28'),
(10, 3, 'orders', NULL, NULL, NULL, 4, '2025-04-17 22:32:06', '2025-04-17 22:32:06'),
(11, 3, 'orders', NULL, NULL, NULL, 4, '2025-04-17 22:55:10', '2025-04-17 22:55:10'),
(12, 3, 'categories', 'created', '[\"XVR\",\"SWITCH\",\"DVR\",\"CAMERA\",\"CABEL\",\"NVR\"]', NULL, 4, '2025-04-17 22:55:12', '2025-04-17 22:55:12'),
(13, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-17 22:55:15', '2025-04-17 22:55:15'),
(14, 3, 'orders', NULL, NULL, NULL, 4, '2025-04-17 23:12:47', '2025-04-17 23:12:47'),
(15, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-17 23:12:49', '2025-04-17 23:12:49'),
(16, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-17 23:12:53', '2025-04-17 23:12:53'),
(20, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-17 23:13:17', '2025-04-17 23:13:17'),
(21, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-17 23:13:28', '2025-04-17 23:13:28'),
(22, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-17 23:13:34', '2025-04-17 23:13:34'),
(26, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-17 23:13:58', '2025-04-17 23:13:58'),
(27, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-17 23:14:19', '2025-04-17 23:14:19'),
(29, 3, 'orders', NULL, NULL, NULL, 4, '2025-04-17 23:17:05', '2025-04-17 23:17:05'),
(30, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-17 23:17:06', '2025-04-17 23:17:06'),
(31, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-17 23:17:09', '2025-04-17 23:17:09'),
(37, 3, 'orders', NULL, NULL, NULL, 4, '2025-04-17 23:23:45', '2025-04-17 23:23:45'),
(38, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-17 23:23:47', '2025-04-17 23:23:47'),
(39, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-17 23:23:50', '2025-04-17 23:23:50'),
(40, 3, 'orders', NULL, NULL, NULL, 4, '2025-04-18 00:06:46', '2025-04-18 00:06:46'),
(41, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 00:06:48', '2025-04-18 00:06:48'),
(42, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 00:06:50', '2025-04-18 00:06:50'),
(43, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 00:07:17', '2025-04-18 00:07:17'),
(44, 3, 'new_products', 'created', '[\"HDTV-HDTV LENGTH:3M\",\"HDTV-HDTV LENGTH:1.5M\",\"UAC-B122-AF40LM\"]', NULL, 4, '2025-04-18 00:07:19', '2025-04-18 00:07:19'),
(45, 3, 'new_products', NULL, NULL, NULL, 4, '2025-04-18 00:07:20', '2025-04-18 00:07:20'),
(46, 3, 'orders', NULL, NULL, NULL, 4, '2025-04-18 00:53:43', '2025-04-18 00:53:43'),
(47, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 00:53:44', '2025-04-18 00:53:44'),
(48, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 00:53:49', '2025-04-18 00:53:49'),
(49, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 00:54:12', '2025-04-18 00:54:12'),
(50, 3, 'all_products', 'updated', '[\"HDTV-HDTV LENGTH:3M\",\"HDTV-HDTV LENGTH:1.5M\",\"UAC-B122-AF40LM\"]', NULL, 4, '2025-04-18 00:54:13', '2025-04-18 00:54:13'),
(51, 3, 'all_products', NULL, NULL, NULL, 4, '2025-04-18 00:54:13', '2025-04-18 00:54:13'),
(52, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 00:54:22', '2025-04-18 00:54:22'),
(53, 3, 'new_products', NULL, NULL, NULL, 4, '2025-04-18 00:54:22', '2025-04-18 00:54:22'),
(54, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 00:55:37', '2025-04-18 00:55:37'),
(55, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 00:55:39', '2025-04-18 00:55:39'),
(56, 3, 'all_products', 'updated', '[\"HDTV-HDTV LENGTH:3M\",\"HDTV-HDTV LENGTH:1.5M\",\"UAC-B122-AF40LM\"]', NULL, 4, '2025-04-18 00:55:40', '2025-04-18 00:55:40'),
(57, 3, 'all_products', NULL, NULL, NULL, 4, '2025-04-18 00:55:40', '2025-04-18 00:55:40'),
(58, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 00:56:39', '2025-04-18 00:56:39'),
(59, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 00:56:41', '2025-04-18 00:56:41'),
(60, 3, 'new_products', NULL, NULL, NULL, 4, '2025-04-18 00:56:41', '2025-04-18 00:56:41'),
(61, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 00:56:44', '2025-04-18 00:56:44'),
(62, 3, 'all_products', NULL, NULL, NULL, 4, '2025-04-18 00:56:44', '2025-04-18 00:56:44'),
(63, 3, 'all_products', NULL, NULL, NULL, 4, '2025-04-18 00:56:44', '2025-04-18 00:56:44'),
(64, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 00:56:50', '2025-04-18 00:56:50'),
(65, 3, 'orders', NULL, NULL, NULL, 4, '2025-04-18 00:56:52', '2025-04-18 00:56:52'),
(66, 3, 'orders', NULL, NULL, NULL, 4, '2025-04-18 00:56:55', '2025-04-18 00:56:55'),
(67, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 00:56:57', '2025-04-18 00:56:57'),
(68, 3, 'new_products', NULL, NULL, NULL, 4, '2025-04-18 00:56:57', '2025-04-18 00:56:57'),
(69, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 00:58:09', '2025-04-18 00:58:09'),
(70, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 00:58:13', '2025-04-18 00:58:13'),
(71, 3, 'new_products', NULL, NULL, NULL, 4, '2025-04-18 00:58:13', '2025-04-18 00:58:13'),
(72, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 00:58:16', '2025-04-18 00:58:16'),
(73, 3, 'new_products', NULL, NULL, NULL, 4, '2025-04-18 00:58:16', '2025-04-18 00:58:16'),
(74, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 00:58:17', '2025-04-18 00:58:17'),
(75, 3, 'all_products', NULL, NULL, NULL, 4, '2025-04-18 00:58:17', '2025-04-18 00:58:17'),
(76, 3, 'all_products', NULL, NULL, NULL, 4, '2025-04-18 00:58:17', '2025-04-18 00:58:17'),
(77, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 00:59:20', '2025-04-18 00:59:20'),
(78, 3, 'orders', NULL, NULL, NULL, 4, '2025-04-18 00:59:22', '2025-04-18 00:59:22'),
(79, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 00:59:24', '2025-04-18 00:59:24'),
(80, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 00:59:27', '2025-04-18 00:59:27'),
(81, 3, 'orders', NULL, NULL, NULL, 4, '2025-04-18 01:00:21', '2025-04-18 01:00:21'),
(82, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 01:00:22', '2025-04-18 01:00:22'),
(83, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 01:00:24', '2025-04-18 01:00:24'),
(84, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 01:00:27', '2025-04-18 01:00:27'),
(85, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 01:00:29', '2025-04-18 01:00:29'),
(86, 3, 'new_products', NULL, NULL, NULL, 4, '2025-04-18 01:00:29', '2025-04-18 01:00:29'),
(87, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 01:00:30', '2025-04-18 01:00:30'),
(88, 3, 'all_products', NULL, NULL, NULL, 4, '2025-04-18 01:00:30', '2025-04-18 01:00:30'),
(89, 3, 'all_products', NULL, NULL, NULL, 4, '2025-04-18 01:00:31', '2025-04-18 01:00:31'),
(90, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 01:00:41', '2025-04-18 01:00:41'),
(91, 3, 'new_products', NULL, NULL, NULL, 4, '2025-04-18 01:00:41', '2025-04-18 01:00:41'),
(92, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 01:00:45', '2025-04-18 01:00:45'),
(93, 3, 'all_products', NULL, NULL, NULL, 4, '2025-04-18 01:00:45', '2025-04-18 01:00:45'),
(94, 3, 'all_products', NULL, NULL, NULL, 4, '2025-04-18 01:00:46', '2025-04-18 01:00:46'),
(95, 3, 'orders', NULL, NULL, NULL, 4, '2025-04-18 01:04:50', '2025-04-18 01:04:50'),
(96, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 01:04:52', '2025-04-18 01:04:52'),
(97, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 01:04:53', '2025-04-18 01:04:53'),
(98, 3, 'categories', 'reset', NULL, NULL, 4, '2025-04-18 01:04:57', '2025-04-18 01:04:57'),
(99, 3, 'orders', NULL, NULL, NULL, 4, '2025-04-18 01:05:03', '2025-04-18 01:05:03'),
(100, 3, 'categories', 'created', '[\"XVR\",\"SWITCH\",\"DVR\",\"CAMERA\",\"CABEL\",\"NVR\"]', NULL, 4, '2025-04-18 01:05:09', '2025-04-18 01:05:09'),
(101, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 01:05:39', '2025-04-18 01:05:39'),
(102, 3, 'all_products', NULL, NULL, NULL, 4, '2025-04-18 01:05:39', '2025-04-18 01:05:39'),
(103, 3, 'all_products', NULL, NULL, NULL, 4, '2025-04-18 01:05:39', '2025-04-18 01:05:39'),
(104, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 01:05:42', '2025-04-18 01:05:42'),
(105, 3, 'new_products', NULL, NULL, NULL, 4, '2025-04-18 01:05:42', '2025-04-18 01:05:42'),
(106, 3, 'categories', 'reset', NULL, NULL, 4, '2025-04-18 01:22:56', '2025-04-18 01:22:56'),
(107, 3, 'orders', NULL, NULL, NULL, 4, '2025-04-18 01:23:04', '2025-04-18 01:23:04'),
(108, 3, 'orders', NULL, NULL, NULL, 4, '2025-04-18 01:23:10', '2025-04-18 01:23:10'),
(109, 3, 'categories', 'created', '[\"XVR\",\"SWITCH\",\"DVR\",\"CAMERA\",\"CABEL\",\"NVR\"]', NULL, 4, '2025-04-18 01:31:09', '2025-04-18 01:31:09'),
(110, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 01:31:14', '2025-04-18 01:31:14'),
(111, 3, 'all_products', NULL, NULL, NULL, 4, '2025-04-18 01:31:14', '2025-04-18 01:31:14'),
(112, 3, 'all_products', NULL, NULL, NULL, 4, '2025-04-18 01:31:14', '2025-04-18 01:31:14'),
(113, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 01:31:58', '2025-04-18 01:31:58'),
(114, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 01:32:24', '2025-04-18 01:32:24'),
(115, 3, 'all_products', NULL, NULL, NULL, 4, '2025-04-18 01:32:24', '2025-04-18 01:32:24'),
(116, 3, 'all_products', NULL, NULL, NULL, 4, '2025-04-18 01:32:25', '2025-04-18 01:32:25'),
(117, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 01:32:26', '2025-04-18 01:32:26'),
(118, 3, 'new_products', NULL, NULL, NULL, 4, '2025-04-18 01:32:26', '2025-04-18 01:32:26'),
(119, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 01:32:30', '2025-04-18 01:32:30'),
(120, 3, 'new_products', NULL, NULL, NULL, 4, '2025-04-18 01:32:30', '2025-04-18 01:32:30'),
(121, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 01:32:31', '2025-04-18 01:32:31'),
(122, 3, 'all_products', NULL, NULL, NULL, 4, '2025-04-18 01:32:31', '2025-04-18 01:32:31'),
(123, 3, 'all_products', NULL, NULL, NULL, 4, '2025-04-18 01:32:32', '2025-04-18 01:32:32'),
(124, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 01:33:24', '2025-04-18 01:33:24'),
(125, 3, 'new_products', NULL, NULL, NULL, 4, '2025-04-18 01:33:24', '2025-04-18 01:33:24'),
(126, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 01:33:26', '2025-04-18 01:33:26'),
(127, 3, 'all_products', NULL, NULL, NULL, 4, '2025-04-18 01:33:26', '2025-04-18 01:33:26'),
(128, 3, 'all_products', NULL, NULL, NULL, 4, '2025-04-18 01:33:26', '2025-04-18 01:33:26'),
(129, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 01:33:28', '2025-04-18 01:33:28'),
(130, 3, 'orders', NULL, NULL, NULL, 4, '2025-04-18 01:33:32', '2025-04-18 01:33:32'),
(131, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 01:33:33', '2025-04-18 01:33:33'),
(132, 3, 'all_products', 'reset', NULL, NULL, 4, '2025-04-18 01:33:39', '2025-04-18 01:33:39'),
(133, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 01:33:43', '2025-04-18 01:33:43'),
(134, 3, 'new_products', 'created', '[\"HDTV-HDTV LENGTH:3M\",\"HDTV-HDTV LENGTH:1.5M\",\"UAC-B122-AF40LM\"]', NULL, 4, '2025-04-18 01:33:46', '2025-04-18 01:33:46'),
(135, 3, 'new_products', NULL, NULL, NULL, 4, '2025-04-18 01:33:46', '2025-04-18 01:33:46'),
(136, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 01:33:49', '2025-04-18 01:33:49'),
(137, 3, 'all_products', 'updated', '[\"HDTV-HDTV LENGTH:3M\",\"HDTV-HDTV LENGTH:1.5M\",\"UAC-B122-AF40LM\"]', NULL, 4, '2025-04-18 01:33:49', '2025-04-18 01:33:49'),
(138, 3, 'all_products', NULL, NULL, NULL, 4, '2025-04-18 01:33:50', '2025-04-18 01:33:50'),
(139, 3, 'orders', NULL, NULL, NULL, 4, '2025-04-18 01:54:59', '2025-04-18 01:54:59'),
(140, 3, 'categories', 'reset', NULL, NULL, 4, '2025-04-18 01:55:02', '2025-04-18 01:55:02'),
(141, 3, 'categories', 'created', '[\"XVR\",\"SWITCH\",\"DVR\",\"CAMERA\",\"CABEL\",\"NVR\"]', NULL, 4, '2025-04-18 01:55:07', '2025-04-18 01:55:07'),
(142, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 01:55:11', '2025-04-18 01:55:11'),
(143, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 01:55:31', '2025-04-18 01:55:31'),
(144, 3, 'new_products', NULL, NULL, NULL, 4, '2025-04-18 01:55:31', '2025-04-18 01:55:31'),
(145, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 01:55:33', '2025-04-18 01:55:33'),
(146, 3, 'all_products', NULL, NULL, NULL, 4, '2025-04-18 01:55:33', '2025-04-18 01:55:33'),
(147, 3, 'all_products', NULL, NULL, NULL, 4, '2025-04-18 01:55:34', '2025-04-18 01:55:34'),
(148, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 02:26:10', '2025-04-18 02:26:10'),
(149, 3, 'new_products', NULL, NULL, NULL, 4, '2025-04-18 02:26:10', '2025-04-18 02:26:10'),
(150, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 02:26:11', '2025-04-18 02:26:11'),
(151, 3, 'all_products', NULL, NULL, NULL, 4, '2025-04-18 02:26:11', '2025-04-18 02:26:11'),
(152, 3, 'all_products', NULL, NULL, NULL, 4, '2025-04-18 02:26:11', '2025-04-18 02:26:11'),
(153, 3, 'all_products', 'reset', NULL, NULL, 4, '2025-04-18 02:28:29', '2025-04-18 02:28:29'),
(154, 3, 'categories', 'reset', NULL, NULL, 4, '2025-04-18 02:28:34', '2025-04-18 02:28:34'),
(155, 3, 'categories', 'created', '[\"XVR\",\"SWITCH\",\"DVR\",\"CAMERA\",\"CABEL\",\"NVR\"]', NULL, 4, '2025-04-18 02:28:39', '2025-04-18 02:28:39'),
(156, 3, 'orders', NULL, NULL, NULL, 4, '2025-04-18 02:28:45', '2025-04-18 02:28:45'),
(157, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 02:28:47', '2025-04-18 02:28:47'),
(158, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 02:28:58', '2025-04-18 02:28:58'),
(159, 3, 'new_products', 'created', '[\"HDTV-HDTV LENGTH:3M\",\"HDTV-HDTV LENGTH:1.5M\",\"UAC-B122-AF40LM\"]', NULL, 4, '2025-04-18 02:29:01', '2025-04-18 02:29:01'),
(160, 3, 'new_products', NULL, NULL, NULL, 4, '2025-04-18 02:29:01', '2025-04-18 02:29:01'),
(161, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 02:29:03', '2025-04-18 02:29:03'),
(162, 3, 'all_products', 'updated', '[\"HDTV-HDTV LENGTH:3M\",\"HDTV-HDTV LENGTH:1.5M\",\"UAC-B122-AF40LM\"]', NULL, 4, '2025-04-18 02:29:04', '2025-04-18 02:29:04'),
(163, 3, 'all_products', NULL, NULL, NULL, 4, '2025-04-18 02:29:05', '2025-04-18 02:29:05'),
(164, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 02:32:33', '2025-04-18 02:32:33'),
(165, 3, 'new_products', NULL, NULL, NULL, 4, '2025-04-18 02:32:33', '2025-04-18 02:32:33'),
(166, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 02:32:35', '2025-04-18 02:32:35'),
(167, 3, 'all_products', NULL, NULL, NULL, 4, '2025-04-18 02:32:35', '2025-04-18 02:32:35'),
(168, 3, 'all_products', NULL, NULL, NULL, 4, '2025-04-18 02:32:36', '2025-04-18 02:32:36'),
(169, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 02:32:54', '2025-04-18 02:32:54'),
(170, 3, 'new_products', NULL, NULL, NULL, 4, '2025-04-18 02:32:54', '2025-04-18 02:32:54'),
(171, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 02:32:57', '2025-04-18 02:32:57'),
(172, 3, 'all_products', NULL, NULL, NULL, 4, '2025-04-18 02:32:57', '2025-04-18 02:32:57'),
(173, 3, 'all_products', NULL, NULL, NULL, 4, '2025-04-18 02:32:57', '2025-04-18 02:32:57'),
(174, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 02:34:07', '2025-04-18 02:34:07'),
(175, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 02:34:09', '2025-04-18 02:34:09'),
(176, 3, 'new_products', NULL, NULL, NULL, 4, '2025-04-18 02:34:09', '2025-04-18 02:34:09'),
(177, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 02:34:10', '2025-04-18 02:34:10'),
(178, 3, 'all_products', NULL, NULL, NULL, 4, '2025-04-18 02:34:10', '2025-04-18 02:34:10'),
(179, 3, 'all_products', NULL, NULL, NULL, 4, '2025-04-18 02:34:10', '2025-04-18 02:34:10'),
(180, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 02:36:38', '2025-04-18 02:36:38'),
(181, 3, 'new_products', NULL, NULL, NULL, 4, '2025-04-18 02:36:38', '2025-04-18 02:36:38'),
(182, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 02:36:40', '2025-04-18 02:36:40'),
(183, 3, 'all_products', 'updated', '[\"UAC-B122-AF40LM\"]', NULL, 4, '2025-04-18 02:36:41', '2025-04-18 02:36:41'),
(184, 3, 'all_products', NULL, NULL, NULL, 4, '2025-04-18 02:36:41', '2025-04-18 02:36:41'),
(185, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 02:36:58', '2025-04-18 02:36:58'),
(186, 3, 'new_products', NULL, NULL, NULL, 4, '2025-04-18 02:36:58', '2025-04-18 02:36:58'),
(187, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 02:36:59', '2025-04-18 02:36:59'),
(188, 3, 'all_products', 'updated', '[\"UAC-B122-AF40LM\"]', NULL, 4, '2025-04-18 02:37:01', '2025-04-18 02:37:01'),
(189, 3, 'all_products', NULL, NULL, NULL, 4, '2025-04-18 02:37:02', '2025-04-18 02:37:02'),
(190, 3, 'all_products', 'reset', NULL, NULL, 4, '2025-04-18 02:37:18', '2025-04-18 02:37:18'),
(191, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 02:37:23', '2025-04-18 02:37:23'),
(192, 3, 'new_products', 'created', '[\"HDTV-HDTV LENGTH:3M\",\"HDTV-HDTV LENGTH:1.5M\",\"UAC-B122-AF40LM\"]', NULL, 4, '2025-04-18 02:37:24', '2025-04-18 02:37:24'),
(193, 3, 'new_products', NULL, NULL, NULL, 4, '2025-04-18 02:37:24', '2025-04-18 02:37:24'),
(194, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 02:37:26', '2025-04-18 02:37:26'),
(195, 3, 'all_products', 'updated', '[\"HDTV-HDTV LENGTH:3M\",\"HDTV-HDTV LENGTH:1.5M\",\"UAC-B122-AF40LM\"]', NULL, 4, '2025-04-18 02:37:27', '2025-04-18 02:37:27'),
(196, 3, 'all_products', NULL, NULL, NULL, 4, '2025-04-18 02:37:27', '2025-04-18 02:37:27'),
(197, 3, 'orders', NULL, NULL, NULL, 4, '2025-04-18 13:14:10', '2025-04-18 13:14:10'),
(198, 3, 'categories', 'created', '[\"EXTENDER\"]', NULL, 4, '2025-04-18 13:14:13', '2025-04-18 13:14:13'),
(199, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 13:14:16', '2025-04-18 13:14:16'),
(200, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 13:14:18', '2025-04-18 13:14:18'),
(201, 3, 'new_products', 'created', '[\"HDMI EXTENDER 120M KVM\",\"HDMI 60M KVM\"]', NULL, 4, '2025-04-18 13:14:21', '2025-04-18 13:14:21'),
(202, 3, 'new_products', NULL, NULL, NULL, 4, '2025-04-18 13:14:21', '2025-04-18 13:14:21'),
(203, 3, 'categories', NULL, NULL, NULL, 4, '2025-04-18 13:14:23', '2025-04-18 13:14:23'),
(204, 3, 'all_products', 'updated', '[\"HDTV-HDTV LENGTH:3M\",\"HDTV-HDTV LENGTH:1.5M\",\"HDMI EXTENDER 120M KVM\",\"HDMI 60M KVM\"]', NULL, 4, '2025-04-18 13:14:24', '2025-04-18 13:14:24'),
(205, 3, 'all_products', NULL, NULL, NULL, 4, '2025-04-18 13:14:25', '2025-04-18 13:14:25'),
(206, 4, 'categories', NULL, NULL, NULL, 5, '2025-05-22 10:17:40', '2025-05-22 10:17:40'),
(207, 4, 'categories', NULL, NULL, NULL, 5, '2025-05-30 14:13:43', '2025-05-30 14:13:43');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `accounting_accounts`
--
ALTER TABLE `accounting_accounts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `accounting_accounts_transactions`
--
ALTER TABLE `accounting_accounts_transactions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `accounting_account_types`
--
ALTER TABLE `accounting_account_types`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `accounting_acc_trans_mappings`
--
ALTER TABLE `accounting_acc_trans_mappings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `accounting_budgets`
--
ALTER TABLE `accounting_budgets`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `accounts`
--
ALTER TABLE `accounts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `accounts_business_id_index` (`business_id`),
  ADD KEY `accounts_account_type_id_index` (`account_type_id`),
  ADD KEY `accounts_created_by_index` (`created_by`);

--
-- Indexes for table `account_transactions`
--
ALTER TABLE `account_transactions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `account_transactions_account_id_index` (`account_id`),
  ADD KEY `account_transactions_transaction_id_index` (`transaction_id`),
  ADD KEY `account_transactions_transaction_payment_id_index` (`transaction_payment_id`),
  ADD KEY `account_transactions_transfer_transaction_id_index` (`transfer_transaction_id`),
  ADD KEY `account_transactions_created_by_index` (`created_by`),
  ADD KEY `account_transactions_type_index` (`type`),
  ADD KEY `account_transactions_sub_type_index` (`sub_type`),
  ADD KEY `account_transactions_operation_date_index` (`operation_date`);

--
-- Indexes for table `account_types`
--
ALTER TABLE `account_types`
  ADD PRIMARY KEY (`id`),
  ADD KEY `account_types_parent_account_type_id_index` (`parent_account_type_id`),
  ADD KEY `account_types_business_id_index` (`business_id`);

--
-- Indexes for table `activity_log`
--
ALTER TABLE `activity_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `activity_log_log_name_index` (`log_name`);

--
-- Indexes for table `aiassistance_history`
--
ALTER TABLE `aiassistance_history`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `assets`
--
ALTER TABLE `assets`
  ADD PRIMARY KEY (`id`),
  ADD KEY `assets_business_id_foreign` (`business_id`),
  ADD KEY `assets_category_id_foreign` (`category_id`),
  ADD KEY `assets_created_by_foreign` (`created_by`);

--
-- Indexes for table `asset_maintenances`
--
ALTER TABLE `asset_maintenances`
  ADD PRIMARY KEY (`id`),
  ADD KEY `asset_maintenances_business_id_index` (`business_id`),
  ADD KEY `asset_maintenances_asset_id_index` (`asset_id`),
  ADD KEY `asset_maintenances_status_index` (`status`),
  ADD KEY `asset_maintenances_priority_index` (`priority`),
  ADD KEY `asset_maintenances_created_by_index` (`created_by`),
  ADD KEY `asset_maintenances_assigned_to_index` (`assigned_to`);

--
-- Indexes for table `asset_transactions`
--
ALTER TABLE `asset_transactions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `asset_transactions_business_id_foreign` (`business_id`),
  ADD KEY `asset_transactions_asset_id_foreign` (`asset_id`),
  ADD KEY `asset_transactions_receiver_foreign` (`receiver`),
  ADD KEY `asset_transactions_parent_id_foreign` (`parent_id`),
  ADD KEY `asset_transactions_created_by_foreign` (`created_by`);

--
-- Indexes for table `asset_warranties`
--
ALTER TABLE `asset_warranties`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `barcodes`
--
ALTER TABLE `barcodes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `barcodes_business_id_foreign` (`business_id`);

--
-- Indexes for table `bookings`
--
ALTER TABLE `bookings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `bookings_contact_id_foreign` (`contact_id`),
  ADD KEY `bookings_business_id_foreign` (`business_id`),
  ADD KEY `bookings_created_by_foreign` (`created_by`),
  ADD KEY `bookings_table_id_index` (`table_id`),
  ADD KEY `bookings_waiter_id_index` (`waiter_id`),
  ADD KEY `bookings_location_id_index` (`location_id`),
  ADD KEY `bookings_booking_status_index` (`booking_status`),
  ADD KEY `bookings_correspondent_id_index` (`correspondent_id`);

--
-- Indexes for table `brands`
--
ALTER TABLE `brands`
  ADD PRIMARY KEY (`id`),
  ADD KEY `brands_business_id_foreign` (`business_id`),
  ADD KEY `brands_created_by_foreign` (`created_by`);

--
-- Indexes for table `business_locations`
--
ALTER TABLE `business_locations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `business_locations_business_id_index` (`business_id`),
  ADD KEY `business_locations_invoice_scheme_id_foreign` (`invoice_scheme_id`),
  ADD KEY `business_locations_invoice_layout_id_foreign` (`invoice_layout_id`),
  ADD KEY `business_locations_sale_invoice_layout_id_index` (`sale_invoice_layout_id`),
  ADD KEY `business_locations_selling_price_group_id_index` (`selling_price_group_id`),
  ADD KEY `business_locations_receipt_printer_type_index` (`receipt_printer_type`),
  ADD KEY `business_locations_printer_id_index` (`printer_id`);

--
-- Indexes for table `cash_denominations`
--
ALTER TABLE `cash_denominations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `cash_denominations_model_type_model_id_index` (`model_type`,`model_id`);

--
-- Indexes for table `cash_gateway_companies`
--
ALTER TABLE `cash_gateway_companies`
  ADD PRIMARY KEY (`id`),
  ADD KEY `cash_gateway_companies_business_id_index` (`business_id`);

--
-- Indexes for table `cash_registers`
--
ALTER TABLE `cash_registers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `cash_registers_business_id_foreign` (`business_id`),
  ADD KEY `cash_registers_user_id_foreign` (`user_id`),
  ADD KEY `cash_registers_location_id_index` (`location_id`);

--
-- Indexes for table `cash_register_transactions`
--
ALTER TABLE `cash_register_transactions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `cash_register_transactions_cash_register_id_foreign` (`cash_register_id`),
  ADD KEY `cash_register_transactions_transaction_id_index` (`transaction_id`),
  ADD KEY `cash_register_transactions_type_index` (`type`),
  ADD KEY `cash_register_transactions_transaction_type_index` (`transaction_type`);

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `categories_business_id_foreign` (`business_id`),
  ADD KEY `categories_created_by_foreign` (`created_by`),
  ADD KEY `categories_parent_id_index` (`parent_id`),
  ADD KEY `categories_woocommerce_cat_id_index` (`woocommerce_cat_id`);

--
-- Indexes for table `categorizables`
--
ALTER TABLE `categorizables`
  ADD KEY `categorizables_categorizable_type_categorizable_id_index` (`categorizable_type`,`categorizable_id`);

--
-- Indexes for table `cms_pages`
--
ALTER TABLE `cms_pages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cms_page_metas`
--
ALTER TABLE `cms_page_metas`
  ADD PRIMARY KEY (`id`),
  ADD KEY `cms_page_metas_cms_page_id_foreign` (`cms_page_id`);

--
-- Indexes for table `cms_site_details`
--
ALTER TABLE `cms_site_details`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `contacts`
--
ALTER TABLE `contacts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `contacts_business_id_foreign` (`business_id`),
  ADD KEY `contacts_created_by_foreign` (`created_by`),
  ADD KEY `contacts_type_index` (`type`),
  ADD KEY `contacts_contact_status_index` (`contact_status`),
  ADD KEY `contacts_crm_source_index` (`crm_source`),
  ADD KEY `contacts_crm_life_stage_index` (`crm_life_stage`),
  ADD KEY `contacts_converted_by_index` (`converted_by`);

--
-- Indexes for table `crm_call_logs`
--
ALTER TABLE `crm_call_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `crm_call_logs_business_id_index` (`business_id`),
  ADD KEY `crm_call_logs_user_id_index` (`user_id`),
  ADD KEY `crm_call_logs_contact_id_index` (`contact_id`),
  ADD KEY `crm_call_logs_created_by_index` (`created_by`);

--
-- Indexes for table `crm_campaigns`
--
ALTER TABLE `crm_campaigns`
  ADD PRIMARY KEY (`id`),
  ADD KEY `crm_campaigns_business_id_foreign` (`business_id`),
  ADD KEY `crm_campaigns_created_by_index` (`created_by`);

--
-- Indexes for table `crm_contact_person_commissions`
--
ALTER TABLE `crm_contact_person_commissions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `crm_lead_users`
--
ALTER TABLE `crm_lead_users`
  ADD PRIMARY KEY (`id`),
  ADD KEY `crm_lead_users_user_id_index` (`user_id`),
  ADD KEY `crm_lead_users_contact_id_index` (`contact_id`);

--
-- Indexes for table `crm_marketplaces`
--
ALTER TABLE `crm_marketplaces`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `crm_proposals`
--
ALTER TABLE `crm_proposals`
  ADD PRIMARY KEY (`id`),
  ADD KEY `crm_proposals_business_id_foreign` (`business_id`),
  ADD KEY `crm_proposals_contact_id_foreign` (`contact_id`),
  ADD KEY `crm_proposals_sent_by_index` (`sent_by`);

--
-- Indexes for table `crm_proposal_templates`
--
ALTER TABLE `crm_proposal_templates`
  ADD PRIMARY KEY (`id`),
  ADD KEY `crm_proposal_templates_business_id_foreign` (`business_id`),
  ADD KEY `crm_proposal_templates_created_by_index` (`created_by`);

--
-- Indexes for table `crm_schedules`
--
ALTER TABLE `crm_schedules`
  ADD PRIMARY KEY (`id`),
  ADD KEY `crm_schedules_created_by_index` (`created_by`),
  ADD KEY `crm_schedules_business_id_index` (`business_id`),
  ADD KEY `crm_schedules_contact_id_index` (`contact_id`),
  ADD KEY `crm_schedules_schedule_type_index` (`schedule_type`),
  ADD KEY `crm_schedules_notify_type_index` (`notify_type`);

--
-- Indexes for table `crm_schedule_logs`
--
ALTER TABLE `crm_schedule_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `crm_schedule_logs_schedule_id_foreign` (`schedule_id`),
  ADD KEY `crm_schedule_logs_created_by_index` (`created_by`);

--
-- Indexes for table `crm_schedule_users`
--
ALTER TABLE `crm_schedule_users`
  ADD PRIMARY KEY (`id`),
  ADD KEY `crm_schedule_users_schedule_id_foreign` (`schedule_id`),
  ADD KEY `crm_schedule_users_user_id_index` (`user_id`);

--
-- Indexes for table `currencies`
--
ALTER TABLE `currencies`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `customer_groups`
--
ALTER TABLE `customer_groups`
  ADD PRIMARY KEY (`id`),
  ADD KEY `customer_groups_business_id_foreign` (`business_id`),
  ADD KEY `customer_groups_created_by_index` (`created_by`),
  ADD KEY `customer_groups_price_calculation_type_index` (`price_calculation_type`),
  ADD KEY `customer_groups_selling_price_group_id_index` (`selling_price_group_id`);

--
-- Indexes for table `dashboard_configurations`
--
ALTER TABLE `dashboard_configurations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `dashboard_configurations_business_id_foreign` (`business_id`);

--
-- Indexes for table `discounts`
--
ALTER TABLE `discounts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `discounts_business_id_index` (`business_id`),
  ADD KEY `discounts_brand_id_index` (`brand_id`),
  ADD KEY `discounts_category_id_index` (`category_id`),
  ADD KEY `discounts_location_id_index` (`location_id`),
  ADD KEY `discounts_priority_index` (`priority`),
  ADD KEY `discounts_spg_index` (`spg`);

--
-- Indexes for table `discount_variations`
--
ALTER TABLE `discount_variations`
  ADD KEY `discount_variations_discount_id_index` (`discount_id`),
  ADD KEY `discount_variations_variation_id_index` (`variation_id`);

--
-- Indexes for table `document_and_notes`
--
ALTER TABLE `document_and_notes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `document_and_notes_business_id_index` (`business_id`),
  ADD KEY `document_and_notes_notable_id_index` (`notable_id`),
  ADD KEY `document_and_notes_created_by_index` (`created_by`);

--
-- Indexes for table `essentials_allowances_and_deductions`
--
ALTER TABLE `essentials_allowances_and_deductions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `essentials_allowances_and_deductions_business_id_index` (`business_id`);

--
-- Indexes for table `essentials_attendances`
--
ALTER TABLE `essentials_attendances`
  ADD PRIMARY KEY (`id`),
  ADD KEY `essentials_attendances_user_id_index` (`user_id`),
  ADD KEY `essentials_attendances_business_id_index` (`business_id`),
  ADD KEY `essentials_attendances_essentials_shift_id_index` (`essentials_shift_id`);

--
-- Indexes for table `essentials_documents`
--
ALTER TABLE `essentials_documents`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `essentials_document_shares`
--
ALTER TABLE `essentials_document_shares`
  ADD PRIMARY KEY (`id`),
  ADD KEY `essentials_document_shares_document_id_index` (`document_id`),
  ADD KEY `essentials_document_shares_value_type_index` (`value_type`);

--
-- Indexes for table `essentials_holidays`
--
ALTER TABLE `essentials_holidays`
  ADD PRIMARY KEY (`id`),
  ADD KEY `essentials_holidays_business_id_index` (`business_id`),
  ADD KEY `essentials_holidays_location_id_index` (`location_id`);

--
-- Indexes for table `essentials_kb`
--
ALTER TABLE `essentials_kb`
  ADD PRIMARY KEY (`id`),
  ADD KEY `essentials_kb_business_id_index` (`business_id`),
  ADD KEY `essentials_kb_parent_id_index` (`parent_id`),
  ADD KEY `essentials_kb_created_by_index` (`created_by`);

--
-- Indexes for table `essentials_kb_users`
--
ALTER TABLE `essentials_kb_users`
  ADD PRIMARY KEY (`id`),
  ADD KEY `essentials_kb_users_kb_id_index` (`kb_id`),
  ADD KEY `essentials_kb_users_user_id_index` (`user_id`);

--
-- Indexes for table `essentials_leaves`
--
ALTER TABLE `essentials_leaves`
  ADD PRIMARY KEY (`id`),
  ADD KEY `essentials_leaves_essentials_leave_type_id_index` (`essentials_leave_type_id`),
  ADD KEY `essentials_leaves_business_id_index` (`business_id`),
  ADD KEY `essentials_leaves_user_id_index` (`user_id`);

--
-- Indexes for table `essentials_leave_types`
--
ALTER TABLE `essentials_leave_types`
  ADD PRIMARY KEY (`id`),
  ADD KEY `essentials_leave_types_business_id_index` (`business_id`);

--
-- Indexes for table `essentials_messages`
--
ALTER TABLE `essentials_messages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `essentials_messages_business_id_index` (`business_id`),
  ADD KEY `essentials_messages_user_id_index` (`user_id`),
  ADD KEY `essentials_messages_location_id_index` (`location_id`);

--
-- Indexes for table `essentials_payroll_groups`
--
ALTER TABLE `essentials_payroll_groups`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `essentials_payroll_group_transactions`
--
ALTER TABLE `essentials_payroll_group_transactions`
  ADD KEY `essentials_payroll_group_transactions_payroll_group_id_foreign` (`payroll_group_id`);

--
-- Indexes for table `essentials_reminders`
--
ALTER TABLE `essentials_reminders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `essentials_reminders_business_id_index` (`business_id`),
  ADD KEY `essentials_reminders_user_id_index` (`user_id`);

--
-- Indexes for table `essentials_shifts`
--
ALTER TABLE `essentials_shifts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `essentials_shifts_type_index` (`type`),
  ADD KEY `essentials_shifts_business_id_index` (`business_id`);

--
-- Indexes for table `essentials_todo_comments`
--
ALTER TABLE `essentials_todo_comments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `essentials_todo_comments_task_id_index` (`task_id`),
  ADD KEY `essentials_todo_comments_comment_by_index` (`comment_by`);

--
-- Indexes for table `essentials_to_dos`
--
ALTER TABLE `essentials_to_dos`
  ADD PRIMARY KEY (`id`),
  ADD KEY `essentials_to_dos_status_index` (`status`),
  ADD KEY `essentials_to_dos_priority_index` (`priority`),
  ADD KEY `essentials_to_dos_created_by_index` (`created_by`),
  ADD KEY `essentials_to_dos_business_id_index` (`business_id`),
  ADD KEY `essentials_to_dos_task_id_index` (`task_id`);

--
-- Indexes for table `essentials_user_allowance_and_deductions`
--
ALTER TABLE `essentials_user_allowance_and_deductions`
  ADD KEY `essentials_user_allowance_and_deductions_user_id_index` (`user_id`),
  ADD KEY `allow_deduct_index` (`allowance_deduction_id`);

--
-- Indexes for table `essentials_user_sales_targets`
--
ALTER TABLE `essentials_user_sales_targets`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `essentials_user_shifts`
--
ALTER TABLE `essentials_user_shifts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `essentials_user_shifts_user_id_index` (`user_id`),
  ADD KEY `essentials_user_shifts_essentials_shift_id_index` (`essentials_shift_id`);

--
-- Indexes for table `expense_categories`
--
ALTER TABLE `expense_categories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `expense_categories_business_id_foreign` (`business_id`);

--
-- Indexes for table `group_sub_taxes`
--
ALTER TABLE `group_sub_taxes`
  ADD KEY `group_sub_taxes_group_tax_id_foreign` (`group_tax_id`),
  ADD KEY `group_sub_taxes_tax_id_foreign` (`tax_id`);

--
-- Indexes for table `invoice_layouts`
--
ALTER TABLE `invoice_layouts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `invoice_layouts_business_id_foreign` (`business_id`);

--
-- Indexes for table `invoice_schemes`
--
ALTER TABLE `invoice_schemes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `invoice_schemes_business_id_foreign` (`business_id`),
  ADD KEY `invoice_schemes_scheme_type_index` (`scheme_type`),
  ADD KEY `invoice_schemes_number_type_index` (`number_type`);

--
-- Indexes for table `media`
--
ALTER TABLE `media`
  ADD PRIMARY KEY (`id`),
  ADD KEY `media_model_type_model_id_index` (`model_type`,`model_id`),
  ADD KEY `media_business_id_index` (`business_id`),
  ADD KEY `media_uploaded_by_index` (`uploaded_by`),
  ADD KEY `media_woocommerce_media_id_index` (`woocommerce_media_id`);

--
-- Indexes for table `mfg_ingredient_groups`
--
ALTER TABLE `mfg_ingredient_groups`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mfg_recipes`
--
ALTER TABLE `mfg_recipes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mfg_recipes_product_id_index` (`product_id`),
  ADD KEY `mfg_recipes_variation_id_index` (`variation_id`);

--
-- Indexes for table `mfg_recipe_ingredients`
--
ALTER TABLE `mfg_recipe_ingredients`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mfg_recipe_ingredients_mfg_recipe_id_index` (`mfg_recipe_id`),
  ADD KEY `mfg_recipe_ingredients_variation_id_index` (`variation_id`),
  ADD KEY `mfg_recipe_ingredients_sub_unit_id_index` (`sub_unit_id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  ADD KEY `model_has_permissions_model_type_model_id_index` (`model_type`,`model_id`);

--
-- Indexes for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  ADD KEY `model_has_roles_model_type_model_id_index` (`model_type`,`model_id`);

--
-- Indexes for table `notifications`
--
ALTER TABLE `notifications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `notifications_notifiable_type_notifiable_id_index` (`notifiable_type`,`notifiable_id`);

--
-- Indexes for table `notification_templates`
--
ALTER TABLE `notification_templates`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `oauth_auth_codes`
--
ALTER TABLE `oauth_auth_codes`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `oauth_personal_access_clients`
--
ALTER TABLE `oauth_personal_access_clients`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_personal_access_clients_client_id_index` (`client_id`);

--
-- Indexes for table `packages`
--
ALTER TABLE `packages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `pjt_invoice_lines`
--
ALTER TABLE `pjt_invoice_lines`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pjt_invoice_lines_transaction_id_foreign` (`transaction_id`),
  ADD KEY `pjt_invoice_lines_tax_rate_id_index` (`tax_rate_id`);

--
-- Indexes for table `pjt_projects`
--
ALTER TABLE `pjt_projects`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pjt_projects_business_id_index` (`business_id`),
  ADD KEY `pjt_projects_contact_id_index` (`contact_id`),
  ADD KEY `pjt_projects_lead_id_index` (`lead_id`),
  ADD KEY `pjt_projects_created_by_index` (`created_by`);

--
-- Indexes for table `pjt_project_members`
--
ALTER TABLE `pjt_project_members`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pjt_project_members_project_id_foreign` (`project_id`),
  ADD KEY `pjt_project_members_user_id_index` (`user_id`);

--
-- Indexes for table `pjt_project_tasks`
--
ALTER TABLE `pjt_project_tasks`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pjt_project_tasks_project_id_foreign` (`project_id`),
  ADD KEY `pjt_project_tasks_business_id_index` (`business_id`),
  ADD KEY `pjt_project_tasks_created_by_index` (`created_by`);

--
-- Indexes for table `pjt_project_task_comments`
--
ALTER TABLE `pjt_project_task_comments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pjt_project_task_comments_project_task_id_foreign` (`project_task_id`);

--
-- Indexes for table `pjt_project_task_members`
--
ALTER TABLE `pjt_project_task_members`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pjt_project_task_members_project_task_id_foreign` (`project_task_id`),
  ADD KEY `pjt_project_task_members_user_id_index` (`user_id`);

--
-- Indexes for table `pjt_project_time_logs`
--
ALTER TABLE `pjt_project_time_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pjt_project_time_logs_project_id_foreign` (`project_id`),
  ADD KEY `pjt_project_time_logs_project_task_id_foreign` (`project_task_id`),
  ADD KEY `pjt_project_time_logs_user_id_index` (`user_id`),
  ADD KEY `pjt_project_time_logs_created_by_index` (`created_by`);

--
-- Indexes for table `printers`
--
ALTER TABLE `printers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `printers_business_id_foreign` (`business_id`);

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`),
  ADD KEY `products_brand_id_foreign` (`brand_id`),
  ADD KEY `products_category_id_foreign` (`category_id`),
  ADD KEY `products_sub_category_id_foreign` (`sub_category_id`),
  ADD KEY `products_tax_foreign` (`tax`),
  ADD KEY `products_name_index` (`name`),
  ADD KEY `products_business_id_index` (`business_id`),
  ADD KEY `products_unit_id_index` (`unit_id`),
  ADD KEY `products_created_by_index` (`created_by`),
  ADD KEY `products_warranty_id_index` (`warranty_id`),
  ADD KEY `products_type_index` (`type`),
  ADD KEY `products_tax_type_index` (`tax_type`),
  ADD KEY `products_barcode_type_index` (`barcode_type`),
  ADD KEY `products_secondary_unit_id_index` (`secondary_unit_id`),
  ADD KEY `products_repair_model_id_index` (`repair_model_id`),
  ADD KEY `products_woocommerce_product_id_index` (`woocommerce_product_id`),
  ADD KEY `products_woocommerce_media_id_index` (`woocommerce_media_id`);

--
-- Indexes for table `product_locations`
--
ALTER TABLE `product_locations`
  ADD KEY `product_locations_product_id_index` (`product_id`),
  ADD KEY `product_locations_location_id_index` (`location_id`);

--
-- Indexes for table `product_racks`
--
ALTER TABLE `product_racks`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_racks_business_id_index` (`business_id`),
  ADD KEY `product_racks_location_id_index` (`location_id`),
  ADD KEY `product_racks_product_id_index` (`product_id`);

--
-- Indexes for table `product_variations`
--
ALTER TABLE `product_variations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_variations_name_index` (`name`),
  ADD KEY `product_variations_product_id_index` (`product_id`);

--
-- Indexes for table `purchase_lines`
--
ALTER TABLE `purchase_lines`
  ADD PRIMARY KEY (`id`),
  ADD KEY `purchase_lines_transaction_id_foreign` (`transaction_id`),
  ADD KEY `purchase_lines_product_id_foreign` (`product_id`),
  ADD KEY `purchase_lines_variation_id_foreign` (`variation_id`),
  ADD KEY `purchase_lines_tax_id_foreign` (`tax_id`),
  ADD KEY `purchase_lines_sub_unit_id_index` (`sub_unit_id`),
  ADD KEY `purchase_lines_lot_number_index` (`lot_number`);

--
-- Indexes for table `reference_counts`
--
ALTER TABLE `reference_counts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `reference_counts_business_id_index` (`business_id`);

--
-- Indexes for table `repair_device_models`
--
ALTER TABLE `repair_device_models`
  ADD PRIMARY KEY (`id`),
  ADD KEY `repair_device_models_business_id_index` (`business_id`),
  ADD KEY `repair_device_models_brand_id_index` (`brand_id`),
  ADD KEY `repair_device_models_device_id_index` (`device_id`),
  ADD KEY `repair_device_models_created_by_index` (`created_by`);

--
-- Indexes for table `repair_statuses`
--
ALTER TABLE `repair_statuses`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `res_product_modifier_sets`
--
ALTER TABLE `res_product_modifier_sets`
  ADD KEY `res_product_modifier_sets_modifier_set_id_foreign` (`modifier_set_id`);

--
-- Indexes for table `res_tables`
--
ALTER TABLE `res_tables`
  ADD PRIMARY KEY (`id`),
  ADD KEY `res_tables_business_id_foreign` (`business_id`);

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`),
  ADD KEY `roles_business_id_foreign` (`business_id`);

--
-- Indexes for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`role_id`),
  ADD KEY `role_has_permissions_role_id_foreign` (`role_id`);

--
-- Indexes for table `selling_price_groups`
--
ALTER TABLE `selling_price_groups`
  ADD PRIMARY KEY (`id`),
  ADD KEY `selling_price_groups_business_id_foreign` (`business_id`);

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD UNIQUE KEY `sessions_id_unique` (`id`);

--
-- Indexes for table `sheet_spreadsheets`
--
ALTER TABLE `sheet_spreadsheets`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sheet_spreadsheets_business_id_foreign` (`business_id`),
  ADD KEY `sheet_spreadsheets_created_by_index` (`created_by`);

--
-- Indexes for table `sheet_spreadsheet_shares`
--
ALTER TABLE `sheet_spreadsheet_shares`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sheet_spreadsheet_shares_sheet_spreadsheet_id_foreign` (`sheet_spreadsheet_id`),
  ADD KEY `sheet_spreadsheet_shares_shared_with_index` (`shared_with`),
  ADD KEY `sheet_spreadsheet_shares_shared_id_index` (`shared_id`);

--
-- Indexes for table `stock_adjustment_lines`
--
ALTER TABLE `stock_adjustment_lines`
  ADD PRIMARY KEY (`id`),
  ADD KEY `stock_adjustment_lines_product_id_foreign` (`product_id`),
  ADD KEY `stock_adjustment_lines_variation_id_foreign` (`variation_id`),
  ADD KEY `stock_adjustment_lines_transaction_id_index` (`transaction_id`),
  ADD KEY `stock_adjustment_lines_lot_no_line_id_index` (`lot_no_line_id`);

--
-- Indexes for table `subscriptions`
--
ALTER TABLE `subscriptions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `subscriptions_business_id_foreign` (`business_id`),
  ADD KEY `subscriptions_package_id_index` (`package_id`),
  ADD KEY `subscriptions_created_id_index` (`created_id`);

--
-- Indexes for table `superadmin_communicator_logs`
--
ALTER TABLE `superadmin_communicator_logs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `superadmin_frontend_pages`
--
ALTER TABLE `superadmin_frontend_pages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tax_rates`
--
ALTER TABLE `tax_rates`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tax_rates_business_id_foreign` (`business_id`),
  ADD KEY `tax_rates_created_by_foreign` (`created_by`),
  ADD KEY `tax_rates_woocommerce_tax_rate_id_index` (`woocommerce_tax_rate_id`);

--
-- Indexes for table `transaction_sell_lines`
--
ALTER TABLE `transaction_sell_lines`
  ADD PRIMARY KEY (`id`),
  ADD KEY `transaction_sell_lines_transaction_id_foreign` (`transaction_id`),
  ADD KEY `transaction_sell_lines_product_id_foreign` (`product_id`),
  ADD KEY `transaction_sell_lines_variation_id_foreign` (`variation_id`),
  ADD KEY `transaction_sell_lines_tax_id_foreign` (`tax_id`),
  ADD KEY `transaction_sell_lines_children_type_index` (`children_type`),
  ADD KEY `transaction_sell_lines_parent_sell_line_id_index` (`parent_sell_line_id`),
  ADD KEY `transaction_sell_lines_line_discount_type_index` (`line_discount_type`),
  ADD KEY `transaction_sell_lines_discount_id_index` (`discount_id`),
  ADD KEY `transaction_sell_lines_lot_no_line_id_index` (`lot_no_line_id`),
  ADD KEY `transaction_sell_lines_sub_unit_id_index` (`sub_unit_id`),
  ADD KEY `transaction_sell_lines_woocommerce_line_items_id_index` (`woocommerce_line_items_id`);

--
-- Indexes for table `transaction_sell_lines_purchase_lines`
--
ALTER TABLE `transaction_sell_lines_purchase_lines`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sell_line_id` (`sell_line_id`),
  ADD KEY `stock_adjustment_line_id` (`stock_adjustment_line_id`),
  ADD KEY `purchase_line_id` (`purchase_line_id`);

--
-- Indexes for table `types_of_services`
--
ALTER TABLE `types_of_services`
  ADD PRIMARY KEY (`id`),
  ADD KEY `types_of_services_business_id_index` (`business_id`);

--
-- Indexes for table `units`
--
ALTER TABLE `units`
  ADD PRIMARY KEY (`id`),
  ADD KEY `units_business_id_foreign` (`business_id`),
  ADD KEY `units_created_by_foreign` (`created_by`),
  ADD KEY `units_base_unit_id_index` (`base_unit_id`);

--
-- Indexes for table `user_contact_access`
--
ALTER TABLE `user_contact_access`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_contact_access_user_id_index` (`user_id`),
  ADD KEY `user_contact_access_contact_id_index` (`contact_id`);

--
-- Indexes for table `variations`
--
ALTER TABLE `variations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `variations_product_id_foreign` (`product_id`),
  ADD KEY `variations_product_variation_id_foreign` (`product_variation_id`),
  ADD KEY `variations_name_index` (`name`),
  ADD KEY `variations_sub_sku_index` (`sub_sku`),
  ADD KEY `variations_variation_value_id_index` (`variation_value_id`),
  ADD KEY `variations_woocommerce_variation_id_index` (`woocommerce_variation_id`);

--
-- Indexes for table `variation_group_prices`
--
ALTER TABLE `variation_group_prices`
  ADD PRIMARY KEY (`id`),
  ADD KEY `variation_group_prices_variation_id_foreign` (`variation_id`),
  ADD KEY `variation_group_prices_price_group_id_foreign` (`price_group_id`);

--
-- Indexes for table `variation_location_details`
--
ALTER TABLE `variation_location_details`
  ADD PRIMARY KEY (`id`),
  ADD KEY `variation_location_details_location_id_foreign` (`location_id`),
  ADD KEY `variation_location_details_product_id_index` (`product_id`),
  ADD KEY `variation_location_details_product_variation_id_index` (`product_variation_id`),
  ADD KEY `variation_location_details_variation_id_index` (`variation_id`);

--
-- Indexes for table `variation_templates`
--
ALTER TABLE `variation_templates`
  ADD PRIMARY KEY (`id`),
  ADD KEY `variation_templates_business_id_foreign` (`business_id`),
  ADD KEY `variation_templates_woocommerce_attr_id_index` (`woocommerce_attr_id`);

--
-- Indexes for table `variation_value_templates`
--
ALTER TABLE `variation_value_templates`
  ADD PRIMARY KEY (`id`),
  ADD KEY `variation_value_templates_name_index` (`name`),
  ADD KEY `variation_value_templates_variation_template_id_index` (`variation_template_id`);

--
-- Indexes for table `warranties`
--
ALTER TABLE `warranties`
  ADD PRIMARY KEY (`id`),
  ADD KEY `warranties_business_id_index` (`business_id`),
  ADD KEY `warranties_duration_type_index` (`duration_type`);

--
-- Indexes for table `woocommerce_sync_logs`
--
ALTER TABLE `woocommerce_sync_logs`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `accounting_accounts`
--
ALTER TABLE `accounting_accounts`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=88;

--
-- AUTO_INCREMENT for table `accounting_accounts_transactions`
--
ALTER TABLE `accounting_accounts_transactions`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `accounting_account_types`
--
ALTER TABLE `accounting_account_types`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=155;

--
-- AUTO_INCREMENT for table `accounting_acc_trans_mappings`
--
ALTER TABLE `accounting_acc_trans_mappings`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `accounting_budgets`
--
ALTER TABLE `accounting_budgets`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `accounts`
--
ALTER TABLE `accounts`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44;

--
-- AUTO_INCREMENT for table `account_transactions`
--
ALTER TABLE `account_transactions`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6537;

--
-- AUTO_INCREMENT for table `account_types`
--
ALTER TABLE `account_types`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `activity_log`
--
ALTER TABLE `activity_log`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9988;

--
-- AUTO_INCREMENT for table `aiassistance_history`
--
ALTER TABLE `aiassistance_history`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `assets`
--
ALTER TABLE `assets`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `asset_maintenances`
--
ALTER TABLE `asset_maintenances`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `asset_transactions`
--
ALTER TABLE `asset_transactions`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `asset_warranties`
--
ALTER TABLE `asset_warranties`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `barcodes`
--
ALTER TABLE `barcodes`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `bookings`
--
ALTER TABLE `bookings`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `brands`
--
ALTER TABLE `brands`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=42;

--
-- AUTO_INCREMENT for table `business_locations`
--
ALTER TABLE `business_locations`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `cash_denominations`
--
ALTER TABLE `cash_denominations`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cash_gateway_companies`
--
ALTER TABLE `cash_gateway_companies`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cash_registers`
--
ALTER TABLE `cash_registers`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=180;

--
-- AUTO_INCREMENT for table `cash_register_transactions`
--
ALTER TABLE `cash_register_transactions`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4636;

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT for table `cms_pages`
--
ALTER TABLE `cms_pages`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `cms_page_metas`
--
ALTER TABLE `cms_page_metas`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `cms_site_details`
--
ALTER TABLE `cms_site_details`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `contacts`
--
ALTER TABLE `contacts`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=78;

--
-- AUTO_INCREMENT for table `crm_call_logs`
--
ALTER TABLE `crm_call_logs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `crm_campaigns`
--
ALTER TABLE `crm_campaigns`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `crm_contact_person_commissions`
--
ALTER TABLE `crm_contact_person_commissions`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `crm_lead_users`
--
ALTER TABLE `crm_lead_users`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `crm_marketplaces`
--
ALTER TABLE `crm_marketplaces`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `crm_proposals`
--
ALTER TABLE `crm_proposals`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `crm_proposal_templates`
--
ALTER TABLE `crm_proposal_templates`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `crm_schedules`
--
ALTER TABLE `crm_schedules`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `crm_schedule_logs`
--
ALTER TABLE `crm_schedule_logs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `crm_schedule_users`
--
ALTER TABLE `crm_schedule_users`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `currencies`
--
ALTER TABLE `currencies`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=142;

--
-- AUTO_INCREMENT for table `customer_groups`
--
ALTER TABLE `customer_groups`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `dashboard_configurations`
--
ALTER TABLE `dashboard_configurations`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `discounts`
--
ALTER TABLE `discounts`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `document_and_notes`
--
ALTER TABLE `document_and_notes`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `essentials_allowances_and_deductions`
--
ALTER TABLE `essentials_allowances_and_deductions`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `essentials_attendances`
--
ALTER TABLE `essentials_attendances`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `essentials_documents`
--
ALTER TABLE `essentials_documents`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `essentials_document_shares`
--
ALTER TABLE `essentials_document_shares`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `essentials_holidays`
--
ALTER TABLE `essentials_holidays`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `essentials_kb`
--
ALTER TABLE `essentials_kb`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `essentials_kb_users`
--
ALTER TABLE `essentials_kb_users`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `essentials_leaves`
--
ALTER TABLE `essentials_leaves`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `essentials_leave_types`
--
ALTER TABLE `essentials_leave_types`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `essentials_messages`
--
ALTER TABLE `essentials_messages`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `essentials_payroll_groups`
--
ALTER TABLE `essentials_payroll_groups`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `essentials_reminders`
--
ALTER TABLE `essentials_reminders`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `essentials_shifts`
--
ALTER TABLE `essentials_shifts`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `essentials_todo_comments`
--
ALTER TABLE `essentials_todo_comments`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `essentials_to_dos`
--
ALTER TABLE `essentials_to_dos`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `essentials_user_sales_targets`
--
ALTER TABLE `essentials_user_sales_targets`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `essentials_user_shifts`
--
ALTER TABLE `essentials_user_shifts`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `expense_categories`
--
ALTER TABLE `expense_categories`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34;

--
-- AUTO_INCREMENT for table `invoice_layouts`
--
ALTER TABLE `invoice_layouts`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `invoice_schemes`
--
ALTER TABLE `invoice_schemes`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `media`
--
ALTER TABLE `media`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=153;

--
-- AUTO_INCREMENT for table `mfg_ingredient_groups`
--
ALTER TABLE `mfg_ingredient_groups`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mfg_recipes`
--
ALTER TABLE `mfg_recipes`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mfg_recipe_ingredients`
--
ALTER TABLE `mfg_recipe_ingredients`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=456;

--
-- AUTO_INCREMENT for table `notification_templates`
--
ALTER TABLE `notification_templates`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=71;

--
-- AUTO_INCREMENT for table `oauth_personal_access_clients`
--
ALTER TABLE `oauth_personal_access_clients`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `packages`
--
ALTER TABLE `packages`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=203;

--
-- AUTO_INCREMENT for table `pjt_invoice_lines`
--
ALTER TABLE `pjt_invoice_lines`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `pjt_projects`
--
ALTER TABLE `pjt_projects`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `pjt_project_members`
--
ALTER TABLE `pjt_project_members`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `pjt_project_tasks`
--
ALTER TABLE `pjt_project_tasks`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `pjt_project_task_comments`
--
ALTER TABLE `pjt_project_task_comments`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pjt_project_task_members`
--
ALTER TABLE `pjt_project_task_members`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `pjt_project_time_logs`
--
ALTER TABLE `pjt_project_time_logs`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `printers`
--
ALTER TABLE `printers`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=805;

--
-- AUTO_INCREMENT for table `product_racks`
--
ALTER TABLE `product_racks`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=630;

--
-- AUTO_INCREMENT for table `product_variations`
--
ALTER TABLE `product_variations`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=805;

--
-- AUTO_INCREMENT for table `purchase_lines`
--
ALTER TABLE `purchase_lines`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=287;

--
-- AUTO_INCREMENT for table `reference_counts`
--
ALTER TABLE `reference_counts`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=39;

--
-- AUTO_INCREMENT for table `repair_device_models`
--
ALTER TABLE `repair_device_models`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `repair_statuses`
--
ALTER TABLE `repair_statuses`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `res_tables`
--
ALTER TABLE `res_tables`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `selling_price_groups`
--
ALTER TABLE `selling_price_groups`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sheet_spreadsheets`
--
ALTER TABLE `sheet_spreadsheets`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sheet_spreadsheet_shares`
--
ALTER TABLE `sheet_spreadsheet_shares`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `stock_adjustment_lines`
--
ALTER TABLE `stock_adjustment_lines`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `subscriptions`
--
ALTER TABLE `subscriptions`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `superadmin_communicator_logs`
--
ALTER TABLE `superadmin_communicator_logs`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `superadmin_frontend_pages`
--
ALTER TABLE `superadmin_frontend_pages`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tax_rates`
--
ALTER TABLE `tax_rates`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `transaction_sell_lines`
--
ALTER TABLE `transaction_sell_lines`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4595;

--
-- AUTO_INCREMENT for table `transaction_sell_lines_purchase_lines`
--
ALTER TABLE `transaction_sell_lines_purchase_lines`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4536;

--
-- AUTO_INCREMENT for table `types_of_services`
--
ALTER TABLE `types_of_services`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `units`
--
ALTER TABLE `units`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `user_contact_access`
--
ALTER TABLE `user_contact_access`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `variations`
--
ALTER TABLE `variations`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=805;

--
-- AUTO_INCREMENT for table `variation_group_prices`
--
ALTER TABLE `variation_group_prices`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `variation_location_details`
--
ALTER TABLE `variation_location_details`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=251;

--
-- AUTO_INCREMENT for table `variation_templates`
--
ALTER TABLE `variation_templates`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `variation_value_templates`
--
ALTER TABLE `variation_value_templates`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `warranties`
--
ALTER TABLE `warranties`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `woocommerce_sync_logs`
--
ALTER TABLE `woocommerce_sync_logs`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=209;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `assets`
--
ALTER TABLE `assets`
  ADD CONSTRAINT `assets_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `assets_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`),
  ADD CONSTRAINT `assets_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `asset_transactions`
--
ALTER TABLE `asset_transactions`
  ADD CONSTRAINT `asset_transactions_asset_id_foreign` FOREIGN KEY (`asset_id`) REFERENCES `assets` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `asset_transactions_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `asset_transactions_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `asset_transactions_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `asset_transactions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `asset_transactions_receiver_foreign` FOREIGN KEY (`receiver`) REFERENCES `users` (`id`);

--
-- Constraints for table `barcodes`
--
ALTER TABLE `barcodes`
  ADD CONSTRAINT `barcodes_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `bookings`
--
ALTER TABLE `bookings`
  ADD CONSTRAINT `bookings_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `bookings_contact_id_foreign` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `bookings_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `brands`
--
ALTER TABLE `brands`
  ADD CONSTRAINT `brands_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `brands_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `business_locations`
--
ALTER TABLE `business_locations`
  ADD CONSTRAINT `business_locations_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `business_locations_invoice_layout_id_foreign` FOREIGN KEY (`invoice_layout_id`) REFERENCES `invoice_layouts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `business_locations_invoice_scheme_id_foreign` FOREIGN KEY (`invoice_scheme_id`) REFERENCES `invoice_schemes` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `cash_registers`
--
ALTER TABLE `cash_registers`
  ADD CONSTRAINT `cash_registers_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `cash_registers_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `cash_register_transactions`
--
ALTER TABLE `cash_register_transactions`
  ADD CONSTRAINT `cash_register_transactions_cash_register_id_foreign` FOREIGN KEY (`cash_register_id`) REFERENCES `cash_registers` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `categories`
--
ALTER TABLE `categories`
  ADD CONSTRAINT `categories_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `categories_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `cms_page_metas`
--
ALTER TABLE `cms_page_metas`
  ADD CONSTRAINT `cms_page_metas_cms_page_id_foreign` FOREIGN KEY (`cms_page_id`) REFERENCES `cms_pages` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `contacts`
--
ALTER TABLE `contacts`
  ADD CONSTRAINT `contacts_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `contacts_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `crm_campaigns`
--
ALTER TABLE `crm_campaigns`
  ADD CONSTRAINT `crm_campaigns_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `crm_lead_users`
--
ALTER TABLE `crm_lead_users`
  ADD CONSTRAINT `crm_lead_users_contact_id_foreign` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `crm_proposals`
--
ALTER TABLE `crm_proposals`
  ADD CONSTRAINT `crm_proposals_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `crm_proposals_contact_id_foreign` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `crm_proposal_templates`
--
ALTER TABLE `crm_proposal_templates`
  ADD CONSTRAINT `crm_proposal_templates_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `crm_schedules`
--
ALTER TABLE `crm_schedules`
  ADD CONSTRAINT `crm_schedules_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `crm_schedule_logs`
--
ALTER TABLE `crm_schedule_logs`
  ADD CONSTRAINT `crm_schedule_logs_schedule_id_foreign` FOREIGN KEY (`schedule_id`) REFERENCES `crm_schedules` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `crm_schedule_users`
--
ALTER TABLE `crm_schedule_users`
  ADD CONSTRAINT `crm_schedule_users_schedule_id_foreign` FOREIGN KEY (`schedule_id`) REFERENCES `crm_schedules` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `customer_groups`
--
ALTER TABLE `customer_groups`
  ADD CONSTRAINT `customer_groups_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `dashboard_configurations`
--
ALTER TABLE `dashboard_configurations`
  ADD CONSTRAINT `dashboard_configurations_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `essentials_kb`
--
ALTER TABLE `essentials_kb`
  ADD CONSTRAINT `essentials_kb_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `essentials_kb` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `essentials_payroll_group_transactions`
--
ALTER TABLE `essentials_payroll_group_transactions`
  ADD CONSTRAINT `essentials_payroll_group_transactions_payroll_group_id_foreign` FOREIGN KEY (`payroll_group_id`) REFERENCES `essentials_payroll_groups` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `expense_categories`
--
ALTER TABLE `expense_categories`
  ADD CONSTRAINT `expense_categories_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `group_sub_taxes`
--
ALTER TABLE `group_sub_taxes`
  ADD CONSTRAINT `group_sub_taxes_group_tax_id_foreign` FOREIGN KEY (`group_tax_id`) REFERENCES `tax_rates` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `group_sub_taxes_tax_id_foreign` FOREIGN KEY (`tax_id`) REFERENCES `tax_rates` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `invoice_layouts`
--
ALTER TABLE `invoice_layouts`
  ADD CONSTRAINT `invoice_layouts_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `invoice_schemes`
--
ALTER TABLE `invoice_schemes`
  ADD CONSTRAINT `invoice_schemes_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `mfg_recipe_ingredients`
--
ALTER TABLE `mfg_recipe_ingredients`
  ADD CONSTRAINT `mfg_recipe_ingredients_mfg_recipe_id_foreign` FOREIGN KEY (`mfg_recipe_id`) REFERENCES `mfg_recipes` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `pjt_invoice_lines`
--
ALTER TABLE `pjt_invoice_lines`
  ADD CONSTRAINT `pjt_invoice_lines_transaction_id_foreign` FOREIGN KEY (`transaction_id`) REFERENCES `transactions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `pjt_project_members`
--
ALTER TABLE `pjt_project_members`
  ADD CONSTRAINT `pjt_project_members_project_id_foreign` FOREIGN KEY (`project_id`) REFERENCES `pjt_projects` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `pjt_project_tasks`
--
ALTER TABLE `pjt_project_tasks`
  ADD CONSTRAINT `pjt_project_tasks_project_id_foreign` FOREIGN KEY (`project_id`) REFERENCES `pjt_projects` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `pjt_project_task_comments`
--
ALTER TABLE `pjt_project_task_comments`
  ADD CONSTRAINT `pjt_project_task_comments_project_task_id_foreign` FOREIGN KEY (`project_task_id`) REFERENCES `pjt_project_tasks` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `pjt_project_task_members`
--
ALTER TABLE `pjt_project_task_members`
  ADD CONSTRAINT `pjt_project_task_members_project_task_id_foreign` FOREIGN KEY (`project_task_id`) REFERENCES `pjt_project_tasks` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `pjt_project_time_logs`
--
ALTER TABLE `pjt_project_time_logs`
  ADD CONSTRAINT `pjt_project_time_logs_project_id_foreign` FOREIGN KEY (`project_id`) REFERENCES `pjt_projects` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `pjt_project_time_logs_project_task_id_foreign` FOREIGN KEY (`project_task_id`) REFERENCES `pjt_project_tasks` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `printers`
--
ALTER TABLE `printers`
  ADD CONSTRAINT `printers_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `products`
--
ALTER TABLE `products`
  ADD CONSTRAINT `products_brand_id_foreign` FOREIGN KEY (`brand_id`) REFERENCES `brands` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `products_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `products_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `products_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `products_repair_model_id_foreign` FOREIGN KEY (`repair_model_id`) REFERENCES `repair_device_models` (`id`),
  ADD CONSTRAINT `products_sub_category_id_foreign` FOREIGN KEY (`sub_category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `products_tax_foreign` FOREIGN KEY (`tax`) REFERENCES `tax_rates` (`id`),
  ADD CONSTRAINT `products_unit_id_foreign` FOREIGN KEY (`unit_id`) REFERENCES `units` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `product_variations`
--
ALTER TABLE `product_variations`
  ADD CONSTRAINT `product_variations_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `purchase_lines`
--
ALTER TABLE `purchase_lines`
  ADD CONSTRAINT `purchase_lines_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `purchase_lines_tax_id_foreign` FOREIGN KEY (`tax_id`) REFERENCES `tax_rates` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `purchase_lines_transaction_id_foreign` FOREIGN KEY (`transaction_id`) REFERENCES `transactions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `purchase_lines_variation_id_foreign` FOREIGN KEY (`variation_id`) REFERENCES `variations` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `repair_device_models`
--
ALTER TABLE `repair_device_models`
  ADD CONSTRAINT `repair_device_models_brand_id_foreign` FOREIGN KEY (`brand_id`) REFERENCES `brands` (`id`),
  ADD CONSTRAINT `repair_device_models_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `repair_device_models_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `repair_device_models_device_id_foreign` FOREIGN KEY (`device_id`) REFERENCES `categories` (`id`);

--
-- Constraints for table `res_product_modifier_sets`
--
ALTER TABLE `res_product_modifier_sets`
  ADD CONSTRAINT `res_product_modifier_sets_modifier_set_id_foreign` FOREIGN KEY (`modifier_set_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `res_tables`
--
ALTER TABLE `res_tables`
  ADD CONSTRAINT `res_tables_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `roles`
--
ALTER TABLE `roles`
  ADD CONSTRAINT `roles_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `selling_price_groups`
--
ALTER TABLE `selling_price_groups`
  ADD CONSTRAINT `selling_price_groups_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `sheet_spreadsheets`
--
ALTER TABLE `sheet_spreadsheets`
  ADD CONSTRAINT `sheet_spreadsheets_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `sheet_spreadsheet_shares`
--
ALTER TABLE `sheet_spreadsheet_shares`
  ADD CONSTRAINT `sheet_spreadsheet_shares_sheet_spreadsheet_id_foreign` FOREIGN KEY (`sheet_spreadsheet_id`) REFERENCES `sheet_spreadsheets` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `stock_adjustment_lines`
--
ALTER TABLE `stock_adjustment_lines`
  ADD CONSTRAINT `stock_adjustment_lines_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `stock_adjustment_lines_transaction_id_foreign` FOREIGN KEY (`transaction_id`) REFERENCES `transactions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `stock_adjustment_lines_variation_id_foreign` FOREIGN KEY (`variation_id`) REFERENCES `variations` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `subscriptions`
--
ALTER TABLE `subscriptions`
  ADD CONSTRAINT `subscriptions_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `tax_rates`
--
ALTER TABLE `tax_rates`
  ADD CONSTRAINT `tax_rates_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `tax_rates_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `transaction_sell_lines`
--
ALTER TABLE `transaction_sell_lines`
  ADD CONSTRAINT `transaction_sell_lines_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `transaction_sell_lines_tax_id_foreign` FOREIGN KEY (`tax_id`) REFERENCES `tax_rates` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `transaction_sell_lines_transaction_id_foreign` FOREIGN KEY (`transaction_id`) REFERENCES `transactions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `transaction_sell_lines_variation_id_foreign` FOREIGN KEY (`variation_id`) REFERENCES `variations` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `units`
--
ALTER TABLE `units`
  ADD CONSTRAINT `units_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `units_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `variations`
--
ALTER TABLE `variations`
  ADD CONSTRAINT `variations_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `variations_product_variation_id_foreign` FOREIGN KEY (`product_variation_id`) REFERENCES `product_variations` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `variation_group_prices`
--
ALTER TABLE `variation_group_prices`
  ADD CONSTRAINT `variation_group_prices_price_group_id_foreign` FOREIGN KEY (`price_group_id`) REFERENCES `selling_price_groups` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `variation_group_prices_variation_id_foreign` FOREIGN KEY (`variation_id`) REFERENCES `variations` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `variation_location_details`
--
ALTER TABLE `variation_location_details`
  ADD CONSTRAINT `variation_location_details_location_id_foreign` FOREIGN KEY (`location_id`) REFERENCES `business_locations` (`id`),
  ADD CONSTRAINT `variation_location_details_variation_id_foreign` FOREIGN KEY (`variation_id`) REFERENCES `variations` (`id`);

--
-- Constraints for table `variation_templates`
--
ALTER TABLE `variation_templates`
  ADD CONSTRAINT `variation_templates_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `variation_value_templates`
--
ALTER TABLE `variation_value_templates`
  ADD CONSTRAINT `variation_value_templates_variation_template_id_foreign` FOREIGN KEY (`variation_template_id`) REFERENCES `variation_templates` (`id`) ON DELETE CASCADE;
COMMIT;

