-- https://www.phpmyadmin.net/
--
-- Waktu pembuatan: 15 Bulan Mei 2026 pada 12.17
-- Versi server: 9.1.0
-- Versi PHP: 8.3.14

START TRANSACTION;



--
-- Database: `kasir`
--

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

--
-- Struktur dari tabel `branches`
--

CREATE TABLE IF NOT EXISTS `branches` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` text COLLATE utf8mb4_unicode_ci,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `logo` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `has_warehouse` tinyint(1) NOT NULL DEFAULT '0',
  `warehouse_address` text COLLATE utf8mb4_unicode_ci,
  `warehouse_phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `opening_time` time DEFAULT NULL,
  `closing_time` time DEFAULT NULL,
  `is_headquarter` tinyint(1) NOT NULL DEFAULT '0',
  `barcode_prefix` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `branches_code_unique` (`code`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `branches`
--

INSERT INTO `branches` (`id`, `code`, `name`, `address`, `phone`, `email`, `logo`, `is_active`, `has_warehouse`, `warehouse_address`, `warehouse_phone`, `opening_time`, `closing_time`, `is_headquarter`, `barcode_prefix`, `created_at`, `updated_at`) VALUES
(1, 'SET', 'ABBA BENTO Setiabudi', 'Jl. Setiabudi, Seafood 2000 (Seberang Galon, Sebelah Tomoro Coffee)', '-', 'setiabudi@abbabento.com', NULL, 1, 0, NULL, NULL, '08:00:00', '22:00:00', 1, 'ABBA', '2026-05-15 12:17:13', '2026-05-15 12:17:13'),
(2, 'HLT', 'ABBA BENTO Halat', 'Jl. Halat No. 25, Sebelah Alfa Midi', '-', 'halat@abbabento.com', NULL, 1, 0, NULL, NULL, '08:00:00', '22:00:00', 0, 'ABBA', '2026-05-15 12:17:13', '2026-05-15 12:17:13');

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

--
-- Struktur dari tabel `categories`
--

CREATE TABLE IF NOT EXISTS `categories` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `categories_slug_unique` (`slug`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `categories`
--

INSERT INTO `categories` (`id`, `name`, `slug`, `description`, `created_at`, `updated_at`) VALUES
(1, 'Makanan Berat', 'makanan-berat', 'Makanan utama/porsi besar: nasi, mie, spaghetti, dll', '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(2, 'Snack Manis', 'snack-manis', 'Makanan ringan manis: pudding, kue, risol coklat, dll', '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(3, 'Snack Asin', 'snack-asin', 'Makanan ringan asin/gurih: risol, dimsum, lumpia, dll', '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(4, 'Minuman', 'minuman', 'Berbagai jenis minuman: teh, jeruk, jus, dll', '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(5, 'Dessert', 'dessert', 'Makanan penutup: pudding, bubur manis, es krim, dll', '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(6, 'Lauk Siap Santap', 'lauk-siap-santap', 'Lauk siap makan: sambal, pepes, sate, dll', '2026-05-15 12:17:17', '2026-05-15 12:17:17');

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

--
-- Struktur dari tabel `complaints`
--

CREATE TABLE IF NOT EXISTS `complaints` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `complaint_number` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `partner_id` bigint UNSIGNED DEFAULT NULL,
  `product_id` bigint UNSIGNED DEFAULT NULL,
  `transaction_id` bigint UNSIGNED DEFAULT NULL,
  `branch_id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `category` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('pending','in_progress','resolved','closed') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `resolution` text COLLATE utf8mb4_unicode_ci,
  `resolved_at` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `complaints_complaint_number_unique` (`complaint_number`),
  KEY `complaints_transaction_id_foreign` (`transaction_id`),
  KEY `complaints_user_id_foreign` (`user_id`),
  KEY `complaints_partner_id_status_index` (`partner_id`,`status`),
  KEY `complaints_product_id_status_index` (`product_id`,`status`),
  KEY `complaints_branch_id_status_index` (`branch_id`,`status`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `complaints`
--

INSERT INTO `complaints` (`id`, `complaint_number`, `partner_id`, `product_id`, `transaction_id`, `branch_id`, `user_id`, `category`, `description`, `status`, `resolution`, `resolved_at`, `created_at`, `updated_at`) VALUES
(1, 'CMP/20260415/6ICCGL', 1, 1, NULL, 1, 2, 'product_quality', 'Produk nasi goreng terasa kurang segar, kemungkinan bumbu sudah lama', 'resolved', 'Sudah dikonfirmasi dengan mitra, akan lebih diperhatikan kualitas bumbu', '2026-04-20', '2026-04-20 12:17:18', '2026-04-20 12:17:18'),
(2, 'CMP/20260426/SFJ6DT', 3, 5, NULL, 1, 6, 'packaging', 'Kemasan es jeruk bocor saat dibawa pelanggan', 'closed', 'Mitra sudah mengganti dengan kemasan yang lebih baik', '2026-04-30', '2026-04-30 12:17:18', '2026-04-30 12:17:18'),
(3, 'CMP/20260502/2DYBVT', 6, 11, NULL, 1, 7, 'product_quality', 'Puding coklat terlalu lembek dan tidak sesuai standar', 'in_progress', NULL, NULL, '2026-05-02 12:17:18', '2026-05-02 12:17:18'),
(4, 'CMP/20260514/SCC9LN', 8, 14, NULL, 1, 6, 'service', 'Pengambilan produk sisa oleh mitra terlalu lambat', 'pending', NULL, NULL, '2026-05-14 12:17:18', '2026-05-14 12:17:18'),
(5, 'CMP/20260425/IDOWCU', 4, 8, NULL, 2, 3, 'other', 'Label harga pada produk keripik singkong tidak sesuai dengan harga di kasir', 'resolved', 'Sudah dilakukan pengecekan dan perbaikan label harga', '2026-04-28', '2026-04-28 12:17:18', '2026-04-28 12:17:18');

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

--
-- Struktur dari tabel `daily_stocks`
--

CREATE TABLE IF NOT EXISTS `daily_stocks` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `product_id` bigint UNSIGNED NOT NULL,
  `partner_id` bigint UNSIGNED NOT NULL,
  `branch_id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `stock_date` date NOT NULL,
  `initial_stock` int NOT NULL DEFAULT '0',
  `sold` int NOT NULL DEFAULT '0',
  `remaining` int NOT NULL DEFAULT '0',
  `returned` int NOT NULL DEFAULT '0',
  `notes` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `product_branch_date_unique` (`product_id`,`branch_id`,`stock_date`),
  KEY `daily_stocks_user_id_foreign` (`user_id`),
  KEY `daily_stocks_partner_id_stock_date_index` (`partner_id`,`stock_date`),
  KEY `daily_stocks_branch_id_stock_date_index` (`branch_id`,`stock_date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Struktur dari tabel `failed_jobs`
--

CREATE TABLE IF NOT EXISTS `failed_jobs` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `uuid` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Struktur dari tabel `jobs`
--

CREATE TABLE IF NOT EXISTS `jobs` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `queue` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint UNSIGNED NOT NULL,
  `reserved_at` int UNSIGNED DEFAULT NULL,
  `available_at` int UNSIGNED NOT NULL,
  `created_at` int UNSIGNED NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Struktur dari tabel `job_batches`
--

CREATE TABLE IF NOT EXISTS `job_batches` (
  `id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_jobs` int NOT NULL,
  `pending_jobs` int NOT NULL,
  `failed_jobs` int NOT NULL,
  `failed_job_ids` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `options` mediumtext COLLATE utf8mb4_unicode_ci,
  `cancelled_at` int DEFAULT NULL,
  `created_at` int NOT NULL,
  `finished_at` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Struktur dari tabel `migrations`
--

CREATE TABLE IF NOT EXISTS `migrations` (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `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_01_01_000001_create_branches_table', 1),
(5, '2024_01_01_000003_create_categories_table', 1),
(6, '2024_01_01_000004_create_products_table', 1),
(7, '2024_01_01_000005_create_transactions_table', 1),
(8, '2024_01_01_000006_create_transaction_details_table', 1),
(9, '2024_01_01_000007_create_settings_table', 1),
(10, '2024_01_02_000008_create_price_tiers_table', 1),
(11, '2024_01_02_000009_create_product_bundles_table', 1),
(12, '2024_01_02_000010_create_product_bundle_items_table', 1),
(13, '2026_04_04_040640_create_product_branches_table', 1),
(14, '2026_04_06_163723_create_partners_table', 1),
(15, '2026_04_06_163931_create_daily_stocks_table', 1),
(16, '2026_04_06_164021_create_complaints_table', 1),
(17, '2026_04_07_000001_create_printers_table', 1),
(18, '2026_04_16_000000_remove_price_and_cost_from_product_branches', 1),
(19, '2026_04_16_010000_add_price_and_cost_to_products_table', 1);

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

--
-- Struktur dari tabel `partners`
--

CREATE TABLE IF NOT EXISTS `partners` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama_bank` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `no_rekening` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text COLLATE utf8mb4_unicode_ci,
  `total_sales` decimal(15,2) NOT NULL DEFAULT '0.00',
  `total_fee` decimal(15,2) NOT NULL DEFAULT '0.00',
  `current_balance` decimal(15,2) NOT NULL DEFAULT '0.00',
  `total_disbursed` decimal(15,2) NOT NULL DEFAULT '0.00',
  `fee_percentage` decimal(5,2) NOT NULL DEFAULT '20.00',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `notes` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `partners_code_unique` (`code`)
) ENGINE=MyISAM AUTO_INCREMENT=85 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `partners`
--

INSERT INTO `partners` (`id`, `code`, `name`, `nama_bank`, `no_rekening`, `phone`, `email`, `address`, `total_sales`, `total_fee`, `current_balance`, `total_disbursed`, `fee_percentage`, `is_active`, `notes`, `created_at`, `updated_at`) VALUES
(1, 'MTR-000001', 'Mulyono', NULL, NULL, '081234567001', 'mulyono@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Nasi Hainan Ayam Teriyaki, Nasi Kare Ayam Lada Hitam', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(2, 'MTR-000002', 'Sri Rezeki', NULL, NULL, '081234567002', 'srirejeki@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Pulut Kinca Durian, Nasi Goreng Ijo', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(3, 'MTR-000003', 'Lely', NULL, NULL, '081234567003', 'lely@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Gabin Fla Susu, Green Tea Creamy, The Hijau', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(4, 'MTR-000004', 'Nonie', NULL, NULL, '081234567004', 'nonie@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Risol Mayo', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(5, 'MTR-000005', 'Iqbalsyam', NULL, NULL, '081234567005', 'iqbalsyam@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Nasi Tim Ayam, Quesillo Caramel', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(6, 'MTR-000006', 'Yuni', NULL, NULL, '081234567006', 'yuni@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Aneka Pie, Leum Thai', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(7, 'MTR-000007', 'Nila', NULL, NULL, '081234567007', 'nila@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Takoyaki', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(8, 'MTR-000008', 'Ina', NULL, NULL, '081234567008', 'ina@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Brownies Almond, Putu Ayu', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(9, 'MTR-000009', 'Nur Mus Margo', NULL, NULL, '081234567009', 'nurmusmargo@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Nasi Ayam Cabe Ijo', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(10, 'MTR-000010', 'Nur Syamsiah', NULL, NULL, '081234567010', 'nursyamsiah@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Nasi Goreng Kampung Komplit, Nasi Ayam Pecak', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(11, 'MTR-000011', 'Kedai Kang Opal', NULL, NULL, '081234567011', 'kedai kangopal@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Spring Roll, Salad Sayur Ayam, Salad Sayur Telur', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(12, 'MTR-000012', 'Nanda Vita', NULL, NULL, '081234567012', 'nandavita@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Sambal Kentang Ati Ampela', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(13, 'MTR-000013', 'Pratiwi', NULL, NULL, '081234567013', 'pratiwi@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Nasi Liwet Sambal Balacan, Nasi Goreng Kangkung, Roti Sosis Mayo', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(14, 'MTR-000014', 'Sonny', NULL, NULL, '081234567014', 'sonny@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Wanpaku Sandwich, Kwetiauw Belawan', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(15, 'MTR-000015', 'Aprilia', NULL, NULL, '081234567015', 'aprilia@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Nasi Ayam Kandar, Nasi Lengko Cirebon, Cireng', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(16, 'MTR-000016', 'Tita', NULL, NULL, '081234567016', 'tita@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Pangsit Mayo, Tortilla Pizza', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(17, 'MTR-000017', 'Ummu Habib', NULL, NULL, '081234567017', 'ummuhabib@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Nasi Ayam Bakar Madu, Nasi Kuning Telor, Chicken Steak', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(18, 'MTR-000018', 'Dewi', NULL, NULL, '081234567018', 'dewi@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Nasi Ayam Kecap, Mie Goreng Ayam Suwir, Mi hun Ayam Suwir', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(19, 'MTR-000019', 'Uwie', NULL, NULL, '081234567019', 'uwie@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Risol Isi Sayur, Nasi Bakar Ayam Kemangi', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(20, 'MTR-000020', 'Susilawati Dawet', NULL, NULL, '081234567020', 'susilawatidawet@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Dawet Premium Non Santan', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(21, 'MTR-000021', 'Thalia', NULL, NULL, '081234567021', 'thalia@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Pangsit Goreng Bumbu Kacang, Nasi Daun Jeruk Telur Barend, Cheese Roll', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(22, 'MTR-000022', 'Azraim Kitchen', NULL, NULL, '081234567022', 'azraimkitchen@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Nasi Ayam Mentega, Nasi Ayam Ricis', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(23, 'MTR-000023', 'Trie', NULL, NULL, '081234567023', 'trie@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Nasi Ayam Saos Thai, Ayam Saos Thai', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(24, 'MTR-000024', 'Vina', NULL, NULL, '081234567024', 'vina@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Sus Coklat, Sus Vanilla', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(25, 'MTR-000025', 'Suci', NULL, NULL, '081234567025', 'suci@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Sambal Baby Cumi, Nasi Baby Cumi Pedas', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(26, 'MTR-000026', 'Nonik', NULL, NULL, '081234567026', 'nonik@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Ricebowl Chicken Katsu', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(27, 'MTR-000027', 'Yani', NULL, NULL, '081234567027', 'yani@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Pudding Jelly Ball', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(28, 'MTR-000028', 'Midori Berkah', NULL, NULL, '081234567028', 'midoriberkah@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Pudding, Manisan Jambu', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(29, 'MTR-000029', 'Dea Afriza', NULL, NULL, '081234567029', 'deaafriza@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Corndog Sosis', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(30, 'MTR-000030', 'Cinthia', NULL, NULL, '081234567030', 'cinthia@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Sate Kerang', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(31, 'MTR-000031', 'Nini', NULL, NULL, '081234567031', 'nini@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Aneka Jus, Bubur Manis 3 Rasa, Bubur Kacang Hijau', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(32, 'MTR-000032', 'Mama Baim', NULL, NULL, '081234567032', 'mamabaim@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Pudding Fla, Sate Jelly Rainbow', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(33, 'MTR-000033', 'Novi', NULL, NULL, '081234567033', 'novi@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Nasi Goreng Nugget, Es Sere Kesturi', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(34, 'MTR-000034', 'Rynd Febriana', NULL, NULL, '081234567034', 'ryndfebriana@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Spagetti Brule, Perkedel Jagung', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(35, 'MTR-000035', 'Citra Kusuma', NULL, NULL, '081234567035', 'citracusuma@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Nasi Goreng Aceh', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(36, 'MTR-000036', 'Ria Anjani', NULL, NULL, '081234567036', 'riaanjani@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Nasi Ayam Urap', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(37, 'MTR-000037', 'Rina', NULL, NULL, '081234567037', 'rina@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Empek-empek ikan, Lemontea, Mie Rebus', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(38, 'MTR-000038', 'Maya', NULL, NULL, '081234567038', 'maya@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Aneka Jamu', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(39, 'MTR-000039', 'Ayu', NULL, NULL, '081234567039', 'ayu@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Risol Smoke Beef Mayo, Spicy Beef Macaroni, Honey Garlic Chicken Wings', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(40, 'MTR-000040', 'Sekar', NULL, NULL, '081234567040', 'sekar@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Mangoo Sago, Aplukat Sago', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(41, 'MTR-000041', 'Yuli', NULL, NULL, '081234567041', 'yuli@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Nasi Bakar Ikan Tongkol, Bolu Kukus Aren, Pepes Jamur Tiram', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(42, 'MTR-000042', 'Intan', NULL, NULL, '081234567042', 'intan@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Nasi Chicken Katsu Bbq, Nasi Chicken Katsu smbl Mata', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(43, 'MTR-000043', 'Golda', NULL, NULL, '081234567043', 'golda@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Honey Lime Tea, Kombucha', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(44, 'MTR-000044', 'Mivi', NULL, NULL, '081234567044', 'mivi@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Siomay, Lumpia dimsum', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(45, 'MTR-000045', 'Linda Sari', NULL, NULL, '081234567045', 'lindasari@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Gado-gado Padang, Nasi Ayam Pedas Manis', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(46, 'MTR-000046', 'Dinda Risfanita', NULL, NULL, '081234567046', 'dindarisfanita@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Pempek Tenggiri, Dimsum Goreng', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(47, 'MTR-000047', 'Fauzie', NULL, NULL, '081234567047', 'fauzie@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Cheescake Crumble, Risol Macaroni', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(48, 'MTR-000048', 'Syifa', NULL, NULL, '081234567048', 'syifa@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Serabi Gula Aren, Nasi Ayam Saus Tiram', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(49, 'MTR-000049', 'Mutia Kaswie', NULL, NULL, '081234567049', 'mutiokaswie@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Kue Kaswie', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(50, 'MTR-000050', 'Abidzar', NULL, NULL, '081234567050', 'abidzar@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Nasi Lele Penyet, Bubur Singkong, Pepes Ikan Dencis', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(51, 'MTR-000051', 'Sabiah Erni', NULL, NULL, '081234567051', 'sabiaherni@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Nasi Soto Medan, Sate Puyuh', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(52, 'MTR-000052', 'Susilawati Jeruk', NULL, NULL, '081234567052', 'susilawatijeruk@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Dodol Ubi, Es Jeruk', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(53, 'MTR-000053', 'Ika Mawarni', NULL, NULL, '081234567053', 'ikamawarni@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Sushi, Macaroni Schotel, Dimsum Mentai', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(54, 'MTR-000054', 'Yuyun Cake', NULL, NULL, '081234567054', 'yuyuncake@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Lontong Pecal, Zuppa Soup, Kukis Hias', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(55, 'MTR-000055', 'Dafi', NULL, NULL, '081234567055', 'dafi@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Milky Pudding Gula Aren', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(56, 'MTR-000056', 'Alfin', NULL, NULL, '081234567056', 'alfin@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Nasi liwet teri', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(57, 'MTR-000057', 'Tami', NULL, NULL, '081234567057', 'tami@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Spagetti Bolognese, Dimsum Kukus', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(58, 'MTR-000058', 'Fitri', NULL, NULL, '081234567058', 'fitri@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Lupis, Nona Manis', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(59, 'MTR-000059', 'Fika', NULL, NULL, '081234567059', 'fika@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Nasi Ayam Chilipadi, Hotdog Sosis Jumbo, Spagetti Komplit', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(60, 'MTR-000060', 'Vira', NULL, NULL, '081234567060', 'vira@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Es Melon Cemod', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(61, 'MTR-000061', 'Vera Ver', NULL, NULL, '081234567061', 'veraver@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Pisang Lumer, Roscebowl Hot Lava', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(62, 'MTR-000062', 'Agus Lumpia', NULL, NULL, '081234567062', 'aguslumpia@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Lumpia Ayam, Tahu Balek', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(63, 'MTR-000063', 'Syarifah', NULL, NULL, '081234567063', 'syarifah@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Risol Cokelat, Salad Kampung', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(64, 'MTR-000064', 'Zahra', NULL, NULL, '081234567064', 'zahra@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Tahu Goreng Medan, Java Tea', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(65, 'MTR-000065', 'Bu Ida', NULL, NULL, '081234567065', 'buida@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Nasi Minyak Aceh, Timpan Aceh, Mie Aceh Ayam Suwir', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(66, 'MTR-000066', 'Farhan', NULL, NULL, '081234567066', 'farhan@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Grontol Jagung, Rujak Serut', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(67, 'MTR-000067', 'Hi Oppie', NULL, NULL, '081234567067', 'hioppie@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Nasi Goreng Kampung, Nasi Lemak Melayu, Pudding Tutti Frutti', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(68, 'MTR-000068', 'Nisa Donat', NULL, NULL, '081234567068', 'nisanonat@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Karipap, Pandan Nutella, Sus Buah', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(69, 'MTR-000069', 'Dinda Iqlima', NULL, NULL, '081234567069', 'dindaiqlima@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Sandwich Mayo, Spagetti Blackpaper', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(70, 'MTR-000070', 'Hera', NULL, NULL, '081234567070', 'hera@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Nasi Goreng ala Solaria, Dimsum Hongkong', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(71, 'MTR-000071', 'Wanti', NULL, NULL, '081234567071', 'wanti@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Tahu Gemoy, Mie Gomak', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(72, 'MTR-000072', 'Nidya Dhani', NULL, NULL, '081234567072', 'nidyadhani@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Nasi Ayam Bacem Smb Terasi', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(73, 'MTR-000073', 'Kiki', NULL, NULL, '081234567073', 'kiki@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Choco Cheese Nutella, Sus Es Krim', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(74, 'MTR-000074', 'Syaidah', NULL, NULL, '081234567074', 'syaidah@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Mie Yamin, Nasi Ayam Madura', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(75, 'MTR-000075', 'Malik', NULL, NULL, '081234567075', 'malik@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Susu Kedele, Nasi Kuning Komplit', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(76, 'MTR-000076', 'Ria', NULL, NULL, '081234567076', 'ria@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Nasi Ayam Tangkap, Sambal Pisang', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(77, 'MTR-000077', 'Kede Ummu', NULL, NULL, '081234567077', 'kedemmu@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Nasi Bakar Seafood', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(78, 'MTR-000078', 'Mutia Daffa', NULL, NULL, '081234567078', 'mutiadaffa@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Nasi Cokot, Nasi Ayam Suwir Sambal Mat', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(79, 'MTR-000079', 'Annisa', NULL, NULL, '081234567079', 'annisa@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Roti Jala, Nasi Ayam Lengkuas, Nasi Sambel Teri Ubi Tumbuk', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(80, 'MTR-000080', 'Zulka', NULL, NULL, '081234567080', 'zulka@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Nasi Dendeng Sapi', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(81, 'MTR-000081', 'Wiyah', NULL, NULL, '081234567081', 'wiyah@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Buko Pandan, Nasi Ayam Cabe Caplak', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(82, 'MTR-000082', 'Anggie Dwi', NULL, NULL, '081234567082', 'anggiedwi@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Lontong Sate Godok, Talam Beras Pandan Aren, Kue Lapis Pandan Coklat', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(83, 'MTR-000083', 'Dewi Maya', NULL, NULL, '081234567083', 'dewimaya@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Es Lumut Mangga, Soes Cokelat Crispy, Stik Balado', '2026-05-15 12:17:16', '2026-05-15 12:17:16'),
(84, 'MTR-000084', 'Wibi', NULL, NULL, '081234567084', 'wibi@email.com', '-', 0.00, 0.00, 0.00, 0.00, 20.00, 1, 'Spesialis: Nasi Mentai', '2026-05-15 12:17:16', '2026-05-15 12:17:16');

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

--
-- Struktur dari tabel `price_tiers`
--

CREATE TABLE IF NOT EXISTS `price_tiers` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `branch_id` bigint UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `min_qty` int NOT NULL DEFAULT '1',
  `max_qty` int DEFAULT NULL,
  `type` enum('fixed','percentage') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'percentage',
  `value` decimal(15,2) NOT NULL DEFAULT '0.00',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `price_tiers_code_unique` (`code`),
  KEY `price_tiers_branch_id_foreign` (`branch_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Struktur dari tabel `printers`
--

CREATE TABLE IF NOT EXISTS `printers` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `branch_id` bigint UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection_type` enum('browser','bluetooth','network','usb') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'browser',
  `ip_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `port` int NOT NULL DEFAULT '9100',
  `bluetooth_device_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bluetooth_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `paper_size` enum('58mm','80mm') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '80mm',
  `is_default` tinyint(1) NOT NULL DEFAULT '0',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `settings` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `printers_branch_id_is_default_index` (`branch_id`,`is_default`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Struktur dari tabel `products`
--

CREATE TABLE IF NOT EXISTS `products` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `category_id` bigint UNSIGNED DEFAULT NULL,
  `partner_id` bigint UNSIGNED DEFAULT NULL,
  `sku` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `barcode` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `category_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fee_percentage` decimal(5,2) NOT NULL DEFAULT '20.00',
  `notes` text COLLATE utf8mb4_unicode_ci,
  `unit` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pcs',
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `price` decimal(15,2) NOT NULL DEFAULT '0.00',
  `cost` decimal(15,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`id`),
  UNIQUE KEY `products_sku_unique` (`sku`),
  UNIQUE KEY `products_slug_unique` (`slug`),
  UNIQUE KEY `products_barcode_unique` (`barcode`),
  KEY `products_category_id_foreign` (`category_id`),
  KEY `products_partner_id_is_active_index` (`partner_id`,`is_active`),
  KEY `products_barcode_index` (`barcode`),
  KEY `products_partner_id_index` (`partner_id`)
) ENGINE=MyISAM AUTO_INCREMENT=170 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `products`
--

INSERT INTO `products` (`id`, `category_id`, `partner_id`, `sku`, `name`, `slug`, `barcode`, `description`, `category_type`, `fee_percentage`, `notes`, `unit`, `image`, `is_active`, `created_at`, `updated_at`, `price`, `cost`) VALUES
(1, 1, 1, 'PRD-BD2CB825', 'Nasi Hainan Ayam Teriyaki', 'nasi-hainan-ayam-teriyaki', '2D2BAEDDE141', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 12000.00, 0.00),
(2, 1, 1, 'PRD-43A49387', 'Nasi Kare Ayam Lada Hitam', 'nasi-kare-ayam-lada-hitam', '26F614951CB5', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 12000.00, 0.00),
(3, 2, 2, 'PRD-3BE245E0', 'Pulut Kinca Durian', 'pulut-kinca-durian', '6D879D097F61', NULL, 'snack_manis', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(4, 1, 2, 'PRD-E3083988', 'Nasi Goreng Ijo', 'nasi-goreng-ijo', '3508EC400B3A', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(5, 2, 3, 'PRD-B4A1F71B', 'Gabin Fla Susu', 'gabin-fla-susu', 'A14D7BF8BC07', NULL, 'snack_manis', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 6000.00, 0.00),
(6, 4, 3, 'PRD-E6549170', 'Green Tea Creamy', 'green-tea-creamy', 'B8945CEB569D', NULL, 'minuman', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(7, 4, 3, 'PRD-023098D5', 'The Hijau', 'the-hijau', '5E0CEB539A5F', NULL, 'minuman', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 7000.00, 0.00),
(8, 3, 4, 'PRD-0BA15486', 'Risol Mayo', 'risol-mayo', '1CB80A2CE2C1', NULL, 'snack_asin', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(9, 1, 5, 'PRD-4D50D7BA', 'Nasi Tim Ayam', 'nasi-tim-ayam', 'B587D7DCF9B4', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 12000.00, 0.00),
(10, 5, 5, 'PRD-CD379AFE', 'Quesillo Caramel', 'quesillo-caramel', '82B4C47E7B72', NULL, 'dessert', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(11, 2, 6, 'PRD-36BAC8CE', 'Aneka Pie', 'aneka-pie', '0A54562DDF70', NULL, 'snack_manis', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(12, 5, 6, 'PRD-CCD532B5', 'Leum Thai', 'leum-thai', 'D6E7386A44E3', NULL, 'dessert', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 6000.00, 0.00),
(13, 3, 7, 'PRD-A269AFA4', 'Takoyaki', 'takoyaki', 'BD4B1FBB3067', NULL, 'snack_asin', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(14, 2, 8, 'PRD-A835D8AB', 'Brownies Almond', 'brownies-almond', '95AB229DB0DB', NULL, 'snack_manis', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(15, 2, 8, 'PRD-2A9BACC0', 'Putu Ayu', 'putu-ayu', 'AFF99AF96F6A', NULL, 'snack_manis', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 5000.00, 0.00),
(16, 1, 9, 'PRD-DE80F433', 'Nasi Ayam Cabe Ijo', 'nasi-ayam-cabe-ijo', 'BAB0BCB01B64', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 15000.00, 0.00),
(17, 1, 10, 'PRD-30D74FFA', 'Nasi Goreng Kampung Kompli', 'nasi-goreng-kampung-kompli', '860ACECBD746', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 15000.00, 0.00),
(18, 1, 10, 'PRD-E93BBAB4', 'Nasi Ayam Pecak', 'nasi-ayam-pecak', '445EB433A6AA', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 15000.00, 0.00),
(19, 3, 11, 'PRD-6BC3C6C8', 'Spring Roll', 'spring-roll', '3EF5080CBBBE', NULL, 'snack_asin', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(20, 1, 11, 'PRD-AFB0C041', 'Salad Sayur Ayam', 'salad-sayur-ayam', '831FAA1B223B', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 15000.00, 0.00),
(21, 1, 11, 'PRD-4E87BFA7', 'Salad Sayur Telur', 'salad-sayur-telur', '68AEEBF171A0', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 13000.00, 0.00),
(22, 6, 12, 'PRD-95B2C350', 'Sambal Kentang Ati Ampela', 'sambal-kentang-ati-ampela', '311EFB28F2A6', NULL, 'lauk_siap_santap', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(23, 1, 13, 'PRD-3D3C9B9D', 'Nasi Liwet Sambal Balacan', 'nasi-liwet-sambal-balacan', 'CB11E765E38D', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(24, 1, 13, 'PRD-E5CC99A2', 'Nasi Goreng Kangkung', 'nasi-goreng-kangkung', '7B54FEEA8F91', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(25, 3, 13, 'PRD-183419E7', 'Roti Sosis Mayo', 'roti-sosis-mayo', 'DF161C055B50', NULL, 'snack_asin', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(26, 3, 14, 'PRD-266A3586', 'Wanpaku Sandwich', 'wanpaku-sandwich', '2087EEE393DE', NULL, 'snack_asin', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(27, 3, 14, 'PRD-5F00F754', 'Kwetiauw Belawan', 'kwetiauw-belawan', 'F9622312629E', NULL, 'snack_asin', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(28, 1, 15, 'PRD-9E308FB0', 'Nasi Ayam Kandar', 'nasi-ayam-kandar', '1AB1398F8094', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 12000.00, 0.00),
(29, 1, 15, 'PRD-EFFF7177', 'Nasi Lengko Cirebon', 'nasi-lengko-cirebon', '730ADED66ED6', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(30, 3, 15, 'PRD-EA564E9B', 'Cireng', 'cireng', '32A83678DDEF', NULL, 'snack_asin', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(31, 3, 16, 'PRD-6DD00FF7', 'Pangsit Mayo', 'pangsit-mayo', 'DC516F3B0A34', NULL, 'snack_asin', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(32, 3, 16, 'PRD-BA0F1658', 'Tortilla Pizza', 'tortilla-pizza', 'F81B51B54257', NULL, 'snack_asin', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(33, 1, 17, 'PRD-CF6A30B0', 'Nasi Ayam Bakar Madu', 'nasi-ayam-bakar-madu', 'F6F65AC727FE', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 15000.00, 0.00),
(34, 1, 17, 'PRD-01B90325', 'Nasi Kuning Telor', 'nasi-kuning-telor', 'C8D2A9A17077', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(35, 1, 17, 'PRD-CF85C54D', 'Chicken Steak', 'chicken-steak', '17805F5AAC82', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 15000.00, 0.00),
(36, 1, 18, 'PRD-95FE629B', 'Nasi Ayam Kecap', 'nasi-ayam-kecap', '6C9774A599C7', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 15000.00, 0.00),
(37, 1, 18, 'PRD-253F25EA', 'Mie Goreng Ayam Suwir', 'mie-goreng-ayam-suwir', '109F5771211F', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(38, 1, 18, 'PRD-CF2AAB11', 'Mi hun Ayam Suwir', 'mi-hun-ayam-suwir', '2B537D553A90', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(39, 3, 19, 'PRD-BD786233', 'Risol Isi Sayur', 'risol-isi-sayur', '7B10C9ED532B', NULL, 'snack_asin', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(40, 1, 19, 'PRD-8673D204', 'Nasi Bakar Ayam Kemangi', 'nasi-bakar-ayam-kemangi', '3598C18A275D', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(41, 4, 20, 'PRD-51F05FD8', 'Dawet Premium Non Santan', 'dawet-premium-non-santan', '1F9CDBFA93F4', NULL, 'minuman', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(42, 3, 21, 'PRD-34F2FE4E', 'Pangsit Goreng Bumbu Kacang', 'pangsit-goreng-bumbu-kacang', '639F1117CAE2', NULL, 'snack_asin', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(43, 1, 21, 'PRD-D595D29E', 'Nasi Daun Jeruk Telur Barend', 'nasi-daun-jeruk-telur-barend', 'BD89465AB59A', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(44, 2, 21, 'PRD-3652260F', 'Cheese Roll', 'cheese-roll', '5A8DBCDE6759', NULL, 'snack_manis', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(45, 1, 22, 'PRD-6285486E', 'Nasi Ayam Mentega', 'nasi-ayam-mentega', '6B59EB0B5F23', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(46, 1, 22, 'PRD-874DC59D', 'Nasi Ayam Ricis', 'nasi-ayam-ricis', '10F3B93498B8', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(47, 1, 23, 'PRD-5AC97D9F', 'Nasi Ayam Saos Thai', 'nasi-ayam-saos-thai', 'FEB553B3066B', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(48, 6, 23, 'PRD-A8748515', 'Ayam Saos Thai', 'ayam-saos-thai', '0BE79884BB29', NULL, 'lauk_siap_santap', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(49, 2, 24, 'PRD-801CC7EE', 'Sus Coklat', 'sus-coklat', '93628910FE8D', NULL, 'snack_manis', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(50, 2, 24, 'PRD-70D15B79', 'Sus Vanilla', 'sus-vanilla', 'D0117E350496', NULL, 'snack_manis', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(51, 6, 25, 'PRD-73B27806', 'Sambal Baby Cumi', 'sambal-baby-cumi', 'AE666911CDFB', NULL, 'lauk_siap_santap', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(52, 1, 25, 'PRD-51C91B1D', 'Nasi Baby Cumi Pedas', 'nasi-baby-cumi-pedas', '9E143C6D9B68', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 13000.00, 0.00),
(53, 1, 26, 'PRD-133713DE', 'Ricebowl Chicken Katsu', 'ricebowl-chicken-katsu', 'AB0DDD7423CA', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(54, 2, 27, 'PRD-A5C8E269', 'Pudding Jelly Ball', 'pudding-jelly-ball', '6E1B5E086020', NULL, 'snack_manis', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(55, 2, 28, 'PRD-06F6313D', 'Pudding', 'pudding', 'CC0A46973CA8', NULL, 'snack_manis', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(56, 2, 28, 'PRD-67C5D704', 'Manisan Jambu', 'manisan-jambu', '6ED724054324', NULL, 'snack_manis', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(57, 3, 29, 'PRD-102B7EAE', 'Corndog Sosis', 'corndog-sosis', 'B1B1CC39CEDD', NULL, 'snack_asin', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(58, 3, 30, 'PRD-FE77F9C6', 'Sate Kerang', 'sate-kerang', '1BC55533AB0E', NULL, 'snack_asin', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(59, 4, 31, 'PRD-E3C2A47D', 'Aneka Jus', 'aneka-jus', '3FF551443D2B', NULL, 'minuman', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 5000.00, 0.00),
(60, 5, 31, 'PRD-2989E5D0', 'Bubur Manis 3 Rasa', 'bubur-manis-3-rasa', '616A006CA690', NULL, 'dessert', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(61, 5, 31, 'PRD-D81BA92E', 'Bubur Kacang Hijau', 'bubur-kacang-hijau', '09D6A1EF4837', NULL, 'dessert', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 6000.00, 0.00),
(62, 5, 32, 'PRD-5B39EAC0', 'Pudding Fla', 'pudding-fla', '97C930420D90', NULL, 'dessert', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(63, 5, 32, 'PRD-81592893', 'Sate Jelly Rainbow', 'sate-jelly-rainbow', '90B1FED452C4', NULL, 'dessert', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(64, 1, 33, 'PRD-AC3CCB95', 'Nasi Goreng Nugget', 'nasi-goreng-nugget', '51CB05918EDC', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 15000.00, 0.00),
(65, 4, 33, 'PRD-08AF70A7', 'Es Sere Kesturi', 'es-sere-kesturi', 'AE4EF77DC7FD', NULL, 'minuman', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(66, 3, 34, 'PRD-CD39483F', 'Spagetti Brule', 'spagetti-brule', 'D08B6F727B86', NULL, 'snack_asin', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 12000.00, 0.00),
(67, 5, 34, 'PRD-C1823B75', 'Perkedel Jagung', 'perkedel-jagung', 'FDAD35DA1EB0', NULL, 'dessert', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(68, 1, 35, 'PRD-034E9410', 'Nasi Goreng Aceh', 'nasi-goreng-aceh', '9AACE2542EC0', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 13000.00, 0.00),
(69, 1, 36, 'PRD-939BB3C8', 'Nasi Ayam Urap', 'nasi-ayam-urap', 'F7815BEB97D4', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 15000.00, 0.00),
(70, 3, 37, 'PRD-67EF1B31', 'Empek-empek ikan', 'empek-empek-ikan', 'D704872A7A7B', NULL, 'snack_asin', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(71, 4, 37, 'PRD-495A89F2', 'Lemontea', 'lemontea', 'E9B370C3F4F7', NULL, 'minuman', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(72, 1, 37, 'PRD-A3AD8761', 'Mie Rebus', 'mie-rebus', 'A6DC5808C1E4', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(73, 5, 38, 'PRD-4E22B97A', 'Aneka Jamu', 'aneka-jamu', '6B60CE8A91E5', NULL, 'dessert', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(74, 3, 39, 'PRD-22F386E4', 'Risol Smoke Beef Mayo', 'risol-smoke-beef-mayo', '37F8422564A9', NULL, 'snack_asin', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 15000.00, 0.00),
(75, 3, 39, 'PRD-A1BA6068', 'Spicy Beef Macaroni', 'spicy-beef-macaroni', '3CC4C753A086', NULL, 'snack_asin', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 15000.00, 0.00),
(76, 6, 39, 'PRD-62358499', 'Honey Garlic Chicken Wings', 'honey-garlic-chicken-wings', 'D979E7FB035A', NULL, 'lauk_siap_santap', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 15000.00, 0.00),
(77, 5, 40, 'PRD-85864B63', 'Mangoo Sago', 'mangoo-sago', '711CD2D29397', NULL, 'dessert', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(78, 5, 40, 'PRD-037C4E16', 'Aplukat Sago', 'aplukat-sago', '48316DC3752C', NULL, 'dessert', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(79, 1, 41, 'PRD-B0C9CE8F', 'Nasi Bakar Ikan Tongkol', 'nasi-bakar-ikan-tongkol', '35F8141D61C8', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(80, 2, 41, 'PRD-EE566152', 'Bolu Kukus Aren', 'bolu-kukus-aren', '7233A774021C', NULL, 'snack_manis', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 6000.00, 0.00),
(81, 6, 41, 'PRD-365AB396', 'Pepes Jamur Tiram', 'pepes-jamur-tiram', '9E60A57B3E5C', NULL, 'lauk_siap_santap', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(82, 1, 42, 'PRD-C69B915B', 'Nasi Chicken Katsu Bbq', 'nasi-chicken-katsu-bbq', '6762A830D8E5', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 15000.00, 0.00),
(83, 1, 42, 'PRD-6BFE708B', 'Nasi Chicken Katsu smbl Mata', 'nasi-chicken-katsu-smbl-mata', 'F97EE2CD339C', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 15000.00, 0.00),
(84, 4, 43, 'PRD-D85291D6', 'Honey Lime Tea', 'honey-lime-tea', '72EF1CAAC42B', NULL, 'minuman', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(85, 4, 43, 'PRD-5FC60205', 'Kombucha', 'kombucha', '4C5662DA0C95', NULL, 'minuman', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 15000.00, 0.00),
(86, 3, 44, 'PRD-82F143D8', 'Siomay', 'siomay', '14BC23285450', NULL, 'snack_asin', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(87, 3, 44, 'PRD-92BD7A48', 'Lumpia dimsum', 'lumpia-dimsum', 'B6DB468A681F', NULL, 'snack_asin', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(88, 1, 45, 'PRD-B5BA0867', 'Gado-gado Padang', 'gado-gado-padang', 'F4DCAFEDEEAB', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(89, 1, 45, 'PRD-88FE7826', 'Nasi Ayam Pedas Manis', 'nasi-ayam-pedas-manis', 'A5FD3CBB3BE1', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(90, 3, 46, 'PRD-20EA4F85', 'Pempek Tenggiri', 'pempek-tenggiri', 'AEE97B6B5A6E', NULL, 'snack_asin', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 12000.00, 0.00),
(91, 3, 46, 'PRD-332E874B', 'Dimsum Goreng', 'dimsum-goreng', 'BC1DC4B27F0B', NULL, 'snack_asin', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 12000.00, 0.00),
(92, 2, 47, 'PRD-27693D91', 'Cheescake Crumble', 'cheescake-crumble', '5BB7AFA489AD', NULL, 'snack_manis', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 15000.00, 0.00),
(93, 3, 47, 'PRD-3820E710', 'Risol Macaroni', 'risol-macaroni', 'EE1A818F3E67', NULL, 'snack_asin', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(94, 2, 48, 'PRD-B7F11F40', 'Serabi Gula Aren', 'serabi-gula-aren', '570CE1957E96', NULL, 'snack_manis', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(95, 1, 48, 'PRD-8DA7E13B', 'Nasi Ayam Saus Tiram', 'nasi-ayam-saus-tiram', '581A4812BC0A', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 15000.00, 0.00),
(96, 2, 49, 'PRD-6A9E0C45', 'Kue Kaswie', 'kue-kaswie', '1C6D55A8F7AE', NULL, 'snack_manis', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 5000.00, 0.00),
(97, 1, 50, 'PRD-E5C95C4B', 'Nasi Lele Penyet', 'nasi-lele-penyet', '51B057FC6EA4', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 13000.00, 0.00),
(98, 5, 50, 'PRD-D278D1DB', 'Bubur Singkong', 'bubur-singkong', '9E182757DAF0', NULL, 'dessert', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(99, 6, 50, 'PRD-25C2B941', 'Pepes Ikan Dencis', 'pepes-ikan-dencis', 'A288F29A035D', NULL, 'lauk_siap_santap', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(100, 1, 51, 'PRD-F162A9A2', 'Nasi Soto Medan', 'nasi-soto-medan', '303E0BF5CE30', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(101, 3, 51, 'PRD-A7632677', 'Sate Puyuh', 'sate-puyuh', '31CF6659DC37', NULL, 'snack_asin', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(102, 2, 52, 'PRD-5C834380', 'Dodol Ubi', 'dodol-ubi', 'B4D34BF7FA39', NULL, 'snack_manis', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(103, 4, 52, 'PRD-A3BE1A92', 'Es Jeruk', 'es-jeruk', 'BBA2927E881C', NULL, 'minuman', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 7000.00, 0.00),
(104, 1, 53, 'PRD-C121700B', 'Sushi', 'sushi', '0882EDA8E5A6', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 12000.00, 0.00),
(105, 3, 53, 'PRD-30B77F83', 'Macaroni Schotel', 'macaroni-schotel', 'CEED5DA16877', NULL, 'snack_asin', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 12000.00, 0.00),
(106, 3, 53, 'PRD-D3FC2A70', 'Dimsum Mentai', 'dimsum-mentai', 'D0E895CF389F', NULL, 'snack_asin', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 12000.00, 0.00),
(107, 1, 54, 'PRD-1EEDDE85', 'Lontong Pecal', 'lontong-pecal', 'B0C98F4FB711', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(108, 3, 54, 'PRD-55FBE918', 'Zuppa Soup', 'zuppa-soup', 'F452830C5D59', NULL, 'snack_asin', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(109, 2, 54, 'PRD-0857220A', 'Kukis Hias', 'kukis-hias', '469484A15EC8', NULL, 'snack_manis', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(110, 5, 55, 'PRD-7E89F303', 'Milky Pudding Gula Aren', 'milky-pudding-gula-aren', '04D5FD74607A', NULL, 'dessert', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(111, 1, 56, 'PRD-3F76F0DB', 'Nasi liwet teri', 'nasi-liwet-teri', '72887BE5FDC5', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(112, 1, 57, 'PRD-17E9467F', 'Spagetti Bolognese', 'spagetti-bolognese', '102AAF1A7B40', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(113, 3, 57, 'PRD-08050F7D', 'Dimsum Kukus', 'dimsum-kukus', '21B72047AE2C', NULL, 'snack_asin', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(114, 2, 58, 'PRD-B6DD2D33', 'Lupis', 'lupis', 'FCC0F25B9DC1', NULL, 'snack_manis', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 6000.00, 0.00),
(115, 2, 58, 'PRD-BCE75BE6', 'Nona Manis', 'nona-manis', '6553FAD036CD', NULL, 'snack_manis', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 6000.00, 0.00),
(116, 1, 59, 'PRD-D898A4E0', 'Nasi Ayam Chilipadi', 'nasi-ayam-chilipadi', '30832F91F1C8', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(117, 3, 59, 'PRD-53944B5A', 'Hotdog Sosis Jumbo', 'hotdog-sosis-jumbo', '5FCC18A4252B', NULL, 'snack_asin', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(118, 3, 59, 'PRD-CE80B793', 'Spagetti Komplit', 'spagetti-komplit', 'E9E311C43AD2', NULL, 'snack_asin', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 15000.00, 0.00),
(119, 4, 60, 'PRD-D4A91381', 'Es Melon Cemod', 'es-melon-cemod', '47C6A5C42C25', NULL, 'minuman', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(120, 5, 61, 'PRD-B22E93CA', 'Pisang Lumer', 'pisang-lumer', 'A7D78146A826', NULL, 'dessert', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 15000.00, 0.00),
(121, 1, 61, 'PRD-61B81139', 'Roicebowl Hot Lava', 'roicebowl-hot-lava', 'D0E17E77B5F3', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(122, 3, 62, 'PRD-E40838B7', 'Lumpia Ayam', 'lumpia-ayam', '32188AEC441A', NULL, 'snack_asin', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(123, 3, 62, 'PRD-CF53EEC5', 'Tahu Balek', 'tahu-balek', '86262A66CF39', NULL, 'snack_asin', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(124, 2, 63, 'PRD-AC7A3949', 'Risol Cokelat', 'risol-cokelat', '76E2DA8FCCCD', NULL, 'snack_manis', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 12000.00, 0.00),
(125, 5, 63, 'PRD-0AE2454A', 'Salad Kampung', 'salad-kampung', '33E9E78DABC6', NULL, 'dessert', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(126, 3, 64, 'PRD-30678D64', 'Tahu Goreng Medan', 'tahu-goreng-medan', 'F1BD3ADCF0F1', NULL, 'snack_asin', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(127, 4, 64, 'PRD-61059427', 'Java Tea', 'java-tea', '255FCF671F8E', NULL, 'minuman', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 7000.00, 0.00),
(128, 1, 65, 'PRD-8D8A2FC7', 'Nasi Minyak Aceh', 'nasi-minyak-aceh', '82020E369CC9', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 12000.00, 0.00),
(129, 2, 65, 'PRD-A0BB8D81', 'Timpan Aceh', 'timpan-aceh', 'C8A47E58FE96', NULL, 'snack_manis', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(130, 1, 65, 'PRD-B7E93DC5', 'Mie Aceh Ayam Suwir', 'mie-aceh-ayam-suwir', '972E4A4A03A0', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(131, 2, 66, 'PRD-6627DB97', 'Grontol Jagung', 'grontol-jagung', '3F5D31CC34D7', NULL, 'snack_manis', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 6000.00, 0.00),
(132, 2, 66, 'PRD-4ABFDDCC', 'Rujak Serut', 'rujak-serut', 'EB55847E87BE', NULL, 'snack_manis', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(133, 1, 67, 'PRD-C0C3277A', 'Nasi Goreng Kampung', 'nasi-goreng-kampung', '196179A170C3', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(134, 1, 67, 'PRD-BD466E69', 'Nasi Lemak Melayu', 'nasi-lemak-melayu', '956971BB8ACC', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(135, 5, 67, 'PRD-5F8B9908', 'Pudding Tutti Frutti', 'pudding-tutti-frutti', '47A67730D15F', NULL, 'dessert', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(136, 3, 68, 'PRD-BE727171', 'Karipap', 'karipap', '36540108BD37', NULL, 'snack_asin', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(137, 2, 68, 'PRD-C2BD819C', 'Pandan Nutella', 'pandan-nutella', '819AB3C94D00', NULL, 'snack_manis', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(138, 2, 68, 'PRD-A38C0414', 'Sus Buah', 'sus-buah', 'C22413A67178', NULL, 'snack_manis', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(139, 3, 69, 'PRD-D8AB5B0E', 'Sandwich Mayo', 'sandwich-mayo', '8D0DFB6A2EEF', NULL, 'snack_asin', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(140, 3, 69, 'PRD-D10438FE', 'Spagetti Blackpaper', 'spagetti-blackpaper', 'C39551F18FED', NULL, 'snack_asin', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 13000.00, 0.00),
(141, 1, 70, 'PRD-F277EC0F', 'Nasi Goreng ala Solaria', 'nasi-goreng-ala-solaria', 'CDFA8196CC30', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 12000.00, 0.00),
(142, 3, 70, 'PRD-7B3FCEBE', 'Dimsum Hongkong', 'dimsum-hongkong', 'F844DC545530', NULL, 'snack_asin', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(143, 3, 71, 'PRD-E74DFB15', 'Tahu Gemoy', 'tahu-gemoy', '454C0FB6005A', NULL, 'snack_asin', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(144, 1, 71, 'PRD-1144635F', 'Mie Gomak', 'mie-gomak', 'FFA5C37C4498', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(145, 1, 72, 'PRD-8E78A015', 'Nasi Ayam Bacem Smb Terasi', 'nasi-ayam-bacem-smb-terasi', '6AF5C279A5CE', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 13000.00, 0.00),
(146, 2, 73, 'PRD-FD7AF01D', 'Choco Cheese Nutella', 'choco-cheese-nutella', '683EED935DD4', NULL, 'snack_manis', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 12000.00, 0.00),
(147, 2, 73, 'PRD-A4D34226', 'Sus Es Krim', 'sus-es-krim', 'BC381DC4B269', NULL, 'snack_manis', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(148, 1, 74, 'PRD-2158B9A8', 'Mie Yamin', 'mie-yamin', '1ECB9A612918', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(149, 1, 74, 'PRD-DFE30CE9', 'Nasi Ayam Madura', 'nasi-ayam-madura', '83F24BA62EBC', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(150, 4, 75, 'PRD-BE76E34D', 'Susu Kedele', 'susu-kedele', 'BD751A1B20E6', NULL, 'minuman', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 3000.00, 0.00),
(151, 1, 75, 'PRD-59022E02', 'Nasi Kuning Komplit', 'nasi-kuning-komplit', '6F7D3886919F', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 15000.00, 0.00),
(152, 1, 76, 'PRD-793A579B', 'Nasi Ayam Tangkap', 'nasi-ayam-tangkap', '081A6CF3CD7A', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 13000.00, 0.00),
(153, 1, 76, 'PRD-6ADE6EDD', 'Sambal Pisang', 'sambal-pisang', '5182E2C4B0AF', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(154, 1, 77, 'PRD-20F425BC', 'Nasi Bakar Seafood', 'nasi-bakar-seafood', '7DC76F50E400', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 15000.00, 0.00),
(155, 1, 78, 'PRD-D1EC5F9D', 'Nasi Cokot', 'nasi-cokot', 'C12B8B2AAD4E', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 6000.00, 0.00),
(156, 1, 78, 'PRD-1F5D02EF', 'Nasi Ayam Suwir Sambal Mat', 'nasi-ayam-suwir-sambal-mat', 'BF90C436965F', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(157, 2, 79, 'PRD-80B61F7F', 'Roti Jala', 'roti-jala', '457B2C936E33', NULL, 'snack_manis', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 13000.00, 0.00),
(158, 1, 79, 'PRD-1557DBF1', 'Nasi Ayam Lengkuas', 'nasi-ayam-lengkuas', '307B9CB2F2DA', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 15000.00, 0.00),
(159, 1, 79, 'PRD-90ABFAEA', 'Nasi Sambel Teri Ubi Tumbuk', 'nasi-sambel-teri-ubi-tumbuk', '1CDEFCE23E28', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(160, 1, 80, 'PRD-5D37F232', 'Nasi Dendeng Sapi', 'nasi-dendeng-sapi', 'DCAA00435269', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 15000.00, 0.00),
(161, 5, 81, 'PRD-165AEF01', 'Buko Pandan', 'buko-pandan', '450E1496A5A2', NULL, 'dessert', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(162, 1, 81, 'PRD-59B15DEA', 'Nasi Ayam Cabe Caplak', 'nasi-ayam-cabe-caplak', 'B4B5FAE32FA1', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(163, 1, 82, 'PRD-997BEB17', 'Lontong Sate Godok', 'lontong-sate-godok', '7553C7858ABA', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 12000.00, 0.00),
(164, 2, 82, 'PRD-62100A72', 'Talam Beras Pandan Aren', 'talam-beras-pandan-aren', 'C500BFC1B19B', NULL, 'snack_manis', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(165, 2, 82, 'PRD-D3FED210', 'Kue Lapis Pandan Coklat', 'kue-lapis-pandan-coklat', 'DCD7C6D3067E', NULL, 'snack_manis', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(166, 4, 83, 'PRD-8A7BF4B8', 'Es Lumut Mangga', 'es-lumut-mangga', 'E6DCE4C56737', NULL, 'minuman', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(167, 2, 83, 'PRD-D907A949', 'Soes Cokelat Crispy', 'soes-cokelat-crispy', 'E77D2374A467', NULL, 'snack_manis', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 10000.00, 0.00),
(168, 3, 83, 'PRD-16A3DE8B', 'Stik Balado', 'stik-balado', '1D4B7577C9A9', NULL, 'snack_asin', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 5000.00, 0.00),
(169, 1, 84, 'PRD-54AED1A6', 'Nasi Mentai', 'nasi-mentai', 'C2755DE11BC1', NULL, 'makanan_berat', 20.00, NULL, 'porsi', NULL, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17', 15000.00, 0.00);

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

--
-- Struktur dari tabel `product_branches`
--

CREATE TABLE IF NOT EXISTS `product_branches` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `product_id` bigint UNSIGNED NOT NULL,
  `branch_id` bigint UNSIGNED NOT NULL,
  `stock` int NOT NULL DEFAULT '0',
  `min_stock` int NOT NULL DEFAULT '5',
  `track_stock` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `product_branches_product_id_branch_id_unique` (`product_id`,`branch_id`),
  KEY `product_branches_branch_id_stock_index` (`branch_id`,`stock`)
) ENGINE=MyISAM AUTO_INCREMENT=339 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `product_branches`
--

INSERT INTO `product_branches` (`id`, `product_id`, `branch_id`, `stock`, `min_stock`, `track_stock`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(2, 1, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(3, 2, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(4, 2, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(5, 3, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(6, 3, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(7, 4, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(8, 4, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(9, 5, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(10, 5, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(11, 6, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(12, 6, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(13, 7, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(14, 7, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(15, 8, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(16, 8, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(17, 9, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(18, 9, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(19, 10, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(20, 10, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(21, 11, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(22, 11, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(23, 12, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(24, 12, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(25, 13, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(26, 13, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(27, 14, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(28, 14, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(29, 15, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(30, 15, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(31, 16, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(32, 16, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(33, 17, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(34, 17, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(35, 18, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(36, 18, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(37, 19, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(38, 19, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(39, 20, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(40, 20, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(41, 21, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(42, 21, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(43, 22, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(44, 22, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(45, 23, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(46, 23, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(47, 24, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(48, 24, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(49, 25, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(50, 25, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(51, 26, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(52, 26, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(53, 27, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(54, 27, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(55, 28, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(56, 28, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(57, 29, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(58, 29, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(59, 30, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(60, 30, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(61, 31, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(62, 31, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(63, 32, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(64, 32, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(65, 33, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(66, 33, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(67, 34, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(68, 34, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(69, 35, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(70, 35, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(71, 36, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(72, 36, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(73, 37, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(74, 37, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(75, 38, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(76, 38, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(77, 39, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(78, 39, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(79, 40, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(80, 40, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(81, 41, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(82, 41, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(83, 42, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(84, 42, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(85, 43, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(86, 43, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(87, 44, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(88, 44, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(89, 45, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(90, 45, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(91, 46, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(92, 46, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(93, 47, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(94, 47, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(95, 48, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(96, 48, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(97, 49, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(98, 49, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(99, 50, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(100, 50, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(101, 51, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(102, 51, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(103, 52, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(104, 52, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(105, 53, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(106, 53, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(107, 54, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(108, 54, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(109, 55, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(110, 55, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(111, 56, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(112, 56, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(113, 57, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(114, 57, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(115, 58, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(116, 58, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(117, 59, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(118, 59, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(119, 60, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(120, 60, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(121, 61, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(122, 61, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(123, 62, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(124, 62, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(125, 63, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(126, 63, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(127, 64, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(128, 64, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(129, 65, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(130, 65, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(131, 66, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(132, 66, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(133, 67, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(134, 67, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(135, 68, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(136, 68, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(137, 69, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(138, 69, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(139, 70, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(140, 70, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(141, 71, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(142, 71, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(143, 72, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(144, 72, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(145, 73, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(146, 73, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(147, 74, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(148, 74, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(149, 75, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(150, 75, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(151, 76, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(152, 76, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(153, 77, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(154, 77, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(155, 78, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(156, 78, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(157, 79, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(158, 79, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(159, 80, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(160, 80, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(161, 81, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(162, 81, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(163, 82, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(164, 82, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(165, 83, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(166, 83, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(167, 84, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(168, 84, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(169, 85, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(170, 85, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(171, 86, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(172, 86, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(173, 87, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(174, 87, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(175, 88, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(176, 88, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(177, 89, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(178, 89, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(179, 90, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(180, 90, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(181, 91, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(182, 91, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(183, 92, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(184, 92, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(185, 93, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(186, 93, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(187, 94, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(188, 94, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(189, 95, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(190, 95, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(191, 96, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(192, 96, 2, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(193, 97, 1, 0, 10, 1, '2026-05-15 12:17:17', '2026-05-15 12:17:17'),
(194, 97, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(195, 98, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(196, 98, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(197, 99, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(198, 99, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(199, 100, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(200, 100, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(201, 101, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(202, 101, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(203, 102, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(204, 102, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(205, 103, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(206, 103, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(207, 104, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(208, 104, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(209, 105, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(210, 105, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(211, 106, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(212, 106, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(213, 107, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(214, 107, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(215, 108, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(216, 108, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(217, 109, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(218, 109, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(219, 110, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(220, 110, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(221, 111, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(222, 111, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(223, 112, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(224, 112, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(225, 113, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(226, 113, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(227, 114, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(228, 114, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(229, 115, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(230, 115, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(231, 116, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(232, 116, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(233, 117, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(234, 117, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(235, 118, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(236, 118, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(237, 119, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(238, 119, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(239, 120, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(240, 120, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(241, 121, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(242, 121, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(243, 122, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(244, 122, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(245, 123, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(246, 123, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(247, 124, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(248, 124, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(249, 125, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(250, 125, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(251, 126, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(252, 126, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(253, 127, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(254, 127, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(255, 128, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(256, 128, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(257, 129, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(258, 129, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(259, 130, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(260, 130, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(261, 131, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(262, 131, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(263, 132, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(264, 132, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(265, 133, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(266, 133, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(267, 134, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(268, 134, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(269, 135, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(270, 135, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(271, 136, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(272, 136, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(273, 137, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(274, 137, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(275, 138, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(276, 138, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(277, 139, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(278, 139, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(279, 140, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(280, 140, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(281, 141, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(282, 141, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(283, 142, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(284, 142, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(285, 143, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(286, 143, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(287, 144, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(288, 144, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(289, 145, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(290, 145, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(291, 146, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(292, 146, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(293, 147, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(294, 147, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(295, 148, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(296, 148, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(297, 149, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(298, 149, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(299, 150, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(300, 150, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(301, 151, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(302, 151, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(303, 152, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(304, 152, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(305, 153, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(306, 153, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(307, 154, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(308, 154, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(309, 155, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(310, 155, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(311, 156, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(312, 156, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(313, 157, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(314, 157, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(315, 158, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(316, 158, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(317, 159, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(318, 159, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(319, 160, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(320, 160, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(321, 161, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(322, 161, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(323, 162, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(324, 162, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(325, 163, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(326, 163, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(327, 164, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(328, 164, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(329, 165, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(330, 165, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(331, 166, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(332, 166, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(333, 167, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(334, 167, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(335, 168, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(336, 168, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(337, 169, 1, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18'),
(338, 169, 2, 0, 10, 1, '2026-05-15 12:17:18', '2026-05-15 12:17:18');

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

--
-- Struktur dari tabel `product_bundles`
--

CREATE TABLE IF NOT EXISTS `product_bundles` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `branch_id` bigint UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `bundle_price` decimal(15,2) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `product_bundles_branch_id_foreign` (`branch_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Struktur dari tabel `product_bundle_items`
--

CREATE TABLE IF NOT EXISTS `product_bundle_items` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `product_bundle_id` bigint UNSIGNED NOT NULL,
  `product_id` bigint UNSIGNED NOT NULL,
  `quantity` int NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `product_bundle_items_product_bundle_id_foreign` (`product_bundle_id`),
  KEY `product_bundle_items_product_id_foreign` (`product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Struktur dari tabel `sessions`
--

CREATE TABLE IF NOT EXISTS `sessions` (
  `id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Struktur dari tabel `transactions`
--

CREATE TABLE IF NOT EXISTS `transactions` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `branch_id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `invoice_number` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` enum('pos') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pos',
  `subtotal` decimal(15,2) NOT NULL DEFAULT '0.00',
  `discount` decimal(15,2) NOT NULL DEFAULT '0.00',
  `discount_type` enum('percent','nominal') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'nominal',
  `tax` decimal(15,2) NOT NULL DEFAULT '0.00',
  `tax_rate` decimal(5,2) NOT NULL DEFAULT '0.00',
  `total` decimal(15,2) NOT NULL DEFAULT '0.00',
  `paid` decimal(15,2) NOT NULL DEFAULT '0.00',
  `change` decimal(15,2) NOT NULL DEFAULT '0.00',
  `payment_method` enum('cash','transfer','qris') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'cash',
  `status` enum('pending','completed','cancelled','refunded') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'completed',
  `notes` text COLLATE utf8mb4_unicode_ci,
  `customer_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `transactions_invoice_number_unique` (`invoice_number`),
  KEY `transactions_user_id_foreign` (`user_id`),
  KEY `transactions_branch_id_created_at_index` (`branch_id`,`created_at`),
  KEY `transactions_invoice_number_index` (`invoice_number`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Struktur dari tabel `transaction_details`
--

CREATE TABLE IF NOT EXISTS `transaction_details` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `transaction_id` bigint UNSIGNED NOT NULL,
  `product_id` bigint UNSIGNED DEFAULT NULL,
  `product_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_sku` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quantity` int NOT NULL DEFAULT '1',
  `price` decimal(15,2) NOT NULL DEFAULT '0.00',
  `cost` decimal(15,2) NOT NULL DEFAULT '0.00',
  `subtotal` decimal(15,2) NOT NULL DEFAULT '0.00',
  `discount` decimal(15,2) NOT NULL DEFAULT '0.00',
  `total` decimal(15,2) NOT NULL DEFAULT '0.00',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `transaction_details_transaction_id_foreign` (`transaction_id`),
  KEY `transaction_details_product_id_foreign` (`product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
COMMIT;

