-- =============================================
-- MIGRATION: New Menu Koito Resto + Inventory Split
-- =============================================
-- 1. Tambah kolom item_type pada ingredients
--    ('bahan' = stok bahan baku, 'peralatan' = stok peralatan masak)
-- 2. Ganti seluruh menu lama dengan 97 menu baru (16 kategori)
-- 3. Seed awal peralatan masak
--
-- CATATAN: jalankan SEKALI saja. Menu lama di-soft delete (deleted_at),
-- riwayat order lama tetap aman.
-- =============================================

USE joglo_koi_rms;

-- =============================================
-- 1. KOLOM item_type PADA ingredients
-- =============================================
ALTER TABLE ingredients ADD COLUMN item_type ENUM('bahan','peralatan') NOT NULL DEFAULT 'bahan' AFTER code;

-- =============================================
-- 2. SOFT DELETE MENU & KATEGORI LAMA
-- =============================================
UPDATE menu_categories SET deleted_at = NOW() WHERE deleted_at IS NULL;
UPDATE menus SET deleted_at = NOW() WHERE deleted_at IS NULL;

-- Bebaskan SKU menu lama yang di-soft-delete (unique index), agar SKU baru tidak bentrok
UPDATE menus SET sku = CONCAT(sku, '-OLD') WHERE deleted_at IS NOT NULL AND sku IS NOT NULL;

-- =============================================
-- 2b. KATEGORI & MENU BARU (97 menu, 16 kategori)
-- =============================================
INSERT INTO menu_categories (name, description, icon, sort_order) VALUES
('New Menu Koito Resto', NULL, 'utensils', 1),
('Soup', NULL, 'utensils', 2),
('Nasi Goreng', NULL, 'utensils', 3),
('Vegetable', NULL, 'utensils', 4),
('Signature Dishes', NULL, 'utensils', 5),
('Ayam dan Bebek', NULL, 'utensils', 6),
('Ikan dan Seafood', NULL, 'utensils', 7),
('Appetizer/Cemilan', NULL, 'utensils', 8),
('Croissant', NULL, 'utensils', 9),
('Spaghetti', NULL, 'utensils', 10),
('Coffe (Hot/Ice)', NULL, 'utensils', 11),
('Noncoffe (Hot/Ice)', NULL, 'utensils', 12),
('Milkshake', NULL, 'utensils', 13),
('Drink Pitcher', NULL, 'utensils', 14),
('Paket Family', NULL, 'utensils', 15),
('Festive Weekend', NULL, 'utensils', 16);

