File indexing completed on 2024-03-24 06:03:43
0001 0002 0003 CREATE TABLE `sso_auth_token` 0004 ( 0005 `sso_auth_token_id` int(11) NOT NULL AUTO_INCREMENT, 0006 `token_member_id` int(11) NOT NULL, 0007 `token_value` varchar(45) NOT NULL, 0008 `token_action` varchar(45) NOT NULL, 0009 `remember_me` int(1) DEFAULT '0', 0010 `token_created` datetime DEFAULT NULL, 0011 `token_changed` datetime DEFAULT NULL, 0012 `token_expired` datetime DEFAULT NULL, 0013 PRIMARY KEY (`sso_auth_token_id`), 0014 KEY `idx_token` (`token_member_id`, `token_value`, `token_action`) 0015 ) ENGINE = InnoDB 0016 AUTO_INCREMENT = 1 0017 DEFAULT CHARSET = `latin1`; 0018 0019 DELIMITER $$ 0020 0021 DROP TRIGGER IF EXISTS `sso_auth_token_BEFORE_INSERT`$$ 0022 CREATE DEFINER = CURRENT_USER TRIGGER `sso_auth_token_BEFORE_INSERT` 0023 BEFORE INSERT 0024 ON `sso_auth_token` 0025 FOR EACH ROW 0026 BEGIN 0027 IF `NEW`.`token_created` IS NULL THEN 0028 SET `NEW`.`token_created` = NOW(); 0029 END IF; 0030 IF `NEW`.`token_expired` IS NULL THEN 0031 SET `NEW`.`token_expired` = NOW() + INTERVAL 1 HOUR; 0032 END IF; 0033 END$$ 0034 DELIMITER ;