BEGIN;
alter table phone add column callinterruptsdial varchar(3) not NULL default 'no';
alter table phone add CONSTRAINT phone_callinterruptsdial_check CHECK (callinterruptsdial IN ('yes', 'no'));

alter table phonetype add column callinterruptsdial varchar(3) not NULL default 'no';
alter table phonetype add CONSTRAINT phonetype_callinterruptsdial_check CHECK (callinterruptsdial IN ('yes', 'no'));

alter table phonetypephone add column callinterruptsdial varchar(3) not NULL default 'no';
alter table phonetypephone add CONSTRAINT phonetypephone_callinterruptsdial_check CHECK (callinterruptsdial IN ('yes', 'no'));

alter table phonetypecontactphone add column callinterruptsdial varchar(3) not NULL default 'no';
alter table phonetypecontactphone add CONSTRAINT phonetypecontactphone_callinterruptsdial_check CHECK (callinterruptsdial IN ('yes', 'no'));
COMMIT;

BEGIN;
alter table phone add column backlight varchar(3) not NULL default 'on';
alter table phone add CONSTRAINT phone_backlight_check CHECK (backlight IN ('off', 'on'));

alter table phonetype add column backlight varchar(3) not NULL default 'on';
alter table phonetype add CONSTRAINT phonetype_backlight_check CHECK (backlight IN ('off', 'on'));

alter table phonetypephone add column backlight varchar(3) not NULL default 'on';
alter table phonetypephone add CONSTRAINT phonetypephone_backlight_check CHECK (backlight IN ('off', 'on'));

alter table phonetypecontactphone add column backlight varchar(3) not NULL default 'on';
alter table phonetypecontactphone add CONSTRAINT phonetypecontactphone_backlight_check CHECK (backlight IN ('off', 'on'));
COMMIT;

BEGIN;
alter table phone add column backlight_time integer not NULL default '10';
alter table phonetype add column backlight_time integer not NULL default '10';
alter table phonetypephone add column backlight_time integer not NULL default '10';
alter table phonetypecontactphone add column backlight_time integer not NULL default '10';
COMMIT;

BEGIN;
alter table phone add column brightness integer not NULL default '1';
alter table phonetype add column brightness integer not NULL default '1';
alter table phonetypephone add column brightness integer not NULL default '1';
alter table phonetypecontactphone add column brightness integer not NULL default '1';
COMMIT;

BEGIN;
alter table phone add column  brightness_idle integer not NULL default '0';
alter table phonetype add column  brightness_idle integer not NULL default '0';
alter table phonetypephone add column  brightness_idle integer not NULL default '0';
alter table phonetypecontactphone add column  brightness_idle integer not NULL default '0';
COMMIT;

BEGIN;
alter table phone add column uifocusringingline varchar(3) not NULL default 'yes';
alter table phone add CONSTRAINT phone_uifocusringingline_check CHECK (uifocusringingline IN ('yes', 'no'));

alter table phonetype add column uifocusringingline varchar(3) not NULL default 'yes';
alter table phonetype add CONSTRAINT phonetype_uifocusringingline_check CHECK (uifocusringingline IN ('yes', 'no'));

alter table phonetypephone add column uifocusringingline varchar(3) not NULL default 'yes';
alter table phonetypephone add CONSTRAINT phonetypephone_uifocusringingline_check CHECK (uifocusringingline IN ('yes', 'no'));

alter table phonetypecontactphone add column uifocusringingline varchar(3) not NULL default 'yes';
alter table phonetypecontactphone add CONSTRAINT phonetypecontactphone_uifocusringingline_check CHECK (uifocusringingline IN ('yes', 'no'));
COMMIT;

BEGIN;
alter table phone add column vol_handset_sidetone integer not NULL default '10';
alter table phonetype add column vol_handset_sidetone integer not NULL default '10';
alter table phonetypephone add column vol_handset_sidetone integer not NULL default '10';
alter table phonetypecontactphone add column vol_handset_sidetone integer not NULL default '10';
COMMIT;

BEGIN;
alter table phone add column vol_headset_sidetone integer not NULL default '10';
alter table phonetype add column vol_headset_sidetone integer not NULL default '10';
alter table phonetypephone add column vol_headset_sidetone integer not NULL default '10';
alter table phonetypecontactphone add column vol_headset_sidetone integer not NULL default '10';
COMMIT;

