-- https://www.phpmyadmin.net/
--

START TRANSACTION;



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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tenant_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `deleted_by` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`id`, `tenant_id`, `name`, `is_active`, `created_by`, `updated_by`, `deleted_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 2, 'Makanan', 1, 2, 2, NULL, '2026-01-05 21:59:26', '2026-01-05 21:59:26', NULL),
(2, 2, 'Minuman', 1, 2, 2, NULL, '2026-01-05 21:59:32', '2026-01-05 21:59:32', NULL),
(3, 4, 'Makanan', 1, 6, 6, NULL, '2026-01-18 13:15:33', '2026-01-18 13:15:33', NULL),
(4, 4, 'Minuman', 1, 6, 6, NULL, '2026-01-18 13:15:46', '2026-01-18 13:15:46', NULL),
(5, 5, '1 porsi 10 tusuk', 1, 7, 7, 7, '2026-01-19 08:52:13', '2026-01-19 09:26:27', '2026-01-19 09:26:27'),
(6, 5, 'Makanan', 1, 7, 7, NULL, '2026-01-19 09:24:46', '2026-01-19 09:24:46', NULL),
(7, 5, 'Minuman', 1, 7, 7, NULL, '2026-01-19 09:24:57', '2026-01-19 09:24:57', NULL),
(8, 5, 'Makanan ringan', 1, 7, 7, NULL, '2026-01-19 09:25:26', '2026-01-19 09:25:26', NULL);

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

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) UNSIGNED NOT NULL,
  `reserved_at` int(10) UNSIGNED DEFAULT NULL,
  `available_at` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `job_batches`
--

CREATE TABLE `job_batches` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` longtext NOT NULL,
  `options` mediumtext DEFAULT NULL,
  `cancelled_at` int(11) DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `finished_at` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `medias`
--

CREATE TABLE `medias` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `file_name` varchar(255) NOT NULL,
  `file_path` varchar(255) NOT NULL,
  `file_mime_type` varchar(255) DEFAULT NULL,
  `file_type` enum('USER','PRODUCT','TENANT') NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `medias`
--

INSERT INTO `medias` (`id`, `file_name`, `file_path`, `file_mime_type`, `file_type`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'TEST-sate-ayam.jpg', 'stoediolaman/kastoed/media/test/FEXCmAQ0OPxTRkuD4u7OcyPPDXIEqBnuoyWgyC5p.jpg', NULL, 'PRODUCT', '2026-01-05 22:01:26', '2026-01-05 22:01:26', NULL),
(2, 'TEST-teh-leci.png', 'stoediolaman/kastoed/media/test/LCS8g2BlDDK5h9hDttdcWjfNj5DEx0aC01YtgkYV.png', NULL, 'PRODUCT', '2026-01-05 22:02:23', '2026-01-05 22:02:23', NULL),
(3, 'rumah-spongebob.jpg', 'stoediolaman/kastoed/media/test/QZ7VBGP8Its5jsdJeEsXJdb8JYKNLeaWjvglVdEp.jpg', NULL, 'TENANT', '2026-01-12 16:04:16', '2026-01-12 16:04:16', NULL),
(4, 'IMG-20250930-WA0006.jpg', 'stoediolaman/kastoed/media/test/8gPws73nndsiXXK6UBITBM7Y8UDaXPBLxCW0S2jb.jpg', NULL, 'PRODUCT', '2026-01-13 12:55:30', '2026-01-13 12:55:30', NULL),
(5, 'download.jpeg', 'stoediolaman/kastoed/media/test/6emZDRKOm5AVCsdQcnsCxjBnKLROkFJcZvWU46YH.jpg', NULL, 'PRODUCT', '2026-01-17 13:25:44', '2026-01-17 13:25:44', NULL),
(6, '0D8EE2AC-F6A5-4F8D-9ECA-BD66B4218797.jpeg', 'stoediolaman/kastoed/media/test/Y0nUnJ6CGYC3KVUbNo496qhCVIMZaRLnuQDCIJee.jpg', NULL, 'PRODUCT', '2026-01-18 13:16:25', '2026-01-18 13:16:25', NULL),
(7, '2456B7B5-9CC4-484F-BEB7-5B66F820E3EF.jpeg', 'stoediolaman/kastoed/media/test/4zOcwU8rSA18BrGCPpoyxALeVk7h5WVvEpRc8xRD.jpg', NULL, 'PRODUCT', '2026-01-18 13:20:19', '2026-01-18 13:20:19', NULL),
(8, '9B87B14D-DF6A-470C-AC08-C0DB30BECBAA.jpeg', 'stoediolaman/kastoed/media/test/EguNvMqBLl3TFlYkdyPdIB8NdofXg5hUMdcbb4wl.jpg', NULL, 'PRODUCT', '2026-01-18 13:21:36', '2026-01-18 13:21:36', NULL);

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '0001_01_01_000000_create_users_table', 1),
(2, '0001_01_01_000001_create_cache_table', 1),
(3, '0001_01_01_000002_create_jobs_table', 1),
(4, '2025_12_11_010407_create_medias_table', 1),
(5, '2025_12_11_010407_create_order_statuses_table', 1),
(6, '2025_12_11_010407_create_payment_methods_table', 1),
(7, '2025_12_11_010407_create_roles_table', 1),
(8, '2025_12_11_010407_create_subscription_statuses_table', 1),
(9, '2025_12_11_010532_create_tenants_table', 1),
(10, '2025_12_11_010606_add_columns_to_users_table', 1),
(11, '2025_12_11_010606_create_categories_table', 1),
(12, '2025_12_11_010606_create_products_table', 1),
(13, '2025_12_11_010713_create_orders_table', 1),
(14, '2025_12_11_010714_create_order_items_table', 1),
(15, '2025_12_21_084404_create_permission_tables', 1),
(16, '2025_12_21_094000_add_guard_name_to_roles_table', 1);

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

--
-- Table structure for table `model_has_permissions`
--

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(255) NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `model_has_roles`
--

