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/1_add_roles.sql | |
parent | 37fcd0061e27216d14e03487b6c7428e78aad55d (diff) |
Fix migrations.
Diffstat (limited to 'migrations/1_add_roles.sql')
-rw-r--r-- | migrations/1_add_roles.sql | 4 |
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 |