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

START TRANSACTION;



--
-- Database: `e_commerce_mid`
--

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

--
-- Table structure for table `brands`
--

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

--
-- Dumping data for table `brands`
--

INSERT INTO `brands` (`id`, `name`, `slug`, `description`, `created_at`, `updated_at`) VALUES
(1, 'So Good', 'so-good', 'Premium frozen food products', '2026-06-16 05:55:51', '2026-06-16 05:55:51'),
(2, 'Kanzler', 'kanzler', 'Premium beef and chicken frozen products', '2026-06-16 05:55:51', '2026-06-16 05:55:51'),
(3, 'Fiesta', 'fiesta', 'Quality frozen food with international taste', '2026-06-16 05:55:51', '2026-06-16 05:55:51'),
(4, 'Champ', 'champ', 'Frozen chicken products for everyday meals', '2026-06-16 05:55:51', '2026-06-16 05:55:51'),
(5, 'Belva', 'belva', 'Traditional Indonesian frozen snacks', '2026-06-16 05:55:51', '2026-06-16 05:55:51'),
(6, 'Finna', 'finna', 'Seafood-based frozen traditional food', '2026-06-16 05:55:51', '2026-06-16 05:55:51'),
(7, 'Cedea', 'cedea', 'Chinese-style frozen dimsum and snacks', '2026-06-16 05:55:51', '2026-06-16 05:55:51'),
(8, 'Otak-Otak Cap Jempol', 'otak-otak-cap-jempol', 'Traditional Indonesian otak-otak ikan', '2026-06-16 05:55:51', '2026-06-16 05:55:51'),
(9, 'Golden Wheat', 'golden-wheat', 'Premium frozen potato products', '2026-06-16 05:55:51', '2026-06-16 05:55:51'),
(10, 'Wall\'s', 'walls', 'World-famous ice cream and frozen desserts', '2026-06-16 05:55:51', '2026-06-16 05:55:51');

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

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

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

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

INSERT INTO `categories` (`id`, `name`, `slug`, `description`, `created_at`, `updated_at`) VALUES
(11, 'Sayuran Beku', 'sayuran-beku', 'Frozen vegetables seperti kentang, brokoli, dan mix sayuran', '2026-06-16 05:55:51', '2026-06-16 05:55:51'),
(12, 'Daging & Ayam Beku', 'daging-ayam-beku', 'Frozen meat and chicken products seperti sosis, nugget, dan wings', '2026-06-16 05:55:51', '2026-06-16 05:55:51'),
(13, 'Makanan Laut Beku', 'makanan-laut-beku', 'Frozen seafood seperti otak-otak, fish finger, dan tempura udang', '2026-06-16 05:55:51', '2026-06-16 05:55:51'),
(14, 'Camilan Beku', 'camilan-beku', 'Frozen snacks seperti dimsum, lumpia, pisang goreng, dan tahu isi', '2026-06-16 05:55:51', '2026-06-16 05:55:51');

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

--
-- 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 `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, '2024_11_07_133714_create_categories', 1),
(5, '2024_11_07_133837_create_products', 1),
(6, '2024_11_07_134744_create_orders', 1),
(7, '2024_11_07_135133_create_order_items', 1),
(8, '2024_11_08_000001_create_brands', 2),
(9, '2024_11_08_000002_add_brand_id_to_products_table', 2),
(10, '2024_11_08_000003_create_otp_codes_table', 3),
(11, '2024_11_09_000001_create_shipping_costs_table', 4),
(12, '2024_11_09_000002_modify_orders_table', 4),
(13, '2024_11_09_000003_modify_users_role', 4);

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

--
-- 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,
  `quantity` int(11) NOT NULL,
  `price` decimal(15,2) 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 `order_items`
--

INSERT INTO `order_items` (`id`, `order_id`, `product_id`, `quantity`, `price`, `created_at`, `updated_at`) VALUES
(1, 1, 2, 1, 35000.00, '2026-06-16 07:18:30', '2026-06-16 07:18:30'),
(2, 1, 3, 1, 45000.00, '2026-06-16 07:18:30', '2026-06-16 07:18:30'),
(3, 2, 11, 1, 25000.00, '2026-06-16 07:41:43', '2026-06-16 07:41:43'),
(4, 2, 12, 1, 27000.00, '2026-06-16 07:41:43', '2026-06-16 07:41:43'),
(5, 2, 16, 1, 32000.00, '2026-06-16 07:41:43', '2026-06-16 07:41:43');

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

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

CREATE TABLE `products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `category_id` bigint(20) UNSIGNED NOT NULL,
  `brand_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `price` decimal(15,2) NOT NULL,
  `stock` int(11) DEFAULT NULL,
  `image` longtext DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `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 `products`
--

