Adapts homonyms issues to new mail chain.

[platal.git] / upgrade / 1.1.0 / 01_new_mail_schema.sql

diff --git a/upgrade/1.1.0/01_new_mail_schema.sql b/upgrade/1.1.0/01_new_mail_schema.sql
index 1d599b1..46cbd97 100644 (file)
--- a/upgrade/1.1.0/01_new_mail_schema.sql
+++ b/upgrade/1.1.0/01_new_mail_schema.sql
@@ -35,7 +35,7 @@ CREATE TABLE email_source_other (
   domain SMALLINT(3) UNSIGNED NOT NULL DEFAULT 1,
   hrmid VARCHAR(255) NOT NULL,
   type ENUM('homonym', 'ax', 'honeypot'),
-  expire DATE NOT NULL DEFAULT '0000-00-00',
+  expire DATE DEFAULT NULL,
   PRIMARY KEY (email, domain),
   KEY (domain),
   FOREIGN KEY (domain) REFERENCES email_virtual_domains (id) ON UPDATE CASCADE ON DELETE CASCADE