/* Describe the firewall host */
CREATE TABLE "hosts" (
	"uname"		varchar(64) PRIMARY KEY,
	"ip"		inet
);

/* Actual filtered packets */
CREATE TABLE "ip_quads" (	
	"id"		SERIAL PRIMARY KEY,
	"host"		varchar(64) NOT NULL,
	"ts"		timestamp NOT NULL,
	"proto"		int4 NOT NULL,
	"src_ip"	inet NOT NULL,
	"dst_ip" 	inet NOT NULL,
	"src_port"	int4 NOT NULL,
	"dst_port" 	int4 NOT NULL,
	CONSTRAINT "ip_quad_host" FOREIGN KEY ("host")
	REFERENCES "hosts" ("uname")
);

/* Our indexes */
CREATE INDEX "dst_ip_ip_quads_key" ON "ip_quads" ("dst_ip");
CREATE INDEX "src_ip_ip_quads_key" ON "ip_quads" ("src_ip");
CREATE INDEX "dst_port_ip_quads_key" ON "ip_quads" ("dst_port");
CREATE INDEX "proto_ip_quads_key" ON "ip_quads" ("proto");
CREATE INDEX "ip_hosts_key" ON "hosts" ("ip");