CREATE TABLE vpntrack (
	IP	text primary key,
	affairs	int,
	type	text,
	state	text,
	class	text,
	date_intro date DEFAULT current_timestamp,
	date_event date,
	comment text
);


-- 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")
);
