-- SheListens — migration 002: platform settings (payment gateway keys, etc.)
-- Run via phpMyAdmin or: mysql -u USER -p DBNAME < migrations/002_platform_settings.sql
-- Safe to run on an existing database — only adds one new table.

CREATE TABLE IF NOT EXISTS platform_settings (
  setting_key   VARCHAR(60) PRIMARY KEY,
  setting_value TEXT NULL,
  updated_at    DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;