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/6_genericize_access_control.sql | |
parent | 37fcd0061e27216d14e03487b6c7428e78aad55d (diff) |
Fix migrations.
Diffstat (limited to 'migrations/6_genericize_access_control.sql')
-rw-r--r-- | migrations/6_genericize_access_control.sql | 7 |
1 files changed, 6 insertions, 1 deletions
diff --git a/migrations/6_genericize_access_control.sql b/migrations/6_genericize_access_control.sql index b415d5b..c7727bf 100644 --- a/migrations/6_genericize_access_control.sql +++ b/migrations/6_genericize_access_control.sql @@ -1,3 +1,5 @@ +BEGIN; + ALTER TABLE lazychat_targets RENAME TO post_targets; CREATE VIEW user_visible_posts AS @@ -5,10 +7,13 @@ CREATE VIEW user_visible_posts AS FROM effective_user_roles eur, post_targets t WHERE t.target = eur.role UNION - SELECT m.owner, m.message + SELECT m.owner, m.id FROM posts m; CREATE OR REPLACE VIEW user_visible_lazychat_messages AS SELECT uvp.user, uvp.message FROM user_visible_posts uvp INNER JOIN lazychat_messages lm ON lm.id = uvp.message; + +COMMIT; + |