ALTER TABLE card_e100p DROP CONSTRAINT card_e100p_switchtype_check;
ALTER TABLE card_octobri DROP CONSTRAINT card_octobri_switchtype_check;
ALTER TABLE card_quadbri DROP CONSTRAINT card_quadbri_switchtype_check;
ALTER TABLE card_t100p DROP CONSTRAINT card_t100p_switchtype_check;
ALTER TABLE card_te110p DROP CONSTRAINT card_te110p_switchtype_check;
ALTER TABLE card_te120p DROP CONSTRAINT card_te120p_switchtype_check;
ALTER TABLE card_te205p DROP CONSTRAINT card_te205p_switchtype_1_check;
ALTER TABLE card_te205p DROP CONSTRAINT card_te205p_switchtype_2_check;
ALTER TABLE card_te210p DROP CONSTRAINT card_te210p_switchtype_1_check;
ALTER TABLE card_te210p DROP CONSTRAINT card_te210p_switchtype_2_check;
ALTER TABLE card_te405p DROP CONSTRAINT card_te405p_switchtype_1_check;
ALTER TABLE card_te405p DROP CONSTRAINT card_te405p_switchtype_2_check;
ALTER TABLE card_te405p DROP CONSTRAINT card_te405p_switchtype_3_check;
ALTER TABLE card_te405p DROP CONSTRAINT card_te405p_switchtype_4_check;
ALTER TABLE card_te410p DROP CONSTRAINT card_te410p_switchtype_1_check;
ALTER TABLE card_te410p DROP CONSTRAINT card_te410p_switchtype_2_check;
ALTER TABLE card_te410p DROP CONSTRAINT card_te410p_switchtype_3_check;
ALTER TABLE card_te410p DROP CONSTRAINT card_te410p_switchtype_4_check;
ALTER TABLE card_e100p ADD CONSTRAINT card_e100p_switchtype_check CHECK (switchtype IN ('national', 'dms100', '4ess', '5ess', 'euroisdn', 'ni1', 'qsig'));
ALTER TABLE card_octobri ADD CONSTRAINT card_octobri_switchtype_check CHECK (switchtype IN ('national', 'dms100', '4ess', '5ess', 'euroisdn', 'ni1', 'qsig'));
ALTER TABLE card_quadbri ADD CONSTRAINT card_quadbri_switchtype_check CHECK (switchtype IN ('national', 'dms100', '4ess', '5ess', 'euroisdn', 'ni1', 'qsig'));
ALTER TABLE card_t100p ADD CONSTRAINT card_t100p_switchtype_check CHECK (switchtype IN ('national', 'dms100', '4ess', '5ess', 'euroisdn', 'ni1', 'qsig'));
ALTER TABLE card_te110p ADD CONSTRAINT card_te110p_switchtype_check CHECK (switchtype IN ('national', 'dms100', '4ess', '5ess', 'euroisdn', 'ni1', 'qsig'));
ALTER TABLE card_te120p ADD CONSTRAINT card_te120p_switchtype_check CHECK (switchtype IN ('national', 'dms100', '4ess', '5ess', 'euroisdn', 'ni1', 'qsig'));
ALTER TABLE card_te205p ADD CONSTRAINT card_te205p_switchtype_1_check CHECK (switchtype_1 IN ('national', 'dms100', '4ess', '5ess', 'euroisdn', 'ni1', 'qsig'));
ALTER TABLE card_te205p ADD CONSTRAINT card_te205p_switchtype_2_check CHECK (switchtype_2 IN ('national', 'dms100', '4ess', '5ess', 'euroisdn', 'ni1', 'qsig'));
ALTER TABLE card_te210p ADD CONSTRAINT card_te210p_switchtype_1_check CHECK (switchtype_1 IN ('national', 'dms100', '4ess', '5ess', 'euroisdn', 'ni1', 'qsig'));
ALTER TABLE card_te210p ADD CONSTRAINT card_te210p_switchtype_2_check CHECK (switchtype_2 IN ('national', 'dms100', '4ess', '5ess', 'euroisdn', 'ni1', 'qsig'));
ALTER TABLE card_te405p ADD CONSTRAINT card_te405p_switchtype_1_check CHECK (switchtype_1 IN ('national', 'dms100', '4ess', '5ess', 'euroisdn', 'ni1', 'qsig'));
ALTER TABLE card_te405p ADD CONSTRAINT card_te405p_switchtype_2_check CHECK (switchtype_2 IN ('national', 'dms100', '4ess', '5ess', 'euroisdn', 'ni1', 'qsig'));
ALTER TABLE card_te405p ADD CONSTRAINT card_te405p_switchtype_3_check CHECK (switchtype_3 IN ('national', 'dms100', '4ess', '5ess', 'euroisdn', 'ni1', 'qsig'));
ALTER TABLE card_te405p ADD CONSTRAINT card_te405p_switchtype_4_check CHECK (switchtype_4 IN ('national', 'dms100', '4ess', '5ess', 'euroisdn', 'ni1', 'qsig'));
ALTER TABLE card_te410p ADD CONSTRAINT card_te410p_switchtype_1_check CHECK (switchtype_1 IN ('national', 'dms100', '4ess', '5ess', 'euroisdn', 'ni1', 'qsig'));
ALTER TABLE card_te410p ADD CONSTRAINT card_te410p_switchtype_2_check CHECK (switchtype_2 IN ('national', 'dms100', '4ess', '5ess', 'euroisdn', 'ni1', 'qsig'));
ALTER TABLE card_te410p ADD CONSTRAINT card_te410p_switchtype_3_check CHECK (switchtype_3 IN ('national', 'dms100', '4ess', '5ess', 'euroisdn', 'ni1', 'qsig'));
ALTER TABLE card_te410p ADD CONSTRAINT card_te410p_switchtype_4_check CHECK (switchtype_4 IN ('national', 'dms100', '4ess', '5ess', 'euroisdn', 'ni1', 'qsig'));

