upgrade/account/copy_tables.php

   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
  25 function copyTable($source, $target, $convertToInnoDB = true)
  26 {
  27     XDB::execute('CREATE TABLE  ' . $target . '
  28                           LIKE  ' . $source);
  29     if ($convertToInnoDB) {
  30         XDB::execute('ALTER TABLE  ' . $target . '
  31                            ENGINE = InnoDB');
  32     }
  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');
  64 copyTable('#x4dat#.groupesx_auth', 'group_auth');
  65
  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
  75 copyTable('#x4dat#.evenements', 'announces');
  76 copyTable('#x4dat#.evenements_photo', 'announce_photos');
  77 copyTable('#x4dat#.evenements_vus', 'announce_read');
  78
  79 copyTable('#x4dat#.gapps_accounts', 'gapps_accounts', false);
  80 copyTable('#x4dat#.gapps_nicknames', 'gapps_nicknames', false);
  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');
  87 copyTable('#x4dat#.emails_send_save', 'email_send_save');
  88 copyTable('#x4dat#.homonymes', 'homonyms');
  89 copyTable('#x4dat#.ip_watch', 'ip_watch');
  90 copyTable('#x4dat#.mx_watch', 'mx_watch');
  91 copyTable('#x4dat#.ml_moderate', 'email_list_moderate');
  92
  93 copyTable('#x4dat#.postfix_blacklist', 'postfix_blacklist');
  94 copyTable('#x4dat#.postfix_mailseen', 'postfix_mailseen');
  95 copyTable('#x4dat#.postfix_whitelist', 'postfix_whitelist');
  96
  97 copyTable('#x4dat#.photo', 'profile_photos');
  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');
 107
 108 copyTable('#x4dat#.register_marketing', 'register_marketing');
 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');
 127 copyTable('#x4dat#.survey_answers', 'survey_answers');
 128 copyTable('#x4dat#.survey_votes', 'survey_votes');
 129
 130 copyTable('#x4dat#.watch_profile', 'watch_profile');
 131 copyTable('#x4dat#.perte_pass', 'account_lost_passwords');
 132
 133 copyTable('#x4dat#.emails', 'emails');
 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');
 141
 142 copyTable('#x4dat#.openid_trusted', 'account_auth_openid', false);
 143
 144 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
 145 ?>