summaryrefslogtreecommitdiff
path: root/migrations/4_add_user_default_target.sql
diff options
context:
space:
mode:
Diffstat (limited to 'migrations/4_add_user_default_target.sql')
-rw-r--r--migrations/4_add_user_default_target.sql5
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;
+