X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2F0.9.16%2F03_mail_storage.sql;h=95429776376ecbd1f4329160a9967994e0efa3a3;hb=3d964835e8ff04f0f86c80aea026b82896cb4a46;hp=4774a53703f050b366de317e6921b5954d96ebdd;hpb=08fa70684fd1332178cddb6b318151335fb4506c;p=platal.git diff --git a/upgrade/0.9.16/03_mail_storage.sql b/upgrade/0.9.16/03_mail_storage.sql index 4774a53..9542977 100644 --- a/upgrade/0.9.16/03_mail_storage.sql +++ b/upgrade/0.9.16/03_mail_storage.sql @@ -1,3 +1,4 @@ -ALTER TABLE auth_user_md5 ADD COLUMN mail_storage SET('imap', 'googleapps') DEFAULT 'imap' NOT NULL AFTER smtppass; +ALTER TABLE auth_user_md5 ADD COLUMN mail_storage SET('imap', 'googleapps') DEFAULT '' NOT NULL AFTER smtppass; +UPDATE auth_user_md5 SET mail_storage = 'imap'; # vim:set syntax=mysql: