diff options
Diffstat (limited to 'migrations')
| -rw-r--r-- | migrations/20241009031441_login_created_at.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/migrations/20241009031441_login_created_at.sql b/migrations/20241009031441_login_created_at.sql index 001c48e..bef4c28 100644 --- a/migrations/20241009031441_login_created_at.sql +++ b/migrations/20241009031441_login_created_at.sql @@ -41,7 +41,8 @@ select login.id from login left join message - on login.id = message.sender; + on login.id = message.sender +group by login.id; insert into unsequenced (at, channel) select created_at, id |