-- Phase 12: open lab bookings. Import after diabeasy_schema.sql.
-- Everything else stays coming_soon deliberately.

UPDATE service_categories SET status = 'active'      WHERE code = 'lab_test';
UPDATE service_categories SET status = 'coming_soon' WHERE code IN ('food','pharmacy','consult','vas');

-- Example partner and catalogue. Replace with your real lab before going live;
-- the prices below are placeholders, not market rates.
--
-- INSERT INTO partners (name, partner_type, contact_person, mobile, cities, commission_pct, settlement_days)
-- VALUES ('Example Diagnostics', 'lab', 'Contact Name', '919820000000',
--         JSON_ARRAY('Mumbai','Thane'), 20.00, 30);
--
-- INSERT INTO services (category_id, partner_id, name, slug, description,
--                       mrp, sale_price, commission_pct, linked_gap_rule, home_collection, cities)
-- SELECT c.id, p.id, 'HbA1c (home collection)', 'hba1c-home',
--        'Shows your average blood sugar over the last 3 months. No fasting needed.',
--        650, 499, 20.00, 'HBA1C_Q3', 1, NULL
--   FROM service_categories c, partners p
--  WHERE c.code = 'lab_test' AND p.name = 'Example Diagnostics';