PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE ipv4 (id integer primary key, userid integer, hostname varchar(16), ip varchar(60), valid integer default 0, expires varchar(20));
CREATE TABLE ipv6 (id integer primary key, userid integer, hostname varchar(16), ip varchar(60), valid integer default 0, expires varchar(20));
CREATE TABLE sshfp (id integer primary key, userid integer, hostname varchar(16), sshfp varchar(50), type integer, valid integer default 0);
COMMIT;
