BEGIN;
ALTER TABLE phonetype ADD COLUMN hasvideo VARCHAR(3);
UPDATE phonetype SET hasvideo = 'no' WHERE hasvideo IS NULL;
ALTER TABLE phonetype ALTER COLUMN hasvideo SET DEFAULT 'no';
ALTER TABLE phonetype ALTER COLUMN hasvideo SET NOT NULL;
ALTER TABLE phonetype ADD CONSTRAINT phonetype_hasvideo_check CHECK (hasvideo IN ('yes', 'no'));

update phonetype set hasvideo = 'yes' where id = '5009';
update phonetype set hasvideo = 'yes' where id = '63';
update phonetype set hasvideo = 'yes' where id = '69';
update phonetype set hasvideo = 'yes' where id = '200';
update phonetype set hasvideo = 'yes' where id = '216';

COMMIT;

