summaryrefslogtreecommitdiffstats
path: root/data
diff options
context:
space:
mode:
authorSimon Rettberg2015-09-30 18:29:58 +0200
committerSimon Rettberg2015-09-30 18:29:58 +0200
commit15263d25f96ac7a031d388d2f0d5a6ea6455ef1b (patch)
tree46750b233508a5a259374a1bff9c624ff1d87e48 /data
parent[CreateLdapConfig] Only generate certificates if none exist yet (diff)
downloadtmlite-bwlp-15263d25f96ac7a031d388d2f0d5a6ea6455ef1b.tar.gz
tmlite-bwlp-15263d25f96ac7a031d388d2f0d5a6ea6455ef1b.tar.xz
tmlite-bwlp-15263d25f96ac7a031d388d2f0d5a6ea6455ef1b.zip
[dozmod-upgrade] Disable email notifications by default, will be enabled when account is merged
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.