-- Renames the "Change" note category to "Revision".

alter table notes drop constraint if exists notes_category_check;

update notes set category = 'Revision' where category = 'Change';

alter table notes alter column category set default 'Revision';

alter table notes add constraint notes_category_check
  check (category in ('Revision', 'Bug', 'Question', 'Live Changelog'));
