diff options
| -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.
|