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;
}