File indexing completed on 2024-04-14 05:53:07
0001 CREATE TABLE `login_history` ( 0002 `id` INT(11) NOT NULL AUTO_INCREMENT, 0003 `member_id` INT(11) NOT NULL, 0004 `login_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, 0005 `ip` VARCHAR(50) NULL DEFAULT NULL, 0006 `ip_inet` VARBINARY(16) NULL DEFAULT NULL, 0007 `browser` VARCHAR(50) NULL DEFAULT NULL, 0008 `os` VARCHAR(50) NULL DEFAULT NULL, 0009 `architecture` VARCHAR(50) NULL DEFAULT NULL, 0010 `fingerprint` VARCHAR(50) NULL DEFAULT NULL, 0011 PRIMARY KEY (`id`) 0012 ) 0013 ENGINE=InnoDB 0014 ; 0015 ALTER TABLE `login_history` 0016 ADD COLUMN `user_agent` VARCHAR(255) NULL DEFAULT NULL AFTER `fingerprint`; 0017 0018 0019 ALTER TABLE `login_history` 0020 ADD COLUMN `ipv4` VARCHAR(50) NULL DEFAULT NULL AFTER `ip_inet`, 0021 ADD COLUMN `ipv4_inet` VARBINARY(16) NULL DEFAULT NULL AFTER `ipv4`, 0022 ADD COLUMN `ipv6` VARCHAR(50) NULL DEFAULT NULL AFTER `ipv4_inet`, 0023 ADD COLUMN `ipv6_inet` VARBINARY(16) NULL DEFAULT NULL AFTER `ipv6`;