You are here

function inactive_user_upgrade_5000 in Inactive User 5

Change to more appropriate, smaller data types in MySQL.

Return value

array

File

./inactive_user.install, line 68

Code

function inactive_user_upgrade_5000() {
  $ret = array();
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      $ret[] = update_sql("ALTER TABLE {inactive_users} CHANGE uid uid INT(10) UNSIGNED NOT NULL DEFAULT '0'");
      $ret[] = update_sql("ALTER TABLE {inactive_users} CHANGE notified_admin notified_user TINYINT(1) UNSIGNED NOT NULL DEFAULT '0'");
      $ret[] = update_sql("ALTER TABLE {inactive_users} CHANGE notified_user notified_user TINYINT(1) UNSIGNED NOT NULL DEFAULT '0'");
      $ret[] = update_sql("ALTER TABLE {inactive_users} CHANGE notified_user_block notified_user_block TINYINT(1) UNSIGNED NOT NULL DEFAULT '0'");
      $ret[] = update_sql("ALTER TABLE {inactive_users} CHANGE notified_admin_block notified_admin_block TINYINT(1) UNSIGNED NOT NULL DEFAULT '0'");
      $ret[] = update_sql("ALTER TABLE {inactive_users} CHANGE protected protected TINYINT(1) UNSIGNED NOT NULL DEFAULT '0'");
      break;
  }
  return $ret;
}