github.com/Azareal/Gosora@v0.0.0-20210729070923-553e66b59003/schema/mysql/query_login_logs.sql (about) 1 CREATE TABLE `login_logs`( 2 `lid` int not null AUTO_INCREMENT, 3 `uid` int not null, 4 `success` boolean DEFAULT 0 not null, 5 `ipaddress` varchar(200) not null, 6 `doneAt` datetime not null, 7 primary key(`lid`) 8 );