Ubuntu

migration = $factory; $this->userTable = Common::prefixTable('user'); $this->optionTable = Common::prefixTable('option'); } /** * * @return Migration[] */ public function getMigrations(Updater $updater) { return [$this->migration->db->addColumns('user', ['ts_last_seen' => 'TIMESTAMP null DEFAULT null']), $this->migration->db->addColumns('user', ['ts_inactivity_notified' => 'TIMESTAMP null DEFAULT null']), $this->migration->db->sql($this->migrateLastLoginFromOptionsTableSql()), $this->migration->db->sql($this->removeLegacyValuesFromOptionsTableSql())]; } private function migrateLastLoginFromOptionsTableSql() : string { return sprintf("UPDATE `%s` u JOIN (\n SELECT \n SUBSTRING_INDEX(o.option_name, 'UsersManager.lastSeen.', -1) AS login,\n o.option_value AS last_seen\n FROM `%s` o\n WHERE o.option_name LIKE 'UsersManager.lastSeen.%%'\n ) AS userData\n ON u.login = userData.login\n SET u.ts_last_seen = CONVERT_TZ(FROM_UNIXTIME(userData.last_seen), 'SYSTEM', '+00:00')", $this->userTable, $this->optionTable); } private function removeLegacyValuesFromOptionsTableSql() : string { return sprintf("DELETE FROM `%s` WHERE option_name LIKE 'UsersManager.lastSeen.%%'", $this->optionTable); } public function doUpdate(Updater $updater) { $updater->executeMigrations(__FILE__, $this->getMigrations($updater)); } }