1BEGIN;
2
3CREATE TABLE "statistics" (
4  "day" date NOT NULL DEFAULT CURRENT_DATE,
5
6  "device_count" integer NOT NULL,
7  "device_ip_count" integer NOT NULL,
8  "device_link_count" integer NOT NULL,
9  "device_port_count" integer NOT NULL,
10  "device_port_up_count" integer NOT NULL,
11  "ip_table_count" integer NOT NULL,
12  "ip_active_count" integer NOT NULL,
13  "node_table_count" integer NOT NULL,
14  "node_active_count" integer NOT NULL,
15
16  "netdisco_ver" text,
17  "snmpinfo_ver" text,
18  "schema_ver" text,
19  "perl_ver" text,
20  "pg_ver" text,
21
22  PRIMARY KEY ("day")
23);
24
25COMMIT;
26