alter table zap_channel drop constraint zap_channel_cardtype;
alter table zap_channel drop constraint zap_channel_cardtype_check;
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', 'e100p', 'te120p', 'te210p', 'te205p', 'te410p', 'te405p'));

CREATE TABLE card_tdm800p (
 id serial,
 name varchar(24) NOT NULL default '',
--GENERATE:/etc/zaptel.conf::
--HELP_EN_INFO:name for this card
--HELP_EN_LONG:Name for this card
--HELP_NL_INFO:naam van deze card
--HELP_NL_LONG:Naam van deze kaart

 status varchar(8) NOT NULL default 'active'
   CHECK (status IN ('active', 'deleted')),
--GENERATE:/etc/zaptel.conf::
--HELP_EN_INFO:status
--HELP_EN_LONG:Card status
--HELP_NL_INFO:status
--HELP_NL_LONG:Status van deze kaart

 PRIMARY KEY  (id)
);

GRANT UPDATE, SELECT, INSERT, DELETE ON card_tdm800p TO astium;
GRANT UPDATE, SELECT, INSERT, DELETE ON card_tdm800p_id_seq TO astium;
INSERT INTO card_tdm800p (name, status) VALUES ('empty', 'deleted');
