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