CREATE TABLE `model_has_roles` (
  `role_id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(255) NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_roles`
--

INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES
(1, 'App\\Models\\User', 1),
(2, 'App\\Models\\User', 2),
(2, 'App\\Models\\User', 3),
(2, 'App\\Models\\User', 6),
(2, 'App\\Models\\User', 7),
(2, 'App\\Models\\User', 8),
(2, 'App\\Models\\User', 9);

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

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tenant_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `order_number` varchar(255) NOT NULL,
  `customer_name` varchar(255) NOT NULL,
  `total_amount` decimal(15,2) NOT NULL,
  `payment_method_id` bigint(20) UNSIGNED NOT NULL,
  `payment_amount` decimal(15,2) NOT NULL,
  `change_amount` decimal(15,2) NOT NULL DEFAULT 0.00,
  `order_status_id` bigint(20) UNSIGNED NOT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `deleted_by` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `orders`
--

INSERT INTO `orders` (`id`, `tenant_id`, `user_id`, `order_number`, `customer_name`, `total_amount`, `payment_method_id`, `payment_amount`, `change_amount`, `order_status_id`, `created_by`, `updated_by`, `deleted_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 2, 2, 'INV-1767650600-720', 'TEST Guest 1', 25000.00, 1, 50000.00, 25000.00, 2, 2, 2, NULL, '2026-01-05 22:03:20', '2026-01-05 22:03:20', NULL),
(2, 2, 1, 'INV-1767686363-374', 'Guest', 30000.00, 1, 1000000.00, 970000.00, 2, 1, 1, NULL, '2026-01-06 07:59:23', '2026-01-06 07:59:23', NULL),
(3, 2, 2, 'INV-1768307950-398', 'beta', 25000.00, 1, 100000.00, 75000.00, 2, 2, 2, NULL, '2026-01-13 12:39:10', '2026-01-13 12:39:10', NULL),
(4, 2, 2, 'INV-1768448097-544', 'Betet', 75000.00, 2, 100000.00, 25000.00, 2, 2, 2, NULL, '2026-01-15 03:34:57', '2026-01-15 03:34:57', NULL),
(5, 2, 2, 'INV-1768458883-829', 'Beya', 10000.00, 1, 50000.00, 40000.00, 2, 2, 2, NULL, '2026-01-15 06:34:43', '2026-01-15 06:34:43', NULL),
(6, 2, 2, 'INV-1768495702-647', 'Yanto', 40000.00, 1, 50000.00, 10000.00, 2, 2, 2, NULL, '2026-01-15 16:48:22', '2026-01-15 16:48:22', NULL),
(7, 2, 2, 'INV-1768495705-812', 'Guest', 0.00, 1, 50000.00, 50000.00, 2, 2, 2, NULL, '2026-01-15 16:48:25', '2026-01-15 16:48:25', NULL),
(8, 2, 2, 'INV-1768495705-232', 'Guest', 0.00, 1, 50000.00, 50000.00, 2, 2, 2, NULL, '2026-01-15 16:48:25', '2026-01-15 16:48:25', NULL),
(9, 2, 2, 'INV-1768524624-197', 'Guest', 65000.00, 1, 100000.00, 35000.00, 2, 2, 2, NULL, '2026-01-16 00:50:24', '2026-01-16 00:50:24', NULL),
(10, 2, 2, 'INV-1768554867-591', 'Guest', 15000.00, 2, 15000.00, 0.00, 2, 2, 2, NULL, '2026-01-16 09:14:27', '2026-01-16 09:14:27', NULL),
(11, 2, 2, 'INV-1768554873-477', 'Guest', 0.00, 2, 15000.00, 15000.00, 2, 2, 2, NULL, '2026-01-16 09:14:33', '2026-01-16 09:14:33', NULL),
(12, 2, 2, 'INV-1768736475-600', 'Guest', 500.00, 1, 500.00, 0.00, 2, 2, 2, NULL, '2026-01-18 11:41:15', '2026-01-18 11:41:15', NULL),
(13, 2, 2, 'INV-1768736480-325', 'Guest', 0.00, 1, 500.00, 500.00, 2, 2, 2, NULL, '2026-01-18 11:41:20', '2026-01-18 11:41:20', NULL),
(14, 4, 6, 'INV-1768742583-466', 'Heri', 10000.00, 1, 10000.00, 0.00, 2, 6, 6, NULL, '2026-01-18 13:23:03', '2026-01-18 13:23:03', NULL),
(15, 2, 2, 'INV-1768784213-198', 'Guest', 35000.00, 1, 100000.00, 65000.00, 2, 2, 2, NULL, '2026-01-19 00:56:53', '2026-01-19 00:56:53', NULL),
(16, 2, 2, 'INV-1768784219-220', 'Guest', 0.00, 1, 1000000.00, 1000000.00, 2, 2, 2, NULL, '2026-01-19 00:56:59', '2026-01-19 00:56:59', NULL),
(17, 2, 2, 'INV-1768821565-568', 'Es teh ', 35000.00, 1, 50000.00, 15000.00, 2, 2, 2, NULL, '2026-01-19 11:19:25', '2026-01-19 11:19:25', NULL),
(18, 2, 2, 'INV-1768821570-566', 'Guest', 0.00, 1, 50000.00, 50000.00, 2, 2, 2, NULL, '2026-01-19 11:19:30', '2026-01-19 11:19:30', NULL),
(19, 5, 7, 'INV-1768826717-675', 'Pa Haji maper', 80000.00, 1, 100000.00, 20000.00, 2, 7, 7, NULL, '2026-01-19 12:45:17', '2026-01-19 12:45:17', NULL),
(20, 5, 7, 'INV-1768826920-918', 'Sels depo kramik', 41000.00, 1, 41000.00, 0.00, 2, 7, 7, NULL, '2026-01-19 12:48:40', '2026-01-19 12:48:40', NULL),
(21, 5, 7, 'INV-1768828189-710', 'Teh liza', 80000.00, 1, 100000.00, 20000.00, 2, 7, 7, NULL, '2026-01-19 13:09:49', '2026-01-19 13:09:49', NULL),
(22, 5, 7, 'INV-1768889013-910', 'Guest', 20000.00, 1, 20000.00, 0.00, 2, 7, 7, NULL, '2026-01-20 06:03:33', '2026-01-20 06:03:33', NULL),
(23, 5, 7, 'INV-1768976495-828', 'Kang Deden Benkel', 40000.00, 1, 40000.00, 0.00, 2, 7, 7, NULL, '2026-01-21 06:21:35', '2026-01-21 07:28:57', NULL),
(24, 5, 7, 'INV-1768979825-907', 'Tni', 18000.00, 2, 18000.00, 0.00, 2, 7, 7, NULL, '2026-01-21 07:17:05', '2026-01-21 07:17:05', NULL),
(25, 5, 7, 'INV-1768979921-652', 'Meja 1', 68000.00, 1, 100000.00, 32000.00, 2, 7, 7, NULL, '2026-01-21 07:18:41', '2026-01-21 07:18:41', NULL),
(26, 5, 7, 'INV-1768988831-980', 'Ibu enci pabrik', 21000.00, 1, 50000.00, 29000.00, 2, 7, 7, NULL, '2026-01-21 09:47:11', '2026-01-21 09:47:11', NULL),
(27, 5, 7, 'INV-1768997047-394', 'Kang Deden bengkel', 40000.00, 1, 50000.00, 10000.00, 2, 7, 7, NULL, '2026-01-21 12:04:07', '2026-01-21 12:04:07', NULL),
(28, 5, 7, 'INV-1769061110-403', 'Meja 5 / teteh teteh 2org', 39000.00, 1, 40000.00, 1000.00, 2, 7, 7, NULL, '2026-01-22 05:51:50', '2026-01-22 05:51:50', NULL),
(29, 5, 7, 'INV-1769162542-902', 'Kang deden', 28000.00, 1, 50000.00, 22000.00, 2, 7, 7, NULL, '2026-01-23 10:02:22', '2026-01-23 10:02:22', NULL),
(30, 5, 7, 'INV-1769162604-911', 'Venamon', 36000.00, 1, 50000.00, 14000.00, 2, 7, 7, NULL, '2026-01-23 10:03:24', '2026-01-23 10:03:24', NULL),
(31, 5, 7, 'INV-1769234238-627', 'Ibu pabrik', 11000.00, 1, 11000.00, 0.00, 2, 7, 7, NULL, '2026-01-24 05:57:18', '2026-01-24 05:57:18', NULL),
(32, 5, 7, 'INV-1769234238-694', 'Guest', 0.00, 1, 11000.00, 11000.00, 2, 7, 7, NULL, '2026-01-24 05:57:18', '2026-01-24 05:57:18', NULL),
(33, 5, 7, 'INV-1769242662-388', 'Sekeluarga', 48000.00, 2, 48000.00, 0.00, 2, 7, 7, NULL, '2026-01-24 08:17:42', '2026-01-24 08:17:42', NULL),
(34, 5, 7, 'INV-1769255475-537', 'Apih', 20000.00, 1, 50000.00, 30000.00, 2, 7, 7, NULL, '2026-01-24 11:51:15', '2026-01-24 11:51:15', NULL),
(35, 5, 7, 'INV-1769316870-197', 'Meja1', 28000.00, 1, 30000.00, 2000.00, 2, 7, 7, NULL, '2026-01-25 04:54:30', '2026-01-25 04:54:30', NULL),
(36, 5, 7, 'INV-1769331632-284', 'Guest', 123000.00, 1, 150000.00, 27000.00, 2, 7, 7, NULL, '2026-01-25 09:00:32', '2026-01-25 09:00:32', NULL),
(37, 5, 7, 'INV-1769344647-227', 'Farid', 60000.00, 1, 60000.00, 0.00, 2, 7, 7, NULL, '2026-01-25 12:37:27', '2026-01-25 12:37:27', NULL),
(38, 5, 7, 'INV-1769405115-213', 'Ibu pabrik', 16000.00, 1, 16000.00, 0.00, 2, 7, 7, NULL, '2026-01-26 05:25:15', '2026-01-26 05:25:15', NULL),
(39, 5, 7, 'INV-1769419306-418', 'Guest', 40000.00, 1, 50000.00, 10000.00, 2, 7, 7, NULL, '2026-01-26 09:21:46', '2026-01-26 09:21:46', NULL),
(40, 5, 7, 'INV-1769575829-771', 'Anak muda pasangan', 48000.00, 1, 50000.00, 2000.00, 2, 7, 7, NULL, '2026-01-28 04:50:29', '2026-01-28 04:50:29', NULL),
(41, 5, 7, 'INV-1769580811-354', 'Ibu pabrik', 16000.00, 1, 50000.00, 34000.00, 2, 7, 7, NULL, '2026-01-28 06:13:31', '2026-01-28 06:13:31', NULL),
(42, 5, 7, 'INV-1769589045-241', 'Sunarti sayati', 39000.00, 1, 50000.00, 11000.00, 2, 7, 7, NULL, '2026-01-28 08:30:45', '2026-01-28 08:30:45', NULL),
(43, 5, 7, 'INV-1769669230-426', 'Teteh Eiger', 66000.00, 3, 66000.00, 0.00, 2, 7, 7, NULL, '2026-01-29 06:47:10', '2026-01-29 06:47:10', NULL),
(44, 5, 7, 'INV-1769755367-225', 'Meja1 Bpk anak', 42000.00, 1, 50000.00, 8000.00, 2, 7, 7, NULL, '2026-01-30 06:42:47', '2026-01-30 06:42:47', NULL),
(45, 5, 7, 'INV-1769755455-209', 'Ibu warung desa', 48000.00, 1, 50000.00, 2000.00, 2, 7, 7, NULL, '2026-01-30 06:44:15', '2026-01-30 06:44:15', NULL);

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

--
-- Table structure for table `order_items`
--

CREATE TABLE `order_items` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `product_name` varchar(255) NOT NULL,
  `price` decimal(15,2) NOT NULL,
  `buying_price` decimal(15,2) DEFAULT NULL,
  `quantity` int(11) NOT NULL,
  `subtotal` decimal(15,2) NOT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `deleted_by` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `order_items`
--

INSERT INTO `order_items` (`id`, `order_id`, `product_id`, `product_name`, `price`, `buying_price`, `quantity`, `subtotal`, `created_by`, `updated_by`, `deleted_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, 1, 'TEST Sate Ayam', 15000.00, 0.00, 1, 15000.00, 2, 2, NULL, '2026-01-05 22:03:20', '2026-01-05 22:03:20', NULL),
(2, 1, 2, 'TEST Teh Leci', 10000.00, 0.00, 1, 10000.00, 2, 2, NULL, '2026-01-05 22:03:20', '2026-01-05 22:03:20', NULL),
(3, 2, 1, 'TEST Sate Ayam', 15000.00, 0.00, 2, 30000.00, 1, 1, NULL, '2026-01-06 07:59:23', '2026-01-06 07:59:23', NULL),
(4, 3, 1, 'TEST Sate Ayam', 15000.00, 0.00, 1, 15000.00, 2, 2, NULL, '2026-01-13 12:39:10', '2026-01-13 12:39:10', NULL),
(5, 3, 2, 'TEST Teh Leci', 10000.00, 0.00, 1, 10000.00, 2, 2, NULL, '2026-01-13 12:39:10', '2026-01-13 12:39:10', NULL),
(6, 4, 1, 'TEST Sate Ayam', 15000.00, 0.00, 5, 75000.00, 2, 2, NULL, '2026-01-15 03:34:57', '2026-01-15 03:34:57', NULL),
(7, 5, 2, 'TEST Teh Leci', 10000.00, 0.00, 1, 10000.00, 2, 2, NULL, '2026-01-15 06:34:43', '2026-01-15 06:34:43', NULL),
(8, 6, 2, 'TEST Teh Leci', 10000.00, 0.00, 1, 10000.00, 2, 2, NULL, '2026-01-15 16:48:22', '2026-01-15 16:48:22', NULL),
(9, 6, 1, 'TEST Sate Ayam', 15000.00, 0.00, 2, 30000.00, 2, 2, NULL, '2026-01-15 16:48:22', '2026-01-15 16:48:22', NULL),
(10, 9, 1, 'TEST Sate Ayam', 15000.00, 0.00, 1, 15000.00, 2, 2, NULL, '2026-01-16 00:50:24', '2026-01-16 00:50:24', NULL),
(11, 9, 2, 'TEST Teh Leci', 10000.00, 0.00, 5, 50000.00, 2, 2, NULL, '2026-01-16 00:50:24', '2026-01-16 00:50:24', NULL),
(12, 10, 1, 'TEST Sate Ayam', 15000.00, 0.00, 1, 15000.00, 2, 2, NULL, '2026-01-16 09:14:27', '2026-01-16 09:14:27', NULL),
(13, 12, 6, 'ABC', 500.00, 0.00, 1, 500.00, 2, 2, NULL, '2026-01-18 11:41:15', '2026-01-18 11:41:15', NULL),
(14, 14, 7, 'BUBUR AYAM ', 10000.00, 0.00, 1, 10000.00, 6, 6, NULL, '2026-01-18 13:23:03', '2026-01-18 13:23:03', NULL),
(15, 15, 1, 'TEST Sate Ayam', 15000.00, 0.00, 1, 15000.00, 2, 2, NULL, '2026-01-19 00:56:53', '2026-01-19 00:56:53', NULL),
(16, 15, 3, 'Nasi goreng pedas', 20000.00, 0.00, 1, 20000.00, 2, 2, NULL, '2026-01-19 00:56:53', '2026-01-19 00:56:53', NULL),
(17, 17, 3, 'Nasi goreng pedas', 20000.00, 0.00, 1, 20000.00, 2, 2, NULL, '2026-01-19 11:19:25', '2026-01-19 11:19:25', NULL),
(18, 17, 1, 'TEST Sate Ayam', 15000.00, 0.00, 1, 15000.00, 2, 2, NULL, '2026-01-19 11:19:25', '2026-01-19 11:19:25', NULL),
(19, 19, 10, 'Sate sapi', 40000.00, 0.00, 1, 40000.00, 7, 7, NULL, '2026-01-19 12:45:17', '2026-01-19 12:45:17', NULL),
(20, 19, 14, 'Sate jando full', 4000.00, 0.00, 5, 20000.00, 7, 7, NULL, '2026-01-19 12:45:17', '2026-01-19 12:45:17', NULL),
(21, 19, 34, 'Jeruk panas dingin', 10000.00, 0.00, 1, 10000.00, 7, 7, NULL, '2026-01-19 12:45:17', '2026-01-19 12:45:17', NULL),
(22, 19, 12, 'Nasi', 5000.00, 0.00, 2, 10000.00, 7, 7, NULL, '2026-01-19 12:45:17', '2026-01-19 12:45:17', NULL),
(23, 20, 37, 'Paket Nasi sate ayam', 18000.00, 0.00, 1, 18000.00, 7, 7, NULL, '2026-01-19 12:48:40', '2026-01-19 12:48:40', NULL),
(24, 20, 39, 'Paket Nasi ayam goreng', 18000.00, 0.00, 1, 18000.00, 7, 7, NULL, '2026-01-19 12:48:40', '2026-01-19 12:48:40', NULL),
(25, 20, 12, 'Nasi', 5000.00, 0.00, 1, 5000.00, 7, 7, NULL, '2026-01-19 12:48:40', '2026-01-19 12:48:40', NULL),
(26, 21, 10, 'Sate sapi', 40000.00, 0.00, 1, 40000.00, 7, 7, NULL, '2026-01-19 13:09:49', '2026-01-19 13:09:49', NULL),
(27, 21, 12, 'Nasi', 5000.00, 0.00, 2, 10000.00, 7, 7, NULL, '2026-01-19 13:09:49', '2026-01-19 13:09:49', NULL),
(28, 21, 30, 'Aneka Just', 10000.00, 0.00, 2, 20000.00, 7, 7, NULL, '2026-01-19 13:09:49', '2026-01-19 13:09:49', NULL),
(29, 21, 31, 'Capuchin cingcau', 10000.00, 0.00, 1, 10000.00, 7, 7, NULL, '2026-01-19 13:09:49', '2026-01-19 13:09:49', NULL),
(30, 22, 44, 'Nasi Paket special Ayam lalab sambal', 20000.00, 0.00, 1, 20000.00, 7, 7, NULL, '2026-01-20 06:03:33', '2026-01-20 06:03:33', NULL),
(31, 23, 44, 'Nasi Paket special Ayam lalab sambal', 20000.00, 0.00, 2, 40000.00, 7, 7, NULL, '2026-01-21 06:21:35', '2026-01-21 06:21:35', NULL),
(32, 24, 39, 'Paket Nasi ayam goreng', 18000.00, 0.00, 1, 18000.00, 7, 7, NULL, '2026-01-21 07:17:05', '2026-01-21 07:17:05', NULL),
(33, 25, 10, 'Sate sapi', 40000.00, 0.00, 1, 40000.00, 7, 7, NULL, '2026-01-21 07:18:41', '2026-01-21 07:18:41', NULL),
(34, 25, 12, 'Nasi', 5000.00, 0.00, 2, 10000.00, 7, 7, NULL, '2026-01-21 07:18:41', '2026-01-21 07:18:41', NULL),
(35, 25, 37, 'Paket Nasi sate ayam', 18000.00, 0.00, 1, 18000.00, 7, 7, NULL, '2026-01-21 07:18:41', '2026-01-21 07:18:41', NULL),
(36, 26, 13, 'Goreng ayam', 15000.00, 0.00, 1, 15000.00, 7, 7, NULL, '2026-01-21 09:47:11', '2026-01-21 09:47:11', NULL),
(37, 26, 46, 'Asin pedas beureum', 6000.00, 0.00, 1, 6000.00, 7, 7, NULL, '2026-01-21 09:47:11', '2026-01-21 09:47:11', NULL),
(38, 27, 44, 'Nasi Paket special Ayam lalab sambal', 20000.00, 0.00, 2, 40000.00, 7, 7, NULL, '2026-01-21 12:04:07', '2026-01-21 12:04:07', NULL),
(39, 28, 39, 'Paket Nasi ayam goreng', 18000.00, 0.00, 2, 36000.00, 7, 7, NULL, '2026-01-22 05:51:50', '2026-01-22 05:51:50', NULL),
(40, 28, 40, 'Kerupuk Gumilar', 3000.00, 0.00, 1, 3000.00, 7, 7, NULL, '2026-01-22 05:51:50', '2026-01-22 05:51:50', NULL),
(41, 29, 39, 'Paket Nasi ayam goreng', 18000.00, 0.00, 1, 18000.00, 7, 7, NULL, '2026-01-23 10:02:22', '2026-01-23 10:02:22', NULL),
(42, 29, 16, 'Ati ampela', 7000.00, 0.00, 1, 7000.00, 7, 7, NULL, '2026-01-23 10:02:22', '2026-01-23 10:02:22', NULL),
(43, 29, 40, 'Kerupuk Gumilar', 3000.00, 0.00, 1, 3000.00, 7, 7, NULL, '2026-01-23 10:02:22', '2026-01-23 10:02:22', NULL),
(44, 30, 39, 'Paket Nasi ayam goreng', 18000.00, 0.00, 2, 36000.00, 7, 7, NULL, '2026-01-23 10:03:24', '2026-01-23 10:03:24', NULL),
(45, 31, 24, 'Karedok ', 6000.00, 0.00, 1, 6000.00, 7, 7, NULL, '2026-01-24 05:57:18', '2026-01-24 05:57:18', NULL),
(46, 31, 12, 'Nasi', 5000.00, 0.00, 1, 5000.00, 7, 7, NULL, '2026-01-24 05:57:18', '2026-01-24 05:57:18', NULL),
(47, 33, 12, 'Nasi', 5000.00, 0.00, 1, 5000.00, 7, 7, NULL, '2026-01-24 08:17:42', '2026-01-24 08:17:42', NULL),
(48, 33, 28, 'Nasi goreng nenek', 15000.00, 0.00, 1, 15000.00, 7, 7, NULL, '2026-01-24 08:17:42', '2026-01-24 08:17:42', NULL),
(49, 33, 26, 'Spageti wow telor', 10000.00, 0.00, 1, 10000.00, 7, 7, NULL, '2026-01-24 08:17:42', '2026-01-24 08:17:42', NULL),
(50, 33, 39, 'Paket Nasi ayam goreng', 18000.00, 0.00, 1, 18000.00, 7, 7, NULL, '2026-01-24 08:17:42', '2026-01-24 08:17:42', NULL),
(51, 34, 44, 'Nasi Paket special Ayam lalab sambal', 20000.00, 0.00, 1, 20000.00, 7, 7, NULL, '2026-01-24 11:51:15', '2026-01-24 11:51:15', NULL),
(52, 35, 39, 'Paket Nasi ayam goreng', 18000.00, 0.00, 1, 18000.00, 7, 7, NULL, '2026-01-25 04:54:30', '2026-01-25 04:54:30', NULL),
(53, 35, 34, 'Jeruk panas dingin', 10000.00, 0.00, 1, 10000.00, 7, 7, NULL, '2026-01-25 04:54:30', '2026-01-25 04:54:30', NULL),
(54, 36, 10, 'Sate sapi', 40000.00, 0.00, 1, 40000.00, 7, 7, NULL, '2026-01-25 09:00:32', '2026-01-25 09:00:32', NULL),
(55, 36, 12, 'Nasi', 5000.00, 0.00, 3, 15000.00, 7, 7, NULL, '2026-01-25 09:00:32', '2026-01-25 09:00:32', NULL),
(56, 36, 47, 'Sate sapi special', 45000.00, 0.00, 1, 45000.00, 7, 7, NULL, '2026-01-25 09:00:32', '2026-01-25 09:00:32', NULL),
(57, 36, 34, 'Jeruk panas dingin', 10000.00, 0.00, 2, 20000.00, 7, 7, NULL, '2026-01-25 09:00:32', '2026-01-25 09:00:32', NULL),
(58, 36, 40, 'Kerupuk Gumilar', 3000.00, 0.00, 1, 3000.00, 7, 7, NULL, '2026-01-25 09:00:32', '2026-01-25 09:00:32', NULL),
(59, 37, 10, 'Sate sapi', 40000.00, 0.00, 1, 40000.00, 7, 7, NULL, '2026-01-25 12:37:27', '2026-01-25 12:37:27', NULL),
(60, 37, 48, 'Sate sapi eceran', 4000.00, 0.00, 5, 20000.00, 7, 7, NULL, '2026-01-25 12:37:27', '2026-01-25 12:37:27', NULL),
(61, 38, 24, 'Karedok ', 6000.00, 0.00, 1, 6000.00, 7, 7, NULL, '2026-01-26 05:25:15', '2026-01-26 05:25:15', NULL),
(62, 38, 49, 'Cireng', 10000.00, 0.00, 1, 10000.00, 7, 7, NULL, '2026-01-26 05:25:15', '2026-01-26 05:25:15', NULL),
(63, 39, 10, 'Sate sapi', 40000.00, 0.00, 1, 40000.00, 7, 7, NULL, '2026-01-26 09:21:46', '2026-01-26 09:21:46', NULL),
(64, 40, 12, 'Nasi', 5000.00, 0.00, 2, 10000.00, 7, 7, NULL, '2026-01-28 04:50:29', '2026-01-28 04:50:29', NULL),
(65, 40, 22, 'Oseng kangkung', 8000.00, 0.00, 1, 8000.00, 7, 7, NULL, '2026-01-28 04:50:29', '2026-01-28 04:50:29', NULL),
(66, 40, 48, 'Sate sapi eceran', 4000.00, 0.00, 5, 20000.00, 7, 7, NULL, '2026-01-28 04:50:29', '2026-01-28 04:50:29', NULL),
(67, 40, 34, 'Jeruk panas dingin', 10000.00, 0.00, 1, 10000.00, 7, 7, NULL, '2026-01-28 04:50:29', '2026-01-28 04:50:29', NULL),
(68, 41, 49, 'Cireng', 10000.00, 0.00, 1, 10000.00, 7, 7, NULL, '2026-01-28 06:13:31', '2026-01-28 06:13:31', NULL),
(69, 41, 24, 'Karedok ', 6000.00, 0.00, 1, 6000.00, 7, 7, NULL, '2026-01-28 06:13:31', '2026-01-28 06:13:31', NULL),
(70, 42, 39, 'Paket Nasi ayam goreng', 18000.00, 0.00, 2, 36000.00, 7, 7, NULL, '2026-01-28 08:30:45', '2026-01-28 08:30:45', NULL),
(71, 42, 40, 'Kerupuk Gumilar', 3000.00, 0.00, 1, 3000.00, 7, 7, NULL, '2026-01-28 08:30:45', '2026-01-28 08:30:45', NULL),
(72, 43, 50, 'Paket nasi sate sapi 5', 25000.00, 0.00, 2, 50000.00, 7, 7, NULL, '2026-01-29 06:47:10', '2026-01-29 06:47:10', NULL),
(73, 43, 29, 'Es campur', 10000.00, 0.00, 1, 10000.00, 7, 7, NULL, '2026-01-29 06:47:10', '2026-01-29 06:47:10', NULL),
(74, 43, 24, 'Karedok ', 6000.00, 0.00, 1, 6000.00, 7, 7, NULL, '2026-01-29 06:47:10', '2026-01-29 06:47:10', NULL),
(75, 44, 37, 'Paket Nasi sate ayam', 18000.00, 0.00, 2, 36000.00, 7, 7, NULL, '2026-01-30 06:42:47', '2026-01-30 06:42:47', NULL),
(76, 44, 24, 'Karedok ', 6000.00, 0.00, 1, 6000.00, 7, 7, NULL, '2026-01-30 06:42:47', '2026-01-30 06:42:47', NULL),
(77, 45, 13, 'Goreng ayam', 15000.00, 0.00, 3, 45000.00, 7, 7, NULL, '2026-01-30 06:44:15', '2026-01-30 06:44:15', NULL),
(78, 45, 40, 'Kerupuk Gumilar', 3000.00, 0.00, 1, 3000.00, 7, 7, NULL, '2026-01-30 06:44:15', '2026-01-30 06:44:15', NULL);

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

--
-- Table structure for table `order_statuses`
--

CREATE TABLE `order_statuses` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `order_statuses`
--

INSERT INTO `order_statuses` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'PENDING', '2026-01-05 21:24:45', '2026-01-05 21:24:45', NULL),
(2, 'COMPLETED', '2026-01-05 21:24:45', '2026-01-05 21:24:45', NULL),
(3, 'CANCELLED', '2026-01-05 21:24:45', '2026-01-05 21:24:45', NULL);

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