-- MENUS
INSERT INTO menus (category_id, sku, name, description, price, cost_price, is_available) VALUES
((SELECT id FROM menu_categories WHERE name = 'New Menu Koito Resto' AND deleted_at IS NULL), 'NM-001', 'Tahu Cabe Garam', NULL, 19000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'New Menu Koito Resto' AND deleted_at IS NULL), 'NM-002', 'Chiken Steak (New)', NULL, 35000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'New Menu Koito Resto' AND deleted_at IS NULL), 'NM-003', 'Mix Platter (Kentang Goreng, Sosis, Nugget)', NULL, 25000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Soup' AND deleted_at IS NULL), 'SP-001', 'Soup Iga Reguler', NULL, 40000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Soup' AND deleted_at IS NULL), 'SP-002', 'Iga Premium', NULL, 55000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Soup' AND deleted_at IS NULL), 'SP-003', 'Ikan Koito', NULL, 30000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Soup' AND deleted_at IS NULL), 'SP-004', 'Manten', NULL, 20000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Nasi Goreng' AND deleted_at IS NULL), 'NG-001', 'Nasi Goreng Ayam', NULL, 30000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Nasi Goreng' AND deleted_at IS NULL), 'NG-002', 'Nasi Goreng Teri Peti', NULL, 30000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Nasi Goreng' AND deleted_at IS NULL), 'NG-003', 'Nasi Goreng Kouitoresto Istimewa', NULL, 40000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Nasi Goreng' AND deleted_at IS NULL), 'NG-004', 'Nasi Goreng Chef Recommendation', NULL, 35000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Nasi Goreng' AND deleted_at IS NULL), 'NG-005', 'Nasi Goreng Paru', NULL, 30000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Nasi Goreng' AND deleted_at IS NULL), 'NG-006', 'Nasi Goreng Seafood', NULL, 45000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Nasi Goreng' AND deleted_at IS NULL), 'NG-007', 'Nasi Goreng Lada Hitam', NULL, 39000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Vegetable' AND deleted_at IS NULL), 'VG-001', 'Urap Mentah Pedas Manis', NULL, 16000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Vegetable' AND deleted_at IS NULL), 'VG-002', 'CA Kangkung', NULL, 18000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Vegetable' AND deleted_at IS NULL), 'VG-003', 'CA Brokoli Bawang Putih', NULL, 39000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Vegetable' AND deleted_at IS NULL), 'VG-004', 'Capcay', NULL, 22000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Vegetable' AND deleted_at IS NULL), 'VG-005', 'Jamur Bledos', NULL, 22000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Signature Dishes' AND deleted_at IS NULL), 'SD-001', 'Cumi Pedas Masak Kelapa', NULL, 45000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Signature Dishes' AND deleted_at IS NULL), 'SD-002', 'Udang Masak Khas Koito', NULL, 45000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Signature Dishes' AND deleted_at IS NULL), 'SD-003', 'Paru Masak Kandis', NULL, 28000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Signature Dishes' AND deleted_at IS NULL), 'SD-004', 'Paru Goreng Daun Jeruk', NULL, 27000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Signature Dishes' AND deleted_at IS NULL), 'SD-005', 'Bebek Bamby', NULL, 36000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Signature Dishes' AND deleted_at IS NULL), 'SD-006', 'Bebek Rica Pandan', NULL, 36000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Signature Dishes' AND deleted_at IS NULL), 'SD-007', 'Bebek Pengantin', NULL, 37000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Signature Dishes' AND deleted_at IS NULL), 'SD-008', 'Bebek BBQ', NULL, 38000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Signature Dishes' AND deleted_at IS NULL), 'SD-009', 'Bebek Sinulingga', NULL, 47000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Signature Dishes' AND deleted_at IS NULL), 'SD-010', 'Cumi Sinulingga', NULL, 47000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Signature Dishes' AND deleted_at IS NULL), 'SD-011', 'Udang Bawang Cais', NULL, 49000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Ayam dan Bebek' AND deleted_at IS NULL), 'AB-001', 'Ayam Kampung Goreng', NULL, 30000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Ayam dan Bebek' AND deleted_at IS NULL), 'AB-002', 'Ayam Kampung Bakar', NULL, 30000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Ayam dan Bebek' AND deleted_at IS NULL), 'AB-003', 'Bebek Goreng', NULL, 38000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Ayam dan Bebek' AND deleted_at IS NULL), 'AB-004', 'Bebek Bakar', NULL, 39000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Ayam dan Bebek' AND deleted_at IS NULL), 'AB-005', 'Chiken Steak', NULL, 45000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Ayam dan Bebek' AND deleted_at IS NULL), 'AB-006', 'Chiken Steak', NULL, 35000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Ikan dan Seafood' AND deleted_at IS NULL), 'IS-001', 'Gurame Goreng', NULL, 37000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Ikan dan Seafood' AND deleted_at IS NULL), 'IS-002', 'Gurame Terbang', NULL, 42000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Ikan dan Seafood' AND deleted_at IS NULL), 'IS-003', 'Gurame Asam Manis', NULL, 47000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Ikan dan Seafood' AND deleted_at IS NULL), 'IS-004', 'Gurame Bakar (Manis/Pedas/Rujak)', NULL, 40000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Ikan dan Seafood' AND deleted_at IS NULL), 'IS-005', 'Nila Goreng', NULL, 35000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Ikan dan Seafood' AND deleted_at IS NULL), 'IS-006', 'Nila Bakar (Manis/Pedas/Rujak)', NULL, 38000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Ikan dan Seafood' AND deleted_at IS NULL), 'IS-007', 'Cumi Goreng', NULL, 37000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Ikan dan Seafood' AND deleted_at IS NULL), 'IS-008', 'Iga Sapi Bakar', NULL, 47000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Appetizer/Cemilan' AND deleted_at IS NULL), 'AC-001', 'Kentang Goreng', NULL, 18000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Appetizer/Cemilan' AND deleted_at IS NULL), 'AC-002', 'Dimsum', NULL, 28000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Appetizer/Cemilan' AND deleted_at IS NULL), 'AC-003', 'Pisang Goreng Khas Koito', NULL, 18000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Appetizer/Cemilan' AND deleted_at IS NULL), 'AC-004', 'Pisang Goreng Keju', NULL, 22000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Appetizer/Cemilan' AND deleted_at IS NULL), 'AC-005', 'Pisang Goreng Coklat', NULL, 22000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Appetizer/Cemilan' AND deleted_at IS NULL), 'AC-006', 'Lumpia Goreng', NULL, 20000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Appetizer/Cemilan' AND deleted_at IS NULL), 'AC-007', 'Jamur Crisppy', NULL, 17000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Appetizer/Cemilan' AND deleted_at IS NULL), 'AC-008', 'Mendoan', NULL, 13000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Appetizer/Cemilan' AND deleted_at IS NULL), 'AC-009', 'Mixed Fruit Salad', NULL, 34000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Croissant' AND deleted_at IS NULL), 'CR-001', 'Croissant Keju', NULL, 25000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Croissant' AND deleted_at IS NULL), 'CR-002', 'Croissant Coklat', NULL, 25000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Croissant' AND deleted_at IS NULL), 'CR-003', 'Croissant Red Velvet', NULL, 25000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Croissant' AND deleted_at IS NULL), 'CR-004', 'Croissant Sandwich', NULL, 30000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Spaghetti' AND deleted_at IS NULL), 'PG-001', 'Spaghetti Sauce Daging', NULL, 25000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Spaghetti' AND deleted_at IS NULL), 'PG-002', 'Spaghetti Bawang Cabe', NULL, 25000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Coffe (Hot/Ice)' AND deleted_at IS NULL), 'CF-001', 'Americano', NULL, 19000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Coffe (Hot/Ice)' AND deleted_at IS NULL), 'CF-002', 'Cappucino', NULL, 20000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Coffe (Hot/Ice)' AND deleted_at IS NULL), 'CF-003', 'Coffe Latte', NULL, 21000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Coffe (Hot/Ice)' AND deleted_at IS NULL), 'CF-004', 'Hazelnut Latte', NULL, 21000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Coffe (Hot/Ice)' AND deleted_at IS NULL), 'CF-005', 'Caramel Latte', NULL, 21500, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Coffe (Hot/Ice)' AND deleted_at IS NULL), 'CF-006', 'Vanila Latte', NULL, 25000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Coffe (Hot/Ice)' AND deleted_at IS NULL), 'CF-007', 'Kopi Susu', NULL, 19000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Noncoffe (Hot/Ice)' AND deleted_at IS NULL), 'NC-001', 'Origial Tea', NULL, 9000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Noncoffe (Hot/Ice)' AND deleted_at IS NULL), 'NC-002', 'Lemon Tea', NULL, 15000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Noncoffe (Hot/Ice)' AND deleted_at IS NULL), 'NC-003', 'Lychee Tea', NULL, 15000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Noncoffe (Hot/Ice)' AND deleted_at IS NULL), 'NC-004', 'Orange', NULL, 19000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Noncoffe (Hot/Ice)' AND deleted_at IS NULL), 'NC-005', 'Thai Tea', NULL, 21000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Noncoffe (Hot/Ice)' AND deleted_at IS NULL), 'NC-006', 'Greentea', NULL, 21000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Noncoffe (Hot/Ice)' AND deleted_at IS NULL), 'NC-007', 'Chocolate', NULL, 23000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Noncoffe (Hot/Ice)' AND deleted_at IS NULL), 'NC-008', 'Teh Madu Jahe', NULL, 19000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Noncoffe (Hot/Ice)' AND deleted_at IS NULL), 'NC-009', 'Avocado', NULL, 20000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Noncoffe (Hot/Ice)' AND deleted_at IS NULL), 'NC-010', 'Guava', NULL, 20000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Noncoffe (Hot/Ice)' AND deleted_at IS NULL), 'NC-011', 'Mango', NULL, 20000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Noncoffe (Hot/Ice)' AND deleted_at IS NULL), 'NC-012', 'Melon', NULL, 20000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Noncoffe (Hot/Ice)' AND deleted_at IS NULL), 'NC-013', 'Semangka', NULL, 20000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Noncoffe (Hot/Ice)' AND deleted_at IS NULL), 'NC-014', 'Strawberry', NULL, 20000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Milkshake' AND deleted_at IS NULL), 'MS-001', 'Milkshake Chocolate', NULL, 27000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Milkshake' AND deleted_at IS NULL), 'MS-002', 'Milkshake Strawberry', NULL, 27000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Milkshake' AND deleted_at IS NULL), 'MS-003', 'Milkshake Vanila', NULL, 25000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Milkshake' AND deleted_at IS NULL), 'MS-004', 'Milkshake Cookies & Cream', NULL, 21000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Drink Pitcher' AND deleted_at IS NULL), 'DP-001', 'Ice Tea Pitcher', NULL, 26000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Drink Pitcher' AND deleted_at IS NULL), 'DP-002', 'Ice Lemon Tea Pitcher', NULL, 23000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Drink Pitcher' AND deleted_at IS NULL), 'DP-003', 'Ice Lychee Tea Pitcher', NULL, 25000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Paket Family' AND deleted_at IS NULL), 'PF-001', 'Paket Joglo (3 Orang)', NULL, 187000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Paket Family' AND deleted_at IS NULL), 'PF-002', 'Paket Limasan (3 Orang)', NULL, 187000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Paket Family' AND deleted_at IS NULL), 'PF-003', 'Paket Lesehan (3 Orang)', NULL, 177000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Paket Family' AND deleted_at IS NULL), 'PF-004', 'Paket Galery Koito (4 Orang)', NULL, 207000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Paket Family' AND deleted_at IS NULL), 'PF-005', 'Chef Recommendation (10 Orang)', NULL, 600000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Paket Family' AND deleted_at IS NULL), 'PF-006', 'Menu Extravaganza (10 Orang)', NULL, 999000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Paket Family' AND deleted_at IS NULL), 'PF-007', 'Chef Recommendation Spesial (10 Orang)', NULL, 1550000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Festive Weekend' AND deleted_at IS NULL), 'FW-001', '1 Kg Gurame Bakar + Pitcher Ice Tea', NULL, 145000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Festive Weekend' AND deleted_at IS NULL), 'FW-002', '1 Kg Nila Bakar + Pitcher Ice Lemon Tea', NULL, 145000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Festive Weekend' AND deleted_at IS NULL), 'FW-003', '1 Kg Iga Bakar + Pitcher Ice Lychee Tea', NULL, 180000, 0, 1);


