upgrade/account/copy_tables.sh

   1 #!/usr/bin/env bash
   2
   3 copyTable() {
   4     echo "CREATE TABLE $2 LIKE $1;"
   5     [[ "$3" == *"no-innodb"* ]] || echo "ALTER TABLE $2 ENGINE = InnoDB;"
   6     [[ "$3" == *"no-content"* ]] || echo "INSERT INTO $2 SELECT * FROM $1;"
   7 }
   8
   9
  10 copyTable '#forums#.list' 'forums'
  11 copyTable '#forums#.abos' 'forum_subs'
  12 copyTable '#forums#.innd' 'forum_innd'
  13 copyTable '#forums#.profils' 'forum_profiles'
  14
  15 copyTable '#logger#.actions' 'log_actions'
  16 copyTable '#logger#.events' 'log_events'
  17 copyTable '#logger#.last_sessions' 'log_last_sessions'
  18 copyTable '#logger#.sessions' 'log_sessions'
  19
  20 copyTable '#paiement#.paiements' 'payments'
  21 copyTable '#paiement#.codeC' 'payment_codeC'
  22 copyTable '#paiement#.codeRCB' 'payment_codeRCB'
  23 copyTable '#paiement#.methodes' 'payment_methods'
  24 copyTable '#paiement#.transactions' 'payment_transactions'
  25
  26 copyTable '#groupex#.announces' 'group_announces'
  27 copyTable '#groupex#.announces_photo' 'group_announces_photo'
  28 copyTable '#groupex#.announces_read' 'group_announces_read'
  29 copyTable '#groupex#.asso' 'groups'
  30 copyTable '#groupex#.dom' 'group_dom'
  31 copyTable '#groupex#.evenements' 'group_events'
  32 copyTable '#groupex#.evenements_items' 'group_event_items'
  33 copyTable '#groupex#.evenements_participants' 'group_event_participants'
  34 copyTable '#groupex#.membres' 'group_members'
  35 copyTable '#groupex#.membres_sub_requests' 'group_member_sub_requests'
  36 copyTable '#x4dat#.groupesx_auth' 'group_auth'
  37
  38 copyTable '#x4dat#.axletter' 'axletter'
  39 copyTable '#x4dat#.axletter_ins' 'axletter_ins'
  40 copyTable '#x4dat#.axletter_rights' 'axletter_rights'
  41
  42 copyTable '#x4dat#.newsletter' 'newsletter'
  43 copyTable '#x4dat#.newsletter_art' 'newsletter_art'
  44 copyTable '#x4dat#.newsletter_cat' 'newsletter_cat'
  45 copyTable '#x4dat#.newsletter_ins' 'newsletter_ins'
  46
  47 copyTable '#x4dat#.evenements' 'announces'
  48 copyTable '#x4dat#.evenements_photo' 'announce_photos'
  49 copyTable '#x4dat#.evenements_vus' 'announce_read'
  50
  51 copyTable '#x4dat#.gapps_accounts' 'gapps_accounts' no-innodb
  52 copyTable '#x4dat#.gapps_nicknames' 'gapps_nicknames' no-innodb
  53 copyTable '#x4dat#.gapps_queue' 'gapps_queue'
  54 copyTable '#x4dat#.gapps_reporting' 'gapps_reporting'
  55
  56 copyTable '#x4dat#.contacts' 'contacts'
  57 copyTable '#x4dat#.coupures' 'downtimes'
  58 copyTable '#x4dat#.emails_watch' 'email_watch'
  59 copyTable '#x4dat#.emails_send_save' 'email_send_save'
  60 copyTable '#x4dat#.homonymes' 'homonyms'
  61 copyTable '#x4dat#.ip_watch' 'ip_watch'
  62 copyTable '#x4dat#.mx_watch' 'mx_watch'
  63 copyTable '#x4dat#.ml_moderate' 'email_list_moderate'
  64
  65 copyTable '#x4dat#.postfix_blacklist' 'postfix_blacklist'
  66 copyTable '#x4dat#.postfix_mailseen' 'postfix_mailseen'
  67 copyTable '#x4dat#.postfix_whitelist' 'postfix_whitelist'
  68
  69 copyTable '#x4dat#.photo' 'profile_photos'
  70 copyTable '#x4dat#.binets_def' 'profile_binet_enum'
  71 copyTable '#x4dat#.binets_ins' 'profile_binets'
  72 copyTable '#x4dat#.sections' 'profile_section_enum'
  73 copyTable '#x4dat#.profile_medals' 'profile_medal_enum'
  74 copyTable '#x4dat#.profile_medals_sub' 'profile_medals'
  75 copyTable '#x4dat#.profile_medals_grades' 'profile_medal_grade_enum'
  76 copyTable '#x4dat#.competences_def' 'profile_skill_enum'
  77 copyTable '#x4dat#.competences_ins' 'profile_skills'
  78 copyTable '#x4dat#.langues_def' 'profile_langskill_enum'
  79 copyTable '#x4dat#.langues_ins' 'profile_langskills'
  80
  81 copyTable '#x4dat#.register_marketing' 'register_marketing'
  82 copyTable '#x4dat#.register_pending' 'register_pending'
  83 copyTable '#x4dat#.register_subs' 'register_subs'
  84 copyTable '#x4dat#.register_mstats' 'register_mstats'
  85
  86 copyTable '#x4dat#.reminder' 'reminder'
  87 copyTable '#x4dat#.reminder_type' 'reminder_type'
  88
  89 copyTable '#x4dat#.requests' 'requests'
  90 copyTable '#x4dat#.requests_answers' 'requests_answers'
  91 copyTable '#x4dat#.requests_hidden' 'requests_hidden'
  92
  93 copyTable '#x4dat#.search_autocomplete' 'search_autocomplete'
  94 copyTable '#x4dat#.search_name' 'search_name'
  95
  96 copyTable '#x4dat#.skins' 'skins'
  97 copyTable '#x4dat#.tips' 'reminder_tips'
  98
  99 copyTable '#x4dat#.survey_surveys' 'surveys'
 100 copyTable '#x4dat#.survey_answers' 'survey_answers'
 101 copyTable '#x4dat#.survey_votes' 'survey_votes'
 102
 103 copyTable '#x4dat#.watch_profile' 'watch_profile'
 104 copyTable '#x4dat#.perte_pass' 'account_lost_passwords'
 105
 106 copyTable '#x4dat#.emails' 'emails'
 107 copyTable '#x4dat#.aliases' 'aliases'
 108 copyTable '#x4dat#.virtual' 'virtual'
 109 copyTable '#x4dat#.virtual_domains' 'virtual_domains'
 110 copyTable '#x4dat#.virtual_redirect' 'virtual_redirect'
 111
 112 copyTable '#x4dat#.watch_nonins' 'watch_nonins'
 113 copyTable '#x4dat#.watch_promo' 'watch_promo'
 114
 115 copyTable '#x4dat#.openid_trusted' 'account_auth_openid' no-innodb