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/4_add_user_default_target.sql | 5 +++++ 1 file changed, 5 insertions(+) (limited to 'migrations/4_add_user_default_target.sql') diff --git a/migrations/4_add_user_default_target.sql b/migrations/4_add_user_default_target.sql index 89d0b25..4486410 100644 --- a/migrations/4_add_user_default_target.sql +++ b/migrations/4_add_user_default_target.sql @@ -1,3 +1,5 @@ +BEGIN TRANSACTION; + CREATE TABLE user_default_target( "user" INTEGER NOT NULL, target INTEGER NOT NULL, @@ -10,3 +12,6 @@ INSERT INTO user_default_target SELECT users.id, roles.id FROM users INNER JOIN roles ON (roles."name" = 'Inner Circle'); + +COMMIT; + -- cgit v1.2.3