summaryrefslogtreecommitdiffstats
path: root/data
diff options
context:
space:
mode:
Diffstat (limited to 'data')
-rw-r--r--data/dozmod-upgrade.sql4
1 files changed, 2 insertions, 2 deletions
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.