X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2F0.9.16%2F03_mail_storage.sql;h=95429776376ecbd1f4329160a9967994e0efa3a3;hb=21c7c593d7100a887f984c49a82c03eb32169fc4;hp=4774a53703f050b366de317e6921b5954d96ebdd;hpb=756ff73fbb0cdd01cce2eda27ba18e1cc99bd735;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: