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/4_add_user_default_target.sql | |
parent | 37fcd0061e27216d14e03487b6c7428e78aad55d (diff) |
Fix migrations.
Diffstat (limited to 'migrations/4_add_user_default_target.sql')
-rw-r--r-- | migrations/4_add_user_default_target.sql | 5 |
1 files changed, 5 insertions, 0 deletions
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; + |