ALTER TABLE `2025_2026_journal_transactions` ADD `deleted_at` TIMESTAMP NULL DEFAULT NULL AFTER `updated_at`;


//to reorder the heads table;
SET @rownum := 0;

UPDATE heads
SET sort_order = (@rownum := @rownum + 1)
ORDER BY
  CASE
    WHEN LOWER(name) = 'yearly subscription' THEN 1
    WHEN LOWER(name) = 'subscription' THEN 2
    WHEN LOWER(name) = 'contingency fund' THEN 3
    ELSE 4
  END,
  name ASC;