aboutsummaryrefslogtreecommitdiffstats
path: root/sql
diff options
context:
space:
mode:
authorSteinar H. Gunderson <sgunderson@bigfoot.com>2014-04-06 11:56:33 +0200
committerSteinar H. Gunderson <sgunderson@bigfoot.com>2014-04-06 11:56:33 +0200
commit5b534fcc5cb0544554938954209419b2ff5d6fdb (patch)
tree8b65151f95640b16db85a7f90be8d06a12464bbd /sql
parenta2e48f6ed2cae97f85ef1c0ffd85be72cec89ba6 (diff)
When fetching traffic data, fetch _all_ ports (in bulk), not just the ones we think we want right now.
Diffstat (limited to 'sql')
-rw-r--r--sql/nms.sql3
1 files changed, 2 insertions, 1 deletions
diff --git a/sql/nms.sql b/sql/nms.sql
index bd695e1..23f20b2 100644
--- a/sql/nms.sql
+++ b/sql/nms.sql
@@ -430,7 +430,8 @@ CREATE TABLE polls (
bytes_in bigint NOT NULL,
bytes_out bigint NOT NULL,
errors_in bigint NOT NULL,
- errors_out bigint NOT NULL
+ errors_out bigint NOT NULL,
+ official_port boolean NOT NULL DEFAULT false
);
ALTER TABLE ONLY polls ALTER COLUMN "time" SET STATISTICS 100;