Fix minor issues in rteval-parser database schemas

- The rtevxmlrpc database user needs SELECT privileges on rtevalruns, otherwise
the DatabaseStatus() XML-RPC call fails.

- The hwlatdetect_summary table was defined with a wrong column name

6 files changed, 7 insertions, 1 deletions

diff --git a/server/sql/rteval-1.0.sql b/server/sql/rteval-1.0.sql
index 3b9ed3e..2ff3aae 100644
--- a/server/sql/rteval-1.0.sql
+++ b/server/sql/rteval-1.0.sql
@@ -103,6 +103,7 @@ CREATE LANGUAGE 'plpgsql';
     ) WITH OIDS;
 
     GRANT SELECT,INSERT ON rtevalruns TO rtevparser;
+    GRANT SELECT ON rtevalruns TO rtevxmlrpc;
     GRANT USAGE ON rtevalruns_rterid_seq TO rtevparser;
 
 -- TABLE rtevalruns_details
diff --git a/server/sql/rteval-1.1.sql b/server/sql/rteval-1.1.sql
index bd249fa..3977568 100644
--- a/server/sql/rteval-1.1.sql
+++ b/server/sql/rteval-1.1.sql
@@ -115,6 +115,7 @@ CREATE DATABASE rteval ENCODING 'utf-8';
     ) WITH OIDS;
 
     GRANT SELECT,INSERT ON rtevalruns TO rtevparser;
+    GRANT SELECT ON rtevalruns TO rtevxmlrpc;
     GRANT USAGE ON rtevalruns_rterid_seq TO rtevparser;
 
 -- TABLE rtevalruns_details
diff --git a/server/sql/rteval-1.2.sql b/server/sql/rteval-1.2.sql
index 6512364..05bf33b 100644
--- a/server/sql/rteval-1.2.sql
+++ b/server/sql/rteval-1.2.sql
@@ -116,6 +116,7 @@ CREATE DATABASE rteval ENCODING 'utf-8';
     ) WITH OIDS;
 
     GRANT SELECT,INSERT ON rtevalruns TO rtevparser;
+    GRANT SELECT ON rtevalruns TO rtevxmlrpc;
     GRANT USAGE ON rtevalruns_rterid_seq TO rtevparser;
 
 -- TABLE rtevalruns_details
diff --git a/server/sql/rteval-1.3.sql b/server/sql/rteval-1.3.sql
index 0723cc1..4082ab4 100644
--- a/server/sql/rteval-1.3.sql
+++ b/server/sql/rteval-1.3.sql
@@ -116,6 +116,7 @@ CREATE DATABASE rteval ENCODING 'utf-8';
     ) WITH OIDS;
 
     GRANT SELECT,INSERT ON rtevalruns TO rtevparser;
+    GRANT SELECT ON rtevalruns TO rtevxmlrpc;
     GRANT USAGE ON rtevalruns_rterid_seq TO rtevparser;
 
 -- TABLE rtevalruns_details
diff --git a/server/sql/rteval-1.4.sql b/server/sql/rteval-1.4.sql
index 048600c..d6262af 100644
--- a/server/sql/rteval-1.4.sql
+++ b/server/sql/rteval-1.4.sql
@@ -116,6 +116,7 @@ CREATE DATABASE rteval ENCODING 'utf-8';
     ) WITH OIDS;
 
     GRANT SELECT,INSERT ON rtevalruns TO rtevparser;
+    GRANT SELECT ON rtevalruns TO rtevxmlrpc;
     GRANT USAGE ON rtevalruns_rterid_seq TO rtevparser;
 
 -- TABLE rtevalruns_details
diff --git a/server/sql/rteval-1.5.sql b/server/sql/rteval-1.5.sql
index 8eefe0a..c73dd0d 100644
--- a/server/sql/rteval-1.5.sql
+++ b/server/sql/rteval-1.5.sql
@@ -116,6 +116,7 @@ CREATE DATABASE rteval ENCODING 'utf-8';
     ) WITH OIDS;
 
     GRANT SELECT,INSERT ON rtevalruns TO rtevparser;
+    GRANT SELECT ON rtevalruns TO rtevxmlrpc;
     GRANT USAGE ON rtevalruns_rterid_seq TO rtevparser;
 
 -- TABLE rtevalruns_details
@@ -198,7 +199,7 @@ CREATE DATABASE rteval ENCODING 'utf-8';
        rterid         INTEGER REFERENCES rtevalruns(rterid) NOT NULL,
        duration       INTEGER NOT NULL,
        threshold      INTEGER NOT NULL,
-       window         INTEGER NOT NULL,
+       timewindow     INTEGER NOT NULL,
        width          INTEGER NOT NULL,
        samplecount    INTEGER NOT NULL,
        hwlat_min      REAL NOT NULL,