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