-- ============================================================================
--  BullCombo General Dealers — Rebrand + Menu Seed Script
--  Run this once against your live database (phpMyAdmin > SQL tab, or via
--  the mysql CLI) after uploading the updated site files.
-- ============================================================================

-- 1) Update site branding (safe to re-run; only touches row id=1)
INSERT IGNORE INTO site_settings (id, site_name, currency, currency_symbol)
VALUES (1, 'BullCombo General Dealers', 'ZMW', 'K');

UPDATE site_settings
SET site_name = 'BullCombo General Dealers',
    logo      = 'logos/bullcombo_logo.jpg'
WHERE id = 1;

-- 2) Categories used by the menu below
INSERT INTO categories (name, slug, sort_order, status)
VALUES ('Plain Meals', 'plain-meals', 1, 'active')
ON DUPLICATE KEY UPDATE name = VALUES(name);

INSERT INTO categories (name, slug, sort_order, status)
VALUES ('Food Combos', 'food-combos', 2, 'active')
ON DUPLICATE KEY UPDATE name = VALUES(name);

-- 3) Plain Meals
-- Image field is left NULL — add photos later via Admin > Products (or run
-- an UPDATE with the filename once you've uploaded each picture).
INSERT INTO products (name, short_description, price, category, slug, type, status) VALUES
('Shawarma', NULL, 45.00, 'Plain Meals', 'shawarma', 'physical_product', 'active'),
('Shawarma Plata', NULL, 70.00, 'Plain Meals', 'shawarma-plata', 'physical_product', 'active'),
('Plain Fries', NULL, 30.00, 'Plain Meals', 'plain-fries', 'physical_product', 'active'),
('Plain Fries Special', NULL, 50.00, 'Plain Meals', 'plain-fries-special', 'physical_product', 'active'),
('Plain Sausage (Special)', NULL, 20.00, 'Plain Meals', 'plain-sausage-special', 'physical_product', 'active'),
('Plain Sausage (Ordinary)', NULL, 15.00, 'Plain Meals', 'plain-sausage-ordinary', 'physical_product', 'active'),
('Coleslaw', NULL, 15.00, 'Plain Meals', 'coleslaw', 'physical_product', 'active'),
('Vegetable Shawarma', NULL, 30.00, 'Plain Meals', 'vegetable-shawarma', 'physical_product', 'active'),
('Fritters', NULL, 6.99, 'Plain Meals', 'fritters', 'physical_product', 'active'),
('Plain Feet (4 Feet, 2 Necks, 2 Gizzards)', NULL, 15.00, 'Plain Meals', 'plain-feet', 'physical_product', 'active'),
('Plain Chicken (1 Piece)', NULL, 30.00, 'Plain Meals', 'plain-chicken-1-piece', 'physical_product', 'active'),
('Samosa', NULL, 15.00, 'Plain Meals', 'samosa', 'physical_product', 'active'),
('Extra Fries', NULL, 20.00, 'Plain Meals', 'extra-fries', 'physical_product', 'active');

-- 4) Food Combos
INSERT INTO products (name, short_description, price, category, slug, type, status) VALUES
('Tonga Combo #1', 'Ordinary Sausage, Fries and Coleslaw', 50.00, 'Food Combos', 'tonga-combo-1', 'physical_product', 'active'),
('Tonga Combo #2', 'Special Sausage, Fries and Coleslaw', 55.00, 'Food Combos', 'tonga-combo-2', 'physical_product', 'active'),
('Tonga Combo #3', '2 Sausage, Fries and Coleslaw', 70.00, 'Food Combos', 'tonga-combo-3', 'physical_product', 'active'),
('Bull Combo #1', '1 Chicken Piece, Fries and Coleslaw', 60.00, 'Food Combos', 'bull-combo-1', 'physical_product', 'active'),
('Bull Combo #2', '2 Chicken Pieces, Fries and Coleslaw', 80.00, 'Food Combos', 'bull-combo-2', 'physical_product', 'active'),
('Bull Combo #3', '3 Chicken Pieces, Fries and Coleslaw', 100.00, 'Food Combos', 'bull-combo-3', 'physical_product', 'active'),
('2x2 Combo', '2 Packs of Fries, 2 Chicken Pieces and Coleslaw', 105.00, 'Food Combos', '2x2-combo', 'physical_product', 'active'),
('Bull Chicky', '5 Chicken Pieces', 110.00, 'Food Combos', 'bull-chicky', 'physical_product', 'active'),
('Feet Combo', '4 Feet, 2 Necks and 2 Gizzards, Fries and Coleslaw', 50.00, 'Food Combos', 'feet-combo', 'physical_product', 'active'),
('Bull Special', '3 Chicken Pieces, Fries, Sausage and Coleslaw', 110.00, 'Food Combos', 'bull-special', 'physical_product', 'active'),
('Bull Special Plus', '2 Fries, 5 Chicken Pieces, 2 Sausages, 2 Fruiticana, 2 Bottles of Water and Coleslaw', 250.00, 'Food Combos', 'bull-special-plus', 'physical_product', 'active');