CREATE TABLE IF NOT EXISTS subscription_plans (
  id INT AUTO_INCREMENT PRIMARY KEY,
  plan_key ENUM('standard','standard_plus','premium','premium_plus') NOT NULL UNIQUE,
  name VARCHAR(100) NOT NULL,
  description TEXT NULL,
  price_cents INT NOT NULL,
  currency VARCHAR(3) NOT NULL DEFAULT 'usd',
  stripe_product_id VARCHAR(255) NULL,
  stripe_price_id VARCHAR(255) NULL,
  profile_limit INT NOT NULL DEFAULT 4,
  messages_per_week INT NOT NULL DEFAULT 3,
  redos_per_message INT NOT NULL DEFAULT 2,
  dates_per_profile INT NOT NULL DEFAULT 12,
  gift_ideas BOOLEAN NOT NULL DEFAULT FALSE,
  is_active BOOLEAN NOT NULL DEFAULT TRUE,
  created_at DATETIME NOT NULL DEFAULT NOW(),
  updated_at DATETIME NOT NULL DEFAULT NOW() ON UPDATE NOW()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
