I have a question... Is it okay to change all database tables to Dynamic?
There are a few extension that gave an error on installation, error told me to change the table to "Dynamic".
So then I thought maybe it's better to change all tables at once...
Will that give any problems at some point?
And is this the correct way to di it:
Code: Select all
ALTER TABLE `phpbb_acl_arcade_groups` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_acl_arcade_options` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_acl_arcade_roles` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_acl_arcade_roles_data` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_acl_arcade_users` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_acl_groups` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_acl_options` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_acl_roles` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_acl_roles_data` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_acl_users` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_arcade_access` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_arcade_announce` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_arcade_announce_data` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_arcade_categories` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_arcade_challenge` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_arcade_challenge_champ` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_arcade_config` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_arcade_delete_games` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_arcade_download` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_arcade_favorites` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_arcade_games` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_arcade_game_rating` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_arcade_logs` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_arcade_menu` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_arcade_plays` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_arcade_ranks` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_arcade_reports` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_arcade_scores` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_arcade_sessions` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_arcade_super_scores` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_arcade_tour` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_arcade_tour_champ` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_arcade_tour_wins` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_arcade_users` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_arcade_users_banned` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_attachments` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_banlist` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_bbcodes` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_bookmarks` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_bots` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_captcha_answers` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_captcha_questions` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_config` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_config_text` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_confirm` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_disallow` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_dm_partners` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_drafts` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_ext` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_extensions` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_extension_groups` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_forums` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_forums_access` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_forums_track` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_forums_watch` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_groups` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_icons` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_image_upload` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_jv_points_transfer_log` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_jv_shoutbox` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_lang` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_log` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_login_attempts` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_migrations` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_moderator_cache` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_modules` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_notifications` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_notification_emails` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_notification_types` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_oauth_accounts` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_oauth_states` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_oauth_tokens` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_poll_options` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_poll_votes` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_portal_config` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_portal_modules` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_posts` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_ppde_currency` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_ppde_donation_pages` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_ppde_txn_log` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_privmsgs` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_privmsgs_folder` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_privmsgs_rules` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_privmsgs_to` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_profile_fields` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_profile_fields_data` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_profile_fields_lang` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_profile_lang` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_qa_confirm` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_ranks` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_reports` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_reports_reasons` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_search_results` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_search_wordlist` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_search_wordmatch` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_sessions` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_sessions_keys` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_sitelist` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_smilies` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_sortables_answers` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_sortables_confirm` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_sortables_questions` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_styles` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_teampage` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_topics` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_topics_posted` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_topics_track` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_topics_watch` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_topic_prefixes` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_userdownloadslog` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_users` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_user_group` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_user_notifications` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_warnings` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_whovisitedthistopic` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_words` ROW_FORMAT=DYNAMIC;
ALTER TABLE `phpbb_zebra` ROW_FORMAT=DYNAMIC;