alter table zap_channel drop constraint zap_channel_cardtype;
alter table zap_channel drop constraint zap_channel_cardtype_check;
alter table zap_channel drop constraint zap_channel_cardtype_check1;
alter table zap_channel add CONSTRAINT zap_channel_cardtype_check CHECK (cardtype IN ('quadbri', 'octobri', 'unogsm', 'duogsm', 'quadgsm', 'x100p', 'tdm400p', 'tdm410', 'tdm2400p', 'tdm800p', 't100p', 'te110p', 'te120p', 'e100p', 'te210p', 'te205p', 'te410p', 'te405p'));

