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