ALTER TABLE channel add column ignoreregexpire varchar(3);
UPDATE channel SET ignoreregexpire = 'no' where ignoreregexpire is NULL;
ALTER TABLE channel ALTER column ignoreregexpire SET not NULL;
ALTER TABLE channel ALTER column ignoreregexpire SET default 'no';
alter table channel add constraint channel_ignoreregexpire CHECK (ignoreregexpire IN ('yes','no'));