INSERT INTO `products` (`id`, `category_id`, `brand_id`, `name`, `slug`, `description`, `price`, `stock`, `image`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 14, 1, 'So Good Chicken Nugget 500g', 'so-good-chicken-nugget-500g', 'Chicken nugget premium dari So Good, terbuat dari daging ayam pilihan dengan balutan tepung renyah. Cocok untuk camilan keluarga.', 38000.00, 100, 'data:image/jpeg;base64,[BLOB]', 1, '2026-06-16 05:56:33', '2026-06-16 05:56:33'),
(2, 12, 1, 'So Good Sosis Ayam 500g', 'so-good-sosis-ayam-500g', 'Sosis ayam berkualitas tinggi dari So Good, siap digoreng atau dibakar untuk lauk praktis sehari-hari.', 35000.00, 89, 'data:image/jpeg;base64,[BLOB]', 1, '2026-06-16 05:56:33', '2026-06-16 07:24:50');
INSERT INTO `products` (`id`, `category_id`, `brand_id`, `name`, `slug`, `description`, `price`, `stock`, `image`, `is_active`, `created_at`, `updated_at`) VALUES
(3, 14, 2, 'Kanzler Beef Nugget 500g', 'kanzler-beef-nugget-500g', 'Beef nugget premium dengan daging sapi asli, tekstur juicy dan rasa yang lezat.', 45000.00, 79, 'data:image/jpeg;base64,[BLOB]', 1, '2026-06-16 05:56:33', '2026-06-16 07:24:50'),
(4, 12, 2, 'Kanzler Sosis Sapi 500g', 'kanzler-sosis-sapi-500g', 'Sosis sapi premium Kanzler dengan potongan daging sapi asli, kaya rasa dan protein.', 42000.00, 75, 'data:image/jpeg;base64,[BLOB]', 1, '2026-06-16 05:56:33', '2026-06-16 05:56:33');
INSERT INTO `products` (`id`, `category_id`, `brand_id`, `name`, `slug`, `description`, `price`, `stock`, `image`, `is_active`, `created_at`, `updated_at`) VALUES
(5, 14, 2, 'Kanzler Chicken Pop 250g', 'kanzler-chicken-pop-250g', 'Chicken pop Kanzler, potongan daging ayam berbumbu dengan balutan tepung crispy yang digemari anak-anak.', 28000.00, 95, 'data:image/jpeg;base64,[BLOB]', 1, '2026-06-16 05:56:33', '2026-06-16 05:56:33'),
(6, 13, 3, 'Fiesta Fish Finger 500g', 'fiesta-fish-finger-500g', 'Fish finger Fiesta dari daging ikan fillet berkualitas, dilapisi tepung roti renyah.', 40000.00, 70, 'data:image/jpeg;base64,[BLOB]', 1, '2026-06-16 05:56:33', '2026-06-16 05:56:33'),
(7, 12, 3, 'Fiesta Chicken Wings 500g', 'fiesta-chicken-wings-500g', 'Sayap ayam Fiesta yang sudah dibumbui, siap dipanggang atau digoreng untuk hidangan spesial.', 45000.00, 60, 'data:image/jpeg;base64,[BLOB]', 1, '2026-06-16 05:56:33', '2026-06-16 05:56:33');
INSERT INTO `products` (`id`, `category_id`, `brand_id`, `name`, `slug`, `description`, `price`, `stock`, `image`, `is_active`, `created_at`, `updated_at`) VALUES
(8, 13, 3, 'Fiesta Tempura Udang 300g', 'fiesta-tempura-udang-300g', 'Tempura udang Fiesta dengan udang utuh dan balutan tepung Jepang yang ringan dan renyah.', 48000.00, 55, 'data:image/jpeg;base64,[BLOB]', 1, '2026-06-16 05:56:33', '2026-06-16 05:56:33'),
(9, 12, 4, 'Champ Sosis Ayam 500g', 'champ-sosis-ayam-500g', 'Sosis ayam Champ dengan harga terjangkau, cocok untuk bekal sekolah dan lauk praktis.', 32000.00, 85, 'data:image/jpeg;base64,[BLOB]', 1, '2026-06-16 05:56:33', '2026-06-16 05:56:33');
INSERT INTO `products` (`id`, `category_id`, `brand_id`, `name`, `slug`, `description`, `price`, `stock`, `image`, `is_active`, `created_at`, `updated_at`) VALUES
(10, 14, 4, 'Champ Naget Ayam 500g', 'champ-naget-ayam-500g', 'Naget ayam Champ favorit keluarga, renyah di luar dan lembut di dalam.', 30000.00, 110, 'data:image/jpeg;base64,[BLOB]', 1, '2026-06-16 05:56:33', '2026-06-16 05:56:33'),
(11, 14, 5, 'Belva Pisang Goreng Frozen 500g', 'belva-pisang-goreng-frozen-500g', 'Pisang goreng frozen Belva, tinggal goreng untuk camilan tradisional yang praktis.', 25000.00, 64, 'data:image/jpeg;base64,[BLOB]', 1, '2026-06-16 05:56:33', '2026-06-16 07:41:43'),
(12, 14, 5, 'Belva Tahu Isi Frozen 500g', 'belva-tahu-isi-frozen-500g', 'Tahu isi frozen Belva dengan isian sayuran dan daging, siap digoreng kapan saja.', 27000.00, 59, 'data:image/jpeg;base64,[BLOB]', 1, '2026-06-16 05:56:33', '2026-06-16 07:41:43');
INSERT INTO `products` (`id`, `category_id`, `brand_id`, `name`, `slug`, `description`, `price`, `stock`, `image`, `is_active`, `created_at`, `updated_at`) VALUES
(13, 13, 6, 'Finna Otak-Otak Ikan 250g', 'finna-otak-otak-ikan-250g', 'Otak-otak ikan Finna, camilan seafood tradisional dengan tekstur kenyal dan rasa gurih.', 22000.00, 75, 'data:image/jpeg;base64,[BLOB]', 1, '2026-06-16 05:56:33', '2026-06-16 05:56:33'),
(14, 14, 6, 'Finna Siomay Ikan 250g', 'finna-siomay-ikan-250g', 'Siomay ikan Finna dengan saus kacang, camilan tradisional favorit sepanjang masa.', 20000.00, 80, 'data:image/jpeg;base64,[BLOB]', 1, '2026-06-16 05:56:33', '2026-06-16 05:56:33'),
(15, 14, 7, 'Cedea Dimsum Ayam 500g', 'cedea-dimsum-ayam-500g', 'Dimsum ayam Cedea dengan kulit tipis dan isian daging ayam cincang berbumbu.', 35000.00, 70, 'data:image/jpeg;base64,[BLOB]', 1, '2026-06-16 05:56:33', '2026-06-16 05:56:33');
INSERT INTO `products` (`id`, `category_id`, `brand_id`, `name`, `slug`, `description`, `price`, `stock`, `image`, `is_active`, `created_at`, `updated_at`) VALUES
(16, 13, 7, 'Cedea Lumpia Semarang 500g', 'cedea-lumpia-semarang-500g', 'Lumpia Semarang Cedea dengan isian rebung dan udang, siap digoreng hingga keemasan.', 32000.00, 64, 'data:image/jpeg;base64,[BLOB]', 1, '2026-06-16 05:56:33', '2026-06-16 07:41:43'),
(17, 13, 8, 'Otak-Otak Cap Jempol 250g', 'otak-otak-cap-jempol-250g', 'Otak-otak ikan Cap Jempol yang legendaris, dibungkus daun pisang dengan bumbu khas.', 24000.00, 70, 'data:image/jpeg;base64,[BLOB]', 1, '2026-06-16 05:56:33', '2026-06-16 05:56:33'),
(18, 11, 9, 'Golden Wheat French Fries 1kg', 'golden-wheat-french-fries-1kg', 'Kentang goreng beku Golden Wheat ukuran 1kg, cocok untuk camilan atau pelengkap makanan.', 45000.00, 50, 'data:image/jpeg;base64,[BLOB]', 1, '2026-06-16 05:56:33', '2026-06-16 05:56:33');
INSERT INTO `products` (`id`, `category_id`, `brand_id`, `name`, `slug`, `description`, `price`, `stock`, `image`, `is_active`, `created_at`, `updated_at`) VALUES
(19, 11, 9, 'Golden Wheat Potato Wedges 500g', 'golden-wheat-potato-wedges-500g', 'Potato wedges Golden Wheat dengan bumbu herbal, siap dipanggang atau digoreng.', 28000.00, 55, 'data:image/jpeg;base64,[BLOB]', 1, '2026-06-16 05:56:33', '2026-06-16 05:56:33'),
(20, 11, 9, 'Golden Wheat Tater Tots 500g', 'golden-wheat-tater-tots-500g', 'Tater tots Golden Wheat, camilan kentang berbentuk bulat kecil yang renyah di luar lembut di dalam.', 32000.00, 45, 'data:image/jpeg;base64,[BLOB]', 1, '2026-06-16 05:56:33', '2026-06-16 05:56:33');

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

