Nun habe ich das nächste Problem: Wenn ich einen Beitrag posten will, gibt es eine MySQL-Fehlermeldung
Code: Alles auswählen
SQL ERROR [ mysqli ]
Field 'post_id' doesn't have a default value [1364]
SQL
INSERT INTO phpbb3_posts (forum_id, poster_id, icon_id, poster_ip, post_time, post_visibility, enable_bbcode, enable_smilies, enable_magic_url, enable_sig, post_username, post_subject, post_text, post_checksum, post_attachment, bbcode_bitfield, bbcode_uid, post_postcount, post_edit_locked, topic_id) VALUES (100, 23407, 0, '78.104.15.100', 1557825249, 1, 1, 1, 1, 1, '', 'Re: ECTS in VO+UE Lateinische Formenlehre und Syntax', '<t>Test</t>', '0cbc6611f5540bd0809a388dc95a615b', 0, '', '1pflivf', 1, 0, 159277)
BACKTRACE
FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()
FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 997
CALL: trigger_error()
FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 193
CALL: phpbb\db\driver\driver->sql_error()
FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbb\db\driver\mysqli->sql_query()
FILE: [ROOT]/includes/functions_posting.php
LINE: 1893
CALL: phpbb\db\driver\factory->sql_query()
FILE: [ROOT]/posting.php
LINE: 1457
CALL: submit_post()
Wenn ich allerdings die von mysql_updater.php generierten MySQL-Befehle in meiner Datenbank via phpMyAdmin ausführe, erhalte ich ebenfalls eine Fehlermeldung:
Code: Alles auswählen
Statische Analyse:
3 Fehler wurden während der Analyse gefunden.
Missing comma before start of a new alter operation. (near "COLLATE" at position 184)
Missing comma before start of a new alter operation. (near "DEFAULT CHARSET" at position 385)
Unerkannte ALTER-Operation. (near "DEFAULT CHARSET" at position 385)
SQL-Befehl:
# Table: 'phpbb3_acl_options' ALTER TABLE phpbb3_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
MySQL meldet: Dokumentation
#1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key
Code: Alles auswählen
USE...
# Table: 'phpbb3_acl_groups'
ALTER TABLE phpbb3_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: 'phpbb3_acl_options'
ALTER TABLE phpbb3_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: 'phpbb3_acl_roles'
ALTER TABLE phpbb3_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: 'phpbb3_acl_roles_data'
ALTER TABLE phpbb3_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: 'phpbb3_acl_users'
ALTER TABLE phpbb3_acl_users
MODIFY user_id INT(10) 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: 'phpbb3_attachments'
ALTER TABLE phpbb3_attachments
MODIFY attach_id INT(10) UNSIGNED NOT NULL auto_increment,
MODIFY post_msg_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY topic_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY in_message tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY poster_id INT(10) 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: 'phpbb3_banlist'
ALTER TABLE phpbb3_banlist
MODIFY ban_id INT(10) UNSIGNED NOT NULL auto_increment,
MODIFY ban_userid INT(10) 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: 'phpbb3_bbcodes'
ALTER TABLE phpbb3_bbcodes
MODIFY bbcode_id smallint(4) UNSIGNED 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: 'phpbb3_bookmarks'
ALTER TABLE phpbb3_bookmarks
MODIFY topic_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
# Table: 'phpbb3_bots'
ALTER TABLE phpbb3_bots
MODIFY bot_id INT(10) 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 INT(10) 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: 'phpbb3_config'
ALTER TABLE phpbb3_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: 'phpbb3_config_text'
ALTER TABLE phpbb3_config_text
MODIFY config_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY config_value mediumtext NOT NULL COLLATE utf8_bin,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
# Table: 'phpbb3_confirm'
ALTER TABLE phpbb3_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,
MODIFY attempts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
# Table: 'phpbb3_disallow'
ALTER TABLE phpbb3_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: 'phpbb3_drafts'
ALTER TABLE phpbb3_drafts
MODIFY draft_id INT(10) UNSIGNED NOT NULL auto_increment,
MODIFY user_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY topic_id INT(10) 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(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY draft_message mediumtext NOT NULL COLLATE utf8_bin,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
# Table: 'phpbb3_ext'
ALTER TABLE phpbb3_ext
MODIFY ext_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY ext_active tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY ext_state text NOT NULL COLLATE utf8_bin,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
# Table: 'phpbb3_extension_groups'
ALTER TABLE phpbb3_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: 'phpbb3_extensions'
ALTER TABLE phpbb3_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: 'phpbb3_forums'
ALTER TABLE phpbb3_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(8) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY forum_link varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY forum_password varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY forum_style mediumint(8) 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(8) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY forum_topics_per_page smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY forum_type tinyint(4) DEFAULT '0' NOT NULL,
MODIFY forum_status tinyint(4) DEFAULT '0' NOT NULL,
MODIFY forum_last_post_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY forum_last_poster_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY forum_last_post_subject varchar(255) 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,
MODIFY display_subforum_list tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY forum_options int(20) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY enable_shadow_prune tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY prune_shadow_days mediumint(8) UNSIGNED DEFAULT '7' NOT NULL,
MODIFY prune_shadow_freq mediumint(8) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY prune_shadow_next int(11) DEFAULT '0' NOT NULL,
MODIFY forum_posts_approved mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY forum_posts_unapproved mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY forum_posts_softdeleted mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY forum_topics_approved mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY forum_topics_unapproved mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY forum_topics_softdeleted mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
# Table: 'phpbb3_forums_access'
ALTER TABLE phpbb3_forums_access
MODIFY forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY session_id char(32) DEFAULT '' NOT NULL COLLATE utf8_bin,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
# Table: 'phpbb3_forums_track'
ALTER TABLE phpbb3_forums_track
MODIFY user_id INT(10) 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: 'phpbb3_forums_watch'
ALTER TABLE phpbb3_forums_watch
MODIFY forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY notify_status tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
# Table: 'phpbb3_groups'
ALTER TABLE phpbb3_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_skip_auth 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(8) 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 varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
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 mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY group_max_recipients mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
DROP INDEX group_legend_name,
ADD KEY group_legend_name (group_legend, group_name),
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
# Table: 'phpbb3_icons'
ALTER TABLE phpbb3_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_alt varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
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: 'phpbb3_lang'
ALTER TABLE phpbb3_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: 'phpbb3_log'
ALTER TABLE phpbb3_log
MODIFY log_id INT(10) UNSIGNED NOT NULL auto_increment,
MODIFY log_type tinyint(4) DEFAULT '0' NOT NULL,
MODIFY user_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY topic_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY post_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY reportee_id INT(10) 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: 'phpbb3_login_attempts'
ALTER TABLE phpbb3_login_attempts
MODIFY attempt_ip varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY attempt_browser varchar(150) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY attempt_forwarded_for varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY attempt_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY username varchar(255) DEFAULT '0' NOT NULL COLLATE utf8_bin,
MODIFY username_clean varchar(255) DEFAULT '0' NOT NULL COLLATE utf8_bin,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
# Table: 'phpbb3_migrations'
ALTER TABLE phpbb3_migrations
MODIFY migration_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY migration_depends_on text NOT NULL COLLATE utf8_bin,
MODIFY migration_schema_done tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY migration_data_done tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY migration_data_state text NOT NULL COLLATE utf8_bin,
MODIFY migration_start_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY migration_end_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
# Table: 'phpbb3_moderator_cache'
ALTER TABLE phpbb3_moderator_cache
MODIFY forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_id INT(10) 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: 'phpbb3_modules'
ALTER TABLE phpbb3_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: 'phpbb3_notification_types'
ALTER TABLE phpbb3_notification_types
MODIFY notification_type_id smallint(4) UNSIGNED NOT NULL auto_increment,
MODIFY notification_type_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY notification_type_enabled tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
# Table: 'phpbb3_notifications'
ALTER TABLE phpbb3_notifications
MODIFY notification_id int(10) UNSIGNED NOT NULL auto_increment,
MODIFY notification_type_id smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY item_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY item_parent_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY notification_read tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY notification_time int(11) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY notification_data text NOT NULL COLLATE utf8_bin,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
# Table: 'phpbb3_oauth_accounts'
ALTER TABLE phpbb3_oauth_accounts
MODIFY user_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY provider varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY oauth_provider_id text NOT NULL COLLATE utf8_bin,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
# Table: 'phpbb3_oauth_states'
ALTER TABLE phpbb3_oauth_states
MODIFY user_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY session_id char(32) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY provider varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY oauth_state varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
# Table: 'phpbb3_oauth_tokens'
ALTER TABLE phpbb3_oauth_tokens
MODIFY user_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY session_id char(32) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY provider varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY oauth_token mediumtext NOT NULL COLLATE utf8_bin,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
# Table: 'phpbb3_poll_options'
ALTER TABLE phpbb3_poll_options
MODIFY poll_option_id tinyint(4) DEFAULT '0' NOT NULL,
MODIFY topic_id INT(10) 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: 'phpbb3_poll_votes'
ALTER TABLE phpbb3_poll_votes
MODIFY topic_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY poll_option_id tinyint(4) DEFAULT '0' NOT NULL,
MODIFY vote_user_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY vote_user_ip varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
# Table: 'phpbb3_posts'
ALTER TABLE phpbb3_posts
MODIFY post_id INT(10) UNSIGNED NOT NULL auto_increment,
MODIFY topic_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY poster_id INT(10) 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_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(255) DEFAULT '' NOT NULL COLLATE utf8_unicode_ci,
MODIFY post_text mediumtext NOT NULL COLLATE utf8_bin,
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(8) 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 INT(10) 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,
MODIFY post_visibility tinyint(3) DEFAULT '0' NOT NULL,
MODIFY post_delete_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY post_delete_reason varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY post_delete_user INT(10) UNSIGNED DEFAULT '0' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
# Table: 'phpbb3_privmsgs'
ALTER TABLE phpbb3_privmsgs
MODIFY msg_id INT(10) UNSIGNED NOT NULL auto_increment,
MODIFY root_level mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY author_id INT(10) 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(255) 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 INT(10) 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(8) 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,
MODIFY message_reported tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
# Table: 'phpbb3_privmsgs_folder'
ALTER TABLE phpbb3_privmsgs_folder
MODIFY folder_id mediumint(8) UNSIGNED NOT NULL auto_increment,
MODIFY user_id INT(10) 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: 'phpbb3_privmsgs_rules'
ALTER TABLE phpbb3_privmsgs_rules
MODIFY rule_id mediumint(8) UNSIGNED NOT NULL auto_increment,
MODIFY user_id INT(10) 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 INT(10) 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: 'phpbb3_privmsgs_to'
ALTER TABLE phpbb3_privmsgs_to
MODIFY msg_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY author_id INT(10) 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: 'phpbb3_profile_fields'
ALTER TABLE phpbb3_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 varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin,
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(64) 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,
MODIFY field_show_profile tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY field_show_on_vt tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY field_show_novalue tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY field_show_on_pm tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY field_show_on_ml tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY field_is_contact tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY field_contact_desc varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY field_contact_url varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
# Table: 'phpbb3_profile_fields_data'
ALTER TABLE phpbb3_profile_fields_data
MODIFY user_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY pf_phpbb_interests mediumtext NOT NULL COLLATE utf8_bin,
MODIFY pf_phpbb_occupation mediumtext NOT NULL COLLATE utf8_bin,
MODIFY pf_phpbb_skype varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY pf_phpbb_googleplus varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY pf_phpbb_twitter varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY pf_phpbb_location varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY pf_phpbb_icq varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY pf_phpbb_youtube varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY pf_phpbb_facebook varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY pf_phpbb_website varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY pf_phpbb_yahoo varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY pf_phpbb_aol varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
# Table: 'phpbb3_profile_fields_lang'
ALTER TABLE phpbb3_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 varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY lang_value varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
# Table: 'phpbb3_profile_lang'
ALTER TABLE phpbb3_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: 'phpbb3_ranks'
ALTER TABLE phpbb3_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: 'phpbb3_reports'
ALTER TABLE phpbb3_reports
MODIFY report_id INT(10) UNSIGNED NOT NULL auto_increment,
MODIFY reason_id smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY post_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_id INT(10) 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,
MODIFY pm_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY reported_post_enable_bbcode tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY reported_post_enable_smilies tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY reported_post_enable_magic_url tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY reported_post_text mediumtext NOT NULL COLLATE utf8_bin,
MODIFY reported_post_uid varchar(8) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY reported_post_bitfield varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
# Table: 'phpbb3_reports_reasons'
ALTER TABLE phpbb3_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: 'phpbb3_search_results'
ALTER TABLE phpbb3_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: 'phpbb3_search_wordlist'
ALTER TABLE phpbb3_search_wordlist
MODIFY word_id INT(10) 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: 'phpbb3_search_wordmatch'
ALTER TABLE phpbb3_search_wordmatch
MODIFY post_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY word_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY title_match tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
# Table: 'phpbb3_sessions'
ALTER TABLE phpbb3_sessions
MODIFY session_id char(32) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY session_user_id INT(10) 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,
MODIFY session_forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
# Table: 'phpbb3_sessions_keys'
ALTER TABLE phpbb3_sessions_keys
MODIFY key_id char(32) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY user_id INT(10) 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: 'phpbb3_sitelist'
ALTER TABLE phpbb3_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: 'phpbb3_smilies'
ALTER TABLE phpbb3_smilies
MODIFY smiley_id mediumint(8) UNSIGNED NOT NULL auto_increment,
MODIFY code varchar(50) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY emotion varchar(255) 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: 'phpbb3_styles'
ALTER TABLE phpbb3_styles
MODIFY style_id mediumint(8) 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 style_path varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY bbcode_bitfield varchar(255) DEFAULT 'kNg=' NOT NULL COLLATE utf8_bin,
MODIFY style_parent_id int(4) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY style_parent_tree text NOT NULL COLLATE utf8_bin,
DROP INDEX style_name,
ADD UNIQUE style_name (style_name),
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
# Table: 'phpbb3_teampage'
ALTER TABLE phpbb3_teampage
MODIFY teampage_id mediumint(8) UNSIGNED NOT NULL auto_increment,
MODIFY group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY teampage_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY teampage_position mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY teampage_parent mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
# Table: 'phpbb3_topics'
ALTER TABLE phpbb3_topics
MODIFY topic_id INT(10) 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_reported tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY topic_title varchar(255) DEFAULT '' NOT NULL COLLATE utf8_unicode_ci,
MODIFY topic_poster INT(10) 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_status tinyint(3) DEFAULT '0' NOT NULL,
MODIFY topic_type tinyint(3) DEFAULT '0' NOT NULL,
MODIFY topic_first_post_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY topic_first_poster_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_unicode_ci,
MODIFY topic_first_poster_colour varchar(6) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY topic_last_post_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY topic_last_poster_id INT(10) 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(255) 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 INT(10) 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,
MODIFY topic_visibility tinyint(3) DEFAULT '0' NOT NULL,
MODIFY topic_delete_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY topic_delete_reason varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY topic_delete_user INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY topic_posts_approved mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY topic_posts_unapproved mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY topic_posts_softdeleted mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
# Table: 'phpbb3_topics_posted'
ALTER TABLE phpbb3_topics_posted
MODIFY user_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY topic_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY topic_posted tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
# Table: 'phpbb3_topics_track'
ALTER TABLE phpbb3_topics_track
MODIFY user_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY topic_id INT(10) 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: 'phpbb3_topics_watch'
ALTER TABLE phpbb3_topics_watch
MODIFY topic_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY notify_status tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
# Table: 'phpbb3_user_group'
ALTER TABLE phpbb3_user_group
MODIFY group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_id INT(10) 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: 'phpbb3_user_notifications'
ALTER TABLE phpbb3_user_notifications
MODIFY item_type varchar(165) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY item_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY method varchar(165) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY notify tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
# Table: 'phpbb3_users'
ALTER TABLE phpbb3_users
MODIFY user_id INT(10) 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(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY user_passchg int(11) 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 varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY user_dateformat varchar(64) DEFAULT 'd M Y H:i' NOT NULL COLLATE utf8_bin,
MODIFY user_style mediumint(8) 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 int(4) DEFAULT '0' NOT NULL,
MODIFY user_unread_privmsg int(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 '230271' NOT NULL,
MODIFY user_avatar varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY user_avatar_type varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
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(8) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY user_sig_bbcode_bitfield varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY user_jabber varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY user_actkey varchar(32) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY user_newpasswd varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY user_form_salt varchar(32) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY user_new tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY user_reminded tinyint(4) DEFAULT '0' NOT NULL,
MODIFY user_reminded_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
DROP INDEX username_clean,
ADD UNIQUE username_clean (username_clean),
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
# Table: 'phpbb3_warnings'
ALTER TABLE phpbb3_warnings
MODIFY warning_id mediumint(8) UNSIGNED NOT NULL auto_increment,
MODIFY user_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY post_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY log_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY warning_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
# Table: 'phpbb3_words'
ALTER TABLE phpbb3_words
MODIFY word_id INT(10) 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: 'phpbb3_zebra'
ALTER TABLE phpbb3_zebra
MODIFY user_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY zebra_id INT(10) 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;