USE [% pp3 %];

ALTER TABLE `[% table_prefix %]_bbcodes` modify column `bbcode_id` smallint(4) unsigned NOT NULL DEFAULT '0';

REPLACE INTO `[% table_prefix %]_config` (`config_name`, `config_value`, `is_dynamic`) VALUES 
	('email_max_chunk_size', '50', 0),
	('ip_login_limit_max', '50', 0),
	('ip_login_limit_time', '21600', 0),
	('ip_login_limit_use_forwarded', '0', 0);

UPDATE `[% table_prefix %]_extension_groups`
    SET `group_name` = REPLACE( `group_name`, 'EXT_GROUP_', '')  
    WHERE `group_name` LIKE 'EXT_GROUP_%';

CREATE TABLE IF NOT EXISTS `[% table_prefix %]_login_attempts` (
  `attempt_ip` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '',
  `attempt_browser` varchar(150) COLLATE utf8_bin NOT NULL DEFAULT '',
  `attempt_forwarded_for` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `attempt_time` int(11) unsigned NOT NULL DEFAULT '0',
  `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `username` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '0',
  `username_clean` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '0',
  KEY `att_ip` (`attempt_ip`,`attempt_time`),
  KEY `att_for` (`attempt_forwarded_for`,`attempt_time`),
  KEY `att_time` (`attempt_time`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

ALTER TABLE `[% table_prefix %]_profile_fields` add column `field_show_novalue` tinyint(1) unsigned NOT NULL DEFAULT '0';

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