-- =============================================
-- 3. SEED PERALATAN MASAK (stok peralatan masak)
-- =============================================
INSERT INTO ingredients (code, name, item_type, category_id, unit_id, purchase_price, minimum_stock, maximum_stock, current_stock) VALUES
('EQP-001', 'Wajan', 'peralatan', NULL, (SELECT id FROM units WHERE abbreviation = 'Pcs' LIMIT 1), 150000, 1, 10, 5),
('EQP-002', 'Panci Besar', 'peralatan', NULL, (SELECT id FROM units WHERE abbreviation = 'Pcs' LIMIT 1), 250000, 1, 10, 5),
('EQP-003', 'Panci Kecil', 'peralatan', NULL, (SELECT id FROM units WHERE abbreviation = 'Pcs' LIMIT 1), 120000, 1, 10, 5),
('EQP-004', 'Wajan Deep Fryer', 'peralatan', NULL, (SELECT id FROM units WHERE abbreviation = 'Pcs' LIMIT 1), 400000, 1, 10, 5),
('EQP-005', 'Pisau Dapur', 'peralatan', NULL, (SELECT id FROM units WHERE abbreviation = 'Pcs' LIMIT 1), 75000, 1, 10, 5),
('EQP-006', 'Talenan', 'peralatan', NULL, (SELECT id FROM units WHERE abbreviation = 'Pcs' LIMIT 1), 45000, 1, 10, 5),
('EQP-007', 'Spatula', 'peralatan', NULL, (SELECT id FROM units WHERE abbreviation = 'Pcs' LIMIT 1), 20000, 1, 10, 5),
('EQP-008', 'Sendok Sayur', 'peralatan', NULL, (SELECT id FROM units WHERE abbreviation = 'Pcs' LIMIT 1), 18000, 1, 10, 5),
('EQP-009', 'Centong Nasi', 'peralatan', NULL, (SELECT id FROM units WHERE abbreviation = 'Pcs' LIMIT 1), 20000, 1, 10, 5),
('EQP-010', 'Kompor', 'peralatan', NULL, (SELECT id FROM units WHERE abbreviation = 'Pcs' LIMIT 1), 350000, 1, 10, 5),
('EQP-011', 'Tabung Gas 3kg', 'peralatan', NULL, (SELECT id FROM units WHERE abbreviation = 'Pcs' LIMIT 1), 220000, 1, 10, 5),
('EQP-012', 'Rice Cooker', 'peralatan', NULL, (SELECT id FROM units WHERE abbreviation = 'Pcs' LIMIT 1), 450000, 1, 10, 5),
('EQP-013', 'Blender', 'peralatan', NULL, (SELECT id FROM units WHERE abbreviation = 'Pcs' LIMIT 1), 380000, 1, 10, 5),
('EQP-014', 'Timbangan Dapur', 'peralatan', NULL, (SELECT id FROM units WHERE abbreviation = 'Pcs' LIMIT 1), 120000, 1, 10, 5),
('EQP-015', 'Loyang', 'peralatan', NULL, (SELECT id FROM units WHERE abbreviation = 'Pcs' LIMIT 1), 60000, 1, 10, 5),
('EQP-016', 'Teko Listrik', 'peralatan', NULL, (SELECT id FROM units WHERE abbreviation = 'Pcs' LIMIT 1), 250000, 1, 10, 5),
('EQP-017', 'Freezer', 'peralatan', NULL, (SELECT id FROM units WHERE abbreviation = 'Pcs' LIMIT 1), 3500000, 1, 10, 5),
('EQP-018', 'Etalase Kaca', 'peralatan', NULL, (SELECT id FROM units WHERE abbreviation = 'Pcs' LIMIT 1), 1500000, 1, 10, 5),
('EQP-019', 'Sendok & Garpu', 'peralatan', NULL, (SELECT id FROM units WHERE abbreviation = 'Pcs' LIMIT 1), 15000, 1, 10, 5),
('EQP-020', 'Gelas', 'peralatan', NULL, (SELECT id FROM units WHERE abbreviation = 'Pcs' LIMIT 1), 12000, 1, 10, 5),
('EQP-021', 'Piring', 'peralatan', NULL, (SELECT id FROM units WHERE abbreviation = 'Pcs' LIMIT 1), 18000, 1, 10, 5),
('EQP-022', 'Mangkuk', 'peralatan', NULL, (SELECT id FROM units WHERE abbreviation = 'Pcs' LIMIT 1), 15000, 1, 10, 5);

-- =============================================
-- SELESAI
-- =============================================