mail_server/postfixadmin/password_expiration.sql
2021-05-05 20:09:14 +05:30

3 lines
204 B
SQL

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