File indexing completed on 2024-04-28 13:54:19 

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 ;