-- Player titles.
--
-- ROM's pcdata->title, shown after the name on the who list: "Golkie the newbie". A player sets it
-- themselves with `title`, and it is the one piece of a character sheet that is purely theirs.
--
-- DEFAULTS TO ROM'S OWN NUDGE, verbatim from comm.c:2889 -- "the newbie. <Please set title soon type
-- 'help title'>". It reads oddly for a default and that is exactly why it works: every player who has
-- not set one is visibly asking to. A blank default would look finished and stay blank forever.
--
-- NOT NULL with a default rather than nullable, because every consumer would otherwise need to
-- decide what a null title renders as, and they would not all decide the same thing.

ALTER TABLE characters
    ADD COLUMN title TEXT NOT NULL
    DEFAULT 'the newbie. <Please set title soon type ''help title''>';
