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