-- Upgrade: schema_version 13 to 14 (PostgreSQL)
--

ALTER TABLE projects ADD use_signed_off_by CHAR(1);
UPDATE projects SET use_signed_off_by = 'N';
ALTER TABLE projects ALTER COLUMN use_signed_off_by SET DEFAULT 'N';
ALTER TABLE projects ALTER COLUMN use_signed_off_by SET NOT NULL;

UPDATE schema_version SET version_nbr = 14;