| 1 | #!/usr/bin/env bash |
| 2 | |
| 3 | changeEngine() { |
| 4 | echo "ALTER TABLE $1 ENGINE = InnoDB;" |
| 5 | } |
| 6 | |
| 7 | changeEngine 'account_auth_openid' |
| 8 | changeEngine 'account_lost_passwords' |
| 9 | changeEngine 'account_profiles' |
| 10 | changeEngine 'account_types' |
| 11 | changeEngine 'accounts' |
| 12 | changeEngine 'aliases' |
| 13 | changeEngine 'announce_photos' |
| 14 | changeEngine 'announce_read' |
| 15 | changeEngine 'announces' |
| 16 | changeEngine 'axletter' |
| 17 | changeEngine 'axletter_ins' |
| 18 | changeEngine 'axletter_rights' |
| 19 | changeEngine 'carvas' |
| 20 | changeEngine 'contacts' |
| 21 | changeEngine 'downtimes' |
| 22 | changeEngine 'email_list_moderate' |
| 23 | changeEngine 'email_options' |
| 24 | changeEngine 'email_send_save' |
| 25 | changeEngine 'email_watch' |
| 26 | changeEngine 'emails' |
| 27 | changeEngine 'forum_innd' |
| 28 | changeEngine 'forum_profiles' |
| 29 | changeEngine 'forum_subs' |
| 30 | changeEngine 'forums' |
| 31 | changeEngine 'gapps_accounts' |
| 32 | changeEngine 'gapps_nicknames' |
| 33 | changeEngine 'gapps_queue' |
| 34 | changeEngine 'gapps_reporting' |
| 35 | changeEngine 'geoloc_administrativeareas' |
| 36 | changeEngine 'geoloc_countries' |
| 37 | changeEngine 'geoloc_localities' |
| 38 | changeEngine 'geoloc_subadministrativeareas' |
| 39 | changeEngine 'group_announces' |
| 40 | changeEngine 'group_announces_photo' |
| 41 | changeEngine 'group_announces_read' |
| 42 | changeEngine 'group_auth' |
| 43 | changeEngine 'group_dom' |
| 44 | changeEngine 'group_event_items' |
| 45 | changeEngine 'group_event_participants' |
| 46 | changeEngine 'group_events' |
| 47 | changeEngine 'group_member_sub_requests' |
| 48 | changeEngine 'group_members' |
| 49 | changeEngine 'groups' |
| 50 | changeEngine 'homonyms' |
| 51 | changeEngine 'ip_watch' |
| 52 | changeEngine 'log_actions' |
| 53 | changeEngine 'log_events' |
| 54 | changeEngine 'log_last_sessions' |
| 55 | changeEngine 'log_sessions' |
| 56 | changeEngine 'mx_watch' |
| 57 | changeEngine 'newsletter' |
| 58 | changeEngine 'newsletter_art' |
| 59 | changeEngine 'newsletter_cat' |
| 60 | changeEngine 'newsletter_ins' |
| 61 | changeEngine 'payment_bankaccounts' |
| 62 | changeEngine 'payment_codeC' |
| 63 | changeEngine 'payment_codeRCB' |
| 64 | changeEngine 'payment_methods' |
| 65 | changeEngine 'payment_transactions' |
| 66 | changeEngine 'payments' |
| 67 | changeEngine 'postfix_blacklist' |
| 68 | changeEngine 'postfix_mailseen' |
| 69 | changeEngine 'postfix_whitelist' |
| 70 | changeEngine 'profile_addresses' |
| 71 | changeEngine 'profile_binet_enum' |
| 72 | changeEngine 'profile_binets' |
| 73 | changeEngine 'profile_corps' |
| 74 | changeEngine 'profile_corps_enum' |
| 75 | changeEngine 'profile_corps_rank_enum' |
| 76 | changeEngine 'profile_display' |
| 77 | changeEngine 'profile_education' |
| 78 | changeEngine 'profile_education_degree' |
| 79 | changeEngine 'profile_education_degree_enum' |
| 80 | changeEngine 'profile_education_enum' |
| 81 | changeEngine 'profile_education_field_enum' |
| 82 | changeEngine 'profile_job' |
| 83 | changeEngine 'profile_job_alternates' |
| 84 | changeEngine 'profile_job_enum' |
| 85 | changeEngine 'profile_job_sector_enum' |
| 86 | changeEngine 'profile_job_subsector_enum' |
| 87 | changeEngine 'profile_job_subsubsector_enum' |
| 88 | changeEngine 'profile_langskill_enum' |
| 89 | changeEngine 'profile_langskills' |
| 90 | changeEngine 'profile_medal_enum' |
| 91 | changeEngine 'profile_medal_grade_enum' |
| 92 | changeEngine 'profile_medals' |
| 93 | changeEngine 'profile_mentor' |
| 94 | changeEngine 'profile_mentor_country' |
| 95 | changeEngine 'profile_mentor_sector' |
| 96 | changeEngine 'profile_name' |
| 97 | changeEngine 'profile_name_enum' |
| 98 | changeEngine 'profile_networking' |
| 99 | changeEngine 'profile_networking_enum' |
| 100 | changeEngine 'profile_phones' |
| 101 | changeEngine 'profile_photos' |
| 102 | changeEngine 'profile_section_enum' |
| 103 | changeEngine 'profile_skill_enum' |
| 104 | changeEngine 'profile_skills' |
| 105 | changeEngine 'profiles' |
| 106 | changeEngine 'register_marketing' |
| 107 | changeEngine 'register_mstats' |
| 108 | changeEngine 'register_pending' |
| 109 | changeEngine 'register_subs' |
| 110 | changeEngine 'reminder' |
| 111 | changeEngine 'reminder_tips' |
| 112 | changeEngine 'reminder_type' |
| 113 | changeEngine 'requests' |
| 114 | changeEngine 'requests_answers' |
| 115 | changeEngine 'requests_hidden' |
| 116 | changeEngine 'search_autocomplete' |
| 117 | changeEngine 'search_name' |
| 118 | changeEngine 'skins' |
| 119 | changeEngine 'survey_answers' |
| 120 | changeEngine 'survey_votes' |
| 121 | changeEngine 'surveys' |
| 122 | changeEngine 'virtual' |
| 123 | changeEngine 'virtual_domains' |
| 124 | changeEngine 'virtual_redirect' |
| 125 | changeEngine 'watch' |
| 126 | changeEngine 'watch_nonins' |
| 127 | changeEngine 'watch_profile' |
| 128 | changeEngine 'watch_promo' |