-- Test stock data for m001 branch
-- Add initial stock quantities and reorder levels to existing items

UPDATE m001_items SET 
    current_stock = 100.00,
    reorder_level = 10.00,
    last_updated = NOW()
WHERE sell_type = 'unit';

UPDATE m001_items SET 
    current_stock = 50.00,
    reorder_level = 5.00,
    last_updated = NOW()
WHERE sell_type = 'fraction';

-- Set some items to low stock for testing
UPDATE m001_items SET 
    current_stock = 3.00
WHERE items_name LIKE '%Ice Cream%' OR items_name LIKE '%Dessert%'
LIMIT 2;

-- Set one item to out of stock for testing
UPDATE m001_items SET 
    current_stock = 0.00
WHERE items_name LIKE '%Coca Cola%'
LIMIT 1; 