Commit | Line | Data |
---|---|---|
aa1f260a FB |
1 | #!/usr/bin/env bash |
2 | ||
3 | copyTable() { | |
4 | echo "CREATE TABLE $2 LIKE $1;" | |
8425f487 FB |
5 | [[ "$3" == *"no-innodb"* ]] || echo "ALTER TABLE $2 ENGINE = InnoDB;" |
6 | [[ "$3" == *"no-content"* ]] || echo "INSERT INTO $2 SELECT * FROM $1;" | |
aa1f260a FB |
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 | ||
8425f487 FB |
51 | copyTable '#x4dat#.gapps_accounts' 'gapps_accounts' no-innodb |
52 | copyTable '#x4dat#.gapps_nicknames' 'gapps_nicknames' no-innodb | |
aa1f260a FB |
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' | |
c6d16b24 | 75 | copyTable '#x4dat#.profile_medals_grades' 'profile_medal_grade_enum' |
aa1f260a FB |
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' | |
da431170 | 97 | copyTable '#x4dat#.tips' 'reminder_tips' |
aa1f260a FB |
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 | ||
8425f487 | 115 | copyTable '#x4dat#.openid_trusted' 'account_auth_openid' no-innodb |