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 $globals->dbuser = 'admin';
  26 $globals->dbpwd  = 'lknjiuhb';
  27 $globals->debug  = 1;
  28
  29 function copyTable($source, $target, $convertToInnoDB = true)
  30 {
  31     XDB::execute('CREATE TABLE  ' . $target . '
  32                           LIKE  ' . $source);
  33     if ($convertToInnoDB) {
  34         XDB::execute('ALTER TABLE  ' . $target . '
  35                            ENGINE = InnoDB');
  36     }
  37     XDB::execute('INSERT INTO  ' . $target . '
  38                        SELECT  *
  39                          FROM  ' . $source);
  40 }
  41
  42 copyTable('#forums#.list', 'forums');
  43 copyTable('#forums#.abos', 'forum_subs');
  44 copyTable('#forums#.innd', 'forum_innd');
  45 copyTable('#forums#.profils', 'forum_profiles');
  46
  47 copyTable('#logger#.actions', 'log_actions');
  48 copyTable('#logger#.events', 'log_events');
  49 copyTable('#logger#.last_sessions', 'log_last_sessions');
  50 copyTable('#logger#.sessions', 'log_sessions');
  51
  52 copyTable('#paiement#.paiements', 'payments');
  53 copyTable('#paiement#.codeC', 'payment_codeC');
  54 copyTable('#paiement#.codeRCB', 'payment_codeRCB');
  55 copyTable('#paiement#.methodes', 'payment_methods');
  56 copyTable('#paiement#.transactions', 'payment_transactions');
  57
  58 copyTable('#groupex#.announces', 'group_announces');
  59 copyTable('#groupex#.announces_photo', 'group_announces_photo');
  60 copyTable('#groupex#.announces_read', 'group_announces_read');
  61 copyTable('#groupex#.asso', 'groups');
  62 copyTable('#groupex#.dom', 'group_dom');
  63 copyTable('#groupex#.evenements', 'group_events');
  64 copyTable('#groupex#.evenements_items', 'group_event_items');
  65 copyTable('#groupex#.evenements_participants', 'group_event_participants');
  66 copyTable('#groupex#.membres', 'group_members');
  67 copyTable('#groupex#.membres_sub_requests', 'group_member_sub_requests');
  68 copyTable('#x4dat#.groupesx_auth', 'group_auth');
  69
  70 copyTable('#x4dat#.axletter', 'axletter');
  71 copyTable('#x4dat#.axletter_ins', 'axletter_ins');
  72 copyTable('#x4dat#.axletter_rights', 'axletter_rights');
  73
  74 copyTable('#x4dat#.newsletter', 'newsletter');
  75 copyTable('#x4dat#.newsletter_art', 'newsletter_art');
  76 copyTable('#x4dat#.newsletter_cat', 'newsletter_cat');
  77 copyTable('#x4dat#.newsletter_ins', 'newsletter_ins');
  78
  79
  80 copyTable('#x4dat#.evenements', 'announces');
  81 copyTable('#x4dat#.evenements_photo', 'announce_photos');
  82 copyTable('#x4dat#.evenements_vus', 'announce_read');
  83
  84 copyTable('#x4dat#.gapps_accounts', 'gapps_accounts', false);
  85 copyTable('#x4dat#.gapps_nicknames', 'gapps_nicknames', false);
  86 copyTable('#x4dat#.gapps_queue', 'gapps_queue');
  87 copyTable('#x4dat#.gapps_reporting', 'gapps_reporting');
  88
  89 copyTable('#x4dat#.contacts', 'contacts');
  90 copyTable('#x4dat#.coupures', 'downtimes');
  91 copyTable('#x4dat#.emails_watch', 'email_watch');
  92 copyTable('#x4dat#.homonymes', 'homonyms');
  93 copyTable('#x4dat#.ip_watch', 'ip_watch');
  94 copyTable('#x4dat#.mx_watch', 'mx_watch');
  95 copyTable('#x4dat#.ml_moderate', 'ml_moderate');
  96
  97 copyTable('#x4dat#.postfix_blacklist', 'postfix_blacklist');
  98 copyTable('#x4dat#.postfix_mailseen', 'postfix_mailseen');
  99 copyTable('#x4dat#.postfix_whitelist', 'postfix_whitelist');
 100
 101 copyTable('#x4dat#.photo', 'profile_photos');
 102 copyTable('#x4dat#.binets_def', 'profile_binet_enum');
 103 copyTable('#x4dat#.binets_ins', 'profile_binets');
 104 copyTable('#x4dat#.sections', 'profile_section_enum');
 105 copyTable('#x4dat#.profile_medals', 'profile_medal_enum');
 106 copyTable('#x4dat#.profile_medals_sub', 'profile_medals');
 107 copyTable('#x4dat#.competences_def', 'profile_skill_enum');
 108 copyTable('#x4dat#.competences_ins', 'profile_skills');
 109 copyTable('#x4dat#.langues_def', 'profile_langskill_enum');
 110 copyTable('#x4dat#.langues_ins', 'profile_langskills');
 111
 112 copyTable('#x4dat#.register_marketing', 'register_marketing');
 113 copyTable('#x4dat#.register_pending', 'register_pending');
 114 copyTable('#x4dat#.register_subs', 'register_subs');
 115 copyTable('#x4dat#.register_mstats', 'register_mstats');
 116
 117 copyTable('#x4dat#.reminder', 'reminder');
 118 copyTable('#x4dat#.reminder_type', 'reminder_type');
 119
 120 copyTable('#x4dat#.requests', 'requests');
 121 copyTable('#x4dat#.requests_answers', 'requests_answers');
 122 copyTable('#x4dat#.requests_hidden', 'requests_hidden');
 123
 124 copyTable('#x4dat#.search_autocomplete', 'search_autocomplete');
 125 copyTable('#x4dat#.search_name', 'search_name');
 126
 127 copyTable('#x4dat#.skins', 'skins');
 128 copyTable('#x4dat#.tips', 'tips');
 129
 130 copyTable('#x4dat#.survey_surveys', 'surveys');
 131 copyTable('#x4dat#.survey_answers', 'survey_answers');
 132 copyTable('#x4dat#.survey_votes', 'survey_votes');
 133
 134 copyTable('#x4dat#.watch_profile', 'watch_profile');
 135 copyTable('#x4dat#.perte_pass', 'account_lost_passwords');
 136
 137 copyTable('#x4dat#.geoloc_pays', 'geoloc_pays');
 138
 139 copyTable('#x4dat#.emails', 'emails');
 140 copyTable('#x4dat#.aliases', 'aliases');
 141 copyTable('#x4dat#.virtual', 'virtual');
 142 copyTable('#x4dat#.virtual_domains', 'virtual_domains');
 143 copyTable('#x4dat#.virtual_redirect', 'virtual_redirect');
 144
 145 copyTable('#x4dat#.watch_nonins', 'watch_nonins');
 146 copyTable('#x4dat#.watch_promo', 'watch_promo');
 147
 148 copyTable('#x4dat#.openid_trusted', 'openid_trusted', false);
 149
 150 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
 151 ?>