Database schema differences

Status
Not open for further replies.

Brogan

XenForo moderator
Staff member
#2
1.0.4 to 1.1.0
Code:
Table xf_admin_log missing from DB xenforo_104.
Table xf_admin_search_type missing from DB xenforo_104.
Column xf_bb_code_media_site.addon_id missing from DB xenforo_104.xf_bb_code_media_site.
Column xf_bb_code_media_site.embed_html_callback_class missing from DB xenforo_104.xf_bb_code_media_site.
Column xf_bb_code_media_site.embed_html_callback_method missing from DB xenforo_104.xf_bb_code_media_site.
Column xf_bb_code_media_site.match_callback_class missing from DB xenforo_104.xf_bb_code_media_site.
Column xf_bb_code_media_site.match_callback_method missing from DB xenforo_104.xf_bb_code_media_site.
Column xf_bb_code_media_site.match_is_regex missing from DB xenforo_104.xf_bb_code_media_site.
Column xf_conversation_message.attach_count missing from DB xenforo_104.xf_conversation_message.
Column xf_conversation_message.ip_id missing from DB xenforo_104.xf_conversation_message.
Column xf_feed.prefix_id missing from DB xenforo_104.xf_feed.
Column xf_forum.count_messages missing from DB xenforo_104.xf_forum.
Column xf_forum.default_prefix_id missing from DB xenforo_104.xf_forum.
Column xf_forum.find_new missing from DB xenforo_104.xf_forum.
Column xf_forum.prefix_cache missing from DB xenforo_104.xf_forum.
Table xf_forum_prefix missing from DB xenforo_104.
Table xf_identity_service missing from DB xenforo_110.
Column xf_language.text_direction missing from DB xenforo_104.xf_language.
Table xf_moderator_log missing from DB xenforo_104.
Column xf_node.display_in_list differs in COLUMN_KEY value ( vs MUL).
Table xf_notice missing from DB xenforo_104.
Table xf_notice_dismissed missing from DB xenforo_104.
Column xf_post.user_id differs in COLUMN_KEY value ( vs MUL).
Column xf_post.warning_id missing from DB xenforo_104.xf_post.
Column xf_post.warning_message missing from DB xenforo_104.xf_post.
Column xf_profile_post.user_id differs in COLUMN_KEY value ( vs MUL).
Column xf_profile_post.warning_id missing from DB xenforo_104.xf_profile_post.
Column xf_profile_post.warning_message missing from DB xenforo_104.xf_profile_post.
Column xf_profile_post_comment.ip_id missing from DB xenforo_104.xf_profile_post_comment.
Column xf_search.user_results missing from DB xenforo_104.xf_search.
Column xf_smilie.sprite_mode missing from DB xenforo_104.xf_smilie.
Column xf_smilie.sprite_params missing from DB xenforo_104.xf_smilie.
Table xf_stats_daily missing from DB xenforo_104.
Column xf_thread.prefix_id missing from DB xenforo_104.xf_thread.
Table xf_thread_prefix missing from DB xenforo_104.
Table xf_thread_prefix_group missing from DB xenforo_104.
Column xf_trophy.criteria missing from DB xenforo_110.xf_trophy.
Column xf_trophy.user_criteria missing from DB xenforo_104.xf_trophy.
Column xf_user.warning_points missing from DB xenforo_104.xf_user.
Table xf_user_field missing from DB xenforo_104.
Table xf_user_field_value missing from DB xenforo_104.
Table xf_user_group_promotion missing from DB xenforo_104.
Table xf_user_group_promotion_log missing from DB xenforo_104.
Table xf_user_identity missing from DB xenforo_110.
Table xf_user_ignored missing from DB xenforo_104.
Column xf_user_profile.custom_fields missing from DB xenforo_104.xf_user_profile.
Column xf_user_profile.identities missing from DB xenforo_110.xf_user_profile.
Column xf_user_profile.ignored missing from DB xenforo_104.xf_user_profile.
Table xf_warning missing from DB xenforo_104.
Table xf_warning_action missing from DB xenforo_104.
Table xf_warning_action_trigger missing from DB xenforo_104.
Table xf_warning_definition missing from DB xenforo_104.

