| 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#.email_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 |