diff options
| author | Simon Rettberg | 2015-09-30 18:29:58 +0200 |
|---|---|---|
| committer | Simon Rettberg | 2015-09-30 18:29:58 +0200 |
| commit | 15263d25f96ac7a031d388d2f0d5a6ea6455ef1b (patch) | |
| tree | 46750b233508a5a259374a1bff9c624ff1d87e48 /data | |
| parent | [CreateLdapConfig] Only generate certificates if none exist yet (diff) | |
| download | tmlite-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.sql | 4 |
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.
|