--
-- 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
('hAtdBoWwjEBfb8e4yrOuk8UlOF3aecQwBm1uPjL1', 15, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36 Edg/149.0.0.0', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiNE5qaDVvQVk5ZHdFT3dQNWRZYmtpUlViU1pqOXF5VW9SczdxR2JpaiI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjg6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9vcmRlcnMiO31zOjUwOiJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7aToxNTt9', 1781619926),
('yS67exBX7NudjMrDO0wW8lFU7GLwySl6ZvXkp2tG', 1, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiejNuOHh5aHVVRUNxcWk2REtkalZXU0VpSDEyVUZuY01xcmxIZ1VmNCI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzE6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hZG1pbi9wb3MiO31zOjUwOiJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7aToxO3M6ODoicG9zX2NhcnQiO2E6MTp7aToxMTthOjY6e3M6MjoiaWQiO2k6MTE7czo0OiJuYW1lIjtzOjMxOiJCZWx2YSBQaXNhbmcgR29yZW5nIEZyb3plbiA1MDBnIjtzOjU6InByaWNlIjtkOjI1MDAwO3M6NToiaW1hZ2UiO3M6MTYwODc6ImRhdGE6aW1hZ2UvanBlZztiYXNlNjQsLzlqLzRBQVFTa1pKUmdBQkFRRUFZQUJnQUFELy9nQStRMUpGUVZSUFVqb2daMlF0YW5CbFp5QjJNUzR3SUNoMWMybHVaeUJKU2tjZ1NsQkZSeUIyT0RBcExDQmtaV1poZFd4MElIRjFZV3hwZEhrSy85c0FRd0FJQmdZSEJnVUlCd2NIQ1FrSUNnd1VEUXdMQ3d3WkVoTVBGQjBhSHg0ZEdod2NJQ1F1SnlBaUxDTWNIQ2czS1N3d01UUTBOQjhuT1QwNE1qd3VNelF5LzlzQVF3RUpDUWtNQ3d3WURRMFlNaUVjSVRJeU1qSXlNakl5TWpJeU1qSXlNakl5TWpJeU1qSXlNakl5TWpJeU1qSXlNakl5TWpJeU1qSXlNakl5TWpJeU1qSXkvOEFBRVFnQ1dBSllBd0VpQUFJUkFRTVJBZi9FQUI4QUFBRUZBUUVCQVFFQkFBQUFBQUFBQUFBQkFnTUVCUVlIQ0FrS0MvL0VBTFVRQUFJQkF3TUNCQU1GQlFRRUFBQUJmUUVDQXdBRUVRVVNJVEZCQmhOUllRY2ljUlF5Z1pHaENDTkNzY0VWVXRId0pETmljb0lKQ2hZWEdCa2FKU1luS0NrcU5EVTJOemc1T2tORVJVWkhTRWxLVTFSVlZsZFlXVnBqWkdWbVoyaHBhbk4wZFhaM2VIbDZnNFNGaG9lSWlZcVNrNVNWbHBlWW1acWlvNlNscHFlb3FhcXlzN1MxdHJlNHVickN3OFRGeHNmSXljclMwOVRWMXRmWTJkcmg0dVBrNWVibjZPbnE4Zkx6OVBYMjkvajUrdi9FQUI4QkFBTUJBUUVCQVFFQkFRRUFBQUFBQUFBQkFnTUVCUVlIQ0FrS0MvL0VBTFVSQUFJQkFnUUVBd1FIQlFRRUFBRUNkd0FCQWdNUkJBVWhNUVlTUVZFSFlYRVRJaktCQ0JSQ2thR3h3UWtqTTFMd0ZXSnkwUW9XSkRUaEpmRVhHQmthSmljb0tTbzFOamM0T1RwRFJFVkdSMGhKU2xOVVZWWlhXRmxhWTJSbFptZG9hV3B6ZEhWMmQzaDVlb0tEaElXR2g0aUppcEtUbEpXV2w1aVptcUtqcEtXbXA2aXBxckt6dExXMnQ3aTV1c0xEeE1YR3g4akp5dExUMU5YVzE5aloydUxqNU9YbTUranA2dkx6OVBYMjkvajUrdi9hQUF3REFRQUNFUU1SQUQ4QStmNktLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0FvcTlvbGpIcWV2YWRZU3N5eDNWMUZDN0oxQVpnQ1I3ODE3VHIzd3UrRnZoblVCWWF6NHQxUzB1akdKQkcyMWp0SklCNGlQb2FBUENLSzlpYndiOEczd0l2SGQrcDlYVEkvOEFSUXA2L0JqdzVyb0k4S2VQckM3dU1mTGJUaGR4K3UxdHcvNzVvQThhb3JvUEZmZ3ZYZkJsOHRyclZtWXQrZkttUTdvNVFQN3JEK1J3ZmF1Zm9BS0s5WDBMd3RvbDM4QWRiOFF6NmVqNnRiM0RKRmNsbXlvM1JqR000L2lQYnZYbEZBQlJSUlFBVVVVVUFGRkZGQUJSUlJRQVVVVVVBRkZGRkFCUlJSUUFVVVVVQUZGRkZBQlJSUlFBVVVVQUVrQURKUFFVQUZGZXFlSFBnbHFOMXBxNng0cTFLMzhQYVpnTWZ0SkFseDdna0JNKzV6N1ZvUHBQd08wek1VdXVhdnFNZzRaa0RZejdFSW8vVTBBZU4wVjdFTksrQjJvalpGcnVzYWRJZnVsMWNqOGN4c1AxRmNmNDg4SWFONFkvcytmUlBFMXRyZHJlK1ovcXR1NkhadDRiREhydTlCMFBGQUhHMFVVVUFGRkZGQUJSUlJRQVVVVVVBRkZGRkFCUlJSUUFVVVVVQUZGRkZBQlJSUlFBVVVVVUFGRkZGQUJSUlJRQVVVVVVBRkZGRkFCUlJSUUFVVVVVQUZGRkZBQlJSUlFBVVVVVUFGRkZGQUJSUlJRQnNlRS8rUnkwUC9zSVcvOEE2TVd2UVAyaHYrU2xSLzhBWVBpLzlDZXZQL0NmL0k1YUgvMkVMZjhBOUdMWG9IN1EzL0pTby84QXNIeGYraFBRQjVQU283UnVyb3hWMU9WWlRnZytvcEtLQVBvUHdmcWovRmI0VDY1NGYxcy9hTlQwcU1QYjNMY3VUdFl4c1QzSUtsU2U0UFBKcjU4cjNQOEFaK1E2ZnBIaTdYYmpLMmNGdW9MRTRCMnE3dCtReCtkZUdVQVg0dGMxYURTSmRKaTFLN2owNlp0MGxxc3pDSnp4eVZ6ZzlCK1ZVSzlTMFB3ZG9kNThDZGE4VFQyWmJWclc0S1JUK2E0Q2pkR1B1ZzdUOTQ5cTh0b0FLSzYvNGVlQXJ6eDlyaldrTW90ckszVVNYZHlSbnkxUFFBZDJPRGo2RTlxN1M5MTM0UWVGcDJzdE44TlQrSUpZanRlN25tT3h5RHpnbmc5T29VQTlzaWdEeHlpdlhGOGMvQ3UvYnk5UitIa2x0R2VDOXBQOHc5K0NsY2w0NXR2QkNEVDdyd1pkM3JyUDVuMnEydXdjd0ViZHVDUnpuTGQyKzcxb0E1Q2l0THcvWldPbzYvWTJlcFhnc3JLV1VMUGNFZ2VXbmM4OFY2ZzE5OEV2RDM3dUhUdFY4UVRMeDV6bGxRbjN5eUQvQU1kTkFIanRGZXdENGgvQzlqNWIvRGhSRWVySzZsdjZmenE3YytBL0JIeEE4TTMycitBRGNXV3AyYTc1ZE5tWW5kM3hna2tFNE9DQ1JrWXg2QUhpVkZGZW4rQXZCMmk2NzhOUEYrc1gxbzB0L3A4VHRheUNSeHNJakxENVFRRHlPK2FBUE1LSzlkMDc0ZWVHdkIyaTIrdC9FaTZtRTl3dSszMFcySkVyajBmR0NEK0tnZHpuaWhQSDN3dVp2SWwrSE8yMnpqekVtQmt4NjlRYy93REFxQVBJcUs5YjhiZkRudy9jZUVQK0UwOENYY2sybElRTHExa1lzMFBRSEdmbUdDUmtIUFhJT0s4a29BS0s5VzhIZkRMUzR2RFE4WWVPNzFySFJTQTF2YkkySkxuUFQzd2VjQWNrYzhEa3lUZVBmaGphT1lOUCtIQXVMWWNDUzV1Y09mejNuL3g2Z0R5V2l2WExUVGZobDhRSlBzT2xwZGVGdGJsNGdTYVF5Mjh6bm91U1Rqbi9BSGZZSHBTZU5QaHZaK0VmaEhwdC9lV1BsZUlqcUJ0N21ZVE15c3U2WEdGenR3VlZDRGorZEFIa2xGRkZBQlh0SHdyOE5hWDRjOE0zUHhJOFR4ZzI5dmthZkF3eVhZSEc4RHVTM3lyNllKOURYamR2QTkxY3hXOFF6Sks0UlI3azRGZTIvSHk3ajBiVFBEWGd1eStXMXRMY1RzT203QTh0Q1IrRWg5eWFBUE0vR2ZqbldmSEdyTmVhbE9SQXJIeUxSRCs3aFgwQTduMUo1UDZWelZGRkFCUlJSUUFVVVY2QjhQdmhuSjR0dDdqV2RXdlJwZmgyMHo1MTI1QUw0NUlYUEF3T3JIZ2VoNXdBZWYwVjdEY2VLZmhGb0VwdHRKOEh6NnpzNGE2dXBTQko3Z01UL3dDZ3I5S2RhNng4SHZGa2dzNy9BRUM1OE9YRXAycGR3ekh5MEo5VG5BL0ZjZTRvQThjb3JzdmlCOFBOUThCNmpFSkpWdk5NdWh1dGIyTVlWeDZFYzRiOUNPUjN4eHRBQlJYcS93QVVmQWVsNkhZZURsOE82Yk45dDFXRi9OUkhlVnBuQ3hiY0FrODVkdUI2MWF0UGhQNGU4TFdFTi84QUVieEV0akpLdTlOT3REdWxJOXlBU2ZRN1JnZjNxQVBIcUs5SDhWM3Z3cVBoMjV0dkRHbWFvdXJaVHlicWRtMlkzRGRrRis2NS9oNzF3bWs2VmU2NXF0dHBtblFOUGQzTDdJNDE3bitnQXlTZXdCb0FwMFY3UGMrRlBoMzhOWVlvdkY4dHhydXZNZ2Q3RzBZckhGa2Nad1YvOGVPVHdRdFVsOGYvQUF6dUg4bTcrR3l4VzNUeklMak1tUHcyL3dEb1ZBSGt0RmVyZUxQaHZvdDU0VGZ4bDREdkpiclM0OG02czVUbVMzQTZuMTQ2a0huSE9TSzhwb0FLSzlVMHp3THBtcGZBMmJYN2ZUNUo5ZmE5VzNoWkhjbHN5b2dVSURnazdzZEt2LzhBQ0YrQ1BoelpRemVPN2lYVmRibFFPdWtXVC9MR0QwM0VFZm1TQjF3R29BOGNvcjErSHh6OEs3NTF0dFErSHh0TGRqdE0xdkxsbEI3OEZUK3RadnhKK0hHbmFGcE5wNHA4TDNwdmZEdDZ3VUZtM05FeHpqbnV2QkhQSUl3ZWFBUE1xS0s5aTBqNGErSFBDUGh1SHhIOFNaNVZOd00yMmt3TVJJL3MyQ0RuQkJ3Q0F1Ums1T0tBUEhhSzlZaytJUHczall3d2ZEU0o3Y2RIa3VzT2Zyd2YvUXFrZzhMZUFmaUpGSkY0UG11TkQxNVZMUjZiZlB1aW54eVFyRWsvci93SEhOQUhrZEZlby9GUHdQcG5nL3d4NFJrdHJGN2JVcnkyYiswTjBqTVdsVkk4OEVrRDVtYnBYbDFBQlJSUlFBVVVVVUFGRkZGQUJSUlJRQVVVVVVBRkZGRkFCUlJSUUFVVVVVQUZGRkZBR3g0VC93Q1J5MFAvQUxDRnYvNk1Xdllmalg0RThUK0pQSGFYMmo2UFBkMndzbzR6SWhVRGNHWWtjbjNGZVBlRS93RGtjdEQvQU93aGIvOEFveGE5YytOL2pQeEpvUGoyT3owbldyeXp0alpSdjVjTW0wYml6NVA2Q2dEZ0YrRWZqMWpnZUc3clB1NkQvd0Jtcm90RytBWGltN2NTNjFMWjZOWnFOMHNrc3F5T3Erd1U0L05oWEpOOFMvR3pqQjhVYW4rRTVIOHF4ZFMxN1dOWklPcWFyZlh1T24ybTRlVEgwM0UwQWVyZVBQR2ZoL3c1NE0vNFYvNExsKzBRSGkrdjFZRVNIT1dBWWZlTEVja2NBREE5dkdhS0tBUGIvRFAvQUNhOTRqLzYrMi85Q2hyeEN2Yi9BQXovQU1tdmVJLyt2dHYvQUVLR3ZFS0FQY1BnZ2cxSHdUNDQwYXpjSnFsemFrUllPR082TjFVL1FNZnczVjRuY1c4MXBjeTI5eEU4VThURkpJM1hES3c0SUlQUTFmOEFEL2lIVlBDK3J4YXBwRjAxdmRSNUc0Y2hsUFZXQjRJUG9mNWl2VkgrS2ZnbnhncS84SjE0UEgydkFVM3RnZm1QcGs1VmdCNmJtb0E4WW9yMmlINFplQVBHWVllQ3ZGenczeEJJc3I5Y2tuMEFJVnNlNDNWNWg0bjhLNnY0UTFoOU0xaTI4bWNEY2pLY3BLdlpsYnVQNWREZzBBWTFGWDlFMGE5OFE2MWFhVHAwZm1YZDFJRWpVbkE5U1Nld0FCSjloWHJlb1IvRDM0VU91bno2V1BGUGlSRkJuTTVBZ2hZajd1MDVBOWNZWStwRkFIaXRldGZzK1MzTnQ4UjNpeElzVTlqSXJnZzRPQ3JEK1g2KzlRbjQ5ZUpMZjVOTDByUTlPaEhBU0MxUFQzK2JINkN1eitGSHhWOFVlTC9HOGVsYXJMYlBhbTNra0lpZ0NuSUF4elFCNGQ0cHQwdFBGK3RXMFF4SERmenhxQU93a1lDdmJmZ0RmUWFYNEY4VTZoY3J1Z3RIOCtRZXFwR1dQOHE4WThhZjhqMTRoLzdDZHovNk5hdlUvaE4veVJ2NGhmOEFYcFAvQU9rNzBBZVRlSmZFV29lS3RldWRYMU9VeVR6dHd2OEFER3ZaRkhZQWY0OVNheWFLS0FQYmZnTzdhbm9Yakh3N0w4MEZ6YUJsUTlBV1YwYjg4citWZU82WGFwZmF2WldqdHRTZWRJbU9lZ1pnUDYxN0IremFBZkZPc2dqSU5pTWcvd0MrSzhYaGxrZ21TYUppa2tiQmxZZFFSeURRQjdEKzBQcUVpK0tOSzBPSWVYWVdOaXJ4eEwwRE14SDZLaWo4NjhicjN6eDVvTW54YjhKYVg0MjhOVzdTNmhERDludmJNY01kdkpDWis4Vll0OVF3N2pGZUUzZG5kV0Z3MXZlVzAxdk92M281a0tNUHFEelFCRXJGR0RLU0dCeUNEeURYMEI4VDlYbjF2OW43d3pxTjIrNjVudUlQTVk4RjNFY29KL0hCTmVUZUVQaC80ZzhaMzhVT25XVXEyck4rOHZaRUloakhjN3U1OWh5YTd2NDE2L3BsdHAyaStCTkdtRTF0bzZxYmgxT1I1aXJ0VVpIOFFCWW4zYjYwQWVPVVVVVUFiZmd4RWw4YytINDVQdU5xVnNyWkdlREt1YTd2OW9SbWI0bHFHNkxZUkJmcGx6L01tdk5OTHZUcHVyMlYrb3liYWRKZ1BYYXdQOUs5ZS9hTHNBZkVXaTYzRDgxdmVXWGxxNDZNVVl0bjhSSVB5b0E4V3IxbXorSWZ3N2dzYmVLZjRjd1N5cEdxdklYWDVtQXdUMDdtdkpxS0FQWC9BUGhaSHcyLzZKcEIvd0I5cC9oVy9lVy9nM3hSOEd2RUhpVFNmQ2RwcGM5cXhoak9BemdqeXp1QkE0Ky9pdkFhOXY4QUIvOEF5Ykw0cS82KzVQNVEwQWVLVzhFbDFjeFc4SzdwWlhDSW83c1RnQ3ZidmpiZUw0WDhNZUhmQU9uTUV0bzdjVDNBVVlNbURoU2Zxd2RqNm5GZVVlREZWL0hQaDlYKzZkU3RnY2VubXJYZWZ0Q2x6OFNrRGRCWVJCZnB1ZjhBcm1nRHlpaWlpZ0QzYndSS2ZIM3dPMS93NWVmdnJ2UlY4MnpkdVNnMnMwWUI2OVZkZjkwNHJ3bXZjdjJiaHYxTHhIRzMrcWEyaURrL1Z2NlpydzJnRDYyOFg2dnAzaFB3Um8vaXk0Z1NmVXJHeEZ0cHFTZmQ4MlpFeWZ3RVpQMEREdlh5cnF1cTMydDZuUHFPbzNNbHhkenR1a2tjNUovd0E2QWRxOXQrUE53NitDdkJkc0QrN2tqTWpEUGRZNHdQL1FqWGcxQUJYdFB3SHM3ZlRMSHhSNHl1bzk0MHUwS3hjLzdKZC94d3FqL2dScnhhdmY4QTRSZjJZdndTOFV2cTZYRGFmOXFsKzFDMy93QllZL0tqempuNjBBZUZhbHFOMXEycFhPb1hzelRYVnpJWkpIWTlTVFZXdlYvdEh3Ui81OHZFbjVqL0FPS28rMGZCSC9ueThTZm1QL2lxQUYrQU9zeVczam1UUTVEdnN0VnRwRWVGdVZMb3BZSEgrNkhINDE1MzRrMHIrdy9FK3E2VnppenU1WVZKN3FyRUEvaU1HdlZ2RC9pYjRQOEFoblhMYldOTnRQRUMzZHNXTVpjQmh5cFU1RzcwSnJ6WHh4ckZuNGc4YTZ0cTJuckl0cmR6bVNNU3FGYmtET1FQZk5BSHVIdzQ4UUw0Vy9aOHZkYk1heVBhVFRORXJEZ3lGZ3FaOXR6Q3ZualVkUnZOVzFHNDFDL3VIdUx1NGN2TEs1NVluL1BUdFhzMm5mOEFKcUdyZjlmYS93RHBURlhpRkFCWHR2Z2QyMW45bmZ4ZnBrM3pyWXU4MFdmNFFBc2dBLzRFckg4YThTcjJ2NFNnSDRSL0VYSXovb1VuL29pU2dEenY0YzZmQnFueEYwR3p1UUdoZThSblZ1akJmbXdmcmpGZEI4Y3RXdU5TK0tGL2J5c2ZKc1VqdDRVN0tOZ1kvbXpIOUs0cncvckV2aC94RnAycndydWV6dUVtMlp4dkNuSlg4UmtmalhyM3hWOEVYSGpEN0w0KzhKVzAxL2FhaEFqWE1DSis5VXFOb1lKMVBBQUlHY0ZjOGc4QUhoOVdMRyt1ZE52N2UrczVXaXViZVJaWXBGNnF3T1FhaWxoa2dsYUthTjQ1Rk9HUjFJSVB1RFhjK0FQaGZyWGpIVklIbXRKclRSbFlOY1hrcUZGS0RxRXo5NG5weHdPOUFIZmZ0RVhmMjNSZkI5MFJ0TThjMHUzcGpLeEgrdGVDMTZoOGIvRjlsNGs4VTIybjZYSWttbjZURVlFZERsV2tKRzhyN2ZLby93Q0ExNWZRQVVVVVVBRkZGRkFCUlJSUUFVVVVVQUZGRkZBQlJSUlFBVVVVVUFGRkZGQUJSUlJRQnNlRS93RGtjdEQvQU93aGIvOEFveGE5QS9hRy93Q1NsUi85ZytML0FOQ2V2UFBERTBkdjRzMGFhYVJJNG83NkIzZDJBVlZEZ2trbm9CWGNmSFhWTlAxZjRnUjNPbVg5cmUyNHNZMDgyMm1XUmR3WjhqS2tqUElvQTh5b29vb0FLS0tLQVBiL0FBei9BTW12ZUkvK3Z0di9BRUtHdkVLOWg4UGExcFVIN09XdjZYTHFkbkhxRXR5elIyanpxSlhHNkxrSm5KNkh0Mk5lUFVBRkZkajRHc2ZCT3BwZldmaTNVTHJUWjNLZllydUVFb3ArYmNINFBIM2V3NzhpdXEvNFVsYjN3TW1oK085QXZvZXpOTHRJK29VdGlnRHlhS1dTR1ZKWW5hT1JHREk2SEJVam9RZXhyM0Q0azNUK0kvZ1Q0VDhRNmxnNm1MZ1FtVmdOemdySUdQOEF3THkxYXM2MStEMmc2TEt0MTR1OGNhVERheDRaNExTVU5KSjdBbm44bEpyRStLUHhBc2ZGSDJEUlBEOXNiYncvcGE3YmRXWEJsWURhR3gxQUE0R2VlU1Qxd0FEWi9aenQ0SmZpRGV5eUtHbGgwNTJpejJKZU1FL2tTUHhOZVg2M05jM0d2YWpOZUZqZFBjeU5NV09UdkxIUDYxcWVCZkZrM2dyeGJhYXpFaGxqanlrOElPUE1qYmhoOWVoSHVCWHEydjhBZ0R3aDhTTDJUeEI0UzhVV05uY1hiYjdpeXVQbCtjOHMyM081U1Q3RUU1SU5BSGcxZTYvczVlR3AzMVhVZkVzMFpXMmpoTnBBU09IZGlDeEgwQ2dmOENyTGorRkhoWHcyVnUvR1BqZXg4cFBtTm5ZSGRKTDdBOHRqNkwrSXJkOExmRkhUTlErSXVrNmZhRzMwTHdqcHNFeTIwYzhxeEt6YkNBN2tuR2VUZ1pKNVBKSm9BOGQ4YWY4QUk5ZUlmK3duYy84QW8xcTlUK0UzL0pHL2lGLzE2VC8razcxNVI0dG1pdWZHZXV6d1NwTERMcUZ3OGNrYkJsZFRJeEJCSEJCSGV2U3ZoanJXbFdId284YzJkN3FkbmJYVnpiVExCQk5PcVBLVEF3QVZTY3R6eHhRQjQ3UlJSUUI3WCt6Wi93QWpWclAvQUY1RC93QkRGZUtWNjkrei9yT2w2TjRsMWFYVmRTczdHTjdNS2ozVTZ4Qmp2QndDeEdUWGtOQUh2ZnhMMUhYdkMvaFR3YzNoRzR1clhRWWJOWCswMm4zV2tLakhtRWNjZ2s4OEVsdXVPT1JnK1BYamlPSUpQUFlYUkg4VTFvdWZyOHVCK2xaWGhMNHNlS2ZCOW90alozTVZ6WUxuYmEzYWIwWEp5ZHBCQkhVOFp4N1YwamZIQ0s0WVBlK0JmRDl4SjNZeERrL2lEUUJ6MnQvR0h4dnJzRFc4MnNOYlFNTU5IWm9Jcy84QUFoODM0WnJoSzlodC9pZDRBMWRsdC9FSHc1c2JhRThHZXdDaGgrQVZELzQ5V2Q4U2ZodnB1amFOYWVMUENsNGJ2dzllRURERWt3azV4Z25rcndSenlDTUhPZUFEeStpaWlnQXIzenczNUh4YStEcmVHR21qWHhEb2dWcmJlUUM2cUNFUCs2Vk93K2h3VDJyd090SFF0ZDFMdzNxOEdxYVZjdGIzY0orVmgwSTdxUjNCOUtBS2w1WjNHbjNrMW5kd3ZEY3dPWTVJbkdHUmdjRUVWRFh1VXZpbjRkZkZPM2ovQU9FcmpiUU5mQ2hUZXcvY2t4MCtiQkdQWnh3T0ExVUgrQk50ZEh6Tkg4ZGFOZHdIa094QTQvNEN6QTBBZU9WN2Y0UC9BT1RaZkZYL0FGOXlmeWhxa3Z3VDBld2Jkcm54QjBlMGpBeVZSbDNINmJuSDhqVnZYUEZYZ1B3dDhNdFQ4RitHdFJ2ZFZtdlNYYWNwOGl1ZHVTV0lYakNERzBINjBBZU0yTjNKWWFoYlhrUCt0dDVWbFRQOTVTQ1A1VjdOOGY3RmRVVHc5NHhzZjNsamVXZ2dNaTlCMWtUUDFETi8zelhpVmVvZUFQaU5wdHRvRS9nM3huYnRkK0hialBseWdGbnRpVG5nRG5ibmtZNUI5YzhBSGw5RmV2emZCYlROV2I3UjRVOGI2UmVXajhxbDFKdGtUMk8zT1Qvd0ZmcFRyYjRUZUd2RHJyZStOUEdtbkMyaitZMmxpKzZTWHZnSDcyUG91ZmNVQWFud3RqLzRRLzRRK0tmRnQyUExONGhpdFF3eHZLaGxVajJNamtmOEJyd3F2UlBpVjhTRThWcmJhTG9sc2JIdzVZWUZ2QmdLWkNCZ013SFFBWkFIdms4OVBPNkFQYy9qMy95S3ZnZi9BSzk1UC9RSWE4TXIyWDQyYTNwT3ErRy9CMFduYW5aWGtsdkJJSmt0N2haREdka1hEQlNjZEQxOURYalZBQlh0dndMbmcxcncvd0NMUEJzOG9SNysyTWtJSjlWS09md3pHYThTclQ4UDY5ZitHZGR0ZFgwMlh5N3EyZmN1ZVF3NkZTTzRJeUQ5YUFLZDdaM0duMzA5bGRSTkZjVzhqUlN4c01GV1U0SS9NVkJYdWVvbjRkL0Z4UnFNbXFKNFk4U3NvRXkzRER5cFNPQmtuQWIwQkJEZW9QRllwK0Erb3QrOGg4VmVIWGcvNTZHNVljZmdwSDYwQWVUVVY2cGRmRHJ3WDRlc0xtZlhmSHRuZFhhUlA1Vm5wb0RreVlPME1SdUlCT09xajZpdks2QVBiOU8vNU5RMWIvcjdYLzBwaXJ4Q3ZZckRXdEtUOW1iVTlKYlU3TmRTZTVWbHN6T29tWWZhSXprSm5jZUFUMDZDdkhhQUN2YS9oSi95U1Q0aS93RFhsTC82SWtyeFN2WHZoaHJPbDZmOEwvSGxwZTZsWjIxemRXY2l3UXpUcWp5a3d1QUZVbkxISkE0OWFBUEs5TWp0cHRXczRyMS9MdEhuUlpuQnh0UXNOeC9MTmUzL0FCajhSK01QQ2ZqQ3dmUmJpNTA3UllMUkVzemJxUElZL3dBUUl3VkpHQU1Ib0FPT2VmQnE5RThOL0dqeFo0ZHNJOVBhUzIxS3lqVUlrVjlHWEtLT0FBd0lPUHJtZ0M1SDhmUEd5b0JJK25UTU9qeVdveVB5SUZjLzRpK0tQakR4UmJ2YTZockVpMmpqRFc5dW9pUmg2TnQ1WWV4SnJxMitObHBOazNQZ0R3L014R0NURVA2cWF0MmZ4QStHZmlPWmJYeEg0RXR0TFdUNWZ0ZGpqQ2Y3VGJGUmdQcHVvQThab3IwSDRuL0RsZkJOMWFYMm0zUnZORDFBYnJXWWtGbE9NN1NSd2NnZ2c5eG4wNTgrb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaXJHbnpRMitwV3M5ekY1MEVjeVBKRVJuZW9JSkhQcU9LQUs5RmV2dm9md2k4V3Q1Mm02L2RlR3JxVGxyYTdUZEVoOWllUC9BQi84QlVaK0RHbE93YUQ0amVIcElqMGZ6RkdSK0RuK2RBSGtsZTRhZDVsait5eHFZMUhjcVhWMS9vYXYvRURMR1JqL0FJRXJ0K0JxbGJlRFBoZDRVWVhmaUh4akhya2tmekxaNmVBVmMvM1RzTGYraExYTC9FYjRrVCtONXJheXRMUWFmb2RqeGEyYTRIUVlETmpnSEhBQTRVY0R1U0FjSlJSUlFBVVVVVUFGRkZGQUJSUlJRQVVVVVVBRkZGRkFCUlJSUUFVVVVVQUZGRkZBQlJSUlFBVVVVVUFGRkZGQUJSUlJRQVVWcStHNzNUZE84UTJkM3JGa2IzVG8zUG4yNHhtUlNDTURPUFhOZWxONFErRkhpVmpMb25qS1RSSkc1TnRxU2ZLaFBZRml2L29UVUFlUVVWNjEvd0FLWTB6ZG4vaFl2aDd5c1ozK1l1Y2ZUZjhBMXE3WjZKOEtQQXNpMzJxZUlQOEFoS0wrRWhvN1cwUU5DemRzZ0VxZitCUGoyTkFGbngxNWxsK3puNFNzdFMzQytlZEhpUi92QkFzaEJ4N0l5ajhSWGg5ZFo0LzhlNmg0KzF3WDEyZ2d0b1FVdGJWV3lJbFBYbnV4d01uMkhvSzVPZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQUtLS0tBQ2lpaWdBb29vb0FLS0tLQUNpaWlnQW9vb29BS0tLS0FDaWlpZ0Fvb29vQS85az0iO3M6ODoicXVhbnRpdHkiO2k6MTtzOjU6InN0b2NrIjtpOjY0O319fQ==', 1781621577);

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

--
-- Table structure for table `shipping_costs`
--

CREATE TABLE `shipping_costs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `destination` varchar(255) NOT NULL,
  `cost` decimal(15,2) 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 `shipping_costs`
--

INSERT INTO `shipping_costs` (`id`, `destination`, `cost`, `created_at`, `updated_at`) VALUES
(1, 'Surabaya', 20000.00, NULL, NULL),
(2, 'Gresik', 30000.00, NULL, NULL),
(3, 'Sidoarjo', 10000.00, NULL, NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `brands`
--
ALTER TABLE `brands`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `brands_slug_unique` (`slug`);

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `categories_slug_unique` (`slug`);

--
-- 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 `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `order_items`
--
ALTER TABLE `order_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_items_product_id_foreign` (`product_id`),
  ADD KEY `order_items_order_id_product_id_index` (`order_id`,`product_id`);

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `products_slug_unique` (`slug`),
  ADD KEY `products_category_id_foreign` (`category_id`),
  ADD KEY `products_brand_id_foreign` (`brand_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 `shipping_costs`
--
ALTER TABLE `shipping_costs`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

--
-- 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 `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

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

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

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

--
-- Constraints for table `order_items`
--
ALTER TABLE `order_items`
  ADD CONSTRAINT `order_items_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `order_items_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `products`
--
ALTER TABLE `products`
  ADD CONSTRAINT `products_brand_id_foreign` FOREIGN KEY (`brand_id`) REFERENCES `brands` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `products_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE;
COMMIT;

