-- Update header menu to include Home and Blog
UPDATE `ms_menus` SET `items` = '[
  {"label_ar":"الرئيسية","label_en":"Home","url":"/","target":"_self","type":"link"},
  {"label_ar":"المنتجات","label_en":"Products","url":"/products","target":"_self","type":"link"},
  {"label_ar":"الأسعار","label_en":"Pricing","url":"/#pricing","target":"_self","type":"link"},
  {"label_ar":"المدونة","label_en":"Blog","url":"/blog","target":"_self","type":"link"},
  {"label_ar":"عنا","label_en":"About","url":"/about","target":"_self","type":"link"},
  {"label_ar":"تواصل","label_en":"Contact","url":"/contact","target":"_self","type":"link"}
]' WHERE `location` = 'header';

-- If no row exists, insert it
INSERT INTO `ms_menus` (`location`, `items`)
SELECT 'header', '[
  {"label_ar":"الرئيسية","label_en":"Home","url":"/","target":"_self","type":"link"},
  {"label_ar":"المنتجات","label_en":"Products","url":"/products","target":"_self","type":"link"},
  {"label_ar":"الأسعار","label_en":"Pricing","url":"/#pricing","target":"_self","type":"link"},
  {"label_ar":"المدونة","label_en":"Blog","url":"/blog","target":"_self","type":"link"},
  {"label_ar":"عنا","label_en":"About","url":"/about","target":"_self","type":"link"},
  {"label_ar":"تواصل","label_en":"Contact","url":"/contact","target":"_self","type":"link"}
]'
WHERE NOT EXISTS (SELECT 1 FROM `ms_menus` WHERE `location` = 'header');
