PHPbb Install script

18 posts / 0 new
Last post
#1 Thu, 09/13/2007 - 12:12
sales@mytechdir...

PHPbb Install script

If this is in the wrong place, please move. I used the install scripts option to install phpbb3 rc5, because I was running it on another site without issue. While I prefer not to use install scripts, since I still have not figured out the ftp problem, I used it and I cannot get access to the ACP. Uninstall and reinstall does not fix.

I get an error saying the module is missing.

Everything else works fine though.

Any hints? I am going to uninstall / reinstall again while I wait for response.

Thu, 09/13/2007 - 12:13
sales@mytechdir...

Exact error,

<div class='quote'>
General Error
Module not accessible
</div>

Thu, 09/13/2007 - 13:44 (Reply to #2)
Joe
Joe's picture

What's in the error_log when you try to browse to the installed script? We'll need to figure out what module it's looking for and get it installed. How that's done will depend on the OS, but there's probably a package for it in the OS standard repository (or ours, if we provided the PHP packages in question).

--

Check out the forum guidelines!

Thu, 09/13/2007 - 16:40 (Reply to #3)
sales@mytechdir...

I guess I am not following your question.

I am using a virtualmin built in script to install phpbb forum software. The module it cannot access is the ACP, Administration Control Panel. The script installs fine. Everything else works correctly too, I just get the above error when trying to access the ACP.

Thu, 09/13/2007 - 16:43 (Reply to #4)
Joe
Joe's picture

Ah, see, the problem is you assume that I know enough about phpBB to know what ACP stands for. I don't. I've never seen phpBB beyond just running the install script and going &quot;yep, looks like it worked&quot;. ;-)

I'll look into it. It's probably a bug in the installer. If so, I'll file a bug about it.

--

Check out the forum guidelines!

Thu, 09/13/2007 - 17:11 (Reply to #5)
sales@mytechdir...

LOL, thanks.

Thu, 09/13/2007 - 19:27
sales@mytechdir...

While I think this is still an issue, I managed to install phpbb3 RC5 via file manager, but my backup database was a MySQL 4 and virtualmin is running version 5. I need to be able to run an mysql updater, but I cannot seem to find the mysql console, do you have it built in to virtualmin?

Thu, 09/13/2007 - 19:44 (Reply to #7)
Joe
Joe's picture

If you have a proper MySQL dump file, you can use the MySQL module in Webmin to import it.

Click on Manage Databases for the domain in question. Click on the Manage.. link beside the database you'd like to import into (or create a new one, if more are permitted for the domain, and you want a new database for this app). Then click &quot;Execute SQL&quot;.

This will bring up a form where you can upload your old dump file, or import it from a file on the server itself.

If you don't have a dump, you'll need to make one on the original MySQL version--as far as I know there is no safe way to upgrade a binary MySQL database file from an old version to a new one without a dump/restore step.

--

Check out the forum guidelines!

Fri, 09/14/2007 - 05:02
sales@mytechdir...

They have written an updater, http://www.phpbb.com/bugs/phpbb3/ticket.php?ticket_id=14401&amp;start=10

Maybe if you see what I am looking at, it may better assist you understanding of what I am trying to do.

Fri, 09/14/2007 - 12:00 (Reply to #9)
Joe
Joe's picture

That is application level stuff. You still need a dump from your MySQL 4 database to do anything with it. You can execute that updater once you've restored into your MySQL 5 database (you'd run it just like you executed the dump file, as documented above).

If you don't have a MySQL 4 dump, you must get one. Binary databases cannot move between major revisions of MySQL. The updater merely updates the database tables for phpBB to work under MySQL 5. That's good to know about, but it definitely doesn't change that you need a dump from MySQL 4, if you want to bring a database over to MySQL 5.

What does you database backup look like? Is it SQL statements? If so, it's a dump. If it looks like binary data (it might be gzipped and tarred, so you'd need to gunzip and extract the tar to know what it actually contains) then it's not a dump and you cannot restore it into MySQL 5 (the data will be corrupt and unusable).

--

Check out the forum guidelines!

Fri, 09/14/2007 - 07:35
sales@mytechdir...

The following is the code I need to have executed on my db to make it compatiable with mysql 5

[code:1]
USE mytechdirect_forum; # Table: 'phpbb_attachments' ALTER TABLE phpbb_attachments MODIFY attach_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY post_msg_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY in_message tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY is_orphan tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY physical_filename varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY real_filename varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY download_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY attach_comment text NOT NULL COLLATE utf8_bin, MODIFY extension varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY mimetype varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY filesize int(20) UNSIGNED DEFAULT '0' NOT NULL, MODIFY filetime int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY thumbnail tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_acl_groups' ALTER TABLE phpbb_acl_groups MODIFY group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY auth_option_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY auth_role_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY auth_setting tinyint(2) DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_acl_options' ALTER TABLE phpbb_acl_options MODIFY auth_option_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY auth_option varchar(50) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY is_global tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY is_local tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY founder_only tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_acl_roles' ALTER TABLE phpbb_acl_roles MODIFY role_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY role_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY role_description text NOT NULL COLLATE utf8_bin, MODIFY role_type varchar(10) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY role_order smallint(4) UNSIGNED DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_acl_roles_data' ALTER TABLE phpbb_acl_roles_data MODIFY role_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY auth_option_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY auth_setting tinyint(2) DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_acl_users' ALTER TABLE phpbb_acl_users MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY auth_option_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY auth_role_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY auth_setting tinyint(2) DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_banlist' ALTER TABLE phpbb_banlist MODIFY ban_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY ban_userid mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY ban_ip varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY ban_email varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY ban_start int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY ban_end int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY ban_exclude tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY ban_reason varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY ban_give_reason varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, DROP INDEX ban_email, ADD KEY ban_email (ban_email, ban_exclude), DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_bbcodes' ALTER TABLE phpbb_bbcodes MODIFY bbcode_id tinyint(3) DEFAULT '0' NOT NULL, MODIFY bbcode_tag varchar(16) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY bbcode_helpline varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY display_on_posting tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY bbcode_match text NOT NULL COLLATE utf8_bin, MODIFY bbcode_tpl mediumtext NOT NULL COLLATE utf8_bin, MODIFY first_pass_match mediumtext NOT NULL COLLATE utf8_bin, MODIFY first_pass_replace mediumtext NOT NULL COLLATE utf8_bin, MODIFY second_pass_match mediumtext NOT NULL COLLATE utf8_bin, MODIFY second_pass_replace mediumtext NOT NULL COLLATE utf8_bin, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_bookmarks' ALTER TABLE phpbb_bookmarks MODIFY topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_bots' ALTER TABLE phpbb_bots MODIFY bot_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY bot_active tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY bot_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY bot_agent varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY bot_ip varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_config' ALTER TABLE phpbb_config MODIFY config_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY config_value varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY is_dynamic tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_confirm' ALTER TABLE phpbb_confirm MODIFY confirm_id char(32) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY session_id char(32) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY confirm_type tinyint(3) DEFAULT '0' NOT NULL, MODIFY code varchar(8) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY seed int(10) UNSIGNED DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_disallow' ALTER TABLE phpbb_disallow MODIFY disallow_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY disallow_username varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_drafts' ALTER TABLE phpbb_drafts MODIFY draft_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY save_time int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY draft_subject varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY draft_message mediumtext NOT NULL COLLATE utf8_bin, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_extensions' ALTER TABLE phpbb_extensions MODIFY extension_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY extension varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_extension_groups' ALTER TABLE phpbb_extension_groups MODIFY group_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY group_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY cat_id tinyint(2) DEFAULT '0' NOT NULL, MODIFY allow_group tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY download_mode tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY upload_icon varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY max_filesize int(20) UNSIGNED DEFAULT '0' NOT NULL, MODIFY allowed_forums text NOT NULL COLLATE utf8_bin, MODIFY allow_in_pm tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_forums' ALTER TABLE phpbb_forums MODIFY forum_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY parent_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY left_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY right_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY forum_parents mediumtext NOT NULL COLLATE utf8_bin, MODIFY forum_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY forum_desc text NOT NULL COLLATE utf8_bin, MODIFY forum_desc_bitfield varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY forum_desc_options int(11) UNSIGNED DEFAULT '7' NOT NULL, MODIFY forum_desc_uid varchar(5) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY forum_link varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY forum_password varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY forum_style smallint(4) UNSIGNED DEFAULT '0' NOT NULL, MODIFY forum_image varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY forum_rules text NOT NULL COLLATE utf8_bin, MODIFY forum_rules_link varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY forum_rules_bitfield varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY forum_rules_options int(11) UNSIGNED DEFAULT '7' NOT NULL, MODIFY forum_rules_uid varchar(5) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY forum_topics_per_page tinyint(4) DEFAULT '0' NOT NULL, MODIFY forum_type tinyint(4) DEFAULT '0' NOT NULL, MODIFY forum_status tinyint(4) DEFAULT '0' NOT NULL, MODIFY forum_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY forum_topics mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY forum_topics_real mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY forum_last_post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY forum_last_poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY forum_last_post_subject varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY forum_last_post_time int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY forum_last_poster_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY forum_last_poster_colour varchar(6) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY forum_flags tinyint(4) DEFAULT '32' NOT NULL, MODIFY display_on_index tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY enable_indexing tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY enable_icons tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY enable_prune tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY prune_next int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY prune_days mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY prune_viewed mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY prune_freq mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_forums_access' ALTER TABLE phpbb_forums_access MODIFY forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY session_id char(32) DEFAULT '' NOT NULL COLLATE utf8_bin, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_forums_track' ALTER TABLE phpbb_forums_track MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY mark_time int(11) UNSIGNED DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_forums_watch' ALTER TABLE phpbb_forums_watch MODIFY forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY notify_status tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_groups' ALTER TABLE phpbb_groups MODIFY group_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY group_type tinyint(4) DEFAULT '1' NOT NULL, MODIFY group_founder_manage tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY group_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY group_desc text NOT NULL COLLATE utf8_bin, MODIFY group_desc_bitfield varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY group_desc_options int(11) UNSIGNED DEFAULT '7' NOT NULL, MODIFY group_desc_uid varchar(5) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY group_display tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY group_avatar varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY group_avatar_type tinyint(2) DEFAULT '0' NOT NULL, MODIFY group_avatar_width smallint(4) UNSIGNED DEFAULT '0' NOT NULL, MODIFY group_avatar_height smallint(4) UNSIGNED DEFAULT '0' NOT NULL, MODIFY group_rank mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY group_colour varchar(6) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY group_sig_chars mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY group_receive_pm tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY group_message_limit mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY group_legend tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_icons' ALTER TABLE phpbb_icons MODIFY icons_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY icons_url varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY icons_width tinyint(4) DEFAULT '0' NOT NULL, MODIFY icons_height tinyint(4) DEFAULT '0' NOT NULL, MODIFY icons_order mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY display_on_posting tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_lang' ALTER TABLE phpbb_lang MODIFY lang_id tinyint(4) NOT NULL auto_increment, MODIFY lang_iso varchar(30) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY lang_dir varchar(30) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY lang_english_name varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY lang_local_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY lang_author varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_log' ALTER TABLE phpbb_log MODIFY log_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY log_type tinyint(4) DEFAULT '0' NOT NULL, MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY reportee_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY log_ip varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY log_time int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY log_operation text NOT NULL COLLATE utf8_bin, MODIFY log_data mediumtext NOT NULL COLLATE utf8_bin, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_moderator_cache' ALTER TABLE phpbb_moderator_cache MODIFY forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY username varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY group_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY display_on_index tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_modules' ALTER TABLE phpbb_modules MODIFY module_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY module_enabled tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY module_display tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY module_basename varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY module_class varchar(10) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY parent_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY left_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY right_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY module_langname varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY module_mode varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY module_auth varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_poll_options' ALTER TABLE phpbb_poll_options MODIFY poll_option_id tinyint(4) DEFAULT '0' NOT NULL, MODIFY topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY poll_option_text text NOT NULL COLLATE utf8_bin, MODIFY poll_option_total mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_poll_votes' ALTER TABLE phpbb_poll_votes MODIFY topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY poll_option_id tinyint(4) DEFAULT '0' NOT NULL, MODIFY vote_user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY vote_user_ip varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_posts' ALTER TABLE phpbb_posts MODIFY post_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY icon_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY poster_ip varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY post_time int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY post_approved tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY post_reported tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY enable_bbcode tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY enable_smilies tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY enable_magic_url tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY enable_sig tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY post_username varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY post_subject varchar(100) DEFAULT '' NOT NULL COLLATE utf8_unicode_ci, MODIFY post_text mediumtext NOT NULL COLLATE utf8_unicode_ci, MODIFY post_checksum varchar(32) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY post_attachment tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY bbcode_bitfield varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY bbcode_uid varchar(5) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY post_postcount tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY post_edit_time int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY post_edit_reason varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY post_edit_user mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY post_edit_count smallint(4) UNSIGNED DEFAULT '0' NOT NULL, MODIFY post_edit_locked tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_privmsgs' ALTER TABLE phpbb_privmsgs MODIFY msg_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY root_level mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY author_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY icon_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY author_ip varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY message_time int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY enable_bbcode tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY enable_smilies tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY enable_magic_url tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY enable_sig tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY message_subject varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY message_text mediumtext NOT NULL COLLATE utf8_bin, MODIFY message_edit_reason varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY message_edit_user mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY message_attachment tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY bbcode_bitfield varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY bbcode_uid varchar(5) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY message_edit_time int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY message_edit_count smallint(4) UNSIGNED DEFAULT '0' NOT NULL, MODIFY to_address text NOT NULL COLLATE utf8_bin, MODIFY bcc_address text NOT NULL COLLATE utf8_bin, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_privmsgs_folder' ALTER TABLE phpbb_privmsgs_folder MODIFY folder_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY folder_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY pm_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_privmsgs_rules' ALTER TABLE phpbb_privmsgs_rules MODIFY rule_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY rule_check mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY rule_connection mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY rule_string varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY rule_user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY rule_group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY rule_action mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY rule_folder_id int(11) DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_privmsgs_to' ALTER TABLE phpbb_privmsgs_to MODIFY msg_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY author_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY pm_deleted tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY pm_new tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY pm_unread tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY pm_replied tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY pm_marked tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY pm_forwarded tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY folder_id int(11) DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_profile_fields' ALTER TABLE phpbb_profile_fields MODIFY field_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY field_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY field_type tinyint(4) DEFAULT '0' NOT NULL, MODIFY field_ident varchar(20) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY field_length varchar(20) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY field_minlen varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY field_maxlen varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY field_novalue varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY field_default_value varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY field_validation varchar(20) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY field_required tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY field_show_on_reg tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY field_hide tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY field_no_view tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY field_active tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY field_order mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_profile_fields_data' ALTER TABLE phpbb_profile_fields_data MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_profile_fields_lang' ALTER TABLE phpbb_profile_fields_lang MODIFY field_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY lang_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY option_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY field_type tinyint(4) DEFAULT '0' NOT NULL, MODIFY lang_value varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_profile_lang' ALTER TABLE phpbb_profile_lang MODIFY field_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY lang_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY lang_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY lang_explain text NOT NULL COLLATE utf8_bin, MODIFY lang_default_value varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_ranks' ALTER TABLE phpbb_ranks MODIFY rank_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY rank_title varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY rank_min mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY rank_special tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY rank_image varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_reports' ALTER TABLE phpbb_reports MODIFY report_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY reason_id smallint(4) UNSIGNED DEFAULT '0' NOT NULL, MODIFY post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_notify tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY report_closed tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY report_time int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY report_text mediumtext NOT NULL COLLATE utf8_bin, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_reports_reasons' ALTER TABLE phpbb_reports_reasons MODIFY reason_id smallint(4) UNSIGNED NOT NULL auto_increment, MODIFY reason_title varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY reason_description mediumtext NOT NULL COLLATE utf8_bin, MODIFY reason_order smallint(4) UNSIGNED DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_search_results' ALTER TABLE phpbb_search_results MODIFY search_key varchar(32) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY search_time int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY search_keywords mediumtext NOT NULL COLLATE utf8_bin, MODIFY search_authors mediumtext NOT NULL COLLATE utf8_bin, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_search_wordlist' ALTER TABLE phpbb_search_wordlist MODIFY word_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY word_text varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY word_common tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY word_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, DROP INDEX wrd_txt, ADD UNIQUE wrd_txt (word_text), DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_search_wordmatch' ALTER TABLE phpbb_search_wordmatch MODIFY post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY word_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY title_match tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_sessions' ALTER TABLE phpbb_sessions MODIFY session_id char(32) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY session_user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY session_last_visit int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY session_start int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY session_time int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY session_ip varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY session_browser varchar(150) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY session_forwarded_for varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY session_page varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY session_viewonline tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY session_autologin tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY session_admin tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_sessions_keys' ALTER TABLE phpbb_sessions_keys MODIFY key_id char(32) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY last_ip varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY last_login int(11) UNSIGNED DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_sitelist' ALTER TABLE phpbb_sitelist MODIFY site_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY site_ip varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY site_hostname varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY ip_exclude tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_smilies' ALTER TABLE phpbb_smilies MODIFY smiley_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY code varchar(50) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY emotion varchar(50) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY smiley_url varchar(50) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY smiley_width smallint(4) UNSIGNED DEFAULT '0' NOT NULL, MODIFY smiley_height smallint(4) UNSIGNED DEFAULT '0' NOT NULL, MODIFY smiley_order mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY display_on_posting tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_styles' ALTER TABLE phpbb_styles MODIFY style_id smallint(4) UNSIGNED NOT NULL auto_increment, MODIFY style_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY style_copyright varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY style_active tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY template_id smallint(4) UNSIGNED DEFAULT '0' NOT NULL, MODIFY theme_id smallint(4) UNSIGNED DEFAULT '0' NOT NULL, MODIFY imageset_id smallint(4) UNSIGNED DEFAULT '0' NOT NULL, DROP INDEX style_name, ADD UNIQUE style_name (style_name), DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_styles_template' ALTER TABLE phpbb_styles_template MODIFY template_id smallint(4) UNSIGNED NOT NULL auto_increment, MODIFY template_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY template_copyright varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY template_path varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY bbcode_bitfield varchar(255) DEFAULT 'kNg=' NOT NULL COLLATE utf8_bin, MODIFY template_storedb tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, DROP INDEX tmplte_nm, ADD UNIQUE tmplte_nm (template_name), DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_styles_template_data' ALTER TABLE phpbb_styles_template_data MODIFY template_id smallint(4) UNSIGNED DEFAULT '0' NOT NULL, MODIFY template_filename varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY template_included text NOT NULL COLLATE utf8_bin, MODIFY template_mtime int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY template_data mediumtext NOT NULL COLLATE utf8_bin, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_styles_theme' ALTER TABLE phpbb_styles_theme MODIFY theme_id smallint(4) UNSIGNED NOT NULL auto_increment, MODIFY theme_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY theme_copyright varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY theme_path varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY theme_storedb tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY theme_mtime int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY theme_data mediumtext NOT NULL COLLATE utf8_bin, DROP INDEX theme_name, ADD UNIQUE theme_name (theme_name), DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_styles_imageset' ALTER TABLE phpbb_styles_imageset MODIFY imageset_id smallint(4) UNSIGNED NOT NULL auto_increment, MODIFY imageset_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY imageset_copyright varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY imageset_path varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin, DROP INDEX imgset_nm, ADD UNIQUE imgset_nm (imageset_name), DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_styles_imageset_data' ALTER TABLE phpbb_styles_imageset_data MODIFY image_id smallint(4) UNSIGNED NOT NULL auto_increment, MODIFY image_name varchar(200) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY image_filename varchar(200) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY image_lang varchar(30) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY image_height smallint(4) UNSIGNED DEFAULT '0' NOT NULL, MODIFY image_width smallint(4) UNSIGNED DEFAULT '0' NOT NULL, MODIFY imageset_id smallint(4) UNSIGNED DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_topics' ALTER TABLE phpbb_topics MODIFY topic_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY icon_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY topic_attachment tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY topic_approved tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY topic_reported tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY topic_title varchar(100) DEFAULT '' NOT NULL COLLATE utf8_unicode_ci, MODIFY topic_poster mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY topic_time int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY topic_time_limit int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY topic_views mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY topic_replies mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY topic_replies_real mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY topic_status tinyint(3) DEFAULT '0' NOT NULL, MODIFY topic_type tinyint(3) DEFAULT '0' NOT NULL, MODIFY topic_first_post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY topic_first_poster_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY topic_first_poster_colour varchar(6) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY topic_last_post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY topic_last_poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY topic_last_poster_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY topic_last_poster_colour varchar(6) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY topic_last_post_subject varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY topic_last_post_time int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY topic_last_view_time int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY topic_moved_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY topic_bumped tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY topic_bumper mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY poll_title varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY poll_start int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY poll_length int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY poll_max_options tinyint(4) DEFAULT '1' NOT NULL, MODIFY poll_last_vote int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY poll_vote_change tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_topics_track' ALTER TABLE phpbb_topics_track MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY mark_time int(11) UNSIGNED DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_topics_posted' ALTER TABLE phpbb_topics_posted MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY topic_posted tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_topics_watch' ALTER TABLE phpbb_topics_watch MODIFY topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY notify_status tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_user_group' ALTER TABLE phpbb_user_group MODIFY group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY group_leader tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_pending tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_users' ALTER TABLE phpbb_users MODIFY user_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY user_type tinyint(2) DEFAULT '0' NOT NULL, MODIFY group_id mediumint(8) UNSIGNED DEFAULT '3' NOT NULL, MODIFY user_permissions mediumtext NOT NULL COLLATE utf8_bin, MODIFY user_perm_from mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_ip varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_regdate int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY username varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY username_clean varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_password varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_passchg int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_pass_convert tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_email varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_email_hash bigint(20) DEFAULT '0' NOT NULL, MODIFY user_birthday varchar(10) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_lastvisit int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_lastmark int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_lastpost_time int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_lastpage varchar(200) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_last_confirm_key varchar(10) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_last_search int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_warnings tinyint(4) DEFAULT '0' NOT NULL, MODIFY user_last_warning int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_login_attempts tinyint(4) DEFAULT '0' NOT NULL, MODIFY user_inactive_reason tinyint(2) DEFAULT '0' NOT NULL, MODIFY user_inactive_time int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_lang varchar(30) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_timezone decimal(5,2) DEFAULT '0' NOT NULL, MODIFY user_dst tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_dateformat varchar(30) DEFAULT 'd M Y H:i' NOT NULL COLLATE utf8_bin, MODIFY user_style smallint(4) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_rank mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_colour varchar(6) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_new_privmsg tinyint(4) DEFAULT '0' NOT NULL, MODIFY user_unread_privmsg tinyint(4) DEFAULT '0' NOT NULL, MODIFY user_last_privmsg int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_message_rules tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_full_folder int(11) DEFAULT '-3' NOT NULL, MODIFY user_emailtime int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_topic_show_days smallint(4) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_topic_sortby_type varchar(1) DEFAULT 't' NOT NULL COLLATE utf8_bin, MODIFY user_topic_sortby_dir varchar(1) DEFAULT 'd' NOT NULL COLLATE utf8_bin, MODIFY user_post_show_days smallint(4) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_post_sortby_type varchar(1) DEFAULT 't' NOT NULL COLLATE utf8_bin, MODIFY user_post_sortby_dir varchar(1) DEFAULT 'a' NOT NULL COLLATE utf8_bin, MODIFY user_notify tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_notify_pm tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY user_notify_type tinyint(4) DEFAULT '0' NOT NULL, MODIFY user_allow_pm tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY user_allow_viewonline tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY user_allow_viewemail tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY user_allow_massemail tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY user_options int(11) UNSIGNED DEFAULT '895' NOT NULL, MODIFY user_avatar varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_avatar_type tinyint(2) DEFAULT '0' NOT NULL, MODIFY user_avatar_width smallint(4) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_avatar_height smallint(4) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_sig mediumtext NOT NULL COLLATE utf8_bin, MODIFY user_sig_bbcode_uid varchar(5) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_sig_bbcode_bitfield varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_from varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_icq varchar(15) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_aim varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_yim varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_msnm varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_jabber varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_website varchar(200) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_occ text NOT NULL COLLATE utf8_bin, MODIFY user_interests text NOT NULL COLLATE utf8_bin, MODIFY user_actkey varchar(32) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_newpasswd varchar(32) DEFAULT '' NOT NULL COLLATE utf8_bin, DROP INDEX username_clean, ADD UNIQUE username_clean (username_clean), DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_warnings' ALTER TABLE phpbb_warnings MODIFY warning_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY log_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY warning_time int(11) UNSIGNED DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_words' ALTER TABLE phpbb_words MODIFY word_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY word varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY replacement varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_zebra' ALTER TABLE phpbb_zebra MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY zebra_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY friend tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY foe tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
[/code:1]

Fri, 09/14/2007 - 07:36
sales@mytechdir...

I guess code tags are messed up?

USE mytechdirect_forum; # Table: 'phpbb_attachments' ALTER TABLE phpbb_attachments MODIFY attach_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY post_msg_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY in_message tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY is_orphan tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY physical_filename varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY real_filename varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY download_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY attach_comment text NOT NULL COLLATE utf8_bin, MODIFY extension varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY mimetype varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY filesize int(20) UNSIGNED DEFAULT '0' NOT NULL, MODIFY filetime int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY thumbnail tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_acl_groups' ALTER TABLE phpbb_acl_groups MODIFY group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY auth_option_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY auth_role_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY auth_setting tinyint(2) DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_acl_options' ALTER TABLE phpbb_acl_options MODIFY auth_option_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY auth_option varchar(50) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY is_global tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY is_local tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY founder_only tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_acl_roles' ALTER TABLE phpbb_acl_roles MODIFY role_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY role_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY role_description text NOT NULL COLLATE utf8_bin, MODIFY role_type varchar(10) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY role_order smallint(4) UNSIGNED DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_acl_roles_data' ALTER TABLE phpbb_acl_roles_data MODIFY role_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY auth_option_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY auth_setting tinyint(2) DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_acl_users' ALTER TABLE phpbb_acl_users MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY auth_option_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY auth_role_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY auth_setting tinyint(2) DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_banlist' ALTER TABLE phpbb_banlist MODIFY ban_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY ban_userid mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY ban_ip varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY ban_email varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY ban_start int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY ban_end int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY ban_exclude tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY ban_reason varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY ban_give_reason varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, DROP INDEX ban_email, ADD KEY ban_email (ban_email, ban_exclude), DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_bbcodes' ALTER TABLE phpbb_bbcodes MODIFY bbcode_id tinyint(3) DEFAULT '0' NOT NULL, MODIFY bbcode_tag varchar(16) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY bbcode_helpline varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY display_on_posting tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY bbcode_match text NOT NULL COLLATE utf8_bin, MODIFY bbcode_tpl mediumtext NOT NULL COLLATE utf8_bin, MODIFY first_pass_match mediumtext NOT NULL COLLATE utf8_bin, MODIFY first_pass_replace mediumtext NOT NULL COLLATE utf8_bin, MODIFY second_pass_match mediumtext NOT NULL COLLATE utf8_bin, MODIFY second_pass_replace mediumtext NOT NULL COLLATE utf8_bin, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_bookmarks' ALTER TABLE phpbb_bookmarks MODIFY topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_bots' ALTER TABLE phpbb_bots MODIFY bot_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY bot_active tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY bot_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY bot_agent varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY bot_ip varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_config' ALTER TABLE phpbb_config MODIFY config_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY config_value varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY is_dynamic tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_confirm' ALTER TABLE phpbb_confirm MODIFY confirm_id char(32) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY session_id char(32) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY confirm_type tinyint(3) DEFAULT '0' NOT NULL, MODIFY code varchar(8) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY seed int(10) UNSIGNED DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_disallow' ALTER TABLE phpbb_disallow MODIFY disallow_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY disallow_username varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_drafts' ALTER TABLE phpbb_drafts MODIFY draft_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY save_time int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY draft_subject varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY draft_message mediumtext NOT NULL COLLATE utf8_bin, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_extensions' ALTER TABLE phpbb_extensions MODIFY extension_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY extension varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_extension_groups' ALTER TABLE phpbb_extension_groups MODIFY group_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY group_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY cat_id tinyint(2) DEFAULT '0' NOT NULL, MODIFY allow_group tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY download_mode tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY upload_icon varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY max_filesize int(20) UNSIGNED DEFAULT '0' NOT NULL, MODIFY allowed_forums text NOT NULL COLLATE utf8_bin, MODIFY allow_in_pm tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_forums' ALTER TABLE phpbb_forums MODIFY forum_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY parent_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY left_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY right_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY forum_parents mediumtext NOT NULL COLLATE utf8_bin, MODIFY forum_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY forum_desc text NOT NULL COLLATE utf8_bin, MODIFY forum_desc_bitfield varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY forum_desc_options int(11) UNSIGNED DEFAULT '7' NOT NULL, MODIFY forum_desc_uid varchar(5) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY forum_link varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY forum_password varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY forum_style smallint(4) UNSIGNED DEFAULT '0' NOT NULL, MODIFY forum_image varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY forum_rules text NOT NULL COLLATE utf8_bin, MODIFY forum_rules_link varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY forum_rules_bitfield varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY forum_rules_options int(11) UNSIGNED DEFAULT '7' NOT NULL, MODIFY forum_rules_uid varchar(5) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY forum_topics_per_page tinyint(4) DEFAULT '0' NOT NULL, MODIFY forum_type tinyint(4) DEFAULT '0' NOT NULL, MODIFY forum_status tinyint(4) DEFAULT '0' NOT NULL, MODIFY forum_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY forum_topics mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY forum_topics_real mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY forum_last_post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY forum_last_poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY forum_last_post_subject varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY forum_last_post_time int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY forum_last_poster_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY forum_last_poster_colour varchar(6) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY forum_flags tinyint(4) DEFAULT '32' NOT NULL, MODIFY display_on_index tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY enable_indexing tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY enable_icons tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY enable_prune tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY prune_next int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY prune_days mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY prune_viewed mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY prune_freq mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_forums_access' ALTER TABLE phpbb_forums_access MODIFY forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY session_id char(32) DEFAULT '' NOT NULL COLLATE utf8_bin, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_forums_track' ALTER TABLE phpbb_forums_track MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY mark_time int(11) UNSIGNED DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_forums_watch' ALTER TABLE phpbb_forums_watch MODIFY forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY notify_status tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_groups' ALTER TABLE phpbb_groups MODIFY group_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY group_type tinyint(4) DEFAULT '1' NOT NULL, MODIFY group_founder_manage tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY group_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY group_desc text NOT NULL COLLATE utf8_bin, MODIFY group_desc_bitfield varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY group_desc_options int(11) UNSIGNED DEFAULT '7' NOT NULL, MODIFY group_desc_uid varchar(5) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY group_display tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY group_avatar varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY group_avatar_type tinyint(2) DEFAULT '0' NOT NULL, MODIFY group_avatar_width smallint(4) UNSIGNED DEFAULT '0' NOT NULL, MODIFY group_avatar_height smallint(4) UNSIGNED DEFAULT '0' NOT NULL, MODIFY group_rank mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY group_colour varchar(6) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY group_sig_chars mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY group_receive_pm tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY group_message_limit mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY group_legend tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_icons' ALTER TABLE phpbb_icons MODIFY icons_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY icons_url varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY icons_width tinyint(4) DEFAULT '0' NOT NULL, MODIFY icons_height tinyint(4) DEFAULT '0' NOT NULL, MODIFY icons_order mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY display_on_posting tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_lang' ALTER TABLE phpbb_lang MODIFY lang_id tinyint(4) NOT NULL auto_increment, MODIFY lang_iso varchar(30) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY lang_dir varchar(30) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY lang_english_name varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY lang_local_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY lang_author varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_log' ALTER TABLE phpbb_log MODIFY log_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY log_type tinyint(4) DEFAULT '0' NOT NULL, MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY reportee_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY log_ip varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY log_time int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY log_operation text NOT NULL COLLATE utf8_bin, MODIFY log_data mediumtext NOT NULL COLLATE utf8_bin, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_moderator_cache' ALTER TABLE phpbb_moderator_cache MODIFY forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY username varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY group_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY display_on_index tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_modules' ALTER TABLE phpbb_modules MODIFY module_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY module_enabled tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY module_display tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY module_basename varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY module_class varchar(10) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY parent_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY left_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY right_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY module_langname varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY module_mode varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY module_auth varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_poll_options' ALTER TABLE phpbb_poll_options MODIFY poll_option_id tinyint(4) DEFAULT '0' NOT NULL, MODIFY topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY poll_option_text text NOT NULL COLLATE utf8_bin, MODIFY poll_option_total mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_poll_votes' ALTER TABLE phpbb_poll_votes MODIFY topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY poll_option_id tinyint(4) DEFAULT '0' NOT NULL, MODIFY vote_user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY vote_user_ip varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_posts' ALTER TABLE phpbb_posts MODIFY post_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY icon_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY poster_ip varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY post_time int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY post_approved tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY post_reported tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY enable_bbcode tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY enable_smilies tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY enable_magic_url tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY enable_sig tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY post_username varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY post_subject varchar(100) DEFAULT '' NOT NULL COLLATE utf8_unicode_ci, MODIFY post_text mediumtext NOT NULL COLLATE utf8_unicode_ci, MODIFY post_checksum varchar(32) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY post_attachment tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY bbcode_bitfield varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY bbcode_uid varchar(5) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY post_postcount tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY post_edit_time int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY post_edit_reason varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY post_edit_user mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY post_edit_count smallint(4) UNSIGNED DEFAULT '0' NOT NULL, MODIFY post_edit_locked tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_privmsgs' ALTER TABLE phpbb_privmsgs MODIFY msg_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY root_level mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY author_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY icon_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY author_ip varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY message_time int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY enable_bbcode tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY enable_smilies tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY enable_magic_url tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY enable_sig tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY message_subject varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY message_text mediumtext NOT NULL COLLATE utf8_bin, MODIFY message_edit_reason varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY message_edit_user mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY message_attachment tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY bbcode_bitfield varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY bbcode_uid varchar(5) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY message_edit_time int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY message_edit_count smallint(4) UNSIGNED DEFAULT '0' NOT NULL, MODIFY to_address text NOT NULL COLLATE utf8_bin, MODIFY bcc_address text NOT NULL COLLATE utf8_bin, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_privmsgs_folder' ALTER TABLE phpbb_privmsgs_folder MODIFY folder_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY folder_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY pm_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_privmsgs_rules' ALTER TABLE phpbb_privmsgs_rules MODIFY rule_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY rule_check mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY rule_connection mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY rule_string varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY rule_user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY rule_group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY rule_action mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY rule_folder_id int(11) DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_privmsgs_to' ALTER TABLE phpbb_privmsgs_to MODIFY msg_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY author_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY pm_deleted tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY pm_new tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY pm_unread tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY pm_replied tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY pm_marked tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY pm_forwarded tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY folder_id int(11) DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_profile_fields' ALTER TABLE phpbb_profile_fields MODIFY field_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY field_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY field_type tinyint(4) DEFAULT '0' NOT NULL, MODIFY field_ident varchar(20) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY field_length varchar(20) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY field_minlen varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY field_maxlen varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY field_novalue varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY field_default_value varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY field_validation varchar(20) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY field_required tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY field_show_on_reg tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY field_hide tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY field_no_view tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY field_active tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY field_order mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_profile_fields_data' ALTER TABLE phpbb_profile_fields_data MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_profile_fields_lang' ALTER TABLE phpbb_profile_fields_lang MODIFY field_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY lang_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY option_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY field_type tinyint(4) DEFAULT '0' NOT NULL, MODIFY lang_value varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_profile_lang' ALTER TABLE phpbb_profile_lang MODIFY field_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY lang_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY lang_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY lang_explain text NOT NULL COLLATE utf8_bin, MODIFY lang_default_value varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_ranks' ALTER TABLE phpbb_ranks MODIFY rank_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY rank_title varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY rank_min mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY rank_special tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY rank_image varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_reports' ALTER TABLE phpbb_reports MODIFY report_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY reason_id smallint(4) UNSIGNED DEFAULT '0' NOT NULL, MODIFY post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_notify tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY report_closed tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY report_time int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY report_text mediumtext NOT NULL COLLATE utf8_bin, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_reports_reasons' ALTER TABLE phpbb_reports_reasons MODIFY reason_id smallint(4) UNSIGNED NOT NULL auto_increment, MODIFY reason_title varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY reason_description mediumtext NOT NULL COLLATE utf8_bin, MODIFY reason_order smallint(4) UNSIGNED DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_search_results' ALTER TABLE phpbb_search_results MODIFY search_key varchar(32) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY search_time int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY search_keywords mediumtext NOT NULL COLLATE utf8_bin, MODIFY search_authors mediumtext NOT NULL COLLATE utf8_bin, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_search_wordlist' ALTER TABLE phpbb_search_wordlist MODIFY word_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY word_text varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY word_common tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY word_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, DROP INDEX wrd_txt, ADD UNIQUE wrd_txt (word_text), DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_search_wordmatch' ALTER TABLE phpbb_search_wordmatch MODIFY post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY word_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY title_match tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_sessions' ALTER TABLE phpbb_sessions MODIFY session_id char(32) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY session_user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY session_last_visit int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY session_start int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY session_time int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY session_ip varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY session_browser varchar(150) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY session_forwarded_for varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY session_page varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY session_viewonline tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY session_autologin tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY session_admin tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_sessions_keys' ALTER TABLE phpbb_sessions_keys MODIFY key_id char(32) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY last_ip varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY last_login int(11) UNSIGNED DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_sitelist' ALTER TABLE phpbb_sitelist MODIFY site_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY site_ip varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY site_hostname varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY ip_exclude tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_smilies' ALTER TABLE phpbb_smilies MODIFY smiley_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY code varchar(50) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY emotion varchar(50) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY smiley_url varchar(50) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY smiley_width smallint(4) UNSIGNED DEFAULT '0' NOT NULL, MODIFY smiley_height smallint(4) UNSIGNED DEFAULT '0' NOT NULL, MODIFY smiley_order mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY display_on_posting tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_styles' ALTER TABLE phpbb_styles MODIFY style_id smallint(4) UNSIGNED NOT NULL auto_increment, MODIFY style_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY style_copyright varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY style_active tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY template_id smallint(4) UNSIGNED DEFAULT '0' NOT NULL, MODIFY theme_id smallint(4) UNSIGNED DEFAULT '0' NOT NULL, MODIFY imageset_id smallint(4) UNSIGNED DEFAULT '0' NOT NULL, DROP INDEX style_name, ADD UNIQUE style_name (style_name), DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_styles_template' ALTER TABLE phpbb_styles_template MODIFY template_id smallint(4) UNSIGNED NOT NULL auto_increment, MODIFY template_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY template_copyright varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY template_path varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY bbcode_bitfield varchar(255) DEFAULT 'kNg=' NOT NULL COLLATE utf8_bin, MODIFY template_storedb tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, DROP INDEX tmplte_nm, ADD UNIQUE tmplte_nm (template_name), DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_styles_template_data' ALTER TABLE phpbb_styles_template_data MODIFY template_id smallint(4) UNSIGNED DEFAULT '0' NOT NULL, MODIFY template_filename varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY template_included text NOT NULL COLLATE utf8_bin, MODIFY template_mtime int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY template_data mediumtext NOT NULL COLLATE utf8_bin, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_styles_theme' ALTER TABLE phpbb_styles_theme MODIFY theme_id smallint(4) UNSIGNED NOT NULL auto_increment, MODIFY theme_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY theme_copyright varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY theme_path varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY theme_storedb tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY theme_mtime int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY theme_data mediumtext NOT NULL COLLATE utf8_bin, DROP INDEX theme_name, ADD UNIQUE theme_name (theme_name), DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_styles_imageset' ALTER TABLE phpbb_styles_imageset MODIFY imageset_id smallint(4) UNSIGNED NOT NULL auto_increment, MODIFY imageset_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY imageset_copyright varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY imageset_path varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin, DROP INDEX imgset_nm, ADD UNIQUE imgset_nm (imageset_name), DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_styles_imageset_data' ALTER TABLE phpbb_styles_imageset_data MODIFY image_id smallint(4) UNSIGNED NOT NULL auto_increment, MODIFY image_name varchar(200) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY image_filename varchar(200) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY image_lang varchar(30) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY image_height smallint(4) UNSIGNED DEFAULT '0' NOT NULL, MODIFY image_width smallint(4) UNSIGNED DEFAULT '0' NOT NULL, MODIFY imageset_id smallint(4) UNSIGNED DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_topics' ALTER TABLE phpbb_topics MODIFY topic_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY icon_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY topic_attachment tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY topic_approved tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY topic_reported tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY topic_title varchar(100) DEFAULT '' NOT NULL COLLATE utf8_unicode_ci, MODIFY topic_poster mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY topic_time int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY topic_time_limit int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY topic_views mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY topic_replies mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY topic_replies_real mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY topic_status tinyint(3) DEFAULT '0' NOT NULL, MODIFY topic_type tinyint(3) DEFAULT '0' NOT NULL, MODIFY topic_first_post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY topic_first_poster_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY topic_first_poster_colour varchar(6) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY topic_last_post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY topic_last_poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY topic_last_poster_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY topic_last_poster_colour varchar(6) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY topic_last_post_subject varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY topic_last_post_time int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY topic_last_view_time int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY topic_moved_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY topic_bumped tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY topic_bumper mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY poll_title varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY poll_start int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY poll_length int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY poll_max_options tinyint(4) DEFAULT '1' NOT NULL, MODIFY poll_last_vote int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY poll_vote_change tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_topics_track' ALTER TABLE phpbb_topics_track MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY mark_time int(11) UNSIGNED DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_topics_posted' ALTER TABLE phpbb_topics_posted MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY topic_posted tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_topics_watch' ALTER TABLE phpbb_topics_watch MODIFY topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY notify_status tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_user_group' ALTER TABLE phpbb_user_group MODIFY group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY group_leader tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_pending tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_users' ALTER TABLE phpbb_users MODIFY user_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY user_type tinyint(2) DEFAULT '0' NOT NULL, MODIFY group_id mediumint(8) UNSIGNED DEFAULT '3' NOT NULL, MODIFY user_permissions mediumtext NOT NULL COLLATE utf8_bin, MODIFY user_perm_from mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_ip varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_regdate int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY username varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY username_clean varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_password varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_passchg int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_pass_convert tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_email varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_email_hash bigint(20) DEFAULT '0' NOT NULL, MODIFY user_birthday varchar(10) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_lastvisit int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_lastmark int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_lastpost_time int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_lastpage varchar(200) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_last_confirm_key varchar(10) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_last_search int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_warnings tinyint(4) DEFAULT '0' NOT NULL, MODIFY user_last_warning int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_login_attempts tinyint(4) DEFAULT '0' NOT NULL, MODIFY user_inactive_reason tinyint(2) DEFAULT '0' NOT NULL, MODIFY user_inactive_time int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_lang varchar(30) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_timezone decimal(5,2) DEFAULT '0' NOT NULL, MODIFY user_dst tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_dateformat varchar(30) DEFAULT 'd M Y H:i' NOT NULL COLLATE utf8_bin, MODIFY user_style smallint(4) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_rank mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_colour varchar(6) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_new_privmsg tinyint(4) DEFAULT '0' NOT NULL, MODIFY user_unread_privmsg tinyint(4) DEFAULT '0' NOT NULL, MODIFY user_last_privmsg int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_message_rules tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_full_folder int(11) DEFAULT '-3' NOT NULL, MODIFY user_emailtime int(11) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_topic_show_days smallint(4) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_topic_sortby_type varchar(1) DEFAULT 't' NOT NULL COLLATE utf8_bin, MODIFY user_topic_sortby_dir varchar(1) DEFAULT 'd' NOT NULL COLLATE utf8_bin, MODIFY user_post_show_days smallint(4) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_post_sortby_type varchar(1) DEFAULT 't' NOT NULL COLLATE utf8_bin, MODIFY user_post_sortby_dir varchar(1) DEFAULT 'a' NOT NULL COLLATE utf8_bin, MODIFY user_notify tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_notify_pm tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY user_notify_type tinyint(4) DEFAULT '0' NOT NULL, MODIFY user_allow_pm tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY user_allow_viewonline tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY user_allow_viewemail tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY user_allow_massemail tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, MODIFY user_options int(11) UNSIGNED DEFAULT '895' NOT NULL, MODIFY user_avatar varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_avatar_type tinyint(2) DEFAULT '0' NOT NULL, MODIFY user_avatar_width smallint(4) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_avatar_height smallint(4) UNSIGNED DEFAULT '0' NOT NULL, MODIFY user_sig mediumtext NOT NULL COLLATE utf8_bin, MODIFY user_sig_bbcode_uid varchar(5) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_sig_bbcode_bitfield varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_from varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_icq varchar(15) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_aim varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_yim varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_msnm varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_jabber varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_website varchar(200) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_occ text NOT NULL COLLATE utf8_bin, MODIFY user_interests text NOT NULL COLLATE utf8_bin, MODIFY user_actkey varchar(32) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_newpasswd varchar(32) DEFAULT '' NOT NULL COLLATE utf8_bin, DROP INDEX username_clean, ADD UNIQUE username_clean (username_clean), DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_warnings' ALTER TABLE phpbb_warnings MODIFY warning_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY log_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY warning_time int(11) UNSIGNED DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_words' ALTER TABLE phpbb_words MODIFY word_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY word varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY replacement varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, DEFAULT CHARSET=utf8 COLLATE=utf8_bin; # Table: 'phpbb_zebra' ALTER TABLE phpbb_zebra MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY zebra_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY friend tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY foe tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Fri, 09/14/2007 - 13:44
sales@mytechdir...

I am sorry, I thought I mentioned it was dumped.

The post above is the output of what needs to be updated. I have backed up and restored databases a few times, but the tools I used were what my previous host used. I just need to know if there is a mysql console built into virtualmin?

Fri, 09/14/2007 - 14:23 (Reply to #13)
Joe
Joe's picture

Yeah, we're just talking past one another here. ;-)

The MySQL module that I've been talking about is the UI we provide for Virtualmin. It can import database dumps, and it can execute your update script for phpBB.

If you want to do it from the command line, login as the virtual server user using ssh and run mysql -p (and optionally include the database name).

I'm not sure what you're looking for when you say &quot;mysql console&quot;? I've been talking about the full-featured MySQL Webmin module all along. It can create and manage databases, dump and restore databases, manage users and permissions, manage tables and fields, manage data within those tables and fields, search within database tables, and start/stop MySQL. Pretty much everything you can do with MySQL can be done from the Webmin MySQL module.

--

Check out the forum guidelines!

Sat, 09/15/2007 - 18:51
sales@mytechdir...

Did you get the chance to check the link I provided?

I get an error when trying to use virtualmin correct the database issues.

I am not going to post the whole thing,

Error
Failed to execute SQL : SQL USE mytechdirect_forum; # Table: 'phpbb_attachments' ALTER TABLE phpbb_attachments MODIFY attach_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY post_msg_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY in_message tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY poster_id mediumint(8)

Sun, 09/16/2007 - 07:44
sales@mytechdir...

What would be the best way to add mysql 4 as an option on my server?

Sun, 09/16/2007 - 21:51
sales@mytechdir...

I got this issue corrected with the help of phpbb support.

Sun, 09/16/2007 - 22:06
sales@mytechdir...

Also, the virtualmin built in sql command line interface seems not to work properly. I installed phpmyadmin, used the sql command line and the database update was corrected using the same queries as were attempted using the virtualmin interface, which failed.

Topic locked