BEGIN;
ALTER TABLE phone ADD COLUMN timezone_long varchar(40);
UPDATE phone SET timezone_long = 'UTC' WHERE timezone_long IS NULL;
ALTER TABLE phone ALTER COLUMN timezone_long SET DEFAULT 'UTC';
ALTER TABLE phone ALTER COLUMN timezone_long SET NOT NULL;
UPDATE phone SET timezone_long = timezone;
ALTER TABLE phone RENAME timezone TO timezone_shrt;
ALTER TABLE phone RENAME timezone_long TO timezone;
ALTER TABLE phone DROP COLUMN timezone_shrt;
COMMIT;
