﻿USE deliverus;
INSERT INTO category (name_ar, name_en, module_id, priority, created_at)
SELECT 'تجربة', 'QA Category', 1, 1, NOW()
FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM category WHERE name_en='QA Category');
SET @cat := (SELECT id FROM category WHERE name_en='QA Category' LIMIT 1);
INSERT INTO product (name_ar, name_en, description_ar, description_en, thumbnail, store_id, category_id, module_id, price, total_price, stock, status, max_purchase, created_at)
SELECT 'منتج تجريبي', 'QA Product', 'وصف', 'desc', 'uploads/default.png', 1, @cat, 1, 25, 25, 100, 'ACTIVE', 10, NOW()
FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM product WHERE name_en='QA Product');
UPDATE store SET closed=0, temporarily_closed=0, status='ACTIVE', zone_id=1 WHERE id=1;
INSERT INTO store_schedule (store_id, opening_time, closing_time, day)
SELECT 1, '00:00:00', '23:59:59', d.day FROM (
  SELECT 'SUNDAY' AS day UNION SELECT 'MONDAY' UNION SELECT 'TUESDAY' UNION SELECT 'WEDNESDAY'
  UNION SELECT 'THURSDAY' UNION SELECT 'FRIDAY' UNION SELECT 'SATURDAY'
) d
WHERE NOT EXISTS (SELECT 1 FROM store_schedule ss WHERE ss.store_id=1 AND ss.day=d.day);
SELECT 'category' t, id c FROM category WHERE name_en='QA Category'
UNION ALL SELECT 'product', id FROM product WHERE name_en='QA Product'
UNION ALL SELECT 'schedules', COUNT(*) FROM store_schedule WHERE store_id=1;
