Commit | Line | Data |
---|---|---|
100e66fc FB |
1 | #!/usr/bin/php5 -q |
2 | <?php | |
3 | /*************************************************************************** | |
4 | * Copyright (C) 2003-2010 Polytechnique.org * | |
5 | * http://opensource.polytechnique.org/ * | |
6 | * * | |
7 | * This program is free software; you can redistribute it and/or modify * | |
8 | * it under the terms of the GNU General Public License as published by * | |
9 | * the Free Software Foundation; either version 2 of the License, or * | |
10 | * (at your option) any later version. * | |
11 | * * | |
12 | * This program is distributed in the hope that it will be useful, * | |
13 | * but WITHOUT ANY WARRANTY; without even the implied warranty of * | |
14 | * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * | |
15 | * GNU General Public License for more details. * | |
16 | * * | |
17 | * You should have received a copy of the GNU General Public License * | |
18 | * along with this program; if not, write to the Free Software * | |
19 | * Foundation, Inc., * | |
20 | * 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA * | |
21 | ***************************************************************************/ | |
22 | ||
23 | require('./connect.db.inc.php'); | |
24 | ||
d0293d9b | 25 | function copyTable($source, $target, $convertToInnoDB = true) |
100e66fc FB |
26 | { |
27 | XDB::execute('CREATE TABLE ' . $target . ' | |
d0293d9b FB |
28 | LIKE ' . $source); |
29 | if ($convertToInnoDB) { | |
30 | XDB::execute('ALTER TABLE ' . $target . ' | |
31 | ENGINE = InnoDB'); | |
32 | } | |
100e66fc FB |
33 | XDB::execute('INSERT INTO ' . $target . ' |
34 | SELECT * | |
35 | FROM ' . $source); | |
36 | } | |
37 | ||
38 | copyTable('#forums#.list', 'forums'); | |
39 | copyTable('#forums#.abos', 'forum_subs'); | |
40 | copyTable('#forums#.innd', 'forum_innd'); | |
41 | copyTable('#forums#.profils', 'forum_profiles'); | |
42 | ||
43 | copyTable('#logger#.actions', 'log_actions'); | |
44 | copyTable('#logger#.events', 'log_events'); | |
45 | copyTable('#logger#.last_sessions', 'log_last_sessions'); | |
46 | copyTable('#logger#.sessions', 'log_sessions'); | |
47 | ||
48 | copyTable('#paiement#.paiements', 'payments'); | |
49 | copyTable('#paiement#.codeC', 'payment_codeC'); | |
50 | copyTable('#paiement#.codeRCB', 'payment_codeRCB'); | |
51 | copyTable('#paiement#.methodes', 'payment_methods'); | |
52 | copyTable('#paiement#.transactions', 'payment_transactions'); | |
53 | ||
54 | copyTable('#groupex#.announces', 'group_announces'); | |
55 | copyTable('#groupex#.announces_photo', 'group_announces_photo'); | |
56 | copyTable('#groupex#.announces_read', 'group_announces_read'); | |
57 | copyTable('#groupex#.asso', 'groups'); | |
58 | copyTable('#groupex#.dom', 'group_dom'); | |
59 | copyTable('#groupex#.evenements', 'group_events'); | |
60 | copyTable('#groupex#.evenements_items', 'group_event_items'); | |
61 | copyTable('#groupex#.evenements_participants', 'group_event_participants'); | |
62 | copyTable('#groupex#.membres', 'group_members'); | |
63 | copyTable('#groupex#.membres_sub_requests', 'group_member_sub_requests'); | |
9d5e1087 | 64 | copyTable('#x4dat#.groupesx_auth', 'group_auth'); |
100e66fc | 65 | |
06f4daf9 FB |
66 | copyTable('#x4dat#.axletter', 'axletter'); |
67 | copyTable('#x4dat#.axletter_ins', 'axletter_ins'); | |
68 | copyTable('#x4dat#.axletter_rights', 'axletter_rights'); | |
69 | ||
70 | copyTable('#x4dat#.newsletter', 'newsletter'); | |
71 | copyTable('#x4dat#.newsletter_art', 'newsletter_art'); | |
72 | copyTable('#x4dat#.newsletter_cat', 'newsletter_cat'); | |
73 | copyTable('#x4dat#.newsletter_ins', 'newsletter_ins'); | |
74 | ||
06f4daf9 FB |
75 | copyTable('#x4dat#.evenements', 'announces'); |
76 | copyTable('#x4dat#.evenements_photo', 'announce_photos'); | |
77 | copyTable('#x4dat#.evenements_vus', 'announce_read'); | |
78 | ||
d0293d9b FB |
79 | copyTable('#x4dat#.gapps_accounts', 'gapps_accounts', false); |
80 | copyTable('#x4dat#.gapps_nicknames', 'gapps_nicknames', false); | |
06f4daf9 FB |
81 | copyTable('#x4dat#.gapps_queue', 'gapps_queue'); |
82 | copyTable('#x4dat#.gapps_reporting', 'gapps_reporting'); | |
83 | ||
84 | copyTable('#x4dat#.contacts', 'contacts'); | |
85 | copyTable('#x4dat#.coupures', 'downtimes'); | |
86 | copyTable('#x4dat#.emails_watch', 'email_watch'); | |
48e683dd | 87 | copyTable('#x4dat#.emails_send_save', 'email_send_save'); |
06f4daf9 FB |
88 | copyTable('#x4dat#.homonymes', 'homonyms'); |
89 | copyTable('#x4dat#.ip_watch', 'ip_watch'); | |
90 | copyTable('#x4dat#.mx_watch', 'mx_watch'); | |
2235cd7f | 91 | copyTable('#x4dat#.ml_moderate', 'email_list_moderate'); |
06f4daf9 FB |
92 | |
93 | copyTable('#x4dat#.postfix_blacklist', 'postfix_blacklist'); | |
94 | copyTable('#x4dat#.postfix_mailseen', 'postfix_mailseen'); | |
95 | copyTable('#x4dat#.postfix_whitelist', 'postfix_whitelist'); | |
96 | ||
100e66fc | 97 | copyTable('#x4dat#.photo', 'profile_photos'); |
5c8a71f2 FB |
98 | copyTable('#x4dat#.binets_def', 'profile_binet_enum'); |
99 | copyTable('#x4dat#.binets_ins', 'profile_binets'); | |
100 | copyTable('#x4dat#.sections', 'profile_section_enum'); | |
101 | copyTable('#x4dat#.profile_medals', 'profile_medal_enum'); | |
102 | copyTable('#x4dat#.profile_medals_sub', 'profile_medals'); | |
103 | copyTable('#x4dat#.competences_def', 'profile_skill_enum'); | |
104 | copyTable('#x4dat#.competences_ins', 'profile_skills'); | |
105 | copyTable('#x4dat#.langues_def', 'profile_langskill_enum'); | |
106 | copyTable('#x4dat#.langues_ins', 'profile_langskills'); | |
100e66fc | 107 | |
100e66fc | 108 | copyTable('#x4dat#.register_marketing', 'register_marketing'); |
06f4daf9 FB |
109 | copyTable('#x4dat#.register_pending', 'register_pending'); |
110 | copyTable('#x4dat#.register_subs', 'register_subs'); | |
111 | copyTable('#x4dat#.register_mstats', 'register_mstats'); | |
112 | ||
113 | copyTable('#x4dat#.reminder', 'reminder'); | |
114 | copyTable('#x4dat#.reminder_type', 'reminder_type'); | |
115 | ||
116 | copyTable('#x4dat#.requests', 'requests'); | |
117 | copyTable('#x4dat#.requests_answers', 'requests_answers'); | |
118 | copyTable('#x4dat#.requests_hidden', 'requests_hidden'); | |
119 | ||
120 | copyTable('#x4dat#.search_autocomplete', 'search_autocomplete'); | |
121 | copyTable('#x4dat#.search_name', 'search_name'); | |
122 | ||
123 | copyTable('#x4dat#.skins', 'skins'); | |
124 | copyTable('#x4dat#.tips', 'tips'); | |
125 | ||
126 | copyTable('#x4dat#.survey_surveys', 'surveys'); | |
d0293d9b | 127 | copyTable('#x4dat#.survey_answers', 'survey_answers'); |
06f4daf9 FB |
128 | copyTable('#x4dat#.survey_votes', 'survey_votes'); |
129 | ||
100e66fc | 130 | copyTable('#x4dat#.watch_profile', 'watch_profile'); |
06f4daf9 | 131 | copyTable('#x4dat#.perte_pass', 'account_lost_passwords'); |
100e66fc | 132 | |
d0293d9b | 133 | copyTable('#x4dat#.emails', 'emails'); |
06f4daf9 FB |
134 | copyTable('#x4dat#.aliases', 'aliases'); |
135 | copyTable('#x4dat#.virtual', 'virtual'); | |
136 | copyTable('#x4dat#.virtual_domains', 'virtual_domains'); | |
137 | copyTable('#x4dat#.virtual_redirect', 'virtual_redirect'); | |
138 | ||
139 | copyTable('#x4dat#.watch_nonins', 'watch_nonins'); | |
140 | copyTable('#x4dat#.watch_promo', 'watch_promo'); | |
d0293d9b FB |
141 | |
142 | copyTable('#x4dat#.openid_trusted', 'openid_trusted', false); | |
06f4daf9 | 143 | |
100e66fc FB |
144 | // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8: |
145 | ?> |