File indexing completed on 2024-04-21 16:41:57 

0001 ALTER TABLE `session`
0002     CHANGE COLUMN `idsession` `session_id` INT(11) NOT NULL AUTO_INCREMENT,
0003     CHANGE COLUMN `member_id` `member_id` INT(11) NOT NULL ,
0004     CHANGE COLUMN `uuid` `remember_me_id` VARCHAR(255) NOT NULL ,
0005     ADD COLUMN `expiry` DATETIME NOT NULL AFTER `remember_me_id`,
0006     DROP INDEX `member_uuid` ,
0007     ADD INDEX `idx_remember` (`member_id` ASC, `remember_me_id` ASC, `expiry` ASC);
0008 
0009 UPDATE `session`
0010 SET `expiry` = DATE_ADD(`session`.`created`, INTERVAL + 31536000 SECOND)
0011 ;