\connect - ipstat
CREATE TABLE "default_values" (
	"price_for_traffic" float4,
	"abonent_payment" float4
);
REVOKE ALL on "default_values" from PUBLIC;
GRANT SELECT on "default_values" to "nobody";
GRANT ALL on "default_values" to "ipstat";
COPY "default_values" FROM stdin;
0.15	12.72
\.
\connect - ipstat
CREATE TABLE "reports" (
	"ip" character varying(14),
	"month" int2,
	"year" int2,
	"r_date" date,
	"full_name" character varying(50),
	"address" character varying(50),
	"phone" character varying(20),
	"email" character varying(22),
	"reg_data" character varying(40),
	"contract" character varying(20),
	"nr_inv" int2,
	"abonement_m" float4,
	"traffic" int4,
	"traffic_m" float4,
	"nalog_m" float4,
	"total_m" float4,
	"start_date" date,
	"stop_date" date,
	"proxy" float4
);
REVOKE ALL on "reports" from PUBLIC;
GRANT SELECT on "reports" to "nobody";
GRANT ALL on "reports" to "ipstat";
\connect - ipstat
CREATE TABLE "statistic" (
	"id" int4,
	"date" date,
	"ip" character varying(16),
	"in" int4,
	"out" int4,
	"inlv" int8,
	"outlv" int8
);
REVOKE ALL on "statistic" from PUBLIC;
GRANT SELECT on "statistic" to "nobody";
GRANT ALL on "statistic" to "ipstat";
\connect - ipstat
CREATE TABLE "users" (
	"id" int4,
	"contract" character varying(20),
	"full_name" character varying(50),
	"phone" character varying(50),
	"address" character varying(50),
	"floor" character varying(20),
	"username" character varying(10),
	"password" character varying(10),
	"ip" character varying(14),
	"traffic_limit" int2,
	"email" character varying(40),
	"status" int2,
	"start_date" date,
	"stop_date" date,
	"reg_data" character varying(40),
	"on_off" int2,
	"foreignt" int2,
	"proxy" float4
);
REVOKE ALL on "users" from PUBLIC;
GRANT SELECT on "users" to "nobody";
GRANT ALL on "users" to "ipstat";