diff options
author | Matthias Andreas Benkard <code@mail.matthias.benkard.de> | 2012-08-18 16:10:52 +0200 |
---|---|---|
committer | Matthias Andreas Benkard <code@mail.matthias.benkard.de> | 2012-08-18 16:10:52 +0200 |
commit | d1c51370a79867089f002a0b61cc3c6eb0680d08 (patch) | |
tree | dcfeca254f0a29053dc57a502e8b7761e30a179e /schema.sql | |
parent | 9acbd8e14f6ef3ec5a04081294a26ecc3a3333ec (diff) |
Fix view user_visible_lazychat_messages; adapt Lafargue implementation.
Diffstat (limited to 'schema.sql')
-rw-r--r-- | schema.sql | 9 |
1 files changed, 6 insertions, 3 deletions
@@ -231,9 +231,12 @@ CREATE TRIGGER new_user_create_user_role EXECUTE PROCEDURE new_user_create_user_role(); CREATE VIEW user_visible_lazychat_messages AS - SELECT eur.user, t.message - FROM effective_user_roles eur, lazychat_targets t - WHERE t.target = eur.role; + SELECT eur.user, t.message + FROM effective_user_roles eur, lazychat_targets t + WHERE t.target = eur.role + UNION + SELECT m.author, m.message + FROM lazychat_messages m; ROLLBACK; --COMMIT; |