Fixed some field types

The cyclic_statistics.num_samples and cyclic_histogram.value can in some
situations become incredibly high.  This fix should give a little bit more
room for higher numbers.  PostgreSQL bigint uses 8 bytes for the storage.

1 files changed, 3 insertions, 3 deletions

diff --git a/sql/rteval-1.0.sql b/sql/rteval-1.0.sql
index c20db2f..3b9ed3e 100644
--- a/sql/rteval-1.0.sql
+++ b/sql/rteval-1.0.sql
@@ -126,11 +126,11 @@ CREATE LANGUAGE 'plpgsql';
         rterid        INTEGER REFERENCES rtevalruns(rterid) NOT NULL,
         coreid        INTEGER, -- NULL=system
         priority      INTEGER, -- NULL=system
-        num_samples   INTEGER NOT NULL,
+        num_samples   BIGINT NOT NULL,
         lat_min       REAL NOT NULL,
         lat_max       REAL NOT NULL,
         lat_mean      REAL NOT NULL,
-        mode          INTEGER NOT NULL,
+        mode          REAL NOT NULL,
         range         REAL NOT NULL,
         median        REAL NOT NULL,
         stddev        REAL NOT NULL,
@@ -150,7 +150,7 @@ CREATE LANGUAGE 'plpgsql';
         rterid        INTEGER REFERENCES rtevalruns(rterid) NOT NULL,
         core          INTEGER, -- NULL=system
         index         INTEGER NOT NULL,
-        value         INTEGER NOT NULL
+        value         BIGINT NOT NULL
     ) WITHOUT OIDS;
     CREATE INDEX cyclic_histogram_rterid ON cyclic_histogram(rterid);