-- ============================================================
--  Break the Locks — Part 10 v2 Schema Patch
--  Run once in phpMyAdmin on the admin_btlc database.
--
--  Adds trigger-based rule fields:
--    trigger_text   — the user's actual trigger feeling/situation
--    old_habit_text — the habit the trigger sets off
--    alternatives   — JSON array of AI-proposed alternative actions
--                     the user picks from when adopting a trigger rule
-- ============================================================

ALTER TABLE `user_life_rule_suggestions`
  ADD COLUMN `trigger_text`   VARCHAR(500) NULL AFTER `negative_text`,
  ADD COLUMN `old_habit_text` VARCHAR(500) NULL AFTER `trigger_text`,
  ADD COLUMN `alternatives`   TEXT NULL AFTER `old_habit_text`;