Watch 4 Star 5 Fork 1

oldhuhu / DiscuzX 3.4 to 3.5

Join us
Explore and code with more than 5 million developers,Free private repositories !:)
Sign up
This repository doesn't specify license. Without author's permission, this code is only for learning and cannot be used for other purposes.
Discuz! X3.4 升级到 Discuz! X3.5 的升级程序及其他相关资源项目 spread retract

Clone or download
scheme-change-innodb.sql 14.41 KB
Copy Edit Web IDE Raw Blame History
ALTER TABLE pre_forum_post
MODIFY COLUMN position INT unsigned NOT NULL DEFAULT '0';
ALTER TABLE pre_common_member_grouppm
ADD INDEX gpmid(gpmid);
ALTER TABLE pre_common_admincp_cmenu ENGINE=innodb;
ALTER TABLE pre_common_admincp_group ENGINE=innodb;
ALTER TABLE pre_common_admincp_member ENGINE=innodb;
ALTER TABLE pre_common_admincp_perm ENGINE=innodb;
ALTER TABLE pre_common_admincp_session ENGINE=innodb;
ALTER TABLE pre_common_admingroup ENGINE=innodb;
ALTER TABLE pre_common_adminnote ENGINE=innodb;
ALTER TABLE pre_common_advertisement ENGINE=innodb;
ALTER TABLE pre_common_advertisement_custom ENGINE=innodb;
ALTER TABLE pre_common_banned ENGINE=innodb;
ALTER TABLE pre_common_block ENGINE=innodb;
ALTER TABLE pre_common_block_favorite ENGINE=innodb;
ALTER TABLE pre_common_block_item ENGINE=innodb;
ALTER TABLE pre_common_block_item_data ENGINE=innodb;
ALTER TABLE pre_common_block_permission ENGINE=innodb;
ALTER TABLE pre_common_block_pic ENGINE=innodb;
ALTER TABLE pre_common_block_style ENGINE=innodb;
ALTER TABLE pre_common_block_xml ENGINE=innodb;
ALTER TABLE pre_common_cache ENGINE=innodb;
ALTER TABLE pre_common_card ENGINE=innodb;
ALTER TABLE pre_common_card_log ENGINE=innodb;
ALTER TABLE pre_common_card_type ENGINE=innodb;
ALTER TABLE pre_common_connect_guest ENGINE=innodb;
ALTER TABLE pre_common_credit_log ENGINE=innodb;
ALTER TABLE pre_common_credit_log_field ENGINE=innodb;
ALTER TABLE pre_common_credit_rule ENGINE=innodb;
ALTER TABLE pre_common_credit_rule_log ENGINE=innodb;
ALTER TABLE pre_common_credit_rule_log_field ENGINE=innodb;
ALTER TABLE pre_common_cron ENGINE=innodb;
ALTER TABLE pre_common_devicetoken ENGINE=innodb;
ALTER TABLE pre_common_district ENGINE=innodb;
ALTER TABLE pre_common_diy_data ENGINE=innodb;
ALTER TABLE pre_common_domain ENGINE=innodb;
ALTER TABLE pre_common_failedip ENGINE=innodb;
ALTER TABLE pre_common_failedlogin ENGINE=innodb;
ALTER TABLE pre_common_friendlink ENGINE=innodb;
ALTER TABLE pre_common_grouppm ENGINE=innodb;
ALTER TABLE pre_common_invite ENGINE=innodb;
ALTER TABLE pre_common_magic ENGINE=innodb;
ALTER TABLE pre_common_magiclog ENGINE=innodb;
ALTER TABLE pre_common_mailcron ENGINE=innodb;
ALTER TABLE pre_common_mailqueue ENGINE=innodb;
ALTER TABLE pre_common_member ENGINE=innodb;
ALTER TABLE pre_common_member_action_log ENGINE=innodb;
ALTER TABLE pre_common_member_connect ENGINE=innodb;
ALTER TABLE pre_common_member_count ENGINE=innodb;
ALTER TABLE pre_common_member_crime ENGINE=innodb;
ALTER TABLE pre_common_member_field_forum ENGINE=innodb;
ALTER TABLE pre_common_member_field_home ENGINE=innodb;
ALTER TABLE pre_common_member_forum_buylog ENGINE=innodb;
ALTER TABLE pre_common_member_grouppm ENGINE=innodb;
ALTER TABLE pre_common_member_log ENGINE=innodb;
ALTER TABLE pre_common_member_magic ENGINE=innodb;
ALTER TABLE pre_common_member_medal ENGINE=innodb;
ALTER TABLE pre_common_member_newprompt ENGINE=innodb;
ALTER TABLE pre_common_member_profile ENGINE=innodb;
ALTER TABLE pre_common_member_profile_setting ENGINE=innodb;
ALTER TABLE pre_common_member_security ENGINE=innodb;
-- ALTER TABLE pre_common_member_secwhite ENGINE=innodb;
ALTER TABLE pre_common_member_stat_field ENGINE=innodb;
ALTER TABLE pre_common_member_status ENGINE=innodb;
ALTER TABLE pre_common_member_validate ENGINE=innodb;
ALTER TABLE pre_common_member_verify ENGINE=innodb;
ALTER TABLE pre_common_member_verify_info ENGINE=innodb;
ALTER TABLE pre_common_myapp ENGINE=innodb;
ALTER TABLE pre_common_myinvite ENGINE=innodb;
ALTER TABLE pre_common_mytask ENGINE=innodb;
ALTER TABLE pre_common_nav ENGINE=innodb;
ALTER TABLE pre_common_onlinetime ENGINE=innodb;
ALTER TABLE pre_common_optimizer ENGINE=innodb;
ALTER TABLE pre_common_patch ENGINE=innodb;
ALTER TABLE pre_common_plugin ENGINE=innodb;
ALTER TABLE pre_common_pluginvar ENGINE=innodb;
-- ALTER TABLE pre_common_process ENGINE=innodb;
ALTER TABLE pre_common_regip ENGINE=innodb;
ALTER TABLE pre_common_relatedlink ENGINE=innodb;
ALTER TABLE pre_common_remote_port ENGINE=innodb;
ALTER TABLE pre_common_report ENGINE=innodb;
ALTER TABLE pre_common_searchindex ENGINE=innodb;
-- ALTER TABLE pre_common_seccheck ENGINE=innodb;
ALTER TABLE pre_common_secquestion ENGINE=innodb;
-- ALTER TABLE pre_common_session ENGINE=innodb;
ALTER TABLE pre_common_setting ENGINE=innodb;
ALTER TABLE pre_common_smiley ENGINE=innodb;
ALTER TABLE pre_common_sphinxcounter ENGINE=innodb;
ALTER TABLE pre_common_stat ENGINE=innodb;
ALTER TABLE pre_common_statuser ENGINE=innodb;
ALTER TABLE pre_common_style ENGINE=innodb;
ALTER TABLE pre_common_stylevar ENGINE=innodb;
ALTER TABLE pre_common_syscache ENGINE=innodb;
ALTER TABLE pre_common_tag ENGINE=innodb;
ALTER TABLE pre_common_tagitem ENGINE=innodb;
ALTER TABLE pre_common_task ENGINE=innodb;
ALTER TABLE pre_common_taskvar ENGINE=innodb;
ALTER TABLE pre_common_template ENGINE=innodb;
ALTER TABLE pre_common_template_block ENGINE=innodb;
ALTER TABLE pre_common_template_permission ENGINE=innodb;
ALTER TABLE pre_common_uin_black ENGINE=innodb;
ALTER TABLE pre_common_usergroup ENGINE=innodb;
ALTER TABLE pre_common_usergroup_field ENGINE=innodb;
-- ALTER TABLE pre_common_visit ENGINE=innodb;
ALTER TABLE pre_common_word ENGINE=innodb;
ALTER TABLE pre_common_word_type ENGINE=innodb;
ALTER TABLE pre_connect_disktask ENGINE=innodb;
ALTER TABLE pre_connect_feedlog ENGINE=innodb;
ALTER TABLE pre_connect_memberbindlog ENGINE=innodb;
ALTER TABLE pre_connect_postfeedlog ENGINE=innodb;
ALTER TABLE pre_connect_tthreadlog ENGINE=innodb;
ALTER TABLE pre_forum_access ENGINE=innodb;
ALTER TABLE pre_forum_activity ENGINE=innodb;
ALTER TABLE pre_forum_activityapply ENGINE=innodb;
ALTER TABLE pre_forum_announcement ENGINE=innodb;
ALTER TABLE pre_forum_attachment ENGINE=innodb;
ALTER TABLE pre_forum_attachment_0 ENGINE=innodb;
ALTER TABLE pre_forum_attachment_1 ENGINE=innodb;
ALTER TABLE pre_forum_attachment_2 ENGINE=innodb;
ALTER TABLE pre_forum_attachment_3 ENGINE=innodb;
ALTER TABLE pre_forum_attachment_4 ENGINE=innodb;
ALTER TABLE pre_forum_attachment_5 ENGINE=innodb;
ALTER TABLE pre_forum_attachment_6 ENGINE=innodb;
ALTER TABLE pre_forum_attachment_7 ENGINE=innodb;
ALTER TABLE pre_forum_attachment_8 ENGINE=innodb;
ALTER TABLE pre_forum_attachment_9 ENGINE=innodb;
ALTER TABLE pre_forum_attachment_exif ENGINE=innodb;
ALTER TABLE pre_forum_attachment_unused ENGINE=innodb;
ALTER TABLE pre_forum_attachtype ENGINE=innodb;
ALTER TABLE pre_forum_bbcode ENGINE=innodb;
ALTER TABLE pre_forum_collection ENGINE=innodb;
ALTER TABLE pre_forum_collectioncomment ENGINE=innodb;
ALTER TABLE pre_forum_collectionfollow ENGINE=innodb;
ALTER TABLE pre_forum_collectioninvite ENGINE=innodb;
ALTER TABLE pre_forum_collectionrelated ENGINE=innodb;
ALTER TABLE pre_forum_collectionteamworker ENGINE=innodb;
ALTER TABLE pre_forum_collectionthread ENGINE=innodb;
ALTER TABLE pre_forum_creditslog ENGINE=innodb;
ALTER TABLE pre_forum_debate ENGINE=innodb;
ALTER TABLE pre_forum_debatepost ENGINE=innodb;
ALTER TABLE pre_forum_faq ENGINE=innodb;
ALTER TABLE pre_forum_filter_post ENGINE=innodb;
ALTER TABLE pre_forum_forum ENGINE=innodb;
ALTER TABLE pre_forum_forum_threadtable ENGINE=innodb;
ALTER TABLE pre_forum_forumfield ENGINE=innodb;
ALTER TABLE pre_forum_forumrecommend ENGINE=innodb;
ALTER TABLE pre_forum_groupcreditslog ENGINE=innodb;
ALTER TABLE pre_forum_groupfield ENGINE=innodb;
ALTER TABLE pre_forum_groupinvite ENGINE=innodb;
ALTER TABLE pre_forum_grouplevel ENGINE=innodb;
ALTER TABLE pre_forum_groupuser ENGINE=innodb;
ALTER TABLE pre_forum_hotreply_member ENGINE=innodb;
ALTER TABLE pre_forum_hotreply_number ENGINE=innodb;
ALTER TABLE pre_forum_imagetype ENGINE=innodb;
ALTER TABLE pre_forum_medal ENGINE=innodb;
ALTER TABLE pre_forum_medallog ENGINE=innodb;
ALTER TABLE pre_forum_memberrecommend ENGINE=innodb;
ALTER TABLE pre_forum_moderator ENGINE=innodb;
ALTER TABLE pre_forum_modwork ENGINE=innodb;
ALTER TABLE pre_forum_newthread ENGINE=innodb;
ALTER TABLE pre_forum_onlinelist ENGINE=innodb;
ALTER TABLE pre_forum_order ENGINE=innodb;
ALTER TABLE pre_forum_poll ENGINE=innodb;
ALTER TABLE pre_forum_polloption ENGINE=innodb;
ALTER TABLE pre_forum_polloption_image ENGINE=innodb;
ALTER TABLE pre_forum_pollvoter ENGINE=innodb;
ALTER TABLE pre_forum_post ENGINE=innodb;
ALTER TABLE pre_forum_post_location ENGINE=innodb;
ALTER TABLE pre_forum_post_moderate ENGINE=innodb;
ALTER TABLE pre_forum_post_tableid ENGINE=innodb;
ALTER TABLE pre_forum_postcache ENGINE=innodb;
ALTER TABLE pre_forum_postcomment ENGINE=innodb;
ALTER TABLE pre_forum_postlog ENGINE=innodb;
ALTER TABLE pre_forum_poststick ENGINE=innodb;
ALTER TABLE pre_forum_promotion ENGINE=innodb;
ALTER TABLE pre_forum_ratelog ENGINE=innodb;
ALTER TABLE pre_forum_relatedthread ENGINE=innodb;
ALTER TABLE pre_forum_replycredit ENGINE=innodb;
ALTER TABLE pre_forum_rsscache ENGINE=innodb;
ALTER TABLE pre_forum_sofa ENGINE=innodb;
ALTER TABLE pre_forum_spacecache ENGINE=innodb;
ALTER TABLE pre_forum_statlog ENGINE=innodb;
ALTER TABLE pre_forum_thread ENGINE=innodb;
ALTER TABLE pre_forum_thread_moderate ENGINE=innodb;
ALTER TABLE pre_forum_threadaddviews ENGINE=innodb;
ALTER TABLE pre_forum_threadcalendar ENGINE=innodb;
ALTER TABLE pre_forum_threadclass ENGINE=innodb;
ALTER TABLE pre_forum_threadclosed ENGINE=innodb;
-- ALTER TABLE pre_forum_threaddisablepos ENGINE=innodb;
ALTER TABLE pre_forum_threadhidelog ENGINE=innodb;
ALTER TABLE pre_forum_threadhot ENGINE=innodb;
ALTER TABLE pre_forum_threadimage ENGINE=innodb;
ALTER TABLE pre_forum_threadlog ENGINE=innodb;
ALTER TABLE pre_forum_threadmod ENGINE=innodb;
ALTER TABLE pre_forum_threadpartake ENGINE=innodb;
ALTER TABLE pre_forum_threadpreview ENGINE=innodb;
ALTER TABLE pre_forum_threadprofile ENGINE=innodb;
ALTER TABLE pre_forum_threadprofile_group ENGINE=innodb;
ALTER TABLE pre_forum_threadrush ENGINE=innodb;
ALTER TABLE pre_forum_threadtype ENGINE=innodb;
ALTER TABLE pre_forum_trade ENGINE=innodb;
ALTER TABLE pre_forum_tradecomment ENGINE=innodb;
ALTER TABLE pre_forum_tradelog ENGINE=innodb;
ALTER TABLE pre_forum_typeoption ENGINE=innodb;
ALTER TABLE pre_forum_typeoptionvar ENGINE=innodb;
ALTER TABLE pre_forum_typevar ENGINE=innodb;
ALTER TABLE pre_forum_warning ENGINE=innodb;
ALTER TABLE pre_home_album ENGINE=innodb;
ALTER TABLE pre_home_album_category ENGINE=innodb;
ALTER TABLE pre_home_appcreditlog ENGINE=innodb;
ALTER TABLE pre_home_blacklist ENGINE=innodb;
ALTER TABLE pre_home_blog ENGINE=innodb;
ALTER TABLE pre_home_blog_category ENGINE=innodb;
ALTER TABLE pre_home_blog_moderate ENGINE=innodb;
ALTER TABLE pre_home_blogfield ENGINE=innodb;
ALTER TABLE pre_home_class ENGINE=innodb;
ALTER TABLE pre_home_click ENGINE=innodb;
ALTER TABLE pre_home_clickuser ENGINE=innodb;
ALTER TABLE pre_home_comment ENGINE=innodb;
ALTER TABLE pre_home_comment_moderate ENGINE=innodb;
ALTER TABLE pre_home_docomment ENGINE=innodb;
ALTER TABLE pre_home_doing ENGINE=innodb;
ALTER TABLE pre_home_doing_moderate ENGINE=innodb;
ALTER TABLE pre_home_favorite ENGINE=innodb;
ALTER TABLE pre_home_feed ENGINE=innodb;
ALTER TABLE pre_home_feed_app ENGINE=innodb;
ALTER TABLE pre_home_follow ENGINE=innodb;
ALTER TABLE pre_home_follow_feed ENGINE=innodb;
ALTER TABLE pre_home_follow_feed_archiver ENGINE=innodb;
ALTER TABLE pre_home_friend ENGINE=innodb;
ALTER TABLE pre_home_friend_request ENGINE=innodb;
ALTER TABLE pre_home_friendlog ENGINE=innodb;
ALTER TABLE pre_home_notification ENGINE=innodb;
ALTER TABLE pre_home_pic ENGINE=innodb;
ALTER TABLE pre_home_pic_moderate ENGINE=innodb;
ALTER TABLE pre_home_picfield ENGINE=innodb;
ALTER TABLE pre_home_poke ENGINE=innodb;
ALTER TABLE pre_home_pokearchive ENGINE=innodb;
ALTER TABLE pre_home_share ENGINE=innodb;
ALTER TABLE pre_home_share_moderate ENGINE=innodb;
ALTER TABLE pre_home_show ENGINE=innodb;
ALTER TABLE pre_home_specialuser ENGINE=innodb;
ALTER TABLE pre_home_userapp ENGINE=innodb;
ALTER TABLE pre_home_userappfield ENGINE=innodb;
ALTER TABLE pre_home_visitor ENGINE=innodb;
ALTER TABLE pre_mobile_setting ENGINE=innodb;
ALTER TABLE pre_mobile_wsq_threadlist ENGINE=innodb;
ALTER TABLE pre_portal_article_content ENGINE=innodb;
ALTER TABLE pre_portal_article_count ENGINE=innodb;
ALTER TABLE pre_portal_article_moderate ENGINE=innodb;
ALTER TABLE pre_portal_article_related ENGINE=innodb;
ALTER TABLE pre_portal_article_title ENGINE=innodb;
ALTER TABLE pre_portal_article_trash ENGINE=innodb;
ALTER TABLE pre_portal_attachment ENGINE=innodb;
ALTER TABLE pre_portal_category ENGINE=innodb;
ALTER TABLE pre_portal_category_permission ENGINE=innodb;
ALTER TABLE pre_portal_comment ENGINE=innodb;
ALTER TABLE pre_portal_comment_moderate ENGINE=innodb;
ALTER TABLE pre_portal_rsscache ENGINE=innodb;
ALTER TABLE pre_portal_topic ENGINE=innodb;
ALTER TABLE pre_portal_topic_pic ENGINE=innodb;
ALTER TABLE pre_security_evilpost ENGINE=innodb;
ALTER TABLE pre_security_eviluser ENGINE=innodb;
ALTER TABLE pre_security_failedlog ENGINE=innodb;
ALTER TABLE pre_ucenter_admins ENGINE=innodb;
ALTER TABLE pre_ucenter_applications ENGINE=innodb;
ALTER TABLE pre_ucenter_badwords ENGINE=innodb;
ALTER TABLE pre_ucenter_domains ENGINE=innodb;
ALTER TABLE pre_ucenter_failedlogins ENGINE=innodb;
ALTER TABLE pre_ucenter_feeds ENGINE=innodb;
ALTER TABLE pre_ucenter_friends ENGINE=innodb;
ALTER TABLE pre_ucenter_mailqueue ENGINE=innodb;
ALTER TABLE pre_ucenter_memberfields ENGINE=innodb;
ALTER TABLE pre_ucenter_members ENGINE=innodb;
ALTER TABLE pre_ucenter_mergemembers ENGINE=innodb;
ALTER TABLE pre_ucenter_newpm ENGINE=innodb;
ALTER TABLE pre_ucenter_notelist ENGINE=innodb;
ALTER TABLE pre_ucenter_pm_indexes ENGINE=innodb;
ALTER TABLE pre_ucenter_pm_lists ENGINE=innodb;
ALTER TABLE pre_ucenter_pm_members ENGINE=innodb;
ALTER TABLE pre_ucenter_pm_messages_0 ENGINE=innodb;
ALTER TABLE pre_ucenter_pm_messages_1 ENGINE=innodb;
ALTER TABLE pre_ucenter_pm_messages_2 ENGINE=innodb;
ALTER TABLE pre_ucenter_pm_messages_3 ENGINE=innodb;
ALTER TABLE pre_ucenter_pm_messages_4 ENGINE=innodb;
ALTER TABLE pre_ucenter_pm_messages_5 ENGINE=innodb;
ALTER TABLE pre_ucenter_pm_messages_6 ENGINE=innodb;
ALTER TABLE pre_ucenter_pm_messages_7 ENGINE=innodb;
ALTER TABLE pre_ucenter_pm_messages_8 ENGINE=innodb;
ALTER TABLE pre_ucenter_pm_messages_9 ENGINE=innodb;
ALTER TABLE pre_ucenter_protectedmembers ENGINE=innodb;
ALTER TABLE pre_ucenter_settings ENGINE=innodb;
ALTER TABLE pre_ucenter_sqlcache ENGINE=innodb;
ALTER TABLE pre_ucenter_tags ENGINE=innodb;
ALTER TABLE pre_ucenter_vars ENGINE=innodb;

Comment ( 0 )

Sign in for post a comment

1
https://gitee.com/oldhuhu/DiscuzX34235.git
git@gitee.com:oldhuhu/DiscuzX34235.git
oldhuhu
DiscuzX34235
DiscuzX 3.4 to 3.5
master

Help Search