INSERT INTO phpbb_config(config_name, config_value)

VALUES('sf_mod_rewrite_enabled', 1),

	('sf_rewrite_all_htm', 1),

	('sf_rewrite_index', 0),

	('sf_rewrite_mode', 1),

	('sf_simplify_pages', 1),

	('sf_charset_mapping', 'auto'),

	('sf_fake_dirs', 1),

	('sf_postlink_rewrite', 0),

	('sf_max_keywords_length', 768),

	('sf_sitemap_enabled', 1),

	('sf_show_lastpost_link', 0),

	('sf_map_index_only', 1),

	('sf_map_mode_listonly', 1),

	('sf_topics_per_page', 30),

	('sf_log_spiders', 1),

	('sf_spider_session_length', 3600),

	('sf_cache_refresh_mode', 'post'),

	('sf_cache_read_mode', 'file-direct'),

	('sf_show_bots_on_index', 1),

	('sf_shmop_lasttoken', -1);

CREATE TABLE phpbb_spider_log(

  log_id mediumint(8) NOT NULL auto_increment,

  spider_name varchar(255) NOT NULL default '',

  spider_firstvisit int(11) NOT NULL default '0',

  spider_lastvisit int(11) NOT NULL default '0',

  spider_hits mediumint(8) NOT NULL default '0',

  PRIMARY KEY(log_id),

  KEY spider_lastvisit(spider_lastvisit)

);

ALTER TABLE phpbb_sessions ADD session_bot VARCHAR(255) NOT NULL default '';

ALTER TABLE phpbb_sessions ADD INDEX(session_bot(2));