chore(cargo): bump hyper from 1.8.1 to 1.9.0

Bumps [hyper](https://github.com/hyperium/hyper) from 1.8.1 to 1.9.0.
- [Release notes](https://github.com/hyperium/hyper/releases)
- [Changelog](https://github.com/hyperium/hyper/blob/master/CHANGELOG.md)
- [Commits](https://github.com/hyperium/hyper/compare/v1.8.1...v1.9.0)

---
updated-dependencies:
- dependency-name: hyper
  dependency-version: 1.9.0
  dependency-type: direct:production
  update-type: version-update:semver-minor
...

Signed-off-by: dependabot[bot] <support@github.com>

Cargo.lock

@@ -2601,9 +2601,9 @@ dependencies = [
 
 [[package]]
 name = "hyper"
-version = "1.8.1"
+version = "1.9.0"
 source = "registry+https://github.com/rust-lang/crates.io-index"
-checksum = "2ab2d4f250c3d7b1c9fcdff1cece94ea4e2dfbec68614f7b87cb205f24ca9d11"
+checksum = "6299f016b246a94207e63da54dbe807655bf9e00044f73ded42c3ac5305fbcca"
 dependencies = [
  "atomic-waker",
  "bytes",
@@ -2616,7 +2616,6 @@ dependencies = [
  "httpdate",
  "itoa",
  "pin-project-lite",
- "pin-utils",
  "smallvec",
  "tokio",
  "want",

src/chatlist.rs

@@ -15,7 +15,7 @@ use crate::message::{Message, MessageState, MsgId};
 use crate::param::{Param, Params};
 use crate::stock_str;
 use crate::summary::Summary;
-use crate::tools::{IsNoneOrEmpty, Time, time_elapsed};
+use crate::tools::IsNoneOrEmpty;
 
 /// Regex to find out if a query should filter by unread messages.
 pub static IS_UNREAD_FILTER: LazyLock<regex::Regex> =
@@ -264,8 +264,7 @@ impl Chatlist {
                 ).await?
             } else {
                 //  show normal chatlist
-                let start = Time::now();
-                let items = context.sql.query_map_vec(
+                context.sql.query_map_vec(
                     "SELECT c.id, m.id
                      FROM chats c
                      LEFT JOIN msgs m
@@ -273,27 +272,17 @@ impl Chatlist {
                            AND m.id=(
                                    SELECT id
                                      FROM msgs
-                                   -- state=`OutDraft`.
-                                   WHERE state=19 AND hidden=1 AND chat_id=c.id
-                                        -- `InFresh`...`OutDelivered` inclusive except `OutDraft`.
-                                        OR state IN (10,13,16,18,20,24,26)
-                                            AND hidden=0
-                                            AND chat_id=c.id
+                                    WHERE chat_id=c.id
+                                      AND (hidden=0 OR state=?)
                                       ORDER BY timestamp DESC, id DESC LIMIT 1)
                      WHERE c.id>9 AND c.id!=?
                        AND (c.blocked=0 OR c.blocked=2)
                        AND NOT c.archived=?
                      GROUP BY c.id
                      ORDER BY c.id=0 DESC, c.archived=? DESC, IFNULL(NULLIF(m.timestamp,0),c.created_timestamp) DESC, m.id DESC;",
-                    (skip_id, ChatVisibility::Archived, ChatVisibility::Pinned),
+                    (MessageState::OutDraft, skip_id, ChatVisibility::Archived, ChatVisibility::Pinned),
                     process_row,
-                ).await?;
-                info!(
-                    context,
-                    "chatlist built in {:?}.",
-                    time_elapsed(&start),
-                );
-                items
+                ).await?
             };
             if !flag_no_specials && get_archived_cnt(context).await? > 0 {
                 if ids.is_empty() && flag_add_alldone_hint {

src/sql/migrations.rs

@@ -2373,17 +2373,6 @@ ALTER TABLE contacts ADD COLUMN name_normalized TEXT;
         .await?;
     }
 
-    inc_and_check(&mut migration_version, 152)?;
-    if dbversion < migration_version {
-        sql.execute_migration(
-            "UPDATE msgs SET state=26 WHERE state=28;
-            DROP INDEX IF EXISTS msgs_index7;
-            CREATE INDEX msgs_index7 ON msgs (state, hidden, chat_id, timestamp, id);",
-            migration_version,
-        )
-        .await?;
-    }
-
     let new_version = sql
         .get_raw_config_int(VERSION_CFG)
         .await?