BEGIN;
alter table phone add column clock varchar(3) NOT NULL default 'yes';
alter table phone add CONSTRAINT phone_clock_check CHECK (clock IN ('yes', 'no'));

alter table phonetype add column clock varchar(3) NOT NULL default 'yes';
alter table phonetype add CONSTRAINT phonetype_clock_check CHECK (clock IN ('yes', 'no'));

alter table phonetypephone add column clock varchar(3) NOT NULL default 'yes';
alter table phonetypephone add CONSTRAINT phonetypephone_clock_check CHECK (clock IN ('yes', 'no'));

alter table phonetypecontactphone add column clock varchar(3) NOT NULL default 'yes';
alter table phonetypecontactphone add CONSTRAINT phonetypecontactphone_clock_check CHECK (clock IN ('yes', 'no'));

COMMIT;
