X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2Faccount%2Fcopy_tables.sh;h=8c5abf508d635bd8d342b59b75a08a9d12e6d550;hb=34465ab035104f739a54ec62660f04f874448627;hp=8f026c35b9853b1f6030981394e959281b3c045a;hpb=aa1f260a73063805648c82a2198499f161966e31;p=platal.git diff --git a/upgrade/account/copy_tables.sh b/upgrade/account/copy_tables.sh index 8f026c3..8c5abf5 100755 --- a/upgrade/account/copy_tables.sh +++ b/upgrade/account/copy_tables.sh @@ -2,10 +2,8 @@ copyTable() { echo "CREATE TABLE $2 LIKE $1;" - if [ -z "$3" ] ; then - echo "ALTER TABLE $2 ENGINE = InnoDB;" - fi - echo "INSERT INTO $2 SELECT * FROM $1;" + [[ "$3" == *"no-innodb"* ]] || echo "ALTER TABLE $2 ENGINE = InnoDB;" + [[ "$3" == *"no-content"* ]] || echo "INSERT INTO $2 SELECT * FROM $1;" } @@ -50,8 +48,8 @@ copyTable '#x4dat#.evenements' 'announces' copyTable '#x4dat#.evenements_photo' 'announce_photos' copyTable '#x4dat#.evenements_vus' 'announce_read' -copyTable '#x4dat#.gapps_accounts' 'gapps_accounts' 'false' -copyTable '#x4dat#.gapps_nicknames' 'gapps_nicknames' 'false' +copyTable '#x4dat#.gapps_accounts' 'gapps_accounts' no-innodb +copyTable '#x4dat#.gapps_nicknames' 'gapps_nicknames' no-innodb copyTable '#x4dat#.gapps_queue' 'gapps_queue' copyTable '#x4dat#.gapps_reporting' 'gapps_reporting' @@ -95,7 +93,7 @@ copyTable '#x4dat#.search_autocomplete' 'search_autocomplete' copyTable '#x4dat#.search_name' 'search_name' copyTable '#x4dat#.skins' 'skins' -copyTable '#x4dat#.tips' 'tips' +copyTable '#x4dat#.tips' 'reminder_tips' copyTable '#x4dat#.survey_surveys' 'surveys' copyTable '#x4dat#.survey_answers' 'survey_answers' @@ -113,4 +111,4 @@ copyTable '#x4dat#.virtual_redirect' 'virtual_redirect' copyTable '#x4dat#.watch_nonins' 'watch_nonins' copyTable '#x4dat#.watch_promo' 'watch_promo' -copyTable '#x4dat#.openid_trusted' 'account_auth_openid' 'false' +copyTable '#x4dat#.openid_trusted' 'account_auth_openid' no-innodb