-- 20260327_006_demo_duration_week.sql

INSERT INTO pricing_rules (plan_type, duration_key, duration_days, base_price, per_pc_price, per_web_price, currency, is_active)
VALUES ('A-COMPLEX', '7_days', 7, '0.00', '0.00', '0.00', 'TRY', 1)
ON DUPLICATE KEY UPDATE
    duration_days = VALUES(duration_days),
    base_price = VALUES(base_price),
    per_pc_price = VALUES(per_pc_price),
    per_web_price = VALUES(per_web_price),
    currency = VALUES(currency),
    is_active = VALUES(is_active);

DELETE FROM pricing_rules
WHERE duration_key IN ('2_days', 'demo_2_days', 'demo_7_days', '1_week');

UPDATE payment_requests
SET duration_key = '7_days'
WHERE duration_key IN ('2_days', 'demo_2_days', 'demo_7_days', '1_week');
