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;"
10 copyTable
'#forums#.list' 'forums'
11 copyTable
'#forums#.abos' 'forum_subs'
12 copyTable
'#forums#.innd' 'forum_innd'
13 copyTable
'#forums#.profils' 'forum_profiles'
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'
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'
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'
38 copyTable
'#x4dat#.axletter' 'axletter'
39 copyTable
'#x4dat#.axletter_ins' 'axletter_ins'
40 copyTable
'#x4dat#.axletter_rights' 'axletter_rights'
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'
47 copyTable
'#x4dat#.evenements' 'announces'
48 copyTable
'#x4dat#.evenements_photo' 'announce_photos'
49 copyTable
'#x4dat#.evenements_vus' 'announce_read'
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'
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'
65 copyTable
'#x4dat#.postfix_blacklist' 'postfix_blacklist'
66 copyTable
'#x4dat#.postfix_mailseen' 'postfix_mailseen'
67 copyTable
'#x4dat#.postfix_whitelist' 'postfix_whitelist'
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'
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'
86 copyTable
'#x4dat#.reminder' 'reminder'
87 copyTable
'#x4dat#.reminder_type' 'reminder_type'
89 copyTable
'#x4dat#.requests' 'requests'
90 copyTable
'#x4dat#.requests_answers' 'requests_answers'
91 copyTable
'#x4dat#.requests_hidden' 'requests_hidden'
93 copyTable
'#x4dat#.search_autocomplete' 'search_autocomplete'
94 copyTable
'#x4dat#.search_name' 'search_name'
96 copyTable
'#x4dat#.skins' 'skins'
97 copyTable
'#x4dat#.tips' 'reminder_tips'
99 copyTable
'#x4dat#.survey_surveys' 'surveys'
100 copyTable
'#x4dat#.survey_answers' 'survey_answers'
101 copyTable
'#x4dat#.survey_votes' 'survey_votes'
103 copyTable
'#x4dat#.watch_profile' 'watch_profile'
104 copyTable
'#x4dat#.perte_pass' 'account_lost_passwords'
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'
112 copyTable
'#x4dat#.watch_nonins' 'watch_nonins'
113 copyTable
'#x4dat#.watch_promo' 'watch_promo'
115 copyTable
'#x4dat#.openid_trusted' 'account_auth_openid' no-innodb