# 2026-10-26T17:31:49Z native stand: empty database -> API start applies migrations; second run is a no-op
$ grep migrations /srv/stand/api.log
api.log:{"ts": "2026-10-26T17:31:46Z", "level": "info", "logger": "messenger.db", "msg": "migration applied", "version": "0002_cache_invalidation_outbox"}
api.log:{"ts": "2026-10-26T17:31:46Z", "level": "info", "logger": "messenger.http", "msg": "migrations checked", "applied": ["0001_init", "0002_cache_invalidation_outbox"]}
api-ttl.log:{"ts": "2026-10-26T17:24:57Z", "level": "info", "logger": "messenger.http", "msg": "migrations checked", "applied": []}
api-ttl.log:{"ts": "2026-10-26T17:31:46Z", "level": "info", "logger": "messenger.http", "msg": "migrations checked", "applied": []}

$ python -m messenger migrate   # repeat
{"applied": []}

$ psql -c "\dt" ; select * from schema_migrations
                    List of relations
 Schema |            Name             | Type  |   Owner   
--------+-----------------------------+-------+-----------
 public | chat_members                | table | messenger
 public | chats                       | table | messenger
 public | messages                    | table | messenger
 public | schema_migrations           | table | messenger
 public | session_cache_invalidations | table | messenger
 public | sessions                    | table | messenger
 public | users                       | table | messenger
(7 rows)

            version             |   checksum   |          applied_at           
--------------------------------+--------------+-------------------------------
 0001_init                      | 64c1576d88cc | 2026-10-26 20:31:46.828818+03
 0002_cache_invalidation_outbox | fcebf1c9345a | 2026-10-26 20:31:46.834237+03
(2 rows)

                                      List of relations
 Schema |               Name               | Type  |   Owner   |            Table            
--------+----------------------------------+-------+-----------+-----------------------------
 public | chat_members_pkey                | index | messenger | chat_members
 public | chat_members_position_key        | index | messenger | chat_members
 public | chat_members_user_idx            | index | messenger | chat_members
 public | chats_pkey                       | index | messenger | chats
 public | messages_chat_created_id_idx     | index | messenger | messages
 public | messages_pkey                    | index | messenger | messages
 public | schema_migrations_pkey           | index | messenger | schema_migrations
 public | session_cache_invalidations_pkey | index | messenger | session_cache_invalidations
 public | sessions_expires_idx             | index | messenger | sessions
 public | sessions_pkey                    | index | messenger | sessions
 public | sessions_user_idx                | index | messenger | sessions
 public | users_pkey                       | index | messenger | users
 public | users_username_key               | index | messenger | users
(13 rows)

