-- SheListens — migration 012: session cap is weekly, not daily
-- The booking cap was enforced per calendar day when it was always meant
-- to be per week (3 sessions/week, ISO Mon-Sun) — see lib/booking_rules.php.
-- This renames the existing setting row in place so any value an admin
-- already configured carries over (its meaning changes from "per day" to
-- "per week" as of this migration — worth a quick check in Admin ->
-- Settings after deploying).
-- Run via phpMyAdmin or: mysql -u USER -p DBNAME < backend/migrations/012_weekly_session_cap.sql

UPDATE platform_settings
SET setting_key = 'max_sessions_per_week'
WHERE setting_key = 'max_sessions_per_day';

-- In case that row never existed (fresh install before this migration),
-- make sure the key is present with the documented default.
INSERT INTO platform_settings (setting_key, setting_value)
SELECT 'max_sessions_per_week', '3'
WHERE NOT EXISTS (
    SELECT 1 FROM platform_settings WHERE setting_key = 'max_sessions_per_week'
);