PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE users (id integer primary key, username varchar(16), password varchar(65), priv integer default 1, hostname varchar(16));
INSERT INTO "users" VALUES(1,'admin','8c6976e5b5410415bde908bd4dee15dfb167a9c873fc4bb8a81f6f2ab448a918',10,'admin');
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;
