}
if (!install_column_exists($database, "VISITOR_LOG", "USER_AGENT")) {
$sql = "ALTER TABLE VISITOR_LOG ADD COLUMN USER_AGENT VARCHAR(255) DEFAULT NULL";
if (!($result = $db->query($sql))) {
$valid = false;
return;
}
}
if (!install_column_exists($database, "USER_PREFS", "SHOW_SHARE_LINKS")) {
$sql = "ALTER TABLE USER_PREFS ADD SHOW_SHARE_LINKS CHAR(1) NOT NULL DEFAULT 'Y'";
if (!($result = $db->query($sql))) {
$valid = false;
return;
}
}
if (!install_column_exists($database, "USER_PREFS", 'LEFT_FRAME_WIDTH')) {
$sql = "ALTER TABLE USER_PREFS ADD COLUMN LEFT_FRAME_WIDTH SMALLINT(4) DEFAULT '280' NOT NULL AFTER THREAD_LAST_PAGE";
if (!($result = $db->query($sql))) {
$valid = false;
return;
}
}
$sql = "ALTER TABLE USER_PREFS CHANGE UID UID MEDIUMINT(8) UNSIGNED NOT NULL";
if (!($result = $db->query($sql))) {
$valid = false;
return;
}
$sql = "ALTER TABLE USER_PREFS CHANGE FIRSTNAME FIRSTNAME VARCHAR(32) NOT NULL";
if (!($result = $db->query($sql))) {
$valid = false;
return;
$db->query($sql);
if (install_index_exists($config['db_database'], 'POST_ATTACHMENT_IDS', 'TID')) {
$sql = "ALTER TABLE POST_ATTACHMENT_IDS DROP KEY TID";
$db->query($sql);
}
$sql = "ALTER TABLE SEARCH_ENGINE_BOTS ";
$sql .= "CHANGE NAME NAME VARCHAR(32) COLLATE UTF8_GENERAL_CI NOT NULL AFTER SID, ";
$sql .= "CHANGE URL URL VARCHAR(255) COLLATE UTF8_GENERAL_CI NOT NULL AFTER NAME, ";
$sql .= "CHANGE AGENT_MATCH AGENT_MATCH VARCHAR(32) COLLATE UTF8_GENERAL_CI NOT NULL AFTER URL";
$db->query($sql);
$sql = "ALTER TABLE SEARCH_RESULTS ";
$sql .= "CHANGE TID TID MEDIUMINT(8) UNSIGNED NOT NULL AFTER FORUM, ";
$sql .= "CHANGE PID PID MEDIUMINT(8) UNSIGNED NOT NULL AFTER TID, ";
$sql .= "CHANGE RELEVANCE RELEVANCE FLOAT UNSIGNED NOT NULL AFTER PID ";
$db->query($sql);
if (install_column_exists($config['db_database'], 'SEARCH_RESULTS', 'FID')) {
$sql = "ALTER TABLE SEARCH_RESULTS DROP COLUMN FID";
$db->query($sql);
}
$sql = "ALTER TABLE TIMEZONES ";
$sql .= "CHANGE TZID TZID INT(11) NOT NULL FIRST, ";
$sql .= "CHANGE DST_OFFSET DST_OFFSET DOUBLE NULL DEFAULT 0 AFTER GMT_OFFSET";
$db->query($sql);
$sql = "ALTER TABLE USER ";
$sql .= "CHANGE LOGON LOGON VARCHAR(32) COLLATE UTF8_GENERAL_CI NOT NULL AFTER UID, ";
$sql .= "CHANGE PASSWD PASSWD VARCHAR(255) COLLATE UTF8_GENERAL_CI NOT NULL AFTER LOGON, ";
$sql .= "CHANGE SALT SALT VARCHAR(255) COLLATE UTF8_GENERAL_CI NOT NULL AFTER PASSWD, ";
$sql .= "CHANGE EMAIL EMAIL VARCHAR(80) COLLATE UTF8_GENERAL_CI NOT NULL AFTER NICKNAME, ";
$sql .= "CHANGE REGISTERED REGISTERED DATETIME NOT NULL AFTER EMAIL, ";
$sql .= "CHANGE IPADDRESS IPADDRESS VARCHAR(255) COLLATE UTF8_GENERAL_CI NOT NULL AFTER REGISTERED";
$db->query($sql);
