CREATE TABLE mailhogs (
	"IP"		text,
	"origin"	text,
	"rule"		text,
	"class"		text,
	"severity"	text,
	"comment"	text,
	"affairs"	int,
	"state"		text,
	"type"		text,
	"mb_class"	text,
	date_intro	date,
	date_event	date,
	PRIMARY KEY("IP")
);

-- object: affairs_by_ip | type: TABLE --
DROP TABLE IF EXISTS affairs_by_ip ;
CREATE TABLE "affairs_by_ip" (
	id		integer,
	ip_addr		text,
	affair_num	integer,
	rule		text,
	event_date	date,
	time_useconds	integer,
	PRIMARY KEY ("id")
);
