<?php
/* $Id$ */

include_once './includes/bootstrap.inc';
include_once 'database/updates.inc';
drupal_bootstrap(DRUPAL_BOOTSTRAP_FULL);

// Fill this array with the drupal tables you have.
// put it in your document root, Call it and notice the first table name.
// Keep refreshing it until you go back to the first table!

$foo = _system_update_utf8(array(
				 "access",
				 "accesslog",
				 "aggregator_category",
				 "aggregator_category_feed",
				 "aggregator_category_item",
				 "aggregator_feed",
				 "aggregator_item",
				 "authmap",
				 "blocks",
				 "book",
				 "boxes",
				 "cache",
				 "client",
				 "client_system",
				 "comments",
				 "contact",
				 "dashboard",
				 "event",
				 "file_revisions",
				 "files",
				 "filter_formats",
				 "filters",
				 "flexinode_data",
				 "flexinode_field",
				 "flexinode_type",
				 "flood",
				 "forum",
				 "history",
				 "img_assist_map",
				 "inactive_users",
				 "legal_accepted",
				 "legal_conditions",
				 "locales_meta",
				 "locales_source",
				 "locales_target",
				 "massmailertemplate",
				 "menu",
				 "moderation_filters",
				 "moderation_roles",
				 "moderation_votes",
				 "node",
				 "node_access",
				 "node_comment_statistics",
				 "node_counter",
				 "node_revisions",
				 "nodequeue_nodes",
				 "nodequeue_queue",
				 "nodequeue_roles",
				 "nodequeue_types",
				 "old_revisions",
				 "permission",
				 "poll",
				 "poll_choices",
				 "poll_votes",
				 "profile_fields",
				 "profile_values",
				 "queue",
				 "role",
				 "scheduler",
				 "search_dataset",
				 "search_index",
				 "search_total",
				 "sequences",
				 "sessions",
				 "sidecontent",
				 "sn_newsletters",
				 "sn_snid_tid",
				 "sn_subscriptions",
				 "statistics_filter_browsers",
				 "subscriptions",
				 "subscriptions_holding",
				 "system",
				 "taxonomy_block",
				 "term_data",
				 "term_hierarchy",
				 "term_node",
				 "term_relation",
				 "term_synonym",
				 "tinymce_role",
				 "tinymce_settings",
				 "url_alias",
				 "users",
				 "users_roles",
				 "variable",
				 "view_argument",
				 "view_exposed_filter",
				 "view_filter",
				 "view_sort",
				 "view_tablefield",
				 "view_view",
				 "vocabulary",
				 "vocabulary_node_types",
				 "volunteer",
				 "volunteer_contact_event",
				 "watchdog",
				 "webform",
				 "webform_component",
				 "webform_role_node",
				 "webform_submitted_data",
				 "webform_tmp",
));
print_r($foo);

function update_convert_table_utf8($table) {
  $ret = array();
  $types = array('char' => 'binary',
                 'varchar' => 'varbinary',
                 'tinytext' => 'tinyblob',
                 'text' => 'blob',
                 'mediumtext' => 'mediumblob',
                 'longtext' => 'longblob');

  // Get next table in list
  $convert_to_binary = array();
  $convert_to_utf8 = array();

  // Set table default charset
  $ret[] = update_sql('ALTER TABLE {'. $table .'} DEFAULT CHARACTER SET utf8');

  // Find out which columns need converting and build SQL statements
  $result = db_query('SHOW FULL COLUMNS FROM {'. $table .'}');
  while ($column = db_fetch_array($result)) {
    list($type) = explode('(', $column['Type']);
    if (isset($types[$type])) {
      $names = 'CHANGE `'. $column['Field'] .'` `'. $column['Field'] .'` ';
      $attributes = ' DEFAULT '. ($column['Default'] == 'NULL' ? 'NULL ' :
                     "'". db_escape_string($column['Default']) ."' ") .
                    ($column['Null'] == 'YES' ? 'NULL' : 'NOT NULL');

      $convert_to_binary[] = $names . preg_replace('/'. $type .'/i', $types[$type], $column['Type']) . $attributes;
      $convert_to_utf8[] = $names . $column['Type'] .' CHARACTER SET utf8'. $attributes;
    }
  }

  if (count($convert_to_binary)) {
    // Convert text columns to binary
    $ret[] = update_sql('ALTER TABLE {'. $table .'} '. implode(', ', $convert_to_binary));
    // Convert binary columns to UTF-8
    $ret[] = update_sql('ALTER TABLE {'. $table .'} '. implode(', ', $convert_to_utf8));
  }
  return $ret;
}


function update_sql($sql) {
  $result = db_query($sql);
  return array('success' => $result !== FALSE, 'query' => check_plain($sql));
}

?>