From 83780af41e3981d0da3b1c1bc3f071fea4538d55 Mon Sep 17 00:00:00 2001 From: Matthias Andreas Benkard Date: Sat, 22 Sep 2012 15:28:19 +0000 Subject: Fix migrations. --- migrations/1_add_roles.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'migrations/1_add_roles.sql') 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 -- cgit v1.2.3