alter table channel add column autolink int(1) not null default 0;
alter table channel add column silence int(1) not null default 0;
alter table channel add column basewiki int(11) not null default 1;
alter table channel add column hedgehog int(1) not null default 0;

update channel set hedgehog = 1
where channel_id in (
  select cc_channel
  from channelconfig
    inner join configuration on cc_config = configuration_id
  where configuration_name = 'hedgehog'
        and cc_value <> configuration_value
);

update channel set silence = 1
where channel_id in (
  select cc_channel
  from channelconfig
    inner join configuration on cc_config = configuration_id
  where configuration_name = 'silence'
        and cc_value <> configuration_value
);

update channel set autolink = 1
where channel_id in (
  select cc_channel
  from channelconfig
    inner join configuration on cc_config = configuration_id
  where configuration_name = 'autolink'
        and cc_value <> configuration_value
);