-- Reorders expense categories so Groceries appears first (in the Add
-- Expense grid, Budgets, Manage, and anywhere else categories are listed
-- in their configured order) and becomes the new default-selected category
-- on the Add Expense form — the default is simply "whichever category has
-- the lowest sort_order" (index.php), so swapping these two values is all
-- that's needed; no PHP code change required.
--
-- Run once via phpMyAdmin. Safe to run even if it's already been applied —
-- running it a second time just swaps the two values back, so only run it
-- once.

UPDATE categories SET sort_order = 1 WHERE type = 'expense' AND name = 'Groceries';
UPDATE categories SET sort_order = 2 WHERE type = 'expense' AND name = 'Food';