--
-- Table structure for table `payment_methods`
--

CREATE TABLE `payment_methods` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payment_methods`
--

INSERT INTO `payment_methods` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'CASH', '2026-01-05 21:24:45', '2026-01-05 21:24:45', NULL),
(2, 'QRIS', '2026-01-05 21:24:45', '2026-01-05 21:24:45', NULL),
(3, 'TRANSFER', '2026-01-05 21:24:45', '2026-01-05 21:24:45', NULL);

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

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `guard_name` varchar(255) 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 `permissions`
--

INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'ViewAny:Category', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(2, 'View:Category', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(3, 'Create:Category', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(4, 'Update:Category', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(5, 'Delete:Category', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(6, 'Restore:Category', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(7, 'ForceDelete:Category', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(8, 'ForceDeleteAny:Category', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(9, 'RestoreAny:Category', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(10, 'Replicate:Category', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(11, 'Reorder:Category', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(12, 'ViewAny:Media', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(13, 'View:Media', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(14, 'Create:Media', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(15, 'Update:Media', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(16, 'Delete:Media', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(17, 'Restore:Media', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(18, 'ForceDelete:Media', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(19, 'ForceDeleteAny:Media', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(20, 'RestoreAny:Media', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(21, 'Replicate:Media', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(22, 'Reorder:Media', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(23, 'ViewAny:OrderStatus', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(24, 'View:OrderStatus', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(25, 'Create:OrderStatus', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(26, 'Update:OrderStatus', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(27, 'Delete:OrderStatus', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(28, 'Restore:OrderStatus', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(29, 'ForceDelete:OrderStatus', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(30, 'ForceDeleteAny:OrderStatus', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(31, 'RestoreAny:OrderStatus', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(32, 'Replicate:OrderStatus', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(33, 'Reorder:OrderStatus', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(34, 'ViewAny:Order', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(35, 'View:Order', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(36, 'Create:Order', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(37, 'Update:Order', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(38, 'Delete:Order', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(39, 'Restore:Order', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(40, 'ForceDelete:Order', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(41, 'ForceDeleteAny:Order', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(42, 'RestoreAny:Order', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(43, 'Replicate:Order', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(44, 'Reorder:Order', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(45, 'ViewAny:PaymentMethod', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(46, 'View:PaymentMethod', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(47, 'Create:PaymentMethod', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(48, 'Update:PaymentMethod', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(49, 'Delete:PaymentMethod', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(50, 'Restore:PaymentMethod', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(51, 'ForceDelete:PaymentMethod', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(52, 'ForceDeleteAny:PaymentMethod', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(53, 'RestoreAny:PaymentMethod', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(54, 'Replicate:PaymentMethod', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(55, 'Reorder:PaymentMethod', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(56, 'ViewAny:Product', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(57, 'View:Product', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(58, 'Create:Product', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(59, 'Update:Product', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(60, 'Delete:Product', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(61, 'Restore:Product', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(62, 'ForceDelete:Product', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(63, 'ForceDeleteAny:Product', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(64, 'RestoreAny:Product', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(65, 'Replicate:Product', 'web', '2026-01-05 21:57:29', '2026-01-05 21:57:29'),
(66, 'Reorder:Product', 'web', '2026-01-05 21:57:30', '2026-01-05 21:57:30'),
(67, 'ViewAny:SubscriptionStatus', 'web', '2026-01-05 21:57:30', '2026-01-05 21:57:30'),
(68, 'View:SubscriptionStatus', 'web', '2026-01-05 21:57:30', '2026-01-05 21:57:30'),
(69, 'Create:SubscriptionStatus', 'web', '2026-01-05 21:57:30', '2026-01-05 21:57:30'),
(70, 'Update:SubscriptionStatus', 'web', '2026-01-05 21:57:30', '2026-01-05 21:57:30'),
(71, 'Delete:SubscriptionStatus', 'web', '2026-01-05 21:57:30', '2026-01-05 21:57:30'),
(72, 'Restore:SubscriptionStatus', 'web', '2026-01-05 21:57:30', '2026-01-05 21:57:30'),
(73, 'ForceDelete:SubscriptionStatus', 'web', '2026-01-05 21:57:30', '2026-01-05 21:57:30'),
(74, 'ForceDeleteAny:SubscriptionStatus', 'web', '2026-01-05 21:57:30', '2026-01-05 21:57:30'),
(75, 'RestoreAny:SubscriptionStatus', 'web', '2026-01-05 21:57:30', '2026-01-05 21:57:30'),
(76, 'Replicate:SubscriptionStatus', 'web', '2026-01-05 21:57:30', '2026-01-05 21:57:30'),
(77, 'Reorder:SubscriptionStatus', 'web', '2026-01-05 21:57:30', '2026-01-05 21:57:30'),
(78, 'ViewAny:Tenant', 'web', '2026-01-05 21:57:30', '2026-01-05 21:57:30'),
(79, 'View:Tenant', 'web', '2026-01-05 21:57:30', '2026-01-05 21:57:30'),
(80, 'Create:Tenant', 'web', '2026-01-05 21:57:30', '2026-01-05 21:57:30'),
(81, 'Update:Tenant', 'web', '2026-01-05 21:57:30', '2026-01-05 21:57:30'),
(82, 'Delete:Tenant', 'web', '2026-01-05 21:57:30', '2026-01-05 21:57:30'),
(83, 'Restore:Tenant', 'web', '2026-01-05 21:57:30', '2026-01-05 21:57:30'),
(84, 'ForceDelete:Tenant', 'web', '2026-01-05 21:57:30', '2026-01-05 21:57:30'),
(85, 'ForceDeleteAny:Tenant', 'web', '2026-01-05 21:57:30', '2026-01-05 21:57:30'),
(86, 'RestoreAny:Tenant', 'web', '2026-01-05 21:57:30', '2026-01-05 21:57:30'),
(87, 'Replicate:Tenant', 'web', '2026-01-05 21:57:30', '2026-01-05 21:57:30'),
(88, 'Reorder:Tenant', 'web', '2026-01-05 21:57:30', '2026-01-05 21:57:30'),
(89, 'ViewAny:User', 'web', '2026-01-05 21:57:30', '2026-01-05 21:57:30'),
(90, 'View:User', 'web', '2026-01-05 21:57:30', '2026-01-05 21:57:30'),
(91, 'Create:User', 'web', '2026-01-05 21:57:30', '2026-01-05 21:57:30'),
(92, 'Update:User', 'web', '2026-01-05 21:57:30', '2026-01-05 21:57:30'),
(93, 'Delete:User', 'web', '2026-01-05 21:57:30', '2026-01-05 21:57:30'),
(94, 'Restore:User', 'web', '2026-01-05 21:57:30', '2026-01-05 21:57:30'),
(95, 'ForceDelete:User', 'web', '2026-01-05 21:57:30', '2026-01-05 21:57:30'),
(96, 'ForceDeleteAny:User', 'web', '2026-01-05 21:57:30', '2026-01-05 21:57:30'),
(97, 'RestoreAny:User', 'web', '2026-01-05 21:57:30', '2026-01-05 21:57:30'),
(98, 'Replicate:User', 'web', '2026-01-05 21:57:30', '2026-01-05 21:57:30'),
(99, 'Reorder:User', 'web', '2026-01-05 21:57:30', '2026-01-05 21:57:30'),
(100, 'ViewAny:Role', 'web', '2026-01-05 21:57:30', '2026-01-05 21:57:30'),
(101, 'View:Role', 'web', '2026-01-05 21:57:30', '2026-01-05 21:57:30'),
(102, 'Create:Role', 'web', '2026-01-05 21:57:30', '2026-01-05 21:57:30'),
(103, 'Update:Role', 'web', '2026-01-05 21:57:30', '2026-01-05 21:57:30'),
(104, 'Delete:Role', 'web', '2026-01-05 21:57:30', '2026-01-05 21:57:30'),
(105, 'Restore:Role', 'web', '2026-01-05 21:57:30', '2026-01-05 21:57:30'),
(106, 'ForceDelete:Role', 'web', '2026-01-05 21:57:30', '2026-01-05 21:57:30'),
(107, 'ForceDeleteAny:Role', 'web', '2026-01-05 21:57:30', '2026-01-05 21:57:30'),
(108, 'RestoreAny:Role', 'web', '2026-01-05 21:57:30', '2026-01-05 21:57:30'),
(109, 'Replicate:Role', 'web', '2026-01-05 21:57:30', '2026-01-05 21:57:30'),
(110, 'Reorder:Role', 'web', '2026-01-05 21:57:30', '2026-01-05 21:57:30'),
(111, 'View:Dashboard', 'web', '2026-01-05 21:57:30', '2026-01-05 21:57:30'),
(112, 'View:OrdersChart', 'web', '2026-01-05 21:57:30', '2026-01-05 21:57:30'),
(113, 'View:StatsOverview', 'web', '2026-01-05 21:57:30', '2026-01-05 21:57:30');

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

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tenant_id` bigint(20) UNSIGNED NOT NULL,
  `category_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `product_image_id` bigint(20) UNSIGNED DEFAULT NULL,
  `description` text DEFAULT NULL,
  `buying_price` decimal(15,2) DEFAULT NULL,
  `selling_price` decimal(15,2) NOT NULL,
  `is_stock_managed` tinyint(1) NOT NULL,
  `barcode` varchar(255) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `deleted_by` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `products`
--

INSERT INTO `products` (`id`, `tenant_id`, `category_id`, `name`, `product_image_id`, `description`, `buying_price`, `selling_price`, `is_stock_managed`, `barcode`, `is_active`, `created_by`, `updated_by`, `deleted_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 2, 1, 'TEST Sate Ayam', 1, NULL, 10000.00, 15000.00, 0, NULL, 1, 2, 2, NULL, '2026-01-05 22:01:26', '2026-01-05 22:01:26', NULL),
(2, 2, 2, 'TEST Teh Leci', 2, NULL, 8000.00, 10000.00, 0, NULL, 1, 2, 2, NULL, '2026-01-05 22:02:23', '2026-01-05 22:02:23', NULL),
(3, 2, 1, 'Nasi goreng pedas', 4, NULL, 7500.00, 20000.00, 1, NULL, 1, 2, 2, NULL, '2026-01-13 12:55:30', '2026-01-16 08:40:53', NULL),
(4, 2, 1, 'Bekal makan siang', NULL, NULL, 18000.00, 20000.00, 0, NULL, 1, 2, 2, NULL, '2026-01-16 08:59:39', '2026-01-16 08:59:39', NULL),
(5, 2, 1, 'Sepatu bola', 5, NULL, 100000.00, 200000.00, 0, NULL, 1, 2, 2, NULL, '2026-01-17 13:25:44', '2026-01-17 13:25:44', NULL),
(6, 2, 1, 'ABC', NULL, NULL, 300.00, 500.00, 1, NULL, 1, 2, 2, NULL, '2026-01-18 11:39:44', '2026-01-18 11:39:44', NULL),
(7, 4, 3, 'BUBUR AYAM ', 6, NULL, 5000.00, 10000.00, 0, NULL, 1, 6, 6, NULL, '2026-01-18 13:16:25', '2026-01-18 13:16:25', NULL),
(8, 4, 3, 'MIE AYAM BASO', 7, NULL, 9000.00, 17000.00, 0, NULL, 1, 6, 6, NULL, '2026-01-18 13:20:19', '2026-01-18 13:20:19', NULL),
(9, 4, 3, 'MIE AYAM', 8, NULL, 6000.00, 12000.00, 0, NULL, 1, 6, 6, NULL, '2026-01-18 13:21:36', '2026-01-18 13:21:36', NULL),
(10, 5, 6, 'Sate sapi', NULL, NULL, 25000.00, 40000.00, 1, NULL, 1, 7, 7, NULL, '2026-01-19 09:30:28', '2026-01-19 09:30:28', NULL),
(11, 5, 6, 'Sate ayam', NULL, NULL, 15000.00, 30000.00, 0, NULL, 1, 7, 7, NULL, '2026-01-19 09:31:16', '2026-01-19 09:31:16', NULL),
(12, 5, 6, 'Nasi', NULL, NULL, 2500.00, 5000.00, 0, NULL, 1, 7, 7, NULL, '2026-01-19 12:19:52', '2026-01-19 12:19:52', NULL),
(13, 5, 6, 'Goreng ayam', NULL, NULL, 7500.00, 15000.00, 0, NULL, 1, 7, 7, NULL, '2026-01-19 12:21:07', '2026-01-19 12:21:07', NULL),
(14, 5, 6, 'Sate jando full', NULL, NULL, 2000.00, 4000.00, 0, NULL, 1, 7, 7, NULL, '2026-01-19 12:21:41', '2026-01-19 12:22:00', NULL),
(15, 5, 6, 'Ikan goreng', NULL, NULL, 6000.00, 13000.00, 0, NULL, 1, 7, 7, NULL, '2026-01-19 12:22:38', '2026-01-19 12:22:38', NULL),
(16, 5, 6, 'Ati ampela', NULL, NULL, 2000.00, 7000.00, 0, NULL, 1, 7, 7, NULL, '2026-01-19 12:23:08', '2026-01-19 12:23:08', NULL),
(17, 5, 6, 'Telor ceplok', NULL, NULL, 2000.00, 7000.00, 0, NULL, 1, 7, 7, NULL, '2026-01-19 12:23:32', '2026-01-19 12:23:32', NULL),
(18, 5, 6, 'Asin spat ', NULL, NULL, 2000.00, 600.00, 0, NULL, 1, 7, 7, NULL, '2026-01-19 12:24:45', '2026-01-19 12:24:45', NULL),
(19, 5, 6, 'Goreng tahu tempe', NULL, NULL, 1000.00, 2500.00, 0, NULL, 1, 7, 7, NULL, '2026-01-19 12:25:25', '2026-01-19 12:25:25', NULL),
(20, 5, 6, 'Perkedel tahu', NULL, NULL, 1000.00, 2500.00, 0, NULL, 1, 7, 7, NULL, '2026-01-19 12:25:55', '2026-01-19 12:25:55', NULL),
(21, 5, 6, 'Jengkol goreng', NULL, NULL, 2000.00, 6000.00, 0, NULL, 1, 7, 7, NULL, '2026-01-19 12:26:20', '2026-01-19 12:26:20', NULL),
(22, 5, 6, 'Oseng kangkung', NULL, NULL, 3500.00, 8000.00, 0, NULL, 1, 7, 7, NULL, '2026-01-19 12:26:56', '2026-01-19 12:26:56', NULL),
(23, 5, 6, 'Oseng jando / daging', NULL, NULL, 7500.00, 20000.00, 0, NULL, 1, 7, 7, NULL, '2026-01-19 12:28:55', '2026-01-23 03:28:24', NULL),
(24, 5, 6, 'Karedok ', NULL, NULL, 3000.00, 6000.00, 0, NULL, 1, 7, 7, NULL, '2026-01-19 12:29:26', '2026-01-19 12:29:26', NULL),
(25, 5, 6, 'Indomie kuah goreng plus telor', NULL, NULL, 5000.00, 10000.00, 0, NULL, 1, 7, 7, NULL, '2026-01-19 12:30:42', '2026-01-19 12:30:42', NULL),
(26, 5, 6, 'Spageti wow telor', NULL, NULL, 5000.00, 10000.00, 0, NULL, 1, 7, 7, NULL, '2026-01-19 12:31:19', '2026-01-19 12:31:19', NULL),
(27, 5, 6, 'Mie goreng nenek', NULL, NULL, 10000.00, 15000.00, 0, NULL, 1, 7, 7, NULL, '2026-01-19 12:31:42', '2026-01-19 12:31:42', NULL),
(28, 5, 6, 'Nasi goreng nenek', NULL, NULL, 10000.00, 15000.00, 0, NULL, 1, 7, 7, NULL, '2026-01-19 12:32:01', '2026-01-19 12:32:01', NULL),
(29, 5, 7, 'Es campur', NULL, NULL, 5000.00, 10000.00, 0, NULL, 1, 7, 7, NULL, '2026-01-19 12:32:37', '2026-01-19 12:32:37', NULL),
(30, 5, 7, 'Aneka Just', NULL, NULL, 5000.00, 10000.00, 0, NULL, 1, 7, 7, NULL, '2026-01-19 12:33:01', '2026-01-19 12:33:01', NULL),
(31, 5, 7, 'Capuchin cingcau', NULL, NULL, 5000.00, 10000.00, 0, NULL, 1, 7, 7, NULL, '2026-01-19 12:33:42', '2026-01-19 12:33:42', NULL),
(32, 5, 7, 'Es kelapa jelly', NULL, NULL, 5000.00, 10000.00, 0, NULL, 1, 7, 7, NULL, '2026-01-19 12:35:25', '2026-01-19 12:35:25', NULL),
(33, 5, 7, 'Teh manis panas dingin', NULL, NULL, 4000.00, 8000.00, 0, NULL, 1, 7, 7, NULL, '2026-01-19 12:35:50', '2026-01-19 12:35:50', NULL),
(34, 5, 7, 'Jeruk panas dingin', NULL, NULL, 6000.00, 10000.00, 0, NULL, 1, 7, 7, NULL, '2026-01-19 12:36:24', '2026-01-19 12:36:24', NULL),
(35, 5, 7, 'Kopi sachet', NULL, NULL, 2500.00, 5000.00, 0, NULL, 1, 7, 7, NULL, '2026-01-19 12:36:57', '2026-01-19 12:36:57', NULL),
(36, 5, 7, 'Kopi v60', NULL, NULL, 8000.00, 15000.00, 0, NULL, 1, 7, 7, NULL, '2026-01-19 12:37:20', '2026-01-19 12:37:20', NULL),
(37, 5, 6, 'Paket Nasi sate ayam', NULL, NULL, 12000.00, 18000.00, 0, NULL, 1, 7, 7, NULL, '2026-01-19 12:39:33', '2026-01-19 12:39:33', NULL),
(38, 5, 6, 'Nasi paket sate sapi', NULL, NULL, 17500.00, 25000.00, 0, NULL, 1, 7, 7, 7, '2026-01-19 12:40:15', '2026-01-19 12:46:55', '2026-01-19 12:46:55'),
(39, 5, 6, 'Paket Nasi ayam goreng', NULL, NULL, 9000.00, 18000.00, 0, NULL, 1, 7, 7, NULL, '2026-01-19 12:40:45', '2026-01-19 12:40:45', NULL),
(40, 5, 8, 'Kerupuk Gumilar', NULL, NULL, 1600.00, 3000.00, 0, NULL, 1, 7, 7, NULL, '2026-01-20 05:49:08', '2026-01-22 05:48:42', NULL),
(41, 5, 7, 'Air mineral TGM 600ml ', NULL, NULL, 3000.00, 5000.00, 0, NULL, 1, 7, 7, NULL, '2026-01-20 05:50:47', '2026-01-20 05:51:08', NULL),
(42, 5, 7, 'Air mineral TGM 300ml', NULL, NULL, 2000.00, 3000.00, 0, NULL, 1, 7, 7, NULL, '2026-01-20 05:51:41', '2026-01-20 05:51:41', NULL),
(43, 5, 7, 'Air mineral TGM 200ml', NULL, NULL, 1000.00, 2000.00, 0, NULL, 1, 7, 7, NULL, '2026-01-20 05:52:08', '2026-01-20 05:52:08', NULL),
(44, 5, 6, 'Nasi Paket special Ayam lalab sambal', NULL, NULL, 8500.00, 20000.00, 0, NULL, 1, 7, 7, NULL, '2026-01-20 06:02:35', '2026-01-20 06:02:35', NULL),
(45, 5, 8, 'Seblak kering', NULL, NULL, 2500.00, 5000.00, 0, NULL, 1, 7, 7, NULL, '2026-01-20 07:19:14', '2026-01-20 07:19:14', NULL),
(46, 5, 6, 'Asin pedas beureum', NULL, NULL, 3000.00, 6000.00, 0, NULL, 1, 7, 7, NULL, '2026-01-21 09:46:16', '2026-01-21 09:46:16', NULL),
(47, 5, 6, 'Sate sapi special', NULL, NULL, 25000.00, 45000.00, 0, NULL, 1, 7, 7, NULL, '2026-01-25 08:28:34', '2026-01-25 08:28:34', NULL),
(48, 5, 6, 'Sate sapi eceran', NULL, NULL, 2500.00, 4000.00, 0, NULL, 1, 7, 7, NULL, '2026-01-25 12:36:27', '2026-01-25 12:36:27', NULL),
(49, 5, 8, 'Cireng', NULL, NULL, 5000.00, 10000.00, 0, NULL, 1, 7, 7, NULL, '2026-01-26 05:24:42', '2026-01-26 05:24:42', NULL),
(50, 5, 6, 'Paket nasi sate sapi 5', NULL, NULL, 17500.00, 25000.00, 0, NULL, 1, 7, 7, NULL, '2026-01-29 06:46:01', '2026-01-29 06:46:01', NULL);

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

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `guard_name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`, `guard_name`) VALUES
(1, 'SUPERADMIN', '2026-01-05 21:24:45', '2026-01-05 21:24:45', NULL, 'web'),
(2, 'OWNER', '2026-01-05 21:24:45', '2026-01-05 21:24:45', NULL, 'web'),
(3, 'MANAGER', '2026-01-05 21:24:45', '2026-01-05 21:24:45', NULL, 'web'),
(4, 'STAFF', '2026-01-05 21:24:45', '2026-01-05 21:24:45', NULL, 'web');

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

