ALTER TABLE project
    ADD unit VARCHAR(31) NULL;

UPDATE project
SET unit = 'log2 TPM'
WHERE unit IS NULL;
