diff options
author | Steinar H. Gunderson <sgunderson@bigfoot.com> | 2014-04-06 11:56:33 +0200 |
---|---|---|
committer | Steinar H. Gunderson <sgunderson@bigfoot.com> | 2014-04-06 11:56:33 +0200 |
commit | 5b534fcc5cb0544554938954209419b2ff5d6fdb (patch) | |
tree | 8b65151f95640b16db85a7f90be8d06a12464bbd /sql | |
parent | a2e48f6ed2cae97f85ef1c0ffd85be72cec89ba6 (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.sql | 3 |
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; |