/* ADD OPTIONAL SUBMITTER NAME COLUMN IN GAMES TABLE */

BEGIN;

ALTER TABLE scores.games ALTER COLUMN submitter_id DROP NOT NULL;

ALTER TABLE scores.games
ADD COLUMN submitter_name TEXT;


UPDATE metadata
SET value = '3'
WHERE property = 'latest_migration';

COMMIT;