USE [% pp3 %];

ALTER TABLE `[% table_prefix %]_confirm` CHANGE COLUMN `session_id` `session_id` char(32) collate utf8_bin NOT NULL default '';
ALTER TABLE `[% table_prefix %]_confirm` CHANGE COLUMN `confirm_id` `confirm_id` char(32) collate utf8_bin NOT NULL default '';
ALTER TABLE `[% table_prefix %]_confirm` ADD COLUMN `attempts` mediumint(8) unsigned NOT NULL default '0';

ALTER TABLE `[% table_prefix %]_forums` ADD COLUMN `forum_options` int(20) unsigned NOT NULL default '0';

ALTER TABLE `[% table_prefix %]_groups` ADD COLUMN `group_skip_auth` tinyint(1) unsigned NOT NULL default '0';

ALTER TABLE `[% table_prefix %]_log` ADD INDEX `log_time` (`log_time`);

ALTER TABLE `[% table_prefix %]_posts` ADD INDEX `post_username` (`post_username`);

ALTER TABLE `[% table_prefix %]_privmsgs` ADD COLUMN `message_reported` tinyint(1) unsigned NOT NULL default '0';

ALTER TABLE `[% table_prefix %]_profile_fields` ADD COLUMN `field_show_on_vt` tinyint(1) unsigned NOT NULL default '0';

ALTER TABLE `[% table_prefix %]_reports` ADD COLUMN `pm_id` mediumint(8) unsigned NOT NULL default '0';
ALTER TABLE `[% table_prefix %]_reports` ADD INDEX `post_id` (`post_id`);
ALTER TABLE `[% table_prefix %]_reports` ADD INDEX `pm_id` (`pm_id`);

ALTER TABLE `[% table_prefix %]_sessions` CHANGE COLUMN `session_id` `session_id` char(32) collate utf8_bin NOT NULL default '';

ALTER TABLE `[% table_prefix %]_sessions_keys` CHANGE COLUMN `key_id` `key_id` char(32) collate utf8_bin NOT NULL default '';

ALTER TABLE `[% table_prefix %]_users` CHANGE COLUMN `user_options` `user_options` int(11) unsigned NOT NULL default '230271';
ALTER TABLE `[% table_prefix %]_users` CHANGE COLUMN `user_post_sortby_type` `user_post_sortby_type` varchar(1) collate utf8_bin NOT NULL default 't';
ALTER TABLE `[% table_prefix %]_users` CHANGE COLUMN `user_topic_sortby_dir` `user_topic_sortby_dir` varchar(1) collate utf8_bin NOT NULL default 'd';
ALTER TABLE `[% table_prefix %]_users` CHANGE COLUMN `user_topic_sortby_type` `user_topic_sortby_type` varchar(1) collate utf8_bin NOT NULL default 't';
ALTER TABLE `[% table_prefix %]_users` CHANGE COLUMN `user_post_sortby_dir` `user_post_sortby_dir` varchar(1) collate utf8_bin NOT NULL default 'a';
ALTER TABLE `[% table_prefix %]_users` ADD COLUMN `user_reminded` tinyint(4) NOT NULL default '0';
ALTER TABLE `[% table_prefix %]_users` ADD COLUMN `user_reminded_time` int(11) unsigned NOT NULL default '0';
ALTER TABLE `[% table_prefix %]_users` ADD COLUMN `user_new` tinyint(1) unsigned NOT NULL default '1';

UPDATE `[% table_prefix %]_config` SET config_value = '3.0.6' WHERE config_name = 'version';

