CREATE TRIGGER updateExpireDate
BEFORE INSERT ON license
FOR EACH ROW
BEGIN
SET NEW.expiredate= DATE_ADD(NOW(), INTERVAL 1 YEAR);
END;