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`;