--
-- Table structure for table `role_has_permissions`
--

CREATE TABLE `role_has_permissions` (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `role_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_has_permissions`
--

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

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

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext NOT NULL,
  `last_activity` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('1AYvkmWK2sf3ziBaMsuTouJcogyHPtAM0i8XM7py', NULL, '144.91.73.51', 'Mozilla/5.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoicUVLYUlqVDFtaHFvdzVncmQwSmNYYW04eEZCTFNKd3hDM2hWQUE5NCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NTA6Imh0dHBzOi8va2FzdG9lZC5zdG9lZGlvcG9ydGFsLmNvbS9pbmRleC5waHA/aW5mbz0xIjtzOjU6InJvdXRlIjtzOjI3OiJnZW5lcmF0ZWQ6OjZ5cUxIUDA4RXBWUEJiaXIiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1774828995),
('2bKk4PaMwfim6Zb8HkNH84qYn6v9ECcPMiGv7GvB', NULL, '34.122.147.229', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiWDhOVm96bmN6R1Z4ME1aSEE2U1hXMVZiMjREV0tFTnM2aUd6SGtXNyI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzI6Imh0dHA6Ly9rYXN0b2VkLnN0b2VkaW9wb3J0YWwuY29tIjtzOjU6InJvdXRlIjtzOjI3OiJnZW5lcmF0ZWQ6OjZ5cUxIUDA4RXBWUEJiaXIiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1774676345),
('2KKHSycROl2VFa0T2yZvkMjkGgKW4xVcp3TQcVRH', NULL, '147.182.243.164', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiTDI3VnhwTk9obmFxeWtid3JybWJxT3dXRnVDbk0xOVBxZVdWajZGOSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mzc6Imh0dHBzOi8vd3d3Lmthc3RvZWQuc3RvZWRpb3BvcnRhbC5jb20iO3M6NToicm91dGUiO3M6Mjc6ImdlbmVyYXRlZDo6NnlxTEhQMDhFcFZQQmJpciI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1774609677),
('2xWJzezTKTcXYEr1spE7X5W1qoHb4M0R9FTnKzRH', NULL, '137.184.199.161', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiaFEzWXZWckt4RDVsNTlUa2p6bEpPbG5ySDE0NHZpOEdTVWdIVlRPZiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzI6Imh0dHA6Ly9rYXN0b2VkLnN0b2VkaW9wb3J0YWwuY29tIjtzOjU6InJvdXRlIjtzOjI3OiJnZW5lcmF0ZWQ6OjZ5cUxIUDA4RXBWUEJiaXIiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1775126607),
('417emqjj5RQfwPIEX0etZ3Mv9tM71Nj6C2CeUP9g', NULL, '74.7.227.147', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiSzhJWHplY3pndE5OaUtVVEhCWXhVSWVoa3JsODJDbzdoeXZuWldoRiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NDk6Imh0dHBzOi8vd3d3Lmthc3RvZWQuc3RvZWRpb3BvcnRhbC5jb20vYWRtaW4vbG9naW4iO3M6NToicm91dGUiO3M6MjU6ImZpbGFtZW50LmFkbWluLmF1dGgubG9naW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1774501603),
('4pAmDAIoMvvIBh5dwNMPtre2Op0LNraGhZZf3AL2', NULL, '198.235.24.178', 'Hello from Palo Alto Networks, find out more about our scans in https://docs-cortex.paloaltonetworks.com/r/1/Cortex-Xpanse/Scanning-activity', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiZ0tZNVBScnl6NDBFZ0RlSm5pTkFzTFdoY1YwQTBKUDBxTVphN3p0QiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mzc6Imh0dHBzOi8vd3d3Lmthc3RvZWQuc3RvZWRpb3BvcnRhbC5jb20iO3M6NToicm91dGUiO3M6Mjc6ImdlbmVyYXRlZDo6NnlxTEhQMDhFcFZQQmJpciI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1775310590),
('4VrVzxXfQjzbkowEcJfA0TCtg2v7gSFKxSJtloyy', NULL, '34.60.81.132', 'Mozilla/5.0 (compatible; CMS-Checker/1.0; +https://example.com)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiRkdzQjlVQjJqT3VDb1JjY0dwVFg5b2xIdnV2dHd1UTF5ejR3TWNzTCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzI6Imh0dHA6Ly9rYXN0b2VkLnN0b2VkaW9wb3J0YWwuY29tIjtzOjU6InJvdXRlIjtzOjI3OiJnZW5lcmF0ZWQ6OjZ5cUxIUDA4RXBWUEJiaXIiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1774455029),
('4w3JARLlumrDRFG2DTcbIel5qCMDSQf7kST8NLaq', NULL, '23.95.96.140', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 15_7_3) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.0 Safari/605.1.15', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiYlhrM3prMkRnNUZJVVpTTUh5VVBJQzRGSThxdVhHV1FMeGJNc0VjWCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzY6Imh0dHA6Ly93d3cua2FzdG9lZC5zdG9lZGlvcG9ydGFsLmNvbSI7czo1OiJyb3V0ZSI7czoyNzoiZ2VuZXJhdGVkOjo2eXFMSFAwOEVwVlBCYmlyIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1775089390),
('4xNYmWP1YfaDa38KyToD3Ac94hRAFhp4RQAxHshg', NULL, '35.204.109.104', 'Scrapy/2.13.4 (+https://scrapy.org)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiQndJOHZGc05MVGVsRG9PclphVExPN0hTU3U0NmcxWFp4ZUNBblhQZyI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mzc6Imh0dHBzOi8vd3d3Lmthc3RvZWQuc3RvZWRpb3BvcnRhbC5jb20iO3M6NToicm91dGUiO3M6Mjc6ImdlbmVyYXRlZDo6NnlxTEhQMDhFcFZQQmJpciI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1775119323),
('4XYcrBmHl3bwhcmbojO2wkFUIjfPWCldbOKZiOfM', NULL, '74.7.227.41', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiTHVIcHYwWm1IRmRlTnVZSU5mQWdNdGw0NGd1QjV3NjFJYWVPaVIwayI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mzc6Imh0dHBzOi8vd3d3Lmthc3RvZWQuc3RvZWRpb3BvcnRhbC5jb20iO3M6NToicm91dGUiO3M6Mjc6ImdlbmVyYXRlZDo6NnlxTEhQMDhFcFZQQmJpciI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1775441699),
('8tUJjRW8yRsmVLOUxwzQPks4H0Hp6wYxb84wgESQ', NULL, '167.99.95.143', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiVVdtR2FjUW0yOXVuZmNDTmFsc3VPSEtqQldmUVNIN2swVzNZemEwVCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzM6Imh0dHBzOi8va2FzdG9lZC5zdG9lZGlvcG9ydGFsLmNvbSI7czo1OiJyb3V0ZSI7czoyNzoiZ2VuZXJhdGVkOjo2eXFMSFAwOEVwVlBCYmlyIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1774951054),
('9DQ1V1cmuTwQnhJ9mH3XY158UxYORguLDTcpmAnw', NULL, '147.182.243.164', 'Mozilla/5.0 (X11; Linux x86_64; rv:142.0) Gecko/20100101 Firefox/142.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoid2NqUWVxS0ZyTEhnY3ZzSDE2ZjE3MGthZU1ydmhnSDU5R0VPVFJUbCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzY6Imh0dHA6Ly93d3cua2FzdG9lZC5zdG9lZGlvcG9ydGFsLmNvbSI7czo1OiJyb3V0ZSI7czoyNzoiZ2VuZXJhdGVkOjo2eXFMSFAwOEVwVlBCYmlyIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1774609675),
('a43PlyNTByvOqCiWNX0yBu9zbgqe13VuVkTXeRdR', NULL, '66.132.172.214', 'Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoidVNsd3ZPaTVFWTUxZzZjOUxQM0luT2w3NndFNmFZbmxndXN1SzI2TyI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzI6Imh0dHA6Ly9rYXN0b2VkLnN0b2VkaW9wb3J0YWwuY29tIjtzOjU6InJvdXRlIjtzOjI3OiJnZW5lcmF0ZWQ6OjZ5cUxIUDA4RXBWUEJiaXIiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1775488752),
('BxSEtBZWtJHazIeMVzILBv57lm2i5QXw2kGNGz5R', NULL, '144.91.73.51', 'Mozilla/5.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoib1hNYmZ2bmp3M0dBcGdjSjRTNXdiNUx0MGJvTW5TeHp0b29qQ05rVCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NTM6Imh0dHA6Ly93d3cua2FzdG9lZC5zdG9lZGlvcG9ydGFsLmNvbS9pbmRleC5waHA/aW5mbz0xIjtzOjU6InJvdXRlIjtzOjI3OiJnZW5lcmF0ZWQ6OjZ5cUxIUDA4RXBWUEJiaXIiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1774837219),
('C79HKS9Gyq9qnIUVg46zTnFzXb1TL5zVvwa5HDGd', NULL, '205.169.39.11', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.5938.132 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiZnpQc29sR3RRWHU1S2RyVWZTNGdKVkdudDhFMlZhRDVOaTM2MHh0VyI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzI6Imh0dHA6Ly9rYXN0b2VkLnN0b2VkaW9wb3J0YWwuY29tIjtzOjU6InJvdXRlIjtzOjI3OiJnZW5lcmF0ZWQ6OjZ5cUxIUDA4RXBWUEJiaXIiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1774857684),
('cLaTujbhyLgMLp6QIElTiuKjI5669jOHZH5yyHKJ', NULL, '147.185.132.46', 'Hello from Palo Alto Networks, find out more about our scans in https://docs-cortex.paloaltonetworks.com/r/1/Cortex-Xpanse/Scanning-activity', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiMTJlUFBjS09YVXdQTWRZRkRTR3BwN1VQQ3ZVTzRjV21vM0xNNzZGMSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzY6Imh0dHA6Ly93d3cua2FzdG9lZC5zdG9lZGlvcG9ydGFsLmNvbSI7czo1OiJyb3V0ZSI7czoyNzoiZ2VuZXJhdGVkOjo2eXFMSFAwOEVwVlBCYmlyIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1775603277),
('crZcnqgViLDa1vaGU6vedM0NzidCMAAyQT638Ta8', NULL, '136.112.160.31', 'Mozilla/5.0 (compatible; CMS-Checker/1.0; +https://example.com)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoidVlZVVlmSnNzd1BaYXkzWTduU0V6TFM4NWR3aDRzaGxuMEZwQkhVUiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzY6Imh0dHA6Ly93d3cua2FzdG9lZC5zdG9lZGlvcG9ydGFsLmNvbSI7czo1OiJyb3V0ZSI7czoyNzoiZ2VuZXJhdGVkOjo2eXFMSFAwOEVwVlBCYmlyIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1774453035),
('D14PZcn7xwaXL8S8MJl5ediCPI9sh7S4l1p98HOe', NULL, '74.7.227.186', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoidDZndXNhTTM2STY1UFlHYWpYcTZyTzFZSDRnaWFrTHB4SGNSSjlEMiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzM6Imh0dHBzOi8va2FzdG9lZC5zdG9lZGlvcG9ydGFsLmNvbSI7czo1OiJyb3V0ZSI7czoyNzoiZ2VuZXJhdGVkOjo2eXFMSFAwOEVwVlBCYmlyIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1775292360),
('D7PSHX3Afz7Hbc187dwfJWxLvZfm8i4hmWWypiGH', NULL, '167.99.95.143', 'Mozilla/5.0 (X11; Linux x86_64; rv:142.0) Gecko/20100101 Firefox/142.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiUHF2MENBM2hsOFpmalhJTTN5VTljY0hTaE9DYnNhazNnOTkxRHJTSyI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzI6Imh0dHA6Ly9rYXN0b2VkLnN0b2VkaW9wb3J0YWwuY29tIjtzOjU6InJvdXRlIjtzOjI3OiJnZW5lcmF0ZWQ6OjZ5cUxIUDA4RXBWUEJiaXIiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1774951051),
('DASwbNVeyq1dU5moQfnDfj0CKnUCGZ1z8SiU0ZzY', NULL, '2602:80d:1007::14', 'Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoia0V2dVRiNGpuYTRESlFLN2M4dXhwRUFyd3ZrU2xrUU4wNWlnTTVUWiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzM6Imh0dHBzOi8va2FzdG9lZC5zdG9lZGlvcG9ydGFsLmNvbSI7czo1OiJyb3V0ZSI7czoyNzoiZ2VuZXJhdGVkOjo2eXFMSFAwOEVwVlBCYmlyIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1774665804),
('Dw5UNb5xko9C6jJkh1uoMgxzFEXvI9OBKEPcujiP', NULL, '199.45.154.147', 'Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiNzBLOXNRQ29NQUZrRzlrcTdaU3VubXBuZ0ZRTXRia0xRM05BMUNkcyI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzY6Imh0dHA6Ly93d3cua2FzdG9lZC5zdG9lZGlvcG9ydGFsLmNvbSI7czo1OiJyb3V0ZSI7czoyNzoiZ2VuZXJhdGVkOjo2eXFMSFAwOEVwVlBCYmlyIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1774978131),
('eMoyT89rJUnJgTzn3HmyOfUSqV1trktzVjFQE3dr', NULL, '195.211.77.141', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'YToyOntzOjY6Il90b2tlbiI7czo0MDoiWUgxMVFzMWJPV1Vwb3l1VEJxeUxCUGNDY0hPRE1ESWRBNkNUS016NCI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1774601613),
('ey8NYQlpRdC1Nda76FaMPHBSh7IKiWgPoy5PvSM1', NULL, '2602:80d:1005::16', 'Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiblpHSVA2d1NQTzhDVmlQUEN6NXdqYThFdW0wZFJhU2lBT2ZKOUUyYSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzM6Imh0dHBzOi8va2FzdG9lZC5zdG9lZGlvcG9ydGFsLmNvbSI7czo1OiJyb3V0ZSI7czoyNzoiZ2VuZXJhdGVkOjo2eXFMSFAwOEVwVlBCYmlyIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1775287525),
('F6xcR9Xe15UxIboUcHzfSwRncAK7bUT7LAChSNA8', NULL, '205.210.31.50', 'Hello from Palo Alto Networks, find out more about our scans in https://docs-cortex.paloaltonetworks.com/r/1/Cortex-Xpanse/Scanning-activity', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiUkNsU2dNRm1uaUhoUGQyR011STN6MEV4emp1anp5bmR2U3B4ZG1taiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzI6Imh0dHA6Ly9rYXN0b2VkLnN0b2VkaW9wb3J0YWwuY29tIjtzOjU6InJvdXRlIjtzOjI3OiJnZW5lcmF0ZWQ6OjZ5cUxIUDA4RXBWUEJiaXIiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1775235458),
('fUYodm1KWgbTPJhnTvxYOEqZ3wLe0PA1j55vMrGn', NULL, '205.169.39.18', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.5938.132 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoicWZyRDNWb1lTTHFhMTVwbzNMZmdqalNXZGlVUXhZRkxNSUtnSVdReSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzI6Imh0dHA6Ly9rYXN0b2VkLnN0b2VkaW9wb3J0YWwuY29tIjtzOjU6InJvdXRlIjtzOjI3OiJnZW5lcmF0ZWQ6OjZ5cUxIUDA4RXBWUEJiaXIiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1775101817),
('gNhXVyRsrzKFMn3CS3qqYHwiU6wUDEqOzgeWnbZZ', NULL, '3.18.186.238', 'visionheight.com/scan Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) Chrome/126.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiSm1FZ0NEUnhrQ0JWTEdGaFJYVVFBdWJUZnp2WkpxbjVoMlp6R2tWWiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzM6Imh0dHBzOi8va2FzdG9lZC5zdG9lZGlvcG9ydGFsLmNvbSI7czo1OiJyb3V0ZSI7czoyNzoiZ2VuZXJhdGVkOjo2eXFMSFAwOEVwVlBCYmlyIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1774834318),
('GrrP1UBn6EbTxqrAMi8hYjWt2YPjQ6YHTcDy25mt', NULL, '74.7.243.235', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiVWNyWXFPS0FlbkdhaDFiSFF2TzZPMDBJWWN4V2F2bHI1MW1wZTg0cSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mzc6Imh0dHBzOi8vd3d3Lmthc3RvZWQuc3RvZWRpb3BvcnRhbC5jb20iO3M6NToicm91dGUiO3M6Mjc6ImdlbmVyYXRlZDo6NnlxTEhQMDhFcFZQQmJpciI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1775178726),
('Gvr3SP2SlZnSSXLjybpUMPZQ0TYPXv0xzH6viGru', NULL, '144.91.73.51', 'Mozilla/5.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiRzg0eUZNd0djdmhvd1pSM282aVg3TlV2MU1UM3BBZEpkaGc5RDJqWiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NDQ6Imh0dHBzOi8va2FzdG9lZC5zdG9lZGlvcG9ydGFsLmNvbS8/cGhwaW5mbz0xIjtzOjU6InJvdXRlIjtzOjI3OiJnZW5lcmF0ZWQ6OjZ5cUxIUDA4RXBWUEJiaXIiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1774828984),
('hLcpu7meNQUanOzy2gBgV85zOCGodOeoddT1VnSz', NULL, '195.211.77.141', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiU2lWV3RZd1Y5QkViOVhpdFljSmZIeDV4UUZEcFBLbGdIb3I3VkxpMSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzM6Imh0dHBzOi8va2FzdG9lZC5zdG9lZGlvcG9ydGFsLmNvbSI7czo1OiJyb3V0ZSI7czoyNzoiZ2VuZXJhdGVkOjo2eXFMSFAwOEVwVlBCYmlyIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1774601629),
('Iu8Jg5SzHpCQMtAGr9EMXbX780jfIYR0Tw96Zq7a', NULL, '104.197.69.115', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiYWdtcjNOMWd5ZENUQUQ1ZUxCMlo1UHN6ZjBnQWJzSWFwQkR3QW5ieCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NDQ6Imh0dHA6Ly9rYXN0b2VkLnN0b2VkaW9wb3J0YWwuY29tL2FkbWluL2xvZ2luIjtzOjU6InJvdXRlIjtzOjI1OiJmaWxhbWVudC5hZG1pbi5hdXRoLmxvZ2luIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1774676362),
('J19Xxq7BPWCoFEZ1TOU4nFYBgn08dvLi2u2K2KxR', NULL, '74.7.243.252', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiT0NvcEljdjZOUDRoalJ0NFNNZkVkS3JKYkp0aGtSb2FmZGR6MW5EZCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzM6Imh0dHBzOi8va2FzdG9lZC5zdG9lZGlvcG9ydGFsLmNvbSI7czo1OiJyb3V0ZSI7czoyNzoiZ2VuZXJhdGVkOjo2eXFMSFAwOEVwVlBCYmlyIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1774492558),
('Jh2j3QvJK5LVl3jQezduoTAVcgfYDjkVaxbcDc3Z', NULL, '2602:80d:1007::64', 'Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiNjI3WmJzRk8xMmZLU0dJQ1ZvcDA0MUFUbzZWUlJ1S0duZmpLTXk5OSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzY6Imh0dHA6Ly93d3cua2FzdG9lZC5zdG9lZGlvcG9ydGFsLmNvbSI7czo1OiJyb3V0ZSI7czoyNzoiZ2VuZXJhdGVkOjo2eXFMSFAwOEVwVlBCYmlyIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1774731711),
('JneMQ363gEvrQBIyVyJiawnXkuLvsJxR3LOWrM1M', NULL, '2a14:7c1:400::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.3', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiRTludXZYTkE4Zjd1WUZGc3hzUFpNdEcyS01NbHEzR3RMdU9Sd2ttMiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzM6Imh0dHBzOi8va2FzdG9lZC5zdG9lZGlvcG9ydGFsLmNvbSI7czo1OiJyb3V0ZSI7czoyNzoiZ2VuZXJhdGVkOjo2eXFMSFAwOEVwVlBCYmlyIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1775330381),
('LKXN85p9cnwXAsWF6uURI5MoB6kpMIzlbuHDKphU', NULL, '205.210.31.2', 'Hello from Palo Alto Networks, find out more about our scans in https://docs-cortex.paloaltonetworks.com/r/1/Cortex-Xpanse/Scanning-activity', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoidVB0TzZZbllOdmlnVzlFNmlMbmhOSHc1WFdwam4zZHUwUzhvVHdDMyI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzI6Imh0dHA6Ly9rYXN0b2VkLnN0b2VkaW9wb3J0YWwuY29tIjtzOjU6InJvdXRlIjtzOjI3OiJnZW5lcmF0ZWQ6OjZ5cUxIUDA4RXBWUEJiaXIiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1775574865),
('N2CyOB376lpM6KR6kvLdHazgmwGOcv4ZgHhIBI5u', NULL, '2602:80d:1005::18', 'Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiWDRaUmxhZkpUNzZTU1dkY2tLU202QndhZ09GQVo5UDVUS1hSVzlyVyI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzI6Imh0dHA6Ly9rYXN0b2VkLnN0b2VkaW9wb3J0YWwuY29tIjtzOjU6InJvdXRlIjtzOjI3OiJnZW5lcmF0ZWQ6OjZ5cUxIUDA4RXBWUEJiaXIiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1774644808),
('NHeovvuyV5A7M7YxMHsqSGtWbMbBptjFPRDdiImi', NULL, '2602:80d:1007::76', 'Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiWGxJTzM4UVlrZmpldUJSYzRTZlN5bkgzZEhveDI3bVd4bjVjQWJ0QiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mzc6Imh0dHBzOi8vd3d3Lmthc3RvZWQuc3RvZWRpb3BvcnRhbC5jb20iO3M6NToicm91dGUiO3M6Mjc6ImdlbmVyYXRlZDo6NnlxTEhQMDhFcFZQQmJpciI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1774726001),
('NnpFf6y27ku4wNjC1Apg3Gq5ReYeYhXgAQJCSj12', NULL, '2a14:7c1:400::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.3', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiVGd1ZkNFTksyOHJYUFBKQVplWHU5ZTM0ckJzVnVaWVFRVzFvQXZMcSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzM6Imh0dHBzOi8va2FzdG9lZC5zdG9lZGlvcG9ydGFsLmNvbSI7czo1OiJyb3V0ZSI7czoyNzoiZ2VuZXJhdGVkOjo2eXFMSFAwOEVwVlBCYmlyIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1774795487),
('o4Yc5jz8fSZsRHoJkAdSGw1RJdoeoVf6STHaXCjT', NULL, '66.132.195.105', 'Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiTDlITzgxVm9uZExPbnN2RUtoWmpXVEpEbGRKckg2WXpGc0JZanV4dSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzM6Imh0dHBzOi8va2FzdG9lZC5zdG9lZGlvcG9ydGFsLmNvbSI7czo1OiJyb3V0ZSI7czoyNzoiZ2VuZXJhdGVkOjo2eXFMSFAwOEVwVlBCYmlyIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1775488594),
('ogXyYpMCVD00giJW2r2KsUQWpd53CYntcEdubmg4', NULL, '70.224.198.136', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.3', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoibnFYb29qY1ZoY21GaHJIc0J5MFlSdlR6MlVSOTgxSElnNG9DS3ZhZiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzY6Imh0dHA6Ly93d3cua2FzdG9lZC5zdG9lZGlvcG9ydGFsLmNvbSI7czo1OiJyb3V0ZSI7czoyNzoiZ2VuZXJhdGVkOjo2eXFMSFAwOEVwVlBCYmlyIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1775282159),
('PwrAsavfJqCX1h4viXoSMZgySoNRw68FZVTFTzGw', NULL, '74.7.227.186', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoicXpwS21ySW5aVmh5MVduTGk4VElqSXo4aWNMMk5xOWt4Y2VzWFpONyI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzM6Imh0dHBzOi8va2FzdG9lZC5zdG9lZGlvcG9ydGFsLmNvbSI7czo1OiJyb3V0ZSI7czoyNzoiZ2VuZXJhdGVkOjo2eXFMSFAwOEVwVlBCYmlyIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1775090678),
('pzEPM5hRAjls90nj8h2aR09PUx4yUanYXRuf6PXP', NULL, '2602:80d:1008::21', 'Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoibGlQNDBNVEl1TXFnVnhmVHNocjNJNXJkR0xKV1NxYm5NT1l1V0lIWCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzI6Imh0dHA6Ly9rYXN0b2VkLnN0b2VkaW9wb3J0YWwuY29tIjtzOjU6InJvdXRlIjtzOjI3OiJnZW5lcmF0ZWQ6OjZ5cUxIUDA4RXBWUEJiaXIiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1775264045),
('QfJkKP3jRxW9TNqGglhyHqKRDlFaIbi3bpp44WtO', NULL, '205.210.31.40', 'Hello from Palo Alto Networks, find out more about our scans in https://docs-cortex.paloaltonetworks.com/r/1/Cortex-Xpanse/Scanning-activity', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoicFFteEFESWpYRXVjcUlza29ieWYyazY3SHU2NG53MUxwR2tLRFdqeCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzM6Imh0dHBzOi8va2FzdG9lZC5zdG9lZGlvcG9ydGFsLmNvbSI7czo1OiJyb3V0ZSI7czoyNzoiZ2VuZXJhdGVkOjo2eXFMSFAwOEVwVlBCYmlyIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1775211168),
('QKkwybpTe1ylUxmiDlExOZqIwYJ5owRaokkBtsbF', NULL, '74.7.243.235', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoibTZHUmhZakNaN0R0ZEpGY1ZtUjVrREpuRm9WRmtTdWlTNm1sMzhxbiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mzc6Imh0dHBzOi8vd3d3Lmthc3RvZWQuc3RvZWRpb3BvcnRhbC5jb20iO3M6NToicm91dGUiO3M6Mjc6ImdlbmVyYXRlZDo6NnlxTEhQMDhFcFZQQmJpciI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1774721429),
('qUIVR97vjdytA9uBv2MbaGDUUbf7OcM4Qpz7HYRn', NULL, '72.11.155.223', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 15_7_3) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.0 Safari/605.1.15', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiejZYSzhyRnN5cnltWHJLVTdYS2x1YW5pT3o4a280eGFtU05UZjZsWSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzI6Imh0dHA6Ly9rYXN0b2VkLnN0b2VkaW9wb3J0YWwuY29tIjtzOjU6InJvdXRlIjtzOjI3OiJnZW5lcmF0ZWQ6OjZ5cUxIUDA4RXBWUEJiaXIiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1775181894),
('R7sjj0lHG5xZHgHyFALnRuY7Cwezn377xqxijCoX', NULL, '15.236.212.30', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiQ2tyS2dIcVBZaXNKVFo0bXFkZFFmeUxBVTFLVEFYbXhBRzF5OVRhZyI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzM6Imh0dHBzOi8va2FzdG9lZC5zdG9lZGlvcG9ydGFsLmNvbSI7czo1OiJyb3V0ZSI7czoyNzoiZ2VuZXJhdGVkOjo2eXFMSFAwOEVwVlBCYmlyIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1775557651),
('ranjxs8Vd8dw53fVz2utMHScn2M3dYujY4EY1vww', NULL, '91.134.35.95', 'Mozilla/5.0 (Windows NT 6.3; Trident/7.0; ASI.NET; ASI; Windows NT 6.3; Trident/7.0; ASI.NET) like Gecko', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiYmlPcDdKSXJlV25tUXZUbWVhUldIQklYNm5mejI4T0UxbkVpcHFUcSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzI6Imh0dHA6Ly9rYXN0b2VkLnN0b2VkaW9wb3J0YWwuY29tIjtzOjU6InJvdXRlIjtzOjI3OiJnZW5lcmF0ZWQ6OjZ5cUxIUDA4RXBWUEJiaXIiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1775233280),
('RoQdgodaL1FdJANfsH8MPs8RGMbPCIOenuna9LJo', NULL, '35.204.109.104', 'Scrapy/2.13.4 (+https://scrapy.org)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiWXk4Q3VMc285Q0JyVlZsVVNZVXhzaU9KUWVmT1pWaXZ2ZHlEZVg1SCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzM6Imh0dHBzOi8va2FzdG9lZC5zdG9lZGlvcG9ydGFsLmNvbSI7czo1OiJyb3V0ZSI7czoyNzoiZ2VuZXJhdGVkOjo2eXFMSFAwOEVwVlBCYmlyIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1775119320),
('rWQolEO29HizpouoiP5tWDBPiGOcaItqTEBnMYfW', NULL, '144.91.73.51', 'Mozilla/5.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiQTlRRnozUXM3b3k2N2ZVNlZlV29OSVJCQTB1c0htMFhEU1VMMnd4QiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NTQ6Imh0dHBzOi8vd3d3Lmthc3RvZWQuc3RvZWRpb3BvcnRhbC5jb20vaW5kZXgucGhwP2luZm89MSI7czo1OiJyb3V0ZSI7czoyNzoiZ2VuZXJhdGVkOjo2eXFMSFAwOEVwVlBCYmlyIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1774837187),
('sWXB0f4FNRP1EKNiNldc4QOhwkbQtNv7jTiIpX8I', NULL, '3.18.186.238', 'visionheight.com/scan Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) Chrome/126.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiWWs2bVRQdllDT1VCUlMxWndBNGxYYkVTZlg0Ymppa3BJQmp6Nm9aRyI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzM6Imh0dHBzOi8va2FzdG9lZC5zdG9lZGlvcG9ydGFsLmNvbSI7czo1OiJyb3V0ZSI7czoyNzoiZ2VuZXJhdGVkOjo2eXFMSFAwOEVwVlBCYmlyIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1775568346),
('t3aMzavkw6DBeODoW1w4AGvWOtxF43Mis1R8sch2', NULL, '134.122.41.102', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiYktVbkVMQkdEMXdqdGUxMFlKUmN3U3VsWUtmZ3cwVnFabVc4Q1BUNSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzI6Imh0dHA6Ly9rYXN0b2VkLnN0b2VkaW9wb3J0YWwuY29tIjtzOjU6InJvdXRlIjtzOjI3OiJnZW5lcmF0ZWQ6OjZ5cUxIUDA4RXBWUEJiaXIiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1775140479),
('tGB1goD2VRdSly8Wgizi2oRLS4KyZapPoEpiPkHv', NULL, '205.169.39.12', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.5938.132 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiTHBFVFh2VDZrUzk5eUFpZ0Rjc1o3SXplNThmNEU1ejI2T2JYTzFqSyI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzY6Imh0dHA6Ly93d3cua2FzdG9lZC5zdG9lZGlvcG9ydGFsLmNvbSI7czo1OiJyb3V0ZSI7czoyNzoiZ2VuZXJhdGVkOjo2eXFMSFAwOEVwVlBCYmlyIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1775100985),
('uKNNyI6IO3zXeQsBwLF5JkqmrtCSlT8nLkHC8VWP', NULL, '66.132.172.33', 'Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiMmlaUzZzMEtwQnZGZno3cHZJQlRtU3phMXQ0dkJTSXYxamdtRkE2cyI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mzc6Imh0dHBzOi8vd3d3Lmthc3RvZWQuc3RvZWRpb3BvcnRhbC5jb20iO3M6NToicm91dGUiO3M6Mjc6ImdlbmVyYXRlZDo6NnlxTEhQMDhFcFZQQmJpciI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1774978081),
('V1gSwvS0zaAlESb6mM561F4fGYHkXCfN5ATHUUiW', NULL, '74.7.227.186', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoidzVXcEU1T3RqUlNJM0xiMHNCZVE0MXhNRWVmTUp6TXNRT1JwWFkwTyI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzM6Imh0dHBzOi8va2FzdG9lZC5zdG9lZGlvcG9ydGFsLmNvbSI7czo1OiJyb3V0ZSI7czoyNzoiZ2VuZXJhdGVkOjo2eXFMSFAwOEVwVlBCYmlyIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1774895090),
('V1phD6wlHyiza0imogCBEaGnNvFMWcRA2GmQeGIv', NULL, '217.216.37.56', 'Go-http-client/1.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoidGdsNm5XS2lUcGZvbDZmbTVYYThRc2hQdHczNEFyTlplc1ZISmN4SCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzI6Imh0dHA6Ly9rYXN0b2VkLnN0b2VkaW9wb3J0YWwuY29tIjtzOjU6InJvdXRlIjtzOjI3OiJnZW5lcmF0ZWQ6OjZ5cUxIUDA4RXBWUEJiaXIiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1774747532),
('WBCGiTAoRfseZTCSIPKfSPrjScQbl23Z7oriPL87', NULL, '74.7.227.186', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiOWpmZHFVVm5mbEdVbUliVW5YcXA4T25xWTNNZ1lZNVhMMzBsbnhOZyI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NDU6Imh0dHBzOi8va2FzdG9lZC5zdG9lZGlvcG9ydGFsLmNvbS9hZG1pbi9sb2dpbiI7czo1OiJyb3V0ZSI7czoyNToiZmlsYW1lbnQuYWRtaW4uYXV0aC5sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1774696345),
('XVgD393SItSsqq5sN8SdJdrAm66SjS0e6m3CzUzq', NULL, '54.176.11.195', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoib3pDYXc4bndWREc5aFd0OVo5N2U0aExRYjUyclpXMnhBNDdjd3U5ZiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mzc6Imh0dHBzOi8vd3d3Lmthc3RvZWQuc3RvZWRpb3BvcnRhbC5jb20iO3M6NToicm91dGUiO3M6Mjc6ImdlbmVyYXRlZDo6NnlxTEhQMDhFcFZQQmJpciI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1775558957),
('Xyq7NO5AFx9XPfeaB3rMQuqia2oZKALDKbEDsTyz', NULL, '103.18.35.107', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoieE5hektYVldkVVdGUjgzU1FicHdBM0IwdHFEOUd0Z2NPQTJkZXppeSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NDU6Imh0dHBzOi8va2FzdG9lZC5zdG9lZGlvcG9ydGFsLmNvbS9hZG1pbi9sb2dpbiI7czo1OiJyb3V0ZSI7czoyNToiZmlsYW1lbnQuYWRtaW4uYXV0aC5sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1775620106),
('yBF4Fx3UiNrAbmEnrKSI0s8e5Pb49BG94ktAHwXU', NULL, '2602:80d:1005::13', 'Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiV09zNTV1WnpVeXVXSXRTZGozUGVBUWl3M29aazNtbjFmOXpuOFpxRSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzY6Imh0dHA6Ly93d3cua2FzdG9lZC5zdG9lZGlvcG9ydGFsLmNvbSI7czo1OiJyb3V0ZSI7czoyNzoiZ2VuZXJhdGVkOjo2eXFMSFAwOEVwVlBCYmlyIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1775594661),
('yfpWNgHqoeO3zQnimmW7dvihU35RxIeGsBgyadYv', NULL, '3.233.59.216', 'RecordedFuture Global Inventory Crawler', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiQjJWWHVWUmdUN1VFQUYzMEg4OHVORFg1Y2VNZlc1aXplZHlXR1k0NSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzM6Imh0dHBzOi8va2FzdG9lZC5zdG9lZGlvcG9ydGFsLmNvbSI7czo1OiJyb3V0ZSI7czoyNzoiZ2VuZXJhdGVkOjo2eXFMSFAwOEVwVlBCYmlyIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1774860237),
('YKwh3XMWebesucxqiTpwkNlBsFKGMCgDv8kkaQy0', NULL, '2602:80d:1005::1e', 'Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiaFpzVXR2YVllTWV0enVBVEJSU1dGcDlhUVBZbHA5aVZndE1pNlc4USI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mzc6Imh0dHBzOi8vd3d3Lmthc3RvZWQuc3RvZWRpb3BvcnRhbC5jb20iO3M6NToicm91dGUiO3M6Mjc6ImdlbmVyYXRlZDo6NnlxTEhQMDhFcFZQQmJpciI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1775590285);

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

--
-- Table structure for table `subscription_statuses`
--

CREATE TABLE `subscription_statuses` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `subscription_statuses`
--

INSERT INTO `subscription_statuses` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'ACTIVE', '2026-01-05 21:24:45', '2026-01-05 21:24:45', NULL),
(2, 'INACTIVE', '2026-01-05 21:24:45', '2026-01-05 21:24:45', NULL),
(3, 'PENDING', '2026-01-05 21:24:45', '2026-01-05 21:24:45', NULL);

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

--
-- Table structure for table `tenants`
--

CREATE TABLE `tenants` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `address` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `tenant_media_id` bigint(20) UNSIGNED DEFAULT NULL,
  `subscription_status_id` bigint(20) UNSIGNED NOT NULL,
  `expired_at` datetime NOT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `deleted_by` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tenants`
--

INSERT INTO `tenants` (`id`, `name`, `slug`, `address`, `phone`, `tenant_media_id`, `subscription_status_id`, `expired_at`, `created_by`, `updated_by`, `deleted_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Default Tenant', 'default-tenant', 'Default Address', '0000000000', NULL, 1, '2027-01-06 04:24:45', NULL, NULL, NULL, '2026-01-05 21:24:45', '2026-01-05 21:24:45', NULL),
(2, 'TEST Tenant 1', 'test-tenant-1', 'Jl Menuju Kemakmuran Nomor 1 Laweyan Surakarta', '08123456789', 3, 1, '2027-01-06 04:56:24', 1, 2, NULL, '2026-01-05 21:56:38', '2026-01-12 16:04:16', NULL),
(3, 'TEST Tenant 2', 'test-tenant-2', 'Jl Pulpy Nomor 1 Banjarsari Surakarta', '08123345678', NULL, 2, '2026-01-06 08:07:40', 1, 1, NULL, '2026-01-06 01:07:57', '2026-01-13 04:29:58', NULL),
(4, 'Toko Hedyadrian', 'toko-hedyadrian', 'Jl. Menuju Puncak Nomor 1 Cilacap', '08123456789', NULL, 1, '2026-02-18 16:55:00', 1, 1, NULL, '2026-01-18 09:55:08', '2026-01-18 09:55:08', NULL),
(5, 'Dapoer Nenek', 'dapoer-nenek', 'Jl Raya Mangesti Nomor 1 Cilacap', '08123456789', NULL, 1, '2026-02-18 21:47:00', 1, 1, NULL, '2026-01-18 14:47:35', '2026-01-18 14:47:35', NULL),
(6, 'Nasgor Pa Ah', 'nasgor-pa-ah', 'Jl Raya Mangesti Nomor 1 Cilacap', '08123456789', NULL, 1, '2026-02-19 07:53:01', 1, 1, NULL, '2026-01-19 00:53:09', '2026-01-19 00:53:09', NULL),
(7, 'Jastip Garuda', 'jastip-garuda', 'Jl Raya Mangesti Nomor 1 Cilacap', '08123456789', NULL, 1, '2026-02-19 09:45:28', 1, 1, NULL, '2026-01-19 02:45:36', '2026-01-19 02:45:36', NULL);

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `categories_tenant_id_foreign` (`tenant_id`),
  ADD KEY `categories_created_by_foreign` (`created_by`),
  ADD KEY `categories_updated_by_foreign` (`updated_by`),
  ADD KEY `categories_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

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

--
-- Indexes for table `medias`
--
ALTER TABLE `medias`
  ADD PRIMARY KEY (`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_id_model_type_index` (`model_id`,`model_type`);

--
-- 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_id_model_type_index` (`model_id`,`model_type`);

--
-- Indexes for table `orders`
--
ALTER TABLE `orders`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `orders_order_number_unique` (`order_number`),
  ADD KEY `orders_tenant_id_foreign` (`tenant_id`),
  ADD KEY `orders_user_id_foreign` (`user_id`),
  ADD KEY `orders_payment_method_id_foreign` (`payment_method_id`),
  ADD KEY `orders_order_status_id_foreign` (`order_status_id`),
  ADD KEY `orders_created_by_foreign` (`created_by`),
  ADD KEY `orders_updated_by_foreign` (`updated_by`),
  ADD KEY `orders_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `order_items`
--
ALTER TABLE `order_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_items_order_id_foreign` (`order_id`),
  ADD KEY `order_items_product_id_foreign` (`product_id`),
  ADD KEY `order_items_created_by_foreign` (`created_by`),
  ADD KEY `order_items_updated_by_foreign` (`updated_by`),
  ADD KEY `order_items_deleted_by_foreign` (`deleted_by`);

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

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

--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`);

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`),
  ADD KEY `products_tenant_id_foreign` (`tenant_id`),
  ADD KEY `products_category_id_foreign` (`category_id`),
  ADD KEY `products_product_image_id_foreign` (`product_image_id`),
  ADD KEY `products_created_by_foreign` (`created_by`),
  ADD KEY `products_updated_by_foreign` (`updated_by`),
  ADD KEY `products_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`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 `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

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

--
-- Indexes for table `tenants`
--
ALTER TABLE `tenants`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `tenants_slug_unique` (`slug`),
  ADD KEY `tenants_tenant_media_id_foreign` (`tenant_media_id`),
  ADD KEY `tenants_subscription_status_id_foreign` (`subscription_status_id`),
  ADD KEY `tenants_created_by_foreign` (`created_by`),
  ADD KEY `tenants_updated_by_foreign` (`updated_by`),
  ADD KEY `tenants_deleted_by_foreign` (`deleted_by`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `medias`
--
ALTER TABLE `medias`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `orders`
--
ALTER TABLE `orders`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=46;

--
-- AUTO_INCREMENT for table `order_items`
--
ALTER TABLE `order_items`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=79;

--
-- AUTO_INCREMENT for table `order_statuses`
--
ALTER TABLE `order_statuses`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `payment_methods`
--
ALTER TABLE `payment_methods`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=114;

--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=51;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `subscription_statuses`
--
ALTER TABLE `subscription_statuses`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `tenants`
--
ALTER TABLE `tenants`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `categories`
--
ALTER TABLE `categories`
  ADD CONSTRAINT `categories_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `categories_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `categories_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`),
  ADD CONSTRAINT `categories_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- 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 `orders`
--
ALTER TABLE `orders`
  ADD CONSTRAINT `orders_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `orders_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `orders_order_status_id_foreign` FOREIGN KEY (`order_status_id`) REFERENCES `order_statuses` (`id`),
  ADD CONSTRAINT `orders_payment_method_id_foreign` FOREIGN KEY (`payment_method_id`) REFERENCES `payment_methods` (`id`),
  ADD CONSTRAINT `orders_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`),
  ADD CONSTRAINT `orders_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `orders_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `order_items`
--
ALTER TABLE `order_items`
  ADD CONSTRAINT `order_items_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `order_items_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `order_items_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`),
  ADD CONSTRAINT `order_items_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`),
  ADD CONSTRAINT `order_items_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `products`
--
ALTER TABLE `products`
  ADD CONSTRAINT `products_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`),
  ADD CONSTRAINT `products_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `products_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `products_product_image_id_foreign` FOREIGN KEY (`product_image_id`) REFERENCES `medias` (`id`),
  ADD CONSTRAINT `products_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`),
  ADD CONSTRAINT `products_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- 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 `tenants`
--
ALTER TABLE `tenants`
  ADD CONSTRAINT `tenants_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `tenants_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `tenants_subscription_status_id_foreign` FOREIGN KEY (`subscription_status_id`) REFERENCES `subscription_statuses` (`id`),
  ADD CONSTRAINT `tenants_tenant_media_id_foreign` FOREIGN KEY (`tenant_media_id`) REFERENCES `medias` (`id`),
  ADD CONSTRAINT `tenants_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);
COMMIT;