1.1.0 to 1.1.1
Code:
No changes

1.1.1 to 1.1.2
Code:
Column xf_user_external_auth.provider differs in COLUMN_KEY value (MUL vs PRI).

1.1.2 to 1.1.3
Code:
No changes

1.1.3 to 1.1.4
Code:
Column xf_report.content_user_id differs in COLUMN_KEY value (MUL vs ).
Column xf_user_confirmation.confirmation_date differs in COLUMN_KEY value (MUL vs ).

1.1.4 to 1.1.5
Code:
No changes
 

Brogan

XenForo moderator
Staff member
#3
1.1.5 to 1.2.0 Beta 1
Code:
Table xf_admin_template_modification missing from DB xenforo_115.
Table xf_admin_template_modification_log missing from DB xenforo_115.
Column xf_ban_email.banned_email differs in COLUMN_TYPE value (varchar(120) vs varchar(50)).
Table xf_bb_code_parse_cache missing from DB xenforo_115.
Column xf_code_event_listener.hint missing from DB xenforo_115.xf_code_event_listener.
Table xf_content_spam_cache missing from DB xenforo_115.
Column xf_conversation_master.recipients missing from DB xenforo_115.xf_conversation_master.
Column xf_conversation_master.user_id differs in COLUMN_KEY value (MUL vs ).
Column xf_conversation_user.is_starred missing from DB xenforo_115.xf_conversation_user.
Table xf_deferred missing from DB xenforo_115.
Table xf_draft missing from DB xenforo_115.
Table xf_edit_history missing from DB xenforo_115.
Table xf_email_template_modification missing from DB xenforo_115.
Table xf_email_template_modification_log missing from DB xenforo_115.
Column xf_forum.allowed_watch_notifications missing from DB xenforo_115.xf_forum.
Column xf_forum.default_sort_direction missing from DB xenforo_115.xf_forum.
Column xf_forum.default_sort_order missing from DB xenforo_115.xf_forum.
Column xf_forum.require_prefix missing from DB xenforo_115.xf_forum.
Table xf_forum_watch missing from DB xenforo_115.
Column xf_ip.log_date differs in COLUMN_KEY value (MUL vs ).
Column xf_liked_content.like_user_id differs in COLUMN_KEY value (MUL vs ).
Table xf_mail_queue missing from DB xenforo_115.
Column xf_node.breadcrumb_data missing from DB xenforo_115.xf_node.
Column xf_option.edit_format differs in COLUMN_TYPE value (enum('textbox','spinbox','onoff','radio','select','checkbox','template','callback','onofftextbox') vs enum('textbox','spinbox','onoff','radio','select','checkbox','template','callback')).
Table xf_permission_cache_content_type missing from DB xenforo_120.
Table xf_permission_cache_global_group missing from DB xenforo_120.
Column xf_post.edit_count missing from DB xenforo_115.xf_post.
Column xf_post.last_edit_date missing from DB xenforo_115.xf_post.
Column xf_post.last_edit_user_id missing from DB xenforo_115.xf_post.
Table xf_registration_spam_cache missing from DB xenforo_115.
Column xf_report.report_count missing from DB xenforo_115.xf_report.
Column xf_report_comment.is_report missing from DB xenforo_115.xf_report_comment.
Table xf_route_filter missing from DB xenforo_115.
Column xf_session_activity.robot_key missing from DB xenforo_115.xf_session_activity.
Column xf_template.disable_modifications missing from DB xenforo_115.xf_template.
Column xf_template.last_edit_date missing from DB xenforo_115.xf_template.
Table xf_template_history missing from DB xenforo_115.
Table xf_template_modification missing from DB xenforo_115.
Table xf_template_modification_log missing from DB xenforo_115.
Column xf_user.is_staff missing from DB xenforo_115.xf_user.
Column xf_user.like_count differs in COLUMN_KEY value (MUL vs ).
Column xf_user.message_count differs in COLUMN_KEY value (MUL vs ).
Column xf_user.register_date differs in COLUMN_KEY value (MUL vs ).
Column xf_user.trophy_points differs in COLUMN_KEY value (MUL vs ).
Column xf_user_group.banner_css_class missing from DB xenforo_115.xf_user_group.
Column xf_user_group.banner_text missing from DB xenforo_115.xf_user_group.
Column xf_user_option.enable_flash_uploader missing from DB xenforo_115.xf_user_option.
Column xf_user_profile.dob_month differs in COLUMN_KEY value (MUL vs ).
Column xf_user_upgrade_expired.extra missing from DB xenforo_115.xf_user_upgrade_expired.
Column xf_user_upgrade_expired.original_end_date missing from DB xenforo_115.xf_user_upgrade_expired.
Column xf_user_upgrade_log.subscriber_id missing from DB xenforo_115.xf_user_upgrade_log.
 
