DROP TABLE Unfiltered;
DROP TABLE Runtimes;

CREATE TABLE "Unfiltered" (
	"Id"	INTEGER NOT NULL,
	"Ip"	TEXT NOT NULL,
	"ResponseCode"	INTEGER NOT NULL,
	"Port1"	INTEGER NOT NULL,
	"Port2"	INTEGER NOT NULL,
	"Filtered"	INTEGER NOT NULL,
	CONSTRAINT "PK_Unfiltered" PRIMARY KEY("Id" AUTOINCREMENT)
);

CREATE TABLE "Runtimes" (
    "Id" INTEGER NOT NULL CONSTRAINT "PK_Runtimes" PRIMARY KEY AUTOINCREMENT,
    "StartTime" TEXT NOT NULL,
    "EndTime" TEXT NOT NULL,
    "ThreadNumber" INTEGER NOT NULL
);