upgrade/1.0.1/innodb.sh

   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'