bips
2,784 rows
This data as json, CSV (advanced)
Suggested facets: jail
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE bips(ip TEXT NOT NULL, jail TEXT NOT NULL, timeofban INTEGER NOT NULL, bantime INTEGER NOT NULL, bancount INTEGER NOT NULL default 1, data JSON, PRIMARY KEY(ip, jail), FOREIGN KEY(jail) REFERENCES jails(name) ); CREATE INDEX bips_timeofban ON bips(timeofban); CREATE INDEX bips_ip ON bips(ip);