BEGIN;

ALTER TABLE articles ADD COLUMN description VARCHAR(255);
UPDATE articles SET description = CONCAT(title, ' - by ', author, ' - on ', TO_CHAR(date, 'YYYY-MM-DD'));
ALTER TABLE articles ALTER COLUMN description SET NOT NULL;

COMMIT;
