summaryrefslogtreecommitdiff
path: root/migrations/1_add_roles.sql
diff options
context:
space:
mode:
authorMatthias Andreas Benkard <code@mail.matthias.benkard.de>2012-09-22 15:28:19 +0000
committerMatthias Andreas Benkard <code@mail.matthias.benkard.de>2012-09-22 15:28:19 +0000
commit83780af41e3981d0da3b1c1bc3f071fea4538d55 (patch)
tree4a7d1a2c65631a8f3a6438cee109aee41dce7c15 /migrations/1_add_roles.sql
parent37fcd0061e27216d14e03487b6c7428e78aad55d (diff)
Fix migrations.
Diffstat (limited to 'migrations/1_add_roles.sql')
-rw-r--r--migrations/1_add_roles.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/migrations/1_add_roles.sql b/migrations/1_add_roles.sql
index f55d6bf..802d9f8 100644
--- a/migrations/1_add_roles.sql
+++ b/migrations/1_add_roles.sql
@@ -90,7 +90,7 @@ WITH world(id) AS (
INSERT INTO lazychat_targets
SELECT m.id, world.id
FROM lazychat_messages m, world
- WHERE m.visibility = 'public';
+ WHERE m.visibility = 'public'
)
INSERT INTO role_tags SELECT id, 'world' FROM world;
@@ -131,7 +131,7 @@ $$ LANGUAGE plpgsql;
CREATE TRIGGER new_user_put_in_universal_role
AFTER INSERT ON users
FOR EACH ROW
- EXECUTE PROCEDURE put_new_user_in_universal_role();
+ EXECUTE PROCEDURE new_user_put_in_universal_role();
CREATE FUNCTION new_user_put_user_in_user_role() RETURNS TRIGGER AS $$
BEGIN