Last edited:

Brogan

XenForo moderator
Staff member
#7
1.2.4 to 1.3.0 Beta 1

Code:
Column xf_admin_log.ip_address differs in COLUMN_DEFAULT value ( vs 0).
Column xf_admin_log.ip_address differs in COLUMN_TYPE value (varbinary(16) vs int(10) unsigned).
Column xf_attachment_data.upload_date differs in COLUMN_KEY value (MUL vs ).
Table xf_bb_code missing from DB xenforo_124.
Column xf_conversation_message.message_date differs in COLUMN_KEY value (MUL vs ).
Column xf_conversation_message.user_id differs in COLUMN_KEY value (MUL vs ).
Column xf_error_log.ip_address differs in COLUMN_DEFAULT value ( vs 0).
Column xf_error_log.ip_address differs in COLUMN_TYPE value (varbinary(16) vs int(10) unsigned).
Table xf_image_proxy missing from DB xenforo_124.
Column xf_ip.ip differs in COLUMN_TYPE value (varbinary(16) vs int(10) unsigned).
Column xf_ip_match.end_range differs in COLUMN_TYPE value (varbinary(16) vs int(10) unsigned).
Column xf_ip_match.first_byte missing from DB xenforo_124.xf_ip_match.
Column xf_ip_match.first_octet missing from DB xenforo.xf_ip_match.
Column xf_ip_match.ip differs in COLUMN_TYPE value (varchar(43) vs varchar(25)).
Column xf_ip_match.start_range differs in COLUMN_TYPE value (varbinary(16) vs int(10) unsigned).
Column xf_liked_content.like_date differs in COLUMN_KEY value (MUL vs ).
Table xf_link_proxy missing from DB xenforo_124.
Column xf_login_attempt.attempt_id missing from DB xenforo_124.xf_login_attempt.
Column xf_login_attempt.ip_address differs in COLUMN_TYPE value (varbinary(16) vs int(10) unsigned).
Column xf_moderator_log.ip_address differs in COLUMN_DEFAULT value ( vs 0).
Column xf_moderator_log.ip_address differs in COLUMN_TYPE value (varbinary(16) vs int(10) unsigned).
Column xf_phrase.title differs in COLUMN_TYPE value (varbinary(100) vs varbinary(75)).
Column xf_post.post_date differs in COLUMN_KEY value (MUL vs ).
Column xf_profile_post.post_date differs in COLUMN_KEY value (MUL vs ).
Column xf_profile_post_comment.comment_date differs in COLUMN_KEY value (MUL vs ).
Column xf_profile_post_comment.user_id differs in COLUMN_KEY value (MUL vs ).
Column xf_registration_spam_cache.decision missing from DB xenforo.xf_registration_spam_cache.
Column xf_registration_spam_cache.result missing from DB xenforo_124.xf_registration_spam_cache.
Column xf_registration_spam_cache.timeout differs in COLUMN_KEY value (MUL vs ).
Column xf_report_comment.user_id differs in COLUMN_KEY value (MUL vs ).
Column xf_session_activity.ip differs in COLUMN_DEFAULT value ( vs 0).
Column xf_session_activity.ip differs in COLUMN_TYPE value (varbinary(16) vs int(10) unsigned).
Column xf_session_activity.unique_key differs in COLUMN_TYPE value (varbinary(16) vs int(10) unsigned).
Column xf_smilie.display_in_editor missing from DB xenforo_124.xf_smilie.
Column xf_smilie.display_order missing from DB xenforo_124.xf_smilie.
Column xf_smilie.smilie_category_id missing from DB xenforo_124.xf_smilie.
Table xf_smilie_category missing from DB xenforo_124.
Table xf_spam_trigger_log missing from DB xenforo_124.
Column xf_thread.post_date differs in COLUMN_KEY value (MUL vs ).
Column xf_thread.user_id differs in COLUMN_KEY value (MUL vs ).
Column xf_user.user_state differs in COLUMN_TYPE value (enum('valid','email_confirm','email_confirm_edit','moderated','email_bounce') vs enum('valid','email_confirm','email_confirm_edit','moderated')).
Table xf_user_change_log missing from DB xenforo_124.
Table xf_user_change_temp missing from DB xenforo_124.
Column xf_user_field.moderator_editable missing from DB xenforo_124.xf_user_field.
Column xf_user_profile.external_auth missing from DB xenforo_124.xf_user_profile.
Column xf_user_profile.facebook_auth_id missing from DB xenforo.xf_user_profile.
Column xf_warning_action.action differs in COLLATION_NAME value (NULL vs utf8_general_ci).
Column xf_warning_action.action differs in COLUMN_TYPE value (varbinary(25) vs enum('ban_length','ban_points','discourage','groups')).
Column xf_warning_action.action_length missing from DB xenforo_124.xf_warning_action.
Column xf_warning_action.action_length_type missing from DB xenforo_124.xf_warning_action.
Column xf_warning_action.ban_length missing from DB xenforo.xf_warning_action.
Column xf_warning_action.ban_length_type missing from DB xenforo.xf_warning_action.
Column xf_warning_action_trigger.action differs in COLLATION_NAME value (NULL vs utf8_general_ci).
Column xf_warning_action_trigger.action differs in COLUMN_TYPE value (varbinary(25) vs enum('ban_points','discourage','groups')).
 

