-- Drop directives.goal and directive_goal_history.
--
-- The unified contract surface makes contracts the source of truth for
-- spec text. A directive is now a folder of contracts; the orchestrator
-- daemon reads the currently-active contract's body when it spawns,
-- replanned, or runs completion. directives.goal was the pre-contract
-- spec field — superseded.
--
-- directive_goal_history tracked edits to the goal field. Contract
-- bodies have their own version field on the contracts table; the
-- amend/replan flow now queries that instead.

DROP TABLE IF EXISTS directive_goal_history;

ALTER TABLE directives DROP COLUMN IF EXISTS goal;
ALTER TABLE directives DROP COLUMN IF EXISTS goal_updated_at;