summaryrefslogtreecommitdiffstats
path: root/sql
diff options
context:
space:
mode:
authorDavid Sommerseth <davids@redhat.com>2009-07-30 15:25:16 +0200
committerDavid Sommerseth <davids@redhat.com>2009-07-30 15:25:16 +0200
commit006dd27ce58da9ba53cbdd4218c64036c1c45b9f (patch)
tree1f3374326d94449bb40171ff152032531416185b /sql
parentfb1bf41d3b6dc4b77fc349c4dfc503fbed71e8eb (diff)
downloadrteval-006dd27ce58da9ba53cbdd4218c64036c1c45b9f.tar.gz
rteval-006dd27ce58da9ba53cbdd4218c64036c1c45b9f.tar.xz
rteval-006dd27ce58da9ba53cbdd4218c64036c1c45b9f.zip
Added new column: rtevalruns.report_filename.
Corrected also some typos
Diffstat (limited to 'sql')
-rw-r--r--sql/rteval-1.0.sql19
1 files changed, 10 insertions, 9 deletions
diff --git a/sql/rteval-1.0.sql b/sql/rteval-1.0.sql
index 1202ac6..1f8d7bc 100644
--- a/sql/rteval-1.0.sql
+++ b/sql/rteval-1.0.sql
@@ -33,15 +33,16 @@
-- Overview over all rteval runs, when they were run and how long they ran.
--
CREATE TABLE rtevalruns (
- rterid SERIAL NOT NULL, -- RTEval Run Id
- syskey INTEGER REFERENCES systems(syskey) NOT NULL,
- kernel_ver VARCHAR(32) NOT NULL,
- kernel_rt BOOLEAN NOT NULL,
- arch VARCHAR(12) NOT NULL,
- run_start TIMESTAMP WITH TIME ZONE NOT NULL,
- run_duration INTEGER NOT NULL,
- load_avg REAL NOT NULL,
- version VARCHAR(4), -- Version of rteval
+ rterid SERIAL NOT NULL, -- RTEval Run Id
+ syskey INTEGER REFERENCES systems(syskey) NOT NULL,
+ kernel_ver VARCHAR(32) NOT NULL,
+ kernel_rt BOOLEAN NOT NULL,
+ arch VARCHAR(12) NOT NULL,
+ run_start TIMESTAMP WITH TIME ZONE NOT NULL,
+ run_duration INTEGER NOT NULL,
+ load_avg REAL NOT NULL,
+ version VARCHAR(4), -- Version of rteval
+ report_filename TEXT,
PRIMARY KEY(rterid)
) WITH OIDS;