USE [% pp3 %];

ALTER TABLE `[% table_prefix %]_log` DROP INDEX `log_time`;

ALTER TABLE `[% table_prefix %]_topics_track` ADD INDEX `topic_id` (`topic_id`);

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

INSERT IGNORE INTO `[% table_prefix %]_config` (`config_name`, `config_value`, `is_dynamic`) VALUES
('captcha_plugin', 'phpbb_captcha_nogd', 0);

INSERT IGNORE INTO `[% table_prefix %]_config` (`config_name`, `config_value`, `is_dynamic`) VALUES
('captcha_gd_wave', '0', 0);

INSERT IGNORE INTO `[% table_prefix %]_config` (`config_name`, `config_value`, `is_dynamic`) VALUES
('captcha_gd_3d_noise', '1', 0);

INSERT IGNORE INTO `[% table_prefix %]_config` (`config_name`, `config_value`, `is_dynamic`) VALUES
('captcha_gd_fonts', '1', 0);
