USE [% phpbb %];

ALTER TABLE [% table_prefix %]_search_results ADD COLUMN search_time int(11) DEFAULT '0' NOT NULL AFTER session_id;

INSERT INTO [% table_prefix %]_config (config_name, config_value) VALUES ('search_flood_interval','15');
INSERT INTO [% table_prefix %]_config (config_name, config_value) VALUES ('rand_seed', '0')

UPDATE [% table_prefix %]_config SET config_value = '1' WHERE config_name = 'enable_confirm';
UPDATE [% table_prefix %]_config SET config_value = '.0.20' WHERE config_name = 'version';

UPDATE [% table_prefix %]_forums SET auth_post='1', auth_reply='1' WHERE forum_id = '1';
