From 15263d25f96ac7a031d388d2f0d5a6ea6455ef1b Mon Sep 17 00:00:00 2001
From: Simon Rettberg
Date: Wed, 30 Sep 2015 18:29:58 +0200
Subject: [dozmod-upgrade] Disable email notifications by default, will be
 enabled when account is merged

---
 data/dozmod-upgrade.sql | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'data/dozmod-upgrade.sql')

diff --git a/data/dozmod-upgrade.sql b/data/dozmod-upgrade.sql
index abca7b3..f235926 100644
--- a/data/dozmod-upgrade.sql
+++ b/data/dozmod-upgrade.sql
@@ -9,8 +9,8 @@ DELETE FROM imagebase;
 DELETE FROM user;
 
 -- Migrate users (set all to specific organisation)
-INSERT INTO sat.user (userid, firstname, lastname, email, organizationid, canlogin)
-	SELECT bw.userID, bw.Vorname, bw.Nachname, Concat('@', bw.mail, '@'), 'hs-offenburg.de', 1
+INSERT INTO sat.user (userid, firstname, lastname, email, organizationid, canlogin, emailnotifications)
+	SELECT bw.userID, bw.Vorname, bw.Nachname, Concat('@', bw.mail, '@'), 'hs-offenburg.de', 1, 0
 	FROM bwLehrpool.m_user AS bw;
 
 -- Insert dummy account to which we link all images/lectures without existing real user.
-- 
cgit v1.2.3-55-g7522

