have you already converted to PhpBB2 ?
you could gimme a clou where ecactly your stuck at the moment
first i converted from smf to phpbb2 then followed
How To Upgrade From phpBB 2 and i fail after the following step
12. Apply all permissions listed in Fresh Installation.
the script does not work so i can't Start with the 13 step :(
when i tried for the 8th time finally got some error message atleast
Icy Phoenix - Update in progress
The following SQL have not been executed:
* ALTER TABLE `phpbb_album_cat` ADD `cat_parent` MEDIUMINT(8) UNSIGNED DEFAULT '0' NULL AFTER `cat_approval`
+++ Error: Duplicate column name 'cat_parent'
* ALTER TABLE `phpbb_album_cat` ADD `cat_user_id` MEDIUMINT(8) UNSIGNED DEFAULT '0' NULL AFTER `cat_parent`
+++ Error: Duplicate column name 'cat_user_id'
* ALTER TABLE phpbb_auth_access ADD `auth_mod` tinyint(1) NOT NULL default '0'
+++ Error: Duplicate column name 'auth_mod'
* ALTER TABLE `phpbb_sessions` ADD `session_admin` TINYINT(2) DEFAULT '0' NOT NULL
+++ Error: Duplicate column name 'session_admin'
* CREATE TABLE `phpbb_sessions_keys` ( `key_id` varchar(32) NOT NULL default '0', `user_id` mediumint(8) NOT NULL default '0', `last_ip` varchar(8) NOT NULL default '0', `last_login` int(11) NOT NULL default '0', PRIMARY KEY (`key_id`,`user_id`), KEY `last_login` (`last_login`) )
+++ Error: Table 'phpbb_sessions_keys' already exists
* INSERT INTO phpbb_config VALUES ('allow_autologin', '1')
+++ Error: Duplicate entry 'allow_autologin' for key 1
* INSERT INTO phpbb_config VALUES ('max_autologin_time', '0')
+++ Error: Duplicate entry 'max_autologin_time' for key 1
* INSERT INTO `phpbb_kb_articles` VALUES (1, 1, 'Test Article', 'This is a test article for your KB', '1057708235', 2, '', '93074f48a9', 'This is a test article for your Knowledge Base. This MOD is based on code written by wGEric < eric@egcnetwork.com > (Eric Faerber) - http://eric.best-1.biz/, now supervised by _Haplo < jonohlsson@hotmail.com > (Jon Ohlsson) - http://www.mx-system.com/ Be sure you add categories and article types in the ACP and also change the Configuration to your liking. Have fun and enjoy your new Knowledge Base! :D', 1, 1, 0, 0, '0.0000', 0)
+++ Error: Column count doesn't match value count at row 1
* DROP TABLE phpbb_cracktrack
+++ Error: Unknown table 'phpbb_cracktrack'
* ALTER TABLE phpbb_users ADD user_login_tries smallint(5) UNSIGNED DEFAULT '0' NOT NULL
+++ Error: Duplicate column name 'user_login_tries'
* ALTER TABLE phpbb_users ADD user_last_login_try int(11) DEFAULT '0' NOT NULL
+++ Error: Duplicate column name 'user_last_login_try'
* ALTER TABLE `phpbb_search_results` ADD COLUMN search_time int(11) DEFAULT '0' NOT NULL
+++ Error: Duplicate column name 'search_time'
* INSERT INTO phpbb_config VALUES ('search_min_chars', '3')
+++ Error: Duplicate entry 'search_min_chars' for key 1
* DROP TABLE phpbb_flags
+++ Error: Unknown table 'phpbb_flags'
* DROP TABLE `phpbb_ctrack`
+++ Error: Unknown table 'phpbb_ctrack'
* DROP TABLE `phpbb_ct_filter`
+++ Error: Unknown table 'phpbb_ct_filter'
* ALTER TABLE `phpbb_users` DROP `ct_postcount`
+++ Error: Can't DROP 'ct_postcount'; check that column/key exists
* ALTER TABLE `phpbb_users` DROP `ct_posttime`
+++ Error: Can't DROP 'ct_posttime'; check that column/key exists
* ALTER TABLE `phpbb_users` DROP `ct_searchcount`
+++ Error: Can't DROP 'ct_searchcount'; check that column/key exists
* ALTER TABLE `phpbb_users` DROP `ct_searchtime`
+++ Error: Can't DROP 'ct_searchtime'; check that column/key exists
* DROP TABLE `phpbb_block_position`
+++ Error: Unknown table 'phpbb_block_position'
* DROP TABLE `phpbb_block_variable`
+++ Error: Unknown table 'phpbb_block_variable'
* DROP TABLE `phpbb_blocks`
+++ Error: Unknown table 'phpbb_blocks'
* DROP TABLE `phpbb_layout`
+++ Error: Unknown table 'phpbb_layout'
* DROP TABLE `phpbb_portal_config`
+++ Error: Unknown table 'phpbb_portal_config'
* DROP TABLE `phpbb_config_mg`
+++ Error: Unknown table 'phpbb_config_mg'
* DROP TABLE `phpbb_color_groups`
+++ Error: Unknown table 'phpbb_color_groups'
* ALTER TABLE `phpbb_groups` DROP `group_color_group`
+++ Error: Can't DROP 'group_color_group'; check that column/key exists
* ALTER TABLE `phpbb_users` DROP `user_session_topic`
+++ Error: Can't DROP 'user_session_topic'; check that column/key exists
* ALTER TABLE `phpbb_sessions` DROP `session_topic`
+++ Error: Can't DROP 'session_topic'; check that column/key exists
* ALTER TABLE `phpbb_cms_blocks` ADD `layout_special` int(10) NOT NULL default '0' AFTER `layout`
+++ Error: Duplicate column name 'layout_special'
* CREATE TABLE `phpbb_dl_notraf` ( user_id MEDIUMINT(8) NOT NULL DEFAULT 0, dl_id INT(11) NOT NULL DEFAULT 0 )
+++ Error: Table 'phpbb_dl_notraf' already exists
* ALTER TABLE `phpbb_cms_layout` CHANGE `forum_wide` `global_blocks` TINYINT(1) NOT NULL DEFAULT '0'
+++ Error: Unknown column 'forum_wide' in 'phpbb_cms_layout'
* ALTER TABLE `phpbb_cms_layout_special` CHANGE `forum_wide` `global_blocks` TINYINT(1) NOT NULL DEFAULT '0'
+++ Error: Unknown column 'forum_wide' in 'phpbb_cms_layout_special'
* INSERT INTO `phpbb_config` (config_name, config_value) VALUES ('link_this_topic', '0')
+++ Error: Duplicate entry 'link_this_topic' for key 1
* ALTER TABLE `phpbb_ajax_shoutbox` DROP `shout_uid`
+++ Error: Can't DROP 'shout_uid'; check that column/key exists
* ALTER TABLE `phpbb_cms_blocks` DROP `block_bbcode_uid`
+++ Error: Can't DROP 'block_bbcode_uid'; check that column/key exists
* ALTER TABLE `phpbb_dl_bug_tracker` DROP `report_uid`
+++ Error: Can't DROP 'report_uid'; check that column/key exists
* ALTER TABLE `phpbb_dl_comments` DROP `bbcode_uid`
+++ Error: Can't DROP 'bbcode_uid'; check that column/key exists
* ALTER TABLE `phpbb_downloads` DROP `bbcode_uid`
+++ Error: Can't DROP 'bbcode_uid'; check that column/key exists
* ALTER TABLE `phpbb_downloads_cat` DROP `bbcode_uid`
+++ Error: Can't DROP 'bbcode_uid'; check that column/key exists
* ALTER TABLE `phpbb_kb_articles` DROP `bbcode_uid`
+++ Error: Can't DROP 'bbcode_uid'; check that column/key exists
* ALTER TABLE `phpbb_pa_comments` DROP INDEX `comments_id`
+++ Error: Can't DROP 'comments_id'; check that column/key exists
* ALTER TABLE `phpbb_pa_comments` DROP INDEX `comment_bbcode_uid`
+++ Error: Can't DROP 'comment_bbcode_uid'; check that column/key exists
* ALTER TABLE `phpbb_pa_comments` DROP `comment_bbcode_uid`
+++ Error: Can't DROP 'comment_bbcode_uid'; check that column/key exists
* ALTER TABLE `phpbb_shout` DROP `shout_bbcode_uid`
+++ Error: Can't DROP 'shout_bbcode_uid'; check that column/key exists
* INSERT INTO `___posts___` SELECT p.post_id, p.topic_id, p.forum_id, p.poster_id, p.post_time, p.poster_ip, p.post_username, t.post_subject, t.post_text, t.post_text_compiled, p.enable_bbcode, p.enable_html, p.enable_smilies, p.enable_sig, t.edit_notes, p.post_edit_time, p.post_edit_count, p.post_edit_id, p.post_attachment, p.post_bluecard, p.enable_autolinks_acronyms FROM `phpbb_posts` p, `phpbb_posts_text` t WHERE p.post_id = t.post_id ORDER BY p.post_id
+++ Error: Unknown column 't.post_text_compiled' in 'field list'
* DROP TABLE `phpbb_optimize_db`
+++ Error: Unknown table 'phpbb_optimize_db'
* INSERT INTO `___megamail___` SELECT m.mail_id, m.mailsession_id, 0, m.user_id, m.group_id, m.email_subject, m.email_body, 0, m.batch_start, m.batch_size, m.batch_wait, m.status FROM `phpbb_megamail` m ORDER BY m.mail_id
+++ Error: Table 'underarc_rama.phpbb_megamail' doesn't exist
* RENAME TABLE `phpbb_megamail` TO `_old_phpbb_megamail`
+++ Error: Can't find file: './underarc_rama/phpbb_megamail.frm' (errno: 2)
* ALTER TABLE `phpbb_cms_blocks` ADD `border` TINYINT(1) SET DEFAULT '1' AFTER `border_explain`
+++ Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SET DEFAULT '1' AFTER `border_explain`' at line 1
* ALTER TABLE `phpbb_cms_blocks` ADD `titlebar` TINYINT(1) SET DEFAULT '1' AFTER `border`
+++ Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SET DEFAULT '1' AFTER `border`' at line 1
* UPDATE `phpbb_cms_blocks` SET border= '0' WHERE border_explain= '0,0,0,0'
+++ Error: Unknown column 'border_explain' in 'where clause'
* UPDATE `phpbb_cms_blocks` SET border= '1' WHERE border_explain= '1,1,1,1'
+++ Error: Unknown column 'border_explain' in 'where clause'
* UPDATE `phpbb_cms_blocks` SET titlebar= '0' WHERE titlebar_explain= '0,0'
+++ Error: Unknown column 'titlebar_explain' in 'where clause'
* UPDATE `phpbb_cms_blocks` SET titlebar= '1' WHERE titlebar_explain= '1,1'
+++ Error: Unknown column 'titlebar_explain' in 'where clause'
* ALTER TABLE phpbb_registration_desc DROP `reg_option1`
+++ Error: Can't DROP 'reg_option1'; check that column/key exists
* ALTER TABLE phpbb_registration_desc DROP `reg_option2`
+++ Error: Can't DROP 'reg_option2'; check that column/key exists
* ALTER TABLE phpbb_registration_desc DROP `reg_option3`
+++ Error: Can't DROP 'reg_option3'; check that column/key exists
* ALTER TABLE `phpbb_cms_layout_special` ADD `page_id` varchar(100) NOT NULL DEFAULT '' AFTER `lsid`
+++ Error: Duplicate column name 'page_id'
* ALTER TABLE `phpbb_cms_layout_special` ADD `locked` tinyint(1) NOT NULL DEFAULT '1' AFTER `page_id`
+++ Error: Duplicate column name 'locked'
The following SQL have been executed successfully:
Spoiler: [ Show ]
Spoiler: [ Hide ]
* ALTER TABLE phpbb_config CHANGE `config_value` `config_value` TEXT NOT NULL
+++ Successful
* CREATE TABLE `phpbb_acronyms` ( `acronym_id` mediumint(9) NOT NULL auto_increment, `acronym` varchar(80) NOT NULL default '', `description` varchar(255) NOT NULL default '', PRIMARY KEY (`acronym_id`) )
+++ Successful
* CREATE TABLE `phpbb_adminedit` ( `edit_id` mediumint(8) unsigned NOT NULL auto_increment, `edituser` char(100) NOT NULL default '', `editok` char(100) NOT NULL default '', PRIMARY KEY (`edit_id`) )
+++ Successful
* CREATE TABLE `phpbb_album` ( `pic_id` int(11) unsigned NOT NULL auto_increment, `pic_filename` varchar(255) NOT NULL default '', `pic_thumbnail` varchar(255) NULL default '', `pic_title` varchar(255) NOT NULL default '', `pic_desc` text, `pic_user_id` mediumint(8) NOT NULL default '0', `pic_username` varchar(32) NULL default '', `pic_user_ip` varchar(8) NOT NULL default '0', `pic_time` int(11) unsigned NOT NULL default '0', `pic_cat_id` mediumint(8) unsigned NOT NULL default '1', `pic_view_count` int(11) unsigned NOT NULL default '0', `pic_lock` tinyint(3) NOT NULL default '0', `pic_approval` tinyint(3) NOT NULL default '1', PRIMARY KEY (`pic_id`), KEY `pic_cat_id` (`pic_cat_id`), KEY `pic_user_id` (`pic_user_id`), KEY `pic_time` (`pic_time`) )
+++ Successful
* CREATE TABLE `phpbb_album_cat` ( `cat_id` mediumint(8) unsigned NOT NULL auto_increment, `cat_title` varchar(255) NOT NULL default '', `cat_desc` text, `cat_order` mediumint(8) NOT NULL default '0', `cat_view_level` tinyint(3) NOT NULL default '-1', `cat_upload_level` tinyint(3) NOT NULL default '0', `cat_rate_level` tinyint(3) NOT NULL default '0', `cat_comment_level` tinyint(3) NOT NULL default '0', `cat_edit_level` tinyint(3) NOT NULL default '0', `cat_delete_level` tinyint(3) NOT NULL default '2', `cat_view_groups` varchar(255) NULL default '', `cat_upload_groups` varchar(255) NULL default '', `cat_rate_groups` varchar(255) NULL default '', `cat_comment_groups` varchar(255) NULL default '', `cat_edit_groups` varchar(255) NULL default '', `cat_delete_groups` varchar(255) NULL default '', `cat_moderator_groups` varchar(255) NULL default '', `cat_approval` tinyint(3) NOT NULL default '0', `cat_parent` mediumint(8) unsigned default '0', `cat_user_id` mediumint(8) unsigned default '0', PRIMARY KEY (`cat_id`), KEY `cat_order` (`cat_order`) )
+++ Successful
* CREATE TABLE `phpbb_album_comment` ( `comment_id` int(11) unsigned NOT NULL auto_increment, `comment_pic_id` int(11) unsigned NOT NULL default '0', `comment_cat_id` int(11) NOT NULL default '0', `comment_user_id` mediumint(8) NOT NULL default '0', `comment_username` varchar(32) default '', `comment_user_ip` varchar(8) NOT NULL default '', `comment_time` int(11) unsigned NOT NULL default '0', `comment_text` text, `comment_edit_time` int(11) unsigned default NULL, `comment_edit_count` smallint(5) unsigned NOT NULL default '0', `comment_edit_user_id` mediumint(8) default NULL, PRIMARY KEY (`comment_id`), KEY `comment_pic_id` (`comment_pic_id`), KEY `comment_user_id` (`comment_user_id`), KEY `comment_user_ip` (`comment_user_ip`), KEY `comment_time` (`comment_time`) )
+++ Successful
* CREATE TABLE `phpbb_album_config` ( `config_name` varchar(255) NOT NULL default '', `config_value` varchar(255) NOT NULL default '', PRIMARY KEY (`config_name`) )
+++ Successful
* CREATE TABLE `phpbb_album_rate` ( `rate_pic_id` int(11) unsigned NOT NULL default '0', `rate_user_id` mediumint(8) NOT NULL default '0', `rate_user_ip` char(8) NOT NULL default '', `rate_point` tinyint(3) unsigned NOT NULL default '0', `rate_hon_point` tinyint(3) NOT NULL default '0', KEY `rate_pic_id` (`rate_pic_id`), KEY `rate_user_id` (`rate_user_id`), KEY `rate_user_ip` (`rate_user_ip`), KEY `rate_point` (`rate_point`) )
+++ Successful
* CREATE TABLE phpbb_attachments_config ( config_name varchar(255) NOT NULL, config_value varchar(255) NOT NULL, PRIMARY KEY (config_name) )
+++ Successful
* CREATE TABLE phpbb_forbidden_extensions ( ext_id mediumint(8) UNSIGNED NOT NULL auto_increment, extension varchar(100) NOT NULL, PRIMARY KEY (ext_id) )
+++ Successful
* CREATE TABLE phpbb_extension_groups ( group_id mediumint(8) NOT NULL auto_increment, group_name char(20) NOT NULL, cat_id tinyint(2) DEFAULT '0' NOT NULL, allow_group tinyint(1) DEFAULT '0' NOT NULL, download_mode tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, upload_icon varchar(100) DEFAULT '', max_filesize int(20) DEFAULT '0' NOT NULL, forum_permissions varchar(255) default '' NOT NULL, PRIMARY KEY group_id (group_id) )
+++ Successful
* CREATE TABLE phpbb_extensions ( ext_id mediumint(8) UNSIGNED NOT NULL auto_increment, group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, extension varchar(100) NOT NULL, comment varchar(100), PRIMARY KEY ext_id (ext_id) )
+++ Successful
* CREATE TABLE phpbb_attachments_desc ( attach_id mediumint(8) UNSIGNED NOT NULL auto_increment, physical_filename varchar(255) NOT NULL, real_filename varchar(255) NOT NULL, download_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, comment varchar(255), extension varchar(100), mimetype varchar(100), filesize int(20) NOT NULL, filetime int(11) DEFAULT '0' NOT NULL, thumbnail tinyint(1) DEFAULT '0' NOT NULL, PRIMARY KEY (attach_id), KEY filetime (filetime), KEY physical_filename (physical_filename(10)), KEY filesize (filesize) )
+++ Successful
* CREATE TABLE phpbb_attachments ( attach_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, privmsgs_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, user_id_1 mediumint(8) NOT NULL, user_id_2 mediumint(8) NOT NULL, KEY attach_id_post_id (attach_id, post_id), KEY attach_id_privmsgs_id (attach_id, privmsgs_id), KEY post_id (post_id), KEY privmsgs_id (privmsgs_id) )
+++ Successful
* CREATE TABLE phpbb_quota_limits ( quota_limit_id mediumint(8) unsigned NOT NULL auto_increment, quota_desc varchar(20) NOT NULL default '', quota_limit bigint(20) unsigned NOT NULL default '0', PRIMARY KEY (quota_limit_id) )
+++ Successful
* CREATE TABLE phpbb_attach_quota ( user_id mediumint(8) unsigned NOT NULL default '0', group_id mediumint(8) unsigned NOT NULL default '0', quota_type smallint(2) NOT NULL default '0', quota_limit_id mediumint(8) unsigned NOT NULL default '0', KEY quota_type (quota_type) )
+++ Successful
* ALTER TABLE phpbb_forums ADD auth_download TINYINT(2) DEFAULT '0' NOT NULL
+++ Successful
* ALTER TABLE phpbb_auth_access ADD auth_download TINYINT(1) DEFAULT '0' NOT NULL
+++ Successful
* ALTER TABLE phpbb_posts ADD post_attachment TINYINT(1) DEFAULT '0' NOT NULL
+++ Successful
* ALTER TABLE phpbb_topics ADD topic_attachment TINYINT(1) DEFAULT '0' NOT NULL
+++ Successful
* ALTER TABLE phpbb_privmsgs ADD privmsgs_attachment TINYINT(1) DEFAULT '0' NOT NULL
+++ Successful
* CREATE TABLE `phpbb_autolinks` ( `link_id` mediumint(5) unsigned NOT NULL auto_increment, `link_keyword` varchar(50) NOT NULL default '', `link_title` varchar(50) NOT NULL default '', `link_url` varchar(200) NOT NULL default '', `link_comment` varchar(200) NOT NULL default '', `link_style` varchar(200) NOT NULL default '', `link_forum` tinyint(1) NOT NULL default '0', `link_int` tinyint(1) NOT NULL default '0', KEY `link_id` (`link_id`) )
+++ Successful
* ALTER TABLE phpbb_forums ADD auth_globalannounce TINYINT (2) DEFAULT '3' NOT NULL AFTER auth_announce
+++ Successful
* ALTER TABLE phpbb_auth_access ADD auth_globalannounce TINYINT (1) not null AFTER auth_announce
+++ Successful
* ALTER TABLE phpbb_auth_access ADD `auth_ban` tinyint(1) NOT NULL default '0'
+++ Successful
* ALTER TABLE phpbb_auth_access ADD `auth_greencard` tinyint(1) NOT NULL default '0'
+++ Successful
* ALTER TABLE phpbb_auth_access ADD `auth_bluecard` tinyint(1) NOT NULL default '0'
+++ Successful
* ALTER TABLE phpbb_auth_access ADD `auth_rate` tinyint(1) NOT NULL default '0'
+++ Successful
* ALTER TABLE phpbb_auth_access ADD `auth_news` tinyint(1) NOT NULL default '0'
+++ Successful
* ALTER TABLE phpbb_auth_access ADD `auth_cal` tinyint(1) NOT NULL default '0'
+++ Successful
* ALTER TABLE `phpbb_banlist` ADD `ban_time` INT(11) DEFAULT NULL
+++ Successful
* ALTER TABLE `phpbb_banlist` ADD `ban_expire_time` INT(11) DEFAULT NULL
+++ Successful
* ALTER TABLE `phpbb_banlist` ADD `ban_by_userid` MEDIUMINT(8) DEFAULT NULL
+++ Successful
* ALTER TABLE `phpbb_banlist` ADD `ban_priv_reason` TEXT DEFAULT NULL
+++ Successful
* ALTER TABLE `phpbb_banlist` ADD `ban_pub_reason_mode` TINYINT(1) DEFAULT NULL
+++ Successful
* ALTER TABLE `phpbb_banlist` ADD `ban_pub_reason` TEXT DEFAULT NULL
+++ Successful
* ALTER TABLE `phpbb_categories` ADD `cat_main_type` CHAR(1) DEFAULT NULL
+++ Successful
* ALTER TABLE `phpbb_categories` ADD `cat_main` MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL
+++ Successful
* ALTER TABLE `phpbb_categories` ADD `cat_desc` TEXT NOT NULL
+++ Successful
* ALTER TABLE `phpbb_categories` ADD `icon` VARCHAR(255) DEFAULT NULL
+++ Successful
* CREATE TABLE `phpbb_force_read` ( `topic_number` int(25) NOT NULL default '0', `message` text NOT NULL, `install_date` int(15) NOT NULL default '0', `active` tinyint(2) NOT NULL default '1', `effected` tinyint(1) NOT NULL default '1' )
+++ Successful
* CREATE TABLE `phpbb_force_read_users` ( `user` varchar(255) NOT NULL default '', `read` int(1) NOT NULL default '0', `time` int(10) NOT NULL default '0' )
+++ Successful
* ALTER TABLE `phpbb_forums` ADD `thank` TINYINT(1) DEFAULT '1' NOT NULL
+++ Successful
* ALTER TABLE `phpbb_forums` ADD `forum_notify` TINYINT(1) UNSIGNED DEFAULT '1' NOT NULL
+++ Successful
* ALTER TABLE `phpbb_forums` ADD `forum_link` VARCHAR(255) DEFAULT NULL
+++ Successful
* ALTER TABLE `phpbb_forums` ADD `forum_link_internal` TINYINT(1) DEFAULT '0' NOT NULL
+++ Successful
* ALTER TABLE `phpbb_forums` ADD `forum_link_hit_count` TINYINT(1) DEFAULT '0' NOT NULL
+++ Successful
* ALTER TABLE `phpbb_forums` ADD `forum_link_hit` BIGINT(20) UNSIGNED DEFAULT '0' NOT NULL
+++ Successful
* ALTER TABLE `phpbb_forums` ADD `icon` VARCHAR(255) DEFAULT NULL
+++ Successful
* ALTER TABLE `phpbb_forums` ADD `main_type` CHAR(1) DEFAULT NULL
+++ Successful
* ALTER TABLE `phpbb_forums` ADD `auth_news` TINYINT(2) DEFAULT '2' NOT NULL
+++ Successful
* ALTER TABLE `phpbb_forums` ADD `auth_cal` TINYINT(2) DEFAULT '0' NOT NULL
+++ Successful
* ALTER TABLE `phpbb_forums` ADD `auth_ban` TINYINT(2) DEFAULT '3' NOT NULL
+++ Successful
* ALTER TABLE `phpbb_forums` ADD `auth_greencard` TINYINT(2) DEFAULT '5' NOT NULL
+++ Successful
* ALTER TABLE `phpbb_forums` ADD `auth_bluecard` TINYINT(2) DEFAULT '1' NOT NULL
+++ Successful
* ALTER TABLE `phpbb_forums` ADD `auth_rate` TINYINT(2) DEFAULT '-1' NOT NULL
+++ Successful
* ALTER TABLE `phpbb_forums` ADD `forum_rules` TEXT NOT NULL
+++ Successful
* ALTER TABLE `phpbb_forums` ADD `rules_display_title` TINYINT(1) DEFAULT '1' NOT NULL
+++ Successful
* ALTER TABLE `phpbb_forums` ADD `rules_custom_title` VARCHAR(80) NOT NULL
+++ Successful
* ALTER TABLE `phpbb_forums` ADD `rules_in_viewforum` TINYINT(1) UNSIGNED DEFAULT '0' NOT NULL
+++ Successful
* ALTER TABLE `phpbb_forums` ADD `rules_in_viewtopic` TINYINT(1) UNSIGNED DEFAULT '0' NOT NULL
+++ Successful
* ALTER TABLE `phpbb_forums` ADD `rules_in_posting` TINYINT(1) UNSIGNED DEFAULT '0' NOT NULL
+++ Successful
* CREATE TABLE `phpbb_forums_watch` ( `forum_id` smallint(5) unsigned NOT NULL default '0', `user_id` mediumint(8) NOT NULL default '0', `notify_status` tinyint(1) NOT NULL default '0', KEY `forum_id` (`forum_id`), KEY `user_id` (`user_id`), KEY `notify_status` (`notify_status`) )
+++ Successful
* CREATE TABLE `phpbb_google_bot_detector` ( `detect_id` int(8) NOT NULL auto_increment, `detect_time` int(11) NOT NULL default '0', `detect_url` varchar(255) NOT NULL default '', PRIMARY KEY (`detect_id`) )
+++ Successful
* ALTER TABLE `phpbb_groups` ADD `group_count` INT(4) UNSIGNED DEFAULT '99999999'
+++ Successful
* ALTER TABLE `phpbb_groups` ADD `group_count_max` INT(4) UNSIGNED DEFAULT '99999999'
+++ Successful
* ALTER TABLE `phpbb_groups` ADD `group_count_enable` SMALLINT(2) UNSIGNED DEFAULT '0'
+++ Successful
* CREATE TABLE `phpbb_hacks_list` ( `hack_id` mediumint(8) unsigned NOT NULL auto_increment, `hack_name` varchar(255) NOT NULL default '', `hack_desc` varchar(255) NOT NULL default '', `hack_author` varchar(255) NOT NULL default '', `hack_author_email` varchar(255) NOT NULL default '', `hack_author_website` tinytext NOT NULL, `hack_version` varchar(32) NOT NULL default '', `hack_hide` enum('Yes','No') NOT NULL default 'No', `hack_download_url` tinytext NOT NULL, `hack_file` varchar(255) NOT NULL default '', `hack_file_mtime` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`hack_id`), UNIQUE KEY `hack_name` (`hack_name`), KEY `hack_file` (`hack_file`), KEY `hack_hide` (`hack_hide`) )
+++ Successful
* CREATE TABLE `phpbb_jr_admin_users` ( `user_id` mediumint(9) NOT NULL default '0', `user_jr_admin` longtext NOT NULL, `start_date` int(10) unsigned NOT NULL default '0', `update_date` int(10) unsigned NOT NULL default '0', `admin_notes` text NOT NULL, `notes_view` tinyint(1) NOT NULL default '0', PRIMARY KEY (`user_id`) )
+++ Successful
* CREATE TABLE `phpbb_kb_articles` ( `article_id` mediumint(8) unsigned NOT NULL auto_increment, `article_category_id` mediumint(8) unsigned NOT NULL default '0', `article_title` varchar(255) binary NOT NULL default '', `article_description` varchar(255) binary NOT NULL default '', `article_date` varchar(255) binary NOT NULL default '', `article_author_id` mediumint(8) NOT NULL default '0', `username` varchar(255) default NULL, `article_body` text NOT NULL, `article_type` mediumint(8) unsigned NOT NULL default '0', `approved` tinyint(1) unsigned NOT NULL default '0', `topic_id` mediumint(8) unsigned NOT NULL default '0', `views` bigint(8) NOT NULL default '0', `article_rating` double(6,4) NOT NULL default '0.0000', `article_totalvotes` int(255) NOT NULL default '0', KEY `article_id` (`article_id`) )
+++ Successful
* CREATE TABLE `phpbb_kb_categories` ( `category_id` mediumint(8) unsigned NOT NULL auto_increment, `category_name` varchar(255) binary NOT NULL default '', `category_details` varchar(255) binary NOT NULL default '', `number_articles` mediumint(8) unsigned NOT NULL default '0', `parent` mediumint(8) unsigned default NULL, `cat_order` mediumint(8) unsigned NOT NULL default '0', `auth_view` tinyint(3) NOT NULL default '0', `auth_post` tinyint(3) NOT NULL default '0', `auth_rate` tinyint(3) NOT NULL default '0', `auth_comment` tinyint(3) NOT NULL default '0', `auth_edit` tinyint(3) NOT NULL default '0', `auth_delete` tinyint(3) NOT NULL default '2', `auth_approval` tinyint(3) NOT NULL default '0', `auth_approval_edit` tinyint(3) NOT NULL default '0', `auth_view_groups` varchar(255) default NULL, `auth_post_groups` varchar(255) default NULL, `auth_rate_groups` varchar(255) default NULL, `auth_comment_groups` varchar(255) default NULL, `auth_edit_groups` varchar(255) default NULL, `auth_delete_groups` varchar(255) default NULL, `auth_approval_groups` varchar(255) default NULL, `auth_approval_edit_groups` varchar(255) default NULL, `auth_moderator_groups` varchar(255) default NULL, `comments_forum_id` tinyint(3) NOT NULL default '-1', KEY `category_id` (`category_id`) )
+++ Successful
* CREATE TABLE `phpbb_kb_config` ( `config_name` varchar(255) NOT NULL default '', `config_value` varchar(255) NOT NULL default '', PRIMARY KEY (`config_name`) )
+++ Successful
* CREATE TABLE `phpbb_kb_custom` ( `custom_id` int(50) NOT NULL auto_increment, `custom_name` text NOT NULL, `custom_description` text NOT NULL, `data` text NOT NULL, `field_order` int(20) NOT NULL default '0', `field_type` tinyint(2) NOT NULL default '0', `regex` varchar(255) NOT NULL default '', PRIMARY KEY (`custom_id`) )
+++ Successful
* CREATE TABLE `phpbb_kb_customdata` ( `customdata_file` int(50) NOT NULL default '0', `customdata_custom` int(50) NOT NULL default '0', `data` text NOT NULL )
+++ Successful
* CREATE TABLE `phpbb_kb_results` ( `search_id` int(11) unsigned NOT NULL default '0', `session_id` varchar(32) NOT NULL default '', `search_array` text NOT NULL, PRIMARY KEY (`search_id`), KEY `session_id` (`session_id`) )
+++ Successful
* CREATE TABLE `phpbb_kb_search` ( `search_id` int(11) unsigned NOT NULL default '0', `session_id` varchar(32) NOT NULL default '', `search_array` text NOT NULL, PRIMARY KEY (`search_id`), KEY `session_id` (`session_id`) )
+++ Successful
* CREATE TABLE `phpbb_kb_types` ( `id` mediumint(8) unsigned NOT NULL auto_increment, `type` varchar(255) binary NOT NULL default '', KEY `id` (`id`) )
+++ Successful
* CREATE TABLE `phpbb_kb_votes` ( `votes_ip` varchar(50) NOT NULL default '0', `votes_userid` int(50) NOT NULL default '0', `votes_file` int(50) NOT NULL default '0' )
+++ Successful
* CREATE TABLE `phpbb_kb_wordlist` ( `word_text` varchar(50) binary NOT NULL default '', `word_id` mediumint(8) unsigned NOT NULL auto_increment, `word_common` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`word_text`), KEY `word_id` (`word_id`) )
+++ Successful
* CREATE TABLE `phpbb_kb_wordmatch` ( `article_id` mediumint(8) unsigned NOT NULL default '0', `word_id` mediumint(8) unsigned NOT NULL default '0', `title_match` tinyint(1) NOT NULL default '0', KEY `post_id` (`article_id`), KEY `word_id` (`word_id`) )
+++ Successful
* CREATE TABLE `phpbb_link_categories` ( `cat_id` mediumint(8) unsigned NOT NULL auto_increment, `cat_title` varchar(100) NOT NULL default '', `cat_order` mediumint(8) unsigned NOT NULL default '0', PRIMARY KEY (`cat_id`), KEY `cat_order` (`cat_order`) )
+++ Successful
* CREATE TABLE `phpbb_link_config` ( `config_name` varchar(255) NOT NULL default '', `config_value` varchar(255) NOT NULL default '' )
+++ Successful
* CREATE TABLE `phpbb_links` ( `link_id` mediumint(8) unsigned NOT NULL auto_increment, `link_title` varchar(100) NOT NULL default '', `link_desc` varchar(255) default NULL, `link_category` mediumint(8) unsigned NOT NULL default '0', `link_url` varchar(100) NOT NULL default '', `link_logo_src` varchar(120) default NULL, `link_joined` int(11) NOT NULL default '0', `link_active` tinyint(1) NOT NULL default '0', `link_hits` int(10) unsigned NOT NULL default '0', `user_id` mediumint(8) NOT NULL default '0', `user_ip` varchar(8) NOT NULL default '', `last_user_ip` varchar(8) NOT NULL default '', PRIMARY KEY (`link_id`) )
+++ Successful
* CREATE TABLE `phpbb_liw_cache` ( `image_checksum` varchar(32) NOT NULL default '', `image_width` varchar(10) default NULL, `image_height` varchar(10) default NULL, PRIMARY KEY (`image_checksum`) )
+++ Successful
* CREATE TABLE `phpbb_logins` ( `login_id` mediumint(8) unsigned NOT NULL auto_increment, `login_userid` mediumint(8) NOT NULL default '0', `login_ip` varchar(8) NOT NULL default '0', `login_user_agent` varchar(255) NOT NULL default 'n/a', `login_time` int(11) NOT NULL default '0', PRIMARY KEY (`login_id`) )
+++ Successful
* CREATE TABLE `phpbb_news` ( `news_id` mediumint(8) unsigned NOT NULL auto_increment, `news_category` varchar(70) NOT NULL default '', `news_image` varchar(70) NOT NULL default '', PRIMARY KEY (`news_id`) )
+++ Successful
* CREATE TABLE `phpbb_notes` ( `id` int(8) NOT NULL default '0', `text` text )
+++ Successful
* CREATE TABLE `phpbb_pa_auth` ( `group_id` mediumint(8) NOT NULL default '0', `cat_id` smallint(5) unsigned NOT NULL default '0', `auth_view` tinyint(1) NOT NULL default '0', `auth_read` tinyint(1) NOT NULL default '0', `auth_view_file` tinyint(1) NOT NULL default '0', `auth_edit_file` tinyint(1) NOT NULL default '0', `auth_delete_file` tinyint(1) NOT NULL default '0', `auth_upload` tinyint(1) NOT NULL default '0', `auth_download` tinyint(1) NOT NULL default '0', `auth_rate` tinyint(1) NOT NULL default '0', `auth_email` tinyint(1) NOT NULL default '0', `auth_view_comment` tinyint(1) NOT NULL default '0', `auth_post_comment` tinyint(1) NOT NULL default '0', `auth_edit_comment` tinyint(1) NOT NULL default '0', `auth_delete_comment` tinyint(1) NOT NULL default '0', `auth_mod` tinyint(1) NOT NULL default '0', `auth_search` tinyint(1) NOT NULL default '1', `auth_stats` tinyint(1) NOT NULL default '1', `auth_toplist` tinyint(1) NOT NULL default '1', `auth_viewall` tinyint(1) NOT NULL default '1', KEY `group_id` (`group_id`), KEY `cat_id` (`cat_id`) )
+++ Successful
* CREATE TABLE `phpbb_pa_cat` ( `cat_id` int(10) NOT NULL auto_increment, `cat_name` text, `cat_desc` text, `cat_parent` int(50) default NULL, `parents_data` text NOT NULL, `cat_order` int(50) default NULL, `cat_allow_file` tinyint(2) NOT NULL default '0', `cat_allow_ratings` tinyint(2) NOT NULL default '1', `cat_allow_comments` tinyint(2) NOT NULL default '1', `cat_files` mediumint(8) NOT NULL default '-1', `cat_last_file_id` mediumint(8) unsigned NOT NULL default '0', `cat_last_file_name` varchar(255) NOT NULL default '', `cat_last_file_time` int(50) unsigned NOT NULL default '0', `auth_view` tinyint(2) NOT NULL default '0', `auth_read` tinyint(2) NOT NULL default '0', `auth_view_file` tinyint(2) NOT NULL default '0', `auth_edit_file` tinyint(1) NOT NULL default '0', `auth_delete_file` tinyint(1) NOT NULL default '0', `auth_upload` tinyint(2) NOT NULL default '0', `auth_download` tinyint(2) NOT NULL default '0', `auth_rate` tinyint(2) NOT NULL default '0', `auth_email` tinyint(2) NOT NULL default '0', `auth_view_comment` tinyint(2) NOT NULL default '0', `auth_post_comment` tinyint(2) NOT NULL default '0', `auth_edit_comment` tinyint(2) NOT NULL default '0', `auth_delete_comment` tinyint(2) NOT NULL default '0', PRIMARY KEY (`cat_id`) )
+++ Successful
* CREATE TABLE `phpbb_pa_comments` ( `comments_id` int(10) NOT NULL auto_increment, `file_id` int(10) NOT NULL default '0', `comments_text` text NOT NULL, `comments_title` text NOT NULL, `comments_time` int(50) NOT NULL default '0', `poster_id` mediumint(8) NOT NULL default '0', PRIMARY KEY (`comments_id`) )
+++ Successful
* CREATE TABLE `phpbb_pa_config` ( `config_name` varchar(255) NOT NULL default '', `config_value` varchar(255) NOT NULL default '', PRIMARY KEY (`config_name`) )
+++ Successful
* CREATE TABLE `phpbb_pa_custom` ( `custom_id` int(50) NOT NULL auto_increment, `custom_name` text NOT NULL, `custom_description` text NOT NULL, `data` text NOT NULL, `field_order` int(20) NOT NULL default '0', `field_type` tinyint(2) NOT NULL default '0', `regex` varchar(255) NOT NULL default '', PRIMARY KEY (`custom_id`) )
+++ Successful
* CREATE TABLE `phpbb_pa_customdata` ( `customdata_file` int(50) NOT NULL default '0', `customdata_custom` int(50) NOT NULL default '0', `data` text NOT NULL )
+++ Successful
* CREATE TABLE `phpbb_pa_download_info` ( `file_id` mediumint(8) NOT NULL default '0', `user_id` mediumint(8) NOT NULL default '0', `downloader_ip` varchar(8) NOT NULL default '', `downloader_os` varchar(255) NOT NULL default '', `downloader_browser` varchar(255) NOT NULL default '', `browser_version` varchar(255) NOT NULL default '' )
+++ Successful
* CREATE TABLE `phpbb_pa_files` ( `file_id` int(10) NOT NULL auto_increment, `user_id` mediumint(8) NOT NULL default '0', `poster_ip` varchar(8) NOT NULL default '', `file_name` text, `file_size` int(20) NOT NULL default '0', `unique_name` varchar(255) NOT NULL default '', `real_name` varchar(255) NOT NULL default '', `file_dir` varchar(255) NOT NULL default '', `file_desc` text, `file_creator` text, `file_version` text, `file_longdesc` text, `file_ssurl` text, `file_sshot_link` tinyint(2) NOT NULL default '0', `file_dlurl` text, `file_time` int(50) default NULL, `file_update_time` int(50) NOT NULL default '0', `file_catid` int(10) default NULL, `file_posticon` text, `file_license` int(10) default NULL, `file_dls` int(10) default NULL, `file_last` int(50) default NULL, `file_pin` int(2) default NULL, `file_docsurl` text, `file_approved` tinyint(1) NOT NULL default '1', `file_broken` tinyint(1) NOT NULL default '0', PRIMARY KEY (`file_id`) )
+++ Successful
* CREATE TABLE `phpbb_pa_license` ( `license_id` int(10) NOT NULL auto_increment, `license_name` text, `license_text` text, PRIMARY KEY (`license_id`) )
+++ Successful
* CREATE TABLE `phpbb_pa_mirrors` ( `mirror_id` mediumint(8) NOT NULL auto_increment, `file_id` int(10) NOT NULL default '0', `unique_name` varchar(255) NOT NULL default '', `file_dir` varchar(255) NOT NULL default '', `file_dlurl` varchar(255) NOT NULL default '', `mirror_location` varchar(255) NOT NULL default '', PRIMARY KEY (`mirror_id`), KEY `file_id` (`file_id`) )
+++ Successful
* CREATE TABLE `phpbb_pa_votes` ( `user_id` mediumint(8) NOT NULL default '0', `votes_ip` varchar(50) NOT NULL default '0', `votes_file` int(50) NOT NULL default '0', `rate_point` tinyint(3) unsigned NOT NULL default '0', `voter_os` varchar(255) NOT NULL default '', `voter_browser` varchar(255) NOT NULL default '', `browser_version` varchar(8) NOT NULL default '', KEY `user_id` (`user_id`) )
+++ Successful
* ALTER TABLE `phpbb_posts` ADD `post_bluecard` TINYINT(1) DEFAULT NULL
+++ Successful
* CREATE TABLE `phpbb_privmsgs_archive` ( `privmsgs_id` mediumint(8) unsigned NOT NULL auto_increment, `privmsgs_type` tinyint(4) NOT NULL default '0', `privmsgs_subject` varchar(255) NOT NULL default '0', `privmsgs_from_userid` mediumint(8) NOT NULL default '0', `privmsgs_to_userid` mediumint(8) NOT NULL default '0', `privmsgs_date` int(11) NOT NULL default '0', `privmsgs_ip` varchar(8) NOT NULL default '', `privmsgs_enable_bbcode` tinyint(1) NOT NULL default '1', `privmsgs_enable_html` tinyint(1) NOT NULL default '0', `privmsgs_enable_smilies` tinyint(1) NOT NULL default '1', `privmsgs_attach_sig` tinyint(1) NOT NULL default '1', `privmsgs_attachment` tinyint(1) NOT NULL default '0', `privmsgs_enable_autolinks_acronyms` tinyint(1) NOT NULL default '0', PRIMARY KEY (`privmsgs_id`), KEY `privmsgs_from_userid` (`privmsgs_from_userid`), KEY `privmsgs_to_userid` (`privmsgs_to_userid`) )
+++ Successful
* CREATE TABLE `phpbb_profile_view` ( `user_id` mediumint(8) NOT NULL default '0', `viewername` varchar(25) NOT NULL default '', `viewer_id` mediumint(8) NOT NULL default '0', `view_stamp` int(11) NOT NULL default '0', `counter` mediumint(8) NOT NULL default '0' )
+++ Successful
* CREATE TABLE `phpbb_rate_results` ( `rating_id` mediumint(8) unsigned NOT NULL auto_increment, `user_id` mediumint(8) unsigned NOT NULL default '0', `topic_id` mediumint(8) unsigned NOT NULL default '0', `rating` mediumint(8) unsigned NOT NULL default '0', `user_ip` char(8) NOT NULL default '', `rating_time` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`rating_id`), KEY `topic_id` (`topic_id`) )
+++ Successful
* CREATE TABLE `phpbb_referrers` ( `referrer_id` int(11) NOT NULL auto_increment, `referrer_host` varchar(255) NOT NULL default '', `referrer_url` varchar(255) NOT NULL default '', `referrer_ip` varchar(8) NOT NULL default '', `referrer_hits` int(11) NOT NULL default '1', `referrer_firstvisit` int(11) NOT NULL default '0', `referrer_lastvisit` int(11) NOT NULL default '0', PRIMARY KEY (`referrer_id`) )
+++ Successful
* ALTER TABLE `phpbb_sessions` ADD `session_user_agent` VARCHAR(255) NOT NULL
+++ Successful
* CREATE TABLE `phpbb_shout` ( `shout_id` mediumint(8) unsigned NOT NULL auto_increment, `shout_username` varchar(25) NOT NULL default '', `shout_user_id` mediumint(8) NOT NULL default '0', `shout_group_id` mediumint(8) NOT NULL default '0', `shout_session_time` int(11) NOT NULL default '0', `shout_ip` varchar(8) NOT NULL default '', `shout_text` text NOT NULL, `shout_active` mediumint(8) NOT NULL default '0', `enable_bbcode` tinyint(1) NOT NULL default '0', `enable_html` tinyint(1) NOT NULL default '0', `enable_smilies` tinyint(1) NOT NULL default '0', `enable_sig` tinyint(1) NOT NULL default '0', KEY `shout_id` (`shout_id`) )
+++ Successful
* CREATE TABLE `phpbb_site_history` ( `date` int(11) NOT NULL default '0', `reg` mediumint(8) NOT NULL default '0', `hidden` mediumint(8) NOT NULL default '0', `guests` mediumint(8) NOT NULL default '0', `new_topics` mediumint(8) NOT NULL default '0', `new_posts` mediumint(8) NOT NULL default '0', UNIQUE KEY `date` (`date`) )
+++ Successful
* CREATE TABLE `phpbb_stats_config` ( `config_name` varchar(50) NOT NULL default '', `config_value` varchar(255) NOT NULL default '', PRIMARY KEY (`config_name`) )
+++ Successful
* CREATE TABLE `phpbb_stats_modules` ( `module_id` tinyint(8) NOT NULL default '0', `name` varchar(150) NOT NULL default '', `active` tinyint(1) NOT NULL default '0', `installed` tinyint(1) NOT NULL default '0', `display_order` mediumint(8) unsigned NOT NULL default '0', `update_time` mediumint(8) unsigned NOT NULL default '0', `auth_value` tinyint(2) NOT NULL default '0', `module_info_cache` blob, `module_db_cache` blob, `module_result_cache` blob, `module_info_time` int(10) unsigned NOT NULL default '0', `module_cache_time` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`module_id`) )
+++ Successful
* CREATE TABLE `phpbb_thanks` ( `topic_id` mediumint(8) NOT NULL default '0', `user_id` mediumint(8) NOT NULL default '0', `thanks_time` int(11) NOT NULL default '0' )
+++ Successful
* CREATE TABLE `phpbb_title_infos` ( `id` int(11) NOT NULL auto_increment, `title_info` varchar(255) NOT NULL default '', `date_format` varchar(25) default NULL, `admin_auth` tinyint(1) default '0', `mod_auth` tinyint(1) default '0', `poster_auth` tinyint(1) default '0', UNIQUE KEY `id` (`id`) )
+++ Successful
* CREATE TABLE `phpbb_topic_view` ( `topic_id` mediumint(8) NOT NULL default '0', `user_id` mediumint(8) NOT NULL default '0', `view_time` int(11) NOT NULL default '0', `view_count` int(11) NOT NULL default '0' )
+++ Successful
* ALTER TABLE `phpbb_topics` ADD `topic_desc` VARCHAR(255)
+++ Successful
* ALTER TABLE `phpbb_topics` ADD `title_compl_infos` VARCHAR(255) DEFAULT NULL
+++ Successful
* ALTER TABLE `phpbb_topics` ADD `news_id` INT(10) UNSIGNED DEFAULT '0' NOT NULL
+++ Successful
* ALTER TABLE `phpbb_topics` ADD `topic_calendar_time` INT(11) DEFAULT NULL
+++ Successful
* ALTER TABLE `phpbb_topics` ADD `topic_calendar_duration` INT(11) DEFAULT NULL
+++ Successful
* ALTER TABLE `phpbb_topics` ADD `topic_rating` DOUBLE UNSIGNED DEFAULT '0' NOT NULL
+++ Successful
* ALTER TABLE `phpbb_users` ADD `user_http_agents` VARCHAR(255) NOT NULL
+++ Successful
* ALTER TABLE `phpbb_users` ADD `user_rank2` INT(11) DEFAULT '-1'
+++ Successful
* ALTER TABLE `phpbb_users` ADD `user_rank3` INT(11) DEFAULT '-2'
+++ Successful
* ALTER TABLE `phpbb_users` ADD `user_rank4` INT(11) DEFAULT '-2'
+++ Successful
* ALTER TABLE `phpbb_users` ADD `user_rank5` INT(11) DEFAULT '-2'
+++ Successful
* ALTER TABLE `phpbb_users` ADD `ct_search` VARCHAR(10) NOT NULL
+++ Successful
* ALTER TABLE `phpbb_users` ADD `user_birthday` INT(11) DEFAULT '999999' NOT NULL
+++ Successful
* ALTER TABLE `phpbb_users` ADD `user_next_birthday_greeting` INT(11) DEFAULT '0' NOT NULL
+++ Successful
* ALTER TABLE `phpbb_users` ADD `user_sub_forum` TINYINT(1) DEFAULT '1' NOT NULL
+++ Successful
* ALTER TABLE `phpbb_users` ADD `user_split_cat` TINYINT(1) DEFAULT '1' NOT NULL
+++ Successful
* ALTER TABLE `phpbb_users` ADD `user_last_topic_title` TINYINT(1) DEFAULT '1' NOT NULL
+++ Successful
* ALTER TABLE `phpbb_users` ADD `user_sub_level_links` TINYINT(1) DEFAULT '2' NOT NULL
+++ Successful
* ALTER TABLE `phpbb_users` ADD `user_display_viewonline` TINYINT(1) DEFAULT '2' NOT NULL
+++ Successful
* ALTER TABLE `phpbb_users` ADD `user_color_group` MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL
+++ Successful
* ALTER TABLE `phpbb_users` ADD `user_gender` TINYINT(4) DEFAULT '0' NOT NULL
+++ Successful
* ALTER TABLE `phpbb_users` ADD `user_lastlogon` INT(11) DEFAULT '0' NOT NULL
+++ Successful
* ALTER TABLE `phpbb_users` ADD `user_totaltime` INT(11) DEFAULT '0'
+++ Successful
* ALTER TABLE `phpbb_users` ADD `user_totallogon` INT(11) DEFAULT '0'
+++ Successful
* ALTER TABLE `phpbb_users` ADD `user_totalpages` INT(11) DEFAULT '0'
+++ Successful
* ALTER TABLE `phpbb_users` ADD `user_calendar_display_open` TINYINT(1) DEFAULT '0' NOT NULL
+++ Successful
* ALTER TABLE `phpbb_users` ADD `user_calendar_header_cells` TINYINT(1) DEFAULT '0' NOT NULL
+++ Successful
* ALTER TABLE `phpbb_users` ADD `user_calendar_week_start` TINYINT(1) DEFAULT '1' NOT NULL
+++ Successful
* ALTER TABLE `phpbb_users` ADD `user_calendar_nb_row` TINYINT(2) UNSIGNED DEFAULT '5' NOT NULL
+++ Successful
* ALTER TABLE `phpbb_users` ADD `user_calendar_birthday` TINYINT(1) DEFAULT '1' NOT NULL
+++ Successful
* ALTER TABLE `phpbb_users` ADD `user_calendar_forum` TINYINT(1) DEFAULT '1' NOT NULL
+++ Successful
* ALTER TABLE `phpbb_users` ADD `user_warnings` SMALLINT(5) DEFAULT '0'
+++ Successful
* ALTER TABLE `phpbb_users` ADD `user_time_mode` TINYINT(4) DEFAULT '5' NOT NULL
+++ Successful
* ALTER TABLE `phpbb_users` ADD `user_dst_time_lag` TINYINT(4) DEFAULT '60' NOT NULL
+++ Successful
* ALTER TABLE `phpbb_users` ADD `user_pc_timeOffsets` VARCHAR(11) DEFAULT '0' NOT NULL
+++ Successful
* ALTER TABLE `phpbb_users` ADD `user_skype` VARCHAR(255) DEFAULT NULL
+++ Successful
* ALTER TABLE `phpbb_users` ADD `user_registered_ip` VARCHAR(8) DEFAULT NULL
+++ Successful
* ALTER TABLE `phpbb_users` ADD `user_registered_hostname` VARCHAR(255) DEFAULT NULL
+++ Successful
* ALTER TABLE `phpbb_users` ADD `user_profile_view` SMALLINT(5) DEFAULT '0' NOT NULL
+++ Successful
* ALTER TABLE `phpbb_users` ADD `user_last_profile_view` INT(11) DEFAULT '0' NOT NULL
+++ Successful
* ALTER TABLE `phpbb_users` ADD `user_topics_per_page` VARCHAR(5) DEFAULT NULL
+++ Successful
* ALTER TABLE `phpbb_users` ADD `user_hot_threshold` VARCHAR(5) DEFAULT NULL
+++ Successful
* ALTER TABLE `phpbb_users` ADD `user_posts_per_page` VARCHAR(5) DEFAULT NULL
+++ Successful
* ALTER TABLE `phpbb_users` ADD `user_allowswearywords` TINYINT(1) DEFAULT '0' NOT NULL
+++ Successful
* ALTER TABLE `phpbb_users` ADD `user_showavatars` TINYINT(1) DEFAULT '1'
+++ Successful
* ALTER TABLE `phpbb_users` ADD `user_showsignatures` TINYINT(1) DEFAULT '1'
+++ Successful
* ALTER TABLE `phpbb_users` ADD `user_profile_view_popup` TINYINT(1) DEFAULT '0'
+++ Successful
* ALTER TABLE `phpbb_vote_voters` ADD `vote_cast` TINYINT(4) UNSIGNED DEFAULT '0' NOT NULL
+++ Successful
* ALTER TABLE phpbb_users ADD ct_mailcount INT(10) NOT NULL AFTER user_newpasswd
+++ Successful
* ALTER TABLE phpbb_users ADD ct_pwreset INT(2) NOT NULL AFTER user_newpasswd
+++ Successful
* ALTER TABLE phpbb_users ADD ct_unsucclogin INT(10) DEFAULT NULL AFTER user_newpasswd
+++ Successful
* ALTER TABLE phpbb_users ADD ct_logintry INT(2) DEFAULT 0 AFTER user_newpasswd
+++ Successful
* CREATE TABLE phpbb_ct_viskey ( confirm_id char(32) NOT NULL default '', session_id char(32) NOT NULL default '', code char(6) NOT NULL default '', PRIMARY KEY (session_id,confirm_id))
+++ Successful
* CREATE TABLE `phpbb_xs_news` ( `news_id` mediumint(8) unsigned NOT NULL auto_increment, `news_date` int(11) NOT NULL default '0', `news_text` text NOT NULL, `news_display` tinyint(1) NOT NULL default '1', `news_smilies` tinyint(1) NOT NULL default '0', PRIMARY KEY (`news_id`) )
+++ Successful
* CREATE TABLE `phpbb_xs_news_cfg` ( `config_name` varchar(255) NOT NULL default '', `config_value` varchar(255) NOT NULL default '', PRIMARY KEY (`config_name`) )
+++ Successful
* CREATE TABLE `phpbb_xs_news_xml` ( `xml_id` mediumint(8) NOT NULL auto_increment, `xml_title` varchar(255) NOT NULL default '', `xml_show` tinyint(1) NOT NULL default '0', `xml_feed` text NOT NULL, `xml_is_feed` tinyint(1) NOT NULL default '1', `xml_width` varchar(4) NOT NULL default '98%', `xml_height` char(3) NOT NULL default '20', `xml_font` char(3) NOT NULL default '0', `xml_speed` char(2) NOT NULL default '3', `xml_direction` tinyint(1) NOT NULL default '0', PRIMARY KEY (`xml_id`) )
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('max_pics', '1024')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('user_pics_limit', '-1')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('mod_pics_limit', '-1')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('max_file_size', '128000')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('max_width', '1024')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('max_height', '768')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('rows_per_page', '5')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('cols_per_page', '4')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('fullpic_popup', '0')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('thumbnail_quality', '75')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('thumbnail_size', '125')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('thumbnail_cache', '1')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('sort_method', 'pic_time')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('sort_order', 'DESC')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('jpg_allowed', '1')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('png_allowed', '1')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('gif_allowed', '1')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('desc_length', '512')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('hotlink_prevent', '0')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('hotlink_allowed', 'mightygorgon.com,icyphoenix.com')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('personal_gallery', '0')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('personal_gallery_private', '0')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('personal_gallery_limit', '-1')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('personal_gallery_view', '-1')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('rate', '1')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('rate_scale', '10')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('comment', '1')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('gd_version', '2')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('album_version', '.0.56')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('fap_version', '1.2.4')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('show_index_thumb', '0')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('show_index_total_pics', '1')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('show_index_total_comments', '1')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('show_index_comments', '0')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('show_index_last_comment', '1')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('show_index_last_pic', '1')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('show_index_pics', '0')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('show_recent_in_subcats', '1')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('show_recent_instead_of_nopics', '1')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('line_break_subcats', '1')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('show_index_subcats', '1')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('personal_allow_gallery_mod', '0')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('personal_allow_sub_categories', '0')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('personal_sub_category_limit', '-1')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('personal_show_subcats_in_index', '0')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('personal_show_recent_in_subcats', '0')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('personal_show_recent_instead_of_nopics', '0')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('show_personal_gallery_link', '1')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('album_category_sorting', 'cat_order')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('album_category_sorting_direction', 'ASC')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('album_debug_mode', '0')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('show_all_in_personal_gallery', '1')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('new_pic_check_interval', '1M')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('index_enable_supercells', '0')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('email_notification', '1')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('show_download', '2')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('show_slideshow', '1')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('show_pic_size_on_thumb', '1')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('hon_rate_users', '0')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('hon_rate_where', '')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('hon_rate_sep', '1')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('hon_rate_times', '1')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('disp_watermark_at', '3')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('wut_users', '0')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('use_watermark', '0')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('rate_type', '2')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('disp_rand', '1')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('disp_mostv', '1')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('disp_high', '1')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('disp_late', '1')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('img_cols', '4')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('img_rows', '1')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('midthumb_use', '1')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('midthumb_height', '450')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('midthumb_width', '600')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('midthumb_cache', '1')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('max_files_to_upload', '1')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('max_pregenerated_fields', '1')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('dynamic_fields', '1')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('pregenerate_fields', '0')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('propercase_pic_title', '1')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('show_index_last_pic_lv', '0')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('personal_pics_approval', '0')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('show_img_no_gd', '0')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('dynamic_pic_resampling', '1')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('max_file_size_resampling', '1024000')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('switch_nuffload', '0')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('path_to_bin', './cgi-bin/')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('perl_uploader', '1')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('show_progress_bar', '1')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('close_on_finish', '1')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('max_pause', '5')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('simple_format', '0')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('multiple_uploads', '1')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('max_uploads', '5')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('zip_uploads', '1')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('resize_pic', '1')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('resize_width', '600')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('resize_height', '600')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('resize_quality', '70')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('show_pics_nav', '1')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('show_inline_copyright', '0')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('enable_nuffimage', '1')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('enable_sepia_bw', '0')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('personal_allow_avatar_gallery', '1')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('show_gif_mid_thumb', '1')
+++ Successful
* INSERT INTO `phpbb_album_config` VALUES ('slideshow_script', '0')
+++ Successful
* INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('upload_dir','files')
+++ Successful
* INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('upload_img','images/attach_post.png')
+++ Successful
* INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('topic_icon','images/disk_multiple.png')
+++ Successful
* INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('display_order','0')
+++ Successful
* INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('max_filesize','262144')
+++ Successful
* INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('attachment_quota','52428800')
+++ Successful
* INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('max_filesize_pm','262144')
+++ Successful
* INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('max_attachments','3')
+++ Successful
* INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('max_attachments_pm','1')
+++ Successful
* INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('disable_mod','0')
+++ Successful
* INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('allow_pm_attach','1')
+++ Successful
* INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('attachment_topic_review','0')
+++ Successful
* INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('allow_ftp_upload','0')
+++ Successful
* INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('show_apcp','0')
+++ Successful
* INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('attach_version','2.4.0')
+++ Successful
* INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('default_upload_quota', '0')
+++ Successful
* INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('default_pm_quota', '0')
+++ Successful
* INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('ftp_server','')
+++ Successful
* INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('ftp_path','')
+++ Successful
* INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('download_path','')
+++ Successful
* INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('ftp_user','')
+++ Successful
* INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('ftp_pass','')
+++ Successful
* INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('ftp_pasv_mode','1')
+++ Successful
* INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_display_inlined','1')
+++ Successful
* INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_max_width','0')
+++ Successful
* INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_max_height','0')
+++ Successful
* INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_link_width','0')
+++ Successful
* INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_link_height','0')
+++ Successful
* INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_create_thumbnail','0')
+++ Successful
* INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_min_thumb_filesize','12000')
+++ Successful
* INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_imagick', '')
+++ Successful
* INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('use_gd2','0')
+++ Successful
* INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('wma_autoplay','0')
+++ Successful
* INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('flash_autoplay','0')
+++ Successful
* INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (1,'php')
+++ Successful
* INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (2,'php3')
+++ Successful
* INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (3,'php4')
+++ Successful
* INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (4,'phtml')
+++ Successful
* INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (5,'pl')
+++ Successful
* INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (6,'asp')
+++ Successful
* INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (7,'cgi')
+++ Successful
* INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, forum_permissions) VALUES (1,'Images',1,1,1,'',0,'')
+++ Successful
* INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, forum_permissions) VALUES (2,'Archives',0,1,1,'',0,'')
+++ Successful
* INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, forum_permissions) VALUES (3,'Plain Text',0,0,1,'',0,'')
+++ Successful
* INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, forum_permissions) VALUES (4,'Documents',0,0,1,'',0,'')
+++ Successful
* INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, forum_permissions) VALUES (5,'Real Media',0,0,2,'',0,'')
+++ Successful
* INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, forum_permissions) VALUES (6,'Streams',2,0,1,'',0,'')
+++ Successful
* INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, ma 