Brogan

XenForo moderator
Staff member
#8
1.2.5 to 1.3.0

Code:
Column xf_admin_log.ip_address differs in COLUMN_DEFAULT value ( vs 0).
Column xf_admin_log.ip_address differs in COLUMN_TYPE value (varbinary(16) vs int(10) unsigned).
Column xf_admin_template_phrase.phrase_title differs in COLUMN_TYPE value (varbinary(100) vs varbinary(75)).
Column xf_attachment_data.upload_date differs in COLUMN_KEY value (MUL vs ).
Table xf_bb_code missing from DB xenforo_125.
Column xf_conversation_message.message_date differs in COLUMN_KEY value (MUL vs ).
Column xf_conversation_message.user_id differs in COLUMN_KEY value (MUL vs ).
Column xf_email_template_phrase.phrase_title differs in COLUMN_TYPE value (varbinary(100) vs varbinary(75)).
Column xf_error_log.ip_address differs in COLUMN_DEFAULT value ( vs 0).
Column xf_error_log.ip_address differs in COLUMN_TYPE value (varbinary(16) vs int(10) unsigned).
Table xf_image_proxy missing from DB xenforo_125.
Column xf_ip.ip differs in COLUMN_TYPE value (varbinary(16) vs int(10) unsigned).
Column xf_ip_match.end_range differs in COLUMN_TYPE value (varbinary(16) vs int(10) unsigned).
Column xf_ip_match.first_byte missing from DB xenforo_125.xf_ip_match.
Column xf_ip_match.first_octet missing from DB xenforo_130.xf_ip_match.
Column xf_ip_match.ip differs in COLUMN_TYPE value (varchar(43) vs varchar(25)).
Column xf_ip_match.start_range differs in COLUMN_TYPE value (varbinary(16) vs int(10) unsigned).
Column xf_liked_content.like_date differs in COLUMN_KEY value (MUL vs ).
Table xf_link_proxy missing from DB xenforo_125.
Column xf_login_attempt.attempt_id missing from DB xenforo_125.xf_login_attempt.
Column xf_login_attempt.ip_address differs in COLUMN_TYPE value (varbinary(16) vs int(10) unsigned).
Column xf_moderator_log.ip_address differs in COLUMN_DEFAULT value ( vs 0).
Column xf_moderator_log.ip_address differs in COLUMN_TYPE value (varbinary(16) vs int(10) unsigned).
Column xf_phrase.title differs in COLUMN_TYPE value (varbinary(100) vs varbinary(75)).
Column xf_phrase_compiled.title differs in COLUMN_TYPE value (varbinary(100) vs varbinary(75)).
Column xf_phrase_map.title differs in COLUMN_TYPE value (varbinary(100) vs varbinary(75)).
Column xf_post.post_date differs in COLUMN_KEY value (MUL vs ).
Column xf_profile_post.post_date differs in COLUMN_KEY value (MUL vs ).
Column xf_profile_post_comment.comment_date differs in COLUMN_KEY value (MUL vs ).
Column xf_profile_post_comment.user_id differs in COLUMN_KEY value (MUL vs ).
Column xf_registration_spam_cache.decision missing from DB xenforo_130.xf_registration_spam_cache.
Column xf_registration_spam_cache.result missing from DB xenforo_125.xf_registration_spam_cache.
Column xf_registration_spam_cache.timeout differs in COLUMN_KEY value (MUL vs ).
Column xf_report_comment.user_id differs in COLUMN_KEY value (MUL vs ).
Column xf_session_activity.ip differs in COLUMN_DEFAULT value ( vs 0).
Column xf_session_activity.ip differs in COLUMN_TYPE value (varbinary(16) vs int(10) unsigned).
Column xf_session_activity.unique_key differs in COLUMN_TYPE value (varbinary(16) vs int(10) unsigned).
Column xf_smilie.display_in_editor missing from DB xenforo_125.xf_smilie.
Column xf_smilie.display_order missing from DB xenforo_125.xf_smilie.
Column xf_smilie.smilie_category_id missing from DB xenforo_125.xf_smilie.
Table xf_smilie_category missing from DB xenforo_125.
Table xf_spam_trigger_log missing from DB xenforo_125.
Column xf_template_phrase.phrase_title differs in COLUMN_TYPE value (varbinary(100) vs varbinary(75)).
Column xf_thread.post_date differs in COLUMN_KEY value (MUL vs ).
Column xf_thread.user_id differs in COLUMN_KEY value (MUL vs ).
Column xf_user.user_state differs in COLUMN_TYPE value (enum('valid','email_confirm','email_confirm_edit','moderated','email_bounce') vs enum('valid','email_confirm','email_confirm_edit','moderated')).
Table xf_user_change_log missing from DB xenforo_125.
Table xf_user_change_temp missing from DB xenforo_125.
Column xf_user_field.moderator_editable missing from DB xenforo_125.xf_user_field.
Column xf_user_profile.external_auth missing from DB xenforo_125.xf_user_profile.
Column xf_user_profile.facebook_auth_id missing from DB xenforo_130.xf_user_profile.
Column xf_user_upgrade_log.log_date differs in COLUMN_KEY value (MUL vs ).
Column xf_warning_action.action differs in COLLATION_NAME value (NULL vs utf8_general_ci).
Column xf_warning_action.action differs in COLUMN_TYPE value (varbinary(25) vs enum('ban_length','ban_points','discourage','groups')).
Column xf_warning_action.action_length missing from DB xenforo_125.xf_warning_action.
Column xf_warning_action.action_length_type missing from DB xenforo_125.xf_warning_action.
Column xf_warning_action.ban_length missing from DB xenforo_130.xf_warning_action.
Column xf_warning_action.ban_length_type missing from DB xenforo_130.xf_warning_action.
Column xf_warning_action_trigger.action differs in COLLATION_NAME value (NULL vs utf8_general_ci).
Column xf_warning_action_trigger.action differs in COLUMN_TYPE value (varbinary(25) vs enum('ban_points','discourage','groups')).
 

