CREATE TABLE sqlite_stat1(tbl,idx,stat);
CREATE TABLE "attempts" (
    "eid" INTEGER PRIMARY KEY AUTOINCREMENT,
    "ip_id" INTEGER NOT NULL,
    "user_id" INTEGER NOT NULL,
    "port_id" INTEGER NOT NULL,
    "timestamp" TEXT NOT NULL
, "create_time" TEXT);
CREATE TABLE sqlite_sequence(name,seq);
CREATE TABLE ip (
    "eid" INTEGER PRIMARY KEY AUTOINCREMENT,
    "IP" TEXT NOT NULL
, "create_time" TEXT);
CREATE TABLE ports (
    "eid" INTEGER PRIMARY KEY AUTOINCREMENT,
    "port" INTERGER NOT NULL,
    "create_time" TEXT);
CREATE TABLE users (
    "eid" INTEGER PRIMARY KEY AUTOINCREMENT,
    "user" TEXT NOT NULL,
    "create_time" TEXT);
CREATE TABLE who_is (
    "eid" INTEGER PRIMARY KEY AUTOINCREMENT,
    "entry" TEXT NOT NULL,
    "ip_id" INTEGER NOT NULL,
    "timestamp" TEXT NOT NULL
, "create_time" TEXT);
CREATE TABLE "run_log" (
    "eid" INTEGER PRIMARY KEY AUTOINCREMENT,
    "run_time_start" TEXT,
    "run_time_end" TEXT,
    "input_file" TEXT,
    "last_log_first_line" TEXT,
    "last_line_read" INTEGER
);
CREATE VIEW try1 as
select u.user, p.port, i.ip, a.timestamp, a.create_time
from attempts a join
ports p on a.port_id = p.eid join
ip i on i.eid = a.ip_id join
users u on u.eid = a.user_id
order by a.timestamp;