File indexing completed on 2024-03-24 06:03:43
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 ;