Brogan

XenForo moderator
Staff member
#11
1.3.4 to 1.4.0

Code:
Column xf_bb_code.allow_empty missing from DB xenforo_13.xf_bb_code.
Table xf_email_bounce_log missing from DB xenforo_13.
Table xf_email_bounce_soft missing from DB xenforo_13.
Column xf_forum.allow_poll missing from DB xenforo_13.xf_forum.
Column xf_forum.list_date_limit_days missing from DB xenforo_13.xf_forum.
Column xf_forum.moderate_messages missing from DB xenforo_14.xf_forum.
Column xf_forum.moderate_replies missing from DB xenforo_13.xf_forum.
Column xf_forum.moderate_threads missing from DB xenforo_13.xf_forum.
Table xf_help_page missing from DB xenforo_13.
Column xf_poll.change_vote missing from DB xenforo_13.xf_poll.
Column xf_poll.max_votes missing from DB xenforo_13.xf_poll.
Column xf_poll.multiple missing from DB xenforo_14.xf_poll.
Column xf_poll.view_results_unvoted missing from DB xenforo_13.xf_poll.
Table xf_sitemap missing from DB xenforo_13.
Table xf_thread_reply_ban missing from DB xenforo_13.
Table xf_trophy_user_title missing from DB xenforo_14.
Column xf_user.activity_visible missing from DB xenforo_13.xf_user.
Column xf_user_profile.password_date missing from DB xenforo_13.xf_user_profile.
Table xf_user_title_ladder missing from DB xenforo_13.
 

