Сервер: отвязать PostgreSQL DM runtime от signed_messages_v2

SHiNE-server/shine-server-db/src/main/java/shine/db/dao/SignedMessagesV2DAO.java

@@ -248,9 +248,9 @@ public final class SignedMessagesV2DAO {
                     time_ms, nonce, message_type, revision_time_ms, reencrypted_at_ms,
                     raw_block, created_at_ms, source_api, origin_session_id,
                     receipt_ref_base_key, receipt_ref_type, read_at_ms
-                FROM signed_messages_v2
+                FROM %s
                 WHERE message_key = ?
-                """;
+                """.formatted(messagesTable());
             try (PreparedStatement ps = c.prepareStatement(sql)) {
                 ps.setString(1, messageKey);
                 try (ResultSet rs = ps.executeQuery()) {
@@ -571,7 +571,7 @@ public final class SignedMessagesV2DAO {
                 message_key, base_key, target_login, from_login, to_login,
                 time_ms, nonce, message_type, revision_time_ms, reencrypted_at_ms,
                 raw_block, created_at_ms, source_api, origin_session_id,
-                receipt_ref_base_key, receipt_ref_type
+                receipt_ref_base_key, receipt_ref_type, read_at_ms
             FROM %s
             WHERE message_type IN (7, 8)
               AND (

SHiNE-server/shine-server-db/src/main/resources/postgres/schema_v1.sql

@@ -541,27 +541,6 @@ CREATE TABLE IF NOT EXISTS signed_message_session_delivery (
 CREATE INDEX IF NOT EXISTS idx_signed_message_delivery_session
     ON signed_message_session_delivery(session_id, delivered);
 
-CREATE OR REPLACE VIEW signed_messages_v2 AS
-SELECT
-    message_key,
-    base_key,
-    target_login,
-    from_login,
-    to_login,
-    time_ms,
-    nonce,
-    message_type,
-    revision_time_ms,
-    reencrypted_at_ms,
-    raw_block,
-    created_at_ms,
-    source_api,
-    origin_session_id,
-    receipt_ref_base_key,
-    receipt_ref_type,
-    read_at_ms
-FROM signed_messages;
-
 CREATE TABLE IF NOT EXISTS message_views_state (
     viewer_login       TEXT NOT NULL,
     to_bch_name        TEXT NOT NULL,

VERSION.properties

@@ -1,2 +1,2 @@
 client.version=1.2.354
-server.version=1.2.325
+server.version=1.2.326