File indexing completed on 2024-04-21 06:00:35 

0001 CREATE TABLE `member_token`
0002 (
0003     `token_id`                int(11)     NOT NULL AUTO_INCREMENT,
0004     `token_member_id`         int(11)     NOT NULL,
0005     `token_provider_name`     varchar(45) NOT NULL,
0006     `token_value`             varchar(45) NOT NULL,
0007     `token_provider_username` varchar(45) DEFAULT NULL,
0008     `token_fingerprint`       varchar(45) DEFAULT NULL,
0009     `token_created`           datetime    DEFAULT NULL,
0010     `token_changed`           datetime    DEFAULT NULL,
0011     `token_deleted`           datetime    DEFAULT NULL,
0012     PRIMARY KEY (`token_id`),
0013     KEY `idx_token` (`token_member_id`, `token_provider_name`, `token_value`)
0014 ) ENGINE = InnoDB
0015   DEFAULT CHARSET = `latin1`;
0016 
0017 DELIMITER $$
0018 
0019 DROP TRIGGER IF EXISTS `member_token_BEFORE_INSERT`$$
0020 
0021 CREATE DEFINER = CURRENT_USER TRIGGER `member_token_BEFORE_INSERT`
0022     BEFORE INSERT
0023     ON `member_token`
0024     FOR EACH ROW
0025 BEGIN
0026     IF `NEW`.`token_created` IS NULL THEN
0027         SET `NEW`.`token_created` = NOW();
0028     END IF;
0029 END$$
0030 DELIMITER ;