Brogan

XenForo moderator
Staff member
#12
1.4.0 to 1.4.8

Code:
Column xf_edit_history.edit_user_id differs in COLUMN_KEY value (MUL vs ).
Column xf_image_proxy.is_processing differs in COLUMN_KEY value (MUL vs ).
Column xf_login_attempt.ip_address differs in COLUMN_KEY value (MUL vs ).
Column xf_stats_daily.counter differs in COLUMN_TYPE value (bigint(20) unsigned vs int(10) unsigned).
Column xf_user_alert.user_id differs in COLUMN_KEY value (MUL vs ).
 

Brogan

XenForo moderator
Staff member
#13
1.4.8 to 1.5.0 Beta 1

Code:
Column xf_admin.admin_language_id missing from DB xenforo_14.xf_admin.
Column xf_attachment_data.file_path missing from DB xenforo_14.xf_attachment_data.
Column xf_forum.min_tags missing from DB xenforo_14.xf_forum.
Table xf_image_proxy_referrer missing from DB xenforo_14.
Table xf_link_proxy_referrer missing from DB xenforo_14.
Column xf_notice.auto_dismiss missing from DB xenforo_14.xf_notice.
Column xf_notice.css_class missing from DB xenforo_14.xf_notice.
Column xf_notice.delay_duration missing from DB xenforo_14.xf_notice.
Column xf_notice.display_duration missing from DB xenforo_14.xf_notice.
Column xf_notice.display_image missing from DB xenforo_14.xf_notice.
Column xf_notice.display_style missing from DB xenforo_14.xf_notice.
Column xf_notice.image_url missing from DB xenforo_14.xf_notice.
Column xf_notice.notice_type missing from DB xenforo_14.xf_notice.
Column xf_notice.visibility missing from DB xenforo_14.xf_notice.
Column xf_profile_post.latest_comment_ids differs in COLUMN_DEFAULT value (NULL vs ).
Column xf_profile_post.latest_comment_ids differs in COLUMN_TYPE value (blob vs varbinary(100)).
Column xf_profile_post_comment.like_users missing from DB xenforo_14.xf_profile_post_comment.
Column xf_profile_post_comment.likes missing from DB xenforo_14.xf_profile_post_comment.
Column xf_profile_post_comment.message_state missing from DB xenforo_14.xf_profile_post_comment.
Column xf_profile_post_comment.warning_id missing from DB xenforo_14.xf_profile_post_comment.
Column xf_profile_post_comment.warning_message missing from DB xenforo_14.xf_profile_post_comment.
Table xf_tag missing from DB xenforo_14.
Table xf_tag_content missing from DB xenforo_14.
Table xf_tag_result_cache missing from DB xenforo_14.
Table xf_tfa_attempt missing from DB xenforo_14.
Table xf_tfa_provider missing from DB xenforo_14.
Column xf_thread.tags missing from DB xenforo_14.xf_thread.
Column xf_user_alert.action differs in COLUMN_TYPE value (varbinary(30) vs varbinary(25)).
Column xf_user_option.use_tfa missing from DB xenforo_14.xf_user_option.
Table xf_user_tfa missing from DB xenforo_14.
Table xf_user_tfa_trusted missing from DB xenforo_14.
 
Status
Not open for further replies.
Top