alter ignore table minibbtable_forums add column topics_count int(10) not null default 0;
alter ignore table minibbtable_forums add column posts_count int(10) not null default 0;

#2.0 RC3
alter ignore table minibbtable_forums add column forum_group varchar(150) not null default '';

alter ignore table minibbtable_topics add column posts_count int(10) not null default 0;
alter ignore table minibbtable_topics add column sticky int(1) not null default 0;
alter ignore table minibbtable_topics add key (sticky);

#2.0 RC3
alter ignore table minibbtable_topics add column topic_last_post_time datetime not null;
alter ignore table minibbtable_topics add key (topic_last_post_id);
alter ignore table minibbtable_topics add key posts_count (posts_count);
alter ignore table minibbtable_topics add key topic_time (topic_time);
alter ignore table minibbtable_topics add key topic_last_post_time (topic_last_post_time);
alter ignore table minibbtable_topics add key topic_views (topic_views);

alter ignore table minibbtable_send_mails add key (topic_id);
alter ignore table minibbtable_send_mails add key (user_id);

alter ignore table minibbtable_users add language varchar(3) not null default '';
alter ignore table minibbtable_users change user_icq user_icq varchar(50) not null default '';
alter ignore table minibbtable_users add activity int(1) not null default '1';
alter ignore table minibbtable_users add user_custom1 varchar(255) not null default '';
alter ignore table minibbtable_users add user_custom2 varchar(255) not null default '';
alter ignore table minibbtable_users add user_custom3 varchar(255) not null default '';

alter ignore table minibbtable_posts add key poster_ip (poster_ip);

#2.0 RC3
ALTER ignore TABLE minibbtable_users ADD num_topics INT(10) UNSIGNED DEFAULT '0' NOT NULL AFTER activity;
ALTER ignore TABLE minibbtable_users ADD num_posts INT(10) UNSIGNED DEFAULT '0' NOT NULL AFTER num_topics;

#2.0 RC5
ALTER ignore TABLE minibbtable_banned ADD banreason varchar(255) DEFAULT '' NOT NULL;