password_expiration.sql 204 B

123
  1. ALTER TABLE mailbox ADD COLUMN password_expiry TIMESTAMP DEFAULT now() not null;
  2. UPDATE mailbox set password_expiry = now() + interval 90 day;
  3. ALTER TABLE domain ADD COLUMN password_expiry int DEFAULT 0;