· 9 years ago · Oct 01, 2016, 08:34 PM
1CREATE TABLE IF NOT EXISTS password_recovery(
2 email VARCHAR(50) NOT NULL UNIQUE,
3 confirmation_id INTEGER(5) PRIMARY KEY,
4 FOREIGN KEY (email) REFERENCES users (email)
5 ON DELETE NO ACTION ON UPDATE NO ACTION,
6);
7
8CREATE TRIGGER IF NOT EXISTS password_recovery_deletion_timer AFTER INSERT ON password_recovery
9 BEGIN
10 DO SLEEP(120);
11 // i want to delete here but how do I pass which record triggered the trigger?
12 END;