Change log?

Samar

Member
Where can i find changelog for version 1.1.0 ?

I want to know what changes have been made in db structure in 1.1.0 as compared to version 1.0.4?
 
Then is it possible for someone to tell me whats the difference in the database structure in both versions?
 
Here's a list of db schema differences from 1.0 to 1.1 Beta 4 (thanks to Mike for the script and instructions :))

This has been run in a 1.0 environment, comparing to 1.1; clipthea_xf10 is the name of the 1.0 database.

Code:
* Table xf_admin_log missing from DB clipthea_xf10.
* Table xf_admin_search_type missing from DB clipthea_xf10.
* Column xf_bb_code_media_site.addon_id missing from DB clipthea_xf10.xf_bb_code_media_site.
* Column xf_bb_code_media_site.embed_html_callback_class missing from DB clipthea_xf10.xf_bb_code_media_site.
* Column xf_bb_code_media_site.embed_html_callback_method missing from DB clipthea_xf10.xf_bb_code_media_site.
* Column xf_bb_code_media_site.match_callback_class missing from DB clipthea_xf10.xf_bb_code_media_site.
* Column xf_bb_code_media_site.match_callback_method missing from DB clipthea_xf10.xf_bb_code_media_site.
* Column xf_bb_code_media_site.match_is_regex missing from DB clipthea_xf10.xf_bb_code_media_site.
* Column xf_conversation_message.attach_count missing from DB clipthea_xf10.xf_conversation_message.
* Column xf_conversation_message.ip_id missing from DB clipthea_xf10.xf_conversation_message.
* Column xf_feed.prefix_id missing from DB clipthea_xf10.xf_feed.
* Column xf_forum.count_messages missing from DB clipthea_xf10.xf_forum.
* Column xf_forum.default_prefix_id missing from DB clipthea_xf10.xf_forum.
* Column xf_forum.find_new missing from DB clipthea_xf10.xf_forum.
* Column xf_forum.prefix_cache missing from DB clipthea_xf10.xf_forum.
* Table xf_forum_prefix missing from DB clipthea_xf10.
* Table xf_identity_service missing from DB clipthea_xf11.
* Column xf_language.text_direction missing from DB clipthea_xf10.xf_language.
* Table xf_moderator_log missing from DB clipthea_xf10.
* Column xf_node.display_in_list differs in COLUMN_KEY value ( vs MUL).
* Table xf_notice missing from DB clipthea_xf10.
* Table xf_notice_dismissed missing from DB clipthea_xf10.
* Column xf_post.user_id differs in COLUMN_KEY value ( vs MUL).
* Column xf_post.warning_id missing from DB clipthea_xf10.xf_post.
* Column xf_post.warning_message missing from DB clipthea_xf10.xf_post.
* Column xf_profile_post.user_id differs in COLUMN_KEY value ( vs MUL).
* Column xf_profile_post.warning_id missing from DB clipthea_xf10.xf_profile_post.
* Column xf_profile_post.warning_message missing from DB clipthea_xf10.xf_profile_post.
* Column xf_profile_post_comment.ip_id missing from DB clipthea_xf10.xf_profile_post_comment.
* Column xf_search.user_results missing from DB clipthea_xf10.xf_search.
* Column xf_smilie.sprite_mode missing from DB clipthea_xf10.xf_smilie.
* Column xf_smilie.sprite_params missing from DB clipthea_xf10.xf_smilie.
* Table xf_stats_daily missing from DB clipthea_xf10.
* Column xf_thread.prefix_id missing from DB clipthea_xf10.xf_thread.
* Table xf_thread_prefix missing from DB clipthea_xf10.
* Table xf_thread_prefix_group missing from DB clipthea_xf10.
* Column xf_trophy.criteria missing from DB clipthea_xf11.xf_trophy.
* Column xf_trophy.user_criteria missing from DB clipthea_xf10.xf_trophy.
* Column xf_user.warning_points missing from DB clipthea_xf10.xf_user.
* Table xf_user_field missing from DB clipthea_xf10.
* Table xf_user_field_value missing from DB clipthea_xf10.
* Table xf_user_group_promotion missing from DB clipthea_xf10.
* Table xf_user_group_promotion_log missing from DB clipthea_xf10.
* Table xf_user_identity missing from DB clipthea_xf11.
* Table xf_user_ignored missing from DB clipthea_xf10.
* Column xf_user_profile.custom_fields missing from DB clipthea_xf10.xf_user_profile.
* Column xf_user_profile.identities missing from DB clipthea_xf11.xf_user_profile.
* Column xf_user_profile.ignored missing from DB clipthea_xf10.xf_user_profile.
 * Table xf_warning missing from DB clipthea_xf10.
* Table xf_warning_action missing from DB clipthea_xf10.
* Table xf_warning_action_trigger missing from DB clipthea_xf10.
* Table xf_warning_definition missing from DB clipthea_xf10.
 
Use a database compare tool (e.g. phpstorm have one)
dbcomparingtool.webp
or compare XenForo_Install_Data_MySql from the newest build with the previous
OR

last but not least=> check the upgrade scripts (IMO most comfortable ;) if you need only the xf data without any add-ons)
 
Well thats a good plan.

I will sure try that. Because the data provided by Brogan is incomplete(it is one sided).
 
I highly recommend SQLyog. If you work on a daily basis with databases then it will save you a lot of time.

I also highly recommend PhpStorm. So do what ragtek said as well. Tried a lot of things and these 2 programs make me a lot more efficient.
 
Top Bottom