diff options
| author | Matthias Andreas Benkard <code@mail.matthias.benkard.de> | 2012-09-22 15:28:19 +0000 |
|---|---|---|
| committer | Matthias Andreas Benkard <code@mail.matthias.benkard.de> | 2012-09-22 15:28:19 +0000 |
| commit | 83780af41e3981d0da3b1c1bc3f071fea4538d55 (patch) | |
| tree | 4a7d1a2c65631a8f3a6438cee109aee41dce7c15 /migrations/3_fix_lazychat_message_visibility.sql | |
| parent | 37fcd0061e27216d14e03487b6c7428e78aad55d (diff) | |
Fix migrations.
Diffstat (limited to 'migrations/3_fix_lazychat_message_visibility.sql')
| -rw-r--r-- | migrations/3_fix_lazychat_message_visibility.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/migrations/3_fix_lazychat_message_visibility.sql b/migrations/3_fix_lazychat_message_visibility.sql index 4af6b30..9f200ef 100644 --- a/migrations/3_fix_lazychat_message_visibility.sql +++ b/migrations/3_fix_lazychat_message_visibility.sql @@ -3,5 +3,5 @@ CREATE OR REPLACE VIEW user_visible_lazychat_messages AS FROM effective_user_roles eur, lazychat_targets t WHERE t.target = eur.role UNION - SELECT m.author, m.message + SELECT m.author, m.id FROM lazychat_messages m; |