diff options
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; + |